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
The growth rate of transaction events with Tokens Withdrawn, Tokens Deposited and FeesDeducted events was higher than the other events.
The 3 events Tokens Withdrawn, Tokens Deposited and FeesDeducted seem to be related to one activity. Because all three have the largest number of events.
More than 1.6 million wallets have had between 1 and 3 different events in their transactions. About 1,500 wallets also had between 3 and 5 different events in their transactions.