Try Quests to earn FLOWFlow - NFL All Day Tournament [Round 2]
🏈 NFL All Day → Source
NFL All Day is a digital collectible marketplace that lets football fans collect video highlights in the form of NFTs and connect with other like-minded fans from around the world. On NFL All Day, football fans can collect non-fungible tokens (NFTs) called "Moments" that capture highlights of great passes, touchdowns and other plays.
What is a Moment?
A Moment is a digital video clip of an iconic play from a National Football League game that has been stored on the blockchain. Moments are immutable, meaning they can’t be edited or deleted and can be stored forever on a blockchain.
❓ What are NFL All Day Moments and packs? → Source
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
✍️ Description of Work
In this dashboard, we want to check if there is a type of play that is more valuable, or do valuable players sell at higher prices regardless of play type? we also want to see if there was any meaningful purchasing behavior for certain players who outperformed in Week 1? To examine these two cases, we will go to the following sections:
Section 1 → Valuable Play Type== and ==Player
- Find Valuable NFTs for sale at the highest prices
- Investigating Play Types in Valuable NFTs → Sales Volume, Number of Sales, Average Sales Volume
- Investigating Play Types for Valuable NFTs in all sales → Sales Volume, Number of Sales, Number of NFT, Average Sales Volume, Number of Seller, Number of Buyer and etc.
- Investigating Player in Valuable NFTs → Sales Volume, Number of Sales, Average Sales Volume
- Investigating Player for Valuable NFTs in all sales → Sales Volume, Number of Sales, Number of NFT, Average Sales Volume, Number of Seller, Number of Buyer and etc.
- Comparison of Play Types and Players in Valuable NFTs
Section 2 → Purchasing behavior for certain players who Outperformed in Week 1
🧠 Methodology
To deal with this dashboard, we use flow.core schema and ez_nft_sales and dim_allday_metadata tables. nft_collection for NFL All Day is equal to A.e4cf4bdc1751c65d.AllDay
- First, we extract the list of NFL All Day data in the dim_allday_metadata table, including nft_collection, nft_id, player, moment_tier, team, season, week== and ==play_type and then join it with the ez_nft_sales table on:
join with ez_nft_sales table on (sale.nft_collection = metadata.nft_collection and sale.nft_id = metadata.nft_id) -> pseudocode
Finally, using the results obtained from NFL All Day sales records, we perform our entire analysis.
Valuable NFT: According to our definition, an NFT is valuable when it is scarce and sold at the highest possible price
📈 The analyzes we want to do:
Section 1 → Valuable Play Type== and ==Player
To deal with this section, we first get 100 NFTs that are valuable in terms of highest possible price, then we examine the play types and players in these 100 NFTs. Our reviews are in terms of sales volume, number of sales, average sales and median for play types and players, then we review play types and players in all sales based on these criteria separately plus number of buyers and sellers . Finally, we compare the play types and players and we check which ones are more valuable.
Section 2 → Purchasing behavior for certain players who Outperformed in Week 1
The week 1 of the NFL started on the 9th and continued until the 13th of September, in this week we will review the NFT sales by Volume and Number of sales by players and get the Top Players (outperformed), and then we will get their sales in week 1 and after this week. The top 15 players of week 1 in terms of rank according to this link, in order:
- Aaron Rodgers, Cooper Kupp, Josh Allen, Patrick Mahomes, Jonathan Taylor, Davante Adams, Derek Carr, Justin Herbert, Joe Burrow, Justin Jefferson, Tom Brady, Travis Kelce, Ja'Marr Chase, Lamar Jackson and Derrick Henry
We get the sales volume for the top players during week 1 and after week 1 and we check how their good performance in the first week has affected their sales volume.
✅ Observations
It can be seen that from Top 100 Valuable NFTs:
- The highest selling price is 50,000 USD for Odell Beckham Jr. with play type Reception
- The lowest selling price is 4000 USD which is Cooper Kupp with play type Player Melt
- 100 NFTs Valuable corresponding to 28 unique players and 7 unique play types
- Up to 100 Valuable NFTs corresponding to moment_tiers ULTIMATE, LEGENDARY or RARE
→ Now we check the player and play types for these 100 NFTs and all sales
✅ Observations
- You can see that the highest volume of sales and number of sales and unique player is in the top valuable NFTs is for play type Player Melt and Pass
- It is interesting that the average and median sales volumes for Player Melt and Pass are almost equal, while these values for Reception are more than Player Melt and Pass, but the number of sales for Reception is less than Player Melt and Pass.
→ Now we check the ==play types== of all the sales
✅ Observations
According to the charts above, from the review of the Top 10 Play Types in all sales, it is clear that:
- In terms of Sales Volume (USD), the following play types have the highest sales volume in order:
- Reception > Pass > Rush > Player Melt > Interception
- In terms of Number of Sales, the following play types have the highest sales volume in order:
- Reception > Rush > Pass > Interception > Sack
It is interesting that in the Top 10 Play Types in terms of Volume and Number of Sales, Pass is among the first three, while Pass is also among the the first tow in Top 100 Valuable NFTs Play Types. So, Pass can be mentioned as a Valuable play type, although this issue is still not certain. So let's measure the sales volume of play types in terms of statistical data (Average and Median)
✅ Observations
-
It can be seen that the Average overall volume of sales is 35.7 USD and their Median is 15 USD
-
It can be seen that the Average and Median for Reception is lower than the overall Average and Median , while Reception is among the first Top Play Types in terms of all criteria:
Reception: So, we conclude that ==Reception== is the first in terms of sales in terms of all criteria, but ==Reception== play type is ==Not Valuable== and ==Influential== because users spend less than the overall average to buy Reception type NFTs.\
-
It is interesting, you can see that the Average and Median for Pass and Player Melt are ==higher== than the overall Average and Median , while Pass and Player Melt are among the top paly types in Top Valuable NFT and according to the definition of Player Melt we conclude that Pass is the most valuable play type.
Now we check the ==Players== in the Top 100 Valuable NFT and the total sales and finally we compare the ==Players== with ==play type(Pass)== to see which ones are more ==valuable==.
✅ Observations
- You can see that 100 valuable NFTs belong to 28 Unique Players
- 28 players corresponding to 100 valuable NFTs corresponding to a maximum of 2 unique play types
- They observe that the players with the highest number of sales among the 100 valuable NFTs have almost the same average and median.
→ Now we check the ==players== of all the sales
✅ Observations
According to the charts above, from the review of the Top 10 Player in all sales, it is clear that:
- In terms of Sales Volume (USD), the following Players have the highest sales volume in order:
- Tom Brady > Patrick Mahomes II > Justin Herbert
- In terms of Number of Sales, the following Players have the highest sales volume in order:
- Cooper Kupp > Nick Chubb > Justin Herbert
It is observed that the players who had the highest number and volume of sales among the 100 valuable NFTs, almost all of them are among the top 10 players in terms of all the reviewed criteria, and this is a natural thing, now we have to look at the statistical data to see the player valuable or not?
✅ Observations
- It can be seen that the Average overall volume of sales is 35.7 USD and their Median is 15 USD
- You can see that the players who have the highest number and volume of sales and are among the 100 valuable NFTs, the Average and Median sales volume of all of them are higher than the overall== Average and Median, this shows that users prefer to spend more than average to buy NFTs based on the player they want, and this shows that the players are valuable.
So far, we have come to the conclusion that the ==Pass Play Type== is more valuable than other play types, and it has also been found that users spend more than average to buy NFTs per ==player==, indicating that players are more valuable. Now, in the next step, we will compare players and play types.
✅ Observations
According to the results obtained, which are related to the review of play types and players in Valuable NFTs, it is clear that:
- About 59% of sales related to players are higher than the overall average sales volume, which means that users prefer to spend more money on NFTs based on the player.
- Only 26% of sales related to play types are higher than the overall average sales volume, which means that users prefer to spend less money on NFTs based on play type.
- Of the 100 Valuable NFTs, about 86% of their descriptions mentioned the names of the players and only 14% mentioned the play types.
Therefore, according to the obtained results, ==Players are more Valuable==, and the performance of a player makes a NFT valuable, but at the same time, play type ==Pass is also effective== according to the analysis.
✅ Observations
- You can see that the Volume of Sales, the Number of Sales, the Number of Buyers and Sellers in the period from December 9 to 13, 2022, which was the first week, has increased significantly compared to other times.
- The highest volume and number of sales was related to Sep 12, 2022
→ We will look at the sales volume for the top 15 players (outperformed) in the first week and see how their good performance has affected their NFT sales.
✅ Observations
- You can see that for the Top 15 players (outperformed) in the Week 1, 7 (50%) of them increased their sales after the Week 1 and their NFTs traded at a higher price.
- Justin Herbert, Aaron Rodgers and Derrick Henry had the biggest increase in sales price after the Week 1
→ Now we are going to distribute the sales volume of these players in the first week and after that
✅ Observations
- As you can see, three players, Justin Herbert, Aaron Rodgers and Derrick Henry had the highest increase in sales price after week 1
✔️ Final Conclusion
> According to the review and comparison of the valuable of play type and players, we came to the conclusion that players are more valuable and users trade NFTs more based on players and for about 59% of players they spend more than the overall average. Meanwhile, only 26% of play types spend more money than the overall average, but you can't ignore the Pass play type because it is among the 100 most valuable NFTs and users spend more money than the overall average for Pass-type NFTs. > > Also, after examining the volume and number of sales of the Top 15 players (outperformed) in the week 1 of the 2022 season, we came to the conclusion that about 50% of the players who performed better in the first week (outperformed) had a higher sales price after that, and three players Justin Herbert, Aaron Rodgers and Derrick Henry have had significant increases