Method
> To solve this question, I used the following three tables from the Phippside tables and also got help from others. > > > 1. osmosis.core.dim_prices > 2. osmosis.core.dim_labels > 3. osmosis.core.fact_liquidity_provider_actions
Question❓
> Analyze how users join pools on Osmosis. > > Do they dive in headfirst (add both assets; joinpool) or do they wade in carefully (singleside; join swap extern amount in). Also analyze how deep the pool is (typical swap size in token and USD for both activities).
- 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
Analysis
> The data of this section about the daily price of osmos is daily from the beginning of the year until now. > > As you can see, with the passage of time, we have seen a decrease in the price, the price has reached from ten dollars to one dollar, part of it is due to the overall fall of the market.
Analaysis
> The graph on the left represents the number of users who have joined the pools over time, this graph is divided into two groups ( single sid / both assets ). > > As you can see, since the end of last year, we have seen an increase in the number of users in each category, and since the end of March, we have seen a decrease in this trend. > > This trend at the end of the previous year was caused by the entry of user join the pool by single side . > > The highest amount on March 1 this year is single side user = 5398 and both assets = 8435. > > The second chart is exactly like the first chart, and the highest amount of transactions on March 1st with the number single side transaction = 8985 TX and both assets transaction = 15000TX.
> The diagram on the left is about the volume of USD entering the pools, which is almost similar to the two diagrams above, with the difference that before the gradual increase in volume, on October 3rd, we see a sharp increase in the volume of deposits, which is equal to $109.5 USD
Analaysis
> This section contains three pie charts, which represent the number of users, the number of transactions, and the volume of input to osmosis pools based on Do they dive in headfirst (add both assets; joinpool) or do they wade in carefully (singleside; join swap extern amount in). > > In terms of the number of users, 67.3% dive in headfirst (add both assets; joinpool) and 32.7% they wade in carefully (singleside ) > > About the number of transactions is 65.8% for both assets join and 34.2 % for single side join > > But in terms of volume, this percentage is slightly different. > > 86.9% for both assets join and 13.1 % for single side join

Analysis
> In this section, we see the review of each assets based on the criteria of the number of users, the number of transactions, and the USD volume.
>
>
> As it is known, in all three parameters, the osmosis token is ranked first, followed by the atom token. In all three parameters, the value of Both assets is always greater than Single Side.
>
> ## in terms of Total user :
>
> 1.osmo with 142K for Both Assets
>
> and 67.9 K for single side
>
>
> 2. Atom with 123.6 K for Both assets
>
> and 25.5 K for Single Side
>
>
>
> ## in terms of Volume USD :
>
>
> 1. Osmo with $ 1B USD for Both Assets
>
> and $ 175.5 K USd for Single Side
> 2. Atom with $629 M USD for Both Assets
>
> and $96 M USD for Single Side
>
>
> ## in terms of Transaction :
>
> 1.Osmo with 1.89 TX for Both Assets
>
> and 711K TX for Single Side
>
>
> 2. Atom with 708K TX for Both assets
>
> and 92.8K TX for Single Side
>
> \
Analysis
> The information in this section is about the number of Both Assets swaps & Swapers & Volume of swaps for each Assets, which is displayed as a percentage. > > As it can be seen, in all three sections, the highest percentage is related to Osmo token with more than 40 %, Atom token ranks second respectively with 24.9 % for Volume USD and 23.1 % for swapers and 18.7 % for number of swaps.
- Join swap
-
Number of swap = OSMO / ATOM / STARS / JUNO
-
Swappers = OSMO / ATOM / JUNO / STARS
-
USD volume of swaps = OSMO / ATOM / JUNO / XRPT
\
-
Analysis
> The information in this section is about the number of Single Side swaps & Swapers & Volume of swaps for each Assets, which is displayed as a percentage.
>
> As it can be seen, in all three sections, the highest percentage is related to Osmos token with more than 50 %, in terms of the number of swapers and USD volume, Atom token ranks second respectively with 11.2 % and 30 % , but in terms of the number of transactions, Stars token is ranked with 8.38%.
>
> * Join swap
> * Number of swap = OSMO / STARS / ATOM / HUAHUA
> * Swappers = OSMO / ATOM / STARS / HUAHUA
> * USD volume of swaps = OSMO / ATOM / JUNO / SCRT
>
> \
> # ✍️ conclusion
- First with the passage of time, we have seen a decrease in the price, the price has reached from ten dollars to one dollar, part of it is due to the overall fall of the market.
- As we have seen, there are differences in how users enter the pools, and this process has changed over time. But always the number of people who dive in headfirst (add both assets; joinpool) is far more than those who wade in carefully (singleside; join swap extern amount in)
- Osmo is always the main token to join the pool and Atom token is in the second place.
- In the beginning, only Both Assets deposits were made, but since the end of last year, we have seen the arrival of Single sid deposits, which has caused an increase in joining the pool in two-way mode as well.
> # THANKS 🙏

Discord name : Majid#1786