LTirrell2022-01-01_solana_fails
    Updated 2023-02-21
    -- When Do Transactions Fail?
    -- Do times of high transaction volume lead to more transaction failures?
    -- Create a visualization that shows the relationship between transaction volume and success rate of transactions throughout the month of December.
    -- Are there any noticeable patterns to when transactions are more likely to fail?


    select
    date_trunc('minute', block_timestamp) as datetime,
    count(
    case
    when succeeded = 'FALSE' then succeeded
    end
    ) as fails,
    count(
    case
    when succeeded = 'TRUE' then succeeded
    end
    ) as success,
    count(tx_id) as tx_count,
    success / (tx_count) as success_rate
    from
    solana.core.fact_transactions
    where
    block_timestamp :: date >= '2021-12-01'
    and block_timestamp :: date < '2022-01-01'
    group by
    datetime
    order by
    datetime
    Run a query to Download Data