Is this why the price of STEEM is struggling? STEEM Withdrawls 2017

in utopian-io •  7 years ago 

2017 was a fantastic year in the world of cryptocurrency. We have seen Bitcoin prices go above $10,000 and millions raised through ICO’s. So why then has the price of STEEM not experienced some of the same growth as the major coins?

Yesterday I did a post on Steemit Investors 2017

https://steemit.com/utopian-io/@paulag/steemit-investors-2017-steemit-business-intelligence

In this analysis I found that 14% of active new users registered in 2017 have invested into Steemit by transferring either STEEM of SBD via an exchange to Steemit.

The analysis yesterday was based on users that registered in 2017. I have now reworked this analysis to include all account. The aim of this was to see how much in total was transferred into Steemit via the exchanges

3.png

48.68M STEEM was invested into Steemit and 4.61M in SBD. If you are unsure about the rest of the data in that visualization, please do read yesterday’s post.

After I did yesterday’s posts the thought crossed my mind that if people are investing in Steemit, then why is the price of STEEM not seeing good gains?

Basis of Analysis

I connected to @arcange SteemSQL database using Power BI.

First I connected to the Accounts table so that I could have access to the account creation data.
The second table I connected to was the TxTransfers table. I used the following SQL query

         SELECT *   
         FROM TxTransfers (NOLOCK)
         WHERE [to] in ('blocktrades', 'bittrex', 'changelly', 'openledger-dex', 'poloniex')
          and timestamp >= CONVERT(datetime,'01/01/2017')

After which I carried out further transformation steps on the data and calculations using DAX.

Findings

4.png

The total withdrawn from Steemit in 2017 to date is 86.90M STEEM and 6.94M SBD.

On the top left the red bar chart shows the amount of STEEM withdrawn based on the date the account was created. On the bottom left also in red, shows the mount of SBD withdrawn based on the date the account was created.

The bar chart in blue shows the number of unquiet accounts making a withdrawal based on the date the account was set up.

On the right you can see a list of accounts sorted by the highest withdrawal amount.

I am not surprised to see that the higher value withdrawals are from the older accounts on Steemit but I was surprised to see that the number of accounts making withdrawals increased significantly in May 17.

Lets take a closer look. First I have filtered the data to show only accounts set up in 2017.

5.png

Taken from yesterday’s report, here is the transfer IN data.

14.png

Now I have filtered the data to shown only accounts set up in 2016

6.png

And I have also reworked yesterday’s data to show account set up in 2016 for transfers IN.

Let’s do the Math

8.png

To put that in a different perspective, for every 1 STEEM invested into the platform 1.27 STEEM is taken out. For every 1 SBD invested 1.98 is taken back out.

The positive side of this is that for accounts set up in 2017, so new investors, for every 1 STEEM invested only .45 STEEM is taken back out.

Conclusion

I am not a trader and I don’t claim to know much about stocks or crypto. I also understand that there is a lot of STEEM held on exchanges and not included in these calculations.

However this data represents Steemit users and their willingness to invest in steemit and provide liquidity.

It only takes a quick look at https://steemwhales.com to see how much STEEM is held by the whales with accounts created in 2016. This is all available for power down. If the rate of withdrawals continues to exceed the rate of investment then I believe the price of STEEM will continue to fall and I don’t think the SMTs will help.

Right now, we need investors to stay put, or at least ensure the rate of new investment to Steemit is at a higher level than the rate of withdrawals.

I can understand early investors wanting to take profit, but Steemit is still very new and putting it in a business perspective, start-up capital is still needed.

Maybe it’s even time to consider changing the rules for power downs and withdrawals?

What are your thoughts and feedback on this data, please do leave your comments below

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

Shout out and thanks to @arcange for keeping and maintaining the steemsql database



Posted on Utopian.io - Rewarding Open Source Contributors

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

I believe it is healthy for the ecosystem when Steem is changing hands. When a whale sells his stake, this stake gets bought up by several new investors. Steem works on a Proof of Brain algorithm, which thrives when there are more users. So the spreading of Steem is actually good, even when this dampens the price on the short term

This is an excellent point. Steem distribution is extremely unequal at the moment, and the whales powering down is very good for this platform. That Steem will end up in many more hands, or many more brains, if you want to look at it that way, each being a new neuron added to the super-brain that is the decentralised autonomous Steem community.

I get this, and do agree to an extent. yes we need the steem in more hands but we also need liquidity

Technically more steem going to the exchanges builds liquidity. What we need is demand.

I also believe it is health for steemit to change hands, the problem is the stakes are not fully reinvested into steemit, as can be seen by the withdrawls vs deposits. so how much is held on exchanges, and why is it there and not on steemit?

  ·  7 years ago (edited)

There are traders and investors. Steem that is not powered up does not receive interest and does nog give voting power. There is a price to this. It actually costs money to keep your Steem just as Steem.

With there being more liquid Steem available then before a higher percent of the market is basically saying that it is currently more profitable to trade than to power up. Or they do not know what to do with the Steem Power.

This ecosystem is quite new and a lot of things are still being figured out. Aside from self voting it is quite difficult to just start turning your voting power into more Steem. Traders are mostly looking for short term gains while investors buy up the lows and are currently stabilising the price around $1.

I personally think this $1 mark is the rough bottom for the new run up. Maybe starting early next year after the release of the smartphone app, HF20 and SMTs

WhatsApp Image 2017-11-29 at 18.10.07.jpeg

If you look at the total market cap over time you see that there was an inital hype and after that the pice bottomed out and stabilised and go for another cycle, with a higher high than before and a higher bottom then before. This cycle will repeat itself over and over and is based on human emotions

I think that people withdrawing Steem is a good thing, it's being used, and in order for it to succeed it has to be. I don't think the price of Steem is struggling. We are right on the cusp of having some awesome updates to the official front end, all sorts of awesome develpment on 3rd party apps, we're just young as a token, and as a community. It's not really fair to compare Steem to btc, when btc has been around for a lot longer. Since btc is transferrable into any currency, digital or fiat, it's king. Untill another currency can do the same, there's no point to being upset about it.

Steem is about 10x where it was this time last year... I don't think our price is struggling as much as we're just breaking out of our cocoon.

If the steem network is being used to transfer money, then it is serving one of its functions as means of transferring money (sbd in this case).

What Paula is saying is that powering down (whose only intent is to ultimately trade that steem out for other coins) will end up flooding the exchanges who provide liquidity, with more steem. If there are not enough buyers and too much steem sitting on exchanges, the value will go down if their steem grows faster than user demand looking to enter the steem.

At the same time steem is developing and growing trying to increase value. This can only be done of steem isn't being dumped into the market.

I like the article, but I think it kind of misses the point. Steem's main strengths are propagation and ease of entry. The price doesn't really matter this early.

@inquiringtimes is right in pointing out that BTC has been out far longer, and this creates the illusion that it's doing better than Steem. It isn't. Steem has far more potential at the end of it's first decade than BTC is showing at the end of it's first.

Also keep in mind that Steem is inherently inflationary to a fairly large degree, so can't be meaningfully compared to an exclusive, deflationary cryptocurrency like bitcoin. The fact that Steem is mostly holding its value despite the fact that more is created every day says something extremely positive about the currency's direction.

If you were here a year ago then you remember that at one point (for several months, maybe more) Steem was dropping like a stone in water. Now we've reached our first stabilization and, even if a significant portion of the first whales leave, I have full confidence that Steem will recover long term. It's built to do so.

The markets just don't matter as much with Steem as they do with BTC because Steem is aimed at being a social cryptocurrency with wide propogation. When enough people are using it, investors will come knocking in droves.

Exactly. This is a long term game. I'm not worried about the price of Steem at all. This long exhalation was always going to happen. Once the whales cash out, and that Steem gets bought up by many more users, they will be much more likely to hold on to their smaller SP balances. This is a natural cycle in all crypto. Long fractals. It just means that when the price spike does come, it will be extremely fast and violent.

This is a long term game, and steem does need to change hands and the power be distributed among a wider base

Lets add in this point, if the price of steem goes up, so does the vote value. New people coming to steemit have been seeing 0 on their vote given. This is not very motivational.

I do think the problem here is people's lack of willingness to invest in Steem rather than any problem with the system. At the moment anybody can put $50 into Steem, that's literally pocket change, and as the statistics stand, that already puts them into a higher bracket of users than the majority, who have nothing. With just 50 SP you can see your voting power have a real effect, especially if fully utilised daily and the rewards powered up. But most people don't do that. Even if the Steem price goes up the proportions won't change. It will still take the same amount of money to buy a proportional level of voting power.

Thank you for your detailed analysis though, it's very interesting and much appreciated!

$50 is not pocket change to many many users here. It really depends on where you are from.

Yes, indeed! $50 can represent a big chunk of cash!

Spot on. The ease of entry is so incredibly important. When you register Steemit sets the user's wallet up and they are good to go. That is HUGE. Try using LBRY. It's a pain in the ass for the non technical user.

STEEM has been incredibly stable compared to most alts for the past 8 months, it hasn't gone up a lot, hasn't gone down a lot in terms of USD. BTC is a different story.

What I love about Steemit, aside from the blogging and community, is the ability to get my rewards 50/50. Then I can invest at least half back into the platform and take the other half to do with as I please. This was another genius move.

Steemit is ahead of it's time regarding crypto social media and we are all early adopters so HODL.

Yep, total agreement. You're right: the 50/50 system is a spark of real genius, though maybe a subtle one that many people don't fully appreciate.

I have a tongue and cheek way if describing this: 'hunger proof'. Take the SBD to supplement your income and know that the rest is out of your reach unless you're willing to wait a significant amount of time for it.

Even if some immediate concern is up (bill is due, budgetary mishaps, or even an extreme case where you were literally starving (hungry) and your judgment was at its most altered), you aren't tempted to power down.

It's better than savings, and people are going to realize this.

While i think the ease of entry is something that steem shines on. I dont think it has a much of a primary effect right now, as it will later in the game. Think of it this way, if there was an EXE file that you could run and mine btc back in 2009, why didnt anyone do it since ease of entry was that great?

This is a rehtorical question, because back then BTC didnt matter. Just like right now, ease of entry doesnt really matter.

What does matter right now is a library of content. The better the content, the more likely the result will show up on google searches, and once a steemit article becomes atleast 1 in say every 10 searches a user performs, thats when ease of entry will become important. Right now, not so much.

Your explanation is very interesting @jenkinrocket. I am very interested.

Great work @paulag thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]

@paulag

First of all, thank you for a detailed reporting well done job.

I posted my own analysis for the last six months as being investors. It is a dismay report, losing 43.55% for STEEM while other crypto currencies enjoying 100%+ returns.

For example, for the last six months of trading.
Bitcoins 346% gain
Ethereum 40% gain not a bad return.
Dash 410% gain
Litecoin 231% gain
IOTA 239% gain
and many other, continue reading here.
https://steemit.com/bitcoin/@yehey/bitcoin-is-not-the-highest-earner-in-cryptocurrencies-steem-loss-43-44-since-june-2017-gains-losses-report-of-top-20

I agree we need more investors, banks, credit/financing companies to help move STEEM to the next level of growth.

I'm looking forward to move to the next level, we are stagnant for quite some time now.

Cheers,
@yehey

Very interesting analysis, thank you Paula!

Which tool did you use for visualizations, Tableau?

I've been interested in Data Analysis for at least one year, learning and studying by myself. And now, in Steemit I'm having my first contact with blockchain and cryptocurrencies, something really fascinating. Started just 3 weeks ago.

When I read this:

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

it was :O like music for me, my two passions together <3

Now I'll follow you and will be checking the #BIsteemit content.

Thank you again :)

I use Power BI :-) looking forward to seeing you over on #bisteemit

On just the motivation side of it....steem is setup for withdrawal then contribution. Steemit is the only place you can come and earn money in crypto from scratch by blogging and curating.

The that money can be taken to do whatever with, pay bills. Buy some BTC that is flying.

On the flipside the price of steem isn't doing much so there is no motivation for gains there in addition to the fact that it can just be earned from posting and curating, thus less motivation to invest in it.

I bought steem once back in 2016 and earned the rest of my SP posting. I have bought every other crypto once. I was able to build a position in Steem without investing dollars.

Its the blessing and curse of steemit.

Excellent analysis, thank you!

Since our reputation is as a pay for posting platform, people look to supplement their income and will sell. That downward pressure needs to be balanced by others investing. I think smt's will bring a lot to the table in this regard!

The power down process is already too stringent, imho, and should NOT be made even more so. Where else is your money tied up like this? If you invested in a bank cd, you could pay a penalty to withdraw all your money. Steemit does not have anything comparable. Powering up massive amounts means that you really believe in the long term prospects, barring any changes.

These two issues seem to be our main problems that will hopefully be helped by smt's.

Smt wont help at all in short term.
Some piece of tech which i doubt has any usecase at present day steemit could deal with 1-2 millions of steem withdrawing each month? You're kidding me.

Time will tell!

@hashclouds you bring some good points to the discussion

Good data analysis. I'm trying to get caught up on the current state of crypto currencies and steem in particular so I found this helpful and interesting. Are you thinking that the power down time should be increased, to say, 6 months? I'm not sure what other options there are to halt the tide of excess steem leaving (but I'm also not even close to an expert!).

I am no expert either, and to be honest I dont know if it should be increased after reading some of the other points made

I'd suspect that some whales who have made Steemit their full time job need to power down and will continue to do so. They're probably not inclined to buy much again, so they'll continue to earn from the inflationary currency and take their regular power down out for life expenses. This workflow is easy to maintain when content is regularly voted blindly with pre-set voting trails so people can stabilize this system. Nothing wrong with taking money out, but you're right that more is going out than coming in, and maybe this plays a part of it.

yes, people need money to live off at the end of the day, and I have no issue with this, but can steemit sustain this sort of sell off?

I'm inclined to think that the value would rise with more adoption in the next two years to offset this enough. I have no expertise to feel confident in that though.

However, I do sense and see that there's a decent portion of users who act heavily in their own personal interests alone, as interpreted by their outpouring of filler posts for votes to satisfy auto/voting trail rewards, met with offensively low amount of commenter engagement and upvoting. I think that this one way street mentality will fuel the issue you're raising because it's a selfish mindset of expecting, versus giving. Eventually one pool will drain out the other.

this is very good information for us beginners. you have made my mind open with the steep price decreasing from time to time. and yet I do not have the information possible because of the limited knowledge I've been devoted to in this world of steemit .. and when I look in detail the information you provide and have no errors to fix ... thank you for sharing my knowledge so useful to me .. and now the steam is starting to fall again ...

I am ranked #5,591 in Steem POWER with only 600 SP. That puts me in the 2.34% of the 239,377 STEEMians tracked by Steem Whales. I think it shows that not a lot of people are investing in their STEEM, just getting in and trading it out. I think if more would do conversion and invest into SP, that maybe, the price would go up. Of course, all the bots probably doesn't help with things.

Where am I in the STEEMit World: Dec 1st

Great analysis. I have not invested 1 penny of fiat or crypto currency into Steemit. Only hard work and original content.... so I went from $0 to $1,600 in 5 months. I plan to keep everything on Steemit and only trade between Steem dollars to Steem to power up

Well put together and interesting to see it laid out. For me it's of no worry as I'm accumulating at this point and fairly new. I do think it shouldn't take as long as it does to power down. The price being as low as it is makes it a buying opportunity IMO.

indeed why? Steem is unique because the token right now is centered on a blockchain that is spoken about all the time. I know reddit does the same, but it's interesting how we the STEEM have an actual voice. We can only hope @ned see's this trend and changes it up - I really don't think he will abandon his baby! Hopefully good minds are at work.

  ·  7 years ago (edited)

I think also, more activity, a lot of activity need to be done in using the Steem platform for posting, etc to keep the blockchain working. This will build more Steem. We also should get on social media to direct people to Steem. Steem needs to work on better marketing strategies.

Even if you're chatting on an unrelated subject, I think in some cases, on the end, one should ask people " have you heard of Steem?" Then give the link to how this social media site helps to generate value, valuable crytocurrencies, as well as its social benefits.

Perhaps Steemit is a better longterm investment tool.

I have a question @paulag. Have you also considered power up and the amount of Steem that goes into Steem power? 50% or 100% of the author/curation rewards are rewarded in Steem Power. I'm wondering how this picture would look if we could add this figure too.

On a side note, excellent post and very thorough analysis! Your work is awesome as usual!

Thank you very much. You have given an important news. It's great to see the news. Actually everyone is doing a lot of good work. Taher Crop is your news today.

In general I think this could end up being a good thing.

One of the main problems of Steemit is the initial distribution of power. More power downs means less super powerful entities and, in the long run, better distribution of rewards.

The potential wide proliferation of SMT's makes it so that the current price of Steem is mostly irrelevant. That is the genius behind SMT's. Whatever people will be making with SMT's as far as their participation will be more than they made before: nothing. This means that Steem-backed tokens will be distributed far and wide.

And a tipping point of distribution nothing else will mater. If 100 million people have Steem, this will inherently create demand for mainstream acceptance and pave the way for a tide of new investors that will likely be clamoring to join at a far faster rate than those who leave.

If these people want to go - let them. They may well be making the rest of us first and second year early adopters filthy rich.

If someone has 10M steem and powers down to 5M steem, they are STILL a whale and got their cake and get to eat it too!
I doubt these whales will be GETTING OUT. They take the cream off the top and then go for the next round.

Fair point. There's a great chance a great many of these whales are adopting that strategy.

fully agreed the the initial distribution needs changing

From the pure base mathematics of supply and demand this underpins the steem price progress (or lack of) :

To put that in a different perspective, for every 1 STEEM invested into the platform 1.27 STEEM is taken out. For every 1 SBD invested 1.98 is taken back out.

But as has been seen with so many alt-coins the basic laws of economics can be readily overridden with enough hype and hoopla.

That is something steemit does rather miss out on - which may of course be a good thing. But a strong dose of full-on marketing I am sure would not go amiss.

One other suggestion. Would it be possible to overlay the steem price graphs on top of the withdrawal graphs. That might readily reveal an expected pattern.

As always, great analysis and thanks for finding the time to provide this management level data for steemit.

Hello Paula G, I have been following you for awhile, love your bisteemit work, I have a question - its about your utopian-io use -

What category would this article fall under? I see that some of your articles seem to be tutorials now, but I do see some other authors using the utopian condenser for their normal articles, like this one seems to be.

Please understand me, I love what you do, and am only asking in the interest to understand more. For example I use utopian for articles about opensource development - what repository does this article refer to?

Blessings to you and all that you do!

steemit/condenser is the repository. I did do some tutorial, however one was not accepted because it did not related to a tutorial on an opensource repository

Some rules should be made for power down and withdrawals.

the Steem I hold as Steempower has been stagnant for months. My BTC and other cryptos (that I was able to buy thanks to Steem) has quadroupled in that time.

If I was a whale I would bite my ass having all that money locked on Steem(power).

An analysis I'd be intrested in is the amount of SP held by accounts with 100% voting power, in other words how many accounts are not excersing their voting power, as a % of those that do, and how much does it flactuate over time.
Because those things significantly impact the rewards that our votes give, and it would be nice how much do these accounts contribute to the voting strengh of everyone else.

yes this would be an interesting analysis, let me see if I an fit it in :-)

bots.
bots are parasites...turning a once healthy platform into an infested rotting corpse.
no wonder the whales are leaving.

I doubt the whales are leaving... they are simply skimming the cream off the top. They will stick around and skim the next round and the next and the next. Why wouldn't they?

Indeed...why not.
They built this place..and allowed you and I to play.
No cost...for free.
What's to complain about?

I'm not so sure all of the whales built the place. Someone built it and the rest just use it, same as we do. The earlier people who found this place are the luckiest and get the greatest rewards. The later one gets on-board, the harder it will be to get rich off it. It is still early and we don't know what will happen. Everyone who is currently here and is not taking all their Steem out could possibly make some serious cash! Time will tell.

I am sure who built it.
Two guys name of Dan and Ned....
then they had investors help pay the cost of set up.
oddly enough the investors kinda like the idea of return on investment.
who'd a thought?

Everitt - Im not sure if everyone sees things the same way as you do. This person uses words like early and lucky, 'serious cash!'- I don't think they understand the ecosystem and instead see a pyramid scheme.

maybe because there IS no pyramid scheme!

How can there be? No one is asked to invest any money
(unless they want to).

"investors kinda like the idea of return on investment"

:-)

Not kinda like, they want (including me) to see ROI.

investor goes where the money is, yehey i didnt know u are an investor?

Don't be such a luddite, all bots have a human operator, I wish more of them were easily available to everyone though.

no they don't
they have human PROGRAMMERS.
who set them free to do damage to steemit.
kind of like a speeding car with no driver in a school zone.

Irresponsible bots can be efficiently suppressed by another bot.
That's what we do to fight bot spam.

machines fighting machines.
gee..I thought Steemit was a SOCIAL media
not robot wars.

You think regular social media are not bot ridden? Bots don't have weight here unless they invest money. Look at what just happened here. https://steemit.com/steemit/@themarkymark/calling-all-steemians-i-need-your-help

I could give a damn less about 'regular social media'...they stink.
Steemit has a HIGHER standard than they do.
destroy all bots.

Do you know who owned the first upvote bot? The 2nd?

I have no idea, but I bet you are going to find out for us all lol :-)

  ·  7 years ago (edited)

Bernie with Randowhale and not far behind was fyrstriken (wrong spelling oops) with Booster. Both are whales, both are witnesses 😊

lol I just knew you would know

Always a pleasure to read your well supported reports

Thank you very much @transisto

@paulag - a very well thought out and insightful post as usual, and I think as we start piling up the quantitative analysis we will need to start considering or proposing some solutions that will help address the issues (with or without the investors). I can't speak for investors (and there might be several different types of them out there) but I understand the need for others to 'cash out' because it is their only means of utilizing the value of the cryptocurrency. This could be solved by people providing more services that can be purchased using steem so that we keep the currency in the ecosystem. But for investors looking to make a profit, I just don't think this is the type of platform that was designed to cope with this type of behaviour and as you pointed out I don't think SMTs will solve this problem. It would be a very interesting hypothetical scenario to see what would happen if all the people creating content moved onto a different platform and whether it is possible to sustain it...

really like the idea of having more ways to use steem..... a credit card be awesome

Not sure what the finance laws are in the UK regarding cryptocurrency, but I am not holding my breath for something to be available in Australia any time soon (sorry I think my rant is still not finished yet :D). Is it possible to track transactions on the steem blockchain in relation to the exchange of goods and services? That would be an very interesting story/data set to motivate some of the entrepreneurs and investors to set one up!

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

Achievements

  • WOW WOW WOW People loved what you did here. GREAT JOB!
  • 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

  ·  7 years ago Reveal Comment

I do not like it this way @riskisteemit