,case

when AMOUNT_OUT_USD>0 and AMOUNT_OUT_USD<=10 then 'Below 10 $'

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

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

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

when AMOUNT_OUT_USD>10000 then 'Up To 10K $' end as dis_volume

,count(distinct ORIGIN_FROM_ADDRESS) as buyers

from ethereum.core.ez_dex_swaps

where date>='2023-04-17'

and TOKEN_IN=lower('0x1f9840a85d5af5bf1d1762f925bdaddc4201f984')

and AMOUNT_OUT_USD is not null

and dis_volume is not null

group by 1,2