freemartianBedrock Failed Transactions
    Updated 2023-08-30

    with dates as (
    select
    timestampdiff('day', '2023-06-06 16:00:00.000', current_date) as X_days_after_bedrock,
    '2023-06-06 16:00:00.000' as Bedrock_live,
    current_date - (2*X_days_after_bedrock) as X_days_before_bedrock
    )

    SELECT
    COUNT(tx_hash) AS "Number failed transactions",
    (CASE
    WHEN block_timestamp < '2023-06-06 16:00:00.000' THEN 'Before Bedrock'
    when block_timestamp > '2023-06-06 16:00:00.000' then 'After Bedrock' END
    ) AS "Label",
    date_trunc('day', block_timestamp) as time

    FROM optimism.core.fact_transactions
    inner join dates d
    WHERE block_timestamp BETWEEN X_days_before_bedrock and current_date
    and status != 'SUCCESS'
    GROUP BY "Label", time
    ORDER BY "Label"





    Run a query to Download Data