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/
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 @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.
