date_trunc('hour', block_timestamp) as hours,

avg(tx_count) as avg_tpb

from ethereum.core.fact_blocks

where block_timestamp::date <= current_date - 1

and block_timestamp::date >= '2022-06-06'

group by hours

order by hours