q = query(valuation).filter(valuation.code == ‘000001.XSHE’)
df = get_fundamentals(q, ‘2018-12-30’)
turnover_ratio 换手率
market_cap 总市值
capitalization 总股本171.7亿
circulating_cap 流通股171.7亿
circulating_market_cap :流通市值1610.6亿
查询某一日换手率大于30的票:
scu = list (get_all_securities(date=‘2018-12-26’).index)#all of A
q=query(valuation.code).filter(valuation.code.in_(scu),valuation.turnover_ratio>30).order_by( valuation.turnover_ratio.desc()).limit(500)
df = get_fundamentals(q)
df
按照日期查:比如查2018-12-27这天的换手榜:
scu = list (get_all_securities(date=‘2018-12-26’).index)#all of A
q=query(valuation.code).filter(valuation