SELECT

DATE_TRUNC('second', block_timestamp) AS second_timestamp,

COUNT(*) AS tx_count

FROM MONAD.testnet.fact_transactions

WHERE block_timestamp >= '2025-02-19 15:00:00.000' --

GROUP BY 1

SELECT

AVG(tx_count) AS avg_tps, --

MIN(tx_count) AS min_tps, --

MAX(tx_count) AS max_tps --

FROM transactions_per_second;