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

COUNT(DISTINCT BLOCK_NUMBER) AS "Daily Blocks",

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

FROM

base.core.fact_transactions

WHERE

status = 'SUCCESS'

GROUP BY 1

ORDER BY 1 ASC