Query editor
WITH base_perf AS (SELECTDATE_TRUNC('hour', block_time) AS hour,COUNT(DISTINCT base.blocks.number) AS blocks,COUNT(*) AS txFROM base.transactionsJOIN base.blocksON base.transactions.block_number = base.blocks.numberWHEREblock_time BETWEEN TRY_CAST('2025-10-20 07:00:00' AS TIMESTAMP) AND TRY_CAST('2025-10-20 12:00:00' AS TIMESTAMP)GROUP BY1)SELECThour,blocks,tx,ROUND(tx / 3600.0, 1) AS tps,CASEWHEN tx >= 420000THEN 'Operational'WHEN tx BETWEEN 350000 AND 419999THEN 'Partial recovery'ELSE 'Limited capacity'END AS statusFROM base_perfORDER BYhour