UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 1092 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 10093 AND Type_ = 10; UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 10886 AND Type_ = 10; UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 12708 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 13056 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-20' WHERE SecCode = 19450 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = 'BVMLJ0', PermSecMapEndDate = '2026-01-17', endDate = '2026-01-17' WHERE SecCode = 23996 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 28864 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-20' WHERE SecCode = 31682 AND Type_ = 1; UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 32948 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 39931 AND Type_ = 10; UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 40671 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'WIGGk.F', RkdDisplayRIC = 'WIGGk.F', RkdExchCode = 'FRA' WHERE SecCode = 44481 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'NTRb.CO^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-19', endDate = '2026-01-19' WHERE SecCode = 45794 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 46007 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 46189 AND Type_ = 10; UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 47239 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 47451 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 48839 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 49114 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 53901 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'PDS', RkdSEDOL = 'BLKFWW', RkdRIC = 'PDS', RkdDisplayRIC = 'PDS.N', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', OrgPermID = 5097125110.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 56814 AND Type_ = 1; UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 66876 AND Type_ = 10; UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 68392 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 70741 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71041 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'ROLT.NS^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-19', endDate = '2026-01-19' WHERE SecCode = 72182 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 78848 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81556 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 84552 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86934 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 87540 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'MURJ.J^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-19', endDate = '2026-01-19' WHERE SecCode = 88997 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 91067 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 91549 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 97849 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 99440 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 114648 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 115629 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 126806 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'FFNT.CD^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-19', PermQuoteRetireDate = '2026-01-19', endDate = '2026-01-19' WHERE SecCode = 214732 AND Type_ = 1; UPDATE data_universe SET RkdRIC = 'BIOT.ST^G25', RkdIssueStatus = 0.0 WHERE SecCode = 215848 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 305491 AND Type_ = 10; UPDATE data_universe SET OrgPermID = 5097125548.0, PriTRBCIndPermID = 4294951296.0, PermOrgIPODate = '2021-03-03' WHERE SecCode = 309092 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 356235 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'GHC.HNO^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-19', endDate = '2026-01-19' WHERE SecCode = 1123551 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 1548392 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1623752 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3002461 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'KPF.HNO', RkdDisplayRIC = 'KPF.HNO', RkdExchCode = 'UPC' WHERE SecCode = 3100328 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC' WHERE SecCode = 3124058 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'HALDER', QuotePermID = 236801608204.0, ExchCode = 'NSI' WHERE SecCode = 3155992 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 3160209 AND Type_ = 10; UPDATE data_universe SET OrgPermID = 5084670919.0, PriInstrPermID = 21598864636.0 WHERE SecCode = 3211294 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21716782408.0, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21', endDate = '2021-01-20' WHERE SecCode = 3255119 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3318763 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 DsCtryQtStatus = 'A' WHERE SecCode = 3358014 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'BAKK.L^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-19', endDate = '2026-01-19' WHERE SecCode = 3404428 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21859526011.0, ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-20', endDate = '2022-06-20' WHERE SecCode = 3436782 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3444651 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 3490925 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3664311 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3783079 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3878945 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4204830 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4566936 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4641478 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4842761 AND Type_ = 10; UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5156823 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5297846 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5366265 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5384551 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5449616 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5450886 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5489262 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5969248 AND Type_ = 10; UPDATE data_universe SET OrgPermID = 5084670919.0, PriInstrPermID = 21598864636.0 WHERE SecCode = 6211060 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 6258211 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6627454 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6627600 AND Type_ = 10; UPDATE data_universe SET PriValQuotePermID = 236801655534.0, PriInstrPermID = 232888672663.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0 WHERE SecCode = 6627674 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = 'BVMLJ7', PermSecMapEndDate = '2026-01-17', endDate = '2026-01-17' WHERE SecCode = 11015187 AND Type_ = 1; UPDATE data_universe SET PermQuoteRetireDate = '2026-01-20' WHERE SecCode = 11111522 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = 'BVMLMD', PermSecMapEndDate = '2026-01-17', endDate = '2026-01-17' WHERE SecCode = 11152692 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = 'BVMLJN', PermSecMapEndDate = '2026-01-17', endDate = '2026-01-17' WHERE SecCode = 11180147 AND Type_ = 1; UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NOVA', RkdSEDOL = 'BVMLMG', PermSecMapEndDate = '2026-01-17', endDate = '2026-01-17' WHERE SecCode = 11197041 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG216211345', RkdSEDOL = 'BVMLJ8', RkdCUSIP = 'G2162113', PermSecMapEndDate = '2026-01-17', endDate = '2026-01-17' WHERE SecCode = 11199544 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'DNTL.TO^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-19', PermQuoteRetireDate = '2026-01-19', endDate = '2026-01-19' WHERE SecCode = 11224513 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA74449F4078', RkdSEDOL = 'BVMLHZ', RkdCUSIP = '74449F40', PermSecMapEndDate = '2026-01-17', endDate = '2026-01-17' WHERE SecCode = 11235543 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US83006G5009', RkdSEDOL = 'BVMLJD', RkdCUSIP = '83006G50', PermSecMapEndDate = '2026-01-17', endDate = '2026-01-17' WHERE SecCode = 11253812 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'PDC' WHERE SecCode = 11255441 AND Type_ = 1; UPDATE data_universe SET SecMapStartDate = '2019-10-03', PermSecMapStartDate = '2024-10-15' WHERE SecCode = 11274294 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232896894814.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11285376 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232896894814.0, IsPrimaryInstr = 1.0, startDate = '2025-09-30' WHERE SecCode = 11286900 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232897977459.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11288811 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232898990925.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11289422 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11289560 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236801673020.0, PriTrdQuotePermID = 236801673020.0, ExchCode = 'NYS', PermSecMapStartDate = '2026-01-16', startDate = '2026-01-08' WHERE SecCode = 11290373 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236797714770.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11290725 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236801673041.0, PriTrdQuotePermID = 236801673041.0, PriValQuotePermID = 25727039790.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS' WHERE SecCode = 11290726 AND Type_ = 1;