Last week I looked at what the top communities were on Hive and Leofinance were miles ahead of everyone with a whooping 25,575 subscribers in which 720 subscrbers were active over the last 7 days. The post is. here. My aul flower and soon to be a person of leisure @shanibeer asked me a question which I did not know the answer to. The question was , Out of the Leofinance active users could you check if the active users were old or new users. Good question. So after a few trials and errors on a python script I came to the conclusion that the Hive API would not suffice with this kind of info so I cranked up the Hive SQL for the first time. Paid 1 HBD to get a code sent to me and off I went with Cursor AI and vibe coded a script to do this job.
I have always liked Leofinance. I do not post regularly on it because I don't do many crypto posts and when I do I forget to use the Leofinance tag but I remember them when they set up and in fairness to them they have really went from strength to strength. They tried things that worked, they tried things that didn't work but the important thing is that they are trying which is more than I can say about the rest of the Hive Community. Let's take a look at their total subscribers first of all by year of when they subscribed to the Leo Community. This is from 2020.
Subscribers Sign Up By Year.
So Leo's peak signup was 2021 which was Covid year and it is an outlier obviously. You can see the bump in 2024 when they started to get funded by the DHF. Easy to measure metrics right here. They might not have hit their targets but I tell you one thing. I would prefer a measurable metric that half hit a target than an non-measurable target that we don't know the ROI.
Current Active Users Signup Year.
So below we see the 2013 active Leofinance users over the last 30 days. I found out that the 725 active users on the Community page screen on Peakd are those who created a transaction such as a comment or a post over the last 7 days so the 2013 is over the course of a month. Someone may correct me if I am wrong here. Point to note this is over a 30 day rolling month so if I cranked up the numbers today we would have a different set of results.
466 active users of Leofinance were onboarded in 2025 so this answers @shanibeer 's question hopefully. So around a quarter of their active users were onboarded this year. It is also good to see that Leo is retaining active users from the good or bad old days. Depends on how you want to think of it. Pretty even chart over the course of the few years which is positive.
Leo Community All Time Top Posters
Leofinance represents 17.8% of all Hive posts with 4,256,322 posts. The 3rd largest posting community on the blockchain. . Let's take a look at the top users who post on Leo. We have @leoglossary way out in front posting on @leofinance. Then we have @leothreads which is their container for their microblogging. @taskmaster4450 is in number 3 being a prominent Leofinance poster with @yann03 up ater him. I think going down through the list they have some strong Hive active posters embedded in their Community so it looks like a good base foundation right there. Hive rewards plus Leo rewards. It's a shrewd move. Rewards from both Communities. I should be doing it more. Just in case you are wondering. @khaleelkazi is coming in at 31st place which is not too shabby as the founder. He posts regularly but doesn't take the piss either.
Leo Community Top Active Posters (30 days Rolling)
@yann03 and @daniasi are the top two most active this month on Leo but we have some consistant posting among the top 20 here ranging from 24 mosts to 57 posts. Nobody going too wild which is the sign of a well regulated community.
These two charts were a pain in the arse to put together and I am still looking at how best to use the Hive SQL. For example I was wondering why @khaleelkazi wasn't anywhere near the top 50 in posts . It was because he wasn't using the word "leofinance" in his recent tags. Only "Leo". In order to get an adequate data set I needed to include both the Leo and Leofinance tags and the Community tag which is #hive-167922. Sometimes that was in the tags and leo wasn't and sometimes leo was in and the tag wasn't. It was all a good learning experience. But in order to adequately get a sense for the users who post in the community I included the Leo , Leofinance and the Hive-167922 tag.
One thing I did not that the total subscriber count in the Hive API , in Hive SQL and on the front of the Community page are all different numbers.
API: 26,091 subscribers
HiveSQL: 26,128 subscribers
Community page: 25,025 subscribers
There is difference of around 1066 in the total subscribers. Would anyone know why this is? Are the users muted or show no transactions? I am not sure why but the difference between the Community page and the API, SQL is quite big. We used the dataset between 2020 and present which added up to 21,573. This was half way between the two so we went with this one for the total in the charts. Any the whole post will give you some indication around the numbers per year.
Leofinance is an important part of the Hive blockchain and we may be best to remember they are growing and getting larger and larger. I hope they do well transacting on more chains as every boat rises with the tide and they are onboarding daily. Their latest signup was yesterday
@edelvyslizano and they signed up 4 yesterday in total. Leofinance is becoming a success story just like Splinterland's did. Supporting them would be the wise move here.
Your charts are pretty.
Charts.js all the way
I am too lazy for that stuff. I just use those silly corpo-programs I know. Had a very anti-FOSS workplace and never learned the other ways. Now that I am poor and destitute, I too can unlock the secrets of
git pullandgit cloneandwhile poor weep()ahahaha
while poor weep()that hits me so close to the chest.I have only used Linux and FOSS stuff since the mid 90s, because poor.
I do love my git in fairness. Nothing bugs me more when the website breaks and I have to do a hard reset and the last time I pushed was 3 days ago so now I'm a push fiend.
Great stats. Don't really tell the whole story though. Admittedly, along with the value plan gang, they are Hives top grifters.
Leo glossary, Hives own Wikipedia spam on the Blockchain. Probably the dumbest idea they came up with.
Leo are a crap community. Think they suck and are scammers. Cub, Leo, and their latest LeoStrategy.. LOL.. they give Saul Goodman a run for his money with schemes.
Sitting on the fence as usual I see. Tell us what you really think. 🤣🤣🤣 .Jeez I wasn’t aware some of this stuff . I saw leoglossary had a heap of posts alright but didn’t really know what it was . I shall take note my friend because it’s you and not a thin foil helmet.
I'm slightly paranoid 😆😅
😂 well the one in the picture was 100% right so maybe you are too. The post rewards tell me everything anyway 🤣
I used to post in there quite a bit, but the whole CUB thing really turned me off and then their front end started being down more than it was up and I decided to just kind of cut ties. I doubt they miss me that much!
Yes I remember the CUB airdrop and got lost a few hive myself but what it did teach me is bridging between two blockchains and how to do it. This helped me down the line so I found the hassle of staking my CUB in pools all worth it in the end. I think everyone got caught up in the CUB excitement. But I maybe did not have much skin in the game unlike you. But I would say they miss you as you are a regular poster. Why not start posting to pay breakeven on your Leo debt and then call it all square once you reach your losses. 😄
I don't think you can earn LEO from posting anymore after the flipped the inflation. At least that was the way I read it. I have sold off most of my LEO now.
Thank you for this and the mention.
Looking at 2024, it looks like:
The start of some KPIs we can use to evaluate value-plan activities?
Can’t argue with that maths.
You've probably seen this new proposal for Hive Analytics.
In there are a couple of features that look at another side active communities, which is how much HP their subscribers hold. Actually, it's slightly different to that - it's how much HP is held by accounts created through a particular source.
I did not @shanibeer . I was not aware of any Leo drama until I looked at the post rewards. 🤣
I'm glad to see that hive hasn't stagnated completely.
There's hope for us yet Michael. All Hive needs is one spark
Hate em or love em...
They are making moves y'know
Exactly @seki1 exactly