Exploratory Analysis – Account Creation and HF20 Changes
steem·@paulag·
0.000 HBDExploratory Analysis – Account Creation and HF20 Changes
<html>
<p>Exciting times are ahead with HF20 coming to STEEM on the 25th of September. For most of us here on steem this does not mean to much but there are some fundamental changes taking place that will need a little consideration by witnesses on new parameters that need to be set.</p>
<h2> Repository</h2>
<p><a href="https://github.com/steemit/steem">https://github.com/steemit/steem</a> </p>
<p>HF20, known as Velocity, makes changes to the account creation process works. Currently accounts can be set up with delegation, as Steemit Inc. have been doing for some time. This method of account creation will cease.</p>
<p>Instead the options will be Non-Discounted Accounts and Discounted Accounts.</p>
<p><strong>Non-Discounted Accounts</strong> will be created by paying the Account creation fee in STEEM. From what I understand, this STEEM will be burned when the account is created. </p>
<p>The account creation fee is set by witnesses. Currently, this identified as ‘reg fee’ on https://steemian.info/witnesses and is multiplied by 30 to get the actual fee. So, a 0.20 fee would be 6.0 STEEM. At current prices this is very low, considering some months ago most witnesses had this set at 0.10 or 3 STEEM and the price was 10 times higher.</p>
<p>When HF20 happens, a onetime multiplication of x30 will take place on the account creation fees since this multiplication will no longer take place at account creation stage.</p>
<p><em><strong>Is it time for witnesses to consider reviewing the account creation fee now that the price of steem is so low?</strong></em></p>
<p><strong>Discounted Accounts.</strong> This is where things get interesting and is a new way to create accounts. With discounted accounts the fee is paid with the new resource credit that will also be introduced with HF20. It’s a two step process. First the recourse credits will be used to Claim a discounted account. Once a discounted account is claimed it will be stored in their pending claims account until step two. Step two involved the actual set up of the discounted account.</p>
<p>Some points to note about pending claims. These do not expire, they are not transferable and there is also no upper limit to the amount one can have. But the do require recourse credits, and with SMT’s on the way, this could be a limited resource, especially for those with low SP. This could very well become an activity only carried out by highly staked accounts.</p>
<p><em><strong>Is it a case therefore that the account creation fee should be valued not against steem but RCs? </strong></em></p>
<p>By removing the delegation method and introducing the discounted accounts, a lot of the onus of account creation moves to witnesses. Between them the witnesses need to decide how many discount account creation tokens are created each day and the total number allowed at any one time.</p>
<p><em><strong>Do you think the number of account creation tokens should be limited and capped and at what levels?</strong></em></p>
<p>You can read more about these changes on @steemitblog</p>
<p>https://steemit.com/hf20/@steemitblog/velocity-hardfork-account-creation-guidelines</p>
<h2>Exploratory Analysis</h2>
<p>I have carried out an exploratory analysis with the aim of gathering account sign up information in a way that it can be sliced and diced so people can see when and who has been setting up accounts. Hopefully by looking at the numbers you will be better informed when considering what parameters should be set and why.</p>
<p>I have used Steemsql to gather the data and I have taken 2017 and 2018. Full details of the queries can be found at the bottom of the report.</p>
<p>The full report is available here and is fully interactive. Don’t be afraid to click around, you won’t break it.</p>
<p>https://app.powerbi.com/view?r=eyJrIjoiMzE5YTU1MzEtZWQ3Ni00ZWUxLWI0NmItNDc1MjFiNzYzZmZhIiwidCI6ImRhZWNkYWM0LTYyNjgtNGQyNy05Nzk0LWFiMjA0ODdkZTgyNyIsImMiOjh9</p>
<h3>Overview</h3>
<p>https://cdn.steemitimages.com/DQmZvLHUVzAUWFpje9wSxSk7zwh4VLLQnSiPVDCYxz81guv/2.png</p>
<p>The overview page of the report contains some general information</p>
<p>When filters are NOT placed on this report we can see that for 2017 and 2018 combined we have over 1M new accounts. Of which 19.12% have their about profile complete and 9.19% have completed a link in the profile to a website or other source. If you have followed my monthly new user report, you will know that these values are important as it is an indication of the quality of the account.</p>
<p>43.43% of accounts have posted, 21.25% have posted 10 or more times and 9.63% have posted 50+ times.</p>
<p>I have then created an account classification based on the account actives.</p>
<p><strong>Fully active</strong> accounts have both posted and voted at some stage</p>
<p>Some accounts <strong>have posted and never voted</strong></p>
<p>Some accounts <strong>have voted and never posted</strong></p>
<p><strong>Wallet holder</strong> accounts have made a transfer but have not posted or voted</p>
<p><strong>Not active </strong>accounts have never posted, voted or made a transfer.</p>
<p>The number and % of these accounts is seen in the pie chart.</p>
<p><del>I have also added recovery account information as it gives some indication on who is setting up accounts. </del></p>
<p>I have used the accounts create tables to gather information on who has set up each account</p>
<p>96.67% accounts have @steem set up as a recover account, 0.84% blocktrades and 0.71% @anonsteem. </p>
<p>The gif shows how you can add and remove filters and interact with the dashboard.</p>
<p>https://cdn.steemitimages.com/DQmWfFrJVN8sWEUfEiY7qJZF1ixJvoaqwuBTs1pSsPgVKUP/powerupleague.gif</p>
<h2>Time Series</h2>
<p>The second page of the report shows the time series for accounts set up, the top charts shows the months and the bottom chart shows the weeks and the same period in the prior year. This page is also fully interactive and you can filter the data by years or Account Activity type.</p>
<p>https://cdn.steemitimages.com/DQmRavQQhXdN3cNtu51t12fbUMvh1m1TGzKa39DcuPd3seB/3.png</p>
<h2>Forecast</h2>
<p>Based on weekly account set up numbers I have used Power BI to predict the number of new accounts needed each week for the next 6 weeks</p>
<p>https://cdn.steemitimages.com/DQmVRp1qMWrd8vUfcZRiK2ymfFhTX3NbnXM1LCQPGdVcikX/4.png</p>
<h2><strong>Fee </strong></h2>
<p>On this page you will find an interactive time series for 2018 on the fees paid to create accounts and the delegations given.</p>
<p> https://cdn.steemitimages.com/DQmXGe4XrHVpgLVLi8hYNX1bhkWiR8BW8ksjVFmq1EeNVBs/2.png </p>
<h2>Delegations:</h2>
<p>On this page you will find an interactive time series for 2018 for delegations given to new accounts so they can transact.</p>
<p> https://cdn.steemitimages.com/DQme38DMVW917SnBQ9e4sFuJq8g28D9fhRkwNRy8tVPaNnU/3.png </p>
<p><strong>Explore Fees_delegation </strong></p>
<p>This page will give further details on the fees paid and delegations given. it has been set up so you can explore groupings between fees, delegations and account creation.</p>
<p> https://cdn.steemitimages.com/DQmW2PZSDuzvvDcuSVXcrobZr878Jfv6ENkZB4rL4yHXdoQ/4.png </p>
<h2>Conclusion</h2>
<p>The number of accounts being set up each month has declined since Jan 18 and the median monthly new user for year to date is 60K and the weekly median is 16.5K.</p>
<p>The vast majority of accounts have a recovery account of Steem. After HF20 I would expect to see this change considerably for new accounts as DApps will have the ability to register accounts using the discounted account model. This will in turn reduce the number of applications going though steemit inc and steemit.com. It will therefore be up to each DApps to decide on the account application process.</p>
<p>There are a number of things for witnesses to consider in addition to the data when deciding on these parameters. For example, if a cap is set on the total number of account creation tokens is circulation at any one time, how can the witnesses prevent illegitimate grabbing and stockpiling leaving a diminished amount for more legitimate use? Obviously, this could be countered by witnesses by increasing the cap and will have to be monitored. </p>
<p>Is it also worth considering how many new users we are equipped to handle? Are we ready to just open the flood gates? Or, should we keep it at a trickle, so we grow some awesome dolphins and orcas, improving the base users and current distribution first?</p>
<p>How many new discount account tokens should we issue each day and why?</p>
<p> https://cdn.steemitimages.com/DQmbQRxg3R9M2AFLHQjW388a6ng6ofoN3UVux5B8FGtiiWA/1.png </p>
<h2>Data and Queries</h2>
<p>To prepare this analysis I connected to steemsql. The SQL query to get the accounts information was</p>
<pre><code>Select *</code></pre>
<pre><code>FROM Accounts (NOLOCK)</code></pre>
<pre><code>where </code></pre>
<pre><code>created >= CONVERT(datetime,'01/01/2017')</code></pre>
<p> and the SQL query to get the accounts involved in transfer details was </p>
<pre><code>let</code></pre>
<pre><code> Source = Sql.Database("vip.steemsql.com", "DBSteem", [Query="select [from], timestamp#(lf)from TXTransfers#(lf)where #(lf)timestamp >= CONVERT(datetime,'01/01/2017')#(lf)"]),</code></pre>
<pre><code> #"Changed Type" = Table.TransformColumnTypes(Source,{{"timestamp", type date}}),</code></pre>
<pre><code> #"Appended Query" = Table.Combine({#"Changed Type", #"transfers (2)"}),</code></pre>
<pre><code> #"Removed Duplicates" = Table.Distinct(#"Appended Query", {"from"})</code></pre>
<pre><code>in</code></pre>
<pre><code> #"Removed Duplicates"</code></pre>
<p><code>The SQL query used to get account creation information is</code></p>
<pre><code>Select *</code></pre>
<pre><code>FROM txAccountcreates (NOLOCK)</code></pre>
<pre><code>where </code></pre>
<pre><code>timestamp >= CONVERT(datetime,'01/01/2017')</code></pre>
<p><br></p>
<p><br></p>
<p>To identify the accounts activity</p>
<p>the accounts table records the number of posts made, this allows us to identify accounts that have and have not posted.</p>
<p>The accounts table does not record the number of votes. However it does record the last vote date. adjustments had to be made to this as accounts that did not vote, recorded their last vote data as the account creation date.</p>
<p>To get the wallet holders only, any accounts that did not post or vote, but have made a transfer have been included as wallet holders.</p>
<p>Non active accounts have not voted, not posts and have not made a transfer.</p>
</html>👍 mimismartypants, nonzerosum, east.autovote, anttn, damahsyari, holger80, cryptoandcoffee, steembasicincome, musmui, semperenglish, beautifuldata, zcool, acidyo, eastmael, hitmeasap, ades, crokkon, tarazkp, espoem, j3dy, accelerator, effofex, steemitph, gamer86, mrday, abh12345, luigi-tecnologo, orlandumike, jesus.christ, sbdraffle, crimsonclad, helpie, momogrow, discordiant, soulturtle, socent, fefecolors, misterro, isaria, redrica, hz432creations, melavie, art-mess, pechichemena, kernelillo, mountainjewel, spawnband, veckinon, videopawer, clayboyn, eonwarped, luisferchav, carpedimus, silentscreamer, hazem91, free-reign, melor9, preventsuicide, eonwarp, boxcarblue, foxyspirit, lillywilton, markaustin, mrshev, mangos, legendchew, phi23, make-a-whale, familytree, roleerob, amriadits, arcange, amosbastian, nanzo-scoop, luoq, ladiesofsteemit, tebarsuara, smk-trail, prometheus2, seanlloyd, icsan, emily-cook, lucifier, mummyimperfect, ak2020, t-bot, mafeeva, chappers, silverade, fitat40, hafismultim, ptcmyanmar, good-karma2, timons, steem.lion, king.steem, bar-bar1903, amarspm53, steem.peng, yee900, steem-bar, power.steem, steem.sport, moemoe1998, mmsupporter1, lucifer2, marcovugts, sanhtun, jingis07, raphaelle, markgritter, elsurtidor, amymya, ameliabartlett, polbot, carrieallen, chainchoppers, trevorpetrie, gamsam, camuel, cobloc, anarcho-andrei, followbtcnews, edgarbevens, lordbutterfly, jamesbarraclough, wallacecarranza, marysemciver, omitaylor, moon32walker, jokinmenipieleen, torico, verhp11, asonintrigue, evecab, karonte, edwardstobia, musicvoter, theatreofdelays, kryptoe, wolfnworbeikood, grizzle, avesa, peter-ella, musicvoter2, dinoromanelli, djlethalskillz, grayarty, recordpool, archaimusic, mrart, emsteemians, elamental, ultramod, rhmi90, theturtleproject, thexreposts, hedge-x, shanibeer, drakos, heyimsnuffles, holoz0r, scorer, rogeviolinista, kiriatjrb, rognel2904, jamzed, steemitbuzz, hhtb, ggd3yydze, mariusjuk, wolfhart, jbrrd, jonmagnusson, nickychu, scuzzy, daysteembeliever, multifacet, saragarmee, sapphic, fulltime, yidneth, mike-nascar, postpromoter, demotruk, greenorange, fulltimebot22, fulltimebot4, jasonbu, fulltimebot21, pnc, sircork, torrey.blog, fulltimebot1, victorrojas4, soyrosa, themarkymark, aitch, clicked, mac128k, fulltimebot14, einstei1, etcmike, bubke, meanbees, goat-girlz, meanroosterfarm, timcliff, fulltimebot27, rades, remind-me, siddartha, truthly, iauns, kaczynski, steem77, belvaj, somto, aneukpineung78, arteem, bitjunky, retinox, codingdefined, majes, steemjetdiscord, rayfa, ristianti, howo, prameshtyagi, jacekw.dev, andresaulait, highmess, lextenebris, steemchiller, oups, lyndsaybowes, geekorner, pedromrmourato, harvhat, msicc, mielia, steemflower, steem-ua, barton26, liberosist, meerkat, surpassinggoogle, southparkqueen, baboyed1000, karyah1001, tradeownsystems, plojslydia, nessyquel, princekelly, ranielbrianulan, kerry234, ekjosh, awesome.ian, berylwills, goddywise4-eu, okekemmichael, andrelion, meansunlare, pauloliverpino, greenpower, babaj, pelephotography, camilus, hoobeehey, kul0tzzz, jacintoelbarouki, ulfiatu.akiya, jims, thamrin, jefry113, dexter24, mhel, mahmuddin, davealemana, smafey, penantang, masud222, pipo092281, parag, muksalbaihaqi, estrellamag, zohaib715, jecren, harkushi, goalgetter, layanmarissa, strings, ligarayk, asfuriah, allaboutme, ryl, loydjayme25, josh26, kingsman2, basir92, rheyss08, julianalpanta, annamighty, sissyjill, dzued, fifi-yanti, richmanoloriegbe, atjehsteemit, arellanoyan, morbyjohn, pojgaerlan, aldiyani, freudy, zombieslayer, khloyd, akaikeru, beni96, jeanp, azharmaulana, toyosiartdiy, theunlimited, donjyde, faisal08, queenlyka, muammarnst, fibrefox, khairuddin08, bravofer, belvajarandilla, muzaiyan, zay-arasi, dondondamayo, anime.lovers, ihsan19, toniesteem, bobiecayao, elbleess, kofspades, mercy11, bobtucks, klizo, enjoyy, hasan086, handfree42, nellita66, popson, levinvillas, talivet, chiboyzz, modernmclaire, used-lessboy, victoriakorol, starzy, antigenx, mcamayra, vanj, lstriker, shahaan, monwalker, rhei86, bittrex12, virgo27, muzzlealem, wandy01, jayo, ayoade96, mikemaphu, mbahtutorial, rechellomataro, lykia, sabiondico, kaplat, gerliepepito, etaletai, techsfair, blackelephant, mayorhero, geotorb, jaber-hossain70, gpwebers, morin89, devitech, wave.beads, purepinoy, christinevelasco, liquidpoopcorn, jgpro, bhim, olayemzeecool, amarm, studytext, crypto4euro, vlogger56, brewingstories, rextylerblunt, paulasands, ahmad097, hazelicious, qanon1111, ahsanabdullah, akeenze13, mittalamit284, devondrjackson, femidada, kumagang, emdesan, hasim5164, mkmk, bitcoin.news, shemzy, cheesom, imkareencajes, breezieblack, noechie1827, matadonis, sampath94, dtube-alfa, devangbuch, chrisjayl, neilrichmond, erenai, dazzy, greenville, kelvo, roheemat, ernoldlvb, edyscout81, leeyen23, aikee, sazid36, joanpablo, emeliveiga, akram7, gnaimul, chiqui03, marzuki-r, mojacko, daldon, engmi, pharao20, briandominise, rarcenal, galihtruff, cebusteemer, jezelle, mvoalevine, chrome.citizen, ikibaru-san, edundayo, minnowboostere, mrwang, moksamol, lotfiuser, rishadhaque, sunnylife, gps7530, shippou95, adnanbtc, evolutionnow, advsamadhan, fadiji09, bestsmiles, hokulor, fredoski, iamfo, pboss123, jedamez, preciousimo, princefizzy, alex04, polycarpedet, mutiarahmi, beshooo, sharminwadud, joco0820, muhammad.iqbal, jembee, jomar07, kyanzieuno, halim08, mayib, richardgreen, tammydixon, golden-man, mindbuilder-sc, boyaceh, ninihorlah, noodles09, sirwayneweezy, bertoandes, cebuana, osky, r5yn1r4, nicole24, mypride, pasokon, ayoshewa, dantoyin, bradondamyx12345, wanderinglynelle, freitzie123, bloghound, foways, joshruiz, chunnorris, viralfever, pjmisa, salim001, kike313, hrovat66, engineeringfeed, tomatom, paragon99, sirfreeman, vegasgambler, benjaspa, syamsudduha2, aronexxon, upyinnyarthutha, ninjarobo, rikilb, phoebedoll, afefe, arrahman90, steem-factuals, lianbloog, egheprincez, jsantos17, gemz2inspire, membee, steemitkyle, maikelblogo, mikeyurnero, fauzan11, erebuta01, hardaeborla, jayboi, vicmic, johngoad, kayegrasya, cynicalcake, elvinjohn21, david9122, jumpnrun, samsonite18654, joseaybar1, andylsyahputra, withbristy, jackbawa, skyphotographer, foley, ak477, dong-a, denkeicui, unityph, scottallen, naayren, gelique, glendale05, citysitebuilders, medyomaldita, caroljayne02, lemcervantes, unika-ejes, crystaljonah1, saifulhuri, whoib, ljpaez, lemi, crypto-whiz, jhanmervz, ckbahdon, preetisingh1993, fidel66, iamhumbled, esl, yourmercury, dolphinscute, eruditescholar1, originalmrspice, kutrulaju, annalorin28, ramadhanil, greatwarrior79, loudetteiam, sahiba, cradle, ilmondoditea, blessedsteemer, genesis171, byash, mrnightmare89, signup-newpeople, bigbiggi70, ekafao, adebits, drmoises, lemareg, maintang03, randomkindness, sadnesscarl, digital-aster, ramonjvp, idiongo, choobymaverick, grizzz, praditya, lksingha, rajesh1000, rizzybear, sid000, bellalhossain, pandina, chriswilson, pemburubitcoin, princezakir, minnowwboster, azisjesika, mzajoke, lunasilver, cesaralejandro, maanabdullah, shiddiq, big-m, razik9708, rachelleignacio, shiddiq000, elangzone, fadliloways, kawan-baru, shiddiqmjmr, carolinafer, gio.vanne, vyaduka, rawpostblog, antisocialian, zyper, hmuajanice, dreamseller, forhadh, semtroneum, alom8, razane, semihemre, thereikiforest, syami, alchemylgc, mdsohagm752, dktrending341, shahidullah832, jalvarezgw, qusain, neyda1975, naveedakhtar6283, tech-master, holatati, pipks, tff, camillius, melihkorkmaz, tony-duke, umut1905, iamwhatiamnot, alien-mastermind, beanenergy, faithvarron, eightbitfiction, mirna98, stuckinacup, arisviyo, ihal0001, dynamicshine, lakawero, ingpablojosue, wealth4good, morarnagringa, realblockchain, tinytaruen, tolarnee, simgirl, rosemarynoble, charisman, steemdragon, rosenderevies, masaitv, rigelmarco, khairamuliani, michealkey, zeshanjaved, pushpo, kaloka, zenc, abyni, cap.potato, letzsteem, donkeypong, analisa, kevinwong, tombstone, arconite, nurhayati, skreza, eduardonarvaez, aehiguese, lifediaries2nd, reungkhoem, udochi, carloniere, alextone, marysent, mrxplicit, badzkie123, gwapoaller, nanwaiwaimyint, sukro, hillaryaa, isaganicabrales, tentalavera, williams-owb, cordeta, onin91, frellarong, luijii, raquelita, lykaypajaro, sunshinebear, isaaceko, orhem, botefarm, bgmuna, keybordjp, steeman220, geezyweezy, bumut, syawalkoki, laura97, mwamin7, chinwengozi, friskykitty, tjessie, sojol527, autofreak, bitmycoin, khat.holanda23, jacobzeema, jancharlest, mimi87, justmeagain, jga, surfermarly, ausbitbank, utopian-io, kittysilhouette, babeline, doktormuslem, ivelevitico, aaronsuncamacho, dataspeaks, firepower, rico127, cryptocurator, soluce07, musatokmak,