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

    Introduction

    Blockchain-based platform NBA Top Shot lets sports fans to purchase, sell, and trade unique video highlights licensed by the NBA. A million people signed up for the initiative in 2021, after it was launched in 2019 and spent most of 2020 in development.

    Officially sanctioned NBA collectibles, Moment NFTs pay homage to some of the game's most memorable moments as performed by some of the game's greatest players. Core to NBA Top Shot, these are some of the top plays from all across NBA.

    What makes them unique in comparison to other types of highlights? The blockchain's NFTs give each one a unique identity. To put it another way, your Moments are uniquely yours.

    Your favorite players will be featured in special collectible moments like:

    • Video Highlights of the Playing Field
    • This item has been verified as authentic by the NBA and the NBPA
    • Sequence and serial number for the type of moment in time
    • Highlights and Stats for the Player
    • Badges

    Method

    According to this question's response, the following tables were used:

    • flow.core.fact_nft_sales.
    • flow.core.dim_topshot_metadata.
    • flow.core.fact_events.

    From the NFT sales table, I retrieved the address of purchasers and sellers, as well as the total sales amount. Afterwards, I linked up the new metastable and used NFT ids to connect it to the old one. The answers to all the questions were then computed.

    NFT Holders and Balance tables are not available in Flow tables. As a result, I required a way to find the most relevant data from all tables. I went with the Facts table for this event.

    I compiled a list of events. Deposit first, and then withdraw. In Flow tables, these two names mean purchase and sell. The total number of buyers and sellers was counted when I joined the meta table. Each NFT is entitled to the remaining number of users. Holders is the closest match.

    NFT IDs from the Top Shot collection are stored in the flow.core.dim topshot metadata database. Moments are represented by NFT IDs that have a play type of one of nine different sorts, and each of these Moments has a play type. Figure out how many of these moments have the same play type by using this table.

    To figure out how many of these Moments had been created, I consulted the flow.core.fact events database. Those transactions that matched the following criteria were considered Moments minting transactions for this purpose:

    Each of these tables has a different number of Moments than the other, and this is what makes these tables unique. There was also a count of the absences for each of them. Of course, these absences can be attributed to the following reasons:

    Both the dim topshot metadata table and the fact events table can include instances of a given event when the latter does not

    The data in the fact events table has a time limit (data is available from April 22 to July 8)

    Moments are not created.

    It's possible that the incompleteness of the dim topshot metadata database is the cause of moments that are both present in the fact events table and absent from it.

    After that, we'll use the fact events table's data for guidance in answering the remaining questions. However, only information from the fact events and dim topshot metadata columns was consulted for this analysis. It was presumed that those who minted Moment were holders, and it was examined to see how many of them sold their token. We've purged the holders' list of those who have sold their shares (even if they bought one of the Moments in the days after the sale of their own minted Moment and still have it).

    Analysis

    What play_types do users hold most? ==(Vis 1 & 2)

    • Rim, which has over 24K holders, accounts for 21% of the total.
    • The second is Assist, which has 18,8K subscribers, or 16.4% of all subscribers.
    • The third most popular role is 3-Pointer, which has 16.67K holders, or 14.5 percent of the total holders.

    Conclusion

    • The month of May was a very busy one ==in terms of sales==, but by the beginning of June, the busier days had given way to quieter ones and the pace of the industry had begun to slow down.
    • According to the figures for sales, there was a significant amount of action in this region during the ==month of May==, but after the first few days of June, the busy days gave way to days that were more subdued.
    • The day of ==May 6 saw the highest number of sales==. This month features all five of the days with the highest daily sales totals. It might be more accurate to refer to May as ==the month of moments== if we were to give it a moniker.
    • When looking at the total number of mints created on a daily basis, it is clear that the majority of the mints were finished in a relatively short amount of time. There are seven days of the week, which are numbered from one to seven, on which one may experience a mint moment:
    • Because there are four days in the beginning of the month and a total of five days in May, it would be a good idea to designate that month as ==Mint Moments Month==.
    • Since the 20th of April, ==RIM== has held the position of having ==the highest sales volume== of any others.
    • The same can be said about ==assists== and ==3-pointers==. When I look at the figures, can see that the 3-pointer had a significant ==number of purchasers== in comparison to the number of sellers, and it was also in the top three.

    About:

    What we wanna do in this dashboard?

    Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. \n

    • This week, focus specifically on 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 play_types generate?
    • Include any other transactional metrics you can think of.
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Daily Count of Sales Transactions ==(Vis 3 & 5)

    • The sixth of May was the day that saw the most sales activity. The highest volume in sales took placed for Rim, Assist, 3-pointers, mid-range, and steal.
    • Since June 2022, there has been a reduction in the overall number of sales.
    • Following the conclusion of NBA games, there was a discernible decrease in the overall number of purchases.
    Loading...
    db_img
    Loading...
    Loading...
    Loading...
    Loading...

    Mint Moment Overview ==(Vis 12 => 15)

    • In this sector, when looking at the total number of mints created on a daily basis, it is clear that the majority of the mints were finished in a relatively short amount of time. There are seven days of the week, which are numbered from one to seven, on which one may experience a mint moment:
    • Because there are four days in the beginning of the month and a total of five days in May, it would be a good idea to designate that month as ==Mint Moments Month==.
    • Rim, 3-pointer & Assist are top 3 roles with highest count and percentage shares of minting than others. as same expected.

    Total Count of Buyers VS. Sellers on each Play Type ==(Vis 11 & 12)

    • Rim has 61K Buyers and 77K sellers in total.

    • Assist has 30K Buyers and 32K sellers.

    • 3-pointer has 34K buyers and 38K sellers.

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

      \

    **The shares of Sales Volume amount ==(Vis 8 & 10) **

    • with 10.2m volume, The Rim role has 36% of total sales volume.
    • 3-Pointer has 20% of total sales volume with nearly 6m.
    • Assist is in the third place with 15% shares and more than 4m.

    Daily Sales Volume ==(Vis 7)

    • 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.

    Cumulative amount of Sales Volume ==(Vis 9)

    As Rim's role grows in importance, the gap between him and the second-highest sales volume widens.

    3-pointer is in the second place, but the deference is more than $5 million in comparable to Rim.

    The cumulative volume of an assist and others is similar and smoothly.

    Shares of Sale volume amount ==(Vis 4 & 6)

    • Based on overall sales, RIM is the most popular role in the game.

      The 3-pointer role is more popular with second place, according to a recent poll. 3 Pointers account for 15.5 percent of overall sales, whereas 2 Pointers account for less than 1 percent.

      Overall, the attackers have a better chance than the defenders and the midfielders have.