i_danMonad: TPS
    Updated 2025-02-21
    WITH hourly_tx AS (
    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.0 AS "TPS"
    FROM hourly_tx
    --WHERE hour>= '2025-01-24'--tps > 1
    ORDER BY hour
    Last run: 27 days ago
    Hour
    Total Wallets
    Total Transactions
    TPS
    1
    2025-01-07 20:00:00.0002100.002778
    2
    2025-01-07 21:00:00.0006890.024722
    3
    2025-01-07 22:00:00.0003820.022778
    4
    2025-01-07 23:00:00.00039880.274444
    5
    2025-01-08 00:00:00.000110.000278
    6
    2025-01-08 02:00:00.000240.001111
    7
    2025-01-08 03:00:00.000180.002222
    8
    2025-01-08 04:00:00.000120.000556
    9
    2025-01-08 05:00:00.0003410.011389
    10
    2025-01-08 06:00:00.0003350.009722
    11
    2025-01-08 07:00:00.0003480.013333
    12
    2025-01-08 08:00:00.0004120.003333
    13
    2025-01-08 09:00:00.0005230.006389
    14
    2025-01-08 10:00:00.000250.001389
    15
    2025-01-08 11:00:00.0003120.003333
    16
    2025-01-08 12:00:00.0004170.004722
    17
    2025-01-08 13:00:00.000550.001389
    18
    2025-01-08 14:00:00.0004440.012222
    19
    2025-01-08 15:00:00.0004290.008056
    20
    2025-01-08 16:00:00.00024320.12
    ...
    1066
    45KB
    2s