case

when amount_in_usd <=10 then ' less than $10'

when amount_in_usd <10 and amount_in_usd <= 100 then 'between $10 - $100'

when amount_in_usd <100 and amount_in_usd <= 1000 then 'between $100 - $1000'

when amount_in_usd <1000 and amount_in_usd <= 10000 then 'between $1000 - $10000'

when amount_in_usd <10000 and amount_in_usd <= 100000 then 'between $10000 - $100000'

else 'more than $100000'

end as Volume,

count(distinct tx_hash) as swaps

from ethereum.core.ez_dex_swaps

where platform like 'uniswap%'

and block_timestamp > current_date - interval '12 months'

group by 1