superflyGeneral table of sales
Updated 2022-07-13
9
1
2
3
4
5
6
7
8
›
⌄
select A.team , count (R.seller) as NUMBER_of_sales ,sum (R.Price ) as Value
from flow.core.dim_topshot_metadata A
JOIN flow.core.fact_nft_sales R on A.nft_id= R.nft_id
WHERE R.tx_succeeded = 'TRUE'
AND team LIKE ('%Heat%') or team like '%Warriors' or team like '%Mavericks' or team like '%Celtics'
AND R.block_timestamp between '2022-05-17' and '2022-05-30'
AND A.NFT_COLLECTION LIKE '%TopShot'
GROUP BY 1
Run a query to Download Data