SELECT

DATE_TRUNC('week', block_timestamp) AS week,

COUNT(DISTINCT tx_signer) AS "Weekly Active Users"

FROM near.core.fact_transactions

WHERE block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01'

GROUP BY week

SELECT

week,

"Weekly Active Users",

SUM("Weekly Active Users") OVER (ORDER BY week) AS "Cumulative Users"

FROM weekly_active_users

ORDER BY week;