SELECT block_timestamp, BLOCK_ID, COUNT(DISTINCT TX_ID) as tpb

FROM flipside_prod_db.algorand.transactions

WHERE block_timestamp > '2022-06-10'

GROUP BY 1, 2

SELECT to_char(date_trunc('hour', block_timestamp), 'yyyy-mm-dd HH24:MI:SS') as hour, avg(tpb) as avg_tpb, min(tpb) as min_tpb, max(tpb) as max_tpb

FROM tpb

GROUP BY 1

ORDER BY 1 ASC