hess5. TPS
    Updated 2025-04-13
    with monad AS (select block_timestamp,
    tx_hash
    from monad.testnet.fact_transactions
    where tx_succeeded = 'TRUE'
    )
    ,
    txns as (select trunc(block_timestamp,'second') as seconds,
    count(DISTINCT tx_hash) as txns
    from monad
    group by 1
    )

    select trunc(seconds,'day') as daily,
    avg(txns) as "Avg TPS",
    median(txns) as "Median TPS",
    max(txns) as "Max TPS"
    from txns
    group by 1
    order by 1 asc


    Last run: 12 days ago
    DAILY
    Avg TPS
    Median TPS
    Max TPS
    1
    2025-01-07 00:00:00.00033.41692
    2
    2025-01-08 00:00:00.0001.049151139
    3
    2025-01-09 00:00:00.0005.5548091600
    4
    2025-01-10 00:00:00.0001.2569731291
    5
    2025-01-11 00:00:00.000111
    6
    2025-01-12 00:00:00.000111
    7
    2025-01-13 00:00:00.0001.02622513
    8
    2025-01-14 00:00:00.0001.03140212
    9
    2025-01-15 00:00:00.0001.04031514
    10
    2025-01-16 00:00:00.0001.03196619
    11
    2025-01-17 00:00:00.0001.617454119
    12
    2025-01-18 00:00:00.0001.083799118
    13
    2025-01-19 00:00:00.0002.7635811200
    14
    2025-01-20 00:00:00.0002.6675681100
    15
    2025-01-21 00:00:00.0008.0658861200
    16
    2025-01-22 00:00:00.0004.5651441200
    17
    2025-01-23 00:00:00.0001.494068123
    18
    2025-01-24 00:00:00.0002247.51173630006000
    19
    2025-01-25 00:00:00.0001.552288114
    20
    2025-01-26 00:00:00.0001.694645111
    97
    4KB
    118s