Pool of The Week
Introduction
The Osmosis blockchain is a distributed network that is managed by a large group of developers and front-ends (100+ validators and full nodes). You may quickly acquire knowledge of the Osmosis blockchain, create applications for it, and incorporate it into your existing infrastructure by perusing our documentation and examining our demonstrations.
The OSMO token is a governance token that allows staked token holders to decide the future of the protocol, including every implementation detail.
To facilitate decentralized trade, AMMs collect and store a variety of digital assets under the supervision of a smart contract. Liquidity providers deposit their assets into the pool and profit from fees when customers make trades using the pool rather than the traditional order book mechanism enabled by smart contracts. The act of placing assets into an AMM pool is known as providing liquidity (or "LPing"). Asset swaps can be made through AMMs, which are decentralized finance protocols.
Method
This dashboard’s aims is to monitor the liquidity-providing activities occurring across the aforementioned pools of the Week program. In this investigation, osmosis.core.fact liquidity provider actions will serve as our primary data source. Both the date of analysis and the announcement date need to be filtered for each pool, with pool id set to the corresponding pool's identifier (#ID). Since there are 2 different currencies for each pool (OSMO + Other Token), determining the USD worth of liquidity-providing acts is a significant difficulty. To do this, we need to link the osmosis.core.dim prices table with the osmosis.core.dim labels table. However, not all assets' currencies were included in the price table's list of supported currencies, so I had to add them myself (using the union command). Token price is 1 OSMO (stOSMO). An equivalence of $1 in IST, or Inter Stable Coin. Also I found the daily price of BNB tokens in ethereum.core.fact hourly token prices.
And I got the current market price of WETH.grv by querying the osmosis.core.dim prices table.
:hourglass_flowing_sand: Overall View
The current section graphs represent an overall view of assessed pools in total since their announcement to present.
As of shown charts , the pool of stOSMO / OSMO has had the most LP volume in & out, total active unique LPer and LP transactions, that is normal, because of the start date for this pool was earlier than others.
As the chart right shows, the IST / OSMO pool has the most average LP volume out with $923.3 volume in average, that followed by BNB/OSMO with $437.1 outflow volume in average.
:hourglass_flowing_sand: The visuals below show the LP metrics of all pools over time since their announcement to present.
✍🏻 Conclusion
As of Findings above:
- With $710.6K in LP net volume, stOSMO / OSMO has the most amount of LP money entering its pool.
- The majority of pools (with the exception of wETH.grv / OSMO) exhibit a rising trend for their entering LP volume and a falling trend for their exited LP volume, indicating that they have been gaining volume across the observed time frames.
- stOSMO / OSMO has attracted the largest number of new users and active users, as well as the largest number of transactions directly related to increasing the pool's LP amount.
- The bulk of these pools (with the exception of the Out charts on stOSMO and OSMO) appear to have been decreasing the number of users or the number of transactions.
About:
-
Author: HaM☰d
\
-
Discord: 0xHaM☰d#8391
\
-
Twitter: @arjmandi_hamed
\
-
Email: h_arjmandi2012@yahoo.com
Track LP volume in and out of pools
Since the start of November, the Osmosis Support Labs team has run the Pool of the Week program, highlighting important and/or new pools within the ecosystem. What kind of impact has this program had on the liquidity of these pools?
Track LP volume in and out of these pools based on the following dates:
> * 11/11/22 Pool 833 - stOSMO / OSMO > * 11/15/22 Pool 837 - IST / OSMO > * 11/22/22 Pool 840 - BNB / OSMO > * 11/29/22 Pool 634 - wETH.grv / OSMO
For each pool track from date above to present. \n
Hey there 👋!
Firstly, I appreciate you sticking with it until the conclusion.
I'm Hamed, a civil engineering Ph.D.
student interested in data analysis.
I've made many similar dashboards and visualizations since I started at Flipside in January.
Please take a look at my various contact details and let me know what you think.
:mag_right: Findings:
The charts above show the LPing metrics for each pool over time, from their announcement date to the present.
As can be seen, the number of transactions and active LPers has increased over time. and normally the stOSMO/OSMO pool is the most popular pool based on LPing metrics.
The chart to the right shows the average LP volume in and out per pool by day. As can be observed, except on some days, the stOSMO/OSMO pool has the highest average volume over time. However, on November 23rd and 26th, the BNB/OSMO and IST/OSMO had the highest average volume.
Also, in terms of new LPers wETH.grv/OSMO had the lowest number of new LPers since announcement date.
:mag_right: Findings:
The combined graph right shows the LP volume in and out, net volume and growth of net volume over time for IST/OSMO since their announcement date to present.
As can be seen total net volume is over $104.73K into the pool
The Outflow and inflow volume peaked at $46.3K & $42.4K in Nov 26th & Dec 1th, respectively.
Overall, the daily number of active LPers and into transactions directions are too more than out direction.
:mag_right: Findings:
The combined graph right shows the LP volume in and out, net volume and growth of net volume over time for BNB/OSMO since their announcement date to present.
As can be seen total net volume is over $6.3K into the pool
The Outflow and inflow volume peaked at $35.6K & $12.6K in Nov 23th & 28th, respectively.
Overall, the daily number of active LPers and into transactions directions are too more than out direction.
:mag_right: Findings:
The combined graph right shows the LP volume in and out, net volume and growth of net volume over time for wETH.grv/OSMO since their announcement date to present.
As can be seen total net volume is over $226.07 into the pool
The Outflow and inflow volume peaked at $204.9 & $3K in Dec 3th & Nov 30th, respectively.
Overall, the daily number of active LPers and into transactions directions are too more than out direction, but it decreased over time.
:mag_right: Findings:
The combined graph right shows the LP volume in and out, net volume and growth of net volume over time for stOSMO/OSMO since their announcement date to present.
As can be seen total net volume is over $710.06K into the pool.
The Outflow and inflow volume peaked at $33.7K & $160K in Nov 16 & 23th, respectively.
Overall, the daily number of active LPers and into transactions directions are too more than out direction.
