EXTRACT(HOUR FROM BLOCK_TIMESTAMP) AS hour_of_day,

COUNT(*) AS bond_events

FROM thorchain.defi.fact_bond_events

GROUP BY EXTRACT(HOUR FROM BLOCK_TIMESTAMP)

ORDER BY hour_of_day;