Crazzy_SidOP: Block Height
    Updated 2024-10-14
    SELECT
    DATE(BLOCK_TIMESTAMP) AS date,
    MAX(BLOCK_NUMBER) AS block_height
    FROM
    optimism.core.fact_blocks
    WHERE
    BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '30 DAY'
    GROUP BY
    DATE(BLOCK_TIMESTAMP)
    ORDER BY
    date DESC;

    QueryRunArchived: QueryRun has been archived