SELECT

DATE_TRUNC('hour', block_timestamp) AS hour,

COUNT(tx_id) AS txn

FROM

flipside_prod_db.polygon.transactions

WHERE

block_timestamp::date >= '2022-07-01'

GROUP BY hour

--GROUP BY date

--ORDER BY date