Last I checked, if you took every user on-boarded by leo.voter in the last 12 months, there is less than 1,300 HP powered up total. While this is pretty bad, it's no surprise as most users don't power up and just earn rewards or do nothing at all.
What is more interesting to me is there are 13,614 monthly active users added to Hive but only 1,797 users who have created more than 4 comment/posts that have been on-boarded by Leo. If you look at those who created over 10 comment/posts, there are 1112 users. If you drill down to anyone who has done over 1, the number is 3,457 and if you say anyone who has done at least 1 you are looking at 8,133. We still haven't hit 13,614, so I am not sure how you can represent an active user who hasn't posted or commented.
If you look at transfers from these same users, it's about 8600 unique, but to the user is around 13,600 which is where I think they got their metric from. As you know every user on-boarded get spam messages upon on-boarding from executiveboard and witnesses and dhf projects looking for votes.
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.
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.
That's really helpful, thank you.