SELECT

from_address,

MIN(DATE_TRUNC('hour', block_timestamp)) AS first_transaction_date

FROM

monad.testnet.fact_transactions

WHERE

block_timestamp >= '2025-02-19'

GROUP BY

from_address

),

daily_new_users AS (

SELECT

first_transaction_date AS date,

COUNT(DISTINCT from_address) AS new_users

FROM

user_first_transaction

GROUP BY

first_transaction_date

date,

new_users,

SUM(new_users) OVER (ORDER BY date) AS total_users

daily_new_users

ORDER BY

date DESC;