Overview

In this dashboard,I will review the following:

• introduction Osmosis

• in terms of metrics such as:

• The Ratio Of Liquid to satake Osmos

• Daily Holder Of Osmos

• Top 100 Holders osmo Start of year and now

• Osmo Price

• Average Osmo per wallet

  \

Introduction

The Osmosis AMM:

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.

Methodology

• Iused:
• fact_daily_balances
• dim_labels
• dim_prices
• for The Ratio Of Liquid to satake Osmos
• Daily Holder Of Osmos
• Top 100 Holders osmo Start of year and now
• Osmo Price
• Average Osmo per wallet

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?

Q1.ratio of liquid to staked OSMO

> Observations

• As you can see, the ratio of liquid to staked OSMO changed overtime has increased and decreased over time, but since October 10th, we have seen an increase in this rate.
• This rate increase is due to the decrease in the amount of staked.

Q2.top 100 OSMO holders

Observations

> * In this section we see the top 100 holders at the beginning of the year and now... something like 50% of the top holders at the beginning of the year are still there now. > * Top 100 the start of the year > * 1.osmo1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3aq6l09 volume$=75813212.545936 > * 2.osmo1jv65s3grqf6v6jl3dp4t6c9t9rk99cd80yhvld volume $= 46467578.929142 3.osmo1pvxhtre74l37p6y2rs2e8xyek75z7xlc7g2trt volume $=35945192.906734 > * Top 100 the now > * 1.osmo1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3aq6l09 volume $=218700662.851377 2.osmo1jv65s3grqf6v6jl3dp4t6c9t9rk99cd80yhvld volume$ =59725263.78739 3.osmo1pvxhtre74l37p6y2rs2e8xyek75z7xlc7g2trt volume $=23913355.163717

Q3. current average OSMO per wallet

Observations

• As you can see, with the decrease in the price of osmosis, we see a decrease in the average amount of osmosis in each wallet, but at the same time as the decrease of the previous two options, we see an increase in the number of users and holders.
• In fact, reducing the price of osmosis increases the number of users and decreases the average osmosis in each wallet.
• average Osmo Per Wallet Current Date : 868 Osmos Per wallet

\

Conclusion & last Observations

• As shown in the diagram above. The best tokens in terms of the number of holders are as follows.
• 1. Osmo 375 K Holders
• 2.Atom 160 K Holders
• 3.Ustc 98 K Holders
• Price of osmo and osmo market cap over time has been reducing over time greatly.
• As you can see, with the decrease in the price of osmosis, we see a decrease in the average amount of osmosis in each wallet, but at the same time as the decrease of the previous two options, we see an increase in the number of users and holders.
• As you can see, the ratio of liquid to staked OSMO changed overtime has increased and decreased over time, but since October 10th, we have seen an increase in this rate.

The solution of this question and the queries are completely used from the filipside database. The construction of the dashboard was also used from the site app.flipsidecrypto.com/velocity, which belongs to flipside

About

contact data:

discord : aor67#3352

twitter :amir 1367

THANKS >>