What makes a Top Shots moment valuable? (Part I)

    \

    What Will You Read?

    • In This Analysis, You Will Read about NBA Top shots Play Type. We want to examine the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these?

    • Also, I’ll check the number of buyers and sellers per type over time and in total.

      What are NBA Top shots?

    • NBA Top Shot is a blockchain-based platform that allows sports fans to buy, sell, and trade unique versions of officially licensed video highlights. The project originated in 2019, spent most of 2020 in development, and rose to popularity with upwards of a million registered users in 2021.

      \

    • Analyzed By Hess - Reading Time Almost 10 Min.

    \

    Method

    • Sales Activities
      • First, I extracted buyers, sellers, and sales amounts from the NFT sales table.
      • Second I joined the new metastable and matched with NFT ids. Then calculated all requested questions.
    • Top Holders based on Play types
      • We don’t have exactly an NFT Holder or Balance table in Flow tables. So I needed a method to get the nearest result from all existing tables. I chose the Fact event table.

      • First, I extracted events. 1. Deposit and 2. Withdraw. These two names mean buy and sell in Flow tables. by Joining the meta table, I counted all buyers and sellers. The remaining number of users belongs to each NFT. So we have the nearest result of Holders.

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

    Daily Sales Volume

    • As a result of total buyers, sellers, and total sales, Rim has the highest daily Sales Volume.
    • Following the Rim Role, 3-Pointers have the highest average sales volume.
    • Almost Rim has the highest sales daily, but 3-pointer places have changed over time.

    \

    Total Daily Number of Sales

    • The highest sales activities happened on May 6th. The top roles were Rim, Assist, 3-pointers, mid-range, and steal.
    • Since June 2022, The total number of sales has decreased.
    • After NBA games, The total number of sales dropped significantly.
    Loading...

    \

    Total Buyers and Sellers per Play Type

    • Rim has 53K Buyers and 29.5K sellers since April 20th.

    • Assist has 38K Buyers and 19K sellers.

    • 3-pointer has 35K buyers and 18K sellers.

      These are the top 3 popular roles in NBA top shots.

    Almost All Roles have a similar range between buyers and sellers. There isn’t any role in the number of buyers and sellers have higher or lower difference.

    Loading...
    Loading...
    Loading...
    Loading...
    db_img

    \

    Top 3 Play types Volume:

    :1st_place_medal: The Top Volume goes to RIM play type. The total sales volume of RIM is about 10M dollars. :open_mouth:

    :2nd_place_medal: Three Pointer with 5.8M dollars is in the second highest sales volume play type.

    :3rd_place_medal: Assist role is in third place. The total sales volume of the Assist role is 4.3M dollars.

    Volume Shares

    • with 10M dollars volume, The Rim role has 36% of total sales volume.
    • 3 Pointer has 20% of total sales volume with 5.8M dollars.
    • Mid-range, Block and Assist all have above 2M sales.

    Sale Shares

    • The Most Popular Role is RIM based on the total number of sales.
    • Three Pointer is more popular than the two pointer role. 3 Pointers have 155 of total number sales, and 2 Pointers has below 1%.
    • In total, Attackers have a better chance than middle and defenders. :basketball:

    Total Buyers and Sellers

    • Most Buys and sells happen on Rim Role. At least 2x than the nearest rival, which is 3-pointers.
    • This role (RIM) has 30% of total buyers and 33% of total sellers. :top:
    • There are more sellers than buyers.

    \

    Cumulative Sales Volume

    :top: every day, Rim's role increases its difference with the second highest sales volume.

    :star2: 3-pointers following the RIm, but it has 1.3M dollars distance.

    :last_quarter_moon_with_face::first_quarter_moon_with_face: Assist and block cumulative volume are similar to each other.

    \

    Top Holders Based on Roles

    :1st_place_medal: Rim, with nearly 24K holders, has 20% of the total holders.

    :2nd_place_medal: The second one is Assist with 18.4K holders, 16.4% of total holders.

    :3rd_place_medal: 3-Pointer with 16.6K holders, 14.5% of total holders, is in the third popular Roles leaderboard.

    \

    Conclusion

    • RIM has the highest sales volume since April 20th among other role.
    • 3-pointer and assist are similar to each other. I can see 3-pointer had a higher sales volume, number of sales, buyer and sellers but it’s not in the top 3 holders.
    • Attackers are more popular than middle and defenders.

    Thank You For Reading!

    ALL CONTENTS AND CODES WRITTEN BY HESS :writing_hand:

    • Twitter: hessaminanloo
    • Discord: hess#0890
    • ENS: he3am.eth