Hive Total Claimed Accounts - Trends, Insights, and Analysis...

Hey All,

Hive Total Claimed Accounts.png

There is this activity on the HIVE blockchain where users with the help of their Resource Credits aka RC are able to claim new hive accounts and its not necessary that once you have claimed an account a new account has been created on the chain. Have a look at my account where I have close to 2227 account tokens which I can use to claim #HIVE accounts.

There is a difference between Claimed Account Vs and Created Account.

Feature	Created Account	Claimed Account
Definition	An account that has been officially created on the Hive blockchain with a unique username.	An account that is reserved or allocated but not yet activated or used. See below image, I have 2227 accounts left to be claimed
Activation Status	Fully active and can perform transactions, post, vote, etc.	Not yet active; cannot perform any actions until claimed/activated.
User Ownership	Directly controlled by the user who created it.	Claimed by someone who has received the rights to use the account, often via a creation token.

With my current HP status which is around 140K+ when I click on - "Claim Multiple accounts" on peakd platform - I get this message::

As of writing this blog post, my recource credits is close to 83% and if I use these RC then I can claim close to 18 more accounts. In simple words we can say that the #HIVE chain will automatically calculate how much of ones account HP is “spent” to claim the account. Moving further to the - "Hive Total Claimed Accounts" here the query that I triggered and the result that I got on my DBeaver application.

As you can see close to 5.7 million accounts have been claimed, indicating that many accounts are claimed but not yet activated. Do we get into the trends and insights of this data i.e.;

Top 100 Users by Total Account Claimed
Used vs Unused Claimed
Percentage Utilization of Claimed And finally
Heatmap of Claimed vs Created Accounts

Sounds intresting? I went further adding and refining my query to pull records for the Top100 users who have claimed accounts and then plotted some above defined graphs to analyze the trends. Here is the working query with the output, I exported it to a csv file to plot the graphs.

Query out in table form for Top20 for readablity purpose. Note the graphs though are plotted consedring the top100 users data who have claimed accounts based on raking.

Rank	Creator	TotalClaimed	TotalCreated	UnusedClaims	PercentShare	ConversionRate
1	appreciator	598866	22628	576238	11.03	3.78
2	blocktrades	487402	169	487233	9.32	0.03
3	ocdb	498357	27072	471285	9.02	5.43
4	steem	220961	0	220961	4.23	0.00
5	buildawhale	190580	0	190580	3.65	0.00
6	rocky1	141284	0	141284	2.70	0.00
7	ecency	143424	9547	133877	2.56	6.66
8	alpha	125836	0	125836	2.41	0.00
9	bdvoter	120496	40	120456	2.30	0.03
10	theycallmedan	97525	15	97510	1.87	0.02
11	themarkymark	87489	7	87482	1.67	0.01
12	blocktrades.com	78558	0	78558	1.50	0.00
13	threespeak	73736	2421	71315	1.36	3.28
14	gtg	69589	12	69577	1.33	0.02
15	smartsteem	67570	0	67570	1.29	0.00
16	adm	58009	0	58009	1.11	0.00
17	abit	56597	1	56596	1.08	0.00
18	leo.voter	102905	47293	55612	1.06	45.96
19	honey-swap	49873	3	49870	0.95	0.01
20	zingtoken	49436	1	49435	0.95	0.00

Let’s now take a quick look at the different graphs plotted; their insights are largely self-explanatory.

Ok I guess this should be it for todays post on - "Hive Total Claimed Accounts - Trends, Insights, and Analysis..." Let me know what you guys were able to spot on these trend analysis for hive account claimed by top20 users. I hope I was able to explain things clearly. If you have any follow-up questions or doubts, please feel free to share them in the comments below. Happy Learning with HiveSQL....Cheers...

Hive Total Claimed Accounts - Trends, Insights, and Analysis...

#Hive #Accountsclaimed #hiveAccountsclaimed #Blockchain #Crypto #HiveSQL #PowerUpTrend #HiveCommunity #Web3 #Decentralization #HiveBlog

Best Regards
Paras

Image Courtesy:: pro canva license, hiveblocks, DBeaver

PS:- None of the above is a FINANCIAL Advice. Please DYOR; Do your own research. I've have an interest in BlockChain & Cryptos and have been investing in many emerging projects.

Recent Top 5 Hive Blockchain Data Query Blogs

📚 My Earlier HiveSQL - Hive Blockchain Data Related Blogs