Vote diversification - LeoFinance curators are upvoting how many authors on an average? ( Python codes )

in LeoFinance7 months ago

Good evening to everyone , today I am here with yet another statistical post which focuses on the voting data with respect to LeoFinance only .

Steps followed

  • I have taken every user who has staked LEO or has delegation for their account -
from hiveengine.tokenobject import Token
token=Token('LEO')
s=[]
end=0
x=0
while(end!=1):
    res=token.get_holder(offset=x) # function used to retrieve all user balance
    s.append(res)

    x=x+len(res)
    if(len(res)<500):
        end=1


list_holders=[]
for i in range(0,len(s)):
    for j in range(0,len(s[i])):
        list_holders.append(s[i][j])
user_list=[]
for i in range(0,len(list_holders)):
    if(float(list_holders[i]['stake'])>0 or float(list_holders[i]['delegationsIn'])>0): # checking for stake and delegations IN balance
        user_list.append(list_holders[i]['account']) # If yes , storing it in a list . 
    else:
        pass

I have explained the code above itself .

  • I have then gone through each and every user from user_list and searched for their curation reward in LEO and then stored it in a DataFrame . It looks like this -

image.png

Note - above data is for 25th Feb to 3rd March

  • Then all the statistical functions
df_leo_curation.groupby(['curator','author']).count().reset_index().groupby('curator').count().sort_values('author',ascending=False).head(30)['author'].to_frame()

Data

So for those who aren't interested in the code but want to see the data here it is -

Top 30 users who have got curation rewards from various authors -

UserNumber of different users they have upvoted
@uwelang533
@mk-leo-token458
@leovoter431
@onealfa.leo426
@r0nd0n413
@gadrian335
@babytarazkp329
@leo.voter316
@leofinance315
@roleerob309
@engrsayful306
@snoochieboochies286
@sbi-tokens285
@localgrower273
@leoneil.leo272
@ikaro272
@megavest254
@haxxdump253
@empoderat252
@alokkumar121243
@beehivetrader238
@abh12345.leo236
@travelwritemoney235
@shurbertum234
@thahodler233
@abdul.qadir232
@taskmaster4450le231
@onestop225
@alphacore222
@jeanlucsr203

What is this data? This tells us that in the past 7 days these people have voted for 200 and above different authors on LeoFinance .

Number of authors actually posted on LeoFinance

893 - that means the top 5 curators of LeoFinance has upvoted for 50% of the authors who have posted/commented using LeoFinance tag . 1 in 2 ( in 7 days ) - isn't that amazing? If you check the accounts - most of them have good amount of LP or good amount of HP .

Note - some are auto upvoting accounts but others aren't , I am sure I need not mention here who actually curates manually in the above list , you all know it

Average number of authors upvoted by curators on LeoFinance ( over 7 days )

36.35

Average number of authors upvoted by curators on LeoFinance ( per day )

5.19 - This is not an impressive number . This tells us either of two things

  1. People aren't utiziling all their upvotes
  2. People are voting for few others only .

5.19 means one curator per day is earning curation reward from 5 authors only .

Proportion of curators based on number of authors they have voted

image.png

Note

  1. Many of you might argue that whales have large voting value so they can diversify but a new user cannot do that -
    • This is partially correct and partially wrong because they need not vote different users at all . They can vote just 20 authors - 30 authors but clearly the data says otherwise , they aren't doing it .
  2. Out of 800 users who have posted using #leofinance during the period , there are many bots which you have to take into consideration .
  3. If you want your curation rewards total from 25th Feb to 4th March ( now ) let me know in the comments .

Regards,
Mr.

Posted Using LeoFinance Beta

Sort:  

I am probably in that 11-50 pile and I should look to diversify a little bit more. I am surprised that we have so 6.3% is 100 people or more. I might be in the 51-100 pile if I am lucky but I have keeping my activity to my feed and leomarkettalk.

Well if you wish to know it I will post your stats here , let me know .

I usually avoid posting others data unless they are okay with it.

Posted Using LeoFinance Beta

Yea I would like to see my data. Maybe I am lagging behind the pack by not diversifying enough.

Posted Using LeoFinance Beta

From 25th Feb to 4th March ( till 5 AM UTC ) -
0.325 is the total curation reward earned by @jfang003,
You have got curation rewards by upvoting to 311 different posts/comments, 74 unique authors

Not really bad but yeah could be better.

Yea it could definitely be better. At least I am in the top 25% for upvoting unique authors. But I really should be in the 100+ unique authors given the amount of comments I have been making everyday.

You are actually in top 15% . There were totally 1711 curators for that period and your rank was 254 .

Posted Using LeoFinance Beta

Awww... look at my baby.... I'm such a proud daddy.

That weirdness aside, can you do the curation for @babytarazkp please?

Awww... look at my baby.... I'm such a proud daddy.

can you do the curation for @babytarazkp please?

Sure :)

From 25th Feb to 4th March ( till 5 AM UTC ) -

34.91 is the total curation reward earned by @babytarazkp

You have got curation rewards by upvoting to 838 different posts/comments, 329 unique authors .

Great job :)

!ENGAGE 20

Posted Using LeoFinance Beta

Lol, nice choice of gif :)

Thank you for the info!

Don't mention , let me know if you need any other data , I will get them ASAP.

Thank you for your engagement on this post, you have recieved ENGAGE tokens.

Job well done.
festive_01.png

toruk_washere_new3leo.jpg

More info why you see this.

Posted Using LeoFinance Beta

Thanks a lot sir :)
If you need the curation data for your account please let me know :)

Posted Using LeoFinance Beta

Quite a solid stat here. It will help encourage quality when it comes to curation on Hive's second layer tokens. I hope to see this out for other tokens.

I will a similar one for Sports and CTP on monday because I have something already planned for today and tomorrow post so.

Out of 800 users who have posted using #leofinance during the period

Let's make it 1000 soon :)

Posted Using LeoFinance Beta

According to me we will hit it in around 30 days or so :)

Posted Using LeoFinance Beta

Let's make it even faster then 30 ;)

If #projectblank is here within 10 days then yeah we can bring over 200 users to LeoFinance within 20 days I guess.

Posted Using LeoFinance Beta

The Upvote System here is pretty good compared to hive itself
Also in sportstalksocial
Hive tribes are doing good

Posted Using LeoFinance Beta

You are absolutely right and one of the main reason for that is - dust system.

Posted Using LeoFinance Beta

If you want your curation rewards total from 25th Feb to 4th March ( now ) let me know in the comments .

Can you do my @abh12345.leo account please?

Hey from 25th Feb to 4th March ( till 5 AM UTC ) -

34.873 is the total curation reward earned by @abh12345.leo

You have got curation rewards by upvoting to 449 different posts/comments, 236 unique authors .

Posted Using LeoFinance Beta

That's not bad at all, thanks :)

One of the best . When it comes to upvoting unique ( or different authors ) you are ranked 22nd for the above mentioned period :)

Thanks for continuing to do this! Great information!

Posted Using LeoFinance Beta

No problem at all :) My pleasure . Let me know if you need your data , I will provide you.

Posted Using LeoFinance Beta

Okay thanks! I don't think I do right now, but at some point in the future I might definitely need it!

Posted Using LeoFinance Beta

Got it :) If you need any data at any time let me know .

Posted Using LeoFinance Beta

Really!?? Haha cool - I think this is the very first time I am listed as a #1 on any post / initiative on this blockchain since August 2016 :-).

Screen Shot 20210304 at 16.48.46.png

A shame I have only a few Leo Power

Posted Using LeoFinance Beta

Well LP doesn't matter. It's the intention that matters. Do you have a upvote bot running or something?

Posted Using LeoFinance Beta

True - I would still like to hear my weekly stats :-) - even I end up in tears.

I have no upvote bot running but also follow some trusted votes.

Posted Using LeoFinance Beta

I have no upvote bot running but also follow some trusted votes.

That's amazing then because couple of people in top 10 have bot running which upvotes all the #leofinance tagged posts but you have done incredibly well . Good job.

Posted Using LeoFinance Beta

And how are my weekly curation stats :-)?

I will send that to you as soon as I hop on my laptop . Sorry for the delay.

Posted Using LeoFinance Beta

no worries, take your time, it is not that important :-)

Posted Using LeoFinance Beta

From 25th Feb to 4th March ( till 5 AM UTC ) -
3.387 is the total curation reward earned by @uwelang,
You have got curation rewards by upvoting to 1360 different posts/comments, 533 unique authors .

There you go :) Good job .

Posted Using LeoFinance Beta

At the risk of embarrassing myself, I would like to see my data. It can only help me improve. :)

Posted Using LeoFinance Beta

Well I personally feel you are doing well .

Here is your data -

From 25th Feb to 4th March ( till 5 AM UTC ) -
5.891 is the total curation reward earned by @oldmans,
You have got curation rewards by upvoting to 114 different posts/comments, 49 unique authors .

Posted Using LeoFinance Beta

Thank you!

Posted Using LeoFinance Beta

I would like to see mine, I Know that i need to get better.

Posted Using LeoFinance Beta

From 25th Feb to 4th March ( till 5 AM UTC ) -
123.301 is the total curation reward earned by @tbnfl4sun,
You have got curation rewards by upvoting to 228 different posts/comments, 97 unique authors .

Well 97 users isn't bad . It is bad when it's less than 50 ( well according to me)

Posted Using LeoFinance Beta

Thanks, I was a little less active this week.

Posted Using LeoFinance Beta

Man you were less active but still you earned 123 LEO curation reward ? Lol . Good job mate .

Posted Using LeoFinance Beta

That's not so bad, is it? I do like having a large stake so I can earn without posting that much.

Posted Using LeoFinance Beta

Yes definitely , curation is as important as posting on Hive blockchain . Just imagine what happens if all curators took a break for a week lol .

Posted Using LeoFinance Beta

@tbnfl4sun based on my observation,you are trying your best,you can do better though...winks...

Posted Using LeoFinance Beta

Another great use of your analytical mind! lol This stuff is so interesting. I'm glad you like putting it out. I'd like to see my number if you get a chance please. Thank you!

By the way, what did you mean by "dust system"? Is there something I should know about that?

Posted Using LeoFinance Beta

Dust system is only applicable to Hive and not for tribes , it means that any post or comment which has less than 0.02$ rewards will be turned to dust that means you won't get that payout. So if my upvote is worth 0.01$ I usually vote post and not comments because of the fear that I will lose my curation rewards if others won't upvote the comment and push it above 0.02$.

Your data -

From 25th Feb to 4th March ( till 5 AM UTC ) -
2.26 is the total curation reward earned by @dagger212,
You have got curation rewards by upvoting to 108 different posts/comments, 73 unique authors .

Posted Using LeoFinance Beta

Thank you! So these numbers are just voting. Not actual comments, correct? I rarely vote on something I don't comment on. But I would get more curation reward if I did. Is that what this is telling me?

Posted Using LeoFinance Beta

Yes you got it right . You have considerably large LP and could earn more curation rewards but you aren't upvoting to your full potential is what the data says.

Posted Using LeoFinance Beta

Interesting, could have guessed that it looked like this but nice to see data that support it. More communities need to look at this and see what works!

Absolutely . Monday I will post about Sports and CTP , let's see what's happening over there.

Posted Using LeoFinance Beta

Awesome work!

I'd love to know my stats if yer offering!

Posted Using LeoFinance Beta

From 25th Feb to 4th March ( till 5 AM UTC ) -
106.86 is the total curation reward earned by @revise.leo,
You have got curation rewards by upvoting to 128 different posts/comments, 69 unique authors .

Sorry for the delay in replying .

Posted Using LeoFinance Beta

No worries about the time - I'm in the green pie I'll take that!

Be interesting to see this by votes on top level posts and votes on comments.

I'm sure I'm on votes to 60 odd authors because of comment voting mainly.

Posted Using LeoFinance Beta

Ah well right now the script doesn't differentiate between both . I will certainly take that into consideration the next time , is that okay?

Posted Using LeoFinance Beta

Hey that's cool - it's a great tool as it is, but it would be an awesome addition tooo!

Posted Using LeoFinance Beta

Definitely . If this weekend I find sometime I will implement that too :) Thanks for the advice.

Posted Using LeoFinance Beta

Congratulations @amr008! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You made more than 5500 comments.
Your next target is to reach 6000 comments.
You got more than 7750 replies.
Your next target is to reach 8000 replies.

You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Check out the last post from @hivebuzz:

Feedback from the March 1st Hive Power Up Day
Hive Tour Update - Financial stages

Hmmm.... I upvote a lot of other authors.

Posted Using LeoFinance Beta

Hello @offgridlife . You most certainly upvote a lot of people but this data is only regarding LeoFinance posts/ comments.

I just checked and you have got only 8 curation rewards in LEO for the said period .

Most of your curation rewards are 0 that's why you haven't been included in the top 25 list .

If I had counted this too then you would have been at the top maybe -

Ex: image.png

Posted Using LeoFinance Beta

Ok... thanks. I wonder why my curation rewards are only zero ? I have almost 16,000 Hive power ???

No sir , your curation rewards for Hive is very high .

What I sent was for LEO . Your LEO curation rewards are 0 because you have only 60 LP right now .

Posted Using LeoFinance Beta

It would be good to see such stats for the sportstalk and ctp very soon. Its always helpful for the bloggers to understand the timings when whales are active and the whales who actually vote 😁

That's true . I will do for them too very soon :)