SELECT
date_trunc('week', block_timestamp) AS week
, COUNT(DISTINCT tx_hash) AS transactions
, SUM(transactions) OVER (ORDER BY week) AS total_transactions
, COUNT(DISTINCT tx_signer) AS users
FROM near.core.fact_transactions
--WHERE 1=1
-- AND block_timestamp >= '2023-01-01'
GROUP BY 1
ORDER BY 1 DESC