Hey All,

The learning continues as I explore Hive Blockchain data, leveraging DBeave to query HiveSQL uncovering trends, patterns, and insights that deepen my understanding of the network and at the same time play around with the data to plot some graphs using Python - matplotlib and pandas. In todays post we would be seeing three different queries which are::

• Hive Power Up Trend Yearly [Last 1 Year]
• Hive Power Up Trend Monthly And then finally
• Hive Power Up during HPUD days...

I queried the HiveSQL database and then got the output of all these three queries into a .csv file to plot grpahs. So here we go with the first query and its output followed by the graph.

Daily Power-up Trend (last 1 year)

SELECT 
    CONVERT(date, [timestamp]) AS Date,
    SUM(hive_vested) AS TotalPoweredUp
FROM VOTransferToVestingCompleteds
WHERE [timestamp] >= DATEADD(year, -1, GETDATE()) -- Hive Power Ups yearly  trend
GROUP BY CONVERT(date, [timestamp])
ORDER BY Date;

I am not inserting the above query output as it will fill up all the space of this blog post with 365 records. Have a look at the graph above -"hive_powerup_trend_yearly" showcasing the hive being powered up during each day for the year. There are some noticable days where we see hive power up more than 800K+ and some days above 500K+ and near around 400K+ as well. Up next is the seeing the Hive power up on a monthly basis.

Monthly Hive Power-up Trend (last 1 year)

SELECT 
    YEAR([timestamp]) AS Year,
    MONTH([timestamp]) AS Month,
    SUM(hive_vested) AS TotalPoweredUp
FROM VOTransferToVestingCompleteds
WHERE [timestamp] >= DATEADD(year, -1, GETDATE())
GROUP BY YEAR([timestamp]), MONTH([timestamp]) -- Hive Power Ups Monthly basis
ORDER BY Year, Month;

Here is the out of the query and the graph plotted using phython.

And now finally coming to the last part which is checking on the trend for #HIVE power up during the HPUD days.

PowerUps on first day of month, last 12 months

SELECT
  CONVERT(DATE, timestamp) AS Date,
  SUM(hive_vested) AS PoweredUp
FROM VOTransferToVestingCompleteds
WHERE timestamp >= DATEADD(MONTH, -12, GETUTCDATE())
  AND DAY(timestamp) = 1  -- Hive Power Ups HPUD only on the 1st of each month
GROUP BY CONVERT(DATE, timestamp)
ORDER BY Date;

Here is the query output and the grpah plotted.

Overall, it was a great learning experience to pull records, explore, and observe the Hive Power-Up Trends: Yearly, Monthly, & During Hive Power-Up Day. It’s always insightful to see how Hive Power fluctuates over time, and how community activity peaks during Power-Up Days. This analysis not only deepens understanding of the Hive network but also highlights patterns of engagement and growth. Do you agree? That’s all for today’s post on “Hive Power-Up Trends: Yearly, Monthly & During Hive Power-Up Day – Learn as You Explore..” I hope I was able to explain things clearly. If you have any follow-up questions or doubts, please feel free to share them in the comments below. Happy Learning with HiveSQL....Cheers...before I end here is the final image plotted showcasing the overall of all the three graphs above Yearly, monthly and first day of the month #hive power up.

Hive Power-Up Trends: Yearly, Monthly & During Hive Power-Up Day – Learn as You Explore...

Hive #Blockchain #Crypto #HiveSQL #PowerUpTrend #HiveCommunity #Web3 #Decentralization #HiveBlog

Best Regards Paras

Image Courtesy:: pro canva license, hiveblocks, DBeaver

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.