TRUNC(BLOCK_TIMESTAMP, 'day') AS day,

COUNT(DISTINCT FROM_ADDRESS) AS active_users

FROM

blast.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE) -- Filter for the last 30 days

GROUP BY

TRUNC(BLOCK_TIMESTAMP, 'day')

ORDER BY

day DESC;