COUNT(DISTINCT(account_address)) AS unique_holders

FROM

aptos.core.fact_transfers AS et

JOIN

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

WHERE

dt.symbol = 'doodoo'

AND et.success = TRUE

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