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.

Osmosis

Osmosis is an advanced automated market maker (AMM) protocol that runs on its own chain

:thinking: What can people do on Osmosis?

Well… not much. Osmosis acts like a liquidity hub for the Cosmos Ecosystem.

Users can swap, provide liquidity in pools, and stake their Osmosis token to participate in the governance of the protocol as well as receive staking rewards

:telescope: Scope of Analysis

How many active users are there on Osmosis?
What do Osmosis users do on-chain?
How active are Osmosis users throughout the day?
What assets are moved in and out of Osmosis via IBC?

The chart above shows the daily number of new users, active users (distinct wallets), and total new users on Osmosis since July 2021. At the time of analysis, there were 570k unique wallets.

The chart above shows the volume of transactions on Osmosis by the type of event that it’s labeled with and the transaction distribution normalized.(area plot) . Osmosis experienced growth in transaction volumes from July 2021 to March 2022 which declined thereafter. The transaction volumes have remained steady since July 2022.

osmo1zl0pzaz07pmemhcy7zjujpu6cje2qms6t4fkld is leading swap activity by having 178K transactions.

osmo1rl7lksuzayz5j0u0p35ezrw95czp3gyt73umxu has the most transfer activity by 81K transactins.

Methodology

This code select datediff(day,min(block_timestamp::date),CURRENT_DATE ) from osmosis.core.fact_transactions gives us the number of days that the transaction has been in the database which is 485 days.
To find active users, we assume that 2/3 of these days have transacted, so we extract users who have transacted for at least 320 days, which gives us 1,447 daily active users.
Then we extract the transaction code of these users
Then we answer the questions asked in the bounty from the osmosis.core.fact_msgs table

Bubble chart here shows distribution of token transfers to Osmosis and as its shown almost all days of month has same numbers of token transfers which is mostly between 400K and 450K, so we can conclude that on each day same number of token transfers has been flowed into Osmosis.

Conclusion