Hey @Brian, starting today, I begin getting this error when collecting daily prices as I do every morning. This error is causing the entire job to fail. Any help/advice is appreciated; thanks!
2021-08-19 07:24:16 quantrocket.history: INFO [usstock-daily] Collecting US history from 2021-08 to present
2021-08-19 07:24:17 quantrocket.history: INFO [usstock-daily] Collecting updated US securities listings
2021-08-19 07:24:17 quantrocket.history: INFO [usstock-daily] Applying price adjustments for 82 securities
2021-08-19 07:24:17 quantrocket.history: ERROR Traceback (most recent call last):
2021-08-19 07:24:17 quantrocket.history: ERROR File "/opt/conda/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
2021-08-19 07:24:17 quantrocket.history: ERROR self.dialect.do_execute(
2021-08-19 07:24:17 quantrocket.history: ERROR File "/opt/conda/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
2021-08-19 07:24:17 quantrocket.history: ERROR cursor.execute(statement, parameters)
2021-08-19 07:24:17 quantrocket.history: ERROR sqlite3.OperationalError: no such table: Price
2021-08-19 07:24:17 quantrocket.history: ERROR
2021-08-19 07:24:17 quantrocket.history: ERROR The above exception was the direct cause of the following exception:
2021-08-19 07:24:17 quantrocket.history: ERROR
2021-08-19 07:24:17 quantrocket.history: ERROR Traceback (most recent call last):
2021-08-19 07:24:17 quantrocket.history: ERROR File "sym://qrocket_log_py", line 34, in wrapped
2021-08-19 07:24:17 quantrocket.history: ERROR File "sym://qrocket_mule_py", line 150, in mule_collect_other_vendor
2021-08-19 07:24:17 quantrocket.history: ERROR File "sym://qrocket_history_collect_usstock_collect_py", line 96, in collect
2021-08-19 07:24:17 quantrocket.history: ERROR File "sym://qrocket_history_collect_usstock_adjust_py", line 50, in adjust
2021-08-19 07:24:17 quantrocket.history: ERROR File "sym://qrocket_history_collect_usstock_adjust_py", line 169, in _adjust_sid
2021-08-19 07:24:17 quantrocket.history: ERROR File "/opt/conda/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 976, in execute
2021-08-19 07:24:17 quantrocket.history: ERROR return self._execute_text(object_, multiparams, params)
2021-08-19 07:24:17 quantrocket.history: ERROR File "/opt/conda/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1143, in _execute_text
2021-08-19 07:24:17 quantrocket.history: ERROR ret = self._execute_context(
2021-08-19 07:24:17 quantrocket.history: ERROR File "/opt/conda/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
2021-08-19 07:24:17 quantrocket.history: ERROR self._handle_dbapi_exception(
2021-08-19 07:24:17 quantrocket.history: ERROR File "/opt/conda/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1476, in _handle_dbapi_exception
2021-08-19 07:24:17 quantrocket.history: ERROR util.raise_from_cause(sqlalchemy_exception, exc_info)
2021-08-19 07:24:17 quantrocket.history: ERROR File "/opt/conda/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
2021-08-19 07:24:17 quantrocket.history: ERROR reraise(type(exception), exception, tb=exc_tb, cause=cause)
2021-08-19 07:24:17 quantrocket.history: ERROR File "/opt/conda/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
2021-08-19 07:24:17 quantrocket.history: ERROR raise value.with_traceback(tb)
2021-08-19 07:24:17 quantrocket.history: ERROR File "/opt/conda/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
2021-08-19 07:24:17 quantrocket.history: ERROR self.dialect.do_execute(
2021-08-19 07:24:17 quantrocket.history: ERROR File "/opt/conda/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 588, in do_execute
2021-08-19 07:24:17 quantrocket.history: ERROR cursor.execute(statement, parameters)
2021-08-19 07:24:17 quantrocket.history: ERROR sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: Price
2021-08-19 07:24:17 quantrocket.history: ERROR [SQL:
2021-08-19 07:24:17 quantrocket.history: ERROR UPDATE Price
2021-08-19 07:24:17 quantrocket.history: ERROR SET
2021-08-19 07:24:17 quantrocket.history: ERROR Open = UnadjOpen,
2021-08-19 07:24:17 quantrocket.history: ERROR High = UnadjHigh,
2021-08-19 07:24:17 quantrocket.history: ERROR Low = UnadjLow,
2021-08-19 07:24:17 quantrocket.history: ERROR Close = UnadjClose,
2021-08-19 07:24:17 quantrocket.history: ERROR Volume = UnadjVolume,
2021-08-19 07:24:17 quantrocket.history: ERROR Vwap = UnadjVwap
2021-08-19 07:24:17 quantrocket.history: ERROR WHERE Sid = ?
2021-08-19 07:24:17 quantrocket.history: ERROR ]
2021-08-19 07:24:17 quantrocket.history: ERROR [parameters: ('FIBBG000BB3080',)]
2021-08-19 07:24:17 quantrocket.history: ERROR (Background on this error at: http://sqlalche.me/e/e3q8)
2021-08-19 07:24:17 quantrocket.history: ERROR