In [1]:

    

import pyhkconnect as hkc
dp = hkc.northbound_shareholding_sh() # dataframe from pandas
dp


    

    
Out[1]:







  

    

      

      
code
      
name
      
shareholding
      
shareholding_percent
    
  
  

    

      
0
      
90000
      
SHANGHAI PUDONG DEVELOPMENT BANK CO., LTD. (A ...
      
432,600,632
      
1.53%
    
    

      
1
      
90004
      
GUANGZHOU BAIYUN INTERNATIONAL AIRPORT CO.,LTD...
      
190,058,444
      
9.18%
    
    

      
2
      
90006
      
DONGFENG AUTOMOBILE CO.,LTD (A #600006)
      
1,360,220
      
0.06%
    
    

      
3
      
90007
      
CHINA WORLD TRADE CENTER COMPANY LTD. (A #600007)
      
15,656,599
      
1.55%
    
    

      
4
      
90008
      
BEIJING CAPITAL CO.,LTD (A #600008)
      
84,561,617
      
1.75%
    
    

      
5
      
90009
      
SHANGHAI INTERNATIONAL AIRPORT CO., LTD. (A #6...
      
325,095,003
      
29.73%
    
    

      
6
      
90010
      
INNER MONGOLIA BAOTOU STEEL UNION CO.,LTD. (A ...
      
258,585,949
      
0.81%
    
    

      
7
      
90011
      
HUANENG POWER INTERNATIONAL, INC. (A #600011)
      
51,752,802
      
0.49%
    
    

      
8
      
90012
      
ANHUI EXPRESSWAY COMPANY LIMITED (A #600012)
      
7,759,992
      
0.66%
    
    

      
9
      
90015
      
HUA XIA BANK CO., LIMITED (A #600015)
      
99,421,652
      
0.77%
    
    

      
10
      
90016
      
CHINA MINSHENG BANKING CORP., LTD. (A #600016)
      
615,082,700
      
1.73%
    
    

      
11
      
90017
      
RIZHAO PORT CO.,LTD. (A #600017)
      
35,056,723
      
1.13%
    
    

      
12
      
90018
      
SHANGHAI INTERNATIONAL PORT (GROUP) CO., LTD (...
      
136,608,197
      
0.58%
    
    

      
13
      
90019
      
BAOSHAN IRON & STEEL CO., LTD. (A #600019)
      
621,006,479
      
2.80%
    
    

      
14
      
90020
      
HENAN ZHONGYUAN EXPRESSWAY COMPANY LIMITED (A ...
      
11,923,710
      
0.53%
    
    

      
15
      
90021
      
SHANGHAI ELECTRIC POWER COMPANY LIMITED (A #60...
      
2,448,007
      
0.11%
    
    

      
16
      
90023
      
ZHEJIANG ZHENENG ELECTRIC POWER CO.,LTD (A #60...
      
73,999,298
      
0.54%
    
    

      
17
      
90025
      
HUANENG LANCANG RIVER HYDROPOWER INC. (A #600025)
      
50,845,216
      
0.56%
    
    

      
18
      
90026
      
COSCO SHIPPING ENERGY TRANSPORTATION CO., LTD....
      
24,735,976
      
0.90%
    
    

      
19
      
90027
      
HUADIAN POWER INTERNATIONAL CORPORATION LIMITE...
      
45,455,206
      
0.64%
    
    

      
20
      
90028
      
CHINA PETROLEUM AND CHEMICAL CORPORATION (A #6...
      
1,126,106,126
      
1.17%
    
    

      
21
      
90029
      
CHINA SOUTHERN AIRLINES COMPANY LIMITED (A #60...
      
509,780,142
      
7.25%
    
    

      
22
      
90030
      
CITIC SECURITIES COMPANY LIMITED (A #600030)
      
226,014,310
      
2.30%
    
    

      
23
      
90031
      
SANY HEAVY INDUSTRY CO.,LTD (A #600031)
      
631,609,837
      
8.13%
    
    

      
24
      
90033
      
FUJIAN EXPRESSWAY DEVELOPMENT COMPANY LIMITED ...
      
5,657,595
      
0.20%
    
    

      
25
      
90036
      
CHINA MERCHANTS BANK CO.,LIMITED (A #600036)
      
796,697,513
      
3.86%
    
    

      
26
      
90037
      
BEIJING GEHUA CATV NETWORK CO., LTD. (A #600037)
      
1,070,328
      
0.07%
    
    

      
27
      
90038
      
AVICOPTER PLC (A #600038)
      
8,611,851
      
1.46%
    
    

      
28
      
90039
      
SICHUAN ROAD & BRIDGE CO.,LTD (A #600039)
      
18,528,022
      
0.53%
    
    

      
29
      
90048
      
POLY DEVELOPMENTS AND HOLDINGS GROUP CO., LTD....
      
270,089,004
      
2.29%
    
    

      
...
      
...
      
...
      
...
      
...
    
    

      
816
      
93801
      
ZBOM HOME COLLECTION CO.,LTD (A #603801)
      
59,019
      
0.07%
    
    

      
817
      
93803
      
RAISECOM TECHNOLOGY CO.,LTD. (A #603803)
      
1,091,594
      
0.49%
    
    

      
818
      
93806
      
HANGZHOU FIRST PV MATERIAL CO., LTD. (A #603806)
      
976,547
      
0.18%
    
    

      
819
      
93816
      
JASON FURNITURE (HANGZHOU) CO.,LTD. (A #603816)
      
21,093,508
      
23.67%
    
    

      
820
      
93818
      
QUMEI HOME FURNISHINGS GROUP CO., LTD (A #603818)
      
593,211
      
0.12%
    
    

      
821
      
93833
      
OPPEIN HOME GROUP INC. (A #603833)
      
6,579,922
      
7.14%
    
    

      
822
      
93848
      
GUANGDONG HOTATA TECHNOLOGY GROUP CO., LTD. (A...
      
41,058
      
0.05%
    
    

      
823
      
93858
      
SHANDONG BUCHANG PHARMACEUTICALS CO., LTD (A #...
      
6,853,254
      
1.60%
    
    

      
824
      
93861
      
GUANGZHOU BAIYUN ELECTRIC EQUIPMENT CO.,LTD. (...
      
950,413
      
0.78%
    
    

      
825
      
93866
      
TOLY BREAD CO., LTD. (A #603866)
      
6,545,575
      
1.39%
    
    

      
826
      
93868
      
SHANGHAI FLYCO ELECTRICAL APPLIANCE CO., LTD (...
      
1,668,124
      
3.82%
    
    

      
827
      
93871
      
JIA YOU INTERNATIONAL LOGISTICS CO., LTD (A #6...
      
422,801
      
1.51%
    
    

      
828
      
93877
      
NINGBO PEACEBIRD FASHION CO., LTD. (A #603877)
      
1,778,268
      
0.88%
    
    

      
829
      
93881
      
SHANGHAI ATHUB CO.,LTD. (A #603881)
      
463,308
      
0.36%
    
    

      
830
      
93882
      
GUANGZHOU KINGMED DIAGNOSTICS GROUP CO., LTD. ...
      
538,058
      
0.19%
    
    

      
831
      
93883
      
LBX PHARMACY CHAIN JOINT STOCK COMPANY (A #603...
      
2,836,917
      
1.06%
    
    

      
832
      
93885
      
JUNEYAO AIRLINES CO., LTD (A #603885)
      
5,670,094
      
0.31%
    
    

      
833
      
93888
      
XINHUANETCO.,LTD. (A #603888)
      
2,673,854
      
1.51%
    
    

      
834
      
93895
      
SHANGHAI TIANYONG ENGINEERING CO.,LTD (A #603895)
      
102,000
      
0.31%
    
    

      
835
      
93897
      
ZHEJIANG GRANDWALL ELECTRIC SCIENCE&TECHNOLOGY...
      
112,124
      
0.25%
    
    

      
836
      
93898
      
GUANGZHOU HOLIKE CREATIVE HOME CO.,LTD. (A #60...
      
1,660,102
      
0.53%
    
    

      
837
      
93899
      
SHANGHAI M&G STATIONERY INC. (A #603899)
      
6,812,750
      
0.74%
    
    

      
838
      
93929
      
L&K ENGINEERING(SUZHOU)CO.,LTD. (A #603929)
      
308,624
      
0.31%
    
    

      
839
      
93939
      
YIFENG PHARMACY CHAIN CO., LTD. (A #603939)
      
24,218,944
      
6.67%
    
    

      
840
      
93959
      
HUNAN BAILI ENGINEERING SCI & TECH CO.,LTD. (A...
      
235,562
      
0.15%
    
    

      
841
      
93979
      
JCHX MINING MANAGEMENT CO.,LTD. (A #603979)
      
191,590
      
0.03%
    
    

      
842
      
93986
      
GIGADEVICE SEMICONDUCTOR(BEIJING) INC (A #603986)
      
1,830,810
      
0.88%
    
    

      
843
      
93989
      
HUNAN AIHUA GROUP C0.,LTD. (A #603989)
      
6,852,552
      
1.75%
    
    

      
844
      
93993
      
CHINA MOLYBDENUM CO., LTD. (A #603993)
      
140,386,349
      
0.79%
    
    

      
845
      
93997
      
NINGBO JIFENG AUTO PARTS CO.,LTD (A #603997)
      
2,327,341
      
0.36%
    
  

846 rows × 4 columns

In [ ]: