UPDATE data_universe SET Name = 'OTT HERITAGE HOSP EUR0.85778196' WHERE SecCode = 37718 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55846120871.0, ExchCode = 'CPH' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21563604590.0, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 55155 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PSFm', QuotePermID = 21478541730.0, IsPrimaryQuote = 0.0, ExchCode = 'EQD', PermQuoteRetireDate = '2017-02-03', endDate = '2017-02-03' WHERE SecCode = 62335 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70969 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 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 RkdRIC = '043090.KQ^H26', RkdIssueStatus = 0.0 WHERE SecCode = 82506 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838797189.0, ExchCode = 'JNB' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88495 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 RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-26', endDate = '2026-08-26' WHERE SecCode = 94726 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-24' WHERE SecCode = 95504 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 RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DREAMUS COMPANY KRW2500' WHERE SecCode = 104850 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 PermSecMapEndDate = '2026-08-25' WHERE SecCode = 125258 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 131988 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'AVENIQUE LTD INR2' WHERE SecCode = 243364 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 424431 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '8283.T^H26', RkdIssueStatus = 0.0 WHERE SecCode = 568101 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 643063 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BVG INVESTMENT JSC VND10000' WHERE SecCode = 790351 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ORBITEO ASI SA PLN1.00' WHERE SecCode = 879925 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BNC3LR1', SecMapEndDate = '2026-08-24', endDate = '2026-08-24' WHERE SecCode = 890647 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDGl', QuotePermID = 21531119071.0, ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2409481 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CAP2.DE', RkdDisplayRIC = 'CAP2.DE', RkdExchCode = 'ETR' WHERE SecCode = 2830908 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2923366 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2026-06-05' WHERE SecCode = 3101370 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2026-06-12' WHERE SecCode = 3245596 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BANPU PUBLIC CO THB10 (LOCAL)' WHERE SecCode = 3258936 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BANPU PUBLIC CO THB10 (NVDR)' WHERE SecCode = 3259989 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2023-10-27' WHERE SecCode = 3260398 AND Type_ = 10;
UPDATE data_universe SET Name = 'GLOBAL GOLD MINING NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3309732 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'CHEMCRUX', RkdRIC = 'CHEC.NS', RkdDisplayRIC = 'CHEC.NS', RkdExchCode = 'NSE' WHERE SecCode = 3318942 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21732297982.0, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BNC3LR1' WHERE SecCode = 3356354 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3396703 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3404696 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3407043 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-24' WHERE SecCode = 3410196 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'JTC.L^H26', RkdIssueStatus = 0.0 WHERE SecCode = 3440134 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-25', SecMapEndDate = '2026-08-24', PermSecMapEndDate = '2026-08-25', endDate = '2026-08-24' WHERE SecCode = 3661124 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 3793428 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-24' WHERE SecCode = 3881173 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3885292 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 PermSecMapEndDate = '2026-08-25' WHERE SecCode = 4333241 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-25' WHERE SecCode = 4500401 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 QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4635330 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000480444', RkdTicker = 'KLVDA', RkdSEDOL = 'BNC3HS', RkdRIC = 'KLVDA.AX', RkdDisplayRIC = 'KLVDA.AX' WHERE SecCode = 4871191 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5041664 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE0JYY01029', RkdSEDOL = 'BXPVRZ', RkdCUSIP = 'Y5765T12' WHERE SecCode = 5082416 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2026-04-15', DsExchQtStartDate = '2023-09-04' WHERE SecCode = 5515094 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2026-04-15' WHERE SecCode = 5517574 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007SS4', RkdCUSIP = 'Y151AP10' WHERE SecCode = 6934738 AND Type_ = 10;
UPDATE data_universe SET Name = 'WATERWAYS LEISURE INR1 (POST SUBD)', DsPrimQtSedol = 'BMWDW04' WHERE SecCode = 6955162 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TW0007943003', RkdTicker = '7943', RkdSEDOL = 'BSJS45', RkdCUSIP = 'Y5S8CB10', RkdRIC = '7943.TWO', RkdDisplayRIC = '7943.TWO', RkdCode = 145395.0, RkdIssueID = 1.0, RkdIssueCode = 186106.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TPO', RkdExchCtry = 'TWN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 7040613 AND Type_ = 10;
UPDATE data_universe SET Name = 'POWERHAUS URANIUM NPV' WHERE SecCode = 7048412 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'TWO.N^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-08-25', SecMapEndDate = '2026-08-24', endDate = '2026-08-24' WHERE SecCode = 10923445 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11023905 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11037077 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-25', SecMapEndDate = '2026-08-24', PermSecMapEndDate = '2026-08-25', endDate = '2026-08-24' WHERE SecCode = 11108370 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11130053 AND Type_ = 1;
UPDATE data_universe SET Name = 'ENDOVIA HEALTH SCIENCES INC COM SHS' WHERE SecCode = 11132638 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BV8CY13' WHERE SecCode = 11174939 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-08-24', endDate = '2026-08-24' WHERE SecCode = 11186707 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BV8CWL9' WHERE SecCode = 11215246 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BV8CY02' WHERE SecCode = 11220828 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11222704 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11223968 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-25', endDate = '2026-08-25' WHERE SecCode = 11229943 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX3H194' WHERE SecCode = 11239946 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11241417 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11244579 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11251558 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-26', SecMapEndDate = '2025-10-08', endDate = '2025-10-08' WHERE SecCode = 11282159 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11289387 AND Type_ = 1;
UPDATE data_universe SET Name = 'MERIDIAN3 INDUSTRIALS ACQ CO UNIT 06/29/2031' WHERE SecCode = 11298691 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US75867H1068', RkdTicker = 'REF', RkdSEDOL = 'C04JJC', RkdCUSIP = '75867H10', RkdRIC = 'REF', RkdDisplayRIC = 'REF.N', RkdCode = 145394.0, RkdIssueID = 1.0, RkdIssueCode = 186105.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11299832 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MIAC', QuotePermID = 236812899261.0, InstrPermID = 232939936087.0, OrgPermID = 6000154448.0, PriTrdQuotePermID = 236812899261.0, PriValQuotePermID = 25726992699.0, PriInstrPermID = 232939936087.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-07-02', PermSecMapStartDate = '2026-08-22', startDate = '2026-07-02' WHERE SecCode = 11300848 AND Type_ = 1;