RE: Voting habits of the top 200 Whales - SteemitSQL Analysis by paulag

Viewing a response to: @ammonite/re-paulag-201781t95628193z

steemit · @paulag · Aug 1 '17

I need to find out what time zone the server is at and I will come back to you on that one......

👍 macrophotography

`post_id`	8,902,785
`author`	paulag
`permlink`	re-ammonite-re-paulag-201781t95628193z-20170801t125554081z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 12:55:54
`last_update`	2017-08-01 12:55:54
`depth`	2
`children`	4
`net_rshares`	338,563,847
`last_payout`	2017-08-08 12:55:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	96
`author_reputation`	224,445,607,823,384
`root_title`	"Voting habits of the top 200 Whales - SteemitSQL Analysis"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
macrophotography	0 B		338,563,847	100%

@wolo · Aug 2 '17 (edited)

$1.28

@ammonite @paulag Pretty sure it is PST.

----
I really loved your analysis - hope you do more in the future.

👍 randowhale, randowhalebonus, thesloth, wolo, randowhaletrail

`post_id`	9,022,364
`author`	wolo
`permlink`	re-paulag-re-ammonite-re-paulag-201781t95628193z-20170802t163343829z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["ammonite", "paulag"], "tags": ["steemit"]}"
`created`	2017-08-02 16:33:45
`last_update`	2017-08-02 16:34:09
`depth`	3
`children`	1
`net_rshares`	315,390,000,581
`last_payout`	2017-08-09 16:33:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.963 SBD
`curator_payout_value`	0.314 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	109
`author_reputation`	857,695,898,590
`root_title`	"Voting habits of the top 200 Whales - SteemitSQL Analysis"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (5)

voter	rshares	pct
randowhale	266,729,747,284	2.1%
randowhalebonus	41,648,666,094	1%
thesloth	4,232,217,769	1%
randowhaletrail	619,122,534	1%
wolo	2,160,246,900	100%

@randowhale · Aug 7 '17

This post received a 2.1% upvote from @randowhale thanks to @wolo!  For more information, [click here](https://steemit.com/steemit/@randowhale/randowhale-is-now-only-1-steem-sbd-per-vote-spread-the-news)!

properties (22)

`post_id`	9,439,391
`author`	randowhale
`permlink`	re-re-paulag-re-ammonite-re-paulag-201781t95628193z-20170802t163343829z-20170807t062208
`category`	steemit
`json_metadata`	"{"format": "markdown", "app": "randowhale/0.1"}"
`created`	2017-08-07 06:22:09
`last_update`	2017-08-07 06:22:09
`depth`	4
`children`	0
`net_rshares`	0
`last_payout`	2017-08-14 06:22:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	204
`author_reputation`	47,497,053,264,845
`root_title`	"Voting habits of the top 200 Whales - SteemitSQL Analysis"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@davidthelad · Aug 3 '17

o yeah please did you find the time zone, I appreciate this your post quite a lot, really helpful, something  different from all the shitposts I've been seeing.

properties (22)

`post_id`	9,113,702
`author`	davidthelad
`permlink`	re-paulag-re-ammonite-re-paulag-201781t95628193z-20170803t160703445z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-03 16:07:12
`last_update`	2017-08-03 16:07:12
`depth`	3
`children`	1
`net_rshares`	0
`last_payout`	2017-08-10 16:07:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	160
`author_reputation`	3,043,219,887,107
`root_title`	"Voting habits of the top 200 Whales - SteemitSQL Analysis"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@paulag · Aug 4 '17

the time zone is UTC

properties (22)

`post_id`	9,179,329
`author`	paulag
`permlink`	re-davidthelad-re-paulag-re-ammonite-re-paulag-201781t95628193z-20170804t094902836z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-04 09:49:00
`last_update`	2017-08-04 09:49:00
`depth`	4
`children`	0
`net_rshares`	0
`last_payout`	2017-08-11 09:49:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	20
`author_reputation`	224,445,607,823,384
`root_title`	"Voting habits of the top 200 Whales - SteemitSQL Analysis"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000