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 
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...