April 2019 - Top 10 Curation Rewards
After a couple of hours of faffing around I have defeated SQL and have your top 10 curation rewards for April to present....
source
Before today, I wasn't actually aware where my largest curation rewards were coming from. I expected that my vote weight would be higher than average, and wondered if OCDB might be influencing them somewhat, but I wasn't sure where from, what vote time was working, or how much the top earners gave me.
So I thought I'd have a look, and see if there was something I could offer you :)
The columns are as follows:
- Author
- Link to the post/comment
- Number of hours, minutes, seconds the vote was cast following the creation of the post/comment
- Vote weight
- Reward in Vests
- Reward in SP (estimated)
The reward in SP is estimated because we are going back a month, and since the amount of STEEM per MVESTS is constantly moving (upwards), this number will be slightly inaccurate.
Also, as I am checking the curation payouts for April, the content could have been created during the last 7 days of March.
Here's mine for April 2019:
| Author | Link | Vote TD | weight | Vests | SP est |
|---|---|---|---|---|---|
| surfermarly | content | 00:08:30 | 10000 | 3071.56 | 1.540 |
| v4vapid | content | 00:11:15 | 10000 | 2952.32 | 1.480 |
| anomadsoul | content | 00:10:24 | 10000 | 2191.24 | 1.098 |
| v4vapid | content | 00:11:12 | 10000 | 1963.46 | 0.984 |
| v4vapid | content | 00:11:18 | 10000 | 1806.44 | 0.905 |
| anomadsoul | content | 00:10:33 | 10000 | 1602.44 | 0.803 |
| v4vapid | content | 00:11:18 | 10000 | 1516.32 | 0.760 |
| anomadsoul | content | 00:10:33 | 10000 | 1501.33 | 0.752 |
| anomadsoul | content | 00:10:45 | 10000 | 1432.56 | 0.718 |
| anomadsoul | content | 00:10:33 | 10000 | 1366.6 | 0.685 |
So basically, the 100% votes won the day - not a big surprise, but it would have been nice to see a lower vote weight in there too.
The authors are likely known to most of you, and well, they've all been good to me in the past so there we are :)
Two are contests which were backed by a blocktrades vote - that helped, but the top earning one I am very happy to see up there because I sat in the audience watching @surfermarly promoting Steem at a recent blockchain conference in sunny Palma, Mallorca. Fitting that it tops the list I think :)
Looking at the rewards in approximate Steem Power, the top two are more than 3 times the size of my full vote back then which was around 35 - 40 cents. Nice!
The query itself is rather slow at around 5 mins for 1 execution. It's almost certainly my code but I am joining 3 tables together to find the information I want to present.
Anyone interested in a report?
Cheers
Asher
Yes please as curation continues to be the biggest mystery for me on how to improve!
Posted using Partiko iOS
Almost missed this one as it has been bumped to the top :)
Wow! 1.5+ SP from one vote. Sweet.
Almost all votes are at 10-11 mins, looks like you have found a sweet spot.
Yep - That post got the full treatment it deserved :)
10-11 mins looking good for me, I think lower is better with less SP, and higher (up to 15 mins) is better with more SP.
I love those freaking numbers, was I number 6 today or you ? Just checking for @bengy 😂
😬
It seems that you are in 6th :D
What is your max vote size? .475 sounds much bigger!
Thanks
Very interesting indeed. Is there actually any articles explaining the curation to a dummy? Something that would explain the weight and vests and everything else I don't understand 😝
And you're welcome btw 😁
yes please abh12345
Alright let's have a look :)
A couple of nice ones there from kryptogames :)
Of course. I went to bed a bit earlier than normal :)
I am glad to hear it!
Quite a decent spread :)
Not too bad and glad that ocd is in there. I think that the one for May might be better for variation as I have been voting on OCD recommendations a couple times a week to get more authors involved.
Looks like an interesting summery summary, even if it was back in the fall, when you have time it would be appreciated, thank you.
These are for last month, is that fall where you are? :D
COOL
Typo, should have been spring, dead brain day, what can I say.
Hey Asher. Any report is useful to see how and where we can improve. This month I have jumped a bit and still trying to find my feet with this.
I'll try to remember to kick on of these out each month then :)
Gentle dong? lol
Lol. Yep he got hit by oracle-d as did bozz. This is why these two did so well and I got lucky. I wish it was that easy and you could do that every day ,but it changes every week.Would be great to see this monthly and a good idea.
When you get the time throw my report in there also
That is interesting
Sure :)
Thanks
I sure don’t get how this works. But then again I just on’t have the time to sit down and go ver it.
50 more SP and I am where I want to be (Dolphin). Hahaha thats what counts.
Tarazkp posts 4 times a day. :(. Hehehe
I do interesting on the report.. can I get mine, please.. thank you👐
Of course :)
you are doing it with your code? it would be fun to see the stats.
Yes, SQL script. Let's see :)
thanks