DAY | AVERAGE_BLOCK_TIME_MS | |
|---|---|---|
1 | 2024-08-25 00:00:00.000 | 644.496225 |
2 | 2024-08-26 00:00:00.000 | 377.054403 |
3 | 2024-08-27 00:00:00.000 | 359.89986 |
4 | 2024-08-28 00:00:00.000 | 352.948626 |
5 | 2024-08-29 00:00:00.000 | 353.12173 |
6 | 2024-08-30 00:00:00.000 | 353.128947 |
7 | 2024-08-31 00:00:00.000 | 353.108742 |
8 | 2024-09-01 00:00:00.000 | 353.049583 |
9 | 2024-09-02 00:00:00.000 | 352.961603 |
10 | 2024-09-03 00:00:00.000 | 352.950068 |
11 | 2024-09-04 00:00:00.000 | 352.971697 |
12 | 2024-09-05 00:00:00.000 | 352.824672 |
13 | 2024-09-06 00:00:00.000 | 352.778572 |
14 | 2024-09-07 00:00:00.000 | 352.729604 |
15 | 2024-09-08 00:00:00.000 | 352.77137 |
16 | 2024-09-09 00:00:00.000 | 352.775691 |
17 | 2024-09-10 00:00:00.000 | 352.732484 |
18 | 2024-09-11 00:00:00.000 | 352.733924 |
19 | 2024-09-12 00:00:00.000 | 352.736804 |
20 | 2024-09-13 00:00:00.000 | 352.761287 |
moonshot21Daily Average Block Time
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH block_times AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,
BLOCK_TIMESTAMP,
LAG(BLOCK_TIMESTAMP) OVER (PARTITION BY DATE_TRUNC('day', BLOCK_TIMESTAMP) ORDER BY BLOCK_HEIGHT) AS previous_block_time
FROM eclipse.core.fact_blocks
)
SELECT
day,
AVG(DATEDIFF(second, previous_block_time, BLOCK_TIMESTAMP) * 1000) AS average_block_time_ms
FROM block_times
WHERE
previous_block_time IS NOT NULL
GROUP BY day
ORDER BY day;
Last run: 11 days ago
...
180
7KB
7s