📌 Overview

• in this dashboard,I will review the following
• In the first stage, a brief introduction to what is Osmosis Exchange ?
• osmo Price
• total swap and swapper
• Daily volume swap to & from osmo
• Daily total swap to from stablecoin
• Analyze each chart
• General conclusion about the dashboard

🖋️ Methodology

• I Used osmosis.core.fact_swaps and osmosis.core.dim_prices tables in getting the :
  • Project name: uosmo & OSMO
  • case when date < '2022-11-08' then 'Before FTX' when date >= '2022-11-08' then 'After FTX' end as period

    • osmo Price

    • total swap and swapper

    • Daily volume swap to & from osmo

    • Daily total swap to from stablecoin

      \

Question

> This week has highlighted the need for transparency & decentralization in crypto markets. Let's see how users have reacted to this wild week in Web3. Have behaviors changed? Analyze growth in Osmosis Volumes & User Count this week. > > Has more money flowed into Osmosis this week compared to the past few weeks/months? Where is this money coming from? Centralized Exchanges? Have wallets moved more into stables?

Introduction

• What’s Osmosis Exchange?

  > Osmosis is a new innovation of Decentralized Exchange built on an entirely different ecosystem. Decentralized Finance has continued to witness progressive innovations different from the existing ones. Osmosis is a decentralized exchange created by making use of the Cosmos SDK built on the Cosmos ecosystem a framework used for creating blockchains. Osmosis also adopts the use of the Automated Market Maker features enhancing liquidity on the cosmos system. > > The Osmosis exchange was developed on public and open-source software that allows peer-to-peer transaction and allows trading of tokens accepted by the IBC. Users are allowed to access pools by making use of webs or mobile interfaces. So operations are not limited to the website alone but users must understand that they are responsible for the interfaces and fees. Osmosis exchange is highly volatile and users may experience fluctuation of token prices in their trading pair. > > Osmosis is an autonomous chain secured by the cosmos network and it was fashioned in a way that it remains one of the powerful decentralized Automated Market Maker protocols to be built on the Cosmos hub. It was launched as a great decentralized token supply to ATOM holders secured by validators. The Osmosis exchange allows flexible operations of the Automated Market Maker on the Cosmos ecosystem and ensures that it is interoperable.

observations

• The graph on the left is related to the price of the osmo token in the last 60 days.
• As you can see, it has had the same trend in the last 60 days.
• But since a week before the FTX consensus, we have seen a slight increase in the price.
• But on November 8, at the same time as the exchange event, we have seen the price of osmo drop.

observations

The two graphs above are related to the number of swaps and swappers during the last 60 days.

which is divided into two parts before and after the FTX exchange event.

In the last 60 days, the trend has been relatively the same, but in terms of the number of swaps after November 8, we have seen an increase of almost 50% in swaps, but there is not much change in terms of the number of swappers.

observations

The two graphs above are related to the Daily volume osmo swap from and to osmo during the last 60 days.

which is divided into two parts before and after the FTX exchange event.

The upper graph is related to the volume of swaps from Osmosis to other tokens and vice versa.

As can be seen, before the FTX exchange event, we have seen a multiple increase in the volume of osmo converted to other coins and vice versa. And it will decrease again. However, at the same time as the FTX exchange event on November 8, we have seen an increase in the conversion of osmo to other coins. But regarding the conversion of other currencies to Osmosis, we have had a smaller increase

In general, the volume of conversion of other currencies to Osmosis is always much higher than the volume of conversion of Osmosis to other currencies.

observations

• The top left graph is related to the number of swaps from Osmosis to other currencies.
• As can be seen. In the last 60 days, there has been a slight increase. Simultaneously with the FTX exchange event, we have seen an increase in the number of swaps.
• But the graph on the right is divided into two categories, stable coins and other currencies,
• as you can see. Stable coins have a smaller share than other tokens.

observations

• The top left graph is related to the number of swaps from other currencies to Osmosis .
• As can be seen. In the last 60 days, there has been a slight increase. Simultaneously with the FTX exchange event, we have seen an increase in the number of swaps.
• But the graph on the right is divided into two categories, stable coins and other currencies,
• as you can see. Stable coins have a smaller share than other tokens.

Stablecoins Swaps

Osmo Price

Osmo Swap

📚 Conclusion

• Price : As you can see, it has had the same trend in the last 60 days.
• But since a week before the FTX consensus, we have seen a slight increase in the price.
• But on November 8, at the same time as the exchange event, we have seen the price of osmo drop.
• Number of swap & swapper : In the last 60 days, the trend has been relatively the same, but in terms of the number of swaps after November 8, we have seen an increase of almost 50% in swaps, but there is not much change in terms of the number of swappers.
• Volume of Swap : As can be seen, before the FTX exchange event, we have seen a multiple increase in the volume of osmo converted to other coins and vice versa. And it will decrease again. However, at the same time as the FTX exchange event on November 8, we have seen an increase in the conversion of osmo to other coins. But regarding the conversion of other currencies to Osmosis, we have had a smaller increase

Appendix

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

My Data :grinning:

discod : esi69#8413

> # thanks for reading !