Try Quests to earn FLOW[Flow] - NFL ALL (THANKSGIVING) DAY
Bounty Question
The NFL's annual Thanksgiving games recently drove record viewership in the U.S., with 42 million people tuning in to see the Giants take on the Cowboys. Did FLOW NFT project NFL ALL DAY see similar boosts in popularity?
Create a dashboard that analyzes NFL ALL DAY NFT activity over the past week, and compares it to activity over the past year. Include at least these metrics, along with any others you find notable or interesting:
- Sales volume (daily)
- Total Sales Volume
- Daily Average Sales Price and 7-day moving average
- Total Unique Buyers
- Average Buyers/Day
NFL All Day
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.Unlike traditional sports memorabilia such as ticket stubs or trading cards, NFL All Day Moments are stored on a blockchain and can be bought, sold or traded on a peer-to-peer marketplace. In the coming months, fans will also be able to use their Moments to win prizes by competing in official challenges. Launched at the tail end of 2021, NFL All Day is the latest product offering from Dapper Labs, the same creators of the hit NFT Marketplace and NBA Top Shot.
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.Like physical trading cards, Moments come in different types and tiers with unique digital serial numbers to guarantee ownership and authenticity. The rarer the Moment, the more valuable it is in the marketplace.
What are NFL All Day Moments and packs?
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.
Methodology
Considering that more than a week has passed since Thanksgiving (which was November 24th) and the goal of the bounty question is the effect of this day on the sale of NFL All Day Collection. the reviews of this dashboard were done in two time frames. One was from before Thanksgiving (which covers the period from February 2022 to November 23), abbreviated as "before Thanksgiving", and the other from November 24 to the day before the current date (due to incomplete data for the current day) was called "after Thanksgiving". From the beginning to the end of this dashboard, all the charts and data on the left half of the dashboard are for the "before Thanksgiving" period and the data on the right half of the dashboard are for the "after Thanksgiving" period. (Although in each part, this division is mentioned again to avoid any confusion in viewing the results related to each time period.) The methods adopted below have been the same for both time periods, and therefore the explanations mentioned for different time periods are not separated and they can be considered true for both time periods.
To buy and sell NFTs of this collection in the two existing marketplaces, only two currencies have been used: 1) DapperUtilityCoin, which has a value equal to $1, and the other is the FLOW token. In order to apply the USD value of purchases and sales made with this token, considering that there is a minute-by-minute FLOW token price in the flow.core.fact_prices table, I calculated the USD value of each transaction based on the price of FLOW at the same time and date. (instead of calculating the daily average price of the FLOW token) so that the USD value results of the trades are very close to their actual USD value on the date and time of the trade.
The NFTs of this collection were traded in two marketplaces, one of them (GaiaOrder) hosted all the NFT transactions of this collection from February 12 to July 6, and the other (NFTStorefront) hosted these transactions from July 6 to the current date. Because in the period before Thanksgiving, the data of both marketplaces are present, "donut" charts have been used in many parameters, but in the period after Thanksgiving, because there is only one marketplace (NFTStorefront), the results and data It is generally reported as "single number".
This is how it is done in this dashboard:
In the first step, an overview of the sale of NFTs of this collection was done. In this overview, parameters such as Number of Sales, Number of Buyers, Number of Sellers, Number of NFTs and sales volume (USD) were obtained.
In the second step, the 5 parameters mentioned in the first step were calculated and reported as an average per day.
In the third step, the 5 parameters mentioned in the first step were calculated for the marketplace(s).
In the fourth step, the 5 mentioned parameters were plotted on a daily basis. Also, the cumulative diagram of each of these parameters was also drawn.
In the fifth step, the average money paid for NFTs bought was also plotted on a daily basis and plotted against its 7-day moving average in a graph.
In the sixth step, the overall average floor price of NFTs of this specific collection and their daily floor were drawn in another graph.
In the seventh step, the value of the highest NFT transaction per day was also obtained.
In the eighth step, the distributions of buyers (based on the number of purchases, volume of purchases and number of NFTs purchased), sellers (based on the number of sales, volume of sales and number of NFTs sold) and NFTs (number of transactions, volume of transactions and average price) are determined. became.
In the ninth step, the status of the teams and players that were traded in relation to NFTs was determined (in all 5 parameters).
Overview
Over 1.9m sold in 277 days vs over 39k sold in 11 days. (Pre-Thanksgiving: average 6,864 sales per day, post-Thanksgiving: average 3,554 sales per day.) Even in terms of daily averages, the pre-Thanksgiving period is superior.
1.133m NFTs were traded in the pre-Thanksgiving period, and 34.7k NFTs were traded in the post-Thanksgiving period. This means that in the period before Thanksgiving, each NFT was bought and sold an average of 1.68 times, while in the period after Thanksgiving, each NFT was bought and sold an average of 1.12 times. Here too, the post-Thanksgiving period has not been able to outperform the long-term average sales of NFTs in this collection.
The USD value of NFT transactions in this collection in the period before Thanksgiving was more than $71m, while in the period after this day, the value of these NFT transactions was about $635k. This means that there was an average of over $256k in NFT sales per day in the pre-Thanksgiving period, but this number reached a daily average of $57.7k in the post-Thanksgiving period. A very noticeable decrease in averages!
In terms of daily averages, if we check these periods:
- ==Average Sales/Day==: In the period before Thanksgiving, this parameter is higher in both marketplaces than its average in the period after Thanksgiving. (GaiaOrder is about 1.6 times and NFTStorefront is about 2.21 times)
- ==Average Sales Volume(USD)/Day==: in the period before Thanksgiving, this parameter is higher in both marketplaces than its average in the period after Thanksgiving (GaiaOrder around 4.66 times and NFTStorefront around 4.18 times)
- ==Average NFTs/Day==: In these parameters, in the period before Thanksgiving, the results of both marketplaces are higher than the average in the period after Thanksgiving. (GaiaOrder is about 1.56 times and NFTStorefront is about 2.18 times)
- ==Average Buyers/Day==: In the period before Thanksgiving, this parameter is higher in both marketplaces than its average in the period after Thanksgiving. (GaiaOrder is about 1.46 times and NFTStorefront is about 2.23 times)
- ==Average Sellers/Day==: here, like the previous 4 parameters, a certain superiority can be seen in the period before Thanksgiving. (GaiaOrder about 1.6 times and NFTStorefront about 2.06 times)
Daily Review
Three peaks can be seen in the daily sales of NFTs of this collection in the period before Thanksgiving:
- The last days of February and the first days of March
- Last 10 days of April
- September and October
The highest daily sales was on February 23, when more than 59k transactions took place. This record occurred in the GaiaOrder marketplace. The second and third day records are on September 12 and April 12 respectively (with over 37k and 31k sales in one day).
In the post-Thanksgiving period, the highest number of sales in a single day was November 29, when 5.43k sales occurred on this day. Two days of Thanksgiving, 4.25k sales of NFTs of this collection have been made. The number of sales on the top day after Thanksgiving is less than 10% of the sales on the top day before Thanksgiving!) The trend charts of the number of buyers, the number of sellers, and the number of NFTs traded daily in the pre-Thanksgiving period are very similar to the trend charts of the daily sales numbers. Although there are differences in the best days of each of these parameters, the generality of what we saw in the previous chart is the same here.
But in the period after Thanksgiving, more differences appear. For example, in the number of daily sellers, Thanksgiving and the day after that are the first two days in terms of the number of unique sellers in one day. (while the highest number of sales occurred on November 29). The highest number of unique buyers was also recorded on November 25. But in terms of the number of unique NFTs sold in a single day, November 29 holds the upper hand. It seems that on Thanksgiving Day and the day after, a smaller number of NFTs were moved between more buyers and sellers.
The trend of the daily sales volume chart in the pre-Thanksgiving period has a relatively acceptable appearance similarity with that analyzed in the previous 4 parameters, but the intensity of the differences is not the same as the previous parameters. All three top days in terms of sales volume (based on USD value) were in February and March. In the period after Thanksgiving, the first day of December has the highest sales volume. If we look at the average daily sales chart on this day, we can see that the average value of NFTs sold on this day is over $27, while on other days of the post-Thanksgiving period, the average USD value of NFTs sold is at least It was $17.66 (as of November 30).
In the graph of the average USD value of daily transactions, an almost downward trend can be seen. The averages, which peaked in March (the highest value was on March 23, when the average value of each NFT sold was more than $91), then started a downward trend, except for In May, July and August, this downward trend has been followed. In the days leading up to Thanksgiving, the lowest daily averages have been recorded.
The average floor price of NFTs sold in the pre-Thanksgiving period is 1.38 times the average floor price of NFTs sold in the post-Thanksgiving period.
In the pre-Thanksgiving period, with the exception of February 12th, when Flora NFTs sold (out of two sales) at $80, Flora's single-day high was $6. Since Thanksgiving, the price of flour has fluctuated between $1 and $2.
On March 19, an NFT worth $65k was sold, the most valuable NFT sold from this collection to date. In the post-Thanksgiving period, on the first day of December, the sale of an NFT worth $9.5k makes this day quite unrivaled among other days in the period.
Distributions
In the pre-Thanksgiving period, 23 percent of sellers made between 2 and 5 sales, and another 23 percent between 6 and 10. . Only 9.5% of sellers have had only one sale. While in the period after Thanksgiving, 39.6% had only one sale and 38.2% had between 2 and 5 sales.
In the pre-Thanksgiving period, 26.6 percent of shoppers made between 2 and 5 purchases, and another 20.4 percent made only one purchase. While in the period after Thanksgiving, 43.5% made between 2 and 5 purchases and another 26.7% of buyers made only one purchase in this 11-day period.
In the pre-Thanksgiving period, 42.8 percent of sellers sold more than $500. Only 1.85% of users had a sales volume of less than $10. While in the period after Thanksgiving, the sales volume of 45.5 percent of sellers was between 10 and 50 dollars. It is interesting that in this same 11-day period, the sales volume of 3.56% of users was more than 500 dollars.
In the pre-Thanksgiving period, the purchase volume of 32.8% of buyers was more than $500, and a more even distribution can be seen among other categories. For example, the last category is related to the purchase volume of less than $10, which about 8.5% of buyers are in this category. While in the period after Thanksgiving, the purchase volume of 42.4% of buyers was between 10 and 50 dollars. More than 5% of buyers have paid more than $500 to buy NFTs in this collection in these 11 days.
In the pre-Thanksgiving period, 23% of sellers sold between 2-5 and another 23% between 6-10 NFTs. Only 9.5% of sellers have sold just one NFT. While in the post-Thanksgiving period, 39.6% sold only one NFT and 38.2% sold between 2 and 5 NFTs.
In the pre-Thanksgiving period, 26.6% of buyers bought between 2 and 5 NFTs, and another 20.4% bought just one NFT. While in the post-Thanksgiving period, 43.5% had between 2 and 5 NFTs, and another 26.7% of buyers bought only one NFT in this 11-day period.
About 58% of NFTs traded only once in the pre-Thanksgiving period, and 41.4% of NFTs traded between 2 and 5 times. While in the period after Thanksgiving, 88.5% have traded only once and 11.5% between two and five times. Only 2 NFTs have been traded between 6 and 10 times in this time frame!
The average value of 32.9% of NFTs sold in the pre-Thanksgiving period was between $5 and $10, and another 29.9% was between $10 and $25. In the days after Thanksgiving, 37.9% were under $5 and 29.9% were between $5 and $10.
More than 28% of NFTs traded between $10 and $25 in the pre-Thanksgiving period, and more than 24% of NFTs traded between $5 and $10. While in the post-Thanksgiving period, about 83% of NFTs had a sales volume of less than $25, with the less than $5 range ranking first with more than 33% of all NFTs.
Conclusion
Part I: Overview
In no parameter, superiority and a significant increase can be observed in the days after Thanksgiving compared to the period before it. The numbers aren't even close, and there's a clear lead in the averages with the pre-Thanksgiving period.
Part II: Daily Review
In the period before Thanksgiving, the 5 parameters have experienced almost the same trends with different intensities, but in the period after Thanksgiving, it can be seen that the days with the highest sales, the highest buyers, the highest sales volume, and the highest sales volume are on different days of this time period. It has been 11 days.
Part III: Distributions
Considering the period of 277 days, compared to the period of 11 days after Thanksgiving, it is normal that the numbers and figures in the period after Thanksgiving in the distribution charts are lower than the numbers and figures in the period before Thanksgiving.
Part IV: Teams and Players Status
Kansas City Chiefs, Los Angeles Rams, Cincinnati Bengals and Tampa Bay Buccaneers have been important and outstanding teams in the statistics reported in the 5 main parameters examined about the teams.
Mac Jones, Cooper Kupp, Ja'Marr Chase, Matthew Stafford, Tom Brady, Patrick Mahomes B have been important and outstanding players in the statistics reported in the 5 main parameters examined about the players.
Teams Status
Before Thanksgiving:
- Kansas City Chiefs, Los Angeles Rams and Cincinnati Bengals are ranked first to third in terms of sales. (109.64k, 103.66k and 94.4k respectively)
- The teams Los Angeles Rams, Cincinnati Bengals and Kansas City Chiefs are ranked first to third in terms of the number of buyers. (21.1k, 19.5k and 19.12k respectively)
- Kansas City Chiefs, Los Angeles Rams and Cincinnati Bengals are ranked first to third in terms of the number of sellers. (35.5k, 32.1k and 31.5k respectively)
- The teams Los Angeles Rams, Kansas City Chiefs and Cincinnati Bengals are ranked first to third in terms of the number of NFTs traded. (respectively 61.23k, 60.86k and 55.045k)
- Tampa Bay Buccaneers, Kansas City Chiefs and Cincinnati Bengals are ranked first to third in terms of sales volume (USD). (respectively $6.36m, $5.6m and $4.64m)
After Thanksgiving:
- The teams Detroit Lions, New England Patriots and Buffalo Bills are ranked first to third in terms of the number of sales. (respectively 2.848k, 2.322k and 2.137k)
- The teams Detroit Lions, New England Patriots and Buffalo Bills are ranked first to third in terms of the number of sellers. (1.628k, 1.61k and 1.319k respectively)
- The teams Detroit Lions, New England Patriots and Buffalo Bills are ranked first to third in terms of the number of buyers. (1.74k, 1.519k and 1.293k respectively)
- The teams Detroit Lions, New England Patriots and Buffalo Bills are ranked first to third in terms of the number of NFTs purchased. (respectively 2.517k, 2.05k and 1.875k)
- The teams Minnesota Vikings, Detroit Lions and Buffalo Bills are ranked first to third in terms of purchase volume (USD). (respectively $46k, $43.3k and $42.4k)
Players Status
Before Thanksgiving:
- Mac Jones, Cooper Kupp and Ja’Marr Chase are ranked first to third in terms of sales. (17.5k, 17.4k and 15.45k respectively)
- Cooper Kupp and Ja’Marr Chase and Mac Jones are ranked first to third in terms of the number of buyers. (10.6k, 9.1k and 8.9k respectively)
- Mac Jones, Cooper Kupp and Matthew Stafford are ranked first to third in terms of the number of NFTs traded. (10.04k, 8.93k and 8.91k respectively)
- Cooper Kupp, Mac Jones and Ja’Marr Chase are ranked first to third in terms of the number of sellers. (respectively 11.54k, 11.19k and 10.58k)
- Tom Brady, Patrick Mahomes B, Ja’Marr Chase are ranked first to third in terms of sales volume (USD). (respectively $4.59m, $3.09m and $1.9m)
After Thanksgiving:
- Mac Jones, Calvin Johnson and Sam Williams are ranked first to third in terms of the number of sales. (respectively 1.256k, 1.023k and 0.812k)
- Mac Jones, Sam Williams and Calvin Johnson are ranked first to third in terms of the number of buyers. (1.137k, 0.747k and 0.645k respectively)
- Mac Jones, Calvin Johnson and Sam Williams are ranked first to third in terms of the number of sellers. (respectively 1.107k, 0.92k and 0.83k)
- Mac Jones, Calvin Johnson and Sam Williams are ranked first to third in terms of the number of NFTs purchased. (946, 732 and 643 respectively)
- Tom Brady, Mac Jones and Calvin Johnson are ranked first to third in terms of purchase volume (USD). (respectively $29.1k, $27.75k and $19.22k)