Comparison Of NFL All-Day Activity Over The Past Year With This Year’s Thanksgiving Week

Source : Twitter

Bounty Question: The NFL’s annual Thanksgiving games recently drove record viewership in the U.S., with 42 million people tuning in to see the Giants take on the Cowboys. Did FLOW NFT project NFL ALL DAY see similar boosts in popularity? Create a dashboard that analyzes NFL ALL DAY NFT activity over the past week, and compares it to activity over the past year. Include at least these metrics, along with any others you find notable or interesting:

  • Sales volume (daily)
  • Total Sales Volume
  • Daily Average Sales Price and 7-day moving average
  • Total Unique Buyers
  • Average Buyers/Day

Introduction

AFC (American Football Conference) and NFC (National Football Conference) are the two divisions of the National Football League (NFL), which has 32 teams in total. American football’s highest professional level is played in the NFL, one of North America’s major professional sports leagues. A NFL regular season lasts 18 weeks, with teams playing 17 games and having one bye week per team. The season begins in August with a three-week preseason, followed by an 18-week regular season. After the end of the regular season, seven teams from each conference (four division winners and three wild cards) advance to the playoffs, a single-elimination tournament culminating in the Super Bowl, where the AFC and the NFC conference champions compete for the championship in February. New York City is the league’s headquarters.

What is NFL All Day?

The NFL ALL DAY platform will allow users to collect Moment NFTs from their favorite NFL teams through the Dapper platform. Officially licensed NFL video highlights are available as part of A Moment. Moments come in various types, tiers, and series, with unique digital serial numbers that verify authenticity and ownership history. They also indicate a player’s first-ever All Day Moment, for example. The All Day Marketplace values certain serial numbers more than others – such as those from early sets, those from the final set, and those from the particular player’s jersey. Moments are held like investments or sold in the peer-to-peer marketplace once purchased. Competitions in the coming months will allow you to win prizes using them. The NFL All Day marketplace connects like-minded football fans from around the world through the exchange of video highlights in the form of NFTs. As the NFT market rose to prominence in early 2021, Dapper’s NBA Top Shot platform, which has a similar approach, entered the mainstream. Using existing video highlights and limited editions, both platforms create digital collectibles based on video highlights from their respective leagues.

Here from the below tweet we can see the feast of NFL All day has begun on Nov 24,2022.

From the below picture, we can see the details of the Thanksgiving Challenge : NFLChallenge page

Source : Image

Approach

In this dashboard, we analyze NFL ALL DAY NFT activity during the Thanksgiving week, a week before Thanksgiving, a week after Thanksgiving, as well as compare it to activity over the past year. As a result of taking their different metrics into consideration

  • Buyers – Total Unique , A Week Before , A Week After and Thanksgiving Week
  • Sellers – Total Unique , A Week Before , A Week After and Thanksgiving Week
  • Sales Transactions – Total , A Week Before , A Week After and Thanksgiving Week
  • Sales Volume – Total , A Week Before , A Week After and Thanksgiving Week
  • Avg. NFT Sale Price – For Past One Year , A Week Before , A Week After and Thanksgiving Week 
  • Lastly, we can see the maximum, minimum, and median NFT sale price on a week before, after, and just during Thanksgiving week.

Observations

As we can see from the above analysis, we can compare the activity over the past year for the NFL ALL DAY NFT and see how it compares with the activity during Thanksgiving.

  • We see that the number of buyers is higher in the week of Thanksgiving week as compared to the week before and after Thanksgiving.
  • According to the above analysis, we can see a maximum number of buyers during Sept 2022 when compared to the whole year. Therefore, we can say that when the NFL started on Sept 1st, 2022, there were more buyers than during Thanksgiving.
  • Compared to the weeks after and before Thanksgiving, there are more sellers in the Thanksgiving week. In addition, we can see that the number of sellers is declining after Thanksgiving week.
  • Thanksgiving did not show any big differences in seller numbers compared to previous years’ data. As a result of the volatility in the cryptocurrency market, we can also say the number of sellers has decreased.
  • When compared with Thanksgiving week and after Thanksgiving week, the number of sales transactions was higher in the week before Thanksgiving.
  • Compared to the past year’s sales with the Thanksgiving week sales, we didn’t see much improvement in sales. Moreover, we can see that sales increased suddenly at the beginning of the NFL season. It took place in September 2022. 
  • From the above analysis, we can also see that the sales volume is greater than during the Thanksgiving week and after the Thanksgiving week.
  •  During the first few weeks of the NFL, which is September 2022, there is a sudden surge in sales.
  • Initially, you can see the maximum sales volume for the past year. The market is experiencing a bear market, which is causing a decrease in sales volume.
  • According to the above analysis, the average NFT sale price was lower during the Thanksgiving week when compared with before and after Thanksgiving.
  • Based on the past one year data, the average NFT sale price has decreased.
  • The average sale price of NFTs in the past year was 36. During Thanksgiving, however, it decreased by almost half. Cryptocurrency is experiencing a bearish situation, which we can attribute to the bearish situation in the market. 
  • Based on the above analysis, we can see that the maximum NFT sale price is 9500. In comparison, before and during the week of Thanksgiving, it was almost three times higher.
  • From the above analysis, we can conclude that sales volume, sellers, and buyers will be high during the beginning of the NFL in September 2022. During the Thanksgiving holiday, the number of sellers, buyers, and sales volume does not seem to have increased much in comparison to the start of the NFL.

Reference Query

WITH nft_sales as (
SELECT  
  *,
  sales.block_timestamp::date  as date, 
  case
  	when date  between '2022-11-14' and '2022-11-21' then 'A Week Before Thanksgiving Week'  
  	when date  between '2022-11-21' and '2022-11-28' then 'Thanksgiving Week'  
  	when date between '2022-11-28' and '2022-12-05' then 'A Week After Thanksgiving Week'  
  	else 'Others'
  end time_period
FROM flow.core.ez_nft_sales sales
INNER JOIN flow.core.dim_allday_metadata USING(NFT_ID, NFT_COLLECTION)
WHERE sales.block_timestamp >= '2021-11-18'
  	and TX_SUCCEEDED
),
overall as (
  SELECT 
  	SUM(price) as tot_sales_volume,
  	count(distinct buyer) as uniq_buyers,
  	count(distinct seller) as uniq_sellers,
  	count(distinct TX_ID) as uniq_sales
  FROM nft_sales
)
SELECT * FROM overall
----------
WITH nft_sales as (
SELECT  
  *,
  sales.block_timestamp::date  as date, 
  case
  	when date  between '2022-11-14' and '2022-11-21' then 'A Week Before Thanksgiving Week'  
  	when date  between '2022-11-21' and '2022-11-28' then 'Thanksgiving Week'  
  	when date between '2022-11-28' and '2022-12-05' then 'A Week After Thanksgiving Week'  
  	else 'Others'
  end time_period
FROM flow.core.ez_nft_sales sales
INNER JOIN flow.core.dim_allday_metadata USING(NFT_ID, NFT_COLLECTION)
WHERE sales.block_timestamp >= '2021-11-18'
  and TX_SUCCEEDED
)
SELECT 
  	date, 
  	count(tx_id) as sale_txns,
  	count(distinct seller) as sellers,
  	count(distinct buyer) as buyers,
	sum(price) as sales_vol_flow,
  	avg(price) as avg_sale_price_flow
FROM nft_sales
GROUP BY 1
-----------
WITH nft_sales as (
SELECT  
  *,
  sales.block_timestamp::date  as date, 
  case
  	when date  between '2022-11-14' and '2022-11-21' then 'A Week Before Thanksgiving Week'  
  	when date  between '2022-11-21' and '2022-11-28' then 'Thanksgiving Week'  
  	when date between '2022-11-28' and '2022-12-05' then 'A Week After Thanksgiving Week'  
  	else 'Others'
  end time_period
FROM flow.core.ez_nft_sales sales
INNER JOIN flow.core.dim_allday_metadata USING(NFT_ID, NFT_COLLECTION)
WHERE sales.block_timestamp >= '2021-11-18'
  	and TX_SUCCEEDED
),
overall as (
  SELECT 
  	time_period,
  	SUM(price) as tot_sales_volume,
  	count(distinct buyer) as uniq_buyers,
  	count(distinct seller) as uniq_sellers,
  	count(distinct TX_ID) as uniq_sales,
  	avg(price) as avg_sale_price,
  	median(price) as med_sale_price,
  	min(price) as min_sale_price,
  	max(price) as max_sale_price
  FROM nft_sales
  WHERE time_period !='Others'
  GROUP BY time_period
)
SELECT * FROM overall