SELECT

MAX(block_timestamp) - INTERVAL '1 hour' AS recent_hour_start,

MAX(block_timestamp) - INTERVAL '24 hour' AS recent_day_start

FROM

monad.testnet.fact_transactions

),

max_block_tx AS (

SELECT

block_number AS max_tx_block_number,

COUNT(*) AS max_tx_per_block

FROM

monad.testnet.fact_transactions

WHERE

TX_SUCCEEDED = true

GROUP BY

block_number

ORDER BY

max_tx_per_block DESC

LIMIT 1

),

recent_hour AS (

SELECT

DATE_TRUNC('hour', convert_timezone('UTC', 'Asia/Shanghai', block_timestamp)) AS hour,

COUNT(*) AS tx_count

FROM

monad.testnet.fact_transactions

WHERE

TX_SUCCEEDED = true

AND block_timestamp >= (SELECT recent_hour_start FROM recent_time_range)

GROUP BY

DATE_TRUNC('hour', convert_timezone('UTC', 'Asia/Shanghai', block_timestamp))

),

hourly_tps AS (

SELECT

AVG(tx_count) / 3600.0 AS tps_per_second_hourly