DATE_TRUNC('week', BLOCK_TIMESTAMP) AS WEEK,

SUM(AMOUNT_IN_USD) AS WEEKLY_VOLUME_USD

FROM

aptos.defi.ez_dex_swaps

WHERE

SYMBOL_IN IN ('GUI', 'SHRIMP', 'doodoo', 'UPTOS', 'DONK')

AND BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE)

GROUP BY

WEEK

ORDER BY

WEEK;