trunc(block_timestamp,'week') as weekly,

PLATFORM_NAME,

count (distinct tx_hash) as Total_TX,

count(DISTINCT buyer_address) as Buyers,

sum(price) as volume_near,

sum(Total_TX) over (partition by PLATFORM_NAME ORDER BY weekly asc) as Cum_TX,

sum(buyers) over (partition by PLATFORM_NAME ORDER BY weekly asc) as Cum_Buyers,

sum(volume_near) over (partition by PLATFORM_NAME ORDER BY weekly asc) as Cum_Volume_near

from near.nft.ez_nft_sales

where block_timestamp::date>='2024-01-01'

group by 1,2

HAVING Total_TX > 1