PLATFORM, SYMBOL_IN, SYMBOL_OUT, amount_in_usd, amount_out_usd

FROM

optimism.core.ez_dex_swaps

WHERE

(PLATFORM, amount_in_usd) IN (

SELECT

PLATFORM, MAX(amount_in_usd)

FROM

optimism.core.ez_dex_swaps

GROUP BY

PLATFORM

)

ORDER BY

PLATFORM, amount_in_usd DESC

LIMIT

10;