Skip to content

Instantly share code, notes, and snippets.

@c0indev3l

c0indev3l/cryptocoincharts.ipynb

Created February 23, 2014 16:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save c0indev3l/9173307 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save c0indev3l/9173307 to your computer and use it in GitHub Desktop.
Download ZIP
IPython Notebook to get alt-coins prices from Cryptocoincharts (API v2)
Display the source blob
Display the rendered blob
Raw
cryptocoincharts.ipynb
{
"metadata": {
"name": ""
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "raw",
"metadata": {},
"source": [
"Python script to get data from Cryptocoincharts\n",
"http://www.cryptocoincharts.info/\n",
"\n",
"Download data (price, volume) of several alt-coins\n",
"Build DataFrame using Pandas\n",
"\n",
" Copyright (C) 2014 \"Working4coins\" <[email protected]>\n",
"\n",
" This program is free software: you can redistribute it and/or modify\n",
" it under the terms of the GNU General Public License as published by\n",
" the Free Software Foundation, either version 3 of the License, or\n",
" (at your option) any later version.\n",
"\n",
" This program is distributed in the hope that it will be useful,\n",
" but WITHOUT ANY WARRANTY; without even the implied warranty of\n",
" MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\n",
" GNU General Public License for more details.\n",
"\n",
" You should have received a copy of the GNU General Public License\n",
" along with this program. If not, see <http://www.gnu.org/licenses/>\n",
"\n",
"\n",
"I'm developer and I provide under free software license some softwares that can be useful\n",
"for crypto-currencies users/traders.\n",
"If you consider that what I'm doing for crypto-currency ecosystem is valuable\n",
"you can send me some crypto-coins.\n",
"\n",
"https://sites.google.com/site/working4coins/donate\n",
"\n",
"Requirements:\n",
" - Python http://www.python.org/\n",
" (if you are using hell OS called Windows maybe you should\n",
" use Enthought Python or Anaconda)\n",
" - pandas http://pandas.pydata.org/\n",
" - requests http://requests.readthedocs.org/\n",
" - requests_cache https://pypi.python.org/pypi/requests-cache\n",
"\n",
"$ pip install requests\n",
"$ pip install requests_cache\n",
"$ pip install pandas"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import requests\n",
"import requests_cache\n",
"expire_after = 30*60 # expire_after=delay_second or None\n",
"requests_cache.install_cache('req_cache', backend='sqlite', expire_after=expire_after)\n",
"import json\n",
"import pandas as pd\n",
"from StringIO import StringIO"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"url = \"http://www.cryptocoincharts.info/v2/api/listCoins\"\n",
"req = requests.get(url)\n",
"raw_data = req.content\n",
"io = StringIO(raw_data)\n",
"dfListCoins = pd.read_json(io)\n",
"dfListCoins = dfListCoins.set_index('id', verify_integrity=True)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 2
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfListCoins.dtypes"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 3,
"text": [
"name object\n",
"price_btc float64\n",
"volume_btc float64\n",
"website object\n",
"dtype: object"
]
}
],
"prompt_number": 3
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"dfListCoins['volume_rel_btc'] = dfListCoins['volume_btc'] / dfListCoins['volume_btc']['btc'] * 100.0\n",
"dfListCoins = dfListCoins.sort(['volume_btc'], ascending=[False])\n",
"dfListCoins"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>name</th>\n",
" <th>price_btc</th>\n",
" <th>volume_btc</th>\n",
" <th>website</th>\n",
" <th>volume_rel_btc</th>\n",
" </tr>\n",
" <tr>\n",
" <th>id</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>ltc</th>\n",
" <td> Litecoin</td>\n",
" <td> 2.551000e-02</td>\n",
" <td> 212976.449429</td>\n",
" <td> http://cur.lv/5rzqv</td>\n",
" <td> 110.362748</td>\n",
" </tr>\n",
" <tr>\n",
" <th>btc</th>\n",
" <td> Bitcoin</td>\n",
" <td> 1.000000e+00</td>\n",
" <td> 192978.566774</td>\n",
" <td> http://bitcoin.org</td>\n",
" <td> 100.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>nmc</th>\n",
" <td> Namecoin</td>\n",
" <td> 6.000000e-03</td>\n",
" <td> 1522.179911</td>\n",
" <td> </td>\n",
" <td> 0.788782</td>\n",
" </tr>\n",
" <tr>\n",
" <th>doge</th>\n",
" <td> DogeCoin</td>\n",
" <td> 1.940000e-06</td>\n",
" <td> 1449.119197</td>\n",
" <td> http://cur.lv/5rztu</td>\n",
" <td> 0.750922</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ppc</th>\n",
" <td> Peercoin</td>\n",
" <td> 6.440000e-03</td>\n",
" <td> 1256.592606</td>\n",
" <td> http://cur.lv/5rzp4</td>\n",
" <td> 0.651157</td>\n",
" </tr>\n",
" <tr>\n",
" <th>tips</th>\n",
" <td> Fedoracoin</td>\n",
" <td> 1.000000e-08</td>\n",
" <td> 583.083336</td>\n",
" <td> http://cur.lv/62fav</td>\n",
" <td> 0.302149</td>\n",
" </tr>\n",
" <tr>\n",
" <th>pts</th>\n",
" <td> ProtoShares</td>\n",
" <td> 2.610000e-02</td>\n",
" <td> 448.705689</td>\n",
" <td> http://cur.lv/5rztd</td>\n",
" <td> 0.232516</td>\n",
" </tr>\n",
" <tr>\n",
" <th>max</th>\n",
" <td> Maxcoin</td>\n",
" <td> 1.416000e-03</td>\n",
" <td> 416.801565</td>\n",
" <td> </td>\n",
" <td> 0.215983</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ifc</th>\n",
" <td> InfiniteCoin</td>\n",
" <td> 1.300000e-07</td>\n",
" <td> 300.517960</td>\n",
" <td> </td>\n",
" <td> 0.155726</td>\n",
" </tr>\n",
" <tr>\n",
" <th>nxt</th>\n",
" <td> Nxt</td>\n",
" <td> 8.558000e-05</td>\n",
" <td> 163.828995</td>\n",
" <td> http://cur.lv/5rzp0</td>\n",
" <td> 0.084895</td>\n",
" </tr>\n",
" <tr>\n",
" <th>xpm</th>\n",
" <td> PrimeCoin</td>\n",
" <td> 3.050000e-03</td>\n",
" <td> 157.026555</td>\n",
" <td> http://cur.lv/5rzt0</td>\n",
" <td> 0.081370</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mec</th>\n",
" <td> MegaCoin</td>\n",
" <td> 6.460000e-04</td>\n",
" <td> 139.499046</td>\n",
" <td> http://cur.lv/5rzsl</td>\n",
" <td> 0.072287</td>\n",
" </tr>\n",
" <tr>\n",
" <th>qrk</th>\n",
" <td> Quarkcoin</td>\n",
" <td> 1.010100e-04</td>\n",
" <td> 136.296261</td>\n",
" <td> http://cur.lv/5rzq3</td>\n",
" <td> 0.070628</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mcx</th>\n",
" <td> MCX</td>\n",
" <td> 2.510000e-01</td>\n",
" <td> 132.880822</td>\n",
" <td> http://cur.lv/5rzsn</td>\n",
" <td> 0.068858</td>\n",
" </tr>\n",
" <tr>\n",
" <th>vtc</th>\n",
" <td> VertCoin</td>\n",
" <td> 3.039910e-03</td>\n",
" <td> 115.764116</td>\n",
" <td> http://vertcoin.org</td>\n",
" <td> 0.059988</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ftc</th>\n",
" <td> Feathercoin</td>\n",
" <td> 4.400000e-04</td>\n",
" <td> 113.280785</td>\n",
" <td> </td>\n",
" <td> 0.058701</td>\n",
" </tr>\n",
" <tr>\n",
" <th>wdc</th>\n",
" <td> WorldCoin</td>\n",
" <td> 2.161200e-04</td>\n",
" <td> 87.291266</td>\n",
" <td> </td>\n",
" <td> 0.045234</td>\n",
" </tr>\n",
" <tr>\n",
" <th>nvc</th>\n",
" <td> Novacoin</td>\n",
" <td> 1.392000e-02</td>\n",
" <td> 81.348547</td>\n",
" <td> </td>\n",
" <td> 0.042154</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mxb</th>\n",
" <td> mcxBUX</td>\n",
" <td> 1.614030e-03</td>\n",
" <td> 78.293276</td>\n",
" <td> https://mcxnow.com?r=xchrix</td>\n",
" <td> 0.040571</td>\n",
" </tr>\n",
" <tr>\n",
" <th>drk</th>\n",
" <td> DRK</td>\n",
" <td> 1.820000e-03</td>\n",
" <td> 72.471068</td>\n",
" <td> </td>\n",
" <td> 0.037554</td>\n",
" </tr>\n",
" <tr>\n",
" <th>xcp</th>\n",
" <td> XCP</td>\n",
" <td> 1.286000e-02</td>\n",
" <td> 61.685476</td>\n",
" <td> </td>\n",
" <td> 0.031965</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mint</th>\n",
" <td> MINT</td>\n",
" <td> 1.500000e-07</td>\n",
" <td> 55.412148</td>\n",
" <td> </td>\n",
" <td> 0.028714</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mmc</th>\n",
" <td> MemoryCoin</td>\n",
" <td> 2.400200e-04</td>\n",
" <td> 49.521041</td>\n",
" <td> http://memorycoin.org</td>\n",
" <td> 0.025661</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mnc</th>\n",
" <td> Mincoin</td>\n",
" <td> 9.550000e-04</td>\n",
" <td> 45.853612</td>\n",
" <td> </td>\n",
" <td> 0.023761</td>\n",
" </tr>\n",
" <tr>\n",
" <th>uno</th>\n",
" <td> UNO</td>\n",
" <td> 1.121114e-02</td>\n",
" <td> 41.773707</td>\n",
" <td> </td>\n",
" <td> 0.021647</td>\n",
" </tr>\n",
" <tr>\n",
" <th>net</th>\n",
" <td> Netcoin</td>\n",
" <td> 1.170000e-05</td>\n",
" <td> 41.650709</td>\n",
" <td> http://netcoinfoundation.org/</td>\n",
" <td> 0.021583</td>\n",
" </tr>\n",
" <tr>\n",
" <th>dime</th>\n",
" <td> Dimecoin</td>\n",
" <td> 1.000000e-08</td>\n",
" <td> 39.978090</td>\n",
" <td> http://cur.lv/62f4x</td>\n",
" <td> 0.020716</td>\n",
" </tr>\n",
" <tr>\n",
" <th>karm</th>\n",
" <td> Karmacoin</td>\n",
" <td> 4.000000e-08</td>\n",
" <td> 39.178538</td>\n",
" <td> http://karmacoin.info/</td>\n",
" <td> 0.020302</td>\n",
" </tr>\n",
" <tr>\n",
" <th>tix</th>\n",
" <td> Tickets</td>\n",
" <td> 3.000000e-08</td>\n",
" <td> 39.012463</td>\n",
" <td> </td>\n",
" <td> 0.020216</td>\n",
" </tr>\n",
" <tr>\n",
" <th>moon</th>\n",
" <td> MoonCoin</td>\n",
" <td> 6.000000e-08</td>\n",
" <td> 33.775905</td>\n",
" <td> </td>\n",
" <td> 0.017502</td>\n",
" </tr>\n",
" <tr>\n",
" <th>dvc</th>\n",
" <td> Devcoin</td>\n",
" <td> 0.000000e+00</td>\n",
" <td> 33.516826</td>\n",
" <td> http://cur.lv/5rzqs</td>\n",
" <td> 0.017368</td>\n",
" </tr>\n",
" <tr>\n",
" <th>sll</th>\n",
" <td> SLL</td>\n",
" <td> 6.670000e-06</td>\n",
" <td> 32.790000</td>\n",
" <td> </td>\n",
" <td> 0.016992</td>\n",
" </tr>\n",
" <tr>\n",
" <th>meow</th>\n",
" <td> Kittehcoin</td>\n",
" <td> 2.300000e-07</td>\n",
" <td> 28.756995</td>\n",
" <td> </td>\n",
" <td> 0.014902</td>\n",
" </tr>\n",
" <tr>\n",
" <th>zet</th>\n",
" <td> ZetaCoin</td>\n",
" <td> 2.110000e-05</td>\n",
" <td> 27.109133</td>\n",
" <td> http://cur.lv/5rzoe</td>\n",
" <td> 0.014048</td>\n",
" </tr>\n",
" <tr>\n",
" <th>leaf</th>\n",
" <td> Leafcoin</td>\n",
" <td> 6.000000e-08</td>\n",
" <td> 20.909544</td>\n",
" <td> http://leafco.in/</td>\n",
" <td> 0.010835</td>\n",
" </tr>\n",
" <tr>\n",
" <th>lot</th>\n",
" <td> LottoCoin</td>\n",
" <td> 1.400000e-07</td>\n",
" <td> 20.871457</td>\n",
" <td> http://cur.lv/5rzq8</td>\n",
" <td> 0.010815</td>\n",
" </tr>\n",
" <tr>\n",
" <th>rdd</th>\n",
" <td> RDD</td>\n",
" <td> 8.000000e-08</td>\n",
" <td> 20.759707</td>\n",
" <td> </td>\n",
" <td> 0.010758</td>\n",
" </tr>\n",
" <tr>\n",
" <th>col</th>\n",
" <td> ColossusCoin</td>\n",
" <td> 1.000000e-08</td>\n",
" <td> 20.377550</td>\n",
" <td> http://cur.lv/5rzrc</td>\n",
" <td> 0.010559</td>\n",
" </tr>\n",
" <tr>\n",
" <th>frc</th>\n",
" <td> Freicoin</td>\n",
" <td> 8.800000e-05</td>\n",
" <td> 19.852297</td>\n",
" <td> </td>\n",
" <td> 0.010287</td>\n",
" </tr>\n",
" <tr>\n",
" <th>dgc</th>\n",
" <td> Digitalcoin</td>\n",
" <td> 2.535300e-04</td>\n",
" <td> 19.621004</td>\n",
" <td> </td>\n",
" <td> 0.010167</td>\n",
" </tr>\n",
" <tr>\n",
" <th>cnc</th>\n",
" <td> CHNCoin</td>\n",
" <td> 1.806000e-05</td>\n",
" <td> 18.765814</td>\n",
" <td> </td>\n",
" <td> 0.009724</td>\n",
" </tr>\n",
" <tr>\n",
" <th>bqc</th>\n",
" <td> BBQCoin</td>\n",
" <td> 3.230000e-05</td>\n",
" <td> 18.103385</td>\n",
" <td> </td>\n",
" <td> 0.009381</td>\n",
" </tr>\n",
" <tr>\n",
" <th>red</th>\n",
" <td> RedCoin</td>\n",
" <td> 1.411000e-05</td>\n",
" <td> 16.738749</td>\n",
" <td> http://cur.lv/5rzrn</td>\n",
" <td> 0.008674</td>\n",
" </tr>\n",
" <tr>\n",
" <th>anc</th>\n",
" <td> AnonCoin</td>\n",
" <td> 2.742700e-03</td>\n",
" <td> 16.366781</td>\n",
" <td> http://anoncoin.net</td>\n",
" <td> 0.008481</td>\n",
" </tr>\n",
" <tr>\n",
" <th>tag</th>\n",
" <td> TagCoin</td>\n",
" <td> 1.230300e-03</td>\n",
" <td> 16.134058</td>\n",
" <td> </td>\n",
" <td> 0.008361</td>\n",
" </tr>\n",
" <tr>\n",
" <th>eac</th>\n",
" <td> EarthCoin</td>\n",
" <td> 6.700000e-07</td>\n",
" <td> 15.940960</td>\n",
" <td> http://cur.lv/62f4i</td>\n",
" <td> 0.008260</td>\n",
" </tr>\n",
" <tr>\n",
" <th>msc</th>\n",
" <td> Mastercoin</td>\n",
" <td> 1.045000e-01</td>\n",
" <td> 15.163151</td>\n",
" <td> http://cur.lv/5rzpc</td>\n",
" <td> 0.007857</td>\n",
" </tr>\n",
" <tr>\n",
" <th>corg</th>\n",
" <td> CORG</td>\n",
" <td> 3.000000e-08</td>\n",
" <td> 15.000543</td>\n",
" <td> </td>\n",
" <td> 0.007773</td>\n",
" </tr>\n",
" <tr>\n",
" <th>wolf</th>\n",
" <td> WOLF</td>\n",
" <td> 1.300000e-03</td>\n",
" <td> 14.554187</td>\n",
" <td> </td>\n",
" <td> 0.007542</td>\n",
" </tr>\n",
" <tr>\n",
" <th>xrp</th>\n",
" <td> XRP</td>\n",
" <td> 2.571000e-05</td>\n",
" <td> 12.444169</td>\n",
" <td> </td>\n",
" <td> 0.006448</td>\n",
" </tr>\n",
" <tr>\n",
" <th>huc</th>\n",
" <td> HUC</td>\n",
" <td> 8.689000e-04</td>\n",
" <td> 11.815509</td>\n",
" <td> </td>\n",
" <td> 0.006123</td>\n",
" </tr>\n",
" <tr>\n",
" <th>cgb</th>\n",
" <td> CryptogenicBullion</td>\n",
" <td> 1.245650e-03</td>\n",
" <td> 11.033953</td>\n",
" <td> https://cryptogenicbullion.org</td>\n",
" <td> 0.005718</td>\n",
" </tr>\n",
" <tr>\n",
" <th>src</th>\n",
" <td> SecureCoin</td>\n",
" <td> 9.726800e-04</td>\n",
" <td> 10.296553</td>\n",
" <td> http://cur.lv/5rzsx</td>\n",
" <td> 0.005336</td>\n",
" </tr>\n",
" <tr>\n",
" <th>yac</th>\n",
" <td> Yacoin</td>\n",
" <td> 3.400000e-05</td>\n",
" <td> 9.813512</td>\n",
" <td> http://www.yacoin.org/</td>\n",
" <td> 0.005085</td>\n",
" </tr>\n",
" <tr>\n",
" <th>btb</th>\n",
" <td> BitBar</td>\n",
" <td> 8.000004e-02</td>\n",
" <td> 8.682549</td>\n",
" <td> </td>\n",
" <td> 0.004499</td>\n",
" </tr>\n",
" <tr>\n",
" <th>trc</th>\n",
" <td> Terracoin</td>\n",
" <td> 3.800000e-04</td>\n",
" <td> 8.339067</td>\n",
" <td> </td>\n",
" <td> 0.004321</td>\n",
" </tr>\n",
" <tr>\n",
" <th>cach</th>\n",
" <td> CACH</td>\n",
" <td> 4.303000e-03</td>\n",
" <td> 8.177253</td>\n",
" <td> </td>\n",
" <td> 0.004237</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ric</th>\n",
" <td> RIC</td>\n",
" <td> 8.000100e-04</td>\n",
" <td> 8.123345</td>\n",
" <td> </td>\n",
" <td> 0.004209</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mrc</th>\n",
" <td> MRC</td>\n",
" <td> 4.000000e-08</td>\n",
" <td> 7.991627</td>\n",
" <td> </td>\n",
" <td> 0.004141</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td> FourtyTwoCoin</td>\n",
" <td> 1.651000e+02</td>\n",
" <td> 7.812683</td>\n",
" <td> http://fourtytwo42.com/</td>\n",
" <td> 0.004048</td>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>217 rows \u00d7 5 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 4,
"text": [
" name price_btc volume_btc \\\n",
"id \n",
"ltc Litecoin 2.551000e-02 212976.449429 \n",
"btc Bitcoin 1.000000e+00 192978.566774 \n",
"nmc Namecoin 6.000000e-03 1522.179911 \n",
"doge DogeCoin 1.940000e-06 1449.119197 \n",
"ppc Peercoin 6.440000e-03 1256.592606 \n",
"tips Fedoracoin 1.000000e-08 583.083336 \n",
"pts ProtoShares 2.610000e-02 448.705689 \n",
"max Maxcoin 1.416000e-03 416.801565 \n",
"ifc InfiniteCoin 1.300000e-07 300.517960 \n",
"nxt Nxt 8.558000e-05 163.828995 \n",
"xpm PrimeCoin 3.050000e-03 157.026555 \n",
"mec MegaCoin 6.460000e-04 139.499046 \n",
"qrk Quarkcoin 1.010100e-04 136.296261 \n",
"mcx MCX 2.510000e-01 132.880822 \n",
"vtc VertCoin 3.039910e-03 115.764116 \n",
"ftc Feathercoin 4.400000e-04 113.280785 \n",
"wdc WorldCoin 2.161200e-04 87.291266 \n",
"nvc Novacoin 1.392000e-02 81.348547 \n",
"mxb mcxBUX 1.614030e-03 78.293276 \n",
"drk DRK 1.820000e-03 72.471068 \n",
"xcp XCP 1.286000e-02 61.685476 \n",
"mint MINT 1.500000e-07 55.412148 \n",
"mmc MemoryCoin 2.400200e-04 49.521041 \n",
"mnc Mincoin 9.550000e-04 45.853612 \n",
"uno UNO 1.121114e-02 41.773707 \n",
"net Netcoin 1.170000e-05 41.650709 \n",
"dime Dimecoin 1.000000e-08 39.978090 \n",
"karm Karmacoin 4.000000e-08 39.178538 \n",
"tix Tickets 3.000000e-08 39.012463 \n",
"moon MoonCoin 6.000000e-08 33.775905 \n",
"dvc Devcoin 0.000000e+00 33.516826 \n",
"sll SLL 6.670000e-06 32.790000 \n",
"meow Kittehcoin 2.300000e-07 28.756995 \n",
"zet ZetaCoin 2.110000e-05 27.109133 \n",
"leaf Leafcoin 6.000000e-08 20.909544 \n",
"lot LottoCoin 1.400000e-07 20.871457 \n",
"rdd RDD 8.000000e-08 20.759707 \n",
"col ColossusCoin 1.000000e-08 20.377550 \n",
"frc Freicoin 8.800000e-05 19.852297 \n",
"dgc Digitalcoin 2.535300e-04 19.621004 \n",
"cnc CHNCoin 1.806000e-05 18.765814 \n",
"bqc BBQCoin 3.230000e-05 18.103385 \n",
"red RedCoin 1.411000e-05 16.738749 \n",
"anc AnonCoin 2.742700e-03 16.366781 \n",
"tag TagCoin 1.230300e-03 16.134058 \n",
"eac EarthCoin 6.700000e-07 15.940960 \n",
"msc Mastercoin 1.045000e-01 15.163151 \n",
"corg CORG 3.000000e-08 15.000543 \n",
"wolf WOLF 1.300000e-03 14.554187 \n",
"xrp XRP 2.571000e-05 12.444169 \n",
"huc HUC 8.689000e-04 11.815509 \n",
"cgb CryptogenicBullion 1.245650e-03 11.033953 \n",
"src SecureCoin 9.726800e-04 10.296553 \n",
"yac Yacoin 3.400000e-05 9.813512 \n",
"btb BitBar 8.000004e-02 8.682549 \n",
"trc Terracoin 3.800000e-04 8.339067 \n",
"cach CACH 4.303000e-03 8.177253 \n",
"ric RIC 8.000100e-04 8.123345 \n",
"mrc MRC 4.000000e-08 7.991627 \n",
"42 FourtyTwoCoin 1.651000e+02 7.812683 \n",
" ... ... ... \n",
"\n",
" website volume_rel_btc \n",
"id \n",
"ltc http://cur.lv/5rzqv 110.362748 \n",
"btc http://bitcoin.org 100.000000 \n",
"nmc 0.788782 \n",
"doge http://cur.lv/5rztu 0.750922 \n",
"ppc http://cur.lv/5rzp4 0.651157 \n",
"tips http://cur.lv/62fav 0.302149 \n",
"pts http://cur.lv/5rztd 0.232516 \n",
"max 0.215983 \n",
"ifc 0.155726 \n",
"nxt http://cur.lv/5rzp0 0.084895 \n",
"xpm http://cur.lv/5rzt0 0.081370 \n",
"mec http://cur.lv/5rzsl 0.072287 \n",
"qrk http://cur.lv/5rzq3 0.070628 \n",
"mcx http://cur.lv/5rzsn 0.068858 \n",
"vtc http://vertcoin.org 0.059988 \n",
"ftc 0.058701 \n",
"wdc 0.045234 \n",
"nvc 0.042154 \n",
"mxb https://mcxnow.com?r=xchrix 0.040571 \n",
"drk 0.037554 \n",
"xcp 0.031965 \n",
"mint 0.028714 \n",
"mmc http://memorycoin.org 0.025661 \n",
"mnc 0.023761 \n",
"uno 0.021647 \n",
"net http://netcoinfoundation.org/ 0.021583 \n",
"dime http://cur.lv/62f4x 0.020716 \n",
"karm http://karmacoin.info/ 0.020302 \n",
"tix 0.020216 \n",
"moon 0.017502 \n",
"dvc http://cur.lv/5rzqs 0.017368 \n",
"sll 0.016992 \n",
"meow 0.014902 \n",
"zet http://cur.lv/5rzoe 0.014048 \n",
"leaf http://leafco.in/ 0.010835 \n",
"lot http://cur.lv/5rzq8 0.010815 \n",
"rdd 0.010758 \n",
"col http://cur.lv/5rzrc 0.010559 \n",
"frc 0.010287 \n",
"dgc 0.010167 \n",
"cnc 0.009724 \n",
"bqc 0.009381 \n",
"red http://cur.lv/5rzrn 0.008674 \n",
"anc http://anoncoin.net 0.008481 \n",
"tag 0.008361 \n",
"eac http://cur.lv/62f4i 0.008260 \n",
"msc http://cur.lv/5rzpc 0.007857 \n",
"corg 0.007773 \n",
"wolf 0.007542 \n",
"xrp 0.006448 \n",
"huc 0.006123 \n",
"cgb https://cryptogenicbullion.org 0.005718 \n",
"src http://cur.lv/5rzsx 0.005336 \n",
"yac http://www.yacoin.org/ 0.005085 \n",
"btb 0.004499 \n",
"trc 0.004321 \n",
"cach 0.004237 \n",
"ric 0.004209 \n",
"mrc 0.004141 \n",
"42 http://fourtytwo42.com/ 0.004048 \n",
" ... ... \n",
"\n",
"[217 rows x 5 columns]"
]
}
],
"prompt_number": 4
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"trading_pair = 'btc_usd'\n",
"url = \"http://www.cryptocoincharts.info/v2/api/tradingPair/{trading_pair}\".format(trading_pair=trading_pair)\n",
"req = requests.get(url)\n",
"raw_data = req.text\n",
"d = json.loads(raw_data)\n",
"d"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 5,
"text": [
"{u'best_market': u'bitstamp',\n",
" u'id': u'btc/usd',\n",
" u'latest_trade': u'2014-02-23 15:50:24',\n",
" u'price': u'627.01000000',\n",
" u'price_before_24h': u'577.95000000',\n",
" u'volume_btc': u'49727.1792239324',\n",
" u'volume_first': u'49727.1792239324',\n",
" u'volume_second': u'30338870.5247006'}"
]
}
],
"prompt_number": 5
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"url = \"http://www.cryptocoincharts.info/v2/api/tradingPairs\"\n",
"params = {\n",
" 'pairs': 'ltc_btc,nmc_usd,ppc_btc'\n",
"}\n",
"req = requests.post(url, params)\n",
"raw_data = req.content\n",
"io = StringIO(raw_data)\n",
"dfTradingPairs = pd.read_json(io)\n",
"dfTradingPairs"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>best_market</th>\n",
" <th>id</th>\n",
" <th>latest_trade</th>\n",
" <th>price</th>\n",
" <th>price_before_24h</th>\n",
" <th>volume_btc</th>\n",
" <th>volume_first</th>\n",
" <th>volume_second</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td> btc-e</td>\n",
" <td> ltc/btc</td>\n",
" <td> 2014-02-23 15:50:12</td>\n",
" <td> 0.02551</td>\n",
" <td> 0.02483</td>\n",
" <td> 2531.046723</td>\n",
" <td> 100482.242371</td>\n",
" <td> 2531.046723</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td> btc-e</td>\n",
" <td> nmc/usd</td>\n",
" <td> 2014-02-23 15:54:07</td>\n",
" <td> 3.69400</td>\n",
" <td> 3.22600</td>\n",
" <td> 1204.501006</td>\n",
" <td> 200750.167664</td>\n",
" <td> 714116.295459</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td> btc-e</td>\n",
" <td> ppc/btc</td>\n",
" <td> 2014-02-23 15:50:57</td>\n",
" <td> 0.00648</td>\n",
" <td> 0.00634</td>\n",
" <td> 384.744984</td>\n",
" <td> 60151.358932</td>\n",
" <td> 384.744984</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>3 rows \u00d7 8 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 6,
"text": [
" best_market id latest_trade price price_before_24h \\\n",
"0 btc-e ltc/btc 2014-02-23 15:50:12 0.02551 0.02483 \n",
"1 btc-e nmc/usd 2014-02-23 15:54:07 3.69400 3.22600 \n",
"2 btc-e ppc/btc 2014-02-23 15:50:57 0.00648 0.00634 \n",
"\n",
" volume_btc volume_first volume_second \n",
"0 2531.046723 100482.242371 2531.046723 \n",
"1 1204.501006 200750.167664 714116.295459 \n",
"2 384.744984 60151.358932 384.744984 \n",
"\n",
"[3 rows x 8 columns]"
]
}
],
"prompt_number": 6
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment