RE: Calculating Hive Curation Rewards Using HiveSQL by steevc

View this thread on: hive.blog | peakd.com | ecency.com

Viewing a response to: @geekgirl/calculating-hive-curation-rewards-using-hivesql

hive-167922 · @steevc · Sep 20 '21

$0.36

I really need to look deeper into what HiveSQL can do. I have had some fun with it.

It's interesting to see how many large accounts are not voting at all. It looks like I am about average for curation income. I am not too strategic about how I vote.

!PIZZA

👍 geekgirl, proofofbrainio, stemgeeks, xplosive, richardcrill, scholaris.pob, stemcuration, anthonyadavisleo, sfr-treasury, yggdrasil.laguna
👎 anddumbcunts

`author`	steevc
`permlink`	re-geekgirl-qzq4kk
`category`	hive-167922
`json_metadata`	{"tags":["hive-167922"],"app":"peakd/2021.09.1"}
`created`	2021-09-20 08:21:57
`last_update`	2021-09-20 08:21:57
`depth`	1
`children`	2
`last_payout`	2021-09-27 08:21:57
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.179 HBD
`curator_payout_value`	0.177 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	258
`author_reputation`	1,052,227,841,139,063
`root_title`	"Calculating Hive Curation Rewards Using HiveSQL"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	106,425,821
`net_rshares`	424,199,015,188
`author_curate_reward`	""

properties (23)vote details (11)

voter	rshares	pct
richardcrill	13,657,632,041	6%
xplosive	18,908,147,767	100%
geekgirl	337,913,125,588	20%
anddumbcunts	0	-0.1%
sfr-treasury	47,024,846	55%
stemgeeks	19,543,035,427	20%
stemcuration	664,031,437	20%
yggdrasil.laguna	10,129,497	10%
anthonyadavisleo	160,848,507	55%
proofofbrainio	26,710,821,327	3%
scholaris.pob	6,584,218,751	6%

@geekgirl · Sep 20 '21 (edited)

$0.19

Yes, HiveSQL is fun.

I did notice that too, how some large stakeholders are not active in curating at all. Win for rest of us I guess. :)

I don't follow any strategy either when curating. I think just voting what see and like is the best way. Rewards are just a bonus.

Thank You!

👍 steevc, stemgeeks, fatman, scholaris.pob, cryptokungfu, stemcuration, yggdrasil.laguna

`author`	geekgirl
`permlink`	qzqc7z
`category`	hive-167922
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2021-09-20 11:07:12
`last_update`	2021-09-20 11:07:33
`depth`	2
`children`	0
`last_payout`	2021-09-27 11:07:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.097 HBD
`curator_payout_value`	0.095 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	282
`author_reputation`	1,217,987,453,490,030
`root_title`	"Calculating Hive Curation Rewards Using HiveSQL"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	106,428,342
`net_rshares`	230,892,602,304
`author_curate_reward`	""

properties (23)vote details (7)

voter	rshares	pct
steevc	192,353,978,009	10%
fatman	8,005,617,889	2%
stemgeeks	18,279,559,857	20%
stemcuration	284,807,718	20%
yggdrasil.laguna	9,849,646	10%
scholaris.pob	6,576,305,255	6%
cryptokungfu	5,382,483,930	100%

@pizzabot · Sep 20 '21

<center><p>@geekgirl! I sent you a slice of <b>$PIZZA</b> on behalf of @steevc.</p>
<p>Learn more about <b>$PIZZA Token</b> at <a href="https://hive.pizza">hive.pizza</a>
<sub>(2/10)</sub></p></center>

properties (22)

`author`	pizzabot
`permlink`	re-re-geekgirl-qzq4kk-20210920t082259z
`category`	hive-167922
`json_metadata`	"{"app": "beem/0.24.26"}"
`created`	2021-09-20 08:23:00
`last_update`	2021-09-20 08:23:00
`depth`	2
`children`	0
`last_payout`	2021-09-27 08:23:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	201
`author_reputation`	6,182,557,893,399
`root_title`	"Calculating Hive Curation Rewards Using HiveSQL"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	106,425,834
`net_rshares`	0