Try Quests to earn FLOWNFL ALL (THANKSGIVING) DAY
Overview 👀 ~ 5 min read
In this dashboard, I will answer this question from Flipside Crypto:
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?
\n
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
Methodology 🧠
I used Flow tables to solve this question
In the flow.core.ez_nft_sales table, purchases and sales in the A.e4cf4bdc1751c65d.AllDay
collection were done through 3 tokens, 2 of which were stable and their price was always $1,
but the other was the Flow token, which I got from the flow.core.fact_prices table. I got the price and combined it with the data. To get average_sale_day and average_unique_buyers_day and average_volume_day I needed the first recorded sale date which was 2022-02-22
At first, I only compared the days of Thanksgiving with other days, but no particular trend was observed in the graphs, so I decided to add different events that occurred during the year, so that maybe I can say something about the graphs. And finally, I chose criteria that could provide useful information, and in my personal opinion, finding the top 10 buyers or top sellers is a cliché.
Introduction 💭
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.
- for more information read here
Who is playing on Thanksgiving?
- The Buffalo Bills (7-3) play at the Detroit Lions (4-6).
- The New York Giants (7-3) play at the Dallas Cowboys (7-3).
- The New England Patriots (6-4) play at the Minnesota Vikings (8-2).
When are the NFL games on Thanksgiving?
Thursday, Nov. 24, which is Week 12 of the 2022 season.
How to watch the NFL's Thanksgiving tripleheader?
- Buffalo Bills-Detroit Lions on CBS (12:30 p.m. ET)
- New York Giants-Dallas Cowboys on FOX (4:30 p.m. ET)
- New England Patriots-Minnesota Vikings on NBC (8:20 p.m. ET)
- for more information read here
What is Flow, blockchain ?
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. It is based on a unique, multi-role architecture, and designed to scale without sharding, allowing for massive improvements in speed and throughput while preserving a developer-friendly, ACID-compliant environment.
- Flow empowers developers to build thriving crypto- and crypto-enabled businesses. Applications on Flow can keep consumers in control of their own data; create new kinds of digital assets tradable on open markets accessible from anywhere in the world; and build open economies owned by the users that help make them valuable.
- Smart contracts on Flow can be assembled like Lego blocks to power apps serving billions of people, from basketball fans to businesses with mission-critical requirements.
There are four pillars that make Flow unique among existing blockchains:
- Multi-role architecture: Flow’s design is unique, allowing the network to scale to serve billions of users without sharding or reducing decentralization of consensus.
- Resource-oriented programming: smart contracts on Flow are written in Cadence, an easier and - - safer programming language for crypto assets and apps.
- Developer ergonomics: from upgradeable smart contracts and built-in logging support to the Flow Emulator, this network is designed for results.
- Consumer onboarding: Flow was designed for mainstream consumers, with payment onramps catalyzing a safe and low-friction path from fiat to crypto.
- for more information read here
🕵️♀️ observations
- If we analyze the graphs of the number of daily sales and buyers and sellers, it is that there is no special trend in different events throughout the year, even if this event is Thanksgiving Day.
- But at the time when this analysis is being written, the market situation is also involved in this factor, most of the projects have sometimes postponed their plans.
- Average Sales per day = 23.8 Sales
- Average Buyer per day = 6.85 Buyers
- Average Seller per day = 8.5 Sellers
- Average Volume $ per day = $ 883
- Average Price Selling = $ 36.1
🕵️♀️ observations
- According to the line graph above, the averages have been lower since Thanksgiving (November 24), sometimes even lower than before
- For example, before November 24, users spent an average of $30 to buy each NFT, but after Thanksgiving, this number is has been up to $20
- Median sales volume and price floor do not show any particular trend, but it can be said that on Thanksgiving days, these two scales were lower than other days.
🕵️♀️ observations
- Looking at the general information on different days, if we consider a daily event, sales on Columbus Day were more than other days.
- In the same way, the number of buyers and sellers and the volume of sales have also increased on this day
- But the noteworthy point is that the average cost (ASP) for users on Thanksgiving days is the lowest possible compared to the rest of the year.
🕵️♀️ observations
- The graphs above give us the idea that the teams that played on Thanksgiving Day during the year include almost 40% of the total number of sales and volume of sales and the number of buyers and sellers,
- but on Thanksgiving Day, all the criteria are increased. and the percentage of ownership of these teams compared to other teams is close to 80%
- In fact, the Thanksgiving event for these teams has made them sell more .
🕵️♀️ observations
- Among other collections that fans of this collection buy, we can mention Topshot, which is very popular among fans
- If we write down the purchases of users and categorize them according to their shopping list, shopping list charts will be created
- On Thanksgiving days, the same Topshot is among the shopping lists of users
- 3 shopping lists of users who have bought over time
- All Day | PackNFT | TopShot 35.8%
- All Day | PackNFT | TopShot | UFC_NFT 12.5%
- All Day | NFL_NFT | PackNFT | TopShot 9.89%
- 3 shopping lists of users who have bought On Thanksgiving days
- AllDay | PackNFT | TopShot 27.2%
- AllDay | NFL_NFT | PackNFT | TopShot 19.5%
- AllDay | NFL_NFT | PackNFT | TopShot | UFC_NFT 11.4%
🕵️♀️ observations
- The average price that fans have spent to buy other collections during the year includes a wider range, among which Flunks, SturdyItems, and Gaia collections are among the most expensive collections for users.
- Users spent most of their money on TopShot, PackNFT, and UFC_NFT collections throughout the year
- But the results are different from Thanksgiving onwards
- The average price that fans have spent to buy other collections during the Thanksgiving days includes a smaller range, among which Golazos, TuneGONFT and TopShot collections are considered the most expensive collections for users,
- and users during the days of Thanks, they spent most of their money on TopShot, Golazos and UFC_NFT collections
🕵️♀️ observations
- In general, over time, if users buy from the ALLDAY collection, a large percentage of them buy between 1 and 10 times, and users buy a little more than 100 times.
- But if users want to buy collections other than ALLDAY, sometimes they have bought more than 500 times and many users have bought between 10 and 100 times.
- These definitions apply to Thanksgiving Day and beyond
Conclusion 🎉
-
It seems that daily sales on days like Columbus Day and Halloween are higher than Thanksgiving Day, but the lowest prices are traded on Thanksgiving Day on Average .
-
It seems that the Thanksgiving event did not cause a big impact on the sales volume, but it changed the sales of the teams that played on this day.
-
Total Sales Volume in Thanksgiving Day = $68.453 k
- Total Sales Volume in Days After Thanksgiving Day = $518.145 k
-
Total Unique Buyers in Thanksgiving Day = 1281
- Total Unique Buyers in Days After Thanksgiving Day = 9521
-
Total Unique Buyers/day in Thanksgiving Day = 4.52
- Total Unique Buyers/day in Days After Thanksgiving Day = 3.73
-
the teams that played on Thanksgiving Day during the year include almost 40% of the total number of sales and volume of sales and the number of buyers and sellers,
- but on Thanksgiving Day, all the criteria are increased. and the percentage of ownership of these teams compared to other teams is close to 80%
-
Many users have collections (All Day | PackNFT | TopShot) in their shopping list
-
a large percentage of users hold between 1 and 5 NFTs,
- almost 77% of users hold between 1 and 5 NFTs.
\
Appendix 🤝
The solution of this question and the queries are completely used from the filipside database
The construction of the dashboard was also used from the site
app.flipsidecrypto.com/velocity, which belongs to flipside