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