scrobble.life
OCD

Where are the Votes (SP) going?

Asher @abh12345@abh12345 (80)2394d

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

Comments · 21

  • @trendotoken(59)· 2391d

    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

  • @bien(69)· 2393d

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

  • @arcange(79)· 2394d

    Congratulations @abh12345! Your post was mentioned in the Steem Hit Parade in the following category:

    • Comments - Ranked 8 with 48 comments
  • @wamush(4)· 2394d

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

    Posted via Steemleo

  • @steem-ua(64)· 2394d

    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

  • @teutonium(65)· 2394d

    I don't really like those upvotes going for burnposts, inflation is high, true, but at least it decentralizes the SP between more people decreasing the bad effect that the early mining had and making the blockchain truly decentralized, burning that inflation actually prevents the decentralization... but it's their stake after all, so I guess it's their choice, maybe it's a good thing, if those big accounts weren't burning the big amounts that we can see in those stats the price would probably go down by way too much...

    Now you got to do one of these for downvotes 😅

  • @chekohler(76)· 2394d

    Very little trickle-down I guess its to be expected with the funnel being so small and to curate effectively takes real-time and commitment. You'd think the recipients of all this inflation would be keen to pass it on, but hardly any of them even curate, that so-called passing it on effect died at the first hurdle lol

  • @freebornangel(72)· 2394d

    Now if we could get who on that list is only here to maximize their btc holdings, that would be great.

  • @geekgirl(80)· 2394d

    I am not in the list. Rigged!

  • @whatsup(76)· 2394d

    Interesting post! Thanks

  • @whatsup(76)· 2394d

    There we are curation in action. :) Naughty grin.

  • @smooth(74)· 2394d

    @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.

  • @abitcoinskeptic(75)· 2394d

    Some of the people on this list and their content :(

  • @stackin(78)· 2394d

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

  • @buggedout(77)· 2394d

    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.

  • @revisesociology(82)· 2394d

    Nice work!

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

  • @acidyo(84)· 2394d

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

  • @tsnaks(68)· 2394d

    Dayumn, that's alot alot of Steem Power :D

  • @beerlover(65)· 2394d

    View or trade BEER.


    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.

  • @steevc(80)· 2394d

    Interesting stats. We can see that a lot of big accounts support the potato and burn posts. I guess they think those do some good. It's also clear that some people are making a lot more than most of us could hope to. I am sure some of that is down to fishing for curation rewards, but that's the way of things. At least the curation projects are helping spread the rewards better than previously.

    Cheers. Have a !BEER.

  • @amico(67)· 2394d

    @tipu curate

    A huge hug from @amico! 🤗

    #sbi-skip !trdo