PPC Charts

Quote from: AndyRossy on September 28, 2012, 08:11:45 PM

Quote from: wormbog on September 28, 2012, 07:42:46 PM

Some charts I'd like to see...

* difficulty over time

* coins generated from proof-of-work blocks vs proof-of-stake blocks per day/hour/whatever

For the charting, consider HighCharts:

http://www.highcharts.com/

Thanks for making these charts!

I am using high charts, will be adding difficulty and volume next, but I like your other suggestion

may well add this. I'll probably modify the client to hook the database.

Just moved from SQLite into Postgres - so now I can finally write so more "useful" SQL / get nicer graphs.

PPC Explorer has an API. The nethash call gives out some of the info you may need.

www.ppcexplore.org:2750/chain/PPcoin/q/nethash/1/start -will give you the entire block chain. I cut a section out below.

Code:

blockNumber:          height of last block in interval + 1
time:                 block time in seconds since 0h00 1 Jan 1970 UTC
target:               decimal target at blockNumber
avgTargetSinceLast:   harmonic mean of target over interval
difficulty:           difficulty at blockNumber
hashesToWin:          expected number of hashes needed to solve a block at this difficulty
avgIntervalSinceLast: interval seconds divided by blocks
netHashPerSecond:     estimated network hash rate over interval

Statistical values are approximate and differ slightly from http://blockexplorer.com/q/nethash.

/chain/CHAIN/q/nethash[/INTERVAL[/START[/STOP]]]
Default INTERVAL=144, START=0, STOP=infinity.
Negative values back from the last block.

blockNumber,time,target,avgTargetSinceLast,difficulty,hashesToWin,avgIntervalSinceLast,netHashPerSecond
START DATA
6321,1348001607,2017033654835272903204881886938165864819002079680517138097897472,2008145278777970750594747070786808460561099322256345733283534418,13366.136,57407118101245,541,106582645653
6322,1348003534,2016638197425943542316760232204503781834787631287515903923585024,2017033654835304971062482760647675097563617797584126764960621601,13368.757,57418375485059,1927,29790927920
6323,1348003731,2025476356669367988832241023712380176148659747753321264517742592,2016638197425957944966802877668263353227600586265526519447608121,13310.422,57167830597500,197,291463834950
6324,1348004018,2022777202923151716103791634260400879589735734912201729677197312,2025476356669372832826096729490958673478111330489001315464996624,13328.183,57244114215833,287,199191047378
6325,1348005684,105310684730512927707642485721578091156292573197555328461475676160,2022777202923153346124948826258396240274441996577795309961165418,256.003,1099528405248,1666,34360212615
6326,1348006143,2016682137138091249082107082730466235499700347775627152165175296,105310684730513301846352651663230519488751921631738188223328812799,13368.466,57417124446611,459,2395486722
6327,1348006205,2026838487745946898557993390017216239760953958884769960007041024,2016682137138108301526619451639250825889721227837992664932221994,13301.477,57129411118539,62,926082652365
6328,1348006687,2023235431349834943799551646888295039238111206859647604196638720,2026838487745949068591901435267247961266845173408666930397157686,13325.165,57231149397212,482,118525749209
6329,1348006898,2022444516531176222023308337420970873269682310073645135848013824,2023235431349854661597524717985513790275433418307836263894777403,13330.376,57253530710409,211,271237674868
6330,1348007422,2019839519310990749506316484810339691706999832564192561525161984,2022444516531179979281136850558467905557602445584923205152902793,13347.568,57327370877868,524,109262463188
6331,1348010713,2019331074070424428364445785867059870727295541773190974729617408,2019839519310997805848479760786072642291491242708216507850978941,13350.929,57341805276096,3291,17419438128
6332,1348012115,2037277307931894948668252307828010589010932175988913649401987072,2019331074070426684284222639739910069305278656134566189455117384,13233.322,56836685308619,1402,40900003763
6333,1348012276,2042669338322592107444387250942545974462364099315708255048564736,2037277307931905422121896545142460683411583751090356490032852098,13198.390,56686653617860,161,353022890116
6334,1348013097,2039706546303489594123856758334791955913963787545921230758477824,2042669338322594527631975910907904044708943948441839670004551608,13217.561,56768994268888,821,69045863116
6335,1348013479,2041194219414776237464885840428092172854580045786259206938034176,2039706546303490627315291111396723209363686704510873901287342213,13207.928,56727619614028,382,148609932641
6336,1348014016,2039719100506960367485384429913638371246795992256810158827503616,2041194219414810821951358924962792636796836960115536650562309789,13217.480,56768644863175,537,105638025352
6337,1348014855,2039292257588954073193443596232860249930501032086586604480626688,2039719100506992219920700863995217845509887832931911036107455294,13220.246,56780527070806,839,67662270397
6338,1348015967,2040899195633213063468985558325201412533023235080369397315928064,2039292257588980599505982476704862436512882224321542934325819394,13209.837,56735819919508,1112,51061625064
6339,1348016091,2044345324485940351208331406718542421395463428219380152263507968,2040899195633239344711712747664933552353977014198735152965836642,13187.569,56640181015618,124,457546934835
6340,1348016495,2041125171295686983976483646744436888524002919876370102558392320,2044345324485944177080746067019821419330464599654746299664009835,13208.374,56729538621980,404,140198467860
6341,1348017440,2039800702829520394335314295176140070910205322877588191276171264,2041125171295721840376311803058038170295541689502557627080565878,13216.951,56766373830881,945,60031257801
6342,1348017514,105310684730512927707642485721578091156292573197555328461475676160,2039800702829552764553926220429075782187793990038153499829319126,256.003,1099528405248,74,767113159877
6343,1348017916,2038080776954024443806023288874181170312193277485805045819637760,105310684730513301846352651663230519488751921631738188223328812799,13228.105,56814278681520,402,2735145287
6344,1348018268,2037239645321482628583669293091471343012435561856246865194909696,2038080776954049901221078552269879288271547728245624388388771758,13233.566,56837736052914,352,161404200800
6345,1348018765,2035569936259869771500488973104898103745752335308019432014479360,2037239645321511342939988563379114062717549888880234941434838858,13244.421,56884358122360,497,114361641958
6346,1348018812,2034873177967241849935703200478922052773564973853683924183547904,2035569936259874076856291372129964015053972970629930135682982174,13248.956,56903835821841,47,1210305491965
6347,1348019303,2031150856638157548242748577350959906588816277075116751717400576,2034873177967249271859952429814840124251941228746725640987463084,13273.236,57008118751439,491,115893759311
6348,1348021094,2030416435735117306593379789988444609618132301488114459679391744,2031150856638176107870050519593104537510729684202438692539565246,13278.038,57028739129268,1791,31830328728
6349,1348021202,2038400909142529164524978914134764761299414497613472711579795456,2030416435735118106135289746890445409501968603411344701373808687,13226.027,56805355962103,108,528043880827
6350,1348023149,2035086599426244997081673617319311113431712453938795701356986368,2038400909142537099447906170440428328526818792083996723884008539,13247.567,56897868262688,1947,29175837680
6351,1348023745,2044138180128672590743124825667576568403732050489712839124582400,2035086599426245053566673612047564770822683376251839757837926399,13188.906,56645920693104,596,95466221917
6352,1348025871,2044106794619995657339305646720460530071651538712490518952017920,2044138180128698522747084416646295273129223528873451420387433210,13189.108,56646790442689,2126,26644365331
6353,1348026348,2054407518567765200472760177163944310660475503996855999587680256,2044106794620005875355606276249544255316770602954107418766477762,13122.978,56362765513066,477,118756374094
6354,1348026390,2053572664036958771931170017170657691027133890722742282997465088,2054407518567791120646204385168513446286772212702330908661480216,13128.313,56385679097271,42,1341970607454
6355,1348027196,2049781294588785216749813200359040260511808068034286006151675904,2053572664036964577832456421396415910636089220849101230797356508,13152.596,56489972634151,806,69957418235
6356,1348027344,2051174811174041059879384745610992362456182790942957021813538816,2049781294588804853342568455453381695056470011418753222753302285,13143.661,56451594767312,148,381689004285
6357,1348027784,2048111585527172359666632880372467021245124841486058572971245568,2051174811174067976042882654035801589938292886590751939506518305,13163.319,56536025700724,440,128299079017
6358,1348028330,2047025646926950463894489288802252094955139133994166295000514560,2048111585527197088345198171875140922345243355828292823381780441,13170.302,56566017827449,546,103545834617

The Variable difficulty of the blocks in PPC, more than likely make the Net hash per second estimates off, especially when considering POS blocks have very low difficulty compared with current POW blocks.

The POS blocks are fairly easy to pull out, 6325 was the first POS with a difficulty of ~256 vs the ~13,000 of the blocks around it. One could probably use the logic that if a blocks difficulty is below a certain percentage compared with a number of blocks around it is POS.

PPC explorer uses different logic to see POS blocks.One of my short term goals is to add a field in the database and flag blocks either as POS or POW. Perhaps I could replace the inaccurate net hash per second field in the API with a POS/POW flag (Probably a Boolean).