KaskoazulTop10 Swap Away
    Updated 2022-02-27
    SELECT
    l.label as labelAway,
    s.swap_to_mint,
    count(tx_id) as swapCountAway --count(l.label)
    FROM Solana.swaps s
    LEFT OUTER JOIN Solana.labels l
    ON s.swap_to_mint = l.address
    WHERE block_timestamp::date >= '2022-02-01'
    AND succeeded = 'True'
    GROUP BY 1, 2
    ORDER BY 3 DESC
    LIMIT 10
    Run a query to Download Data