Mrftitechnological-violet copy
    Updated 6 hours ago
    -- forked from technological-violet @ https://flipsidecrypto.xyz/studio/queries/2a92b40c-b035-499d-8b5c-874cb5936f73

    WITH block_data AS (
    SELECT
    block_timestamp,
    count(DISTINCT tx_hash) as tx_count,
    LEAD(block_timestamp) OVER (ORDER BY block_timestamp) as next_block_timestamp
    FROM
    monad.testnet.fact_transactions
    --where block_timestamp > '2025-02-19 15:00:00.000' --all time

    GROUP BY
    block_timestamp
    )

    SELECT
    AVG(tx_count / NULLIF(DATEDIFF('second', block_timestamp, next_block_timestamp), 0)) AS "AVG TPS",
    MAX(tx_count / NULLIF(DATEDIFF('second', block_timestamp, next_block_timestamp), 0)) AS "MAX TPS"
    FROM
    block_data
    WHERE
    next_block_timestamp IS NOT NULL


    Last run: about 6 hours agoAuto-refreshes every 12 hours
    AVG TPS
    MAX TPS
    1
    157.6834875019457653
    1
    25B
    551s