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.

Introduction

• NBA Top Shots is a NFT Collection of NBA highlights, they have:
  • The Moment: A videoclip of the highlight with their description and date.
  • A Player: The Playmaker of the moment, with their stats in the game and the season.
  • A Play: The type of play present in the video.
• This is some of the information these NFTs have, they have a lot more, which makes this NFT collection the most successful project in the flowverse.

Methodology

• Using Flipside’s Flow tables:
  • flow.core.fact_nft_sales: To get info about sales volume.
  • flow.core.dim_topshot_metadata: To get info about the NFT.
• Limitations: There are TopShot NFTs ids missing in both tables, for example:
  • ID 1673194 is present in sales table with but not in metadata table
  • ID 36746512 #1 Top Sale in NBA Topshot marketplace doesn’t have records in both sales or metadata tables.
• So i’ll be working only with NFTs present in both tables, with an extra limitation, the currency used the DUC, because most of the NFTs present in both tables have this currency, and this is the equivalent to 1 USD according to #Flow in Flipside’s Discord.

TopShot NFTs sales by Play Type

TopShot NFTs sales by Play Category.

\

Most of the sales activity and volume by play type are Rim which means plays around the basket, 3 pointer with the second place, and all the following types are in the same place in both sales volume and total sales.

But there is a big problem if you look at the type of Dunk/Layup there is only 174 sales and 13.019k DUC volume which contradicts the following charts in play category.

In play category which isn’t the same as play type, Dunk and Layup presents a higher total sales and sales volume in comparison with play type dunk/layup.

Jump shot (category) correlates with mid-range (type) but with a slightly difference of 9 sales and 453 DUC (which are the 2 pointer type), 3 pointer, assist, block, handles and steal correlates perfectly in comparison with play type.

That means the Dunk and Layup are a play category, and both (category) conforms the Rim Type + Dunk/Layup Type.

Summary

Play Type Rim is the most popular in sales, making the most holded by users, also it has the highest sales volume of all the play types, followed by Play Type 3 Pointer at second place.

Extra Metrics:

The play type Rims are related to Dunk or Layup in play category, but maybe by an accident they put dunk/layup as a play type which complicates the analysis.

By the sales volume and activity users prefers plays related to score in basketball more than players stealing or handling/dribbling the ball.