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 steemdb.com, 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 steemdb.com 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: https://steemdb.com/@jesta/curation
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: https://steemdb.com/@jesta/authoring
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: https://steemdb.com/@kevinwong/powerup
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: https://steemdb.com/@jesta/powerdown
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: https://steemdb.com/@bittrex/transfers
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.
Pagination
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.
https://github.com/aaroncox/steemdb/commits/master
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 :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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 :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
One stemdb to show them all :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Beautiful! I love your service :D
Resteemed too.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
whts up with steemstats?! an update?!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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 :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Followed, top effort.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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 :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Resteemed!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
i wont survive Steemit without having Steemdb! I find myself more and more using it instead of steemd.
thanks for the great work.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Awesome work!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I love all the stats we can get out of the blockchain. Thanks for doing this
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you for this amazing tool to allow us to find out more info about our Steemit accounts
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is awesome news for the @steemit community! @steemstats and all of those who have put so much effort into this platform, Thank You!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Simply majestic :)
You bring the true meaning to the word TRANSPARENCY! Congratulations.
Keep up the excellent work!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
An outstanding tool! I really like it and I thanks you for developing it.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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 :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great job @jesta :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is genius! Thanks for developing it :) Much appreciated.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Awesome job! Can you increase the number of ranked posts, or make a "more" button on the bottom?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Increased to 100!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Cool!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I admire what you are doing for our community @jesta. So much value added! A pleasure to resteem!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Top Post
Congratulations. Your post received the most upvotes yesterday.
https://steemit.com/stats/@steempowerwhale/key-stats-for-authors-monday-october-10-2016-100-for-steem
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
good job as always @jesta 8]
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit