itsxenuxPopular Swap Pairs
    Updated 2022-03-02
    WITH query_table AS(
    SELECT b.label AS TOKEN_FROM, bf.label AS TO_TOKEN, COUNT(TOKEN_FROM) AS SWAP_COUNT,
    CONCAT(TOKEN_FROM,
    '/',
    TO_TOKEN) AS PAIRS
    FROM Solana.swaps s
    JOIN Solana.labels b ON s.swap_from_mint = b.address
    JOIN Solana.labels bf ON s.swap_to_mint = bf.address

    WHERE block_timestamp::date >= '2022-02-01' AND swap_program LIKE 'jupiter%' And swap_from_amount != 0 AND swap_to_amount != 0
    AND s.swap_from_mint != s.swap_to_mint
    AND succeeded = 'True'
    Group by TOKEN_FROM, TO_TOKEN
    Order by SWAP_COUNT DESC
    limit 10)
    SELECT * FROM query_table;
    Run a query to Download Data