-- AND DATE_TRUNC('days', BLOCK_TIMESTAMP) > CURRENT_DATE - INTERVAL '5 months'

With tx AS

(SELECT DATE_TRUNC('months', BLOCK_TIMESTAMP) "MONTH",

COUNT(*) Tx

FROM flipside_prod_db.polygon.transactions

WHERE SUCCESS = TRUE

GROUP BY 1),

wallets AS

(SELECT

"MONTH", SUM(NEW_WALLETS) OVER(ORDER BY MONTH) CUMULATIVE_WALLETS

FROM

(SELECT DATE_TRUNC('months', BLOCK_TIMESTAMP) "MONTH", COUNT(*) NEW_WALLETS

FROM

(SELECT FROM_ADDRESS, MIN(BLOCK_TIMESTAMP) BLOCK_TIMESTAMP

FROM flipside_prod_db.polygon.transactions

WHERE SUCCESS = TRUE

GROUP BY 1)

GROUP BY 1))

SELECT tx.MONTH, TX, CUMULATIVE_WALLETS::DECIMAL CUMULATIVE_WALLETS

FROM tx

LEFT JOIN wallets

on tx.MONTH = wallets.MONTH

ORDER BY 1