SELECT
TEAM,
sum(PRICE) as volume
FROM flow.core.fact_nft_sales JOIN flow.core.dim_topshot_metadata
ON flow.core.fact_nft_sales.NFT_ID = flow.core.dim_topshot_metadata.NFT_ID
WHERE BLOCK_TIMESTAMP >= '2022-05-17'
AND BLOCK_TIMESTAMP < '2022-05-30'
and flow.core.fact_nft_sales.NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'
AND TX_SUCCEEDED = 'TRUE'
GROUP by 1
ORDER by 2 DESC