SteemSQL is a public MS-SQL database with all the blockchain data in it.
A few days ago, I announced the availability of the Witnesses table in the SteemSQL database.
Witnesses table is a non-transactional table which contains a list of all witnesses and related information.
But what about having a full history about witnesses, how they moved in the ranking, when they missed block, how they published pricefeed, when and how long did they deactivated their witness node, ... ?
To be able to answer all those questions, I added the
SSWitnesses table to SteemSQL. This table contains a daily snapshot of the most interesting values from the
Each snapshot is taken every day at 23:59:59 UTC.
SSWitnesses table description
The table contains the following columns:
|date||The date at which the snapshot has been taken|
|name||account name of the witness|
|votes_count||number of votes the witness received|
|url||The URL of the witness presentation post|
|votes||Total amount of VEST from voters|
|total_missed||Number of blocks missed|
|last_confirmed_block_num||Block number of the last block signed by the witness|
|signing_key||Current signing key use by the Witness. A value of |
|account_creation_fee||Proposed cost for the creation of a new account|
|maximum_block_size||Proposed maximum block size|
|sbd_interest_rate||Proposed interest rate to rewards users holding SBD|
|sbd_exchange_rate_base||Proposed cost in SBD to buy 1 STEEM|
|sbd_exchange_rate_quote||Proposed value for the ratio between SBD and STEEM for rewards|
|last_sbd_exchange_update||Last time the witness updated its pricefeed|
|running_version||Current version of the witness node|
|hardfork_version_vote||Current version of the hardfork supported by the witness|
|hardfork_time_vote||Time of vote from the witness for the latest supported hardfork|
Here an updated diagram of the database:
Visit SteemSQL website for more information.
Thanks for reading.