SELECT

DATE_TRUNC('day', block_timestamp) AS date,

FROM_ADDRESS AS user_address

FROM

kaia.core.fact_transactions

),

first_activity AS (

SELECT

user_address,

MIN(date) AS first_activity_date

FROM

user_activity

GROUP BY

user_address

),

daily_new_users AS (

SELECT

first_activity_date AS date,

COUNT(DISTINCT user_address) AS daily_new_users

FROM

first_activity

GROUP BY

first_activity_date

),

daily_users AS (

SELECT

date,

COUNT(DISTINCT user_address) AS daily_users

FROM

user_activity

GROUP BY

date

),

stats AS (

SELECT