SELECT
platform,
DATE(et.block_timestamp) AS date,
SUM(et.amount_in_usd) AS daily_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, date
ORDER BY
date, daily_volume_usd DESC;