mysql_____.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas\n",
    "from futuquant import *\n",
    "from pypinyin import *\n",
    "\n",
    "pysqldf = lambda q: sqldf(q, globals())\n",
    "from redis import StrictRedis\n",
    "from sshtunnel import SSHTunnelForwarder\n",
    "from pandasql import sqldf\n",
    "from sqlalchemy import create_engine\n",
    "import pymysql\n",
    "import requests\n",
    "import json\n",
    "import pandas as pd\n",
    "import arrow\n",
    "\n",
    "server = SSHTunnelForwarder(\n",
    "        (\"47.100.229.250\", 22),\n",
    "        ssh_username=\"root\",\n",
    "        ssh_password=\"LOOP2themoon\",\n",
    "        remote_bind_address=(\"192.168.82.172\", 3306))\n",
    "server.start()\n",
    "engine = create_engine(f'mysql+pymysql://root:LOOP2themoon@127.0.0.1:{server.local_bind_port}/iquant_stock?charset=utf8')\n",
    "\n",
    "sql = f\"select * from t_stock \"\n",
    "df = pd.read_sql(sql, engine)\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "          id       code                                               name  \\\n",
      "0          1   HK.00001                                                 长和   \n",
      "1          2   HK.00002                                               中电控股   \n",
      "2          3   HK.00003                                             香港中华煤气   \n",
      "3          4   HK.00004                                              九龙仓集团   \n",
      "4          5   HK.00005                                               汇丰控股   \n",
      "5          6   HK.00006                                               电能实业   \n",
      "6          7   HK.00007                                             香港金融集团   \n",
      "7          8   HK.00008                                               电讯盈科   \n",
      "8          9   HK.00009                                               九号运通   \n",
      "9         10   HK.00010                                               恒隆集团   \n",
      "10        11   HK.00011                                               恒生银行   \n",
      "11        12   HK.00012                                               恒基地产   \n",
      "12        13   HK.00014                                               希慎兴业   \n",
      "13        14   HK.00015                                               盈信控股   \n",
      "14        15   HK.00016                                              新鸿基地产   \n",
      "15        16   HK.00017                                              新世界发展   \n",
      "16        17   HK.00018                                             东方报业集团   \n",
      "17        18   HK.00019                                            太古股份公司A   \n",
      "18        19   HK.00020                                                会德丰   \n",
      "19        20   HK.00021                                            大中华地产控股   \n",
      "20        21   HK.00022                                               茂盛控股   \n",
      "21        22   HK.00023                                               东亚银行   \n",
      "22        23   HK.00024                                               宝威控股   \n",
      "23        24   HK.00025                                               其士国际   \n",
      "24        25   HK.00026                                               中华汽车   \n",
      "25        26   HK.00027                                               银河娱乐   \n",
      "26        27   HK.00028                                                 天安   \n",
      "27        28   HK.00029                                               达力集团   \n",
      "28        29   HK.00030                                             万隆控股集团   \n",
      "29        30   HK.00031                                               航天控股   \n",
      "...      ...        ...                                                ...   \n",
      "19239  19274    JP.1758                             Taiyo Kisokogyo Co Ltd   \n",
      "19240  19275    JP.1795                                        Masaru Corp   \n",
      "19241  19276    JP.2831                                Hagoromo Foods Corp   \n",
      "19242  19277    JP.4673             Kawasaki Geological Engineering Co Ltd   \n",
      "19243  19278    JP.4760                                       Alpha Co Ltd   \n",
      "19244  19279    JP.5283                                  Takamisawa Co Ltd   \n",
      "19245  19280    JP.5939                                 Otani Kogyo Co Ltd   \n",
      "19246  19281    JP.6018                           Hanshin Diesel Works Ltd   \n",
      "19247  19282    JP.6647                                 Morio Denki Co Ltd   \n",
      "19248  19283    JP.7446                             Tohoku Chemical Co Ltd   \n",
      "19249  19284    JP.7464                                      Saftec Co Ltd   \n",
      "19250  19285    JP.7531                           Seiwa Chuo Holdings Corp   \n",
      "19251  19286    JP.7815                      Tokyo Board Industries Co Ltd   \n",
      "19252  19287    JP.7849                             Starts Publishing Corp   \n",
      "19253  19288    JP.7857                                        Seki Co Ltd   \n",
      "19254  19289    JP.8115                                     Moonbat Co Ltd   \n",
      "19255  19290    JP.9679                                       Horai Co Ltd   \n",
      "19256  19291    JP.9720                              Hotel Newgrand Co Ltd   \n",
      "19257  19292    JP.9776                    Sapporo Clinical Laboratory Inc   \n",
      "19258  19293    JP.9852                         CB Group Management Co Ltd   \n",
      "19259  19294    JP.9997                                     Belluna Co Ltd   \n",
      "19260  19295  SH.603956                                                威派格   \n",
      "19261  19296  SZ.399295                                               创业蓝筹   \n",
      "19262  19297  SZ.399296                                                创成长   \n",
      "19263  19298   US.CIM-D                     CHIMERA INVESTMENT CORPORATION   \n",
      "19264  19299   US.ENR-A                             ENERGIZER HOLDINGS INC   \n",
      "19265  19300    US.GOSS                                 GOSSAMER BIO, INC.   \n",
      "19266  19301    US.HEXO                                         HEXO Corp.   \n",
      "19267  19302    US.NRGX  PIMCO Energy & Tactical Credit Opportunities Fund   \n",
      "19268  19303    US.SEEL                            SEELOS THERAPEUTICS INC   \n",
      "\n",
      "                                              full_spell  \\\n",
      "0                                               zhang he   \n",
      "1                                     zhong dian kong gu   \n",
      "2                            xiang gang zhong hua mei qi   \n",
      "3                                  jiu long cang ji tuan   \n",
      "4                                       hui feng kong gu   \n",
      "5                                       dian neng shi ye   \n",
      "6                            xiang gang jin rong ji tuan   \n",
      "7                                       dian xun ying ke   \n",
      "8                                       jiu hao yun tong   \n",
      "9                                      heng long ji tuan   \n",
      "10                                   heng sheng yin hang   \n",
      "11                                       heng ji di chan   \n",
      "12                                       xi shen xing ye   \n",
      "13                                      ying xin kong gu   \n",
      "14                                   xin hong ji di chan   \n",
      "15                                   xin shi jie fa zhan   \n",
      "16                              dong fang bao ye ji tuan   \n",
      "17                               tai gu gu fen gong si A   \n",
      "18                                           hui de feng   \n",
      "19                          da zhong hua di chan kong gu   \n",
      "20                                     mao sheng kong gu   \n",
      "21                                      dong ya yin hang   \n",
      "22                                       bao wei kong gu   \n",
      "23                                         qi shi guo ji   \n",
      "24                                      zhong hua qi che   \n",
      "25                                          yin he yu le   \n",
      "26                                               tian an   \n",
      "27                                         da li ji tuan   \n",
      "28                              wan long kong gu ji tuan   \n",
      "29                                     hang tian kong gu   \n",
      "...                                                  ...   \n",
      "19239                             Taiyo Kisokogyo Co Ltd   \n",
      "19240                                        Masaru Corp   \n",
      "19241                                Hagoromo Foods Corp   \n",
      "19242             Kawasaki Geological Engineering Co Ltd   \n",
      "19243                                       Alpha Co Ltd   \n",
      "19244                                  Takamisawa Co Ltd   \n",
      "19245                                 Otani Kogyo Co Ltd   \n",
      "19246                           Hanshin Diesel Works Ltd   \n",
      "19247                                 Morio Denki Co Ltd   \n",
      "19248                             Tohoku Chemical Co Ltd   \n",
      "19249                                      Saftec Co Ltd   \n",
      "19250                           Seiwa Chuo Holdings Corp   \n",
      "19251                      Tokyo Board Industries Co Ltd   \n",
      "19252                             Starts Publishing Corp   \n",
      "19253                                        Seki Co Ltd   \n",
      "19254                                     Moonbat Co Ltd   \n",
      "19255                                       Horai Co Ltd   \n",
      "19256                              Hotel Newgrand Co Ltd   \n",
      "19257                    Sapporo Clinical Laboratory Inc   \n",
      "19258                         CB Group Management Co Ltd   \n",
      "19259                                     Belluna Co Ltd   \n",
      "19260                                         wei pai ge   \n",
      "19261                                 chuang ye lan chou   \n",
      "19262                                 chuang cheng zhang   \n",
      "19263                     CHIMERA INVESTMENT CORPORATION   \n",
      "19264                             ENERGIZER HOLDINGS INC   \n",
      "19265                                       Gossamer Bio   \n",
      "19266                             ENERGIZER HOLDINGS INC   \n",
      "19267  PIMCO Energy & Tactical Credit Opportunities Fund   \n",
      "19268                            SEELOS THERAPEUTICS INC   \n",
      "\n",
      "                                            simple_spell exchange category  \\\n",
      "0                                                     zh       HK       HK   \n",
      "1                                                   zdkg       HK       HK   \n",
      "2                                                 xgzhmq       HK       HK   \n",
      "3                                                  jlcjt       HK       HK   \n",
      "4                                                   hfkg       HK       HK   \n",
      "5                                                   dnsy       HK       HK   \n",
      "6                                                 xgjrjt       HK       HK   \n",
      "7                                                   dxyk       HK       HK   \n",
      "8                                                   jhyt       HK       HK   \n",
      "9                                                   hljt       HK       HK   \n",
      "10                                                  hsyh       HK       HK   \n",
      "11                                                  hjdc       HK       HK   \n",
      "12                                                  xsxy       HK       HK   \n",
      "13                                                  yxkg       HK       HK   \n",
      "14                                                 xhjdc       HK       HK   \n",
      "15                                                 xsjfz       HK       HK   \n",
      "16                                                dfbyjt       HK       HK   \n",
      "17                                               tggfgsA       HK       HK   \n",
      "18                                                   hdf       HK       HK   \n",
      "19                                               dzhdckg       HK       HK   \n",
      "20                                                  mskg       HK       HK   \n",
      "21                                                  dyyh       HK       HK   \n",
      "22                                                  bwkg       HK       HK   \n",
      "23                                                  qsgj       HK       HK   \n",
      "24                                                  zhqc       HK       HK   \n",
      "25                                                  yhyl       HK       HK   \n",
      "26                                                    ta       HK       HK   \n",
      "27                                                  dljt       HK       HK   \n",
      "28                                                wlkgjt       HK       HK   \n",
      "29                                                  htkg       HK       HK   \n",
      "...                                                  ...      ...      ...   \n",
      "19239                             Taiyo Kisokogyo Co Ltd       JP       JP   \n",
      "19240                                        Masaru Corp       JP       JP   \n",
      "19241                                Hagoromo Foods Corp       JP       JP   \n",
      "19242             Kawasaki Geological Engineering Co Ltd       JP       JP   \n",
      "19243                                       Alpha Co Ltd       JP       JP   \n",
      "19244                                  Takamisawa Co Ltd       JP       JP   \n",
      "19245                                 Otani Kogyo Co Ltd       JP       JP   \n",
      "19246                           Hanshin Diesel Works Ltd       JP       JP   \n",
      "19247                                 Morio Denki Co Ltd       JP       JP   \n",
      "19248                             Tohoku Chemical Co Ltd       JP       JP   \n",
      "19249                                      Saftec Co Ltd       JP       JP   \n",
      "19250                           Seiwa Chuo Holdings Corp       JP       JP   \n",
      "19251                      Tokyo Board Industries Co Ltd       JP       JP   \n",
      "19252                             Starts Publishing Corp       JP       JP   \n",
      "19253                                        Seki Co Ltd       JP       JP   \n",
      "19254                                     Moonbat Co Ltd       JP       JP   \n",
      "19255                                       Horai Co Ltd       JP       JP   \n",
      "19256                              Hotel Newgrand Co Ltd       JP       JP   \n",
      "19257                    Sapporo Clinical Laboratory Inc       JP       JP   \n",
      "19258                         CB Group Management Co Ltd       JP       JP   \n",
      "19259                                     Belluna Co Ltd       JP       JP   \n",
      "19260                                                wpg       SH       SZ   \n",
      "19261                                               cylc       SZ       SZ   \n",
      "19262                                                ccz       SZ       SZ   \n",
      "19263                     CHIMERA INVESTMENT CORPORATION       US       US   \n",
      "19264                             ENERGIZER HOLDINGS INC       US       US   \n",
      "19265                                       Gossamer Bio       US       US   \n",
      "19266                             ENERGIZER HOLDINGS INC       US       US   \n",
      "19267  PIMCO Energy & Tactical Credit Opportunities Fund       US       US   \n",
      "19268                            SEELOS THERAPEUTICS INC       US       US   \n",
      "\n",
      "              create_time         update_time     symbol  \n",
      "0     2019-01-17 18:14:17 2019-01-17 18:14:17    0001.HK  \n",
      "1     2019-01-17 18:14:17 2019-01-17 18:14:17    0002.HK  \n",
      "2     2019-01-17 18:14:17 2019-01-17 18:14:17    0003.HK  \n",
      "3     2019-01-17 18:14:17 2019-01-17 18:14:17    0004.HK  \n",
      "4     2019-01-17 18:14:17 2019-01-17 18:14:17    0005.HK  \n",
      "5     2019-01-17 18:14:17 2019-01-17 18:14:17    0006.HK  \n",
      "6     2019-01-17 18:14:17 2019-01-17 18:14:17    0007.HK  \n",
      "7     2019-01-17 18:14:17 2019-01-17 18:14:17    0008.HK  \n",
      "8     2019-01-17 18:14:17 2019-01-17 18:14:17    0009.HK  \n",
      "9     2019-01-17 18:14:17 2019-01-17 18:14:17    0010.HK  \n",
      "10    2019-01-17 18:14:17 2019-01-17 18:14:17    0011.HK  \n",
      "11    2019-01-17 18:14:17 2019-01-17 18:14:17    0012.HK  \n",
      "12    2019-01-17 18:14:17 2019-01-17 18:14:17    0014.HK  \n",
      "13    2019-01-17 18:14:17 2019-01-17 18:14:17    0015.HK  \n",
      "14    2019-01-17 18:14:17 2019-01-17 18:14:17    0016.HK  \n",
      "15    2019-01-17 18:14:17 2019-01-17 18:14:17    0017.HK  \n",
      "16    2019-01-17 18:14:17 2019-01-17 18:14:17    0018.HK  \n",
      "17    2019-01-17 18:14:17 2019-01-17 18:14:17    0019.HK  \n",
      "18    2019-01-17 18:14:17 2019-01-17 18:14:17    0020.HK  \n",
      "19    2019-01-17 18:14:17 2019-01-17 18:14:17    0021.HK  \n",
      "20    2019-01-17 18:14:17 2019-01-17 18:14:17    0022.HK  \n",
      "21    2019-01-17 18:14:17 2019-01-17 18:14:17    0023.HK  \n",
      "22    2019-01-17 18:14:17 2019-01-17 18:14:17    0024.HK  \n",
      "23    2019-01-17 18:14:17 2019-01-17 18:14:17    0025.HK  \n",
      "24    2019-01-17 18:14:17 2019-01-17 18:14:17    0026.HK  \n",
      "25    2019-01-17 18:14:17 2019-01-17 18:14:17    0027.HK  \n",
      "26    2019-01-17 18:14:17 2019-01-17 18:14:17    0028.HK  \n",
      "27    2019-01-17 18:14:17 2019-01-17 18:14:17    0029.HK  \n",
      "28    2019-01-17 18:14:17 2019-01-17 18:14:17    0030.HK  \n",
      "29    2019-01-17 18:14:17 2019-01-17 18:14:17    0031.HK  \n",
      "...                   ...                 ...        ...  \n",
      "19239 2019-01-29 08:00:00 2019-01-29 08:00:00     1758.T  \n",
      "19240 2019-01-29 08:00:00 2019-01-29 08:00:00     1795.T  \n",
      "19241 2019-01-29 08:00:00 2019-01-29 08:00:00     2831.T  \n",
      "19242 2019-01-29 08:00:00 2019-01-29 08:00:00     4673.T  \n",
      "19243 2019-01-29 08:00:00 2019-01-29 08:00:00     4760.T  \n",
      "19244 2019-01-29 08:00:00 2019-01-29 08:00:00     5283.T  \n",
      "19245 2019-01-29 08:00:00 2019-01-29 08:00:00     5939.T  \n",
      "19246 2019-01-29 08:00:00 2019-01-29 08:00:00     6018.T  \n",
      "19247 2019-01-29 08:00:00 2019-01-29 08:00:00     6647.T  \n",
      "19248 2019-01-29 08:00:00 2019-01-29 08:00:00     7446.T  \n",
      "19249 2019-01-29 08:00:00 2019-01-29 08:00:00     7464.T  \n",
      "19250 2019-01-29 08:00:00 2019-01-29 08:00:00     7531.T  \n",
      "19251 2019-01-29 08:00:00 2019-01-29 08:00:00     7815.T  \n",
      "19252 2019-01-29 08:00:00 2019-01-29 08:00:00     7849.T  \n",
      "19253 2019-01-29 08:00:00 2019-01-29 08:00:00     7857.T  \n",
      "19254 2019-01-29 08:00:00 2019-01-29 08:00:00     8115.T  \n",
      "19255 2019-01-29 08:00:00 2019-01-29 08:00:00     9679.T  \n",
      "19256 2019-01-29 08:00:00 2019-01-29 08:00:00     9720.T  \n",
      "19257 2019-01-29 08:00:00 2019-01-29 08:00:00     9776.T  \n",
      "19258 2019-01-29 08:00:00 2019-01-29 08:00:00     9852.T  \n",
      "19259 2019-01-29 08:00:00 2019-01-29 08:00:00     9997.T  \n",
      "19260 2019-01-29 08:00:00 2019-01-29 08:00:00       None  \n",
      "19261 2019-01-29 08:00:00 2019-01-29 08:00:00  399295.SZ  \n",
      "19262 2019-01-29 08:00:00 2019-01-29 08:00:00  399296.SZ  \n",
      "19263 2019-01-29 08:00:00 2019-01-29 08:00:00       None  \n",
      "19264 2019-01-29 08:00:00 2019-01-29 08:00:00       None  \n",
      "19265 2019-01-29 08:00:00 2019-01-29 08:00:00       GOSS  \n",
      "19266 2019-01-29 08:00:00 2019-01-29 08:00:00       HEXO  \n",
      "19267 2019-01-29 08:00:00 2019-01-29 08:00:00       NRGX  \n",
      "19268 2019-01-29 08:00:00 2019-01-29 08:00:00       SEEL  \n",
      "\n",
      "[19269 rows x 10 columns]\n"
     ]
    }
   ],
   "source": [
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['full_spell'] = df['full_spell'].apply(lambda full_spell : full_spell.replace(\" \",\"\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "          id       code                                               name  \\\n",
      "0          1   HK.00001                                                 长和   \n",
      "1          2   HK.00002                                               中电控股   \n",
      "2          3   HK.00003                                             香港中华煤气   \n",
      "3          4   HK.00004                                              九龙仓集团   \n",
      "4          5   HK.00005                                               汇丰控股   \n",
      "5          6   HK.00006                                               电能实业   \n",
      "6          7   HK.00007                                             香港金融集团   \n",
      "7          8   HK.00008                                               电讯盈科   \n",
      "8          9   HK.00009                                               九号运通   \n",
      "9         10   HK.00010                                               恒隆集团   \n",
      "10        11   HK.00011                                               恒生银行   \n",
      "11        12   HK.00012                                               恒基地产   \n",
      "12        13   HK.00014                                               希慎兴业   \n",
      "13        14   HK.00015                                               盈信控股   \n",
      "14        15   HK.00016                                              新鸿基地产   \n",
      "15        16   HK.00017                                              新世界发展   \n",
      "16        17   HK.00018                                             东方报业集团   \n",
      "17        18   HK.00019                                            太古股份公司A   \n",
      "18        19   HK.00020                                                会德丰   \n",
      "19        20   HK.00021                                            大中华地产控股   \n",
      "20        21   HK.00022                                               茂盛控股   \n",
      "21        22   HK.00023                                               东亚银行   \n",
      "22        23   HK.00024                                               宝威控股   \n",
      "23        24   HK.00025                                               其士国际   \n",
      "24        25   HK.00026                                               中华汽车   \n",
      "25        26   HK.00027                                               银河娱乐   \n",
      "26        27   HK.00028                                                 天安   \n",
      "27        28   HK.00029                                               达力集团   \n",
      "28        29   HK.00030                                             万隆控股集团   \n",
      "29        30   HK.00031                                               航天控股   \n",
      "...      ...        ...                                                ...   \n",
      "19239  19274    JP.1758                             Taiyo Kisokogyo Co Ltd   \n",
      "19240  19275    JP.1795                                        Masaru Corp   \n",
      "19241  19276    JP.2831                                Hagoromo Foods Corp   \n",
      "19242  19277    JP.4673             Kawasaki Geological Engineering Co Ltd   \n",
      "19243  19278    JP.4760                                       Alpha Co Ltd   \n",
      "19244  19279    JP.5283                                  Takamisawa Co Ltd   \n",
      "19245  19280    JP.5939                                 Otani Kogyo Co Ltd   \n",
      "19246  19281    JP.6018                           Hanshin Diesel Works Ltd   \n",
      "19247  19282    JP.6647                                 Morio Denki Co Ltd   \n",
      "19248  19283    JP.7446                             Tohoku Chemical Co Ltd   \n",
      "19249  19284    JP.7464                                      Saftec Co Ltd   \n",
      "19250  19285    JP.7531                           Seiwa Chuo Holdings Corp   \n",
      "19251  19286    JP.7815                      Tokyo Board Industries Co Ltd   \n",
      "19252  19287    JP.7849                             Starts Publishing Corp   \n",
      "19253  19288    JP.7857                                        Seki Co Ltd   \n",
      "19254  19289    JP.8115                                     Moonbat Co Ltd   \n",
      "19255  19290    JP.9679                                       Horai Co Ltd   \n",
      "19256  19291    JP.9720                              Hotel Newgrand Co Ltd   \n",
      "19257  19292    JP.9776                    Sapporo Clinical Laboratory Inc   \n",
      "19258  19293    JP.9852                         CB Group Management Co Ltd   \n",
      "19259  19294    JP.9997                                     Belluna Co Ltd   \n",
      "19260  19295  SH.603956                                                威派格   \n",
      "19261  19296  SZ.399295                                               创业蓝筹   \n",
      "19262  19297  SZ.399296                                                创成长   \n",
      "19263  19298   US.CIM-D                     CHIMERA INVESTMENT CORPORATION   \n",
      "19264  19299   US.ENR-A                             ENERGIZER HOLDINGS INC   \n",
      "19265  19300    US.GOSS                                 GOSSAMER BIO, INC.   \n",
      "19266  19301    US.HEXO                                         HEXO Corp.   \n",
      "19267  19302    US.NRGX  PIMCO Energy & Tactical Credit Opportunities Fund   \n",
      "19268  19303    US.SEEL                            SEELOS THERAPEUTICS INC   \n",
      "\n",
      "                                        full_spell  \\\n",
      "0                                          zhanghe   \n",
      "1                                  zhongdiankonggu   \n",
      "2                           xianggangzhonghuameiqi   \n",
      "3                                jiulongcangjituan   \n",
      "4                                    huifengkonggu   \n",
      "5                                    diannengshiye   \n",
      "6                           xianggangjinrongjituan   \n",
      "7                                    dianxunyingke   \n",
      "8                                    jiuhaoyuntong   \n",
      "9                                   henglongjituan   \n",
      "10                                hengshengyinhang   \n",
      "11                                    hengjidichan   \n",
      "12                                    xishenxingye   \n",
      "13                                   yingxinkonggu   \n",
      "14                                 xinhongjidichan   \n",
      "15                                 xinshijiefazhan   \n",
      "16                             dongfangbaoyejituan   \n",
      "17                               taigugufengongsiA   \n",
      "18                                       huidefeng   \n",
      "19                          dazhonghuadichankonggu   \n",
      "20                                  maoshengkonggu   \n",
      "21                                   dongyayinhang   \n",
      "22                                    baoweikonggu   \n",
      "23                                      qishiguoji   \n",
      "24                                   zhonghuaqiche   \n",
      "25                                       yinheyule   \n",
      "26                                          tianan   \n",
      "27                                      dalijituan   \n",
      "28                             wanlongkonggujituan   \n",
      "29                                  hangtiankonggu   \n",
      "...                                            ...   \n",
      "19239                          TaiyoKisokogyoCoLtd   \n",
      "19240                                   MasaruCorp   \n",
      "19241                            HagoromoFoodsCorp   \n",
      "19242           KawasakiGeologicalEngineeringCoLtd   \n",
      "19243                                   AlphaCoLtd   \n",
      "19244                              TakamisawaCoLtd   \n",
      "19245                              OtaniKogyoCoLtd   \n",
      "19246                        HanshinDieselWorksLtd   \n",
      "19247                              MorioDenkiCoLtd   \n",
      "19248                          TohokuChemicalCoLtd   \n",
      "19249                                  SaftecCoLtd   \n",
      "19250                        SeiwaChuoHoldingsCorp   \n",
      "19251                    TokyoBoardIndustriesCoLtd   \n",
      "19252                         StartsPublishingCorp   \n",
      "19253                                    SekiCoLtd   \n",
      "19254                                 MoonbatCoLtd   \n",
      "19255                                   HoraiCoLtd   \n",
      "19256                           HotelNewgrandCoLtd   \n",
      "19257                 SapporoClinicalLaboratoryInc   \n",
      "19258                       CBGroupManagementCoLtd   \n",
      "19259                                 BellunaCoLtd   \n",
      "19260                                     weipaige   \n",
      "19261                              chuangyelanchou   \n",
      "19262                             chuangchengzhang   \n",
      "19263                 CHIMERAINVESTMENTCORPORATION   \n",
      "19264                         ENERGIZERHOLDINGSINC   \n",
      "19265                                  GossamerBio   \n",
      "19266                         ENERGIZERHOLDINGSINC   \n",
      "19267  PIMCOEnergy&TacticalCreditOpportunitiesFund   \n",
      "19268                        SEELOSTHERAPEUTICSINC   \n",
      "\n",
      "                                            simple_spell exchange category  \\\n",
      "0                                                     zh       HK       HK   \n",
      "1                                                   zdkg       HK       HK   \n",
      "2                                                 xgzhmq       HK       HK   \n",
      "3                                                  jlcjt       HK       HK   \n",
      "4                                                   hfkg       HK       HK   \n",
      "5                                                   dnsy       HK       HK   \n",
      "6                                                 xgjrjt       HK       HK   \n",
      "7                                                   dxyk       HK       HK   \n",
      "8                                                   jhyt       HK       HK   \n",
      "9                                                   hljt       HK       HK   \n",
      "10                                                  hsyh       HK       HK   \n",
      "11                                                  hjdc       HK       HK   \n",
      "12                                                  xsxy       HK       HK   \n",
      "13                                                  yxkg       HK       HK   \n",
      "14                                                 xhjdc       HK       HK   \n",
      "15                                                 xsjfz       HK       HK   \n",
      "16                                                dfbyjt       HK       HK   \n",
      "17                                               tggfgsA       HK       HK   \n",
      "18                                                   hdf       HK       HK   \n",
      "19                                               dzhdckg       HK       HK   \n",
      "20                                                  mskg       HK       HK   \n",
      "21                                                  dyyh       HK       HK   \n",
      "22                                                  bwkg       HK       HK   \n",
      "23                                                  qsgj       HK       HK   \n",
      "24                                                  zhqc       HK       HK   \n",
      "25                                                  yhyl       HK       HK   \n",
      "26                                                    ta       HK       HK   \n",
      "27                                                  dljt       HK       HK   \n",
      "28                                                wlkgjt       HK       HK   \n",
      "29                                                  htkg       HK       HK   \n",
      "...                                                  ...      ...      ...   \n",
      "19239                             Taiyo Kisokogyo Co Ltd       JP       JP   \n",
      "19240                                        Masaru Corp       JP       JP   \n",
      "19241                                Hagoromo Foods Corp       JP       JP   \n",
      "19242             Kawasaki Geological Engineering Co Ltd       JP       JP   \n",
      "19243                                       Alpha Co Ltd       JP       JP   \n",
      "19244                                  Takamisawa Co Ltd       JP       JP   \n",
      "19245                                 Otani Kogyo Co Ltd       JP       JP   \n",
      "19246                           Hanshin Diesel Works Ltd       JP       JP   \n",
      "19247                                 Morio Denki Co Ltd       JP       JP   \n",
      "19248                             Tohoku Chemical Co Ltd       JP       JP   \n",
      "19249                                      Saftec Co Ltd       JP       JP   \n",
      "19250                           Seiwa Chuo Holdings Corp       JP       JP   \n",
      "19251                      Tokyo Board Industries Co Ltd       JP       JP   \n",
      "19252                             Starts Publishing Corp       JP       JP   \n",
      "19253                                        Seki Co Ltd       JP       JP   \n",
      "19254                                     Moonbat Co Ltd       JP       JP   \n",
      "19255                                       Horai Co Ltd       JP       JP   \n",
      "19256                              Hotel Newgrand Co Ltd       JP       JP   \n",
      "19257                    Sapporo Clinical Laboratory Inc       JP       JP   \n",
      "19258                         CB Group Management Co Ltd       JP       JP   \n",
      "19259                                     Belluna Co Ltd       JP       JP   \n",
      "19260                                                wpg       SH       SZ   \n",
      "19261                                               cylc       SZ       SZ   \n",
      "19262                                                ccz       SZ       SZ   \n",
      "19263                     CHIMERA INVESTMENT CORPORATION       US       US   \n",
      "19264                             ENERGIZER HOLDINGS INC       US       US   \n",
      "19265                                       Gossamer Bio       US       US   \n",
      "19266                             ENERGIZER HOLDINGS INC       US       US   \n",
      "19267  PIMCO Energy & Tactical Credit Opportunities Fund       US       US   \n",
      "19268                            SEELOS THERAPEUTICS INC       US       US   \n",
      "\n",
      "              create_time         update_time     symbol  \n",
      "0     2019-01-17 18:14:17 2019-01-17 18:14:17    0001.HK  \n",
      "1     2019-01-17 18:14:17 2019-01-17 18:14:17    0002.HK  \n",
      "2     2019-01-17 18:14:17 2019-01-17 18:14:17    0003.HK  \n",
      "3     2019-01-17 18:14:17 2019-01-17 18:14:17    0004.HK  \n",
      "4     2019-01-17 18:14:17 2019-01-17 18:14:17    0005.HK  \n",
      "5     2019-01-17 18:14:17 2019-01-17 18:14:17    0006.HK  \n",
      "6     2019-01-17 18:14:17 2019-01-17 18:14:17    0007.HK  \n",
      "7     2019-01-17 18:14:17 2019-01-17 18:14:17    0008.HK  \n",
      "8     2019-01-17 18:14:17 2019-01-17 18:14:17    0009.HK  \n",
      "9     2019-01-17 18:14:17 2019-01-17 18:14:17    0010.HK  \n",
      "10    2019-01-17 18:14:17 2019-01-17 18:14:17    0011.HK  \n",
      "11    2019-01-17 18:14:17 2019-01-17 18:14:17    0012.HK  \n",
      "12    2019-01-17 18:14:17 2019-01-17 18:14:17    0014.HK  \n",
      "13    2019-01-17 18:14:17 2019-01-17 18:14:17    0015.HK  \n",
      "14    2019-01-17 18:14:17 2019-01-17 18:14:17    0016.HK  \n",
      "15    2019-01-17 18:14:17 2019-01-17 18:14:17    0017.HK  \n",
      "16    2019-01-17 18:14:17 2019-01-17 18:14:17    0018.HK  \n",
      "17    2019-01-17 18:14:17 2019-01-17 18:14:17    0019.HK  \n",
      "18    2019-01-17 18:14:17 2019-01-17 18:14:17    0020.HK  \n",
      "19    2019-01-17 18:14:17 2019-01-17 18:14:17    0021.HK  \n",
      "20    2019-01-17 18:14:17 2019-01-17 18:14:17    0022.HK  \n",
      "21    2019-01-17 18:14:17 2019-01-17 18:14:17    0023.HK  \n",
      "22    2019-01-17 18:14:17 2019-01-17 18:14:17    0024.HK  \n",
      "23    2019-01-17 18:14:17 2019-01-17 18:14:17    0025.HK  \n",
      "24    2019-01-17 18:14:17 2019-01-17 18:14:17    0026.HK  \n",
      "25    2019-01-17 18:14:17 2019-01-17 18:14:17    0027.HK  \n",
      "26    2019-01-17 18:14:17 2019-01-17 18:14:17    0028.HK  \n",
      "27    2019-01-17 18:14:17 2019-01-17 18:14:17    0029.HK  \n",
      "28    2019-01-17 18:14:17 2019-01-17 18:14:17    0030.HK  \n",
      "29    2019-01-17 18:14:17 2019-01-17 18:14:17    0031.HK  \n",
      "...                   ...                 ...        ...  \n",
      "19239 2019-01-29 08:00:00 2019-01-29 08:00:00     1758.T  \n",
      "19240 2019-01-29 08:00:00 2019-01-29 08:00:00     1795.T  \n",
      "19241 2019-01-29 08:00:00 2019-01-29 08:00:00     2831.T  \n",
      "19242 2019-01-29 08:00:00 2019-01-29 08:00:00     4673.T  \n",
      "19243 2019-01-29 08:00:00 2019-01-29 08:00:00     4760.T  \n",
      "19244 2019-01-29 08:00:00 2019-01-29 08:00:00     5283.T  \n",
      "19245 2019-01-29 08:00:00 2019-01-29 08:00:00     5939.T  \n",
      "19246 2019-01-29 08:00:00 2019-01-29 08:00:00     6018.T  \n",
      "19247 2019-01-29 08:00:00 2019-01-29 08:00:00     6647.T  \n",
      "19248 2019-01-29 08:00:00 2019-01-29 08:00:00     7446.T  \n",
      "19249 2019-01-29 08:00:00 2019-01-29 08:00:00     7464.T  \n",
      "19250 2019-01-29 08:00:00 2019-01-29 08:00:00     7531.T  \n",
      "19251 2019-01-29 08:00:00 2019-01-29 08:00:00     7815.T  \n",
      "19252 2019-01-29 08:00:00 2019-01-29 08:00:00     7849.T  \n",
      "19253 2019-01-29 08:00:00 2019-01-29 08:00:00     7857.T  \n",
      "19254 2019-01-29 08:00:00 2019-01-29 08:00:00     8115.T  \n",
      "19255 2019-01-29 08:00:00 2019-01-29 08:00:00     9679.T  \n",
      "19256 2019-01-29 08:00:00 2019-01-29 08:00:00     9720.T  \n",
      "19257 2019-01-29 08:00:00 2019-01-29 08:00:00     9776.T  \n",
      "19258 2019-01-29 08:00:00 2019-01-29 08:00:00     9852.T  \n",
      "19259 2019-01-29 08:00:00 2019-01-29 08:00:00     9997.T  \n",
      "19260 2019-01-29 08:00:00 2019-01-29 08:00:00       None  \n",
      "19261 2019-01-29 08:00:00 2019-01-29 08:00:00  399295.SZ  \n",
      "19262 2019-01-29 08:00:00 2019-01-29 08:00:00  399296.SZ  \n",
      "19263 2019-01-29 08:00:00 2019-01-29 08:00:00       None  \n",
      "19264 2019-01-29 08:00:00 2019-01-29 08:00:00       None  \n",
      "19265 2019-01-29 08:00:00 2019-01-29 08:00:00       GOSS  \n",
      "19266 2019-01-29 08:00:00 2019-01-29 08:00:00       HEXO  \n",
      "19267 2019-01-29 08:00:00 2019-01-29 08:00:00       NRGX  \n",
      "19268 2019-01-29 08:00:00 2019-01-29 08:00:00       SEEL  \n",
      "\n",
      "[19269 rows x 10 columns]\n"
     ]
    }
   ],
   "source": [
    "print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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
}