alessio9567USDC flow swap volume
    Updated 2022-10-03
    WITH usdc_outflow AS (
    SELECT date_trunc('day', block_timestamp) AS dayt
    ,sum(swap_from_amount) AS volume_out
    FROM solana.core.fact_swaps
    WHERE swap_from_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- swap from USDC
    AND succeeded = 'TRUE'
    AND block_timestamp >= current_date - 30
    GROUP BY 1
    ),usdc_inflow AS (
    SELECT date_trunc('day', block_timestamp) AS dayt
    ,sum(swap_to_amount) AS volume_in
    FROM solana.core.fact_swaps
    WHERE swap_to_mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- swap to USDC
    AND succeeded = 'TRUE'
    AND block_timestamp >= current_date - 30
    GROUP BY 1
    )
    SELECT a.dayt
    ,-a.volume_out AS outflow
    ,b.volume_in AS inflow
    ,b.volume_in - a.volume_out AS flow
    FROM usdc_outflow a
    LEFT JOIN usdc_inflow b
    ON a.dayt = b.dayt

    Run a query to Download Data