SELECT

DATE_TRUNC('DAY', block_timestamp) AS activity_date,

TX_HASH AS tx

FROM ronin.core.fact_transactions

),

daily_counts AS (

SELECT

activity_date,

COUNT(DISTINCT tx) AS daily_active_tx_hash

FROM daily_active_TX_HASH

GROUP BY activity_date

SELECT

activity_date,

daily_active_tx_hash,

SUM(daily_active_tx_hash) OVER (ORDER BY activity_date) AS cumulative_active_tx_hash

FROM daily_counts

ORDER BY activity_date DESC;