stock = D.instruments()[:]
df = D.history_data(stock, 
                   '2022-01-14',
                    '2022-01-14',
                    ['name','market_cap_float','volume',
                     'close','price_limit_status']) #获取相关股票数据


df=df[['date','instrument','name','market_cap_float','volume','close','price_limit_status']]



df.rename(columns={'date':'日期','instrument':'代码','name':'名称','market_cap_float':'流通市值','volume':'成交量','close':'收盘价'}, inplace=True)
df.head(1000)

df.sort_values(by= ['收盘价','流通市值'],ascending= False).head(1000)

df[(df['price_limit_status']>2)].head(1000)

df[(df['price_limit_status']>2)].head(1000) #选择满足条件的信息

df[(df['流通市值']>0) & (df['流通市值']<30000000000)].head(1000) #选择流通市值在某区间的数据