Try Quests to earn cryptoCosmoverse Free Play
Introduction
Cosmoverse is an event highlighting the Cosmos / Interchain ecosystem and its many participants, including Secret Network!
Blockchain technology could create a more decentralized, empowering web. But it has one big flaw.
Almost every blockchain is public by default, exposing all your data on-chain for everyone to see. This puts users at risk and blocks the widespread adoption of Web3.
Secret Network aims to change this by serving as the Web3 privacy hub.
Method
In the current dashboard, I tried to analyze the swaps and swappers activity of SCRT on the Osmosis DEX during the past week. Then, going to analyze the LP and LPers activity on SCRT Liquidity Pools during the past week.
For Swaps analysis, I used osmosis.core.fact_swaps table, osmosis.core.fact_liquidity_provider_actions table For Liquidity Pool Analysis.
-
SCRT Token Contract Address = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A' (Decimals = 6)
\
As mentioned in the bounty question, the data analyzed below are for the last 7 days (during the past week). but you can change it to your own period choice.
The Idea of the this research is credited to these dashboards [1] & [2]
:chart_with_downwards_trend: Average Price Change Over Last Week
- Based on the Right chart, SCRT token has experienced almost 5.3% fell in price during the past week (from $0.93 on 4th October to 0.88 on 8 October) that have had positive correlation with BTC price (from $19.63 on 4th October to 19.06 on 8 October)
:whale2: Top 10 hodlers:
- The bar chart in the right and PIE graph in side, shows the top 10 SCRT hodler addresses in the current date.
- OSMO1gdg…jp4m with 300K SCRT token is the top holder with more than 26% of token supply.
:radioactive: Active Users over time:
- On the Right line chart, can be seen that daily number of new SCRT swappers from its listing on Osmosis till today.
- As can be observed, the daily trend of new SCRT swappers is kinda decreasing over time and its growth rate has almost a constant light slope since April 15th, till today.
- Most number of new SCRT swappers have achieved during Feb 2022, with more than 2.46K per day.
✍🏻 Conclusion
Buying and Selling SCRT Tokens
> * As excepted the SCRT price are in a positive correlation with BTC. > * OSMO1gdg…jp4m with 300K SCRT token is the top holder with more than 26% of token supply. > * Transactions Concerning a Rolling Changeover in the SCRT > * Most number of new SCRT swappers have achieved during Feb 2022, with more than 2.46K per day. > * during the past week, there were 2.41k swaps from SCRT to other tokens made by 1.9K unique swappers. On the contrary, there were 2.57k swaps to SCRT from other tokens made by 1.64K unique swappers. So, The activity of swaps from SCRT to other tokens during the past week was as same as swaps to SCRT token.
SCRT Pools Event
> * The SCRT/OSMO pool shrank from over $2.8M SCRT And $1.4M OSMO in March to half in June. > * There has been a steady decline in the number of liquidity providers contributing to the SCRT/OSMO Pool beginning in December 2021. > * Running supply of LP tokens sharply declined since Apr 25th.
About:
-
Author: HaM☰d
\
-
Discord: 0xHaM☰d#8391
\
-
Twitter: @arjmandi_hamed
\
-
Email: h_arjmandi2012@yahoo.com
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.
Based on the second two above charts, the user address osmo10g69…d2zk has made the most number of swaps From and To SCRT during the past week (102 swaps with total $103.3K volume and 117 tx swapa and 98.9K volume, respectively) while the user address osmo1trh8fmmxn7r2w3wn85gp4y0gj8hq97fzuee67a has made the most volume of swaps ($77,273 in 2 swap transactions) among all other SCRT swappers.
On the contrary, the user address osmo13zgvlec8zz9vmh9pe93deg3d4r97wu6yl9zf25 has made the most number of swaps To EVMOS during the past week (451 swaps with total $32,997 volume) while the user address osmo1h25pc432t23htkemmpw3ucm09nepxtqhsc43dz has made the most volume of swaps ($134,693 in 14 swap transactions) among all other swappers during the past week.
In the following section tried to track LPer’s Activities over last 7 days
According to the following charts, he first day of last 7 days have had most adding liquidity and removing.
overall, from Sep 4th till 8th, the pool_joined (Add Liquidity) was more than pool_exited (Remove Liquidity) and after that the removing passed add liquidity.
:telescope: Findings:
The pools for adding SCRT were in three categories, such as SCRT/ATOM, SCRT/OSMO and others.
As can be seen the others have had more that 99.5% of LPer’s activities.
In Oct 9th, the highest volume of SCRT transacted to other pools.
According to the above charts, the volume of Add Liquidity actions (= pool_joined) ($2.35k) via SCRT against to Remove Liquidity actions (= pool_exited) ($13.1k) is too low.
But, the average removed liquidity by SCRT from pools ($1.5K) is more than adding liquidity actions ($181).
:telescope: Findings:
-
The chart on the left shows another view of the apparent slowdown in new liquidity provision to the pool, especially in the past week.
-
Running supply of LP tokens sharply declined since Apr 25th.
-
Mints have decreased and more LP tokens are burned than minted, indicating a net removal of liquidity.
-
In the past 7 days, there is a net outflow of liquidity from the pool as a direct result of LPs withdrawing their funds.
-
Since early of recent Sep, the pool tokens reservoir for SCRT and OSMO had a smooth recovery.
The last sections in the following allocated to top 10 popular origin and destinations of swapped transactions To and from SCRT on past 7 days.
:telescope: Findings:
According to the above charts, during the past week, there were 2.41k swaps from SCRT to other tokens made by 1.9K unique swappers. On the contrary, there were 2.57k swaps to SCRT from other tokens made by 1.64K unique swappers. So, The activity of swaps from SCRT to other tokens during the past week was as same as swaps to SCRT token.
But, the volume of Swaps to SCRT ($426.4K) is less than the volume of swaps from SCRT ($489.5K) during the past week. Also, the Average and median swaps from SCRT is more than swaps to SCRT.
On the above charts, we can see there are more swaps from SCRT to other tokens in all days except Oct 4th. Moreover, we can see highest activity of SCRT swaps on Friday- 6th October.
But in terms of volume, as mentioned above, the daily volume of swaps To SCRT in almost all days is a little less than Swaps from SCRT.