import requests
from datetime import datetime as dt
from pprint import pprint as pp
def request_quandl(endpoint, **kwargs):
params = {'order': 'asc', 'returns': 'numpy', 'authtoken': 'YOUR_AUTH_TOKEN'}
params.update(kwargs)
r = requests.get('https://www.quandl.com/api/v3/datasets/%s/data.json' % endpoint, params=params).json()
df = {'datetime': [], 'Open': [], 'High': [], 'Low': [], 'Close': [], 'Volume': []}
i = 0
while i < len(r['dataset_data']['data']):
# df['datetime'].append(i)
# df['datetime'].append(r['dataset_data']['data'][i][0])
df['datetime'].append(dt.strptime(r['dataset_data']['data'][i][0], '%Y-%m-%d'))
df['Open'].append(float(r['dataset_data']['data'][i][1]))
df['High'].append(float(r['dataset_data']['data'][i][2]))
df['Low'].append(float(r['dataset_data']['data'][i][3]))
df['Close'].append(float(r['dataset_data']['data'][i][4]))
df['Volume'].append(int(r['dataset_data']['data'][i][5]))
i += 1
return df
df = request_quandl('BCHARTS/BITSTAMPUSD', collapse='daily')
print (len(df['Close']))
pp (df)