Repository
https://github.com/steemit/steem
Contents
- Introduction
- Scope
- An overview and comparison
- Activity by Content and Up-votes
- Activity by Posting Key
- Conclusion / Summary
- Tools and Scripts
- Relevant Links and Resources
source
Introduction
This analysis is a follow up to Steem: Account Claims Analysis. Background information with regards to Claimed Accounts and their purpose can be found on this post.
At the time of writing, the Resource Credit cost of claiming an account is 9,289,019,776,360 RCs. This number was obtained by the output a failed account claim (due to lack of RC 'mana') using Steem Connect's 'claim account' web-page.
Using https://steemd.com/@abh12345 as a guide with a 'max_mana' (RCs) of 34,615,566,006,823 and the current RC cost of claiming an account, it is estimated that that a Steem account will require to hold approximately 4,640 Active Steem Power (And have 100% 'mana'/RCs available) to create a pending claimed account.
34,615,566,006,823 / 9,289,019,776,360 = 3.726503639804659
17,292.94 Steem Power / 3.726503639804659 = 4,640 SP
The aim of this analysis is to:
- Review current claim and creation numbers and compare with the previous work two months ago
- Take a look at some of the activities the claimed accounts are undertaking
Scope
The data for this analysis was gathered on the 15th March 2019 and unless otherwise stated, the data processed covers the period from the 25th September 2018 to the 14th March 2019.
An account created via a claim 'token' is considered to be one which has a 0.0000 fee and 0.0000 delegation attached.
An overview and comparison
The very first account claim was made on the 25th September 2018 by 'blocktrades'.
From this date up until 14th March 2019, 332,751 accounts have been claimed and this number is shared between 761 claimants.
The previous analysis covered 113 days from the 25th September 2018 to the 16th January 2019 and in that time there were 221,935 claims shared between 566 claimants.
The table below shows the overall, previous, and most recent period - which is the 56 days between the first and 2nd analysis.
We can see that the daily average number of claims is rising slowly as time progresses, but rising much faster is the average number of claim 'tokens' that are being used to create an account. This could be due to the increasing number of applications and games available, and there is further analysis here later in the report.
The next chart shows the number of accounts created from a claim 'token', grouped into weeks.
The average number of accounts created prior to 2019 on any given week is lower than 2019, but there are three busy weeks in 2018, and one in 2019. Looking closer at the busy period in early January 2019, we can see that a total of 8628 accounts were created via a claim token in the 4 days covering the 8th - 11th January, and 4087 of those were on the 9th January.
A quick check on this date alone shows that, as probably expected by some, 'steem' is the creator of the vast majority of these accounts via a claim token - 3992 of the 3087. Since the 9th of January, no more than 2000 accounts have been created using this method in a single day, and perhaps any backlogs of accounts requiring creation have been cleared.
From the 25th September 2018 to the 14th March 2019, 89,602 accounts have been created via a claim token. 'steem' have created the vast majority of these accounts, 76,537 in total.
Activity by Content and Up-votes
In this section, a look at the activity of accounts created via a claim token, grouped by the account that created them, as far as Posts, Comments, Up-votes, and Down-votes.
The table is made up of the top 20 claimed account creators and a selection of additional creators which are related to applications. .e.g. 'appics'.
As far as overall activity based on the criteria above, the accounts created by 'blocktrades' via claims show up well in all areas. Only 'actifit' average more posts per account created, but produce less than half the comments than the 'blocktrades' created accounts, on average.
The accounts created by 'fundition' show easily the highest number of comments, with almost 70 on average per account created. 'partiko', surprisingly for me, rank 5th on the average number of comments produced by an account created via a claim.
Potentially, the accounts mentioned above are the creators of the accounts producing content, as apposed to some of the creators with low averages for this criteria, whose accounts could be more focused on games, or curation.
'blocktrades' and 'actifit' also average highly on the voting numbers, and 'actifit' likely score well in this regard due to a curation initiative they have in place for application users:
...visiting the Actifitter's activity page on actifit.io, upvoting a minimum of 3 actifitter's reports with 20%, will earn you 3 AFIT tokens, daily! source
Activity by Posting Key
Using the table above for popular creators tied to applications, and scan through the Posting 'Auths' of various accounts to build a list of commonly used applications, the following table looks at the number of claimed accounts that are using these applications, and what they make of the total percentage.
These numbers are based on the 'posting' field in the 'accounts' of the SteemSQL.
'dtube' have by far the largest number of entries in the posting field, with 'busy', and 'steemauto' - the automation tool in 3rd.
It is 'drugwars' that has the largest percentage of posting auths attached to claimed accounts, and perhaps surprisingly, 'fundition' is a clear second. 'partiko' and 'peakmonsters' also show reasonably high percentages - about a quarter of accounts with posting auths for those applications tied to accounts created via claims.
The data here is far from conclusive as 'drugwars', for example, is one of the newer applications and so perhaps more likely to have a higher percentage of claimed accounts linked via posting authorization.
And considering the number of Steem accounts in existence, the overall numbers attached to these 'popular' applications does not look that great in my opinion. I would have expected to see higher figures all round.
Conclusion / Summary
Account creations, excluding those created by 'steem', started out relatively steady following the hardfork at the end of September 2018, but since the turn of the year have picked up noticeably.
Accounts created through 'blocktrades' show up best as far as content activity and voting, and it is 'drugwars' leading the way as far as claimed accounts registered via posting authorization playing the game.
This analysis didn't quite go the way I had planned it, and spanned over 3 days. The amount of data that could be presented on the topic is vast, and this is only a relatively small sample. Earnings grouped by account creator, and Vests owned / delegated to claimed accounts summed/averaged by creator could also lead to some interesting findings - perhaps it's best not to know :)
Tools and Scripts
This analysis was produced by gathering data from SteemSQL, a copy of the Steem blockchain data held in a SQL Server database which is managed by @arcange. The scripts were written in Linqpad 5 and the charts produced using MS Excel.
-- Total claims in Scope of analysis
select count(*) from TxAccountClaims where timestamp between '09/25/2018 00:00:00' and '03/14/2019 00:00:00'
-- Recent period
select count(*) from TxAccountClaims where timestamp between '01/16/2019 00:00:00' and '03/14/2019 00:00:00'
-- Accounts (all in scope) Created from Pending Claimed Account
select fee, delegation, creator, new_account_name, timestamp from TxAccountCreates
where fee = 0.0000 and delegation = 0.0000
and timestamp < '03/14/2019 00:00:00'
and timestamp > '09/25/2018 00:00:00'
order by timestamp desc
-- Accounts (first period) Created from Pending Claimed Account
select fee, delegation, creator, new_account_name, timestamp from TxAccountCreates
where fee = 0.0000 and delegation = 0.0000
and timestamp < '01/16/2019 00:00:00'
and timestamp > '09/25/2018 00:00:00'
order by timestamp desc
-- Week Creates
select cast(datepart(ww,convert(date,[timestamp])) as varchar(20)), count(*) from TxAccountCreates
where timestamp > getdate()-200
and fee = 0.0000 and delegation = 0.0000
group by cast(datepart(ww,convert(date,[timestamp])) as varchar(20))
-- Day Creates
select cast(datepart(month,convert(date,[timestamp])) as varchar(20))+'/'+cast(datepart(day,convert(date,[timestamp])) as varchar(20))+'/'+cast(datepart(year,convert(date,[timestamp])) as varchar(20)), count(*) from TxAccountCreates
where timestamp > getdate()-190
and fee = 0.0000 and delegation = 0.0000
group by cast(datepart(month,convert(date,[timestamp])) as varchar(20))+'/'+cast(datepart(day,convert(date,[timestamp])) as varchar(20))+'/'+cast(datepart(year,convert(date,[timestamp])) as varchar(20))
-- Creator on most recent busy day
select creator, count(*) from TxAccountCreates
where timestamp between '01/09/2019 00:00:00' and '01/09/2019 23:59:59'
group by creator
order by count(*) desc
-- Creator totals
select creator, count(*) from TxAccountCreates
where fee = 0.0000 and delegation = 0.0000
and timestamp < '03/14/2019 00:00:00'
and timestamp > '09/25/2018 00:00:00'
group by creator
order by count(*) desc
-------------------------------------------------
-- Posts
select creator, count(*)
from TxAccountCreates
inner join Accounts on new_account_name = name
inner join Comments on name = author
where fee = 0.0000 and delegation = 0.0000
and timestamp < '03/14/2019 00:00:00'
and timestamp > '09/25/2018 00:00:00'
and depth = 0
group by creator
order by count(*) desc
-- Comments
select creator, count(*)
from TxAccountCreates
inner join Accounts on new_account_name = name
inner join Comments on name = author
where fee = 0.0000 and delegation = 0.0000
and timestamp < '03/14/2019 00:00:00'
and timestamp > '09/25/2018 00:00:00'
and depth > 0
group by creator
order by count(*) desc
-- up-votes
select creator, count(*)
from TxAccountCreates ac
inner join Accounts on new_account_name = name
inner join txvotes on name = voter
where fee = 0.0000 and delegation = 0.0000
and ac.timestamp < '03/14/2019 00:00:00'
and ac.timestamp > '09/25/2018 00:00:00'
and weight > 0
group by creator
order by count(*) desc
------------------------------
select count(*) from accounts where posting like '%drugwars%'
-- Hardfork
select count(*)
from TxAccountCreates
inner join Accounts on new_account_name = name
where fee = 0.0000 and delegation = 0.0000
and posting like '%drugwars%'
and timestamp < '03/14/2019 00:00:00'
and timestamp > '09/25/2018 00:00:00'
-- 1st Jan
select count(*)
from TxAccountCreates
inner join Accounts on new_account_name = name
where fee = 0.0000 and delegation = 0.0000
and posting like '%drugwars%'
and timestamp < '03/14/2019 00:00:00'
and timestamp > '01/01/2019 00:00:00'
Cheers
Asher