AlishSuccess rate on jupiter
    Updated 2022-03-13
    WITH Jup_tot AS (
    SELECT
    to_date(block_timestamp) AS Days,
    COUNT(tx_id) tot_tx
    FROM solana.swaps
    WHERE Days>='2022-01-01'
    AND swap_program LIKE '%jupiter%'
    GROUP BY Days
    ORDER BY Days ASC
    ),

    jup_success AS (
    SELECT
    to_date(block_timestamp) AS Days,
    COUNT(tx_id) success_tx
    FROM solana.swaps
    WHERE Days>='2022-01-01'
    AND swap_program LIKE '%jupiter%'
    AND succeeded='true'
    GROUP BY Days
    ORDER BY Days ASC
    ),



    Success_rate AS(
    SELECT*
    FROM Jup_tot
    JOIN jup_success
    USING(Days)
    )

    SELECT
    Days, tot_tx, SUCCESS_TX,SUCCESS_TX/tot_tx*100 AS success_percent
    Run a query to Download Data