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:

    1. Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume.
    2. 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 need flow.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 by A.c1e4f4f4c4257510.TopShotMarketV3 or A.c1e4f4f4c4257510.Market because they show NBA top shot.

    Loading...
    Loading...
    Loading...
    Loading...

    Swaps volume:

    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.

    Sales volume:

    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.

    Conclusion

    According to the data we have for this question, I can't see any positive impact of NBA playoffs event. Seems market condition has more effects on blockchains.