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 - $1K'

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

else 'More Than $10K' end as dist,

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 date, dist having usd_vol > 0