from avalanche.core.ez_dex_swaps

group by 2)

,

new as ( select DISTINCT origin_from_address

from tx

where date::date >= '2023-05-30' )

select case when origin_from_address in (select origin_from_address from new) then 'New Users'

else 'Old Users' end as type , count(DISTINCT(origin_from_address)) as users, count(DISTINCT(tx_hash)) as total_txs,

sum(amount_out) as EMDX_amount, avg(amount_out) as avg_amount

from avalanche.core.ez_dex_swaps

where symbol_out = 'EMDX' and block_timestamp::date <= '2023-06-01'

group by 1