par_rnEclipse 01
    Updated 2025-02-19
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP_HOUR) AS date,
    SUM(TRANSACTION_COUNT) AS total_transactions,
    SUM(TRANSACTION_COUNT_SUCCESS) AS successful_transactions,
    SUM(TRANSACTION_COUNT_FAILED) AS failed_transactions,
    SUM(UNIQUE_SIGNERS_COUNT) AS unique_users,
    SUM(TOTAL_FEES_USD) AS total_fees
    FROM
    eclipse.stats.ez_core_metrics_hourly
    GROUP BY
    1
    ORDER BY
    date
    QueryRunArchived: QueryRun has been archived