Hey there, and welcome to the Bee Balanced blog! In this post, I want to dive deeper into what this tool does and how you can use it to get insights into your Hive activity. Whether you're just curious about your own standing, looking at trends in the community, or trying to make more informed curation decisions, this tool has something for you.
Jump right to the tool: https://beebalanced.streamlit.app/
Lately, I've seen a lot of discussions—at least in my Hive bubble—about Hive ethics and the so-called extractors in the ecosystem. How people behave in Hive, whether they contribute meaningfully or just extract value, has been a hot topic.
Reading through these discussions, I realized that I wanted to check where I stand. I know my own actions and intentions, but how are they perceived by the community? Can I measure this objectively?
Many of these conversations focus on groups and trends, so I decided to build a tool that lets anyone check their own stats. Inspired by posts from 
Let’s break it down. Who might find this tool useful?
If you’re active on Hive, this tool can help you check your KE ratio—whether it’s "good, bad, or ugly." Of course, the KE ratio isn’t everything, so I highly recommend reading some of the great posts about its meaning and limitations.
New Splinterlands Contest Rules & KE Indicator: What It Is & How to Improve It (ENG/ITA)
Splinterlands Contest Posts and Curation - part 1
Splinterlands Contest Posts and Curation - part 2
KE ratio as a guide
A Sad Realization About Splinterlands & Hive
Leeching Arseholes
Understanding your ke ratio and why it is important
Many Hive communities host contests where they curate posts and reward participants with generous upvotes. The goal is usually to encourage engagement, visibility, and community growth—not just to hand out easy rewards.
This tool can help curators make better decisions by showing a user’s Hive ethics at a glance. You can:
Even if you're just a regular voter, you might find it useful to check where your support is going.
Since I’m mostly active in the Splinterlands community, I also added detailed insights into SPL asset holdings. Weekly SPL contest posts made me realize how useful this could be.
With this tool, you can:
Spot missing data—if something isn’t showing up, let me know, and I’ll see if it can be added!
If you're someone who just loves data and visualizations, this tool offers plenty of ways to query and graph Hive + Hive Engine balances. Whether you're looking at personal stats or community-wide trends, there are endless possibilities.
A quick disclaimer: This is a side project I built in my free time. There might be bugs or missing features, and I’d love your feedback!
I’ll walk you through how the tool works and what you can do with it. Stay tuned!
This is the core feature of the tool! Simply enter one or multiple Hive accounts you want to analyze, and you'll get various insights about their activity and assets.
These numbers help assess a player's level of investment in the game.
All data that is being collected can be stored into a csv so you can track it on you own in a excel.
Note: Be-aware when you do this the next time the columns can change make sure you watch that before combining it into you own excel.
This page is pretty straightforward! Just enter one or multiple permalinks (these are the unique links to Hive posts or comments), and the tool will generate a list of unique commenters from that post.
This feature is especially useful if you're hosting a contest and need to scan for all participants who left a comment on your post.
For example, here’s how it works with Splinterlands’ Social Media Challenge—you can quickly see who engaged with the post without manually checking every comment.
This page provides a visual breakdown of the rich list for SPSP holders or the top 100 Hive users who have earned the most posting rewards (author rewards)—with a minimum of 500 HP.
For these users, the tool generates several graphs, each with a detailed explanation of what the data represents.
Here are some examples of what you can explore:
Every chart has a explanation on what you see:
You need to be authorize to do some advance queries. These are resource-intensive and puts extra load on the Splinterlands API.
This query:
Retrieves all accounts that have been active in the last 6 months (at least 10 comments).
This results in a list of around 8,000 accounts, which can put a strain on the SPL API and might block the page for other users.
Because of this, the feature is restricted to prevent overloading the SPL API.
However, since this is an open-source project, if you really want to run this query, you can check out the code and do it yourself. Feel free to tweak it based on your needs!
Now we’re getting to my favorite part—custom queries! 🎉
This feature is still in development, and there are a lot of dependencies between options and fields, so no guarantees that everything works perfectly yet (consider this your friendly disclaimer!).
On this page, you can define your own query and visualize the results:
Once you're happy with your base query, you can layer in more data:
✅ Hive Engine Tokens – The default token set we discussed earlier.
✅ Splinterlands (SPL) Data – Additional details on SPL assets.
If you're not authorized, you can still run queries, but with a limit of 100 accounts to fetch SPL data.
Authorized users can unlock more advanced queries, but again, to prevent excessive API calls, some restrictions apply.
And that’s it! BeeBalanced has been live for a little while now, and I hope you all enjoy using the tool and find it beneficial for the Hive community.
I want to emphasize that this tool was never meant to single out individuals or label anyone as a "bad actor." Instead, my goal was to look at the data objectively—to hold up a mirror for myself and others, reflecting how we engage on the blockchain.
At the end of the day, Hive is built on public data, but it’s up to each person to interpret that data and make their own decisions based on it.
For me, this project has been an eye-opener. Even though I already knew I wasn’t an extractor, it still inspired me to improve my own behavior—to be more mindful of how I contribute to Hive’s long-term sustainability.
I hope it does the same for you. 🚀
Stay balanced, stay engaged, and let’s keep building a better Hive ecosystem together!
Bee Balanced
