WITH USDC AS (
SELECT
date_trunc('day',BLOCK_TIMESTAMP)::DATE AS DAY,
sum(SWAP_FROM_AMOUNT) AS USDC_TO_UST
FROM solana.swaps
WHERE block_timestamp::DATE >='2021-12-01'
AND SWAP_FROM_MINT::string='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
AND SWAP_TO_MINT::string='9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i'
AND SUCCEEDED = TRUE
AND SWAP_PROGRAM::string='jupiter aggregator v2'
GROUP BY 1
ORDER BY 1 ASC),
USDT AS (
SELECT
date_trunc('day',BLOCK_TIMESTAMP)::DATE AS DAY,
sum(SWAP_FROM_AMOUNT) AS USDT_TO_UST
FROM solana.swaps
WHERE block_timestamp::DATE >='2021-12-01'
AND SWAP_FROM_MINT::string='Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
AND SWAP_TO_MINT::string='9vMJfxuKxXBoEa7rM12mYLMwTacLMLDJqHozw96WQL8i'
AND SUCCEEDED = TRUE
AND SWAP_PROGRAM::string='jupiter aggregator v2'
GROUP BY 1
ORDER BY 1 ASC)
SELECT
C.DAY,
C.USDC_TO_UST,
T.USDT_TO_UST
FROM USDC C INNER JOIN USDT T ON C.DAY=T.DAY
GROUP BY 1,2,3
ORDER BY 1 ASC