NBA Top Shot

> NBA Top Shot is a first-of-its-kind collectible game that allows people to collect, trade, and sell their favorite NBA highlights as digital tokens. These highlights can be collected to complete timed challenges, arranged into showcases, and eventually carried over into the forthcoming game experience!

NBA Top Shop Play Type

• Rim, Assist, 3 Pointer, Block, Mid-Range, Steal, Handles, Dunk/Layup and 2 Pointer

Description of Work

In this bounty we want to examine NFT Top Shot based on Play Types. things we want to examine include:

• What Play Types do users hold most
• How much volume in sales do these Play Types generate?

Note: We use the ==flow.core== schema, ==fact_nft_sales==, ==dim_topshot_metadata== and ==fact_prices== tables

1 → Method

• How to find NFT Top Shot holders:
  • To obtain NFT Holders, we must first obtain the Last Transaction for each NFT (==nft_id==) in the fact_nft_sales table:
    • with last_sales_tbl (select nft_id, max(block_timestamp) as last_sales_time where nft_collection = 'A.0b2a3299cc857e29.TopShot' and tx_succeeded = 'true') → Pseudocode
  • Now we need to know which Wallet this transaction was made by so that we can get the current Holder of each NFT, so we have:
    • select buyer, nft_id from flow.core.fact_nft_sales join last_sales_tbl on nft_id = nft_id and last_sales_time = sales_time → Pseudocode
  • After we get all the Holders (from step b), we join it with the dim_topshot_metadata table based on nft_id, and then we group them based on play_type and count the number of wallets (Holders) in each group (play_type ):
    • select play_type, count(distinct wallet) as number_of_holders from flow.core.dim_topshot_metadata metadata group by play_type → Pseudocode

• How to find NFT Top Shot sales volume by play_type
  • To get the sales volume of NBA Top Shots NFTs, we must first convert the sales volume to USD from fact_nft_sales table. In general, we have two types of currency for sale for NBA Top Shots NFTs, one is DapperUtilityCoin and the other is FlowToken. We consider each DapperUtilityCoin as one USD ==(1 DapperUtilityCoin = 1 USD) and we use fact_prices table to convert FlowToken to USD
  • After converting the volume of sales to USD, we join the result of the obtained table with the dim_topshot_metadata table based on nft_id and group based on play_type and obtain the sales volume for each group.

2 → Some exceptions

• In the flow.core database, we have the start date of selling NFTs from ==2022-04-20== onwards, so our calculations are based on this date onwards.

• The total number of NFTs sold for NFT Top Shot (distinct nft_id) is 1,389,430 in the fact_nft_sales table, while the total number of NFTs (distinct nft_id) in the dim_topshot_metadata table is 1,059,954, which means we only have information about 76.28% of all NFT Top Shots in the dim_topshot_metadata table
• So we get the calculations for the number of holders and sales volume of Top Shot based on dim_topshot_metadata table, while if we get these values based on the fact_nft_sales table for NFT Top Shot, it is more, but our goal is to focus on play_type

1 → What Play Types do users hold most

Conclusion of Part 1

• Given that the total Number of Holders for NBA Top Shots based on the dim_topshot_metadata table is 21.76k, then we have:
  • 15766 wallets hold Rim paly_type NFTs, that is 72.44% of the total number of NBA Top Shots holders
  • 12273 wallets hold Assist paly_type NFTs, that is 56.39% of the total number of NBA Top Shots holders
  • 10517 wallets hold 3 Pointer paly_type NFTs, that is 48.32% of the total number of NBA Top Shots holders
  • 9310 wallets hold Block paly_type NFTs, that is 42.78% of the total number of NBA Top Shots holders
  • 8949 wallets hold Mid-Range paly_type NFTs, that is 41.12% of the total number of NBA Top Shots holders
  • 8531 wallets hold Steal paly_type NFTs, that is 39.2% of the total number of NBA Top Shots holders
  • 4611 wallets hold Handles paly_type NFTs, that is 21.18% of the total number of NBA Top Shots holders
  • 138 wallets hold Dunk/Layup paly_type NFTs, that is 0.63% of the total number of NBA Top Shots holders
  • 8 wallets hold 2 Pointer paly_type NFTs, that is 0.03% of the total number of NBA Top Shots holders
• The wallets 0x1b885e305cc0e984==, 0xed8707e2ae5bba5a and **0xee4fe6c87ab048d0 **respectively hold the largest number of NBA Top Shots NFTs, which can be seen to be the largest amount of play_type Rim, followed by 3 Pointer and Assist.

2 → How much volume in sales do these Play Types generate?

Conclusion of Part 2

• Given that the total Sales Volume in USD for NBA Top Shots based on the dim_topshot_metadata table is 8.25M USD, then we have:
  • Total Sales Volume for Rim== paly_type NFTs is 3013010.47 USD, that is 36.5% of the total sales volume of NBA Top Shots
  • Total Sales Volume for 3 Pointer paly_type NFTs is 1706868 USD, that is 20.68% of the total sales volume of NBA Top Shots
  • Total Sales Volume for Assist paly_type NFTs is 1149309.69 USD, that is 13.92% of the total sales volume of NBA Top Shots
  • Total Sales Volume for Block paly_type NFTs is 1032138 USD, that is 12.5% of the total sales volume of NBA Top Shots
  • Total Sales Volume for Mid-Range paly_type NFTs is 690291.5 USD, that is 8.36% of the total sales volume of NBA Top Shots
  • Total Sales Volume for Steal paly_type NFTs is 338710 USD, that is 4.1% of the total sales volume of NBA Top Shots
  • Total Sales Volume for Handles paly_type NFTs is 309528 USD, that is 3.75% of the total sales volume of NBA Top Shots
  • Total Sales Volume for Dunk/Layup paly_type NFTs is 13019 USD, that is 0.15% of the total sales volume of NBA Top Shots
  • Total Sales Volume for 2 Pointer paly_type NFTs is 453 USD, that is 0.005% of the total sales volume of NBA Top Shots
• The wallets 0x8ecaf48ce609159a, 0xed8707e2ae5bba5a and 0xc8c58c9919c93088 respectively has the largest buy volume (USD) of NBA Top Shots NFTs which can be seen to be the largest volume o Rim, followed by 3 Pointer and Assist== play_types
• It can be seen that among the Top 10 NFT IDs in NBA Top Shot in terms of sales volume, 9 are related to play_type Rim and 1 is related to 3 Pointer
• It can be seen that the highest volume of sales is related to May 6, June 7 and April 26 which are respectively the highest daily sales volume for Rim, Assist and 3 Pointer play_types.

Final Conclusion

According to the analysis and review of Holders and the sales volume of NBA Top Shot based on play_type, it has been determined that users tend to hold NFTs related to play_type such as Rim, Assist and 3 Pointer, also the largest purchase volume related to NFTs of the type Rim, 3 Pointer and Assist, so we come to the conclusion that:

• Based on Holders:

    1️⃣ Rim with 15766 holders (72.44%)
  
    2️⃣ Assist with 12273 holders (56.39%)
  
    3️⃣ 3 Pointer with 10517 holders (48.32%)
  

• Based on Volume:

    1️⃣ Rim with 3013010.47 USD (36.5%)
  
    2️⃣ 3 Pointer 1706868 USD (20.68%)
  
    3️⃣ Assist 1149309.69 USD (13.92%)
  

  \