itsxenuxTop 10 Popular Swaped To
    Updated 2022-03-02
    WITH query_table AS
    (SELECT s.swap_to_mint , b.address_name, COUNT(s.swap_to_mint) AS swap_count
    FROM Solana.swaps s
    JOIN Solana.labels b ON s.swap_to_mint = b.address
    WHERE block_timestamp::date >= '2022-02-01'
    AND swap_program LIKE 'jupiter%' AND swap_from_amount != 0 AND swap_to_amount != 0 AND succeeded = 'True'
    GROUP BY s.swap_to_mint, b.address_name
    ORDER BY swap_count DESC LIMIT 10)
    SELECT * FROM query_table;
    Run a query to Download Data