TO_CHAR(BLOCK_TIMESTAMP, 'YYYY-MM-DD') AS "Date",

COUNT(DISTINCT FROM_ADDRESS) AS "Daily Actice Wallets",

SUM("Daily Actice Wallets") OVER (ORDER BY "Date") AS "Total Active Wallets (Cum.)"

FROM

base.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= '2023-08-09' AND BLOCK_TIMESTAMP <= '2023-09-10'

STATUS = 'SUCCESS'

GROUP BY 1

ORDER BY 1 DESC