flipside

    SOL 22/6/6 Solana Outages 1.1: Num transactions per minute 5/1
    elvisSOL 22/6/6 Solana Outages 1.1: Num transactions per minute 5/1
    Updated 2022-06-06
    WITH NUM_TS_SUCCESS AS (
    SELECT date_trunc('minute',block_timestamp) AS time, count(tx_id) AS tx_succeeded
    FROM flipside_prod_db.solana.fact_transactions
    WHERE (block_timestamp > '2022-04-30 12:00:00' AND block_timestamp < '2022-05-01 12:00:00')
    AND succeeded = TRUE
    GROUP BY 1
    ),
    NUM_TS_FAILED AS (
    SELECT date_trunc('minute',block_timestamp) AS time, count(tx_id) AS tx_failed
    FROM flipside_prod_db.solana.fact_transactions
    WHERE (block_timestamp > '2022-04-30 12:00:00' AND block_timestamp < '2022-05-01 12:00:00')
    AND succeeded = FALSE
    GROUP BY 1
    ),
    NUM_TS_PER_MIN AS (
    SELECT *
    FROM NUM_TS_SUCCESS NATURAL FULL JOIN NUM_TS_FAILED
    )

    SELECT *
    FROM NUM_TS_PER_MIN
    Run a query to Download Data