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 AS "TPS"

FROM hourly_tx

WHERE hour >= '2025-02-19 15:00'--tps > 1

ORDER BY hour