flipside

    Try Quests to earn FLOWTry Quests to earn FLOW
    Share

    Flow-12.Active Wallets

    -- Q12. What are active wallets doing more broadly? What type of activities are the most common on average, -- and what are the whales doing? Is there a way to identify real users and organic transaction activity? -- Hint: Track wallets by activity using the events table to derive activity type based on what events are in the transaction

    Definitions

    • A whale is defined as a wallet with more than 300 NFTs
    • A bot is defined as a wallet with more than 500 transactions per day on average.

    What are active wallets doing more broadly? What type of activities are the most common on average

    • Given below is the activity type of average wallets overall.
    • The most common type of activity is TokensDeposited, TokensWithdrawn and Fees Deducted.
    • Also given below are the Top 10 most common types of activities.
    Loading...
    Loading...

    What are the whales doing?

    • Given below is the activity type of whale wallets overall.
    • The most common type of activity by whales is TokensDeposited, TokensWithdrawn and Fees Deducted.
    • Also given below are the Top 10 most common types of activities, MomentListed and MomentWithdrawn is an activity different from average wallets.
    Loading...
    Loading...

    Is there a way to identify real users and organic transaction activity?

    • We can try to identify real vs users activity.
    • We define a bot as a wallet with more than 500 transactions per day on average.
    • Based on that assumption given below is what the breakdown of transactions look like.
    • very interesting to see that on some days like May 29, 2022 we see 93% of transactions by bots.
    • Most days there is significant activity by bots.
    Loading...
    Loading...