date_trunc(hour, block_timestamp) AS hour_,

COUNT(*) AS nb_blocks,

ROUND(3600 / COUNT(*), 2) AS avg_block_time

FROM monad.testnet.fact_blocks

WHERE block_timestamp BETWEEN DATE_TRUNC(hour, SYSDATE() - INTERVAL '7 days')

AND DATE_TRUNC(hour, SYSDATE()) - INTERVAL '1 hour' - INTERVAL '1 second'

AND NOT (DATE(block_timestamp) = '2025-03-20' AND EXTRACT(HOUR FROM block_timestamp) BETWEEN 11 AND 16)

GROUP BY 1

ORDER BY 1;