with tab1 as (

select date_trunc('minute',BLOCK_TIMESTAMP) as time

,BUYER

,PRICE

from flow.core.ez_nft_sales

where CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'

select date_trunc('day',time) as day

,BUYER

,PRICE

,row_number()over(partition by BUYER order by day) as time_row

from tab1)

select day

,count(distinct BUYER) as new_buyers

,sum(new_buyers)over(order by day) as total_new_buyers

from act1

where time_row=1

and day>='2023-04-01' and day<='2023-04-30'

group by 1