Untitled BoardBinance Bonanza

    On October 28th, 2022 Binance became the first CEX to list spot trading for $OSMO. Abruptly, OSMO price shot up around 32%. How did this news impact trading on Osmosis. Analyze OSMO trading activity on October 28th and this past week vs. daily & weekly averages. This analysis should occur against two time periods: the 60-day averages & the 60-days prior to the May Terra collapse. Did any other tokens see a spike in trading on Osmosis?

    db_img

    What is Osmosis and what is its purpose?

    Osmosis is an advanced Automated Marketer Protocol (AMM) that allows developers to build custom AMMs with robust liquidity pools. Osmosis is built using the Cosmos SDK and uses the Inter-Blockchain Communication (IBC) feature to enable cross-chain transactions. The Cosmos

    ecosystem follows the "Blockchain as Decentralized Program" architecture; This means that Osmosis is a blockchain connected to Cosmos Hub, which is also a decentralized exchange.

    Osmosis, with the help of IBC, connects to the entire ecosystem of Cosmos chains and their more than 10 billion dollars of native assets. After supporting active blockchains on the Cosmos hub, the project aims to connect to other chains such as Ethereum and Bitcoin.

    allows users to create liquidity pools with unique parameters. For example, as you know, two tokens with an equal ratio should be added in normal liquidity pools; But in this project, pools with multiple ratios can be created. Osmosis rewards structure is also compatible with these capabilities.

    Osmosis got ideas from three automatic market makers, UniSwap, Balancer and Crew Finance; Therefore, it can be said that it has the advantages of all three mentioned AMMs.

    Methodology

    • The following code was used to extract the price of tokens
    select
        date_trunc(day,recorded_at)::date as date
        ,SYMBOL
        ,avg(price) as OSMO_PRICE
      from osmosis.core.dim_prices
    group by 1,2
    
    • The osmosis.core.dim_labels table was used to extract token names

    • Three time periods were considered in this analysis→

      Past Week -> date>='2022-10-28' 
      Sixty Days Ago -> date>='2022-8-28' and date<='2022-10-27'
      Terra Collapse ->date>='2022-03-12' and date<='2022-05-12'
      

    All charts of this analysis are defined on the basis of the above three time periods

    • The following wallets were used to find inflow and outflow in Binance

        when sender in ('osmo129uhlqcsvmehxgzcsdxksnsyz94dvea907e575','osmo1krmqr8zhvteevq4hnl7q0pxtff6xpnqz4ckxcu') 
        and receiver not in ('osmo129uhlqcsvmehxgzcsdxksnsyz94dvea907e575','osmo1krmqr8zhvteevq4hnl7q0pxtff6xpnqz4ckxcu') then 'Outflow From Binance'
        when receiver in ('osmo129uhlqcsvmehxgzcsdxksnsyz94dvea907e575','osmo1krmqr8zhvteevq4hnl7q0pxtff6xpnqz4ckxcu') 
        and sender not in ('osmo129uhlqcsvmehxgzcsdxksnsyz94dvea907e575','osmo1krmqr8zhvteevq4hnl7q0pxtff6xpnqz4ckxcu') then 'Inflow To Binance' 
        else 'Inner Binance Flow' 
      

    Queries are updated daily and the results of the last week may not match the result of the dashboard

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

    In the three graphs below, the number of transactions is compared with the daily price of OSMO in three time periods

    • In the period of Terra Collapse, the most transaction was on March 22, and at the same time, we are witnessing the fall in the price of OSMO
    • In the period of Sixty Days Ago, the most transaction was on September 9
    • In the last one week, we have seen the growth of the price of OSMO and the high number of transaction on October 28

    In the three graphs below, the growth of the number of wallets in three time periods And the growth of the number of transactions is compared with the daily price of OSMO

    • In the last one week, we have seen the growth of the price of OSMO and the growth of the number of wallets and the growth of the number of transactions on October 28

    In the three graphs below, the number of wallets is compared with the daily price of OSMO in three time periods

    • In the period of Terra Collapse, the largest number of wallets was on April 23, and we are witnessing the fall in the price of OSMO
    • In the period of Sixty Days Ago, the largest number of wallets was on September 14
    • In the last one week, we have seen the growth of OSMO price and the high number of wallets on October 28

    Transactions section

    Swaps section

    Loading...
    Loading...
    Loading...
    Loading...
    • The highest number of swaps OSMO was on May 12 in the Terra Collapse period and October 28 and the Past Week period(from)
    • The highest average OSMO swap volume was on May 10 during the Terra Collapse period, and on October 28 and the Past Week period(from)
    • The highest volume of OSMO swap from was on May 11 during the Terra Collapse period, and on October 28 and the Past Week period(from)
    • The most traders were on March 28 in the Terra Collapse period and October 28 and the Past Week period(from)
    Loading...
    Loading...
    Loading...
    Loading...
    • The average dollar volume of swaps during the Terra Collapse period is about 580 thousand
    • The average dollar volume of swaps Sixty Days Ago is about 153 thousand
    • The average dollar volume of swaps last week was about 511 thousand
    • The number of swaps during Terra Collapse is about 1 million
    • The number of swaps in the period of Sixty Days Ago is about 521K
    • The number of swaps during the past week is about 51K

    • The number of traders in the Terra Collapse period is about 108K
    • The number of swaps in the period of Sixty Days Ago is about 50K
    • The number of swaps during the past week is about 14K

    Swap ==from== OSMO

    Swap to OSMO

    Loading...
    Loading...
    Loading...
    Loading...
    • The highest average OSMO swap volume was on arch 21 during the Terra Collapse period, and on October 28 and the Past Week period(to)
    • The highest volume of OSMO swap from was on May 11 during the Terra Collapse period, and on October 28 and the Past Week period(to)
    • The highest number of swaps OSMO was on May 12 in the Terra Collapse period and October 28 and the Past Week period(to)
    • The most traders were on May 11 in the Terra Collapse period and October 28 and the Past Week period(to)

    Tokenology

    In this section, 5 popular tokens were analyzed in terms of the number of swaps, the number of traders, and the volume of swaps in three time periods

    Loading...
    Loading...
    Loading...
    • The highest number of swaps was on May 12 and for the OSMO token in the Terra Collapse period, followed by October 28 for the OSMO token in the Past Week period.
    • The highest number of traders was on March 21

      and for the OSMO token in the Terra Collapse period, followed by October 28 for the OSMO token in the Past Week period.

    • The highest volume USD$ of swaps was on May 11 and for the OSMO token in the Terra Collapse period, followed by October 28 for the OSMO token in the Past Week period.
    Loading...
    Loading...
    Loading...
    Loading...

    Outflow From Binance and Inflow To Binance

    Findings and conclusion

    Transactions→

    • In the period of Terra Collapse, the most transaction was on March 22, and at the same time, we are witnessing the fall in the price of OSMO
    • In the period of Sixty Days Ago, the most transaction was on September 9
    • In the last one week, we have seen the growth of the price of OSMO and the high number of transaction on October 28
    • In the period of Terra Collapse, the largest number of wallets was on April 23, and we are witnessing the fall in the price of OSMO
    • In the period of Sixty Days Ago, the largest number of wallets was on September 14
    • In the last one week, we have seen the growth of OSMO price and the high number of wallets on October 28
    • In the last one week, we have seen the growth of the price of OSMO and the growth of the number of wallets and the growth of the number of transactions on October 28

    Swaps→

    • The number of swaps during Terra Collapse is about 1 million
    • The number of swaps in the period of Sixty Days Ago is about 521K
    • The number of swaps during the past week is about 51K
    • The number of traders in the Terra Collapse period is about 108K
    • The number of swaps in the period of Sixty Days Ago is about 50K
    • The number of swaps during the past week is about 14K
    • The average dollar volume of swaps during the Terra Collapse period is about 580 thousand
    • The average dollar volume of swaps Sixty Days Ago is about 153 thousand
    • The average dollar volume of swaps last week was about 511 thousand
    • The average number of daily swaps in the Past Week period is about 30% higher than the Sixty Days Ago period and less than the Terra Collapse period
    • The average number of daily traders in the Past Week period is about 57% higher than the Sixty Days Ago period and the Terra Collapse period

    Swap From →

    • The highest number of swaps OSMO was on May 12 in the Terra Collapse period and October 28 and the Past Week period(from)
    • The most traders were on March 28 in the Terra Collapse period and October 28 and the Past Week period(from)
    • The highest volume of OSMO swap from was on May 11 during the Terra Collapse period, and on October 28 and the Past Week period(from)
    • The highest average OSMO swap volume was on May 10 during the Terra Collapse period, and on October 28 and the Past Week period(from)

    Swap To →

    • The highest number of swaps OSMO was on May 12 in the Terra Collapse period and October 28 and the Past Week period(to)
    • The most traders were on May 11 in the Terra Collapse period and October 28 and the Past Week period(to)
    • The highest volume of OSMO swap from was on May 11 during the Terra Collapse period, and on October 28 and the Past Week period(to)
    • The highest average OSMO swap volume was on arch 21 during the Terra Collapse period, and on October 28 and the Past Week period(to)

    Tokenology→

    • The highest volume USD$ of swaps was on May 11 and for the OSMO token in the Terra Collapse period, followed by October 28 for the OSMO token in the Past Week period
    • The highest number of traders was on March 21 and for the OSMO token in the Terra Collapse period, followed by October 28 for the OSMO token in the Past Week period
    • The highest number of swaps was on May 12 and for the OSMO token in the Terra Collapse period, followed by October 28 for the OSMO token in the Past Week period

    Outflow From Binance and Inflow To Binance →

    • The highest Inflow To Binance was on October 28 and the highest Outflow From Binance was on October 29 in terms of the number of transfers
    • The highest Inflow To Binance was on October 28 and the highest Outflow From Binance was on October 30 in terms of the number of wallets
    • The highest Inflow To Binance was on October 28 and the highest Outflow From Binance was on October 29 in terms of the OSMO volume
    • The highest Inflow To Binance was on October 28 and the highest Outflow From Binance was on October 29 in terms of the OSMO volume USD$

    Conclusion→

    It seems that in all the parameters of this dashboard, after the Terra Collapse in the period of list spot trading for $OSMO by Binance on October 28, we see the highest quantity statistics.

    The dashboard link has been tweeted

    • The highest Inflow To Binance was on October 28 and the highest Outflow From Binance was on October 29 in terms of the OSMO volume USD$
    • The highest Inflow To Binance was on October 28 and the highest Outflow From Binance was on October 30 in terms of the number of wallets
    • The highest Inflow To Binance was on October 28 and the highest Outflow From Binance was on October 29 in terms of the number of transfers
    • The highest Inflow To Binance was on October 28 and the highest Outflow From Binance was on October 29 in terms of the OSMO volume
    Loading...
    Loading...
    • The average number of daily swaps in the Past Week period is about 30% higher than the Sixty Days Ago period and less than the Terra Collapse period
    Loading...
    Loading...
    • The average number of daily traders in the Past Week period is about 57% higher than the Sixty Days Ago period and the Terra Collapse period