SELECT

FROM_ADDRESS,

MIN(BLOCK_TIMESTAMP) AS first_transaction_date

FROM base.core.fact_transactions;

GROUP BY FROM_ADDRESS

SELECT COUNT(*) AS new_users

FROM FirstTransactions

WHERE first_transaction_date >= DATEADD(day, -30, CURRENT_TIMESTAMP);