UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5387 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 5423 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-12-31', PermSecMapEndDate = '2026-01-05', endDate = '2025-12-31' WHERE SecCode = 8411 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2025-05-01', PermSecMapEndDate = '2026-01-05', endDate = '2025-05-01' WHERE SecCode = 11436 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 32100 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-01-05' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'GCO.MC^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-05', SecMapEndDate = '2026-01-02', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05', endDate = '2026-01-02' WHERE SecCode = 52483 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951210.0 WHERE SecCode = 59357 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73063 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KOSE HLDGS CORP NPV' WHERE SecCode = 74268 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75060 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77859 AND Type_ = 10;
UPDATE data_universe SET Name = 'MINERA ALAMOS INC COM SHS' WHERE SecCode = 80076 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83226 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83916 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'MFLJ.J^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-06', SecMapEndDate = '2025-12-29', PermQuoteRetireDate = '2026-01-06', PermSecMapEndDate = '2026-01-06', endDate = '2025-12-29' WHERE SecCode = 89166 AND Type_ = 10;
UPDATE data_universe SET Name = 'GREEN DEV ELECT GR ''A''CNY1' WHERE SecCode = 97903 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 100496 AND Type_ = 1;
UPDATE data_universe SET Name = 'FRASLE MOBILITY SA COM NPV' WHERE SecCode = 112880 AND Type_ = 10;
UPDATE data_universe SET Name = 'TRAILHEAD GLOBAL NPV' WHERE SecCode = 126255 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836471067.0, PriValQuotePermID = 55836471067.0, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 137412 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 141065 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 144583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 147077 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'E8XG.F', RkdDisplayRIC = 'E8XG.F', RkdExchCode = 'FRA', PriValQuotePermID = 55836398738.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-01-05', endDate = '2026-01-05' WHERE SecCode = 168671 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-05' WHERE SecCode = 292089 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 305082 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-12-30', PermSecMapEndDate = '2026-01-04', endDate = '2025-12-30' WHERE SecCode = 356235 AND Type_ = 10;
UPDATE data_universe SET Name = 'SHANGHAI KAIBAO PH ''A''CNY1' WHERE SecCode = 559591 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 670174 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 709665 AND Type_ = 10;
UPDATE data_universe SET Name = 'UBS FUND MANAGEMEN UBS CH PROP FD DRCT MXD URB' WHERE SecCode = 935925 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-15' WHERE SecCode = 1493553 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2429962 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2455559 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2706356 AND Type_ = 10;
UPDATE data_universe SET Name = 'RS TECHNOLOGIES CO NPV' WHERE SecCode = 2826667 AND Type_ = 10;
UPDATE data_universe SET Name = 'MORROW BANK AB NOK1' WHERE SecCode = 2855774 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2882481 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2923366 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21568326330.0, ExchCode = 'DEU', PermQuoteRetireDate = '2022-06-08', endDate = '2022-06-08' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 96634.0 WHERE SecCode = 3220407 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 3275891 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 PrimaryIssueCode = 107116.0 WHERE SecCode = 3342720 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3358504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-05', SecMapEndDate = '2024-01-03', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05', endDate = '2024-01-03' WHERE SecCode = 3394104 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3395241 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858470979.0, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-03' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET Name = 'LIFECARE ASA NOK0.1' WHERE SecCode = 3547244 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3569570 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3641197 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 3772582 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4129528 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'VCW.HNO^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-06', SecMapEndDate = '2026-01-05', PermQuoteRetireDate = '2026-01-06', PermSecMapEndDate = '2026-01-06', endDate = '2026-01-05' WHERE SecCode = 4333242 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-01-02', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-01-05', endDate = '2026-01-02' WHERE SecCode = 4355904 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-01-02', PermSecMapEndDate = '2026-01-05', endDate = '2026-01-02' WHERE SecCode = 4425686 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4436933 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4540662 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 4635207 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2021-04-15' WHERE SecCode = 4682731 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0016278154', RkdTicker = 'HILB B', RkdSEDOL = 'BN0TGN', RkdCUSIP = 'W4058E10', RkdRIC = 'HILBb.ST', RkdDisplayRIC = 'HILBb.ST', RkdCode = 143872.0, RkdIssueID = 1.0, RkdIssueCode = 183750.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'STO', RkdExchCtry = 'SWE', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 4752205 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0016829790', RkdTicker = 'PRESRV', RkdSEDOL = 'BL5BFJ', RkdCUSIP = 'W6705V10', RkdRIC = 'PRESRV.TE', RkdDisplayRIC = 'PRESRV.TE', RkdCode = 143870.0, RkdIssueID = 1.0, RkdIssueCode = 183748.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'AKT', RkdExchCtry = 'SWE', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 4770119 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0017083835', RkdTicker = 'CHARGE', RkdSEDOL = 'BP6VKY', RkdCUSIP = 'W2R79010', RkdRIC = 'CHARGE.ST', RkdDisplayRIC = 'CHARGE.ST', RkdCode = 143882.0, RkdIssueID = 1.0, RkdIssueCode = 183764.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'STO', RkdExchCtry = 'SWE', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 4800726 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-06', endDate = '2026-01-06' WHERE SecCode = 4889205 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-06', endDate = '2026-01-06' WHERE SecCode = 4889214 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951581.0 WHERE SecCode = 5127372 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-01-02', PermSecMapEndDate = '2026-01-05', endDate = '2026-01-02' WHERE SecCode = 5142544 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5147782 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = 'BRJTT4' WHERE SecCode = 5458392 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5493164 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-06', endDate = '2026-01-06' WHERE SecCode = 6220135 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6411863 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE1000074Q1', RkdTicker = '2575', RkdSEDOL = 'BTXY8J', RkdCUSIP = 'Y973BH10', RkdRIC = '2575.HK', RkdDisplayRIC = '2575.HK', RkdCode = 132804.0, RkdIssueID = 1.0, RkdIssueCode = 168597.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6503362 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6526462 AND Type_ = 10;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 6562448 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6564760 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-01-02', PermSecMapEndDate = '2026-01-04', endDate = '2026-01-02' WHERE SecCode = 6569470 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'ES0105979001', RkdTicker = 'SCGV', RkdSEDOL = 'BV2H4J', RkdCUSIP = 'E5690J10', RkdRIC = 'SCGV.MC', RkdDisplayRIC = 'SCGV.MC', RkdCode = 143879.0, RkdIssueID = 1.0, RkdIssueCode = 183761.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'MCE', RkdExchCtry = 'ESP', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6598936 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PMRL11', QuotePermID = 22149422981.0, InstrPermID = 18068894513.0, OrgPermID = 5097097531.0, PriValQuotePermID = 22149422981.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SAO', QuoteClass = 'CEF', InstrClass = 'CEF', OrgTypeCode = 'CINV', DomCntry = 'BRA', IncCntry = 'BRA', PriTRBCIndPermID = 4294951318.0, PermOrgIPODate = '2025-12-29', PermSecMapStartDate = '2025-12-29', startDate = '2025-12-29' WHERE SecCode = 6617804 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6617811 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 6622147 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11035590 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11136753 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA73965Q8882', RkdSEDOL = 'BTCLTZ', RkdCUSIP = '73965Q88', DsPrimQtSedol = 'BTCLTZ1', PermSecMapEndDate = '2026-01-06', endDate = '2026-01-06' WHERE SecCode = 11162577 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951746.0 WHERE SecCode = 11177866 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'BNXA.V^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-01-06', PermQuoteRetireDate = '2026-01-06', endDate = '2026-01-06' WHERE SecCode = 11191478 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2021-04-15' WHERE SecCode = 11222508 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'PBBK.OQ^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-01-06', PermQuoteRetireDate = '2026-01-06', endDate = '2026-01-06' WHERE SecCode = 11227293 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11248308 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11249090 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US73017P4090', RkdSEDOL = 'BTCLRP', RkdCUSIP = '73017P40', DsPrimQtSedol = 'BTCLRP7' WHERE SecCode = 11259864 AND Type_ = 1;
UPDATE data_universe SET Name = 'NORTH ATLANTIC TITANIUM CORP COM SHS' WHERE SecCode = 11271493 AND Type_ = 1;
UPDATE data_universe SET Name = 'CELLYAN BIOTECHNOLOGY CO LTD ORD SHS CL A' WHERE SecCode = 11273965 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2021-04-15' WHERE SecCode = 11284186 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 11287729 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11288659 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2025-12-15', startDate = '2025-12-15' WHERE SecCode = 11288766 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11289101 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-01-02', PermSecMapEndDate = '2026-01-05', endDate = '2026-01-02' WHERE SecCode = 11289567 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG9584S1066', RkdTicker = 'WSTN', RkdSEDOL = 'BT9QTJ', RkdCUSIP = 'G9584S10', RkdRIC = 'WSTN.O', RkdDisplayRIC = 'WSTN.OQ', RkdCode = 142667.0, RkdIssueID = 1.0, RkdIssueCode = 182068.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11290007 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA8605762068', RkdSEDOL = 'BTCLRZ', RkdCUSIP = '86057620', DsPrimQtSedol = 'BTCLRZ7' WHERE SecCode = 11290226 AND Type_ = 1;
