Try Quests to earn cryptoAlgorand - 2. Ultimate Fifa+ Collect Dashboard
We’ve reached the final round of the Flipside World Cup and to come full circle we will be looking at how the Fifa+ Collect project on Algorand has progressed. The goal is to create a dashboard to allow users to monitor the minting and secondary sales of each collection.
We’ve reached the final round of the Flipside World Cup and to come full circle we will be looking at how the Fifa+ Collect project on Algorand has progressed. The goal is to create a dashboard to allow users to monitor the minting and secondary sales of each collection. Some things to include:
Track mints and secondary sales over time broken out by collection:
- Number of mints/secondary sales
- USD Volume of mints/secondary sales
- Number of wallets
Track the number of each rarity minted in each collection
Track the likelihood of minting each rarity for each collection (Tip: The editions field gives the total supply of the NFT and DO-##. The ## is the card number in the collection, so DO2-38 is card 38 in Drop 2 which will have a supply).
Give a breakdown of secondary sales for the rarity in each collection:
- Number of sales
- Total USD volume
- Average sale per rarity.
- List the most valuable cards in each collection based on secondary sales
Include any other data you think would be useful to a user wanting to mint or buy a pack in the marketplace: some things to consider are card breakdown based on event, year, player, score, or countries.
Tip: Each pack that is minted includes 3 cards.
✅ Observation:
More than 0.78M NTF with the total volume of 1.371M$ has been minted. The number of minter numbers is more than 15.18K.
The NFT's information is as follow:
The number of distinct player is 163
The NFT's belong to the 94 minute of the game the rarity of the these NFTs is 4.
The number of distinct COUNTRY_1 is 55.
The number of distinct COUNTRY_2 is 66.
The number of distinct COUNTRY_1_ SCORE 7.
The number of distinct COUNTRY_2_ SCORE 6.
The number of distinct DROP_NAME is 4.
28 Host are play role in this NFTs by exactly 20 year.
There is 2 type of world cup (Men, and Women)
14.43K NFT with the price of 458K$ are in the secondary market.
The total user numbers is 1445.
✅ Observation:
The "Daily Number-Volume of mint/secondary sale" has been visualized in this section.
The chart of volume is based on USD.
In the chart of "Daily volume of mint/secondary (USD)"
Before the 5th of October, there isn't the secondary market.
Before this time, the mint process of the NFTs has a notable trend.
At first mint process start with a strong action (22,23 September) and the volume of mint rise up to more than 90K$ but after that decreased gradually to less than 9K$!
By appearance of the secondary market, another pattern like previous part has been occurred between (6-18 October)
The maximum mint process has been showed in 8th October by 119.251K$
The maximum volume of secondary market is on 18th of November by more than 38K$.
After the 18th of October there isn't any determined pattern in this chart, but the general stream of the this metric is downwarding.
Not the volume of mint is 123$ and the secondary market volume is less than 35$!!!!!
These information can verified by the Cumulative chart and the slope of this diagram.
Based on the Normalized chart:
The share of secondary market in this metric increased significantly.
Although there is some days that the secondary market hasn't any share in this chart, but there is some days that the share of secondary market is more than 89%!
Based on the "Daily number of mints/secondary sale":
There is two determined trend same as the Volume chart.
The date of these trend is also like the Volume chart.
The maximum number of NFT's mint is on 8th October by more than 71K mint.
Today the number of mint is 72 and the number of secondary sale is 21! (The lowest number of mint and secondary sale!)
In the opposite of the Volume chart the share of secondary sale in the chart of "Number" isn't significant.
The maximum record has been occurred in the 11th of December by 45% of total number.
It is clear that the share of secondary sale is upwarding gradually.
in the last 3 chart the total Volume-Number-Wallets showed.
The total volume of sale in the mints section is more than 1.3 M$.
$ is the sale of secondary market.
The total number of mints is 780.19K
The secondary sale number is 13.97K.
Number of wallets in the mints process is more than 34.24K and in the secondary market is 3281!
✅ Observation:
This section has been designed to investigate the "Total price change"
Based on the "Average USD price of all NFTs":
The chart start in the 19th September with the average price of 1.66.
The average price increased gradually to 14th November. In this time the average price was 5.005!
After this time the price decreased to 5th December and now the price is a little more than December and it is 3.47.
Based on the "Average USD price of mint NFT":
The average price of mint NFT was stable from the beginning to the 24th October.
A sharp spike and increase occurred between 24-31 October from the 1.66 to 2.21 (30% increase)
The peak of average price is on 7th of November by price of 2.37.
After that the stream of this section decreased up to 28th November and now the average price is 1.9.
Based on the "Average USD price of NFT on secondary markets":
In the opposite of last two chart, this diagram has more fluctuations and different pattern over time.
The general trend on this section is downward and the initial price is 35.07 and the today price in the secondary market is less than 4.7! (One eightا of the initial amount)
The average price increase to 50.8 on the 17th October.
There is another two spike on 14th-28th November.
In both above charts the today average price is more than initial average price. But the average price in the secondary market is one eighth of the initial price!
✅ Observation:
In this section the rarity of NFTs has been checked in term of Number and Volume.
Normalized and cumulative charts help us to have more accurate analysis.
All of the above charts draw for mint/ secondary market both.
At the end of section the average price of mint, and secondary market by rarity has been shown.
Based on the "Daily number of NFT mint by rarity":
In this section the NFTs categorized into different class.
"Common", "Rare", "Iconic", and "Epic".
The most of the NFTs classified into "Common" class.
"Rare" is the second.
Same as the previous sections, there is a strong start in term of number.
The "Daily volume of NFT mint by rarity (Normalized)" shows that the share of each class is stable over time approximately.
E.g. common class account for 79%-85% of NFTs.
Rare class changed between 13-17%.
2-3% related to the Epic class.
The lowest record is about "Iconic" class and there is few days that this class recorded! E.g. in 5th December by share of 0.2%!
In the opposite of mint section, The "Epic" NFTs class has a significant share in the secondary market. (Up to 95% in some days! For example 17th October)
The "Iconic" group is another group that attract a lot of attention. The share of this class reach to 82% in some days!
The maximum records is related to the "Epic", and "Iconic" class.
The maximum record in term of volume is occurred in the 18th of November.
The situation is a little different in term of "Number".
The "Common" class has most share in term of "Number"
The second one is "Epic" class.
The minimum share belong to the "Iconic" group.
Based on the "Average price of NFT" in the mint part:
Except the "Iconic" group, all of the other group has good correlation in the average price and changes over time.
All of them change together and their average price is between 2-2.5
But the "Iconic" class is separate from the another classes.
It has the maximum average price today by 3.3, and experience high fluctuations over time. E.g from 2.91 (7th November) to 1.66 (21th November), or from 2.13 (28th November) to 3.33 (5th December)
The situation in the secondary market is the same as the mint part.
The average price in this part is too high.
The price range of the "Iconic" class is between 1000-2500 approximately!
The trend of "Iconic" class pass a sagittal movement between 3th October to 7th November.
A sharp increase comes after the sagitical movement and the average price jumped to the 2541 then the downward trend starts.
🧠 Methodology:
- The tables nft.ez_nft_sales_fifa and nft.ez_nft_metadata_fifa have been used.
- The analyzing have been done in 7 points of view. First, we explored metrics in point of view of totals in 3 sections then we explored in point of view of 4 collections.
- Each section contains mint and secondary market information and has been compared.
- Normalized charts have been prepared for better compression.
- In exploring in point of view of teams we group all NFTs in three best, medium and others.The teams ('BRA','FRA','GER','ENG','ARG','ESP','NED','ITA') is the best teams ever so the best match is the match that team home and away consist of these teams. mediums are the match that one team home or away consist these teams, and others don’t contain the best team. These teams have found by below code:
case
when COUNTRY_1 in ('BRA','FRA','GER','ENG','ARG','ESP','NED','ITA') and COUNTRY_2 in ('BRA','FRA','GER','ENG','ARG','ESP','NED','ITA') then 'best'
when
(COUNTRY_1 in ('BRA','FRA','GER','ENG','ARG','ESP','NED','ITA') and COUNTRY_2 not in ('BRA','FRA','GER','ENG','ARG','ESP','NED','ITA'))
or
(COUNTRY_1 not in ('BRA','FRA','GER','ENG','ARG','ESP','NED','ITA') and COUNTRY_2 in ('BRA','FRA','GER','ENG','ARG','ESP','NED','ITA'))
then 'medium'
else 'others' end as team_score
From the point of view of the players, we speared the most famous player by the below code. So players on the below list are labeled famous, and others are labeled ‘others’.
case
when
player like '%Lionel Messi%'
or player like '%Ronaldo%' or player like'%Kylian Mbappe%' or player like '%Zico%'
or player like '%Alex Morgan%' or player like'%Harry Kane%'
or player like '%Cristiano Ronaldo%' or player like'%Marta%'
or player like '%Mohamed Salah%' or player like'%Iker Casillas%' then 'famous'
else 'others' end as player_score
-
Each section contains price changes of mint and secondary NFTs.
\
Introduction:
About FIFA+ Collect
FIFA+ is the entertainment experience from FIFA that is made for the fans. Playing the greatest football documentaries and films, through to live games and highlights, FIFA+ is free and always premium.
Here at FIFA+, we decided that it’s time to share our amazing archive to enable fans to own unforgettable moments and epic editions from the FIFA archives and digital collectibles. So, we launched FIFA+ Collect. A once-in-a-lifetime opportunity to build a personal digital collection and be part of the richest and most authentic football legacy of all time - The FIFA World Cup™.
We want all fans to be able to access and own, collect and trade, to enjoy a new kind of fandom: Official Digital Collectibles.
How do I get involved?
- Create your account and sign up to begin your FIFA+ Collect journey.
- Once you’ve selected your packs and scored your breathtaking moments, view and enjoy the collectibles you have landed, or trade and sell them on the designed FIFA+ Collect marketplace.
- Compete with your collectibles in upcoming quests to win unforgettable rewards and grow your collection even more.
Enjoy, and get ready for the exciting future of FIFA+ Collect, for fans and football.
The road map of FIFA+ Collect
Your collection journey on FIFA+ Collect goes beyond the Genesis and Archives 1 Collections. Over time, you’ll have access to more drops with exhilarating FIFA highlights, new challenges, reward-generating features that will help feed your fandom, and maybe even a few surprises. Never experience FOMO (fear of missing out) - this is the spot to watch if you want to be first to know what to expect from every new drop and feature so that you can curate your most valuable collection.
**Awe-Inspiring Drops (ongoing) -**Want more goals, more saves, and more of the breathtaking moments that made you a fan? Keep building your personal collection with regularly scheduled pack drops with highlights from FIFA’s legendary 90+ year history and the largest footage archive in professional sports. The highlights you win will be crucial in the games you’ll be able to play, so you’ll want to collect them all. Planned drops through the end of the year include: \n
- Curator Collection - South American Flair
- FIFA Archives 2
- Curator Collection - 80s & 90s
- FIFA Archives 3
- Curator Collection - Best of Europe
A New Way to Play the Beautiful Game - You’re building a great collection. Put it to work with games and challenges that can earn you incredible, exclusive rewards.
- Collection Rewards (October 20th) - First up, we’re announcing a special rewards program for the “gotta have it all” fans and our earliest collectors. Check out the Collections page, located under My Collection, to see how many digital collectibles you’ve scored from the Genesis and Archives Collections. Each time you complete a rarity tier, you’ll earn fun rewards that will help you advance your collection or further your fandom (like the newest packs!). The more tiers you complete, the more you earn; the higher the rarity, the bigger the rewards. Collect all you can before the first match kicks off at World Cup Qatar 2022TM to be eligible for rewards, so complete your collections while you can and while these drops last. Cumulative rewards will get delivered by the final match.
- Challenges (mid-November) - Think your collection is the best? Prove it and earn valuable prizes when you compete in and complete themed challenges. Take on other fans and rise the ranks of the leaderboard to win. Each challenge will have specific requirements for completion based on a given theme. You’ll want to put up your most valuable digital collectibles because you’ll also earn points based on quality and rarity. Later this year, the most competitive fans can compete in Prestige Challenges (December). These are similar to Curator Challenges but are timed and will offer even greater rewards. Stay tuned for more details!
Once-in-a-Lifetime Opportunities -
- Own It. Win It. Live It. (late October) - You own the highlights, now experience them live! For fans and collectors who purchase packs between October 27 and November 20, you’ll be automatically entered for a chance to win an exclusive VIP flyaway to attend the FIFA World Cup Qatar 2022™ in person. A select group of winners will each bring a guest for a paid trip with airfare, luxury accommodations, tickets to two quarter- and semi-final matches, welcome gifts, and more. The more packs you buy, the more chances you have to win. You’ve got to own it to live it, so get your packs while you can.
Join the conversation on our official Discord and Twitter channels where you can participate in live AMAs with the FIFA+ Collect team and get first-hand updates on new releases and launch plans.
*This roadmap is subject to change. Any forward-looking statements with regard to releases, release dates, content, and/or feature functionality are for informational purposes only and do not guarantee that the final product/release will not differ materially from what is expressed here.
✅ Observation:
In this section, the NFTs are classified by the "teams"!
All of the teams were divided into three different classes.
The best teams consist of: ('BRA', 'FRA', 'GER', 'ENG', 'ARG', 'ESP', 'NED', 'And ITA')
The " Methodology " section also explains the medium team and others.
As clear in the "Daily number of NFT mint by teams":
The most share of this section is about the "Others" group of teams.
This fact is true based on the "Daily volume of NFT mint by teams" also.
In the maximum record in the "Daily number" (8th October), more than 45K number is about the "Other" group, more than 21K is about the "Medium" class, and 5254 transactions are related to the "Best" group.
In the maximum record in the "Daily volume" (8th October), 74.99 KS is related to the "Other" group of teams, 35.5 K$ is about the "Medium" class, and "Best" teams have 8739.1 $ NFT's sales.
The "Normalized" chart shows that after 20th November, the share of the "Other" class decreased slightly. "Best" and "Medium" classes’ share increased a little.
The cumulative charts approve the above fact. The sharp jump and spike on the 8th of October show a sharp increase in the chart's slope.
In the secondary market:
The "Others" and "Medium" classes are too close in point of "Volume" Both of them consist of the majority share of the secondary market's volume.
The "Best" has the lower share in this diagram.
Clearly, the "Daily number" has three spikes. All of them are in November.
In the greatest one (15th November), the total number of NFT sales is 393. 227 number is about "Medium," 44 number is related to the "Best," and 445 number belongs to the "Others" class.
In the last charts, the average NFT price in the part of "Mint", and "Secondary market" has been shown.
Based on the first chart, the maximum price is related to the "Best" team. The average price of all teams is stable up to the 24th of October.
The correlation of the average price in the "mint" part is better than the "secondary market"
Both charts have risen and then experienced a downward stream.
The maximum drop occurred in the "Best" team in the secondary part.
✅ Observation:
The classification of this bounty information into the "Players" has occurred in this section.
All of the above information was investigated again by the effect of Players on them.
The players are divided into two different classes.
The first is famous players: "Messi, Ronaldo, Kilyan Mbappe, Zico, Alex Morgan, Harry Kane, Cristiano Ronaldo, Marata, Mohamed Salah, and Iker Casillas"
The other players classify into the group of "Others"”
It is interesting that the "Other" class of players has the majority share in terms of "Daily number"” and "Daily volume" is the mint part!
The share of famous players is so low that their contribution can be ignored.
It is approved in the "Cumulative" chart.
But in the "Secondary" part, the story is completely different!
The share of "Famous" players is really significant Vs. "Other" players.
Based on the "Normalized" chart, the share of "Famous" players can reach more than 87% is some days! (11th of December)
But in terms of "Daily number," the majority is the "Other" group, the same as the mint part.
In the last two charts, the average NFT price has been visualized by the players.
The charts show the Mint market and Secondary market.
The average price of "Famous" players and "Other" players meet each other on the 7th of November in the mint market.
The maximum price is at this time, also.
After that, the downward trend starts.
In the Secondary market:
The average price of "Famous" players is always more than the "Other" group, except on the 28th of November.
The fluctuations in price of "Famous" players is too high, from 96.41$ to less than 9$ over time. But the fluctuations of the average price in "Other" players is between 4-38 $
✅ Observation:
The number of NFTs that have never sold on the secondary market is 0.767M.
More than 564.153K of these NFTs belongs to the men's type world cup.
The share of women's type world cup from this metric is 202.598K NFT.
75.5% of these NFTs (578.789K) related to the "GOAL"”
23.6% is also related to the "SAVE" by number 181.037K.
The "SKILL" with 132 NFTs never sold has the lowest rank in this metric.
✅ Observation:
In this section, we represent the "10 first players with the most average price ($)", and the "10 first players with the most total volume ($)"
"Lionel Messi", "Kylian Mbappe", and "Ronaldo" are the top 3 of the first list by 3033.333$, 2372.5$, and 2072.387$, respectively.
But in the second chart, "Ronaldo" has the first rank with 76.67833 K$, "Cristiano Ronaldo" at 66.14739 K$, and "Carli Lloyd" with 56.90968 K$.
Although "Lionel Messi", and "Kylian Mbappe" has the rank 1 and 2 in the first diagram, they haven’t any place in the second chart.
Result and discussion:
All of the questions has been answered and all of the requests visualized in several sections.
There isn't any question without answer.
Also we check some metric beyond the demands of bounty.
All of the results and conclusions explained at the end on each question completely and clearly.
Some of them are as follow:
The number of mint is 50 time more than secondary market!
In term of volume in the secondary market is one third of mint market.
The number of wallets in the mint market is 7 times more than secondary market!
Although at the beginning the "Average number of NFTs" in the secondary market is 20 times more than mint market, but recently this metric in the secondary market dropped to the adjacency of mint market!
Based on the "Rarity" section, the common class is more popular in the mint market but in the secondary market the "Epic" has the most popularity! Also the mint market has stable pattern in this metric in opposite of secondary market!
The "Average price of Iconic class NFTs" in the secondary market is too much in compare of mint market! (more than 1000$ VS 3$ approximately)
The "Goal" is the most popular event in the both market! "Save" event type NFTs has the second rank in the both market.
The fluctuation of the "Average mint price by event type" in the mint market is too much, but the average price of this index in the secondary market is more than mint market!
The class of "Other" teams has the first rank in the mint market, but in the secondary market "Other" class and "medium" class has the most popularity. The average price of NFTs in this metric in the secondary market is more than 3 time of mint market!
Famous players consist a little share in the mint market, but in the secondary market they compose significant part!
✅ Observation:
The "Event type" is another parameter that is checked in this bounty.
This metric has been shown in the "Mint market" and "Secondary market".
Mint market:
In this part, the "Goal" type of NFTs has the majority in terms of "Daily number", and "Daily volume"
The second rank in these two charts belongs to the "Save" type of NFTs.
"Celebration", and "Pass" are the next ones.
Based on the "Normalized" chart, between 70-85% of "Daily volume" is about the "Goal" type. The "Save" has a share between 9-25%.
The cumulative charts show the trend of each type separately.
Secondary market:
Same as the previous part, the "Goal" type has the most share in terms of "Daily number", and "Daily volume"
The second place is dedicated to the "Save" type of NFTs.
The "Tackle" type has a notable share on some days. E.g. more than 6.9% of the total "Daily volume" is related to this type of NFT.
This trend and information are true in the "Daily number" chart, also.
Based on the last two charts:
The "Tackle", and "Celebration" are the most average NFT price in the "Mint market".
Both of them experience a significant drop between 7-24 November, but after that, they compensate their average price and came back to their initial price.
The "Pass" type has a huge jump from 1.63 to 3.33 from 28th November to 5th December!
In the secondary market, the average price of NFT hasn't high changed over time except for "Pass". The average price of "Pass" dropped from 380$ to 1$ from 24th October to 7th November.