flipside

    Daily variation of the failed and successful transactions as well as the failure rate of transactions
    nsa2000Daily variation of the failed and successful transactions as well as the failure rate of transactions
    Updated 2022-10-26
    select 'Optimism' as blockchain,
    block_timestamp::date as date,
    count (case when STATUS != 'SUCCESS' then 1 end) as Failed_TX,
    count (case when STATUS = 'SUCCESS' then 1 end) as Success_TX,
    (Failed_TX / (Success_TX + Failed_TX)) * 100 as Failure_Rate
    from optimism.core.fact_transactions
    group by 1,2

    union ALL

    select 'Ethereum' as blockchain,
    block_timestamp::date as date,
    count (case when STATUS != 'SUCCESS' then 1 end) as Failed_TX,
    count (case when STATUS = 'SUCCESS' then 1 end) as Success_TX,
    (Failed_TX / (Success_TX + Failed_TX)) * 100 as Failure_Rate
    from ethereum.core.fact_transactions
    group by 1,2
    Run a query to Download Data