Viewing a response to: @paulag/voting-habits-of-the-top-200-whales-steemitsql-analysis
Hi @paulag, I've noticed there might be a couple of problems with your analysis. You seem to have used totals over 15 days rather than 14, which means you didn't use the same number of each weekday. I think if you correct this, you'll find it makes quite a difference to your weekday graphs. It probably affects two days, Saturday and Sunday because you started at 21:00 rather than on a day boundary. Our provisional graph for votes over days (last 4 weeks) looks like this, which is surprisingly different from yours: http://www.steemreports.com/vote-days/?mode=stacked Our times distribution matches pretty well though (again 4 weeks): http://www.steemreports.com/vote-times/
| post_id | 8,990,390 |
|---|---|
| author | steemreports |
| permlink | re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170802t093538210z |
| category | steemit |
| json_metadata | "{"app": "steemit/0.1", "users": ["paulag"], "links": ["http://www.steemreports.com/vote-days/?mode=stacked", "http://www.steemreports.com/vote-times/"], "tags": ["steemit"]}" |
| created | 2017-08-02 09:35:39 |
| last_update | 2017-08-02 09:35:39 |
| depth | 1 |
| children | 0 |
| net_rshares | 0 |
| last_payout | 2017-08-09 09:35:39 |
| 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 | 682 |
| author_reputation | 26,984,297,179,214 |
| 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 |