UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 819 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT5GNW8', PermSecMapEndDate = '2026-07-17', endDate = '2026-07-17' WHERE SecCode = 5979 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 10081 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5095928035.0, PriInstrPermID = 8590928439.0, IncCntry = 'CYM', PermOrgIPODate = '2004-08-24' WHERE SecCode = 13986 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-05-29', endDate = '2026-05-29' WHERE SecCode = 32631 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'SCAFS', RkdRIC = 'SCAFS.MC', RkdDisplayRIC = 'SCAFS.MC', Name = 'AHORRO FAMILIAR SO EUR6', RkdIssueStatus = 1.0, RkdExchCode = 'MCE', PermOrgIPODate = '2026-07-17' WHERE SecCode = 34112 AND Type_ = 10;
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 DsCtryQtStatus = 'S' WHERE SecCode = 48360 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-07-17' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-17' WHERE SecCode = 55872 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXV21B3' WHERE SecCode = 60151 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 67183 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTFH0V9' WHERE SecCode = 68707 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'BANPUU', RkdRIC = 'BANPUU.BK', RkdDisplayRIC = 'BANPUU.BK' WHERE SecCode = 69239 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' 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 PermSecMapEndDate = '2026-07-16' WHERE SecCode = 79182 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVK0LQ9', PermSecMapEndDate = '2026-07-17', endDate = '2026-07-17' WHERE SecCode = 81130 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 82721 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236792718790.0, IsPrimaryQuote = 0.0, ExchCode = 'KNT' WHERE SecCode = 86473 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 DsPrimQtSedol = 'BTFH0T7' WHERE SecCode = 90759 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 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 PriInstrPermID = 232934312665.0, PermOrgIPODate = '2026-07-17' WHERE SecCode = 98099 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '1989-03-09' WHERE SecCode = 101044 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-16' WHERE SecCode = 111353 AND Type_ = 1;
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 ISIN = NULL, Name = 'INDIAN TONERS & DE INR 2 (POST SUB)' WHERE SecCode = 126797 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 180020 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 181407 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GCM', DsPrimQtSedol = 'BNRLG42' WHERE SecCode = 325884 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RIR', QuotePermID = 236809843802.0, ExchCode = 'NSI' WHERE SecCode = 377680 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-16' WHERE SecCode = 546068 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRY', DsPrimQtSedol = 'BVZL8X3' WHERE SecCode = 1142412 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTFH0T7' WHERE SecCode = 1334550 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BANK KASIKORN INDO IDR100' WHERE SecCode = 2287198 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE634J01027', RkdSEDOL = 'BV5L06', RkdCUSIP = 'Y2R44H12' WHERE SecCode = 2594252 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET Name = 'STARBEAM VENTURES INR1 (POST SUBD)' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET Name = 'CALLISTA INDS LTD INR10' WHERE SecCode = 2976322 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 3317887 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '002898.SZ^G26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL, PermSecMapEndDate = '2026-07-16' WHERE SecCode = 3392421 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET Name = 'OBCL LTD INR10' WHERE SecCode = 3444850 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'MYQ0467OO009', RkdSEDOL = 'BTHTZV', RkdCUSIP = 'Y2292J11', PermSecMapStartDate = '2026-07-17', PermSecMapEndDate = NULL, startDate = '2019-08-07', endDate = NULL WHERE SecCode = 3917553 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 PermSecMapEndDate = '2026-07-16' WHERE SecCode = 4194828 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 ISIN = NULL WHERE SecCode = 4386316 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-17', SecMapEndDate = '2026-07-13', PermQuoteRetireDate = '2026-07-17', PermSecMapEndDate = '2026-07-17', endDate = '2026-07-13' WHERE SecCode = 4446111 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 = 4588291 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 = 'A' WHERE SecCode = 4639579 AND Type_ = 10;
UPDATE data_universe SET Name = 'NOVOGENIA AG NPV' WHERE SecCode = 4756719 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BWYF770', PermSecMapEndDate = '2026-07-17', endDate = '2026-07-17' WHERE SecCode = 4773789 AND Type_ = 10;
UPDATE data_universe SET Name = 'RMK ENERGY TBK IDR20' WHERE SecCode = 4796256 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000479453', RkdTicker = 'VAN', RkdSEDOL = 'BX3CHD', RkdRIC = 'VAN.AX', RkdDisplayRIC = 'VAN.AX', Name = 'VANTAGE METALS LTD NPV' WHERE SecCode = 4842750 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21975266861.0, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-16', PermSecMapEndDate = NULL, startDate = '2024-05-17', endDate = NULL WHERE SecCode = 5760140 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6389710 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6522450 AND Type_ = 10;
UPDATE data_universe SET Name = 'ADVANCED ENGINEERE NPV' WHERE SecCode = 6612688 AND Type_ = 10;
UPDATE data_universe SET Name = 'Z.AI CO LTD CNY0.1 H' WHERE SecCode = 6626020 AND Type_ = 10;
UPDATE data_universe SET Name = 'GREEN LT RENEWABLE INFRASTRUCTURE FUND' WHERE SecCode = 6708242 AND Type_ = 10;
UPDATE data_universe SET Name = 'Z.AI CO LTD DR(400 : 1)' WHERE SecCode = 6721491 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AEROPLANE' WHERE SecCode = 6756394 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-06-29', startDate = '2026-06-29' WHERE SecCode = 6960490 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6963465 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6974596 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6974598 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6985954 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6985955 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6985956 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6985959 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6985960 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6985961 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6985966 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6985975 AND Type_ = 10;
UPDATE data_universe SET Name = 'DIGI SPAIN TELECOM EUR0.1' WHERE SecCode = 6985983 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000191567.0, PriInstrPermID = 21479058554.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951641.0, PermOrgIPODate = NULL WHERE SecCode = 11024463 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-17', endDate = '2026-07-17' WHERE SecCode = 11068907 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11105323 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-17', SecMapEndDate = '2026-07-16', endDate = '2026-07-16' WHERE SecCode = 11212859 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermSecMapEndDate = '2026-07-17' WHERE SecCode = 11230576 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US45840Y6095', RkdSEDOL = 'BWXHR6', RkdCUSIP = '45840Y60' WHERE SecCode = 11252479 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ATVHF' WHERE SecCode = 11257858 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 11260559 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 11260969 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5071498641.0, PriInstrPermID = 232832555930.0, DomCntry = 'SWE', IncCntry = 'SWE', PriTRBCIndPermID = 4294951705.0 WHERE SecCode = 11261977 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5071498641.0, PriInstrPermID = 232832555930.0, DomCntry = 'SWE', IncCntry = 'SWE', PriTRBCIndPermID = 4294951705.0 WHERE SecCode = 11263764 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000132924.0, PriInstrPermID = 21814425951.0, IncCntry = 'BMU' WHERE SecCode = 11264576 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11274561 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951318.0 WHERE SecCode = 11281144 AND Type_ = 1;
UPDATE data_universe SET Name = 'NIOBIUMX MNG INC COM' WHERE SecCode = 11288189 AND Type_ = 1;
UPDATE data_universe SET Name = 'DISCIPLINED GROWTH ACQUIS CO UNIT 99/99/9999', IsMajorSec = 'N' WHERE SecCode = 11296371 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232922445516.0 WHERE SecCode = 11297352 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'QMLS', QuotePermID = 236809847508.0, InstrPermID = 232917406734.0, OrgPermID = 5097119716.0, PriTrdQuotePermID = 236809847508.0, PriValQuotePermID = 25727005550.0, PriInstrPermID = 232917406734.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951211.0, PermOrgIPODate = '2026-07-16', PermSecMapStartDate = '2026-07-15', startDate = '2026-07-15' WHERE SecCode = 11299313 AND Type_ = 1;
