flipside

    developing-aquamarine
    monadmetrics-JFe1_Rdeveloping-aquamarine
    Updated 2025-03-11
    SELECT
    COUNT(*) AS total_succeeded_transactions_last_24h,
    SUM(CASE WHEN tx_succeeded = FALSE THEN 1 ELSE 0 END) AS total_failed_transactions_last_24h
    FROM MONAD.testnet.fact_transactions
    WHERE block_timestamp >= DATEADD('day', -1, CURRENT_TIMESTAMP);
    Last run: 8 days ago
    TOTAL_SUCCEEDED_TRANSACTIONS_LAST_24H
    TOTAL_FAILED_TRANSACTIONS_LAST_24H
    1
    		19269994624994
    1
    19B
    1s