2844MOST POPULAR STABLECOIN
    Updated 2022-07-07
    select date_trunc ('day',block_timestamp) as date,
    sum(swap_from_amount) as volume,
    swap_from_asset_id,
    case when swap_from_asset_id= '31566704' then 'USDC'
    when swap_from_asset_id= '312769' then 'USDT'
    when swap_from_asset_id= '465865291' then 'STBL'
    end as stablecoin
    from flipside_prod_db.algorand.swaps
    where swap_from_asset_id in ('31566704','312769','465865291')
    and block_timestamp >= '2022-05-01' and block_timestamp < '2022-07-01'
    group by date,swap_from_asset_id
    order by date desc
    Run a query to Download Data