Summary

• Osmosis seems to have a healthy recover after the bear market trend in the end of the Q1 of 2022, OSMO balance seems to have a strong increase at the end of June start of July, Nowadays liquid and staked OSMO is bigger than the start of the year.
• osmo1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3aq6l09 The number 1 Holder of OSMO seems to have a really good year having almost triplicate their OSMO during the year. This isn’t the case for the rest of the top OSMO holders, which only a few of them remains at the top in the current date and their OSMO didn’t change too much as the number one.
• The average OSMO per wallets seems to be 920, Staked OSMO holders have less than this and Liquidity OSMO holders have more than this number, The average seems to change a lot in the year (mostly because of new OSMO wallets) but in the later months this number seems to increase.
• OSMO is the asset most holded by wallets, 1/3 of these wallets may have ATOM, but OSMO seems to be the asset most used in the Osmosis environment. Although a lot of new assets seems to be popular and may reach the 1/3 as ATOM such as ECH/ION/USTC.

Introduction

• Osmosis is a Layer-1 Blockchain built on the Cosmos framework, operates a DEX and the OSMO is the native token which serves as governance and staking for users.
• The Focus of this dashboard is Osmosis native token the OSMO, and how it’s liquidity, wallet holders and average OSMO per wallet has changed in the year.

Simple Definitions

• DEX: A peer-to-peer market where users can buy and sell assets (Crypto-tokens) without giving their private keys to an intermediate.
• Liquidity Pools (LPs): DEX have their assets to swap(trade) in pools, where people can change one asset for another using the assets in these pools, Users can provide liquidity to these pools an be “investors” who stake their crypto-tokens on DEX’s LPs to earn “transactions fees” when users swap their tokens using these pools.
• Total Value Locked (TVL): The current total value of an asset in a protocol, or a LPs or in a blockchain node.

Methodology

• Using Flipside Databank tables:
  • osmosis.core.dim_prices: To get the Balance in USD of the tokens
  • osmosis.core.fact_daily_balances: To get the Wallets Balance on Osmosis.
  • osmosis.core.dim_labels: To get the Names of the Tokens in Osmosis.
• SQL presents respective credits.

Question

• How has the ratio of liquid to staked OSMO changed overtime?
• Are the top 100 OSMO holders the same now as they were at the start of the year?
• What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth.
• Do wallets normally hold a majority of OSMO, or another token? How has this changed over time?

Osmosis presents a strong increase on OSMO balance in July 2022 onwards, in both staked and liquid.

OSMO wallets holders seems to increase strongly in the Q1 of 2022, but slowly in Q2&Q3.

Locked Liquidity OSMO holders are a few and only appear at the end of the May 2022 which goes from 1(min) to 36(max) only to decrease and mantain at 33 holders.

Average OSMO per user seem to decrease over time, which correlates with the strong increase of users in the Q1 of 2022, but thanks to the strong increase of OSMO Balance on July 2022 this average increases a lot for liquid and staked holders.

Nowadays avg OSMO per staked wallets seems to decrease in October, not for Liquid holders which stays close to the 1000 OSMO per wallet.

Locked Liquidity avg OSMO fluctuates at the end of May (arrival of new users) only to decrease and stay still in June 5 (if we don’t count the 3 users which left days after).

The first 3 places of OSMO holders are the same nowadays, but the first place almost triplicate their OSMO balance.

Second place only have increase less than 20% of their balance which started

Third place have lost OSMO balance.

Fourth place at the start of the year is now 6th place winning less than 1M of Osmo in the period of time.

Fifth place at the start of the year, doesn’t made to the top 15 nowadays.

Sixth place at the start of the year is at 14th place nowadays.

As the 5th place at the start of the year, the rest of the TOP 15 didn’t make it to the newest TOP 15.

The Null value in the daily holders refers to the IBC ATOM.

OSMO is the asset most holded followed by ATOM, which also correlates with the USD volume.

USTC and ION are the following popular assets which users holds.

The rest of assets doesn’t have the same volume of USD or holders.

ECH & EVMOS assets seems to raise popularity over the year and are closely to the 100k holders.

A regular Wallet in Osmosis is likely to have ATOM & OSMO, and maybe USTC-ION-ECH.