UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 2023 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 2097 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = NULL WHERE SecCode = 2803 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475442988.0, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 7178 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 32045 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HOS', Name = 'HORNBECK OFFSHORE SVCS INC N COM' WHERE SecCode = 33185 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 36117 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'DHL AG NPV(REGD)' WHERE SecCode = 43982 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55842440800.0, PermQuoteRetireDate = '2012-05-04', endDate = '2012-05-04' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DYH', QuotePermID = 21830308575.0, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-09-02' WHERE SecCode = 49578 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 RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-02' WHERE SecCode = 68545 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '3718', DsCtryQtStatus = 'A', DsPrimQtSedol = 'BWNN2Z8' WHERE SecCode = 72108 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 72759 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73709 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SAJODONGAONE CO LT KRW5000' WHERE SecCode = 74753 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 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 RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80477 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80562 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82950 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 84342 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'LAND 33 BHD NPV' WHERE SecCode = 86338 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GIXI' WHERE SecCode = 87670 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 25727196678.0, ExchCode = 'A2X' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88709 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 DsCtryQtStatus = 'S' WHERE SecCode = 90013 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG5699G1516', RkdSEDOL = 'BVSV6C', RkdCUSIP = 'G5699G15' WHERE SecCode = 91736 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 93380 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 94862 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-02' WHERE SecCode = 94982 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 95169 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 96166 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 97370 AND Type_ = 10;
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 Name = 'IMPERA WORLDWIDE L INR10' WHERE SecCode = 126342 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135783 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 146140 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ZAF' WHERE SecCode = 146690 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BEL' WHERE SecCode = 176980 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21507329852.0, ExchCode = 'FRA' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 285288 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '096610.KQ^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-03', SecMapEndDate = '2026-09-02', PermQuoteRetireDate = '2026-09-03', endDate = '2026-09-02' WHERE SecCode = 340660 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 361205 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 429392 AND Type_ = 10;
UPDATE data_universe SET Name = 'ALPHA PROFESSIONAL USD0.001 (POST BL CHG)' WHERE SecCode = 566853 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4150.TWO^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-03', SecMapEndDate = '2026-09-02', endDate = '2026-09-02' WHERE SecCode = 823018 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 881834 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-03', PermQuoteRetireDate = '2026-09-03', endDate = '2026-09-03' WHERE SecCode = 1110900 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1694231 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-02', SecMapEndDate = '2026-09-02', PermQuoteRetireDate = '2026-08-31', endDate = '2026-08-31' WHERE SecCode = 2385337 AND Type_ = 10;
UPDATE data_universe SET Name = 'GOLFZONDECA INC KRW500', Country = 'KOR' WHERE SecCode = 2396445 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'HELIO.ST^G26', RkdIssueStatus = 0.0 WHERE SecCode = 2580219 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET Name = 'MR. BLUE CORPORATI KRW500' WHERE SecCode = 2727820 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2831967 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'PIIPPO.HE^F26', RkdIssueStatus = 0.0 WHERE SecCode = 2835285 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2905771 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21615835622.0, ExchCode = 'DEU', PermQuoteRetireDate = '2022-09-27', endDate = '2022-09-27' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3358012 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', IncCntry = NULL WHERE SecCode = 3378303 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TEN TECHS GP PLC ORD GBP0.001' WHERE SecCode = 3405323 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3547828 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3568391 AND Type_ = 10;
UPDATE data_universe SET Name = 'DFV DEUTSCHE FAMIL NPV (REGD)' WHERE SecCode = 3661124 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3774518 AND Type_ = 10;
UPDATE data_universe SET Name = 'FORTUNE RES INV IDR100' WHERE SecCode = 3857447 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3886819 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 = 4094234 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4201683 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4300561 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 Name = 'DRAGON GOLD MNG NPV', Country = 'HKG' WHERE SecCode = 4396374 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-02' WHERE SecCode = 4444662 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 DsQuoteCurr = 'EUR' WHERE SecCode = 4633128 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-02', PermQuoteRetireDate = '2026-09-02', endDate = '2026-09-02' WHERE SecCode = 4659794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-03', SecMapEndDate = '2026-08-31', PermQuoteRetireDate = '2026-09-03', endDate = '2026-08-31' WHERE SecCode = 4712678 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4759419 AND Type_ = 10;
UPDATE data_universe SET Name = 'EAU LITHIUM LTD NPV' WHERE SecCode = 4788553 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4794506 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVBKRW6' WHERE SecCode = 4871191 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5045124 AND Type_ = 10;
UPDATE data_universe SET Name = 'BROKEN HILL MNS NPV' WHERE SecCode = 5104481 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5119093 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5127374 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5392796 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5600661 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 5616074 AND Type_ = 10;
UPDATE data_universe SET Name = 'EBRO MTR S GP EV EUR0.1' WHERE SecCode = 5954307 AND Type_ = 10;
UPDATE data_universe SET Name = 'GOLDEN HORSE MINER NPV CDI 1:1' WHERE SecCode = 6041243 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-02', PermQuoteRetireDate = '2026-09-02' WHERE SecCode = 6371486 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6809154 AND Type_ = 10;
UPDATE data_universe SET Name = 'AXIANT RESOURCES L NPV' WHERE SecCode = 7080302 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7080318 AND Type_ = 10;
UPDATE data_universe SET ExchCode = 'CVE' WHERE SecCode = 10924405 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-03', PermQuoteRetireDate = '2026-09-03', endDate = '2026-09-03' WHERE SecCode = 10958979 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-02' WHERE SecCode = 11171585 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-02' WHERE SecCode = 11187864 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11198089 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG451391398', RkdSEDOL = 'BTCL6K', RkdCUSIP = 'G4513913' WHERE SecCode = 11204164 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US83193D3026', RkdSEDOL = 'C094KW', RkdCUSIP = '83193D30' WHERE SecCode = 11226914 AND Type_ = 1;
UPDATE data_universe SET Name = 'RESPONSIBLE ENERGY CORP COM' WHERE SecCode = 11243215 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'YFOR', RkdRIC = 'YFOR.O', RkdDisplayRIC = 'YFOR.OQ', Name = 'YYFORCE INC CL A ORD SHS' WHERE SecCode = 11264467 AND Type_ = 1;
UPDATE data_universe SET Name = 'DHL AG CDN DEP RCPTS CA' WHERE SecCode = 11276214 AND Type_ = 1;
UPDATE data_universe SET Name = 'INFLECTION POINT ACQU CORP V UNIT 02/11/2031' WHERE SecCode = 11291836 AND Type_ = 1;
UPDATE data_universe SET Name = 'INFLECTION POINT ACQU CORP V CL A ORD SHS' WHERE SecCode = 11292617 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SGLD', QuotePermID = 236813069446.0, InstrPermID = 232947337088.0, OrgPermID = 4297632698.0, PriTrdQuotePermID = 236813069446.0, PriValQuotePermID = 25726992335.0, PriInstrPermID = 8589992282.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NAS', QuoteClass = 'ADR', InstrClass = 'ADR', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951922.0, PermOrgIPODate = '2007-03-29', PermSecMapStartDate = '2026-08-26', startDate = '2026-08-26' WHERE SecCode = 11301203 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TLACU', QuotePermID = 236809289965.0, InstrPermID = 232943210588.0, OrgPermID = 6000180736.0, PriTrdQuotePermID = 236809289965.0, PriValQuotePermID = 25727014931.0, PriInstrPermID = 232943210588.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-09-01', PermSecMapStartDate = '2026-09-01' WHERE SecCode = 11301272 AND Type_ = 1;