fantapopularity of top 10 swapped to tokens
    Updated 2022-04-03
    with part1 as (select count(*) as count ,block_timestamp::date as date ,swap_program
    from
    solana.fact_swaps
    where
    date >= '2022-01-01' and
    (swap_program='raydium v4' or swap_program='jupiter aggregator v2' or swap_program='orca' )
    and succeeded = 'True'
    group by date,swap_program)
    , part2 as (select count(distinct swapper) as count ,block_timestamp::date as date ,swap_program
    from
    solana.fact_swaps
    where
    date >= '2022-01-01' and
    (swap_program='raydium v4' or swap_program='jupiter aggregator v2' or swap_program='orca' )
    and succeeded = 'True'
    group by date,swap_program)
    , part3 as(select top 10 count(*) as count ,label.address_name as name
    from solana.fact_swaps as swap inner join solana.dim_labels as label on label.address=swap.swap_to_mint
    where
    swap.swap_program='raydium v4'
    and swap.block_timestamp::date >= '2022-01-01'
    and swap.succeeded = 'True'
    group by name
    order by count(*) DESC)
    , part4 as(select top 10 count(*) as count ,label.address_name as name
    from solana.fact_swaps as swap inner join solana.dim_labels as label on label.address=swap.swap_from_mint
    where
    swap.swap_program='raydium v4'
    and swap.block_timestamp::date >= '2022-01-01'
    and swap.succeeded = 'True'
    group by name
    order by count(*) DESC)
    , part5 as (select count(*) as count ,block_timestamp::date as date,label.address_name as name
    from solana.fact_swaps as swap inner join solana.dim_labels as label on label.address=swap.swap_from_mint
    where
    swap_program='raydium v4'
    Run a query to Download Data