Kruys-Collinseducational-salmon
    Updated 2025-02-20
    SELECT
    DATE_TRUNC('hour', block_timestamp) AS hour,
    AVG(cumulative_gas_used / NULLIF(gas_limit, 0)) AS avg_block_congestion
    FROM monad.testnet.fact_transactions
    WHERE block_timestamp >= '2025-02-19'
    GROUP BY hour
    ORDER BY hour;