Repository
https://github.com/steemit/steem
Introduction
An analysis will be made of the new steem account created in February 2019. Then a closer look will be made on accounts activity, rewards, balance and delegation received.
Based on this, an effort will be made to allocate the genuine users who are active and not rewarded. They will receive a small reward in form of SBI units, delegation and liquid STEEM. The end selection will be done manually from the pool of accounts that meet certain criteria.
A note before continuing. The purpose of this analysis is not to go as much in the of account creation process and stats. The main purpose is to find a few new Steemians, who deserve some push in the back. A much detailed analysis on the account creation process is made by 
This is an effort to try to contribute to the community and give something back. We all know that starting is not easy. A small push is very much welcomed. It is nice when someone finds you and rewards you without you asking for it.
It is first time doing this so maybe there will be some improvements and changes in the future. Suggestions are welcomed.
Accounts creations in February 2019
Below is a chart of the number of accounts created in February 2019.
A total of 19,199 steem accounts were created in February 2019
Compared to January 2019 when this number was 25,054, there is a slight drop in the number of accounts created, but February have 3 days less as well 😊. December was a month with low number of accounts created, so compared to December the numbers are much better.
The average daily account created in February is around 700. The record number of created accounts was on 12th of February, with 1178 accounts. The minimum was a few days later on 16th of February with 258 accounts created.
Who created the accounts
Below is a chart for the account creators.
Steem created the most accounts with 85,3% share. Next is Oracle-D and Blocktrades after them. Steemmonsters, Steemhunt and Partiko are also in the top creators of accounts. There is a total of 315 creators of accounts in February 2019, with a lot of them creating only a few accounts. All of them are in the others category.
Accounts Distribution per Number of Posts and Balance
How active was the new accounts? Do they got rewarded for activities?
Below is a chart of the number of accounts and how much they posted. The accounts are grouped in 7 groups>
- Accounts that didn’t posted, 0 posts,
- Accounts with 1 post,
- Accounts with posts between 2 and 5,
- Accounts with posts between 5 and 10,
- Accounts with posts between 10 and 20,
- Accounts with posts between 20 and 50 and
- Accounts with more than 50 posts.
Comments are also included in the number of posts.
Accounts Distribution per Number of Posts
A majority 72,2% out of the 19,199 accounts created in February didn’t posted at all. An 8,3% posted only once. The rest of the accounts share around 20% are in the group that posted more than once. Their distribution is shown on the chart.
Accounts Distribution per Balance
Below is a chart of the number of accounts and their distribution according to the balance of the account. A note on the balance. The balance of the account is a sum of the different balances, like SBD, savings, vests, pending reward etc. A conversion is made on the SBD balance in STEEM. So the final balance can be approximate and not totally accurate.
The accounts are grouped in 7 groups, just as for the posts above.
A majority almost 70% of the accounts created in February have 0 balance. An 21,1% have balance between 0 and 1. The rest of the accounts share around 9% are in the groups with a balance more than 1 STEEM.
This balance doesn’t include the delegated STEEM that the accounts usually get when created.
Posting and Balance Dependencies
I will search for Steemians to reward mainly under two criteria. Number of posts and balance. At the end I will go through a pool of accounts manually and try to find the ones with quality content. Lets see how are dependencies between posts and balance.
Here is a scatter chart on that.
I have limited the axes between 10 STEEM and 50 posts, since the majority of the accounts are in this range. As we can see there is no correlation between posting and balance. Actually, there is a lot of accounts with zero posts but with some STEEM in the account. I guess people are using the accounts only as a wallet. Maybe some of them to diversify the risk holding everything in one place.
For example, there is more than 100 accounts with a balance greater then 50 STEEM, that were created in February but didn’t posted. Maybe some of them will in the coming period.
Top 10 accounts with most posts
Here are the top 10 accounts created in February 2019 and had the biggest number of posts.
| No | Account | Posts |
|---|---|---|
| 1 |  | 3802 |
| 2 |  | 267 |
| 3 |  | 240 |
| 4 |  | 234 |
| 5 |  | 207 |
| 6 |  | 197 |
| 7 |  | 173 |
| 8 |  | 154 |
| 9 |  | 151 |
| 10 |  | 131 |
At number one place with a total of 3802 posts is 
Top 10 accounts with the biggest balance
Here are the top 10 accounts created in February 2019 and have the biggest balance.
| No | Account | Balance |
|---|---|---|
| 1 |  | ~501,197 |
| 2 |  | ~40,089 |
| 3 |  | ~16,082 |
| 4 | | ~13,654 |
| 5 |  | ~12,023 |
| 6 |  | ~7,190 |
| 7 |  | ~5,980 |
| 8 |  | ~4,205 |
| 9 |  | ~4,177 |
| 10 |  | ~4,074 |
Note on the balance. It is a sum from all the diferent balances, SBD included and it is estimated.
These accounts are doing great and they certainly don’t need a push in the back 😊. Congrats on them and holdings they have in STEEM.
Searching for Steemians to support
Ok, now comes the hard part. Not that the numbers and charts above were easy to do but checking the account profiles manually was quite an experience.
Like mentioned above I was looking for accounts that are active but received almost no reward. I tried to find them and reward them as much as I can. Not asking from them to come to me. It is a special feeling when someone finds you and rewards you without you asking for it.
Here what I did. First, I searched for accounts with more then 30 posts and less then 0,3 STEEM balance. This resulted in around 50 account that I then checked them all manually.
Since I wasn’t quite satisfied with the result of this pool of accounts, I made a second pool for accounts with a filter for daily posts. Accounts between 0,5 and 1 post per day were selected and balance between 0,1 and 1 STEEM. This resulted in a pool of 142 accounts. Out of these accounts I checked around 100 accounts and found some good ones in there. I ended up with a around 25 preselected accounts and then went one more time through them to select the top 5 that will be rewarded.
Now, the final choice is a bit subjective from my side, but the main criteria were for the accounts to have some activates but not rewarded enough. The final manual check from my side was to check for quality and original content.
Here are the rewarded accounts and the rewards.
| No | Account | Reward |
|---|---|---|
| 1 |  | 6 SBI, 30 SP delegation, 2 STEEM |
| 2 |  | 4 SBI, 30 SP delegation, 1 STEEM |
| 3 |  | 30 SP delegation |
| 4 |  | 20 SP delegation |
| 5 |  | 15 SP delegation |
Congrats to these Steemians and hope you will grow fast!
These Steemians will receive an automated upvote from me for the next month as well. That is an approximate 0,03$ worth now.
The rewards are maybe not as big, but that is what I can do now. Hope to increase them in time, and the number of rewarded Steemians as well.
The delegations are for one month and then they will be delegated to new users after that.
Transfers:
Delegations:
The query used to get new account information was:
let
Source = Sql.Database("vip.steemsql.com", "DBSteem", [Query="Select *#(lf)FROM Accounts (NOLOCK)#(lf)where #(lf)(created >= CONVERT(datetime,'02/01/2019')#(lf)AND created< CONVERT(datetime,'02/28/2019'))"])
in
Source
The query used to get who created accounts was:
Select *
FROM Accounts (NOLOCK)
where
( created >= CONVERT(datetime,'01/01/2018')
AND created< CONVERT(datetime,'12/01/2018')
GitHub Account
https://github.com/dalz
