Tobi_12024-06-04 01:54 PM
    Updated 2024-06-07
    SELECT BLOCK_TIMESTAMP_HOUR, SUM(UNIQUE_SIGNERS_COUNT) AS unique_signers
    FROM solana.stats.ez_core_metrics_hourly;
    WHERE BLOCK_TIMESTAMP_HOUR >= DATEADD(days, -30, CURRENT_TIMESTAMP())
    GROUP BY BLOCK_TIMESTAMP_HOUR
    ORDER BY BLOCK_TIMESTAMP_HOUR;