SELECT

DATE_TRUNC('month', block_timestamp) AS rounded_month,

COUNT(DISTINCT from_address) as unique_users,

--symbol,

SUM(amount_usd) as tx_vol_usd,

COUNT(amount_usd) as tx_count,

CASE

WHEN amount_usd > 100000 THEN 'Large'

ELSE 'Small'

END AS transaction_size

FROM avalanche.core.ez_token_transfers

WHERE rounded_month BETWEEN '2022-01-01' AND '2024-12-31' AND amount_usd < 1e15

GROUP BY

rounded_month, transaction_size

ORDER BY

rounded_month, transaction_size;