select

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

count(distinct tx_hash) as "Swaps",

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

sum(AMOUNT_IN) as "volume in",

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

avalanche.core.ez_dex_swaps

where origin_from_address='{{Address}}'

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

group by 1

order by 1 asc