ORIGIN_FROM_ADDRESS,

case when TOKEN_in = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7') then 'SELL'

when TOKEN_out = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7') then 'BUY' end as type,

count(DISTINCT TX_HASH) as transactions,

sum(AMOUNT_IN) as volume_avax,

sum(AMOUNT_IN_USD) as volume_usd,

avg(AMOUNT_IN_USD) as avg_volume_usd,

from avalanche.defi.ez_dex_swaps

where AMOUNT_OUT_USD is NOT NULL

and TOKEN_in =lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7') OR

TOKEN_out = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')

group by 1,2)

SELECT

type,

case when transactions <= 1 then 'Only One transactions'

when transactions <= 10 then '1-10 transactions'

when transactions <= 20 then '10-20 transactions'

when transactions <= 30 then '20-30 transactions'

when transactions <= 40 then '30-40 transactions'

when transactions <= 50 then '40-50 transactions'

when transactions > 50 then 'More Than 50 transactions ' end as category ,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users

FROM

Distribution_users

where category is NOT NULL

GROUP BY 1,2