Try Quests to earn cryptoBinance Bonanza
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. OSMO will initially be used for the following (although governance is free to add or remove these functions):
- Voting on protocol upgrades
- Allocating liquidity mining rewards for bonded liquidity gauges
- Setting the base network swap fee
The Binance Exchange is a leading cryptocurrency exchange founded in 2017 in Hong Kong. It features a strong focus on altcoin trading. Binance offers crypto-to-crypto trading in more than 600 cryptocurrencies and virtual tokens, including Bitcoin (BTC), Ether (ETH), Litecoin (LTC), Dogecoin (DOGE), and its own token Binance Coin (BNB).
Method
In the current dashboard I used osmosis.core.fact_swaps table to trace the swap activities on OSMO token affected by listing on Binances’ crypto exchange.
Also joined it with osmosis.core.dim_prices and osmosis.core.dim_labels tables to evaluate the trade volume in USD and find its labels to identify most affected tokens by listing of OSMO on Bainance.
The visuals in this dashboard presented the data analysis for this issue on time frames include the day of listing Oct 28th, the week of listing, ‘2022-10-26’ till ‘2022-10-31’ and the in a separate sections since two month before luna collapse in May 11th, include ‘2022-03-10’ till ‘2022-05-11’ called as “> Luna Collapse” in two mode like swap from OSMO & To OSMO, ‘2022-05-11’ till ‘2022-10-26’ called as other days, and ‘2022-10-26’ till ‘2022-10-31’ called as listing week in two aforementioned mode.
The movinge average in 60 & 7-day calculated and put it on above charts and has compared.
✍🏻 Conclusion
-
The OSMO market became tumultuous on October 28 at 4:00 UTC, when the number of swaps to OSMO reached its highest point, the number of transfers into Binance surged, and the price of OSMO went up.
-
On this date, about $20 million OSMO were converted to other tokens, with the majority of the conversions happening on October 28, 2022 at 4:00 a.m. UTC.
-
Over the past week since Binance's listing, 12.9 million OSMO have been transferred there, whereas just 6.1 million $OSMO have left the exchange.
-
Over the past week since Binance's OSMO listing, there have been $20.4M USD worth of inflow transfers and $6.1M USD worth of outflow transfers.
-
On October 28th, 5,000 transactions brought assets into Binance, while only 94 transactions left the exchange. Also More than 1,96,000 users moved their funds to Binance, yet only one individual withdrew assets.
\
About:
-
Author: HaM☰d
\
-
Discord: 0xHaM☰d#8391
\
-
Twitter: @arjmandi_hamed
\
-
Email: h_arjmandi2012@yahoo.com
Osmo on Binance
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?
Further, can you trace OSMO liquidity flowing into Binance in the last few days? Centralized exchange listings of OSMO are permissionless so liquidity on Binance should be funded through purchases on Osmosis.
Note: given this question is being released BEFORE the week of analysis in question please structure your queries accordingly to capture the data that will be populated in the future. Please create dynamically updated queries.
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.
:telescope: Findings:
This sections is allocated to assessing the swaps metrics on the week of listing announcement.
As can be seen in Oct 28, the swap volume From/To peaked at the highest point.
Overall, 15.1M OSMO Swapped FROM other assets against to 8.25M OSMO swapped TO other assets in listing day.
:hourglass_flowing_sand: Swap Volume (in OSMO) by Hourly on Listing Week VS. MA 60 & 7-day
:telescope: Findings:
This section is allocated to comparing effects of listing event with luna collapse on May.
As of charts above and right, on May 11th, swapping TO/FROM OSMO spiked to the highest point with $84.4M USD swaps from OSMO to other tokens against to $94M USD swap volume from other assets to OSMO, that was too huge.
In comparison, the volume swapped affected by listing announcement is too less than LUNA collapse event.
In terms of daily unique swappers, as of chart right can be observed, the number of swappers decreased over two months before luna collapse, but over the past month before listing date, it stayed steadily and in the last days smoothly increased.
:hourglass_flowing_sand: The following visuals show the daily swap volume (in OSMO) vs. MA 7 & 60-day since Mar 10th (two month before luna collapse)
The MA 60-day increased from $1.2M in Mar 10th, two month before collapse, to $2.3M in May 11th, the day of collapse.
Similarly, over two month before listing date, it increased from $1.15M in Aug 28th to $1.4M in listing date, Oct 28th.
:telescope: Findings:
The charts right show the top 10 swap pair based on most swap TO/FROM volume in $USD over listing week.
In Oct 26th, the early day of listing week, the volume of swap peaked at above $1.5B with the highest volume for swapping INJ to OSMO, with near $950M volume, although in the other hand about $2.2B OSMO swapped to INJ.
:telescope: Findings:
Over 6.7K transactions took place for transfer assets to Binance against to 2K for back out from Binance.
In Oct 28th, 5k transactions took placed to inflow assets to Binance against to 94 for outflow.
Also More than 1.96K unique users transferred their assets to Binance while onle one users turned out assets from Binance.
:telescope: Findings:
As of the visuals in the current section, can be seen in the date of listing announcement, the highest volume of swaps took place to OSMO from other tokens in USD & OSMO, so that average swap volume peaked at approximately to 2K in 4am.
But in the late hour of date list the average change volume decreased below 500.
Following PIE chart depict the total amount and percentage of swaps transactions count, number of swappers, total volume in USD & OSMO.
:telescope: Findings:
The charts right show the swap OSMO volume (in OSMO) TO/FROM other assets vs. MA 7 & 60-day.
The 7-day and 60-day moving averages gradually rose from 725.7K and 1.03M on October 26th to 4.97M and 1.2M on October 28th, when trading volume averaged 5M shares per day. On October 28th, daily $OSMO volume increased to 14M, with 1.25M people following the $OSMO ticker.
:telescope: Findings:
- The 60-Day moving average before the listing date in Oct 28th, was 1.2M OSMO Swapped FROM and 1.4m swapped TO per day, while in Oct 28th, the volume of OSMO swapped from & swapped TO, jumped from 62.3k OSMO to 2m and 154.4K to 7.83m, respectively.
- In Total in the past week 15.1M OSMO has been swapped to vs 8.2M OSMO swapped from.