block_timestamp::date as date,

team,

sum(price) as sales_volume,

count(*) as sales_count

from

flow.core.fact_nft_sales a left join flow.core.dim_topshot_metadata b on a.nft_id = b.nft_id

where

marketplace = 'A.c1e4f4f4c4257510.TopShotMarketV3' and team is not null and date between '2022-05-17' and '2022-05-29'

group by 1, 2