Is There Still an Uneven Distribution of STEEM Part 2?

I recently did an analysis and post on Producer rewards where I asked the question ‘Is There Still Uneven Distribution of STEEM Vests?’

One question that came back to me was ‘what is the overall distribution of Steem?’ and the aim of this analysis is to address this question.

The shortcoming in the mentioned post was that it only looked at STEEM Vests distributed to Witnesses. When a block is witnessed a portion of that STEEM is paid as producer rewards and another portion goes to the rewards pool.

You can read the original post here
https://utopian.io/utopian-io/@paulag/is-there-still-uneven-distribution-of-steem-vests

The portion that goes to the rewards pool is then distributed by way of up votes on posts and comments. The Gross Post payout value is shown in SBD and this is further split between Author and Curator rewards.

Analysis

I connected to the steemsql database held and managed by @acrange and I pulled data for the month of November. For more details on the queries used, please see the bottom of this post.
Below is the Gross Post Payouts Shown in SBD for the month of November 2016. This is for Posts only and does not include Comments. Gross post payout includes both the author and curator rewards.

As we can see the distribution of payouts by payout values is widely spread between up to a value of $100. Sorting the same data by Author, below we can see the top post earners for the month of November. The top author for gross post payout in November earned 0.75% of the SBD paid out in posts. In fact all of the authors lists below (23 of them) combined makes up 8.8% of post payout value.
In November there were 41.85K Authors. 23 makes up .05% of this.

Below is the Gross total payout on Comments for the month of November. This only includes comments left on posts.

Below shows the top authors when it comes to comment gross payout value.

In total, between posts and comments 1,191,723 value in SBD was distributed for posts and comments made in November to both authors and curators.

Now lets have a look at the producer rewards

For the month of November 196.39K SP was distributed to witnesses
We can see the top earners in the table below and a more details on this analysis can be found in the first part of this post.

The price of STEEM in November ranged from $1.28 to $0.792 with a median of 1.035. The price of SBD was between $3.02 and $.88 with a median of 1.95

Using the median price for the month of November the SBD to Steem ration is 1.95:1.035. Each SBD can be valued at 1.88 STEEM.

We can now restate the SBD value of Posts and comment to be 2,240,439 SP. The total SP distributed in November was 2,436,829.

The pie chart below shows how this was distributed between posts, comments and witnesses.

I was asked a specific question by @fitzgibbon. Are the Rich getting richer and the poor poorer?

I need to be very careful in how I answer this question. Many of the names that you see on the top lists are whales, so yes, the rich are getting richer. But if they are not gaining, then why would they stay?

And the poor are not getting poorer. They are not losing money, in fact with the current price of SBD and STEEM, the poorer are gaining. I would also like to point out that I am only 6 months on Steemit and gaining by the day. I came with nothing, I have yet to make a financial investment.

The vast majority of SP distributed went to posts. The vast majority of SP distributed went to posts. There were 41.85K unique authors in the month of November and they all shared in a payout of 1,111,256.

I have therefore sorted the Authors by Gross payput value in the month of November and added the total SP owned (control controlled) by that account and I have added in based on the SP, the account ranking. We can see from this table that the top 75 accounts in November are all within the top 4000 accounts on Steemit.

Lets put this in a little more perspective

@davidpakman only joined Steemit in September and is ranked 3669 in the above table. His current steemit balance is $2498, with SP of 1386. He has made it to the top 40 accounts based on gross post payout in November.

Now let’s compare this to my account. I did not make it to the top 75 Authors in terms of gross post payout. I would be ranked account 2524 based on the SP I own (2431 SP). I am on Steemit since June 17, only 3 months more than David. There are many people in the top 75 that are ranked lower than me in terms of their SP but make it to the list.

This proves that you don’t have to be rich to be in the top 4000 accounts on Steemit. It also proves that there is a reasonable spread of rewards between accounts Steemit. However you are unlikely to get to the top list unless you have about 1200 SP.

Queries used

SELECT
*
 FROM 
Comments (NOLOCK)
 where created >= CONVERT(datetime,'11/01/2017') 
 and created< CONVERT(datetime,'12/01/2017')
and depth = 0

and

  SELECT
 *
 FROM 
 accounts (NOLOCK)

and

 Select 
 *
 From VOProducerRewards (NOLOCK)
 where timestamp >= CONVERT(datetime,'11/01/2017') 
and timestamp< CONVERT(datetime,'12/01/2017')

After connecting to the data source I then use M in Power BI query editor to further transform the data and I used DAX to carry out calculations and further modeling.

Is there still uneven distribution of STEEM?

Now that you have seen the data, what do you think?

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

---