alphaville76 / sharadar_db_bundle

10 stars 8 forks source link

sharadar-zipline ingest error #54

Open quant2008 opened 1 year ago

quant2008 commented 1 year ago

I am installing this package on wondows 10. when executeing: sharadar-zipline ingest I get error, could you help?: [2023-03-01 07:39:19.485540] INFO: zipline.data.bundles.core: Ingesting sharadar. logfiles: d:\1\log\sharadar-zipline_2023-03-01_0739.log [2023-03-01 07:39:19] INFO: Start ingesting SEP, SFP and SF1 data into C:\Users\Administrator/.zipline\data\sharadar\latest ... [2023-03-01 07:39:20] INFO: Start fetch date: 1990-01-02 Inserting price data... [####################################] 100% [2023-03-01 07:40:03] INFO: Creating dividends data... [2023-03-01 07:40:05] INFO: Creating splits data... [2023-03-01 07:40:06] INFO: Start writing 43 splits and 2526 dividends data... [2023-03-01 07:40:06] ERROR: Traceback (most recent call last): File "E:\anaconda3\envs\zip38\lib\site-packages\sharadar_db_bundle-2.0-py3.8.egg\sharadar\loaders\ingest_sharadar.py", line 349, in ingest _ingest(start_date, calendar) File "E:\anaconda3\envs\zip38\lib\site-packages\sharadar_db_bundle-2.0-py3.8.egg\sharadar\loaders\ingest_sharadar.py", line 224, in _ingest adjustment_writer.write(splits=splits_df, dividends=dividends_df) File "E:\anaconda3\envs\zip38\lib\site-packages\sharadar_db_bundle-2.0-py3.8.egg\sharadar\data\sql_lite_daily_pricing.py", line 327, in write self.write_frame('splits', splits) File "E:\anaconda3\envs\zip38\lib\site-packages\zipline\data\adjustments.py", line 444, in write_frame return self._write( File "E:\anaconda3\envs\zip38\lib\site-packages\sharadar_db_bundle-2.0-py3.8.egg\sharadar\data\sql_lite_daily_pricing.py", line 304, in _write raise TypeError( TypeError: Expected data of type <class 'numpy.integer'> for column 'effective_date', but got 'int64'.