case

when amount_in_usd > 0 and amount_in_usd < 10 then '(0, 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)'

when amount_in_usd >= 10000 and amount_in_usd < 100000 then '[10K, 100K)'

when amount_in_usd >= 100000 and amount_in_usd < 1000000 then '[100K, 1M)'

when amount_in_usd >= 1000000 and amount_in_usd < 10000000 then '[1M, 10M)'

else 'More than 10M' end as dis, count(*) as "count"

from optimism.velodrome.ez_swaps

where block_timestamp::date < current_date and amount_in_usd > 0 and amount_in_usd is not null

group by 1