barbodswap volume to stablecoins
    Updated 2022-05-24
    SELECT
    date_trunc('day', block_timestamp) as day,
    CASE
    WHEN SWAP_FROM_MINT = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDT'
    WHEN SWAP_FROM_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC'
    WHEN SWAP_FROM_MINT = '9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i' THEN 'UST'
    WHEN SWAP_FROM_MINT = 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX' THEN 'USDH'
    WHEN SWAP_FROM_MINT = '7kbnvuGBxxj8AG9qp8Scn56muWGaRaFqxg1FsRp3PaFT' THEN 'UXD'
    WHEN SWAP_FROM_MINT = 'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS' THEN 'PAI'
    ELSE NULL
    END as stable,
    sum(swap_from_amount) as volume,
    sum(volume) over (partition by stable ORDER BY DAY) as cum_volume
    FROM flipside_prod_db.solana.fact_swaps
    WHERE block_timestamp >= '2022-04-01'
    AND succeeded = 'TRUE'
    AND swap_from_amount > 0
    AND stable is not NULL

    GROUP BY 1,2
    Run a query to Download Data