kiacryptomost popular swapping to
    Updated 2022-03-08
    Select ll.address_name as "to", COUNT(*)
    From solana.swaps s LEFT OUTER JOIN solana.labels l ON s.swap_from_mint = l.address LEFT OUTER JOIN solana.labels ll ON s.swap_to_mint = ll.address
    Where block_timestamp::date >= '2021-12-01' And succeeded = 'True' And (swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_from_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
    or swap_from_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' ) And (swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
    or swap_to_mint = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' ) AND swap_from_amount > 0 AND swap_to_amount > 0 and swap_program = 'jupiter aggregator v2' AND swap_from_mint != swap_to_mint
    GROUP by 1
    ORDER by 2 DESC
    Run a query to Download Data