with tab1 as (

select date_trunc('minute',BLOCK_TIMESTAMP)as time

,AMOUNT_OUT as buy_volume

,ORIGIN_FROM_ADDRESS as buyer

from ethereum.core.ez_dex_swaps

where TOKEN_OUT ='0x65ef703f5594d2573eb71aaf55bc0cb548492df4'

and BLOCK_TIMESTAMP>='2023-05-11' and BLOCK_TIMESTAMP<'2023-05-31')

select date_trunc('day',time) as day

,buyer

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

from tab1)

select day

,count(buyer) as new_buyers

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

from act1

where time_row=1

and day>='2023-05-11' and day<='2023-05-20'

group by 1