SELECT

buyer_address as user,

MIN(block_timestamp) AS date

FROM

aptos.nft.ez_nft_sales

GROUP BY

user

SELECT

date::date as day,

COUNT(*) AS new_user,

SUM(new_user) OVER (ORDER BY day ASC) AS cum_new_users

FROM

new_users

where day >= '2024-01-01'

group by 1