flipside

    Near's failed transactions
    NatNear's failed transactions
    Updated 2022-07-19
    with status_ as (select
    case when tx_receipt[0]:outcome:status:Failure is not NULL
    THEN 'Failure'
    ELSE 'Success'
    end as status,
    BLOCK_TIMESTAMP,
    TXN_HASH
    from flipside_prod_db.mdao_near.transactions)
    select *
    from status_
    where status = 'Failure'
    Run a query to Download Data