fantaorca rate
    Updated 2022-03-16
    with tbl1 as (select count(*) as jupiter ,swap_to_mint from solana.swaps
    where swap_from_mint='So11111111111111111111111111111111111111112'
    and block_timestamp::date >= '2022-01-01' and succeeded=1
    and swap_program='jupiter aggregator v2'
    group by swap_to_mint
    order by jupiter DESC
    limit 5)

    , tbl2 as (select count(*) as orca ,swap_to_mint from solana.swaps
    where swap_from_mint='So11111111111111111111111111111111111111112'
    and block_timestamp::date >= '2022-01-01' and succeeded=1
    and swap_program='orca'
    group by swap_to_mint
    order by orca DESC
    limit 5)

    ,tbl3 as (select sum(swap_to_amount) as jupiter,block_timestamp::date as jupiterdate from solana.swaps
    where swap_from_mint='So11111111111111111111111111111111111111112'
    and jupiterdate >= '2022-01-01' and succeeded=1
    and swap_program='jupiter aggregator v2'
    group by jupiterdate)

    ,tbl4 as (select sum(swap_to_amount) as orca,block_timestamp::date as orcadate from solana.swaps
    where swap_from_mint='So11111111111111111111111111111111111111112'
    and orcadate >= '2022-01-01' and succeeded=1
    and swap_program='orca'
    group by orcadate)

    , tbl5 as (select count(*) as jupiter,block_timestamp::date as jupiterdate from solana.swaps
    where swap_from_mint='So11111111111111111111111111111111111111112'
    and jupiterdate >= '2022-01-01'
    and swap_program='jupiter aggregator v2'
    group by jupiterdate)
    ,tbl6 as(select count(*) as jupiter ,block_timestamp::date as jupiterdate from solana.swaps
    where swap_from_mint='So11111111111111111111111111111111111111112'
    Run a query to Download Data