COUNT(DISTINCT FROM_ADDRESS) AS total_active_users

FROM

base.core.fact_transactions;

WHERE

BLOCK_timestamp >= DATEADD(DAY, -30, CURRENT_TIMESTAMP)