I had fun querying Steemit database - Ever wondered how they generate Steemit stats/charts by mokluc

View this thread on: hive.blog | peakd.com | ecency.com

til · @mokluc · Jul 13 '17

$8.06

I had fun querying Steemit database - Ever wondered how they generate Steemit stats/charts

<center> ![](https://media.giphy.com/media/6dRsQSNHU3Cla/giphy.gif)</center>

I have always been curious how to generate Steemit stats and as seen on some post like:

* [Steemit's Community Engagement is up over 1,000%](https://steemit.com/steemit/@furion/steemit-s-community-engagement-is-up-over-1-000) by @furion 
* [Steemit Statistics - 2017.06.14](https://steemit.com/statistics/@arcange/3v6u18-steemit-statistics-2017-06-13) by @arcange

From my previous [post](https://steemit.com/steemit/@mokluc/i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post) I have stated:
> The past few days I have been exploring Steemit libraries and database. It all started when I wanted to know the top 10 people who votes for my posts in a week/month then populate it on a bar graph/chart.

<center> ![](https://bigclosetr.us/topshelf/system/files/u1973/gallery3/Ancient-Laur-Dividers-1a.png) </center>
### <center><p>How I generated the charts and stats</p></center>
### 1) I downloaded the example of graphs here: [https://github.com/SteemData/steemdata-charts](https://github.com/SteemData/steemdata-charts)
<center> ![](https://picload.org/image/rpidgcpi/github.jpg)</center>
### 2) Created an account on [https://plot.ly/](https://plot.ly/)
<center> ![](https://picload.org/image/rpidgwwl/plot.jpg)</center>
### Then I unzipped the files and upload them on **Plotly** and done...simple as 1,2...
<center> ![](https://bigclosetr.us/topshelf/system/files/u1973/gallery3/Ancient-Laur-Dividers-1a.png) </center>
### By opening the files:
### <center><p>"ChartsLR.ipynb" generates a graph of  "Daily Active Users"</p></center>
<center> ![](https://picload.org/image/rpidrgda/july10.jpg)</center>
### <center><p>"Charts.ipynb" generates a graph of  "Daily posts count"</p></center>
<center> ![](https://picload.org/image/rpidropl/posts.jpg)</center>
<center> ![](https://bigclosetr.us/topshelf/system/files/u1973/gallery3/Ancient-Laur-Dividers-1a.png) </center>
### <center><p>While still on Plotly you can see the code to generate the given examples. Below is an example of **Daily posts count** well not complete here</p></center>
<center> ![](https://picload.org/image/rpidrldr/code.jpg)</center>
### <center><p>In order to edit or create your own graphs or charts:</p></center>
Try Jupyter notebook: [https://try.jupyter.org/](https://try.jupyter.org/) then New, Python3.....and have fun!!!
<center> ![](https://picload.org/image/rpidrcdw/python3.jpg)</center>
### If there are other methods, kindly share...
- - -
### Also check out:  [I had fun querying Steemit database - Is this Steemit first ever post?](https://steemit.com/steemit/@mokluc/i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post)

Image credit: [1](https://giphy.gif)
<center> ![](https://bigclosetr.us/topshelf/system/files/u1973/gallery3/Ancient-Laur-Dividers-1a.png) </center>
<center> ![](https://media.giphy.com/media/F0M5HYrDY5Fkc/giphy.gif) </center>

👍 gavvet, thecryptodrive, timsaid, htooms, mandela, pharesim, speda, dragonslayer109, coinbitgold, mokluc, jacor, rynow, bue, annaarthur, annieb, saiku, sv67216721, nomoreheroes7, selwi, dwaeji-aizelle, funnyman, arjane, nape, steve-walschot, altcointrends, crazymumzysa, ubg, prudy, bue-witness, vannour, boy, keuudeip, mini, detol, chessmasters, velimir, thedonfreeman, daniel.pan, oluwoleolaide, stefen, healthcare, steemcultures, bunny, moon, cih, indiantraveller, zhuvazhuva, furion

`author`	mokluc
`permlink`	i-had-fun-querying-steemit-database-ever-wondered-how-they-generate-steemit-stats-charts
`category`	til
`json_metadata`	{"tags":["til","steemit","steemdata","steemstats","steem"],"users":["furion","arcange"],"image":["https://media.giphy.com/media/6dRsQSNHU3Cla/giphy.gif","https://bigclosetr.us/topshelf/system/files/u1973/gallery3/Ancient-Laur-Dividers-1a.png","https://picload.org/image/rpidgcpi/github.jpg","https://picload.org/image/rpidgwwl/plot.jpg","https://picload.org/image/rpidrgda/july10.jpg","https://picload.org/image/rpidropl/posts.jpg","https://picload.org/image/rpidrldr/code.jpg","https://picload.org/image/rpidrcdw/python3.jpg","https://media.giphy.com/media/F0M5HYrDY5Fkc/giphy.gif"],"links":["https://steemit.com/steemit/@furion/steemit-s-community-engagement-is-up-over-1-000","https://steemit.com/statistics/@arcange/3v6u18-steemit-statistics-2017-06-13","https://steemit.com/steemit/@mokluc/i-had-fun-querying-steemit-database-is-this-steemit-first-ever-post","https://github.com/SteemData/steemdata-charts","https://plot.ly/","https://try.jupyter.org/","https://giphy.gif"],"app":"steemit/0.1","format":"markdown"}
`created`	2017-07-13 17:24:00
`last_update`	2017-07-13 17:24:00
`depth`	0
`children`	4
`last_payout`	2017-07-20 17:24:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	6.788 HBD
`curator_payout_value`	1.274 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	2,949
`author_reputation`	42,525,517,127,291
`root_title`	"I had fun querying Steemit database - Ever wondered how they generate Steemit stats/charts"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	8,362,728
`net_rshares`	1,964,325,218,731
`author_curate_reward`	""

properties (23)vote details (48)

voter	rshares	pct
pharesim	103,607,340,496	0.03%
boy	595,800,643	100%
bue-witness	726,478,268	100%
bunny	97,780,981	100%
bue	13,420,576,389	100%
mini	318,445,555	100%
moon	80,976,394	100%
healthcare	118,674,965	100%
daniel.pan	187,746,577	100%
nomoreheroes7	4,348,508,277	5%
gavvet	585,240,578,926	5%
steve-walschot	1,835,589,599	5%
dragonslayer109	69,942,300,445	5%
coinbitgold	58,873,167,803	30%
thecryptodrive	316,930,572,854	25%
furion	0	100%
jacor	34,682,226,719	5%
zhuvazhuva	0	1%
annieb	6,449,283,203	100%
speda	93,543,894,964	25%
ubg	1,495,835,630	100%
crazymumzysa	1,541,592,540	5%
timsaid	252,108,129,387	2.5%
annaarthur	9,361,890,482	100%
funnyman	2,721,717,972	1%
rynow	19,553,943,860	10%
saiku	5,604,641,885	100%
vannour	639,139,497	0.5%
steemcultures	116,966,893	0.5%
keuudeip	441,156,141	5%
mokluc	41,884,459,945	100%
selwi	3,102,936,129	100%
cih	76,479,436	0.5%
chessmasters	281,842,307	100%
detol	293,632,505	5%
prudy	1,492,583,813	100%
mandela	121,727,467,384	100%
htooms	196,374,776,696	15%
oluwoleolaide	181,234,162	0.5%
arjane	2,211,774,573	25%
velimir	231,966,883	0.5%
sv67216721	4,976,291,018	5%
altcointrends	1,661,131,944	3%
indiantraveller	58,206,286	0.3%
nape	2,051,010,490	100%
dwaeji-aizelle	2,784,550,450	100%
stefen	140,292,392	100%
thedonfreeman	209,624,973	100%

@stefen · Jul 13 '17

Nice demographics :-)

properties (22)

`author`	stefen
`permlink`	re-mokluc-i-had-fun-querying-steemit-database-ever-wondered-how-they-generate-steemit-stats-charts-20170712t184106235z
`category`	til
`json_metadata`	{"tags":["til"],"app":"steemit/0.1"}
`created`	2017-07-13 17:26:09
`last_update`	2017-07-13 17:26:09
`depth`	1
`children`	1
`last_payout`	2017-07-20 17:26:09
`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`	21
`author_reputation`	6,803,833,244,756
`root_title`	"I had fun querying Steemit database - Ever wondered how they generate Steemit stats/charts"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	8,362,947
`net_rshares`	0

@mokluc · Jul 14 '17

Thanks @stefen

properties (22)

`author`	mokluc
`permlink`	re-stefen-re-mokluc-i-had-fun-querying-steemit-database-ever-wondered-how-they-generate-steemit-stats-charts-20170714t153740290z
`category`	til
`json_metadata`	{"tags":["til"],"users":["stefen"],"app":"steemit/0.1"}
`created`	2017-07-14 15:37:39
`last_update`	2017-07-14 15:37:39
`depth`	2
`children`	0
`last_payout`	2017-07-21 15:37: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`	14
`author_reputation`	42,525,517,127,291
`root_title`	"I had fun querying Steemit database - Ever wondered how they generate Steemit stats/charts"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	8,469,293
`net_rshares`	0

@thedonfreeman · Jul 13 '17

Good to know. Thank you. Upvoted!

👍 thedonfreeman

`author`	thedonfreeman
`permlink`	re-mokluc-i-had-fun-querying-steemit-database-ever-wondered-how-they-generate-steemit-stats-charts-20170713t172609239z
`category`	til
`json_metadata`	{"tags":["til"],"app":"steemit/0.1"}
`created`	2017-07-13 17:26:12
`last_update`	2017-07-13 17:26:12
`depth`	1
`children`	1
`last_payout`	2017-07-20 17:26:12
`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`	33
`author_reputation`	7,788,598,670,958
`root_title`	"I had fun querying Steemit database - Ever wondered how they generate Steemit stats/charts"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	8,362,951
`net_rshares`	202,637,474
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
thedonfreeman	0 B		202,637,474	100%

@mokluc · Jul 14 '17

@thedonfreeman thanks for reading.

properties (22)