Here is a snippet of my code.
df = eikon.get_timeseries(['AUD='],start_date='2000-12-31',end_date='2020-4-18',interval='daily',fields=['TIMESTAMP', 'VALUE', 'VOLUME', 'HIGH', 'LOW', 'OPEN', 'CLOSE'])
df.to_csv (r'D:\Data Science\export_dataframe.csv', index = False, header=True)
I am not able to retrieve a TIMESTAMP column.
File "C:/Users/Alex/.spyder-py3/sqllitedbtable.py", line 21, in <module>
Could you kindly assist?
@alexkohhj Hi thanks for your question. The reason for this is that the timestamp field (or datetime) is automatically returned as the index - not a regular column per se. Why don't you try:
Also I note in your export to csv file you have a parameter index=false - I think this should be true. I hope this can help.