COUNT(DISTINCT tx_hash) AS transactions,

COUNT(DISTINCT trader) AS traders,

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

COALESCE(AVG(amount_in_usd), AVG(amount_out_usd), 0) AS AVG_volume

FROM near.defi.ez_dex_swaps

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

OR 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';