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 TX_Count < 3 then '1 or 2'

when TX_Count >= 3 and TX_Count < 10 then '3 - 10'

when TX_Count >= 10 and TX_Count < 30 then '10 - 30'

when TX_Count >= 30 and TX_Count < 100 then '30 - 100'

else 'More Than 100' end as dist,

count(distinct wallet) as wallets

from agg

group by dist