Steemit Good News Story #3 SBD Bull Run and Steemit Winners back by Data

in #utopian-io7 years ago

The crypto market is a volatile markets with major swings every day. However since I joined Steemit back in June of this year, the price of STEEM and SBD has not seen major movements. Until now and since the latter half of November we have seen the price of STEEM rise to $1.96 and the price of SBD rise to $14.04

With the price of SBD rising as high as $14.04, this is going to bring some winners. Many people sold on the uptrend and have made a tidy sum. Many of these have also re-invested this into steemit by buying STEEM with their profits.

The aim of this analysis was to bring a good news story of winners on Steemit backed by data. During this time of high SBD prices many people used the opportunity to cash in some SBD and made a very heathy return. This is good news. But the analysis also gave me the opportunity to mash up data from Steemit and from Coinmarketcap to get a better understanding of any correlation between the two. All findings are shown below.

To carry out this analysis I first used Power BI to connect to coinmarketcap.com and pull the historic pricing of SBD from 11 Nov to 11 December. To do this, I connected to the table using a simple web connect to the url

https://coinmarketcap.com/currencies/steem-dollars/historical-data/?start=20171111&end=20171211

I also connected to the Steemsql database which is held and managed by @acangre. The query used here was

 SELECT *
 FROM TxTransfers (NOLOCK)
  WHERE [to] in ('blocktrades','teambitwala','bittrex', 'teambitwala','changelly', 'hitbtc-exchange',                
  'roomofsatoshi', 'openledger','poloniex', 'openledger-dex','shapeshiftio')
  AND timestamp >= CONVERT(datetime,'11/11/2017') 
  AND timestamp< CONVERT(datetime,'12/11/2017')

After this I carried out further transformations on the retuned data and loaded it to the model.

The final steps included creating a data table in the dataset so I could setup relationships between Coinmarketcap data and Steemit data. I then use DAX to carry out any calculations needed.

High Level Overview

3.png

In total since the 11 Nov 1,707K SBD has been transferred out of Steemit via 23K transactions by 6359 steemains.

On Wed 22 Nov the price of SBD went to $3.02 and this is when we had the biggest transfer of SBD out of Steemit. At the time, who would have thought it would go higher right?

At the start of December the price of SBD began to rise again. We can see on the 2nd Dec the price hits $2.54 and another 94K SBD is transferred out. This is where people began to feel like they don’t want to miss out like they did in Nov.

However the price continues to rise and the number of transactions along with the amount of SBD being transferred out also increases.

We can see a peak on the 8th Dec when the price hit $9.84. At this stage even I thought there was no way it would go higher. From the data it looks like I was not the only one to think this as after this the amount of SBD transferred out of Steemit decreases, although the price continues to rise.
On the 10 Dec the price hit $14.04.

At this stage however large volumes of SBD had already been traded. On the 10th Dec there were 1716 transaction passing 44K SBD out of Steemit.

Although the price and transaction numbers are up on the 9-11th Nov, the overall amount of SBD transferred out is down. The average transfer value is down which would suggest at this stage, all surplus SBD held on Steemit has been sold, and now people are selling their SBD as they claim the rewards.

More Detailed Analysis

The scatter plot below plots the no of transactions on the bottom against the amount of SBD transferred out for each steemain. It is easy to see from this chart the outliers. @paco-steem made 820 transfers totalling 66.7K SBD and @happychau123 made 614 transitions of just under 400K SBD . @smooth-a is also showing as a slight outlier, with 14 transactions and almost 150K SBD

4.png

The next two charts revile some interesting findings. The first chart is the daily volume of SBD as per coinmarketcap plotted against the SBD transferred out of Steemit.

Volume peaked on the 22 Nov on Exchanges, along with the amount of SBD transferred out of Steemit and the trend of both go relatively in the same direction. As volume increases in the exchanges so does the SBD transferred out of Steemit.

Looking at the bottom chart, I have calculated the SBD transferred out to Exchange Volume ratio

5.png

It is very interesting to see that the SBD transfer to Exchange volume ratio was substantially higher before the price of SBD began its accent. A further analysis would be required to see if this was always the case. But it is clear that while the price of SBD was rising, the amount of SBD transferred out of Steemit did not play a major factor in the trading volume.

Steemit Winners

I have taken the SBD transferred out of Steemit and used the close price for that day to calculate how much was made in us$. Below is a table showing the top winners in terms of financial gain

6.png

How I wish I was one of these. Well done to each and every one of you, this is good news.

However
I did mention that some of these have reinvested by purchasing STEEM. To look at this I needed to rework the SQL query.

During the same time period, some people transferred STEEM into Steemit via the exchanges. I have no way to prove what is proceeds from SBD but the table is interesting. The table below shows the people that have transferred into steemit sorted by the amount of STEEM

7.png

For all of you powering up – congratulations, especially if you have used profits made from SBD. Seeing such volumes of power ups is awesome. It really shows a level of confidence in Steemit.

I am part of a Steemit Business Intelligence community. We all post under the tag #BIsteemit. If you have an analysis you would like carried out on Steemit data, please do contact me or any of the #bisteemit team and we will do our best to help you...

You can find #bisteemit on discord https://discordapp.com/invite/JN7Yv7j



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Thank you for the contribution. It has been approved.

The steem blockchain has livened up! Nice to get an external data source to compare and see what you can find. Thanks :)

You can contact us on Discord.
[utopian-moderator]

Why is SBD moving so fast and not Steem ?

I am very pleased with all the information you have provided
Thank you very much for your hard work and for your earlier attention
Here is a resteem
Many thanks again!

I marvel at every one of your posts Paula. You're like a walking computer! I would love to have such a way with numbers and data.

Thanks for this excellent post @paulag! This breakdown of numbers really puts a face on what’s going on with the rise in the SBD value.

SBD rise to $14.04

Geezz…missed a buy on this one…

For all of you powering up – congratulations, especially if you have used profits made from SBD. Seeing such volumes of power ups is awesome. It really shows a level of confidence in Steemit.

I’m glad you’re putting a positive spin on the power up. Some are saying best to leave the SBD alone, as is, for easy conversion.

Others are doing the 50% power up.

Either way, good news is good news.

There’s a huge downside that you might have some background info on:

Any idea on how soon non-owners of the big 3, be able to sell sbd for direct purchase of new-on-the-market alt coins.

Right now, powering up is the only way to build value; but, it’s a little disconcerting to know that the sbd can’t be used to buy anything else without the having an account with the Big 3.

Thanks again for this great post!

Peace.

A mixed SBD strategy sounds like a plan to me.

Who are the big three you speak of? Thanks.

Apologies for the delay @abh12345...

mixed SBD strategy

So, I take you're of the 50/50 group. It certainly is the safest way to not be left holding air should this be a bubble and it bursts.

the big three

BTC, LTC, ETH

Thanks for chiming in.

Peace.

Thanks :)

Just making sure.

I'm of the 25/25/25/25 group - Save, Sell, Power-up, bid-bots :)

Great strategy...I will be glad when an exchange which accepts the direct sell of Steem for other alt coins will become available.

Thanks for chiming in!

Peace.

good post..you tell me very good information with sbd price is rising. that is very unusual

It would be really interesting to find out how much SBD was converted and not traded on the internal market. Wonder if the chain has that info available? It’s crucial to trade out of SBD and not convert when SBD is trading at a large premium above $1 and I spot checked many accounts which were converting, costing them $$$$

Another stellar post, but I have a doubt.... I understand what is Steem, Steem Dollars and Steem Power.

But what is SBD?

The same as Steem Dollars - Steem Backed Dollars.

Ah okay, but I was under the impression Steem Dollars were pegged to the dollar and Steem was volatile... how come STEEM is stable but SBD was $14?

SBDs are always trying to be pegged to a $. The peg is apparently easier to push up than pull down, which sounds like, on the face of it, a benefit to all of us here :)

Indeed, thanks for the help, joined yesterday and still learning the ropes.

Some real winners this past week!

Good to see the top SBD exchanger seemingly buy most of his stake back? I wonder if he made 100% on that as it was entirely possible within a couple of 12 hour time-frames.

The Steem Blockchain is alive and kicking now for sure :D

I would have to speculate that SBD will continue to raise its price because the market couldn't keep up with the demand and a $30 could well be near reality.

@paulag i think you missed my name in that list ;p

for a newbie like me very important data thank you

Ok good article techer

Hey @paulag I am @utopian-io. I have just upvoted you!

Achievements

  • You are generating more rewards than average for this category. Super!;)
  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x

This is why I think Proof-of-Stake is flawed.

Few big winners, lots of smaller nearly insignificant holders.

I have a stash myself, the fruits of my prior enthusiastic posting spree, but honestly I'm not even going to touch it. I want to see some proof this platform isn't just a big vacuum cleaner of optimism and false hopes.

Thanks for your analysis.

the sale of SBD is nothing to do with Proof-of-stake, in fact the price of SBD has been a surprise to everyone and has benefited many.

I have problems with POS myself but this is totally separate. we are all winners when the price goes up

The price of the token is what gives incentive to amass more piles of tokens in the first place.

So I disagree, I think it has a lot to do with Proof-of-Stake and how having the most grants power in a network geared towards accumulating tokens.

For the record, I actually sold a few bitcoins to get that much Steem, a decent portion of it when Steem was below 1$