2844Raydium TOTAL SWAPS
    Updated 2022-07-11
    with Total as(
    select
    block_timestamp::date as "DATE", count(TX_ID) as "Raydium TOTAL SWAPS"
    from
    solana.fact_swaps
    where block_timestamp::date >= '2022-01-01'
    AND swap_program in ('raydium v4')
    AND swap_from_amount > 0
    GROUP BY 1
    ORDER BY 1 DESC),

    FALSE AS (
    select
    block_timestamp::date as "DATE1",count(TX_ID) as "Raydium FAILED SWAPS"
    from solana.core.fact_swaps
    where block_timestamp::date >= '2022-01-01'
    AND succeeded = FALSE
    AND swap_program in ('raydium v4')

    GROUP BY 1
    ORDER BY 1 DESC
    )
    SELECT "DATE","Raydium TOTAL SWAPS","Raydium FAILED SWAPS","Raydium FAILED SWAPS"/"Raydium TOTAL SWAPS" AS "RATE OF FAILED SWAPS"
    FROM Total,FALSE
    WHERE "DATE"="DATE1"
    GROUP BY 1,2,3
    ORDER BY 1
    Run a query to Download Data