WITH daily_totals AS (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,

COUNT(TX_ID) AS total_transactions_today

FROM eclipse.core.fact_transactions

GROUP BY transaction_date

SELECT

transaction_date,

total_transactions_today,

SUM(total_transactions_today) OVER (ORDER BY transaction_date) AS cumulative_transactions

FROM daily_totals

ORDER BY transaction_date DESC;