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

count(distinct(from_address)) as number_of_traders,

count(distinct(tx_id)) as number_of_swaps,

avg(number_of_swaps) over (order by date rows between 6 preceding and current row) as "7d-MA # Swaps",

avg(number_of_traders) over (order by date rows between 6 preceding and current row) as "7d-MA # Traders"

from thorchain.defi.fact_swaps

where date BETWEEN '{{start_date}}' and Current_date() - 1

group by 1

ORDER BY 2 DESC