UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 7504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531136784, Ticker = 'ZHEHl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-08-29' WHERE SecCode = 9121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629381057, Ticker = '0Q1N', ExchCode = 'LSE' WHERE SecCode = 9338 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 9451 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475530716, Ticker = 'OAK', ExchCode = 'VTX', PermQuoteRetireDate = '2006-09-21' WHERE SecCode = 9856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475556855, Ticker = '31QX', ExchCode = 'LSE', PermQuoteRetireDate = '2008-04-25' WHERE SecCode = 9908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 32656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331426, ExchCode = 'BER', PermQuoteRetireDate = '2008-12-30' WHERE SecCode = 34074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358466, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 34155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033744, PermQuoteStatus = 'AC', Ticker = 'AMD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836462028, ExchCode = 'FRA' WHERE SecCode = 35017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051127, ExchCode = 'TDG' WHERE SecCode = 35457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859213206, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521103746, ExchCode = 'STU' WHERE SecCode = 38625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483828644, Ticker = 'EIC', ExchCode = 'STU', PermQuoteRetireDate = '2013-09-17' WHERE SecCode = 38658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325494, ExchCode = 'BER' WHERE SecCode = 38731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950957, Ticker = 'MZN', ExchCode = 'STU', PermQuoteRetireDate = '2020-01-13' WHERE SecCode = 38771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489858, ExchCode = 'QTX', PermQuoteRetireDate = '2025-07-22' WHERE SecCode = 38789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837366352, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 38887 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 43286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624203, Ticker = 'SCXG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475289897, ExchCode = 'GER' WHERE SecCode = 46302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329172, PermQuoteStatus = 'DC', Ticker = 'GVM', ExchCode = 'BER', PermQuoteRetireDate = '2022-07-06' WHERE SecCode = 46388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837356038, ExchCode = 'GER', PermQuoteRetireDate = '2010-05-03' WHERE SecCode = 47291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295342, ExchCode = 'GTX' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243226, Ticker = 'MKA', ExchCode = 'MUN' WHERE SecCode = 48328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485029, ExchCode = 'QTX' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323999, ExchCode = 'BER' WHERE SecCode = 51564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836455246, ExchCode = 'FRA', PermQuoteRetireDate = '2011-10-31' WHERE SecCode = 53520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475417017, ExchCode = 'STU', PermQuoteRetireDate = '2009-11-18' WHERE SecCode = 54686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478545911, Ticker = 'CTV', ExchCode = 'TDG', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 55766 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 = 55838241304, ExchCode = 'MUN', PermQuoteRetireDate = '2011-08-24' WHERE SecCode = 60122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784382500, ExchCode = 'LAS' WHERE SecCode = 60190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328139, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 60233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330718, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 60261 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 60417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836467814, ExchCode = 'FRA', PermQuoteRetireDate = '2011-06-08' WHERE SecCode = 60772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363654, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485966, ExchCode = 'QTX' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659673, ExchCode = 'LAS' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033713, PermQuoteStatus = 'AC', Ticker = 'AK3', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 62376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981064, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 62386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757240136, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 62430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836429999, ExchCode = 'FRA' WHERE SecCode = 62434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474890590, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2017-12-29' WHERE SecCode = 62765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474892813, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 62845 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 70899 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 71468 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-24' WHERE SecCode = 78748 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 79978 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 83801 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 84866 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 85673 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-24' WHERE SecCode = 86007 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2025-09-25' WHERE SecCode = 87347 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 89699 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 94005 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 94296 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'PL9', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 99030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837360475, Ticker = 'SKG', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 104043 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ELV', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 111747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571420277, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 111938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486937555, ExchCode = 'STU' WHERE SecCode = 112025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335260, ExchCode = 'BER' WHERE SecCode = 112035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544726152, ExchCode = 'DEU' WHERE SecCode = 112043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390660, ExchCode = 'FRA' WHERE SecCode = 112049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870865253, ExchCode = 'FRA' WHERE SecCode = 112064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661189444, ExchCode = 'FRA' WHERE SecCode = 112078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000480221, ExchCode = 'DEU' WHERE SecCode = 112079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295811, ExchCode = 'GTX' WHERE SecCode = 112129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419772, ExchCode = 'HAM' WHERE SecCode = 112135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332781, ExchCode = 'BER' WHERE SecCode = 112143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527717624, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488397, ExchCode = 'QTX' WHERE SecCode = 119129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666123478, ExchCode = 'DEU' WHERE SecCode = 126859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451532, Ticker = 'EI', ExchCode = 'SWX' WHERE SecCode = 126877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624077684, ExchCode = 'DEU' WHERE SecCode = 128489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909428, ExchCode = 'DEU' WHERE SecCode = 128495 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-25', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 128769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525789042, ExchCode = 'FRA' WHERE SecCode = 131777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560955107, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 134041 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 135529 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 138119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789195679, ExchCode = 'STU', PermQuoteRetireDate = '2025-01-22', PermSecMapEndDate = NULL WHERE SecCode = 138990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341772, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 139011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655828004, ExchCode = 'FRA', PermQuoteRetireDate = '2023-09-15' WHERE SecCode = 139013 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 140027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475646230, ExchCode = 'FRA', PermQuoteRetireDate = '2013-01-08' WHERE SecCode = 140628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483978392, ExchCode = 'STU', PermQuoteRetireDate = '2019-01-24' WHERE SecCode = 140635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510896217, ExchCode = 'TDG' WHERE SecCode = 143201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633621200, Ticker = '0Y9S', ExchCode = 'LSE' WHERE SecCode = 143694 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-26' WHERE SecCode = 144125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823495681, ExchCode = 'TDG' WHERE SecCode = 144300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629957951, ExchCode = 'TDG' WHERE SecCode = 144320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838587386, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 144351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475073728, PermQuoteStatus = 'AC', Ticker = '0MV8', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 144414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808531456, ExchCode = 'FRA' WHERE SecCode = 144437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22002933391, ExchCode = 'DEU' WHERE SecCode = 144438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059854, ExchCode = 'FRA' WHERE SecCode = 144439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961952139, ExchCode = 'GTX' WHERE SecCode = 144440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334976, ExchCode = 'DEU' WHERE SecCode = 145923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849148091, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 146755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475612875, Ticker = 'MCZG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 147455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112538, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-27', PermSecMapEndDate = NULL WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308280, ExchCode = 'GTX' WHERE SecCode = 147900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308439, ExchCode = 'GTX' WHERE SecCode = 147907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514316877, ExchCode = 'STU' WHERE SecCode = 164791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745304634, ExchCode = 'DEU' WHERE SecCode = 166414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288188, ExchCode = 'FRA' WHERE SecCode = 174875 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 176351 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 176475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334959, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 177219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828052603, ExchCode = 'FRA' WHERE SecCode = 177257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329758, ExchCode = 'BER' WHERE SecCode = 177280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622517895, ExchCode = 'DEU' WHERE SecCode = 177315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856949142, ExchCode = 'GER' WHERE SecCode = 177328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327818, ExchCode = 'BER', PermQuoteRetireDate = '2021-08-23' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330777, ExchCode = 'BER' WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618895145, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 179031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650181, ExchCode = 'DUS' WHERE SecCode = 179171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535118681, ExchCode = 'DEU' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490776, ExchCode = 'QTX' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628831642, ExchCode = 'STU' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788425927, ExchCode = 'LAS' WHERE SecCode = 203057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849054916, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 203070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796328454, PermQuoteStatus = 'AC', Ticker = 'IY3A', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 206847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611365799, ExchCode = 'STU' WHERE SecCode = 249355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476850902, ExchCode = 'TDG' WHERE SecCode = 249426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526392840, ExchCode = 'DEU' WHERE SecCode = 249427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736377950, ExchCode = 'FRA' WHERE SecCode = 249438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237021, ExchCode = 'STU' WHERE SecCode = 249571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598864661, ExchCode = 'STU', PermQuoteRetireDate = '2020-04-15' WHERE SecCode = 249834 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 PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 270236 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836325722, ExchCode = 'BER' WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724373346, ExchCode = 'DEU' WHERE SecCode = 290846 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 294471 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 319110 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2025-09-24', PermSecMapEndDate = NULL WHERE SecCode = 329345 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475510397, PermQuoteStatus = 'DC', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 335172 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 336183 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836321278, ExchCode = 'BER' WHERE SecCode = 353324 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 354680 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 415865 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 418561 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 OrgTypeCode = 'GVTDA' WHERE SecCode = 519149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214201, ExchCode = 'BIV' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672230145, ExchCode = 'DUS' WHERE SecCode = 548626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825883651, ExchCode = 'TDG' WHERE SecCode = 548782 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'PL9' WHERE SecCode = 566622 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2009-12-21' WHERE SecCode = 580355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991501, ExchCode = 'STU' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863112368, Ticker = 'BABC.GB', ExchCode = 'PLU' WHERE SecCode = 703518 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 774326 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'PL9' WHERE SecCode = 1129014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644789470, ExchCode = 'STU' WHERE SecCode = 1303639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482228292, Ticker = 'BLIT', ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-24' WHERE SecCode = 1459433 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1464806 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1496294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591674214, ExchCode = 'TDG' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368530, Ticker = 'PU7D', ExchCode = 'SES', PermQuoteRetireDate = '2018-09-12' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22016709977, ExchCode = 'DEU' WHERE SecCode = 1539178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502889367, ExchCode = 'STU', PermQuoteRetireDate = '2016-07-11' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576116533, ExchCode = 'TDG' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545936600, Ticker = 'AYPi', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 1603990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511796493, ExchCode = 'DEU' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585027678, ExchCode = 'CHI' WHERE SecCode = 1931297 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 1981169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802863785, ExchCode = 'FRA' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915596178, ExchCode = 'BER' WHERE SecCode = 2050473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546935312, ExchCode = 'STU' WHERE SecCode = 2055322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954307391, ExchCode = 'TDG' WHERE SecCode = 2195784 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-25', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 2298762 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2315212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530471925, ExchCode = 'FRA' WHERE SecCode = 2366514 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 2380633 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ELV' WHERE SecCode = 2384507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535535779, ExchCode = 'BTE', PermQuoteRetireDate = '2014-01-28' WHERE SecCode = 2494242 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2494418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696140082, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2522906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540108935, ExchCode = 'STU' WHERE SecCode = 2544431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378729, ExchCode = 'GTX' WHERE SecCode = 2554953 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951262.0 WHERE SecCode = 2569983 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542817473, ExchCode = 'DEU' WHERE SecCode = 2570568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542889448, ExchCode = 'MUN', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 2578855 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951262.0 WHERE SecCode = 2580241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670873, ExchCode = 'ASX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545105822, ExchCode = 'FRA' WHERE SecCode = 2604390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548878301, ExchCode = 'DEU', PermQuoteRetireDate = '2023-08-03' WHERE SecCode = 2650629 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252740, ExchCode = 'BER' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557589734, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-25' WHERE SecCode = 2837420 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 OrgTypeCode = 'GVTDA' WHERE SecCode = 2900752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594331200, ExchCode = 'MUN' WHERE SecCode = 3059437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759241355, ExchCode = 'MUN' WHERE SecCode = 3074354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583964281, ExchCode = 'DEU' WHERE SecCode = 3112921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587662536, ExchCode = 'STU' WHERE SecCode = 3165880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011949508, ExchCode = 'AQX' WHERE SecCode = 3193718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605105387, ExchCode = 'BER', PermQuoteRetireDate = '2019-02-08' WHERE SecCode = 3283717 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'PL9' WHERE SecCode = 3285139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605097537, Ticker = '73M0', ExchCode = 'STU', PermQuoteRetireDate = '2023-11-01' WHERE SecCode = 3295278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605141587, ExchCode = 'TDG' WHERE SecCode = 3295294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22112085792, PermQuoteStatus = 'AC', Ticker = 'SGLDa', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 3301728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288479, ExchCode = 'DEU' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947516, ExchCode = 'STU' WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885786, ExchCode = 'TDG' WHERE SecCode = 3317857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827328140, ExchCode = 'FRA' WHERE SecCode = 3318810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598843090, ExchCode = 'MEX' WHERE SecCode = 3357132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598843075, ExchCode = 'MEX' WHERE SecCode = 3357134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614525598, ExchCode = 'FRA' WHERE SecCode = 3357972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705432, ExchCode = 'MXQ' WHERE SecCode = 3358352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050717, ExchCode = 'FRA' WHERE SecCode = 3358543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616850045, Ticker = '14G0', ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-31' WHERE SecCode = 3366981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186397, ExchCode = 'DEU' WHERE SecCode = 3371968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867520083, ExchCode = 'DEU' WHERE SecCode = 3378316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718461403, Ticker = '0Q1Fl', ExchCode = 'BCO' WHERE SecCode = 3378492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301090, ExchCode = 'GTX' WHERE SecCode = 3379253 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765833817, PermQuoteStatus = 'AC', Ticker = '19U', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622957123, PermQuoteStatus = 'DC', Ticker = 'C5B', ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-19' WHERE SecCode = 3391113 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 3396332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624238995, ExchCode = 'TDG' WHERE SecCode = 3396912 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 = 21667705003, ExchCode = 'MXQ' WHERE SecCode = 3404905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705412, ExchCode = 'MXQ' WHERE SecCode = 3404907 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL WHERE SecCode = 3405556 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951262.0 WHERE SecCode = 3408870 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3408950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850703278, PermQuoteStatus = 'DC', Ticker = 'SOG', ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-02' WHERE SecCode = 3409010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397561, ExchCode = 'FRA' WHERE SecCode = 3409182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 3429555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704376, ExchCode = 'MXQ' WHERE SecCode = 3430658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644531036, PermQuoteStatus = 'AC', Ticker = '1GQd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 3430801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644531032, Ticker = '1JFd', ExchCode = 'BCO', PermQuoteRetireDate = '2022-03-17' WHERE SecCode = 3430802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878856337, ExchCode = 'STU' WHERE SecCode = 3431060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763122579, ExchCode = 'MUN' WHERE SecCode = 3432450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793644583, ExchCode = 'TDG' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643680223, ExchCode = 'BER' WHERE SecCode = 3439542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644789418, Ticker = 'CAS', ExchCode = 'LSE', PermQuoteRetireDate = '2019-03-08' WHERE SecCode = 3446120 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 PriTRBCIndPermID = 4294951262.0 WHERE SecCode = 3456716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652317413, ExchCode = 'TDG' WHERE SecCode = 3473357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749468782, ExchCode = 'FRA' WHERE SecCode = 3503523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056989, ExchCode = 'TDG' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779955765, ExchCode = 'QTX' WHERE SecCode = 3523385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796817245, ExchCode = 'DEU' WHERE SecCode = 3525431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344034, ExchCode = 'QTX' WHERE SecCode = 3529091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803758498, ExchCode = 'STU' WHERE SecCode = 3531554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653736303, ExchCode = 'TDG' WHERE SecCode = 3532701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654291678, ExchCode = 'FRA' WHERE SecCode = 3534921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781272952, ExchCode = 'DUS' WHERE SecCode = 3535855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480112, ExchCode = 'QTX' WHERE SecCode = 3540682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452965, PermQuoteStatus = 'AC', Ticker = '28S0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710951331, ExchCode = 'CHI' WHERE SecCode = 3550579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692715167, ExchCode = 'CHI' WHERE SecCode = 3551896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789697925, ExchCode = 'QTX' WHERE SecCode = 3555055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55866956065, ExchCode = 'BEC' WHERE SecCode = 3587010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879562247, ExchCode = 'GTX' WHERE SecCode = 3587019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731994491, ExchCode = 'FRA' WHERE SecCode = 3588110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872233, ExchCode = 'DEU' WHERE SecCode = 3588112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197226, ExchCode = 'DEU' WHERE SecCode = 3588113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667846371, ExchCode = 'FRA' 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 = 21850059052, ExchCode = 'MUN' WHERE SecCode = 3603358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667209671, ExchCode = 'DEU' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685428815, ExchCode = 'TDG' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918858, ExchCode = 'FRA' WHERE SecCode = 3675860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380265, ExchCode = 'LAS' WHERE SecCode = 3747813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682712565, ExchCode = 'STU' WHERE SecCode = 3756596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520529, ExchCode = 'DEU' WHERE SecCode = 3784710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296352, ExchCode = 'GTX' WHERE SecCode = 3799544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689566285, ExchCode = 'HAM' WHERE SecCode = 3807820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694091502, ExchCode = 'FRA' WHERE SecCode = 3818871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650229, ExchCode = 'DUS' WHERE SecCode = 3829975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694479665, ExchCode = 'TDG' WHERE SecCode = 3830032 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 3831351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918856, ExchCode = 'DEU' WHERE SecCode = 3832752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890002591, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2025-05-26', PermSecMapEndDate = '2025-05-26' WHERE SecCode = 3844919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587917, ExchCode = 'LAS' WHERE SecCode = 3845904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858452393, ExchCode = 'BER' WHERE SecCode = 3849234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369832, ExchCode = 'MEX' WHERE SecCode = 3868466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705621141, ExchCode = 'QTX' WHERE SecCode = 3871754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700880757, ExchCode = 'DEU' WHERE SecCode = 3875222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702365940, ExchCode = 'FRA' WHERE SecCode = 3875223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353726, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3877613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702129365, ExchCode = 'BER', PermQuoteRetireDate = '2021-09-17' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650208, ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-11', PermSecMapEndDate = '2025-02-11' WHERE SecCode = 3888265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727368210, ExchCode = 'MEX' WHERE SecCode = 3890234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849806467, ExchCode = 'DUS' WHERE SecCode = 3894966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773918983, ExchCode = 'BER' WHERE SecCode = 3899638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829123325, ExchCode = 'STU' WHERE SecCode = 3919627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711478411, ExchCode = 'DEU' WHERE SecCode = 3956835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714260910, ExchCode = 'QTX' WHERE SecCode = 3959788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742727, ExchCode = 'HAN' WHERE SecCode = 3977808 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957499828, ExchCode = 'DUS' WHERE SecCode = 3987746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817666768, ExchCode = 'BER' WHERE SecCode = 4001066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720001076, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727361952, ExchCode = 'MEX' WHERE SecCode = 4001279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011932, Ticker = '2BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496271, ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-20' WHERE SecCode = 4034218 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729412273, ExchCode = 'DEU', PermQuoteRetireDate = '2020-01-22', PermSecMapEndDate = '2020-01-22' WHERE SecCode = 4059429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779663, ExchCode = 'MUN' WHERE SecCode = 4081943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907558991, ExchCode = 'MUN' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830064, ExchCode = 'QTX' WHERE SecCode = 4110883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780559871, ExchCode = 'STU' WHERE SecCode = 4134450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520230, ExchCode = 'QTX', PermQuoteRetireDate = '2024-10-03' WHERE SecCode = 4134496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21868559772, ExchCode = 'QTX' WHERE SecCode = 4169151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744442992, ExchCode = 'TDG' WHERE SecCode = 4193439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745350479, ExchCode = 'FRA' WHERE SecCode = 4195339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749833486, ExchCode = 'STU' WHERE SecCode = 4203138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958582, ExchCode = 'FRA' WHERE SecCode = 4209245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858553, ExchCode = 'QTX' WHERE SecCode = 4209248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488857, ExchCode = 'STU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486447, ExchCode = 'DUS' WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888021242, ExchCode = 'GTX' WHERE SecCode = 4248831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534038, ExchCode = 'DUS' WHERE SecCode = 4251502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757455927, ExchCode = 'DEU' WHERE SecCode = 4277594 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951262.0 WHERE SecCode = 4282333 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 4298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342160, ExchCode = 'MEX' WHERE SecCode = 4315098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776247434, ExchCode = 'BER' WHERE SecCode = 4315115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783589639, ExchCode = 'QTX' WHERE SecCode = 4328960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727340441, ExchCode = 'MEX' WHERE SecCode = 4333534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782629845, ExchCode = 'STU', PermQuoteRetireDate = '2025-02-03', PermSecMapEndDate = NULL WHERE SecCode = 4348280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784368317, ExchCode = 'MUN' WHERE SecCode = 4348282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768485393, ExchCode = 'FRA' WHERE SecCode = 4351435 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4388410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777652200, ExchCode = 'FRA', PermQuoteRetireDate = '2025-03-25' WHERE SecCode = 4394756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790861937, ExchCode = 'BER', PermQuoteRetireDate = '2022-06-01', PermSecMapEndDate = NULL WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4396445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312696, ExchCode = 'MEX' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996426, ExchCode = 'BER' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815337125, ExchCode = 'FRA' WHERE SecCode = 4423907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879563641, ExchCode = 'MUN', PermQuoteRetireDate = '2024-03-05', PermSecMapEndDate = '2024-03-05' WHERE SecCode = 4427929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394138, ExchCode = 'STU' WHERE SecCode = 4429683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847714094, ExchCode = 'GTX' WHERE SecCode = 4436993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785716437, ExchCode = 'HAM' WHERE SecCode = 4438384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387348, ExchCode = 'LAS' WHERE SecCode = 4447601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306261, ExchCode = 'MEX' WHERE SecCode = 4456073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791248842, ExchCode = 'FRA' WHERE SecCode = 4462870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789562372, ExchCode = 'FRA' WHERE SecCode = 4463053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727302048, ExchCode = 'BIV' WHERE SecCode = 4463160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796268595, ExchCode = 'QTX' WHERE SecCode = 4485993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805539059, ExchCode = 'QTX' WHERE SecCode = 4491934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823485277, ExchCode = 'STU' WHERE SecCode = 4502501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801053714, ExchCode = 'MUN' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801283028, ExchCode = 'MUN' WHERE SecCode = 4517641 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 4519547 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 4524579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802422923, ExchCode = 'FRA' WHERE SecCode = 4526142 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-25', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 4531983 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 4542550 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 4563414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812659635, ExchCode = 'QTX' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 4574930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819115113, ExchCode = 'DUS' WHERE SecCode = 4592046 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196422, ExchCode = 'DUS' WHERE SecCode = 4593306 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305820, ExchCode = 'BIV' WHERE SecCode = 4597223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275562, ExchCode = 'GTX' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815921838, ExchCode = 'DEU' WHERE SecCode = 4607713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849806471, PermQuoteStatus = 'AC', Ticker = '8900', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 4610043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22107546462, Ticker = 'ABTCa', ExchCode = 'BCO' WHERE SecCode = 4613095 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22007949146, ExchCode = 'DEU' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-25', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 4616837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816901027, ExchCode = 'STU', PermQuoteRetireDate = '2021-06-10' WHERE SecCode = 4620951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819774367, ExchCode = 'DEU' WHERE SecCode = 4623226 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4624288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821858149, ExchCode = 'DEU' WHERE SecCode = 4633101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821858169, ExchCode = 'DEU' WHERE SecCode = 4633105 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 4635265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822791593, ExchCode = 'FRA' WHERE SecCode = 4637756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823782702, ExchCode = 'DUS' WHERE SecCode = 4640283 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-25', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 4653101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839048901, ExchCode = 'MUN' WHERE SecCode = 4657695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795845914, ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233438, ExchCode = 'BIV' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844719378, ExchCode = 'DEU' WHERE SecCode = 4724684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850720248, ExchCode = 'FRA' WHERE SecCode = 4745390 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4751051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867538, ExchCode = 'FRA' WHERE SecCode = 4752212 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4754825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387339, ExchCode = 'LAS' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855820605, ExchCode = 'DEU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856518308, ExchCode = 'FRA' WHERE SecCode = 4777235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857866487, ExchCode = 'MUN' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 4792252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380489, ExchCode = 'LAS' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21626605113, ExchCode = 'STU', PermQuoteRetireDate = '2023-05-15' WHERE SecCode = 4804834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128275, ExchCode = 'BCO' WHERE SecCode = 4806676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862739872, ExchCode = 'FRA' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860858404, ExchCode = 'DEU' WHERE SecCode = 4813526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099419636, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4819878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777156627, ExchCode = 'MUN' WHERE SecCode = 4827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381824, ExchCode = 'LAS' WHERE SecCode = 4845067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872584363, ExchCode = 'FRA' WHERE SecCode = 4873682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21880177757, ExchCode = 'GER' WHERE SecCode = 4925631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881998635, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-25', PermSecMapEndDate = '2022-03-25' WHERE SecCode = 4934327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883533886, ExchCode = 'QTX' WHERE SecCode = 4946223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, PermQuoteStatus = 'DC', Ticker = 'VC91', ExchCode = 'QTX', PermQuoteRetireDate = '2024-09-03' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727200980, ExchCode = 'BIV' WHERE SecCode = 4956738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888705400, ExchCode = 'MUN' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779058751, ExchCode = 'STU' WHERE SecCode = 5004799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897339624, ExchCode = 'FRA' WHERE SecCode = 5025182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902924195, ExchCode = 'BER' WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 5043274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788890733, ExchCode = 'QTX' WHERE SecCode = 5047099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911085, ExchCode = 'MUN' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910179774, ExchCode = 'QTX' WHERE SecCode = 5094355 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236796327838.0 WHERE SecCode = 5144072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561826, ExchCode = 'GTX' WHERE SecCode = 5166540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650249, ExchCode = 'DUS' WHERE SecCode = 5166568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650379, ExchCode = 'QTX' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920795449, ExchCode = 'CHA' WHERE SecCode = 5168048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783316559, ExchCode = 'STU' WHERE SecCode = 5168258 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5189087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928666124, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-02-17' WHERE SecCode = 5209798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930806960, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 5220960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790104332, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938018298, ExchCode = 'FRA' WHERE SecCode = 5277529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107112, ExchCode = 'BIV' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386763, ExchCode = 'LAS' WHERE SecCode = 5292727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956352320, ExchCode = 'TDG' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775732431, ExchCode = 'MEX' WHERE SecCode = 5329511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950815916, ExchCode = 'DEU' WHERE SecCode = 5343552 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-24' WHERE SecCode = 5380510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960524504, ExchCode = 'FRA' WHERE SecCode = 5388849 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-25', PermSecMapEndDate = '2025-09-25' WHERE SecCode = 5427962 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5469639 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5491792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, ExchCode = 'FRA' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22024905249, Ticker = 'SOXL', ExchCode = 'LSE' WHERE SecCode = 5702908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782109056, ExchCode = 'BIV' WHERE SecCode = 5709076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782381254, ExchCode = 'QTX' WHERE SecCode = 5712413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028891058, ExchCode = 'STU' WHERE SecCode = 5726747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037308993, ExchCode = 'DEU' WHERE SecCode = 5786123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037302983, ExchCode = 'DEU' WHERE SecCode = 5786125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783782319, ExchCode = 'STU' WHERE SecCode = 5786132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783963980, ExchCode = 'STU' WHERE SecCode = 5786133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534609, ExchCode = 'QTX' WHERE SecCode = 5786134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783847368, ExchCode = 'BER' WHERE SecCode = 5805681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040680991, ExchCode = 'DEU' WHERE SecCode = 5805700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040690920, ExchCode = 'DEU' WHERE SecCode = 5805706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22042835589, ExchCode = 'DEU' WHERE SecCode = 5814835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785660798, ExchCode = 'STU' WHERE SecCode = 5886967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22054671258, ExchCode = 'DEU' WHERE SecCode = 5890417 AND Type_ = 10;
UPDATE data_universe_permid SET ExchCode = 'TAI' WHERE SecCode = 5931893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787906828, ExchCode = 'STU' WHERE SecCode = 5949087 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5987851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714242, ExchCode = 'MEX' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787861720, ExchCode = 'FRA' WHERE SecCode = 6012971 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5096778001, PriInstrPermID = 232856268550.0, PermOrgIPODate = NULL WHERE SecCode = 6018397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704334, ExchCode = 'MXQ' WHERE SecCode = 6097401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704338, ExchCode = 'MXQ' WHERE SecCode = 6097473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790492416, ExchCode = 'QTX' WHERE SecCode = 6119927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089463033, ExchCode = 'DEU' WHERE SecCode = 6151862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790959257, ExchCode = 'GTX' WHERE SecCode = 6151863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791316273, ExchCode = 'FRA' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099147227, ExchCode = 'DEU' WHERE SecCode = 6232440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22101887166, ExchCode = 'GTX' WHERE SecCode = 6240370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838443, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6245915 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6258207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792989476, ExchCode = 'LAS' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793934077, ExchCode = 'TDG' WHERE SecCode = 6289750 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6347354 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 = 236794594542, ExchCode = 'FRA' WHERE SecCode = 6416433 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-26' WHERE SecCode = 6431522 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6443421 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 6448309 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-24' WHERE SecCode = 6448817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127289121, ExchCode = 'DEU' WHERE SecCode = 6450941 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6450976 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-26' WHERE SecCode = 6456237 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-24' WHERE SecCode = 6464960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796237928, ExchCode = 'STU' WHERE SecCode = 6464987 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 6467530 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6469315 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6469316 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6469317 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6469318 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-09-24' WHERE SecCode = 6469319 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 10782264 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'AMTTF', PermQuoteRetireDate = NULL WHERE SecCode = 11049978 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'NWTCF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-25', PermSecMapEndDate = NULL WHERE SecCode = 11053854 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 11054890 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11062344 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11072382 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 11139987 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11199574 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11214335 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951262.0 WHERE SecCode = 11223568 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 11226944 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11227644 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11232072 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 11241066 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2025-09-24', PermSecMapEndDate = NULL WHERE SecCode = 11248232 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11252317 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11266862 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5096778001, PriInstrPermID = 232856268550.0, PermOrgIPODate = NULL WHERE SecCode = 11270656 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11276706 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11279972 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11279973 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11279974 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11279975 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11279976 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11279977 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11279978 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 11279979 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236796330784.0, ValQuotePermID = 25727060521.0 WHERE SecCode = 11285503 AND Type_ = 1;
UPDATE data_universe_permid SET ValQuotePermID = 236796266931.0, IsPrimaryInstr = 1 WHERE SecCode = 11285716 AND Type_ = 1;
