I have added lots of new graphs and drill downs. Try it out! https://eroche.shinyapps.io/hiveanalytics/ 
author | eroche |
---|---|
permlink | hiveanalytics-updates-v2-3 |
category | hive-133987 |
json_metadata | {"tags":["hivesql","stats","hive","blockchain"],"image":["https://images.hive.blog/DQmdmFw9PzuZfdgnGuPHkWArEJ459X7DTL4qWeFQX4xdA68/image.png"],"links":["https://eroche.shinyapps.io/hiveanalytics/"],"app":"hiveblog/0.1","format":"markdown"} |
created | 2021-06-09 08:00:06 |
last_update | 2021-06-09 08:00:06 |
depth | 0 |
children | 22 |
last_payout | 2021-06-16 08:00:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 3.874 HBD |
curator_payout_value | 3.806 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 203 |
author_reputation | 70,759,290,299,941 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,225,835 |
net_rshares | 13,792,423,103,789 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
jeffjagoe | 0 | 308,067,675,451 | 100% | ||
demotruk | 0 | 994,845,391,657 | 100% | ||
yogi | 0 | 29,919,463,811 | 50% | ||
joythewanderer | 0 | 153,451,021,383 | 100% | ||
bryan-imhoff | 0 | 560,292,694,200 | 50% | ||
steevc | 0 | 995,562,039,303 | 60% | ||
richardcrill | 0 | 267,824,808,279 | 50% | ||
mjhomb | 0 | 365,479,783,831 | 100% | ||
floweroflife | 0 | 1,844,283,040 | 100% | ||
lighteye | 0 | 262,569,910,004 | 100% | ||
eroche | 0 | 368,999,540,752 | 100% | ||
edb | 0 | 43,500,710,114 | 30% | ||
steemfestdreams | 0 | 2,261,250,996 | 100% | ||
seablue | 0 | 9,220,182,979 | 100% | ||
fronttowardenemy | 0 | 203,030,342,641 | 100% | ||
danielsaori | 0 | 727,742,904,482 | 100% | ||
andrianna | 0 | 61,457,162,409 | 100% | ||
freebornsociety | 0 | 2,123,493,162 | 10% | ||
ammonite | 0 | 296,210,752,355 | 100% | ||
spectrumecons | 0 | 1,537,448,835,918 | 30% | ||
toofasteddie | 0 | 174,779,027,274 | 35% | ||
sanjeevm | 0 | 2,490,608,597,111 | 100% | ||
watersnake101 | 0 | 12,188,062,520 | 50% | ||
bashadow | 0 | 84,026,480,456 | 25% | ||
kimzwarch | 0 | 11,400,310,829 | 4% | ||
niallon11 | 0 | 144,889,729,261 | 50% | ||
eastmael | 0 | 43,882,273,472 | 100% | ||
vegoutt-travel | 0 | 22,398,071,618 | 30% | ||
fulcrumleader | 0 | 6,056,165,326 | 100% | ||
beiker | 0 | 8,874,614,634 | 100% | ||
etherpunk | 0 | 878,589,478 | 50% | ||
itchyfeetdonica | 0 | 309,424,874,015 | 50% | ||
sentipl | 0 | 2,851,954,816 | 100% | ||
iwanderela | 0 | 1,007,755,365 | 50% | ||
deepresearch | 0 | 373,136,490,217 | 40% | ||
ajaxalot | 0 | 4,054,094,608 | 5% | ||
wildarms65 | 0 | 6,601,172,918 | 100% | ||
bil.prag | 0 | 100,413,138,161 | 18% | ||
redlambo | 0 | 953,802,215 | 100% | ||
isotonic | 0 | 230,219,792,833 | 100% | ||
steemexperience | 0 | 125,228,506,492 | 50% | ||
slobberchops | 0 | 940,647,773,449 | 20% | ||
enforcer48 | 0 | 120,691,472,590 | 15% | ||
experienced | 0 | 1,678,542,152 | 100% | ||
dalz | 0 | 632,016,997,365 | 100% | ||
smartvote | 0 | 54,448,205,927 | 2.6% | ||
sorin.lite | 0 | 43,968,666,114 | 100% | ||
sbi10 | 0 | 67,929,384,946 | 28.67% | ||
toofast-ace | 0 | 1,281,620,741 | 100% | ||
sbi-tokens | 0 | 625,439,760 | 0.55% | ||
captainhive | 0 | 575,716,014,620 | 30% | ||
elpatoverde | 0 | 7,693,235,739 | 100% |
Awesome! Do you think you could add a filter for inclusion of a certain tag? Not just as the main tag, but of the many tags attached as metadata. I often use a semi manual method to count posts with the tag 'spanish' as a proxy for keeping track of activity of the Venezuelan userbase.
author | demotruk |
---|---|
permlink | re-eroche-quflcu |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2021.06.1"} |
created | 2021-06-09 11:02:57 |
last_update | 2021-06-09 11:02:57 |
depth | 1 |
children | 7 |
last_payout | 2021-06-16 11:02:57 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 286 |
author_reputation | 279,453,298,745,864 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,228,007 |
net_rshares | 0 |
Is this for the individual user posts, or for filtering the posts per day?
author | eroche |
---|---|
permlink | qufnrf |
category | hive-133987 |
json_metadata | {"app":"hiveblog/0.1"} |
created | 2021-06-09 11:54:51 |
last_update | 2021-06-09 11:54:51 |
depth | 2 |
children | 6 |
last_payout | 2021-06-16 11:54:51 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.188 HBD |
curator_payout_value | 0.189 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 75 |
author_reputation | 70,759,290,299,941 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,228,713 |
net_rshares | 985,023,660,702 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
demotruk | 0 | 985,023,660,702 | 100% |
The posts per day count
author | demotruk |
---|---|
permlink | qufo8x |
category | hive-133987 |
json_metadata | {"app":"hiveblog/0.1"} |
created | 2021-06-09 12:05:24 |
last_update | 2021-06-09 12:05:24 |
depth | 3 |
children | 5 |
last_payout | 2021-06-16 12:05:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 23 |
author_reputation | 279,453,298,745,864 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,228,858 |
net_rshares | 0 |
It was always very useful app, thank you @eroche
author | lighteye |
---|---|
permlink | qufe8o |
category | hive-133987 |
json_metadata | {"users":["eroche"],"app":"hiveblog/0.1"} |
created | 2021-06-09 08:29:12 |
last_update | 2021-06-09 08:29:12 |
depth | 1 |
children | 1 |
last_payout | 2021-06-16 08:29:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.063 HBD |
curator_payout_value | 0.064 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 48 |
author_reputation | 618,132,018,303,966 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,226,203 |
net_rshares | 358,634,169,318 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
eroche | 0 | 358,634,169,318 | 100% |
It's wip but getting there i think now :) Good to see you.
author | eroche |
---|---|
permlink | qufil9 |
category | hive-133987 |
json_metadata | {"app":"hiveblog/0.1"} |
created | 2021-06-09 10:03:09 |
last_update | 2021-06-09 10:03:09 |
depth | 2 |
children | 0 |
last_payout | 2021-06-16 10:03:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.044 HBD |
curator_payout_value | 0.045 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 59 |
author_reputation | 70,759,290,299,941 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,227,150 |
net_rshares | 256,618,675,319 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
lighteye | 0 | 256,618,675,319 | 100% |
@eroche, you were given LUV from @steevc. About: https://peakd.com/@luvshares https://ipfs.io/ipfs/QmUptF5k64xBvsQ9B6MjZo1dc2JwvXTWjWJAnyMCtWZxqM
author | luvshares |
---|---|
permlink | re-hiveanalytics-updates-v2-3-20210609t082635z |
category | hive-133987 |
json_metadata | "{"app": "beem/0.24.20"}" |
created | 2021-06-09 08:26:42 |
last_update | 2021-06-09 08:26:42 |
depth | 1 |
children | 0 |
last_payout | 2021-06-16 08:26:42 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 145 |
author_reputation | 5,651,102,754,153 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,226,175 |
net_rshares | 0 |
Cool. Interesting that less people comment than post. I think engaging in comments is one of the best ways to get support. I've had extensive discussions in comments with people. Hive should be social and not just about rewards as not everyone can make a lot. We really do need a lot more people active to make it a viable platform as some communities are tiny. You need a good group to cluster around a topic. I'm talking about actual communities who share an interest and not just those fishing for rewards, e.g. Gems. We have hundreds of thousands of accounts, but the majority are inactive. I know a lot are created in bulk rather than by individuals. Some projects are creating lots, but we do not see much increase in activity. Anyway, I'm having fun and love seeing more stats. !LUV
author | steevc |
---|---|
permlink | re-eroche-qufdnc |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2021.05.5"} |
created | 2021-06-09 08:16:24 |
last_update | 2021-06-09 08:16:24 |
depth | 1 |
children | 9 |
last_payout | 2021-06-16 08:16:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.101 HBD |
curator_payout_value | 0.101 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 792 |
author_reputation | 1,394,624,988,394,417 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,226,034 |
net_rshares | 558,102,282,319 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
eroche | 0 | 365,729,351,766 | 100% | ||
toofasteddie | 0 | 148,217,922,058 | 30% | ||
sorin.lite | 0 | 43,093,185,182 | 100% | ||
luvshares | 0 | 1,061,823,313 | 5% |
I am with you. It would be refreshing to see more comments by unique users, this is a good indication of engagement.
author | eroche |
---|---|
permlink | qufid7 |
category | hive-133987 |
json_metadata | {"app":"hiveblog/0.1"} |
created | 2021-06-09 09:58:21 |
last_update | 2021-06-09 09:58:21 |
depth | 2 |
children | 2 |
last_payout | 2021-06-16 09:58:21 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.028 HBD |
curator_payout_value | 0.027 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 118 |
author_reputation | 70,759,290,299,941 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,227,096 |
net_rshares | 158,291,263,103 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
steevc | 0 | 158,291,263,103 | 10% |
<div class='pull-right'>https://files.peakd.com/file/peakd-hive/beerlover/yiuU6bdf-beerlover20gives20BEER.gif<p><sup><a href='https://hive-engine.com/?p=market&t=BEER'>View or trade </a> <code>BEER</code>.</sup></p></div><center><br> <p>Hey @eroche, here is a little bit of <code>BEER</code> from @steevc for you. Enjoy it!</p> <p>Did you know that <a href='https://dcity.io/city'></b>you can use <b>BEER</b> at dCity game</a> to **buy dCity NFT cards** to rule the world.</p> </center><div></div>
author | beerlover |
---|---|
permlink | re-eroche-qufid7-20210609t100957055z |
category | hive-133987 |
json_metadata | {"app":"beerlover/2.0"} |
created | 2021-06-09 10:09:57 |
last_update | 2021-06-09 10:09:57 |
depth | 3 |
children | 0 |
last_payout | 2021-06-16 10:09:57 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 498 |
author_reputation | 25,827,897,207,690 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,227,237 |
net_rshares | 0 |
I've seen from stats others do that St--m gets less comments per post than Hive, so we are doing something better. The next hardfork may incentivise comment voting and help matters. !BEER
author | steevc |
---|---|
permlink | re-eroche-qufiue |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2021.05.5"} |
created | 2021-06-09 10:08:39 |
last_update | 2021-06-09 10:08:39 |
depth | 3 |
children | 0 |
last_payout | 2021-06-16 10:08:39 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 188 |
author_reputation | 1,394,624,988,394,417 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,227,217 |
net_rshares | 0 |
The fact of the matter is: crypto overwhelmingly attracts people looking for crypto. We still lack a grander vision. For reasons I have a hard time to fathom, a "writer community" such as Mirror did not get to know and understand and adopt Hive, Someone should have extended a helping hand and should have brought us over here. Them, and countless others
author | sorin.lite |
---|---|
permlink | re-steevc-202169t11513965z |
category | hive-133987 |
json_metadata | {"tags":["ecency"],"app":"ecency/3.0.18-mobile","format":"markdown+html"} |
created | 2021-06-09 09:05:15 |
last_update | 2021-06-09 09:05:15 |
depth | 2 |
children | 5 |
last_payout | 2021-06-16 09:05:15 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.028 HBD |
curator_payout_value | 0.022 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 355 |
author_reputation | 15,495,039,207,555 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,226,562 |
net_rshares | 161,686,526,482 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
steevc | 0 | 161,686,526,482 | 10% |
I've said a lot that we need a wide range of content. Crypto is pretty niche. I'm into music, comics, science, environmental issues and running as well as other things. I can find some posts about those to keep me interested. Hive should have something for everyone.
author | steevc |
---|---|
permlink | re-sorinlite-qufg6d |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2021.05.5"} |
created | 2021-06-09 09:11:00 |
last_update | 2021-06-09 09:11:00 |
depth | 3 |
children | 4 |
last_payout | 2021-06-16 09:11:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 266 |
author_reputation | 1,394,624,988,394,417 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,226,630 |
net_rshares | 42,297,897,613 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
sorin.lite | 0 | 42,297,897,613 | 100% |
author | toofasteddie |
---|---|
permlink | re-eroche-qufd9j |
category | hive-133987 |
json_metadata | {"tags":["hive-133987"],"app":"peakd/2021.05.5"} |
created | 2021-06-09 08:08:06 |
last_update | 2021-06-09 08:08:06 |
depth | 1 |
children | 0 |
last_payout | 2021-06-16 08:08:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.082 HBD |
curator_payout_value | 0.082 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 21 |
author_reputation | 672,098,525,912,190 |
root_title | "HiveAnalytics Updates V2.3" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 104,225,943 |
net_rshares | 455,664,770,689 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
steevc | 0 | 98,437,885,683 | 6% | ||
eroche | 0 | 357,226,885,006 | 100% |