princefarzamThe Number of transactions for Orca, Uniswap, and Other Solana DEXes
    Updated 2022-05-21
    WITH ORCA AS (
    SELECT
    DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY,
    COUNT (DISTINCT TX_ID) AS Number_of_transactions
    FROM flipside_prod_db.solana.fact_swaps
    WHERE SWAP_PROGRAM ='orca'
    AND SUCCEEDED = TRUE
    GROUP BY 1
    ORDER BY 1 ASC),
    JUPITER AS (
    SELECT
    DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY,
    COUNT (DISTINCT TX_ID) AS Number_of_transactions
    FROM flipside_prod_db.solana.fact_swaps
    WHERE SWAP_PROGRAM ='jupiter aggregator v2'
    AND SUCCEEDED = TRUE
    GROUP BY 1
    ORDER BY 1 ASC),
    RAYDIUM AS (
    SELECT
    DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY,
    COUNT (DISTINCT TX_ID) AS Number_of_transactions
    FROM flipside_prod_db.solana.fact_swaps
    WHERE SWAP_PROGRAM ='raydium v4'
    AND SUCCEEDED = TRUE
    GROUP BY 1
    ORDER BY 1 ASC),
    SABER AS (
    SELECT
    DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY,
    COUNT (DISTINCT TX_ID) AS Number_of_transactions
    FROM flipside_prod_db.solana.fact_swaps
    WHERE SWAP_PROGRAM ='saber'
    AND SUCCEEDED = TRUE
    GROUP BY 1
    ORDER BY 1 ASC),
    Run a query to Download Data