Open kellymao opened 4 years ago
datetime_str: 2020-08-28 datetime_int: 20200828 insert sql: DELETE FROM stock_data.guess_indicators_lite_sell_daily WHERE date= '20200828' error : (1146, "Table 'stock_data.guess_indicators_lite_sell_daily' doesn't exist") error : (MySQLdb._exceptions.ProgrammingError) (1146, "Table 'stock_data.guess_indicators_daily' doesn't exist") [SQL: SELECT date, code, name, changepercent, trade, open, high, low, settlement, volume, turnoverratio, amount, per, pb, mktcap, nmc ,kdjj,rsi_6,cci FROM stock_data.guess_indicators_daily WHERE date = %s and kdjk <= 20 and kdjd <= 30 and kdjj <= 10 and rsi_6 <= 20 and cci <= -100
stock_data
guess_indicators_lite_sell_daily
date
code
name
changepercent
trade
open
high
low
settlement
volume
turnoverratio
amount
per
pb
mktcap
nmc
kdjj
rsi_6
cci
datetime_str: 2020-08-28 datetime_int: 20200828 insert sql: DELETE FROM
stock_data
.guess_indicators_lite_sell_daily
WHEREdate
= '20200828' error : (1146, "Table 'stock_data.guess_indicators_lite_sell_daily' doesn't exist") error : (MySQLdb._exceptions.ProgrammingError) (1146, "Table 'stock_data.guess_indicators_daily' doesn't exist") [SQL: SELECTdate
,code
,name
,changepercent
,trade
,open
,high
,low
,settlement
,volume
,turnoverratio
,amount
,per
,pb
,mktcap
,nmc
,kdjj
,rsi_6
,cci
FROM stock_data.guess_indicators_daily WHEREdate
= %s and kdjk <= 20 and kdjd <= 30 and kdjj <= 10 and rsi_6 <= 20 and cci <= -100