Try Quests to earn FLOWFlow - NFL All Day Tournament [Round 1]
🏈 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 analyze NFL All Day. For this, we check the following:
- NFL All Day Number of Sales:
- Total Number of Sales and Daily Number of Sales over time
- Top 5 Players by Total Number of Sales
- Top 5 NFTs by Total Number of Sales
- Top 5 Sellers by Total Number of Sales
- Top 5 Buyers by Total Number of Purchases
- NFL All Day Number of Sales by Position
- NFL All Day Sales Volume (USD):
- Total Sales Volume and Daily Sales Volume over time
- Top 5 Players by Sales Volume
- Top 5 NFTs by Sales Volume
- Top 5 Sellers by Sales Volume
- Top 5 Buyers by Purchase Volume
- NFL All Day Sales Volume by Position
🧠 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, series, set_name, positions, etc. and then join it with the ez_nft_sales table on:
on (sale.nft_collection = metadata.nft_collection and sale.nft_id = metadata.nft_id)
Finally, using the results obtained from NFL All Day sales records, we perform our entire analysis.
-
To extract positions from the dim_allday_metadata table, we use the following commands:
moment_stats_full:metadata:playerPosition as positions,
case
when positions = 'K' then 'Kicker'
when positions = 'P' then 'Punter'
when positions = 'TE' then 'Tight End'
when positions = 'OL' then 'Offensive Linemen'
when positions = 'DL' then 'Defensive Line'
when positions = 'RB' then 'Running Back'
when positions = 'LB' then 'Linebacker'
when positions = 'WR' then 'Wide Receiver'
when positions = 'DB' then 'Defensive Backs'
when positions = 'QB' then 'Quarterback'
end as position,
\
✅ Observations
Sellers:
- According to the obtained results, the total number of NFT sellers in Flow is equal to 112.7K, of which 38.8K sellers have sold in NFL All Day, that is, about 34.42% of all sellers have sold in NFL All Day
Buyers:
- According to the obtained results, the total number of unique NFT buyers in Flow is 104.7K, of which 30K buyers made purchases on NFL All Day, that is, about 28.65% of all buyers made purchases on NFL All Day
✅ Observations
- It can be seen that in September (recently), the number of buyers and sellers has increased significantly
Number of Sales:
- The wallet address 0x84c9fe7ef49285fb with 2729, 0xe9648003e12c2070 with 2386 and 0x2bbe4f847f5d1758 with 2184 had the most Number of Sales of NFL All Day NFTs.
- The wallet address 0xe9648003e12c2070 with 2724, 0x84c9fe7ef49285fb with 2682 and 0x2bbe4f847f5d1758 with 2129 had the most Number of Purchase of NFL All Day NFTs.
Interestingly, wallet address ==0x84c9fe7ef49285fb== is mixed among both buyers and sellers of NFL All Day NFTs.
Sales Volume (USD):
- The wallet address 0xc4719ab3f4c3db69 with 144319 USD, 0xed8707e2ae5bba5a with 77444 USD and 0x9cf0e3443ebc8bf9 with 74855 USD had the most Sales Volume of NFL All Day NFTs.
- The wallet address 0xc4719ab3f4c3db69 with 620121USD, 0x64afebe42165be6e with 204558USD and 0xb8eab8b330b6d8f3 with 168423USD had the most Purchase Volume of NFL All Day NFTs.
It is interesting that the wallet address ==0xc4719ab3f4c3db69== has the highest trading volume of NFL All Day NFTs.
✅ Observations
Number of Sales:
- The top players in terms of Number of Sales are respectively Cooper Kupp with 6752, Mark Brunell with 6669 and Cris Carter with 6554.
Sales Volume (USD):
- The top players in terms of Sales Volume (USD) are respectively Ja'Marr Chase with 486760 USD, Justin Herbert with 450311 USD and Patrick Mahomes II with 579885 USD.
✅ Observations
- Wide receiver with 163447 sales, quarterback with 88261 sales and Running Back with 81821 sales have the most Number of Sales among NFL All Day positions.
- Wide receiver with 5357628 USD sales, quarterback with 5740701 USD sales and Running Back with 2097574 USD sales have the most Sales Volume among NFL All Day positions.
✅ Observations
Number of Sales:
- The Top NFTs in terms of Number of Sales are RARE ==#1643391== Series 1, Ball Hawk with 37 sales, COMMON ==#2139160== Series 1, Super Wild Card Weekend with 12 and RARE ==#2248375== Series 1, Divisional Round with 11 sales.
Sales Volume (USD):
- The Top NFTs in terms of Number of Sales are LEGENDARY ==#691331== Series 1, Hoodwinked with 24200 USD sales, LEGENDARY ==#691329== Series 1, Hoodwinked with 16000 USD and ULTIMATE ==#2677673== Historical, Marquee with 44444 USD sales.
The top NFTs are among the ==LEGENDARY== and ==ULTIMATE== tiers, which are the most expensive NFTs and have only been sold once or twice.
✔️ Final Conclusion
> Based on the results obtained from the analysis of sales, users, players and positions for NFL All Day, we obtained the following results: > > * The total number of NFL All Day sales is 516K, which is 14.13% of the total number of NFT sales in Flow > * The total NFL All Day sales volume is 18.6M USD, which is 22.24% of the total NFT sales volume in Flow. > * Total NFL All Day sellers are 38.8K which is 34.42% of all NFT sellers on Flow > * Total NFL All Day buyers are 30K which is 28.65% of total NFT buyers on Flow > * The top seller in terms of number of sales is 0x84c9fe7ef49285fb and the top buyer in terms of number of sales is 0xe9648003e12c2070 > * The top seller and buyer in terms of sales volume is 0xc4719ab3f4c3db69 > * The top players in terms of sales volume are Ja'Marr Chase , Justin Herbert and Patrick Mahomes II. > * The top players in terms of number of sales are Cooper Kupp, Mark Brunell and Cris Carter. > * The Top NFTs in terms of Number of Sales are RARE ==#1643391== Series 1, Ball Hawk with 37 sales, COMMON ==#2139160== Series 1, Super Wild Card Weekend with 12 and RARE ==#2248375== Series 1, Divisional Round with 11 sales. > * The Top NFTs in terms of Number of Sales are LEGENDARY ==#691331== Series 1, Hoodwinked with 24200 USD sales, LEGENDARY ==#691329== Series 1, Hoodwinked with 16000 USD and ULTIMATE ==#2677673== Historical, Marquee with 44444 USD sales.