maybeyonassol_msol_jup_combos
    Updated 2022-03-08
    with
    labels as (
    select
    address,
    address_name
    from solana.labels
    )
    select
    -- swap_from_mint,
    l1.address_name as sell_token,
    -- swap_to_mint,
    l2.address_name as buy_token,
    l1.address_name || ' to ' || l2.address_name as swap_combo,
    count(distinct tx_id) as sell_transactions
    from solana.swaps
    inner join labels l1 on lower(l1.address) = lower(swap_from_mint)
    inner join labels l2 on lower(l2.address) = lower(swap_to_mint)
    where swap_to_amount > 0
    and block_timestamp >= '2022-02-01'
    and swap_program = 'jupiter aggregator v2'
    and swap_from_mint != swap_to_mint
    and (
    swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' or
    swap_to_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
    )
    group by 1,2,3--,4
    order by sell_transactions desc
    limit 10


    Run a query to Download Data