i_danMonad: TPS
Updated 2025-02-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH hourly_tx AS (
SELECT
DATE_TRUNC('hour', block_timestamp) AS hour
, COUNT(*) AS tx_count
, COUNT(DISTINCT from_address) AS add_count
FROM monad.testnet.fact_transactions
GROUP BY 1
)
SELECT
hour AS "Hour"
, add_count AS "Total Wallets"
, tx_count AS "Total Transactions"
, tx_count / 3600.0 AS "TPS"
FROM hourly_tx
--WHERE hour>= '2025-01-24'--tps > 1
ORDER BY hour