You are viewing a single comment's thread from:

RE: Steemit Content Analysis

in Popular STEM2 months ago

I send you the csv-files for each request after sending this comment.

So that you can categorise the data, I would like to explain the conditions that were used in the SQL query:

Accounts per day: Number of accounts created per day (file: daily_account_creation.csv)
Posts per day: Number of posts (without comments) created per day; also deleted/muted posts (file: daily_post_creation.csv)
Commentator per day: Number of authors per day who have written at least one comment; also deleted/muted comments; unique authors (file: daily_commentator_count.csv)
Author per day: Number of authors per day who have written at least one post; also deleted/muted posts; unique authors (file: daily_author_count.csv)

Unfortunately, there is no way (without big effort) to determine the number of voters per day. The votes are not stored separately in a table, but only together with other data.

I hope you can prepare the data accordingly and give us an analysis :-)

Sort:  
 2 months ago 

Coin Marketplace

STEEM 0.16
TRX 0.16
JST 0.029
BTC 68356.90
ETH 2509.71
USDT 1.00
SBD 2.53