Still seeing the same issue on TypeError for barset.df

[sunjiawen]

File "/app/samplealgo/algo.py", line 50, in _get_prices 2019-01-31T17:02:13.116398+00:00 app[worker.1]: return barset.df 2019-01-31T17:02:13.116402+00:00 app[worker.1]: File "/app/.heroku/python/lib/python3.6/site-packages/alpaca_trade_api/entity.py", line 102, in df 2019-01-31T17:02:13.116581+00:00 app[worker.1]: df = bars.df.copy() 2019-01-31T17:02:13.116585+00:00 app[worker.1]: File "/app/.heroku/python/lib/python3.6/site-packages/alpaca_trade_api/entity.py", line 84, in df 2019-01-31T17:02:13.116746+00:00 app[worker.1]: df.index * 1e9, utc=True, 2019-01-31T17:02:13.116750+00:00 app[worker.1]: File "/app/.heroku/python/lib/python3.6/site-packages/pandas/core/ops.py", line 176, in invalid_op 2019-01-31T17:02:13.116959+00:00 app[worker.1]: "{typ}".format(name=name, typ=type(self).name)) 2019-01-31T17:02:13.116983+00:00 app[worker.1]: TypeError: cannot perform mul with this index type: Index

[sunjiawen]

Running locally and see this error:

File "main.py", line 5, in algo.main() File "/Users/jiawensun/Alpaca/samplealgo/algo.py", line 222, in main price_df = prices(Universe) File "/Users/jiawensun/Alpaca/samplealgo/algo.py", line 72, in prices return _get_prices(symbols, end_dt) File "/Users/jiawensun/Alpaca/samplealgo/algo.py", line 59, in _get_prices return barset.df File "/usr/local/lib/python3.7/site-packages/alpaca_trade_api/entity.py", line 107, in df df = bars.df.copy() File "/usr/local/lib/python3.7/site-packages/alpaca_trade_api/entity.py", line 85, in df df.index * 1e9, utc=True, File "/usr/local/lib/python3.7/site-packages/pandas/core/tools/datetimes.py", line 603, in to_datetime result = convert_listlike(arg, box, format) File "/usr/local/lib/python3.7/site-packages/pandas/core/tools/datetimes.py", line 223, in _convert_listlike_datetimes arg, _ = maybe_convert_dtype(arg, copy=False) File "/usr/local/lib/python3.7/site-packages/pandas/core/arrays/datetimes.py", line 1914, in maybe_convert_dtype data = data.astype(_NS_DTYPE) File "/usr/local/lib/python3.7/site-packages/pandas/core/indexes/numeric.py", line 330, in astype raise TypeError(msg) TypeError: Cannot convert Float64Index to dtype datetime64[ns]; integer values are required for conversion

[sunjiawen]

I fixed it myself by converting it to int64

        if not df.empty:
            df.index = pd.to_datetime(
                (df.index * 1e9).astype('int64'), utc=True,
            ).tz_convert(NY)

[tylerfloyd]

I fixed it myself by converting it to int64

        if not df.empty:
            df.index = pd.to_datetime(
                (df.index * 1e9).astype('int64'), utc=True,
            ).tz_convert(NY)

Where did you put this block of code? I am running into the same issue.

[cujo0072]

in the enity.py file. Make sure your running the latest alpaca-trade-api (0.24) on line 84: if not df.empty: df.index = pd.to_datetime( (df.index * 1e9).astype('int64'), utc=True, ).tz_convert(NY) else: df.index = pd.to_datetime( df.index, utc=True )

[davecramer]

Use api version 0.26