COUNT(DISTINCT tx_hash) AS tx_count,

COUNT(DISTINCT borrower) AS Borrowers,

SUM(Amount_USD) AS amountUSD,

AVG(Amount_USD) AS AVG_Amount

FROM avalanche.defi.ez_lending_borrows

WHERE contract_address = '0x794a61358d6845594f94dc1db02a252b5b4814ad'

AND origin_to_address = '0x794a61358d6845594f94dc1db02a252b5b4814ad'

AND token_symbol IN ('USDC', 'AUSD', 'USDt', 'DAI.e', 'FRAX')

AND platform = 'Aave V3'

AND event_name = 'Borrow'

AND block_timestamp >= '2024-01-01'

GROUP BY token_symbol