As promised in a previous post on Steemit developer resources (https://steemit.com/programming/@digimad/developer-resources-for-steem), I've started to have a look at the steem blockchain on the public SQL database available at http://www.steemsql.com/. Its a fantastic resource, many thanks to the person/team behind it.
As a first step I wanted to check out the distribution of posts by users:
- How many users join but then never post?
- Can we spot the bots by singling out unrealistic post counts?
- How many posts do you have to make before you are in the top 80%, 50% or even 10% of Steem users?
This first chart shows the number of users (vertical axis) against the count of posts they've made on Steemit (horizontal axis). I had to use a logarithmic scale as a standard plot just has all the points hugging the axis (skewed by the bots with 0000's of posts).
Here is the same chart, but not logarithmic, and only for the lowest 95% of users (to avoid over-skewing the chart):
Some other interesting observations:
- 67% of users never make a post
- 89.6% of users make 10 posts or less
- if you make more than 11 posts, you are in the top 10% of Steemit users
- to get into the top 5% of steemit users, you have to make 41 posts or more
- to get into the top 1% of steemit users, you have to make 381 posts or more
- only 59 users have made more than 5,000 posts
The top 20 users by post count are:
| Username | Post Count |
|---|---|
| screenname | 28569 |
| cheetah | 25645 |
| mindhunter | 21615 |
| papa-pepper | 18985 |
| jlufer | 17712 |
| steemitboard | 17116 |
| thecryptofiend | 16557 |
| ace108 | 13472 |
| barrydutton | 12651 |
| meesterboom | 12253 |
| karenb54 | 11091 |
| doitvoluntarily | 10945 |
| karenmckersie | 10801 |
| stellabelle | 10421 |
| linkback-bot-v0 | 10067 |
| gringalicious | 9303 |
| englishtchrivy | 9134 |
| steevc | 9014 |
| everittdmickey | 8860 |
| virtualgrowth | 8636 |