Try Quests to earn cryptoDaily Active User
Questions:
In this dashboard, we are going to finding weekly active users on Osmosis.
- What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week.
- What does DAUs activity look like?
- Do they LP more or swap more?
- How often do they transfer tokens into Osmosis?
- Where are these transfers coming from?
Osmosis (OSMO): A DEX for the Cosmos Ecosystem
Osmosis is a DEX protocol, which means it uses smart contracts to determine the price of digital assets, to produce liquidity via a peer-to-peer (P2P) methodology, and to exact trades between users. This approach to an exchange platform is known as an AMM — a DEX protocol that prices crypto assets in liquidity pools. Contributing tokens to these pools helps foster decentralized liquidity, which is then used to facilitate trades on the exchange. Participating as a liquidity provider (LP) can earn you both trading fees and newly minted LP tokens as incentives for participation.
A key innovation within the Osmosis protocol structure is superfluid staking, which allows users to both stake tokens while simultaneously using them to provide assets to a liquidity pool. This means Osmosis users are rewarded for helping secure the blockchain while staking, and receive reward fees associated with liquidity pool transactions.
Solution:
The first step to answering this dashboard question is to come up with a definition of unique users. Here, we consider those who have made more than 4 successful transactions on different days of a week as active users of that week.
To achieve this goal, I use core.fact_transactions table of Osmosis schema.
After finding active users, It is time to categorize their activities. I divided the activities into 5 categories: Governance, Liquidity providing, staking, Swapping, and Transferring.
This chart shows the number of transactions made by active users that doing each 5 category over time.
As you can see, almost always the number of swap transactions is more than the other categories.
Staking is the second most repetitions activity by active users and Transferring follows it by a small margin.
Liquidity providing is fourth repetitions activity and at last is governance voting activity.
This chart shows the number of active users that doing each 5 category over time.
As you can see, almost always the number of users who swap is more than the users of other categories.
Staking is the second most popular activity for active users.
Liquidity providing was third popular activity until Feb 2022 but after that the number of users used transferring and governance voting increased.
As you can see, the unique users increased at the first and this increase continued until the end of March 2022. Since April 2022, we have seen a gradual decrease in the number of active users on the Osmosis network.
On average, ~11.5K unique wallets made 4 or more than 4 transactions per week.
As you can see, the trend is similar to previous part. The unique users increased at the first and this increase continued until the end of March 2022. Since April 2022, we have seen a gradual decrease in the number of active users on the Osmosis network.
Of course, some spikes were seen in May.
On average, ~116K transactions made by active wallets per week.
Conclusion:
- The number of active users and number of transactions made by them increased at the first and this increase continued until the end of Mar 2022. Since April 2022, we have seen a gradual decrease in the number of active users on the Osmosis network.
- The order of popular activity that made by active users in terms of number of unique user is: Swapping > Staking > Transaferring > governance > Liquidity providing.
- The order of most repetitions activity made by active users in terms of number of transactions is: Swapping > Staking > Transaferring > Liquidity providing > governance