Questions

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

What is NFL?

NFL All Day is similar in approach to Dapper's NBA Top Shot platform, which erupted into the mainstream in early 2021 as the NFT market rose to prominence. Both platforms take existing video highlights from each respective league and turn them into digital collectibles, each limited to a certain number of editions.

The National Football League (NFL), the NFL Players Association (NFLPA), and Dapper Labs Inc. today announced that NFL ALL DAY -- the exclusive digital video highlight NFT platform -- is officially open and available to fans worldwide, just ahead of the 2022 NFL season.

The NFL is one of the major professional sports leagues in the United States and Canada and the highest professional level of American football in the world.

Methodology

from flow.core.ez_nft_sales 
from flow.core.dim_allday_metadata

case when date < '2022-11-25' then 'Pre Thanksgiving'
when date = '2022-11-25' then 'During Thanksgiving'
when date > '2022-11-25' then 'After Thanksgiving' 

Sources

Twitter : hadi3_bgh

Discord : hadiseb#1688

NFL ALL DAY NFT activity over the past week

Total Transaction

• The total number of transaction on Thanksgiving day was about 9.21K.
• The highest number of transaction, the week before thanksgiving day, was about 20.89K on November 18th.
• The lowest number of transaction, the week before thanksgiving day, was 7984 on November 22nd.
• The highest number of transaction, the week after thanksgiving day, was about 10.49K on November 29th.
• The lowest number of transaction, the week after thanksgiving day, was 5472 on November 26th.

Total Buyer

• The total number of buyer on Thanksgiving day was 2530
• The highest number of buyer , the week before thanksgiving day, was 8786 on November 18th.
• The lowest number of buyer , the week before thanksgiving day, was 1617 on November 23rd.
• The highest number of buyer , the week after thanksgiving day, was 2665 on November 29th.
• The lowest number of buyer , the week after thanksgiving day, was 1222 on November 26th.

Total Seller

• The total number of seller on Thanksgiving day was 2960.
• The highest number of seller , the week before thanksgiving day, was 3051 on November 19th.
• The lowest number of seller , the week before thanksgiving day, was 1617 on November 23rd.
• The highest number of seller , the week after thanksgiving day, was 2665 on November 29th.
• The lowest number of seller , the week after thanksgiving day, was 1222 on November 26th.

Total Volume

• The total USD volume on thanksgiving day was about 145.2K.
• The minimum of USD volume on thanksgiving day was about 0.2.
• The maximum of USD volume on thanksgiving day was about 1539.
• The average of USD volume on thanksgiving day was about 15.77.
• The most USD volume , the week before thanksgiving day, was about 1.14M on November 18th.
• The least USD volume , the week before thanksgiving day, was about 140.7K on November 24th.
• The most USD volume , the week after thanksgiving day, was about 251.9K on November 30th.
• The least USD volume , the week after thanksgiving day, was about 102.7K on November 26th.

\

• The highest minimum of USD volume , the week before thanksgiving day, was about 0.92 on November 24th.
• The highest minimum of USD volume , the week after thanksgiving day, was about 0.3 on December 4th.
• The highest maximum of USD volume , the week before thanksgiving day, was about 17.5K on November 22nd.
• The highest maximum of USD volume , the week after thanksgiving day, was about 39K on November 30th.
• The highest average of USD volume , the week before thanksgiving day, was about 54.6 on November 18th.
• The highest average of USD volume , the week after thanksgiving day, was about 26.7 on November 30th.
• The highest average of 7 day moving , the week before thanksgiving day, was about 54.6 on November 18th.
• The highest average of 7 day moving , the week after thanksgiving day, was about 19.94 on December 3rd.

NFL ALL DAY NFT activity over the past year

Total Transaction

• The total number of transaction on the Thanksgiving day was about 9.21K and The average of transaction on the Thanksgiving day was about 7.18K.
• The total number of transaction before the Thanksgiving day was about 4.35M and The average of transaction before the Thanksgiving day was about 11.58K.
• The total number of transaction after the Thanksgiving day was about 71.1K and The average of transaction after the Thanksgiving day was about 9.21K.
• The highest number of transaction before the thanksgiving day was about 104.4K on January 23rd 2022.
• The highest number of transaction after the thanksgiving day was about 10.4K on November 29th 2022.

Total Buyer

• The total number of buyer on the Thanksgiving day was 2530 and The average of buyer on the Thanksgiving day was 1679.

• The total number of buyer before the Thanksgiving day was about 174K and The average of buyer before the Thanksgiving day was 4490.

• The total number of buyer after the Thanksgiving day was about 8.95K and The average of buyer after the Thanksgiving day was 2530.

• The highest number of buyer before the thanksgiving day was about 48.43K on January 23rd 2022.

• The highest number of buyer after the thanksgiving day was 2665 on November 29th 2022.

  \

Total Seller

• The total number of seller on the Thanksgiving day was about 2960 and The average of seller after the Thanksgiving day was 1980.
• The total number of seller before the Thanksgiving day was about 139.8K and The average of seller before the Thanksgiving day was 3610.
• The total number of seller after the Thanksgiving day was about 8.95K and The average of seller on the Thanksgiving day was about 2960.
• The highest number of seller before the thanksgiving day was about 16.6K on February 23rd 2022.
• The highest number of seller after the thanksgiving day was 3042 on November 29th 2022.

Total Volume

• The total USD volume on thanksgiving day was about 145.2K.
• The total USD volume the week before the thanksgiving day was about 215.5M.
• The total USD volume the week after the thanksgiving day was about 1.37M.
• The most USD volume , the week before thanksgiving day, was about 7.7M on February 18th 2022.
• The most USD volume , the week after thanksgiving day, was nearly 252K on November 30th 2022.

Total Minimum Volume Over The Last Year

• The total minimum volume during the thanksgiving day was about 0.2.

• The total minimum volume before the thanksgiving day was about 9e-8.

• The total minimum volume after the thanksgiving day was about 0.001.

• The highest minimum volume before the thanksgiving day was 1 on October 22nd 2022.

• The highest minimum volume after the thanksgiving day was 0.3 on December 4th 2022.

Total Maximum Volume Over The Last Year

• The total maximum volume during the thanksgiving day was about 1539.
• The total maximum volume before the thanksgiving day was about 9e-8.
• The total maximum volume after the thanksgiving day was also 1539 same as the maximum volume during the thanksgiving day.
• The highest maximum volume before the thanksgiving day was about 65K on January 17th 2022 and March 19th 2022.
• The highest maximum volume after the thanksgiving day was about 39K on November 30th 2022.

Total Average Volume Over The Last Year

• The total average of volume during the thanksgiving day was about 15.77.
• The total average of volume before the thanksgiving day was about 47.5.
• The total average of volume after the thanksgiving day was also 19.35.
• The highest average of volume before the thanksgiving day was about 212.3 on December 26th 2021.
• The highest average of volume after the thanksgiving day was about 26.78 on November 30th 2022.

Average Of Seven Day Moving

• The highest average of seven day moving before the thanksgiving day was about 143.91 on December 27th 2021.
• In the second place, The highest The highest average of seven day moving before the thanksgiving day was about 142.5 on December 26th 2021.
• The highest average of seven day moving after the thanksgiving day was about 143,91 on November 26th 2022.