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'

WHEN swap_from_asset_id = 2757561 THEN 'realioUSD'

END AS stablecoin,

COUNT (1) as n_swaps,

sum (swap_from_amount) as swap_amount

FROM algorand.swaps

WHERE date between '2022-03-01' AND '2022-03-30'

AND swap_from_amount > 0

AND stablecoin is not NULL

GROUP BY date, stablecoin