Tobi_12024-06-04 11:04 AM
    Updated 2024-06-07
    SELECT BLSELECT
    DATE(BLOCK_TIMESTAMP_HOUR) AS transaction_date,
    SUM(TRANSACTION_COUNT) AS total_transactions
    FROM
    solana.stats.ez_core_metrics_hourly;
    WHERE
    BLOCK_TIMESTAMP_HOUR >= DATEADD(day, -30, CURRENT_TIMESTAMP())
    GROUP BY
    transaction_date
    ORDER BY
    transaction_date;