SELECT

date_trunc('day', b.block_timestamp) AS date,

b.NFT_ID as nft_id,

b.BUYER as BUYER,

b.SELLER as SELLER

FROM flow.core.dim_allday_metadata a

LEFT JOIN flow.core.ez_nft_sales b

ON a.NFT_ID = b.NFT_ID

),

user_min_date AS (

SELECT min(date) AS mindate,

SELLER AS SELLER

FROM nft_allday

GROUP BY 2

select

date,

sum(SELLER) over (order by date rows between unbounded preceding and current row) as cumulative_sum

from (

select

mindate as date,

count(SELLER) as SELLER

from user_min_date

group by 1