Can you tell me the percentage of users that have 50reps and more than 500hp, 60reps and less than 1000hp, and 70reps with less than 10k hp?
Why wouldn't people stay when they are getting 'free' money to cash out and waste on some consumerist bs?
IF you compare leavers with downvotes to those leavers without downvotes that may shed some light on their impact.
Remainers might also be informational.
How many people get downvotes and persist vs those that get them and leave?
The timing relative to dv's to leaving might shed some light, too.
I would suggest that price is impacted more by those with controlling amounts of stake rather than dumpers immediately dumping.
6% inflation is a rounding error once you have enough stake to control the price.
I harp on dumpers because dumping is not helping increase the relative value of hive.
IF those earning large amounts of it, 70+ reputation, are dumping it why would anyone else value what they don't?
At this point I'm gonna guess that in excess of 50% of existing coins are in the hands of fewer than 10 people.
I can't prove that, but the price remains really stable during periods of broader market turmoil, as it should when controlled by relatively few hands.
The issue for me is that this may end up being quite a complex query. Either difficult for the database to process for me or difficult for me to create the right query in the first place. The queries that I wrote for user retention took upwards of an hour to run and I expect this would be more complex than those. But you are right that it should be possible to analyze it with what we have in @hivesql