date_trunc('day', block_timestamp) as date,

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

when platform ilike 'pharaoh%' then 'Pharaoh'

when platform ilike 'uniswap%' then 'Uniswap'

when platform ilike 'hashflow%' then 'Hashflow'

when platform ilike 'kyberswap%' then 'Keberswap'

else INITCAP(platform) end as Platform_,

count(distinct origin_from_address) as swapper,

count(distinct tx_hash) as txns,

sum(txns) over (partition by platform_ order by date) as cumu_xns,

sum(coalesce(amount_in_usd,amount_out_usd)) as swap_volume,

sum(swap_volume) over (partition by platform_ order by date) as cumu_swap_volume,

avg(coalesce(amount_in_usd,amount_out_usd)) as avg_per_txns,

avg(swap_volume) over (partition by platform_ order by date) as daily_avg_swap_volume,

avg(swap_volume) over (partition by platform_ order by date rows between 6 preceding and current row) as ma_7

from avalanche.defi.ez_dex_swaps

where (token_in = '{{Token_Address}}' or token_out = '{{Token_Address}}')

and block_timestamp >= (select min(block_timestamp) from avalanche.defi.ez_dex_swaps

where (token_in = '{{Token_Address}}' or token_out = '{{Token_Address}}'))

group by date , platform_

order by date desc