(select PLATFORM_NAME, BUYER_ADDRESS, min(BLOCK_TIMESTAMP) as min_date

from ethereum.core.ez_nft_sales

where BLOCK_TIMESTAMP::date>='{{Starting_Date}}'

group by 1,2)

select date_trunc({{Time_Interval}},min_date) as date, PLATFORM_NAME, count(BUYER_ADDRESS) as BUYERs,

sum(BUYERs) over (partition by PLATFORM_NAME order by date) as total_BUYERs

from BUYERS

group by 1,2

order by PLATFORM_NAME