strawbetty total volume per day on Orca and Jupiter
    Updated 2022-03-23
    with jupiter_sol_swaps as (
    Select
    block_timestamp::date as date,
    sum(swap_from_amount) as jupiter_total_sol_swapped
    From Solana.swaps s
    Where
    block_timestamp::date >= '2022-01-01'
    AND swap_from_mint = 'So11111111111111111111111111111111111111112' -- SOL as source
    And succeeded = 'True'
    AND swap_program = 'jupiter aggregator v2'
    AND swap_to_amount > 0
    Group by 1
    order by 1
    ), orca_sol_swaps as (
    Select
    block_timestamp::date as date,
    sum(swap_from_amount) as orca_total_sol_swapped
    From Solana.swaps s
    Where
    block_timestamp::date >= '2022-01-01'
    AND swap_from_mint = 'So11111111111111111111111111111111111111112' -- SOL as source
    And succeeded = 'True'
    AND swap_program = 'orca'
    AND swap_to_amount > 0
    Group by 1
    order by 1
    )

    SELECT j.date, jupiter_total_sol_swapped, orca_total_sol_swapped
    FROM jupiter_sol_swaps j LEFT JOIN orca_sol_swaps o ON j.date = o.date
    Run a query to Download Data