Where are the Votes (SP) going?

in OCD5 years ago (edited)

I've been playing with some SQL script for the past couple of hours, trying to find out who's been collecting the voting SP over the past 7 days.

The lists below come with a major caveat in that the right column on each list assumes that every vote cast was cast when the voter was at 100% voting power. Obviously that is unlikely to be the case, but it should serve as a reasonable figure to order by.

Also, downvotes have not been knocked off the totals.

I have the full lists in Excel for anyone who is interested. They didn't present to well in markup and that is the reason for the images.

So that's the top 100 'voter to author'. As you would probably expect, burnpost makes plenty of appearances from the larger accounts, but there are a couple of interesting names being supported often by some large accounts.

The next chart is the complete list, pivoted by author and ordered by total SP voted on their content over the past 7 days. Again, the total VP assumes that each vote was made when the voters VP was at 100%.



This should pretty much match up with the top 7 day earners.

@burnpost, the STEEM sink, has almost 4 times the total of the 2nd account in the list.

Three of my favourite authors are in that list.

And the rest is up to you to analyse :)

Cheers

Asher



select a.name as voter, (a.vesting_shares-delegated_vesting_shares+received_vesting_shares)*509.421/1000000 as sp, v.author
,count(v.voter+v.author) as votes, sum(v.weight) as weight, CONVERT(DECIMAL(16,2), sum((v.weight)+0.0)/10000) as 'same as 100% votes', 
((a.vesting_shares-delegated_vesting_shares+received_vesting_shares)*509.421/1000000)*sum(v.weight)/10000 as total_SP_voted_with
from txvotes v
inner join accounts a on v.voter = a.name
where v.weight > 0
and v.timestamp > getdate()-7 -- number of days to scan
group by a.name, (a.vesting_shares-delegated_vesting_shares+received_vesting_shares)*509.421/1000000,  v.weight, v.author
having 
((a.vesting_shares-delegated_vesting_shares+received_vesting_shares)*509.421/1000000)*sum(v.weight)/10000 > 200000 -- 200,000 or more in SP
 order by ((a.vesting_shares-delegated_vesting_shares+received_vesting_shares)*509.421/1000000)*sum(v.weight)/10000 desc

Sort:  

Can you do a top author list of downvotes received next? :P

yes please.

Should be possible with a slight change to the query :)

Nice work!

I wonder how the distribtion across the top 100 has changed post HF.

I've had a few goes at this and it's a tricky one. Ignoring names makes it a bit easier, so comparing the earnings of the top 100 over a set period prior to the fork v's recently is probably the best bet.

I'll see, this stuff takes hours of titting about! :D

How do I get on that list jk 😂😂😂😂

If you find out let me know! :P

Nice one Asher. What you ideally want is the rshares on the votes, but SteemSQL doesn't seem to provide that. I've had to pull apart API responses to get that info.

I think this is pretty indicative of where the big "relationships" are though.

yeah rshares would be the gold, a total nightmare for average scripters though!

vests is possible but just don't make sense to most (including me) with the numbers being so big.

It's good enough to see where the money is I think, cheers :)

wow what a well detailed statistics,,good post from you...

Posted via Steemleo

@burnpost, the SBD sink

Minor correction. @burnpost isn't a SBD sink. For one thing, SBD isn't currently being paid out as rewards, only STEEM. And if it were (as perhaps soon), @burnpost puts the SBD back on the internal market instead of burning it, and burns the STEEM instead.

In fact @burnpost is only a STEEM sink, not SBD.

@sbdpotato is the SBD sink. It is also on the list, but significantly smaller.

Hi @smooth, thanks for the clarification, I'll correct the post.

@blocktrades and @smooth realy used their power wisely by supporting upvote @burnpost.. Cheers...

Congratulations @abh12345, your post successfully recieved 0.27692888 TRDO from below listed TRENDO callers:

@amico earned : 0.18461925 TRDO curation


To view or trade TRDO go to steem-engine.com
Join TRDO Discord Channel or Join TRDO Web Site


Hey @abh12345, here is a little bit of BEER from @steevc for you. Enjoy it!

Learn how to earn FREE BEER each day by staking.

Hi @abh12345!

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your UA account score is currently 6.485 which ranks you at #174 across all Steem accounts.
Your rank has not changed in the last three days.

In our last Algorithmic Curation Round, consisting of 87 contributions, your post is ranked at #1. Congratulations!

Evaluation of your UA score:
  • You've built up a nice network.
  • The readers appreciate your great work!
  • Try to work on user engagement: the more people that interact with you via the comments, the higher your UA score!

Feel free to join our @steem-ua Discord server

Coin Marketplace

STEEM 0.23
TRX 0.25
JST 0.038
BTC 95511.18
ETH 3313.19
USDT 1.00
SBD 3.30