. by crokkon

`author`	crokkon
`permlink`	re-steempytutorials-an-in-depth-look-at-38-075-votes-since-the-inception-of-utopian-20180720t133554306z
`category`	utopian-io
`json_metadata`	"{"app": ""}"
`created`	2018-07-20 13:35:54
`last_update`	2022-09-18 11:36:33
`depth`	1
`children`	1
`last_payout`	2018-07-27 13:35:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.223 HBD
`curator_payout_value`	0.070 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1
`author_reputation`	81,214,366,861,104
`root_title`	"An In Depth Look At 38 075 Votes Since The Inception Of Utopian"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	65,365,978
`net_rshares`	139,625,125,959
`author_curate_reward`	""

voter	rshares	pct
juliank	115,831,839,802	50%
espoem	15,873,157,797	15%
steempytutorials	7,398,239,980	100%
mops2e	521,888,380	20%

$0.03

Hi @crokkon, thanks for your feedback!

It took about halve a day with 16 threads to process all the blocks. I have not considered beem, and not heard of it. Will look into it, thanks! I agree that querying the account history of @utopian-io would be a lot more efficient. This was mostly a test case for me as I am looking to perform more advanced analyses. 

About distinguishing moderator payments and votes on posts/comments I agree. This is something I have overlooked. I got a list of all the moderators and am looking to analyse the distribution between the costs of running Utopian, i.e. payments to moderators, and payouts to contributors. 

Thanks for the solid feedback, much appreciated.

👍 crokkon

`author`	steempytutorials
`permlink`	re-crokkon-re-steempytutorials-an-in-depth-look-at-38-075-votes-since-the-inception-of-utopian-20180720t203523404z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"users":["crokkon","utopian-io"],"app":"steemit/0.1"}
`created`	2018-07-20 20:35:24
`last_update`	2018-07-20 20:35:24
`depth`	2
`children`	0
`last_payout`	2018-07-27 20:35:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.020 HBD
`curator_payout_value`	0.005 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	699
`author_reputation`	31,094,047,689,691
`root_title`	"An In Depth Look At 38 075 Votes Since The Inception Of Utopian"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	65,406,194
`net_rshares`	13,650,867,783
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
crokkon	0 B		13,650,867,783	25%