princefarzamWHAT PERCENTAGE OF ALL JUPITER SWAPS ARE STABLECOIN SWAPS
    Updated 2022-03-06
    WITH JUPITER AS (SELECT
    COUNT(DISTINCT TX_ID) AS All_JUPITER_SWAPS
    FROM solana.swaps
    WHERE block_timestamp::DATE >='2021-12-01'
    AND SUCCEEDED = TRUE
    AND SWAP_PROGRAM::string='jupiter aggregator v2'),
    STABLE AS(
    SELECT
    COUNT(DISTINCT TX_ID) AS STABLE_SWAPS
    FROM solana.swaps
    WHERE block_timestamp::DATE >='2021-12-01'
    AND SUCCEEDED = TRUE
    AND (SWAP_FROM_MINT::string IN ('9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
    OR SWAP_TO_MINT::string IN ('9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'))
    AND SWAP_PROGRAM::string='jupiter aggregator v2')
    SELECT
    J.All_JUPITER_SWAPS,
    S.STABLE_SWAPS,
    S.STABLE_SWAPS/J.All_JUPITER_SWAPS*100 AS PERCENTAGE
    FROM JUPITER J,STABLE S
    Run a query to Download Data