Updated 2022-07-03
    WITH jupiter AS (
    SELECT block_timestamp::date as date,
    count(tx_id) as tx_count
    FROM solana.core.fact_swaps
    WHERE SUCCEEDED = 'TRUE' and
    date >= '2022-01-01' AND
    swap_program = 'jupiter aggregator v2'
    GROUP BY date
    ORDER BY date ASC),
    saber AS (
    SELECT block_timestamp::date as date,
    count(tx_id) as tx_count
    FROM solana.core.fact_swaps
    WHERE SUCCEEDED = 'TRUE' and
    date >= '2022-01-01' AND
    swap_program = 'saber'
    GROUP BY date
    ORDER BY date ASC),
    raydium AS (
    SELECT block_timestamp::date as date,
    count(tx_id) as tx_count
    FROM solana.core.fact_swaps
    WHERE SUCCEEDED = 'TRUE' and
    date >= '2022-01-01' AND
    swap_program = 'raydium v4'
    GROUP BY date
    ORDER BY date ASC),
    orca AS (
    SELECT block_timestamp::date as date,
    count(tx_id) as tx_count
    FROM solana.core.fact_swaps
    WHERE SUCCEEDED = 'TRUE' and
    date >= '2022-01-01' AND
    swap_program = 'orca'
    GROUP BY date
    ORDER BY date ASC
    Run a query to Download Data