date_trunc('day',block_timestamp) as date,

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'

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

else 'More Than $100000 Volume' end as swap_volume,

count (distinct tx_hash) as Swaps_Count

from Ethereum.sushi.ez_swaps

where date >= '2022-07-01'

group by 1,2