olavsuccess and fail rate by day
    Updated 2022-09-26
    select * from (
    select
    block_timestamp::date as datetime,
    'Pre Merge' as status,
    count (iff(status = 'SUCCESS', 1, null)) as success_rate,
    count (iff(status = 'FAIL', 1, null)) as fail_rate
    from ethereum.core.fact_transactions
    where 1 = 1
    and block_timestamp::date >= '2022-09-08'
    and block_timestamp::date < '2022-09-15'
    group by datetime

    union
    select
    block_timestamp::date as datetime,
    'Day of Merge' as status,
    count (iff(status = 'SUCCESS', 1, null)) as success_rate,
    count (iff(status = 'FAIL', 1, null)) as fail_rate
    from ethereum.core.fact_transactions
    where 1 = 1
    and block_timestamp::date = '2022-09-15'
    group by datetime

    union
    select
    block_timestamp::date as datetime,
    'Post Merge' as status,
    count (iff(status = 'SUCCESS', 1, null)) as success_rate,
    count (iff(status = 'FAIL', 1, null)) as fail_rate
    from ethereum.core.fact_transactions
    where 1 = 1
    and block_timestamp::date > '2022-09-15'
    and block_timestamp::date < '2022-09-23'
    group by datetime
    Run a query to Download Data