SELECT
SUM(SWAP_FROM_AMOUNT) AS total_swap_from_volume,
SUM(SWAP_TO_AMOUNT) AS total_swap_to_volume,
SUM(SWAP_FROM_AMOUNT + SWAP_TO_AMOUNT) AS total_traded_volume
FROM
solana.defi.fact_swaps;
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP());