Yousefi_1994Optimistic Bears - Avg Block Time
Updated 2022-11-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
with optimism_odd_block as (
select
block_number,
block_timestamp
from optimism.core.fact_blocks
where mod(block_number::int, 2) = 1
and block_timestamp::date >= '2022-07-01' and block_timestamp::date <= '2022-07-31'
),
optimism_even_block as (
select
block_number,
block_timestamp
from optimism.core.fact_blocks
where mod(block_number::int, 2) = 0
and block_timestamp::date >= '2022-07-01' and block_timestamp::date <= '2022-07-31'
),
optimism_block_time_difference as (
select
odd.block_number as block_odd,
odd.block_timestamp as time_odd,
even.block_number as block_even,
even.block_timestamp time_even,
datediff('second', time_odd, time_even) as block_time_difference
from optimism_odd_block odd
join optimism_even_block even
on (even.block_number::int) = ((odd.block_number::int) + 1)
where time_odd <= time_even
order by block_time_difference desc
)
select round(avg(block_time_difference), 3) as "Average Block Time" from optimism_block_time_difference
Run a query to Download Data