platform,

DATE(et.block_timestamp) AS engagement_day,

COUNT(*) AS transaction_count

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, engagement_day

ORDER BY

engagement_day;