UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-19', SecMapEndDate = '2026-05-27', endDate = '2026-05-27' WHERE SecCode = 30213 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-19', SecMapEndDate = '2026-05-27', endDate = '2026-05-27' WHERE SecCode = 30235 AND Type_ = 10;
UPDATE data_universe SET Name = 'ATOS GROUP EUR1(POST CONS)' WHERE SecCode = 46790 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-18' WHERE SecCode = 67906 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 69876 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'FREET INC KRW500' WHERE SecCode = 70873 AND Type_ = 10;
UPDATE data_universe SET Name = 'APAC RESOURCES LTD HKD1.00 (HK)' WHERE SecCode = 71995 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75012 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 DsCtryQtStatus = 'S' WHERE SecCode = 77289 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-19', SecMapEndDate = '2024-07-30', endDate = '2024-07-30' WHERE SecCode = 80275 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-06-18', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 82759 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 84305 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2017-02-22', endDate = '2017-02-22' WHERE SecCode = 84409 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 SecMapStartDate = '2013-04-17' WHERE SecCode = 90135 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ONIDA ELECTRONICS INR1' WHERE SecCode = 93697 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 PermSecMapEndDate = '2026-06-18' WHERE SecCode = 98717 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 DsCtryQtStatus = 'S' WHERE SecCode = 127118 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 143394 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2026-05-27' WHERE SecCode = 145065 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 352684 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'WELLE GROUP CO LTD ''A''CNY1' WHERE SecCode = 1031564 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3194837 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21650788270.0, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3769448 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 DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-19', SecMapEndDate = '2026-05-28', endDate = '2026-05-28' WHERE SecCode = 4046415 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 PermInstrStatus = 'AC' WHERE SecCode = 4421086 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 Name = 'CEBU LANDMASTERS' WHERE SecCode = 5722386 AND Type_ = 10;
UPDATE data_universe SET Name = 'DEEPAK BUILDERS & INR1(POST SUBD)' WHERE SecCode = 5969252 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6305206 AND Type_ = 10;
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, SecMapStartDate = '2026-01-05', SecMapEndDate = '2026-05-28', endDate = '2026-05-28' WHERE SecCode = 6608224 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6752842 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-15', startDate = '2026-04-30' WHERE SecCode = 6806345 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-15' WHERE SecCode = 6806346 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-15', startDate = '2026-04-30' WHERE SecCode = 6806347 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-06-15', startDate = '2026-05-06' WHERE SecCode = 6829246 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6846686 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6865121 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6880029 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BOHUSo', QuotePermID = 236808614260.0, InstrPermID = 232940917568.0, OrgPermID = 5044310435.0, PriInstrPermID = 232940917568.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'STO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'NOR', IncCntry = 'NOR', PriTRBCIndPermID = 4294951618.0, PermOrgIPODate = '2026-06-18', PermSecMapStartDate = '2026-06-17', startDate = '2026-06-17' WHERE SecCode = 6927600 AND Type_ = 10;
UPDATE data_universe SET Name = 'PIONEER NAT RES CO PFD A CV 8%' WHERE SecCode = 10775950 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'NAS' WHERE SecCode = 11142751 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BPK4738', PermSecMapEndDate = '2026-06-19', endDate = '2026-06-19' WHERE SecCode = 11151885 AND Type_ = 1;
UPDATE data_universe SET Name = 'BIODEXA PHARMACEUTICALS PLC SPONSORED ADS' WHERE SecCode = 11154766 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 11194627 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-19' WHERE SecCode = 11203366 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BPK46Z3' WHERE SecCode = 11222087 AND Type_ = 1;
UPDATE data_universe SET Name = 'NOVA MINERALS CORP *W EXP 99/99/9999' WHERE SecCode = 11267640 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BN92Y38' WHERE SecCode = 11270668 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BPK4716' WHERE SecCode = 11275270 AND Type_ = 1;
UPDATE data_universe SET Name = 'PN SMART ENERGY LTD CL A ORD SHS' WHERE SecCode = 11275653 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BPK4761' WHERE SecCode = 11277033 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BPK4X52' WHERE SecCode = 11286613 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BPK4749' WHERE SecCode = 11294834 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TVIVU', QuotePermID = 236803384484.0, InstrPermID = 232922153061.0, OrgPermID = 5097065975.0, PriTrdQuotePermID = 236803384484.0, PriValQuotePermID = 25727033703.0, PriInstrPermID = 232922153061.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-06-18', PermSecMapStartDate = '2026-06-13', startDate = '2026-06-13' WHERE SecCode = 11297725 AND Type_ = 1;