maybeyonassol_jup_sells
    Updated 2022-02-27
    with
    labels as (
    select
    address,
    address_name
    from solana.labels
    )
    select
    swap_from_mint,
    labels.address_name,
    count(distinct tx_id) as sell_transactions
    from solana.swaps
    inner join labels on lower(labels.address) = lower(swap_from_mint)
    where swap_to_amount > 0
    and block_timestamp >= '2022-02-01'
    and swap_program = 'jupiter aggregator v2'
    and swap_to_mint != swap_from_mint
    group by 1,2
    order by sell_transactions desc
    limit 10


    Run a query to Download Data