NBA Playoff Usage
Q.15 Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
Goal:
Discussion about the Impact of NBA Playoffs on Transactions and the NBA Top Shots marketplace
Questions:
- Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume.
- What about NBA Top Shots?
Solutions:
The NBA 2022 playoffs started on Saturday, April 16, and will last until Sunday, June 19. So In this dashboard, I consider data from the beginning of March.
To answer this question, we should find the swaps volume and sales volume to find the trend.
-
Swaps volume: I used
flow.core.fact_swaps
table. there isn't amount in USD in this table so we needflow.core.fact_prices
table to find the amount of the swap in USD. -
Sales volume: I used
flow.core.fact_nft_sales
table. the marketplace should equal byA.c1e4f4f4c4257510.TopShotMarketV3
orA.c1e4f4f4c4257510.Market
because they show NBA top shot.
As you can see, The data started on Apr 21st. I need the previous days volume to find the trend but the dataset isn't complete. Anyway, I cant see any trend in the above chart. only there are some spikes on May 10th and May 25th.
According to the above chart, the number of users is decreasing.
Unlike swaps volume, the sales volume on NBA top shot shows decreasing sales in this marketplace clearly. on Apr 20th the sales volume was more than 600,000 $ but now this amount reached to 184,000 $. Nearly three times lower than the amount started.
Decreases are visible in the number of buyers on NBA top shot too.