-- Get the earliest transaction for each user (FROM_ADDRESS)

SELECT

FROM_ADDRESS,

MIN(BLOCK_TIMESTAMP) AS first_transaction_timestamp

FROM sei.core_evm.fact_transactions;

GROUP BY FROM_ADDRESS

),

new_users AS (

-- Filter for users whose first transaction occurred in the last 60 days

SELECT

FROM_ADDRESS

FROM first_transactions

WHERE first_transaction_timestamp >= DATEADD(DAY, -60, CURRENT_DATE)

SELECT

COUNT(DISTINCT FROM_ADDRESS) AS new_users_count

FROM new_users;