Hive Power UP & DOWN - Data for 2 Years Month Wise - Trying to See Some Patterns... Hive Power Up OR DOWN?

Hey All,

I have been using DBeaver for querying HiveSQL database and this is not the first time that I am doing some analysis on the #HVIE data but rather have done several deep dives in the past to understand power-ups, delegation trends, and account activity patterns. Also to be honest, I am no expert but what I am doing is trying out things as I learn and getting to this point is a real achievement for me. As an example this was one of its kind - HiveSQL - Querying to find out HIVE Coming IN [Users] & Going OUT [Exchanges]. In this blog post we are going to look at the numbers for Hive Power Ups & Downs made in last 2 years month wise.

Hive Power UP Month wise (July 2023 – July 2025) two year graph

The above graph indicates July 2024, August 2024, September 2024, and June 2025 show notably higher values compared to most other months. We can say that these are the peak months for Hive Power UP. And whereas December 2024 stands out as the lowest, with an immediate recovery in early 2025. Ok now here is the running query that I triggered via the DBeaver to get the data from HIVESQL.

-- Query Hive Power UP 2 Years Data

SELECT 
  CAST(YEAR(timestamp) AS VARCHAR) + '-' + 
  RIGHT('0' + CAST(MONTH(timestamp) AS VARCHAR), 2) AS Month,
  SUM(amount) / 1000000.0 AS Hive_Powered_Up_Millions
FROM TxTransfers WITH (NOLOCK)
WHERE 
  type = 'transfer_to_vesting'
  AND amount_symbol = 'HIVE'
  AND timestamp >= DATEADD(DAY, -730, GETUTCDATE())  -- last 2 years
GROUP BY 
  YEAR(timestamp), MONTH(timestamp)
ORDER BY 
  YEAR(timestamp), MONTH(timestamp);

Hive Power DOWN Month wise (July 2023 – July 2025) two year graph

What I can interpret from the data here on the HIVE POWER DOWN is that during the start of the Year there is a lot of users doing the Power down and the same is reflected in the month of January, February, March and April 2024. The figures fell from the high in March 2024 down to 9.75 million by September 2024. There again was a secondary spike that occurred in December 2024, when the value rose to 80.39 million before declining again into 2025. Ok now here is the running query that I triggered via the DBeaver to get the data from HIVESQL.

-- Query Hive Power Down 2 Years Data

SELECT 
  CAST(YEAR(timestamp) AS VARCHAR) + '-' + 
  RIGHT('0' + CAST(MONTH(timestamp) AS VARCHAR), 2) AS Month,
  SUM(deposited) / 1000000.0 AS Hive_Powered_Down_Millions
FROM VOFillVestingWithdraws WITH (NOLOCK)
WHERE 
  timestamp >= DATEADD(DAY, -730, GETUTCDATE())  -- last 2 years
GROUP BY 
  YEAR(timestamp), MONTH(timestamp)
ORDER BY 
  YEAR(timestamp), MONTH(timestamp);

Altogether in during the end of the Year there is less Hive Power and more Hive power down and this is clearly visible from the above two bar charts. So this could be either people are either cashing out their holdings i.e. booking profits, rebalancing their investments, or reacting to market trends such as price fluctuations or community sentiment. This highlights a possible shift in user behavior, with reduced confidence or increased liquidity needs during these time frames during the end of the year period. Ok this should be it for todays post on - "Hive Power UP & DOWN - Data for 2 Years Month Wise - Trying to See Some Patterns... Hive Power Up OR DOWN?" Let me know your views on the same... Are you planning to do a #HIVE Power Up OR Down - let me know in the comment section below... 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...

Hive Power - Moving Forward to 150K+ HP - 117K+ HP Achieved... What Next?

#swap #hive #hpud #hivepowerup #hodl #build #stakehive #crypto #hp #staking #goal #hodl #investment #hivepowerdown

Best Regards
Paras

Image Courtesy:: chatgpt, pro canva

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