date_trunc('hour', block_timestamp) as hour,

sum(tx_count)/3600 as avg_tps

from avalanche.core.fact_blocks

where block_timestamp >= '2022-6-20'

group by hour