steemdb 0.4.0 - a rich history for every account

in #steemdb5 years ago

This is probably my favorite set of features (to date) working on this project - it answers so many questions I've had about my account's history I couldn't find elsewhere! In the 0.4.0 release of, new key features include curation reward history, author reward history, transfer history, power up history and power down history.

These features are available for any account, just visit and search for your account using the search bar on the top, and use the sub navigation to find different aspects of your account.

Before I go any further, a huge thank you to @arhag, who helped me gather this information by developing a modified version of steemd. I couldn't have done this as easily without the feature he added here. I hope this patch makes its way into the official build soon!

Sorry mobile users, the site still isn't really optimized on your end yet.

Rewards History

Ever been curious about what your long term rewards history looks like, in terms of both curation and author rewards? I have, and no where have I been able to view detailed information about these events until now.

The black/blue navigation bar on this page allows you to navigate between Curation and Author rewards.

Curation Reward History

Example URL:

The above screenshot and link shows off the new curation rewards page which is available for every account. You can browse through the entire history of curation rewards for an account until the beginning of time using the pagination on the bottom of the page.

I choose to represent the graph and statistical information in VESTS instead of STEEM POWER, because the blockchain actually has no record of the STEEM POWER (AFAIK) you earned in the past. If I had a source of historical conversion rates I could update to show estimates of those rewards, but at this time I do not have that information.

However, each individual record as you scroll shows an estimated earnings in STEEM POWER using today's current conversion rate. So technically if you never powered down those rewards, this is what those rewards have grown to at this date. Confusing I know, we'll work it out and make it more consumable as time progresses :)

Author Reward History

Example URL:

This screenshot and associated link shows off the new author rewards page. Similar to the curation rewards page, this page shows rewards for all of the posts and comments you've ever written. Currently there is no way to filter between the two types of posts easily, but it's something on my radar to improve.

Transfer History

A number of times recently I have been asked for very deep history about the accounting of an account, whether it be for a promotion being run or for personal records. There are currently a number of different ways you can transfer funds, and to start with my in depth data analysis, I've choose what I feel are the three most important:

  • STEEM transfers (or "Power Up") to VESTS
  • VESTS transfers (or "Power Down") to STEEM
  • SBD/STEEM transfers between accounts

In the future I plan on also adding transfers to/from savings accounts as well as escrow.

The black/blue navigation bar on this page allows you to navigate between Power Up, Power Down and Transfer history.

"Power Up" Transfer History (aka Vesting Deposit)

Example URL:

I hope @kevinwong doesn't mind me using him as an example. He has powered up 19x times in the last 30 days, so it made for a good chart :)

This new power up transfer page shows all conversions of STEEM to SP/VESTS an account has ever performed and lets you dig into it's history. The top of the page also features a chart with the amount powered up, each day, over the last 90 days.

The page itself shows how much STEEM was transfered into SP, but doesn't account for how many VESTS the user received. As with the two sections above, once I get my hands on some historical conversion information, I'll be able to generate estimates for these conversions but never exact amounts.

"Power Down" Transfer History (aka Vesting Withdraw)

Example URL:

This new page is the exact opposite of the power up page, and shows all power down transfers an account has ever made. The record being shown here is when the actual power down occurs, and not the request to power down.

Here you can see a week to week overview of how much STEEM POWER/VESTS a user has withdrawn into liquid STEEM. The chart at the top of the page shows the last 90 days of history (roughly 12-13 weeks) of power down transfers.

STEEM/SBD Transfer History

Example URL:

Last but not least is the actual transfer page, which shows all STEEM and SBD transfers involving the account you're viewing. You can use the pagination at the bottom to browse through the entire history of transfers.

I choose @bittrex as an example to show in the screenshot above simply because they have a large volume of incoming and outgoing transfer history.

Note: Most transactions are missing the "type" column of the data right now. I am working on a fix for this, but it will require a decent amount of time to replay the blockchain and correct this issue. In my rush to get this project started, I inadvertently stripped off the currency symbol without thinking to store it anywhere.

Additional Features

New navigation items for accounts

All of the new features described above are located under "Activity" with these two menu items.

The user sidebar sticks to the page now

These pages are getting long, so I figured it might be nice if the sidebar followed you down the page to provide context.


All of these new pages have pagination elements as shown above. This element is at the bottom of each page that lets you browse forward and backward in time.

Some charts have tooltips now

They are sort of terrible, but they show something at least.

I haven't implemented them on every chart simply because it was taking too long, and charts with multiple data segments were almost impossible to do. This charting solution, while looks great, has been rather difficult to use when trying to setup tooltips and interactions.

Full change log

If you're interested in seeing all the minor changes (I won't include here), I'd invite you to check out the github commit history. This is an open source project, anyone can contribute and run it if they choose to.

I'm excited to have these updates deployed and I hope you enjoy! It'll likely be a few weeks before another update to steemdb is deployed, and on the radar is steemstats like features and new/better charting of data.

If you have something you'd specifically like to see, please let me know. While I haven't gotten around to everyones ideas, I do keep track of all suggestions and review them as I'm looking for fun new things to accomplish.


brilliant :) I think there is a lot of value to be found in these stats, especially for getting a little bit of more sentiment towards the status of Steem as currency. Maybe one interesting spin-off of these status will be towards this: a chart where you can measure, in percentages, what is the power-down / power-up ratio, the total amount of steem / vests / sbd in the platform and so on. That might even be something that I would sell access to it. One way or another :)

So you'd be interested in knowing what percentage of a global total a user's power up/down on each individual transaction or are you looking for more of a global ranking stat?

I think I'm interested more in aggregated data, even anonymized, without user identities, more like a trend indicator. It will help create a reliable sentiment among users / investors / traders. Thanks for following up, appreciated :)

Excellent job. I hope the post earns at least $1k as the added value to the ecosystem is much more than another picture of a steem ring or yet another steemfest reminder. WHALES PLEASE UPVOTE THIS POST.

One stemdb to show them all :)

Beautiful! I love your service :D
Resteemed too.

Followed, top effort.

While you're doing more in-depth metrics, could you include 'Total sp/vest of active followers'?
To estimate my potential earning I've just been tracking my total followers, but that weighs berniesanders the same as a minnow.
NB: berniesanders isn't actually following me. Yet.

I have a metric like that being shown on the accounts list page, but not on individual accounts yet. Good call though.

What did you mean by "active" followers though?

I know a lot of stats filter down to qualify only users who have commented or posted or upvoted in the last month, so I figure that would make a better measure of earning potential.
Being followed by a whale who hasn't visited the site in a month isn't likely to be of much benefit.
I'm not really savvy with the nuts and bolts of pulling data though, so I have no idea if you could actually do it that way. Either way, keep up the great work :)

ZOMFG, I wanted to make the very same patch didn't know how, though.

@arhag many thanks!
@jesta many thanks!

@faddat .... scurries away and compiles gleefully!

Awesome work!

If you have something you'd specifically like to see, please let me know.

It'd be interesting to "marry" the SP rewarded to a "back-then" price (from historical feed or exchanges), and a right-now price. By clicking a button one can see the $$$ equivalent (then/now).

Btw, excellent job.

Thanks! As soon as I figure out a way to get historical price data, I'll be adding something like this in. I haven't found a source for the data yet, but I'm sure one's out there.

There may be a workaround, although not very accurate :/

If you take a sample post reward of a given date, it'll give you the SP equivalent (which is the other 50% of the SDs). So, if a post got 100$, and 50$ were in SDs, and then the author got 300 SPs, then we know that these 300 SPs were considered to be worth 50$. So extrapolating this, we get 1SP= 50/300 = 0.166$.

Again, it should not be accurate, due to the lags involved (7-day average and stuff), but I can't think of anything else more representative sort of taking data from the historic charts of a RL exchange.

Thank you for this amazing tool to allow us to find out more info about our Steemit accounts

whts up with steemstats?! an update?!

I haven't had many new features to add over on steemstats recently. It's at the point where I've started rewriting it from scratch, because if I add too much more, it'll crash even more often :)

This is awesome news for the @steemit community! @steemstats and all of those who have put so much effort into this platform, Thank You!!

Simply majestic :)

You bring the true meaning to the word TRANSPARENCY! Congratulations.

Keep up the excellent work!

An outstanding tool! I really like it and I thanks you for developing it.

And could you add a counter anticipated awards curation in the next 24 hours
Just this feature would be very useful for some people
Sorry for my English

I'm only recording after payouts happen. To do estimations, I'd have to load all of your votes in the past 36ish hours, load every post you voted on, check their status, estimate your rewards and total it. It's not quite as easy as looking at your account history :)

This is genius! Thanks for developing it :) Much appreciated.

Awesome job! Can you increase the number of ranked posts, or make a "more" button on the bottom?

Increased to 100!

I admire what you are doing for our community @jesta. So much value added! A pleasure to resteem!

good job as always @jesta 8]

Thanks for this. It will take me a while to read this again and try to figure out everything.

Up voted and your upvoting my newest content about my love for art , I will feel appreciated.