date_trunc('hour', block_timestamp) as hour,

count(distinct(block_number))/3600 as avg_tps

from optimism.core.fact_event_logs

group by hour