date_trunc('week', block_timestamp) AS week

, COUNT(DISTINCT tx_hash) AS transactions

, SUM(transactions) OVER (ORDER BY week) AS total_transactions

, COUNT(DISTINCT sender) AS users

FROM aptos.core.fact_transactions

WHERE 1=1

AND block_timestamp >= '2022-01-01'

AND date_trunc('week', block_timestamp) NOT IN ('2024-05-20', '2024-08-12')

GROUP BY 1

ORDER BY 1 DESC