flipside

    Top Gas-Consuming Blocks in September
    maymoth55Top Gas-Consuming Blocks in September
    Updated 2024-10-03
    SELECT BLOCK_NUMBER, GAS_USED
    FROM polygon.core.fact_blocks
    WHERE BLOCK_TIMESTAMP >= '2023-09-01'
    AND BLOCK_TIMESTAMP < '2023-10-01'
    ORDER BY GAS_USED DESC
    LIMIT 10;