SELECT

buyer_address as user,

MIN(block_timestamp) AS date

FROM

aptos.nft.ez_nft_sales

GROUP BY

user

SELECT

COUNT(*) AS new_user

FROM

new_users

where date::date = current_date - interval '1 day'