WITH USDC AS (
SELECT
date_trunc('day',BLOCK_TIMESTAMP) AS DAY,
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
GROUP BY 1
ORDER BY 1 ASC),
USDT AS (
SELECT
date_trunc('day',BLOCK_TIMESTAMP) AS DAY,
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
GROUP BY 1
ORDER BY 1 ASC),
STBL AS (
SELECT
date_trunc('day',BLOCK_TIMESTAMP) AS DAY,
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
GROUP BY 1
ORDER BY 1 ASC)
SELECT
A.DAY,
A.USDC_SWAP_TO_AMOUNT AS USDC_volume,
B.USDT_SWAP_TO_AMOUNT AS USDT_volume,
C.STBL_SWAP_TO_AMOUNT AS STBL_volume
FROM USDC A INNER JOIN USDT B on A.DAY=B.DAY
INNER JOIN STBL C on A.DAY=C.DAY