Accounts Analysis In Terms Of Vests And Delegation Received - June 2017 - February 2018

Many Steemians including me have a concern about increased number of voting bots coming up almost every month and to some extent, disturbing the Steemit Economic System. On the other hand, the positive thing is many people have come up with some unique ideas and are building applications on Steem Blockchain and running different projects for the betterment of this platform. The main purpose of this analysis is to show a clear picture of what is happening here by showing a general analysis of accounts created, how many of these accounts have become Whales, Orcas, Dolphins & Minnows, a short analysis of whales, top 20 accounts in terms of vests & their activity on this platform and analysis of top 20 accounts who received delegations.

Data

All the data was extracted from Steem SQL Database (Paid subscription service held and managed by @arcange). SQL query that was used to extract the data can be found at the end of this post. The data was taken from June 1, 2017 (The month I joined Steemit) to February, 28, 2018.

General Analysis Of Accounts Created From June 2017 - February 2018

Total 604938 accounts were created From June 2017 to February 2018. Out of these total accounts, 159742 accounts(26.40% of the total accounts) were created in January 2018. The reason might be the sky touching prices of SBDs/Steem in December/January and people were more attracted towards this platform.

Accounts Status

Whales - 2

Orca - 55

Dolphin - 579

Minnows - 3914

Redfish - 600388

Following formula was used in excel to get the status of each account

=IF(E2<1000000,"REDFISH",IF(AND(E2>=1000000,E2<10000000),"MINNOW",IF(AND(E2>=10000000,E2<100000000),"DOLPHIN",IF(AND(E2>=100000000,E2<1000000000),"ORCA",IF(E2>1000000000,"WHALE","NONE")))))

@misterdelegation has the highest number of vests 33854469950.6656 and out of these, 22329690818.7047 have been delegated to following accounts.

Though it's still a mystery who owns this account but a common myth is that this account is being controlled by Steemit Inc itself.
The second account that was able to become a whale was @promobot (voting bot). This account has almost 1001575743.26665 vests and 25000000 vests had been delegated to @utopian-io

Top 20 Accounts In Terms of Vests

Out of 77180711222.5569 vests, top 20 accounts hold 41060076893.4519 vests which is around 53.20% of the total vests. After noticing this unequal distribution of vests, I further went into some deep analysis and tried to figure out how many of them were voting bots and if there is any account that regularly engages with the community and do some manual curation.

Account Name	Vests	Activity	Delegation received
@misterdelegation	33854469950.6656	No Activity	No
@promobot	1001575743.26665	Voting Bot	N/A
@yoo1900	824327137.393611	Engages With The community and have started a project for minnows.	No
@bramd	597089720.841654	Mostly resteem others content and does manual curation.	No
@czechglobalhosts	464909868.032254	Regularly engages with the community	No
@z8teyb289qav9z	415600269.249088	Regularly engages with the community	No
@fenghuang	414549848.731673	Delegated vests to voting bots, no activity	No
@spmarkets	347498465.786832	Delegated vests to a voting bot	No
@gcalex	330178955.770898	11 posts since September, 2017	No
@candyboy	301189780.217397	Regularly engages with the community.	Yes
@cryptopassion	295571448.387548	No comments	No
@dang007	295072491.676773	Not Sure which category he should fall.	No
@moses153	233229209.318642	Mostly resteem other's content	No
@temet-nosce	222160384.197617	No activity, delegated almost all the vests to @sweetsssj	No
@minnowbooster	220945763.510193	Voting Bot	NA
@ipromote	217252662.715586	Regularly engages with the community	Yes
@grandpawhale	210196864.786752	No activity	No
@unknownbloc	204027668.420856	No activity, delegated vests to @smartsteem	No
@imacryptorick	202132848.127872	Quit Steemit 2 months ago	No

Out of these top 20 accounts, two of them are voting bot accounts, whereas, five of them regularly engage with the community. Four of these accounts have no activity on their blogs and two of them have delegated their vests to other accounts. Two other accounts have delegated their vests to voting bots, one account had quit Steemit due to regulatory policies in his country and is currently powering down. For one of these accounts, I don't want to comment since I don't want this post to be flagged! Out of those 5 accounts who regularly engage with the community, two of them received delegations.

Top 20 Accounts In Terms Of Delegations Received

Total vests delegation received by all accounts from June 2017 to February, 2018 were 87743793266.5485 and top 20 accounts received 54352012549.5463 vests which makes around 61.94% of the total delegation received by all accounts. I am going to divide these twenty accounts into three categories, one if delegation received for a Steem application/project like @utopian-io and @dtube, second category would be of upvoting bots/persons and the third one would be of miscellaneous (Accounts that I am not sure about)

Account Name	Delegation Received	Project
@utopian-io	7807548316.33762	Project
@postpromoter	5329821136.91772	Voting Bot/Person
@smart	4307299399.25092	Miscellaneous
@dlive	4196133210.38039	Project
@dtube	4091047134.79643	Project
@buildawhale	3739640140.30635	Voting Bot/Person
@upme	3004135591.54792	Voting Bot/Person
@appreciator	3000000000	Voting Bot/Person
@rocky1	3000000000	Voting Bot/Person
@spaminator	2580361493.12645	Project
@minnowbooster	2246456156.12608	Voting Bot/Person
@dsound	2018987844.57019	Project
@booster	1795343034.81625	Voting Bot/Person
@dmania	1326667200.08772	Project
@peaceandlove	1120982273	Miscellaneous
@sndbox	1044082480	Project
@ed-proxy	1036775520.57232	User Not Found
@therising	1020010661.61085	Voting Bot/Person
@boomerang	861687317.023456	Voting Bot/Person
@upmyvote	825033639.075636	Voting Bot/Person

Out of these 20 accounts who received some massive delegations, 10 of them were voting bot accounts, 7 of them received delegations for some productive Steem based applications/projects and two of them fall under the miscellaneous category. Total amount of vests received by these 20 accounts were 54352012549.5463 and out of these, 23064827679.2988 vests were delegated Steemit based projects/applications (42.43%)

Conclusion

As far as the activity of top 20 accounts is concerned, we can see that only 5 of them have been regularly engaging with the community and others have either don't have any activity or they are just delegating their vests to voting bots. Out of total vests received by top 20 accounts, 57.57% of vests were delegated to voting bots from June 1, 2017 to February 28, 2018 which isn't a good indicator or I would say not an encouraging thing for a new user. Investors should be more focusing towards building new applications and projects that can benefit this platform in the longer run.

SQL Query

Query used to extract the date from Steem Database.

SELECT name,
created,
vesting_shares,
delegated_vesting_shares,
received_vesting_shares
FROM accounts
WHERE created BETWEEN '2017-06-01' AND '2018-02-28'

---

Posted on Utopian.io - Rewarding Open Source Contributors

---