date_trunc('month',BLOCK_TIMESTAMP)as month

,count(distinct TX_HASH) as swap_count

, case

when AMOUNT_OUT_USD>=1 and AMOUNT_IN_USD<10 then '1~10 $'

when AMOUNT_OUT_USD>=10 and AMOUNT_IN_USD<100 then '10~100 $'

when AMOUNT_OUT_USD>=100 and AMOUNT_IN_USD<1000 then '100~1K $'

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

when AMOUNT_OUT_USD>=10000 and AMOUNT_IN_USD<100000 then '10K~100K $'

when AMOUNT_OUT_USD>=100000 and AMOUNT_IN_USD<1000000 then '100K~1M $'

when AMOUNT_OUT_USD>=1000000 then 'Up to 1M $' end as dis_volume

from ethereum.core.ez_dex_swaps

where TOKEN_OUT='0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

and( PLATFORM='uniswap-v2'or PLATFORM='uniswap-v3')

and month>='2022-01-01'

and dis_volume is not null

group by 1,3