flipside

    #2 AvsB Query: success rate - arbitrum
    zakkisyed#2 AvsB Query: success rate - arbitrum
    Updated 2022-07-03
    SELECT count(DISTINCT (tx_hash))
    ,CASE
    WHEN STATUS = 'SUCCESS'
    THEN 'successful transactions'
    ELSE 'failed transactions'
    END AS STATUS
    FROM arbitrum.core.fact_transactions
    WHERE block_timestamp >= CURRENT_DATE - 7
    GROUP BY 2

    Run a query to Download Data