Monad Data Engineallied-maroon
    Updated 16 hours ago
    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: about 16 hours ago
    TOTAL_SUCCEEDED_TRANSACTIONS_LAST_24H
    TOTAL_FAILED_TRANSACTIONS_LAST_24H
    1
    18243507733103
    1
    19B
    3s