选股.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "█\r"
     ]
    }
   ],
   "source": [
    "#-*-coding=utf-8-*-\n",
    "# 用来选股的\n",
    "from setting import get_engine\n",
    "import pandas as pd\n",
    "import tushare as ts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = get_engine('db_stock')\n",
    "basic_df = pd.read_sql('tb_basic_info',engine,index_col='index')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>...</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "      <th>更新日期</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>603897</td>\n",
       "      <td>N长城</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>浙江</td>\n",
       "      <td>25.57</td>\n",
       "      <td>0.45</td>\n",
       "      <td>1.78</td>\n",
       "      <td>131807.23</td>\n",
       "      <td>117523.63</td>\n",
       "      <td>10988.37</td>\n",
       "      <td>...</td>\n",
       "      <td>4.27</td>\n",
       "      <td>20180410</td>\n",
       "      <td>35286.05</td>\n",
       "      <td>1.98</td>\n",
       "      <td>41.98</td>\n",
       "      <td>55.84</td>\n",
       "      <td>8.19</td>\n",
       "      <td>3.87</td>\n",
       "      <td>42986.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300356</td>\n",
       "      <td>光一科技</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>江苏</td>\n",
       "      <td>206.51</td>\n",
       "      <td>3.69</td>\n",
       "      <td>4.15</td>\n",
       "      <td>208679.95</td>\n",
       "      <td>97810.21</td>\n",
       "      <td>17068.50</td>\n",
       "      <td>...</td>\n",
       "      <td>2.49</td>\n",
       "      <td>20121009</td>\n",
       "      <td>28831.28</td>\n",
       "      <td>0.69</td>\n",
       "      <td>-39.02</td>\n",
       "      <td>-47.76</td>\n",
       "      <td>26.05</td>\n",
       "      <td>4.30</td>\n",
       "      <td>19839.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>600711</td>\n",
       "      <td>盛屯矿业</td>\n",
       "      <td>小金属</td>\n",
       "      <td>福建</td>\n",
       "      <td>26.15</td>\n",
       "      <td>14.97</td>\n",
       "      <td>16.77</td>\n",
       "      <td>1125400.88</td>\n",
       "      <td>590581.00</td>\n",
       "      <td>76470.36</td>\n",
       "      <td>...</td>\n",
       "      <td>3.11</td>\n",
       "      <td>19960531</td>\n",
       "      <td>104130.27</td>\n",
       "      <td>0.62</td>\n",
       "      <td>62.61</td>\n",
       "      <td>223.67</td>\n",
       "      <td>6.85</td>\n",
       "      <td>2.95</td>\n",
       "      <td>106700.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>002160</td>\n",
       "      <td>常铝股份</td>\n",
       "      <td>铝</td>\n",
       "      <td>江苏</td>\n",
       "      <td>32.31</td>\n",
       "      <td>4.72</td>\n",
       "      <td>7.24</td>\n",
       "      <td>622252.69</td>\n",
       "      <td>297916.59</td>\n",
       "      <td>151107.36</td>\n",
       "      <td>...</td>\n",
       "      <td>1.45</td>\n",
       "      <td>20070821</td>\n",
       "      <td>27155.90</td>\n",
       "      <td>0.37</td>\n",
       "      <td>40.03</td>\n",
       "      <td>56.07</td>\n",
       "      <td>17.64</td>\n",
       "      <td>3.84</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000717</td>\n",
       "      <td>韶钢松山</td>\n",
       "      <td>普钢</td>\n",
       "      <td>广东</td>\n",
       "      <td>6.32</td>\n",
       "      <td>24.20</td>\n",
       "      <td>24.20</td>\n",
       "      <td>1441538.00</td>\n",
       "      <td>440514.44</td>\n",
       "      <td>801547.88</td>\n",
       "      <td>...</td>\n",
       "      <td>5.35</td>\n",
       "      <td>19970508</td>\n",
       "      <td>-331470.38</td>\n",
       "      <td>-1.37</td>\n",
       "      <td>86.35</td>\n",
       "      <td>2381.13</td>\n",
       "      <td>13.26</td>\n",
       "      <td>9.66</td>\n",
       "      <td>132008.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         code  name industry area      pe  outstanding  totals  totalAssets  \\\n",
       "index                                                                         \n",
       "0      603897   N长城     电气设备   浙江   25.57         0.45    1.78    131807.23   \n",
       "1      300356  光一科技     电气设备   江苏  206.51         3.69    4.15    208679.95   \n",
       "2      600711  盛屯矿业      小金属   福建   26.15        14.97   16.77   1125400.88   \n",
       "3      002160  常铝股份        铝   江苏   32.31         4.72    7.24    622252.69   \n",
       "4      000717  韶钢松山       普钢   广东    6.32        24.20   24.20   1441538.00   \n",
       "\n",
       "       liquidAssets  fixedAssets     ...        pb  timeToMarket       undp  \\\n",
       "index                                ...                                      \n",
       "0         117523.63     10988.37     ...      4.27      20180410   35286.05   \n",
       "1          97810.21     17068.50     ...      2.49      20121009   28831.28   \n",
       "2         590581.00     76470.36     ...      3.11      19960531  104130.27   \n",
       "3         297916.59    151107.36     ...      1.45      20070821   27155.90   \n",
       "4         440514.44    801547.88     ...      5.35      19970508 -331470.38   \n",
       "\n",
       "       perundp    rev   profit    gpr   npr   holders        更新日期  \n",
       "index                                                              \n",
       "0         1.98  41.98    55.84   8.19  3.87   42986.0  2018-04-11  \n",
       "1         0.69 -39.02   -47.76  26.05  4.30   19839.0  2018-04-11  \n",
       "2         0.62  62.61   223.67   6.85  2.95  106700.0  2018-04-11  \n",
       "3         0.37  40.03    56.07  17.64  3.84   50000.0  2018-04-11  \n",
       "4        -1.37  86.35  2381.13  13.26  9.66  132008.0  2018-04-11  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "basic_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "basic_df=basic_df[basic_df['timeToMarket']!=0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 3506 entries, 0 to 3509\n",
      "Data columns (total 24 columns):\n",
      "code                3506 non-null object\n",
      "name                3506 non-null object\n",
      "industry            3506 non-null object\n",
      "area                3506 non-null object\n",
      "pe                  3506 non-null float64\n",
      "outstanding         3506 non-null float64\n",
      "totals              3506 non-null float64\n",
      "totalAssets         3506 non-null float64\n",
      "liquidAssets        3506 non-null float64\n",
      "fixedAssets         3506 non-null float64\n",
      "reserved            3506 non-null float64\n",
      "reservedPerShare    3506 non-null float64\n",
      "esp                 3506 non-null float64\n",
      "bvps                3506 non-null float64\n",
      "pb                  3506 non-null float64\n",
      "timeToMarket        3506 non-null int64\n",
      "undp                3506 non-null float64\n",
      "perundp             3506 non-null float64\n",
      "rev                 3506 non-null float64\n",
      "profit              3506 non-null float64\n",
      "gpr                 3506 non-null float64\n",
      "npr                 3506 non-null float64\n",
      "holders             3506 non-null float64\n",
      "更新日期                3506 non-null object\n",
      "dtypes: float64(18), int64(1), object(5)\n",
      "memory usage: 684.8+ KB\n"
     ]
    }
   ],
   "source": [
    "basic_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/usr/local/lib/python2.7/dist-packages/pandas/core/ops.py:816: FutureWarning: elementwise comparison failed; returning scalar instead, but in the future will perform elementwise comparison\n",
      "  result = getattr(x, name)(y)\n"
     ]
    },
    {
     "ename": "TypeError",
     "evalue": "invalid type comparison",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-25-c38b6c9e83f2>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mbasic_df\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mbasic_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreset_index\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mbasic_df\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'timeToMarket'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mdrop\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mTrue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36mreset_index\u001b[0;34m(self, level, drop, inplace, col_level, col_fill)\u001b[0m\n\u001b[1;32m   3339\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlevel\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m(\u001b[0m\u001b[0mtuple\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlist\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3340\u001b[0m                 \u001b[0mlevel\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mlevel\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3341\u001b[0;31m             \u001b[0mlevel\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_level_number\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlev\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mlev\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mlevel\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3342\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mMultiIndex\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3343\u001b[0m                 \u001b[0;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlevel\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m<\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mnlevels\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/indexes/base.pyc\u001b[0m in \u001b[0;36m_get_level_number\u001b[0;34m(self, level)\u001b[0m\n\u001b[1;32m   1618\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1619\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_get_level_number\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlevel\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1620\u001b[0;31m         \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_validate_index_level\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlevel\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1621\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0;36m0\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1622\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/indexes/base.pyc\u001b[0m in \u001b[0;36m_validate_index_level\u001b[0;34m(self, level)\u001b[0m\n\u001b[1;32m   1613\u001b[0m                                  \u001b[0;34m\" Index has only 1 level, not %d\"\u001b[0m \u001b[0;34m%\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1614\u001b[0m                                  (level + 1))\n\u001b[0;32m-> 1615\u001b[0;31m         \u001b[0;32melif\u001b[0m \u001b[0mlevel\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mname\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1616\u001b[0m             raise KeyError('Level %s must be same as name (%s)' %\n\u001b[1;32m   1617\u001b[0m                            (level, self.name))\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/ops.pyc\u001b[0m in \u001b[0;36mwrapper\u001b[0;34m(self, other, axis)\u001b[0m\n\u001b[1;32m    877\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    878\u001b[0m             \u001b[0;32mwith\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0merrstate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mall\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'ignore'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 879\u001b[0;31m                 \u001b[0mres\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mna_op\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mvalues\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mother\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    880\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mis_scalar\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mres\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    881\u001b[0m                 raise TypeError('Could not compare {typ} type with Series'\n",
      "\u001b[0;32m/usr/local/lib/python2.7/dist-packages/pandas/core/ops.pyc\u001b[0m in \u001b[0;36mna_op\u001b[0;34m(x, y)\u001b[0m\n\u001b[1;32m    816\u001b[0m                     \u001b[0mresult\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0my\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    817\u001b[0m                 \u001b[0;32mif\u001b[0m \u001b[0mresult\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0mNotImplemented\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 818\u001b[0;31m                     \u001b[0;32mraise\u001b[0m \u001b[0mTypeError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"invalid type comparison\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    819\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mAttributeError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    820\u001b[0m                 \u001b[0mresult\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mop\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mx\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0my\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mTypeError\u001b[0m: invalid type comparison"
     ]
    }
   ],
   "source": [
    "basic_df = basic_df.reset_index(basic_df['timeToMarket'],drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>...</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "      <th>更新日期</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>603897</td>\n",
       "      <td>N长城</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>浙江</td>\n",
       "      <td>25.57</td>\n",
       "      <td>0.45</td>\n",
       "      <td>1.78</td>\n",
       "      <td>131807.23</td>\n",
       "      <td>117523.63</td>\n",
       "      <td>10988.37</td>\n",
       "      <td>...</td>\n",
       "      <td>4.27</td>\n",
       "      <td>20180410</td>\n",
       "      <td>35286.05</td>\n",
       "      <td>1.98</td>\n",
       "      <td>41.98</td>\n",
       "      <td>55.84</td>\n",
       "      <td>8.19</td>\n",
       "      <td>3.87</td>\n",
       "      <td>42986.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300356</td>\n",
       "      <td>光一科技</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>江苏</td>\n",
       "      <td>206.51</td>\n",
       "      <td>3.69</td>\n",
       "      <td>4.15</td>\n",
       "      <td>208679.95</td>\n",
       "      <td>97810.21</td>\n",
       "      <td>17068.50</td>\n",
       "      <td>...</td>\n",
       "      <td>2.49</td>\n",
       "      <td>20121009</td>\n",
       "      <td>28831.28</td>\n",
       "      <td>0.69</td>\n",
       "      <td>-39.02</td>\n",
       "      <td>-47.76</td>\n",
       "      <td>26.05</td>\n",
       "      <td>4.30</td>\n",
       "      <td>19839.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>600711</td>\n",
       "      <td>盛屯矿业</td>\n",
       "      <td>小金属</td>\n",
       "      <td>福建</td>\n",
       "      <td>26.15</td>\n",
       "      <td>14.97</td>\n",
       "      <td>16.77</td>\n",
       "      <td>1125400.88</td>\n",
       "      <td>590581.00</td>\n",
       "      <td>76470.36</td>\n",
       "      <td>...</td>\n",
       "      <td>3.11</td>\n",
       "      <td>19960531</td>\n",
       "      <td>104130.27</td>\n",
       "      <td>0.62</td>\n",
       "      <td>62.61</td>\n",
       "      <td>223.67</td>\n",
       "      <td>6.85</td>\n",
       "      <td>2.95</td>\n",
       "      <td>106700.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>002160</td>\n",
       "      <td>常铝股份</td>\n",
       "      <td>铝</td>\n",
       "      <td>江苏</td>\n",
       "      <td>32.31</td>\n",
       "      <td>4.72</td>\n",
       "      <td>7.24</td>\n",
       "      <td>622252.69</td>\n",
       "      <td>297916.59</td>\n",
       "      <td>151107.36</td>\n",
       "      <td>...</td>\n",
       "      <td>1.45</td>\n",
       "      <td>20070821</td>\n",
       "      <td>27155.90</td>\n",
       "      <td>0.37</td>\n",
       "      <td>40.03</td>\n",
       "      <td>56.07</td>\n",
       "      <td>17.64</td>\n",
       "      <td>3.84</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000717</td>\n",
       "      <td>韶钢松山</td>\n",
       "      <td>普钢</td>\n",
       "      <td>广东</td>\n",
       "      <td>6.32</td>\n",
       "      <td>24.20</td>\n",
       "      <td>24.20</td>\n",
       "      <td>1441538.00</td>\n",
       "      <td>440514.44</td>\n",
       "      <td>801547.88</td>\n",
       "      <td>...</td>\n",
       "      <td>5.35</td>\n",
       "      <td>19970508</td>\n",
       "      <td>-331470.38</td>\n",
       "      <td>-1.37</td>\n",
       "      <td>86.35</td>\n",
       "      <td>2381.13</td>\n",
       "      <td>13.26</td>\n",
       "      <td>9.66</td>\n",
       "      <td>132008.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         code  name industry area      pe  outstanding  totals  totalAssets  \\\n",
       "index                                                                         \n",
       "0      603897   N长城     电气设备   浙江   25.57         0.45    1.78    131807.23   \n",
       "1      300356  光一科技     电气设备   江苏  206.51         3.69    4.15    208679.95   \n",
       "2      600711  盛屯矿业      小金属   福建   26.15        14.97   16.77   1125400.88   \n",
       "3      002160  常铝股份        铝   江苏   32.31         4.72    7.24    622252.69   \n",
       "4      000717  韶钢松山       普钢   广东    6.32        24.20   24.20   1441538.00   \n",
       "\n",
       "       liquidAssets  fixedAssets     ...        pb  timeToMarket       undp  \\\n",
       "index                                ...                                      \n",
       "0         117523.63     10988.37     ...      4.27      20180410   35286.05   \n",
       "1          97810.21     17068.50     ...      2.49      20121009   28831.28   \n",
       "2         590581.00     76470.36     ...      3.11      19960531  104130.27   \n",
       "3         297916.59    151107.36     ...      1.45      20070821   27155.90   \n",
       "4         440514.44    801547.88     ...      5.35      19970508 -331470.38   \n",
       "\n",
       "       perundp    rev   profit    gpr   npr   holders        更新日期  \n",
       "index                                                              \n",
       "0         1.98  41.98    55.84   8.19  3.87   42986.0  2018-04-11  \n",
       "1         0.69 -39.02   -47.76  26.05  4.30   19839.0  2018-04-11  \n",
       "2         0.62  62.61   223.67   6.85  2.95  106700.0  2018-04-11  \n",
       "3         0.37  40.03    56.07  17.64  3.84   50000.0  2018-04-11  \n",
       "4        -1.37  86.35  2381.13  13.26  9.66  132008.0  2018-04-11  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "basic_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "basic_df['timeToMarket']=pd.to_datetime(basic_df['timeToMarket'],format='%Y%m%d')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>...</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "      <th>更新日期</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>603897</td>\n",
       "      <td>N长城</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>浙江</td>\n",
       "      <td>25.57</td>\n",
       "      <td>0.45</td>\n",
       "      <td>1.78</td>\n",
       "      <td>131807.23</td>\n",
       "      <td>117523.63</td>\n",
       "      <td>10988.37</td>\n",
       "      <td>...</td>\n",
       "      <td>4.27</td>\n",
       "      <td>2018-04-10</td>\n",
       "      <td>35286.05</td>\n",
       "      <td>1.98</td>\n",
       "      <td>41.98</td>\n",
       "      <td>55.84</td>\n",
       "      <td>8.19</td>\n",
       "      <td>3.87</td>\n",
       "      <td>42986.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300356</td>\n",
       "      <td>光一科技</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>江苏</td>\n",
       "      <td>206.51</td>\n",
       "      <td>3.69</td>\n",
       "      <td>4.15</td>\n",
       "      <td>208679.95</td>\n",
       "      <td>97810.21</td>\n",
       "      <td>17068.50</td>\n",
       "      <td>...</td>\n",
       "      <td>2.49</td>\n",
       "      <td>2012-10-09</td>\n",
       "      <td>28831.28</td>\n",
       "      <td>0.69</td>\n",
       "      <td>-39.02</td>\n",
       "      <td>-47.76</td>\n",
       "      <td>26.05</td>\n",
       "      <td>4.30</td>\n",
       "      <td>19839.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>600711</td>\n",
       "      <td>盛屯矿业</td>\n",
       "      <td>小金属</td>\n",
       "      <td>福建</td>\n",
       "      <td>26.15</td>\n",
       "      <td>14.97</td>\n",
       "      <td>16.77</td>\n",
       "      <td>1125400.88</td>\n",
       "      <td>590581.00</td>\n",
       "      <td>76470.36</td>\n",
       "      <td>...</td>\n",
       "      <td>3.11</td>\n",
       "      <td>1996-05-31</td>\n",
       "      <td>104130.27</td>\n",
       "      <td>0.62</td>\n",
       "      <td>62.61</td>\n",
       "      <td>223.67</td>\n",
       "      <td>6.85</td>\n",
       "      <td>2.95</td>\n",
       "      <td>106700.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>002160</td>\n",
       "      <td>常铝股份</td>\n",
       "      <td>铝</td>\n",
       "      <td>江苏</td>\n",
       "      <td>32.31</td>\n",
       "      <td>4.72</td>\n",
       "      <td>7.24</td>\n",
       "      <td>622252.69</td>\n",
       "      <td>297916.59</td>\n",
       "      <td>151107.36</td>\n",
       "      <td>...</td>\n",
       "      <td>1.45</td>\n",
       "      <td>2007-08-21</td>\n",
       "      <td>27155.90</td>\n",
       "      <td>0.37</td>\n",
       "      <td>40.03</td>\n",
       "      <td>56.07</td>\n",
       "      <td>17.64</td>\n",
       "      <td>3.84</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000717</td>\n",
       "      <td>韶钢松山</td>\n",
       "      <td>普钢</td>\n",
       "      <td>广东</td>\n",
       "      <td>6.32</td>\n",
       "      <td>24.20</td>\n",
       "      <td>24.20</td>\n",
       "      <td>1441538.00</td>\n",
       "      <td>440514.44</td>\n",
       "      <td>801547.88</td>\n",
       "      <td>...</td>\n",
       "      <td>5.35</td>\n",
       "      <td>1997-05-08</td>\n",
       "      <td>-331470.38</td>\n",
       "      <td>-1.37</td>\n",
       "      <td>86.35</td>\n",
       "      <td>2381.13</td>\n",
       "      <td>13.26</td>\n",
       "      <td>9.66</td>\n",
       "      <td>132008.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         code  name industry area      pe  outstanding  totals  totalAssets  \\\n",
       "index                                                                         \n",
       "0      603897   N长城     电气设备   浙江   25.57         0.45    1.78    131807.23   \n",
       "1      300356  光一科技     电气设备   江苏  206.51         3.69    4.15    208679.95   \n",
       "2      600711  盛屯矿业      小金属   福建   26.15        14.97   16.77   1125400.88   \n",
       "3      002160  常铝股份        铝   江苏   32.31         4.72    7.24    622252.69   \n",
       "4      000717  韶钢松山       普钢   广东    6.32        24.20   24.20   1441538.00   \n",
       "\n",
       "       liquidAssets  fixedAssets     ...        pb  timeToMarket       undp  \\\n",
       "index                                ...                                      \n",
       "0         117523.63     10988.37     ...      4.27    2018-04-10   35286.05   \n",
       "1          97810.21     17068.50     ...      2.49    2012-10-09   28831.28   \n",
       "2         590581.00     76470.36     ...      3.11    1996-05-31  104130.27   \n",
       "3         297916.59    151107.36     ...      1.45    2007-08-21   27155.90   \n",
       "4         440514.44    801547.88     ...      5.35    1997-05-08 -331470.38   \n",
       "\n",
       "       perundp    rev   profit    gpr   npr   holders        更新日期  \n",
       "index                                                              \n",
       "0         1.98  41.98    55.84   8.19  3.87   42986.0  2018-04-11  \n",
       "1         0.69 -39.02   -47.76  26.05  4.30   19839.0  2018-04-11  \n",
       "2         0.62  62.61   223.67   6.85  2.95  106700.0  2018-04-11  \n",
       "3         0.37  40.03    56.07  17.64  3.84   50000.0  2018-04-11  \n",
       "4        -1.37  86.35  2381.13  13.26  9.66  132008.0  2018-04-11  \n",
       "\n",
       "[5 rows x 24 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "basic_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>...</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "      <th>更新日期</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>timeToMarket</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-04-10</th>\n",
       "      <td>603897</td>\n",
       "      <td>N长城</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>浙江</td>\n",
       "      <td>25.57</td>\n",
       "      <td>0.45</td>\n",
       "      <td>1.78</td>\n",
       "      <td>131807.23</td>\n",
       "      <td>117523.63</td>\n",
       "      <td>10988.37</td>\n",
       "      <td>...</td>\n",
       "      <td>4.27</td>\n",
       "      <td>2018-04-10</td>\n",
       "      <td>35286.05</td>\n",
       "      <td>1.98</td>\n",
       "      <td>41.98</td>\n",
       "      <td>55.84</td>\n",
       "      <td>8.19</td>\n",
       "      <td>3.87</td>\n",
       "      <td>42986.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012-10-09</th>\n",
       "      <td>300356</td>\n",
       "      <td>光一科技</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>江苏</td>\n",
       "      <td>206.51</td>\n",
       "      <td>3.69</td>\n",
       "      <td>4.15</td>\n",
       "      <td>208679.95</td>\n",
       "      <td>97810.21</td>\n",
       "      <td>17068.50</td>\n",
       "      <td>...</td>\n",
       "      <td>2.49</td>\n",
       "      <td>2012-10-09</td>\n",
       "      <td>28831.28</td>\n",
       "      <td>0.69</td>\n",
       "      <td>-39.02</td>\n",
       "      <td>-47.76</td>\n",
       "      <td>26.05</td>\n",
       "      <td>4.30</td>\n",
       "      <td>19839.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996-05-31</th>\n",
       "      <td>600711</td>\n",
       "      <td>盛屯矿业</td>\n",
       "      <td>小金属</td>\n",
       "      <td>福建</td>\n",
       "      <td>26.15</td>\n",
       "      <td>14.97</td>\n",
       "      <td>16.77</td>\n",
       "      <td>1125400.88</td>\n",
       "      <td>590581.00</td>\n",
       "      <td>76470.36</td>\n",
       "      <td>...</td>\n",
       "      <td>3.11</td>\n",
       "      <td>1996-05-31</td>\n",
       "      <td>104130.27</td>\n",
       "      <td>0.62</td>\n",
       "      <td>62.61</td>\n",
       "      <td>223.67</td>\n",
       "      <td>6.85</td>\n",
       "      <td>2.95</td>\n",
       "      <td>106700.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-08-21</th>\n",
       "      <td>002160</td>\n",
       "      <td>常铝股份</td>\n",
       "      <td>铝</td>\n",
       "      <td>江苏</td>\n",
       "      <td>32.31</td>\n",
       "      <td>4.72</td>\n",
       "      <td>7.24</td>\n",
       "      <td>622252.69</td>\n",
       "      <td>297916.59</td>\n",
       "      <td>151107.36</td>\n",
       "      <td>...</td>\n",
       "      <td>1.45</td>\n",
       "      <td>2007-08-21</td>\n",
       "      <td>27155.90</td>\n",
       "      <td>0.37</td>\n",
       "      <td>40.03</td>\n",
       "      <td>56.07</td>\n",
       "      <td>17.64</td>\n",
       "      <td>3.84</td>\n",
       "      <td>50000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997-05-08</th>\n",
       "      <td>000717</td>\n",
       "      <td>韶钢松山</td>\n",
       "      <td>普钢</td>\n",
       "      <td>广东</td>\n",
       "      <td>6.32</td>\n",
       "      <td>24.20</td>\n",
       "      <td>24.20</td>\n",
       "      <td>1441538.00</td>\n",
       "      <td>440514.44</td>\n",
       "      <td>801547.88</td>\n",
       "      <td>...</td>\n",
       "      <td>5.35</td>\n",
       "      <td>1997-05-08</td>\n",
       "      <td>-331470.38</td>\n",
       "      <td>-1.37</td>\n",
       "      <td>86.35</td>\n",
       "      <td>2381.13</td>\n",
       "      <td>13.26</td>\n",
       "      <td>9.66</td>\n",
       "      <td>132008.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996-05-03</th>\n",
       "      <td>600896</td>\n",
       "      <td>览海投资</td>\n",
       "      <td>水运</td>\n",
       "      <td>海南</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.77</td>\n",
       "      <td>8.69</td>\n",
       "      <td>448937.09</td>\n",
       "      <td>363976.13</td>\n",
       "      <td>453.85</td>\n",
       "      <td>...</td>\n",
       "      <td>2.74</td>\n",
       "      <td>1996-05-03</td>\n",
       "      <td>-60134.50</td>\n",
       "      <td>-0.69</td>\n",
       "      <td>-94.80</td>\n",
       "      <td>18.38</td>\n",
       "      <td>91.85</td>\n",
       "      <td>-416.75</td>\n",
       "      <td>43837.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997-06-25</th>\n",
       "      <td>000819</td>\n",
       "      <td>岳阳兴长</td>\n",
       "      <td>石油加工</td>\n",
       "      <td>湖南</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.71</td>\n",
       "      <td>2.71</td>\n",
       "      <td>81995.88</td>\n",
       "      <td>59217.63</td>\n",
       "      <td>17258.00</td>\n",
       "      <td>...</td>\n",
       "      <td>4.92</td>\n",
       "      <td>1997-06-25</td>\n",
       "      <td>19668.43</td>\n",
       "      <td>0.72</td>\n",
       "      <td>16.55</td>\n",
       "      <td>-132.47</td>\n",
       "      <td>8.32</td>\n",
       "      <td>-0.62</td>\n",
       "      <td>31400.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-26</th>\n",
       "      <td>600929</td>\n",
       "      <td>湖南盐业</td>\n",
       "      <td>食品</td>\n",
       "      <td>湖南</td>\n",
       "      <td>72.52</td>\n",
       "      <td>1.50</td>\n",
       "      <td>9.18</td>\n",
       "      <td>310491.63</td>\n",
       "      <td>78859.31</td>\n",
       "      <td>139873.81</td>\n",
       "      <td>...</td>\n",
       "      <td>5.36</td>\n",
       "      <td>2018-03-26</td>\n",
       "      <td>71625.13</td>\n",
       "      <td>0.78</td>\n",
       "      <td>1.30</td>\n",
       "      <td>15.06</td>\n",
       "      <td>47.71</td>\n",
       "      <td>7.24</td>\n",
       "      <td>140295.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-04-30</th>\n",
       "      <td>300076</td>\n",
       "      <td>GQY视讯</td>\n",
       "      <td>电脑设备</td>\n",
       "      <td>浙江</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.68</td>\n",
       "      <td>4.24</td>\n",
       "      <td>116227.61</td>\n",
       "      <td>76413.81</td>\n",
       "      <td>21807.57</td>\n",
       "      <td>...</td>\n",
       "      <td>2.35</td>\n",
       "      <td>2010-04-30</td>\n",
       "      <td>10759.37</td>\n",
       "      <td>0.25</td>\n",
       "      <td>-40.70</td>\n",
       "      <td>-1298.93</td>\n",
       "      <td>35.65</td>\n",
       "      <td>-29.91</td>\n",
       "      <td>41000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007-08-03</th>\n",
       "      <td>002144</td>\n",
       "      <td>宏达高科</td>\n",
       "      <td>纺织</td>\n",
       "      <td>浙江</td>\n",
       "      <td>26.28</td>\n",
       "      <td>1.36</td>\n",
       "      <td>1.77</td>\n",
       "      <td>199379.38</td>\n",
       "      <td>51652.78</td>\n",
       "      <td>28723.63</td>\n",
       "      <td>...</td>\n",
       "      <td>1.51</td>\n",
       "      <td>2007-08-03</td>\n",
       "      <td>52805.73</td>\n",
       "      <td>2.99</td>\n",
       "      <td>12.73</td>\n",
       "      <td>-6.03</td>\n",
       "      <td>29.92</td>\n",
       "      <td>15.71</td>\n",
       "      <td>21057.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-16</th>\n",
       "      <td>300621</td>\n",
       "      <td>维业股份</td>\n",
       "      <td>装修装饰</td>\n",
       "      <td>深圳</td>\n",
       "      <td>37.99</td>\n",
       "      <td>0.43</td>\n",
       "      <td>1.39</td>\n",
       "      <td>186181.06</td>\n",
       "      <td>169977.59</td>\n",
       "      <td>2515.88</td>\n",
       "      <td>...</td>\n",
       "      <td>3.41</td>\n",
       "      <td>2017-03-16</td>\n",
       "      <td>26666.50</td>\n",
       "      <td>1.92</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>13.34</td>\n",
       "      <td>4.22</td>\n",
       "      <td>19044.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-20</th>\n",
       "      <td>603106</td>\n",
       "      <td>恒银金融</td>\n",
       "      <td>电脑设备</td>\n",
       "      <td>天津</td>\n",
       "      <td>45.40</td>\n",
       "      <td>0.70</td>\n",
       "      <td>2.80</td>\n",
       "      <td>212309.42</td>\n",
       "      <td>190471.27</td>\n",
       "      <td>16428.07</td>\n",
       "      <td>...</td>\n",
       "      <td>4.80</td>\n",
       "      <td>2017-09-20</td>\n",
       "      <td>27721.10</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33.95</td>\n",
       "      <td>11.23</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-15</th>\n",
       "      <td>603811</td>\n",
       "      <td>诚意药业</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>浙江</td>\n",
       "      <td>38.80</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.85</td>\n",
       "      <td>67298.32</td>\n",
       "      <td>46722.62</td>\n",
       "      <td>12191.86</td>\n",
       "      <td>...</td>\n",
       "      <td>4.48</td>\n",
       "      <td>2017-03-15</td>\n",
       "      <td>9561.42</td>\n",
       "      <td>1.12</td>\n",
       "      <td>6.12</td>\n",
       "      <td>1.57</td>\n",
       "      <td>52.11</td>\n",
       "      <td>20.31</td>\n",
       "      <td>10574.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-28</th>\n",
       "      <td>002930</td>\n",
       "      <td>宏川智慧</td>\n",
       "      <td>仓储物流</td>\n",
       "      <td>广东</td>\n",
       "      <td>62.90</td>\n",
       "      <td>0.61</td>\n",
       "      <td>2.43</td>\n",
       "      <td>187270.80</td>\n",
       "      <td>13539.20</td>\n",
       "      <td>103894.40</td>\n",
       "      <td>...</td>\n",
       "      <td>3.66</td>\n",
       "      <td>2018-03-28</td>\n",
       "      <td>38270.21</td>\n",
       "      <td>1.57</td>\n",
       "      <td>-0.74</td>\n",
       "      <td>10.33</td>\n",
       "      <td>56.59</td>\n",
       "      <td>25.41</td>\n",
       "      <td>115500.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-22</th>\n",
       "      <td>603963</td>\n",
       "      <td>大理药业</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>云南</td>\n",
       "      <td>73.92</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.00</td>\n",
       "      <td>62622.20</td>\n",
       "      <td>44925.30</td>\n",
       "      <td>10986.69</td>\n",
       "      <td>...</td>\n",
       "      <td>8.40</td>\n",
       "      <td>2017-09-22</td>\n",
       "      <td>9541.13</td>\n",
       "      <td>0.95</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>63.85</td>\n",
       "      <td>20.00</td>\n",
       "      <td>27488.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-30</th>\n",
       "      <td>603214</td>\n",
       "      <td>爱婴室</td>\n",
       "      <td>百货</td>\n",
       "      <td>上海</td>\n",
       "      <td>49.45</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.00</td>\n",
       "      <td>76961.15</td>\n",
       "      <td>61297.16</td>\n",
       "      <td>7078.72</td>\n",
       "      <td>...</td>\n",
       "      <td>9.27</td>\n",
       "      <td>2018-03-30</td>\n",
       "      <td>25456.17</td>\n",
       "      <td>2.55</td>\n",
       "      <td>14.06</td>\n",
       "      <td>26.47</td>\n",
       "      <td>28.41</td>\n",
       "      <td>5.18</td>\n",
       "      <td>26639.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-17</th>\n",
       "      <td>300595</td>\n",
       "      <td>欧普康视</td>\n",
       "      <td>医疗保健</td>\n",
       "      <td>安徽</td>\n",
       "      <td>54.16</td>\n",
       "      <td>0.76</td>\n",
       "      <td>1.24</td>\n",
       "      <td>84769.46</td>\n",
       "      <td>71856.96</td>\n",
       "      <td>3970.03</td>\n",
       "      <td>...</td>\n",
       "      <td>10.12</td>\n",
       "      <td>2017-01-17</td>\n",
       "      <td>20604.49</td>\n",
       "      <td>1.66</td>\n",
       "      <td>31.61</td>\n",
       "      <td>29.56</td>\n",
       "      <td>76.06</td>\n",
       "      <td>50.72</td>\n",
       "      <td>6781.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-21</th>\n",
       "      <td>300627</td>\n",
       "      <td>华测导航</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>上海</td>\n",
       "      <td>85.66</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1.23</td>\n",
       "      <td>95269.30</td>\n",
       "      <td>88869.28</td>\n",
       "      <td>2105.35</td>\n",
       "      <td>...</td>\n",
       "      <td>9.13</td>\n",
       "      <td>2017-03-21</td>\n",
       "      <td>19288.67</td>\n",
       "      <td>1.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>54.56</td>\n",
       "      <td>14.97</td>\n",
       "      <td>16380.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-08</th>\n",
       "      <td>603637</td>\n",
       "      <td>镇海股份</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>浙江</td>\n",
       "      <td>66.69</td>\n",
       "      <td>0.33</td>\n",
       "      <td>1.33</td>\n",
       "      <td>86330.46</td>\n",
       "      <td>76018.32</td>\n",
       "      <td>5968.18</td>\n",
       "      <td>...</td>\n",
       "      <td>4.33</td>\n",
       "      <td>2017-02-08</td>\n",
       "      <td>20656.95</td>\n",
       "      <td>1.55</td>\n",
       "      <td>-37.75</td>\n",
       "      <td>-28.91</td>\n",
       "      <td>31.54</td>\n",
       "      <td>22.63</td>\n",
       "      <td>9897.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-10-10</th>\n",
       "      <td>300705</td>\n",
       "      <td>九典制药</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>湖南</td>\n",
       "      <td>89.94</td>\n",
       "      <td>0.29</td>\n",
       "      <td>1.17</td>\n",
       "      <td>76920.25</td>\n",
       "      <td>51869.26</td>\n",
       "      <td>13084.78</td>\n",
       "      <td>...</td>\n",
       "      <td>9.34</td>\n",
       "      <td>2017-10-10</td>\n",
       "      <td>12709.62</td>\n",
       "      <td>1.08</td>\n",
       "      <td>42.01</td>\n",
       "      <td>25.76</td>\n",
       "      <td>51.93</td>\n",
       "      <td>12.83</td>\n",
       "      <td>21243.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-10-31</th>\n",
       "      <td>603289</td>\n",
       "      <td>泰瑞机器</td>\n",
       "      <td>专用机械</td>\n",
       "      <td>浙江</td>\n",
       "      <td>45.82</td>\n",
       "      <td>0.51</td>\n",
       "      <td>2.04</td>\n",
       "      <td>88554.82</td>\n",
       "      <td>68437.21</td>\n",
       "      <td>15267.82</td>\n",
       "      <td>...</td>\n",
       "      <td>5.65</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>26118.49</td>\n",
       "      <td>1.28</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>30.63</td>\n",
       "      <td>12.40</td>\n",
       "      <td>48514.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-09</th>\n",
       "      <td>603229</td>\n",
       "      <td>奥翔药业</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>浙江</td>\n",
       "      <td>93.03</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.60</td>\n",
       "      <td>68624.13</td>\n",
       "      <td>45903.00</td>\n",
       "      <td>14470.87</td>\n",
       "      <td>...</td>\n",
       "      <td>7.22</td>\n",
       "      <td>2017-05-09</td>\n",
       "      <td>14151.70</td>\n",
       "      <td>0.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>60.63</td>\n",
       "      <td>22.65</td>\n",
       "      <td>14088.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-02</th>\n",
       "      <td>300660</td>\n",
       "      <td>江苏雷利</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>江苏</td>\n",
       "      <td>26.10</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.02</td>\n",
       "      <td>280316.22</td>\n",
       "      <td>256656.80</td>\n",
       "      <td>16994.20</td>\n",
       "      <td>...</td>\n",
       "      <td>3.21</td>\n",
       "      <td>2017-06-02</td>\n",
       "      <td>33226.21</td>\n",
       "      <td>3.26</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26.74</td>\n",
       "      <td>12.07</td>\n",
       "      <td>18283.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-08-02</th>\n",
       "      <td>300529</td>\n",
       "      <td>健帆生物</td>\n",
       "      <td>医疗保健</td>\n",
       "      <td>广东</td>\n",
       "      <td>62.99</td>\n",
       "      <td>1.06</td>\n",
       "      <td>4.18</td>\n",
       "      <td>170240.02</td>\n",
       "      <td>123065.95</td>\n",
       "      <td>32537.78</td>\n",
       "      <td>...</td>\n",
       "      <td>12.85</td>\n",
       "      <td>2016-08-02</td>\n",
       "      <td>48161.67</td>\n",
       "      <td>1.15</td>\n",
       "      <td>32.16</td>\n",
       "      <td>40.72</td>\n",
       "      <td>84.14</td>\n",
       "      <td>39.58</td>\n",
       "      <td>22527.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-22</th>\n",
       "      <td>002900</td>\n",
       "      <td>哈三联</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>黑龙江</td>\n",
       "      <td>44.11</td>\n",
       "      <td>0.53</td>\n",
       "      <td>2.11</td>\n",
       "      <td>218374.66</td>\n",
       "      <td>135898.92</td>\n",
       "      <td>68163.18</td>\n",
       "      <td>...</td>\n",
       "      <td>4.35</td>\n",
       "      <td>2017-09-22</td>\n",
       "      <td>39189.78</td>\n",
       "      <td>1.86</td>\n",
       "      <td>50.99</td>\n",
       "      <td>3.36</td>\n",
       "      <td>74.17</td>\n",
       "      <td>15.76</td>\n",
       "      <td>38400.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-19</th>\n",
       "      <td>002873</td>\n",
       "      <td>新天药业</td>\n",
       "      <td>中成药</td>\n",
       "      <td>贵州</td>\n",
       "      <td>44.54</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.69</td>\n",
       "      <td>91925.27</td>\n",
       "      <td>57405.90</td>\n",
       "      <td>21257.95</td>\n",
       "      <td>...</td>\n",
       "      <td>5.89</td>\n",
       "      <td>2017-05-19</td>\n",
       "      <td>18090.75</td>\n",
       "      <td>2.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>81.09</td>\n",
       "      <td>11.75</td>\n",
       "      <td>9615.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-03</th>\n",
       "      <td>002350</td>\n",
       "      <td>北京科锐</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>北京</td>\n",
       "      <td>184.53</td>\n",
       "      <td>3.76</td>\n",
       "      <td>3.87</td>\n",
       "      <td>280886.13</td>\n",
       "      <td>197356.56</td>\n",
       "      <td>42124.90</td>\n",
       "      <td>...</td>\n",
       "      <td>3.11</td>\n",
       "      <td>2010-02-03</td>\n",
       "      <td>34932.31</td>\n",
       "      <td>0.90</td>\n",
       "      <td>23.04</td>\n",
       "      <td>-44.28</td>\n",
       "      <td>23.27</td>\n",
       "      <td>1.03</td>\n",
       "      <td>52854.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008-05-16</th>\n",
       "      <td>002235</td>\n",
       "      <td>安妮股份</td>\n",
       "      <td>造纸</td>\n",
       "      <td>福建</td>\n",
       "      <td>58.10</td>\n",
       "      <td>3.34</td>\n",
       "      <td>4.16</td>\n",
       "      <td>272703.47</td>\n",
       "      <td>126430.06</td>\n",
       "      <td>19098.98</td>\n",
       "      <td>...</td>\n",
       "      <td>2.01</td>\n",
       "      <td>2008-05-16</td>\n",
       "      <td>5426.16</td>\n",
       "      <td>0.13</td>\n",
       "      <td>66.06</td>\n",
       "      <td>473.50</td>\n",
       "      <td>31.63</td>\n",
       "      <td>14.46</td>\n",
       "      <td>30659.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-08-10</th>\n",
       "      <td>300688</td>\n",
       "      <td>创业黑马</td>\n",
       "      <td>综合类</td>\n",
       "      <td>北京</td>\n",
       "      <td>171.33</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.68</td>\n",
       "      <td>41396.55</td>\n",
       "      <td>40351.37</td>\n",
       "      <td>380.64</td>\n",
       "      <td>...</td>\n",
       "      <td>14.13</td>\n",
       "      <td>2017-08-10</td>\n",
       "      <td>6212.93</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>56.91</td>\n",
       "      <td>17.97</td>\n",
       "      <td>15720.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-26</th>\n",
       "      <td>603712</td>\n",
       "      <td>七一二</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>天津</td>\n",
       "      <td>363.05</td>\n",
       "      <td>1.00</td>\n",
       "      <td>7.72</td>\n",
       "      <td>348015.50</td>\n",
       "      <td>277392.63</td>\n",
       "      <td>57633.35</td>\n",
       "      <td>...</td>\n",
       "      <td>21.08</td>\n",
       "      <td>2018-02-26</td>\n",
       "      <td>20558.85</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>49.57</td>\n",
       "      <td>8.39</td>\n",
       "      <td>88473.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-09-10</th>\n",
       "      <td>300392</td>\n",
       "      <td>腾信股份</td>\n",
       "      <td>互联网</td>\n",
       "      <td>北京</td>\n",
       "      <td>192.02</td>\n",
       "      <td>1.64</td>\n",
       "      <td>3.84</td>\n",
       "      <td>150430.13</td>\n",
       "      <td>116865.26</td>\n",
       "      <td>14213.17</td>\n",
       "      <td>...</td>\n",
       "      <td>7.38</td>\n",
       "      <td>2014-09-10</td>\n",
       "      <td>11726.03</td>\n",
       "      <td>0.31</td>\n",
       "      <td>17.47</td>\n",
       "      <td>324.13</td>\n",
       "      <td>10.24</td>\n",
       "      <td>1.53</td>\n",
       "      <td>27346.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-03-25</th>\n",
       "      <td>600209</td>\n",
       "      <td>罗顿发展</td>\n",
       "      <td>综合类</td>\n",
       "      <td>海南</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.26</td>\n",
       "      <td>4.39</td>\n",
       "      <td>86705.93</td>\n",
       "      <td>23242.80</td>\n",
       "      <td>16197.40</td>\n",
       "      <td>...</td>\n",
       "      <td>6.31</td>\n",
       "      <td>1999-03-25</td>\n",
       "      <td>5083.85</td>\n",
       "      <td>0.12</td>\n",
       "      <td>53.01</td>\n",
       "      <td>51.86</td>\n",
       "      <td>4.02</td>\n",
       "      <td>-30.81</td>\n",
       "      <td>59619.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997-06-11</th>\n",
       "      <td>000735</td>\n",
       "      <td>罗 牛 山</td>\n",
       "      <td>农业综合</td>\n",
       "      <td>海南</td>\n",
       "      <td>54.68</td>\n",
       "      <td>10.60</td>\n",
       "      <td>11.52</td>\n",
       "      <td>618940.00</td>\n",
       "      <td>207991.38</td>\n",
       "      <td>180241.88</td>\n",
       "      <td>...</td>\n",
       "      <td>3.02</td>\n",
       "      <td>1997-06-11</td>\n",
       "      <td>72196.31</td>\n",
       "      <td>0.63</td>\n",
       "      <td>116.29</td>\n",
       "      <td>85.11</td>\n",
       "      <td>30.92</td>\n",
       "      <td>13.88</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-02-11</th>\n",
       "      <td>300054</td>\n",
       "      <td>鼎龙股份</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>湖北</td>\n",
       "      <td>30.93</td>\n",
       "      <td>6.65</td>\n",
       "      <td>9.61</td>\n",
       "      <td>397465.50</td>\n",
       "      <td>226564.66</td>\n",
       "      <td>47543.53</td>\n",
       "      <td>...</td>\n",
       "      <td>2.70</td>\n",
       "      <td>2010-02-11</td>\n",
       "      <td>77185.90</td>\n",
       "      <td>0.80</td>\n",
       "      <td>35.41</td>\n",
       "      <td>30.84</td>\n",
       "      <td>36.67</td>\n",
       "      <td>18.24</td>\n",
       "      <td>17874.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1997-01-28</th>\n",
       "      <td>000613</td>\n",
       "      <td>大东海A</td>\n",
       "      <td>旅游服务</td>\n",
       "      <td>海南</td>\n",
       "      <td>1574.13</td>\n",
       "      <td>2.66</td>\n",
       "      <td>3.64</td>\n",
       "      <td>8746.66</td>\n",
       "      <td>1382.31</td>\n",
       "      <td>3908.87</td>\n",
       "      <td>...</td>\n",
       "      <td>58.34</td>\n",
       "      <td>1997-01-28</td>\n",
       "      <td>-34110.73</td>\n",
       "      <td>-0.94</td>\n",
       "      <td>28.55</td>\n",
       "      <td>207.44</td>\n",
       "      <td>60.08</td>\n",
       "      <td>10.24</td>\n",
       "      <td>20000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-03-22</th>\n",
       "      <td>300484</td>\n",
       "      <td>蓝海华腾</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>深圳</td>\n",
       "      <td>25.00</td>\n",
       "      <td>0.94</td>\n",
       "      <td>2.08</td>\n",
       "      <td>103367.36</td>\n",
       "      <td>90467.02</td>\n",
       "      <td>3893.34</td>\n",
       "      <td>...</td>\n",
       "      <td>5.06</td>\n",
       "      <td>2016-03-22</td>\n",
       "      <td>35972.95</td>\n",
       "      <td>1.73</td>\n",
       "      <td>2.54</td>\n",
       "      <td>0.94</td>\n",
       "      <td>39.27</td>\n",
       "      <td>24.14</td>\n",
       "      <td>14835.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-03-18</th>\n",
       "      <td>300433</td>\n",
       "      <td>蓝思科技</td>\n",
       "      <td>元器件</td>\n",
       "      <td>湖南</td>\n",
       "      <td>46.39</td>\n",
       "      <td>4.44</td>\n",
       "      <td>26.29</td>\n",
       "      <td>3134060.00</td>\n",
       "      <td>1093617.13</td>\n",
       "      <td>1565460.63</td>\n",
       "      <td>...</td>\n",
       "      <td>3.24</td>\n",
       "      <td>2015-03-18</td>\n",
       "      <td>823279.00</td>\n",
       "      <td>3.13</td>\n",
       "      <td>41.93</td>\n",
       "      <td>12.39</td>\n",
       "      <td>25.00</td>\n",
       "      <td>5.91</td>\n",
       "      <td>35003.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-06</th>\n",
       "      <td>300661</td>\n",
       "      <td>圣邦股份</td>\n",
       "      <td>元器件</td>\n",
       "      <td>北京</td>\n",
       "      <td>87.02</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.61</td>\n",
       "      <td>86190.96</td>\n",
       "      <td>82643.93</td>\n",
       "      <td>1150.35</td>\n",
       "      <td>...</td>\n",
       "      <td>8.73</td>\n",
       "      <td>2017-06-06</td>\n",
       "      <td>19735.47</td>\n",
       "      <td>3.24</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>43.62</td>\n",
       "      <td>16.02</td>\n",
       "      <td>5677.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-05</th>\n",
       "      <td>300588</td>\n",
       "      <td>熙菱信息</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>新疆</td>\n",
       "      <td>65.77</td>\n",
       "      <td>0.31</td>\n",
       "      <td>1.00</td>\n",
       "      <td>84675.42</td>\n",
       "      <td>79111.96</td>\n",
       "      <td>736.22</td>\n",
       "      <td>...</td>\n",
       "      <td>8.19</td>\n",
       "      <td>2017-01-05</td>\n",
       "      <td>13293.88</td>\n",
       "      <td>1.33</td>\n",
       "      <td>35.56</td>\n",
       "      <td>85.39</td>\n",
       "      <td>24.81</td>\n",
       "      <td>7.47</td>\n",
       "      <td>10945.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-26</th>\n",
       "      <td>300603</td>\n",
       "      <td>立昂技术</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>新疆</td>\n",
       "      <td>47.46</td>\n",
       "      <td>0.57</td>\n",
       "      <td>1.03</td>\n",
       "      <td>124445.82</td>\n",
       "      <td>99134.21</td>\n",
       "      <td>2345.56</td>\n",
       "      <td>...</td>\n",
       "      <td>8.70</td>\n",
       "      <td>2017-01-26</td>\n",
       "      <td>16070.23</td>\n",
       "      <td>1.57</td>\n",
       "      <td>247.32</td>\n",
       "      <td>259.16</td>\n",
       "      <td>20.03</td>\n",
       "      <td>8.61</td>\n",
       "      <td>11752.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-11-09</th>\n",
       "      <td>300719</td>\n",
       "      <td>安达维尔</td>\n",
       "      <td>航空</td>\n",
       "      <td>北京</td>\n",
       "      <td>53.58</td>\n",
       "      <td>0.42</td>\n",
       "      <td>1.68</td>\n",
       "      <td>111330.52</td>\n",
       "      <td>99828.74</td>\n",
       "      <td>9335.78</td>\n",
       "      <td>...</td>\n",
       "      <td>5.00</td>\n",
       "      <td>2017-11-09</td>\n",
       "      <td>26470.75</td>\n",
       "      <td>1.58</td>\n",
       "      <td>10.59</td>\n",
       "      <td>-1.52</td>\n",
       "      <td>53.67</td>\n",
       "      <td>20.42</td>\n",
       "      <td>25100.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009-12-16</th>\n",
       "      <td>002320</td>\n",
       "      <td>海峡股份</td>\n",
       "      <td>水运</td>\n",
       "      <td>海南</td>\n",
       "      <td>74.69</td>\n",
       "      <td>4.30</td>\n",
       "      <td>5.08</td>\n",
       "      <td>390513.69</td>\n",
       "      <td>136325.91</td>\n",
       "      <td>235803.70</td>\n",
       "      <td>...</td>\n",
       "      <td>4.75</td>\n",
       "      <td>2009-12-16</td>\n",
       "      <td>79676.13</td>\n",
       "      <td>1.57</td>\n",
       "      <td>26.15</td>\n",
       "      <td>64.71</td>\n",
       "      <td>42.13</td>\n",
       "      <td>23.29</td>\n",
       "      <td>17700.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-08-03</th>\n",
       "      <td>300687</td>\n",
       "      <td>赛意信息</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>广东</td>\n",
       "      <td>52.57</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.80</td>\n",
       "      <td>83921.68</td>\n",
       "      <td>80942.17</td>\n",
       "      <td>291.20</td>\n",
       "      <td>...</td>\n",
       "      <td>6.36</td>\n",
       "      <td>2017-08-03</td>\n",
       "      <td>14224.57</td>\n",
       "      <td>1.78</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>31.36</td>\n",
       "      <td>13.34</td>\n",
       "      <td>13585.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-05-20</th>\n",
       "      <td>300083</td>\n",
       "      <td>劲胜智能</td>\n",
       "      <td>元器件</td>\n",
       "      <td>广东</td>\n",
       "      <td>16.41</td>\n",
       "      <td>11.91</td>\n",
       "      <td>14.32</td>\n",
       "      <td>1144811.25</td>\n",
       "      <td>728822.63</td>\n",
       "      <td>176756.77</td>\n",
       "      <td>...</td>\n",
       "      <td>1.64</td>\n",
       "      <td>2010-05-20</td>\n",
       "      <td>39800.05</td>\n",
       "      <td>0.28</td>\n",
       "      <td>31.86</td>\n",
       "      <td>424.03</td>\n",
       "      <td>27.29</td>\n",
       "      <td>8.96</td>\n",
       "      <td>47930.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008-05-08</th>\n",
       "      <td>002229</td>\n",
       "      <td>鸿博股份</td>\n",
       "      <td>广告包装</td>\n",
       "      <td>福建</td>\n",
       "      <td>525.65</td>\n",
       "      <td>4.15</td>\n",
       "      <td>5.03</td>\n",
       "      <td>210997.52</td>\n",
       "      <td>117592.22</td>\n",
       "      <td>61739.38</td>\n",
       "      <td>...</td>\n",
       "      <td>3.45</td>\n",
       "      <td>2008-05-08</td>\n",
       "      <td>21342.10</td>\n",
       "      <td>0.42</td>\n",
       "      <td>-17.88</td>\n",
       "      <td>-15.14</td>\n",
       "      <td>24.06</td>\n",
       "      <td>1.55</td>\n",
       "      <td>40500.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-10-19</th>\n",
       "      <td>300709</td>\n",
       "      <td>精研科技</td>\n",
       "      <td>元器件</td>\n",
       "      <td>江苏</td>\n",
       "      <td>31.01</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.88</td>\n",
       "      <td>104817.97</td>\n",
       "      <td>51288.05</td>\n",
       "      <td>36566.43</td>\n",
       "      <td>...</td>\n",
       "      <td>3.83</td>\n",
       "      <td>2017-10-19</td>\n",
       "      <td>26389.69</td>\n",
       "      <td>3.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>40.49</td>\n",
       "      <td>17.04</td>\n",
       "      <td>16000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-16</th>\n",
       "      <td>300653</td>\n",
       "      <td>正海生物</td>\n",
       "      <td>医疗保健</td>\n",
       "      <td>山东</td>\n",
       "      <td>65.83</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.80</td>\n",
       "      <td>53081.60</td>\n",
       "      <td>45645.28</td>\n",
       "      <td>2500.00</td>\n",
       "      <td>...</td>\n",
       "      <td>8.40</td>\n",
       "      <td>2017-05-16</td>\n",
       "      <td>12030.73</td>\n",
       "      <td>1.50</td>\n",
       "      <td>21.35</td>\n",
       "      <td>35.63</td>\n",
       "      <td>93.67</td>\n",
       "      <td>33.74</td>\n",
       "      <td>8714.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-11-27</th>\n",
       "      <td>300727</td>\n",
       "      <td>润禾材料</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>浙江</td>\n",
       "      <td>90.09</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.98</td>\n",
       "      <td>43196.92</td>\n",
       "      <td>25291.61</td>\n",
       "      <td>12968.00</td>\n",
       "      <td>...</td>\n",
       "      <td>8.96</td>\n",
       "      <td>2017-11-27</td>\n",
       "      <td>8362.07</td>\n",
       "      <td>0.86</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.56</td>\n",
       "      <td>10.75</td>\n",
       "      <td>50562.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-01-25</th>\n",
       "      <td>300166</td>\n",
       "      <td>东方国信</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>北京</td>\n",
       "      <td>78.81</td>\n",
       "      <td>8.06</td>\n",
       "      <td>10.50</td>\n",
       "      <td>468344.94</td>\n",
       "      <td>273063.00</td>\n",
       "      <td>22614.40</td>\n",
       "      <td>...</td>\n",
       "      <td>3.72</td>\n",
       "      <td>2011-01-25</td>\n",
       "      <td>97738.21</td>\n",
       "      <td>0.93</td>\n",
       "      <td>18.86</td>\n",
       "      <td>30.89</td>\n",
       "      <td>45.86</td>\n",
       "      <td>19.72</td>\n",
       "      <td>35285.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-03-24</th>\n",
       "      <td>603729</td>\n",
       "      <td>龙韵股份</td>\n",
       "      <td>广告包装</td>\n",
       "      <td>上海</td>\n",
       "      <td>176.04</td>\n",
       "      <td>0.67</td>\n",
       "      <td>0.67</td>\n",
       "      <td>97434.93</td>\n",
       "      <td>82516.06</td>\n",
       "      <td>7244.75</td>\n",
       "      <td>...</td>\n",
       "      <td>4.19</td>\n",
       "      <td>2015-03-24</td>\n",
       "      <td>46754.80</td>\n",
       "      <td>7.01</td>\n",
       "      <td>-6.88</td>\n",
       "      <td>-53.62</td>\n",
       "      <td>10.85</td>\n",
       "      <td>2.04</td>\n",
       "      <td>5819.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-23</th>\n",
       "      <td>300657</td>\n",
       "      <td>弘信电子</td>\n",
       "      <td>元器件</td>\n",
       "      <td>福建</td>\n",
       "      <td>67.08</td>\n",
       "      <td>0.26</td>\n",
       "      <td>1.04</td>\n",
       "      <td>184841.84</td>\n",
       "      <td>111414.60</td>\n",
       "      <td>59763.01</td>\n",
       "      <td>...</td>\n",
       "      <td>6.42</td>\n",
       "      <td>2017-05-23</td>\n",
       "      <td>18206.14</td>\n",
       "      <td>1.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>13.57</td>\n",
       "      <td>3.79</td>\n",
       "      <td>11765.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-03-03</th>\n",
       "      <td>300502</td>\n",
       "      <td>新易盛</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>四川</td>\n",
       "      <td>39.29</td>\n",
       "      <td>1.25</td>\n",
       "      <td>2.38</td>\n",
       "      <td>135900.52</td>\n",
       "      <td>100870.77</td>\n",
       "      <td>29193.11</td>\n",
       "      <td>...</td>\n",
       "      <td>4.65</td>\n",
       "      <td>2016-03-03</td>\n",
       "      <td>48375.46</td>\n",
       "      <td>2.03</td>\n",
       "      <td>29.88</td>\n",
       "      <td>20.03</td>\n",
       "      <td>25.61</td>\n",
       "      <td>14.60</td>\n",
       "      <td>21261.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-12-09</th>\n",
       "      <td>000955</td>\n",
       "      <td>欣龙控股</td>\n",
       "      <td>纺织</td>\n",
       "      <td>海南</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.38</td>\n",
       "      <td>5.38</td>\n",
       "      <td>140784.42</td>\n",
       "      <td>68316.99</td>\n",
       "      <td>46174.09</td>\n",
       "      <td>...</td>\n",
       "      <td>5.76</td>\n",
       "      <td>1999-12-09</td>\n",
       "      <td>-40120.17</td>\n",
       "      <td>-0.75</td>\n",
       "      <td>36.59</td>\n",
       "      <td>-155.81</td>\n",
       "      <td>12.15</td>\n",
       "      <td>-9.58</td>\n",
       "      <td>33494.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-07-07</th>\n",
       "      <td>002596</td>\n",
       "      <td>海南瑞泽</td>\n",
       "      <td>其他建材</td>\n",
       "      <td>海南</td>\n",
       "      <td>76.57</td>\n",
       "      <td>7.26</td>\n",
       "      <td>10.74</td>\n",
       "      <td>498120.41</td>\n",
       "      <td>292194.84</td>\n",
       "      <td>59208.46</td>\n",
       "      <td>...</td>\n",
       "      <td>5.37</td>\n",
       "      <td>2011-07-07</td>\n",
       "      <td>63369.16</td>\n",
       "      <td>0.59</td>\n",
       "      <td>56.17</td>\n",
       "      <td>150.94</td>\n",
       "      <td>19.12</td>\n",
       "      <td>6.12</td>\n",
       "      <td>21200.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011-03-16</th>\n",
       "      <td>300189</td>\n",
       "      <td>神农基因</td>\n",
       "      <td>种植业</td>\n",
       "      <td>海南</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.82</td>\n",
       "      <td>10.24</td>\n",
       "      <td>260142.09</td>\n",
       "      <td>166160.41</td>\n",
       "      <td>29938.77</td>\n",
       "      <td>...</td>\n",
       "      <td>2.98</td>\n",
       "      <td>2011-03-16</td>\n",
       "      <td>9359.57</td>\n",
       "      <td>0.09</td>\n",
       "      <td>148.66</td>\n",
       "      <td>49.13</td>\n",
       "      <td>12.07</td>\n",
       "      <td>-1.20</td>\n",
       "      <td>62017.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1994-01-03</th>\n",
       "      <td>600806</td>\n",
       "      <td>*ST昆机</td>\n",
       "      <td>机床制造</td>\n",
       "      <td>云南</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3.90</td>\n",
       "      <td>5.31</td>\n",
       "      <td>193646.66</td>\n",
       "      <td>121889.97</td>\n",
       "      <td>45542.53</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1994-01-03</td>\n",
       "      <td>-45091.93</td>\n",
       "      <td>-0.85</td>\n",
       "      <td>21.07</td>\n",
       "      <td>-23.37</td>\n",
       "      <td>3.60</td>\n",
       "      <td>-51.43</td>\n",
       "      <td>33099.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003-09-05</th>\n",
       "      <td>600432</td>\n",
       "      <td>*ST吉恩</td>\n",
       "      <td>小金属</td>\n",
       "      <td>吉林</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16.04</td>\n",
       "      <td>16.04</td>\n",
       "      <td>1373541.75</td>\n",
       "      <td>297409.28</td>\n",
       "      <td>768094.25</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2003-09-05</td>\n",
       "      <td>-549617.19</td>\n",
       "      <td>-3.43</td>\n",
       "      <td>9.91</td>\n",
       "      <td>-56.24</td>\n",
       "      <td>15.12</td>\n",
       "      <td>-42.86</td>\n",
       "      <td>70654.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1999-09-16</th>\n",
       "      <td>000950</td>\n",
       "      <td>*ST建峰</td>\n",
       "      <td>农药化肥</td>\n",
       "      <td>重庆</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5.99</td>\n",
       "      <td>17.28</td>\n",
       "      <td>1562395.13</td>\n",
       "      <td>1296451.63</td>\n",
       "      <td>48986.46</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1999-09-16</td>\n",
       "      <td>193228.36</td>\n",
       "      <td>1.12</td>\n",
       "      <td>1.16</td>\n",
       "      <td>758.44</td>\n",
       "      <td>9.07</td>\n",
       "      <td>5.20</td>\n",
       "      <td>30624.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1996-11-15</th>\n",
       "      <td>000629</td>\n",
       "      <td>*ST钒钛</td>\n",
       "      <td>普钢</td>\n",
       "      <td>四川</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47.67</td>\n",
       "      <td>85.90</td>\n",
       "      <td>1047323.31</td>\n",
       "      <td>429526.09</td>\n",
       "      <td>468832.44</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1996-11-15</td>\n",
       "      <td>-1126974.13</td>\n",
       "      <td>-1.31</td>\n",
       "      <td>-11.07</td>\n",
       "      <td>114.42</td>\n",
       "      <td>17.74</td>\n",
       "      <td>9.15</td>\n",
       "      <td>309055.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1993-05-18</th>\n",
       "      <td>000511</td>\n",
       "      <td>*ST烯碳</td>\n",
       "      <td>矿物制品</td>\n",
       "      <td>辽宁</td>\n",
       "      <td>0.00</td>\n",
       "      <td>11.55</td>\n",
       "      <td>11.55</td>\n",
       "      <td>346274.91</td>\n",
       "      <td>312833.03</td>\n",
       "      <td>2405.45</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1993-05-18</td>\n",
       "      <td>-63425.48</td>\n",
       "      <td>-0.55</td>\n",
       "      <td>43.62</td>\n",
       "      <td>-55.46</td>\n",
       "      <td>0.22</td>\n",
       "      <td>-14.68</td>\n",
       "      <td>164822.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3506 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                code   name industry area       pe  outstanding  totals  \\\n",
       "timeToMarket                                                              \n",
       "2018-04-10    603897    N长城     电气设备   浙江    25.57         0.45    1.78   \n",
       "2012-10-09    300356   光一科技     电气设备   江苏   206.51         3.69    4.15   \n",
       "1996-05-31    600711   盛屯矿业      小金属   福建    26.15        14.97   16.77   \n",
       "2007-08-21    002160   常铝股份        铝   江苏    32.31         4.72    7.24   \n",
       "1997-05-08    000717   韶钢松山       普钢   广东     6.32        24.20   24.20   \n",
       "1996-05-03    600896   览海投资       水运   海南     0.00         5.77    8.69   \n",
       "1997-06-25    000819   岳阳兴长     石油加工   湖南     0.00         2.71    2.71   \n",
       "2018-03-26    600929   湖南盐业       食品   湖南    72.52         1.50    9.18   \n",
       "2010-04-30    300076  GQY视讯     电脑设备   浙江     0.00         3.68    4.24   \n",
       "2007-08-03    002144   宏达高科       纺织   浙江    26.28         1.36    1.77   \n",
       "2017-03-16    300621   维业股份     装修装饰   深圳    37.99         0.43    1.39   \n",
       "2017-09-20    603106   恒银金融     电脑设备   天津    45.40         0.70    2.80   \n",
       "2017-03-15    603811   诚意药业     化学制药   浙江    38.80         0.57    0.85   \n",
       "2018-03-28    002930   宏川智慧     仓储物流   广东    62.90         0.61    2.43   \n",
       "2017-09-22    603963   大理药业     化学制药   云南    73.92         0.25    1.00   \n",
       "2018-03-30    603214    爱婴室       百货   上海    49.45         0.25    1.00   \n",
       "2017-01-17    300595   欧普康视     医疗保健   安徽    54.16         0.76    1.24   \n",
       "2017-03-21    300627   华测导航     通信设备   上海    85.66         0.50    1.23   \n",
       "2017-02-08    603637   镇海股份     建筑施工   浙江    66.69         0.33    1.33   \n",
       "2017-10-10    300705   九典制药     化学制药   湖南    89.94         0.29    1.17   \n",
       "2017-10-31    603289   泰瑞机器     专用机械   浙江    45.82         0.51    2.04   \n",
       "2017-05-09    603229   奥翔药业     化学制药   浙江    93.03         0.40    1.60   \n",
       "2017-06-02    300660   江苏雷利     电气设备   江苏    26.10         0.25    1.02   \n",
       "2016-08-02    300529   健帆生物     医疗保健   广东    62.99         1.06    4.18   \n",
       "2017-09-22    002900    哈三联     化学制药  黑龙江    44.11         0.53    2.11   \n",
       "2017-05-19    002873   新天药业      中成药   贵州    44.54         0.17    0.69   \n",
       "2010-02-03    002350   北京科锐     电气设备   北京   184.53         3.76    3.87   \n",
       "2008-05-16    002235   安妮股份       造纸   福建    58.10         3.34    4.16   \n",
       "2017-08-10    300688   创业黑马      综合类   北京   171.33         0.17    0.68   \n",
       "2018-02-26    603712    七一二     通信设备   天津   363.05         1.00    7.72   \n",
       "...              ...    ...      ...  ...      ...          ...     ...   \n",
       "2014-09-10    300392   腾信股份      互联网   北京   192.02         1.64    3.84   \n",
       "1999-03-25    600209   罗顿发展      综合类   海南     0.00         4.26    4.39   \n",
       "1997-06-11    000735  罗 牛 山     农业综合   海南    54.68        10.60   11.52   \n",
       "2010-02-11    300054   鼎龙股份     化工原料   湖北    30.93         6.65    9.61   \n",
       "1997-01-28    000613   大东海A     旅游服务   海南  1574.13         2.66    3.64   \n",
       "2016-03-22    300484   蓝海华腾     电气设备   深圳    25.00         0.94    2.08   \n",
       "2015-03-18    300433   蓝思科技      元器件   湖南    46.39         4.44   26.29   \n",
       "2017-06-06    300661   圣邦股份      元器件   北京    87.02         0.15    0.61   \n",
       "2017-01-05    300588   熙菱信息     软件服务   新疆    65.77         0.31    1.00   \n",
       "2017-01-26    300603   立昂技术     通信设备   新疆    47.46         0.57    1.03   \n",
       "2017-11-09    300719   安达维尔       航空   北京    53.58         0.42    1.68   \n",
       "2009-12-16    002320   海峡股份       水运   海南    74.69         4.30    5.08   \n",
       "2017-08-03    300687   赛意信息     软件服务   广东    52.57         0.20    0.80   \n",
       "2010-05-20    300083   劲胜智能      元器件   广东    16.41        11.91   14.32   \n",
       "2008-05-08    002229   鸿博股份     广告包装   福建   525.65         4.15    5.03   \n",
       "2017-10-19    300709   精研科技      元器件   江苏    31.01         0.22    0.88   \n",
       "2017-05-16    300653   正海生物     医疗保健   山东    65.83         0.20    0.80   \n",
       "2017-11-27    300727   润禾材料     化工原料   浙江    90.09         0.24    0.98   \n",
       "2011-01-25    300166   东方国信     软件服务   北京    78.81         8.06   10.50   \n",
       "2015-03-24    603729   龙韵股份     广告包装   上海   176.04         0.67    0.67   \n",
       "2017-05-23    300657   弘信电子      元器件   福建    67.08         0.26    1.04   \n",
       "2016-03-03    300502    新易盛     通信设备   四川    39.29         1.25    2.38   \n",
       "1999-12-09    000955   欣龙控股       纺织   海南     0.00         5.38    5.38   \n",
       "2011-07-07    002596   海南瑞泽     其他建材   海南    76.57         7.26   10.74   \n",
       "2011-03-16    300189   神农基因      种植业   海南     0.00         8.82   10.24   \n",
       "1994-01-03    600806  *ST昆机     机床制造   云南     0.00         3.90    5.31   \n",
       "2003-09-05    600432  *ST吉恩      小金属   吉林     0.00        16.04   16.04   \n",
       "1999-09-16    000950  *ST建峰     农药化肥   重庆     0.00         5.99   17.28   \n",
       "1996-11-15    000629  *ST钒钛       普钢   四川     0.00        47.67   85.90   \n",
       "1993-05-18    000511  *ST烯碳     矿物制品   辽宁     0.00        11.55   11.55   \n",
       "\n",
       "              totalAssets  liquidAssets  fixedAssets     ...         pb  \\\n",
       "timeToMarket                                             ...              \n",
       "2018-04-10      131807.23     117523.63     10988.37     ...       4.27   \n",
       "2012-10-09      208679.95      97810.21     17068.50     ...       2.49   \n",
       "1996-05-31     1125400.88     590581.00     76470.36     ...       3.11   \n",
       "2007-08-21      622252.69     297916.59    151107.36     ...       1.45   \n",
       "1997-05-08     1441538.00     440514.44    801547.88     ...       5.35   \n",
       "1996-05-03      448937.09     363976.13       453.85     ...       2.74   \n",
       "1997-06-25       81995.88      59217.63     17258.00     ...       4.92   \n",
       "2018-03-26      310491.63      78859.31    139873.81     ...       5.36   \n",
       "2010-04-30      116227.61      76413.81     21807.57     ...       2.35   \n",
       "2007-08-03      199379.38      51652.78     28723.63     ...       1.51   \n",
       "2017-03-16      186181.06     169977.59      2515.88     ...       3.41   \n",
       "2017-09-20      212309.42     190471.27     16428.07     ...       4.80   \n",
       "2017-03-15       67298.32      46722.62     12191.86     ...       4.48   \n",
       "2018-03-28      187270.80      13539.20    103894.40     ...       3.66   \n",
       "2017-09-22       62622.20      44925.30     10986.69     ...       8.40   \n",
       "2018-03-30       76961.15      61297.16      7078.72     ...       9.27   \n",
       "2017-01-17       84769.46      71856.96      3970.03     ...      10.12   \n",
       "2017-03-21       95269.30      88869.28      2105.35     ...       9.13   \n",
       "2017-02-08       86330.46      76018.32      5968.18     ...       4.33   \n",
       "2017-10-10       76920.25      51869.26     13084.78     ...       9.34   \n",
       "2017-10-31       88554.82      68437.21     15267.82     ...       5.65   \n",
       "2017-05-09       68624.13      45903.00     14470.87     ...       7.22   \n",
       "2017-06-02      280316.22     256656.80     16994.20     ...       3.21   \n",
       "2016-08-02      170240.02     123065.95     32537.78     ...      12.85   \n",
       "2017-09-22      218374.66     135898.92     68163.18     ...       4.35   \n",
       "2017-05-19       91925.27      57405.90     21257.95     ...       5.89   \n",
       "2010-02-03      280886.13     197356.56     42124.90     ...       3.11   \n",
       "2008-05-16      272703.47     126430.06     19098.98     ...       2.01   \n",
       "2017-08-10       41396.55      40351.37       380.64     ...      14.13   \n",
       "2018-02-26      348015.50     277392.63     57633.35     ...      21.08   \n",
       "...                   ...           ...          ...     ...        ...   \n",
       "2014-09-10      150430.13     116865.26     14213.17     ...       7.38   \n",
       "1999-03-25       86705.93      23242.80     16197.40     ...       6.31   \n",
       "1997-06-11      618940.00     207991.38    180241.88     ...       3.02   \n",
       "2010-02-11      397465.50     226564.66     47543.53     ...       2.70   \n",
       "1997-01-28        8746.66       1382.31      3908.87     ...      58.34   \n",
       "2016-03-22      103367.36      90467.02      3893.34     ...       5.06   \n",
       "2015-03-18     3134060.00    1093617.13   1565460.63     ...       3.24   \n",
       "2017-06-06       86190.96      82643.93      1150.35     ...       8.73   \n",
       "2017-01-05       84675.42      79111.96       736.22     ...       8.19   \n",
       "2017-01-26      124445.82      99134.21      2345.56     ...       8.70   \n",
       "2017-11-09      111330.52      99828.74      9335.78     ...       5.00   \n",
       "2009-12-16      390513.69     136325.91    235803.70     ...       4.75   \n",
       "2017-08-03       83921.68      80942.17       291.20     ...       6.36   \n",
       "2010-05-20     1144811.25     728822.63    176756.77     ...       1.64   \n",
       "2008-05-08      210997.52     117592.22     61739.38     ...       3.45   \n",
       "2017-10-19      104817.97      51288.05     36566.43     ...       3.83   \n",
       "2017-05-16       53081.60      45645.28      2500.00     ...       8.40   \n",
       "2017-11-27       43196.92      25291.61     12968.00     ...       8.96   \n",
       "2011-01-25      468344.94     273063.00     22614.40     ...       3.72   \n",
       "2015-03-24       97434.93      82516.06      7244.75     ...       4.19   \n",
       "2017-05-23      184841.84     111414.60     59763.01     ...       6.42   \n",
       "2016-03-03      135900.52     100870.77     29193.11     ...       4.65   \n",
       "1999-12-09      140784.42      68316.99     46174.09     ...       5.76   \n",
       "2011-07-07      498120.41     292194.84     59208.46     ...       5.37   \n",
       "2011-03-16      260142.09     166160.41     29938.77     ...       2.98   \n",
       "1994-01-03      193646.66     121889.97     45542.53     ...       0.00   \n",
       "2003-09-05     1373541.75     297409.28    768094.25     ...       0.00   \n",
       "1999-09-16     1562395.13    1296451.63     48986.46     ...       0.00   \n",
       "1996-11-15     1047323.31     429526.09    468832.44     ...       0.00   \n",
       "1993-05-18      346274.91     312833.03      2405.45     ...       0.00   \n",
       "\n",
       "              timeToMarket        undp  perundp     rev   profit    gpr  \\\n",
       "timeToMarket                                                              \n",
       "2018-04-10      2018-04-10    35286.05     1.98   41.98    55.84   8.19   \n",
       "2012-10-09      2012-10-09    28831.28     0.69  -39.02   -47.76  26.05   \n",
       "1996-05-31      1996-05-31   104130.27     0.62   62.61   223.67   6.85   \n",
       "2007-08-21      2007-08-21    27155.90     0.37   40.03    56.07  17.64   \n",
       "1997-05-08      1997-05-08  -331470.38    -1.37   86.35  2381.13  13.26   \n",
       "1996-05-03      1996-05-03   -60134.50    -0.69  -94.80    18.38  91.85   \n",
       "1997-06-25      1997-06-25    19668.43     0.72   16.55  -132.47   8.32   \n",
       "2018-03-26      2018-03-26    71625.13     0.78    1.30    15.06  47.71   \n",
       "2010-04-30      2010-04-30    10759.37     0.25  -40.70 -1298.93  35.65   \n",
       "2007-08-03      2007-08-03    52805.73     2.99   12.73    -6.03  29.92   \n",
       "2017-03-16      2017-03-16    26666.50     1.92    0.00     0.00  13.34   \n",
       "2017-09-20      2017-09-20    27721.10     0.99    0.00     0.00  33.95   \n",
       "2017-03-15      2017-03-15     9561.42     1.12    6.12     1.57  52.11   \n",
       "2018-03-28      2018-03-28    38270.21     1.57   -0.74    10.33  56.59   \n",
       "2017-09-22      2017-09-22     9541.13     0.95    0.00     0.00  63.85   \n",
       "2018-03-30      2018-03-30    25456.17     2.55   14.06    26.47  28.41   \n",
       "2017-01-17      2017-01-17    20604.49     1.66   31.61    29.56  76.06   \n",
       "2017-03-21      2017-03-21    19288.67     1.56    0.00     0.00  54.56   \n",
       "2017-02-08      2017-02-08    20656.95     1.55  -37.75   -28.91  31.54   \n",
       "2017-10-10      2017-10-10    12709.62     1.08   42.01    25.76  51.93   \n",
       "2017-10-31      2017-10-31    26118.49     1.28    0.00     0.00  30.63   \n",
       "2017-05-09      2017-05-09    14151.70     0.88    0.00     0.00  60.63   \n",
       "2017-06-02      2017-06-02    33226.21     3.26    0.00     0.00  26.74   \n",
       "2016-08-02      2016-08-02    48161.67     1.15   32.16    40.72  84.14   \n",
       "2017-09-22      2017-09-22    39189.78     1.86   50.99     3.36  74.17   \n",
       "2017-05-19      2017-05-19    18090.75     2.63    0.00     0.00  81.09   \n",
       "2010-02-03      2010-02-03    34932.31     0.90   23.04   -44.28  23.27   \n",
       "2008-05-16      2008-05-16     5426.16     0.13   66.06   473.50  31.63   \n",
       "2017-08-10      2017-08-10     6212.93     0.91    0.00     0.00  56.91   \n",
       "2018-02-26      2018-02-26    20558.85     0.27    0.00     0.00  49.57   \n",
       "...                    ...         ...      ...     ...      ...    ...   \n",
       "2014-09-10      2014-09-10    11726.03     0.31   17.47   324.13  10.24   \n",
       "1999-03-25      1999-03-25     5083.85     0.12   53.01    51.86   4.02   \n",
       "1997-06-11      1997-06-11    72196.31     0.63  116.29    85.11  30.92   \n",
       "2010-02-11      2010-02-11    77185.90     0.80   35.41    30.84  36.67   \n",
       "1997-01-28      1997-01-28   -34110.73    -0.94   28.55   207.44  60.08   \n",
       "2016-03-22      2016-03-22    35972.95     1.73    2.54     0.94  39.27   \n",
       "2015-03-18      2015-03-18   823279.00     3.13   41.93    12.39  25.00   \n",
       "2017-06-06      2017-06-06    19735.47     3.24    0.00     0.00  43.62   \n",
       "2017-01-05      2017-01-05    13293.88     1.33   35.56    85.39  24.81   \n",
       "2017-01-26      2017-01-26    16070.23     1.57  247.32   259.16  20.03   \n",
       "2017-11-09      2017-11-09    26470.75     1.58   10.59    -1.52  53.67   \n",
       "2009-12-16      2009-12-16    79676.13     1.57   26.15    64.71  42.13   \n",
       "2017-08-03      2017-08-03    14224.57     1.78    0.00     0.00  31.36   \n",
       "2010-05-20      2010-05-20    39800.05     0.28   31.86   424.03  27.29   \n",
       "2008-05-08      2008-05-08    21342.10     0.42  -17.88   -15.14  24.06   \n",
       "2017-10-19      2017-10-19    26389.69     3.00    0.00     0.00  40.49   \n",
       "2017-05-16      2017-05-16    12030.73     1.50   21.35    35.63  93.67   \n",
       "2017-11-27      2017-11-27     8362.07     0.86    0.00     0.00  29.56   \n",
       "2011-01-25      2011-01-25    97738.21     0.93   18.86    30.89  45.86   \n",
       "2015-03-24      2015-03-24    46754.80     7.01   -6.88   -53.62  10.85   \n",
       "2017-05-23      2017-05-23    18206.14     1.75    0.00     0.00  13.57   \n",
       "2016-03-03      2016-03-03    48375.46     2.03   29.88    20.03  25.61   \n",
       "1999-12-09      1999-12-09   -40120.17    -0.75   36.59  -155.81  12.15   \n",
       "2011-07-07      2011-07-07    63369.16     0.59   56.17   150.94  19.12   \n",
       "2011-03-16      2011-03-16     9359.57     0.09  148.66    49.13  12.07   \n",
       "1994-01-03      1994-01-03   -45091.93    -0.85   21.07   -23.37   3.60   \n",
       "2003-09-05      2003-09-05  -549617.19    -3.43    9.91   -56.24  15.12   \n",
       "1999-09-16      1999-09-16   193228.36     1.12    1.16   758.44   9.07   \n",
       "1996-11-15      1996-11-15 -1126974.13    -1.31  -11.07   114.42  17.74   \n",
       "1993-05-18      1993-05-18   -63425.48    -0.55   43.62   -55.46   0.22   \n",
       "\n",
       "                 npr   holders        更新日期  \n",
       "timeToMarket                                \n",
       "2018-04-10      3.87   42986.0  2018-04-11  \n",
       "2012-10-09      4.30   19839.0  2018-04-11  \n",
       "1996-05-31      2.95  106700.0  2018-04-11  \n",
       "2007-08-21      3.84   50000.0  2018-04-11  \n",
       "1997-05-08      9.66  132008.0  2018-04-11  \n",
       "1996-05-03   -416.75   43837.0  2018-04-11  \n",
       "1997-06-25     -0.62   31400.0  2018-04-11  \n",
       "2018-03-26      7.24  140295.0  2018-04-11  \n",
       "2010-04-30    -29.91   41000.0  2018-04-11  \n",
       "2007-08-03     15.71   21057.0  2018-04-11  \n",
       "2017-03-16      4.22   19044.0  2018-04-11  \n",
       "2017-09-20     11.23   36000.0  2018-04-11  \n",
       "2017-03-15     20.31   10574.0  2018-04-11  \n",
       "2018-03-28     25.41  115500.0  2018-04-11  \n",
       "2017-09-22     20.00   27488.0  2018-04-11  \n",
       "2018-03-30      5.18   26639.0  2018-04-11  \n",
       "2017-01-17     50.72    6781.0  2018-04-11  \n",
       "2017-03-21     14.97   16380.0  2018-04-11  \n",
       "2017-02-08     22.63    9897.0  2018-04-11  \n",
       "2017-10-10     12.83   21243.0  2018-04-11  \n",
       "2017-10-31     12.40   48514.0  2018-04-11  \n",
       "2017-05-09     22.65   14088.0  2018-04-11  \n",
       "2017-06-02     12.07   18283.0  2018-04-11  \n",
       "2016-08-02     39.58   22527.0  2018-04-11  \n",
       "2017-09-22     15.76   38400.0  2018-04-11  \n",
       "2017-05-19     11.75    9615.0  2018-04-11  \n",
       "2010-02-03      1.03   52854.0  2018-04-11  \n",
       "2008-05-16     14.46   30659.0  2018-04-11  \n",
       "2017-08-10     17.97   15720.0  2018-04-11  \n",
       "2018-02-26      8.39   88473.0  2018-04-11  \n",
       "...              ...       ...         ...  \n",
       "2014-09-10      1.53   27346.0  2018-04-11  \n",
       "1999-03-25    -30.81   59619.0  2018-04-11  \n",
       "1997-06-11     13.88   80000.0  2018-04-11  \n",
       "2010-02-11     18.24   17874.0  2018-04-11  \n",
       "1997-01-28     10.24   20000.0  2018-04-11  \n",
       "2016-03-22     24.14   14835.0  2018-04-11  \n",
       "2015-03-18      5.91   35003.0  2018-04-11  \n",
       "2017-06-06     16.02    5677.0  2018-04-11  \n",
       "2017-01-05      7.47   10945.0  2018-04-11  \n",
       "2017-01-26      8.61   11752.0  2018-04-11  \n",
       "2017-11-09     20.42   25100.0  2018-04-11  \n",
       "2009-12-16     23.29   17700.0  2018-04-11  \n",
       "2017-08-03     13.34   13585.0  2018-04-11  \n",
       "2010-05-20      8.96   47930.0  2018-04-11  \n",
       "2008-05-08      1.55   40500.0  2018-04-11  \n",
       "2017-10-19     17.04   16000.0  2018-04-11  \n",
       "2017-05-16     33.74    8714.0  2018-04-11  \n",
       "2017-11-27     10.75   50562.0  2018-04-11  \n",
       "2011-01-25     19.72   35285.0  2018-04-11  \n",
       "2015-03-24      2.04    5819.0  2018-04-11  \n",
       "2017-05-23      3.79   11765.0  2018-04-11  \n",
       "2016-03-03     14.60   21261.0  2018-04-11  \n",
       "1999-12-09     -9.58   33494.0  2018-04-11  \n",
       "2011-07-07      6.12   21200.0  2018-04-11  \n",
       "2011-03-16     -1.20   62017.0  2018-04-11  \n",
       "1994-01-03    -51.43   33099.0  2018-04-11  \n",
       "2003-09-05    -42.86   70654.0  2018-04-11  \n",
       "1999-09-16      5.20   30624.0  2018-04-11  \n",
       "1996-11-15      9.15  309055.0  2018-04-11  \n",
       "1993-05-18    -14.68  164822.0  2018-04-11  \n",
       "\n",
       "[3506 rows x 24 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "basic_df.set_index(basic_df['timeToMarket'],drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>...</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "      <th>更新日期</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>timeToMarket</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-04-10</th>\n",
       "      <td>603897</td>\n",
       "      <td>N长城</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>浙江</td>\n",
       "      <td>25.57</td>\n",
       "      <td>0.45</td>\n",
       "      <td>1.78</td>\n",
       "      <td>131807.23</td>\n",
       "      <td>117523.63</td>\n",
       "      <td>10988.37</td>\n",
       "      <td>...</td>\n",
       "      <td>4.27</td>\n",
       "      <td>2018-04-10</td>\n",
       "      <td>35286.05</td>\n",
       "      <td>1.98</td>\n",
       "      <td>41.98</td>\n",
       "      <td>55.84</td>\n",
       "      <td>8.19</td>\n",
       "      <td>3.87</td>\n",
       "      <td>42986.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-26</th>\n",
       "      <td>600929</td>\n",
       "      <td>湖南盐业</td>\n",
       "      <td>食品</td>\n",
       "      <td>湖南</td>\n",
       "      <td>72.52</td>\n",
       "      <td>1.50</td>\n",
       "      <td>9.18</td>\n",
       "      <td>310491.63</td>\n",
       "      <td>78859.31</td>\n",
       "      <td>139873.81</td>\n",
       "      <td>...</td>\n",
       "      <td>5.36</td>\n",
       "      <td>2018-03-26</td>\n",
       "      <td>71625.13</td>\n",
       "      <td>0.78</td>\n",
       "      <td>1.30</td>\n",
       "      <td>15.06</td>\n",
       "      <td>47.71</td>\n",
       "      <td>7.24</td>\n",
       "      <td>140295.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-16</th>\n",
       "      <td>300621</td>\n",
       "      <td>维业股份</td>\n",
       "      <td>装修装饰</td>\n",
       "      <td>深圳</td>\n",
       "      <td>37.99</td>\n",
       "      <td>0.43</td>\n",
       "      <td>1.39</td>\n",
       "      <td>186181.06</td>\n",
       "      <td>169977.59</td>\n",
       "      <td>2515.88</td>\n",
       "      <td>...</td>\n",
       "      <td>3.41</td>\n",
       "      <td>2017-03-16</td>\n",
       "      <td>26666.50</td>\n",
       "      <td>1.92</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>13.34</td>\n",
       "      <td>4.22</td>\n",
       "      <td>19044.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-20</th>\n",
       "      <td>603106</td>\n",
       "      <td>恒银金融</td>\n",
       "      <td>电脑设备</td>\n",
       "      <td>天津</td>\n",
       "      <td>45.40</td>\n",
       "      <td>0.70</td>\n",
       "      <td>2.80</td>\n",
       "      <td>212309.42</td>\n",
       "      <td>190471.27</td>\n",
       "      <td>16428.07</td>\n",
       "      <td>...</td>\n",
       "      <td>4.80</td>\n",
       "      <td>2017-09-20</td>\n",
       "      <td>27721.10</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33.95</td>\n",
       "      <td>11.23</td>\n",
       "      <td>36000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-15</th>\n",
       "      <td>603811</td>\n",
       "      <td>诚意药业</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>浙江</td>\n",
       "      <td>38.80</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.85</td>\n",
       "      <td>67298.32</td>\n",
       "      <td>46722.62</td>\n",
       "      <td>12191.86</td>\n",
       "      <td>...</td>\n",
       "      <td>4.48</td>\n",
       "      <td>2017-03-15</td>\n",
       "      <td>9561.42</td>\n",
       "      <td>1.12</td>\n",
       "      <td>6.12</td>\n",
       "      <td>1.57</td>\n",
       "      <td>52.11</td>\n",
       "      <td>20.31</td>\n",
       "      <td>10574.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-28</th>\n",
       "      <td>002930</td>\n",
       "      <td>宏川智慧</td>\n",
       "      <td>仓储物流</td>\n",
       "      <td>广东</td>\n",
       "      <td>62.90</td>\n",
       "      <td>0.61</td>\n",
       "      <td>2.43</td>\n",
       "      <td>187270.80</td>\n",
       "      <td>13539.20</td>\n",
       "      <td>103894.40</td>\n",
       "      <td>...</td>\n",
       "      <td>3.66</td>\n",
       "      <td>2018-03-28</td>\n",
       "      <td>38270.21</td>\n",
       "      <td>1.57</td>\n",
       "      <td>-0.74</td>\n",
       "      <td>10.33</td>\n",
       "      <td>56.59</td>\n",
       "      <td>25.41</td>\n",
       "      <td>115500.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-22</th>\n",
       "      <td>603963</td>\n",
       "      <td>大理药业</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>云南</td>\n",
       "      <td>73.92</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.00</td>\n",
       "      <td>62622.20</td>\n",
       "      <td>44925.30</td>\n",
       "      <td>10986.69</td>\n",
       "      <td>...</td>\n",
       "      <td>8.40</td>\n",
       "      <td>2017-09-22</td>\n",
       "      <td>9541.13</td>\n",
       "      <td>0.95</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>63.85</td>\n",
       "      <td>20.00</td>\n",
       "      <td>27488.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-30</th>\n",
       "      <td>603214</td>\n",
       "      <td>爱婴室</td>\n",
       "      <td>百货</td>\n",
       "      <td>上海</td>\n",
       "      <td>49.45</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.00</td>\n",
       "      <td>76961.15</td>\n",
       "      <td>61297.16</td>\n",
       "      <td>7078.72</td>\n",
       "      <td>...</td>\n",
       "      <td>9.27</td>\n",
       "      <td>2018-03-30</td>\n",
       "      <td>25456.17</td>\n",
       "      <td>2.55</td>\n",
       "      <td>14.06</td>\n",
       "      <td>26.47</td>\n",
       "      <td>28.41</td>\n",
       "      <td>5.18</td>\n",
       "      <td>26639.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-17</th>\n",
       "      <td>300595</td>\n",
       "      <td>欧普康视</td>\n",
       "      <td>医疗保健</td>\n",
       "      <td>安徽</td>\n",
       "      <td>54.16</td>\n",
       "      <td>0.76</td>\n",
       "      <td>1.24</td>\n",
       "      <td>84769.46</td>\n",
       "      <td>71856.96</td>\n",
       "      <td>3970.03</td>\n",
       "      <td>...</td>\n",
       "      <td>10.12</td>\n",
       "      <td>2017-01-17</td>\n",
       "      <td>20604.49</td>\n",
       "      <td>1.66</td>\n",
       "      <td>31.61</td>\n",
       "      <td>29.56</td>\n",
       "      <td>76.06</td>\n",
       "      <td>50.72</td>\n",
       "      <td>6781.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-21</th>\n",
       "      <td>300627</td>\n",
       "      <td>华测导航</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>上海</td>\n",
       "      <td>85.66</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1.23</td>\n",
       "      <td>95269.30</td>\n",
       "      <td>88869.28</td>\n",
       "      <td>2105.35</td>\n",
       "      <td>...</td>\n",
       "      <td>9.13</td>\n",
       "      <td>2017-03-21</td>\n",
       "      <td>19288.67</td>\n",
       "      <td>1.56</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>54.56</td>\n",
       "      <td>14.97</td>\n",
       "      <td>16380.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-08</th>\n",
       "      <td>603637</td>\n",
       "      <td>镇海股份</td>\n",
       "      <td>建筑施工</td>\n",
       "      <td>浙江</td>\n",
       "      <td>66.69</td>\n",
       "      <td>0.33</td>\n",
       "      <td>1.33</td>\n",
       "      <td>86330.46</td>\n",
       "      <td>76018.32</td>\n",
       "      <td>5968.18</td>\n",
       "      <td>...</td>\n",
       "      <td>4.33</td>\n",
       "      <td>2017-02-08</td>\n",
       "      <td>20656.95</td>\n",
       "      <td>1.55</td>\n",
       "      <td>-37.75</td>\n",
       "      <td>-28.91</td>\n",
       "      <td>31.54</td>\n",
       "      <td>22.63</td>\n",
       "      <td>9897.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-10-10</th>\n",
       "      <td>300705</td>\n",
       "      <td>九典制药</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>湖南</td>\n",
       "      <td>89.94</td>\n",
       "      <td>0.29</td>\n",
       "      <td>1.17</td>\n",
       "      <td>76920.25</td>\n",
       "      <td>51869.26</td>\n",
       "      <td>13084.78</td>\n",
       "      <td>...</td>\n",
       "      <td>9.34</td>\n",
       "      <td>2017-10-10</td>\n",
       "      <td>12709.62</td>\n",
       "      <td>1.08</td>\n",
       "      <td>42.01</td>\n",
       "      <td>25.76</td>\n",
       "      <td>51.93</td>\n",
       "      <td>12.83</td>\n",
       "      <td>21243.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-10-31</th>\n",
       "      <td>603289</td>\n",
       "      <td>泰瑞机器</td>\n",
       "      <td>专用机械</td>\n",
       "      <td>浙江</td>\n",
       "      <td>45.82</td>\n",
       "      <td>0.51</td>\n",
       "      <td>2.04</td>\n",
       "      <td>88554.82</td>\n",
       "      <td>68437.21</td>\n",
       "      <td>15267.82</td>\n",
       "      <td>...</td>\n",
       "      <td>5.65</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>26118.49</td>\n",
       "      <td>1.28</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>30.63</td>\n",
       "      <td>12.40</td>\n",
       "      <td>48514.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-09</th>\n",
       "      <td>603229</td>\n",
       "      <td>奥翔药业</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>浙江</td>\n",
       "      <td>93.03</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.60</td>\n",
       "      <td>68624.13</td>\n",
       "      <td>45903.00</td>\n",
       "      <td>14470.87</td>\n",
       "      <td>...</td>\n",
       "      <td>7.22</td>\n",
       "      <td>2017-05-09</td>\n",
       "      <td>14151.70</td>\n",
       "      <td>0.88</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>60.63</td>\n",
       "      <td>22.65</td>\n",
       "      <td>14088.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-02</th>\n",
       "      <td>300660</td>\n",
       "      <td>江苏雷利</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>江苏</td>\n",
       "      <td>26.10</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.02</td>\n",
       "      <td>280316.22</td>\n",
       "      <td>256656.80</td>\n",
       "      <td>16994.20</td>\n",
       "      <td>...</td>\n",
       "      <td>3.21</td>\n",
       "      <td>2017-06-02</td>\n",
       "      <td>33226.21</td>\n",
       "      <td>3.26</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26.74</td>\n",
       "      <td>12.07</td>\n",
       "      <td>18283.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-22</th>\n",
       "      <td>002900</td>\n",
       "      <td>哈三联</td>\n",
       "      <td>化学制药</td>\n",
       "      <td>黑龙江</td>\n",
       "      <td>44.11</td>\n",
       "      <td>0.53</td>\n",
       "      <td>2.11</td>\n",
       "      <td>218374.66</td>\n",
       "      <td>135898.92</td>\n",
       "      <td>68163.18</td>\n",
       "      <td>...</td>\n",
       "      <td>4.35</td>\n",
       "      <td>2017-09-22</td>\n",
       "      <td>39189.78</td>\n",
       "      <td>1.86</td>\n",
       "      <td>50.99</td>\n",
       "      <td>3.36</td>\n",
       "      <td>74.17</td>\n",
       "      <td>15.76</td>\n",
       "      <td>38400.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-19</th>\n",
       "      <td>002873</td>\n",
       "      <td>新天药业</td>\n",
       "      <td>中成药</td>\n",
       "      <td>贵州</td>\n",
       "      <td>44.54</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.69</td>\n",
       "      <td>91925.27</td>\n",
       "      <td>57405.90</td>\n",
       "      <td>21257.95</td>\n",
       "      <td>...</td>\n",
       "      <td>5.89</td>\n",
       "      <td>2017-05-19</td>\n",
       "      <td>18090.75</td>\n",
       "      <td>2.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>81.09</td>\n",
       "      <td>11.75</td>\n",
       "      <td>9615.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-08-10</th>\n",
       "      <td>300688</td>\n",
       "      <td>创业黑马</td>\n",
       "      <td>综合类</td>\n",
       "      <td>北京</td>\n",
       "      <td>171.33</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.68</td>\n",
       "      <td>41396.55</td>\n",
       "      <td>40351.37</td>\n",
       "      <td>380.64</td>\n",
       "      <td>...</td>\n",
       "      <td>14.13</td>\n",
       "      <td>2017-08-10</td>\n",
       "      <td>6212.93</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>56.91</td>\n",
       "      <td>17.97</td>\n",
       "      <td>15720.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-26</th>\n",
       "      <td>603712</td>\n",
       "      <td>七一二</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>天津</td>\n",
       "      <td>363.05</td>\n",
       "      <td>1.00</td>\n",
       "      <td>7.72</td>\n",
       "      <td>348015.50</td>\n",
       "      <td>277392.63</td>\n",
       "      <td>57633.35</td>\n",
       "      <td>...</td>\n",
       "      <td>21.08</td>\n",
       "      <td>2018-02-26</td>\n",
       "      <td>20558.85</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>49.57</td>\n",
       "      <td>8.39</td>\n",
       "      <td>88473.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-11-21</th>\n",
       "      <td>300726</td>\n",
       "      <td>宏达电子</td>\n",
       "      <td>元器件</td>\n",
       "      <td>湖南</td>\n",
       "      <td>86.52</td>\n",
       "      <td>0.40</td>\n",
       "      <td>4.00</td>\n",
       "      <td>100780.30</td>\n",
       "      <td>80427.53</td>\n",
       "      <td>8466.57</td>\n",
       "      <td>...</td>\n",
       "      <td>16.70</td>\n",
       "      <td>2017-11-21</td>\n",
       "      <td>23141.20</td>\n",
       "      <td>0.58</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>70.73</td>\n",
       "      <td>39.73</td>\n",
       "      <td>79196.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-03</th>\n",
       "      <td>300670</td>\n",
       "      <td>大烨智能</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>江苏</td>\n",
       "      <td>88.13</td>\n",
       "      <td>0.27</td>\n",
       "      <td>1.08</td>\n",
       "      <td>69398.42</td>\n",
       "      <td>59512.13</td>\n",
       "      <td>6638.05</td>\n",
       "      <td>...</td>\n",
       "      <td>6.81</td>\n",
       "      <td>2017-07-03</td>\n",
       "      <td>14113.52</td>\n",
       "      <td>1.31</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>31.06</td>\n",
       "      <td>15.77</td>\n",
       "      <td>13484.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-21</th>\n",
       "      <td>300554</td>\n",
       "      <td>三超新材</td>\n",
       "      <td>矿物制品</td>\n",
       "      <td>江苏</td>\n",
       "      <td>94.44</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.52</td>\n",
       "      <td>48783.32</td>\n",
       "      <td>33910.75</td>\n",
       "      <td>12251.67</td>\n",
       "      <td>...</td>\n",
       "      <td>10.86</td>\n",
       "      <td>2017-04-21</td>\n",
       "      <td>10747.62</td>\n",
       "      <td>2.07</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47.15</td>\n",
       "      <td>24.98</td>\n",
       "      <td>4538.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-22</th>\n",
       "      <td>603383</td>\n",
       "      <td>顶点软件</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>福建</td>\n",
       "      <td>49.79</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.86</td>\n",
       "      <td>115820.30</td>\n",
       "      <td>104881.36</td>\n",
       "      <td>3878.28</td>\n",
       "      <td>...</td>\n",
       "      <td>5.41</td>\n",
       "      <td>2017-05-22</td>\n",
       "      <td>38075.21</td>\n",
       "      <td>4.43</td>\n",
       "      <td>19.09</td>\n",
       "      <td>44.59</td>\n",
       "      <td>78.78</td>\n",
       "      <td>41.80</td>\n",
       "      <td>8928.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-23</th>\n",
       "      <td>002927</td>\n",
       "      <td>泰永长征</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>贵州</td>\n",
       "      <td>102.26</td>\n",
       "      <td>0.23</td>\n",
       "      <td>0.94</td>\n",
       "      <td>43605.35</td>\n",
       "      <td>35037.03</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>12.70</td>\n",
       "      <td>2018-02-23</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18.51</td>\n",
       "      <td>48823.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-06</th>\n",
       "      <td>300644</td>\n",
       "      <td>南京聚隆</td>\n",
       "      <td>塑料</td>\n",
       "      <td>江苏</td>\n",
       "      <td>62.16</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.64</td>\n",
       "      <td>82547.78</td>\n",
       "      <td>60597.23</td>\n",
       "      <td>18706.01</td>\n",
       "      <td>...</td>\n",
       "      <td>6.21</td>\n",
       "      <td>2018-02-06</td>\n",
       "      <td>25969.65</td>\n",
       "      <td>4.06</td>\n",
       "      <td>13.33</td>\n",
       "      <td>-28.26</td>\n",
       "      <td>17.55</td>\n",
       "      <td>5.51</td>\n",
       "      <td>31946.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-20</th>\n",
       "      <td>300598</td>\n",
       "      <td>诚迈科技</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>江苏</td>\n",
       "      <td>111.58</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.80</td>\n",
       "      <td>53850.86</td>\n",
       "      <td>44918.25</td>\n",
       "      <td>626.82</td>\n",
       "      <td>...</td>\n",
       "      <td>9.78</td>\n",
       "      <td>2017-01-20</td>\n",
       "      <td>17461.71</td>\n",
       "      <td>2.18</td>\n",
       "      <td>-3.84</td>\n",
       "      <td>-22.12</td>\n",
       "      <td>31.26</td>\n",
       "      <td>8.10</td>\n",
       "      <td>9182.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-10</th>\n",
       "      <td>603266</td>\n",
       "      <td>天龙股份</td>\n",
       "      <td>塑料</td>\n",
       "      <td>浙江</td>\n",
       "      <td>34.03</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.00</td>\n",
       "      <td>98374.46</td>\n",
       "      <td>71618.72</td>\n",
       "      <td>18603.42</td>\n",
       "      <td>...</td>\n",
       "      <td>3.68</td>\n",
       "      <td>2017-01-10</td>\n",
       "      <td>33154.17</td>\n",
       "      <td>3.32</td>\n",
       "      <td>8.21</td>\n",
       "      <td>4.72</td>\n",
       "      <td>28.05</td>\n",
       "      <td>10.33</td>\n",
       "      <td>8819.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-12-18</th>\n",
       "      <td>002919</td>\n",
       "      <td>名臣健康</td>\n",
       "      <td>日用化工</td>\n",
       "      <td>广东</td>\n",
       "      <td>69.13</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.81</td>\n",
       "      <td>46302.28</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>6.24</td>\n",
       "      <td>2017-12-18</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7.77</td>\n",
       "      <td>43677.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-21</th>\n",
       "      <td>603139</td>\n",
       "      <td>康惠制药</td>\n",
       "      <td>中成药</td>\n",
       "      <td>陕西</td>\n",
       "      <td>61.04</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.00</td>\n",
       "      <td>94826.35</td>\n",
       "      <td>81229.31</td>\n",
       "      <td>5390.80</td>\n",
       "      <td>...</td>\n",
       "      <td>3.35</td>\n",
       "      <td>2017-04-21</td>\n",
       "      <td>33866.51</td>\n",
       "      <td>3.39</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>57.10</td>\n",
       "      <td>15.64</td>\n",
       "      <td>13137.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-23</th>\n",
       "      <td>300634</td>\n",
       "      <td>彩讯股份</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>深圳</td>\n",
       "      <td>81.30</td>\n",
       "      <td>0.40</td>\n",
       "      <td>4.00</td>\n",
       "      <td>100621.55</td>\n",
       "      <td>65063.45</td>\n",
       "      <td>1320.74</td>\n",
       "      <td>...</td>\n",
       "      <td>11.01</td>\n",
       "      <td>2018-03-23</td>\n",
       "      <td>19710.35</td>\n",
       "      <td>0.49</td>\n",
       "      <td>33.46</td>\n",
       "      <td>44.54</td>\n",
       "      <td>48.01</td>\n",
       "      <td>21.36</td>\n",
       "      <td>77432.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-24</th>\n",
       "      <td>300629</td>\n",
       "      <td>新劲刚</td>\n",
       "      <td>矿物制品</td>\n",
       "      <td>广东</td>\n",
       "      <td>137.29</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.67</td>\n",
       "      <td>48471.40</td>\n",
       "      <td>36097.23</td>\n",
       "      <td>8623.61</td>\n",
       "      <td>...</td>\n",
       "      <td>9.68</td>\n",
       "      <td>2017-03-24</td>\n",
       "      <td>12290.36</td>\n",
       "      <td>1.84</td>\n",
       "      <td>2.26</td>\n",
       "      <td>-8.10</td>\n",
       "      <td>32.24</td>\n",
       "      <td>9.84</td>\n",
       "      <td>7729.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-11-15</th>\n",
       "      <td>300721</td>\n",
       "      <td>怡达股份</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>江苏</td>\n",
       "      <td>40.04</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.80</td>\n",
       "      <td>100619.93</td>\n",
       "      <td>60467.48</td>\n",
       "      <td>21425.98</td>\n",
       "      <td>...</td>\n",
       "      <td>3.09</td>\n",
       "      <td>2017-11-15</td>\n",
       "      <td>18573.72</td>\n",
       "      <td>2.32</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>16.71</td>\n",
       "      <td>5.48</td>\n",
       "      <td>14138.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-08-22</th>\n",
       "      <td>300693</td>\n",
       "      <td>盛弘股份</td>\n",
       "      <td>电气设备</td>\n",
       "      <td>深圳</td>\n",
       "      <td>54.61</td>\n",
       "      <td>0.23</td>\n",
       "      <td>0.91</td>\n",
       "      <td>78534.15</td>\n",
       "      <td>76455.40</td>\n",
       "      <td>1210.45</td>\n",
       "      <td>...</td>\n",
       "      <td>5.00</td>\n",
       "      <td>2017-08-22</td>\n",
       "      <td>12563.21</td>\n",
       "      <td>1.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>50.40</td>\n",
       "      <td>11.96</td>\n",
       "      <td>13821.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-12-29</th>\n",
       "      <td>300735</td>\n",
       "      <td>光弘科技</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>广东</td>\n",
       "      <td>43.81</td>\n",
       "      <td>0.89</td>\n",
       "      <td>3.55</td>\n",
       "      <td>106216.22</td>\n",
       "      <td>48046.23</td>\n",
       "      <td>48601.87</td>\n",
       "      <td>...</td>\n",
       "      <td>5.12</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>22749.50</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>27.77</td>\n",
       "      <td>14.27</td>\n",
       "      <td>58700.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-12-05</th>\n",
       "      <td>300730</td>\n",
       "      <td>科创信息</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>湖南</td>\n",
       "      <td>907.52</td>\n",
       "      <td>0.23</td>\n",
       "      <td>0.93</td>\n",
       "      <td>32997.26</td>\n",
       "      <td>24184.00</td>\n",
       "      <td>6611.02</td>\n",
       "      <td>...</td>\n",
       "      <td>17.95</td>\n",
       "      <td>2017-12-05</td>\n",
       "      <td>8310.85</td>\n",
       "      <td>0.89</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>36.00</td>\n",
       "      <td>2.69</td>\n",
       "      <td>48600.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-10-31</th>\n",
       "      <td>002910</td>\n",
       "      <td>庄园牧场</td>\n",
       "      <td>乳制品</td>\n",
       "      <td>甘肃</td>\n",
       "      <td>63.18</td>\n",
       "      <td>0.47</td>\n",
       "      <td>1.87</td>\n",
       "      <td>180371.77</td>\n",
       "      <td>87209.15</td>\n",
       "      <td>62579.91</td>\n",
       "      <td>...</td>\n",
       "      <td>3.83</td>\n",
       "      <td>2017-10-31</td>\n",
       "      <td>39948.32</td>\n",
       "      <td>2.13</td>\n",
       "      <td>-5.62</td>\n",
       "      <td>-9.96</td>\n",
       "      <td>30.71</td>\n",
       "      <td>10.88</td>\n",
       "      <td>27589.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-11-01</th>\n",
       "      <td>300711</td>\n",
       "      <td>广哈通信</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>广东</td>\n",
       "      <td>85.40</td>\n",
       "      <td>0.36</td>\n",
       "      <td>1.44</td>\n",
       "      <td>34718.62</td>\n",
       "      <td>30575.38</td>\n",
       "      <td>1612.71</td>\n",
       "      <td>...</td>\n",
       "      <td>11.25</td>\n",
       "      <td>2017-11-01</td>\n",
       "      <td>11660.60</td>\n",
       "      <td>0.81</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>53.03</td>\n",
       "      <td>20.22</td>\n",
       "      <td>71217.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-19</th>\n",
       "      <td>300738</td>\n",
       "      <td>奥飞数据</td>\n",
       "      <td>电信运营</td>\n",
       "      <td>广东</td>\n",
       "      <td>73.05</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.65</td>\n",
       "      <td>33440.90</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>14.12</td>\n",
       "      <td>2018-01-19</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>17.33</td>\n",
       "      <td>32672.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-08-08</th>\n",
       "      <td>603535</td>\n",
       "      <td>嘉诚国际</td>\n",
       "      <td>仓储物流</td>\n",
       "      <td>广东</td>\n",
       "      <td>31.44</td>\n",
       "      <td>0.38</td>\n",
       "      <td>1.50</td>\n",
       "      <td>171046.63</td>\n",
       "      <td>107917.27</td>\n",
       "      <td>36970.78</td>\n",
       "      <td>...</td>\n",
       "      <td>2.71</td>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>51971.03</td>\n",
       "      <td>3.46</td>\n",
       "      <td>20.47</td>\n",
       "      <td>14.32</td>\n",
       "      <td>23.11</td>\n",
       "      <td>11.49</td>\n",
       "      <td>16499.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-26</th>\n",
       "      <td>300514</td>\n",
       "      <td>友讯达</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>深圳</td>\n",
       "      <td>62.79</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.00</td>\n",
       "      <td>68944.21</td>\n",
       "      <td>66716.28</td>\n",
       "      <td>1369.74</td>\n",
       "      <td>...</td>\n",
       "      <td>8.14</td>\n",
       "      <td>2017-04-26</td>\n",
       "      <td>13530.61</td>\n",
       "      <td>1.35</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41.98</td>\n",
       "      <td>13.49</td>\n",
       "      <td>11522.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-16</th>\n",
       "      <td>300733</td>\n",
       "      <td>西菱动力</td>\n",
       "      <td>汽车配件</td>\n",
       "      <td>四川</td>\n",
       "      <td>47.62</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.60</td>\n",
       "      <td>102448.71</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>5.47</td>\n",
       "      <td>2018-01-16</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>15.61</td>\n",
       "      <td>77780.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-01</th>\n",
       "      <td>300739</td>\n",
       "      <td>明阳电路</td>\n",
       "      <td>元器件</td>\n",
       "      <td>深圳</td>\n",
       "      <td>39.96</td>\n",
       "      <td>0.31</td>\n",
       "      <td>1.23</td>\n",
       "      <td>96984.00</td>\n",
       "      <td>54019.57</td>\n",
       "      <td>36262.06</td>\n",
       "      <td>...</td>\n",
       "      <td>7.39</td>\n",
       "      <td>2018-02-01</td>\n",
       "      <td>14147.72</td>\n",
       "      <td>1.15</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>32.15</td>\n",
       "      <td>11.74</td>\n",
       "      <td>61548.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-31</th>\n",
       "      <td>300679</td>\n",
       "      <td>电连技术</td>\n",
       "      <td>元器件</td>\n",
       "      <td>深圳</td>\n",
       "      <td>25.50</td>\n",
       "      <td>0.30</td>\n",
       "      <td>1.20</td>\n",
       "      <td>329440.88</td>\n",
       "      <td>281085.16</td>\n",
       "      <td>34557.31</td>\n",
       "      <td>...</td>\n",
       "      <td>3.01</td>\n",
       "      <td>2017-07-31</td>\n",
       "      <td>59821.28</td>\n",
       "      <td>4.99</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47.23</td>\n",
       "      <td>26.21</td>\n",
       "      <td>23866.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-26</th>\n",
       "      <td>603363</td>\n",
       "      <td>傲农生物</td>\n",
       "      <td>饲料</td>\n",
       "      <td>福建</td>\n",
       "      <td>75.90</td>\n",
       "      <td>0.60</td>\n",
       "      <td>4.26</td>\n",
       "      <td>253808.34</td>\n",
       "      <td>117686.90</td>\n",
       "      <td>71882.36</td>\n",
       "      <td>...</td>\n",
       "      <td>10.01</td>\n",
       "      <td>2017-09-26</td>\n",
       "      <td>17489.06</td>\n",
       "      <td>0.41</td>\n",
       "      <td>-1.52</td>\n",
       "      <td>18.32</td>\n",
       "      <td>18.86</td>\n",
       "      <td>2.21</td>\n",
       "      <td>32006.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-12-27</th>\n",
       "      <td>300684</td>\n",
       "      <td>中石科技</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>北京</td>\n",
       "      <td>79.80</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.87</td>\n",
       "      <td>83437.31</td>\n",
       "      <td>56011.80</td>\n",
       "      <td>24528.76</td>\n",
       "      <td>...</td>\n",
       "      <td>11.84</td>\n",
       "      <td>2017-12-27</td>\n",
       "      <td>20423.99</td>\n",
       "      <td>2.35</td>\n",
       "      <td>187.49</td>\n",
       "      <td>123.06</td>\n",
       "      <td>36.42</td>\n",
       "      <td>14.42</td>\n",
       "      <td>17500.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-05</th>\n",
       "      <td>603032</td>\n",
       "      <td>德新交运</td>\n",
       "      <td>公路</td>\n",
       "      <td>新疆</td>\n",
       "      <td>175.30</td>\n",
       "      <td>0.65</td>\n",
       "      <td>1.33</td>\n",
       "      <td>49133.62</td>\n",
       "      <td>40787.21</td>\n",
       "      <td>4330.50</td>\n",
       "      <td>...</td>\n",
       "      <td>10.94</td>\n",
       "      <td>2017-01-05</td>\n",
       "      <td>12899.17</td>\n",
       "      <td>0.97</td>\n",
       "      <td>-22.93</td>\n",
       "      <td>-46.61</td>\n",
       "      <td>36.61</td>\n",
       "      <td>13.73</td>\n",
       "      <td>2328.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-08-22</th>\n",
       "      <td>300696</td>\n",
       "      <td>爱乐达</td>\n",
       "      <td>航空</td>\n",
       "      <td>四川</td>\n",
       "      <td>103.57</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.69</td>\n",
       "      <td>72619.96</td>\n",
       "      <td>53274.55</td>\n",
       "      <td>14581.25</td>\n",
       "      <td>...</td>\n",
       "      <td>7.53</td>\n",
       "      <td>2017-08-22</td>\n",
       "      <td>9670.87</td>\n",
       "      <td>1.40</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>71.14</td>\n",
       "      <td>52.00</td>\n",
       "      <td>14938.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-20</th>\n",
       "      <td>300613</td>\n",
       "      <td>富瀚微</td>\n",
       "      <td>半导体</td>\n",
       "      <td>上海</td>\n",
       "      <td>68.97</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.45</td>\n",
       "      <td>97363.90</td>\n",
       "      <td>85505.56</td>\n",
       "      <td>1777.51</td>\n",
       "      <td>...</td>\n",
       "      <td>7.87</td>\n",
       "      <td>2017-02-20</td>\n",
       "      <td>26320.40</td>\n",
       "      <td>5.81</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>49.46</td>\n",
       "      <td>25.26</td>\n",
       "      <td>11264.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-09-13</th>\n",
       "      <td>603648</td>\n",
       "      <td>畅联股份</td>\n",
       "      <td>仓储物流</td>\n",
       "      <td>上海</td>\n",
       "      <td>48.82</td>\n",
       "      <td>0.92</td>\n",
       "      <td>3.69</td>\n",
       "      <td>181480.97</td>\n",
       "      <td>129244.95</td>\n",
       "      <td>28878.70</td>\n",
       "      <td>...</td>\n",
       "      <td>5.11</td>\n",
       "      <td>2017-09-13</td>\n",
       "      <td>20402.98</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>27.63</td>\n",
       "      <td>13.54</td>\n",
       "      <td>58370.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-12-29</th>\n",
       "      <td>603329</td>\n",
       "      <td>上海雅仕</td>\n",
       "      <td>仓储物流</td>\n",
       "      <td>上海</td>\n",
       "      <td>65.33</td>\n",
       "      <td>0.33</td>\n",
       "      <td>1.32</td>\n",
       "      <td>84900.68</td>\n",
       "      <td>72657.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>8.46</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.37</td>\n",
       "      <td>35041.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-12-08</th>\n",
       "      <td>300731</td>\n",
       "      <td>科创新源</td>\n",
       "      <td>橡胶</td>\n",
       "      <td>深圳</td>\n",
       "      <td>52.75</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.87</td>\n",
       "      <td>26369.38</td>\n",
       "      <td>23502.03</td>\n",
       "      <td>1737.75</td>\n",
       "      <td>...</td>\n",
       "      <td>11.11</td>\n",
       "      <td>2017-12-08</td>\n",
       "      <td>5390.14</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>48.54</td>\n",
       "      <td>25.94</td>\n",
       "      <td>45956.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-06</th>\n",
       "      <td>300661</td>\n",
       "      <td>圣邦股份</td>\n",
       "      <td>元器件</td>\n",
       "      <td>北京</td>\n",
       "      <td>87.02</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.61</td>\n",
       "      <td>86190.96</td>\n",
       "      <td>82643.93</td>\n",
       "      <td>1150.35</td>\n",
       "      <td>...</td>\n",
       "      <td>8.73</td>\n",
       "      <td>2017-06-06</td>\n",
       "      <td>19735.47</td>\n",
       "      <td>3.24</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>43.62</td>\n",
       "      <td>16.02</td>\n",
       "      <td>5677.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-05</th>\n",
       "      <td>300588</td>\n",
       "      <td>熙菱信息</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>新疆</td>\n",
       "      <td>65.77</td>\n",
       "      <td>0.31</td>\n",
       "      <td>1.00</td>\n",
       "      <td>84675.42</td>\n",
       "      <td>79111.96</td>\n",
       "      <td>736.22</td>\n",
       "      <td>...</td>\n",
       "      <td>8.19</td>\n",
       "      <td>2017-01-05</td>\n",
       "      <td>13293.88</td>\n",
       "      <td>1.33</td>\n",
       "      <td>35.56</td>\n",
       "      <td>85.39</td>\n",
       "      <td>24.81</td>\n",
       "      <td>7.47</td>\n",
       "      <td>10945.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-26</th>\n",
       "      <td>300603</td>\n",
       "      <td>立昂技术</td>\n",
       "      <td>通信设备</td>\n",
       "      <td>新疆</td>\n",
       "      <td>47.46</td>\n",
       "      <td>0.57</td>\n",
       "      <td>1.03</td>\n",
       "      <td>124445.82</td>\n",
       "      <td>99134.21</td>\n",
       "      <td>2345.56</td>\n",
       "      <td>...</td>\n",
       "      <td>8.70</td>\n",
       "      <td>2017-01-26</td>\n",
       "      <td>16070.23</td>\n",
       "      <td>1.57</td>\n",
       "      <td>247.32</td>\n",
       "      <td>259.16</td>\n",
       "      <td>20.03</td>\n",
       "      <td>8.61</td>\n",
       "      <td>11752.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-11-09</th>\n",
       "      <td>300719</td>\n",
       "      <td>安达维尔</td>\n",
       "      <td>航空</td>\n",
       "      <td>北京</td>\n",
       "      <td>53.58</td>\n",
       "      <td>0.42</td>\n",
       "      <td>1.68</td>\n",
       "      <td>111330.52</td>\n",
       "      <td>99828.74</td>\n",
       "      <td>9335.78</td>\n",
       "      <td>...</td>\n",
       "      <td>5.00</td>\n",
       "      <td>2017-11-09</td>\n",
       "      <td>26470.75</td>\n",
       "      <td>1.58</td>\n",
       "      <td>10.59</td>\n",
       "      <td>-1.52</td>\n",
       "      <td>53.67</td>\n",
       "      <td>20.42</td>\n",
       "      <td>25100.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-08-03</th>\n",
       "      <td>300687</td>\n",
       "      <td>赛意信息</td>\n",
       "      <td>软件服务</td>\n",
       "      <td>广东</td>\n",
       "      <td>52.57</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.80</td>\n",
       "      <td>83921.68</td>\n",
       "      <td>80942.17</td>\n",
       "      <td>291.20</td>\n",
       "      <td>...</td>\n",
       "      <td>6.36</td>\n",
       "      <td>2017-08-03</td>\n",
       "      <td>14224.57</td>\n",
       "      <td>1.78</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>31.36</td>\n",
       "      <td>13.34</td>\n",
       "      <td>13585.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-10-19</th>\n",
       "      <td>300709</td>\n",
       "      <td>精研科技</td>\n",
       "      <td>元器件</td>\n",
       "      <td>江苏</td>\n",
       "      <td>31.01</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.88</td>\n",
       "      <td>104817.97</td>\n",
       "      <td>51288.05</td>\n",
       "      <td>36566.43</td>\n",
       "      <td>...</td>\n",
       "      <td>3.83</td>\n",
       "      <td>2017-10-19</td>\n",
       "      <td>26389.69</td>\n",
       "      <td>3.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>40.49</td>\n",
       "      <td>17.04</td>\n",
       "      <td>16000.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-16</th>\n",
       "      <td>300653</td>\n",
       "      <td>正海生物</td>\n",
       "      <td>医疗保健</td>\n",
       "      <td>山东</td>\n",
       "      <td>65.83</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.80</td>\n",
       "      <td>53081.60</td>\n",
       "      <td>45645.28</td>\n",
       "      <td>2500.00</td>\n",
       "      <td>...</td>\n",
       "      <td>8.40</td>\n",
       "      <td>2017-05-16</td>\n",
       "      <td>12030.73</td>\n",
       "      <td>1.50</td>\n",
       "      <td>21.35</td>\n",
       "      <td>35.63</td>\n",
       "      <td>93.67</td>\n",
       "      <td>33.74</td>\n",
       "      <td>8714.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-11-27</th>\n",
       "      <td>300727</td>\n",
       "      <td>润禾材料</td>\n",
       "      <td>化工原料</td>\n",
       "      <td>浙江</td>\n",
       "      <td>90.09</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.98</td>\n",
       "      <td>43196.92</td>\n",
       "      <td>25291.61</td>\n",
       "      <td>12968.00</td>\n",
       "      <td>...</td>\n",
       "      <td>8.96</td>\n",
       "      <td>2017-11-27</td>\n",
       "      <td>8362.07</td>\n",
       "      <td>0.86</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29.56</td>\n",
       "      <td>10.75</td>\n",
       "      <td>50562.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-23</th>\n",
       "      <td>300657</td>\n",
       "      <td>弘信电子</td>\n",
       "      <td>元器件</td>\n",
       "      <td>福建</td>\n",
       "      <td>67.08</td>\n",
       "      <td>0.26</td>\n",
       "      <td>1.04</td>\n",
       "      <td>184841.84</td>\n",
       "      <td>111414.60</td>\n",
       "      <td>59763.01</td>\n",
       "      <td>...</td>\n",
       "      <td>6.42</td>\n",
       "      <td>2017-05-23</td>\n",
       "      <td>18206.14</td>\n",
       "      <td>1.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>13.57</td>\n",
       "      <td>3.79</td>\n",
       "      <td>11765.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>477 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                code  name industry area      pe  outstanding  totals  \\\n",
       "timeToMarket                                                            \n",
       "2018-04-10    603897   N长城     电气设备   浙江   25.57         0.45    1.78   \n",
       "2018-03-26    600929  湖南盐业       食品   湖南   72.52         1.50    9.18   \n",
       "2017-03-16    300621  维业股份     装修装饰   深圳   37.99         0.43    1.39   \n",
       "2017-09-20    603106  恒银金融     电脑设备   天津   45.40         0.70    2.80   \n",
       "2017-03-15    603811  诚意药业     化学制药   浙江   38.80         0.57    0.85   \n",
       "2018-03-28    002930  宏川智慧     仓储物流   广东   62.90         0.61    2.43   \n",
       "2017-09-22    603963  大理药业     化学制药   云南   73.92         0.25    1.00   \n",
       "2018-03-30    603214   爱婴室       百货   上海   49.45         0.25    1.00   \n",
       "2017-01-17    300595  欧普康视     医疗保健   安徽   54.16         0.76    1.24   \n",
       "2017-03-21    300627  华测导航     通信设备   上海   85.66         0.50    1.23   \n",
       "2017-02-08    603637  镇海股份     建筑施工   浙江   66.69         0.33    1.33   \n",
       "2017-10-10    300705  九典制药     化学制药   湖南   89.94         0.29    1.17   \n",
       "2017-10-31    603289  泰瑞机器     专用机械   浙江   45.82         0.51    2.04   \n",
       "2017-05-09    603229  奥翔药业     化学制药   浙江   93.03         0.40    1.60   \n",
       "2017-06-02    300660  江苏雷利     电气设备   江苏   26.10         0.25    1.02   \n",
       "2017-09-22    002900   哈三联     化学制药  黑龙江   44.11         0.53    2.11   \n",
       "2017-05-19    002873  新天药业      中成药   贵州   44.54         0.17    0.69   \n",
       "2017-08-10    300688  创业黑马      综合类   北京  171.33         0.17    0.68   \n",
       "2018-02-26    603712   七一二     通信设备   天津  363.05         1.00    7.72   \n",
       "2017-11-21    300726  宏达电子      元器件   湖南   86.52         0.40    4.00   \n",
       "2017-07-03    300670  大烨智能     电气设备   江苏   88.13         0.27    1.08   \n",
       "2017-04-21    300554  三超新材     矿物制品   江苏   94.44         0.13    0.52   \n",
       "2017-05-22    603383  顶点软件     软件服务   福建   49.79         0.21    0.86   \n",
       "2018-02-23    002927  泰永长征     电气设备   贵州  102.26         0.23    0.94   \n",
       "2018-02-06    300644  南京聚隆       塑料   江苏   62.16         0.16    0.64   \n",
       "2017-01-20    300598  诚迈科技     软件服务   江苏  111.58         0.48    0.80   \n",
       "2017-01-10    603266  天龙股份       塑料   浙江   34.03         0.25    1.00   \n",
       "2017-12-18    002919  名臣健康     日用化工   广东   69.13         0.20    0.81   \n",
       "2017-04-21    603139  康惠制药      中成药   陕西   61.04         0.25    1.00   \n",
       "2018-03-23    300634  彩讯股份     软件服务   深圳   81.30         0.40    4.00   \n",
       "...              ...   ...      ...  ...     ...          ...     ...   \n",
       "2017-03-24    300629   新劲刚     矿物制品   广东  137.29         0.29    0.67   \n",
       "2017-11-15    300721  怡达股份     化工原料   江苏   40.04         0.20    0.80   \n",
       "2017-08-22    300693  盛弘股份     电气设备   深圳   54.61         0.23    0.91   \n",
       "2017-12-29    300735  光弘科技     通信设备   广东   43.81         0.89    3.55   \n",
       "2017-12-05    300730  科创信息     软件服务   湖南  907.52         0.23    0.93   \n",
       "2017-10-31    002910  庄园牧场      乳制品   甘肃   63.18         0.47    1.87   \n",
       "2017-11-01    300711  广哈通信     通信设备   广东   85.40         0.36    1.44   \n",
       "2018-01-19    300738  奥飞数据     电信运营   广东   73.05         0.16    0.65   \n",
       "2017-08-08    603535  嘉诚国际     仓储物流   广东   31.44         0.38    1.50   \n",
       "2017-04-26    300514   友讯达     通信设备   深圳   62.79         0.25    1.00   \n",
       "2018-01-16    300733  西菱动力     汽车配件   四川   47.62         0.40    1.60   \n",
       "2018-02-01    300739  明阳电路      元器件   深圳   39.96         0.31    1.23   \n",
       "2017-07-31    300679  电连技术      元器件   深圳   25.50         0.30    1.20   \n",
       "2017-09-26    603363  傲农生物       饲料   福建   75.90         0.60    4.26   \n",
       "2017-12-27    300684  中石科技     化工原料   北京   79.80         0.22    0.87   \n",
       "2017-01-05    603032  德新交运       公路   新疆  175.30         0.65    1.33   \n",
       "2017-08-22    300696   爱乐达       航空   四川  103.57         0.17    0.69   \n",
       "2017-02-20    300613   富瀚微      半导体   上海   68.97         0.13    0.45   \n",
       "2017-09-13    603648  畅联股份     仓储物流   上海   48.82         0.92    3.69   \n",
       "2017-12-29    603329  上海雅仕     仓储物流   上海   65.33         0.33    1.32   \n",
       "2017-12-08    300731  科创新源       橡胶   深圳   52.75         0.22    0.87   \n",
       "2017-06-06    300661  圣邦股份      元器件   北京   87.02         0.15    0.61   \n",
       "2017-01-05    300588  熙菱信息     软件服务   新疆   65.77         0.31    1.00   \n",
       "2017-01-26    300603  立昂技术     通信设备   新疆   47.46         0.57    1.03   \n",
       "2017-11-09    300719  安达维尔       航空   北京   53.58         0.42    1.68   \n",
       "2017-08-03    300687  赛意信息     软件服务   广东   52.57         0.20    0.80   \n",
       "2017-10-19    300709  精研科技      元器件   江苏   31.01         0.22    0.88   \n",
       "2017-05-16    300653  正海生物     医疗保健   山东   65.83         0.20    0.80   \n",
       "2017-11-27    300727  润禾材料     化工原料   浙江   90.09         0.24    0.98   \n",
       "2017-05-23    300657  弘信电子      元器件   福建   67.08         0.26    1.04   \n",
       "\n",
       "              totalAssets  liquidAssets  fixedAssets     ...         pb  \\\n",
       "timeToMarket                                             ...              \n",
       "2018-04-10      131807.23     117523.63     10988.37     ...       4.27   \n",
       "2018-03-26      310491.63      78859.31    139873.81     ...       5.36   \n",
       "2017-03-16      186181.06     169977.59      2515.88     ...       3.41   \n",
       "2017-09-20      212309.42     190471.27     16428.07     ...       4.80   \n",
       "2017-03-15       67298.32      46722.62     12191.86     ...       4.48   \n",
       "2018-03-28      187270.80      13539.20    103894.40     ...       3.66   \n",
       "2017-09-22       62622.20      44925.30     10986.69     ...       8.40   \n",
       "2018-03-30       76961.15      61297.16      7078.72     ...       9.27   \n",
       "2017-01-17       84769.46      71856.96      3970.03     ...      10.12   \n",
       "2017-03-21       95269.30      88869.28      2105.35     ...       9.13   \n",
       "2017-02-08       86330.46      76018.32      5968.18     ...       4.33   \n",
       "2017-10-10       76920.25      51869.26     13084.78     ...       9.34   \n",
       "2017-10-31       88554.82      68437.21     15267.82     ...       5.65   \n",
       "2017-05-09       68624.13      45903.00     14470.87     ...       7.22   \n",
       "2017-06-02      280316.22     256656.80     16994.20     ...       3.21   \n",
       "2017-09-22      218374.66     135898.92     68163.18     ...       4.35   \n",
       "2017-05-19       91925.27      57405.90     21257.95     ...       5.89   \n",
       "2017-08-10       41396.55      40351.37       380.64     ...      14.13   \n",
       "2018-02-26      348015.50     277392.63     57633.35     ...      21.08   \n",
       "2017-11-21      100780.30      80427.53      8466.57     ...      16.70   \n",
       "2017-07-03       69398.42      59512.13      6638.05     ...       6.81   \n",
       "2017-04-21       48783.32      33910.75     12251.67     ...      10.86   \n",
       "2017-05-22      115820.30     104881.36      3878.28     ...       5.41   \n",
       "2018-02-23       43605.35      35037.03         0.00     ...      12.70   \n",
       "2018-02-06       82547.78      60597.23     18706.01     ...       6.21   \n",
       "2017-01-20       53850.86      44918.25       626.82     ...       9.78   \n",
       "2017-01-10       98374.46      71618.72     18603.42     ...       3.68   \n",
       "2017-12-18       46302.28          0.00         0.00     ...       6.24   \n",
       "2017-04-21       94826.35      81229.31      5390.80     ...       3.35   \n",
       "2018-03-23      100621.55      65063.45      1320.74     ...      11.01   \n",
       "...                   ...           ...          ...     ...        ...   \n",
       "2017-03-24       48471.40      36097.23      8623.61     ...       9.68   \n",
       "2017-11-15      100619.93      60467.48     21425.98     ...       3.09   \n",
       "2017-08-22       78534.15      76455.40      1210.45     ...       5.00   \n",
       "2017-12-29      106216.22      48046.23     48601.87     ...       5.12   \n",
       "2017-12-05       32997.26      24184.00      6611.02     ...      17.95   \n",
       "2017-10-31      180371.77      87209.15     62579.91     ...       3.83   \n",
       "2017-11-01       34718.62      30575.38      1612.71     ...      11.25   \n",
       "2018-01-19       33440.90          0.00         0.00     ...      14.12   \n",
       "2017-08-08      171046.63     107917.27     36970.78     ...       2.71   \n",
       "2017-04-26       68944.21      66716.28      1369.74     ...       8.14   \n",
       "2018-01-16      102448.71          0.00         0.00     ...       5.47   \n",
       "2018-02-01       96984.00      54019.57     36262.06     ...       7.39   \n",
       "2017-07-31      329440.88     281085.16     34557.31     ...       3.01   \n",
       "2017-09-26      253808.34     117686.90     71882.36     ...      10.01   \n",
       "2017-12-27       83437.31      56011.80     24528.76     ...      11.84   \n",
       "2017-01-05       49133.62      40787.21      4330.50     ...      10.94   \n",
       "2017-08-22       72619.96      53274.55     14581.25     ...       7.53   \n",
       "2017-02-20       97363.90      85505.56      1777.51     ...       7.87   \n",
       "2017-09-13      181480.97     129244.95     28878.70     ...       5.11   \n",
       "2017-12-29       84900.68      72657.60         0.00     ...       8.46   \n",
       "2017-12-08       26369.38      23502.03      1737.75     ...      11.11   \n",
       "2017-06-06       86190.96      82643.93      1150.35     ...       8.73   \n",
       "2017-01-05       84675.42      79111.96       736.22     ...       8.19   \n",
       "2017-01-26      124445.82      99134.21      2345.56     ...       8.70   \n",
       "2017-11-09      111330.52      99828.74      9335.78     ...       5.00   \n",
       "2017-08-03       83921.68      80942.17       291.20     ...       6.36   \n",
       "2017-10-19      104817.97      51288.05     36566.43     ...       3.83   \n",
       "2017-05-16       53081.60      45645.28      2500.00     ...       8.40   \n",
       "2017-11-27       43196.92      25291.61     12968.00     ...       8.96   \n",
       "2017-05-23      184841.84     111414.60     59763.01     ...       6.42   \n",
       "\n",
       "              timeToMarket      undp  perundp     rev  profit    gpr    npr  \\\n",
       "timeToMarket                                                                  \n",
       "2018-04-10      2018-04-10  35286.05     1.98   41.98   55.84   8.19   3.87   \n",
       "2018-03-26      2018-03-26  71625.13     0.78    1.30   15.06  47.71   7.24   \n",
       "2017-03-16      2017-03-16  26666.50     1.92    0.00    0.00  13.34   4.22   \n",
       "2017-09-20      2017-09-20  27721.10     0.99    0.00    0.00  33.95  11.23   \n",
       "2017-03-15      2017-03-15   9561.42     1.12    6.12    1.57  52.11  20.31   \n",
       "2018-03-28      2018-03-28  38270.21     1.57   -0.74   10.33  56.59  25.41   \n",
       "2017-09-22      2017-09-22   9541.13     0.95    0.00    0.00  63.85  20.00   \n",
       "2018-03-30      2018-03-30  25456.17     2.55   14.06   26.47  28.41   5.18   \n",
       "2017-01-17      2017-01-17  20604.49     1.66   31.61   29.56  76.06  50.72   \n",
       "2017-03-21      2017-03-21  19288.67     1.56    0.00    0.00  54.56  14.97   \n",
       "2017-02-08      2017-02-08  20656.95     1.55  -37.75  -28.91  31.54  22.63   \n",
       "2017-10-10      2017-10-10  12709.62     1.08   42.01   25.76  51.93  12.83   \n",
       "2017-10-31      2017-10-31  26118.49     1.28    0.00    0.00  30.63  12.40   \n",
       "2017-05-09      2017-05-09  14151.70     0.88    0.00    0.00  60.63  22.65   \n",
       "2017-06-02      2017-06-02  33226.21     3.26    0.00    0.00  26.74  12.07   \n",
       "2017-09-22      2017-09-22  39189.78     1.86   50.99    3.36  74.17  15.76   \n",
       "2017-05-19      2017-05-19  18090.75     2.63    0.00    0.00  81.09  11.75   \n",
       "2017-08-10      2017-08-10   6212.93     0.91    0.00    0.00  56.91  17.97   \n",
       "2018-02-26      2018-02-26  20558.85     0.27    0.00    0.00  49.57   8.39   \n",
       "2017-11-21      2017-11-21  23141.20     0.58    0.00    0.00  70.73  39.73   \n",
       "2017-07-03      2017-07-03  14113.52     1.31    0.00    0.00  31.06  15.77   \n",
       "2017-04-21      2017-04-21  10747.62     2.07    0.00    0.00  47.15  24.98   \n",
       "2017-05-22      2017-05-22  38075.21     4.43   19.09   44.59  78.78  41.80   \n",
       "2018-02-23      2018-02-23      0.00     0.00    0.00    0.00   0.00  18.51   \n",
       "2018-02-06      2018-02-06  25969.65     4.06   13.33  -28.26  17.55   5.51   \n",
       "2017-01-20      2017-01-20  17461.71     2.18   -3.84  -22.12  31.26   8.10   \n",
       "2017-01-10      2017-01-10  33154.17     3.32    8.21    4.72  28.05  10.33   \n",
       "2017-12-18      2017-12-18      0.00     0.00    0.00    0.00   0.00   7.77   \n",
       "2017-04-21      2017-04-21  33866.51     3.39    0.00    0.00  57.10  15.64   \n",
       "2018-03-23      2018-03-23  19710.35     0.49   33.46   44.54  48.01  21.36   \n",
       "...                    ...       ...      ...     ...     ...    ...    ...   \n",
       "2017-03-24      2017-03-24  12290.36     1.84    2.26   -8.10  32.24   9.84   \n",
       "2017-11-15      2017-11-15  18573.72     2.32    0.00    0.00  16.71   5.48   \n",
       "2017-08-22      2017-08-22  12563.21     1.38    0.00    0.00  50.40  11.96   \n",
       "2017-12-29      2017-12-29  22749.50     0.64    0.00    0.00  27.77  14.27   \n",
       "2017-12-05      2017-12-05   8310.85     0.89    0.00    0.00  36.00   2.69   \n",
       "2017-10-31      2017-10-31  39948.32     2.13   -5.62   -9.96  30.71  10.88   \n",
       "2017-11-01      2017-11-01  11660.60     0.81    0.00    0.00  53.03  20.22   \n",
       "2018-01-19      2018-01-19      0.00     0.00    0.00    0.00   0.00  17.33   \n",
       "2017-08-08      2017-08-08  51971.03     3.46   20.47   14.32  23.11  11.49   \n",
       "2017-04-26      2017-04-26  13530.61     1.35    0.00    0.00  41.98  13.49   \n",
       "2018-01-16      2018-01-16      0.00     0.00    0.00    0.00   0.00  15.61   \n",
       "2018-02-01      2018-02-01  14147.72     1.15    0.00    0.00  32.15  11.74   \n",
       "2017-07-31      2017-07-31  59821.28     4.99    0.00    0.00  47.23  26.21   \n",
       "2017-09-26      2017-09-26  17489.06     0.41   -1.52   18.32  18.86   2.21   \n",
       "2017-12-27      2017-12-27  20423.99     2.35  187.49  123.06  36.42  14.42   \n",
       "2017-01-05      2017-01-05  12899.17     0.97  -22.93  -46.61  36.61  13.73   \n",
       "2017-08-22      2017-08-22   9670.87     1.40    0.00    0.00  71.14  52.00   \n",
       "2017-02-20      2017-02-20  26320.40     5.81    0.00    0.00  49.46  25.26   \n",
       "2017-09-13      2017-09-13  20402.98     0.55    0.00    0.00  27.63  13.54   \n",
       "2017-12-29      2017-12-29      0.00     0.00    0.00    0.00   0.00   4.37   \n",
       "2017-12-08      2017-12-08   5390.14     0.62    0.00    0.00  48.54  25.94   \n",
       "2017-06-06      2017-06-06  19735.47     3.24    0.00    0.00  43.62  16.02   \n",
       "2017-01-05      2017-01-05  13293.88     1.33   35.56   85.39  24.81   7.47   \n",
       "2017-01-26      2017-01-26  16070.23     1.57  247.32  259.16  20.03   8.61   \n",
       "2017-11-09      2017-11-09  26470.75     1.58   10.59   -1.52  53.67  20.42   \n",
       "2017-08-03      2017-08-03  14224.57     1.78    0.00    0.00  31.36  13.34   \n",
       "2017-10-19      2017-10-19  26389.69     3.00    0.00    0.00  40.49  17.04   \n",
       "2017-05-16      2017-05-16  12030.73     1.50   21.35   35.63  93.67  33.74   \n",
       "2017-11-27      2017-11-27   8362.07     0.86    0.00    0.00  29.56  10.75   \n",
       "2017-05-23      2017-05-23  18206.14     1.75    0.00    0.00  13.57   3.79   \n",
       "\n",
       "               holders        更新日期  \n",
       "timeToMarket                        \n",
       "2018-04-10     42986.0  2018-04-11  \n",
       "2018-03-26    140295.0  2018-04-11  \n",
       "2017-03-16     19044.0  2018-04-11  \n",
       "2017-09-20     36000.0  2018-04-11  \n",
       "2017-03-15     10574.0  2018-04-11  \n",
       "2018-03-28    115500.0  2018-04-11  \n",
       "2017-09-22     27488.0  2018-04-11  \n",
       "2018-03-30     26639.0  2018-04-11  \n",
       "2017-01-17      6781.0  2018-04-11  \n",
       "2017-03-21     16380.0  2018-04-11  \n",
       "2017-02-08      9897.0  2018-04-11  \n",
       "2017-10-10     21243.0  2018-04-11  \n",
       "2017-10-31     48514.0  2018-04-11  \n",
       "2017-05-09     14088.0  2018-04-11  \n",
       "2017-06-02     18283.0  2018-04-11  \n",
       "2017-09-22     38400.0  2018-04-11  \n",
       "2017-05-19      9615.0  2018-04-11  \n",
       "2017-08-10     15720.0  2018-04-11  \n",
       "2018-02-26     88473.0  2018-04-11  \n",
       "2017-11-21     79196.0  2018-04-11  \n",
       "2017-07-03     13484.0  2018-04-11  \n",
       "2017-04-21      4538.0  2018-04-11  \n",
       "2017-05-22      8928.0  2018-04-11  \n",
       "2018-02-23     48823.0  2018-04-11  \n",
       "2018-02-06     31946.0  2018-04-11  \n",
       "2017-01-20      9182.0  2018-04-11  \n",
       "2017-01-10      8819.0  2018-04-11  \n",
       "2017-12-18     43677.0  2018-04-11  \n",
       "2017-04-21     13137.0  2018-04-11  \n",
       "2018-03-23     77432.0  2018-04-11  \n",
       "...                ...         ...  \n",
       "2017-03-24      7729.0  2018-04-11  \n",
       "2017-11-15     14138.0  2018-04-11  \n",
       "2017-08-22     13821.0  2018-04-11  \n",
       "2017-12-29     58700.0  2018-04-11  \n",
       "2017-12-05     48600.0  2018-04-11  \n",
       "2017-10-31     27589.0  2018-04-11  \n",
       "2017-11-01     71217.0  2018-04-11  \n",
       "2018-01-19     32672.0  2018-04-11  \n",
       "2017-08-08     16499.0  2018-04-11  \n",
       "2017-04-26     11522.0  2018-04-11  \n",
       "2018-01-16     77780.0  2018-04-11  \n",
       "2018-02-01     61548.0  2018-04-11  \n",
       "2017-07-31     23866.0  2018-04-11  \n",
       "2017-09-26     32006.0  2018-04-11  \n",
       "2017-12-27     17500.0  2018-04-11  \n",
       "2017-01-05      2328.0  2018-04-11  \n",
       "2017-08-22     14938.0  2018-04-11  \n",
       "2017-02-20     11264.0  2018-04-11  \n",
       "2017-09-13     58370.0  2018-04-11  \n",
       "2017-12-29     35041.0  2018-04-11  \n",
       "2017-12-08     45956.0  2018-04-11  \n",
       "2017-06-06      5677.0  2018-04-11  \n",
       "2017-01-05     10945.0  2018-04-11  \n",
       "2017-01-26     11752.0  2018-04-11  \n",
       "2017-11-09     25100.0  2018-04-11  \n",
       "2017-08-03     13585.0  2018-04-11  \n",
       "2017-10-19     16000.0  2018-04-11  \n",
       "2017-05-16      8714.0  2018-04-11  \n",
       "2017-11-27     50562.0  2018-04-11  \n",
       "2017-05-23     11765.0  2018-04-11  \n",
       "\n",
       "[477 rows x 24 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "basic_df['2017':'2018']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [],
   "source": [
    "dfs = basic_df['2016':'2018']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>code</th>\n",
       "      <th>name</th>\n",
       "      <th>industry</th>\n",
       "      <th>area</th>\n",
       "      <th>pe</th>\n",
       "      <th>outstanding</th>\n",
       "      <th>totals</th>\n",
       "      <th>totalAssets</th>\n",
       "      <th>liquidAssets</th>\n",
       "      <th>fixedAssets</th>\n",
       "      <th>...</th>\n",
       "      <th>pb</th>\n",
       "      <th>timeToMarket</th>\n",
       "      <th>undp</th>\n",
       "      <th>perundp</th>\n",
       "      <th>rev</th>\n",
       "      <th>profit</th>\n",
       "      <th>gpr</th>\n",
       "      <th>npr</th>\n",
       "      <th>holders</th>\n",
       "      <th>更新日期</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>timeToMarket</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2017-05-04</th>\n",
       "      <td>603501</td>\n",
       "      <td>韦尔股份</td>\n",
       "      <td>半导体</td>\n",
       "      <td>上海</td>\n",
       "      <td>137.28</td>\n",
       "      <td>0.42</td>\n",
       "      <td>4.56</td>\n",
       "      <td>204200.45</td>\n",
       "      <td>169034.19</td>\n",
       "      <td>17705.68</td>\n",
       "      <td>...</td>\n",
       "      <td>14.75</td>\n",
       "      <td>2017-05-04</td>\n",
       "      <td>47177.93</td>\n",
       "      <td>1.04</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19.10</td>\n",
       "      <td>6.20</td>\n",
       "      <td>22079.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-05</th>\n",
       "      <td>300671</td>\n",
       "      <td>富满电子</td>\n",
       "      <td>半导体</td>\n",
       "      <td>深圳</td>\n",
       "      <td>95.24</td>\n",
       "      <td>0.25</td>\n",
       "      <td>1.01</td>\n",
       "      <td>68242.43</td>\n",
       "      <td>51843.62</td>\n",
       "      <td>14202.12</td>\n",
       "      <td>...</td>\n",
       "      <td>7.73</td>\n",
       "      <td>2017-07-05</td>\n",
       "      <td>10927.21</td>\n",
       "      <td>1.08</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>27.95</td>\n",
       "      <td>11.63</td>\n",
       "      <td>10100.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-17</th>\n",
       "      <td>300625</td>\n",
       "      <td>三雄极光</td>\n",
       "      <td>半导体</td>\n",
       "      <td>广东</td>\n",
       "      <td>29.17</td>\n",
       "      <td>0.91</td>\n",
       "      <td>2.80</td>\n",
       "      <td>271604.44</td>\n",
       "      <td>225907.66</td>\n",
       "      <td>23129.76</td>\n",
       "      <td>...</td>\n",
       "      <td>2.96</td>\n",
       "      <td>2017-03-17</td>\n",
       "      <td>60387.82</td>\n",
       "      <td>2.16</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33.28</td>\n",
       "      <td>10.85</td>\n",
       "      <td>44932.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-06</th>\n",
       "      <td>300632</td>\n",
       "      <td>光莆股份</td>\n",
       "      <td>半导体</td>\n",
       "      <td>福建</td>\n",
       "      <td>41.73</td>\n",
       "      <td>0.37</td>\n",
       "      <td>1.16</td>\n",
       "      <td>66851.96</td>\n",
       "      <td>43581.01</td>\n",
       "      <td>19568.85</td>\n",
       "      <td>...</td>\n",
       "      <td>4.80</td>\n",
       "      <td>2017-04-06</td>\n",
       "      <td>19050.15</td>\n",
       "      <td>1.65</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>30.13</td>\n",
       "      <td>12.38</td>\n",
       "      <td>11562.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-10-12</th>\n",
       "      <td>002815</td>\n",
       "      <td>崇达技术</td>\n",
       "      <td>半导体</td>\n",
       "      <td>深圳</td>\n",
       "      <td>32.88</td>\n",
       "      <td>1.06</td>\n",
       "      <td>4.10</td>\n",
       "      <td>494307.56</td>\n",
       "      <td>244897.22</td>\n",
       "      <td>177228.13</td>\n",
       "      <td>...</td>\n",
       "      <td>5.78</td>\n",
       "      <td>2016-10-12</td>\n",
       "      <td>114256.76</td>\n",
       "      <td>2.79</td>\n",
       "      <td>38.10</td>\n",
       "      <td>18.14</td>\n",
       "      <td>32.61</td>\n",
       "      <td>14.31</td>\n",
       "      <td>27600.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-12-28</th>\n",
       "      <td>300582</td>\n",
       "      <td>英飞特</td>\n",
       "      <td>半导体</td>\n",
       "      <td>浙江</td>\n",
       "      <td>83.81</td>\n",
       "      <td>1.21</td>\n",
       "      <td>2.03</td>\n",
       "      <td>136238.97</td>\n",
       "      <td>45586.10</td>\n",
       "      <td>56919.20</td>\n",
       "      <td>...</td>\n",
       "      <td>3.62</td>\n",
       "      <td>2016-12-28</td>\n",
       "      <td>20920.55</td>\n",
       "      <td>1.03</td>\n",
       "      <td>18.08</td>\n",
       "      <td>-34.88</td>\n",
       "      <td>30.55</td>\n",
       "      <td>5.69</td>\n",
       "      <td>17911.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-03-14</th>\n",
       "      <td>300623</td>\n",
       "      <td>捷捷微电</td>\n",
       "      <td>半导体</td>\n",
       "      <td>江苏</td>\n",
       "      <td>42.11</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.94</td>\n",
       "      <td>133111.38</td>\n",
       "      <td>91724.80</td>\n",
       "      <td>25565.35</td>\n",
       "      <td>...</td>\n",
       "      <td>5.18</td>\n",
       "      <td>2017-03-14</td>\n",
       "      <td>33622.19</td>\n",
       "      <td>3.59</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>56.49</td>\n",
       "      <td>35.61</td>\n",
       "      <td>14861.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-08-18</th>\n",
       "      <td>603986</td>\n",
       "      <td>兆易创新</td>\n",
       "      <td>半导体</td>\n",
       "      <td>北京</td>\n",
       "      <td>85.62</td>\n",
       "      <td>1.47</td>\n",
       "      <td>2.03</td>\n",
       "      <td>213397.97</td>\n",
       "      <td>169092.52</td>\n",
       "      <td>9192.86</td>\n",
       "      <td>...</td>\n",
       "      <td>24.17</td>\n",
       "      <td>2016-08-18</td>\n",
       "      <td>73909.36</td>\n",
       "      <td>3.65</td>\n",
       "      <td>44.69</td>\n",
       "      <td>134.74</td>\n",
       "      <td>38.57</td>\n",
       "      <td>22.38</td>\n",
       "      <td>16098.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-12-01</th>\n",
       "      <td>002913</td>\n",
       "      <td>奥士康</td>\n",
       "      <td>半导体</td>\n",
       "      <td>湖南</td>\n",
       "      <td>41.27</td>\n",
       "      <td>0.36</td>\n",
       "      <td>1.44</td>\n",
       "      <td>190226.63</td>\n",
       "      <td>104183.22</td>\n",
       "      <td>81802.18</td>\n",
       "      <td>...</td>\n",
       "      <td>3.15</td>\n",
       "      <td>2017-12-01</td>\n",
       "      <td>36008.44</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>23.97</td>\n",
       "      <td>9.18</td>\n",
       "      <td>30331.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-07-12</th>\n",
       "      <td>300672</td>\n",
       "      <td>国科微</td>\n",
       "      <td>半导体</td>\n",
       "      <td>湖南</td>\n",
       "      <td>1273.88</td>\n",
       "      <td>0.28</td>\n",
       "      <td>1.12</td>\n",
       "      <td>96894.68</td>\n",
       "      <td>71145.50</td>\n",
       "      <td>7825.18</td>\n",
       "      <td>...</td>\n",
       "      <td>7.97</td>\n",
       "      <td>2017-07-12</td>\n",
       "      <td>10634.24</td>\n",
       "      <td>0.95</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>48.04</td>\n",
       "      <td>2.52</td>\n",
       "      <td>16331.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-10-16</th>\n",
       "      <td>300708</td>\n",
       "      <td>聚灿光电</td>\n",
       "      <td>半导体</td>\n",
       "      <td>江苏</td>\n",
       "      <td>67.73</td>\n",
       "      <td>0.64</td>\n",
       "      <td>2.57</td>\n",
       "      <td>147835.27</td>\n",
       "      <td>75164.55</td>\n",
       "      <td>46085.87</td>\n",
       "      <td>...</td>\n",
       "      <td>10.45</td>\n",
       "      <td>2017-10-16</td>\n",
       "      <td>18079.84</td>\n",
       "      <td>0.70</td>\n",
       "      <td>29.32</td>\n",
       "      <td>81.53</td>\n",
       "      <td>28.97</td>\n",
       "      <td>17.72</td>\n",
       "      <td>36514.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-20</th>\n",
       "      <td>300613</td>\n",
       "      <td>富瀚微</td>\n",
       "      <td>半导体</td>\n",
       "      <td>上海</td>\n",
       "      <td>68.97</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.45</td>\n",
       "      <td>97363.90</td>\n",
       "      <td>85505.56</td>\n",
       "      <td>1777.51</td>\n",
       "      <td>...</td>\n",
       "      <td>7.87</td>\n",
       "      <td>2017-02-20</td>\n",
       "      <td>26320.40</td>\n",
       "      <td>5.81</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>49.46</td>\n",
       "      <td>25.26</td>\n",
       "      <td>11264.0</td>\n",
       "      <td>2018-04-11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                code  name industry area       pe  outstanding  totals  \\\n",
       "timeToMarket                                                             \n",
       "2017-05-04    603501  韦尔股份      半导体   上海   137.28         0.42    4.56   \n",
       "2017-07-05    300671  富满电子      半导体   深圳    95.24         0.25    1.01   \n",
       "2017-03-17    300625  三雄极光      半导体   广东    29.17         0.91    2.80   \n",
       "2017-04-06    300632  光莆股份      半导体   福建    41.73         0.37    1.16   \n",
       "2016-10-12    002815  崇达技术      半导体   深圳    32.88         1.06    4.10   \n",
       "2016-12-28    300582   英飞特      半导体   浙江    83.81         1.21    2.03   \n",
       "2017-03-14    300623  捷捷微电      半导体   江苏    42.11         0.37    0.94   \n",
       "2016-08-18    603986  兆易创新      半导体   北京    85.62         1.47    2.03   \n",
       "2017-12-01    002913   奥士康      半导体   湖南    41.27         0.36    1.44   \n",
       "2017-07-12    300672   国科微      半导体   湖南  1273.88         0.28    1.12   \n",
       "2017-10-16    300708  聚灿光电      半导体   江苏    67.73         0.64    2.57   \n",
       "2017-02-20    300613   富瀚微      半导体   上海    68.97         0.13    0.45   \n",
       "\n",
       "              totalAssets  liquidAssets  fixedAssets     ...         pb  \\\n",
       "timeToMarket                                             ...              \n",
       "2017-05-04      204200.45     169034.19     17705.68     ...      14.75   \n",
       "2017-07-05       68242.43      51843.62     14202.12     ...       7.73   \n",
       "2017-03-17      271604.44     225907.66     23129.76     ...       2.96   \n",
       "2017-04-06       66851.96      43581.01     19568.85     ...       4.80   \n",
       "2016-10-12      494307.56     244897.22    177228.13     ...       5.78   \n",
       "2016-12-28      136238.97      45586.10     56919.20     ...       3.62   \n",
       "2017-03-14      133111.38      91724.80     25565.35     ...       5.18   \n",
       "2016-08-18      213397.97     169092.52      9192.86     ...      24.17   \n",
       "2017-12-01      190226.63     104183.22     81802.18     ...       3.15   \n",
       "2017-07-12       96894.68      71145.50      7825.18     ...       7.97   \n",
       "2017-10-16      147835.27      75164.55     46085.87     ...      10.45   \n",
       "2017-02-20       97363.90      85505.56      1777.51     ...       7.87   \n",
       "\n",
       "              timeToMarket       undp  perundp    rev  profit    gpr    npr  \\\n",
       "timeToMarket                                                                  \n",
       "2017-05-04      2017-05-04   47177.93     1.04   0.00    0.00  19.10   6.20   \n",
       "2017-07-05      2017-07-05   10927.21     1.08   0.00    0.00  27.95  11.63   \n",
       "2017-03-17      2017-03-17   60387.82     2.16   0.00    0.00  33.28  10.85   \n",
       "2017-04-06      2017-04-06   19050.15     1.65   0.00    0.00  30.13  12.38   \n",
       "2016-10-12      2016-10-12  114256.76     2.79  38.10   18.14  32.61  14.31   \n",
       "2016-12-28      2016-12-28   20920.55     1.03  18.08  -34.88  30.55   5.69   \n",
       "2017-03-14      2017-03-14   33622.19     3.59   0.00    0.00  56.49  35.61   \n",
       "2016-08-18      2016-08-18   73909.36     3.65  44.69  134.74  38.57  22.38   \n",
       "2017-12-01      2017-12-01   36008.44     2.50   0.00    0.00  23.97   9.18   \n",
       "2017-07-12      2017-07-12   10634.24     0.95   0.00    0.00  48.04   2.52   \n",
       "2017-10-16      2017-10-16   18079.84     0.70  29.32   81.53  28.97  17.72   \n",
       "2017-02-20      2017-02-20   26320.40     5.81   0.00    0.00  49.46  25.26   \n",
       "\n",
       "              holders        更新日期  \n",
       "timeToMarket                       \n",
       "2017-05-04    22079.0  2018-04-11  \n",
       "2017-07-05    10100.0  2018-04-11  \n",
       "2017-03-17    44932.0  2018-04-11  \n",
       "2017-04-06    11562.0  2018-04-11  \n",
       "2016-10-12    27600.0  2018-04-11  \n",
       "2016-12-28    17911.0  2018-04-11  \n",
       "2017-03-14    14861.0  2018-04-11  \n",
       "2016-08-18    16098.0  2018-04-11  \n",
       "2017-12-01    30331.0  2018-04-11  \n",
       "2017-07-12    16331.0  2018-04-11  \n",
       "2017-10-16    36514.0  2018-04-11  \n",
       "2017-02-20    11264.0  2018-04-11  \n",
       "\n",
       "[12 rows x 24 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfs[dfs['industry']==u'半导体']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = ts.get_day_all()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine =get_engine('db_rocky')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_sql('tb_temp',engine)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}