Genopets Staking

    Q78. Genopets is a move-to-earn game reminiscent of Pokemon Go on Solana. Recently, Genopets launched staking for their $GENE token (read more here https://medium.com/@genopets/announcing-gene-token-staking-1513e08ecbe). Create a visualization showing the amount of staked GENE over time. How many unique wallets have staked $GENE since its inception on May 18th? What percentage of those stakers have previously purchased a Genopets NFT? What trends are you seeing with the Genopets NFT collection?

    In this analysis, I take a div into $GENE token since its launching up to now.

    What am I looking for?

    1. wallets that have staked $GENE
    2. The amount of staked GENE
    3. The percentage of stakers that have previously purchased a Genopets NFT

    About my Method

    Today is 2022/06/02 an I determine my indicators up to 2nd of June.
    for this analysis I have used 3 tables (including: solana.fact_event, solana.dim_labels and solana.fact_nft_sales).
    to find NFTs I filtered label column of dim_labels in genopets.

    The first chart shows you the amount of staked $GENE token

    Loading...

    The maximum number of stake have been on 19nd May

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

    by filtering label column of dim_labels on genopets, I found 428 stakers that have previously purchased a Genopets NFT. also in the pervious part I determined total number of distinct stakers; so, by a simple Division operation: