SELECT

FROM_ADDRESS,

MIN(BLOCK_TIMESTAMP) AS first_transaction_date

FROM base.core.fact_transactions

GROUP BY FROM_ADDRESS

),

DailyTransactions AS (

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,

FROM_ADDRESS

FROM base.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= DATEADD(day, -60, CURRENT_TIMESTAMP)

),

UserStatus AS (

SELECT

dt.transaction_date,

dt.FROM_ADDRESS,

CASE

WHEN ft.first_transaction_date = dt.transaction_date THEN 'new'

ELSE 'old'

END AS user_status

FROM DailyTransactions dt

JOIN FirstTransactions ft

ON dt.FROM_ADDRESS = ft.FROM_ADDRESS

),

DailyUserCounts AS (

SELECT

transaction_date,

user_status,

COUNT(DISTINCT FROM_ADDRESS) AS user_count

FROM UserStatus

GROUP BY transaction_date, user_status

),

User_Debuts AS (

SELECT