INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (2884543, 10, '@ROYCE2', 'DE000RYSE888', 'DE000RYSE888', 'RY8', 'RY8', 'BWT3FC', 'D6S0AT10', 'RY8.F', 'RY8.F', 'ROY ASSET HOLDING NPV', 'DE', 'DEU', 282332, 210056, 164420, 'Y', 'D', 'BWT3FC0', 'EQ', 'XET', 'DE', 'EUR', 104493.0, 1.0, 131437.0, 'C', 1.0, 1.0, 'OSR', 'FRA', 'DEU', NULL, 'EQU', NULL, NULL, 'IND', 21562820095.0, 21562819123.0, 5045881482.0, NULL, 21562820095.0, 21562819123.0, 1.0, 1.0, 'DC', 'AC', 'DUS', 'ORD', 'ORD', 'COM', 'DEU', 'DEU', 4294951333.0, '2026-07-14', '2018-05-29', '2015-04-30', '2026-06-08', '2026-07-14', '2018-05-29', '2015-04-29', NULL, '2015-04-29', '2026-06-08');
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (6967208, 10, '@HONGK27180', NULL, NULL, NULL, '2985', NULL, NULL, NULL, NULL, 'HONG KONG GOLD HKD0.04 (PARALLEL 28/07/26)', 'XH', 'HKG', 400259, 274540, 154013, 'N', 'A', 'BWD3ZV5', 'EQ', 'HKG', 'HK', 'HKD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236809400451.0, 232943393677.0, 5037433860.0, NULL, 236809400451.0, 21500897765.0, 1.0, 0.0, 'AC', 'AC', 'HKG', 'ORD', 'ORD', 'COM', 'CHN', 'CYM', 4294951914.0, NULL, '2026-07-08', '2026-07-08', '2079-06-06', '2026-07-29', '2012-04-27', '2026-07-04', NULL, '2026-07-04', NULL);
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (6974633, 10, '@LESLI6', NULL, NULL, NULL, 'ALLSF', NULL, NULL, NULL, NULL, 'LE SLIP FRANCAIS EUR0.24', 'FR', 'FRA', 400575, 274754, 215039, 'Y', 'A', 'BSKSD44', 'EQ', 'PAR', 'FR', 'EUR', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236809536269.0, 232943190138.0, 5045947373.0, NULL, 236809536269.0, 232943190138.0, 1.0, 1.0, 'AC', 'AC', 'PAR', 'ORD', 'ORD', 'COM', 'FRA', 'FRA', 4294951671.0, NULL, '2026-07-14', '2026-07-14', '2079-06-06', NULL, '2026-07-14', '2026-07-08', NULL, '2026-07-08', NULL);
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (6980182, 10, '@HESAI9', NULL, NULL, NULL, '2983', NULL, NULL, NULL, NULL, 'HESAI GROUP USD0.0000125 B (PL 13/08/26', 'XH', 'CYM', 400573, 274753, 196629, 'N', 'A', 'BXPW2M7', 'EQ', 'HKG', 'HK', 'HKD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236809515952.0, 232943818807.0, 5083769871.0, NULL, 236809515952.0, 232899487569.0, 1.0, 0.0, 'AC', 'AC', 'HKG', 'ORD', 'ORD', 'COM', 'CHN', 'CYM', 4294951214.0, NULL, '2026-07-10', '2026-07-14', '2079-06-06', '2026-08-14', '2023-02-09', '2026-07-07', NULL, '2026-07-07', NULL);
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (6982422, 10, '@GREEN462', NULL, NULL, NULL, '2988', NULL, NULL, NULL, NULL, 'GREEN LEADER HLDGS HKD0.004 (PARALLEL 17/08/26', 'HK', 'BMU', 400572, 274751, 26765, 'N', 'A', 'BWL85Z6', 'EQ', 'HKG', 'HK', 'HKD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236809619877.0, 232944256143.0, 4295871802.0, NULL, 236809619877.0, 8591296512.0, 1.0, 0.0, 'AC', 'AC', 'HKG', 'ORD', 'ORD', 'COM', 'HKG', 'BMU', 4294952001.0, NULL, '2026-07-14', '2026-07-14', '2079-06-06', '2026-08-18', '1999-07-06', '2026-07-09', NULL, '2026-07-09', NULL);
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (6982423, 10, '@CFPHA4', NULL, NULL, NULL, '2989', NULL, NULL, NULL, NULL, 'CF PHARMTECH INC CNY1 H (PARALLEL 03/08/26)', 'XH', 'CHN', 400571, 274752, 210211, 'N', 'A', 'BWL8608', 'EQ', 'HKG', 'HK', 'HKD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236809619885.0, 232944256349.0, 5057829932.0, NULL, 236809619885.0, 232902035343.0, 1.0, 0.0, 'AC', 'AC', 'HKG', 'ORD', 'ORD', 'COM', 'CHN', 'CHN', 4294951272.0, NULL, '2026-07-14', '2026-07-14', '2079-06-06', '2026-08-04', '2025-10-08', '2026-07-09', NULL, '2026-07-09', NULL);
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (6982424, 10, '@GENSA1', NULL, NULL, NULL, 'OROX', NULL, NULL, NULL, NULL, 'GENS AUREA SPA NPV', 'IT', 'ITA', 400577, 274755, 215040, 'Y', 'A', 'BWPH9V3', 'EQ', 'MIL', 'IT', 'EUR', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236809831363.0, 232943730754.0, 5039619687.0, NULL, 236809831363.0, NULL, 0.0, 0.0, 'AC', 'AC', 'MIL', 'ORD', 'ORD', 'COM', 'ITA', 'ITA', 4294951488.0, NULL, '2026-07-14', '2026-07-14', '2079-06-06', NULL, '2026-07-14', '2026-07-13', NULL, '2026-07-13', NULL);
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (11236064, 1, 'NEMEP.V', NULL, 'CA6470391062', 'NEME.P', 'ATOI', 'BM9V21', '64703910', 'NEMEp.V', 'NEMEp.V', 'ASIATEL OUTSOURCING INC COM', 'CA', 'CAN', 400597, 274774, 215059, 'Y', 'A', 'BXS0347', 'EQ', 'TSX', 'CA', 'CAD', 138630.0, 1.0, 176546.0, 'C', 1.0, 1.0, 'OSR', 'CVE', 'CAN', NULL, 'EQU', NULL, NULL, 'IND', 25727233465.0, 25727233466.0, 5081347405.0, NULL, 25727233465.0, 25727233466.0, 1.0, 1.0, 'AC', 'AC', 'CVE', 'ORD', 'ORD', 'COM', 'CAN', 'CAN', 4294951782.0, NULL, '2026-07-14', '2021-12-21', '2079-06-06', NULL, '2021-12-21', '2021-12-21', NULL, '2021-12-21', NULL);
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (11237686, 1, 'SEPSF', NULL, 'CA04368A2048', 'ASEP', 'SEPSF', 'BTTRRH', '04368A20', 'ASEP.CD', 'ASEP.CD', 'ASEP MED HLDGS INC COM NEW', 'CA', 'CAN', 348145, 245695, 191322, 'Y', 'A', 'BTTRRH0', 'EQ', 'CNQ', 'CA', 'CAD', 131415.0, 1.0, 166727.0, 'C', 1.0, 1.0, 'OSR', 'CNQ', 'CAN', NULL, 'EQU', NULL, NULL, 'IND', 25727207968.0, 21856600657.0, 5081481206.0, NULL, 21856600655.0, 21856600657.0, 0.0, 1.0, 'AC', 'AC', 'PNK', 'ORD', 'ORD', 'COM', 'CAN', 'CAN', 4294951265.0, NULL, '2021-11-22', '2021-11-19', '2079-06-06', NULL, '2021-11-22', '2022-01-28', NULL, '2021-11-19', NULL);
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (11299219, 1, 'G1810A10', NULL, NULL, NULL, 'BRKH', NULL, NULL, NULL, NULL, 'BURTECH ACQUISITION CORP II ORD SHS CL A', 'US', 'CYM', 400618, 274789, 214046, 'Y', 'A', 'BRCDM32', 'EQ', 'NAS', 'US', 'USD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 236809833577.0, 232921039825.0, 6000109818.0, 236809833566.0, 25727005757.0, 232921039825.0, 0.0, 1.0, 'AC', 'AC', 'SCN', 'ORD', 'ORD', 'COM', 'USA', 'CYM', 4294951348.0, NULL, '2026-07-14', '2026-07-14', '2079-06-06', NULL, '2026-05-22', '2026-07-14', NULL, '2026-05-22', NULL);
INSERT INTO data_universe (SecCode, Type_, ID, ISIN, RkdISIN, RkdTicker, PermIDTicker, RkdSEDOL, RkdCUSIP, RkdRIC, RkdDisplayRIC, Name, ModelCntry, Country, InfoCode, DsSecCode, DsCmpyCode, IsMajorSec, DsCtryQtStatus, DsPrimQtSedol, DsTypeCode, DsExchMnem, DsExchCtryCode, DsQuoteCurr, RkdCode, RkdIssueID, RkdIssueCode, RkdIssueType, RkdIssueStatus, RkdIssueOrder, RkdListingType, RkdExchCode, RkdExchCtry, ShPerListing, PrimaryIssueType, PrimaryIssueCode, RelType, COATypeCode, QuotePermID, InstrPermID, OrgPermID, PriTrdQuotePermID, PriValQuotePermID, PriInstrPermID, IsPrimaryQuote, IsPrimaryInstr, PermQuoteStatus, PermInstrStatus, ExchCode, QuoteClass, InstrClass, OrgTypeCode, DomCntry, IncCntry, PriTRBCIndPermID, DsSecDelistDate, DsExchQtStartDate, SecMapStartDate, SecMapEndDate, PermQuoteRetireDate, PermOrgIPODate, PermSecMapStartDate, PermSecMapEndDate, startDate, endDate) VALUES (11299220, 1, 'G5177612', NULL, 'KYG517761212', 'JONEU', 'JONEU', 'BRCDN0', 'G5177612', 'JONEU.O', 'JONEU.OQ', 'JONES VENTURES INTL ACQUISIT UNIT 07/06/2031', 'US', 'CYM', 400629, 274795, 215075, 'Y', 'A', 'BRCDN06', 'EQ', 'NAS', 'US', 'USD', 145153.0, 1.0, 185737.0, 'C', 1.0, 1.0, 'OSR', 'NASD', 'USA', NULL, 'EQU', NULL, NULL, '', 236809409979.0, 232939103631.0, 6000135913.0, 236808156929.0, 25727018929.0, 232939103631.0, 0.0, 1.0, 'AC', 'AC', 'TXG', 'UNT', 'UNT', 'COM', 'USA', 'CYM', 4294951348.0, NULL, '2026-07-14', '2026-07-14', '2079-06-06', NULL, '2026-07-14', '2026-07-14', NULL, '2026-07-14', NULL);
