Introduction

What is Osmosis?

Osmosis is the eighth blockchain in the Cosmos network (ATOM) to enable the Inter-Blockchain Communication Protocol (IBC), and the sixth blockchain that connects to the Cosmos Hub, according to Cosmos, which is designed to enable interoperability between blockchains. Osmosis is an advanced automated market maker (AMM) protocol that allows developers to build customized AMMs with sovereign liquidity pools. Built using the Cosmos SDK, Osmosis utilizes Inter-Blockchain Communication (IBC) to enable cross-chain transactions.

Overview

In this dashboard, we will focus on the four Osmosis well-known pools i.e.

• Pool 833 - stOSMO / OSMO
• Pool 837 - IST / OSMO
• Pool 840 - BNB / OSMO
• Pool 634 - wETH.grv / OSMO

For each of these pools, 5 main parameters including

• the number of transactions
• the number of LP providers
• the nuber of new LP providers
• the total volume
• the average volume

are extracted in the time period before and after selecting that pool as the pool of the week.

Methodology

In this dashboard, two time periods are considered, the first period is before the pool was selected as the pool of the week and the second period is after the pool was selected as the pool of the week until now. For this purpose, the four important timespans, which are actually the same day that the pool is selected as the pool of the week, are:

• 11/11/22 Pool 833
• 11/15/22 Pool 837
• 11/22/22 Pool 840
• 11/29/22 Pool 634

To calculate the volume, we need the current price of Osmo, BNB, IST and Ethereum, so the following tables will be used to calculate the price of these tokens:

osmosis.core.dim_prices 

To extract osmosis pools liquidity data “osmosis.core.fact_liquidity_provider_actions“ table will be used.

• All these data are extracted from Flipsidecrypto tables.

1- Pool 833 - stOSMO / OSMO

Charts Insights

For pool 833, the number of transactions after the date that the pool was selected as the pool of the week has not changed much, and maybe a slight decrease can be seen in it.

For pool 833, the number of LP Providers has not changed much after the date that the pool was selected as the pool of the week, and maybe a slight decrease can be seen.

For pool 833, the number of new LP Providers after the date that the pool was selected as the pool of the week has decreased.

For pool 833, the total volume of transactions has decreased after the date that the pool was selected as the pool of the week.

For pool 833, the average volume of daily transactions has increased after the date that the pool was selected as the pool of the week, especially on November 13 and 15.

Charts Insights

For pool 833, on all days, the majority of all its transactions are related to the input values to the pool, and the output transactions have a very small percentage.

For pool 833, on all days, most of its users are related to the input values to the pool, and the output LPs have a very small percentage.

For the 833 pool, new LP providers who have made a transaction on the pool have often had an inflow transaction.

For pool 833, in most days, the volume transferred in transactions was related to the volume of the input to the pool, and the output volume is much less than the input volume.

For pool 833, the average volume of input to the pool is higher than the average output volume on most days, but on some days, the average output volume was higher, especially on November 14 and 16.

2- Pool #837 - IST / OSMO

1-1 Pool 833 - Outflows & inflows

Charts Insights

For pool 837, the number of transactions after the date that the pool was selected as the pool of the week has increased, especially on November 24.

For pool 837, the number of LP Providers has increased after the date that the pool was selected as the pool of the week.

For pool 837, the number of new LP Providers has increased after the date that the pool was selected as the pool of the week.

For pool 837, the total volume of transactions decreased after the date that the pool was selected as the pool of the week.

For pool 837, the average volume of daily transactions has increased after the date that the pool was selected as the pool of the week, especially on November 26.

2-1 Pool 837 - Outflows & inflows

3- Pool #840 - BNB / OSMO

Charts Insights

For pool 837, on all days, the majority of all its transactions are related to the input values to the pool, and the output transactions have a very small percentage.

For pool 837, on all days, most of its users are related to the input values to the pool, and the output LPs have a very small percentage.

For the 833 pool, new LP providers who have made a transaction on the pool have often had an inflow transaction.

For pool 837, in most days, the volume transferred in transactions was related to the volume of the input to the pool, and the output volume is much less than the input volume.

For pool 837, the average volume of input to the pool is higher than the average output volume on most days, but on some days, the average output volume was higher, especially on November 26.

Charts Insights

For pool 840, the number of transactions after the date that the pool was selected as the pool of the week has increased, especially on November 29.

For pool 840, the number of LP Providers has increased slightly after the date that the pool was selected as the pool of the week.

For pool 840, the number of new LP Providers has decreased after the date that the pool was selected as the pool of the week.

For pool 840, the total volume of transactions decreased after the date that the pool was selected as the pool of the week. but on December 1 and 2 it increased significantly.

For pool 840, the average volume of daily transactions has increased after the date that the pool was selected as the pool of the week, especially on December 2.

3-1 Pool 840 - Outflows & inflows

Charts Insights

For pool 840, on all days, the majority of all its transactions are related to the input values to the pool, and the output transactions have a very small percentage.

For pool 840, on all days, most of its users are related to the input values to the pool, and the output LPs have a very small percentage.

For the 840 pool, new LP providers who have made a transaction on the pool have often had an inflow transaction.

For pool 840, in most days, the volume transferred in transactions was related to the volume of the input to the pool, and the output volume is much less than the input volume.

For pool 840, the average volume of input to the pool is higher than the average output volume on most days, but on some days, the average output volume was higher, especially on November 23.

4- Pool #634 - wETH.grv / OSMO

Charts Insights

For pool 634, the number of transactions after the date that the pool was selected as the pool of the week has decreased, especially on December 1 ,2 ,3, and 4.

For pool 634, the number of LP Providers has increased slightly after the date that the pool was selected as the pool of the week.

For pool 634, the number of new LP Providers has decreased after the date that the pool was selected as the pool of the week.

For pool 634, the total volume of transactions decreased after the date that the pool was selected as the pool of the week.

For pool 634, the average volume of daily transactions has decreased after the date that the pool was selected as the pool of the week.

4-1 Pool 634- Outflows & inflows

Charts Insights

For pool 634, on all days, the majority of all its transactions are related to the input values to the pool, and the output transactions have a very small percentage.

For pool 634, on all days, most of its users are related to the input values to the pool, and the output LPs have a very small percentage.

For the 634 pool, new LP providers who have made a transaction on the pool have often had an inflow transaction.

For pool 634, in most days, the volume transferred in transactions was related to the volume of the input to the pool, and the output volume is much less than the input volume. but we can see on November 25 the amount of outflow was higher than inflow.

For pool 634, the average volume of input to the pool is higher than the average output volume on most days, but on some days, the average output volume was much higher, especially on November 25.

Conclusion

Almost in all pools, the number of transactions after the date that the pool was selected as the pool of the week has decreased.

Almost in all pools, the number of LP Providers has increased slightly after the date that the pool was selected as the pool of the week.

Almost in all pools, the number of new LP Providers has decreased after the date that the pool was selected as the pool of the week.

Almost in all pools, the total volume of transactions decreased after the date that the pool was selected as the pool of the week.

Almost in all pools, the average volume of daily transactions has decreased after the date that the pool was selected as the pool of the week.

Almost in all pools, on all days, the majority of all its transactions are related to the input values to the pool, and the output transactions have a very small percentage.

Almost in all pools, on all days, most of its users are related to the input values to the pool, and the output LPs have a very small percentage.

Almost in all pools, new LP providers who have made a transaction on the pool have often had an inflow transaction.

Almost in all pools, on most days, the volume transferred in transactions was related to the volume of the input to the pool, and the output volume is much less than the input volume.

Almost in all pools, the average volume of input to the pool is higher than the average output volume on most days, but on some days, the average output volume was much higher.