Hey All,
Now that I have some understanding to query HiveSQL data, I thouhgt this time it would be good to explore how I have been building my #HIVE Power for these last 7 Years or so. The above image reflects a dashboard style snapshot of four graphs that I generated separately to give me a clearer picture of my overall growth trend, monthly consistency, and yearly accumulation. Lets get into the business here and at first here is the working #hivesql query that gets me month wise Hive Powered up along with Year to date cumulative Hive power being added up. Have a look at the following image image from DBeaver App and the output of the query...
Monthly wise Hive Power + Year to date cumulative (grows each month)
WITH hp_activity AS (
SELECT
DATEPART(year, timestamp) AS yr,
DATEPART(month, timestamp) AS mo,
CONVERT(CHAR(7), timestamp, 120) AS year_month,
SUM(CAST(hive_vested AS DECIMAL(18,6))) AS hive_powered_up
FROM dbo.VOTransferToVestingCompleteds
WHERE from_account = 'gungunkrishu'
AND timestamp >= DATEADD(YEAR, -7, GETDATE())
GROUP BY DATEPART(year, timestamp), DATEPART(month, timestamp), CONVERT(CHAR(7), timestamp, 120)
)
SELECT
year_month,
hive_powered_up,
SUM(hive_powered_up) OVER (PARTITION BY yr ORDER BY mo
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
AS yearly_ytd_powered_up
FROM hp_activity
ORDER BY yr, mo;
Next I refined the query to get me a fresh look at my Hive Power growth Year wise and here is what I got. My Hive Power Powered up Yearly Total.
2024 and 2025 are exceptional we can see it clearly with 25K+ in 2024 and 43K+ HP in 2025 and we still have 3 months before this year ends. I think I will end this year with atleast 70K+ HP being powered up. Lest now dive into the four different graphs that were plotted using Python.
Monthly Hive Powered Up for account @gungunkrishu
Started with very small amounts of Hive Powere up during the early days, 2021 (~100–200 HIVE) and then gradually increased, with some spikes. The biggest monthly spikes occurred in:
Aug 2024: 13K+ HIVE
Sep 2025: 21K+ HIVE
Oct 2025: 43K+ HIVE [not shown in this graph though]
Year to Date Cumulative Hive Powere Up
Total Hive Powered Up Per Year Wise
This graph is my favourite the spike in 2025 is clearly visible around 43K+ HP and I am sure I can hit 70K+ HP but then lets see where I land at the end of this year,2025.
Monthly Hive Powere Up Growth Percentage
Ovearll I am happy to deep dive and see how I made progress building my Hive Power stake. I can clearly see where I used to stand in early days and what my account activity was with respect to #hive being powere up. And as I moved, became more consistent and started to understand Hive more better, I releiazed that I need to build my stake at this early stage and hence one can easily see my foscus around build and setting goals around Hive Power. As an example first I was targeting a 150K+ HP goal by the end of this year but accomplishing this goal much earlier I reset it to 175K+ HP at the moment and at the moment seeing the prgoress I see even 200K+ HP is also possible. But lets see how things pan out in near future and then I would decided if I should be taking this strech goal of 200K+ HP by the end of this year,2025 or not. Ok this should be it for todays post on - "My Account #HIVE Power Analysis - For Past 7 Years - What NeXt?" Hopefully things would move in the right direction and I am optimistic that I will take good advantage of opportunities ahead that would ultimately benefit me to further build my #hive stake with more HIVE POWER at my dispersal... #hive to the moon soooon.... Happy powering up #HIVE... and Happy Investing... cheers
Have Your Say on #HIVE POWER - #HBD - HODL Vs SELL?
Selling Vs HOLD #HIVE? Are you building your stake here on the HIVE platform? What are your thoughts in general for HIVE Power and HBD in savings? Are you stacking up HBD or converting HBD to HIVE? What's your overall strategy for HBD looking like? What are your general thought around the platform #HIVE? Please let me know in the comment section below...
My Account #HIVE Power Analysis - For Past 7 Years - What NeXt? Is 200K+ HP on CARDS...
#hivepower #hive #hpud #hivepowerup #hodl #build #stakehive #crypto #hp #staking #goal #hodl #investment
Best Regards
Image Courtesy:: self generated using Phython script
PS:- None of the above is a FINANCIAL Advice. Please DYOR; Do your own research. I've have an interest in BlockChain & Cryptos and have been investing in many emerging projects...
Posted Using INLEO
Wow, reaching that amount of HP has been amazing. I'm also accumulating Hive, but little by little, I don't have much right now, so I'm working on bringing resources to Hive, like my healing account and my witness node. First, saving in Hive is my goal. Then, I think I'll start on HBD. Someday I hope to reach those numbers! Congratulations!
I invite you to learn about my Witness and Healing Node project and support it if you consider it of great value to the Hive network:
https://peakd.com/hive-177682/@kozgamer/what-is-kozgamer-and-how-does-it-work-for-hive-espeng
Consider voting for me as a witness:
https://vote.hive.uno/@kozgamer
thank you. Yes you are in the right direction.. A step by step approach will indeed help building a good #hive power stake. good luck to you well. With regards to hive witness, I will have a look. cheers
Awesome growth. 2024 and 2025 YTD have been a stacking milestone! Inspiriring path.
thank you and Year 2024 & 2025 is where I have done huge power up.. the goal here is to get to 200K+ HP by end of this year, 2025. Let see how far I can get. cheers
With that pace you will definetely make it. 🤝🏻
thanks bhai
This post has been manually curated by @bhattg from Indiaunited community. Join us on our Discord Server.
Do you know that you can earn a passive income by delegating to @indiaunited. We share more than 100 % of the curation rewards with the delegators in the form of IUC tokens. HP delegators and IUC token holders also get upto 20% additional vote weight.
Here are some handy links for delegations: 100HP, 250HP, 500HP, 1000HP.
100% of the rewards from this comment goes to the curator for their manual curation efforts. Please encourage the curator @bhattg by upvoting this comment and support the community by voting the posts made by @indiaunited.
Congratulations @gungunkrishu! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s)
Your next target is to reach 12000 replies.
You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPCongratulations! Keep at it!
thank you. Appreciate it. cheers