System Logs

Total: 14274 Errors Live
Clear
Time Level Category Symbol Source Message
02-19 14:00:42 ERROR error tiger_client Error getting bars for MCHP: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 14:00:42 ERROR error tiger_client Error getting bars for ORCL: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 14:00:42 ERROR error STX tiger_client Error getting bars for STX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 14:00:42 ERROR error tiger_client Error getting bars for WDC: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 14:00:42 ERROR error tiger_client Error getting bars for MRVL: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 14:00:42 ERROR error tiger_client Error getting bars for CRWV: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 14:00:30 ERROR order reconciliation_service Failed to fetch filled orders for real: code=1010 msg=biz param error(account 'test' is not authorized to the api user)
02-19 14:00:30 ERROR order tiger_client Error getting filled orders: code=1010 msg=biz param error(account 'test' is not authorized to the api user)
02-19 14:00:30 ERROR position tiger_client Error getting positions: code=1010 msg=biz param error(account 'test' is not authorized to the api user)
02-19 14:00:27 ERROR position tiger_client Error getting positions: code=1010 msg=biz param error(account 'test' is not authorized to the api user)
02-19 14:00:27 ERROR order reconciliation_service Failed to fetch filled orders for real: code=1010 msg=biz param error(account 'test' is not authorized to the api user)
02-19 14:00:27 ERROR order tiger_client Error getting filled orders: code=1010 msg=biz param error(account 'test' is not authorized to the api user)
02-19 14:00:13 ERROR order trailing_stop_scheduler Error in trailing stop fast check: (psycopg2.errors.UndefinedColumn) column trailing_stop_position.creation_source does not exist LINE 1: ...ighs AS trailing_stop_position_consecutive_highs, trailing_s... ^ [SQL: SELECT trailing_stop_position.id AS trailing_stop_position_id, trailing_stop_position.symbol AS trailing_stop_position_symbol, trailing_stop_position.account_type AS trailing_stop_position_account_type, trailing_stop_position.side AS trailing_stop_position_side, trailing_stop_position.entry_price AS trailing_stop_position_entry_price, trailing_stop_position.first_entry_price AS trailing_stop_position_first_entry_price, trailing_stop_position.quantity AS trailing_stop_position_quantity, trailing_stop_position.timeframe AS trailing_stop_position_timeframe, trailing_stop_position.trade_id AS trailing_stop_position_trade_id, trailing_stop_position.signal_stop_loss AS trailing_stop_position_signal_stop_loss, trailing_stop_position.fixed_stop_loss AS trailing_stop_position_fixed_stop_loss, trailing_stop_position.fixed_take_profit AS trailing_stop_position_fixed_take_profit, trailing_stop_position.stop_loss_order_id AS trailing_stop_position_stop_loss_order_id, trailing_stop_position.take_profit_order_id AS trailing_stop_position_take_profit_order_id, trailing_stop_position.highest_price AS trailing_stop_position_highest_price, trailing_stop_position.lowest_price AS trailing_stop_position_lowest_price, trailing_stop_position.current_trailing_stop AS trailing_stop_position_current_trailing_stop, trailing_stop_position.previous_trailing_stop AS trailing_stop_position_previous_trailing_stop, trailing_stop_position.current_atr AS trailing_stop_position_current_atr, trailing_stop_position.volatility_pct AS trailing_stop_position_volatility_pct, trailing_stop_position.profit_tier AS trailing_stop_position_profit_tier, trailing_stop_position.current_profit_pct AS trailing_stop_position_current_profit_pct, trai
02-19 14:00:09 ERROR order trailing_stop_scheduler Error in trailing stop fast check: (psycopg2.errors.UndefinedColumn) column trailing_stop_position.creation_source does not exist LINE 1: ...ighs AS trailing_stop_position_consecutive_highs, trailing_s... ^ [SQL: SELECT trailing_stop_position.id AS trailing_stop_position_id, trailing_stop_position.symbol AS trailing_stop_position_symbol, trailing_stop_position.account_type AS trailing_stop_position_account_type, trailing_stop_position.side AS trailing_stop_position_side, trailing_stop_position.entry_price AS trailing_stop_position_entry_price, trailing_stop_position.first_entry_price AS trailing_stop_position_first_entry_price, trailing_stop_position.quantity AS trailing_stop_position_quantity, trailing_stop_position.timeframe AS trailing_stop_position_timeframe, trailing_stop_position.trade_id AS trailing_stop_position_trade_id, trailing_stop_position.signal_stop_loss AS trailing_stop_position_signal_stop_loss, trailing_stop_position.fixed_stop_loss AS trailing_stop_position_fixed_stop_loss, trailing_stop_position.fixed_take_profit AS trailing_stop_position_fixed_take_profit, trailing_stop_position.stop_loss_order_id AS trailing_stop_position_stop_loss_order_id, trailing_stop_position.take_profit_order_id AS trailing_stop_position_take_profit_order_id, trailing_stop_position.highest_price AS trailing_stop_position_highest_price, trailing_stop_position.lowest_price AS trailing_stop_position_lowest_price, trailing_stop_position.current_trailing_stop AS trailing_stop_position_current_trailing_stop, trailing_stop_position.previous_trailing_stop AS trailing_stop_position_previous_trailing_stop, trailing_stop_position.current_atr AS trailing_stop_position_current_atr, trailing_stop_position.volatility_pct AS trailing_stop_position_volatility_pct, trailing_stop_position.profit_tier AS trailing_stop_position_profit_tier, trailing_stop_position.current_profit_pct AS trailing_stop_position_current_profit_pct, trai
02-19 13:59:41 ERROR error tiger_client Error getting bars for LRCX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for AMAT: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for ATOM: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for REMX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for EQIX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for CIEN: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for ANET: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error MSFT tiger_client Error getting bars for MSFT: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for LRCX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for META: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for AMAT: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error GOOG tiger_client Error getting bars for GOOG: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for ATOM: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for AMZN: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for REMX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error AAPL tiger_client Error getting bars for AAPL: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for TXN: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for EQIX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for TSLL: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for CIEN: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error SOXL tiger_client Error getting bars for SOXL: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for ANET: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error QCOM tiger_client Error getting bars for QCOM: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error MSFT tiger_client Error getting bars for MSFT: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for META: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error MU tiger_client Error getting bars for MU: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error GOOG tiger_client Error getting bars for GOOG: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for INTC: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for AMZN: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error AVGO tiger_client Error getting bars for AVGO: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error AAPL tiger_client Error getting bars for AAPL: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for ARM: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for TXN: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error AMD tiger_client Error getting bars for AMD: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for TSLL: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for USAR: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for ORCL: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for OKLO: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:41 ERROR error tiger_client Error getting bars for MSTR: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:40 ERROR error tiger_client Error getting bars for MP: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:59:31 ERROR order oca_service Error in rebuild_one_paper_oca: (psycopg2.errors.UndefinedColumn) column trailing_stop_position.creation_source does not exist LINE 1: ...ighs AS trailing_stop_position_consecutive_highs, trailing_s... ^ [SQL: SELECT trailing_stop_position.id AS trailing_stop_position_id, trailing_stop_position.symbol AS trailing_stop_position_symbol, trailing_stop_position.account_type AS trailing_stop_position_account_type, trailing_stop_position.side AS trailing_stop_position_side, trailing_stop_position.entry_price AS trailing_stop_position_entry_price, trailing_stop_position.first_entry_price AS trailing_stop_position_first_entry_price, trailing_stop_position.quantity AS trailing_stop_position_quantity, trailing_stop_position.timeframe AS trailing_stop_position_timeframe, trailing_stop_position.trade_id AS trailing_stop_position_trade_id, trailing_stop_position.signal_stop_loss AS trailing_stop_position_signal_stop_loss, trailing_stop_position.fixed_stop_loss AS trailing_stop_position_fixed_stop_loss, trailing_stop_position.fixed_take_profit AS trailing_stop_position_fixed_take_profit, trailing_stop_position.stop_loss_order_id AS trailing_stop_position_stop_loss_order_id, trailing_stop_position.take_profit_order_id AS trailing_stop_position_take_profit_order_id, trailing_stop_position.highest_price AS trailing_stop_position_highest_price, trailing_stop_position.lowest_price AS trailing_stop_position_lowest_price, trailing_stop_position.current_trailing_stop AS trailing_stop_position_current_trailing_stop, trailing_stop_position.previous_trailing_stop AS trailing_stop_position_previous_trailing_stop, trailing_stop_position.current_atr AS trailing_stop_position_current_atr, trailing_stop_position.volatility_pct AS trailing_stop_position_volatility_pct, trailing_stop_position.profit_tier AS trailing_stop_position_profit_tier, trailing_stop_position.current_profit_pct AS trailing_stop_position_current_profit_pct, trailin
02-19 13:59:31 ERROR order oca_service Error in expire_paper_oca_groups: (psycopg2.errors.UndefinedColumn) column oca_group.creation_source does not exist LINE 1: ...us_tp_order_id AS oca_group_previous_tp_order_id, oca_group.... ^ [SQL: SELECT oca_group.id AS oca_group_id_1, oca_group.oca_group_id AS oca_group_oca_group_id, oca_group.symbol AS oca_group_symbol, oca_group.account AS oca_group_account, oca_group.account_type AS oca_group_account_type, oca_group.side AS oca_group_side, oca_group.quantity AS oca_group_quantity, oca_group.entry_price AS oca_group_entry_price, oca_group.stop_order_id AS oca_group_stop_order_id, oca_group.take_profit_order_id AS oca_group_take_profit_order_id, oca_group.stop_price AS oca_group_stop_price, oca_group.stop_limit_price AS oca_group_stop_limit_price, oca_group.take_profit_price AS oca_group_take_profit_price, oca_group.time_in_force AS oca_group_time_in_force, oca_group.outside_rth_stop AS oca_group_outside_rth_stop, oca_group.outside_rth_tp AS oca_group_outside_rth_tp, oca_group.status AS oca_group_status, oca_group.triggered_order_id AS oca_group_triggered_order_id, oca_group.triggered_price AS oca_group_triggered_price, oca_group.triggered_at AS oca_group_triggered_at, oca_group.trade_id AS oca_group_trade_id, oca_group.trailing_stop_id AS oca_group_trailing_stop_id, oca_group.closed_position_id AS oca_group_closed_position_id, oca_group.rebuild_count AS oca_group_rebuild_count, oca_group.last_rebuild_at AS oca_group_last_rebuild_at, oca_group.previous_stop_order_id AS oca_group_previous_stop_order_id, oca_group.previous_tp_order_id AS oca_group_previous_tp_order_id, oca_group.creation_source AS oca_group_creation_source, oca_group.created_at AS oca_group_created_at, oca_group.updated_at AS oca_group_updated_at FROM oca_group WHERE oca_group.account_type = %(account_type_1)s AND oca_group.status = %(status_1)s] [parameters: {'account_type_1': 'paper', 'status_1': 'ACTIVE'}] (Background on this error
02-19 13:59:30 ERROR order trailing_stop_scheduler Error in trailing stop auto-check: (psycopg2.errors.UndefinedColumn) column trailing_stop_position.creation_source does not exist LINE 2: ...ighs AS trailing_stop_position_consecutive_highs, trailing_s... ^ [SQL: SELECT count(*) AS count_1 FROM (SELECT trailing_stop_position.id AS trailing_stop_position_id, trailing_stop_position.symbol AS trailing_stop_position_symbol, trailing_stop_position.account_type AS trailing_stop_position_account_type, trailing_stop_position.side AS trailing_stop_position_side, trailing_stop_position.entry_price AS trailing_stop_position_entry_price, trailing_stop_position.first_entry_price AS trailing_stop_position_first_entry_price, trailing_stop_position.quantity AS trailing_stop_position_quantity, trailing_stop_position.timeframe AS trailing_stop_position_timeframe, trailing_stop_position.trade_id AS trailing_stop_position_trade_id, trailing_stop_position.signal_stop_loss AS trailing_stop_position_signal_stop_loss, trailing_stop_position.fixed_stop_loss AS trailing_stop_position_fixed_stop_loss, trailing_stop_position.fixed_take_profit AS trailing_stop_position_fixed_take_profit, trailing_stop_position.stop_loss_order_id AS trailing_stop_position_stop_loss_order_id, trailing_stop_position.take_profit_order_id AS trailing_stop_position_take_profit_order_id, trailing_stop_position.highest_price AS trailing_stop_position_highest_price, trailing_stop_position.lowest_price AS trailing_stop_position_lowest_price, trailing_stop_position.current_trailing_stop AS trailing_stop_position_current_trailing_stop, trailing_stop_position.previous_trailing_stop AS trailing_stop_position_previous_trailing_stop, trailing_stop_position.current_atr AS trailing_stop_position_current_atr, trailing_stop_position.volatility_pct AS trailing_stop_position_volatility_pct, trailing_stop_position.profit_tier AS trailing_stop_position_profit_tier, trailing_stop_position.current_profit_pct AS trailing_stop
02-19 13:59:30 ERROR order trailing_stop_scheduler Error in trailing stop fast check: (psycopg2.errors.UndefinedColumn) column trailing_stop_position.creation_source does not exist LINE 1: ...ighs AS trailing_stop_position_consecutive_highs, trailing_s... ^ [SQL: SELECT trailing_stop_position.id AS trailing_stop_position_id, trailing_stop_position.symbol AS trailing_stop_position_symbol, trailing_stop_position.account_type AS trailing_stop_position_account_type, trailing_stop_position.side AS trailing_stop_position_side, trailing_stop_position.entry_price AS trailing_stop_position_entry_price, trailing_stop_position.first_entry_price AS trailing_stop_position_first_entry_price, trailing_stop_position.quantity AS trailing_stop_position_quantity, trailing_stop_position.timeframe AS trailing_stop_position_timeframe, trailing_stop_position.trade_id AS trailing_stop_position_trade_id, trailing_stop_position.signal_stop_loss AS trailing_stop_position_signal_stop_loss, trailing_stop_position.fixed_stop_loss AS trailing_stop_position_fixed_stop_loss, trailing_stop_position.fixed_take_profit AS trailing_stop_position_fixed_take_profit, trailing_stop_position.stop_loss_order_id AS trailing_stop_position_stop_loss_order_id, trailing_stop_position.take_profit_order_id AS trailing_stop_position_take_profit_order_id, trailing_stop_position.highest_price AS trailing_stop_position_highest_price, trailing_stop_position.lowest_price AS trailing_stop_position_lowest_price, trailing_stop_position.current_trailing_stop AS trailing_stop_position_current_trailing_stop, trailing_stop_position.previous_trailing_stop AS trailing_stop_position_previous_trailing_stop, trailing_stop_position.current_atr AS trailing_stop_position_current_atr, trailing_stop_position.volatility_pct AS trailing_stop_position_volatility_pct, trailing_stop_position.profit_tier AS trailing_stop_position_profit_tier, trailing_stop_position.current_profit_pct AS trailing_stop_position_current_profit_pct, trai
02-19 13:59:30 ERROR order trailing_stop_scheduler Traceback (most recent call last): File "/opt/tiger-trading/venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context self.dialect.do_execute( ~~~~~~~~~~~~~~~~~~~~~~~^ cursor, str_statement, effective_parameters, context ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/tiger-trading/venv/lib/python3.13/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute cursor.execute(statement, parameters) ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^ psycopg2.errors.UndefinedColumn: column position.close_source does not exist LINE 1: ...on.trailing_stop_id AS position_trailing_stop_id, position.c... ^ The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/opt/tiger-trading/trailing_stop_scheduler.py", line 1437, in backfill_closed_position_exit_data ).all() ~~~^^ File "/opt/tiger-trading/venv/lib/python3.13/site-packages/sqlalchemy/orm/query.py", line 2704, in all return self._iter().all() # type: ignore ~~~~~~~~~~^^ File "/opt/tiger-trading/venv/lib/python3.13/site-packages/sqlalchemy/orm/query.py", line 2857, in _iter result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( ~~~~~~~~~~~~~~~~~~~~^ statement, ^^^^^^^^^^ params, ^^^^^^^ execution_options={"_sa_orm_load_options": self.load_options}, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/tiger-trading/venv/lib/python3.13/site-packages/sqlalchemy/orm/session.py", line 2351, in execute return self._execute_internal( ~~~~~~~~~~~~~~~~~~~~~~^ statement, ^^^^^^^^^^ ...<4 lines>... _add_event=_add_event, ^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/tiger-trading/venv/lib
02-19 13:59:30 ERROR order trailing_stop_scheduler Error in backfill_closed_position_exit_data: (psycopg2.errors.UndefinedColumn) column position.close_source does not exist LINE 1: ...on.trailing_stop_id AS position_trailing_stop_id, position.c... ^ [SQL: SELECT position.id AS position_id, position.position_key AS position_position_key, position.symbol AS position_symbol, position.account_type AS position_account_type, position.trade_date AS position_trade_date, position.sequence_number AS position_sequence_number, position.side AS position_side, position.status AS position_status, position.total_entry_quantity AS position_total_entry_quantity, position.total_exit_quantity AS position_total_exit_quantity, position.avg_entry_price AS position_avg_entry_price, position.avg_exit_price AS position_avg_exit_price, position.realized_pnl AS position_realized_pnl, position.commission AS position_commission, position.trailing_stop_id AS position_trailing_stop_id, position.close_source AS position_close_source, position.opened_at AS position_opened_at, position.closed_at AS position_closed_at, position.created_at AS position_created_at, position.updated_at AS position_updated_at FROM position WHERE position.status = %(status_1)s AND position.avg_exit_price IS NULL] [parameters: {'status_1': 'CLOSED'}] (Background on this error at: https://sqlalche.me/e/20/f405)
02-19 13:59:30 ERROR trailing_stop trailing_stop_scheduler Error in cleanup_orphaned_open_positions: (psycopg2.errors.UndefinedColumn) column position.close_source does not exist LINE 1: ...on.trailing_stop_id AS position_trailing_stop_id, position.c... ^ [SQL: SELECT position.id AS position_id, position.position_key AS position_position_key, position.symbol AS position_symbol, position.account_type AS position_account_type, position.trade_date AS position_trade_date, position.sequence_number AS position_sequence_number, position.side AS position_side, position.status AS position_status, position.total_entry_quantity AS position_total_entry_quantity, position.total_exit_quantity AS position_total_exit_quantity, position.avg_entry_price AS position_avg_entry_price, position.avg_exit_price AS position_avg_exit_price, position.realized_pnl AS position_realized_pnl, position.commission AS position_commission, position.trailing_stop_id AS position_trailing_stop_id, position.close_source AS position_close_source, position.opened_at AS position_opened_at, position.closed_at AS position_closed_at, position.created_at AS position_created_at, position.updated_at AS position_updated_at FROM position WHERE position.status = %(status_1)s] [parameters: {'status_1': 'OPEN'}] (Background on this error at: https://sqlalche.me/e/20/f405)
02-19 13:59:27 ERROR order oca_service Error in rebuild_one_paper_oca: (psycopg2.errors.UndefinedColumn) column trailing_stop_position.creation_source does not exist LINE 1: ...ighs AS trailing_stop_position_consecutive_highs, trailing_s... ^ [SQL: SELECT trailing_stop_position.id AS trailing_stop_position_id, trailing_stop_position.symbol AS trailing_stop_position_symbol, trailing_stop_position.account_type AS trailing_stop_position_account_type, trailing_stop_position.side AS trailing_stop_position_side, trailing_stop_position.entry_price AS trailing_stop_position_entry_price, trailing_stop_position.first_entry_price AS trailing_stop_position_first_entry_price, trailing_stop_position.quantity AS trailing_stop_position_quantity, trailing_stop_position.timeframe AS trailing_stop_position_timeframe, trailing_stop_position.trade_id AS trailing_stop_position_trade_id, trailing_stop_position.signal_stop_loss AS trailing_stop_position_signal_stop_loss, trailing_stop_position.fixed_stop_loss AS trailing_stop_position_fixed_stop_loss, trailing_stop_position.fixed_take_profit AS trailing_stop_position_fixed_take_profit, trailing_stop_position.stop_loss_order_id AS trailing_stop_position_stop_loss_order_id, trailing_stop_position.take_profit_order_id AS trailing_stop_position_take_profit_order_id, trailing_stop_position.highest_price AS trailing_stop_position_highest_price, trailing_stop_position.lowest_price AS trailing_stop_position_lowest_price, trailing_stop_position.current_trailing_stop AS trailing_stop_position_current_trailing_stop, trailing_stop_position.previous_trailing_stop AS trailing_stop_position_previous_trailing_stop, trailing_stop_position.current_atr AS trailing_stop_position_current_atr, trailing_stop_position.volatility_pct AS trailing_stop_position_volatility_pct, trailing_stop_position.profit_tier AS trailing_stop_position_profit_tier, trailing_stop_position.current_profit_pct AS trailing_stop_position_current_profit_pct, trailin
02-19 13:59:27 ERROR order oca_service Error in expire_paper_oca_groups: (psycopg2.errors.UndefinedColumn) column oca_group.creation_source does not exist LINE 1: ...us_tp_order_id AS oca_group_previous_tp_order_id, oca_group.... ^ [SQL: SELECT oca_group.id AS oca_group_id_1, oca_group.oca_group_id AS oca_group_oca_group_id, oca_group.symbol AS oca_group_symbol, oca_group.account AS oca_group_account, oca_group.account_type AS oca_group_account_type, oca_group.side AS oca_group_side, oca_group.quantity AS oca_group_quantity, oca_group.entry_price AS oca_group_entry_price, oca_group.stop_order_id AS oca_group_stop_order_id, oca_group.take_profit_order_id AS oca_group_take_profit_order_id, oca_group.stop_price AS oca_group_stop_price, oca_group.stop_limit_price AS oca_group_stop_limit_price, oca_group.take_profit_price AS oca_group_take_profit_price, oca_group.time_in_force AS oca_group_time_in_force, oca_group.outside_rth_stop AS oca_group_outside_rth_stop, oca_group.outside_rth_tp AS oca_group_outside_rth_tp, oca_group.status AS oca_group_status, oca_group.triggered_order_id AS oca_group_triggered_order_id, oca_group.triggered_price AS oca_group_triggered_price, oca_group.triggered_at AS oca_group_triggered_at, oca_group.trade_id AS oca_group_trade_id, oca_group.trailing_stop_id AS oca_group_trailing_stop_id, oca_group.closed_position_id AS oca_group_closed_position_id, oca_group.rebuild_count AS oca_group_rebuild_count, oca_group.last_rebuild_at AS oca_group_last_rebuild_at, oca_group.previous_stop_order_id AS oca_group_previous_stop_order_id, oca_group.previous_tp_order_id AS oca_group_previous_tp_order_id, oca_group.creation_source AS oca_group_creation_source, oca_group.created_at AS oca_group_created_at, oca_group.updated_at AS oca_group_updated_at FROM oca_group WHERE oca_group.account_type = %(account_type_1)s AND oca_group.status = %(status_1)s] [parameters: {'account_type_1': 'paper', 'status_1': 'ACTIVE'}] (Background on this error
02-19 13:59:27 ERROR order trailing_stop_scheduler Error in trailing stop auto-check: (psycopg2.errors.UndefinedColumn) column trailing_stop_position.creation_source does not exist LINE 2: ...ighs AS trailing_stop_position_consecutive_highs, trailing_s... ^ [SQL: SELECT count(*) AS count_1 FROM (SELECT trailing_stop_position.id AS trailing_stop_position_id, trailing_stop_position.symbol AS trailing_stop_position_symbol, trailing_stop_position.account_type AS trailing_stop_position_account_type, trailing_stop_position.side AS trailing_stop_position_side, trailing_stop_position.entry_price AS trailing_stop_position_entry_price, trailing_stop_position.first_entry_price AS trailing_stop_position_first_entry_price, trailing_stop_position.quantity AS trailing_stop_position_quantity, trailing_stop_position.timeframe AS trailing_stop_position_timeframe, trailing_stop_position.trade_id AS trailing_stop_position_trade_id, trailing_stop_position.signal_stop_loss AS trailing_stop_position_signal_stop_loss, trailing_stop_position.fixed_stop_loss AS trailing_stop_position_fixed_stop_loss, trailing_stop_position.fixed_take_profit AS trailing_stop_position_fixed_take_profit, trailing_stop_position.stop_loss_order_id AS trailing_stop_position_stop_loss_order_id, trailing_stop_position.take_profit_order_id AS trailing_stop_position_take_profit_order_id, trailing_stop_position.highest_price AS trailing_stop_position_highest_price, trailing_stop_position.lowest_price AS trailing_stop_position_lowest_price, trailing_stop_position.current_trailing_stop AS trailing_stop_position_current_trailing_stop, trailing_stop_position.previous_trailing_stop AS trailing_stop_position_previous_trailing_stop, trailing_stop_position.current_atr AS trailing_stop_position_current_atr, trailing_stop_position.volatility_pct AS trailing_stop_position_volatility_pct, trailing_stop_position.profit_tier AS trailing_stop_position_profit_tier, trailing_stop_position.current_profit_pct AS trailing_stop
02-19 13:59:27 ERROR order trailing_stop_scheduler Error in trailing stop fast check: (psycopg2.errors.UndefinedColumn) column trailing_stop_position.creation_source does not exist LINE 1: ...ighs AS trailing_stop_position_consecutive_highs, trailing_s... ^ [SQL: SELECT trailing_stop_position.id AS trailing_stop_position_id, trailing_stop_position.symbol AS trailing_stop_position_symbol, trailing_stop_position.account_type AS trailing_stop_position_account_type, trailing_stop_position.side AS trailing_stop_position_side, trailing_stop_position.entry_price AS trailing_stop_position_entry_price, trailing_stop_position.first_entry_price AS trailing_stop_position_first_entry_price, trailing_stop_position.quantity AS trailing_stop_position_quantity, trailing_stop_position.timeframe AS trailing_stop_position_timeframe, trailing_stop_position.trade_id AS trailing_stop_position_trade_id, trailing_stop_position.signal_stop_loss AS trailing_stop_position_signal_stop_loss, trailing_stop_position.fixed_stop_loss AS trailing_stop_position_fixed_stop_loss, trailing_stop_position.fixed_take_profit AS trailing_stop_position_fixed_take_profit, trailing_stop_position.stop_loss_order_id AS trailing_stop_position_stop_loss_order_id, trailing_stop_position.take_profit_order_id AS trailing_stop_position_take_profit_order_id, trailing_stop_position.highest_price AS trailing_stop_position_highest_price, trailing_stop_position.lowest_price AS trailing_stop_position_lowest_price, trailing_stop_position.current_trailing_stop AS trailing_stop_position_current_trailing_stop, trailing_stop_position.previous_trailing_stop AS trailing_stop_position_previous_trailing_stop, trailing_stop_position.current_atr AS trailing_stop_position_current_atr, trailing_stop_position.volatility_pct AS trailing_stop_position_volatility_pct, trailing_stop_position.profit_tier AS trailing_stop_position_profit_tier, trailing_stop_position.current_profit_pct AS trailing_stop_position_current_profit_pct, trai
02-19 13:59:26 ERROR order trailing_stop_scheduler Traceback (most recent call last): File "/opt/tiger-trading/venv/lib/python3.13/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context self.dialect.do_execute( ~~~~~~~~~~~~~~~~~~~~~~~^ cursor, str_statement, effective_parameters, context ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/tiger-trading/venv/lib/python3.13/site-packages/sqlalchemy/engine/default.py", line 952, in do_execute cursor.execute(statement, parameters) ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^ psycopg2.errors.UndefinedColumn: column position.close_source does not exist LINE 1: ...on.trailing_stop_id AS position_trailing_stop_id, position.c... ^ The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/opt/tiger-trading/trailing_stop_scheduler.py", line 1437, in backfill_closed_position_exit_data ).all() ~~~^^ File "/opt/tiger-trading/venv/lib/python3.13/site-packages/sqlalchemy/orm/query.py", line 2704, in all return self._iter().all() # type: ignore ~~~~~~~~~~^^ File "/opt/tiger-trading/venv/lib/python3.13/site-packages/sqlalchemy/orm/query.py", line 2857, in _iter result: Union[ScalarResult[_T], Result[_T]] = self.session.execute( ~~~~~~~~~~~~~~~~~~~~^ statement, ^^^^^^^^^^ params, ^^^^^^^ execution_options={"_sa_orm_load_options": self.load_options}, ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/tiger-trading/venv/lib/python3.13/site-packages/sqlalchemy/orm/session.py", line 2351, in execute return self._execute_internal( ~~~~~~~~~~~~~~~~~~~~~~^ statement, ^^^^^^^^^^ ...<4 lines>... _add_event=_add_event, ^^^^^^^^^^^^^^^^^^^^^^ ) ^ File "/opt/tiger-trading/venv/lib
02-19 13:59:26 ERROR order trailing_stop_scheduler Error in backfill_closed_position_exit_data: (psycopg2.errors.UndefinedColumn) column position.close_source does not exist LINE 1: ...on.trailing_stop_id AS position_trailing_stop_id, position.c... ^ [SQL: SELECT position.id AS position_id, position.position_key AS position_position_key, position.symbol AS position_symbol, position.account_type AS position_account_type, position.trade_date AS position_trade_date, position.sequence_number AS position_sequence_number, position.side AS position_side, position.status AS position_status, position.total_entry_quantity AS position_total_entry_quantity, position.total_exit_quantity AS position_total_exit_quantity, position.avg_entry_price AS position_avg_entry_price, position.avg_exit_price AS position_avg_exit_price, position.realized_pnl AS position_realized_pnl, position.commission AS position_commission, position.trailing_stop_id AS position_trailing_stop_id, position.close_source AS position_close_source, position.opened_at AS position_opened_at, position.closed_at AS position_closed_at, position.created_at AS position_created_at, position.updated_at AS position_updated_at FROM position WHERE position.status = %(status_1)s AND position.avg_exit_price IS NULL] [parameters: {'status_1': 'CLOSED'}] (Background on this error at: https://sqlalche.me/e/20/f405)
02-19 13:59:26 ERROR trailing_stop trailing_stop_scheduler Error in cleanup_orphaned_open_positions: (psycopg2.errors.UndefinedColumn) column position.close_source does not exist LINE 1: ...on.trailing_stop_id AS position_trailing_stop_id, position.c... ^ [SQL: SELECT position.id AS position_id, position.position_key AS position_position_key, position.symbol AS position_symbol, position.account_type AS position_account_type, position.trade_date AS position_trade_date, position.sequence_number AS position_sequence_number, position.side AS position_side, position.status AS position_status, position.total_entry_quantity AS position_total_entry_quantity, position.total_exit_quantity AS position_total_exit_quantity, position.avg_entry_price AS position_avg_entry_price, position.avg_exit_price AS position_avg_exit_price, position.realized_pnl AS position_realized_pnl, position.commission AS position_commission, position.trailing_stop_id AS position_trailing_stop_id, position.close_source AS position_close_source, position.opened_at AS position_opened_at, position.closed_at AS position_closed_at, position.created_at AS position_created_at, position.updated_at AS position_updated_at FROM position WHERE position.status = %(status_1)s] [parameters: {'status_1': 'OPEN'}] (Background on this error at: https://sqlalche.me/e/20/f405)
02-19 13:58:44 ERROR error tiger_client Error getting latest trade for TEM: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:44 ERROR error tiger_client Error getting extended hours price for TEM: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:44 ERROR error tiger_client Error getting latest trade for IREN: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:44 ERROR error tiger_client Error getting extended hours price for IREN: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:44 ERROR error tiger_client Error getting latest trade for NFLX: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:44 ERROR error tiger_client Error getting extended hours price for NFLX: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:39 ERROR error tiger_client Error getting latest trade for TEM: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:39 ERROR error tiger_client Error getting extended hours price for TEM: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:39 ERROR error tiger_client Error getting latest trade for IREN: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:39 ERROR error tiger_client Error getting extended hours price for IREN: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:39 ERROR error tiger_client Error getting latest trade for NFLX: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:58:39 ERROR error tiger_client Error getting extended hours price for NFLX: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market)
02-19 13:57:59 ERROR error tiger_client Error getting bars for SOXX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:59 ERROR error tiger_client Error getting bars for ENTG: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:59 ERROR error tiger_client Error getting bars for CRDO: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:59 ERROR error TSM tiger_client Error getting bars for TSM: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:56 ERROR error tiger_client Error getting bars for TEST: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:56 ERROR error tiger_client Error getting bars for IREN: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:56 ERROR error tiger_client Error getting bars for TEM: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:56 ERROR error tiger_client Error getting bars for NFLX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:56 ERROR error tiger_client Error getting bars for SMH: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:55 ERROR error tiger_client Error getting bars for SOXX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:55 ERROR error tiger_client Error getting bars for ENTG: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:55 ERROR error tiger_client Error getting bars for CRDO: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:55 ERROR error TSM tiger_client Error getting bars for TSM: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:12 ERROR error tiger_client Error getting bars for LRCX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:12 ERROR error tiger_client Error getting bars for AMAT: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:12 ERROR error tiger_client Error getting bars for ATOM: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:12 ERROR error tiger_client Error getting bars for REMX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:11 ERROR error tiger_client Error getting bars for EQIX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:11 ERROR error tiger_client Error getting bars for CIEN: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)
02-19 13:57:11 ERROR error tiger_client Error getting bars for ANET: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute)