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.