NuveveCryptoArchivedBlock Time
Updated 2023-05-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with bt as (
select
b.block_timestamp as block_timestamp,
b.block_height as block_height,
datediff(second, b.block_timestamp, a.block_timestamp) as block_time
from flow.core.fact_blocks as a
inner join flow.core.fact_blocks as b on a.block_height = b.block_height + 1
where a.block_timestamp::date >= current_date - 30
)
select
block_timestamp::date as date,
avg(block_time) as block_time
from bt
group by date
Run a query to Download Data