Overview 👀 ~ 5 min read

In this dashboard, I will answer this question from Flipside Crypto:

LaLiga Golazos has entered the arena! LaLiga is Dapper Labs latest marketplace for digital moments of players; this past month, Dapper dropped the first LaLiga packs and opened up the secondary marketplace. \n

For this round, create an analysis looking at LaLiga’s first few weeks of action, comparing against the first few weeks of other Flow darlings like NBA TopShot & NFL All Day, as well as Algorand’s FIFA Collect+. How does La Liga compare in terms of overall sales on pack drops? What about on the secondary marketplace? How many users participated in LaLiga in its first few weeks compared to other relevant marketplaces?

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

What is NBA Topshot?

NBA Top Shot allows users to buy, sell, and collect NBA NFTs that showcase influential “Moments” minted on the FLOW blockchain. Some Moments are rarer than others, but the rarest versions are worth the most. Moments are minted in “Packs,” much like you'd expect from physical trading cards.

What is FIFA+?

FIFA+ Collect is a new platform allowing fans to own and collect FIFA World Cup™ and FIFA Women's World Cup™ moments. FIFA+ Collect will be available later this month and is affordable, inclusive and accessible to all football fans.

What is LaLiga Golazos ?

LaLiga and Dapper Labs have launched 'Golazos', an official non-fungible token (NFT) platform for digital video collectibles based on iconic moments from Spanish soccer's top flight. The platform allows fans to buy and sell NFTs consisting of officially licensed footage involving LaLiga players and teams

Methodology 🧠

LaLiga Golazos

==transaction for example :==

2531814c53fdd8d952069939ad100ff053b946541040d685ab882f0d204fd1d3 -- Eterno Rival pack

d7e508a23ef62039ff1070f49a43bfa6a51384ab51056ce8309af56c828b7316 -- World Stars $199.99

ee4b9be454761e28d002b9978022750b165b1419d7c4cfc71f33ea69a77b08f3 -- World Stars $49.99

To get this data for Golazos I used flow.core.fact_events table contract 0x87ca73a41bb50ad5 is related to Golazos NFTs but I needed this contract to get pack information 'A.87ca73a41bb50ad5.PackNFT' when I checked all transactions They all had one thing in common, which was from this address: 0xead892083b3e2c6c, the cost of the packs was paid, and I was able to find the costs with 2 CTEs. I was able to get the names of the sold packs from the prices paid and reading the site and discord announcements

NBA Topshot

==transaction for example :==

767a2f70608ff63716cbc28f783e955ec605bc0ac7a66eb72bd218bd028260fd

To get this data for Topshot, I used the flow.core.fact_events table. The contract 'A.0b2a3299cc857e29.TopShot' is related to Topshot's NFTs, but I used '0xe1f2a091f7bb5245' to get information about the packs and separate them from secondary sales. This address is related to the TopshotAdminReceiver that sends the packs to the people who buy them But the main problem is that I reset almost 90% of flowscan to find out how much users have spent to buy these packs. But unfortunately, after 1 full day of searching, I couldn't find anything that I could follow up on the tables. Only one way came to my mind, but I was not very sure The solution was to match the approximate time of the drop packs and the number of NFTs in each pack with transactions that are in the same interval with the same number of NFTs. I was able to do this for 3 drops named

HUSTLE_AND_SHOW_PACKS, THROWDOWNS_PACKS and PREMIUM_PACKS. But the problem was that I wanted the first weeks and these 3 packs were not among the packs that were in the first weeks.

I was able to get this information about the drops from the Topshot blog, but I could not get the information about the initial packs. That's why I forgot this method for this question

NFL All Day

==transaction for example :==

e11734e98ebb5d7b054b927794174ccacfea33e2af97d15cef0a7db0e426178c

The situation was much worse for NFL All Day than Topshot because all the packs were sent to people in the form of 1 transaction :| Even on the site, there was no section for previous drops! For this reason, the solution that came to my mind was to consider the people who open their packs and I included event_type = 'Opened' and from the contracts

('A.b715b81853fef53f.PackNFT', 'A. e4cf4bdc1751c65d.PackNFT')

which are both for All Day packs.

!!!

event_type in ('MomentMinted','MomentNFTMinted') are related to uploading packs on the site, not related to selling packs

!!!

FIFA+

Fortunately, thanks to the new tables algorand.nft.ez_nft_sales_fifa, the work became much easier for Fifa, and the whole problem was that the sales were not recorded as a pack, and if the pack had 3 NFTs, it was recorded in table 3 TX_GROUP_ID To solve this problem, I used the command

listagg(DISTINCT nft_asset_id, ',') within GROUP (ORDER BY nft_asset_id ASC) AS nft_ids

so that I can pack nfts in 1 row. The next point is that I checked the Fifa site, all the packs had 3 nft, for this reason I limited the answers to the packs that had 3 nft with the command ARRAY_SIZE(split(nft_ids,',')) = 3

All these efforts were made so that the information I give to the user is correct

All my focus was on the correctness of the data ❤

Some Notes 📝

The format of the dashboard is parametric and all the information and charts change by changing the parameters
All the parameters are set based on the first 5 weeks of each platform, and by changing the parameters, the descriptions may no longer be suitable for the charts.
Another point is that the queries are heavy, if you exceed the parameters, it may take several minutes

Chart & Analyze 🧪📊

🕵️‍♀️ observations

Observations show that in terms of the number of minted packs, FIFA has a relatively high advantage in its early days compared to other platforms.
- Maybe the 2022 World Cup had a great impact on this
LaLiga also sold more packs in the first week than the NFL and NBA
LaLiga seems to have dropped in the first 3 weeks, but nevertheless, the number of users that LaLiga collected in 3 weeks is more than the number of careers that the NBA collected in 5 weeks.
The total number of users who participated in the LaLiga drop is 3.16k

🕵️‍♀️ observations

But about LaLiga drops: 4 drops have been done so far, one of which was standard packs
Among the drops of World Stars, one of them has a supply of 4000 and another one has a supply of 1000, which means that the mintage of 1000 is sold out.
1630 packs have been burned from another World Stars with 4000 supply

🕵️‍♀️ observations

In the first week of the second sale, LaLiga had the second highest sale, but because it was sold in relation to fewer packs, this sale did not grow in the following weeks.
In terms of the volume of second sales, the NFL has the most expensive ($160) second sales.
From Week 3, the NFL has seen a remarkable increase in sales and sales numbers, but has declined in subsequent weeks

🕵️‍♀️ observations

The NFL price floor was $80 in the first week, but it has reached $1 in the following 4 weeks
- But LaLiga was $1 in the first week and reached $5 in the second week. If the sales reached the third week, we would definitely see a high price floor.
The number of packs dropped by LaLiga was low, making it more valuable than the NFL, and few people were willing to sell.

Conclusion 🎉

How does LaLiga compare in terms of overall sales on pack drops?
- LaLiga put the least number of packs for sale among the competitors and in almost 2 weeks 3.16k users bought 5.91k LaLiga packs.
- LaLiga also sold more packs in the first week than the NFL and NBA
The number of packs dropped by LaLiga was low, making it more valuable than the NFL, and few people were willing to sell.
- A total of 670 people participated in the second sale and registered 2,775 transactions .
  
  \

Contact data 👋

-> the writer :sajjadsmoke -> discord : Sajjadiii#5567

Thanks for reading !

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