case swap_from_asset_id

when 31566704 then 'usdc'

when 312769 then 'usdt'

when 465865291 then 'stbl'

else null end as asset,

count(distinct swapper) as user,

count(distinct tx_group_id) as swaps,

sum(swap_from_amount) as volume

from algorand.swaps

where

swap_from_asset_id in (

31566704, --usdc

312769, --usdt

465865291 --stbl

)

and date(block_timestamp) >= '2022-04-01'

group by 1

limit 100