📝 Introduction

🟡 Flow

Flow is a fast, decentralized and developer-friendly blockchain, purposely built to support decentralized apps (DApps), games and the digital assets they run on.[1]

Flow is becoming more permissionless! Flow’s long-term vision is to optimize for security and scalability and move toward decentralization over time.[2]

🟡 NFT

An NFT is a one-of-a-kind, non-fungible, cryptographic token representing a unique digital asset for which there is no copy or substitute. An NFT cannot be substituted for another NFT as each NFT is distinctive and unique in some way. An NFT is not a medium of exchange and is not convertible virtual currency.[3]

🟡 NFL ALL DAY

NFL ALL DAY is where fans come to buy, sell, and play for officially licensed NFL video collectibles.[4]

NFL ALL DAY is the newest Dapper platform in conjunction with the NFL and NFLPA that will allow users to collect Moment™ NFTs from their favorite NFL teams.

Through the partnership between the NFL, NFLPA, and Dapper Labs, team will be bringing users Moments from the NFL's past and present. Collectors will have the opportunity to collect epic Moments that span across decades of play. 

Moments are Online Digital Collectibles, or NFTs, of a player's highlight. [5]

✍🏻 Methodology

In this dashboard, the following tables are used to extract data:

• flow.core.ez_nft_sales → This table is used to find information such as the number of buyers, the number of sellers, the number of sales, the number of NFTs, and the sales volume.
• flow.core.dim_allday_metadata → This table is used to get information about NFTs.
• flow.core.fact_prices → To get the sales volume in USD, we joined this table with the previous tables

📃 Purposes of dashboard

In this dashboard we analyzed NFL ALL DAY NFT activity over the past weeks, and compares it to activity over the past year. Some of the most important metrics used in this dashboard are:

• Sales volume (daily)

• Total Sales Volume

• Daily Average Sales Price and 7-day moving average

• Total Unique Buyers

• Average Buyers/Day

  \

The time frames considered in this dashboard are:

• date='2022-11-24' → 'Thanksgiving Day'

• date>='2022-11-17' and date<='2022-11-23' → 'A Week Before Thanksgiving'

• date>='2022-11-25' → 'After Thanksgiving'

• date>='2022-11-01' and date<='2022-11-16' → 'Other Days of November'

  and other days … \n

General comparison

NFL ALL DAY NFT activity from November onwards

• On other days of November and specifically on November 5th and 9th, the average number of nfts sold by each seller reached its maximum amount of 5 NFTs. Meanwhile, this amount for Thanksgiving was the same as most days in November, i.e. 2 NFTs per seller. Meanwhile, in some days leading up to a week before Thanksgiving, the average number of NFTs purchased by each buyer also reached 5 NFTs.
• In general, the average number of NFTs sold by each seller on Thanksgiving was lower than on other days (other categories).
• In general, in all time groups, the average number of NFTs bought by buyers is more than the number of NFTs sold by sellers.

• From the beginning of November until Thanksgiving day, the average sales volume per seller had a downward trend, while after Thanksgiving, the chart trend changed little.
• The average trading volume of NFTs was higher the week before Thanksgiving than the week after Thanksgiving.
• The average purchase volume per user on thanksgiving day was higher than the average sales volume per user.
• A long-term downward trend from March 2022 can be seen in the average purchase volume per buyer chart. This downward trend can be caused by the conditions prevailing in the crypto market.
• The average volume of buying and selling of NFTs per user in the first half of November was higher than the second half of November. (almost double)

• The average number of transactions per seller a week before Thanksgiving is more than after Thanksgiving day. (7 vs. 6)
• On some days of the first half of November==, the average number of transactions per seller has reached 5 transactions. Meanwhile, the number of transactions of each buyer in the second half of November has reached 5 transactions in 5 days.
• The average number of transactions per seller on thanksgiving day is equal to 2 transactions. While this amount was equal to 3 transactions for each buyer.
• In general, the average number of transactions of buyers in all the categories presented for days is more than the number of transactions of sellers.

• The average price of each NFT on Thanksgiving was around $16 USD. This amount was higher than a week before Thanksgiving and the days after Thanksgiving.
• On average, NFTs sold on March 19, 2022 recorded the highest price ($95 USD). Meanwhile, in the days after Thanksgiving, the average price of each NFT was approximately $15.9 USD.
• The minimum NFT price traded on Thanksgiving Day was $2 USD.
• The maximum traded NFT price was recorded on March 19. (65k USD)
• The highest traded NFT price on Thanksgiving Day was $999 USD.
• The highest traded NFT price in November was $10k USD.

• From mid-September onwards, the number of NFTs sold per day has been decreasing. Since the beginning of November, almost most of the time, the chart related to the number of NFTs sold has been below the 7-day moving average chart.
• The sales volume of NFTs on Thanksgiving Day was about $68.45k USD.
• The number of unique buyers and sellers has been declining since mid-September. However, the chart for the number of unique buyers and sellers has changed little since the week before Thanksgiving. (weak upward trend)

• About 87.7% of the total number of sales transactions were for "Common" NFTs. About 12% of sales transactions were related to "Rare" NFTs. Legendary NFTs only account for 0.3% of the total number of sales transactions. Contrary to the fact that the largest number of sales transactions are related to Common NFTs, the largest volume of sales of NFTs is related to Rare NFTs.

• Kansas City Chiefs NFTs had the most unique buyers and sellers.

• Travis Kelce's NFTs had the most sales volume in November.

• Player-related NFTs labeled N/A had the most sales volume in November.

  \

💡 Conclusion

In this dashboard we analyzed NFL ALL DAY NFT activity over the past weeks, and compares it to activity over the past year.

Some of the most important results obtained in this dashboard are:

• The volume of NFTs sold, the number of NFTs sold, and the number of NFL AllDay buyers and sellers have been on a downward trend since mid-September.

• Detroit Lions and Kansas City Chiefs NFTs performed best in terms of sales count and sales volume in November.

• On Thanksgiving Day, there were no significant changes in metrics such as the volume and number of sales of NFL AllDay NFTs.

  \n

Analyst: Emanoel

***Twitter: ***

Discord: Eman#9698

\n

Special thanks to the Flipsidecrypto 🧡