Monad Data Enginecultural-tan
    Updated 1 day ago
    WITH tps_per_second AS (
    SELECT
    DATE_TRUNC('second', block_timestamp) AS second_timestamp, --
    COUNT(tx_hash) AS tx_count
    FROM MONAD.testnet.fact_transactions
    WHERE block_timestamp >= DATEADD('day', -1, CURRENT_TIMESTAMP) --
    GROUP BY second_timestamp
    )
    SELECT
    AVG(tx_count) AS avg_tps_last_24h --
    FROM tps_per_second;
    Last run: 1 day ago
    AVG_TPS_LAST_24H
    1
    221.593573
    1
    14B
    3s