flipside

    Block Creation Rate per Day in August
    jorshimayorBlock Creation Rate per Day in August
    Updated 2024-09-26
    SELECT
    DATE(block_timestamp) AS day,
    COUNT(block_id) AS blocks_per_day
    FROM
    sei.core.fact_blocks
    WHERE
    block_timestamp BETWEEN '2024-08-01'
    AND '2024-08-31'
    GROUP BY
    day
    ORDER BY
    day ASC;
    QueryRunArchived: QueryRun has been archived