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?

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
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
- 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)
- 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
- 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
- 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.
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
- 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