study correlations between a player category and sales volume

In this chart, I show the 5 most effective players on sales volume each day.

The largest circle on a certain day means this player has the most sales volume on that day.

So now we can find:

• Scottie Barnes caused the increase in sales volume on Apr 26th because 104K $ of NFTs value sold on that day have this trait.

• Magic Johanson caused the increase in sales volume on Jun 7th, 8th, and 9th because more than 450K $ of NFTs value sold on these days have this trait.

Study correlations between a Team category and sales volume

In this chart, I show the 5 most effective teams on sales volume each day.

The largest circle on a certain day means this team has the most sales volume on that day.

So now we can find:

• Toronto Raptors caused the increase in sales volume on Apr 26th because 133K $ of NFTs value sold on that day have this trait.

• Los Angeles Lakers caused the increase in sales volume on Jun 7th, 8th, 9th, and 10th because more than 500K $ of NFTs value sold on these days have this trait.

Study correlations between a Season category and sales volume

In this chart, I show the 5 most effective seasons on sales volume each day.

The largest circle on a certain day means this team has the most sales volume on that day.

So now we can find:

• season 2021-22 caused the increase in sales volume of all time because most NFTs value sold on Flow have this trait.

Study correlations between a play_category and sales volume

In this chart, I show the 5 most effective play_category on sales volume each day.

The largest circle on a certain day means this team has the most sales volume on that day.

So now we can find:

• Dunk caused the increase in sales volume on Apr 22nd, 26th, and May 6th because 450K $ of NFTs value sold on these days have this trait.

• Assist caused the increase in sales volume on Jun 7th because more than 500K $ of NFTs value sold on these days have this trait.

Discussion about correlations between a play_type and sales volume

In this chart, I show the 5 most effective play_type on sales volume each day.

The largest circle on a certain day means this team has the most sales volume on that day.

So now we can find:

• Rim caused the increase in sales volume on Apr 22nd, 23rd, 26th, May 6th, and Jun 7th because 750K $ of NFTs value sold on these days have this trait.

• Assist caused the increase in sales volume on Jun 7th because more than 143K $ of NFTs value sold on that day have this trait.

Flow is a fast, decentralized, and developer-friendly blockchain, designed as the foundation for a new generation of games, apps, and the digital assets that power them. One of the most prominent advantages is the capacity to provide users to create or design NFT collections as well as buy or sell them.

GOAL:

Create an analysis of NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume.

METHODOLOGY:

At the first, I propose some information about NBA Top shot collection by using flow.core.fact_nft_sales table.

(For the rest of charts, I used flow.core.fact_nft_sales and flow.core.dim_topshot_metadata tables.)

Then I studied the effect of each of the following traits separately on the daily sales volume:

1. player
2. team
3. season
4. play_category
5. play_type

I showed the correlation between each of the above traits and sales volume by scatter chart.

Then I showed with the Donut chart how many NFTs of each trait were sold in total and what is its volume.

In the end, find who made the most profit and who made the most loss by buying and selling from this collection.

Taking a look at the NBA Top Shot activity, we can see how in both of the cases (daily sales count and sales volume) the trend looks similar.

It seems like, over the past few days, the activity dropped unbelievably. While daily sales volume has dropped from 117k $ to 5k $, daily sales passed from around 12K to 400.

Both metrics are under the average amount of the past 90 days so It is to say that both metrics are decreasing.

This chart shows maximum price, average price, and minimum price of NBA Top Shot NFTs that have been sold per day on Flow network.

The price is decreasing over time.

• The maximum price dropped from 4400 $ to 725 $ in past 90 days.
• The average price dropped from 25 $ to 13 $ in past 90 days.
• The minimum price is constant on 1$.

The left chart is the top purchased player based on volume and the right chart is based on the count.

According to my analysis:

• The most player purchased based on volume is Magic Johnson who isn't on top, based on the count.
• The most player purchased based on count is Draymond Green who is on top, based on the count.

The left chart is the top purchased team based on volume and the right chart is based on the count.

According to my analysis:

• The most team purchased based on volume is Golden State Warriors which is on top based on the count.

As you see on the above chart, Golden State Warriors has never had a huge volume in one day, but its continuous sales on different days have earned it this place.

The left chart is the top purchased season based on volume and the right chart is based on the count.

According to my analysis:

• The most season purchased based on volume is season 2021-22 which is on top based on the count.

The left chart is the top purchased play_category based on volume and the right chart is based on the count.

According to my analysis:

• The most play_category purchased based on volume is 3 Pointer which is in third place based on the count.
• The most play_category purchased based on count is Layup which is in third place based on the volume.

The left chart is the top purchased play_type based on volume and the right chart is based on the count.

According to my analysis:

• The most play_type purchased based on volume is Rim which is top based on the count too.

Here I show the highest profits that a user has made from buying and selling an NFT.

According to my analysis:

• A user by 0x035e118bc3853851 address made the most profit (6900 $) by buying and selling NFT no. 16239458.
• A user by 0xe7e6e89b0df79d9a address made 6749 $ as profit by buying and selling NFT no. 16239458.

Here I show the highest loss that a user has made from buying and selling an NFT.

According to my analysis:

• A user by 0x2b7f1eabeae32bc6 address made the most loss (6749 $) by buying and selling NFT no. 16239458.

All these three users trade on the same NFT.

Conclusion:

Based on my analysis, the most sales volume on NBA Top Shot is due to the following traits in NFTs:

• player: Magic Johnson
• team: Golden State Warriors
• season: 2021-22
• play_category: 3 Pointer
• play_type: Rim