UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 7851 AND Type_ = 1;
UPDATE data_universe SET Name = 'MANUFACTURAS DE CE NPV' WHERE SecCode = 31387 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 31531 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2026-04-06', PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08', endDate = '2026-04-06' WHERE SecCode = 33731 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951610.0 WHERE SecCode = 38658 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475194877.0, ExchCode = 'STU', PermQuoteRetireDate = '2005-01-26' WHERE SecCode = 40933 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475290166.0, ExchCode = 'STU' WHERE SecCode = 41512 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KMR.I', QuotePermID = 21475581769.0, PermQuoteStatus = 'DC', ExchCode = 'CIR', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 41818 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 42368 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'STGG.F^D26', RkdIssueStatus = 0.0 WHERE SecCode = 59737 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21589872687.0, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-17' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475287223.0, ExchCode = 'HAN', PermQuoteRetireDate = '2004-04-23', endDate = '2004-04-23' WHERE SecCode = 64165 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-02-25' WHERE SecCode = 68739 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'JOJO.BO', RkdDisplayRIC = 'JOJO.BO' WHERE SecCode = 69705 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72293 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72337 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75276 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77184 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78043 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 78322 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78655 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SAHLIBHFI', RkdRIC = 'SHAL.NS', RkdDisplayRIC = 'SHAL.NS', RkdExchCode = 'NSE' WHERE SecCode = 81820 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83601 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85321 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86364 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1992-03-09' WHERE SecCode = 87218 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89024 AND Type_ = 10;
UPDATE data_universe SET Name = 'ELKOP ESTONIA SE NPV' WHERE SecCode = 100237 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 101286 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 105675 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474928708.0, ExchCode = 'JNX' WHERE SecCode = 115378 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 124822 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142298 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21915101968.0, ExchCode = 'DEU' WHERE SecCode = 147555 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21528681544.0, ExchCode = 'NQX', PermQuoteRetireDate = '2010-07-02', endDate = '2010-07-02' WHERE SecCode = 164836 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 165065 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 199026 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 269427 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 369170 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 554738 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 564492 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 568150 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 580046 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEOVACS EUR0.005' WHERE SecCode = 588831 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SGRE.WA^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-08', SecMapEndDate = '2026-04-07', PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08', endDate = '2026-04-07' WHERE SecCode = 940758 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2000130 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2441664 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'HBGH.BO', RkdDisplayRIC = 'HBGH.BO' WHERE SecCode = 2541445 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2890449 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3026618 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 3049344 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 DsCtryQtStatus = 'D', DsSecDelistDate = '2023-08-01', SecMapEndDate = '2023-07-25', endDate = '2023-07-25' WHERE SecCode = 3312528 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2025-10-07', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-04-08', endDate = '2025-10-07' WHERE SecCode = 3385582 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21650788270.0, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21922259627.0, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '1922.HK^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-09', SecMapEndDate = '2026-04-08', PermSecMapEndDate = '2026-04-08', endDate = '2026-04-08' WHERE SecCode = 4006851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4053515 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-04-09', endDate = '2026-04-09' WHERE SecCode = 4079151 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 4261224 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236799369659.0, ExchCode = 'CHI' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5149981 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565180699.0, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5473222 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CH1544292464', PermIDTicker = 'XK7A', RkdSEDOL = 'BT68VR', RkdCUSIP = 'H1954A10', DsPrimQtSedol = 'BT68VR4', PermSecMapEndDate = '2026-04-08', endDate = '2026-04-08' WHERE SecCode = 5487993 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5525173 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-10-15' WHERE SecCode = 5886920 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-04-09', endDate = '2026-04-09' WHERE SecCode = 6043647 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'B1003', RkdSEDOL = 'BT7JNT', Name = 'CIABRASF CIA BRASI COM NPV', DsPrimQtSedol = 'BT7JNT2' WHERE SecCode = 6154012 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2025-05-22' WHERE SecCode = 6297439 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2025-05-22' WHERE SecCode = 6299028 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2025-05-27' WHERE SecCode = 6300538 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2025-05-22' WHERE SecCode = 6305198 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2025-05-22' WHERE SecCode = 6316542 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2025-05-22' WHERE SecCode = 6316543 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2025-05-22' WHERE SecCode = 6316544 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6450911 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-04-09', SecMapEndDate = '2026-04-08', PermSecMapEndDate = '2026-04-08', endDate = '2026-04-08' WHERE SecCode = 6691950 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6745473 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000455057', RkdTicker = '49M', RkdSEDOL = 'BW2L8G', RkdCUSIP = 'Q3946Z10', RkdRIC = '49M.AX', RkdDisplayRIC = '49M.AX', RkdCode = 144649.0, RkdIssueID = 1.0, RkdIssueCode = 184902.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6748873 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 18068907541.0 WHERE SecCode = 6755830 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA73278C2040', RkdSEDOL = 'BT66LH', RkdCUSIP = '73278C20', DsPrimQtSedol = 'BT66LH8' WHERE SecCode = 10926191 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'AL.N^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-08', SecMapEndDate = '2026-04-07', PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08', endDate = '2026-04-07' WHERE SecCode = 10986008 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2011-02-24' WHERE SecCode = 10988860 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11027686 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 11131887 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951358.0 WHERE SecCode = 11155145 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11180728 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11180729 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 25727255535.0, PriValQuotePermID = 25727366156.0, DomCntry = 'USA' WHERE SecCode = 11198774 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11209843 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11212180 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11239219 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'CPTAF', RkdRIC = 'CPTAF.PK', RkdDisplayRIC = 'CPTAF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11240537 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-04-09', SecMapEndDate = '2026-03-24', endDate = '2026-03-24' WHERE SecCode = 11250693 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'OAKU.OQ^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-09', endDate = '2026-04-09' WHERE SecCode = 11253112 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA79467H1029', RkdTicker = 'SCAI', RkdSEDOL = 'BT66LN', RkdCUSIP = '79467H10', RkdRIC = 'SCAI.V', RkdDisplayRIC = 'SCAI.V', DsPrimQtSedol = 'BT66LN4', SecMapStartDate = '2023-05-25' WHERE SecCode = 11253247 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-04-09', SecMapEndDate = '2026-04-08', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09', endDate = '2026-04-08' WHERE SecCode = 11255668 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'HYAC.N^D26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-04-09', endDate = '2026-04-09' WHERE SecCode = 11257235 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11271927 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US70580B1061', RkdTicker = 'GLND', PermIDTicker = 'GLND', RkdSEDOL = 'BV4K66', RkdCUSIP = '70580B10', RkdRIC = 'GLND.O', RkdDisplayRIC = 'GLND.OQ', InfoCode = 395665, DsSecCode = 272214, DsCmpyCode = 213117, DsCtryQtStatus = 'A', DsPrimQtSedol = 'BV4K660', RkdCode = 144589.0, RkdIssueCode = 184802.0, RkdIssueStatus = 1.0, COATypeCode = '', QuotePermID = 236804841102.0, InstrPermID = 232916301644.0, OrgPermID = 5096997405.0, PriTrdQuotePermID = 236804841102.0, PriValQuotePermID = 25727029106.0, PriInstrPermID = 232916301644.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', IncCntry = 'USA', PriTRBCIndPermID = 4294951998.0, DsSecDelistDate = NULL, DsExchQtStartDate = '2026-03-26', SecMapStartDate = '2026-03-26', SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermOrgIPODate = '2026-03-26', PermSecMapStartDate = '2026-03-26', PermSecMapEndDate = NULL, startDate = '2026-03-26', endDate = NULL WHERE SecCode = 11279226 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'MHY1250N1233', RkdSEDOL = 'BT5JCK', RkdCUSIP = 'Y1250N12', DsPrimQtSedol = 'BT5JCK8' WHERE SecCode = 11281757 AND Type_ = 1;
UPDATE data_universe SET Name = 'TELYRX HOLDINGS INC COM' WHERE SecCode = 11287208 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291637 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292189 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA1688821083', RkdTicker = 'CMCG', RkdSEDOL = 'BTJYM8', RkdCUSIP = '16888210', RkdRIC = 'CMCG.V', RkdDisplayRIC = 'CMCG.V', RkdCode = 144650.0, RkdIssueID = 1.0, RkdIssueCode = 184903.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11292196 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292932 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-03-25' WHERE SecCode = 11293711 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ACGCU', QuotePermID = 236805392093.0, InstrPermID = 232926681525.0, OrgPermID = 6000052223.0, PriTrdQuotePermID = 236805392093.0, PriValQuotePermID = 25727028141.0, PriInstrPermID = 232926681525.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-04-07', PermSecMapStartDate = '2026-04-07' WHERE SecCode = 11294225 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AACPU', QuotePermID = 25727292579.0, InstrPermID = 25727292581.0, OrgPermID = 5079700268.0, PriInstrPermID = 25727292581.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'NA', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951348.0, PermSecMapStartDate = '2026-03-27', startDate = '2026-03-27' WHERE SecCode = 11294226 AND Type_ = 1;
