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, -- میانگین TPS

MIN(tx_count) AS min_tps, -- کمترین مقدار TPS

MAX(tx_count) AS max_tps -- بیشترین مقدار TPS

FROM transactions_per_second;