I went back to March 2016 when Steemit was first created and got the totals for new accounts created each day and was amazed to learn that today we had the most new accounts created ever on the Steemit platform.
How many you ask?
8,638 new accounts for Jan 3rd 2018
I'm willing to bet we will see more record breaking day this month as the price of Steem continues to rise.
We are well on our way to a million or even two million accounts this year.
Top 10 growth days for Steemit:
| Total | Date |
| 8638 | 2018-01-03 |
| 6795 | 2017-11-10 |
| 5511 | 2017-06-13 |
| 4783 | 2017-12-18 |
| 4611 | 2017-12-19 |
| 4270 | 2017-07-08 |
| 4246 | 2017-12-26 |
| 4203 | 2017-06-14 |
| 4167 | 2017-12-15 |
| 4126 | 2017-12-24 |
Sql Script:
select
count(name)
,convert(date, created)
from accounts
where convert(date, created) >= dateadd(day, datediff(day, 0, GetDate()) - 10000, 0)
group by convert(date, created)
order by convert(date, created)