INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (70613, 1, '84243420', 49616, 2, 64936, 'P', 0, 1, NULL, 'US8424342017', NULL, '236746', '84243420', 'SOCGM.PK^H26', 'SOCGM.PK', 'OTC', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (70614, 1, '84243430', 49616, 3, 64432, 'C', 0, 1, 'OSR', 'US8424343007', NULL, '282964', '84243430', 'SOCGP.PK^H26', 'SOCGP.PK', 'OTC', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (91514, 1, 'MTHP.V', 58388, 2, 164442, 'C', 1, 1, 'OSR', 'CA0907021012', 'BMND', 'BMHJZY', '09070210', 'BMND.CD', 'BMND.CD', 'CNQ', 'CAN', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (3322264, 10, '@AZULS1', 112451, 1, 141250, 'C', 1, 1, 'OSR', 'BRAZULA02PR3', 'AZUL54', 'BV7DQD', 'P0R0AQ27', 'AZUL54.SA^A26', 'AZUL54.SA', 'SAO', 'BRA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (6638314, 10, '@APRTE1', 145505, 1, 186271, 'C', 1, 1, 'OSR', 'SE0027099060', 'APRTEC', 'BVPLPY', 'W1R51210', 'APRTEC.TE', 'APRTEC.TE', 'AKT', 'SWE', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (6967424, 10, '@RETEC3', 145501, 1, 186266, 'C', 1, 1, 'OSR', 'TW0007934002', '7934', 'BXFHZ3', 'Y7107T10', '7934.TWO', '7934.TWO', 'TPO', 'TWN', NULL, 'EQU', NULL, NULL, ''); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (7092695, 10, '@LUOYA18', 143607, 1, 183374, 'C', 1, 1, 'OSR', NULL, '301699', 'BVSRPQ', NULL, '301699.SZ', '301699.SZ', 'SHE', 'CHN', NULL, 'EQU', NULL, NULL, 'IND'); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11074374, 1, '14067E60', 119098, 6, 168338, 'P', 1, 1, NULL, 'US35243J2006', 'FBRT PRE', 'BNKDZ4', '35243J20', 'FBRT_pe.K', 'FBRT_pe.N', 'NYSE', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11131358, 1, 'M4723810', 96729, 1, 121970, 'C', 1, 1, 'OSR', 'IL0011313900', 'EOCN', 'BKMDKS', 'M4723820', 'EOCN.O', 'EOCN.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11168246, 1, 'CEPPZ', 51550, 10, 184939, 'P', 1, 6, NULL, 'US29273V7047', 'ET PRI', 'BMHLS3', '29273V70', 'ET_pi', 'ET_pi.N', 'NYSE', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11216072, 1, 'SPNV', 125178, 1, 158343, 'C', 1, 1, 'OSR', 'US67623L5057', 'OPAD', 'BXCGJ3', '67623L50', 'OPAD.O', 'OPAD.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11219296, 1, '81786A10', 126023, 1, 159564, 'C', 1, 1, 'OSR', 'US06682J6055', 'PARA', 'BT9QV8', '06682J60', 'PARA.O', 'PARA.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11247303, 1, '37962G10', 133835, 1, 170098, 'C', 1, 1, 'OSR', 'KYG531511338', 'NXAT', 'BNYG4S', 'G5315113', 'NXAT.O', 'NXAT.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11249583, 1, '65290E10', 135746, 1, 172548, 'C', 1, 1, 'OSR', 'US65290E1010', 'NXT', 'BR1GTS', '65290E10', 'NXT.O', 'NXT.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11260763, 1, 'GSTK', 138768, 1, 176713, 'C', 1, 1, 'OSR', 'US4000741003', 'CYPA', 'BRT4LR', '40007410', 'CYPA.PK', 'CYPA.PK', 'OTC', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11265201, 1, 'G7385S10', 138135, 1, 175790, 'C', 1, 1, 'OSR', 'VGG7385S1193', 'ATTT', 'BP9M53', 'G7385S11', 'ATTT.O', 'ATTT.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11298807, 1, 'G6951A10', 144703, 1, 185033, 'C', 1, 1, 'OSR', 'KYG6951A1067', 'PTAC', 'BVMYDG', 'G6951A10', 'PTAC.O', 'PTAC.OQ', 'NASD', 'USA', NULL, NULL, NULL, NULL, NULL); INSERT INTO data_universe_rkd (SecCode, Type_, ID, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, ISIN, Ticker, SEDOL, CUSIP, RIC, DisplayRIC, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode) VALUES (11299829, 1, 'JMKE', 145482, 1, 186244, 'C', 1, 1, 'OSR', 'US47668J1025', 'JMKE', 'BT5DG9', '47668J10', 'JMKE.K', 'JMKE.N', 'NYSE', 'USA', NULL, NULL, NULL, NULL, NULL);