SELECT block_timestamp::date AS Day, COUNT(*) AS eth_transactions, AVG(eth_transactions) OVER(ORDER BY Day ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS Avg_7day_transactions
FROM ethereum.core.fact_transactions
WHERE block_timestamp::date BETWEEN '2020-12-31' AND GETDATE()::date
GROUP BY block_timestamp::date
ORDER BY block_timestamp::date DESC