afonsogap time
Updated 2023-01-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with list as
(
select *,
row_number() over (ORDER BY block_timestamp asc) as rn
from near.core.fact_blocks
where year(block_timestamp) = 2022
),
list2 as (
select datediff(s, o1.block_timestamp, o2.block_timestamp) as diff
from list o1 join list o2
on o1.rn + 1 = o2.rn
)
select
min(diff) as min_gap_time,
avg(diff) as average_gap_time,
median(diff) as median_gap_time,
max(diff) as max_gap_time
from list2
Run a query to Download Data