Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/tynanpurdy/cryptocarbons.
Something went wrong. Try again.
cryptocarbons PhaseII.ipynb
120 kB · 2846 lines
at main
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846{ "cells": [ { "cell_type": "markdown", "metadata": { "id": "GJ4Xt1uf1LT7" }, "source": [ "# Final Project Phase 2 Summary" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "For best use of this notebook, open inside the cloned project github repository.\r\n", "\r\n", "[cryptocarbons](https://github.com/tynanpurdy/cryptocarbons)" ] }, { "cell_type": "markdown", "metadata": { "id": "tb9oVjpRDswQ" }, "source": [ "# Data Collection and Cleaning\n", "You are required to provide data collection and cleaning for the three (3) minimum datasets. Create a function for each of the following sections that reads or scrapes data from a file or website, manipulate and cleans the parsed data, and writes the cleaned data into a new file. \n", "\n", "Make sure your data cleaning and manipulation process is not too simple. Performing complex manipulation and using modules not taught in class shows effort, which will increase the chance of receiving full credit.\n" ] }, { "cell_type": "markdown", "metadata": { "id": "6Dp7Pm-Suh3d" }, "source": [ "## Data Sources\r\n", "Include sources (as links) to your datasets. Add any additional data sources if needed. Clearly indicate if a data source is different from one submitted in your Phase I, as we will check that it satisfies the requirements.\r\n", "* Downloaded Dataset #1 Source: [Global Power Plant Database](https://datasets.wri.org/dataset/globalpowerplantdatabase) `CSV` and [Global Power Plant Emissions Database](http://meicmodel.org/?page_id=91&lang=en) `XLSX`\r\n", "* Downloaded Dataset #2 Source: [BlockChain.com](https://www.blockchain.com/charts/hash-rate) `CSV`\r\n", "* Web Collection #1 Source: [WhatToMine GPUs](https://whattomine.com/gpus) `WEBSCRAPE`\r\n", "* Web Collection #2 Source: [WhatToMine Coins](https://whattomine.com/coins.json) `API REQUEST`\r\n", "\r\n" ] }, { "cell_type": "markdown", "metadata": { "id": "9mRjxZDbE1tj" }, "source": [ "## Downloaded Dataset Requirement\n", "\n", "Fill in the predefined functions with your data scraping/parsing code. You may modify/rename each function as you seem fit, but you must provide at least 3 separate functions that clean each of your required datasets.\n" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\r\n", "import numpy as np\r\n", "from bs4 import BeautifulSoup\r\n", "from pprint import pprint\r\n", "import requests\r\n", "import json" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "id": "0p5xxmqzFGrO" }, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>GENERATION_MW</th>\n", " <th>CO2 Emissions (Mg)</th>\n", " <th>SO2 Emissions (Mg)</th>\n", " <th>NOx Emissions (Mg)</th>\n", " <th>PM2.5 Emissions (Mg)</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>COAL</th>\n", " <td>9.960694e+06</td>\n", " <td>8.880799e+09</td>\n", " <td>2.973419e+07</td>\n", " <td>1.848038e+07</td>\n", " <td>2.508320e+06</td>\n", " </tr>\n", " <tr>\n", " <th>GAS</th>\n", " <td>6.304916e+06</td>\n", " <td>2.518846e+09</td>\n", " <td>5.228739e+04</td>\n", " <td>3.440040e+06</td>\n", " <td>4.144760e+04</td>\n", " </tr>\n", " <tr>\n", " <th>HYDRO</th>\n", " <td>3.755360e+06</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " </tr>\n", " <tr>\n", " <th>WIND</th>\n", " <td>7.094421e+05</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " </tr>\n", " <tr>\n", " <th>OIL</th>\n", " <td>5.360917e+05</td>\n", " <td>7.370139e+08</td>\n", " <td>8.689335e+06</td>\n", " <td>2.723445e+06</td>\n", " <td>9.304416e+04</td>\n", " </tr>\n", " <tr>\n", " <th>SOLAR</th>\n", " <td>3.486002e+05</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " </tr>\n", " <tr>\n", " <th>GEOTHERMAL</th>\n", " <td>6.083382e+04</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " <td>0.000000e+00</td>\n", " </tr>\n", " <tr>\n", " <th>BIOMASS</th>\n", " <td>3.368912e+04</td>\n", " <td>1.196067e+08</td>\n", " <td>1.792376e+05</td>\n", " <td>1.744930e+05</td>\n", " <td>3.713316e+04</td>\n", " </tr>\n", " <tr>\n", " <th>OTHER</th>\n", " <td>3.011469e+06</td>\n", " <td>2.749785e+08</td>\n", " <td>1.500827e+05</td>\n", " <td>3.382073e+05</td>\n", " <td>1.042250e+04</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " GENERATION_MW CO2 Emissions (Mg) SO2 Emissions (Mg) \\\n", "COAL 9.960694e+06 8.880799e+09 2.973419e+07 \n", "GAS 6.304916e+06 2.518846e+09 5.228739e+04 \n", "HYDRO 3.755360e+06 0.000000e+00 0.000000e+00 \n", "WIND 7.094421e+05 0.000000e+00 0.000000e+00 \n", "OIL 5.360917e+05 7.370139e+08 8.689335e+06 \n", "SOLAR 3.486002e+05 0.000000e+00 0.000000e+00 \n", "GEOTHERMAL 6.083382e+04 0.000000e+00 0.000000e+00 \n", "BIOMASS 3.368912e+04 1.196067e+08 1.792376e+05 \n", "OTHER 3.011469e+06 2.749785e+08 1.500827e+05 \n", "\n", " NOx Emissions (Mg) PM2.5 Emissions (Mg) \n", "COAL 1.848038e+07 2.508320e+06 \n", "GAS 3.440040e+06 4.144760e+04 \n", "HYDRO 0.000000e+00 0.000000e+00 \n", "WIND 0.000000e+00 0.000000e+00 \n", "OIL 2.723445e+06 9.304416e+04 \n", "SOLAR 0.000000e+00 0.000000e+00 \n", "GEOTHERMAL 0.000000e+00 0.000000e+00 \n", "BIOMASS 1.744930e+05 3.713316e+04 \n", "OTHER 3.382073e+05 1.042250e+04 " ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "def global_power():\n", " # IMPORT FILES\n", " generation_path = \"data\\global-power-plants\\global_power_plant_database.csv\"\n", " emission_path = \"data\\global-power-plants\\global_power_emissions_database.xlsx\"\n", " \n", " # power generation csv\n", " with open(generation_path, encoding='utf8') as fin:\n", " ppg = pd.read_csv(fin, low_memory=False)\n", " \n", " # power plant emissions xlsx\n", " ppe = pd.read_excel(emission_path, sheet_name='GPED_v1.0_Plant Level', skiprows=0, header=1)\n", "\n", " # removing unwanted data\n", " unwanted_columns = ['latitude',\n", " 'longitude',\n", " 'other_fuel1',\n", " 'other_fuel2',\n", " 'other_fuel3',\n", " 'commissioning_year',\n", " 'gppd_idnr',\n", " 'owner',\n", " 'source',\n", " 'url',\n", " 'geolocation_source',\n", " 'wepp_id',\n", " 'year_of_capacity_data',\n", " 'generation_data_source',\n", " 'generation_gwh_2018',\n", " 'generation_gwh_2019',\n", " 'estimated_generation_note_2013',\n", " 'estimated_generation_note_2014',\n", " 'estimated_generation_note_2015',\n", " 'estimated_generation_note_2016',\n", " 'estimated_generation_note_2017']\n", " ppg.drop(unwanted_columns, axis=1, inplace=True)\n", "\n", " unwanted_columns = ['No.', 'Number of Units', 'Total Plant Installed Capacity (MW)']\n", " ppe.drop(unwanted_columns, axis=1, inplace=True)\n", "\n", " # AGGREGATING DATA\n", " avgs = ['generation_gwh_2013',\n", " 'generation_gwh_2014',\n", " 'generation_gwh_2015',\n", " 'generation_gwh_2016',\n", " 'generation_gwh_2017']\n", " ppg['AVG_GENERATION'] = ppg[avgs].mean(axis=1)\n", "\n", " avgs = ['estimated_generation_gwh_2013',\n", " 'estimated_generation_gwh_2014',\n", " 'estimated_generation_gwh_2015',\n", " 'estimated_generation_gwh_2016',\n", " 'estimated_generation_gwh_2017']\n", " ppg['AVG_EST_GENERATION'] = ppg[avgs].mean(axis=1)\n", "\n", " # merge the two average columns into a single column\n", " ppg['GENERATION_MW'] = ppg.apply(lambda x : np.fmax(x['AVG_GENERATION'], x['AVG_EST_GENERATION']), axis=1)\n", "\n", " # remove unaggregated columns\n", " unwanted_columns = ['AVG_GENERATION',\n", " 'AVG_EST_GENERATION',\n", " 'generation_gwh_2013',\n", " 'generation_gwh_2014',\n", " 'generation_gwh_2015',\n", " 'generation_gwh_2016',\n", " 'generation_gwh_2017',\n", " 'estimated_generation_gwh_2013',\n", " 'estimated_generation_gwh_2014',\n", " 'estimated_generation_gwh_2015',\n", " 'estimated_generation_gwh_2016',\n", " 'estimated_generation_gwh_2017']\n", " ppg.drop(unwanted_columns, axis=1, inplace=True)\n", "\n", " # merge rows by fuel type\n", " generation_dist = ppg.groupby('primary_fuel')['GENERATION_MW'].sum().sort_values(ascending=False)\n", " emission_dist = ppe.groupby('Fuel Types').aggregate({'CO2 Emissions (Mg)':'sum',\n", " 'SO2 Emissions (Mg)':'sum',\n", " 'NOx Emissions (Mg)':'sum',\n", " 'PM2.5 Emissions (Mg)':'sum'})\n", "\n", " # COMBINING TABLES\n", " generation_dist.index = generation_dist.index.str.upper()\n", " generation_dist.drop('WAVE AND TIDAL', axis=0, inplace=True)\n", " gen_other = ['PETCOKE','WASTE','COGENERATION','STORAGE','NUCLEAR']\n", " generation_dist['OTHER'] = generation_dist[gen_other].sum(axis=0)\n", " generation_dist.drop(gen_other, axis=0, inplace=True)\n", " emission_dist = emission_dist.rename(index={'NG':'GAS'})\n", "\n", " power = pd.concat([generation_dist, emission_dist], axis=1)\n", " power = power.fillna(0)\n", "\n", " return power\n", "\n", "############ Function Call ############\n", "global_power()" ] }, { "cell_type": "markdown", "metadata": { "id": "794L4vGXFdYw" }, "source": [ "## Web Collection Requirement \\#1\n" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "id": "vXwpJObDFiWM" }, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>Hashrate (Millions of Hashes Per Sec)</th>\n", " <th>24 Hour Revenue</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>GeForce RTX 3090</th>\n", " <td>114.00 Mh/s</td>\n", " <td>$6.12</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon VII</th>\n", " <td>93.00 Mh/s</td>\n", " <td>$5.14</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 3080</th>\n", " <td>91.50 Mh/s</td>\n", " <td>$4.98</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 3080 Ti</th>\n", " <td>230.00 Mh/s</td>\n", " <td>$3.70</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 6800</th>\n", " <td>64.00 Mh/s</td>\n", " <td>$3.51</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 6900 XT</th>\n", " <td>64.00 Mh/s</td>\n", " <td>$3.51</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 6800 XT</th>\n", " <td>64.00 Mh/s</td>\n", " <td>$3.51</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 3060 Ti</th>\n", " <td>58.10 Mh/s</td>\n", " <td>$3.20</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 3070</th>\n", " <td>58.10 Mh/s</td>\n", " <td>$3.20</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 3070 Ti</th>\n", " <td>34.50 Mh/s</td>\n", " <td>$3.11</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 5700 XT</th>\n", " <td>55.00 Mh/s</td>\n", " <td>$3.01</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 5700</th>\n", " <td>55.00 Mh/s</td>\n", " <td>$3.01</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 2080 Ti</th>\n", " <td>72.00 h/s</td>\n", " <td>$2.93</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 3060 Unrestricted</th>\n", " <td>48.00 Mh/s</td>\n", " <td>$2.64</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX Vega 64</th>\n", " <td>160.00 Mh/s</td>\n", " <td>$2.61</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 6700 XT</th>\n", " <td>48.00 Mh/s</td>\n", " <td>$2.57</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX Vega 56</th>\n", " <td>49.00 Mh/s</td>\n", " <td>$2.55</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 2080</th>\n", " <td>61.00 h/s</td>\n", " <td>$2.47</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 5600 XT</th>\n", " <td>40.50 Mh/s</td>\n", " <td>$2.18</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 2080 Super</th>\n", " <td>41.00 Mh/s</td>\n", " <td>$2.09</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 2070</th>\n", " <td>40.00 Mh/s</td>\n", " <td>$2.08</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 2060 Super</th>\n", " <td>40.00 Mh/s</td>\n", " <td>$2.08</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 2070 Super</th>\n", " <td>40.00 Mh/s</td>\n", " <td>$2.08</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 3060</th>\n", " <td>37.00 Mh/s</td>\n", " <td>$1.97</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce GTX 1080 Ti</th>\n", " <td>3.60 Mh/s</td>\n", " <td>$1.96</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce GTX 1080</th>\n", " <td>34.00 Mh/s</td>\n", " <td>$1.65</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce RTX 2060</th>\n", " <td>18.00 Mh/s</td>\n", " <td>$1.60</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce GTX 1660 Super</th>\n", " <td>29.30 Mh/s</td>\n", " <td>$1.56</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 580 8GB</th>\n", " <td>30.50 Mh/s</td>\n", " <td>$1.53</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce GTX 1660 Ti</th>\n", " <td>28.00 Mh/s</td>\n", " <td>$1.50</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 480 8GB</th>\n", " <td>30.00 Mh/s</td>\n", " <td>$1.48</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce GTX 1070 Ti</th>\n", " <td>29.00 Mh/s</td>\n", " <td>$1.42</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 5500 XT 8GB</th>\n", " <td>26.00 Mh/s</td>\n", " <td>$1.36</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce GTX 1070</th>\n", " <td>33.50 h/s</td>\n", " <td>$1.30</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce GTX 1660</th>\n", " <td>23.00 Mh/s</td>\n", " <td>$1.20</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce GTX 1060 6GB</th>\n", " <td>22.50 Mh/s</td>\n", " <td>$1.14</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon R9 Fury</th>\n", " <td>17.00 Mh/s</td>\n", " <td>$0.97</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 570 4GB</th>\n", " <td>13.00 Mh/s</td>\n", " <td>$0.91</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon RX 470 4GB</th>\n", " <td>12.50 Mh/s</td>\n", " <td>$0.89</td>\n", " </tr>\n", " <tr>\n", " <th>GeForce GTX 1050 Ti</th>\n", " <td>6.40 Mh/s</td>\n", " <td>$0.49</td>\n", " </tr>\n", " <tr>\n", " <th>Radeon R9 380 4GB</th>\n", " <td>19.00 Mh/s</td>\n", " <td>$0.40</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "</div>" ], "text/plain": [ " Hashrate (Millions of Hashes Per Sec) \\\n", "GeForce RTX 3090 114.00 Mh/s \n", "Radeon VII 93.00 Mh/s \n", "GeForce RTX 3080 91.50 Mh/s \n", "GeForce RTX 3080 Ti 230.00 Mh/s \n", "Radeon RX 6800 64.00 Mh/s \n", "Radeon RX 6900 XT 64.00 Mh/s \n", "Radeon RX 6800 XT 64.00 Mh/s \n", "GeForce RTX 3060 Ti 58.10 Mh/s \n", "GeForce RTX 3070 58.10 Mh/s \n", "GeForce RTX 3070 Ti 34.50 Mh/s \n", "Radeon RX 5700 XT 55.00 Mh/s \n", "Radeon RX 5700 55.00 Mh/s \n", "GeForce RTX 2080 Ti 72.00 h/s \n", "GeForce RTX 3060 Unrestricted 48.00 Mh/s \n", "Radeon RX Vega 64 160.00 Mh/s \n", "Radeon RX 6700 XT 48.00 Mh/s \n", "Radeon RX Vega 56 49.00 Mh/s \n", "GeForce RTX 2080 61.00 h/s \n", "Radeon RX 5600 XT 40.50 Mh/s \n", "GeForce RTX 2080 Super 41.00 Mh/s \n", "GeForce RTX 2070 40.00 Mh/s \n", "GeForce RTX 2060 Super 40.00 Mh/s \n", "GeForce RTX 2070 Super 40.00 Mh/s \n", "GeForce RTX 3060 37.00 Mh/s \n", "GeForce GTX 1080 Ti 3.60 Mh/s \n", "GeForce GTX 1080 34.00 Mh/s \n", "GeForce RTX 2060 18.00 Mh/s \n", "GeForce GTX 1660 Super 29.30 Mh/s \n", "Radeon RX 580 8GB 30.50 Mh/s \n", "GeForce GTX 1660 Ti 28.00 Mh/s \n", "Radeon RX 480 8GB 30.00 Mh/s \n", "GeForce GTX 1070 Ti 29.00 Mh/s \n", "Radeon RX 5500 XT 8GB 26.00 Mh/s \n", "GeForce GTX 1070 33.50 h/s \n", "GeForce GTX 1660 23.00 Mh/s \n", "GeForce GTX 1060 6GB 22.50 Mh/s \n", "Radeon R9 Fury 17.00 Mh/s \n", "Radeon RX 570 4GB 13.00 Mh/s \n", "Radeon RX 470 4GB 12.50 Mh/s \n", "GeForce GTX 1050 Ti 6.40 Mh/s \n", "Radeon R9 380 4GB 19.00 Mh/s \n", "\n", " 24 Hour Revenue \n", "GeForce RTX 3090 $6.12 \n", "Radeon VII $5.14 \n", "GeForce RTX 3080 $4.98 \n", "GeForce RTX 3080 Ti $3.70 \n", "Radeon RX 6800 $3.51 \n", "Radeon RX 6900 XT $3.51 \n", "Radeon RX 6800 XT $3.51 \n", "GeForce RTX 3060 Ti $3.20 \n", "GeForce RTX 3070 $3.20 \n", "GeForce RTX 3070 Ti $3.11 \n", "Radeon RX 5700 XT $3.01 \n", "Radeon RX 5700 $3.01 \n", "GeForce RTX 2080 Ti $2.93 \n", "GeForce RTX 3060 Unrestricted $2.64 \n", "Radeon RX Vega 64 $2.61 \n", "Radeon RX 6700 XT $2.57 \n", "Radeon RX Vega 56 $2.55 \n", "GeForce RTX 2080 $2.47 \n", "Radeon RX 5600 XT $2.18 \n", "GeForce RTX 2080 Super $2.09 \n", "GeForce RTX 2070 $2.08 \n", "GeForce RTX 2060 Super $2.08 \n", "GeForce RTX 2070 Super $2.08 \n", "GeForce RTX 3060 $1.97 \n", "GeForce GTX 1080 Ti $1.96 \n", "GeForce GTX 1080 $1.65 \n", "GeForce RTX 2060 $1.60 \n", "GeForce GTX 1660 Super $1.56 \n", "Radeon RX 580 8GB $1.53 \n", "GeForce GTX 1660 Ti $1.50 \n", "Radeon RX 480 8GB $1.48 \n", "GeForce GTX 1070 Ti $1.42 \n", "Radeon RX 5500 XT 8GB $1.36 \n", "GeForce GTX 1070 $1.30 \n", "GeForce GTX 1660 $1.20 \n", "GeForce GTX 1060 6GB $1.14 \n", "Radeon R9 Fury $0.97 \n", "Radeon RX 570 4GB $0.91 \n", "Radeon RX 470 4GB $0.89 \n", "GeForce GTX 1050 Ti $0.49 \n", "Radeon R9 380 4GB $0.40 " ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "def web_scrape(): \r\n", "\r\n", " #creates a dict that connects to a list of all the HashRates of GPUs for easy iteration when creating visuals\r\n", " hashlist = []\r\n", " hashdict = {}\r\n", " url = requests.get('https://whattomine.com/gpus')\r\n", " soup = BeautifulSoup(url.text, 'html.parser')\r\n", " for hasher in soup.find_all('div',{'class' :'position-relative'}):\r\n", " for h in hasher.stripped_strings:\r\n", " hashlist.append(h)\r\n", " hashlist2= hashlist[::2]\r\n", " hashdict['Hashrate(Millions of Hash Per Sec)'] = [z for z in hashlist2] \r\n", " \r\n", " #creates a dict that connects to a list of all the Revenues of GPUs for easy iteration when creating visuals\r\n", " revlist = []\r\n", " revdict = {}\r\n", " for rev in soup.find_all('td',{'class':'text-right table-success font-weight-bold'}):\r\n", " for r in rev.stripped_strings:\r\n", " revlist.append(r)\r\n", " revdict[\"24Hour Revenue\"] = [z for z in revlist]\r\n", " \r\n", " #creates a dict that connects to a list of all the Names of GPUs\r\n", " namelist = []\r\n", " namedict = {}\r\n", " for name in soup.find_all('td'):\r\n", " for n in name.stripped_strings:\r\n", " namelist.append(n)\r\n", " if '(*)' in namelist:\r\n", " namelist.remove('(*)')\r\n", " namelist2 = namelist[1:650:16]\r\n", " namedict[\"GPU Model\"] = [z for z in namelist2]\r\n", "\r\n", " # this dictionary matches GPU model to the hash rate and 24 hour revenue\r\n", " fulldict = {}\r\n", " for i in range(len(namelist2)):\r\n", " fulldict[namelist2[i]] = {\"Hashrate(Millions of Hash Per Sec)\":hashlist2[i],\"24Hour Revenue\": revlist[i]}\r\n", " \r\n", " #creates a data frame with the columns as GPU name and the index as the description \r\n", " data = []\r\n", " data.append(hashlist2)\r\n", " data.append(revlist)\r\n", " df = pd.DataFrame(data, index= ['Hashrate (Millions of Hashes Per Sec)','24 Hour Revenue'], columns = namelist2).T\r\n", " return df \r\n", "\r\n", "############ Function Call ############\r\n", "web_scrape()" ] }, { "cell_type": "markdown", "metadata": { "id": "eDD6sMsCXRxc" }, "source": [ "## Web Collection Requirement \\#2" ] }, { "cell_type": "code", "execution_count": 45, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>id</th>\n", " <th>tag</th>\n", " <th>algorithm</th>\n", " <th>block_time</th>\n", " <th>block_reward</th>\n", " <th>block_reward24</th>\n", " <th>last_block</th>\n", " <th>difficulty</th>\n", " <th>difficulty24</th>\n", " <th>nethash</th>\n", " <th>...</th>\n", " <th>exchange_rate_curr</th>\n", " <th>market_cap</th>\n", " <th>estimated_rewards</th>\n", " <th>estimated_rewards24</th>\n", " <th>btc_revenue</th>\n", " <th>btc_revenue24</th>\n", " <th>profitability</th>\n", " <th>profitability24</th>\n", " <th>lagging</th>\n", " <th>timestamp</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>Ethereum</th>\n", " <td>151</td>\n", " <td>ETH</td>\n", " <td>Ethash</td>\n", " <td>13.4798</td>\n", " <td>2.260425</td>\n", " <td>2.3347</td>\n", " <td>12901084</td>\n", " <td>7273646078428641.0</td>\n", " <td>7076358552259530.0</td>\n", " <td>539595993889274</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$273,549,686,296.98</td>\n", " <td>0.00242</td>\n", " <td>0.00257</td>\n", " <td>0.00014802</td>\n", " <td>0.00015715</td>\n", " <td>100</td>\n", " <td>100</td>\n", " <td>False</td>\n", " <td>1627292203</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-Ethash</th>\n", " <td>15</td>\n", " <td>NICEHASH</td>\n", " <td>Ethash</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>39427305768412</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.00014</td>\n", " <td>0.00015</td>\n", " <td>0.00014273</td>\n", " <td>0.00015189</td>\n", " <td>96</td>\n", " <td>97</td>\n", " <td>False</td>\n", " <td>1627292172</td>\n", " </tr>\n", " <tr>\n", " <th>Ravencoin</th>\n", " <td>234</td>\n", " <td>RVN</td>\n", " <td>KawPow</td>\n", " <td>60.0</td>\n", " <td>5000.0</td>\n", " <td>5000.0</td>\n", " <td>1857852</td>\n", " <td>56167.469987</td>\n", " <td>53525.37911</td>\n", " <td>4020624111529</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$575,087,421.86</td>\n", " <td>69.83923</td>\n", " <td>73.28656</td>\n", " <td>0.00011314</td>\n", " <td>0.00011872</td>\n", " <td>76</td>\n", " <td>76</td>\n", " <td>False</td>\n", " <td>1627292169</td>\n", " </tr>\n", " <tr>\n", " <th>EthereumClassic</th>\n", " <td>162</td>\n", " <td>ETC</td>\n", " <td>Etchash</td>\n", " <td>13.317</td>\n", " <td>3.104</td>\n", " <td>3.104</td>\n", " <td>13204651</td>\n", " <td>290156745728694.0</td>\n", " <td>293242458022672.0</td>\n", " <td>21788446776953</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$6,825,911,540.32</td>\n", " <td>0.08318</td>\n", " <td>0.08231</td>\n", " <td>0.00011538</td>\n", " <td>0.00011416</td>\n", " <td>78</td>\n", " <td>73</td>\n", " <td>False</td>\n", " <td>1627292176</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-KawPow</th>\n", " <td>45</td>\n", " <td>NICEHASH</td>\n", " <td>KawPow</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1230064447958</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.0001</td>\n", " <td>0.00011</td>\n", " <td>0.00010202</td>\n", " <td>0.00011193</td>\n", " <td>69</td>\n", " <td>71</td>\n", " <td>False</td>\n", " <td>1627292170</td>\n", " </tr>\n", " <tr>\n", " <th>Ergo</th>\n", " <td>340</td>\n", " <td>ERG</td>\n", " <td>Autolykos</td>\n", " <td>105.0</td>\n", " <td>67.5011</td>\n", " <td>67.513111</td>\n", " <td>540443</td>\n", " <td>1371769604669440.0</td>\n", " <td>1371968739771980.0</td>\n", " <td>13064472425423</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$179,648,660.18</td>\n", " <td>0.75252</td>\n", " <td>0.75254</td>\n", " <td>0.00011049</td>\n", " <td>0.0001105</td>\n", " <td>75</td>\n", " <td>70</td>\n", " <td>False</td>\n", " <td>1627292206</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-Autolykos</th>\n", " <td>48</td>\n", " <td>NICEHASH</td>\n", " <td>Autolykos</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>688443473515</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.0001</td>\n", " <td>0.0001</td>\n", " <td>0.00009724</td>\n", " <td>0.00010153</td>\n", " <td>66</td>\n", " <td>65</td>\n", " <td>False</td>\n", " <td>1627292172</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-BeamV3</th>\n", " <td>38</td>\n", " <td>NICEHASH</td>\n", " <td>BeamHashIII</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>179602</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.00008</td>\n", " <td>0.00009</td>\n", " <td>0.00008274</td>\n", " <td>0.00008515</td>\n", " <td>56</td>\n", " <td>54</td>\n", " <td>False</td>\n", " <td>1627292171</td>\n", " </tr>\n", " <tr>\n", " <th>Beam</th>\n", " <td>294</td>\n", " <td>BEAM</td>\n", " <td>BeamHashIII</td>\n", " <td>59.0</td>\n", " <td>40.0</td>\n", " <td>40.0</td>\n", " <td>1341352</td>\n", " <td>22980426.0</td>\n", " <td>23232901.0</td>\n", " <td>389498</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$44,355,522.29</td>\n", " <td>6.64263</td>\n", " <td>6.57046</td>\n", " <td>0.00008283</td>\n", " <td>0.00008193</td>\n", " <td>56</td>\n", " <td>52</td>\n", " <td>False</td>\n", " <td>1627292202</td>\n", " </tr>\n", " <tr>\n", " <th>Zano</th>\n", " <td>330</td>\n", " <td>ZANO</td>\n", " <td>ProgPowZ</td>\n", " <td>120.0</td>\n", " <td>1.0</td>\n", " <td>1.0</td>\n", " <td>1160601</td>\n", " <td>1830746768596.0</td>\n", " <td>1839327492207.370117</td>\n", " <td>15256223071</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$32,526,862.54</td>\n", " <td>1.19557</td>\n", " <td>1.19</td>\n", " <td>0.00007966</td>\n", " <td>0.00007929</td>\n", " <td>54</td>\n", " <td>50</td>\n", " <td>False</td>\n", " <td>1627292060</td>\n", " </tr>\n", " <tr>\n", " <th>MWC-CT31</th>\n", " <td>323</td>\n", " <td>MWC</td>\n", " <td>Cuckatoo31</td>\n", " <td>61.0</td>\n", " <td>0.25</td>\n", " <td>0.25</td>\n", " <td>876024</td>\n", " <td>53593.323085</td>\n", " <td>57726.62278</td>\n", " <td>878</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$53,762,312.38</td>\n", " <td>0.65158</td>\n", " <td>0.60502</td>\n", " <td>0.00008519</td>\n", " <td>0.00007911</td>\n", " <td>58</td>\n", " <td>50</td>\n", " <td>False</td>\n", " <td>1627292175</td>\n", " </tr>\n", " <tr>\n", " <th>Vertcoin</th>\n", " <td>5</td>\n", " <td>VTC</td>\n", " <td>Verthash</td>\n", " <td>158.0</td>\n", " <td>25.0</td>\n", " <td>25.0</td>\n", " <td>1602140</td>\n", " <td>101.877361</td>\n", " <td>104.269716</td>\n", " <td>2769366659</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$29,984,251.73</td>\n", " <td>6.18738</td>\n", " <td>6.04548</td>\n", " <td>0.00007951</td>\n", " <td>0.00007768</td>\n", " <td>54</td>\n", " <td>49</td>\n", " <td>False</td>\n", " <td>1627292180</td>\n", " </tr>\n", " <tr>\n", " <th>Conceal</th>\n", " <td>305</td>\n", " <td>CCX</td>\n", " <td>CryptoNightGPU</td>\n", " <td>121.0</td>\n", " <td>6.001</td>\n", " <td>5.999228</td>\n", " <td>818553</td>\n", " <td>124000000.0</td>\n", " <td>130435520.361991</td>\n", " <td>1024793</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$3,389,442.81</td>\n", " <td>9.5123</td>\n", " <td>9.04129</td>\n", " <td>0.00007229</td>\n", " <td>0.00006871</td>\n", " <td>49</td>\n", " <td>44</td>\n", " <td>False</td>\n", " <td>1627292201</td>\n", " </tr>\n", " <tr>\n", " <th>Callisto</th>\n", " <td>283</td>\n", " <td>CLO</td>\n", " <td>Ethash</td>\n", " <td>13.0073</td>\n", " <td>38.7</td>\n", " <td>38.7</td>\n", " <td>7956356</td>\n", " <td>875415217139.0</td>\n", " <td>879842922524.890991</td>\n", " <td>67301839516</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$19,571,090.56</td>\n", " <td>343.29917</td>\n", " <td>341.57385</td>\n", " <td>0.00006827</td>\n", " <td>0.00006792</td>\n", " <td>46</td>\n", " <td>43</td>\n", " <td>False</td>\n", " <td>1627292175</td>\n", " </tr>\n", " <tr>\n", " <th>Etho</th>\n", " <td>306</td>\n", " <td>ETHO</td>\n", " <td>Ethash</td>\n", " <td>12.7992</td>\n", " <td>0.6</td>\n", " <td>0.6</td>\n", " <td>7581046</td>\n", " <td>158048902578.0</td>\n", " <td>140749881723.44101</td>\n", " <td>12348342285</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$4,385,146.47</td>\n", " <td>29.30638</td>\n", " <td>32.87907</td>\n", " <td>0.00005949</td>\n", " <td>0.00006674</td>\n", " <td>40</td>\n", " <td>42</td>\n", " <td>False</td>\n", " <td>1627292176</td>\n", " </tr>\n", " <tr>\n", " <th>Ellaism</th>\n", " <td>221</td>\n", " <td>ELLA</td>\n", " <td>Ethash</td>\n", " <td>12.8755</td>\n", " <td>4.91</td>\n", " <td>4.91</td>\n", " <td>9211704</td>\n", " <td>28634176473.0</td>\n", " <td>27555046069.033901</td>\n", " <td>2223927340</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$90,455.97</td>\n", " <td>1281.51568</td>\n", " <td>1329.6779</td>\n", " <td>0.00006408</td>\n", " <td>0.00006648</td>\n", " <td>43</td>\n", " <td>42</td>\n", " <td>False</td>\n", " <td>1627292175</td>\n", " </tr>\n", " <tr>\n", " <th>Equilibria</th>\n", " <td>341</td>\n", " <td>XEQ</td>\n", " <td>CryptoNightGPU</td>\n", " <td>120.0</td>\n", " <td>5.0437</td>\n", " <td>5.0615</td>\n", " <td>619595</td>\n", " <td>39169759.0</td>\n", " <td>34396891.01182</td>\n", " <td>326414</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$1,815,204.92</td>\n", " <td>25.18976</td>\n", " <td>28.75861</td>\n", " <td>0.00005819</td>\n", " <td>0.00006643</td>\n", " <td>39</td>\n", " <td>42</td>\n", " <td>False</td>\n", " <td>1627291943</td>\n", " </tr>\n", " <tr>\n", " <th>Ryo</th>\n", " <td>260</td>\n", " <td>RYO</td>\n", " <td>CryptoNightGPU</td>\n", " <td>252.0</td>\n", " <td>46.66499</td>\n", " <td>46.66499</td>\n", " <td>538596</td>\n", " <td>133342445.0</td>\n", " <td>131620441.48659</td>\n", " <td>529136</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$1,087,327.89</td>\n", " <td>68.64423</td>\n", " <td>69.53841</td>\n", " <td>0.00006247</td>\n", " <td>0.00006328</td>\n", " <td>42</td>\n", " <td>40</td>\n", " <td>False</td>\n", " <td>1627292086</td>\n", " </tr>\n", " <tr>\n", " <th>Zclassic</th>\n", " <td>167</td>\n", " <td>ZCL</td>\n", " <td>EquihashZero</td>\n", " <td>75.0</td>\n", " <td>0.78125</td>\n", " <td>0.78125</td>\n", " <td>1248599</td>\n", " <td>15.629829</td>\n", " <td>22.029539</td>\n", " <td>1707</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$1,433,373.75</td>\n", " <td>21.60995</td>\n", " <td>15.43983</td>\n", " <td>0.00008752</td>\n", " <td>0.00006253</td>\n", " <td>59</td>\n", " <td>40</td>\n", " <td>False</td>\n", " <td>1627291094</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-Cuckatoo31</th>\n", " <td>36</td>\n", " <td>NICEHASH</td>\n", " <td>Cuckatoo31</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>679</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.00006</td>\n", " <td>0.00006</td>\n", " <td>0.00005922</td>\n", " <td>0.00006138</td>\n", " <td>40</td>\n", " <td>39</td>\n", " <td>False</td>\n", " <td>1627292171</td>\n", " </tr>\n", " <tr>\n", " <th>BitTubeCash</th>\n", " <td>256</td>\n", " <td>TUBE</td>\n", " <td>CuckooCycle</td>\n", " <td>14.9817</td>\n", " <td>8.448794</td>\n", " <td>8.45019</td>\n", " <td>2075704</td>\n", " <td>12440.0</td>\n", " <td>12521.977401</td>\n", " <td>830</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$1,812,409.12</td>\n", " <td>408.09813</td>\n", " <td>405.51814</td>\n", " <td>0.00006121</td>\n", " <td>0.00006083</td>\n", " <td>41</td>\n", " <td>39</td>\n", " <td>False</td>\n", " <td>1627292207</td>\n", " </tr>\n", " <tr>\n", " <th>QuarkChain</th>\n", " <td>318</td>\n", " <td>QKC</td>\n", " <td>Ethash</td>\n", " <td>9.8222</td>\n", " <td>2.5168</td>\n", " <td>2.5168</td>\n", " <td>7218217</td>\n", " <td>54707293815.0</td>\n", " <td>57436193671.363503</td>\n", " <td>11139519418</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$97,841,744.93</td>\n", " <td>150.81826</td>\n", " <td>143.70733</td>\n", " <td>0.00006033</td>\n", " <td>0.00005748</td>\n", " <td>41</td>\n", " <td>37</td>\n", " <td>False</td>\n", " <td>1627292178</td>\n", " </tr>\n", " <tr>\n", " <th>Swap</th>\n", " <td>301</td>\n", " <td>XWP</td>\n", " <td>Cuckaroo29s</td>\n", " <td>14.8486</td>\n", " <td>1.142724</td>\n", " <td>1.143606</td>\n", " <td>5652858</td>\n", " <td>10240.0</td>\n", " <td>8738.214689</td>\n", " <td>689</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$365,267.78</td>\n", " <td>68.70318</td>\n", " <td>80.43012</td>\n", " <td>0.00004809</td>\n", " <td>0.0000563</td>\n", " <td>32</td>\n", " <td>36</td>\n", " <td>False</td>\n", " <td>1627292175</td>\n", " </tr>\n", " <tr>\n", " <th>Expanse</th>\n", " <td>154</td>\n", " <td>EXP</td>\n", " <td>Ethash</td>\n", " <td>21.0</td>\n", " <td>4.0</td>\n", " <td>4.0</td>\n", " <td>5102415</td>\n", " <td>642576567203.0</td>\n", " <td>684339046338.546021</td>\n", " <td>30598884152</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$129,565,766.10</td>\n", " <td>48.26317</td>\n", " <td>45.32597</td>\n", " <td>0.00005454</td>\n", " <td>0.00005122</td>\n", " <td>37</td>\n", " <td>33</td>\n", " <td>False</td>\n", " <td>1627292204</td>\n", " </tr>\n", " <tr>\n", " <th>Ubiq</th>\n", " <td>173</td>\n", " <td>UBQ</td>\n", " <td>Ubqhash</td>\n", " <td>86.0</td>\n", " <td>4</td>\n", " <td>4.0</td>\n", " <td>1626142</td>\n", " <td>4170063115422.0</td>\n", " <td>3635417312734.600098</td>\n", " <td>48489105993</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$9,233,704.72</td>\n", " <td>7.44506</td>\n", " <td>8.53765</td>\n", " <td>0.00004221</td>\n", " <td>0.00004841</td>\n", " <td>29</td>\n", " <td>31</td>\n", " <td>False</td>\n", " <td>1627292056</td>\n", " </tr>\n", " <tr>\n", " <th>Aeternity</th>\n", " <td>297</td>\n", " <td>AE</td>\n", " <td>CuckooCycle</td>\n", " <td>188.0</td>\n", " <td>102.465</td>\n", " <td>102.465</td>\n", " <td>463356</td>\n", " <td>2898600.0</td>\n", " <td>3722921.078431</td>\n", " <td>15418</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$33,734,193.69</td>\n", " <td>23.81091</td>\n", " <td>18.54082</td>\n", " <td>0.00006167</td>\n", " <td>0.00004802</td>\n", " <td>42</td>\n", " <td>31</td>\n", " <td>False</td>\n", " <td>1627292199</td>\n", " </tr>\n", " <tr>\n", " <th>HavenProtocol</th>\n", " <td>279</td>\n", " <td>XHV</td>\n", " <td>CryptoNightHaven</td>\n", " <td>118.0</td>\n", " <td>6.112961</td>\n", " <td>6.117155</td>\n", " <td>890712</td>\n", " <td>2813042911.0</td>\n", " <td>2556668152.72009</td>\n", " <td>23839346</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$44,175,999.47</td>\n", " <td>0.54067</td>\n", " <td>0.59528</td>\n", " <td>0.00004354</td>\n", " <td>0.00004794</td>\n", " <td>29</td>\n", " <td>31</td>\n", " <td>False</td>\n", " <td>1627292206</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-CuckooCycle</th>\n", " <td>37</td>\n", " <td>NICEHASH</td>\n", " <td>CuckooCycle</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>9644</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.00005</td>\n", " <td>0.00005</td>\n", " <td>0.00005138</td>\n", " <td>0.00004775</td>\n", " <td>35</td>\n", " <td>30</td>\n", " <td>False</td>\n", " <td>1627292171</td>\n", " </tr>\n", " <tr>\n", " <th>Zero</th>\n", " <td>210</td>\n", " <td>ZER</td>\n", " <td>EquihashZero</td>\n", " <td>119.0</td>\n", " <td>3.645</td>\n", " <td>3.645</td>\n", " <td>1164557</td>\n", " <td>34222.953153</td>\n", " <td>30146.166764</td>\n", " <td>7189</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$1,074,392.52</td>\n", " <td>15.36998</td>\n", " <td>17.43484</td>\n", " <td>0.00004204</td>\n", " <td>0.00004768</td>\n", " <td>28</td>\n", " <td>30</td>\n", " <td>False</td>\n", " <td>1627292204</td>\n", " </tr>\n", " <tr>\n", " <th>Flux</th>\n", " <td>287</td>\n", " <td>FLUX</td>\n", " <td>ZelHash</td>\n", " <td>120.0</td>\n", " <td>37.5</td>\n", " <td>37.5</td>\n", " <td>911630</td>\n", " <td>1196.042275</td>\n", " <td>997.789653</td>\n", " <td>81649</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>13.88144</td>\n", " <td>16.63787</td>\n", " <td>0.00003948</td>\n", " <td>0.00004732</td>\n", " <td>27</td>\n", " <td>30</td>\n", " <td>False</td>\n", " <td>1627292179</td>\n", " </tr>\n", " <tr>\n", " <th>Bloc</th>\n", " <td>312</td>\n", " <td>BLOC</td>\n", " <td>CryptoNightHaven</td>\n", " <td>161.0</td>\n", " <td>14.5531</td>\n", " <td>14.557264</td>\n", " <td>814279</td>\n", " <td>25202823.0</td>\n", " <td>14390111.786046</td>\n", " <td>156539</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$72,617,981.00</td>\n", " <td>141.08961</td>\n", " <td>243.86454</td>\n", " <td>0.00002681</td>\n", " <td>0.00004633</td>\n", " <td>18</td>\n", " <td>29</td>\n", " <td>False</td>\n", " <td>1627291572</td>\n", " </tr>\n", " <tr>\n", " <th>Vidulum</th>\n", " <td>331</td>\n", " <td>VDL</td>\n", " <td>EquihashZero</td>\n", " <td>59.0</td>\n", " <td>4.8</td>\n", " <td>4.8</td>\n", " <td>1426054</td>\n", " <td>24.615641</td>\n", " <td>25.183505</td>\n", " <td>3417</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$150,544.48</td>\n", " <td>85.32943</td>\n", " <td>83.42817</td>\n", " <td>0.00004693</td>\n", " <td>0.00004589</td>\n", " <td>32</td>\n", " <td>29</td>\n", " <td>False</td>\n", " <td>1627291863</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-NeoScrypt</th>\n", " <td>3</td>\n", " <td>NICEHASH</td>\n", " <td>NeoScrypt</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>312284715</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.00005</td>\n", " <td>0.00004</td>\n", " <td>0.00004993</td>\n", " <td>0.00004499</td>\n", " <td>34</td>\n", " <td>29</td>\n", " <td>False</td>\n", " <td>1627292170</td>\n", " </tr>\n", " <tr>\n", " <th>Tent</th>\n", " <td>288</td>\n", " <td>TENT</td>\n", " <td>Zhash</td>\n", " <td>60.0</td>\n", " <td>6.0</td>\n", " <td>6.0</td>\n", " <td>1870076</td>\n", " <td>65.492704</td>\n", " <td>73.596902</td>\n", " <td>8941</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$1,152,893.21</td>\n", " <td>60.44684</td>\n", " <td>53.83215</td>\n", " <td>0.00004896</td>\n", " <td>0.0000436</td>\n", " <td>33</td>\n", " <td>28</td>\n", " <td>False</td>\n", " <td>1627292204</td>\n", " </tr>\n", " <tr>\n", " <th>Trezarcoin</th>\n", " <td>215</td>\n", " <td>TZC</td>\n", " <td>NeoScrypt</td>\n", " <td>60.0</td>\n", " <td>50.0</td>\n", " <td>50.0</td>\n", " <td>1946415</td>\n", " <td>2.300207</td>\n", " <td>1.84018</td>\n", " <td>164655253</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$300,024.29</td>\n", " <td>1059.86734</td>\n", " <td>1319.9669</td>\n", " <td>0.00003392</td>\n", " <td>0.00004224</td>\n", " <td>23</td>\n", " <td>27</td>\n", " <td>False</td>\n", " <td>1627291591</td>\n", " </tr>\n", " <tr>\n", " <th>Grin-CT32</th>\n", " <td>324</td>\n", " <td>GRIN</td>\n", " <td>Cuckatoo32</td>\n", " <td>59.0</td>\n", " <td>60.0</td>\n", " <td>60.0</td>\n", " <td>1322822</td>\n", " <td>431974.819336</td>\n", " <td>428844.260112</td>\n", " <td>7321</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$22,777,841.86</td>\n", " <td>5.47196</td>\n", " <td>5.5119</td>\n", " <td>0.00004109</td>\n", " <td>0.00004139</td>\n", " <td>28</td>\n", " <td>26</td>\n", " <td>False</td>\n", " <td>1627291961</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-Cuckatoo32</th>\n", " <td>43</td>\n", " <td>NICEHASH</td>\n", " <td>Cuckatoo32</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>83</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.00004</td>\n", " <td>0.00004</td>\n", " <td>0.00004112</td>\n", " <td>0.00004105</td>\n", " <td>28</td>\n", " <td>26</td>\n", " <td>False</td>\n", " <td>1627292172</td>\n", " </tr>\n", " <tr>\n", " <th>BitcoinGold</th>\n", " <td>214</td>\n", " <td>BTG</td>\n", " <td>Zhash</td>\n", " <td>608.0</td>\n", " <td>6.25</td>\n", " <td>6.25</td>\n", " <td>696462</td>\n", " <td>119790.235511</td>\n", " <td>127361.970656</td>\n", " <td>1614015</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$828,694,896.73</td>\n", " <td>0.03467</td>\n", " <td>0.03261</td>\n", " <td>0.00004292</td>\n", " <td>0.00004037</td>\n", " <td>29</td>\n", " <td>26</td>\n", " <td>False</td>\n", " <td>1627292176</td>\n", " </tr>\n", " <tr>\n", " <th>BitcoinZ</th>\n", " <td>207</td>\n", " <td>BTCZ</td>\n", " <td>Zhash</td>\n", " <td>158.0</td>\n", " <td>11875.0</td>\n", " <td>11875.0</td>\n", " <td>788235</td>\n", " <td>1566.478823</td>\n", " <td>1820.172908</td>\n", " <td>81218</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$3,392,156.81</td>\n", " <td>5033.11316</td>\n", " <td>4332.07031</td>\n", " <td>0.0000453</td>\n", " <td>0.00003899</td>\n", " <td>31</td>\n", " <td>25</td>\n", " <td>False</td>\n", " <td>1627292173</td>\n", " </tr>\n", " <tr>\n", " <th>Feathercoin</th>\n", " <td>8</td>\n", " <td>FTC</td>\n", " <td>NeoScrypt</td>\n", " <td>62.0</td>\n", " <td>40.0</td>\n", " <td>40.0</td>\n", " <td>3767674</td>\n", " <td>35.736795</td>\n", " <td>27.397637</td>\n", " <td>2475618796</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$4,883,143.71</td>\n", " <td>55.33527</td>\n", " <td>72.15615</td>\n", " <td>0.00002988</td>\n", " <td>0.00003896</td>\n", " <td>20</td>\n", " <td>25</td>\n", " <td>False</td>\n", " <td>1627292208</td>\n", " </tr>\n", " <tr>\n", " <th>01coin</th>\n", " <td>338</td>\n", " <td>ZOC</td>\n", " <td>NeoScrypt</td>\n", " <td>178.0</td>\n", " <td>10.013</td>\n", " <td>10.013</td>\n", " <td>633498</td>\n", " <td>0.447182</td>\n", " <td>0.524247</td>\n", " <td>10790072</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$27,263.26</td>\n", " <td>902.34953</td>\n", " <td>791.29929</td>\n", " <td>0.00004241</td>\n", " <td>0.00003719</td>\n", " <td>29</td>\n", " <td>24</td>\n", " <td>False</td>\n", " <td>1627292202</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-Zhash</th>\n", " <td>30</td>\n", " <td>NICEHASH</td>\n", " <td>Zhash</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>899298</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.00004</td>\n", " <td>0.00004</td>\n", " <td>0.00003953</td>\n", " <td>0.00003544</td>\n", " <td>27</td>\n", " <td>23</td>\n", " <td>False</td>\n", " <td>1627292170</td>\n", " </tr>\n", " <tr>\n", " <th>Firo</th>\n", " <td>175</td>\n", " <td>FIRO</td>\n", " <td>MTP</td>\n", " <td>294.0</td>\n", " <td>6.25</td>\n", " <td>6.25</td>\n", " <td>392654</td>\n", " <td>848.9626</td>\n", " <td>850.416009</td>\n", " <td>12402267355</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$59,849,970.78</td>\n", " <td>0.26654</td>\n", " <td>0.26608</td>\n", " <td>0.00003444</td>\n", " <td>0.00003438</td>\n", " <td>23</td>\n", " <td>22</td>\n", " <td>False</td>\n", " <td>1627291327</td>\n", " </tr>\n", " <tr>\n", " <th>EtherGem</th>\n", " <td>307</td>\n", " <td>EGEM</td>\n", " <td>Ethash</td>\n", " <td>12.2182</td>\n", " <td>0.96</td>\n", " <td>0.96</td>\n", " <td>8356163</td>\n", " <td>79199619278.0</td>\n", " <td>83704614175.145203</td>\n", " <td>6482102050</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$253,179.10</td>\n", " <td>92.96425</td>\n", " <td>88.02577</td>\n", " <td>0.00003161</td>\n", " <td>0.00002993</td>\n", " <td>21</td>\n", " <td>19</td>\n", " <td>True</td>\n", " <td>1627217681</td>\n", " </tr>\n", " <tr>\n", " <th>Lethean</th>\n", " <td>296</td>\n", " <td>LTHN</td>\n", " <td>CryptoNightR</td>\n", " <td>121.0</td>\n", " <td>286.3094</td>\n", " <td>285.957914</td>\n", " <td>1009298</td>\n", " <td>70846751.0</td>\n", " <td>72689643.489655</td>\n", " <td>585510</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$912,449.18</td>\n", " <td>865.73654</td>\n", " <td>842.84224</td>\n", " <td>0.00002597</td>\n", " <td>0.00002529</td>\n", " <td>18</td>\n", " <td>16</td>\n", " <td>False</td>\n", " <td>1627292207</td>\n", " </tr>\n", " <tr>\n", " <th>Aion</th>\n", " <td>272</td>\n", " <td>AION</td>\n", " <td>Equihash (210,9)</td>\n", " <td>10.0</td>\n", " <td>4.5</td>\n", " <td>4.5</td>\n", " <td>9372646</td>\n", " <td>11026447.0</td>\n", " <td>7099082.232092</td>\n", " <td>1102644</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$60,771,822.25</td>\n", " <td>4.52101</td>\n", " <td>7.02113</td>\n", " <td>0.00001456</td>\n", " <td>0.00002261</td>\n", " <td>10</td>\n", " <td>14</td>\n", " <td>False</td>\n", " <td>1627292172</td>\n", " </tr>\n", " <tr>\n", " <th>Masari</th>\n", " <td>273</td>\n", " <td>MSR</td>\n", " <td>CryptoNightFastV2</td>\n", " <td>60.0</td>\n", " <td>2.553643</td>\n", " <td>2.550966</td>\n", " <td>1660692</td>\n", " <td>37884617.0</td>\n", " <td>46908357.788396</td>\n", " <td>631410</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$572,346.06</td>\n", " <td>28.60388</td>\n", " <td>23.11172</td>\n", " <td>0.00002746</td>\n", " <td>0.00002219</td>\n", " <td>19</td>\n", " <td>14</td>\n", " <td>False</td>\n", " <td>1627292198</td>\n", " </tr>\n", " <tr>\n", " <th>BitCash</th>\n", " <td>304</td>\n", " <td>BITC</td>\n", " <td>X25X</td>\n", " <td>63.0</td>\n", " <td>7.2</td>\n", " <td>7.2</td>\n", " <td>1476243</td>\n", " <td>3.555432</td>\n", " <td>2.782599</td>\n", " <td>242388318</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$244,780.88</td>\n", " <td>100.40485</td>\n", " <td>127.9298</td>\n", " <td>0.00001707</td>\n", " <td>0.00002175</td>\n", " <td>12</td>\n", " <td>14</td>\n", " <td>False</td>\n", " <td>1627292175</td>\n", " </tr>\n", " <tr>\n", " <th>Conflux</th>\n", " <td>337</td>\n", " <td>CFX</td>\n", " <td>Octopus</td>\n", " <td>1.1277</td>\n", " <td>1.999361</td>\n", " <td>1.967899</td>\n", " <td>20400360</td>\n", " <td>770006537031.0</td>\n", " <td>685971412845.644043</td>\n", " <td>682811507520</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$194,627,132.23</td>\n", " <td>3.29776</td>\n", " <td>3.64349</td>\n", " <td>0.00001954</td>\n", " <td>0.00002159</td>\n", " <td>13</td>\n", " <td>14</td>\n", " <td>False</td>\n", " <td>1627292178</td>\n", " </tr>\n", " <tr>\n", " <th>Sinovate</th>\n", " <td>277</td>\n", " <td>SIN</td>\n", " <td>X25X</td>\n", " <td>120.0</td>\n", " <td>12.47</td>\n", " <td>12.47</td>\n", " <td>725212</td>\n", " <td>3.947548</td>\n", " <td>3.279857</td>\n", " <td>141288241</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$2,790,398.46</td>\n", " <td>155.49095</td>\n", " <td>186.48725</td>\n", " <td>0.0000171</td>\n", " <td>0.00002051</td>\n", " <td>12</td>\n", " <td>13</td>\n", " <td>False</td>\n", " <td>1627292201</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-Octopus</th>\n", " <td>47</td>\n", " <td>NICEHASH</td>\n", " <td>Octopus</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>215916442292</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.00002</td>\n", " <td>0.00002</td>\n", " <td>0.00001747</td>\n", " <td>0.00002031</td>\n", " <td>12</td>\n", " <td>13</td>\n", " <td>False</td>\n", " <td>1627292172</td>\n", " </tr>\n", " <tr>\n", " <th>Metaverse</th>\n", " <td>209</td>\n", " <td>ETP</td>\n", " <td>Ethash</td>\n", " <td>22.0</td>\n", " <td>1.496842</td>\n", " <td>1.496842</td>\n", " <td>5458716</td>\n", " <td>2263956656970.0</td>\n", " <td>2255124435492.990234</td>\n", " <td>102907120771</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$10,078,100.62</td>\n", " <td>5.1367</td>\n", " <td>5.1568</td>\n", " <td>0.00001721</td>\n", " <td>0.00001728</td>\n", " <td>12</td>\n", " <td>11</td>\n", " <td>False</td>\n", " <td>1627292174</td>\n", " </tr>\n", " <tr>\n", " <th>Sumokoin</th>\n", " <td>196</td>\n", " <td>SUMO</td>\n", " <td>CryptoNightR</td>\n", " <td>244.0</td>\n", " <td>97.92</td>\n", " <td>97.92</td>\n", " <td>571278</td>\n", " <td>2135705498.0</td>\n", " <td>2211163946.89139</td>\n", " <td>8752891</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$1,717,573.44</td>\n", " <td>9.86097</td>\n", " <td>9.52454</td>\n", " <td>0.00001607</td>\n", " <td>0.00001553</td>\n", " <td>11</td>\n", " <td>10</td>\n", " <td>False</td>\n", " <td>1627291856</td>\n", " </tr>\n", " <tr>\n", " <th>GoByte</th>\n", " <td>225</td>\n", " <td>GBX</td>\n", " <td>NeoScrypt</td>\n", " <td>157.0</td>\n", " <td>3.119531</td>\n", " <td>3.119531</td>\n", " <td>736470</td>\n", " <td>15.653347</td>\n", " <td>12.629793</td>\n", " <td>428220470</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$42,424,188.90</td>\n", " <td>9.80581</td>\n", " <td>12.13671</td>\n", " <td>0.00001088</td>\n", " <td>0.00001347</td>\n", " <td>7</td>\n", " <td>9</td>\n", " <td>False</td>\n", " <td>1627292087</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-CryptoNightR</th>\n", " <td>35</td>\n", " <td>NICEHASH</td>\n", " <td>CryptoNightR</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>60400</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.00001</td>\n", " <td>0.00001</td>\n", " <td>0.000011</td>\n", " <td>0.00001104</td>\n", " <td>7</td>\n", " <td>7</td>\n", " <td>False</td>\n", " <td>1627292170</td>\n", " </tr>\n", " <tr>\n", " <th>EtherSocial</th>\n", " <td>320</td>\n", " <td>ESN</td>\n", " <td>Ethash</td>\n", " <td>231.0</td>\n", " <td>5.0</td>\n", " <td>5.0</td>\n", " <td>6303850</td>\n", " <td>181402256387.0</td>\n", " <td>181321688841.308014</td>\n", " <td>785291153</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>192.29223</td>\n", " <td>192.36888</td>\n", " <td>0.00000846</td>\n", " <td>0.00000846</td>\n", " <td>6</td>\n", " <td>5</td>\n", " <td>False</td>\n", " <td>1627291115</td>\n", " </tr>\n", " <tr>\n", " <th>Quantum R L</th>\n", " <td>263</td>\n", " <td>QRL</td>\n", " <td>RandomX</td>\n", " <td>59.0</td>\n", " <td>5.075868</td>\n", " <td>5.079434</td>\n", " <td>1628964</td>\n", " <td>1633495689.0</td>\n", " <td>1602637132.85417</td>\n", " <td>27686367</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$17,539,125.31</td>\n", " <td>0.37853</td>\n", " <td>0.38609</td>\n", " <td>0.00000233</td>\n", " <td>0.00000238</td>\n", " <td>2</td>\n", " <td>2</td>\n", " <td>False</td>\n", " <td>1627292201</td>\n", " </tr>\n", " <tr>\n", " <th>Monero</th>\n", " <td>101</td>\n", " <td>XMR</td>\n", " <td>RandomX</td>\n", " <td>114.0</td>\n", " <td>0.929053</td>\n", " <td>0.933171</td>\n", " <td>2413140</td>\n", " <td>314861350457.0</td>\n", " <td>301820852181.968018</td>\n", " <td>2761941670</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$4,115,214,305.07</td>\n", " <td>0.00036</td>\n", " <td>0.00038</td>\n", " <td>0.00000215</td>\n", " <td>0.00000226</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>False</td>\n", " <td>1627292097</td>\n", " </tr>\n", " <tr>\n", " <th>Nicehash-RandomX</th>\n", " <td>40</td>\n", " <td>NICEHASH</td>\n", " <td>RandomX</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>0</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>261028802</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$0.00</td>\n", " <td>0.0</td>\n", " <td>0.0</td>\n", " <td>0.00000193</td>\n", " <td>0.00000207</td>\n", " <td>1</td>\n", " <td>1</td>\n", " <td>False</td>\n", " <td>1627292171</td>\n", " </tr>\n", " <tr>\n", " <th>Sero</th>\n", " <td>328</td>\n", " <td>SERO</td>\n", " <td>ProgPow</td>\n", " <td>15.2975</td>\n", " <td>4.4</td>\n", " <td>4.4</td>\n", " <td>5960422</td>\n", " <td>479672956275.0</td>\n", " <td>516002695291.625977</td>\n", " <td>31356297190</td>\n", " <td>...</td>\n", " <td>BTC</td>\n", " <td>$69,274.07</td>\n", " <td>17.19375</td>\n", " <td>15.98422</td>\n", " <td>0.0000001</td>\n", " <td>0.00000009</td>\n", " <td>0</td>\n", " <td>0</td>\n", " <td>False</td>\n", " <td>1627292207</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "<p>60 rows × 23 columns</p>\n", "</div>" ], "text/plain": [ " id tag algorithm block_time \\\n", "Ethereum 151 ETH Ethash 13.4798 \n", "Nicehash-Ethash 15 NICEHASH Ethash 1 \n", "Ravencoin 234 RVN KawPow 60.0 \n", "EthereumClassic 162 ETC Etchash 13.317 \n", "Nicehash-KawPow 45 NICEHASH KawPow 1 \n", "Ergo 340 ERG Autolykos 105.0 \n", "Nicehash-Autolykos 48 NICEHASH Autolykos 1 \n", "Nicehash-BeamV3 38 NICEHASH BeamHashIII 1 \n", "Beam 294 BEAM BeamHashIII 59.0 \n", "Zano 330 ZANO ProgPowZ 120.0 \n", "MWC-CT31 323 MWC Cuckatoo31 61.0 \n", "Vertcoin 5 VTC Verthash 158.0 \n", "Conceal 305 CCX CryptoNightGPU 121.0 \n", "Callisto 283 CLO Ethash 13.0073 \n", "Etho 306 ETHO Ethash 12.7992 \n", "Ellaism 221 ELLA Ethash 12.8755 \n", "Equilibria 341 XEQ CryptoNightGPU 120.0 \n", "Ryo 260 RYO CryptoNightGPU 252.0 \n", "Zclassic 167 ZCL EquihashZero 75.0 \n", "Nicehash-Cuckatoo31 36 NICEHASH Cuckatoo31 1 \n", "BitTubeCash 256 TUBE CuckooCycle 14.9817 \n", "QuarkChain 318 QKC Ethash 9.8222 \n", "Swap 301 XWP Cuckaroo29s 14.8486 \n", "Expanse 154 EXP Ethash 21.0 \n", "Ubiq 173 UBQ Ubqhash 86.0 \n", "Aeternity 297 AE CuckooCycle 188.0 \n", "HavenProtocol 279 XHV CryptoNightHaven 118.0 \n", "Nicehash-CuckooCycle 37 NICEHASH CuckooCycle 1 \n", "Zero 210 ZER EquihashZero 119.0 \n", "Flux 287 FLUX ZelHash 120.0 \n", "Bloc 312 BLOC CryptoNightHaven 161.0 \n", "Vidulum 331 VDL EquihashZero 59.0 \n", "Nicehash-NeoScrypt 3 NICEHASH NeoScrypt 1 \n", "Tent 288 TENT Zhash 60.0 \n", "Trezarcoin 215 TZC NeoScrypt 60.0 \n", "Grin-CT32 324 GRIN Cuckatoo32 59.0 \n", "Nicehash-Cuckatoo32 43 NICEHASH Cuckatoo32 1 \n", "BitcoinGold 214 BTG Zhash 608.0 \n", "BitcoinZ 207 BTCZ Zhash 158.0 \n", "Feathercoin 8 FTC NeoScrypt 62.0 \n", "01coin 338 ZOC NeoScrypt 178.0 \n", "Nicehash-Zhash 30 NICEHASH Zhash 1 \n", "Firo 175 FIRO MTP 294.0 \n", "EtherGem 307 EGEM Ethash 12.2182 \n", "Lethean 296 LTHN CryptoNightR 121.0 \n", "Aion 272 AION Equihash (210,9) 10.0 \n", "Masari 273 MSR CryptoNightFastV2 60.0 \n", "BitCash 304 BITC X25X 63.0 \n", "Conflux 337 CFX Octopus 1.1277 \n", "Sinovate 277 SIN X25X 120.0 \n", "Nicehash-Octopus 47 NICEHASH Octopus 1 \n", "Metaverse 209 ETP Ethash 22.0 \n", "Sumokoin 196 SUMO CryptoNightR 244.0 \n", "GoByte 225 GBX NeoScrypt 157.0 \n", "Nicehash-CryptoNightR 35 NICEHASH CryptoNightR 1 \n", "EtherSocial 320 ESN Ethash 231.0 \n", "Quantum R L 263 QRL RandomX 59.0 \n", "Monero 101 XMR RandomX 114.0 \n", "Nicehash-RandomX 40 NICEHASH RandomX 1 \n", "Sero 328 SERO ProgPow 15.2975 \n", "\n", " block_reward block_reward24 last_block \\\n", "Ethereum 2.260425 2.3347 12901084 \n", "Nicehash-Ethash 1 1 0 \n", "Ravencoin 5000.0 5000.0 1857852 \n", "EthereumClassic 3.104 3.104 13204651 \n", "Nicehash-KawPow 1 1 0 \n", "Ergo 67.5011 67.513111 540443 \n", "Nicehash-Autolykos 1 1 0 \n", "Nicehash-BeamV3 1 1 0 \n", "Beam 40.0 40.0 1341352 \n", "Zano 1.0 1.0 1160601 \n", "MWC-CT31 0.25 0.25 876024 \n", "Vertcoin 25.0 25.0 1602140 \n", "Conceal 6.001 5.999228 818553 \n", "Callisto 38.7 38.7 7956356 \n", "Etho 0.6 0.6 7581046 \n", "Ellaism 4.91 4.91 9211704 \n", "Equilibria 5.0437 5.0615 619595 \n", "Ryo 46.66499 46.66499 538596 \n", "Zclassic 0.78125 0.78125 1248599 \n", "Nicehash-Cuckatoo31 1 1 0 \n", "BitTubeCash 8.448794 8.45019 2075704 \n", "QuarkChain 2.5168 2.5168 7218217 \n", "Swap 1.142724 1.143606 5652858 \n", "Expanse 4.0 4.0 5102415 \n", "Ubiq 4 4.0 1626142 \n", "Aeternity 102.465 102.465 463356 \n", "HavenProtocol 6.112961 6.117155 890712 \n", "Nicehash-CuckooCycle 1 1 0 \n", "Zero 3.645 3.645 1164557 \n", "Flux 37.5 37.5 911630 \n", "Bloc 14.5531 14.557264 814279 \n", "Vidulum 4.8 4.8 1426054 \n", "Nicehash-NeoScrypt 1 1 0 \n", "Tent 6.0 6.0 1870076 \n", "Trezarcoin 50.0 50.0 1946415 \n", "Grin-CT32 60.0 60.0 1322822 \n", "Nicehash-Cuckatoo32 1 1 0 \n", "BitcoinGold 6.25 6.25 696462 \n", "BitcoinZ 11875.0 11875.0 788235 \n", "Feathercoin 40.0 40.0 3767674 \n", "01coin 10.013 10.013 633498 \n", "Nicehash-Zhash 1 1 0 \n", "Firo 6.25 6.25 392654 \n", "EtherGem 0.96 0.96 8356163 \n", "Lethean 286.3094 285.957914 1009298 \n", "Aion 4.5 4.5 9372646 \n", "Masari 2.553643 2.550966 1660692 \n", "BitCash 7.2 7.2 1476243 \n", "Conflux 1.999361 1.967899 20400360 \n", "Sinovate 12.47 12.47 725212 \n", "Nicehash-Octopus 1 1 0 \n", "Metaverse 1.496842 1.496842 5458716 \n", "Sumokoin 97.92 97.92 571278 \n", "GoByte 3.119531 3.119531 736470 \n", "Nicehash-CryptoNightR 1 1 0 \n", "EtherSocial 5.0 5.0 6303850 \n", "Quantum R L 5.075868 5.079434 1628964 \n", "Monero 0.929053 0.933171 2413140 \n", "Nicehash-RandomX 1 1 0 \n", "Sero 4.4 4.4 5960422 \n", "\n", " difficulty difficulty24 \\\n", "Ethereum 7273646078428641.0 7076358552259530.0 \n", "Nicehash-Ethash 1 1 \n", "Ravencoin 56167.469987 53525.37911 \n", "EthereumClassic 290156745728694.0 293242458022672.0 \n", "Nicehash-KawPow 1 1 \n", "Ergo 1371769604669440.0 1371968739771980.0 \n", "Nicehash-Autolykos 1 1 \n", "Nicehash-BeamV3 1 1 \n", "Beam 22980426.0 23232901.0 \n", "Zano 1830746768596.0 1839327492207.370117 \n", "MWC-CT31 53593.323085 57726.62278 \n", "Vertcoin 101.877361 104.269716 \n", "Conceal 124000000.0 130435520.361991 \n", "Callisto 875415217139.0 879842922524.890991 \n", "Etho 158048902578.0 140749881723.44101 \n", "Ellaism 28634176473.0 27555046069.033901 \n", "Equilibria 39169759.0 34396891.01182 \n", "Ryo 133342445.0 131620441.48659 \n", "Zclassic 15.629829 22.029539 \n", "Nicehash-Cuckatoo31 1 1 \n", "BitTubeCash 12440.0 12521.977401 \n", "QuarkChain 54707293815.0 57436193671.363503 \n", "Swap 10240.0 8738.214689 \n", "Expanse 642576567203.0 684339046338.546021 \n", "Ubiq 4170063115422.0 3635417312734.600098 \n", "Aeternity 2898600.0 3722921.078431 \n", "HavenProtocol 2813042911.0 2556668152.72009 \n", "Nicehash-CuckooCycle 1 1 \n", "Zero 34222.953153 30146.166764 \n", "Flux 1196.042275 997.789653 \n", "Bloc 25202823.0 14390111.786046 \n", "Vidulum 24.615641 25.183505 \n", "Nicehash-NeoScrypt 1 1 \n", "Tent 65.492704 73.596902 \n", "Trezarcoin 2.300207 1.84018 \n", "Grin-CT32 431974.819336 428844.260112 \n", "Nicehash-Cuckatoo32 1 1 \n", "BitcoinGold 119790.235511 127361.970656 \n", "BitcoinZ 1566.478823 1820.172908 \n", "Feathercoin 35.736795 27.397637 \n", "01coin 0.447182 0.524247 \n", "Nicehash-Zhash 1 1 \n", "Firo 848.9626 850.416009 \n", "EtherGem 79199619278.0 83704614175.145203 \n", "Lethean 70846751.0 72689643.489655 \n", "Aion 11026447.0 7099082.232092 \n", "Masari 37884617.0 46908357.788396 \n", "BitCash 3.555432 2.782599 \n", "Conflux 770006537031.0 685971412845.644043 \n", "Sinovate 3.947548 3.279857 \n", "Nicehash-Octopus 1 1 \n", "Metaverse 2263956656970.0 2255124435492.990234 \n", "Sumokoin 2135705498.0 2211163946.89139 \n", "GoByte 15.653347 12.629793 \n", "Nicehash-CryptoNightR 1 1 \n", "EtherSocial 181402256387.0 181321688841.308014 \n", "Quantum R L 1633495689.0 1602637132.85417 \n", "Monero 314861350457.0 301820852181.968018 \n", "Nicehash-RandomX 1 1 \n", "Sero 479672956275.0 516002695291.625977 \n", "\n", " nethash ... exchange_rate_curr \\\n", "Ethereum 539595993889274 ... BTC \n", "Nicehash-Ethash 39427305768412 ... BTC \n", "Ravencoin 4020624111529 ... BTC \n", "EthereumClassic 21788446776953 ... BTC \n", "Nicehash-KawPow 1230064447958 ... BTC \n", "Ergo 13064472425423 ... BTC \n", "Nicehash-Autolykos 688443473515 ... BTC \n", "Nicehash-BeamV3 179602 ... BTC \n", "Beam 389498 ... BTC \n", "Zano 15256223071 ... BTC \n", "MWC-CT31 878 ... BTC \n", "Vertcoin 2769366659 ... BTC \n", "Conceal 1024793 ... BTC \n", "Callisto 67301839516 ... BTC \n", "Etho 12348342285 ... BTC \n", "Ellaism 2223927340 ... BTC \n", "Equilibria 326414 ... BTC \n", "Ryo 529136 ... BTC \n", "Zclassic 1707 ... BTC \n", "Nicehash-Cuckatoo31 679 ... BTC \n", "BitTubeCash 830 ... BTC \n", "QuarkChain 11139519418 ... BTC \n", "Swap 689 ... BTC \n", "Expanse 30598884152 ... BTC \n", "Ubiq 48489105993 ... BTC \n", "Aeternity 15418 ... BTC \n", "HavenProtocol 23839346 ... BTC \n", "Nicehash-CuckooCycle 9644 ... BTC \n", "Zero 7189 ... BTC \n", "Flux 81649 ... BTC \n", "Bloc 156539 ... BTC \n", "Vidulum 3417 ... BTC \n", "Nicehash-NeoScrypt 312284715 ... BTC \n", "Tent 8941 ... BTC \n", "Trezarcoin 164655253 ... BTC \n", "Grin-CT32 7321 ... BTC \n", "Nicehash-Cuckatoo32 83 ... BTC \n", "BitcoinGold 1614015 ... BTC \n", "BitcoinZ 81218 ... BTC \n", "Feathercoin 2475618796 ... BTC \n", "01coin 10790072 ... BTC \n", "Nicehash-Zhash 899298 ... BTC \n", "Firo 12402267355 ... BTC \n", "EtherGem 6482102050 ... BTC \n", "Lethean 585510 ... BTC \n", "Aion 1102644 ... BTC \n", "Masari 631410 ... BTC \n", "BitCash 242388318 ... BTC \n", "Conflux 682811507520 ... BTC \n", "Sinovate 141288241 ... BTC \n", "Nicehash-Octopus 215916442292 ... BTC \n", "Metaverse 102907120771 ... BTC \n", "Sumokoin 8752891 ... BTC \n", "GoByte 428220470 ... BTC \n", "Nicehash-CryptoNightR 60400 ... BTC \n", "EtherSocial 785291153 ... BTC \n", "Quantum R L 27686367 ... BTC \n", "Monero 2761941670 ... BTC \n", "Nicehash-RandomX 261028802 ... BTC \n", "Sero 31356297190 ... BTC \n", "\n", " market_cap estimated_rewards \\\n", "Ethereum $273,549,686,296.98 0.00242 \n", "Nicehash-Ethash $0.00 0.00014 \n", "Ravencoin $575,087,421.86 69.83923 \n", "EthereumClassic $6,825,911,540.32 0.08318 \n", "Nicehash-KawPow $0.00 0.0001 \n", "Ergo $179,648,660.18 0.75252 \n", "Nicehash-Autolykos $0.00 0.0001 \n", "Nicehash-BeamV3 $0.00 0.00008 \n", "Beam $44,355,522.29 6.64263 \n", "Zano $32,526,862.54 1.19557 \n", "MWC-CT31 $53,762,312.38 0.65158 \n", "Vertcoin $29,984,251.73 6.18738 \n", "Conceal $3,389,442.81 9.5123 \n", "Callisto $19,571,090.56 343.29917 \n", "Etho $4,385,146.47 29.30638 \n", "Ellaism $90,455.97 1281.51568 \n", "Equilibria $1,815,204.92 25.18976 \n", "Ryo $1,087,327.89 68.64423 \n", "Zclassic $1,433,373.75 21.60995 \n", "Nicehash-Cuckatoo31 $0.00 0.00006 \n", "BitTubeCash $1,812,409.12 408.09813 \n", "QuarkChain $97,841,744.93 150.81826 \n", "Swap $365,267.78 68.70318 \n", "Expanse $129,565,766.10 48.26317 \n", "Ubiq $9,233,704.72 7.44506 \n", "Aeternity $33,734,193.69 23.81091 \n", "HavenProtocol $44,175,999.47 0.54067 \n", "Nicehash-CuckooCycle $0.00 0.00005 \n", "Zero $1,074,392.52 15.36998 \n", "Flux $0.00 13.88144 \n", "Bloc $72,617,981.00 141.08961 \n", "Vidulum $150,544.48 85.32943 \n", "Nicehash-NeoScrypt $0.00 0.00005 \n", "Tent $1,152,893.21 60.44684 \n", "Trezarcoin $300,024.29 1059.86734 \n", "Grin-CT32 $22,777,841.86 5.47196 \n", "Nicehash-Cuckatoo32 $0.00 0.00004 \n", "BitcoinGold $828,694,896.73 0.03467 \n", "BitcoinZ $3,392,156.81 5033.11316 \n", "Feathercoin $4,883,143.71 55.33527 \n", "01coin $27,263.26 902.34953 \n", "Nicehash-Zhash $0.00 0.00004 \n", "Firo $59,849,970.78 0.26654 \n", "EtherGem $253,179.10 92.96425 \n", "Lethean $912,449.18 865.73654 \n", "Aion $60,771,822.25 4.52101 \n", "Masari $572,346.06 28.60388 \n", "BitCash $244,780.88 100.40485 \n", "Conflux $194,627,132.23 3.29776 \n", "Sinovate $2,790,398.46 155.49095 \n", "Nicehash-Octopus $0.00 0.00002 \n", "Metaverse $10,078,100.62 5.1367 \n", "Sumokoin $1,717,573.44 9.86097 \n", "GoByte $42,424,188.90 9.80581 \n", "Nicehash-CryptoNightR $0.00 0.00001 \n", "EtherSocial $0.00 192.29223 \n", "Quantum R L $17,539,125.31 0.37853 \n", "Monero $4,115,214,305.07 0.00036 \n", "Nicehash-RandomX $0.00 0.0 \n", "Sero $69,274.07 17.19375 \n", "\n", " estimated_rewards24 btc_revenue btc_revenue24 \\\n", "Ethereum 0.00257 0.00014802 0.00015715 \n", "Nicehash-Ethash 0.00015 0.00014273 0.00015189 \n", "Ravencoin 73.28656 0.00011314 0.00011872 \n", "EthereumClassic 0.08231 0.00011538 0.00011416 \n", "Nicehash-KawPow 0.00011 0.00010202 0.00011193 \n", "Ergo 0.75254 0.00011049 0.0001105 \n", "Nicehash-Autolykos 0.0001 0.00009724 0.00010153 \n", "Nicehash-BeamV3 0.00009 0.00008274 0.00008515 \n", "Beam 6.57046 0.00008283 0.00008193 \n", "Zano 1.19 0.00007966 0.00007929 \n", "MWC-CT31 0.60502 0.00008519 0.00007911 \n", "Vertcoin 6.04548 0.00007951 0.00007768 \n", "Conceal 9.04129 0.00007229 0.00006871 \n", "Callisto 341.57385 0.00006827 0.00006792 \n", "Etho 32.87907 0.00005949 0.00006674 \n", "Ellaism 1329.6779 0.00006408 0.00006648 \n", "Equilibria 28.75861 0.00005819 0.00006643 \n", "Ryo 69.53841 0.00006247 0.00006328 \n", "Zclassic 15.43983 0.00008752 0.00006253 \n", "Nicehash-Cuckatoo31 0.00006 0.00005922 0.00006138 \n", "BitTubeCash 405.51814 0.00006121 0.00006083 \n", "QuarkChain 143.70733 0.00006033 0.00005748 \n", "Swap 80.43012 0.00004809 0.0000563 \n", "Expanse 45.32597 0.00005454 0.00005122 \n", "Ubiq 8.53765 0.00004221 0.00004841 \n", "Aeternity 18.54082 0.00006167 0.00004802 \n", "HavenProtocol 0.59528 0.00004354 0.00004794 \n", "Nicehash-CuckooCycle 0.00005 0.00005138 0.00004775 \n", "Zero 17.43484 0.00004204 0.00004768 \n", "Flux 16.63787 0.00003948 0.00004732 \n", "Bloc 243.86454 0.00002681 0.00004633 \n", "Vidulum 83.42817 0.00004693 0.00004589 \n", "Nicehash-NeoScrypt 0.00004 0.00004993 0.00004499 \n", "Tent 53.83215 0.00004896 0.0000436 \n", "Trezarcoin 1319.9669 0.00003392 0.00004224 \n", "Grin-CT32 5.5119 0.00004109 0.00004139 \n", "Nicehash-Cuckatoo32 0.00004 0.00004112 0.00004105 \n", "BitcoinGold 0.03261 0.00004292 0.00004037 \n", "BitcoinZ 4332.07031 0.0000453 0.00003899 \n", "Feathercoin 72.15615 0.00002988 0.00003896 \n", "01coin 791.29929 0.00004241 0.00003719 \n", "Nicehash-Zhash 0.00004 0.00003953 0.00003544 \n", "Firo 0.26608 0.00003444 0.00003438 \n", "EtherGem 88.02577 0.00003161 0.00002993 \n", "Lethean 842.84224 0.00002597 0.00002529 \n", "Aion 7.02113 0.00001456 0.00002261 \n", "Masari 23.11172 0.00002746 0.00002219 \n", "BitCash 127.9298 0.00001707 0.00002175 \n", "Conflux 3.64349 0.00001954 0.00002159 \n", "Sinovate 186.48725 0.0000171 0.00002051 \n", "Nicehash-Octopus 0.00002 0.00001747 0.00002031 \n", "Metaverse 5.1568 0.00001721 0.00001728 \n", "Sumokoin 9.52454 0.00001607 0.00001553 \n", "GoByte 12.13671 0.00001088 0.00001347 \n", "Nicehash-CryptoNightR 0.00001 0.000011 0.00001104 \n", "EtherSocial 192.36888 0.00000846 0.00000846 \n", "Quantum R L 0.38609 0.00000233 0.00000238 \n", "Monero 0.00038 0.00000215 0.00000226 \n", "Nicehash-RandomX 0.0 0.00000193 0.00000207 \n", "Sero 15.98422 0.0000001 0.00000009 \n", "\n", " profitability profitability24 lagging timestamp \n", "Ethereum 100 100 False 1627292203 \n", "Nicehash-Ethash 96 97 False 1627292172 \n", "Ravencoin 76 76 False 1627292169 \n", "EthereumClassic 78 73 False 1627292176 \n", "Nicehash-KawPow 69 71 False 1627292170 \n", "Ergo 75 70 False 1627292206 \n", "Nicehash-Autolykos 66 65 False 1627292172 \n", "Nicehash-BeamV3 56 54 False 1627292171 \n", "Beam 56 52 False 1627292202 \n", "Zano 54 50 False 1627292060 \n", "MWC-CT31 58 50 False 1627292175 \n", "Vertcoin 54 49 False 1627292180 \n", "Conceal 49 44 False 1627292201 \n", "Callisto 46 43 False 1627292175 \n", "Etho 40 42 False 1627292176 \n", "Ellaism 43 42 False 1627292175 \n", "Equilibria 39 42 False 1627291943 \n", "Ryo 42 40 False 1627292086 \n", "Zclassic 59 40 False 1627291094 \n", "Nicehash-Cuckatoo31 40 39 False 1627292171 \n", "BitTubeCash 41 39 False 1627292207 \n", "QuarkChain 41 37 False 1627292178 \n", "Swap 32 36 False 1627292175 \n", "Expanse 37 33 False 1627292204 \n", "Ubiq 29 31 False 1627292056 \n", "Aeternity 42 31 False 1627292199 \n", "HavenProtocol 29 31 False 1627292206 \n", "Nicehash-CuckooCycle 35 30 False 1627292171 \n", "Zero 28 30 False 1627292204 \n", "Flux 27 30 False 1627292179 \n", "Bloc 18 29 False 1627291572 \n", "Vidulum 32 29 False 1627291863 \n", "Nicehash-NeoScrypt 34 29 False 1627292170 \n", "Tent 33 28 False 1627292204 \n", "Trezarcoin 23 27 False 1627291591 \n", "Grin-CT32 28 26 False 1627291961 \n", "Nicehash-Cuckatoo32 28 26 False 1627292172 \n", "BitcoinGold 29 26 False 1627292176 \n", "BitcoinZ 31 25 False 1627292173 \n", "Feathercoin 20 25 False 1627292208 \n", "01coin 29 24 False 1627292202 \n", "Nicehash-Zhash 27 23 False 1627292170 \n", "Firo 23 22 False 1627291327 \n", "EtherGem 21 19 True 1627217681 \n", "Lethean 18 16 False 1627292207 \n", "Aion 10 14 False 1627292172 \n", "Masari 19 14 False 1627292198 \n", "BitCash 12 14 False 1627292175 \n", "Conflux 13 14 False 1627292178 \n", "Sinovate 12 13 False 1627292201 \n", "Nicehash-Octopus 12 13 False 1627292172 \n", "Metaverse 12 11 False 1627292174 \n", "Sumokoin 11 10 False 1627291856 \n", "GoByte 7 9 False 1627292087 \n", "Nicehash-CryptoNightR 7 7 False 1627292170 \n", "EtherSocial 6 5 False 1627291115 \n", "Quantum R L 2 2 False 1627292201 \n", "Monero 1 1 False 1627292097 \n", "Nicehash-RandomX 1 1 False 1627292171 \n", "Sero 0 0 False 1627292207 \n", "\n", "[60 rows x 23 columns]" ] }, "execution_count": 45, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#data with details on specific crypto - to utilize when visualizing \r\n", "def coin_info():\r\n", " url = requests.get('https://whattomine.com/coins.json')\r\n", " j = url.json()\r\n", " df = pd.DataFrame(j['coins'])\r\n", " coins = pd.Series(j['coins'].keys)\r\n", " df.rename(index=coins, inplace=True)\r\n", " return df.transpose()\r\n", "\r\n", "############ Function Call ############\r\n", "coin_info()" ] }, { "cell_type": "markdown", "metadata": { "id": "ezovwa1tp0we" }, "source": [ "## Additional Dataset Parsing/Cleaning Functions\n", "\n", "Write any supplemental (optional) functions here." ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/html": [ "<div>\n", "<style scoped>\n", " .dataframe tbody tr th:only-of-type {\n", " vertical-align: middle;\n", " }\n", "\n", " .dataframe tbody tr th {\n", " vertical-align: top;\n", " }\n", "\n", " .dataframe thead th {\n", " text-align: right;\n", " }\n", "</style>\n", "<table border=\"1\" class=\"dataframe\">\n", " <thead>\n", " <tr style=\"text-align: right;\">\n", " <th></th>\n", " <th>Timestamp</th>\n", " <th>hash-rate</th>\n", " </tr>\n", " </thead>\n", " <tbody>\n", " <tr>\n", " <th>0</th>\n", " <td>2020-07-15 00:00:00</td>\n", " <td>1.189935e+08</td>\n", " </tr>\n", " <tr>\n", " <th>1</th>\n", " <td>2020-07-16 00:00:00</td>\n", " <td>1.172690e+08</td>\n", " </tr>\n", " <tr>\n", " <th>2</th>\n", " <td>2020-07-17 00:00:00</td>\n", " <td>1.017481e+08</td>\n", " </tr>\n", " <tr>\n", " <th>3</th>\n", " <td>2020-07-18 00:00:00</td>\n", " <td>1.120953e+08</td>\n", " </tr>\n", " <tr>\n", " <th>4</th>\n", " <td>2020-07-19 00:00:00</td>\n", " <td>1.129576e+08</td>\n", " </tr>\n", " <tr>\n", " <th>...</th>\n", " <td>...</td>\n", " <td>...</td>\n", " </tr>\n", " <tr>\n", " <th>360</th>\n", " <td>2021-07-10 00:00:00</td>\n", " <td>1.149524e+08</td>\n", " </tr>\n", " <tr>\n", " <th>361</th>\n", " <td>2021-07-11 00:00:00</td>\n", " <td>8.924873e+07</td>\n", " </tr>\n", " <tr>\n", " <th>362</th>\n", " <td>2021-07-12 00:00:00</td>\n", " <td>8.996272e+07</td>\n", " </tr>\n", " <tr>\n", " <th>363</th>\n", " <td>2021-07-13 00:00:00</td>\n", " <td>9.710262e+07</td>\n", " </tr>\n", " <tr>\n", " <th>364</th>\n", " <td>2021-07-14 00:00:00</td>\n", " <td>1.213783e+08</td>\n", " </tr>\n", " </tbody>\n", "</table>\n", "<p>365 rows × 2 columns</p>\n", "</div>" ], "text/plain": [ " Timestamp hash-rate\n", "0 2020-07-15 00:00:00 1.189935e+08\n", "1 2020-07-16 00:00:00 1.172690e+08\n", "2 2020-07-17 00:00:00 1.017481e+08\n", "3 2020-07-18 00:00:00 1.120953e+08\n", "4 2020-07-19 00:00:00 1.129576e+08\n", ".. ... ...\n", "360 2021-07-10 00:00:00 1.149524e+08\n", "361 2021-07-11 00:00:00 8.924873e+07\n", "362 2021-07-12 00:00:00 8.996272e+07\n", "363 2021-07-13 00:00:00 9.710262e+07\n", "364 2021-07-14 00:00:00 1.213783e+08\n", "\n", "[365 rows x 2 columns]" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "def hash_history():\r\n", " path = \"data/blockchain-dot-com-hash-rate.json\"\r\n", " hashes = pd.read_csv(path)\r\n", " return hashes\r\n", "\r\n", "############ Function Call ############\r\n", "hash_history()" ] }, { "cell_type": "markdown", "metadata": { "id": "uttEYrm9US5s" }, "source": [ "# Inconsistencies\r\n", "For each inconsistency (NaN, null, duplicate values, empty strings, etc.) you discover in your datasets, write at least 2 sentences stating the significance, how you identified it, and how you handled it.\r\n", "\r\n", "1. In the html web scrape, some GPU names also had an asterisk associated with them. This made the data difficult to iterate through as the information I required did not have an even index pattern. I originally manually pulled out the names, until I realized the (*) was the issue and I removed them all at once. I could then find a pattern for indices and cut my code from 15 lines to 1.\r\n", " \r\n", "2. The coins json in web collection 2 had a nested dictionary that had to be flattened to the top to make one two-way table. Without this fix there was just one column of `'coins'` with json dictionary text inside\r\n", "\r\n", "3. The Global Power Plant Database had power generation data columns for a range of years as well as estimated genration columns for a smaller range of years. Different rows either had generation or estimated generation data, sometimes both, with nans in between. I created new average columns for both groups of generation data, and chose the larger or non empty one for each row to narrow it down to one average generation over a period of time per row.\r\n", "\r\n", "4. The power sources listed in the power plant generation database and the power plant emissions database were not the same. I renamed a source in the emissions table to match the same source in the generation table. I collapsed some power generation sources into an 'other' category that the emissions table had. I then filled in 0s in the combined table for any renewable sources that do not emit pollutants." ] } ], "metadata": { "colab": { "collapsed_sections": [], "name": "PhaseII.ipynb", "provenance": [] }, "interpreter": { "hash": "0635a69235b8be13852489ad251e8c349647cdc922a670444a76820170957137" }, "kernelspec": { "display_name": "Python 3.8.8 64-bit ('base': conda)", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.8" } }, "nbformat": 4, "nbformat_minor": 1}