select date_trunc ('day',block_timestamp) as date,
count(swap_from_amount) as N_swaps,
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 algorand.swaps
where swap_from_asset_id in ('31566704','312769','465865291')
and block_timestamp >= '2022-03-01' and block_timestamp < '2022-04-01'
group by date,swap_from_asset_id
order by date desc