SELECT

Borrower,

SUM(Amount_USD) AS total_volume_usd

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 Borrower

SELECT

CASE

WHEN total_volume_usd < 100 THEN 'Below $100'

WHEN total_volume_usd BETWEEN 100 AND 1000 THEN '$100 - $1K'

WHEN total_volume_usd BETWEEN 1000 AND 10000 THEN '$1K - $10K'

WHEN total_volume_usd BETWEEN 10000 AND 50000 THEN '$10K - $50K'

ELSE '$50K+'

END AS volume_bucket,

COUNT(*) AS depositor_count

FROM volume_counts

GROUP BY 1

ORDER BY 2 DESC;