flipside

    Average Block Size in September
    maymoth55Average Block Size in September
    Updated 2024-10-03
    SELECT DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
    AVG(SIZE) AS avg_block_size
    FROM polygon.core.fact_blocks
    WHERE BLOCK_TIMESTAMP >= '2023-09-01'
    AND BLOCK_TIMESTAMP < '2023-10-01'
    GROUP BY day
    ORDER BY day;

    QueryRunArchived: QueryRun has been archived