SELECT

date_trunc('hour', block_timestamp) as dhour

, CASE WHEN tx_count=0 THEN 'Empty' ELSE 'Non-Empty' END as label

, COUNT(*) as blocks

from monad.testnet.fact_blocks

WHERE 1=1

AND block_timestamp>='2025-02-19'

GROUP by 1, 2

SELECT * from base

ORDER by dhour ASC