WITH new AS (

SELECT

MIN(block_timestamp::date) AS day,

from_address

FROM

monad.testnet.fact_transactions

GROUP BY

2

),

new_users_24 AS (

SELECT

day,

COUNT(DISTINCT from_address) AS "New Users",

SUM("New Users") OVER (ORDER BY day ASC) AS "Cumulative New Users"

FROM

new

GROUP BY

1

SELECT

SUM("New Users") AS "New"

FROM

new_users_24

WHERE

day >= CURRENT_TIMESTAMP - INTERVAL '24 hours';