⏰ Time | 💫 Transactions per Second | 📈 1-Hour Moving Average | |
|---|---|---|---|
1 | 2025-03-16 23:36:00.000 | 35.65 | 35.65 |
2 | 2025-03-16 23:37:00.000 | 147.433333 | 91.5416665 |
3 | 2025-03-16 23:38:00.000 | 155.733333 | 112.938888666 |
4 | 2025-03-16 23:39:00.000 | 162 | 125.2041665 |
5 | 2025-03-16 23:40:00.000 | 198.25 | 139.8133332 |
6 | 2025-03-16 23:41:00.000 | 200.133333 | 149.8666665 |
7 | 2025-03-16 23:42:00.000 | 187.316667 | 155.216666571 |
8 | 2025-03-16 23:43:00.000 | 156.75 | 155.40833325 |
9 | 2025-03-16 23:44:00.000 | 173.5 | 157.418518444 |
10 | 2025-03-16 23:45:00.000 | 164.75 | 158.1516666 |
11 | 2025-03-16 23:46:00.000 | 155.55 | 157.915151454 |
12 | 2025-03-16 23:47:00.000 | 151.483333 | 157.379166583 |
13 | 2025-03-16 23:48:00.000 | 153.933333 | 157.114102461 |
14 | 2025-03-16 23:49:00.000 | 146.6 | 156.363095142 |
15 | 2025-03-16 23:50:00.000 | 144 | 155.5388888 |
16 | 2025-03-16 23:51:00.000 | 160.25 | 155.83333325 |
17 | 2025-03-16 23:52:00.000 | 177.35 | 157.099019529 |
18 | 2025-03-16 23:53:00.000 | 195.433333 | 159.228703611 |
19 | 2025-03-16 23:54:00.000 | 200.516667 | 161.401754315 |
20 | 2025-03-16 23:55:00.000 | 205.116667 | 163.58749995 |
Monad Data Enginestatistical-plum
Updated 2025-03-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH transactions_per_second AS (
SELECT
DATE_TRUNC('minute', block_timestamp) AS minute_timestamp,
COUNT(*) / 60.0 AS tps
FROM MONAD.testnet.fact_transactions
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '24 hours'
GROUP BY 1
)
SELECT
minute_timestamp AS "⏰ Time",
tps AS "💫 Transactions per Second",
AVG(tps) OVER (ORDER BY minute_timestamp ROWS BETWEEN 59 PRECEDING AND CURRENT ROW) AS "📈 1-Hour Moving Average"
FROM transactions_per_second
ORDER BY minute_timestamp;
Last run: 11 days ago
...
1380
69KB
2s