SELECT
    DATE_TRUNC('day', w.time) AS date,
    SUM(CASE WHEN w.symbol = 'USDC' THEN w.amount ELSE 0 END) AS usdc_withdrawals,
    SUM(CASE WHEN w.symbol = 'DAI' THEN w.amount ELSE 0 END) AS dai_withdrawals,
    SUM(CASE WHEN d.symbol = 'USDC' THEN d.amount ELSE 0 END) AS usdc_deposits,
    SUM(CASE WHEN d.symbol = 'DAI' THEN d.amount ELSE 0 END) AS dai_deposits
FROM
    "@portals.transactions.withdraws" w
FULL OUTER JOIN
    "@portals.transactions.deposits" d ON DATE_TRUNC('day', w.time) = DATE_TRUNC('day', d.time) AND w.symbol = d.symbol
WHERE
    w.symbol IN ('USDC', 'DAI') OR d.symbol IN ('USDC', 'DAI')
GROUP BY
    DATE_TRUNC('day', w.time)
ORDER BY
    DATE_TRUNC('day', w.time);