Announcing Top 600 Curator Analytics

Introduction

Introducing the latest addition to my growing suite of Hive Tools: the new Top 600 Curator Analytics. This tool is the first of it's kind and a completely new Analytics solution that is high performance as well as not relying on Hive API servers. I intent to bring real transparency to the fingertips of every Hive user not just developers. If you like what you see, please upvote this post and vote for my Hive Witness node

How Is This Analytics Tool Different?

This tool is different from anything that I wrote before on Hive, because it uses HAF SQL database to run SQL queries to produce source data for these reports.

The big deal here is twofold:

Reports are extremely high performing even faster than what @themarkymark had for his Hive Analytics 2026 DHF proposal
Reports do not burden Hive API servers

How Is This Accomplished?

The way I was able to provide super high performance reports without relying on Hive API servers was by creating a custom direct HAF Database to Azure Pipeline. This pipeline runs on my Hive node every four hours running a SQL query against the HAF database then exports the results into a curation-data.json file which is uploaded automatically into the Azure cloud Blob.

The custom PowerShell Pipeline also updates the timestamp on the HTML file for the top 600 curators dashboard to let user know when the data was last updated. This file is then also uploaded into Azure. I have also built in a manual trigger option so that the data and report can be updated on demand.

Future Plans

Now that the process and automated Pipeline is in place, I intend to build out this tool to include many more Hive Analytics tools to give Hive users a real transparent view on everything on Hive blockchain. It is time for everyone to have access to this data and not just us the developers who can run SQL queries against the HAF databases... I am sure data-driven users like @azircon are going to appreciate this.

Analyzing Top 600 Curators by HP Earned in the Last Seven Days

So with technical details out of the way, let's get into the new report itself. What does this tool let's you see that is not available anywhere else that I know of?

Well the most most crucial data here is the ability to see a full sortable table of the top 600 curators on Hive and their data such as their Total Hive Power, APR% that they have earned, how much HP they have earned as well as how many times they have voted.

You can sort on any field in this table except the Rank. By default the table is sorted by total Vests or HP earned so clicking on one of those headers accomplishes the same as sorting on Rank.

You can also search on curator name such as @tarazkp and see their HP earned via curation and APR as well as how many times they hit Vote button in the last seven days which in case of tarazkp is 169 times.

I can easily extend this to have top 1000 or more curators by HP earned, as you can see our top curator @blocktrades earned 19,631 HP in the last seven days and achieved 8.56% APR, however his APR earnings are not as high as other curators in the top 600 and that is where the following chart comes in:

These are the most efficient curators sorted by HP earned that earned a very high APR of 9.25% to 17%. There are some curators in top 600 that earned higher APR, but I believe that is a function of power down or delegation. Simple example is: you had 10,000 HP then delegated 9,999 exactly 7 days ago, now your effective HP is 1 and you have earned based on 10,000 HP for the 14 to 7 day period. So when the system is calculating your APR you get sky high APR because it is based on 10K HP and not 1HP you have now.

Go ahead and mouse over the green bars. And you will see that @smooth our number one most efficient whale has earned 11,973 HP in the last week and achieved 9.34% APR. Number three on the list @acidyo has earned 2059 HP in the last week and has achieved even higher APR of 9.9%

The most efficient curator in the top ten on this list is @cur8 with 301HP earned and 10.42% APR. The undisputed champion in this chart is @cwow2 with 96 HP earned and at 16.14% APR!

Another interesting chart is the APR% distribution among our top 600 curators. As you can see clearly from the chart above the most common APR is 8% and most curators fall in between 1% and 10% with a few outliers.

I also feel that this above picture tells a story as well. 570 of the top 600 curators on Hive have less than one million power. 25 curators have between One and Five Million Hive Power, two have between 5 and 10 million and three have over ten million Hive Power. If we exclude the small fish under a million here are the big curators of Hive the big top 30 who vote:

There are other charts available as well so take a look at the new tool and let me know what you think and what you would like to add to this report. I am also going to create other reports if this proves popular.

I am a Hive Witness and would really appreciate your vote for me as a witness: https://vote.hive.uno/@seattlea

If you prefer your Hive Witnesses to never power down I am one of those Hive Witnesses. I believe that unless you are a top 20 witness and running more than just a Hive Witness node then you don't need to power down.