BLOCK_DATE | AVERAGE_BLOCKTIME_MS | |
|---|---|---|
1 | 2025-02-26 00:00:00.000 | 524.928 |
2 | 2025-02-25 00:00:00.000 | 508.502 |
3 | 2025-02-24 00:00:00.000 | 501.337 |
4 | 2025-02-23 00:00:00.000 | 500.899 |
5 | 2025-02-22 00:00:00.000 | 500.414 |
6 | 2025-02-21 00:00:00.000 | 500.835 |
7 | 2025-02-20 00:00:00.000 | 501.39 |
8 | 2025-02-19 00:00:00.000 | 513.271 |
moonshot21Daily Average Blocktime
Updated 2025-02-27
9
1
2
3
4
5
6
7
›
⌄
SELECT
DATE(BLOCK_TIMESTAMP) AS block_date,
(86400.0 / COUNT(*) * 1000) AS average_blocktime_ms
FROM monad.testnet.fact_blocks
WHERE BLOCK_TIMESTAMP >= '2025-02-19' AND DATE(BLOCK_TIMESTAMP) < CURRENT_DATE
GROUP BY DATE(BLOCK_TIMESTAMP)
ORDER BY block_date DESC;
Last run: 21 days ago
8
288B
2s