4,617 rows

View and edit SQL

Suggested facets: mineffdate (date)

princeref ▼ princename princenamechin mineffdate
AAA022 K. L. Securities Company 淦聯證券投資公司 2003-04-01 00:00:00
AAA113 Capital For Business Limited   2003-04-01 00:00:00
AAA118 New Gala Securities Company 新基立證券公司 2003-04-01 00:00:00
AAA121 JPMorgan Asset Management (Asia Pacific) Limited   2003-04-01 00:00:00
AAA135 JPMorgan Funds (Asia) Limited 摩根基金(亞洲)有限公司 2003-04-01 00:00:00
AAA137 Citigroup Global Markets Asia Limited 花旗環球金融亞洲有限公司 2003-04-01 00:00:00
AAA347 First Securities (HK) Limited 第一證券(香港)有限公司 2003-04-01 00:00:00
AAA348 Ko Kun Stock Company 高勤證券公司 2003-04-01 00:00:00
AAA419 Ko's Brother (Securities) Company 高氏兄弟(股票)公司 2003-04-01 00:00:00
AAA451 Hamon Investment Management Limited   2003-04-01 00:00:00
AAA460 Tung Shun & Company 同信公司 2003-04-01 00:00:00
AAA502 Promising Securities Company 昌盛證券公司 2003-04-01 00:00:00
AAA523 Hongkong and Shanghai Banking Corporation Limited, The 香港上海滙豐銀行有限公司 2006-08-17 00:00:00
AAA529 HSBC Broking Securities (Hong Kong) Limited 滙豐金融證券(香港)有限公司 2003-04-01 00:00:00
AAA530 HSBC Broking Futures (Hong Kong) Limited 滙豐金融期貨(香港)有限公司 2003-04-01 00:00:00
AAA537 Rifa Securities Limited 日發證券有限公司 2003-04-01 00:00:00
AAA567 Barclays Capital Securities Asia Limited 巴克萊證券亞洲有限公司 2003-04-01 00:00:00
AAA582 Fubon Bank (Hong Kong) Limited 富邦銀行(香港)有限公司 2010-05-13 00:00:00
AAA621 Chong Hing Bank Limited 創興銀行有限公司 2006-10-25 00:00:00
AAA635 FB Securities (Hong Kong) Limited 富銀證券(香港)有限公司 2003-04-01 00:00:00
AAA645 Ho Fung Shares Investment Company 浩豐證券投資公司 2003-04-01 00:00:00
AAA662 Fubon Fund Management (Hong Kong) Limited 富邦基金管理(香港)有限公司 2003-04-01 00:00:00
AAA721 Lamtex Securities Limited 林達證券有限公司 2003-04-01 00:00:00
AAA778 Westpac Banking Corporation   2016-11-21 00:00:00
AAA806 Chong Hing Securities Limited 創興證券有限公司 2003-04-01 00:00:00
AAA808 I & P Securities Limited 慶昌證券有限公司 2003-04-01 00:00:00
AAA847 Get Nice Securities Limited 結好證券有限公司 2003-04-01 00:00:00
AAA849 Goldman Sachs (Asia) Securities Limited 高盛(亞洲)證券有限公司 2003-04-01 00:00:00
AAA854 Great Honest Investment Company Limited 浩誠證券有限公司 2003-04-01 00:00:00
AAA865 Canadian Imperial Bank of Commerce   2010-12-20 00:00:00
AAA867 King Wai Company 景蕙證券公司 2003-04-01 00:00:00
AAA874 South China Securities Limited 南華證券投資有限公司 2003-04-01 00:00:00
AAA889 MUFG Securities Asia Limited 三菱日聯證券亞洲有限公司 2010-12-31 00:00:00
AAA994 Seekers Markets Limited 中南金融有限公司 2003-04-01 00:00:00
AAB026 J.P. Morgan Securities (Far East) Limited   2003-04-01 00:00:00
AAB027 J.P. Morgan Broking (Hong Kong) Limited   2003-04-01 00:00:00
AAB082 Ichiyoshi International (HK) Limited 一吉國際(香港)有限公司 2003-04-01 00:00:00
AAB109 Chung Tak & Company 眾德股票公司 2003-04-01 00:00:00
AAB143 Welform Investors Company 惠成投資公司 2003-04-01 00:00:00
AAB171 Kwok Chung Chun Securities Company   2003-04-01 00:00:00
AAB204 To Hoi Hung Company 杜海雄公司 2003-04-01 00:00:00
AAB217 Daiwa SB Investments (HK) Limited 大和住銀投信投資顧問(香港)有限公司 2003-04-01 00:00:00
AAB241 HSBC Securities (Asia) Limited   2003-04-01 00:00:00
AAB254 Intercontinent Securities Company 通陸證券公司 2003-04-01 00:00:00
AAB291 Malahon Securities Limited 萬利豐證券有限公司 2003-04-01 00:00:00
AAB353 Chow Sang Sang Securities Limited 周生生證券有限公司 2003-04-01 00:00:00
AAB361 Daiwa Asset Management (H.K.) Limited 大和投資管理(香港)有限公司 2003-04-01 00:00:00
AAB375 Credit Agricole Indosuez Cheuvreux Securities (Hong Kong) Limited 東方匯理盛富香港證券有限公司 2003-04-01 00:00:00
AAB444 Amundi Hong Kong Limited 東方匯理資產管理香港有限公司 2003-04-01 00:00:00
AAB453 Ching Yick Company 精益證券公司 2003-04-01 00:00:00
AAB463 Winning & Company 詠明公司 2003-04-01 00:00:00
AAB499 Yunfeng Financial Markets Limited 雲鋒金融市場有限公司 2003-04-01 00:00:00
AAB514 SG Asset Finance (Hong Kong) Limited   2003-04-01 00:00:00
AAB528 Ka Yue Investment Company 嘉裕投資公司 2003-04-01 00:00:00
AAB629 Tokai Tokyo Securities (Asia) Limited 東海東京證券(亞洲)有限公司 2003-04-01 00:00:00
AAB639 Daiwa Capital Markets Hong Kong Limited 大和資本市場香港有限公司 2003-04-01 00:00:00
AAB709 Winfull Securities Limited 永富證券有限公司 2003-04-01 00:00:00
AAB807 Goodcape Investment Company 佳堅投資公司 2003-04-01 00:00:00
AAB856 Hong Kong International Securities Limited 香港國際證券有限公司 2003-04-01 00:00:00
AAB864 Principal Global Investors (Hong Kong) Limited 信安環球投資(香港)有限公司 2003-04-01 00:00:00
AAB885 Wing Fat Securities Limited 永發證券有限公司 2003-04-01 00:00:00
AAB893 CLSA Limited 中信里昂證券有限公司 2003-04-01 00:00:00
AAB947 Credit Agricole Securities (Asia) Limited 東方匯理證券(亞洲)有限公司 2003-04-01 00:00:00
AAB979 On Hing Securities Company   2003-04-01 00:00:00
AAC083 OCBC Wing Hang Bank Limited 華僑永亨銀行有限公司 2005-05-27 00:00:00
AAC086 Mason Securities Limited 茂宸證券有限公司 2003-04-01 00:00:00
AAC106 OCBC Wing Hang Shares Brokerage Co. Limited 華僑永亨証券有限公司 2003-04-01 00:00:00
AAC153 Sun Hung Kai Investment Services Limited 新鴻基投資服務有限公司 2003-04-01 00:00:00
AAC155 China Construction Bank (Asia) Corporation Limited 中國建設銀行(亞洲)股份有限公司 2005-03-07 00:00:00
AAC198 Merrill Lynch (Asia Pacific) Limited   2003-04-01 00:00:00
AAC207 DBS Vickers Securities (Hong Kong) Limited DBS唯高達証券有限公司 2003-04-01 00:00:00
AAC212 DBS Bank Ltd.   2007-05-15 00:00:00
AAC230 Wocom Securities Limited 宏高證券有限公司 2003-04-01 00:00:00
AAC246 Chelac Investment Company 致力證券公司 2003-04-01 00:00:00
AAC257 Barclays Capital Asia Limited 巴克萊亞洲有限公司 2003-04-01 00:00:00
AAC298 BOCI Securities Limited 中銀國際證券有限公司 2003-04-01 00:00:00
AAC350 Katherine Ip & Company 葉阮瓊惠公司 2003-04-01 00:00:00
AAC352 Merrill Lynch Far East Limited   2003-04-01 00:00:00
AAC381 FE Securities Limited 廣利證券有限公司 2003-04-01 00:00:00
AAC483 SHK Online (Securities) Limited 新鴻基科網(証券)有限公司 2003-04-01 00:00:00
AAC523 Macquarie Asia Securities Limited   2005-07-26 00:00:00
AAC529 Bright Securities Company, The 萬光行證券公司 2003-04-01 00:00:00
AAC534 Macquarie Capital Limited 麥格理資本股份有限公司 2003-04-01 00:00:00
AAC556 Montgomery Securities Limited 萬金來證券有限公司 2003-04-01 00:00:00
AAC577 China Tonghai Securities Limited 中國通海證券有限公司 2003-04-01 00:00:00
AAC621 VMS Securities Limited 鼎珮證券有限公司 2003-04-01 00:00:00
AAC648 Sanfull Securities Limited 新富證券有限公司 2003-04-01 00:00:00
AAC662 China Tonghai Asset Management Limited 中國通海資產管理有限公司 2003-04-01 00:00:00
AAC682 China Point Stock Brokers Limited 中方證券有限公司 2003-04-01 00:00:00
AAC710 Szehope & Company 世灝證券公司 2003-04-01 00:00:00
AAC753 JS Cresvale Capital Limited 日盛嘉富資本有限公司 2003-04-01 00:00:00
AAC801 LGT Investment Management (Asia) Limited   2003-04-01 00:00:00
AAC806 Corporate Brokers Limited 協聯證券有限公司 2003-04-01 00:00:00
AAC807 ABN AMRO Financial Products Limited   2003-04-01 00:00:00
AAC846 Pasay Stock and Shares Limited 巴西證券有限公司 2003-04-01 00:00:00
AAC867 Tai Yip Stock Company Limited 大業證券有限公司 2003-04-01 00:00:00
AAC906 Sunrise Investment Company 齊榮投資公司 2003-04-01 00:00:00
AAC913 Bradbury Securities Limited 源盛證券有限公司 2003-04-01 00:00:00
AAC927 Shenwan Hongyuan Securities (H.K.) Limited 申萬宏源證券(香港)有限公司 2003-04-01 00:00:00
AAC939 ICEA Securities Asia Limited 工商東亞證券亞洲有限公司 2003-04-01 00:00:00

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [hksfclicenceinstitutions] (
   [princeref] TEXT PRIMARY KEY,
   [princename] TEXT,
   [princenamechin] TEXT
, [mineffdate] TEXT);