Query editor
/* Unified On-Chain Performance Analysis *//* Period: 2025-10-20 07:00:00 to 2025-10-20 12:00:00 UTC */WITH base_perf AS (SELECTDATE_TRUNC('hour', block_time) AS hour,COUNT(DISTINCT block_number) AS blocks,COUNT(*) AS txFROM base.transactionsWHEREblock_time BETWEEN CAST('2025-10-20 07:00:00' AS TIMESTAMP) AND CAST('2025-10-20 12:00:00' AS TIMESTAMP)GROUP BY1), arbitrum_perf AS (SELECTDATE_TRUNC('hour', block_time) AS hour,COUNT(DISTINCT block_number) AS blocks,COUNT(*) AS txFROM arbitrum.transactionsWHEREblock_time BETWEEN CAST('2025-10-20 07:00:00' AS TIMESTAMP) AND CAST('2025-10-20 12:00:00' AS TIMESTAMP)GROUP BY1), polygon_perf AS (SELECTDATE_TRUNC('hour', block_time) AS hour,COUNT(DISTINCT block_number) AS blocks,COUNT(*) AS txFROM polygon.transactionsWHEREblock_time BETWEEN CAST('2025-10-20 07:00:00' AS TIMESTAMP) AND CAST('2025-10-20 12:00:00' AS TIMESTAMP)GROUP BY1), optimism_perf AS (SELECTDATE_TRUNC('hour', block_time) AS hour,COUNT(DISTINCT block_number) AS blocks,COUNT(*) AS txFROM optimism.transactionsWHEREblock_time BETWEEN CAST('2025-10-20 07:00:00' AS TIMESTAMP) AND CAST('2025-10-20 12:00:00' AS TIMESTAMP)GROUP BY1) /* 🧾 Combine all networks */SELECThour,'Base' AS network,base_perf.blocks,base_perf.tx,ROUND(base_perf.tx / 3600.0, 1) AS tps,CASEWHEN base_perf.tx >= 420000THEN 'Operational'WHEN base_perf.tx BETWEEN 350000 AND 419999THEN 'Partial recovery'ELSE 'Limited capacity'END AS statusFROM base_perfUNION ALLSELECThour,