PLATFORM,

sum( DISTINCT amount_in_usd) as volume_usd,

count(*) as activities,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users

from polygon.defi.ez_dex_swaps

WHERE symbol_in in ('USDC', 'USDA', 'UST', 'USDT', 'BUSD', 'USDD', 'TUSD', 'DAI')

or symbol_out in ('USDC', 'USDA', 'UST', 'USDT', 'BUSD', 'USDD', 'TUSD', 'DAI')

and block_timestamp >= '2024-01-01'

GROUP BY 1

ORDER by 2 DESC