Viewing a response to: @paulag/voting-habits-of-the-top-200-whales-steemitsql-analysis
Great info as always Paula. Im glad to see that the Whales for the most part are quite honorable. I do have one question. In the section where you discuss popular voting times are you basing this on UTC or GMT?
post_id | 8,885,785 | ||||||
---|---|---|---|---|---|---|---|
author | ammonite | ||||||
permlink | re-paulag-201781t95628193z | ||||||
category | steemit | ||||||
json_metadata | "{"app": "esteem/1.4.6", "format": "markdown+html", "community": "esteem", "tags": "steemit"}" | ||||||
created | 2017-08-01 08:56:33 | ||||||
last_update | 2017-08-01 08:56:33 | ||||||
depth | 1 | ||||||
children | 5 | ||||||
net_rshares | 116,245,091,827 | ||||||
last_payout | 2017-08-08 08:56:33 | ||||||
cashout_time | 1969-12-31 23:59:59 | ||||||
total_payout_value | 0.450 SBD | ||||||
curator_payout_value | 0.002 SBD | ||||||
pending_payout_value | 0.000 SBD | ||||||
promoted | 0.000 SBD | ||||||
body_length | 210 | ||||||
author_reputation | 56,378,187,690,347 | ||||||
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 | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
good-karma | 0 | 101,239,561,440 | 0.5% | ||
mondeja | 0 | 153,807,552 | 0.5% | ||
mysteem | 0 | 168,214,767 | 1% | ||
mindfreak | 0 | 0 | 0% | ||
demo | 0 | 324,518,049 | 1% | ||
feruz | 0 | 3,041,685,420 | 1% | ||
adept | 0 | 5,193,149,587 | 0.5% | ||
esteemapp | 0 | 2,930,966,190 | 1% | ||
sellergenius | 0 | 99,937,763 | 0.5% | ||
elgeko | 0 | 1,716,362,151 | 0.25% | ||
bounties | 0 | 344,941,873 | 1% | ||
steempoll | 0 | 334,835,401 | 1% | ||
tipping | 0 | 304,300,182 | 1% | ||
macrophotography | 0 | 332,408,141 | 100% | ||
sdibot | 0 | 60,403,311 | 0.25% |
I need to find out what time zone the server is at and I will come back to you on that one......
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 | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
macrophotography | 0 | 338,563,847 | 100% |
@ammonite @paulag Pretty sure it is PST. ---- I really loved your analysis - hope you do more in the future.
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 | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
randowhale | 0 | 266,729,747,284 | 2.1% | ||
randowhalebonus | 0 | 41,648,666,094 | 1% | ||
thesloth | 0 | 4,232,217,769 | 1% | ||
randowhaletrail | 0 | 619,122,534 | 1% | ||
wolo | 0 | 2,160,246,900 | 100% |
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)!
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 |
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.
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 |
the time zone is UTC
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 |