Getting Your Feet Wet, Part 1

    Question 160: Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions 2) the number of protocols that interacted with 3) the number of different types of transactions undertaken. (deposit, delegate, vote)

    Loading...
    Loading...

    Methodology

    1. Get the total of wallets that first transaction was 90 days ago or less
    2. Get the transactions that those wallets have
    3. Compare between the new wallets and transactions count

    In this study, We will focus on transaction analysis (e.g., transaction count per wallet, average transaction per wallet) from the new wallets or wallets that have a transaction in 90 days or less (this result was written on March 9th, 2022).

    Due to the performance issue when querying the database. In this study we will get only the first sender from every transactions (ignore multisend transactions).

    This chart shows that 68.6% of new addresses have interacted with no more than 5 transactions. (24.2%, 19.3%, 11.7%, 8.0%, 5.5%) from one to five respectively. The other 31.4% ranges from six to 135k+ transactions.

    First, let's get a total number of new wallets that have the first transaction from 90 days ago or less and total of transactions that those wallets have

    From the graph, 78k+ addresses have only interacted with one transaction. The highest transaction count for one address is 135k+. With an average of roughly 14.3 transactions per address

    According to the findings, the total number of new wallets created in the last 90 days is 325k+ addresses, with a total of 4.6m+ transactions interacted by those wallets.

    Analysis

    Conclusion

    New users who make their first transaction in less than 90 days are more likely to make only one transaction, although the average number of transactions for all new users is 14.3.

    Loading...
    Loading...
    db_img