In [29]:

    

import requests
import json
import pandas as pd
import datetime
import time
import pytz

ticker = 'SPXT Index'
end = datetime.datetime.now(tz=pytz.UTC)
end = end.replace(hour=0, minute=0, second=0, microsecond=0)
start = end - datetime.timedelta(days=40*365)
endStr = int(time.mktime(end.timetuple()))
startStr = int(time.mktime(start.timetuple()))
print('End date: ', end, endStr)
print('Start date: ', start, startStr)
url = 'http://192.168.5.9:9997/data/bbg/getAssetsHistoryStartEnd/["%s"]/[TOT_RETURN_INDEX_NET_DVDS]/%s/%s/USD' % (ticker, startStr, endStr)
print(url)

res = requests.get(url).json()


    

    




End date:  2018-06-27 00:00:00+00:00 1530057600
Start date:  1978-07-07 00:00:00+00:00 268617600
http://192.168.5.9:9997/data/bbg/getAssetsHistoryStartEnd/["SPXT Index"]/[TOT_RETURN_INDEX_NET_DVDS]/268617600/1530057600/USD

In [28]:

    

df = pd.DataFrame.from_dict(res['SPXT Index']['TOT_RETURN_INDEX_NET_DVDS'], orient='index')
df.index = pd.to_datetime(df.index, unit='s')
df = df.sort_index()
df.to_csv('./data.csv')


    

In [ ]: