platform,

SUM(et.amount_in_usd) AS total_volume_usd

FROM

aptos.defi.ez_dex_swaps AS et

JOIN

aptos.core.dim_tokens AS dt ON et.token_in = dt.token_address

WHERE

dt.symbol = 'doodoo'

AND et.block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)

GROUP BY

platform

ORDER BY

total_volume_usd DESC

LIMIT 5;