DATE | AVG_TIME_DIFF | |
|---|---|---|
1 | 2025-06-09 00:00:00.000 | 0.596825 |
2 | 2025-06-08 00:00:00.000 | 0.569139 |
3 | 2025-06-07 00:00:00.000 | 0.529665 |
4 | 2025-06-06 00:00:00.000 | 0.546763 |
5 | 2025-06-05 00:00:00.000 | 0.563098 |
6 | 2025-06-04 00:00:00.000 | 0.556665 |
7 | 2025-06-03 00:00:00.000 | 0.53864 |
8 | 2025-06-02 00:00:00.000 | 0.542312 |
9 | 2025-06-01 00:00:00.000 | 0.578813 |
10 | 2025-05-31 00:00:00.000 | 0.573702 |
11 | 2025-05-30 00:00:00.000 | 0.592396 |
12 | 2025-05-29 00:00:00.000 | 0.620115 |
13 | 2025-05-28 00:00:00.000 | 0.527811 |
14 | 2025-05-27 00:00:00.000 | 0.565767 |
15 | 2025-05-26 00:00:00.000 | 0.594914 |
16 | 2025-05-25 00:00:00.000 | 0.536126 |
17 | 2025-05-24 00:00:00.000 | 0.523827 |
18 | 2025-05-23 00:00:00.000 | 0.553162 |
19 | 2025-05-22 00:00:00.000 | 0.572035 |
20 | 2025-05-21 00:00:00.000 | 0.563203 |
BlockTrackeraverage block_time
Updated 2025-06-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date_trunc('{{granularity}}', a.block_timestamp) as date,
avg(datediff(second, a.block_timestamp,b.block_timestamp)) as avg_time_diff
FROM monad.testnet.fact_blocks a, monad.testnet.fact_blocks b
WHERE a.block_number = b.block_number-1
and date >= '2025-01-07'
GROUP BY date
order by date desc
Last run: 14 days ago
...
154
6KB
6s