-- forked from flyingfish / Summer Time Bug @ https://flipsidecrypto.xyz/flyingfish/q/MkkpbU1TihkG/summer-time-bug
select
date_trunc(hour, block_timestamp) as date
, count(1) as hourly_blocks
from solana.core.fact_blocks
where block_timestamp > '2024-03-30'
and block_timestamp < '2024-04-01'
group by date