date_trunc('week',BLOCK_TIMESTAMP) as week,

count(distinct SELLER) as sellers,

count(distinct buyer) as purchasers,

sum(price) as volume_sale,

count(tx_id) as sale_count,

avg(price) as average_sale_price,

sale_count/purchasers as average_buyer,

volume_sale/sale_count as average_sale,

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

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

from flow.core.fact_nft_sales

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

and NFT_COLLECTION='A.0b2a3299cc857e29.TopShot'

group by 1

order by 1