ORIGIN_FROM_ADDRESS,

case when TOKEN_in = '0x18e3605b13f10016901eac609b9e188cf7c18973' then 'SELL'

when TOKEN_out = '0x18e3605b13f10016901eac609b9e188cf7c18973' 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 = '0x18e3605b13f10016901eac609b9e188cf7c18973' OR

TOKEN_out = '0x18e3605b13f10016901eac609b9e188cf7c18973'

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