My Account #HIVE Power Analysis - For Past 7 Years - What NeXt? Is 200K+ HP on CARDS...
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
https://img.leopedia.io/DQmS17XbMJM3Vt3SPotgBEUmQjLhxgZzjQRUgYZwRCATMKp/image.png
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
https://img.leopedia.io/DQmPADkNUQwLGTCPSCYw369APgQZULr33aauy7aWTfBBGSi/image.png
### Total Hive Powered Up Per Year Wise
https://img.leopedia.io/DQmbD9HVxTxBhUo6d4aADUhq8a9eHquz5JkCRS9z8gh6qbG/image.png
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
https://img.leopedia.io/DQmSKeWAijHc8H3mgM6K9Bw56DZYJSpdzxy8Ux4A24mboZn/image.png
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 200
[…]