AndyCoolUST Impact - Average Swap to Stable Coins
    Updated 2022-06-02
    select avg(swap_to_amount) as swap_to_volume,
    date_trunc('day', block_timestamp) as DATE,
    CASE
    when swap_to_asset_id = '31566704' THEN 'USDC'
    when swap_to_asset_id = '312769' THEN 'USDT'
    when swap_to_asset_id = '465865291' THEN 'STBL'
    end as stable
    from flipside_prod_db.algorand.swaps
    where SWAP_to_ASSET_ID in ('31566704', '312769', '465865291')
    and block_timestamp >= '2022-04-15'
    group by DATE, stable
    Run a query to Download Data