Viewing a response to: @paulag/voting-habits-of-the-top-200-whales-steemitsql-analysis
That's some serious data analysis! Thanks for putting in the work needed to debunk the "self-voting and friend-voting whales are killing Steemit" rumors. It's really interesting to see the differences in content categories between whale upvotes and the entire population's voting habits.
| post_id | 9,115,360 |
|---|---|
| author | mtgmisfit |
| permlink | re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170803t162626534z |
| category | steemit |
| json_metadata | "{"app": "steemit/0.1", "tags": ["steemit"]}" |
| created | 2017-08-03 16:26:27 |
| last_update | 2017-08-03 16:26:27 |
| depth | 1 |
| children | 1 |
| net_rshares | 0 |
| last_payout | 2017-08-10 16:26:27 |
| 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 | 288 |
| author_reputation | 422,236,288,651 |
| 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 |
yes it is nice to see the rumors are not exactly true, however I am doing another analysis at the moment on posts from the trending page that might raise some eyebrows
| post_id | 9,129,061 |
|---|---|
| author | paulag |
| permlink | re-mtgmisfit-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170803t192803498z |
| category | steemit |
| json_metadata | "{"app": "steemit/0.1", "tags": ["steemit"]}" |
| created | 2017-08-03 19:28:00 |
| last_update | 2017-08-03 19:28:00 |
| depth | 2 |
| children | 0 |
| net_rshares | 5,168,661,696 |
| last_payout | 2017-08-10 19:28: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 | 167 |
| 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 |
|---|---|---|---|---|---|
| mtgmisfit | 0 | 5,168,661,696 | 100% |