SELECT

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"

FROM

base.core.fact_transactions

WHERE

status = 'SUCCESS'

GROUP BY 1

ORDER BY 1 ASC