-- Find the first day each user interacted with fantasy contracts

SELECT

origin_from_address as user_address,

MIN(date_trunc('day', block_timestamp)) as first_date

FROM monad.testnet.fact_event_logs

WHERE contract_address IN (

LOWER('0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e'),

LOWER('0x9077D31A794D81c21b0650974d5F581F4000CD1a'),

LOWER('0xfA4D5a9ceA2822BA08d0266F121011aC527ced64')

)

GROUP BY user_address

),

daily_new_users AS (

-- Count new users for each day

SELECT

first_date as "Date",

COUNT(*) as "New Users"

FROM user_first_activity

GROUP BY first_date

SELECT

"Date",

"New Users",

SUM("New Users") OVER (ORDER BY "Date" ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as "Cumulative Users"

FROM daily_new_users

ORDER BY "Date" DESC;