UPDATE data_universe_permid SET QuotePermID = 55838299316, PermQuoteStatus = 'DC', Ticker = 'GL9.IE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836386343, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-31' WHERE SecCode = 34403 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-24' WHERE SecCode = 42292 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838259203, ExchCode = 'CHI' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853561637, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531592, ExchCode = 'FRA' WHERE SecCode = 46521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690620527, ExchCode = 'RTB' WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836582583, ExchCode = 'FRA' WHERE SecCode = 48131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589978418.0, IsPrimaryInstr = 1 WHERE SecCode = 51573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487328, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 52586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642496474, ExchCode = 'BTE' WHERE SecCode = 52632 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584354094, ExchCode = 'TDG', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 54284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399700, ExchCode = 'FRA', PermQuoteRetireDate = '2016-02-12' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836518711, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852348972, ExchCode = 'FRA' WHERE SecCode = 60667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168808, Ticker = 'PNPd', ExchCode = 'BCO', PermSecMapStartDate = '2026-04-20' WHERE SecCode = 61754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474898042, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 61930 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 69936 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'TRLED' WHERE SecCode = 71190 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 78996 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 86169 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 87690 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 89087 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-24' WHERE SecCode = 99726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538510584, Ticker = 'XPBRe', ExchCode = 'BCO' WHERE SecCode = 102966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784382991, ExchCode = 'LAS' WHERE SecCode = 104387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822354, ExchCode = 'DEU' WHERE SecCode = 111811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285133, ExchCode = 'FRA' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704207, ExchCode = 'MXQ' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838555485, Ticker = 'NKS', PermQuoteRetireDate = '2016-11-09' WHERE SecCode = 113662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585674844, ExchCode = 'TDG' WHERE SecCode = 114455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793968540, ExchCode = 'FRA' WHERE SecCode = 115232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590303368, ExchCode = 'DEU' WHERE SecCode = 115234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508449990, ExchCode = 'MUN', PermQuoteRetireDate = '2018-12-12' WHERE SecCode = 115464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22054464761, ExchCode = 'DEU' WHERE SecCode = 115623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502331238, ExchCode = 'STU' WHERE SecCode = 115781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546350235, Ticker = 'FNZ', ExchCode = 'TDG', PermQuoteRetireDate = '2019-08-29', PermSecMapEndDate = '2020-01-06' WHERE SecCode = 116225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510687264, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-13', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 116327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504953547, Ticker = 'MHSA', ExchCode = 'GER', PermQuoteRetireDate = '2012-12-18' WHERE SecCode = 116974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712125220, ExchCode = 'FRA' WHERE SecCode = 122073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705320, ExchCode = 'MXQ' WHERE SecCode = 124586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666123478, ExchCode = 'DEU' WHERE SecCode = 126859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957764680, ExchCode = 'FRA' WHERE SecCode = 131976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520192730, ExchCode = 'STU' WHERE SecCode = 138101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379894, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 138103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556785810, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-24' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624377344, ExchCode = 'FRA' WHERE SecCode = 140068 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591385, ExchCode = 'DEU' WHERE SecCode = 140677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152236300, ExchCode = 'DEU' WHERE SecCode = 141403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747499806, ExchCode = 'DEU' WHERE SecCode = 141410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077651, ExchCode = 'LAS' WHERE SecCode = 141439 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 141833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475720989, Ticker = 'G0660', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 145816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539524247, Ticker = 'GKNd', ExchCode = 'BCO', PermQuoteRetireDate = '2018-09-20' WHERE SecCode = 147413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273265, ExchCode = 'GTX', PermQuoteRetireDate = '2025-11-26', PermSecMapEndDate = '2025-11-10' WHERE SecCode = 164342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704537, ExchCode = 'MXQ' WHERE SecCode = 201842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168805, Ticker = 'NRAd', ExchCode = 'BCO', PermSecMapStartDate = '2026-04-20' WHERE SecCode = 202621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498931242, ExchCode = 'FRA' WHERE SecCode = 202935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521985590, ExchCode = 'STU', PermQuoteRetireDate = '2017-04-04' WHERE SecCode = 203925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837356986, ExchCode = 'GER' WHERE SecCode = 248774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175400014, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-23', PermSecMapEndDate = NULL WHERE SecCode = 249305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856726590, ExchCode = 'STU' WHERE SecCode = 249354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535831521, ExchCode = 'STU', PermQuoteRetireDate = '2020-04-15' WHERE SecCode = 249365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847021469, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474844752, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 249377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528277070, ExchCode = 'FRA' WHERE SecCode = 249402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526396050, ExchCode = 'FRA' WHERE SecCode = 249427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805754406, ExchCode = 'MUN' WHERE SecCode = 249668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474900132, ExchCode = 'DEU' WHERE SecCode = 283709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836493793, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 283718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357857, ExchCode = 'DUS' WHERE SecCode = 289443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329561, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 289461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782646010, ExchCode = 'STU' WHERE SecCode = 295269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419292, ExchCode = 'HAM' WHERE SecCode = 295285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327296, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485013, ExchCode = 'QTX' WHERE SecCode = 309339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320647, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 316450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320604, ExchCode = 'BER' WHERE SecCode = 326661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503112746, ExchCode = 'TDG', PermQuoteRetireDate = '2015-12-08' WHERE SecCode = 333182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175399989, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-23', PermSecMapEndDate = NULL WHERE SecCode = 344774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900497, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 345092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538771200, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-20' WHERE SecCode = 345094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839294318, ExchCode = 'GTX' WHERE SecCode = 345100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834800221, Ticker = NULL, ExchCode = 'HKG', PermQuoteRetireDate = '2018-04-24' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835817375, ExchCode = 'MEX' WHERE SecCode = 349684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348908, ExchCode = 'FRA' WHERE SecCode = 353324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475432906, Ticker = '0FCC', ExchCode = 'LSE', PermQuoteRetireDate = '2009-12-10' WHERE SecCode = 374930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620916416, ExchCode = 'TDG' WHERE SecCode = 375326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781439239, ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-21' WHERE SecCode = 391170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877137536, ExchCode = 'MUN' WHERE SecCode = 391171 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-24' WHERE SecCode = 391296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388965, Ticker = 'ZIM.RO', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 408476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475472362, ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 408478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955877, ExchCode = 'TDG' WHERE SecCode = 412853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822777044, ExchCode = 'DUS' WHERE SecCode = 413132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523795704, ExchCode = 'STU' WHERE SecCode = 424779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843288026, ExchCode = 'BER' WHERE SecCode = 424919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843194281, ExchCode = 'FRA' WHERE SecCode = 425031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474878624, Ticker = '0KJT', ExchCode = 'LSE', PermQuoteRetireDate = '2010-07-26' WHERE SecCode = 425350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843333402, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-08' WHERE SecCode = 425411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953597671, ExchCode = 'DUS' WHERE SecCode = 432012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845312523, ExchCode = 'FRA' WHERE SecCode = 436499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853026615, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 442574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475022130, ExchCode = 'DEU' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704447, ExchCode = 'MXQ' WHERE SecCode = 508999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608722355, ExchCode = 'STU' WHERE SecCode = 512041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521102408, Ticker = '0GA', ExchCode = 'STU', PermQuoteRetireDate = '2017-04-28' WHERE SecCode = 513937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849681520, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 514961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541088571, ExchCode = 'STU' WHERE SecCode = 515043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850070208, ExchCode = 'FRA' WHERE SecCode = 518549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486670573, ExchCode = 'STU' WHERE SecCode = 519427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920961818, ExchCode = 'FRA' WHERE SecCode = 519511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323211, PermQuoteStatus = 'DC', Ticker = 'AU3', ExchCode = 'BER', PermQuoteRetireDate = '2016-11-25' WHERE SecCode = 519515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296198, ExchCode = 'GTX' WHERE SecCode = 524403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886808270, ExchCode = 'MUN' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475845507, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 533522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851360620, ExchCode = 'FRA', PermQuoteRetireDate = '2019-02-21' WHERE SecCode = 535417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849997680, Ticker = 'SBUL', ExchCode = 'MIL' WHERE SecCode = 536401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475422413, Ticker = 'FISKS.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2009-09-03' WHERE SecCode = 536734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478626, ExchCode = 'QTX' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522030496, ExchCode = 'TDG' WHERE SecCode = 541495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856846841, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 541974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307223, ExchCode = 'MEX' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799025517, ExchCode = 'MUN' WHERE SecCode = 542943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853456463, ExchCode = 'STU' WHERE SecCode = 551262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806171276, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-24', PermSecMapEndDate = NULL WHERE SecCode = 552845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531115944, Ticker = '6CMBd', ExchCode = 'BCO' WHERE SecCode = 552948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790387228, ExchCode = 'STU', PermQuoteRetireDate = '2023-01-12', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 553921 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-23' WHERE SecCode = 555050 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589978418.0, IsPrimaryInstr = 1 WHERE SecCode = 555895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981295, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 556230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471152, ExchCode = 'GTX' WHERE SecCode = 556254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856214006, ExchCode = 'GER' WHERE SecCode = 558032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575565347, ExchCode = 'STU', PermQuoteRetireDate = '2018-04-26' WHERE SecCode = 560723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856428988, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 564417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864886870, ExchCode = 'MUN' WHERE SecCode = 565861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704751, Ticker = 'FBRN', ExchCode = 'MXQ' WHERE SecCode = 572386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566935915, ExchCode = 'STU' WHERE SecCode = 575072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835820729, ExchCode = 'MEX' WHERE SecCode = 580079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704164, ExchCode = 'MXQ' WHERE SecCode = 580373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981529, ExchCode = 'HAM', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 583151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475660385, InstrPermID = 8590922012, OrgPermID = 4295880615, ValQuotePermID = 55837430854.0, PriInstrPermID = 8590922012.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'YFM', ExchCode = 'GER', PermQuoteRetireDate = '2010-03-29', PermOrgIPODate = NULL WHERE SecCode = 601515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531671030, ExchCode = 'STU' WHERE SecCode = 604212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647852573, ExchCode = 'STU' WHERE SecCode = 607486 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 610640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859812767, Ticker = 'SVV', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 637382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863402759, Ticker = 'OCSP', ExchCode = 'LSE' WHERE SecCode = 649936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290783, ExchCode = 'DUS' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492850, ExchCode = 'QTX' WHERE SecCode = 837909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428184, ExchCode = 'GTX' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475136959, ExchCode = 'DEU' WHERE SecCode = 858901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610380111, ExchCode = 'DEU' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55867148469, Ticker = 'XSIL', ExchCode = 'SWX' WHERE SecCode = 880290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22103473248, ExchCode = 'DEU' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492656, ExchCode = 'QTX' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785297550, ExchCode = 'QTX' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494700995, ExchCode = 'FRA' WHERE SecCode = 982229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800222853, ExchCode = 'FRA' WHERE SecCode = 1017380 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 1260133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797722, ExchCode = 'QTX' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478443280, ExchCode = 'FRA' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1465035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494566098, ExchCode = 'STU' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802786, Ticker = 'PU7D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488652814, ExchCode = 'FRA' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536289548, ExchCode = 'DEU' WHERE SecCode = 1524628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497908, ExchCode = 'FRA' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723938629, ExchCode = 'QTX' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490780237, ExchCode = 'FRA' WHERE SecCode = 1529275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492888711, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-25' WHERE SecCode = 1537137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492890481, ExchCode = 'STU' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800721447, ExchCode = 'FRA' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494700973, ExchCode = 'FRA' WHERE SecCode = 1544114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761654684, ExchCode = 'TDG' WHERE SecCode = 1544731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606227693, ExchCode = 'STU' WHERE SecCode = 1547496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501626987, ExchCode = 'STU' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502126157, ExchCode = 'STO' WHERE SecCode = 1570494 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563046129, ExchCode = 'DEU' WHERE SecCode = 1570622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632884533, ExchCode = 'MUN', PermQuoteRetireDate = '2018-10-05' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234899, ExchCode = 'QTX' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529361618, ExchCode = 'STU' WHERE SecCode = 1618089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507269905, ExchCode = 'FRA' WHERE SecCode = 1618200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510005786, ExchCode = 'FRA' WHERE SecCode = 1653506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512104207, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-09' WHERE SecCode = 1655572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627697, ExchCode = 'QTX' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312304, ExchCode = 'GTX' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511181364, ExchCode = 'TDG' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513074271, ExchCode = 'DEU' WHERE SecCode = 1720504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513762717, ExchCode = 'FRA' WHERE SecCode = 1736071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628061495, ExchCode = 'DEU' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480142, ExchCode = 'QTX' WHERE SecCode = 1778982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285770, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515423659, ExchCode = 'DEU' WHERE SecCode = 1967460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-24' WHERE SecCode = 1992885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531135778, ExchCode = 'BCO' WHERE SecCode = 2073367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659437, ExchCode = 'GTX' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337983, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2126923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519818958, ExchCode = 'DEU' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379476, ExchCode = 'LAS', PermQuoteRetireDate = '2026-01-27', PermSecMapEndDate = NULL WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143697, Ticker = '2KPN', ExchCode = 'MIL' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386834, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524070827, ExchCode = 'FRA' WHERE SecCode = 2240608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869920397, ExchCode = 'MUN' WHERE SecCode = 2255684 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 2270008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576247697, ExchCode = 'FRA' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675187, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525642309, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-10' WHERE SecCode = 2279777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045908023, ExchCode = 'MEX' WHERE SecCode = 2337158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371665, ExchCode = 'SGO' WHERE SecCode = 2377498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538681, ExchCode = 'FRA' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517626184, ExchCode = 'MUN' WHERE SecCode = 2448345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487244, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842579738, ExchCode = 'BER' WHERE SecCode = 2458822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815141967, ExchCode = 'MUN' WHERE SecCode = 2511591 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798387416, ExchCode = 'HAM' WHERE SecCode = 2518731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369915, ExchCode = 'BEC' WHERE SecCode = 2524085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591563754, ExchCode = 'BCO', PermQuoteRetireDate = '2026-03-18' WHERE SecCode = 2527880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545188944, ExchCode = 'STU' WHERE SecCode = 2532821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492002, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 2532826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587290079, ExchCode = 'STU' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707494401, ExchCode = 'TDG' WHERE SecCode = 2543647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103168, ExchCode = 'FRA', PermQuoteRetireDate = '2018-11-29' WHERE SecCode = 2543648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370135, ExchCode = 'SGO' WHERE SecCode = 2545788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489728, ExchCode = 'QTX' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544722891, ExchCode = 'STU' WHERE SecCode = 2556581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729890729, ExchCode = 'DEU' WHERE SecCode = 2556600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542003936, ExchCode = 'FRA', PermQuoteRetireDate = '2015-05-21' WHERE SecCode = 2560597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541408600, ExchCode = 'BER', PermQuoteRetireDate = '2023-07-17', PermSecMapEndDate = NULL WHERE SecCode = 2560601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543102507, ExchCode = 'FRA' WHERE SecCode = 2579445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575706654, ExchCode = 'STU' WHERE SecCode = 2579449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806167421, ExchCode = 'STU' WHERE SecCode = 2585352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369809, ExchCode = 'SGO' WHERE SecCode = 2598717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067757998, Ticker = '3HCSm', ExchCode = 'BCO' WHERE SecCode = 2600076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067641975, ExchCode = 'CHI' WHERE SecCode = 2600378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675457, ExchCode = 'BIV' WHERE SecCode = 2604399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609149462, Ticker = '3ITS', ExchCode = 'LSE' WHERE SecCode = 2604404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704472, ExchCode = 'MXQ' WHERE SecCode = 2605847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659522, ExchCode = 'LAS' WHERE SecCode = 2605870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634474245, ExchCode = 'MUN' WHERE SecCode = 2616461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676610, ExchCode = 'BIV' WHERE SecCode = 2623720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546608346, ExchCode = 'BER' WHERE SecCode = 2628627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690033967, ExchCode = 'MUN' WHERE SecCode = 2628651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544951945, ExchCode = 'STU' WHERE SecCode = 2635770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547450530, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2636990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288297, ExchCode = 'GTX' WHERE SecCode = 2644157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789432566, ExchCode = 'GTX' WHERE SecCode = 2644161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549052746, ExchCode = 'FRA' WHERE SecCode = 2655940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840232, ExchCode = 'FRA' WHERE SecCode = 2655948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451656, PermQuoteStatus = 'DC', Ticker = 'BIDU', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28' WHERE SecCode = 2679897 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-23' WHERE SecCode = 2695647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792941402, ExchCode = 'DEU', PermQuoteRetireDate = '2025-06-25', PermSecMapEndDate = '2025-06-25' WHERE SecCode = 2706346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617877526, Ticker = 'BWOv', ExchCode = 'EBT', PermQuoteRetireDate = '2021-06-01' WHERE SecCode = 2710438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570849268, ExchCode = 'DUS' WHERE SecCode = 2711155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676401, ExchCode = 'BIV' WHERE SecCode = 2812158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557544156, ExchCode = 'FRA' WHERE SecCode = 2817416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558155337, ExchCode = 'FRA' WHERE SecCode = 2823565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21716468870, ExchCode = 'DEU' WHERE SecCode = 2824459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289547, PermQuoteStatus = 'AC', Ticker = '8PSG', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560976379, ExchCode = 'FRA' WHERE SecCode = 2857038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952406, ExchCode = 'FRA' WHERE SecCode = 2858567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599175171, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2861791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460777, ExchCode = 'FRA' WHERE SecCode = 2864471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563864602, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2024-03-15' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561682172, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677051, ExchCode = 'BIV' WHERE SecCode = 2876241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674050, ExchCode = 'BIV' WHERE SecCode = 2889050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479042, ExchCode = 'QTX' WHERE SecCode = 2905610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564680222, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-19' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564938913, ExchCode = 'DEU' WHERE SecCode = 2909928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565148442, ExchCode = 'MUN' WHERE SecCode = 2911859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566806429, ExchCode = 'DEU' WHERE SecCode = 2930976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567022234, ExchCode = 'FRA', PermQuoteRetireDate = '2019-05-27', PermSecMapEndDate = NULL WHERE SecCode = 2932394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569151527, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2952372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704396, ExchCode = 'MXQ' WHERE SecCode = 2963604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687895439, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3008027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285644, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800738271, ExchCode = 'QTX' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929444790, ExchCode = 'QTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679777, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3177778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786342003, Ticker = 'XMW2', ExchCode = 'STU' WHERE SecCode = 3198718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720719093, ExchCode = 'BER', PermQuoteRetireDate = '2023-10-02', PermSecMapEndDate = NULL WHERE SecCode = 3215568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599860813, ExchCode = 'FRA', PermQuoteRetireDate = '2024-07-11' WHERE SecCode = 3242031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011205, Ticker = '2UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301751, Ticker = '0EF', ExchCode = 'GTX' WHERE SecCode = 3246454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100410, ExchCode = 'QTX' WHERE SecCode = 3247170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597458276, ExchCode = 'BER', PermQuoteRetireDate = '2020-07-27' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597702395, ExchCode = 'FRA' WHERE SecCode = 3260047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602047603, ExchCode = 'MUN' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611219951, ExchCode = 'MUN', PermQuoteRetireDate = '2017-12-22' WHERE SecCode = 3297215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546129, ExchCode = 'MUN' WHERE SecCode = 3308987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609327640, ExchCode = 'FRA', PermQuoteRetireDate = '2023-07-04' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388165, ExchCode = 'LAS' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133418, ExchCode = 'FRA' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482861, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611445381, ExchCode = 'DEU' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615298321, ExchCode = 'TRQ' WHERE SecCode = 3358414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793387209, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3358543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011585, Ticker = '2EVK', ExchCode = 'MIL' WHERE SecCode = 3358919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22098741670, ExchCode = 'CHI' WHERE SecCode = 3359183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100723, ExchCode = 'DUS' WHERE SecCode = 3378195 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663294277, ExchCode = 'MUN', PermQuoteRetireDate = '2022-09-12' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624542752, ExchCode = 'DEU' WHERE SecCode = 3400265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100517, ExchCode = 'QTX' WHERE SecCode = 3401365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932183, ExchCode = 'FRA' WHERE SecCode = 3401402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625006753, ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-30', PermSecMapEndDate = '2017-10-30' WHERE SecCode = 3402759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097182, ExchCode = 'LAS' WHERE SecCode = 3405304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628937008, ExchCode = 'TDG' WHERE SecCode = 3405439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816905223, PermQuoteStatus = 'DC', Ticker = 'S06', ExchCode = 'TDG', PermQuoteRetireDate = '2023-10-13' WHERE SecCode = 3406028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168120, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-23', PermSecMapEndDate = NULL WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901491943, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932291, ExchCode = 'FRA' WHERE SecCode = 3409373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353175, ExchCode = 'FRA' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705440, ExchCode = 'MXQ' WHERE SecCode = 3446301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071844, ExchCode = 'FRA', PermQuoteRetireDate = '2019-12-30' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648822392, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-08', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '1UC0' WHERE SecCode = 3491198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675265, ExchCode = 'BIV' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388282, ExchCode = 'LAS', PermQuoteRetireDate = '2025-07-29' WHERE SecCode = 3501431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056989, ExchCode = 'TDG' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803758498, ExchCode = 'STU' WHERE SecCode = 3531554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830259734, ExchCode = 'TDG' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452965, ExchCode = 'FRA' WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796358598, ExchCode = 'TDG' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656740299, Ticker = 'DNKl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-01-20' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3558196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731163509, ExchCode = 'FRA' WHERE SecCode = 3584663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544508318, ExchCode = 'STU' WHERE SecCode = 3587041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757667031, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 3588020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598347923, ExchCode = 'AUX' WHERE SecCode = 3588027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597445922, ExchCode = 'MEX' WHERE SecCode = 3588038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660609678, ExchCode = 'DEU' WHERE SecCode = 3588082 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296175, ExchCode = 'GTX' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731995361, ExchCode = 'DEU' WHERE SecCode = 3588110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544661, ExchCode = 'DUS' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661179149, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787436, ExchCode = 'DUS' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706067030, ExchCode = 'CHI', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731983529, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3615233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759798879, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 3615235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667209671, ExchCode = 'DEU' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667202566, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668158989, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 3644463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669468854, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690033954, ExchCode = 'MUN' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672709111, ExchCode = 'FRA' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670410338, Ticker = 'ROAI', ExchCode = 'SWX', PermQuoteRetireDate = '2023-09-22' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293822, ExchCode = 'GTX' WHERE SecCode = 3657811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672845652, ExchCode = 'FRA' WHERE SecCode = 3675648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675091688, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3690817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21676208303, ExchCode = 'BER' WHERE SecCode = 3725474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679877079, ExchCode = 'FRA' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383886, ExchCode = 'MEX' WHERE SecCode = 3732368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947054171, ExchCode = 'FRA' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685868276, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380275, ExchCode = 'LAS' WHERE SecCode = 3787147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687895438, ExchCode = 'STU' WHERE SecCode = 3793375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198305, ExchCode = 'DEU' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734047256, ExchCode = 'TDG' WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496810, ExchCode = 'DUS' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690339113, ExchCode = 'TDG' WHERE SecCode = 3809861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527695, ExchCode = 'FRA' WHERE SecCode = 3818167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21665888063 WHERE SecCode = 3827938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932282, ExchCode = 'DEU' WHERE SecCode = 3827962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789617001, ExchCode = 'BIV' WHERE SecCode = 3827965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21697686068, Ticker = 'BM51', ExchCode = 'BER', PermQuoteRetireDate = '2022-05-17' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734634078, ExchCode = 'STU' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696168646, ExchCode = 'DEU' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659513, PermQuoteStatus = 'AC', Ticker = '2ZT1', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371245, ExchCode = 'BIV' WHERE SecCode = 3851577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787746616, ExchCode = 'SIU', PermQuoteRetireDate = '2025-01-04' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 3865549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702351475, ExchCode = 'DEU', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938950149, Ticker = 'UPRl', ExchCode = 'BCO' WHERE SecCode = 3883708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789792374, ExchCode = 'DUS' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209289, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820576474, ExchCode = 'DUS' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383362, ExchCode = 'MEX' WHERE SecCode = 3934323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812338413, ExchCode = 'MUN' WHERE SecCode = 3951450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712452863, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3955660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715393197, ExchCode = 'DEU' WHERE SecCode = 3977296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817666768, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4001066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298922, ExchCode = 'GTX' WHERE SecCode = 4004564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403388, ExchCode = 'FRA' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720015410, PermQuoteStatus = 'AC', Ticker = '0XM1', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4007107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843603104, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4008980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377491, ExchCode = 'BIV' WHERE SecCode = 4022727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011925, Ticker = '2BAC' WHERE SecCode = 4031699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027148, Ticker = '1DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010228, Ticker = '2FRA' WHERE SecCode = 4031875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143843, Ticker = '2HEIA', ExchCode = 'MIL' WHERE SecCode = 4031893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011235, Ticker = '2IAG' WHERE SecCode = 4032120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822947768, Ticker = '4DSY', ExchCode = 'ETX' WHERE SecCode = 4032132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723633857, ExchCode = 'STU' WHERE SecCode = 4032148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723632161, ExchCode = 'DEU' WHERE SecCode = 4032154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184457, ExchCode = 'SIU' WHERE SecCode = 4033113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634821003, Ticker = 'OCPETb', ExchCode = 'BCO', PermQuoteRetireDate = '2024-01-31' WHERE SecCode = 4046600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652454, ExchCode = 'FRA' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980198475, ExchCode = 'DEU' WHERE SecCode = 4046667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729412273, ExchCode = 'DEU' WHERE SecCode = 4059429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729412250, ExchCode = 'DEU', PermQuoteRetireDate = '2025-09-03', PermSecMapEndDate = '2025-09-03' WHERE SecCode = 4062000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732154152, ExchCode = 'FRA' WHERE SecCode = 4080678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739862119, PermQuoteStatus = 'DC', Ticker = 'JARUl', ExchCode = 'MAA', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818713443, PermQuoteStatus = 'DC', Ticker = '4E40', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 4101126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587301011, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735442278, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4106680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383364, ExchCode = 'TDG' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787721995, ExchCode = 'MUN' WHERE SecCode = 4110887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586975, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21740303517, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14', PermSecMapEndDate = NULL WHERE SecCode = 4124848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674204, ExchCode = 'BIV' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745664579, ExchCode = 'STU' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745628089, PermQuoteStatus = 'AC', Ticker = 'Z62', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488857, ExchCode = 'STU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679079, ExchCode = 'BIV' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349456, ExchCode = 'MEX' WHERE SecCode = 4228288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749841407, ExchCode = 'FRA' WHERE SecCode = 4228324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754379229, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4253036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754200423, ExchCode = 'FRA' WHERE SecCode = 4253037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754533500, ExchCode = 'FRA' WHERE SecCode = 4256876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534208, PermQuoteStatus = 'AC', Ticker = '0YL0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4259224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534080, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-07', PermSecMapEndDate = '2023-11-07' WHERE SecCode = 4259226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349639, ExchCode = 'BIV' WHERE SecCode = 4259231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755406183, ExchCode = 'DEU' WHERE SecCode = 4267228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756148826, ExchCode = 'MXQ' WHERE SecCode = 4273980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756548990, ExchCode = 'FRA' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757456175, ExchCode = 'FRA' WHERE SecCode = 4277594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763122567, PermQuoteStatus = 'AC', Ticker = '9EG0', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760599386, ExchCode = 'FRA' WHERE SecCode = 4303570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011157, Ticker = '2SPOT' WHERE SecCode = 4309035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143914, Ticker = '2TKWY', ExchCode = 'MIL' WHERE SecCode = 4309036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010963, Ticker = '2AMS' WHERE SecCode = 4309037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011282, Ticker = '2NB' WHERE SecCode = 4309038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143959, Ticker = '2RMS', ExchCode = 'MIL' WHERE SecCode = 4309039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143858, Ticker = '2ASM', ExchCode = 'MIL' WHERE SecCode = 4309043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012280, Ticker = '2FSLR' WHERE SecCode = 4309045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432057, ExchCode = 'DEU' WHERE SecCode = 4309050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709366460, ExchCode = 'BIV' WHERE SecCode = 4324371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727341342, ExchCode = 'BIV' WHERE SecCode = 4324380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771445002, ExchCode = 'QTX' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877510586, ExchCode = 'MUN' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772839734, ExchCode = 'DEU' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538206, ExchCode = 'GTX' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606760, ExchCode = 'DEU' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510674, ExchCode = 'QTX' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452791, ExchCode = 'FRA' WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960079950, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870599, ExchCode = 'FRA' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826495190, ExchCode = 'DUS' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780150286, ExchCode = 'MUN' WHERE SecCode = 4400153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780353097, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999209, ExchCode = 'DEU' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685893, PermQuoteStatus = 'AC', Ticker = '60P0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790867954, ExchCode = 'STU' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793674463, ExchCode = 'DUS' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793526925, ExchCode = 'QTX' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896842819, ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-07' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780165906, ExchCode = 'MXQ' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956106, Ticker = '0A6Nl', ExchCode = 'BCO' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409262, ExchCode = 'FRA' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955219315, ExchCode = 'TDG' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851675957, ExchCode = 'STU' WHERE SecCode = 4526144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627749, ExchCode = 'QTX' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803607182, ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-11', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802587261, ExchCode = 'STU' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219724, ExchCode = 'DEU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219797, ExchCode = 'DEU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786141623, ExchCode = 'MXQ' WHERE SecCode = 4547978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271946, ExchCode = 'BIV' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806535085, ExchCode = 'MUN' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806748726, ExchCode = 'FRA' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807446197, ExchCode = 'FRA', PermQuoteRetireDate = '2025-08-04', PermSecMapEndDate = '2025-08-04' WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381354, ExchCode = 'LAS' WHERE SecCode = 4557929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144478, ExchCode = 'FRA' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286428, ExchCode = 'GTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812606578, ExchCode = 'MUN', PermQuoteRetireDate = '2021-05-18' WHERE SecCode = 4589403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881522351, ExchCode = 'MUN' WHERE SecCode = 4601728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816245393, ExchCode = 'MUN' WHERE SecCode = 4601736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814722256, ExchCode = 'DEU' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815153830, ExchCode = 'FRA' WHERE SecCode = 4603534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275562, ExchCode = 'GTX' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-24' WHERE SecCode = 4612250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800012350, ExchCode = 'LAS' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818266412, ExchCode = 'DEU' WHERE SecCode = 4617743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527622, ExchCode = 'FRA' WHERE SecCode = 4618010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968004, ExchCode = 'FRA' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820389350, ExchCode = 'FRA' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281505, ExchCode = 'DUS' WHERE SecCode = 4632109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854881328, ExchCode = 'GTX' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21934228224, ExchCode = 'STU', PermQuoteRetireDate = '2025-02-07', PermSecMapEndDate = NULL WHERE SecCode = 4643054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914249, ExchCode = 'MUN' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827621995, ExchCode = 'FRA' WHERE SecCode = 4657695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312374, ExchCode = 'GTX' WHERE SecCode = 4664721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835615671, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832850911, ExchCode = 'FRA' WHERE SecCode = 4689999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619187, Ticker = 'CARBm', ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845076965, Ticker = 'V96', ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = NULL WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727235607, ExchCode = 'MEX' WHERE SecCode = 4709611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799043657, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381548, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852456548, Ticker = 'VDOT', ExchCode = 'BRN' WHERE SecCode = 4724692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850051602, ExchCode = 'TDG' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867599, ExchCode = 'FRA' WHERE SecCode = 4748505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852753901, Ticker = 'NVIQl', ExchCode = 'TRQ' WHERE SecCode = 4752180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855114065, ExchCode = 'GTX' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552670, ExchCode = 'LAS' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439582, ExchCode = 'MUN', PermQuoteRetireDate = '2021-11-15' WHERE SecCode = 4773786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856710535, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4777235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857142963, ExchCode = 'STU' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857898826, ExchCode = 'FRA' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858471109, ExchCode = 'DEU', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = '2025-06-17' WHERE SecCode = 4787454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788376836, Ticker = 'A6Id', ExchCode = 'BCO' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727216819, ExchCode = 'MEX' WHERE SecCode = 4802294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862298482, ExchCode = 'DEU', PermQuoteRetireDate = '2026-02-10' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886807336, ExchCode = 'GTX', PermQuoteRetireDate = '2025-01-15' WHERE SecCode = 4811144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192644, ExchCode = 'DEU' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778241629, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4819881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865296250, ExchCode = 'TDG' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580393, ExchCode = 'DEU' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580216, ExchCode = 'DUS' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888953884, ExchCode = 'MUN', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 4834793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867754891, ExchCode = 'MUN' WHERE SecCode = 4845006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867751015, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4845007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379540, ExchCode = 'LAS' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398389, ExchCode = 'GER' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398299, ExchCode = 'FRA', PermQuoteRetireDate = '2024-06-13' WHERE SecCode = 4845030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580391, ExchCode = 'FRA' WHERE SecCode = 4845032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871055968, ExchCode = 'GTX' WHERE SecCode = 4845045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885446303, ExchCode = 'GTX' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580179, ExchCode = 'GER' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887747207, ExchCode = 'STU' WHERE SecCode = 4852140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387394, ExchCode = 'LAS' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872584687, ExchCode = 'FRA' WHERE SecCode = 4873679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954831, ExchCode = 'LAS' WHERE SecCode = 4887246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929410708, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874656832, ExchCode = 'DEU' WHERE SecCode = 4889264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047433, ExchCode = 'MUN' WHERE SecCode = 4893298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898654, ExchCode = 'FRA' WHERE SecCode = 4929498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914321191, ExchCode = 'MUN', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 4943410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883516418, ExchCode = 'FRA' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883757511, PermQuoteStatus = 'DC', Ticker = '7U6', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4949680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893301199, ExchCode = 'GTX' WHERE SecCode = 4952512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885447241, ExchCode = 'DUS', PermQuoteRetireDate = '2025-04-22' WHERE SecCode = 4954564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689480, ExchCode = 'FRA' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716228, ExchCode = 'DEU' WHERE SecCode = 4960863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887746961, ExchCode = 'MUN' WHERE SecCode = 4960868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887740504, ExchCode = 'STU' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887564482, ExchCode = 'QTX' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889561153, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4980098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212169, ExchCode = 'MEX' WHERE SecCode = 4980103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100451, ExchCode = 'QTX' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980178367, ExchCode = 'DUS' WHERE SecCode = 5011657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894536981, ExchCode = 'DUS' WHERE SecCode = 5011663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805995535, ExchCode = 'FRA' WHERE SecCode = 5031899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898852880, ExchCode = 'FRA' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902921017, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727380611, Ticker = 'DC4', ExchCode = 'BRN' WHERE SecCode = 5047087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380636, ExchCode = 'LAS' WHERE SecCode = 5047099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209210, ExchCode = 'FRA' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777464944, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5063516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903664236, ExchCode = 'FRA' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663662, ExchCode = 'DEU' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026880, Ticker = '1KDP' WHERE SecCode = 5107765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716268, ExchCode = 'DEU' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416293, ExchCode = 'TDG' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913082644, ExchCode = 'BER' WHERE SecCode = 5129748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535351, ExchCode = 'DEU' WHERE SecCode = 5134589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788969076, ExchCode = 'QTX' WHERE SecCode = 5147805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423065, ExchCode = 'FRA' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807916823, ExchCode = 'MUN' WHERE SecCode = 5161225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843186265, Ticker = '0A60l', ExchCode = 'BCO' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508528400, ExchCode = 'DEU' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730598077, ExchCode = 'FRA' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180699, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667329377, ExchCode = 'DEU' WHERE SecCode = 5161350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727344849, ExchCode = 'BIV' WHERE SecCode = 5161363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387325, ExchCode = 'LAS' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21657632265, Ticker = 'FT5', ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-04' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369386, ExchCode = 'SGO' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348366, ExchCode = 'MEX' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381527, ExchCode = 'LAS' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893559951, Ticker = 'AZPN1*', ExchCode = 'MXQ' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871079564, ExchCode = 'MXQ' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919483609, ExchCode = 'DEU' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561584, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920271921, ExchCode = 'DEU' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920271908, ExchCode = 'DEU' WHERE SecCode = 5166813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380662, ExchCode = 'LAS' WHERE SecCode = 5168258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955191864, ExchCode = 'DUS' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933953345, ExchCode = 'TDG' WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904151, ExchCode = 'BTE' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836196, Ticker = 'AFTTp', ExchCode = 'EQD' WHERE SecCode = 5206274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836113, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5208067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47733359573, ExchCode = 'DEU' WHERE SecCode = 5209761 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5220922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930042387, ExchCode = 'QTX' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951901113, ExchCode = 'MUN' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793845610, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-26' WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779328331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027032, Ticker = '1HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935009046, ExchCode = 'DEU' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381670, ExchCode = 'LAS' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107112, ExchCode = 'BIV' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758789, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = NULL WHERE SecCode = 5283651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633841, ExchCode = 'FRA' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850700539, ExchCode = 'STU' WHERE SecCode = 5403242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777481353, ExchCode = 'FRA' WHERE SecCode = 5422843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777481357, ExchCode = 'FRA' WHERE SecCode = 5422844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921513369, ExchCode = 'QTX', PermQuoteRetireDate = '2024-12-16', PermSecMapEndDate = '2024-12-16' WHERE SecCode = 5434319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778172838, ExchCode = 'FRA' WHERE SecCode = 5454711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834825, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836104, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5506501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619181, ExchCode = 'BTE' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781906283, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5527546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804440435, ExchCode = 'TDG' WHERE SecCode = 5527547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834912, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834847, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591864463, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 5569318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604521803, Ticker = '4BB', ExchCode = 'MUN', PermQuoteRetireDate = '2019-01-10' WHERE SecCode = 5569431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780872941, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-22' WHERE SecCode = 5633493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966434, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-12' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823715, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-15' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823853, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307748, ExchCode = 'BIV' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197816, ExchCode = 'BIV' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782376739, ExchCode = 'FRA' WHERE SecCode = 5712413 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'UN10' WHERE SecCode = 5758213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787198171, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785264814, ExchCode = 'FRA' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22044538463, ExchCode = 'DEU' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421384, ExchCode = 'MEX' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596709, ExchCode = 'FRA' WHERE SecCode = 5839467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601266, ExchCode = 'FRA' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601265, ExchCode = 'FRA' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601263, ExchCode = 'FRA' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804089043, ExchCode = 'QTX' WHERE SecCode = 5853173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785943776, ExchCode = 'FRA' WHERE SecCode = 5907872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784888212, ExchCode = 'MEX' WHERE SecCode = 5907884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786553288, ExchCode = 'FRA' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776334351, ExchCode = 'MEX' WHERE SecCode = 5958705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788253477, ExchCode = 'BIV' WHERE SecCode = 6012746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788847036, ExchCode = 'TDG' WHERE SecCode = 6043475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587649, ExchCode = 'FRA' WHERE SecCode = 6075918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587648, ExchCode = 'FRA' WHERE SecCode = 6075919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571976518, ExchCode = 'SGO' WHERE SecCode = 6095641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789902796, ExchCode = 'FRA' WHERE SecCode = 6095673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370126, ExchCode = 'BEC' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682858978, ExchCode = 'FRA' WHERE SecCode = 6097372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089781512, PermQuoteStatus = 'AC', Ticker = 'A4AN9W', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 6097382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354995, ExchCode = 'BIV' WHERE SecCode = 6097383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085290988, ExchCode = 'MXQ' WHERE SecCode = 6097386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727345443, ExchCode = 'BIV' WHERE SecCode = 6097390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813177418, ExchCode = 'FRA' WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823888, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409290, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6097431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128285, ExchCode = 'BCO' WHERE SecCode = 6097445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999588395, ExchCode = 'TRQ' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790758447, ExchCode = 'FRA' WHERE SecCode = 6153962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790761386, ExchCode = 'FRA' WHERE SecCode = 6153964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22094064244, ExchCode = 'DEU' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791667937, ExchCode = 'BIV' WHERE SecCode = 6226138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794652095, ExchCode = 'STU' WHERE SecCode = 6308671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792988435, ExchCode = 'GTX' WHERE SecCode = 6310651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349910, ExchCode = 'FRA' WHERE SecCode = 6334403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349773, ExchCode = 'GTX' WHERE SecCode = 6334404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349912, ExchCode = 'FRA' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989720, ExchCode = 'MXQ' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655688, ExchCode = 'GER' WHERE SecCode = 6368869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655569, ExchCode = 'FRA' WHERE SecCode = 6368870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655530, ExchCode = 'GER' WHERE SecCode = 6368872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655499, ExchCode = 'FRA' WHERE SecCode = 6368874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297712, ExchCode = 'BIV' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797026587, ExchCode = 'FRA' WHERE SecCode = 6495428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797030657, ExchCode = 'FRA' WHERE SecCode = 6495429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109710, ExchCode = 'QTX' WHERE SecCode = 6501107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365452, ExchCode = 'DEU' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145080, ExchCode = 'DUS' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798202984, ExchCode = 'MUN' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798597964, ExchCode = 'TDG' WHERE SecCode = 6528817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22137771215, ExchCode = 'DEU' WHERE SecCode = 6528818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798270114, ExchCode = 'FRA' WHERE SecCode = 6528824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799207727, ExchCode = 'MUN' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607143, ExchCode = 'SWX' WHERE SecCode = 6578451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238834, ExchCode = 'QTX' WHERE SecCode = 6587160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238832, ExchCode = 'QTX' WHERE SecCode = 6587161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781821981, ExchCode = 'QTX' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-24' WHERE SecCode = 6627673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357085, ExchCode = 'BRN' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173814070, ExchCode = 'TDG' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883770164, ExchCode = 'DEU' WHERE SecCode = 6667833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161742096, ExchCode = 'DEU' WHERE SecCode = 6686042 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161742192, ExchCode = 'DEU' WHERE SecCode = 6686043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803478723, ExchCode = 'DUS' WHERE SecCode = 6686044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161741477, ExchCode = 'DEU' WHERE SecCode = 6686045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161741374, ExchCode = 'DEU' WHERE SecCode = 6686046 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161764453, ExchCode = 'DEU' WHERE SecCode = 6686051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161764414, ExchCode = 'DEU' WHERE SecCode = 6686052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804168533, ExchCode = 'STU' WHERE SecCode = 6724297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536844, ExchCode = 'FRA' WHERE SecCode = 6728367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536839, ExchCode = 'FRA' WHERE SecCode = 6728368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536834, ExchCode = 'FRA' WHERE SecCode = 6728370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536841, ExchCode = 'FRA' WHERE SecCode = 6728371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536846, ExchCode = 'FRA' WHERE SecCode = 6728372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536845, ExchCode = 'FRA' WHERE SecCode = 6728373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536945, ExchCode = 'FRA' WHERE SecCode = 6728374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536835, ExchCode = 'FRA' WHERE SecCode = 6728375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536836, ExchCode = 'FRA' WHERE SecCode = 6728377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536831, ExchCode = 'FRA' WHERE SecCode = 6728378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799175957, ExchCode = 'MEX' WHERE SecCode = 6728383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167303875, ExchCode = 'DUS' WHERE SecCode = 6728389 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 6731960 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-23' WHERE SecCode = 6752853 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 6779463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172748632, ExchCode = 'DEU' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-24' WHERE SecCode = 6782583 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6793550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22096729407, ExchCode = 'STU' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791406431, ExchCode = 'MEX' WHERE SecCode = 6797364 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6802654 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236806104712.0 WHERE SecCode = 6802661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806094055, IsPrimaryQuote = 1, Ticker = 'KMAR', ExchCode = 'OSL' WHERE SecCode = 6802673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101943, ExchCode = 'FRA' WHERE SecCode = 6802840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806102102, ExchCode = 'MEX' WHERE SecCode = 6802842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806102142, ExchCode = 'FRA' WHERE SecCode = 6802844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806102138, ExchCode = 'FRA' WHERE SecCode = 6802846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806102139, ExchCode = 'FRA' WHERE SecCode = 6802847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806102137, ExchCode = 'FRA' WHERE SecCode = 6802848 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-04-23', PermSecMapEndDate = NULL WHERE SecCode = 10776770 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-04-23', PermSecMapEndDate = NULL WHERE SecCode = 11021549 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'MMILD' WHERE SecCode = 11059239 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11192745 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'MACK', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11192883 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-23', PermSecMapEndDate = NULL WHERE SecCode = 11193247 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11211583 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11224863 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11228445 AND Type_ = 1;
UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11260559 AND Type_ = 1;
UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11260969 AND Type_ = 1;
UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11260970 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'DFSLY' WHERE SecCode = 11270444 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11291034 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11291035 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11291037 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11291040 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11291041 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11291044 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11291045 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11291050 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-24', PermSecMapEndDate = '2026-04-24' WHERE SecCode = 11291051 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 47763235542.0 WHERE SecCode = 11291210 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236806104605.0, ValQuotePermID = 25727025530.0, IsPrimaryInstr = 1 WHERE SecCode = 11294834 AND Type_ = 1;
