SELECT

DATE_TRUNC('month', first_txns) AS week,

COUNT(*) AS new_users

FROM (

SELECT

DISTINCT TX_FROM,

MIN(BLOCK_TIMESTAMP) AS first_txns

FROM solana.core.fact_transfers

WHERE BLOCK_TIMESTAMP >= '2020-01-01' -- Start from a reasonable date for Solana

GROUP BY 1

) AS first_txns

GROUP BY 1

SELECT

week,

new_users,

SUM(new_users) OVER (ORDER BY week) AS cumulative_new_users

FROM new_users

WHERE week IS NOT NULL -- Exclude null weeks

ORDER BY week