Hive History
I have recently learned that it is not very easy to track your hive account growth history. There are no publicly available user friendly tools to do that. Thanks to Marky, and @beaker007 we have discovered and used HAF. The Hive Application Framework (HAF) is a technical component designed to address the challenges of accessing and querying large amounts of historical data on the Hive blockchain.
We have accessed the documentation here: https://mahdiyari.gitlab.io/hafsql/, thanks to @mahdiyari
So what I am trying to do with this? In my previous post, I was trying to investigate how a sample group of people grown their SPS stake. I want to know how they have growth their hive stake as well.
Here are the six accounts in question that I investigated in the last post. Today, I will investigate their hive history of stake. So I colored the SPS stake of these individuals in the same orange color and their current HP in different colors.
Account Balances: HP Equivalent and SPS Staked
| Account | Final HP Equivalent | SPS Staked |
|---|---|---|
| azircon | $$1,128,124.58$ | $18,114,812.00$ |
| bravetofu | $$87,347.84$ | $63,654,356.41$ |
| seattlea | $$18,616.27$ | $569,199.11$ |
| beaker007 | $$7,506.49$ | $410,219.29$ |
| beelzael | $$5,265.74$ | $171,377.95$ |
| unitmaster | $$5,104.15$ | $216,889.69$ |
Whenever, we see and talk about a particular account, the table like above is what we see. This shows their current HP. Now in peakd and hivestats, there is a month or two you can go back and observe how their HP has grown. But I want more. I want see the whole history. That is where HAF helps.
In blue is the HP growth over time for my account. You can clearly see the 3 powerdowns I have done in the past. They are at progressively higher HPs, as hive keeps on giving!. Sep 2021 powerdown was to put Solar Panel on my roof. I wanted to show my wife that hive means something physical, and this money is just not a scam but can actually do something meaningful. In future hive survives or not (it will, I am full confidence), I will have the solar panel on my roof. Nov 2022 was the Riftwatcher sale in Splinterlands, I remember it well, I converted the powerdown hive to Splinterlands cards. Dec 2023 was the Hall of Legends promos, I remember going heavily into them with that powerdown. Even with those powerdown my HP kept on climbing and I am planning to buy some Hive soon. I am expecting VSC DEX will launch soon enough!
Also on note, that I didn't really believed in HDB for a very long time. Even today I have a tiny amount of HBD for the size of account that I have. I believe in it now, and will add to my position as the VSC DEX will get launched.
The Rest of them
All the sample accounts grown their SPS and staked growing their HP.
A bunch of them started in early 2022, while @beelzael is the latest adaptor, started posting in late 2024. But he is picking up rather quickly.
Based on their staking behavior in Hive Power (HP) and SPS (Splintershards), all six accounts demonstrate a fundamental long-term growth mindset, as staking these assets requires locking up capital (HP takes 13 weeks to power down; SPS has withdrawal/unstaking periods).
The differences lie in the scale, timing, and strategic focus of their commitment, which reveals three distinct growth philosophies.
The Strategic Dominators (High-Impact Stakers)
The Balanced & Consistent Builders (Methodical Stakers)
The Gradual and New Contributors (Developing Stakers)
| Investor Profile | Accounts | Key Mindset & Strategy |
|---|---|---|
| Strategic Dominators | azircon, bravetofu | - Highly Aggressive & Calculated: Deploys massive capital, often synchronized with market cycles (e.g., 2025 spike). - Dominance Focus: Aims to maximize influence/returns by holding dominant stakes in both core governance (HP) and DApp utility (SPS). |
| Balanced & Consistent Builders | seattlea, beaker007 | - Disciplined & Methodical: Follows a stable, long-term strategy of consistent reinvestment and linear capital growth since the earliest days (2021). - Ecosystem Balance: Shows sustained, equal commitment to the fundamental health of the Hive chain and the Splinterlands DApp. |
| Gradual and New Contributors | beelzael, unitmaster | - Developing Conviction: Growth is smaller-scale and often passive (rewards-driven) or shows a conviction that grew later (e.g., HP stake starting in 2023). - Lower Risk Exposure: Belief is present, but capital deployment is measured, cautious, or constrained, showing a willingness to participate without deep financial commitment. |
This is a small sample, and I have good knowledge of all these individual. I used their account as a test case. I need to increase the sample size to see, if more investor profile shows up, or if this subcategories collapses. Stay tuned.
I think there is a lot to learn from people's behavior and long term thinking from charts and plots reflecting their long term investment. Public hive wallet and publicly available historical data let us investigate and research that. It is critical to look at these and reflect. Imagine if we can do it, everyone can do it. Hive provides and will always provide, this is not my prediction, but my expectation.
PS: As I finished writing this post, beaker already delivered!
https://beebalanced.streamlit.app/balance_history_page
@beaker007
I saw your code. You might want to use
hafbe_bal.balance_history_by_dayandhafbe_bal.saving_history_by_dayto get the data faster. There is also _by_month for both of them.You can also contact me if you need anything.
Thank you for the post, even if all it did was draw attention to beaker's fantastic account history tool!
TVL (be it staked SPS, HP, other locked HE tokens - many of which have zero value) is an interesting metric that isn't spoken enough about in terms of our size as a chain. We're small, for sure, but we are pretty sticky.
Having a look at my own chart, I am in my "Recovery" phase, and I'm not stopping until Orca status.
The big drop in my HBD was paying off the mortgage at the old house. The big drop in HP was to get more SPL stuff at some point. The big "grow" happening at the moment is a result of setting 100% powerup on all my posts.
Drawing it to that tool was the intention of the post.
I figured out the need of the plot about 24 hrs back by discussing a few "problems". We quickly observed that no where at hive there is an user friendly tool that an average user can look up another user's behavior.
Data is public and nicely organized at HAF but was not available in a "consumable" format. Beaker and I made that happen in 12 hrs.
We did the same thing when I created KE ratio. Goal is always to show data and there behavior and etiquette to people.
HAF is great, and I have some ideas as to how I can use it to make some cool tools as well - eg, some of the word count / "trend" reporting could change into a web app if I sit down and think about it enough - which I will - once I get through my current to do list, which is already too long :D
This is a really awesome new tool from Beaker!
I was finally able to see my full journey on Hive!
And yes, it says I have been around since August 1, 2021 on my Hive profile, but that is when the Hive account was created for Splinterlands! Then it took until September of 2024 for me to get serious about Hive! So the story is growing from 1914 HP On August 2024 to almost 10x Hive of 18,824 HP today after reading Azircon's posts last year and starting to pay attention to Hive:
I guess I am doing something positive for the chain eh? :)
You are, not sure where you get all the bad rep :)
Bad rep comes for doing good:)
Just check your plot and then check plot for olaf.gui
Even a 10-yr old can tell, which blue line is going up and which one is going down. So if I point this out, obviously I am hurting the reward farming.
Now, who will argue with this plot? LOL.
One person is good for the hive economy, and the other person isn't. It is as simple as that.
I'm glad that your opinion on HBD has shifted. I think is one of the best things about the HIVE blockchain right now and has been for the past few years.
have you looked at your account growth?
No, not too much. I have a screenshot of my account value from back when the price was over $3 per token, but like you said, it was hard to track it until now. I know it has grown about 5x since then for sure.
That is the picture of your account since inception.
That's pretty crazy and impressive at the same time. It's cool how you can see the points I pulled some HBD out of savings to have some HIVE liquid in case the price happens to do something crazy again. If not I will eventually be making a fairly large power up one day!
Your last two posts have been fascinating. Thank you for selecting my account as one to highlight. I appreciate it.
Your description of me for "developing conviction" is spot-on accurate. I've put around $12,000 USD into the ecosystem gradually (measured and cautious) since joining Splinterlands.
You can see this spot on the chart where a lot of my conviction shifted from Splinterlands to Hive as I've shifted assets without bringing in any new money.
I have more to say and was going to write a long reply. I think it will make an interesting hive post, so I'm going to think more and write a post about my hive journey and developing conviction.
I see a recent power up, that is very good!
Thanks! I have another 5K swap.hive in my wallet. Waiting for a better conversion rate to HP before swapping. Usually I can get +0.4% when the demand is right.
Thanks again for including my account in this analysis. I've finally finished writing up my response and details about my hive journey and developing conviction. Just leaving the link here for future reference if I or anyone else circles back to this one day.
https://peakd.com/hive-126152/@unitmaster/developing-conviction-my-hive-journey-0-to-10k-hp
Super interesting post! With tons of changes in my life my Splinterlands activity has minimized so much BUT I save a weekly amount of time to stay active in Hive and keep my growth also! I saw an interesting plot that showed HP distributed by communities and we were sitting 7th / 8th... Let's hope we increase in overal HP also!
Here is your plot.
I am on rush to reach worker bee status before 2025!! Also all my HBD earned goes to savings! Thanks for the Hive coaching and push u are doing, Splinterlands experience makes much more sense!
@beaker007 is just the best :-) And yes, you describe me very well. I'm still trying to wrap my head around how everything works, and the more I learn, the more I like it. I'm not a jumping head first kind of guy anymore, especially with something as complex and new to me as Blockchains. If I decide to funnel more of my scarce resources into HIVE, it will be when I'm truly convinced. Until now, it looks like that is going to happen sooner or later.
With SPL, it's different. The money spent there is a lot more than the SPS stake, most what I have is in cards. I'm very convinced by now that it's going to be a long term success, but when it comes to decide between game-play and SPS investment, the game-play always wins 😅
This is you. Youngest of my samples :)
You're late, checking that out was the first thing I did after reading the post! Even played with the lines, took some out, compared others... as always, a neat little tool by Beaker :-)
Thanks @beelzael... always nice to see how much data is freely available 😁
Great tool! I'm all about the longterm growth:
looking good, very balanced!
I don't have that much HP but I've powered down several times in the past to solve minor financial problems, like when my smartphone developed a fault. I hope to increase my HP significantly in the future, maybe by buying hive and powering up. The HAF is sure a handy tool, might try it out.
With a KE =9.35, you are trouble!