Record Breaking: Today we had a massive bump in new account creation on Steemit
steemit·@wakeupnd·
0.000 HBDRecord Breaking: Today we had a massive bump in new account creation on Steemit
https://steemitimages.com/DQmeDxboUYJnG6fAMAvHPLiSoxk1sN14VG16XSZ3rypfDFo/image.png 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. <center>https://media.giphy.com/media/h8UyZ6FiT0ptC/giphy.gif</center> # Top 10 growth days for Steemit: <table> <tr><td>Total </td><td>Date</td></tr> <tr><td><b>8638</b></td><td> <b>2018-01-03</b></td></tr> <tr><td>6795</td><td> 2017-11-10</td></tr> <tr><td>5511</td><td> 2017-06-13</td></tr> <tr><td>4783</td><td> 2017-12-18</td></tr> <tr><td>4611</td><td> 2017-12-19</td></tr> <tr><td>4270</td><td> 2017-07-08</td></tr> <tr><td>4246</td><td> 2017-12-26</td></tr> <tr><td>4203</td><td> 2017-06-14</td></tr> <tr><td>4167</td><td> 2017-12-15</td></tr> <tr><td>4126</td><td> 2017-12-24</td></tr> </table> # 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)