(select

origin_from_address as address,

count(distinct tx_hash) as swaps

from

avalanche.core.ez_dex_swaps

where block_timestamp::date between '{{StartDate}}' and '{{EndDate}}'

group by 1

order by 2 desc

limit 10

select

date_trunc('{{Interval}}',block_timestamp) as "TimeStamp",

count(distinct tx_hash) as "Swaps",

sum(amount_in_usd) as "volume(USD)",

sum("Swaps") over(order by "TimeStamp" asc) as "cumulative swaps",

Avg("volume(USD)") over(order by "TimeStamp" asc rows between 6 preceding and current row) "7MA Volume"

from

avalanche.core.ez_dex_swaps

where origin_from_address in (select address from top_)

and block_timestamp::date between '{{StartDate}}' and '{{EndDate}}'

group by 1--,2,3

order by 1 asc