WITH USDC AS (
SELECT
sum(SWAP_TO_AMOUNT) AS USDC_SWAP_TO_AMOUNT
FROM algorand.swaps
WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
AND SWAP_TO_ASSET_ID=31566704
),
USDT AS (
SELECT
sum(SWAP_TO_AMOUNT) AS USDT_SWAP_TO_AMOUNT
FROM algorand.swaps
WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
AND SWAP_TO_ASSET_ID=312769
),
STBL AS (
SELECT
sum(SWAP_TO_AMOUNT) AS STBL_SWAP_TO_AMOUNT
FROM algorand.swaps
WHERE BLOCK_TIMESTAMP::DATE >='2022-03-01'
AND SWAP_TO_ASSET_ID=465865291
)
SELECT 'The total volume of swap USDC' as type, USDC_SWAP_TO_AMOUNT FROM USDC
UNION ALL
SELECT 'The total volume of swap STBL' as type, STBL_SWAP_TO_AMOUNT FROM STBL
UNION ALL
SELECT 'The total volume of swap USDT' as type, USDT_SWAP_TO_AMOUNT FROM USDT