bachiOptimism l2
Updated 2022-07-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT Concat(h1.block_number, ' - ', h2.block_number) AS
blocks,
Avg(Timestampdiff(second, h1.block_timestamp, h2.block_timestamp)) AS
avg_diff_secs
FROM optimism.core.fact_blocks h1
LEFT JOIN optimism.core.fact_blocks h2
ON h1.block_number + 1 = h2.block_number
--h1.block_number > h2.block_number
WHERE h1.block_number IS NOT NULL
AND h2.block_number IS NOT NULL
GROUP BY blocks
ORDER BY avg_diff_secs DESC
--limit 5000
Run a query to Download Data