kentoartistic-scarlet
    Updated 2024-11-01
    SELECT
    DAY(BLOCK_TIMESTAMP_HOUR) AS day,
    SUM(TRANSACTION_COUNT) AS total_transactions,
    SUM(UNIQUE_FROM_COUNT) AS unique_senders
    FROM sei.stats.ez_core_metrics_hourly
    WHERE BLOCK_TIMESTAMP_HOUR >= '2024-10-01'
    AND BLOCK_TIMESTAMP_HOUR < '2024-11-01'
    GROUP BY day
    ORDER BY total_transactions DESC, unique_senders DESC;

    QueryRunArchived: QueryRun has been archived