COUNT(*) AS total_trades

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);