UPDATE data_universe SET RkdISIN = 'GB00BWPD4D87', RkdSEDOL = 'BWPD4D', RkdCUSIP = 'G0378017' WHERE SecCode = 430 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 907 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IE00038O9UC4', RkdSEDOL = 'BWXJZR' WHERE SecCode = 3002 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 6926 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 9422 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, DsPrimQtSedol = 'BN7RHC5', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 33894 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 36113 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-29', PermQuoteRetireDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 49597 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 57487 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 67959 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 69340 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71928 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 74489 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA89472Y1079', RkdCUSIP = '89472Y10' WHERE SecCode = 74536 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76039 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 RkdCUSIP = 'Q7747416' WHERE SecCode = 78713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80964 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 82584 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DMC', RkdRIC = 'DMC', RkdDisplayRIC = 'DMC.N' WHERE SecCode = 84234 AND Type_ = 1;
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 RkdRIC = '8289.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 91476 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 94266 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 = 'A' WHERE SecCode = 95767 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 95877 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 100175 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000168784.0, PriInstrPermID = 8590931602.0, OrgTypeCode = 'UNK', PermOrgIPODate = NULL WHERE SecCode = 101044 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'JAIA.NS^F26', RkdIssueStatus = 0.0 WHERE SecCode = 113906 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 119146 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 143655 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 345666 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 513474 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-29', PermQuoteRetireDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 522937 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 562062 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 602075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 670174 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 706545 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 796594 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1025098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1122166 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 1154797 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1517550 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 1610436 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1640107 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MID' WHERE SecCode = 2132979 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2397417 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2441664 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2623929 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2646553 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 2693646 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '3198.T^F26', DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 2696581 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 2835285 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000470916', RkdTicker = 'ADRDB', PermIDTicker = 'ADRDB', RkdSEDOL = 'BTZCDG', RkdRIC = 'ADRDB.AX', RkdDisplayRIC = 'ADRDB.AX' 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 QuotePermID = 21587931857.0, ExchCode = 'BTE' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26', endDate = '2026-06-26' WHERE SecCode = 3365585 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 3387570 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3401662 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3504365 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3526122 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3526124 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3619201 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '590A', PriInstrPermID = NULL WHERE SecCode = 3961764 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 DsCtryQtStatus = 'A' WHERE SecCode = 4481042 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 = 'D', DsSecDelistDate = '2026-06-29', PermQuoteRetireDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 4784515 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4854751 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4969392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5089512 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5147782 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ADRDB' WHERE SecCode = 5607472 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6310627 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6590976 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-29', endDate = '2026-06-29' WHERE SecCode = 6832532 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951631.0 WHERE SecCode = 6849655 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007R52' WHERE SecCode = 6902658 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y6839Y10' WHERE SecCode = 6917389 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y228W210' WHERE SecCode = 6921015 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y818J210' WHERE SecCode = 6927588 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-06-23' WHERE SecCode = 6937626 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OPTS', QuotePermID = 236808932126.0, InstrPermID = 232939972876.0, OrgPermID = 6000174901.0, PriValQuotePermID = 236808932126.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'MIL', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'ITA', IncCntry = 'ITA', PermOrgIPODate = '2026-06-26', PermSecMapStartDate = '2026-06-25' WHERE SecCode = 6941773 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6945363 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-06-26' WHERE SecCode = 6945380 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US67113Y8012', RkdSEDOL = 'BNVVQV', RkdCUSIP = '67113Y80', Name = 'NUWELLIS INC NUWELLIS INC' WHERE SecCode = 11021598 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US19200A3032', RkdCUSIP = '19200A30', DsPrimQtSedol = 'BTH26D6' WHERE SecCode = 11152008 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11179609 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US8959703096', RkdSEDOL = 'BRSCZS', RkdCUSIP = '89597030' WHERE SecCode = 11198767 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG4289N1557', RkdCUSIP = 'G4289N15', DsPrimQtSedol = 'BTH26L4' WHERE SecCode = 11201544 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11203233 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG9897X1491', RkdCUSIP = 'G9897X14', DsPrimQtSedol = 'BTH26Q9' WHERE SecCode = 11205267 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11230564 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 236793811078.0, PriTrdQuotePermID = 236809002159.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'GTC', PermQuoteRetireDate = '2026-06-25', PermSecMapStartDate = '2024-12-09', endDate = '2026-06-25' WHERE SecCode = 11237342 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FORT', QuotePermID = 25727253092.0, OrgPermID = 5032048454.0, PriTrdQuotePermID = NULL, PriInstrPermID = 25727253267.0, ExchCode = 'CVE', PriTRBCIndPermID = 4294951942.0, PermOrgIPODate = '2022-03-09', PermSecMapStartDate = '2022-03-08' WHERE SecCode = 11239425 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA57807J2020', RkdSEDOL = 'BTH285', RkdCUSIP = '57807J20' WHERE SecCode = 11240570 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG386171337', RkdCUSIP = 'G3861713', DsPrimQtSedol = 'BTH26H0' WHERE SecCode = 11256494 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG622641333', RkdCUSIP = 'G6226413', DsPrimQtSedol = 'BVV6M74' WHERE SecCode = 11264180 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11266820 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-26', PermOrgIPODate = NULL WHERE SecCode = 11289286 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292229 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232927390510.0 WHERE SecCode = 11295628 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232942228392.0 WHERE SecCode = 11296942 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-06-04' WHERE SecCode = 11297055 AND Type_ = 1;