UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 1339 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, DsSecDelistDate = '2025-10-13' WHERE SecCode = 10093 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 19980 AND Type_ = 1;
UPDATE data_universe SET IncCntry = 'MEX' WHERE SecCode = 29093 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'MEX' WHERE SecCode = 30997 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ANFP.I', QuotePermID = 21475586638.0, ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 33925 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475405461.0, ExchCode = 'MUN' WHERE SecCode = 35324 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '2INVn.DE^A26', RkdIssueStatus = 0.0 WHERE SecCode = 35707 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DYH', QuotePermID = 55836326929.0, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-01-06' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-01-06' WHERE SecCode = 49579 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 55932 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 56578 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DE000A41YCR9', RkdTicker = 'EFF0', PermIDTicker = 'EFF0', RkdSEDOL = 'BV7DQG', RkdCUSIP = 'D1R41111', RkdRIC = 'EFF0k.DE', RkdDisplayRIC = 'EFF0k.DE', DsPrimQtSedol = 'BV7DQG6' WHERE SecCode = 61649 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 64002 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73099 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 77104 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdISIN = 'INE766A01026', RkdSEDOL = 'BTZBTG', RkdCUSIP = 'Y7079515', Name = 'PAE LTD INR10', DsPrimQtSedol = 'BTZBTG9', PermSecMapEndDate = '2026-01-06', endDate = '2026-01-06' WHERE SecCode = 79084 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 80076 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87281 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 89261 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92595 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM', PermOrgIPODate = '2004-04-07' WHERE SecCode = 98668 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 99059 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ERAG', PermIDTicker = 'ERAG', RkdRIC = 'ERAGn.DE', RkdDisplayRIC = 'ERAGn.DE' WHERE SecCode = 140759 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 140844 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'MEX' WHERE SecCode = 146914 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836398738.0, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 168671 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'TRX.L^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-07', SecMapEndDate = '2025-10-22', PermQuoteRetireDate = '2026-01-07', PermSecMapEndDate = '2026-01-07', endDate = '2025-10-22' WHERE SecCode = 189711 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 375203 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-09' WHERE SecCode = 555809 AND Type_ = 10;
UPDATE data_universe SET Name = 'CATALINA RESOURCES NPV DFD 09/01/26(EX-SPLIT)' WHERE SecCode = 557332 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'NVDR' WHERE SecCode = 566423 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1497364 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6403.TWO^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-07', SecMapEndDate = '2026-01-06', PermSecMapEndDate = '2026-01-06', endDate = '2026-01-06' WHERE SecCode = 1796548 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2923366 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2924567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2924589 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3263272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3358504 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 3378476 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3395831 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3409200 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3433633 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3554989 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3569570 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3664312 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3719723 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '2019.HK^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-07', SecMapEndDate = '2026-01-06', PermSecMapEndDate = '2026-01-06', endDate = '2026-01-06' WHERE SecCode = 3772582 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 120914.0 WHERE SecCode = 3960052 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4032275 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4092151 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4462843 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4540662 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4650978 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEXORA TECH CO LTD TWD10' WHERE SecCode = 4724703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4794512 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-01-05', PermQuoteRetireDate = '2026-01-06', PermSecMapEndDate = '2026-01-06', endDate = '2026-01-05' WHERE SecCode = 4889205 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-08-08', PermQuoteRetireDate = '2026-01-06', PermSecMapEndDate = '2026-01-06', endDate = '2025-08-08' WHERE SecCode = 4889214 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4925656 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '450140.KS^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-07', SecMapEndDate = '2025-12-12', PermQuoteRetireDate = '2026-01-07', PermSecMapEndDate = '2026-01-06', endDate = '2025-12-12' WHERE SecCode = 5292508 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '45014K.KS^A26', DsCtryQtStatus = 'D', DsTypeCode = 'PREF', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-07', SecMapEndDate = '2025-12-12', PermQuoteRetireDate = '2026-01-07', PermSecMapEndDate = '2026-01-07', endDate = '2025-12-12' WHERE SecCode = 5292509 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-06', PermSecMapEndDate = NULL, startDate = '2023-07-03', endDate = NULL WHERE SecCode = 5458392 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21975266861.0, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5493164 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'AAI.ASE^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-07', SecMapEndDate = '2026-01-06', PermQuoteRetireDate = '2026-01-07', PermSecMapEndDate = '2026-01-07', endDate = '2026-01-06' WHERE SecCode = 5610275 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5657397 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 126767.0 WHERE SecCode = 5760069 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-01-05', PermQuoteRetireDate = '2026-01-06', PermSecMapEndDate = '2026-01-06', endDate = '2026-01-05' WHERE SecCode = 6220135 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6541023 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6583645 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951954.0 WHERE SecCode = 6583658 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 6583675 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 6587315 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'QA000YI47FK6', RkdTicker = 'MFMS', RkdSEDOL = 'BVV8TB', RkdCUSIP = 'M6872E10', RkdRIC = 'MFMS.QA', RkdDisplayRIC = 'MFMS.QA', RkdCode = 143884.0, RkdIssueID = 1.0, RkdIssueCode = 183768.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'DOH', RkdExchCtry = 'QAT', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6598774 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6601530 AND Type_ = 10;
UPDATE data_universe SET Name = 'IBKS NO 25 SPL KRW100' WHERE SecCode = 6608218 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951548.0 WHERE SecCode = 6610159 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6610164 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6617659 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6617664 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232913305774.0, IsPrimaryInstr = 1.0 WHERE SecCode = 6622147 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'ADR' WHERE SecCode = 10929178 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11026187 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11109486 AND Type_ = 1;
UPDATE data_universe SET Name = 'PRAIRIE PROVIDENT RES INC COM SHS' WHERE SecCode = 11162577 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'MRSN.OQ^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-01-07', SecMapEndDate = '2026-01-05', PermQuoteRetireDate = '2026-01-07', endDate = '2026-01-05' WHERE SecCode = 11174144 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 11189049 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 11189991 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-01-06' WHERE SecCode = 11191478 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PNFP PR C', InfoCode = 391228, DsSecCode = 270112, DsCtryQtStatus = 'A', DsPrimQtSedol = 'BP9N1K1', DsExchMnem = 'NYS', QuotePermID = 25727041295.0, InstrPermID = 25727041301.0, PriTrdQuotePermID = 25727041295.0, PriValQuotePermID = 25727041275.0, PriInstrPermID = NULL, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ADR', InstrClass = 'ADR', DsSecDelistDate = NULL, DsExchQtStartDate = '2026-01-02', SecMapStartDate = '2026-01-02', SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-12-30', PermSecMapEndDate = NULL, startDate = '2025-12-30', endDate = NULL WHERE SecCode = 11208071 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CVAC.OQ^A26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-01-07', endDate = '2026-01-07' WHERE SecCode = 11211044 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11217561 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11221158 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 11221665 AND Type_ = 1;
UPDATE data_universe SET Name = 'BITVENTURES LTD ORD SHS NEW', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11221669 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11224254 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-01-02', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-01-06', endDate = '2026-01-02' WHERE SecCode = 11227293 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097091057.0, PermOrgIPODate = '2021-09-23' WHERE SecCode = 11230470 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2022-08-04', startDate = '2022-08-04' WHERE SecCode = 11244529 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097068229.0, PriInstrPermID = 232802593205.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951211.0, PermOrgIPODate = '2022-12-20' WHERE SecCode = 11248308 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11248583 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11248948 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097068229.0, PriInstrPermID = 232802593205.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951211.0, PermOrgIPODate = '2022-12-20', startDate = '2022-12-20' WHERE SecCode = 11249090 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'RECHF', QuotePermID = 236801199789.0, InstrPermID = 232813461025.0, OrgPermID = 5086711003.0, PriValQuotePermID = 236779667981.0, PriInstrPermID = 232813461025.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = '2023-10-18', PermSecMapStartDate = '2026-01-05' WHERE SecCode = 11276594 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11287515 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232881059017.0 WHERE SecCode = 11288113 AND Type_ = 1;
UPDATE data_universe SET Name = 'ALUSSA ENERGY ACQUISIT CORP UNIT 99/99/9999', PriInstrPermID = 232905383406.0 WHERE SecCode = 11288167 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11288432 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11290244 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11290245 AND Type_ = 1;
