Query editor
-- Robust unified multi-chain comparison with baseline (Oct 19) and outage (Oct 20)WITH-- Per-network performance for Oct 20 (outage window)base_perf AS (SELECTdate_trunc('hour', block_time) AS hour,COUNT(DISTINCT block_number) AS blocks,COUNT(*) AS txFROM base.transactionsWHERE block_time BETWEEN TIMESTAMP '2025-10-20 07:00:00' AND TIMESTAMP '2025-10-20 11:00:00'GROUP BY date_trunc('hour', block_time)),arbitrum_perf AS (SELECTdate_trunc('hour', block_time) AS hour,COUNT(DISTINCT block_number) AS blocks,COUNT(*) AS txFROM arbitrum.transactionsWHERE block_time BETWEEN TIMESTAMP '2025-10-20 07:00:00' AND TIMESTAMP '2025-10-20 11:00:00'GROUP BY date_trunc('hour', block_time)),polygon_perf AS (SELECTdate_trunc('hour', block_time) AS hour,COUNT(DISTINCT block_number) AS blocks,COUNT(*) AS txFROM polygon.transactionsWHERE block_time BETWEEN TIMESTAMP '2025-10-20 07:00:00' AND TIMESTAMP '2025-10-20 11:00:00'GROUP BY date_trunc('hour', block_time)),optimism_perf AS (SELECTdate_trunc('hour', block_time) AS hour,COUNT(DISTINCT block_number) AS blocks,COUNT(*) AS txFROM optimism.transactionsWHERE block_time BETWEEN TIMESTAMP '2025-10-20 07:00:00' AND TIMESTAMP '2025-10-20 11:00:00'GROUP BY date_trunc('hour', block_time)),-- Combined (wrap UNION in a subquery and force column names)combined_day AS (SELECThour,network,blocks,tx,tpsFROM (SELECT hour, 'Base' AS network, blocks, tx, ROUND(tx/3600.0,1) AS tps FROM base_perfUNION ALLSELECT hour, 'Arbitrum' AS network, blocks, tx, ROUND(tx/3600.0,1) AS tps FROM arbitrum_perfUNION ALLSELECT hour, 'Polygon' AS network, blocks, tx, ROUND(tx/3600.0,1) AS tps FROM polygon_perfUNION ALLSELECT hour, 'Optimism' AS network, blocks, tx, ROUND(tx/3600.0,1) AS tps FROM optimism_perf) AS t(hour, network, blocks, tx, tps)),-- Baseline: hourly averages from Oct 19 (same window) per network