LTirrell2022-01-01_solana_2
    Updated 2022-01-19
    -- 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(distinct tx_id)
    -- -- where succeeded='FALSE'
    -- limit 10

    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
    from
    solana.transactions
    where
    block_timestamp :: date >= '2021-12-01'
    and block_timestamp :: date < '2022-01-01'
    group by
    datetime

    Run a query to Download Data