Try Quests to earn FLOWFLOW Usage During the NBA Playoffs
Introduction
The NBA Playoffs is a post-season National Basketball Association (NBA) tournament held to determine the league champion.
NBA Top Shot is an NFT marketplace where sports fans can buy, sell and trade basketball video clips. Launched in 2020, NBA Top Shot is a partnership between the NBA and Dapper Labs, the creators of CryptoKitties.
In this dashboard, we're going to look at whether NBA playoffs semifinals have had an impact on the FLOW network and in particular the Top Shot NFT collection.
Approach
By looking at this website: [playoffstatus.com] , we can see all the schedules for NBA playoffs. In this study, we will use the schedules to examine any correlation between the games and activities on Flow network.
The timezone of the datasets in FlipsideCrypto is UTC + 0, all NBA game schedules are in Eastern Time, so to better understand the data, we need to change the timeframe of the data using convert_timezone('UTC', 'US/Eastern', BLOCK_TIMESTAMP).
In order to find the transactions done in FLOW network we have to use flow.core.fact_transactions table, and to find the NFT sales data were are going to use flow.core.fact_nft_sales table.
The newly added tableflow.core.dim_topshot_metadata, provides useful data about Top Shot collection. We’ll use it to find out NFT of which team sold the most each hour.
Finally, 2022 NBA Playoffs semifinals started May 17 and finished on May 29, therefore we will be using WHERE BLOCK_TIMESTAMP BETWEEN '2022-05-17' AND '2022-05-29' on most of our queries to get data for this specific time frame.
NBA Playoff Schedules
The semi-final stage started on May 17 and ended on May 29. The schedule of the games is depicted in the table below.
Please note that instead of using the full name of the teams, we only use the first character of their name. The winner of each match is indicated by a checkmark.
- H → Heat
- C → Celtics
- W → Warriors
- M → Mavericks
- :white_check_mark: marks the winner.
| 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 29 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20:30 | 21:00 | 20:30 | 21:00 | 20:30 | 21:00 | 20:30 | 21:00 | 20:30 | 21:00 | 20:30 | 20:30 |
| H:white_check_mark: vs C | W:white_check_mark: vs M | H vs C:white_check_mark: | W:white_check_mark: vs M | C vs H:white_check_mark: | M vs W:white_check_mark: | C:white_check_mark: vs H | M:white_check_mark: vs W | H vs C:white_check_mark: | W:white_check_mark: vs M | C vs H:white_check_mark: | H vs C:white_check_mark: |
Top Shots NFT Statistics
On the following charts, the amount of Top Shots NFT collection’s hourly sales during the semifinals can be seen. On the next charts we can see hourly traded volume and average price for the collection.
In the next section, we summarize our observations according to all the charts.
Observations
- Let’s at the beginning analyse the sharp spikes that occurred in transaction count chart and see if these spikes have any connection with the Top Shot NFT collection. There are 3 major spikes visible on the hourly transaction count chart, these spikes happened on May 21, 26 and 29.
- On May 21, just before the match, the amount of transaction count increases, on the same time, the number of hourly sales of the collection increase drastically, although due to low price, the volume didn’t change much, and was similar to other days. also during this time the NFTs related to Warriors sold the most.
- On May 26, 14:00 to 23:00, transaction count increased drastically, during this time, sales count was above the average daily and there was a significant increase in volume.
- On May 29, although there is a sharp increase in transaction count, but it seems to be unrelated to the Top Shot collection, because there isn’t any significant change in charts related to the collection.
- There is also a huge increase in volume on May 18, 19:00 right before the match between Warriors and Mavericks, the sales count is high but not its not the reason for increased volume, but the average price increased significantly during this hour.
- On May 19, noon to just before the match between Heat and Celtics, volume increased drastically, the average sales price also increases significantly during this time, which is the reason behind increased volume.
- According to Top Shot NFT sales chart, May 20 , 700 out of 2600 NFT sold belongs to the teams participating in semifinals, probably influenced by games last night, NFTs related to Heat and Celtics sold the most.
- The afternoon of May 21 was the day that the collection sold the most, 1600 out of 4000 NFTs sold was related to the teams playing in the semifinals. again influenced by the match of last night, Warriors and Mavericks NFTs sold the most.
- On May 25, NFTs related to Mavericks sold significantly, they have won the match from last night.
- It seems that the match from the night before have a significant impact on NFTs sold on a particular day.