par_rnMonad 04
    Updated 2025-02-21
    SELECT
    'Failed' AS transaction_status,
    COUNT(DISTINCT TX_HASH) AS failed_transactions
    FROM monad.testnet.fact_transactions
    WHERE TX_SUCCEEDED NOT IN ('true', TRUE)
    and block_timestamp >= '2025-02-19'

    UNION ALL

    SELECT
    'Successful' AS transaction_status,
    COUNT(DISTINCT TX_HASH) AS successful_transactions
    FROM monad.testnet.fact_transactions
    WHERE TX_SUCCEEDED IN ('true', TRUE)
    and block_timestamp >= '2025-02-19'

    Last run: about 2 months ago
    TRANSACTION_STATUS
    FAILED_TRANSACTIONS
    1
    Failed105430
    2
    Successful6702410
    2
    42B
    3s