Hey All,
I was exploring HiveSQL via DBeaver which helps me to connect to HiveSQL and from there I can trigger different Micosoft SQL queries to pull records. As I was playing around with the queries it struck to my mind how about pulling some records with regards to my hive account @gungunkrishu. What I wanted to see was #Hive and #HBD earned along with Hive Power Up done on a daily basis for this entire month July 2025. I wanted my query to include all rewards even if no #Hive was powered up that day, showing zero for those cases. It also orders the results by date wise such from ascending order i.e. from oldest to the newest. This is becuase one can easily see how rewards and POWER UPs changes has been made on a day by day and hence giving a clear picture on the hive account progress. Plus the motivation here was to play around with data and also organize/represent and analyze the data so that it helps me track my account progress in terms of earned rewards and how I am progressing with boosting my Hive power over time. Maybe at the end of every month, I will trigger this query making changes to the dates and see the real progress made month wise. Ok getting back to business here are the tables that I interacted with - VOAuthorRewards & VOTransferToVestingCompletds and here are the details of both the tables.
VOAuthorRewards
- Blockchain Virtual Operations
- author_reward
Description
This virtual operation is triggered after the payout period on posts and comments.
| Name | Description |
|---|---|
author | author of the post or comment |
permlink | permlink of the post or comment |
hbd_payout | HBD value of the reward |
hive_payout | HIVE value of the reward |
vesting_payout | HP value of the reward |
VOTransferToVestingCompletds
- Blockchain Virtual Operations
- transfer_to_vesting_completed
Description
This virtual operation is issued when a power-up is finally taken into account for governance votes.
| Name | Description |
|---|---|
from_account | account powering up HIVE |
to_account | account receiving VESTS |
hive_vested | amount of HIVE powered up |
hive_vested_symbol | HIVE |
vesting_shares_received | amount of VESTS received |
vesting_shares_received_symbol | VESTS |
And here is how each of those table has been used and a Join query made to get to the final combined results from both the tables.
Here is the HiveSQL working query to get 1 Months data for a user account as to how much HP and HBD has been earned and Hive Powered UP.
SELECT
A.permlink,
A.hbd_payout,
A.vesting_payout,
A.reward_date,
ISNULL(V.total_hive_powered_up, 0) AS hive_powered_up
FROM (
SELECT
permlink,
hbd_payout,
vesting_payout,
author,
CONVERT(DATE, timestamp) AS reward_date
FROM VOAuthorRewards
WHERE author = 'gungunkrishu'
AND timestamp >= '2025-07-01'
AND timestamp < '2025-08-01'
) A
LEFT JOIN (
SELECT
from_account,
CONVERT(DATE, timestamp) AS vesting_date,
SUM(hive_vested) AS total_hive_powered_up
FROM VOTransferToVestingCompleteds
WHERE from_account = 'gungunkrishu'
AND timestamp >= '2025-07-01'
AND timestamp < '2025-08-01'
GROUP BY from_account, CONVERT(DATE, timestamp)
) V
ON A.author = V.from_account
AND A.reward_date = V.vesting_date
ORDER BY A.reward_date ASC;
Query Output; trimming down to HBD_Payout, Vesting_payout, reward_date and Hive Powered UP...
| hbd_payout | vesting_payout | reward_date | hive_powered_up |
|---|---|---|---|
| 2.9810 | 24744.546227 | 2025-07-01 | 5078.237 |
| 3.1510 | 26160.639134 | 2025-07-02 | 43.831 |
| 3.0160 | 24790.983853 | 2025-07-03 | 35.756 |
| 4.3320 | 34083.555304 | 2025-07-04 | 58.512 |
| 0.0180 | 146.768964 | 2025-07-05 | 49.003 |
| 3.5460 | 27905.809541 | 2025-07-05 | 49.003 |
| 5.0810 | 40163.589510 | 2025-07-06 | 54.027 |
| 4.5830 | 36394.399789 | 2025-07-07 | 54.822 |
| 4.0430 | 32109.227011 | 2025-07-08 | 61.933 |
| 3.4160 | 26999.753588 | 2025-07-09 | 1148.229 |
| 4.0240 | 30914.269030 | 2025-07-10 | 35.538 |
| 4.1220 | 31376.907230 | 2025-07-11 | 57.687 |
| 0.0210 | 163.359855 | 2025-07-11 | 57.687 |
| 3.3720 | 25551.482638 | 2025-07-12 | 100.427 |
| 4.9530 | 36207.900186 | 2025-07-13 | 138.416 |
| 3.2390 | 22875.109507 | 2025-07-14 | 60.399 |
| 4.5120 | 31728.785737 | 2025-07-15 | 56.154 |
| 4.2290 | 29732.882977 | 2025-07-16 | 51.685 |
| 4.7080 | 32964.421157 | 2025-07-17 | 21.581 |
| 4.4000 | 30936.891014 | 2025-07-18 | 67.148 |
| 17.5930 | 122637.429551 | 2025-07-19 | 722.172 |
| 18.4630 | 127093.544731 | 2025-07-20 | 176.758 |
| 5.5340 | 37785.142905 | 2025-07-21 | 44.634 |
| 0.0130 | 91.600469 | 2025-07-22 | 132.197 |
| 12.2010 | 80641.218829 | 2025-07-22 | 132.197 |
| 5.0200 | 32789.921776 | 2025-07-23 | 75.122 |
| 0.0220 | 149.885307 | 2025-07-23 | 75.122 |
| 12.7260 | 82461.099683 | 2025-07-24 | 73.045 |
| 14.2740 | 94315.387973 | 2025-07-25 | 476.310 |
| 3.4720 | 23890.757934 | 2025-07-26 | 44.517 |
| 12.2200 | 85129.130025 | 2025-07-27 | 116.855 |
| 3.8630 | 26911.255949 | 2025-07-28 | 27.475 |
| 3.6750 | 25597.563544 | 2025-07-29 | 54.114 |
| 5.8220 | 40551.367956 | 2025-07-30 | 6.776 |
In all I would say a pretty good month for me with a huge Hive Power up on HPUD day with 5078+ HP powered up. You can clearly see consistency is Hive being powered up. All #hive earned is simply powered up and there are cases where you see hive powere up more than 200+ its where #HIVE was bought/swap with other crypto tokens for HIVE. Well this should be it for todays post on - "My Daily Hive Earnings Breakdown — July 2025 - Hive Power & HBD - ALL #HIVE Earnigs Powered UP..." Keeping building and powering up ALL you #HIVE earned... cheers
Have Your Say on Hive Rewards & #HIVE POWER - #HBD - HODL Vs SELL? HP GOAL?
Did you know what - "Delayed Voted" indicates? 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 Daily Hive Earnings Breakdown — July 2025 - Hive Power & HBD - ALL #HIVE Earnigs Powered UP...
#hbd #hivesql #swap #hive #hpud #hivepowerup #hodl #build #stakehive #crypto #hp #staking #goal #hodl #investment #hivepower
Best Regards
Paras
Image Courtesy:: pro canva license
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.