select block_timestamp,

case when platform ilike '%trader-joe%' then 'Trader Joe'

when platform ilike '%kyber%' then 'Kyberswap'

when platform ilike '%uniswap%' then 'Uniswap'

when platform ilike '%Pharaoh%' then 'Pharaoh'

else initcap (platform) end as dex,

origin_from_address as trader,

coalesce (amount_in_usd,amount_out_usd,0) as volume,

row_number () over (partition by trader order by block_timestamp asc) as rn

from avalanche.defi.ez_dex_swaps)

select date_trunc ({{Time_Interval}},block_timestamp) as date,

case when rn = '1' then 'New Traders' else 'Existing Traders' end as type,

count (distinct trader) as Users

from dextable

where block_timestamp >= '{{From_Date}}' and block_timestamp <= '{{To_Date}}'

group by 1,2

order by 1 desc