Final Submission

    Jo-Chuan Chou

    Introduction

    Dune Dashboard Link: https://dune.com/lightsoutjames/STEPN-Dashboard (Links to an external site.)

    Chain: Solana

    Program_ID: B3hpNpGHpQNaDiySNvoNhcnw81XfiE5Z78DGZzpKYuzp

    STEPN is an NFT game built on the Solana chain that emphasizes the Web 3.0 lifestyle, integrates SocialFi and GameFi elements, and encourages players to earn income by walking or running outdoors. The core of STEPN is to earn STEPN's native token GST by earning while walking.

    Loading...

    Conclusion

    For those who like jogging, an APP that can track various running data can be said to be an indispensable tool. While STEPN provides this function, it also brings in the design of Move To Earn, which is eye-catching. If you also want to start trying to experience this game, you can choose shoes with higher efficiency and toughness, which has reduced the time it takes to recover the cost. In addition, remember to keep a part of the tokens for repair use, so as not to have too low durability, resulting in a significant drop in revenue. At present, the official said that the game has many functions under development, and it is expected to add social functions and support more blockchains in the future.

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

    Additional Question / Analysis:

    How many daily new users in the recent week?

    Answer: We can add the SQL code like “ block_timestamp >= CURRENT_DATE - 7 AND block_timestamp < CURRENT_DATE” on the analysis of [STEPN] Daily Users to get daily new users in the recent week. Thus, we can update all the information with the simple SQL commands. 

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

    Analysis of [STEPN] Daily Users

    You can use this graph to understand the daily new users and the original cumulative users so that the enterprise can observe the growth trend of users, and help the company to check the influence of the strategy policy on the users.

    Analysis of  [STEPN] GMT Transferred in BSC Chain

    GMT, the governance token of STEPN, can be used to consume Mint shoes and increase the upper limit of GST earning. Through the analysis of this SQL command, you can know the daily transaction volume.

    Analysis of  [STEPN] Cumulated Users

    Using two different graphs, bar chart and line chart, can represent the differences and trends between accumulated users and new users, so that companies can explore the impact of the environment or company strategy on this parameter of users.