from IPython.display import HTML

!curl -o mtgoxUSD.csv http://api.bitcoincharts.com/v1/trades.csv?symbol=mtgoxUSD

!head mtgoxUSD.csv

import pandas as pd

df=pd.read_csv("mtgoxUSD.csv", 
               names=["unixtime", "price", "amount"], 
               header=None)

# Live-Abfrage
#df=pd.read_csv("http://api.bitcoincharts.com/v1/trades.csv?symbol=mtgoxUSD", 
#               names=["unixtime", "price", "amount"], 
#               header=None)

df

df.head()

import datetime

df["datetime"]=df["unixtime"].map(datetime.datetime.fromtimestamp)

df.head()

df.index

df["price"]

ts=df.set_index("datetime")

ts.head()

del ts["unixtime"]

ts.head()

ts.price

ts.price.describe()

%pylab inline

figsize(15,9)

ts.price.plot()

ts.price.plot()
pd.rolling_mean(ts.price, 1000).plot(style="r-")

ts.amount.plot()

ts.amount.describe()

ts["volume"]=ts["price"]*ts["amount"]

ts.volume.plot()

ts.volume.sum()

ts.volume.max()

ts.volume.idxmax()

per_hour = ts.resample("H", how="sum")
per_hour

per_hour.volume.plot(kind="bar")

!curl -o bitcoin_weighted_prices.json http://api.bitcoincharts.com/v1/weighted_prices.json

import json

!head bitcoin_weighted_prices.json

data=[json.loads(line) for line in open("bitcoin_weighted_prices.json")]

data

data[0]

wp=pd.DataFrame(data[0])
wp

wp[["CAD", "EUR"]].T

wp["datetime"]=wp.timestamp.apply(datetime.datetime.fromtimestamp)
del wp["timestamp"]

wp

wp.T

pd.DataFrame(wp.ix["24h", ["AUD", "EUR", "ILS"]]).T