select ORIGIN_FROM_ADDRESS as wallet,

count (distinct tx_hash) as TX_Count,

sum(coalesce(AMOUNT_IN_USD,0)) as usd_vol

from ethereum.core.ez_dex_swaps

where PLATFORM='uniswap-v3'

and CONTRACT_ADDRESS='0x99ac8ca7087fa4a2a1fb6357269965a2014abc35'

and BLOCK_TIMESTAMP >= current_date - {{days_ago}}

group by wallet

SELECT

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

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

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

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

else 'More Than $10000' end as dist,

count(distinct wallet) as wallets

from agg

group by dist