Objectives

in this dashboard i want to compare tow method of joining in osmosis blockchain pools.at the first there are some definitions to getting know with subject, then there is a mythology that show what i have to do, at last there are some figures and observations to analyzing the subject.

Introduction

• what is osmosis blockchain?

  Osmosis is Layer-1, Proof-of-Stake (PoS) blockchain built using the Cosmos SDK that has optimized its design to be a sandbox for automated market makers (AMMs). The chain enables developers to design and deploy customized AMMs by using its various modules and leveraging Osmosis' on-chain governance system. Osmosis' native token, OSMO, grants holders the right to vote on proposed network changes and earn rewards for helping secure the network. Its first application, also called Osmosis, is an AMM that features ATOM and OSMO as its initial base trading pairs.[source]

  \

• What is the history of osmosis?

  The introduction of automated market makers (AMMs) ushered in a new era of crypto-economic utility and bonding curve applications. AMMs have become an essential element of DeFi infrastructure, and every new ecosystem must have an exchange with liquidity pools to support basic tokens swaps and the creation of supplementary financial products.Osmosis is an AMM protocol created using the Cosmos SDK. The project was announced in October 2020 and launched on Jun. 19th, 2021. Its core developers include Sunny Aggarwal, Josh Lee, and Dev Ojha. Osmosis' vision is that rather than aiming for a one-size-fits-all strategy for AMMs and their liquidity pools, it could provide a sandbox for AMM development. The protocol enables developers to iterate on new, customized AMM designs by using the existing liquidity pools and modules already running on the network. It also features an on-chain governance system that allows each AMM pool's stakeholders (i.e. liquidity providers) to control and direct their pools.

  Osmosis was the first Cosmos-based chain to popularize IBC transfers. IBC transfers had been available for several months before but there was little actual demand from the connected chains; therefore, the volume of IBC transfers was extremely low. Being the first AMM on Cosmos, Osmosis offered the ability to trade and earn rewards through liquidity provision.[source]

  \

• what is staking pools and how they work?

  Staking pools enable holders of a cryptocurrency to pool their assets together to increase the chances of being chosen to verify the next block of transactions on a blockchain network. Similar to mining pools used in the Proof of Work (PoW) consensus algorithm, network participants contribute computational resources to garner adequate hash rate (or hash power), allowing them to gain a competitive advantage over other network participants. Both models issue staking rewards, which are then distributed amongst each participant of the pool (either mining or staking).

  Staking pools are used on Proof of Stake (PoS) blockchain networks only. Proof of Stake (PoS) is a consensus algorithm that selects a node operator at random to verify the next batch of transactions based on their stake in the network. This simply means that the system tends to select a network participant with higher stakes in the network as they have more to lose, hence ensuring the security of the entire blockchain network.

  Staking pools are typically run by a pool operator, requiring pool participants to lock their stake (coins) in a specific blockchain address. This collective staking improves the validators staking power on the network, thereby increasing their chances of being selected by the consensus algorithm. When the network issues staking rewards, they are distributed to stake pool delegators based on their contributions to the pool.[source]

  
  \

Methodology

in this dashboard the following methods are used:

1. analyze the ‘single side’ join

   1.1 analyzie users behavior

   1.2 analyze each pool id

   1.3 analyze each token

   1.4 top five users with most USD volume deposited

2. analyze the ‘both assets’ join

   2.1 analyze users behavior

   2.2 analyze each pool id

   2.3 analyze each token

   2.4 top five users with most USD volume deposited

3. compare each method of joining

in this dashboard the following tables are used:

1. osmosis.core.fact_liquidity_provider_actions
2. osmosis.core.dim_prices
3. osmosis.core.dim_labels

Part 1 / analyze the ‘single side’ join

Part 1.1 / analyzing users behavior

Observations 1

• total number of joins with single side join is 1.222M.
• total number of unique users that joined with single side join is 85.2k.
• total USD volume with single side join is 1.124M.
• at Mar 18,2022 most number of joins with single side join has happened that is 9399.
• at Mar ,2022 most number of joins with single side join has happened that is 248.7k.
• at Mar 18,2022 most number of unique users with single side join have joined that is 6197.
• at Mar,2022 most number of unique users with single side join have joined that is 150.4k.
• at Jan 4,2022 most USD volume with single side join has deposited that is 7.07M.
• at Jan,2022 most USD volume with single side join has deposited that is 85.6M.

Part 1.2 / analyze each pool id

Observations 2

• Pool Id = 1,has most join with single side join that is 188.7k and 15.4% of total joins with single side join.
• Pool Id=1, has most unique users that joined with single side join that is 57.05k and 25.2% of total unique users that joined with single side join.
• Pool Id=1,has most USD volume that deposited with single side join that is 91.4M and 28.4% of total USD volume that deposited with single side join.

Part 1.3 / analyze each token

Observations 3

• OSMO token ,has most join with single side join that is 711.18k and 58.2% of total joins with single side join.
• OSMO token, has most unique users that joined with single side join that is 67.9k and 43.6% of total unique users that joined with single side join.
• OSMO token, has most USD volume that deposited with single side join that is 175.4M and 54.5% of total USD volume that deposited with single side join.

Part 1.4 / top five users with most USD volume deposited

Observations 4

• Top five users that have most USD volume deposited with single side join:

Part 2 / analyze the ‘both assets’ join

Part 2.1 / analyzing users behavior

Observations 5

• total number of joins with both assets join is 3.79M.
• total number of unique users that joined with both assets join is 154.4k.
• total USD volume with both assets join is 2.14B.
• at Mar 1,2022 most number of joins with both assets join has happened that is 26.29k.
• at Mar ,2022 most number of joins with both assets join has happened that is 600.23k.
• at Mar 18,2022 most number of unique users with both assets join have joined that is 9215.
• at Mar,2022 most number of unique users with both assets join have joined that is 222.4k.
• at Oct 3,2022 most USD volume with both assets join has deposited that is 109.4M.
• at Jan ,2022 most USD volume with both assets join has deposited that is 373.8M.

Part 2.2 / analyze each pool id

Observations 6

• Pool Id = 1,has most join with both assets join that is 810.29k and 21.4% of total joins with both assets join.
• Pool Id=1, has most unique users that joined with both assets join that is 111.26k and 23.2% of total unique users that joined with both assets join.
• Pool Id=1,has most USD volume that deposited with both assets join that is 788.39M and 36.8% of total USD volume that deposited with both assets join.

Part 2.3 / analyze each token

Observations 7

• OSMO token ,has most join with single side join that is 1.89M and 49.9% of total joins with single side join.
• OSMO token, has most unique users that joined with single side join that is 142.12k and 30.4% of total unique users that joined with single side join.
• OSMO token, has most USD volume that deposited with single side join that is 1.06B and 49.5% of total USD volume that deposited with single side join.

Part 2.4 / top five users with most USD volume deposited

Observations 8

• Top five users that have most USD volume deposited with both assets join:

Part 3 / compare each method of joining

\

• Thanks for reading my dashboard, please share your insight about it with me :grinning:
• link of tweet that I shared my dashboard :

Observations 9

• number of joins with both assets is more than single side and 75.6% of total joins.
• number of unique users with both assets is more than single side and is 65.5% of total unique users.
• total USD volume os both assets is more than single side and is 99.9% of total USD volume that deposited.