SELECT

date_trunc('hour', block_timestamp) AS hour,

COUNT(distinct tx_hash) AS total_transactions

FROM

blast.core.fact_transactions

GROUP BY

hour

),

cumulative_transactions AS (

SELECT

hour,

total_transactions,

SUM(total_transactions) OVER (ORDER BY hour) AS cumulative_total_transactions

FROM

hourly_transactions

SELECT * FROM cumulative_transactions

ORDER BY hour desc;