date_trunc('week',BLOCK_TIMESTAMP) as week,

PLAY_CATEGORY,

count(distinct SELLER) as sellers,

count(distinct buyer) as buyers,

sum(price) as volume_sale,

count(tx_id) as sale_count,

avg(price) as average_sale_price,

sum(sale_count) over (partition by PLAY_CATEGORY order by week) as cum_sale,

sum(volume_sale) over (partition by PLAY_CATEGORY order by week) as cum_volume

from flow.core.fact_nft_sales x left outer join flow.core.dim_topshot_metadata y on x.NFT_ID=y.NFT_ID

where TX_SUCCEEDED='TRUE' and CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'

and x.NFT_COLLECTION='A.0b2a3299cc857e29.TopShot'

group by 1,2 having PLAY_CATEGORY is not null

order by 1