Mrftiswell chain succeed vs failed tx copy copy
    Updated 2025-02-07
    -- forked from berachain succeed vs failed tx copy @ https://flipsidecrypto.xyz/studio/queries/d83d1bda-b58b-48cc-af6e-bd47a824963e

    (
    SELECT
    'Total succeed transactions' as label,
    count (DISTINCT tx_hash) as "Total transactions"
    FROM
    swell.core.fact_transactions
    where
    TX_SUCCEEDED = 'TRUE'
    )

    union all

    (
    SELECT
    'Total failed transactions' as label,
    count (DISTINCT tx_hash) as "Total transactions"
    FROM
    swell.core.fact_transactions
    where
    TX_SUCCEEDED = 'FALSE'
    )


    Last run: about 1 month ago
    LABEL
    Total transactions
    1
    Total succeed transactions3388696
    2
    Total failed transactions3936
    2
    75B
    3s