Question

Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table.

• What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.

Data Analysis

Methodology

• In this dashboard, for data extraction, the flow.core.fact_nft_sales table is joined with the flow.core.dim_topshot_metadata table, so that by using first table, the information of the seller, buyer and the sales volume be obtained. on the other hand, by using flow. core.dim_topshot_metadata also has been extracted information about teams and players for different NFTs based on play_type.
• There is no data before April 20 in the Flow database.

The chart below shows the number of daily distinct buyers on the TopShot market.

• The highest number of sellers of NFTs is related to the month of May.
• The number of sellers decreased from the second week of June.
• The number of sellers has reached its lowest number in the third week of July.
• The maximum number of sellers of NFTs is related to the 6th of May.
  • on May 6:
    • Rim → 7,322 NFTs → Max
    • Mid Range → 2,876 NFTs
    • Assist → 2,803 NFTs
    • 3Pointer → 2,746 NFTs
    • Steal → 1,866 NFTs
    • Block → 1,594 NFTs
    • Handles→ 145 NFTs
    • Dunk/Layup→ 5 NFTs
    • 2 Pointer → 4 NFTs → Min
• The highest number of sold NFTs of each category are:
  • Rim → May 6 → 7,322 NFTs
  • 3 Pointer → May 6 → 2,746 NFTs
  • Assist → May 4 → 5,283 NFTs
  • Block → May 22 → 1,988 NFTs
  • Mid Range → May 6 → 2,876 NFTs
  • Steal → May 4 → 2,190 NFTs
  • Handles → May 27 → 750 NFTs
  • Dunk/Layup → Apr 21 → 33 NFTs
  • 2 Pointer → Apr 21& May 6 → 4 NFTs

💡 The highest sales of NFTs in any category except Dunk/Layup were recorded in May.

The chart below shows the number of daily distinct sellers on the TopShot marketplace.

• Similar to the highest number of sellers, the highest number of purchasers was recorded on May 6 too.
  • on May 6:

    • Rim → 4,016 NFTs → Max

      - In total, on this day, the number of sellers of this category of NFTs was more than the number of purchaser. (7,322 vs. 4,016)

    • Assist → 2,317 NFTs

      - On May 6, after Rim NFTs, Mid range NFTs had the largest number of sellers. But on this day after Rim NFTs, Assist NFTs have been the most purchased and Mid Range NFTs is in third place.

    • Mid Range → 2,153 NFTs

    • 3Pointer → 2,090 NFTs

    • Steal → 1,724 NFTs

    • Block → 1,358 NFTs

    • Handles→ 142 NFTs

    • Dunk/Layup→ 4 NFTs

    • 2 Pointer → 4 NFTs → Min

💡 In general, the least buying and selling is related to 2 pointer NFTs.

• The highest number of purchased NFTs of each category are:

  • Rim → May 6 → 4,016 NFTs

  • 3 Pointer → May 6 → 2,090 NFTs

  • Assist → May 4 → 4,995 NFTs

  • Block → May 22 → 1,662 NFTs

  • Mid Range → May 6 → 2,153 NFTs

  • Steal → May 4 → 2,353 NFTs

  • Handles → May 27 → 742 NFTs

  • Dunk/Layup → May 16 → 60 NFTs

  • 2 Pointer → Apr 21& May 6& May 16 → 4 NFTs

💡 The highest number of distinct buyers and sellers of NFTs based on 'Play type' is related to Rim, 3 Pointer and Assist NFTs.

• Similar to the number of NFTs sold, the highest sales volume of NFTs was recorded on May 6. On this day, Rim NFTs and 3 pointer NFTs had the highest volume of sales.
• Since the third week of July, the sales volume of NFTs decreased sharply.
• Among the various NFTs, Rim, 3 pointer and Assist NFTs have had the most sales. These three types of NFTs accounted for almost 71% of the total sales volume of NFTs.
• The lowest sales volume is related to 2-pointer NFTs.

• The most popular NFTs among users for holding are:
  • Rim, Assist and 3pointer.

• Among different players, NFTs related to ==Magic Johnson== had the highest sales volume.

• Among the different teams, NFTs of ==Golden State Warriors== have had the highest volume of sales.
• Which teams have the most sold NFTs?
  • Rim& 3pointer& 2pointer → Golden state warriors
  • Assist& Steal → Los Angeles Lakers
  • Block → Philadelphia 76ers
  • Handles& Dunk/Layup → Dallas Mavericks
  • Mid-Range → LA Clippers

Conclusion

In this dashboard, the number of buyers and sellers of NFTs was examined based on play_type, and it was observed that Rim and 3pointer NFTs have the largest number of buyers and sellers. These NFTs also have the largest volume of sales. In addition to these two types, Assist NFTs are also among the most popular NFTs among users to hold. Similarly, NFTs of Magic Johnson, Steph Curry and Scottie Barnes have had the highest volume of sales. NFTs of the Golden State Warriors team are also the most popular in terms of sales volume.

Dunk

3 Pointer

Block

Assist

Handles

Layup