COUNT(DISTINCT tx_hash) AS transactions,

COALESCE(SUM(amount_in_usd), SUM(amount_out_usd), 0) AS total_volume

FROM near.defi.ez_dex_swaps

WHERE symbol_out IN ('USDT.e', 'USDT', 'USDC.e', 'DAI', 'CUSD', 'TUSD', 'USDT', 'USDC', 'FRAX', 'USN')

AND block_timestamp >= '2024-01-01'

AND block_timestamp < '2025-01-01'

GROUP BY symbol_out