SELECT

buyer_address,

MIN(block_timestamp::date) AS date

FROM

aptos.nft.ez_nft_sales

GROUP BY

buyer_address

),

new_sellers AS (

SELECT

seller_address,

MIN(block_timestamp::date) AS date

FROM

aptos.nft.ez_nft_sales

GROUP BY

seller_address

),

date_series AS (

SELECT

'2024-01-01'::date AS day

UNION ALL

SELECT

day + INTERVAL '1 day'

FROM

date_series

WHERE

day + INTERVAL '1 day' <= current_date

),

buyer_counts AS (

SELECT

date::date AS day,

COUNT(*) AS new_user

FROM

new_buyers

WHERE