i_danMonad: TPS Since Official Launch
    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 AS "TPS"
    FROM hourly_tx
    WHERE hour >= '2025-02-19 15:00'--tps > 1
    ORDER BY hour


    Last run: about 1 month ago
    Hour
    Total Wallets
    Total Transactions
    TPS
    1
    2025-02-19 15:00:00.000181997249820.138333
    2
    2025-02-19 16:00:00.000175686592918.313611
    3
    2025-02-19 17:00:00.000228179029725.0825
    4
    2025-02-19 18:00:00.0002751510864130.178056
    5
    2025-02-19 19:00:00.000205678251022.919444
    6
    2025-02-19 20:00:00.000250639359625.998889
    7
    2025-02-19 21:00:00.000155908344423.178889
    8
    2025-02-19 22:00:00.000129897929122.025278
    9
    2025-02-19 23:00:00.0001242212941535.948611
    10
    2025-02-20 00:00:00.0001336410564229.345
    11
    2025-02-20 01:00:00.000149997952322.089722
    12
    2025-02-20 02:00:00.000167598381923.283056
    13
    2025-02-20 03:00:00.000163458724624.235
    14
    2025-02-20 04:00:00.0001884310277128.5475
    15
    2025-02-20 05:00:00.0002209411538232.050556
    16
    2025-02-20 06:00:00.0002300312557734.8825
    17
    2025-02-20 07:00:00.0002655714982841.618889
    18
    2025-02-20 08:00:00.0002643713223336.731389
    19
    2025-02-20 09:00:00.0002773314340439.834444
    20
    2025-02-20 10:00:00.0002366613967038.797222
    40
    2KB
    2s