I used HiveSQL to grab a list of all weekly active users, per week, since 2016 until February 1, 2026.
I made this in response to "Are we losing active users?" by Acidyo. The answer is yes, but only because the price is going down I imagine. As far as I can see, This January was one of the lowest weekly active user counts we've gotten, along with a few other Januaries. There are around 2 lower times. For some reason at the end of the year, or start of the year, there tends to be a very low week with around 3.1-3.4k WAU.
You can either check the raw data the data or play with the chart at https://hive-stats-sable.vercel.app/
About the project
I had to pay HiveSQL a little bit. Turns out it's a premium service? It's either 5 HBD per day or 50 per month. Lotsa moni.
Here's the query that fills in the whole dataset per year. The original one was pretty poorly optimized, took me like one hour to fill the 2016-2026 sqlite.
https://github.com/CryptoSharon/hive-stats/blob/master/fetch-hive-stats.ts
Here's what the SQLite loooks like. It's pretty neat. I found out that Steem was first deployed around April in 2016. 3 active users the whole of that first week! 91 WAU by the last week of April, with 152 posts and 133 comments.
The chart is made using recharts. It looks very cool, but it's very hard to deal with it. Thankfully we have AI agents to do the heavylifting, but some options on the site are still meh.
You're welcome to play with the charts on the url (at the start of the post), to change the code as you wish, and ultimately if you want to make a change and a Pull Request, or just change it for yourself, the code and site are yours to do as you wish!
If you want to learn HiveSQL, I found this cool guide as well https://peakd.com/hive-133987/@beaker007/getting-started-with-hivesql-crawling-hive-blockchain-data-with-python
The docs are here as well https://docs.hivesql.io/
And you can use the code samples from the repo.
Interesting this information that you present I have to review more calmly. Thanks for the data And the links
Lo más útil ahí es simplemente abrir la gráfica y poner el mouse en varias semanas y ver los números que salen. No toma mucho tiempo. Pero creo que en computadora es mejor. La verdad es que no lo probé en teléfono.
Edit: lo probé en el cel y no va muy bien.
Thanks, I'll try it on my computer. The information is interesting. I'd been looking for it for a while and didn't know where to find it. Thanks.
Excellent data, and the chart makes it clear. This is the most responsive reply to Acid's post, and it should draw far greater engagement here, and there, than it is. However, there are reasons that Hive is not growing, and the price of Hive is a symptom of that, not a cause. Hive management is quite aware of the issue, and is the cause of the problem: centralization of stake. A bare majority of stake has existed in ~36 accounts since the advent of the platform in 2016, and that oligarchy has maintained that majority of stake ever since. Having a majority of stake enabled unitary control of governance by controlling the consensus witnesses, whom in turn run the code that enables that oligarchy to capture 99% of rewards, maintaining their bare majority of stake and the virtually exclusive power to profit from Hive. Decentralization threatens their control, so new users must be ejected from the platform, which is revealed in your chart in 2018. I'm surprised Acid posted about it. Perhaps the post is bait to find people like me...
You can see that in 2017 many new accounts onboarded, and most of them were gone by the end of 2018. This is a result of stakeholders that control Hive by virtue of their majority of stake and thereby manage the platform in order to capture almost all the inflation issuing from the rewards pool. Content creators today capture ~10% of rewards, and Whales capture ~99% of rewards. Two looming issues present existential problems present Hive management cannot resolve. One, they are faced with AI basically taking over all Hive rewards. However the oligarchy is provided a stream of free accounts based on the weight of their stake, and I know at least one consensus witness had >10k accounts years ago, so it's likely that the oligarchy has hundreds of thousands of idle accounts they can power up at any time to use AI to extract rewards from the pool. They can essentially turn Hive into a bot farm that preys on new onboards for income. Two, KYC internet will eliminate free speech, on Hive just as it will everywhere else. They could resist that by decentralizing stake and enabling the platform to be resilient to attacks from any one jurisdiction, but as the world is actually ruled by a covert group behind all governments that can impose policies on all governments at once, which we observed during 2021 as all governments adopted identical and completely unreasonable masking, early treatment bans, and jab policies, and as we are observing today with the simultaneous rollout of KYC internet and biometric ID globally. A coordinated international policy can overcome decentralization, and the Hive oligarchy has no means of preventing that. More importantly, they will only lose money attempting to prevent it, so they will simply let Hive die and move on when KYC eliminates the market for Hive.
Thanks!
Yup that's a lot of moni 😂 thanks for the data appreciate it