select EVENT_CONTRACT

from flow.core.dim_contract_labels

where contract_name ilike '%TopShot%'

group by 1

select

BLOCK_TIMESTAMP::date as date ,

count (DISTINCT BUYER) as num_Buyers ,

count (DISTINCT seller) as num_sellers ,

count (DISTINCT tx_id) as num_sales ,

sum (num_sales) over (order by date ) as cum_sales ,

sum (PRICE) as sales_volume ,

sum (sales_volume) over (order by date ) as cum_sales_volume

from flow.core.fact_nft_sales

where block_timestamp::date between '2022-05-10' and '2022-06-06'

and NFT_COLLECTION in (select EVENT_CONTRACT from NBA_nfts )

and TX_SUCCEEDED = true

group by 1