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 volume_usd <= 10 then 'Less than 10 USD'

when volume_usd <= 100 then '10-100 USD'

when volume_usd <= 500 then '100-500 USD'

when volume_usd <= 1000 then '500-1k USD'

when volume_usd <= 5000 then '1k-5k USD'

when volume_usd <= 10000 then '5k-10k USD'

when volume_usd >= 10000 then 'More Than 10k USD' end as category ,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users

FROM

Distribution_users

where category is NOT NULL

GROUP BY 1,2