strawbetty historical swap success rate since January 1st on Jupiter
    Updated 2022-03-23
    with failed_jupiter as (
    Select
    block_timestamp::date as date,
    count(*) as failed_swaps_count
    From Solana.swaps s
    where block_timestamp::date >= '2022-01-01'
    and succeeded = 'FALSE'
    and swap_program like '%jupiter%'
    GROUP BY 1
    ORDER BY 1
    ), success_jupiter as (
    Select
    block_timestamp::date as date,
    count(*) as success_swaps_count
    From Solana.swaps s
    where block_timestamp::date >= '2022-01-01'
    and succeeded = 'TRUE'
    and swap_program like '%jupiter%'
    GROUP BY 1
    ORDER BY 1
    )

    SELECT f.date, failed_swaps_count, success_swaps_count, success_swaps_count/(success_swaps_count+failed_swaps_count) as success_ratio
    FROM failed_jupiter f LEFT JOIN success_jupiter s ON f.date = s.date
    ORDER BY 1
    Run a query to Download Data