date_trunc('month', block_timestamp) as date,

case when AMOUNT_IN_USD < 10 then 'Less Than $10'

when AMOUNT_IN_USD >= 10 and AMOUNT_IN_USD < 100 then '$10 - $100'

when AMOUNT_IN_USD >= 100 and AMOUNT_IN_USD < 1000 then '$100 - $1000'

when AMOUNT_IN_USD >= 1000 and AMOUNT_IN_USD < 10000 then '$1000 - $10000'

else 'More Than $10000' end as dist,

count(distinct tx_hash) as swaps,

count(distinct SENDER) as wallets,

sum(AMOUNT_IN_USD) as usd_vol,

avg(AMOUNT_IN_USD) as avg_usd_vol

from ethereum.core.ez_dex_swaps

where date(block_timestamp) >= '2021-01-01'

and AMOUNT_OUT_USD < 1e8

group by date, dist