Daily Active User
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.
Date: 2022-10-20
Introduction
What is Osmosis in crypto?
- Osmosis is a proof of stake (PoS) blockchain with a decentralized exchange application enabling users to provide liquidity, swap, and in the future natively stake the tokens of blockchains from across the Cosmos ecosystem.
- Osmosis serves as an automated market maker (AMM) that connects to other Tendermint‐based blockchains, creating a heterogenous and interoperable cross‐chain trading experience for users.
Overview of this article
In this article, we discuss the issue of active users of the Osmosis network.
Definition:
A wallet is active if it has at least one daily transaction on the Osmosis network most days of the week, that is, it has been active for at least four days out of seven days of the week.
Main topic are as follows:
1- Daily active users
2- Daily active users’ activities
3- Destinations (to) & origins (from)
Methodology
-
To extract ِDAU data
“osmosis.core.fact_transactions
“ table will be used. -
To extract LP actions data
“
osmosis.core.fact_liquidity_provider_actions
“ table will be used -
To extract swaps data
“
osmosis.core.fact_swaps
“ table will be used -
To extract governance vote data
“
osmosis.core.fact_governance_votes
“ table will be used -
To extract Staking Rewards data
“
osmosis.core.fact_staking_rewards
“ table will be used
Observations
- There are more than 890 daily active users on the Osmosis network.
- The first week of March has the highest number of active users in one day.
- The two months of February and March have the largest number of new users joining this network.
- The general trend of attracting new users is upward, although in recent months its slope (speed of joining) has decreased.

Observations
- The most activity that users have performed on the Osmosis network was swap and after that IBC transfer.
- Only six percent of all transactions on the network were related to LP actions, which is insignificant compared to the number of swaps.
- This situation also existed regarding the number of active users, so that only ten percent of all active users had LP actions, while more than 20 percent of them performed swaps.
- On the 22nd of March, the largest number of transactions, regardless of their type, were performed on this network.
Observations
- "Evmos", "Boot", "Atom", and "Juno" are the four networks that have the most input to osmosis, respectively.
- "Atom", "Boot", "Juno", and "Evmos" are the four networks that have the highest output from osmosis, respectively.
- The most popular tokens on the network are "ATOM", "OSMO" and "juno" which had the highest number of transactions/active users.
Conclusion
- There are more than 890 daily active users on the Osmosis network.
- The first week of March has the highest number of active users in one day.
- The two months of February and March have the largest number of new users joining this network.
- The general trend of attracting new users is upward, although in recent months its slope (speed of joining) has decreased.
- The most activity that users have performed on the Osmosis network was swap and after that IBC transfer.
- Only six percent of all transactions on the network were related to LP actions, which is insignificant compared to the number of swaps.
- This situation also existed regarding the number of active users, so that only ten percent of all active users had LP actions, while more than 20 percent of them performed swaps.
- On the 22nd of March, the largest number of transactions, regardless of their type, were performed on this network.
- "Evmos", "Boot", "Atom", and "Juno" are the four networks that have the most input to osmosis, respectively.
- "Atom", "Boot", "Juno", and "Evmos" are the four networks that have the highest output from osmosis, respectively.
- The most popular tokens on the Osmosis are "ATOM", "OSMO" and "Juno" which had the highest number of transactions/active users.
