picasotransaction
    Updated 2025-02-14
    WITH daily_active_TX_HASH AS (
    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;
    QueryRunArchived: QueryRun has been archived