Try Quests to earn FLOWNFL ALL DAY Tournament Round 2
Description of work
In this dashboard, we want to analyze the valuable NFL ALL DAY NFTs from different perspectives.
This dashboard includes the following sections.
1 - Analyzing the valuable NFTs
2 - Analyzing the status of play types in valuable NFTs
-
1 - 2 Comparison of the number of different play types in the total number of NFTs sold with the number of different play types in valuable NFTs.
-
2 - 2 Comparison of the volume of different play types in the total volume of NFTs sold with the volume of different play types in the total sales volume of valuable NFTs
-
3 - 2 Section 2 Conclusion
\
3 - Analysis of the value of players in valuable NFTs
4 - Is there any meaningful purchasing behavior for certain players who outperformed in Week 1?
5 - Conclusion
- In this work, we considered the Top 100 NFTs traded at the highest prices as the Valuable NFTs.
- You can read my previous dashboard for more information about NFL ALL DAY.
1 - Analyzing valuable NFTs
Methodology
- To find the specifications of NFTs related to NFL All Day, we use the data of the
[flow.core.dim_allday_metadata]. - To find the most valuable NFTs, we use the data of the
[flow.core.ez_nft_sales]. - To buy or sell NFTs, A.ead892083b3e2c6c.DapperUtilityCoin currency is used, each unit of which is equivalent to 1 USD.
- Data related to the NFT sales is available from 2022-04-20 onwards.
Notes:
NFL All Day packs are bundled Moments bought in the NFL All Day marketplace. Each Moment belongs to a specific tier, which indicates the number of highlights available and the rarity of the Moment.
Here are the four different tiers of NFL All Day Moments:
- Common (About 92% of all Moments): The basic primer of any NFL All Day Moments collection with mint counts between 4,000 and 10,000.
- Rare (About 8% of all Moments): Mid-tier moments with mint counts of 499 to 1,200.
- Legendary (About 0.17% of all Moments): Very rare and highly desired Moments. Only about 200 Legendary Moments exist with mint counts of fewer than 99.
- Ultimate (About 0.01% of all Moments): This tier comprises the rarest Moments with a mint count of one to 10.
Source: coindesk.com
✔️Observations
- The number of different Tiers in valuable NFTs are:
-
94 NFTs are in the legendary tier.
-
4 NFTs are in the rare tier.
-
2 NFTs are in the rare tier.
\
-
- Teams with the highest number of valuable NFTs are:
- 13 NFTs belong to Kansas City Chiefs players
- 11 NFTs belong to San Francisco 49ers players
- 11 NFTs belong to Green Bay Packers players
- 9 NFTs belong to Cincinnati Bengals players
- 9 NFTs belong to Los Angeles Chargers players
- 9 NFTs belong to Buffalo Bills players
✔️Observations
- The number of different play types in valuable NFTs is:
-
48 NFTs have Player Melt play type
-
39 NFTs have Pas play type
-
8 NFTs are in the Reception play type
\
-
- Players with the highest number of valuable NFTs are:
- 11 NFTs belong to Trey Lance
- 10 NFTs belong to Patrick Mahomes
- 10 NFTs belong to Aaron Rodgers
- 9 NFTs belong to Josh Allen
- 8 NFTs belong to Justin Herbert
✔️Observations
-
The number of valuable NFTs in different price ranges are:
- 46 NFTs in $5000 - $10000 price range
- 34 NFTs in $2000- $5000 price range
- 16 NFTs in $10000- $20000 price range
- 4 NFTs with more than $20000 price
\
-
The number of different Seasons in valuable NFTs
are:
- Season 2021 - 95 NFTs
- Season 2017, 2014, 2013, 2006 and 2003 - 1 NFTs
✔️Observations
-
Among the total number of NFTs sold (about 420K), the highest percentage of Play Types (Higher than the average number of Play Types) belong to Reception (42.8% - 183466 NFT), Rush(19.3% - 82840 NFT), Pass (12% - 51626 NFT ), and Interception (7.63% - 32722 NFT ), respectively.
\
-
But when we analyze the percentage of different Play Types among valuable NFTs, we reach interesting results. Among the most valuable NFTs, the highest percentage of Play Types belong to Player Melt (48% - 48NFT ) and Pass (39% - 39NFT ), respectively, and the share of other Player Types is less than 10%.
\
-
According to the observations above, Player Melt and Pass are two effective Play Types in valuable NFTs.
-
Player Melt share in all sold NFTs equals 2.2% - Player Melt share in valuable NFTs equals 48% - 45.8% increase (21.81 times share increase)
-
Pass share in all sold NFTs equals 12% - Pass share in valuable NFTs equals 39% - 27% increase (3.25 times share increase)
\
-
-
To ensure the obtained result, we will also analyze the number of play types in the total volume of NFTs sold with the number of play types in the total sales volume of valuable NFTs in the next section
✔️Observations
-
Among the total volume of NFTs sold, the highest percentage of Play Types (Higher than the average sales volume of Play Types) belong to Reception (37.6% - $6.26M), Pas(21.7% - $3.61M), Rush(16.7% - $2.87M ),Player Melt (8.7% - $1.45M),and Interception (5.19% - $865.6K ), respectively.
\
-
But when we analyze the percentage of different Play Types in the total sales volume of valuable NFTs, we reach interesting results. Among the total sales volume of valuable NFTs, the highest percentage of Play Types belong to Player Melt (47.4% - $392.9K), Pass (33.9% - $281K), and Reception (15.1% - $125.2K), respectively, and the share of other Player Types is less than 2%.
\
-
According to the observations above, Player Melt and Pass are two effective Play Types in valuable NFTs.
-
Player Melt share in the total volume of NFTs sold 8.7% - Player Melt share in total sales volume of valuable NFTs equals 47.4% - 38.7% increase (5.4 times share increase)
-
Pass share in the total volume of NFTs sold equals 21.7% - Pass share in total sales volume of valuable NFTs equals 33.9% - 12.2% increase (1.5 times share increase)
\
-
3 - 2 Section 2 Conclusion
According to the results obtained in sections 1 - 2 and 2- 2, it can be concluded that Player Melt and Pass play types can They can make an NFT valuable. But what Play Type does Player Melt refer to?
As explained on the official NFL ALL DAY Twitter account:
While most Moment™ collectibles will have a single NFL highlight, there will be some cases where a collectible will be a compilation of more than one play. These can come in player form (i.e. a player gets multiple sacks in a game and one collectible contains a video melt of all of them)
Therefore, Player Melt does not refer to a specific Play Type.
Final Conclusion of Part 2: Pass Play Type plays an important role in determining the value of an NFT, as about 37% (Average of 33.9 and 39) of valuable NFTs have this type of Play Type. But this conclusion alone is not enough. In the next section, we will analyze the impact of players' value on determining the value of an NFT
3 - Analysis of the value of players in valuable NFTs
Methodology
The value of a player can be determined based on the sales volume of NFTs related to that player or the number of sales of NFTs related to that player. But in this dashboard, we have used a different method!
We prefer to rely on the statistics provided by nfl.com to determine the value of a player and find valuable players based on that!
The number of valuable NFTs is 100 and related to 30 unique players. Since 95% of valuable NFT moments are related to the 2021 season, to determine whether or not the NFTs are related to valuable players, we'll look at these 30 players in the NFL Top 100 Players of 2022 list (2021 season ends in 2022) to see what percentage of them are present NFL Top 100 Players of 2022.
The disadvantage of this method is that we ignore players who have performed brilliantly in the past. But due to their small number, they can be ignored. For example, Brett Favre, who is one of the legendary NFL players, is not considered a valuable player because he retired in 2010.
✔️Observations
-
73% of the total number of valuable NFTs is related to valuable players.
-
63.3% of players related to valuable NFTs are valuable players.
-
From this section, we can conclude that valuable players play an important impact (more than Play Type) in increasing the value of an NFT because 73% of valuable NFTs are related to valuable players.
4 - Is there any meaningful purchasing behavior for certain players who outperformed in Week 1?
Methodology
-
To analyze the impact of a player's performance on purchasing behavior, first, we find the best players of week 1.
- The best performances of week 1 of the current season: Chiefs QB Patrick Mahomes, Giants RB Saquon Barkley lead Players of the Week
- The best performances of week 1 are related to these players:
- 1 - Patrick Mahomes II - Chiefs vs. Cardinals
- 2 - Saquon Barkley - Giants vs. Titans
- 3 - Minkah Fitzpatrick - Steelers vs. Bengals
- 4 - Cade York - Browns vs. Panthers
- 5 - Uchenna Nwosu - Broncos vs. Seahawks
- 6 - Zech McPhearson - Eagles vs. Lions
-
Then we check the purchasing behavior of NFTs related to those players. (The first week started on September 9 and ended on September 13.)
- Of the 6 players mentioned above, only NFTs related to Minkah Fitzpatrick, Saquon Barkley, and Patrick Mahomes are available in the NFL ALL DAY Marketplace.
-
The data relating to the sale of Minkah Fitzpatrick's NFTs in the Flipsidecrypto ( [flow.core.ez_nft_sales] table)database is only available from 2022-09-22 onwards.
Therefore, we cannot calculate the NFT sales related to Minkah Fitzpatrick.
✔️Observations
- As can be seen, the number and volume of sales of NFTs related to Patrick Mahomes II and Saquon Barkley have increased sharply after the first week of matches due to the good performance of these two players.
5 - Conclusion
-
In this dashboard, NFTs that have been sold at the highest prices are considered valuable NFTs. (100 NFT)
\
-
Then, in sections 2 and 3, the impact of play types and the value of players in these NFTs have been examined
-
About 37% of valuable NFTs have Pass ==play type==.
-
==73%== of valuable NFTs are ==related to valuable players.==
\
-
-
Therefore, it can be concluded that the valuable players have a significant impact on determining the value of an NFT, and the play type of an NFT has a minor effect on determining the value of an NFT.
-
A Player's good performance increases the number and volume of sales of NFTs related to that player.