date_trunc('day', block_timestamp) as date,

count(distinct origin_from_address) as swapper,

count(distinct tx_hash) as txns,

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

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

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

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

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

avg(swap_volume) over (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

order by date desc