date_trunc('week', block_timestamp) AS week

, COUNT(DISTINCT tx_hash) AS transactions

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

, COUNT(tx_hash) AS tx_all

, SUM(tx_all) OVER (ORDER BY week) AS total_tx_all

, COUNT(DISTINCT from_address) AS users

FROM base.core.fact_transactions

WHERE block_timestamp >= '2024-01-01'

GROUP BY 1

ORDER BY 1 DESC