Liquidity Pools - Wallet Composition

Introductionđźš©
What is OSMOSIS?
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.
More Info
What is OSMO(Token)?
The Osmosis token (OSMO) is used to vote, stake, and provide liquidity throughout its pools. Superfluid staking, a process novel to the Osmosis protocol, allows users to stake assets to secure the network while simultaneously providing assets in a liquidity pool.
More Info
Method⚡
I extracted the needed data from ==Osmosis.core== schema provided by Flipsidecrypto.
I mainly used ==“osmosis.core.fact_liquidity_provider_actions”== and ==“osmosis.core.fact_swaps”== tables to gather the LP data.
Also i used ==“osmosis.core.dim_prices”== and ==“osmosis.core.dim_labels”== for some additional information and calculate the prices or finiding currencies names.
I used parameter for Pool_ids on some charts and you can insert any Pool_id that you want and see the data for it.
I didnt used any specific time range and this dashboard made on ==2022-10-25.==
Findingsđź‘€
- As we see in the top 5 pools bar chart in terms of users, obviously the first pool that launched on Osmosis zone is the first and the biggest.(ATOM/OSMO)
- The second and the third pool are for JUNO that pairs with the most popular tokens on Osmosis zone which are OSMO and ATOM
- Number of users or swappers peaked on March 2022 and most of them were for ATOM/OSMO Pool
- After March, number of users saw a massive decline and most of the decrease was for USTC/OSMO and NGM/OSMO
Findingsđź‘€
- ==“osmo1s3uhtyzcu2ft4w2dhjtew3gt3lpmc2az2rw5ll”== has deposited the most value between top 10 addresses with 6.95M deposit size, it is also the maximum deposit size between all the wallets
- There are a total of 119K liquidity providers deposited an average of 776 amount
- These top 10 wallets accounts almost 25% of all of the wallets and ==“osmo1s3uhtyzcu2ft4w2dhjtew3gt3lpmc2az2rw5ll”== wallet address accounts 7.54% of all by itself
Findingsđź‘€
- Osmosis experienced a huge spike on March 1st 2022 on both LP transactions and LP users
- On that day, it touched its TVL and then dropped badly after March’s first day
- Osmosis had its highest LP transactions and LP users on March and most of the users had less than 100$ (Shrimp)
- Over 85% LPers have less than 1000$
- Over 80% of LP transactions were less than 1000$
- Number of Monthly transactions and users saw a huge drop after March 2022
Conclusionđź’ˇ
- There was a strange drop to activities on almost all of the activities on June 8 2022 this must be due to a exploit found by the Devs which came down to closing the DEX for further investigation
- ATOM/OSMO is the most popular and the biggest pool on Osmosis Network
- Osmosis recorded an all-time high on both LP transactions and users on March 1st 2022 and had the highest number of LP transactions and LPers in that month too
- ==“osmo1s3uhtyzcu2ft4w2dhjtew3gt3lpmc2az2rw5ll”== is the biggest LPer and recorded the largest deposit value with 6.95M
- 62.6% of LPers have less than 100$ balance
- There are a total of 119K liquidity providers deposited an average of 776 deposit size