Hey All,

Top Hive Users Strong Stake, Zero Power Downs.png

Hive Power down happens and it is upto to the user to keep their #hive account growing or at times do a power down and utliize thier funds as needed. In this blog post, I attempt to query the HiveSQL to search for Top20 HIVE users who have not done a single power down. And to remove the noise, what I have done is put some limitation where I am looking at users who have a Hive Power in the range 50K and 1 Million. Here is the running query and its output.

Top 20 Hive accounts holding 50K–1M HP, with no power-down history...

SELECT TOP 20
    a.name,
    ((a.vesting_shares - a.delegated_vesting_shares + a.received_vesting_shares) 
     * d.total_vesting_fund_hive / d.total_vesting_shares) AS hive_power
FROM Accounts a
CROSS JOIN DynamicGlobalProperties d
WHERE ((a.vesting_shares - a.delegated_vesting_shares + a.received_vesting_shares) 
       * d.total_vesting_fund_hive / d.total_vesting_shares) BETWEEN 50000 AND 1000000
  AND a.withdrawn = 0
  AND a.vesting_withdraw_rate = 0
ORDER BY hive_power DESC;

If I remove the limit of top20 and run the query then we get close to 230 users who have hive power in the range of 50K to 1 Million who has not done a single power down. I was curious to know my number as well as I had a faded memory that in past I have done a power down but was not sure how many times and to my surprise I have done it for six times in past 7 years or so not bad I would say. Here is the sanptshot of the query and its output.

I further wanted to check on some numbers for power down and hence refined the query to remove all the limits of Hive power and see what number of users we get who have not done a single power down. The result that I got was in 2.4 Million users but then this is not correct as this would include account which has not even done a single transaction on the chain. To remove such users I again had to put a limit of having atleast 10 HP and then I got this number 154K+ users and I still feel there could be still some account with no activity and finally I tweaked my query to also check for user actitivty like blog posting and commenting and finally here is the number of users users who have not done a single power down which is 89K+

This should be it for todays post on - " Top20 Hive users who have never done a Hive Power Down & Some Analysis....". Let me know what you guys think about the #HIVE Power down in general and the numbers that we have here. 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...

Top20 Hive users who have never done a Hive Power Down & Some Analysis...

Hive #hivepower #hivepowerinfluence #powerdown #hivepowerdown #blockchain #crypto #HiveSQL #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.

Recent Top 5 Hive Blockchain Data Query Blogs

Posted Using INLEO