observations

• As we can see in the total data graph, on Thanksgiving Day and after, until now, the sales volume has been more than $650,000, during this volume, more than 35,000 NFTs from the NFL collection have been sold and these transactions have been done by about 5,000 NFT traders with more than 40,000 buying and selling times in the Flow ecosystem.
• According to the daily average chart, the sales volume during the last year is about 5 times compared to the days after Thanksgiving, and 4 other daily average data during the last year is about 2 times compared to the days after Thanksgiving, for example, in the days after Thanksgiving, the daily average NFTs sold is about 3,200 tokens and during the last year this amount was about 6,500 tokens.
• According to the graph of the statistical data related to the sales volume, it can be said that the average and median sales volume during the last year is about 2 times compared to the days after Thanksgiving, and the only common data between the two times is the floor price, which is $1.

observations

According to the 2 graphs on the left, which show the daily sales volume and the average daily sales volume with a 7-day moving average, it can be said that the downward trend in sales volume that started on September 12 continues, and it must be said that Thanksgiving Day also failed to do so. The only effect that can be seen is the breaking of the 7-day moving average chart on December 1, on which the average sales reached more than $27. On the day of the games, the sales volume of NFL collectible tokens reached more than $68,000.

Introduction

The NFL's annual Thanksgiving tripleheader returns for the 2022 regular season and features three playoff squads from a season ago, including a pair of division champions. Here's everything you need to know about this year's three NFL games on Thanksgiving Day:

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.

• for more info Visit here

Dashboard Purpose

The purpose of creating this dashboard is to review NFL league games on Thanksgiving Day, and the impact of these games on the sale of NFTs related to the NFL ALL DAY collection. We are going to compare the sales of the NFL ALL DAY collection after theThanksgiving Day games with the sales of NFTs of this collection during the last year. We are going to provide data such as daily and total sales volume as well as daily average sales and average number of buyers as well as total number of buyers and other data related to the volume and number of NFL ALL DAYcollection NFTs.

Methodology

We have divided this dashboard into 3 general sections, in the first section we will provide general statistics of NFT sales before and after the Thanksgiving Day games, and in the second section, we will examine the sales volume from different dimensions, and in the third section, We will explore the number of NFTs sold at two different times, before and after the Thanksgiving Day games.

In this dashboard, we used the flow.core.ez_nft_sales table as the main database and used the flow.core.dim_allday_metadata table to call the teams and players. In this dashboard, we tried to track volume data and number data for the times before and after Thanksgiving and compare them in 2 sections.

DapperUtilityCoin is the currency used to buy NFL ALL DAY collection NFTs.

Part I - General Statistics

In this section, we will present the general data related to sales, in 2 different times, which are related to before and after the Thanksgiving Day games.

Part II - Volumetric Data

In this section, using sales volume visualizations, we will examine the volume data in 2 times before and after the Thanksgiving Day games.

• Daily Volume Stats

• Distribution of Sales Volume

observations

• According to the above monthly and total volume distribution charts, the downward trend of the sales volume is visible after September based on 4 data, the number of sales, the number of buyers, the number of sellers, and the number of tokens sold.
• The total sales volume data based on the number of purchases shows that on Thanksgiving Day and after that, the number of sales transactions with a price below 10 dollars has increased by more than 25%.
• The total sales volume data based on the number of buyers shows that on Thanksgiving Day and after that, the number of buyers of tokens with a price between $10 and $50 has increased by about 10%, and the number of buyers of tokens with a price of less than $10 has also increased by 15%.
• Total sales volume data based on the number of sellers shows that on Thanksgiving Day and after, the number of sellers of tokens with a price between 10 and 50 dollars has increased by about 10%, and the number of sellers of tokens with a price of less than 10 dollars has also increased by 18%.
• Total sales volume data based on the number of traded tokens shows that on Thanksgiving Day and after, the number of trading tokens with a price below 10 dollars has increased by about 25%.

• Top 10 Buyer Behavior

We answer these questions using the following visualizations:

• What are the top 10 buyers before and after Thanksgiving day by volume?

• What are the top 10 teams bought by the top 10 buyers?

• What percentage of the teams purchased by the top 10 buyers belong to teams that played on Thanksgiving Day?

observations

• As we can see, the address 0xfb34edeab0448ef3 with the purchase of 30 tokens and with a purchase volume of more than $22,000 is the top buyer after Thanksgiving day. After that, the address 0x4b7ad060d826fba2 is in the next category with the purchase of more than 900 tokens at a price of more than $7,800. As we can see, the same address also bought the most tokens.

• During the last year and before the Thanksgiving Day games, the address 0xc4719ab3f4c3db69 has been the top buyer of NFL collection tokens with the purchase of more than 2,900 tokens and with a volume of more than $960,000, after that the address 0xed8707e2ae5bba5a has bought about $500,000 and About 4,800 tokens are in the next category.

• It is noteworthy that none of the top 10 buyers before the Thanksgiving Day games are part of the top 10 buyers after the Thanksgiving games.

• Of the top 10 teams acquired by the top 10 buyers after Thanksgiving games, 4 belong to teams that played on Thanksgiving

  Which include : Detroit Lions Buffalo Bills Dallas Cowboys Minnesota Vikings

  About $10,000 worth of tokens from these 4 teams were purchased by the top 10 buyers by volume in the days after Thanksgiving.

• Of the 6 teams that played on Thanksgiving, there are 2 in the top 10 before Thanksgiving day: Buffalo Bills & Dallas Cowboys

• In the days after Thanksgiving, more than 17% of the teams purchased by the top 10 buyers belong to teams that played on this day.

• During the last year, the purchase amount of the top 10 buyers from these teams was around the same, and the amount increased very little in the days after Thanksgiving.

• Top 10 Seller Behavior
• We answer these questions using the following visualizations:

  • What are the top 10 sellers before and after Thanksgiving day by volume?

  • What are the top 10 teams sold by the top 10 sellers?

  • What percentage of the teams sold by the top 10 sellers belong to teams that played on Thanksgiving Day?

observations

• As we can see, the address 0x22dffc87d5f619f5 is in the first rank with the sale of about $12,000 and 25 NFT, and in the second rank is the address 0x228b964ad9dfbea3 with the sale of 5 tokens and the sales volume more than $9,000.

• The address 0xed8707e2ae5bba5a, which is in the second category of the best buyers during the last year, has the first place in the list of the best sellers during the last year. This address is in the first category of sellers with sales of more than $370,000 and more than 3,000 tokens.

• And the address 0xc4719ab3f4c3db69, which was the first place in the list of top 10 buyers of last year, is in the second place in the list of top sellers of last year. This address has sold more than 11,000 tokens at a price of more than $230,000.

• The address 0xed8707e2ae5bba5a is one of the top sellers in the days after Thanksgiving and is in the third place with sales of more than $7,000.

• As we can see, 2 of the teams that played on Thanksgiving are in the top 10 teams sold by top 10 sellers Dallas Cowboys & Minnesota Vikings

  These 2 teams were among the top 10 teams sold by the top 10 sellers last year.

• As we can see, a little more than 15% of the tokens sold by the top 10 sellers belong to teams that played on Thanksgiving Day, which is an increase of about 3% compared to last year.

  \

• Top 10 Teams and Their Sales Volume

observations

• As we can see, 4 teams Detroit Lions, Buffalo Bills, Dallas Cowboys, Minnesota Vikings who played on Thanksgiving Day are in the first to Fourth place, the top 10 most traded teams, these 4 teams were the most traded teams with a transaction volume of about $180,000 and a trade of more than 8,000 tokens in the days after Thanksgiving.
• As we can see, the Dallas Cowboys and the Buffalo Bills have been among the most traded teams in the past year.
• According to the weekly chart of the top 10 teams, we can see that in November, the transactions of teams that played on Thanksgiving Day increased.
• On Thanksgiving Day and the day after that (November 25), the significant increase in the trade of Thanksgiving teams is clearly visible. On November 24, the Detroit Lions are at the top with more than $16,000 in transactions, and on November 25, the Minnesota Vikings are in second place with more than $12,000 in transactions.

Total Share of Sales Volume Before and After Thanksgiving Day

The following 2 graphs answer the question: What percentage of NFL ALL DAY Team trades before and after Thanksgiving day ,belonged to teams that played on this day?

observations

As we can see, after Thanksgiving, more than 35% of the purchase volume of NFL ALL DAY collection teams belongs to the teams that played on this day, and during the last year, these teams had more than 16% of the sales volume.

Part III - Number data

In this section, we will check the trading of tokens related to the NFL collection based on the number.

We plan to check data such as the number of buyers and sellers, the number of tokens traded, etc. before and after Thanksgiving day.

• Daily Count Stats

  The daily visualizations below compare the number data for buyers and sellers, the number of tokens traded, and the number of NFL ALL DAY collection tokens traded on and after Thanksgiving Day with the day before.

• Number distribution

observations of daily stats

• According to the daily graphs, we can see a very slight jump in the number of buyers and sellers on November 24 and 25, which is Thanksgiving Day and the day after, and also on November 29, a small jump in the number of traders can be seen.
• It can be said that on November 29, the number of traded tokens and the number of transactions had a slight jump.
• Over the past year and before Thanksgiving, September 12th has been a good day for the NFL ALL DAY collection trading market, with about 9,000 traders trading more than 33,000 tokens in more than 37,000 trades.

observations of distribution

• According to the number distribution charts in the days after Thanksgiving, 1,350 unique buyers have purchased at least 1 token, which was about 9,500 buyers during the last year and before Thanksgiving.
• The number of sellers who sold at least 1 token after Thanksgiving is more than the number of buyers and there are more than 2,500 unique addresses, this number was more than 5,800 addresses during the last year.
• During the last year, the number of buy transactions for at least 1 token was more than the number of sales transactions, but in the days after Thanksgiving, the number of sales transactions for at least 1 token is more than the buy transactions.

Top 10 Buyer Behavior

• We answer these questions using the following visualizations:

  • What are the top 10 sellers before and after Thanksgiving day by NFT count?

  • What are the top 10 teams sold by the top 10 sellers?

  • What percentage of the teams sold by the top 10 sellers belong to teams that played on Thanksgiving Day?

observations

• As we can see, the address 0x4b7ad060d826fba2 is in the first rank of top buyers with the purchase of 920 tokens. Based on the purchase volume, this address is also in the second rank after Thanksgiving day, it bought more than $7,800 of tokens.
• During the last year and before Thanksgiving Day, Address 0x84c9fe7ef49285fb is in the first rank of the top 10 buyers in terms of the number of tokens purchased, with the purchase of more than 6,600 tokens equivalent to more than $142,000.
• Among the top 10 teams purchased by the top 10 buyers after Thanksgiving Day, Detroit Lions is in the first place, which is one of the teams that organizes the Thanksgiving game. 2 other teams, the Dallas Cowboys and the Buffalo Bills, are also among the top 10 tokens purchased by Top buyers by number of tokens purchased.
• Among the top 10 teams purchased by the top 10 buyers before thanksgiving day, there are 2 teams Detroit Lions and Buffalo Bills.
• More than 23% of the teams that bought the top 10 buyers in the days after Thanksgiving belonged to the teams that played on Thanksgiving Day, and the share of these teams was about 18% of the top 10 buyers bought before Thanksgiving.

• Top 10 Seller Behavior
• We answer these questions using the following visualizations:

  • What are the top 10 sellers before and after Thanksgiving day by NFT count?

  • What are the top 10 teams sold by the top 10 sellers?

  • What percentage of the teams sold by the top 10 sellers belong to teams that played on Thanksgiving Day?

observations

• After Thanksgiving, the address 0xffee4f34acfc3ea6 is the top seller with 434 tokens sold. This address has sold more than 3,500 dollars of tokens, and before Thanksgiving and during the last year, the address 0x84c9fe7ef49285fb is in the first place with 6,690 tokens sold, and the best seller belongs to the days after Thanksgiving (0xffee4f34acfc3ea6) is in second place and has sold 6,478 tokens.

• The Detroit Lions and Dallas Cowboys are among the top 10 tokens sold by the top 10 sellers in the days after Thanksgiving, with 119 tokens sold.

• The number of tokens purchased by the top 10 buyers is more than the number of tokens sold by the top 10 sellers.

• Among the top 10 teams sold over the past years are the Detroit Lions and the Buffalo Bills.

• More than 21% of tokens sold by the top 10 sellers after Thanksgiving day belonged to teams that played on that day, compared to 18% last year.

Top 10 Team and Their Sold Token Count

observations

• Based on the number of tokens traded after the Thanksgiving Day games, New England Patriots is also in the list of top 10 teams in terms of the number of tokens sold, as we can see, in the days close to the Thanksgiving games, this team is in the second place of the 10 most traded teams and on 25 November has reached the first position.
• Until almost the end of November, Thanksgiving Day teams have been among the most traded tokens in NFL collection.

Total Share of Token sold Before and After Thanksgiving Day

The following 2 graphs answer the question: What percentage of NFL ALL DAY Team trades before and after Thanksgiving day ,belonged to teams that played on this day?

observations

As we can see, more than 31% of the teams traded after the Thanksgiving Day games belong to the teams that played on this day, and before these games, the share of these teams was about 18%.

Top 10 Players Based on Sale Volume

observations

• On Thanksgiving Day and after that, New England Patriots player Mac Jones ranks second in the top 10 players with 1,110 tokens traded and and about $28,000 in sales volume , and Tom Brady is in first place, as was the case last year.

• On November 25, about $13,000 have been traded from this player.

Top 10 Players and Their Sold Token count

observations

Before and after the Thanksgiving Day games, Mac Jones, New England Patriots player has the most traded tokens. On November 25, about 550 tokens were traded from this player.

conclusion

In general, it should be said that the Thanksgiving Day games did not have a great impact on the volume of sales and the number of tokens traded, however, the teams that played on Thanksgiving Day had an impact on the volume of transactions and the number of tokens sold by these teams in the NFL collection. The percentage of transactions after Thanksgiving in terms of volume and number of tokens, as well as the volume of transactions of teams and players like Mac Jones, shows this effect.