Hive Power Influence Witness & Proposal Voters Analysis...

0 comments

gungunkrishu5 months ago5 min read

Hey All,

Hive Power Influence Witness & Proposal Voters Analysis .png

This post is in continuation to my last post which was around -

. I got the feedback to do some kind of analysis on the users leveraging their #HIVE Power aka HP on voting for witnesses and DHF [Decentralized HIVE Fund] proposals. So here I am with some analyis and the point to note here before I get started is that I have taken into account only those users who have an HP of 10K ore more. This is just for the sake of maintaining a meaningful benchmark, as accounts with significantly lower HP might distort the results or not reflect the same level of influence on the platform. By filtering in this manner, the data gives some meanignful insight to users who are serious stakeholders who are actually driving engagement, curation, and growth. With that without a further ado; let me start with sharing the working query where I pulled the records based on

total_hp_accounts - Number of users with HP > 10k
witness_voters - Number of those users who vote for at least one witness
pct_witness_voters - percentage of HP > 10k accounts voting for witnesses

Working query to get users with 10K+ HP voting witness

WITH dg AS (
    SELECT 
        total_vesting_fund_hive,
        total_vesting_shares,
        hive_per_vest
    FROM DynamicGlobalProperties
),
hp_accounts AS (
    SELECT 
        a.name,
        CAST((a.vesting_shares + a.received_vesting_shares - a.delegated_vesting_shares) * dg.hive_per_vest AS FLOAT) AS hp,
        a.witness_votes
    FROM Accounts a
    CROSS JOIN dg
)
SELECT
    COUNT(*) AS total_hp_accounts,
    SUM(CASE WHEN a.witness_votes IS NOT NULL AND LEN(a.witness_votes) > 2 THEN 1 ELSE 0 END) AS witness_voters,
    ROUND(100.0 * SUM(CASE WHEN a.witness_votes IS NOT NULL AND LEN(a.witness_votes) > 2 THEN 1 ELSE 0 END) / COUNT(*), 2) AS pct_witness_voters
FROM hp_accounts a
WHERE hp > 10000;

Ok I didnt stop here and went on to refine the query to pull data for proposal voting as well. query to retrieve data where users have 10K HP > voting for wintess and proposal, get the count and pecentages.

Total HP > 10K accounts
Witness voters (count and percentage %)
Proposal voters (count and percentage %)

Along with that I refined the query to get me the governance participation stats showcasing users in the followng #Hive Power ranges.

10K–50K HP
50K–100K HP
100K–500K HP
500K+ HP

All of this will make sense when different graphs are plotted, as visual representation will show patterns, trends, and outliers to stand out clearly. It would be much easier to interpret the numbers, compare different user groups, and make sense out of the raw data once they are displayed in charts. Ok my Phython skills were used here to plot the graphs leveraging matplotlib library. Helping me to transform the raw dataset into meaningful visualizations. So here we go...

The above graphs clearly show how users with different HP range are voting for witness and DFH proposals. The percentage numbers varies higher the HP lower is the percentage and that is obvious for some reasons because we will have less number of users having having in that range lets say above 500K+ HP. I guess I will leave it here for you all to see and grasp this information. The graphs and insights are self-explanatory, and I believe they provide enough clarity for everyone to interpret and draw their own takeaways. This should be it for todays post on - " Hive Power Influence Witness & Proposal Voters Analysis...". Let me know what you guys were able to spot on these trend analysis hive power influence on Witness & Proposals. 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...

Hive Power Influence Witness & Proposal Voters Analysis...

#Hive #hivepower #hivepowerinfluence #witness #voters #blockchain #crypto #HiveSQL #witnessvoters #proposalvoters #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.