DataBeingOptimism Block Time Average Faster
Updated 2022-07-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with optimism_block_time as (SELECT
AVG(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as AVG_block_time,
MAX(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as MAX_block_time,
MIN(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as MIN_block_time, date_trunc('day', a.block_timestamp) as day
FROM optimism.core.fact_transactions a
JOIN optimism.core.fact_transactions b
on a.block_number = b.block_number - 1
GROUP BY 4),
polygon_block_time as (SELECT
AVG(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as AVG_block_time,
MAX(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as MAX_block_time,
MIN(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as MIN_block_time, date_trunc('day', a.block_timestamp) as day
FROM polygon.core.fact_transactions a
JOIN polygon.core.fact_transactions b
on a.block_number = b.block_number - 1
GROUP BY 4)
SELECT ((o.avg_block_time/p.avg_block_time) * 100) as block_time_percent, o.day
FROM optimism_block_time as o
JOIN polygon_block_time as p
ON o.day = p.day
Run a query to Download Data