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

symbol AS "Stablecoin",

COUNT(DISTINCT sender_id) AS "Borrower",

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

SUM(amount_usd) AS "Total Borrowed Volume",

AVG(amount_usd) AS "Avg Borrowed Amount"

near.defi.ez_lending

symbol IN (

'USDT',

'USDt',

'DAI',

'FRAX',

'USDT.e',

'USDC.e',

'USN'

)

AND actions IN ('borrow')

GROUP BY

DATE_TRUNC('month', block_timestamp), symbol

ORDER BY

"Month", symbol;