LTirrell2022-02-18_solana_TPS_p3
    Updated 2022-02-22
    -- Solana TPS
    -- One of Solana's main features is its speed compared to other blockchains. Blockchain performance is usually measured in Transactions per Second (TPS). Measure the TPS of Solana in February (non votes) and 'Successful TPS' per day and create a chart showing how TPS has fluctuated during that time period.
    -- Sample Query: Select block_timestamp::date as date, count(_________) From solana.transactions Where block_timestamp::date >='2022-02-01' Group by date
    select
    date_trunc('second', block_timestamp) as datetime,
    count(
    case
    when succeeded = 'TRUE' then succeeded
    else NULL
    end
    ) as success,
    count(tx_id) as tx_count,
    tx_count - success as fails,
    success / (tx_count) as success_rate
    from
    solana.transactions
    where
    block_timestamp :: date >= '2022-02-15'
    group by
    datetime
    order by
    datetime
    Run a query to Download Data