flipside

yahyahoffman676

Try Quests to earn FLOW

Try Quests to earn FLOW

What makes a Top Shots moment valuable? (Part I)

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.

To answer this question, I used “dim_topshot_metadata” and “fact_nft_sales” database I pulled the information I needed, such as the time of the transaction, NFT ID, price, type of play, and the success or failure of the transaction, from the two mentioned databases and created a new data. Then with this information I answered the different parts asked in the question.

Number of Sales any Play_Type:

The number of times each type of NFT has been sold

Total NFT sale:

Total number of each type of NFT sold per day

Amount Price:

The total value of each type of NFT sold per day in USD

Conclusion:

According to the "Number of Sales any Play_Type" chart, we will notice that the desire to sell NFT of Rim type is more than any other type, and also 2Pointer has the lowest sales.