DAY | Daily AVG TPS | |
|---|---|---|
1 | 2025-02-19 00:00:00.000 | 14.536367 |
2 | 2025-02-20 00:00:00.000 | 43.151518 |
3 | 2025-02-21 00:00:00.000 | 51.404958 |
4 | 2025-02-22 00:00:00.000 | 59.301913 |
5 | 2025-02-23 00:00:00.000 | 110.415271 |
6 | 2025-02-24 00:00:00.000 | 114.712161 |
7 | 2025-02-25 00:00:00.000 | 153.886029 |
8 | 2025-02-26 00:00:00.000 | 255.990532 |
9 | 2025-02-27 00:00:00.000 | 178.986516 |
10 | 2025-02-28 00:00:00.000 | 172.135789 |
11 | 2025-03-01 00:00:00.000 | 133.061795 |
12 | 2025-03-02 00:00:00.000 | 124.346671 |
13 | 2025-03-03 00:00:00.000 | 126.246878 |
14 | 2025-03-04 00:00:00.000 | 136.392479 |
15 | 2025-03-05 00:00:00.000 | 125.181102 |
16 | 2025-03-06 00:00:00.000 | 120.279482 |
17 | 2025-03-07 00:00:00.000 | 124.45637 |
18 | 2025-03-08 00:00:00.000 | 123.947673 |
19 | 2025-03-09 00:00:00.000 | 111.059607 |
20 | 2025-03-10 00:00:00.000 | 137.777011 |
Mrftidistinct-sapphire
Updated 12 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH daily_block_data AS
(
SELECT
date_trunc('day', block_timestamp) AS day,
COUNT(DISTINCT tx_hash) AS daily_tx_count,
DATEDIFF('second', MIN(block_timestamp), MAX(block_timestamp)) AS seconds_in_day
FROM monad.testnet.fact_transactions
GROUP BY 1
)
SELECT
day,
daily_tx_count / NULLIF(seconds_in_day, 0) AS "Daily AVG TPS"
FROM daily_block_data
where day > '2025-02-18 00:00:00.000'
ORDER BY 1
Last run: about 12 hours agoAuto-refreshes every 12 hours
27
1KB
140s