我试图使用SQLAlchemy执行查询dev_engine = create_engine('mysql://...')
dev_connect = dev_engine.connect()
prod_connect = prod_engine.connect()
get_dev_instrument = "select * from market_instrument inner join cme_instrument on market_instrument.id = cme_instrument.instrument_id \
inner join tick_size on market_instrument.id = tick_size.instrument_id \
left join futures on market_instrument.id = futures.instrument_id \
left join `options`on market_instrument.id = `options`.instrument_id \
left join spreads on market_instrument.id = spreads.instrument_id \
inner join (select distinct(substring(m.symbol, 1, 2)) as product from market_instrument as m inner join fills as f on m.id=f.instrument_id \
inner join cme_instrument where symbol<>\"\" and fill_timestamp between CURDATE() - INTERVAL 60 DAY AND NOW())
最低0.47元/天 解锁文章
3266
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
