DATE | AVG_TIME_DIFF | |
|---|---|---|
1 | 2025-01-19 00:00:00.000 | 1 |
2 | 2025-01-10 00:00:00.000 | 1 |
3 | 2025-02-16 00:00:00.000 | 1 |
4 | 2025-03-02 00:00:00.000 | 1 |
5 | 2025-03-22 00:00:00.000 | 1 |
6 | 2024-12-20 00:00:00.000 | 1 |
7 | 2025-02-04 00:00:00.000 | 1 |
8 | 2025-02-15 00:00:00.000 | 1 |
9 | 2025-03-15 00:00:00.000 | 1 |
10 | 2025-03-19 00:00:00.000 | 1 |
11 | 2025-03-14 00:00:00.000 | 1 |
12 | 2025-01-13 00:00:00.000 | 1 |
13 | 2025-03-13 00:00:00.000 | 1 |
14 | 2025-04-01 00:00:00.000 | 1 |
15 | 2025-02-13 00:00:00.000 | 1 |
16 | 2025-02-17 00:00:00.000 | 1 |
17 | 2025-03-31 00:00:00.000 | 1 |
18 | 2024-12-17 00:00:00.000 | 1 |
19 | 2025-02-18 00:00:00.000 | 1 |
20 | 2025-02-22 00:00:00.000 | 1 |
BlockTrackeraverage block_time
Updated 2025-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with time as (
select
block_timestamp,
lag(block_timestamp) over (order by block_timestamp) as prev_time
from ink.core.fact_blocks
where network = 'mainnet'
)
select
date_trunc('day', block_timestamp) as date,
avg(datediff(second,prev_time,block_timestamp)) as avg_time_diff
from time
where date < CURRENT_DATE
group by 1
Last run: 3 months ago
...
121
4KB
7s