piperSolana - Network Performance Dashboard: Failed/Success Tx
    Updated 2022-07-13
    /*
    Twitter: @der_piper
    Discrod: piper#6707

    Solana - Network Performance Dashboard

    Q95. Create a dashboard displaying Solana network performance over time.

    How has the network performed over the past month compared to the rest of the year?
    Has transaction per second and success rates of transactions gone up recently? Is
    this because of less botting or fewer users, or new improvements from the Solana
    engineers? What wallets and programs have paid the most in fees for failed transactions?
    */

    WITH part1 AS (
    SELECT
    block_timestamp::date AS date,
    succeeded,
    COUNT(tx_id) AS number_of_transactions
    FROM
    solana.core.fact_events
    WHERE
    block_timestamp BETWEEN '2022-01-01' AND '2022-04-30'
    GROUP BY date, succeeded),

    part2 AS (
    SELECT
    block_timestamp::date AS date,
    succeeded,
    COUNT(tx_id) AS number_of_transactions
    FROM
    solana.core.fact_events
    WHERE
    block_timestamp BETWEEN '2022-04-29' AND '2022-05-01'
    GROUP BY date, succeeded),
    Run a query to Download Data