NFL ALL (THANKSGIVING) DAY

Objectives

in this dashboard, I want to compare users activity of NFL ALL DAY NFTs before thanksgiving day and after that.

at the first, there are some definitions to getting know with subject, then there is a methodology to show you what I want to do, at last, there are some figures and observations to analyzing subject.

Methodology

in this dashboard the following methods are used:

analyzing users activity before and during thanksgiving week
comparing metrics before and during thanksgiving week
user categorizing
finding top users
analyzing team activity before and during thanksgiving week

in this dashboard the following tables are used:

flow.core.ez_nft_sales
flow.core.fact_prices
flow.core.dim_allday_metadata

Introduction

what is flow blockchain?

Flow (FLOW) is a high-performance blockchain specifically for creating NFTs, massive crypto games, and apps. Unlike general-purpose blockchains such as Ethereum, Flow is built to efficiently scale for potentially billions of people interacting with NFTs like in-game items.

Created by Dapper Labs, the same team behind NBA Top Shots and the infamous CryptoKitties blockchain game, Flow is a project in the right place at the right time. The NFT market is booming, and enormously popular social media platforms like TikTok and Twitter are rolling out NFT features.

Teams across major sports leagues, ranging from the NBA and NFL to MotoGP and esports, have debuted NFT initiatives and collectibles for fans. So, with NFTs already reaching mainstream status, Flow seems bound to succeed.[source]
what is NFT ?

Non-fungible tokens (NFTs) are cryptographic assets on a blockchain with unique identification codes and metadata that distinguish them from each other.

Unlike cryptocurrencies, they cannot be traded or exchanged at equivalency. This differs from fungible tokens like cryptocurrencies, which are identical to each other and, therefore, can serve as a medium for commercial transactions.NFTs evolved from the ERC-721 standard. Developed by some of the same people responsible for the ERC-20 smart contract, ERC-721 defines the minimum interface—ownership details, security, and metadata—required for the exchange and distribution of gaming tokens. The ERC-1155 standard takes the concept further by reducing the transaction and storage costs required for NFTs and batching multiple types of non-fungible tokens into a single contract.[source]
what is NFL ALL DAY?

NFL All Day is a digital collectible marketplace that lets football fans collect video highlights in the form of NFTs and connect with other like-minded fans from around the world. On NFL All Day, football fans can collect non-fungible tokens (NFTs) called "Moments" that capture highlights of great passes, touchdowns and other plays. Unlike traditional sports memorabilia such as ticket stubs or trading cards, NFL All Day Moments are stored on a blockchain and can be bought, sold or traded on a peer-to-peer marketplace. In the coming months, fans will also be able to use their Moments to win prizes by competing in official challenges. Launched at the tail end of 2021, NFL All Day is the latest product offering from Dapper Labs, the same creators of the hit NFT Marketplace and NBA Top Shot.[source]
what is Thanksgiving day?

Thanksgiving Day, annual national holiday in the United States and Canada celebrating the harvest and other blessings of the past year. Americans generally believe that their Thanksgiving is modeled on a 1621 harvest feast shared by the English colonists (Pilgrims) of Plymouth and the Wampanoag people. The American holiday is particularly rich in legend and symbolism, and the traditional fare of the Thanksgiving meal typically includes turkey, bread stuffing, potatoes, cranberries, and pumpkin pie. With respect to vehicular travel, the holiday is often the busiest of the year, as family members gather with one another. Thanksgiving Day is celebrated on Thursday, November 24, 2022.[source]

Part 1 / analyzing users activity before and during thanksgiving week

Observations 1

total number of sales during thanksgiving week is 40.6k.
total number of sales before thanksgiving week is 1.9M.
total sales volume(USD) during thanksgiving week is 0.625M.
total sales volume(USD before thanksgiving week is 71.7M.
at Feb 23,2022 most number of sales before thanksgiving week has happened that is 59.5k, after that at Sep 12,2022 is most that is 37.18k.
at Nov 29,2022 most number of sales during thanksgiving week has happened that is 5430. number of sales during thanksgiving week has a decreasing then increasing trend overall.
at Feb 23,2022 most number of NFTs that sold before thanksgiving week has happened that is 57.1k, after that at Sep 12,2022 is most that is 33.69k.
at Nov 29,2022 most number of NFTs that sold during thanksgiving week has happened that is 5173. number of NFTs that sold during thanksgiving week has a decreasing then increasing trend overall.
cumulative number of sales and NFTs that sold for before thanksgiving week, after Sep 5,2022 has a large increase in it’s slope.
cumulative number of sales and NFTs that sold for during thanksgiving week, after Nov 28,2022 has a large increase in it’s slope.
at Feb 23,2022 most number of unique buyers have traded before thanksgiving week that is 12.3k, after that at Sep 8,2022 is most that is 8397.
at Nov 25,2022 most number of unique buyers have traded during thanksgiving week that is 1744.
at Feb 23,2022 most number of unique sellers have traded before thanksgiving week that is 14.3k, after that at Sep 12,2022 is most that is 10.8k.
at Nov 25,2022 most number of unique sellers have traded during thanksgiving week that is 2060.
at Nov 5,2022 most ratio of number of sales per number of sellers before thanksgiving week has happened 5.017.
at Nov 30,2022 most ratio of number of sales per number of sellers during thanksgiving week has happened 3.31.
at Mar 19,2022 most average of sales volume(USD) before thanksgiving week has happened that is 95.2.
at Mar 19,2022 most average of sales volume(USD) during thanksgiving week has happened that is 27.3.
cumulative sales volume(USD) for before thanksgiving week, after Sep 5,2022 has a large increase in it’s slope.
at Mar 19,2022 minimum sales volume(USD) before thanksgiving week has happened that is 95.2$.
at Dec 1,2022 minimum sales volume(USD) during thanksgiving week has happened that is 27.3$.
at Mar 19,2022 maximum sales volume(USD) before thanksgiving week has happened that is 65k.
at Dec 1,2022 maximum sales volume(USD) during thanksgiving week has happened that is 9500$.

Part 2 / comparing metrics before and during thanksgiving week

Observations 2

average sales number for before thanksgiving week is 6864.105 and for during thanksgiving week is 3383.3.
average of number of unique buyers for before thanksgiving week is 1970.5 and for during thanksgiving week is 1004.75.
average of number of unique sellers for before thanksgiving week is 2445.54 and for during thanksgiving week is 1259.92.
average of sales volume(USD) for before thanksgiving week is 256.86k and for during thanksgiving week is 54.3k.
total sales number for before thanksgiving week is 1.9M and for during thanksgiving week is 40.6k.
total sales volume(USD) for before thanksgiving week is 71.15M and for during thanksgiving week is 652.17k.

Part 3 / user categorizing

Part 3.1 / categorizing number of sales by sales volume

Part 3.2 / categorizing number of sellers by sales volume

Part 3.3 / categorizing number of buyers by sales volume

Observations 3

for during thanksgiving week, most number of sales have volume(USD) less than 10$ and is 15.2k and 37.4% of total sales after that in second level most number of sales have volume(USD) more than 10000$ is 11.93k and 29.2% of total sales.
for before thanksgiving week, most number of sales have volume(USD) more than 10000$ and is 541.67k and 28.5% of total sales after that in second level most number of sales have volume(USD) 10-20$ is 512.8k and 27% of total sales.

\
for during thanksgiving week, most number of sellers have sales volume(USD) 10-20$ and is 1195 and 18.4% of total sellers after that in second level most number of sales have volume(USD) 100-500$ is 1134 and 17.5% of total sellers .
for before thanksgiving week, most number of sellers have sales volume(USD) 100-500$ and is 20.98k and 34.1% of total sellers after that in second level most number of sales have volume(USD) 1000-5000$ is 13.54k and 22% of total sellers .
for during thanksgiving week, most number of buyers have sales volume(USD) 100-500$ and is 875 and 17.4% of total buyers after that in second level most number of sales have volume(USD) 10-20$ is 704 and 14% of total buyers .
for before thanksgiving week, most number of buyers have sales volume(USD) 100-500$ and is 12.27k and 26.5% of total buyers after that in second level most number of sales have volume(USD) 1000-5000$ is 7661 and 16.5% of total buyers .

Part 4 / finding top users

Observations 4

top three sellers that have most number of sales:
- during thanksgiving week:
  
  :1st_place_medal:0xffee4f34acfc3ea6 448
  
  :2nd_place_medal:0x7099f070cdeeb621 377
  
  :3rd_place_medal:0xa74bc9b3f1838cd0 310
- before thanksgiving week:
  
  :1st_place_medal:0x84c9fe7ef49285fb 6714
  
  :2nd_place_medal:0xffee4f34acfc3ea6 6487
  
  :3rd_place_medal:0xe9648003e12c2070 5459
top three buyers that have most number of buy:
- during thanksgiving week:
  
  :1st_place_medal:0x4b7ad060d826fba2 921
  
  :2nd_place_medal:0xffee4f34acfc3ea6 476
  
  :3rd_place_medal:0x7e378ec7ee8e14e8 322
- before thanksgiving week:
  
  :1st_place_medal:0x84c9fe7ef49285fb 6657
  
  :2nd_place_medal:0xffee4f34acfc3ea6 6454
  
  :3rd_place_medal:0xe9648003e12c2070 5398
top three sellers that have most sales volume(USD):
- during thanksgiving week:
  
  :1st_place_medal:0x22dffc87d5f619f5 11829$
  
  :2nd_place_medal:0x228b96a4d9dfbea3 9037$
  
  :3rd_place_medal:0xed8707e2ae5bba5a 7352$
- before thanksgiving week:
  
  :1st_place_medal:0xed8707e2ae5bba5a 372323$
  
  :2nd_place_medal:0xc4719ab3f4c3db69 238520$
  
  :3rd_place_medal:0x84c9fe7ef49285fb 172967$
top three buyers that have most purchase volume(USD):
- during thanksgiving week:
  
  :1st_place_medal:0xfb34edeab0448ef3 22240$
  
  :2nd_place_medal:0x4b7ad060d826fba2 7872$
  
  :3rd_place_medal:0x4b5cef0306599709 4440$
- before thanksgiving week:
  
  :1st_place_medal:0xc4719ab3f4c3db69 961792$
  
  :2nd_place_medal:0xed8707e2ae5bba5a 499653$
  
  :3rd_place_medal:0x0b9986cd8fea9c61 462514$

Part 5 / analyzing team activity before and during thanksgiving week

Observations 5

the team that have most number of sales during thanksgiving week is “Detroit Lions“ that is 2878 and 7.11% of total sales.
the team that have most number of sales before thanksgiving week is “Kansas City“ that is 109.64k and 5.88% of total sales.
the team that have most sales volume(USD) during thanksgiving week is “Minnesota Vikings“ that is 46.48k and 7.14% of total sales volume.
the team that have most sales volume(USD) before thanksgiving week is “Tampa Bay Buccaneers“ that is 6.37M and 8.98% of total sales volume.

Thanks for reading my dashboard, please share your insight about it with me :grinning:
link of tweet that I share my dashboard :

flipside