SteemSQL is a public MS-SQL database with all the blockchain data in it.
Previous posts:
- Introduction post
- A list off all update posts is available on SteemSQL website
What’s new
A few days ago, I announced the availability of the Witnesses table in the SteemSQL database.
The 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 Witnesses table.
Each snapshot is taken every day at 23:59:59 UTC.
SSWitnesses table description
The table contains the following columns:
| Name | Description |
|---|---|
| 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 STM1111111111111111111111111111111114T1Anm means the witness was deactivated |
| 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.