UPDATE data_universe SET PermIDTicker = 'XAN', QuotePermID = 21475442982.0, ExchCode = 'POS' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ISR' WHERE SecCode = 10519 AND Type_ = 10;
UPDATE data_universe SET Name = 'CEMEX SAB DE CV SPON ADR NEW' WHERE SecCode = 12956 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 13989 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'CEMEX S.A.B. DE C. COM SER''A''NPV' WHERE SecCode = 27883 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CEMEX S.A.B. DE C. COM SER''B''NPV' WHERE SecCode = 27888 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CEMEX S.A.B. DE C. CPO NPV(REP 2''A'' & 1''B'')' WHERE SecCode = 27891 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA3564541082', RkdSEDOL = 'BXM1HJ', RkdCUSIP = '35645410', Name = 'FREEGOLD LTD COM NEW' WHERE SecCode = 28391 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = 11490.0, RkdIssueCode = 15675.0, RkdExchCode = 'NA', RkdExchCtry = NULL WHERE SecCode = 43039 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868.0, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 51313 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'DEU' WHERE SecCode = 56127 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-08', PermSecMapEndDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 56295 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CYV', DsPrimQtSedol = 'BSSF4N3', PermSecMapEndDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 74387 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 75203 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 DsCtryQtStatus = 'S' WHERE SecCode = 76411 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 78460 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79084 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81363 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7940.T^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-09', SecMapEndDate = '2026-07-08', PermSecMapEndDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 84806 AND Type_ = 10;
UPDATE data_universe SET Name = 'SIGNET JEWELERS LTD SHS' WHERE SecCode = 84916 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85888 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-09', PermQuoteRetireDate = '2026-07-09', PermSecMapEndDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 88250 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXD2L22' WHERE SecCode = 89269 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 IsMajorSec = 'Y' WHERE SecCode = 90150 AND Type_ = 1;
UPDATE data_universe SET Name = 'GUJARAT INJECT INR1(POST SUBD)' WHERE SecCode = 90598 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-09', PermQuoteRetireDate = '2026-07-09' WHERE SecCode = 91917 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ONIDA', RkdRIC = 'ONIA.NS', RkdDisplayRIC = 'ONIA.NS' WHERE SecCode = 93697 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 94669 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 RkdRIC = 'SDI.AX^G26', RkdIssueStatus = 0.0 WHERE SecCode = 96110 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 96193 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SHANGHAI JUSS SPOR ''A''CNY1' WHERE SecCode = 96398 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 96476 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-09', SecMapEndDate = '2026-07-08', PermQuoteRetireDate = '2026-07-09', endDate = '2026-07-08' WHERE SecCode = 114799 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116617 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-09', endDate = '2026-07-09' WHERE SecCode = 145285 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'GEA1.WA^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-08', SecMapEndDate = '2026-03-10', PermQuoteRetireDate = '2026-07-08', PermSecMapEndDate = '2026-07-08', endDate = '2026-03-10' WHERE SecCode = 147237 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 186577 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 243344 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GCMDA', DsPrimQtSedol = 'BR4VZ80', PermSecMapEndDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 325884 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'CLIJ.J^F26', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 387643 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CIA DE ELECT TULUA COP10' WHERE SecCode = 532082 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'DZM.HNO^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-09', SecMapEndDate = '2022-12-02', PermQuoteRetireDate = '2026-07-09', PermSecMapEndDate = '2026-07-08', endDate = '2022-12-02' WHERE SecCode = 565523 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2010-08-31' WHERE SecCode = 706545 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EMT', DsPrimQtSedol = 'BKKF253' WHERE SecCode = 797593 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 83473.0 WHERE SecCode = 805203 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1310768 AND Type_ = 10;
UPDATE data_universe SET Name = 'LION FIN GP PLC ORD GBP0.01' WHERE SecCode = 1534940 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1602456 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVSV379' WHERE SecCode = 1660603 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN011', QuotePermID = 21512412458.0, ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'DEU' WHERE SecCode = 1835498 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2515633 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXD2L22' WHERE SecCode = 2639395 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 2646553 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'DEU' WHERE SecCode = 2655924 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2688137 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET Name = 'ADHERIUM LTD NPV' WHERE SecCode = 2963543 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'DEU' WHERE SecCode = 3172342 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3217882 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3271698 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3285736 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2017-07-21' WHERE SecCode = 3378476 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858705514.0, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-04' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EMT', DsPrimQtSedol = 'BKKF253' WHERE SecCode = 3610329 AND Type_ = 10;
UPDATE data_universe SET Name = 'JUFEEL INTL HLDGS HKD0.01' WHERE SecCode = 3631179 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3868546 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 RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 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 = 'S' WHERE SecCode = 4620927 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-08' WHERE SecCode = 4631916 AND Type_ = 10;
UPDATE data_universe SET Name = 'ECONOMATICA SA NPV BRL', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4657577 AND Type_ = 10;
UPDATE data_universe SET Name = 'CEMEX S.A.B. DE C. BDR EACH 1 REPR 1 ADR' WHERE SecCode = 4862916 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 132731.0 WHERE SecCode = 4957892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5054829 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 5454700 AND Type_ = 10;
UPDATE data_universe SET Name = 'ZHONGHE SHANGDA AE CNY1 A' WHERE SecCode = 5958659 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6772975 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6870730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-09', SecMapEndDate = '2026-07-08', PermSecMapEndDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 6890758 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6937616 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6945384 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-08', endDate = '2026-07-08' WHERE SecCode = 6960490 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-07-07', startDate = '2026-06-26' WHERE SecCode = 6967195 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6967199 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-07-07' WHERE SecCode = 6967201 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2008-10-17' WHERE SecCode = 10785144 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US08771Y5015', RkdSEDOL = 'BTH25W', RkdCUSIP = '08771Y50' WHERE SecCode = 10933963 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BABY', DsPrimQtSedol = 'BTMRFL7', DsExchMnem = 'CNQ', PermQuoteStatus = 'AC', ExchCode = 'CNX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11027686 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXD1FS3' WHERE SecCode = 11028764 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'ISC.TO^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-08' WHERE SecCode = 11080057 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2015-12-29' WHERE SecCode = 11152008 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US26614N2018', RkdSEDOL = 'BW60F1', RkdCUSIP = '26614N20' WHERE SecCode = 11176481 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-08', PermSecMapEndDate = '2026-07-08' WHERE SecCode = 11219530 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'OLPX.OQ^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-08', PermSecMapEndDate = '2026-07-08' WHERE SecCode = 11231455 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BSNSP90' WHERE SecCode = 11277132 AND Type_ = 1;
UPDATE data_universe SET Name = 'SECURITIZE CORP COM SHS' WHERE SecCode = 11277957 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11296311 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US2439271006', RkdTicker = 'FISN', RkdSEDOL = 'BXCGH4', RkdCUSIP = '24392710', RkdRIC = 'FISN.O', RkdDisplayRIC = 'FISN.OQ', RkdCode = 145138.0, RkdIssueID = 1.0, RkdIssueCode = 185711.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11297671 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11298186 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', IsPrimaryInstr = 0.0 WHERE SecCode = 11298234 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-29' WHERE SecCode = 11298319 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11298355 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG6029D1245', RkdTicker = 'MIACU', RkdSEDOL = 'BTCL70', RkdCUSIP = 'G6029D12', RkdRIC = 'MIACU.O', RkdDisplayRIC = 'MIACU.OQ', RkdCode = 145140.0, RkdIssueID = 1.0, RkdIssueCode = 185714.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11298691 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 11298872 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALPX', IsMajorSec = 'Y', QuotePermID = 236809330309.0, InstrPermID = 232934949071.0, OrgPermID = 6000095565.0, PriTrdQuotePermID = 236809330309.0, PriValQuotePermID = 25727014548.0, PriInstrPermID = 232934949071.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-25', PermSecMapStartDate = '2026-07-03', startDate = '2026-06-25' WHERE SecCode = 11298874 AND Type_ = 1;
