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

COUNT(DISTINCT TX_HASH) AS "Daily Transactions",

SUM("Daily Transactions") OVER (ORDER BY "Date") AS "Total Transactions"

FROM

base.core.fact_transactions

WHERE

status = 'SUCCESS'

GROUP BY 1

ORDER BY 1 ASC