Crazy_KidSwaps On Jupiter 3
    Updated 2022-02-27
    SELECT swap_program, CASE
    WHEN swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'
    WHEN swap_from_mint = 'So11111111111111111111111111111111111111112' THEN 'Wrapped Sol'
    WHEN swap_from_mint = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' THEN 'Raydium'
    WHEN swap_from_mint = 'StepAscQoEioFxxWGnh2sLBDFp9d8rvKz2Yp39iDpyT' THEN 'Step'
    WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN 'mSOL'
    WHEN swap_from_mint = '9n4nbM75f5Ui33ZbPYXn59EwSgE8CGsHtAeTH5YFeJ9E' THEN 'Wrapped Bitcoin (Sollet)'
    WHEN swap_from_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDT'
    END AS swap_from_token,CASE
    WHEN swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'
    WHEN swap_to_mint = 'So11111111111111111111111111111111111111112' THEN 'Wrapped Sol'
    WHEN swap_to_mint = '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' THEN 'Raydium'
    WHEN swap_to_mint = 'StepAscQoEioFxxWGnh2sLBDFp9d8rvKz2Yp39iDpyT' THEN 'Step'
    WHEN swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDT'
    END AS swap_to_token,
    COUNT(swap_from_mint) as swap_count
    FROM solana.swaps
    WHERE date(block_timestamp) >= '2022-02-01' and succeeded = 'TRUE' and swap_from_amount != 0 AND swap_to_amount != 0
    AND swap_from_mint != swap_to_mint
    GROUP BY swap_program, swap_from_mint, swap_to_mint
    ORDER BY swap_count DESC
    limit 10
    Run a query to Download Data