Few days back, I did a query for all hive account to find 'active' users. We can debate about what 'active' users mean, but I wanted to be generous, and used this criteria.
Accounts with author rewards > 500 HP
Accounts with comments > 10
Accounts which made those comments/or posts in last 6 months
I covered the results on this post. The query returned 4349 accounts which I plotted. I think this could be about 50% of hive accounts that 'matters' somewhat.
I would say 10 comments is a very generous bar (its curious that you also used 10). Using your analysis we get:
1112/13614 -> 8%; or 92% of the new accounts are essentially ZIP!
Why in our right mind we want to support such a project! This is in fact far worse that I thought. Reality often is that way!
I chose 10 based on the one year time frame as I felt that was the least (despite fairly insignificant) amount I’d consider someone is even remotely active.
Agree, any 'normal' human user who is even remotely interested in social interaction will likely be doing way more than 10 comments, perhaps even try a post or two. Especially there is a hope of earning here. We have a lot of experience observing this behavior for 8 years.
When you consider they have this going for more than a year now, I wonder if this is total sham! Nomad talks about time, and say no one comes in and becomes an investor on day one. True. But they typically interact. Given enough time, I'd say 1 year is lot of time, there should be thousands of accounts that have more than a month or two time, and if they are making less than 10 comments so far, I highly doubt they are human at all.
I don’t believe it is a total sham but the numbers are bullshit and the value isn’t even remotely there.
Agree, they are just clueless on how content based social media works, which is a shame as they are here long enough.
I forgot the new haf the table is moved out to balances out of accounts, so I was looking at rewards. Instead of 1300 HP, it should be this for all users onboarded in the last 12 months.
Top users being:
wait... 11 users in 12 months?
you like practical jokes a lot, so are you serious?
The top is the sum of all.
Below is top users that were onboarding in the last 12 months based on their HP (> 500 HP)
I don't joke around about data.
Okay, so HP is higher, but I never paid attention to that bit.
Is this bit still the same?
PS. but it is only 11 users that hold more than 500 HP. We can call them 'effective contributor' or whatever fancy word we like to use.
all the user counts are accurate, the problem was balances was removed from accounts table in the new haf but there are hive/hbd fields which are actually rewards not balances. It's kind of weird. I am in the middle of moving all my queries over.