barbodTop 20 Favorite Tokens for Top10 Gainers
    Updated 2022-03-28
    with gainers as (
    select
    SWAPPER
    ,count(tx_id) as tx_count
    ,sum(swap_to_amount-swap_from_amount) as gain
    from solana.swaps
    where block_timestamp::date >= '2022-02-01'
    and swap_program = 'jupiter aggregator v2'
    and succeeded = 'True'
    and (swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_from_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
    and (swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or swap_to_mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
    and swap_from_amount>=100 and swap_to_amount>=100
    group by 1
    having gain>0
    order by gain DESC
    limit 10
    )
    select
    address_name as token ,
    count (tx_id) as transactions
    from solana.swaps join solana.labels
    on swap_to_mint = address
    where block_timestamp::date >= '2022-02-01'
    and swapper in (select SWAPPER from gainers )
    group by 1 order by 2 desc limit 20

    Run a query to Download Data