Near-9. New NEAR Users

    What actions does a user take when they deposit money into the NEAR ecosystem?

    Methodology

    • The SQL Query is based off a query by another user - SQL Credit and Dashboard, the query is then modified for desired result.
    • Since the transfers table is not complete and NEAR tables are not backfilled complete the balances are not accurate and the limitations are same as the ones specified in this Dashboard
    • Overall the methodology:
      • Looks at the transfers tables for transfers to NEAR wallets for inflows, note the timestamp.
      • For next actions
        • Looks at swaps table to find swaps to and from NEAR
        • Looks at the transactions and action_events table to find specific transactions related to staking, unstaking
      • Find all the next action transactions that are done after the first inflow transaction, and rank them by timestamp, pick the very first transaction after inflow.
    • We also look at all the inflows to see how many wallets are transferring $NEAR into the ecosystem.

    Inflows

    • The number of wallets in the past days has decreased from ~70K to 50K wallets daily.
    • The average inflow amount is < 10 $NEAR on most days, however there are days like Aug 24, 2022 where the average is 194 $NEAR.
    • The max inflow amount is around 100K $NEAR on most days, however there are days where there are deposits like 7.8M $NEAR in a day.
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    First Activity after Inflow

    • What is very surprising is that most of the wallets actually transfer NEAR out of their wallets as the first transaction.
      • This is a very high number around 150K wallets in total and 500 wallets on daily basis.
    • Very few wallets actually swap from NEAR and swap to NEAR.
    • Given below are the Daily number of wallets against activity and overall activity count.

    Conclusion

    • The most common first activity after NEAR inflow into wallets is transfer NEAR to another wallet.
    • Few of them actually swap from and to NEAR.
    • None of them stake as the very next activity.