SteemWorld Update / New Tool Planned / Downloadable Steem Accounts DB
I'm in the process of adding a new tool to SteemWorld that will give us an overview of all Steem accounts with many different filtering and sorting capabilities.
The tool will offer predefined sets of data like:
- top/flop accounts by vesting shares (SP)
- top/flop accounts by STEEM/SBD balance
- top/flop accounts by reputation
- top/flop accounts by earned author/curation rewards
- biggest active Powerdowns
- newest/oldest Steem accounts
- and more...
It will also be possible to search for specific criteria.
For example, one can search for accounts:
- and more...
In regards to keeping the database updated in real-time I'm still in the planning stage and maybe I will build an own plugin for
steemd for this. As I already parse each block for other tools on SteemWorld, I might implement it in the existing parsing routines. I will see what's the best solution in my case and keep you updated.
For now I created a test (SQLite) db that contains all the data I need (updated last night) with simple indices (no multi column indices for now, just one for each column in the table). If you are a developer or statistics guy and you want to play around with the data, you can download the (xz compressed) database here:
( 96.6 MB compressed / 586.0 MB uncompressed )
accounts table currently contains the following columns:
If you are on Linux, you can just install 'DB Browser for SQLite' (open source) and jump directly into the db explorer simply by double-clicking the file (after decompressing it from
steem_accounts.sqlite3 of course).
Have fun and Steem on!