strawbettytotal number of swaps
    Updated 2022-03-11
    with top10_token_address as (
    select
    swap_from_mint,
    count(*) as swap_count
    from solana.swaps
    where block_timestamp::date >= '2022-02-01'
    and succeeded = 'TRUE'
    and swap_program = 'jupiter aggregator v2'
    group by 1
    order by 2 DESC
    limit 10
    )

    select block_timestamp::date as date, label, count(*)
    from solana.swaps swaps left outer join solana.labels labels on swaps.swap_from_mint = labels.address
    where block_timestamp::date >= '2022-02-01'
    and succeeded = 'TRUE'
    and swap_program = 'jupiter aggregator v2'
    and (swap_from_mint in (select swap_from_mint from top10_token_address))
    group by 1,2
    order by 3 desc
    Run a query to Download Data