Site icon Tech Dreams

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

Kavitha Kavitha
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:

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

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.

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
Exit mobile version