Cosmoverse Free Play

    What is the question?🚨


    This is an open bounty for ==Cosmoverse Free Play== (Osmosis) and i am going to analyze some metrics for ==HUAHUA== token or ==CHIHUAHUA== on Osmosis.

    What we will cover in this dashboard?🌊


    1. Swapping Activity
    2. Liquidity Pools Stats

    Method⚡


    For this bounty, i analyzed ==HUAHUA== token on osmosis, ==HUAHUA== or ==CHIHUAHUA== is the first interoperable meme coin with a POS blockchain, one the most utilized chains in the cosmos ecosystem. At first i analyzed some swap metrics from it and then i went to Liquidity Providing stats and explored it too and did some analysis on it.

    To collect the desired information i used Osmosis.core database provided by **Flipsidecrypto **and used multiple tables from it.

    I used ==“osmosis.core.dim_prices”== table to calculate HUAHUA price with it and filtered HUAHUA token in that table with symbol = 'HUAHUA‘ then i used ==“osmosis.core.fact_swaps”== to gather the swap data and filtered HUAHUA token with its contract address:

    ==“ibc/B9E0A1A524E98BB407D3CED8720EFEFD186002F90C1B1B7964811DD0CCC12228”== ,

    at last i used ==“osmosis.core.fact_liquidity_provider_actions”== table to collect the LP data and filtered 2 HUAHUA popular pools ==OSMO/HUAHUA== and ==ATOM/HUAHUA== with their pool_id:

    pool_id in (605,606)

    I also used action = 'pool_joined' for adding liquidity and action = ‘pool_exited‘ for removing liquidity from the pools.

    All the charts and analytics that you are going to see are since the last week until now and i used current_date - 7 to specify the time range ==Oct 5th ~ Oct 12th==

    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 HUAHUA?

    Chihuahua is a meme coin and aims to be a community-driven project with a Community Pool of 10B HUAHUA that can be used to fund projects on top of the chain proposed and voted via the Governance built-in in the Chihuahua chain.

    More Info

    Chihuahua Social Media:

    Twitter

    Github

    Medium

    Telegram

    Discord

    db_img
    db_img
    Loading...

    1. Swapping Activity

    Findings👀


    • A total of 1652 swappers made 4160 swaps in the past week
    • Number of swaps and swappers together recorded an all-time high on Oct 10th in the past week with 552 swaps and 329 swappers
    • Oct 12th so far was the worst day in the past week but its not over yet and the data is not complete
    • Number of swaps is approximately moving with number of swappers and they are directly related to each other
    • HUAHUA recorded 285K swap volume in the last week and Oct 10th was its highest
    • Past 3 days volume together was more than the other days of the week volume together
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    2. Liquidity Pool Stats

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Findings👀


    • A total of 90 users made 112 LP transactions and recorded 4230 LP volume in USD in the past 7 days
    • Oct 5th and Oct 6th had more users and transactions than other days
    • Number of adding and removing liquidity transactions and users were almost the same in everyday
    • Removing liquidity volume in USD was so much more than adding liquidity volume in the past week
    • Daily liquidity volume was peaked on Oct 11th and most of it was pool_exited with 2,071$
    • According to the bar chart above, Oct 9th was the worst and Oct 11th was the best day for daily LP volume but if we look more precisely, we see that users are removing liquidity on Oct 11th and it is actually a bad day for the pools
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Findings👀


    • According to the pie charts, removing transactions and removers are a few percent more than the other one
    • 97.4% of LP volume is removing liquidity, it means that removers are removing large amounts of assets from the pools
    • ==“osmo1xmuy888e2lpe09qmy2qxkw9mkny5mtqxp48dfn”== was the biggest HUAHUA pools liquidity provider with 347.7K in the past week
    • Except the above address and ==“osmo1pv9uugf8xtma3tm5a3hlfdq8pwuns5h8wexxqp”== , rest of them provided under 200K liquidity
    • ==“osmo1dha5czlnt79c2y4qen62pkvy8gv5jsl8m0equz”== and ==“osmo15ggj3hch4wfrzwehchpavjzqhcl76mn68zu6uj”== both has made 4 transactions on HUAHUA popular pools and the rest of the top 10 made under 3 transactions
    • 61% (959) of Wallets just swapping their assets than both providing and swapping
    • Swappers are mostly one time users and they do 1 transaction(Swap) then disappear but LP providers are usually doing over 1 transaction
    • Swappers are almost double the LP providers

    Conclusion💡


    • Since the beginning of the week, 1000HUAHUA price dropped almost 10% and then recovered and rised approximately 30% until Oct 10th (20% increase in last 7 days )
    • Over 1650 swappers swapped their assets in the past week and made over 4150 transactions
    • There were more LPers in the beginning of the week than ending
    • Oct 10th had the largest swap volume in USD with 88.4K and Oct 11th had the largest LP volume in USD with 2076.66
    • Most of LPers removing their assets from the pools and there is more removing transactions than adding
    • ==“osmo1xmuy888e2lpe09qmy2qxkw9mkny5mtqxp48dfn”== is leading the liquidity providers by amount with 347.7K provided liquidity in the last week
    • Most of the users only made swap and for some reason didnt like to provide liquidity
    • Swappers are more than 1500 and LPers are less than 1000

    Author: Sbhn_NP

    Discord : Sbhn_NP#8717

    Twitter : Sbhn_np

    Instagram : Sbhn_NP

    Thanks for your time!

    Loading...
    Loading...
    db_img