This is an analysis of the voting of @utopian-io from inception to present day.
Sections
Vote numbers - previous 7 days, 30 days, since first vote cast on the 29th September 2017
Votes against reputation of author
Votes weight against reputation of author.
Popular authors - previous 7 days, 30 days, since first vote
Summary
Tools used to gather data and compile report
General
@utopian-io is the new kid on the Steem block, and has amassed 3.7 million Steem power through delegations.
At the time of writing:
a 25% up-vote is worth $ 72.62
a 50% up-vote is worth $145.23
a 75% up-vote is worth $216.27
a 100% up-vote is worth $288.88
source
Utopian is now a STEEM Witness - You can vote for Witnesses here
1. Vote Counts
To extract this data, the following SQL query has been used:
It would also be valid to join the TxVotes table and add to the WHERE clause to check if 'parent_author' = 0.
Total number of votes given in the past 7 days: 766
Number of votes given in the past 7 days for comments: 9
Daily average: 109
Total number of votes given in the past 30 days: 1749
Number of votes given in the past 30 days for comments: 9
Daily average: 58
Total number of votes given since 29th September (first vote): 1903
Number of votes given since 29th September for comments: 19
Daily average: 35.9
2. Votes and Reputation
The vote count is on the vertical axis, and the reputation range on the horizontal axis.
Votes across Reputation over the past 7 days
To extract this data, the following SQL query has been used:
Note the calculation to refine the user reputation, and the joining of the 'Accounts' table and 'TxVotes' table.
The average reputation here is 57
Votes across Reputation over the past 30 days
The average reputation here is 57.9
Votes across Reputation since 29th September (first vote)
The average reputation here is 57.9
3. Vote Weight and Reputation
The vote weight is on the vertical axis, and the reputation range on the horizontal axis.
Weight (Strength) of votes cast across reputation over the past 7 days
Weight (Strength) of votes cast across Reputation over the past 30 days
Weight (Strength) of votes cast across Reputation since 29th September (first vote)
4. Popular Authors
To extract this first set of data, the following SQL query has been used:
Most popular authors voted on in the past 7 days
Most popular authors voted on in the past 30 days
Most popular authors voted on since 29th September 2017 (first vote)
5. Summary
The number of average daily votes has risen impressively since inception date. This shows the number of author posts relating to @utopian-io increasing, and the accounts' willingness to support them.
The average reputation of post owner voted on is steady at 57 and has even fallen a little since day 1. This shows a good level of commitment to newer members of the Steem Blockchain who are producing work for @utopian-io.
Vote weight is fallen in line with the increasing amount of Steem Power the account holds. This is sensible and good to see, and most votes over the past week are in the 0 - 25% weight range.
Author popularity is changing from week to week, another good sign of rewards being spread and new contributors arriving.
Overall, I think @utopian-io are using their Steem Power delegations well, rewarding many authors and content with a sensible weight of vote.
6. Tools used to gather this report
The data is sourced from SteemSQL - A publicly available SQL database with all the blockchain data held within (Data is normally 1/2 hours delayed from live)
The SQL queries to extra to the data have been produced in both SQL Server Personal Edition and LINQPAD 5.
The charts used to present the data were produced using MS Excel.
This data was compiled on the 21st November at 8:30 am CET
Thanks
Asher @abh12345
Posted on Utopian.io - Rewarding Open Source Contributors