select EVENT_CONTRACT, CONTRACT_NAME

from flow.core.dim_contract_labels

where contract_name ='AllDay'

group by 1,2

select date_trunc(week,BLOCK_TIMESTAMP) weekly ,

team,

count (distinct buyer) num_buyers ,

sum (price ) volume ,

sum (volume) over (partition by team order by weekly) cum_volume

from flow.core.ez_nft_sales join flow.core.dim_allday_metadata using (nft_id)

where NFT_COLLECTION in (select EVENT_CONTRACT from NFLallDay )

and tx_succeeded = 'TRUE'

group by 1,2