This analysis is an attempt to uncover the amount of 'available' Steem Power that is there to potentially vote for Steemit.com based content.
Contents
General / Assumptions
Finding the active Steem Power
Removing 'dedicated' Steem Power
Further account exclusions
Summary
Tools used to gather data and compile report
pixabay source
General / Assumptions
Firstly, it should be stated that the account names that appear in the analysis are free to do as they wish (within their delgators 'rules', if any) with their stake.
For this report, the following criteria has been used to gain a base set of data:
The total Steem Power (including delegated to) is the amount held by every account that has made at least 1 vote in the past 7 days.
The word 'available' is to be used to describe the amount of Steem Power (SP) that is available for free to vote on Steemit.com content.
1. Finding the active Steem Power
The following query was use to list the active voters (voted at least once in the past 7 days) and their available Steem Power.
7 days was chosen as a guide for active voters, and removed accounts such as 'steemit'. If the date was changed assess the previous 31 days the total would be 99,101,480.61 with 'ned' owning 1.8 million of this total.
select sum((cast(left(vesting_shares, len(vesting_shares)-6) as float)*490.009/1000000)+
(cast(left(received_vesting_shares, len(received_vesting_shares)-6) as float)*490.009/1000000)-
(cast(left(delegated_vesting_shares, len(delegated_vesting_shares)-6) as float)*490.009/1000000))
from accounts with (nolock)
where name in (select distinct voter from txvotes with (nolock) where timestamp > getdate()-7)
The total is: 93,242,469.69 Steem Power (7 days)
2 Removing 'dedicated' Steem Power
This section is an attempt to remove the Steem Power that is 'assigned' to the various 'projects' on the Steem Blockchain.
Let's start with the easy one.
utopian-io
select sum((cast(left(vesting_shares, len(vesting_shares)-6) as float)*490.009/1000000)+
(cast(left(received_vesting_shares, len(received_vesting_shares)-6) as float)*490.009/1000000)-
(cast(left(delegated_vesting_shares, len(delegated_vesting_shares)-6) as float)*490.009/1000000))
from accounts with (nolock)
where name in ('utopian-io')
Total SP: 3,870,935.88
This account has been excluded as votes are given for content produced outside of the steemit.com condenser.
The 'd-apps'
select sum((cast(left(vesting_shares, len(vesting_shares)-6) as float)*490.009/1000000)+
(cast(left(received_vesting_shares, len(received_vesting_shares)-6) as float)*490.009/1000000)-
(cast(left(delegated_vesting_shares, len(delegated_vesting_shares)-6) as float)*490.009/1000000))
from accounts with (nolock)
where name in ('dlive',
'dtube',
'dmania',
'dsound')
Total SP: 5,804,473.75
These accounts have been excluded as votes are given for content produced outside of the steemit.com condenser.
Other popular blogging condensers
select sum((cast(left(vesting_shares, len(vesting_shares)-6) as float)*490.009/1000000)+
(cast(left(received_vesting_shares, len(received_vesting_shares)-6) as float)*490.009/1000000)-
(cast(left(delegated_vesting_shares, len(delegated_vesting_shares)-6) as float)*490.009/1000000))
from accounts with (nolock)
where name in ('esteemapp',
'busy.pay',
'busy.org')
Total SP: 1,223,248.50
These accounts have been excluded as votes are given for content produced outside of the steemit.com condenser.
The 'cleaners'
select sum((cast(left(vesting_shares, len(vesting_shares)-6) as float)*490.009/1000000)+
(cast(left(received_vesting_shares, len(received_vesting_shares)-6) as float)*490.009/1000000)-
(cast(left(delegated_vesting_shares, len(delegated_vesting_shares)-6) as float)*490.009/1000000))
from accounts with (nolock)
where name in ('steemcleaners',
'spaminator',
'blacklist-a',
'guard')
Total SP: 2,832,872.82
These accounts have been excluded as they almost exclusively tackle spam/plagiarism with a negative vote.
'Self-service'
select sum((cast(left(vesting_shares, len(vesting_shares)-6) as float)*490.009/1000000)+
(cast(left(received_vesting_shares, len(received_vesting_shares)-6) as float)*490.009/1000000)-
(cast(left(delegated_vesting_shares, len(delegated_vesting_shares)-6) as float)*490.009/1000000))
from accounts with (nolock)
where name in ('ranchorelaxo',
'haejin',
'starjuno')
Total SP: 1,417,692.13
These accounts have been excluded due to self-vote percentages above 90%.
The Bid-bots (direct delegations)
The list of accounts used in this query can be found here: https://hackmd.io/s/rygQEFZqG
The syntax of the query below excludes this list for viewing ease.
select sum((cast(left(vesting_shares, len(vesting_shares)-6) as float)*490.009/1000000)+
(cast(left(received_vesting_shares, len(received_vesting_shares)-6) as float)*490.009/1000000)-
(cast(left(delegated_vesting_shares, len(delegated_vesting_shares)-6) as float)*490.009/1000000))
from accounts with (nolock)
where name in ('BOT LIST GOES HERE')
Total SP: 18,529,234.84
These accounts have been excluded due to the necessity to send a transfer amount for a vote.
What is left available so far?
Excluding the accounts in the set of queries above:
Total Steem Power available: 59,551,529.90
The following Pie chart represents the figures above, which are also listed in the table below.
This is an initial attempt to display Steem Power that is both taken, and free for use on Steemit.com.
However, the analyst would like to look at excluding more accounts and Steem Power to try and give a clearer picture of what Steem Power could actually be available.
3. Further account exclusions
There are additional 'pay for vote' services offered by 'randowhale', 'smartmarket', 'minnowbooster', and 'booster' that can access owned Steem Power (not delegated to these accounts) to provide a vote for content when a transfer is made to one of them.
A true reflection of the scale of this is difficult as the owners of this Steem Power can also cast manual 'non-paid' votes when they wish. Therefore it could be argued that the following SP exclusion is unwarranted, and inaccurate. But let's have a look anyway..
A look into the Wallets of the aforementioned accounts shows a number of different payments out to accounts with various default memos.
The following query represents a best guess at the memo used to send to accounts that have made their vested Steem Power available to be used in a 'pay for vote' system.
select distinct [to] from TxTransfers where [from] = 'minnowbooster'
and timestamp between convert(date,'03/15/2018') and convert(date,'03/22/2018')
and (memo like ('%You withdrew%'))
union
select distinct [to] from TxTransfers where [from] = 'smartsteem'
and timestamp between convert(date,'03/15/2018') and convert(date,'03/22/2018')
and memo like '%Automatic%'
union
select distinct [to] from TxTransfers where [from] = 'randowhale'
and timestamp between convert(date,'03/15/2018') and convert(date,'03/22/2018')
and memo like '%[randowhale]%'
union
select distinct [to] from TxTransfers where [from] = 'booster'
and timestamp between convert(date,'03/15/2018') and convert(date,'03/22/2018')
and memo like '%Payment for%'
The memo's analysed are from the previous 7 days and the total Steem Power of the 1794 unique accounts returned is:
Total SP: 6,096,223.49
Again, this is a best guess for purpose of this analysis. At least some of this Steem Power is being used to vote manually and for 'free'.
A look at the top accounts left
If we exclude the accounts in the first section (bid-bots, cleaners, etc) and the accounts in the previous section, who are the accounts left holding the most available Steem Power? And can we exclude any of these also?
The following is a list of the 25 accounts that were not excluded during the analysis above. Notes are given on the decision to include/exclude their Steem Power or not.
Fig 1:
Fig 2:
From: http://www.steemreports.com/votes-graph
And so, if we remove the Steem Power of the accounts with an 'N' in the list above, the total 'available' Steem Power is:
48,671,915.529
Following the additional removal of 'available' Steem Power as explained in this section, the chart now looks like this:
With additional accounts removed totalling over 11 million Steem Power, there is still over half of the pool remaining.
4. Summary
The amount of active, free and available Steem Power in this analysis sits at almost 50 million.
Using https://www.steemnow.com/upvotecalc.html to test how much this vote is worth at 100%, and entering the maximum of 10 million SP, the figure returned is $1426.73.
Multiply that by 5 (rounding 48,671,915.529 up) and this is $7133.65
Multiply that by 10 (votes), and ignore the reduction in Steem Power each time for simplicity, and this totals $71,336
There is virtually no accounting for 'high' self voting %'s or direct payment for votes in this analysis, and so one would assume the actual free Steem Power and the above figure is highly likely to be lower.
Thanks for reading, the analyst is not looking forward to questions, but is keen on viewing future work by others in this area.
5. Tools used to gather this data and compile report
The data is sourced from SteemSQL - A publicly available SQL database with all the blockchain data held within.
The SQL queries to extra to the data have been produced in both SQL Server Personal Edition and LINQPAD 5. Some of the code used for these results is as follows:
The charts used to present the data were produced using MS Excel.
This data was compiled on the 22nd March 2018 at 6pm (UCT)
Thanks
Asher @abh12345
Posted on Utopian.io - Rewarding Open Source Contributors