SELECT

block_timestamp,

trader AS user

FROM

blast.blitz.ez_clearing_house_events

),

new_users AS (

SELECT

user,

MIN(block_timestamp) AS date

FROM

users

GROUP BY

user

SELECT

date::date AS date,

COUNT(*) AS new_user,

SUM(new_user) OVER (ORDER BY date::date ASC) AS cum_new_users

FROM

new_users

GROUP BY

date::date

ORDER BY

date ASC;