Sleepyblock_creation_time
Updated 2023-06-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
day,
avg(block_creation_time) avg_block_creation,
avg(tx_count) avg_tx_in_block
from(
select
date_trunc('day', block_timestamp) day,
coalesce(TIMESTAMPDIFF(second, lag(block_timestamp)
over(order by block_timestamp), block_timestamp), 2) block_creation_time,
tx_count
from flow.core.fact_blocks
where block_timestamp::date between current_date - 180 and current_date - 1
)
group by day
order by day
Run a query to Download Data