Mrftidistinct-sapphire
Updated 8 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