TOTAL_BLOCKS_LAST_HOUR | AVG_BLOCK_SPEED_MS | |
|---|---|---|
1 | 984 | 1098.007121 |
datavortexblocktime last 1 hr
Updated 2025-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
WITH block_times AS (
SELECT
BLOCK_ID,
BLOCK_TIMESTAMP,
LAG(BLOCK_TIMESTAMP) OVER (ORDER BY BLOCK_TIMESTAMP) AS prev_block_timestamp
FROM
near.core.fact_blocks
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -1, CURRENT_TIMESTAMP)
),
block_speeds AS (
SELECT
BLOCK_ID,
BLOCK_TIMESTAMP,
TIMESTAMPDIFF(MILLISECOND, prev_block_timestamp, BLOCK_TIMESTAMP) AS block_speed_ms
FROM
block_times
WHERE
prev_block_timestamp IS NOT NULL
)
SELECT
COUNT(*) + 1 AS total_blocks_last_day,
AVG(block_speed_ms) AS avg_block_speed_ms
FROM
block_speeds;
Last run: about 1 month ago
1
19B
1s