SUM(CASE WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) as "Trades"

, Platform

FROM kaia.defi.ez_dex_swaps

WHERE block_timestamp >= '2025-01-01'

AND (CASE WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) IS NOT NULL

GROUP BY 2

ORDER BY 1 DESC

LIMIT 10