DATE_TRUNC('month', block_timestamp) AS "Month",

symbol AS "Stablecoin",

COUNT(DISTINCT tx_hash) AS "Total Repayment Transactions",

SUM(amount_usd) AS "Total Repaid Volume",

AVG(amount_usd) AS "Avg Repayment Amount"

near.defi.ez_lending

symbol IN (

'USDT',

'USDt',

'DAI',

'FRAX',

'USDT.e',

'USDC.e',

'USN'

)

AND actions IN ('repay')

AND amount_usd IS NOT NULL

GROUP BY

DATE_TRUNC('month', block_timestamp), symbol

ORDER BY

"Month", "Stablecoin";