UPDATE data_universe SET Name = 'CALEDONIAN HOLD PL ORD GBP0.01' WHERE SecCode = 2991 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BKYI.PK', RkdDisplayRIC = 'BKYI.PK', RkdExchCode = 'OTC' WHERE SecCode = 9345 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'MAC' WHERE SecCode = 19538 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 25455 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-05-12' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951444.0 WHERE SecCode = 67089 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'WONPUNG MULSA KRW1000' WHERE SecCode = 67667 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ASTR' WHERE SecCode = 68277 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68472 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68473 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 69267 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69698 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 72075 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CHONGQING CHONGBAI ''A''CNY1' WHERE SecCode = 74910 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75207 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'KOIY.BO', RkdDisplayRIC = 'KOIY.BO' WHERE SecCode = 76103 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE data_universe SET Name = 'KBIO LABS INC KRW500' WHERE SecCode = 76681 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'JOLSE CO LTD KRW1000' WHERE SecCode = 77250 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1996-08-15' WHERE SecCode = 77383 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ASTR-R' WHERE SecCode = 80704 AND Type_ = 10;
UPDATE data_universe SET Name = 'TBSP PCL THB1(NVDR)' WHERE SecCode = 80720 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81730 AND Type_ = 10;
UPDATE data_universe SET Name = 'CREOSG CO LTD KRW2500' WHERE SecCode = 83589 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 85547 AND Type_ = 10;
UPDATE data_universe SET Name = 'POLY XVERSE INTELL HKD0.01 (POST COMP)' WHERE SecCode = 86443 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000463820', RkdTicker = 'SPXDE', PermIDTicker = 'SPXDE', RkdSEDOL = 'BSHSHW', RkdRIC = 'SPXDE.AX', RkdDisplayRIC = 'SPXDE.AX', DsPrimQtSedol = 'BSHSHW3', SecMapEndDate = '2026-05-11', endDate = '2026-05-11' WHERE SecCode = 87204 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TH0670B10Z01', RkdSEDOL = 'BX9GG3', DsPrimQtSedol = 'BX9GG34' WHERE SecCode = 90115 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET Name = 'TBSP PCL THB1 (LOCAL)' WHERE SecCode = 97054 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 97593 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 97844 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'TSE', ExchCode = 'TOR' WHERE SecCode = 98010 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 98376 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98494 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 98740 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 99097 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-12', PermSecMapEndDate = '2026-05-12' WHERE SecCode = 99438 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 99478 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'NOBIA AB NPV (POST REV SPLIT)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 102878 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 111453 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TH0814A10Z09', RkdSEDOL = 'BX9GG1', DsPrimQtSedol = 'BX9GG12' WHERE SecCode = 122945 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 139134 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 140030 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 143382 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GSPT.NS^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-12', SecMapEndDate = '2026-05-11', PermQuoteRetireDate = '2026-05-13', endDate = '2026-05-11' WHERE SecCode = 143572 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'VISA CHROME LTD INR10' WHERE SecCode = 143733 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 183464 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 199026 AND Type_ = 10;
UPDATE data_universe SET Name = 'JUNE INDUSTRIES LT INR1' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 268324 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'HPOW', PermIDTicker = 'HPOW', RkdRIC = 'HPOW.L', RkdDisplayRIC = 'HPOW.L' WHERE SecCode = 288775 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 296637 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 298971 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'KLT.H', PermIDTicker = 'KLT.H', RkdRIC = 'KLTh.V', RkdDisplayRIC = 'KLTh.V' WHERE SecCode = 322565 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 354668 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 395046 AND Type_ = 10;
UPDATE data_universe SET Name = 'EMIRATES MOBILITY AED0.5' WHERE SecCode = 395052 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 496999 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG8442C1886', RkdSEDOL = 'BVH9PT', RkdCUSIP = 'G8442C18', DsPrimQtSedol = 'BVH9PT0' WHERE SecCode = 1033939 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1173673 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1348835 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951578.0 WHERE SecCode = 1433313 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLITs', QuotePermID = 21482394593.0, ExchCode = 'BUR', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236806710929.0 WHERE SecCode = 1611823 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ASTR', PermIDTicker = 'ASTR', RkdRIC = 'ASTRm.BK', RkdDisplayRIC = 'ASTRm.BK' WHERE SecCode = 2217629 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NSR.AX^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-12', SecMapEndDate = '2026-04-21', PermQuoteRetireDate = '2026-05-12', PermSecMapEndDate = '2026-05-12', endDate = '2026-04-21' WHERE SecCode = 2429429 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 2900880 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'HNX' WHERE SecCode = 2912792 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3001070 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3152632 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3200982 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21716782408.0, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21', endDate = '2021-01-20' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SPXDE', DsPrimQtSedol = 'BSHSHW3' WHERE SecCode = 3275548 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3341054 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3367032 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 3378008 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3394718 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NLFSK.CO^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-13', SecMapEndDate = '2026-05-12', PermQuoteRetireDate = '2026-05-13', endDate = '2026-05-12' WHERE SecCode = 3396657 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FREBd', QuotePermID = 21633475006.0, ExchCode = 'BCO', PermQuoteRetireDate = '2019-02-11' WHERE SecCode = 3429677 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21922259627.0, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3678991 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y5625W11' WHERE SecCode = 3693295 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3736002 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 3858207 AND Type_ = 10;
UPDATE data_universe SET Name = 'SALTWARE CO LTD KRW500' WHERE SecCode = 3932618 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4101081 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7088.T^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-13', SecMapEndDate = '2026-05-12', endDate = '2026-05-12' WHERE SecCode = 4129530 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 4382180 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4383293 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4553949 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4582890 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL, RkdRIC = 'EDX.L', RkdDisplayRIC = 'EDX.L', RkdExchCode = 'LON' WHERE SecCode = 4613103 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4787325 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4790436 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4918578 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4960809 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4970745 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565180699.0, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 5447482 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5448738 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 5485071 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5600816 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'T6S35V11' WHERE SecCode = 5635825 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 18068812178.0 WHERE SecCode = 5848777 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5912053 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-08', PermQuoteRetireDate = '2026-05-12', PermSecMapEndDate = '2026-05-12', endDate = '2026-05-08' WHERE SecCode = 6256408 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6789484 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951527.0 WHERE SecCode = 6806165 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6813232 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6813831 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6829102 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'REXA', QuotePermID = 236806710555.0, InstrPermID = 232934017108.0, OrgPermID = 5096933363.0, PriValQuotePermID = 236806710555.0, PriInstrPermID = 232929330331.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'WSE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'POL', IncCntry = 'POL', PriTRBCIndPermID = 4294951592.0, PermOrgIPODate = '2026-05-07', PermSecMapStartDate = '2026-05-06', startDate = '2026-05-06' WHERE SecCode = 6832532 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ALCE', QuotePermID = 236806709750.0, InstrPermID = 232934002062.0, OrgPermID = 5068075938.0, PriValQuotePermID = 236806709750.0, PriInstrPermID = 25727375325.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SWX', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951288.0, PermOrgIPODate = '2019-04-09', PermSecMapStartDate = '2026-05-06', startDate = '2026-05-06' WHERE SecCode = 6832534 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'RTB', RkdRIC = 'RTB.O', RkdDisplayRIC = 'RTB.OQ', Name = 'RTB DIGITAL INC COMMON STOCK' WHERE SecCode = 10925095 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11079734 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NMS' WHERE SecCode = 11137860 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'AREB.PK', RkdDisplayRIC = 'AREB.PK', RkdExchCode = 'OTC' WHERE SecCode = 11156315 AND Type_ = 1;
UPDATE data_universe SET Name = 'MANULIFE FINL CORP NON CUM PF SR 4' WHERE SecCode = 11160125 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11174616 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'MNG' WHERE SecCode = 11185629 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-12', PermSecMapEndDate = '2026-05-12' WHERE SecCode = 11186429 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'CAN' WHERE SecCode = 11198864 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11200314 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-12', PermSecMapEndDate = '2026-05-12' WHERE SecCode = 11232942 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11234105 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11238736 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11240840 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11250292 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PLGO', Name = 'PELAGOS INS CAP LTD COM' WHERE SecCode = 11254521 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11255869 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-13', SecMapEndDate = '2026-05-12', endDate = '2026-05-12' WHERE SecCode = 11279604 AND Type_ = 1;
UPDATE data_universe SET Name = 'CTW USD CL A ORD SHS' WHERE SecCode = 11281853 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11281952 AND Type_ = 1;
UPDATE data_universe SET Name = 'CCH HLDGS LTD CL A ORD SHS' WHERE SecCode = 11286421 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2023-09-15', startDate = '2023-09-15' WHERE SecCode = 11289605 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11290226 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293776 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US0109111056', RkdTicker = 'ALMR', RkdSEDOL = 'BVPYJ0', RkdCUSIP = '01091110', RkdRIC = 'ALMR.O', RkdDisplayRIC = 'ALMR.OQ', RkdCode = 144832.0, RkdIssueID = 1.0, RkdIssueCode = 185221.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11294599 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11294619 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US42226B5012', RkdTicker = 'NHP', RkdSEDOL = 'BT5HGR', RkdCUSIP = '42226B50', RkdRIC = 'NHP.O', RkdDisplayRIC = 'NHP.OQ', RkdCode = 144835.0, RkdIssueID = 1.0, RkdIssueCode = 185225.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11294781 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG4939F1155', RkdTicker = 'IACQU', RkdSEDOL = 'BVFC90', RkdCUSIP = 'G4939F11', RkdRIC = 'IACQU.O', RkdDisplayRIC = 'IACQU.OQ', RkdCode = 144834.0, RkdIssueID = 1.0, RkdIssueCode = 185224.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295027 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US75381A1088', RkdTicker = 'REA', RkdSEDOL = 'BX564M', RkdCUSIP = '75381A10', RkdRIC = 'REA', RkdDisplayRIC = 'REA.A', RkdCode = 144846.0, RkdIssueID = 1.0, RkdIssueCode = 185236.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295409 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US77106T1079', RkdTicker = 'BOT', PermIDTicker = 'BOT', RkdSEDOL = 'BT9QSY', RkdCUSIP = '77106T10', RkdRIC = 'BOT.O', RkdDisplayRIC = 'BOT.OQ', RkdCode = 144836.0, RkdIssueID = 1.0, RkdIssueCode = 185226.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '', QuotePermID = 236806714234.0, InstrPermID = 232934086956.0, OrgPermID = 5096763030.0, PriTrdQuotePermID = 236806714234.0, PriValQuotePermID = 25727023772.0, PriInstrPermID = 232934086956.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'PRI', IncCntry = 'USA', PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = '2026-05-11', PermSecMapStartDate = '2026-05-07', startDate = '2026-05-07' WHERE SecCode = 11295459 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US60705V1035', RkdTicker = 'MOBI', RkdSEDOL = 'BSLN3D', RkdCUSIP = '60705V10', RkdRIC = 'MOBI.O', RkdDisplayRIC = 'MOBI.OQ', RkdCode = 144842.0, RkdIssueID = 1.0, RkdIssueCode = 185232.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295602 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OTAI.U', QuotePermID = 236806713556.0, InstrPermID = 232927390506.0, OrgPermID = 5097138024.0, PriTrdQuotePermID = 236806713556.0, PriValQuotePermID = 25727023803.0, PriInstrPermID = 232927390506.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-08', PermSecMapStartDate = '2026-05-07', startDate = '2026-05-07' WHERE SecCode = 11295628 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BWIV', QuotePermID = 236806469867.0, InstrPermID = 232896022139.0, OrgPermID = 5097058005.0, PriTrdQuotePermID = 236806469867.0, PriValQuotePermID = 25727024529.0, PriInstrPermID = 232896022139.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PermOrgIPODate = '2026-03-20', PermSecMapStartDate = '2026-05-01', startDate = '2026-03-20' WHERE SecCode = 11295695 AND Type_ = 1;
