select

BLOCK_TIMESTAMP::date as date ,

team ,

count (DISTINCT tx_id) as txs ,

sum (PRICE) as volume

from flow.core.fact_nft_sales

join flow.core.dim_topshot_metadata

using ( NFT_ID )

where block_timestamp between '2022-05-17' and '2022-05-29'

and TX_SUCCEEDED = 'True'

and

(team ='Golden State Warriors' or

team ='Boston Celtics' or

team ='Dallas Mavericks' or

team ='Miami Heat' or

team ='Milwaukee Bucks' )

and

(NFT_COLLECTION = 'A.c4ff83bddcf08500.TopshotData'or

NFT_COLLECTION='A.c1e4f4f4c4257510.TopShotMarketV3'or

NFT_COLLECTION='A.0b2a3299cc857e29.TopShot')

group by 1 ,2