Date | AVG TPS | LAG_AVG_TPS | AVG TPS Change % | MAX TPS | LAG_MAX_TPS | MAX TPS Change % | |
|---|---|---|---|---|---|---|---|
1 | 2025-03-03 00:00:00.000 | 132.817336439076 | 165.632136471376 | -19.81 | 1511 | 7653 | -80.26 |
2 | 2025-02-24 00:00:00.000 | 165.632136471376 | 57.387248002472 | 188.62 | 7653 | 3764 | 103.32 |
3 | 2025-02-17 00:00:00.000 | 57.387248002472 | 3764 |
MrftiMona TPS
Updated 10 days ago
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
27
28
29
30
31
32
33
34
35
›
⌄
-- forked from indirect-magenta @ https://flipsidecrypto.xyz/studio/queries/9b87dc57-bace-42e3-8a7b-83c4846475f2
WITH block_data AS (
SELECT
date_trunc({{period_type}}, block_timestamp) AS period_start,
block_timestamp,
COUNT(DISTINCT tx_hash) AS tx_count,
LEAD(block_timestamp) OVER (ORDER BY block_timestamp) AS next_block_timestamp
FROM
monad.testnet.fact_transactions
WHERE
block_timestamp::date >= '{{start_day}}'
AND date_trunc({{period_type}}, block_timestamp) <= '{{target_day}}'
GROUP BY
1, 2
)
SELECT
period_start AS "Date",
AVG(tx_count / NULLIF(DATEDIFF('second', block_timestamp, next_block_timestamp), 0)) AS "AVG TPS",
LAG("AVG TPS") OVER (ORDER BY period_start) AS lag_avg_tps,
ROUND(100 * ("AVG TPS" - lag_avg_tps)/NULLIF(lag_avg_tps, 0), 2) AS "AVG TPS Change %",
MAX(tx_count / NULLIF(DATEDIFF('second', block_timestamp, next_block_timestamp), 0)) AS "MAX TPS",
LAG("MAX TPS") OVER (ORDER BY period_start) AS lag_max_tps,
ROUND(100 * ("MAX TPS" - lag_max_tps)/NULLIF(lag_max_tps, 0), 2) AS "MAX TPS Change %"
FROM
block_data
WHERE
next_block_timestamp IS NOT NULL
GROUP BY
1
ORDER BY
1 DESC;
Last run: 10 days ago
3
241B
491s