select case when amount_in_usd < 10 then 'Less Than $10'
when amount_in_usd >= 10 and amount_in_usd < 100 then 'Between $10 and $100'
when amount_in_usd >= 100 and amount_in_usd < 1000 then 'Between $100 and $1000'
when amount_in_usd >= 1000 and amount_in_usd < 10000 then 'Between $1000 and $10000'
else 'More Than $10000' end as type,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count
from optimism.velodrome.ez_swaps
group by 1