EXTRACT(YEAR FROM block_timestamp) AS year,

DATE_TRUNC('month', block_timestamp) AS date,

COUNT(DISTINCT tx_hash) AS transactions,

COUNT(DISTINCT trader) AS traders,

COALESCE(SUM(amount_in_usd), SUM(amount_out_usd), 0) AS total_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 >= '2023-01-01'

AND block_timestamp < '2025-01-01'

GROUP BY

year, DATE_TRUNC('month', block_timestamp)

ORDER BY

year, date;