select

date_trunc('hour',block_timestamp) AS hour,

(CASE

WHEN block_timestamp < '2024-03-14 15:00:00.000' THEN 'Before Dencun'

WHEN block_timestamp >= '2024-03-14 15:00:00.000' THEN 'After Dencun'

END

) AS label,

AVG(tx_count) AS tx_in_block

FROM arbitrum.core.fact_blocks

WHERE block_timestamp BETWEEN

DATEADD(hour, -timestampdiff('hour', '2024-03-14 15:00:00.000', current_timestamp), '2024-03-14 15:00:00.000')

AND

DATEADD(hour, timestampdiff('hour', '2024-03-14 15:00:00.000', current_timestamp), '2024-03-14 15:00:00.000')

GROUP BY 1,2