UPDATE data_universe_permid SET QuotePermID = 55836048756, Ticker = 'HON', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-02' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852417171, PermQuoteStatus = 'DC', Ticker = 'TKA.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 7986 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836028512, Ticker = 'IJF', ExchCode = 'ISE' WHERE SecCode = 8027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838801849, PermQuoteStatus = 'AC', Ticker = 'BKYI', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2002-03-04', PermSecMapEndDate = NULL WHERE SecCode = 9345 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 12180 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 24869 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475732246, Ticker = 'SKM.I', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 27054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836050824, Ticker = 'KTCD', ExchCode = 'LSE', PermQuoteRetireDate = '2015-09-18' WHERE SecCode = 29200 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 31536 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475534682, Ticker = 'DATA.L', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 31747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474861865, ExchCode = 'DEU' WHERE SecCode = 33922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033708, PermQuoteStatus = 'AC', Ticker = 'AIL', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34130 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 = 21475458864, ExchCode = 'FRA' WHERE SecCode = 34947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836572846, ExchCode = 'FRA', PermQuoteRetireDate = '2015-12-11' WHERE SecCode = 35004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330979, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 35421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474985040, ExchCode = 'DEU' WHERE SecCode = 35552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475527930, PermQuoteRetireDate = '2009-03-10' WHERE SecCode = 35565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838504360, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-16' WHERE SecCode = 35665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035853, PermQuoteStatus = 'AC', Ticker = 'SOBA', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 35831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491211, PermQuoteStatus = 'AC', Ticker = 'SN20', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 35878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474985751, ExchCode = 'DEU' WHERE SecCode = 36750 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325240, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 37133 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 37358 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 = 21531520132, ExchCode = 'DEU' WHERE SecCode = 38209 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556336685, PermQuoteStatus = 'AC', Ticker = 'L3H', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 38349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364005, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 38363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836519050, ExchCode = 'FRA' WHERE SecCode = 38379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475381474, ExchCode = 'GER' WHERE SecCode = 38380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518956, ExchCode = 'DUS', PermQuoteRetireDate = '2018-04-11' WHERE SecCode = 38400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357414, ExchCode = 'STU' WHERE SecCode = 38617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830303797, ExchCode = 'GTX' WHERE SecCode = 38625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531126213, Ticker = 'EICd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-05-02' WHERE SecCode = 38658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491715, ExchCode = 'QTX' WHERE SecCode = 38803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339290, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 38887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852141755, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 39373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547070061, PermQuoteStatus = 'AC', Ticker = 'XPGd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 39443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475745860, ExchCode = 'STU' WHERE SecCode = 41148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475612738, Ticker = 'CWNG.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 41647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329373, ExchCode = 'BER', PermQuoteRetireDate = '2015-03-31' WHERE SecCode = 41713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475037237, ExchCode = 'TDG', PermQuoteRetireDate = '2017-02-24' WHERE SecCode = 41724 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 42637 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236780105232, ExchCode = 'GTX', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 43244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655824017, ExchCode = 'DEU' WHERE SecCode = 43249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581385252, ExchCode = 'DEU' WHERE SecCode = 43705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474859691, ExchCode = 'DEU' WHERE SecCode = 44084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520650353, ExchCode = 'MUN' WHERE SecCode = 44086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475444399, ExchCode = 'MUN', PermQuoteRetireDate = '2008-01-30' WHERE SecCode = 44185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732784567, ExchCode = 'DEU' WHERE SecCode = 44254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533839980, ExchCode = 'FRA' WHERE SecCode = 44260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702459158, Ticker = 'CPZ1d', ExchCode = 'BCO' WHERE SecCode = 44270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931186423, ExchCode = 'GTX' WHERE SecCode = 44296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364978, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-26' WHERE SecCode = 45085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757667008, ExchCode = 'MUN' WHERE SecCode = 45088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133161, PermQuoteStatus = 'AC', Ticker = 'PBCd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 45367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536897004, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 45459 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 = 21475086185, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 48469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481629, ExchCode = 'QTX' WHERE SecCode = 48527 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 50734 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836393689, ExchCode = 'FRA', PermQuoteRetireDate = '2013-02-06' WHERE SecCode = 51353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487924, PermQuoteStatus = 'AC', Ticker = 'MBI', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 51369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460143, PermQuoteStatus = 'AC', ExchCode = 'HAN', PermQuoteRetireDate = NULL WHERE SecCode = 51370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486727, Ticker = 'ISU', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 51372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836509334, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 51376 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'BIO1' WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'BIO0' WHERE SecCode = 51555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475538440, PermQuoteStatus = 'DC', Ticker = 'CRIG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 52113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475090488, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-06' WHERE SecCode = 52116 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051024, PermQuoteStatus = 'AC', Ticker = '2XT', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 53136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475554656, PermQuoteStatus = 'DC', Ticker = 'RGIO.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 53137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330586, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 53146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475856561, ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-14' WHERE SecCode = 53447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475569862, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'HAM', PermQuoteRetireDate = '2006-05-17' WHERE SecCode = 53618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125592309, ExchCode = 'DEU' WHERE SecCode = 53688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035667, PermQuoteStatus = 'AC', Ticker = 'INVN', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 53697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469997, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 54192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617880508, PermQuoteStatus = 'DC', Ticker = 'NDASEs', ExchCode = 'EBT', PermQuoteRetireDate = '2018-11-28' WHERE SecCode = 54237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475576317, ExchCode = 'STU', PermQuoteRetireDate = '2008-01-07' WHERE SecCode = 54284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508750038, ExchCode = 'TDG' WHERE SecCode = 54302 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 54332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512066320, ExchCode = 'DEU' WHERE SecCode = 54435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475424227, ExchCode = 'DUS', PermQuoteRetireDate = '2008-07-01' WHERE SecCode = 54568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475746682, Ticker = 'TCCG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 54580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035582, ExchCode = 'TDG' WHERE SecCode = 54587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475417008, ExchCode = 'MUN', PermQuoteRetireDate = '2009-11-19' WHERE SecCode = 54686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830306436, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 55213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590786433, ExchCode = 'TDG' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475628897, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2008-04-18', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 56895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838238912, ExchCode = 'MUN' WHERE SecCode = 59881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475153887, ExchCode = 'MUN' WHERE SecCode = 60107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835784239, PermQuoteStatus = 'AC', Ticker = 'QNT', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 60212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836427368, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519378, ExchCode = 'DUS' WHERE SecCode = 60403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486677, ExchCode = 'QTX' WHERE SecCode = 60416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535774837, ExchCode = 'DEU' WHERE SecCode = 60608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548046778, ExchCode = 'STU', PermQuoteRetireDate = '2015-03-06' WHERE SecCode = 60965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482010, ExchCode = 'QTX' WHERE SecCode = 61044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337205, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475569932, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 61651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836463221, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 61930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486851, ExchCode = 'QTX' WHERE SecCode = 62204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659673, ExchCode = 'LAS' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475261170, ExchCode = 'HAN', PermQuoteRetireDate = '2004-03-30' WHERE SecCode = 62480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339451, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836386299, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 62531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035283, PermQuoteStatus = 'AC', Ticker = 'NEQ', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 62765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341618, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 62845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837354776, ExchCode = 'GER' WHERE SecCode = 62872 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 63023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836486980, ExchCode = 'FRA', PermQuoteRetireDate = '2016-07-28' WHERE SecCode = 63097 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331906, ExchCode = 'BER', PermQuoteRetireDate = '2013-05-23' WHERE SecCode = 63227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836526615, ExchCode = 'FRA' WHERE SecCode = 63302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836396769, ExchCode = 'FRA' WHERE SecCode = 63643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790407362, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2021-03-23' WHERE SecCode = 63693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836455728, ExchCode = 'FRA' WHERE SecCode = 63710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486483, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 63757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364071, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 63767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782003465, PermQuoteStatus = 'DC', Ticker = 'VCT', ExchCode = 'STU', PermQuoteRetireDate = '2025-12-02' WHERE SecCode = 63954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308643, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 63973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838526692, ExchCode = 'STU' WHERE SecCode = 63982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836472176, ExchCode = 'FRA' WHERE SecCode = 63997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329595, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 64125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474840407, ExchCode = 'DEU' WHERE SecCode = 64139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474997617, ExchCode = 'FRA' WHERE SecCode = 64180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836423684, ExchCode = 'FRA' WHERE SecCode = 64276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419533, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 64308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475419997, Ticker = 'PMJG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 64344 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399421, ExchCode = 'FRA' WHERE SecCode = 64362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481270, PermQuoteStatus = 'AC', Ticker = 'AJ8', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 64365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388774, ExchCode = 'LAS' WHERE SecCode = 64431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328758, ExchCode = 'BER' WHERE SecCode = 64435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486299, PermQuoteStatus = 'DC', Ticker = 'HVP', ExchCode = 'QTX', PermQuoteRetireDate = '2021-08-04' WHERE SecCode = 64448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544483339, ExchCode = 'TDG' WHERE SecCode = 64549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522869226, Ticker = 'ST7', ExchCode = 'STU', PermQuoteRetireDate = '2023-08-28' WHERE SecCode = 64555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474984046, ExchCode = 'HAM', PermQuoteRetireDate = '2012-07-11' WHERE SecCode = 64558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474986024, ExchCode = 'DEU' WHERE SecCode = 64559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524268066, ExchCode = 'STU' WHERE SecCode = 64572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585187548, ExchCode = 'HAM' WHERE SecCode = 64832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335540, Ticker = 'SPJ', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 64845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850536311, ExchCode = 'FRA' WHERE SecCode = 64863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308464, PermQuoteStatus = 'AC', Ticker = 'SS9', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 65007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475572381, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2004-09-13', PermSecMapEndDate = '2022-06-30' WHERE SecCode = 65029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359995, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 65092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474873744, ExchCode = 'DEU' WHERE SecCode = 65163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492738, ExchCode = 'QTX' WHERE SecCode = 65181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837366536, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 65328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460673, ExchCode = 'HAN' WHERE SecCode = 65358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855342374, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 65368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836411094, ExchCode = 'FRA' WHERE SecCode = 65414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475616741, ExchCode = 'FRA' WHERE SecCode = 65641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836483615, ExchCode = 'FRA', PermQuoteRetireDate = '2009-07-03' WHERE SecCode = 66533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742524, ExchCode = 'HAN' WHERE SecCode = 66686 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 66857 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 66861 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951711.0 WHERE SecCode = 69160 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SRN', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 72565 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 73402 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 79200 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951778.0 WHERE SecCode = 79437 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'VGLS' WHERE SecCode = 80070 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 81855 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951987.0 WHERE SecCode = 86153 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 87160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475717386, IsPrimaryQuote = 0, PermQuoteStatus = 'DC', ExchCode = 'JSD', PermQuoteRetireDate = '2002-01-22', PermSecMapStartDate = '1991-10-25', PermSecMapEndDate = '2002-01-22' WHERE SecCode = 88188 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapStartDate = '2016-02-23', PermSecMapEndDate = '2018-04-13' WHERE SecCode = 88770 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 88784 AND Type_ = 1;
UPDATE data_universe_permid SET QuoteClass = 'CHESS' WHERE SecCode = 90245 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951778.0 WHERE SecCode = 93379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483761700, IsPrimaryQuote = 0, PermQuoteStatus = 'DC', ExchCode = 'CHA', PermQuoteRetireDate = '2025-02-28', PermSecMapStartDate = '2010-01-22', PermSecMapEndDate = '2025-02-28' WHERE SecCode = 96942 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 97005 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-28' WHERE SecCode = 97597 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-21' WHERE SecCode = 98177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141120, ExchCode = 'FRA' WHERE SecCode = 100032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531043704, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 100052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898260294, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-14' WHERE SecCode = 100728 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21609211565, ExchCode = 'TDG' WHERE SecCode = 103792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341666, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 103840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836418073, ExchCode = 'FRA' WHERE SecCode = 103841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335490, ExchCode = 'BER' WHERE SecCode = 103863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475499889, ExchCode = 'STU' WHERE SecCode = 103891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474923635, ExchCode = 'DEU' WHERE SecCode = 103894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033723, ExchCode = 'TDG' WHERE SecCode = 104092 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951975.0 WHERE SecCode = 105142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840969636, Ticker = 'UAX3', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 111950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484409, ExchCode = 'QTX' WHERE SecCode = 112018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285139, ExchCode = 'DEU' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835799282, ExchCode = 'MEX' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475775904, ExchCode = 'MUN' WHERE SecCode = 112468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475032489, ExchCode = 'DEU' WHERE SecCode = 112602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853681433, ExchCode = 'FRA', PermQuoteRetireDate = '2018-03-01' WHERE SecCode = 112633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800222855, ExchCode = 'FRA' WHERE SecCode = 112636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059889, ExchCode = 'FRA' WHERE SecCode = 112909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700183753, ExchCode = 'MXQ' WHERE SecCode = 113051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705636, ExchCode = 'MXQ' WHERE SecCode = 113052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334569, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26', PermSecMapEndDate = '2024-09-26' WHERE SecCode = 114177 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 114774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22054464761, ExchCode = 'DEU' WHERE SecCode = 115623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538235, ExchCode = 'GTX' WHERE SecCode = 115779 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 = 21771298416, ExchCode = 'DEU' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381737, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823487855, ExchCode = 'DUS' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419464, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474928478, ExchCode = 'DEU' WHERE SecCode = 119129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705624, ExchCode = 'MXQ' WHERE SecCode = 122917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474967821, Ticker = 'GJR', ExchCode = 'STU', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 123262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475620985, ExchCode = 'GER' WHERE SecCode = 124562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341899, ExchCode = 'BER', PermQuoteRetireDate = '2016-10-28' WHERE SecCode = 124574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704476, ExchCode = 'MXQ' WHERE SecCode = 124579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536222831, ExchCode = 'MEX' WHERE SecCode = 124586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21966768965, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 124677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835808928, ExchCode = 'MEX' WHERE SecCode = 125073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262929, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 128769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770833005, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-23' WHERE SecCode = 131843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521157927, ExchCode = 'STU' WHERE SecCode = 133024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773000755, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 133025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954131221, ExchCode = 'FRA' WHERE SecCode = 133163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473389, ExchCode = 'GER' WHERE SecCode = 133773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186346, ExchCode = 'DEU' WHERE SecCode = 136909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776858458, ExchCode = 'STU' WHERE SecCode = 136916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517508646, ExchCode = 'DEU' WHERE SecCode = 137300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331463, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-01', PermSecMapEndDate = '2021-03-01' WHERE SecCode = 137370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475142728, ExchCode = 'FRA' WHERE SecCode = 137374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801211984, ExchCode = 'HAM' WHERE SecCode = 137417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625198385, ExchCode = 'DEU' WHERE SecCode = 137437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474864719, ExchCode = 'DEU' WHERE SecCode = 138024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419294, ExchCode = 'HAM' WHERE SecCode = 138046 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448652, ExchCode = 'FRA' WHERE SecCode = 138104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556645874, ExchCode = 'BER', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859258794, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 138235 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 139131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474994818, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 139946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652457, ExchCode = 'FRA' WHERE SecCode = 140677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077651, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 141439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478468739, ExchCode = 'TDG', PermQuoteRetireDate = '2013-02-14' WHERE SecCode = 142058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482719, ExchCode = 'QTX' WHERE SecCode = 142384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324383, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 142505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817036561, ExchCode = 'TDG' WHERE SecCode = 142650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885909284, ExchCode = 'STU' WHERE SecCode = 142718 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 142736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475009275, ExchCode = 'DEU' WHERE SecCode = 142742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554252789, PermQuoteRetireDate = '2015-01-09' WHERE SecCode = 143248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394144, PermQuoteStatus = 'AC', Ticker = 'CD5', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 143563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778285096, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536791830, ExchCode = 'TDG', PermQuoteRetireDate = '2019-06-12' WHERE SecCode = 144107 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 144789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777629168, ExchCode = 'FRA' WHERE SecCode = 145647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337424, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 146280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575204794, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 146333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751522, ExchCode = 'QTX', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = NULL WHERE SecCode = 146856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322660, PermQuoteStatus = 'DC', Ticker = 'A3Z1', ExchCode = 'BER', PermQuoteRetireDate = '2024-01-15', PermSecMapEndDate = '2024-01-15' WHERE SecCode = 146860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793690706, ExchCode = 'FRA' WHERE SecCode = 147011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386859, ExchCode = 'LAS' WHERE SecCode = 147014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561518860, ExchCode = 'DEU' WHERE SecCode = 147146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763556002, ExchCode = 'QTX' WHERE SecCode = 147295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484697, ExchCode = 'QTX', PermQuoteRetireDate = '2026-03-25', PermOrgIPODate = NULL WHERE SecCode = 147470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334164, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 147598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836503758, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 147649 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 = 55836339056, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-12' WHERE SecCode = 147913 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738226516, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 150488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346416, ExchCode = 'DEU' WHERE SecCode = 164507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514316877, ExchCode = 'STU' WHERE SecCode = 164791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625070426, ExchCode = 'STU' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859269580, PermQuoteStatus = 'DC', Ticker = 'G7F1', ExchCode = 'BER', PermQuoteRetireDate = '2017-02-21' WHERE SecCode = 165793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850728851, ExchCode = 'QTX' WHERE SecCode = 169573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612926135, ExchCode = 'TDG' WHERE SecCode = 172965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617037034, ExchCode = 'FRA' WHERE SecCode = 172982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488639, ExchCode = 'QTX' WHERE SecCode = 172988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288493, ExchCode = 'DEU' WHERE SecCode = 174875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538829900, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329758, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 177280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517511603, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-04', PermSecMapEndDate = '2024-04-04' WHERE SecCode = 177409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836489072, ExchCode = 'FRA' WHERE SecCode = 177415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474848733, ExchCode = 'DEU', PermQuoteRetireDate = '2023-05-17' WHERE SecCode = 177474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485767, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-07' WHERE SecCode = 177697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333074, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593612748, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330777, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' 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 = 21548652821, ExchCode = 'DEU' WHERE SecCode = 178159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331615, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296051, ExchCode = 'GTX' WHERE SecCode = 178557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532122910, ExchCode = 'STU', PermQuoteRetireDate = '2014-09-22' WHERE SecCode = 178563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329897, ExchCode = 'BER', PermQuoteRetireDate = '2021-08-23' WHERE SecCode = 178570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787518982, ExchCode = 'STU', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 178579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379741, ExchCode = 'LAS' WHERE SecCode = 178611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679753, ExchCode = 'GER' WHERE SecCode = 178849 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 = 22139574190, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 183749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332552, ExchCode = 'BER', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 183751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338205, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 185280 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951975.0 WHERE SecCode = 185686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338585, ExchCode = 'BER' WHERE SecCode = 186262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474943333, ExchCode = 'DEU' WHERE SecCode = 186807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481704, ExchCode = 'QTX' WHERE SecCode = 187205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509911818, ExchCode = 'TDG', PermQuoteRetireDate = '2022-07-04' WHERE SecCode = 187752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475130180, ExchCode = 'TDG', PermQuoteRetireDate = '2023-02-21' WHERE SecCode = 187830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324515, ExchCode = 'BER' WHERE SecCode = 189024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323361, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 189025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886808308, ExchCode = 'MUN' WHERE SecCode = 189863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954813, ExchCode = 'LAS' WHERE SecCode = 190498 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'AM3', PermSecMapEndDate = '2022-10-26' WHERE SecCode = 190747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337225, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 192497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326664, ExchCode = 'BER' WHERE SecCode = 192797 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-05-13', PermSecMapEndDate = NULL WHERE SecCode = 193829 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475022460, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 194342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850152773, Ticker = 'D8DA', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 194366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532071597, ExchCode = 'STU' WHERE SecCode = 195545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791636472, ExchCode = 'DUS' WHERE SecCode = 198928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836574074, ExchCode = 'FRA' WHERE SecCode = 199359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835455673, Ticker = 'SOYBP', ExchCode = 'PAR', PermQuoteRetireDate = '2013-05-08' WHERE SecCode = 202732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530477951, ExchCode = 'DUS' WHERE SecCode = 203921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956395290, ExchCode = 'DEU' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512957421, ExchCode = 'STU' WHERE SecCode = 207662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544956008, ExchCode = 'DEU' WHERE SecCode = 208922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328659, ExchCode = 'BER' WHERE SecCode = 208947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806228776, ExchCode = 'FRA' WHERE SecCode = 208948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036607, PermQuoteStatus = 'DC', Ticker = 'DD5', ExchCode = 'TDG', PermQuoteRetireDate = '2014-10-22', PermSecMapStartDate = '2022-10-25', PermSecMapEndDate = '2023-04-03' WHERE SecCode = 213645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475090526, ExchCode = 'TDG' WHERE SecCode = 214131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835817048, ExchCode = 'MEX' WHERE SecCode = 214378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704511, ExchCode = 'MXQ' WHERE SecCode = 214889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 216383 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'AFFU' WHERE SecCode = 221382 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805672063, ExchCode = 'FRA' WHERE SecCode = 249189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914282, ExchCode = 'MUN' WHERE SecCode = 249202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474992946, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 249379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256254, ExchCode = 'FRA' WHERE SecCode = 249624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589367501, ExchCode = 'STU', PermQuoteRetireDate = '2020-10-07' WHERE SecCode = 249627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805754406, ExchCode = 'MUN' WHERE SecCode = 249668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666131027, ExchCode = 'TDG', PermQuoteRetireDate = '2020-06-19' WHERE SecCode = 249728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714463535, Ticker = 'EM35m', ExchCode = 'DXE' WHERE SecCode = 252548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275430, ExchCode = 'GTX' WHERE SecCode = 252550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336691, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 260490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804440375, ExchCode = 'FRA' WHERE SecCode = 273208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836529320, ExchCode = 'FRA', PermQuoteRetireDate = '2012-07-17' WHERE SecCode = 282547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324576, ExchCode = 'BER' WHERE SecCode = 286289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325722, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836412358, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 287584 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 = 21667489325, ExchCode = 'QTX', PermQuoteRetireDate = '2023-03-06', PermSecMapEndDate = '2023-03-06' WHERE SecCode = 289619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484849, ExchCode = 'QTX', PermQuoteRetireDate = '2020-10-07' WHERE SecCode = 289896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325116, ExchCode = 'BER' WHERE SecCode = 289915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773003127, ExchCode = 'DEU' WHERE SecCode = 291283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331784, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 291583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329948, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 291628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381147, ExchCode = 'LAS' WHERE SecCode = 292113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885821, ExchCode = 'TDG' WHERE SecCode = 292366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538083046, ExchCode = 'DEU' WHERE SecCode = 294092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794261329, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532933634, ExchCode = 'STU' WHERE SecCode = 296606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335814, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850354101, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 298815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034221, ExchCode = 'TDG' WHERE SecCode = 300369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836527345, ExchCode = 'FRA', PermQuoteRetireDate = '2014-05-19' WHERE SecCode = 302438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007244, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835821280, ExchCode = 'MEX' WHERE SecCode = 308939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334963, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 309089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571572383, ExchCode = 'TDG' WHERE SecCode = 309339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585032968, ExchCode = 'BCO' WHERE SecCode = 309898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527198705, PermQuoteStatus = 'AC', Ticker = '3EO1', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 316264 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 = 55836320657, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 317772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323723, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 318424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320974, Ticker = '45CN', ExchCode = 'BER', PermQuoteRetireDate = '2019-04-03' WHERE SecCode = 323043 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 324369 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836350896, ExchCode = 'FRA', PermQuoteRetireDate = '2012-02-03' WHERE SecCode = 325339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836359971, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 326282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818250581, ExchCode = 'MUN' WHERE SecCode = 327723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796466548, ExchCode = 'STU' WHERE SecCode = 328509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629957388, ExchCode = 'TDG' WHERE SecCode = 330665 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 331348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534819938, ExchCode = 'STU' WHERE SecCode = 332303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22093596042, ExchCode = 'DEU' WHERE SecCode = 332315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531116271, PermQuoteStatus = 'AC', Ticker = 'AGAPl', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 333083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565172549, Ticker = 'OLBPl', ExchCode = 'BTE', PermQuoteRetireDate = '2020-06-17' WHERE SecCode = 333091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491206922, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-31' WHERE SecCode = 333182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879222460, ExchCode = 'STU' WHERE SecCode = 333804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320912, ExchCode = 'BER' WHERE SecCode = 334857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804396433, ExchCode = 'QTX' WHERE SecCode = 335262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320947, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 335658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623722252, ExchCode = 'TDG' WHERE SecCode = 335661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561687455, ExchCode = 'TDG', PermQuoteRetireDate = '2022-12-08' WHERE SecCode = 336764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349905, ExchCode = 'FRA', PermQuoteRetireDate = '2013-03-22' WHERE SecCode = 337012 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-14', PermSecMapStartDate = '2022-07-25', PermSecMapEndDate = '2024-02-08' WHERE SecCode = 338704 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836320662, ExchCode = 'BER' WHERE SecCode = 341124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388066, Ticker = 'COD.NO', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 342896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168118, ExchCode = 'FRA' WHERE SecCode = 344774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564885326, ExchCode = 'FRA' WHERE SecCode = 344777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784580335, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-11' WHERE SecCode = 345092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550076203, ExchCode = 'HAM', PermQuoteRetireDate = '2018-07-12' WHERE SecCode = 345094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957499669, ExchCode = 'DUS' WHERE SecCode = 345100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821849074, ExchCode = 'TDG' WHERE SecCode = 345429 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 345598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475550034, Ticker = 'CAZA', ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 345783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838799125, Ticker = NULL, ExchCode = 'PRA' WHERE SecCode = 346537 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 348091 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 348103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589227637, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 348130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475108673, Ticker = '0N06', ExchCode = 'LSE', PermQuoteRetireDate = '2012-02-13' WHERE SecCode = 348630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707243674, ExchCode = 'TDG' WHERE SecCode = 348709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419816, ExchCode = 'HAM' WHERE SecCode = 348719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834672212, Ticker = '0OA8', ExchCode = 'LSE', PermQuoteRetireDate = '2012-07-02' WHERE SecCode = 351265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673143, Ticker = '0NY0', ExchCode = 'LSE', PermQuoteRetireDate = '2015-09-30' WHERE SecCode = 351274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673962, PermQuoteStatus = 'AC', Ticker = '0OGK', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 351284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836347634, ExchCode = 'FRA', PermQuoteRetireDate = '2009-09-28' WHERE SecCode = 351311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834672474, Ticker = '0EQ8', ExchCode = 'LSE', PermQuoteRetireDate = '2010-07-26' WHERE SecCode = 353920 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509803171, Ticker = NULL, ExchCode = 'LSE' WHERE SecCode = 353941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834676941, Ticker = '0O93', ExchCode = 'LSE', PermQuoteRetireDate = '2022-09-20' WHERE SecCode = 353956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834675302, Ticker = '0NEV', ExchCode = 'LSE', PermQuoteRetireDate = '2012-03-13' WHERE SecCode = 353982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834675808, Ticker = '0GWG', ExchCode = 'LSE', PermQuoteRetireDate = '2018-07-27' WHERE SecCode = 353994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321371, ExchCode = 'BER' WHERE SecCode = 356548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774055180, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2021-11-02', PermSecMapEndDate = '2021-11-02' WHERE SecCode = 359939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561786, ExchCode = 'GTX' WHERE SecCode = 360956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321584, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 362789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723938606, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-05' WHERE SecCode = 362801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799029787, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-11-21' WHERE SecCode = 363732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859257649, PermQuoteStatus = 'AC', Ticker = '0LX1', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 363982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350834, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 368806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350583, ExchCode = 'FRA', PermQuoteRetireDate = '2024-11-29' WHERE SecCode = 368808 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475566805, PermQuoteStatus = 'DC', ExchCode = 'MUN', PermQuoteRetireDate = '2009-08-03' WHERE SecCode = 368820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363589, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 370287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835814252, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 371435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835814728, ExchCode = 'MEX' WHERE SecCode = 372859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834671865, Ticker = '0NNH', ExchCode = 'LSE', PermQuoteRetireDate = '2015-04-30' WHERE SecCode = 374927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21499716930, ExchCode = 'STU' WHERE SecCode = 375279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484743, ExchCode = 'QTX' WHERE SecCode = 375326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533496124, ExchCode = 'STU', PermQuoteRetireDate = '2021-02-10' WHERE SecCode = 375327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552305611, ExchCode = 'STU', PermQuoteRetireDate = '2016-06-08' WHERE SecCode = 377929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21485274677, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = '2024-05-31' WHERE SecCode = 377931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545191001, ExchCode = 'DEU', PermQuoteRetireDate = '2014-08-04' WHERE SecCode = 378775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033616, ExchCode = 'TDG' WHERE SecCode = 383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835813469, ExchCode = 'MEX' WHERE SecCode = 383039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631772204, ExchCode = 'TDG', PermQuoteRetireDate = '2022-11-02', PermSecMapEndDate = '2023-09-12' WHERE SecCode = 384412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22020882891, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 385016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782463487, ExchCode = 'QTX' WHERE SecCode = 385281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840731652, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 387856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852345883, ExchCode = 'GER' WHERE SecCode = 387914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840869960, Ticker = 'TRME', ExchCode = 'LSE' WHERE SecCode = 389399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616156678, ExchCode = 'MCX' WHERE SecCode = 389411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962595022, ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-15' WHERE SecCode = 389476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295315, ExchCode = 'GTX' WHERE SecCode = 390369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955513841, ExchCode = 'DUS' WHERE SecCode = 395256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799281035, ExchCode = 'FRA' WHERE SecCode = 396303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431650, ExchCode = 'FRA' WHERE SecCode = 401619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475806545, ExchCode = 'STU' WHERE SecCode = 401621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785083554, ExchCode = 'TDG' WHERE SecCode = 403552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834674152, Ticker = '0EBK', ExchCode = 'LSE', PermQuoteRetireDate = '2015-04-30' WHERE SecCode = 404675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841814629, ExchCode = 'BER', PermQuoteRetireDate = '2018-03-26' WHERE SecCode = 404717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539608463, ExchCode = 'TDG', PermQuoteRetireDate = '2019-11-01' WHERE SecCode = 404833 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 407811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927526, Ticker = '2ENGI' WHERE SecCode = 408548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479309, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 408562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841613018, ExchCode = 'MEX' WHERE SecCode = 409684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834672784, Ticker = '0EZL', ExchCode = 'LSE', PermQuoteRetireDate = '2017-06-13' WHERE SecCode = 410297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704362, ExchCode = 'MXQ' WHERE SecCode = 411789 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 420086 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 = 55843427223, ExchCode = 'MUN' WHERE SecCode = 425691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488504, ExchCode = 'QTX' WHERE SecCode = 428332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396870, ExchCode = 'FRA' WHERE SecCode = 428966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834676291, Ticker = '0I6Z', ExchCode = 'LSE', PermQuoteRetireDate = '2016-08-17' WHERE SecCode = 429804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308332, ExchCode = 'GTX' WHERE SecCode = 434993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518877, ExchCode = 'DUS' WHERE SecCode = 435796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474947767 WHERE SecCode = 437916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599934396, ExchCode = 'TDG', PermQuoteRetireDate = '2023-12-14', PermSecMapEndDate = '2023-12-14' WHERE SecCode = 438364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684650, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 439455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474954858, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 440782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834675804, PermQuoteStatus = 'AC', Ticker = '0RQ2', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 445297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834675441, Ticker = '0JS9', ExchCode = 'LSE', PermQuoteRetireDate = '2017-10-27' WHERE SecCode = 450252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838301190, PermQuoteStatus = 'DC', Ticker = 'NYR.BE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 450704 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 = 21575865316, ExchCode = 'BCO' WHERE SecCode = 464174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846943054, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 464560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789408416, Ticker = '0AO0', ExchCode = 'FRA', PermQuoteRetireDate = '2022-09-06' WHERE SecCode = 479615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073604520, Ticker = 'XAXDl', ExchCode = 'BTE' WHERE SecCode = 481044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035525, ExchCode = 'TDG', PermQuoteRetireDate = '2014-12-09', PermSecMapEndDate = '2018-09-19' WHERE SecCode = 484246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952832290, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 484491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475107600, ExchCode = 'MUN' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605425984, ExchCode = 'RTB' WHERE SecCode = 500487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848865465, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 503830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627494176, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-12-16', PermSecMapEndDate = '2019-12-17' WHERE SecCode = 503842 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 = 55849266247, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 507407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704447, ExchCode = 'MXQ' WHERE SecCode = 508999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476991409, ExchCode = 'MUN', PermQuoteRetireDate = '2013-03-12' WHERE SecCode = 510380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608722355, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 512041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834675802, Ticker = '0O9J', ExchCode = 'LSE', PermQuoteRetireDate = '2016-06-10' WHERE SecCode = 512425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531115401, Ticker = '0GAd', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-12' 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 = 21475388527, Ticker = 'PAXA.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 515577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851531713, ExchCode = 'GER' WHERE SecCode = 515658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428165, ExchCode = 'GTX' WHERE SecCode = 519511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573299542, ExchCode = 'CHI' WHERE SecCode = 521413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596919142, ExchCode = 'BTE' WHERE SecCode = 521415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562819111, ExchCode = 'CHI' WHERE SecCode = 521420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563166561, ExchCode = 'BTE' WHERE SecCode = 521423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564130165, ExchCode = 'BTE' WHERE SecCode = 521425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575243689, ExchCode = 'BTE' WHERE SecCode = 521426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21579538469, PermQuoteStatus = 'AC', ExchCode = 'BTE', PermQuoteRetireDate = NULL WHERE SecCode = 521434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296198, ExchCode = 'GTX' WHERE SecCode = 524403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591308348, ExchCode = 'STU', PermQuoteRetireDate = '2025-10-09' WHERE SecCode = 527096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640208051, ExchCode = 'CHI', PermQuoteRetireDate = '2018-10-29' WHERE SecCode = 529911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859265616, Ticker = '0MFT', ExchCode = 'LSE', PermQuoteRetireDate = '2023-01-05' WHERE SecCode = 531909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480578, ExchCode = 'QTX', PermQuoteRetireDate = '2020-09-01' WHERE SecCode = 532772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886808270, ExchCode = 'MUN' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062340, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 533522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856295357, ExchCode = 'STU' WHERE SecCode = 534603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478699, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-09', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 535506 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 = 21480923684, ExchCode = 'BER', PermQuoteRetireDate = '2019-12-17' WHERE SecCode = 536609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475867481, ExchCode = 'FRA' WHERE SecCode = 538783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478626, ExchCode = 'QTX' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852284014, ExchCode = 'BER' WHERE SecCode = 540241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851907674, ExchCode = 'FRA' WHERE SecCode = 540531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476219200, ExchCode = 'STU' 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 = 21522128043, ExchCode = 'MUN' WHERE SecCode = 548067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547316142, ExchCode = 'STU' WHERE SecCode = 548626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542942791, ExchCode = 'STU' WHERE SecCode = 548782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301241, ExchCode = 'GTX' WHERE SecCode = 549236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851510082, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 549537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531427744, ExchCode = 'STU' WHERE SecCode = 550860 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 25727309689.0, ValQuotePermID = 21522153591.0 WHERE SecCode = 551365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853693620, ExchCode = 'MUN', PermQuoteRetireDate = '2022-11-01', PermSecMapEndDate = '2022-11-01' WHERE SecCode = 553231 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 PriTrdQuotePermID = 25727309689.0, ValQuotePermID = 21522153591.0 WHERE SecCode = 554222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852277935, ExchCode = 'MEX' WHERE SecCode = 554302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528540521, ExchCode = 'BTE', PermQuoteRetireDate = '2020-03-25' WHERE SecCode = 554481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853892984, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 554906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858811523, ExchCode = 'FRA' WHERE SecCode = 556254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856027323, ExchCode = 'FRA', PermQuoteRetireDate = '2013-07-04' WHERE SecCode = 556535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534813444, ExchCode = 'DUS' WHERE SecCode = 557818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475855781, ExchCode = 'TDG' WHERE SecCode = 557995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856214006, ExchCode = 'GER' WHERE SecCode = 558032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856606623, ExchCode = 'FRA' WHERE SecCode = 559437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804090704, ExchCode = 'HAM' WHERE SecCode = 559903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856811283, PermQuoteStatus = 'DC', Ticker = '7TM', ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 560717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856721464, ExchCode = 'BER', PermQuoteRetireDate = '2018-04-27' WHERE SecCode = 560723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856960400, ExchCode = 'FRA' WHERE SecCode = 561861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718775814, ExchCode = 'BER', PermQuoteRetireDate = '2024-10-03' WHERE SecCode = 561917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633740802, ExchCode = 'TDG' WHERE SecCode = 563028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529362096, ExchCode = 'STU' WHERE SecCode = 563087 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 = 21587932514, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2017-02-03' WHERE SecCode = 564862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474958339, ExchCode = 'DEU' WHERE SecCode = 565316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492892892, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 565330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857350143, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 565707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607812061, PermQuoteStatus = 'AC', Ticker = 'OAA1', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 565752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864886870, ExchCode = 'MUN' WHERE SecCode = 565861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474962557, ExchCode = 'DEU' WHERE SecCode = 565866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547776826, ExchCode = 'FRA' WHERE SecCode = 566156 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791908479, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 566221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539860643, ExchCode = 'STU' WHERE SecCode = 568338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801210626, ExchCode = 'FRA' WHERE SecCode = 573544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858527370, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-23' WHERE SecCode = 577333 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 = 22151702240, ExchCode = 'DEU' WHERE SecCode = 588158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801210149, ExchCode = 'FRA' WHERE SecCode = 588562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883771516, ExchCode = 'FRA' WHERE SecCode = 588644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475793862, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 593104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521814018, ExchCode = 'STU', PermQuoteRetireDate = '2014-04-25' WHERE SecCode = 594093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859132030, ExchCode = 'GER' WHERE SecCode = 594191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068266, ExchCode = 'DEU' WHERE SecCode = 596843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859230063, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 598098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859254285, ExchCode = 'FRA', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 599978 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 = 55859255778, ExchCode = 'FRA', PermQuoteRetireDate = '2012-05-07' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22157401812, ExchCode = 'DEU' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 613367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847342799, ExchCode = 'MUN' WHERE SecCode = 627565 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 PriTRBCIndPermID = 4294951931.0 WHERE SecCode = 645693 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 683529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581498976, ExchCode = 'MUN' WHERE SecCode = 701753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780160052, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 827254 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 832249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475136685, ExchCode = 'FRA' WHERE SecCode = 858901 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NOR' WHERE SecCode = 869499 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 873717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660807802, ExchCode = 'MUN' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NOR' WHERE SecCode = 894183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353634, ExchCode = 'FRA' WHERE SecCode = 909539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545813177, ExchCode = 'FRA' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55868604668, Ticker = 'CBBFDS', ExchCode = 'SWX', PermQuoteRetireDate = '2021-04-19' WHERE SecCode = 933460 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 = 21475766062, Ticker = '29F', ExchCode = 'STU', PermQuoteRetireDate = '2015-03-23' WHERE SecCode = 985004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769605, Ticker = 'TYMA', ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 995830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544497566, ExchCode = 'TRQ' WHERE SecCode = 1051206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097107, ExchCode = 'LAS' WHERE SecCode = 1107275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483848681, ExchCode = 'CHI', PermQuoteRetireDate = '2022-03-08' WHERE SecCode = 1107433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890365, ExchCode = 'AQX' WHERE SecCode = 1108481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890366, ExchCode = 'AQX' WHERE SecCode = 1108490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890382, Ticker = 'ISLNl', ExchCode = 'AQX' WHERE SecCode = 1108496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521581557, ExchCode = 'FRA' WHERE SecCode = 1122776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538186, ExchCode = 'GTX' WHERE SecCode = 1131662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55869150026, ExchCode = 'MEX' WHERE SecCode = 1149852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688591148, ExchCode = 'STU', PermQuoteRetireDate = '2022-11-16' WHERE SecCode = 1157161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531117505, Ticker = 'B5Md', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-01' WHERE SecCode = 1205007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727350738, ExchCode = 'MEX' WHERE SecCode = 1329098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419187, ExchCode = 'LAS' WHERE SecCode = 1447581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583580938, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-08-16', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1455200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704338, ExchCode = 'MXQ' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478615946, ExchCode = 'STO' WHERE SecCode = 1465275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558280851, ExchCode = 'CHI', PermQuoteRetireDate = '2025-02-03' WHERE SecCode = 1472753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480227394, ExchCode = 'STU', PermQuoteRetireDate = '2013-05-20' WHERE SecCode = 1479224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478367, ExchCode = 'QTX' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481623767, ExchCode = 'DEU' WHERE SecCode = 1482803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950893, ExchCode = 'STU' WHERE SecCode = 1485685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385946, ExchCode = 'LAS' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109485, ExchCode = 'FRA' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55886089498, Ticker = 'SLHO', ExchCode = 'MIL', PermQuoteRetireDate = '2019-09-17' WHERE SecCode = 1503000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642014, ExchCode = 'QTX' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531119071, Ticker = 'BRDGl', ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485447, ExchCode = 'QTX' 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 = 55886089472, Ticker = 'LIME', ExchCode = 'MIL', PermQuoteRetireDate = '2019-09-17' WHERE SecCode = 1517254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704850, ExchCode = 'MXQ' WHERE SecCode = 1518823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486671125, ExchCode = 'STU' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487384788, ExchCode = 'FRA' WHERE SecCode = 1522268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822168, ExchCode = 'FRA' WHERE SecCode = 1524540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857170651, ExchCode = 'QTX' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623750, ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-23' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704626, ExchCode = 'MXQ' WHERE SecCode = 1524554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793448735, ExchCode = 'TDG' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536289597, ExchCode = 'FRA' 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 = 21489294362, ExchCode = 'STU', PermQuoteRetireDate = '2013-04-17' WHERE SecCode = 1525783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522741571, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-17' WHERE SecCode = 1527439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098687, ExchCode = 'DEU' WHERE SecCode = 1527502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535039956, ExchCode = 'STU' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067014491, ExchCode = 'DEU' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273313, ExchCode = 'GTX' WHERE SecCode = 1537214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270483, ExchCode = 'FRA' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493901015, ExchCode = 'DEU' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766661889, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1538644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781519910, ExchCode = 'FRA' WHERE SecCode = 1539178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704883, ExchCode = 'MXQ' WHERE SecCode = 1539224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379929, ExchCode = 'LAS' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775091189, ExchCode = 'DEU' WHERE SecCode = 1541396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492779440, ExchCode = 'CPH' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494700973, ExchCode = 'FRA' WHERE SecCode = 1544114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662661860, ExchCode = 'MUN', PermQuoteRetireDate = '2021-04-15' WHERE SecCode = 1544250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480207, PermQuoteStatus = 'DC', Ticker = '7NU', ExchCode = 'QTX', PermQuoteRetireDate = '2023-08-03', PermSecMapEndDate = '2025-06-13' WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496864672, ExchCode = 'DEU' WHERE SecCode = 1546652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954843, ExchCode = 'LAS' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802875945, ExchCode = 'LAS' WHERE SecCode = 1547496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705407, ExchCode = 'MXQ' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650254, ExchCode = 'DUS' WHERE SecCode = 1552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583635015, ExchCode = 'DEU' WHERE SecCode = 1552943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802455291, ExchCode = 'FRA' WHERE SecCode = 1553832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508750705, ExchCode = 'STU' WHERE SecCode = 1554784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498305313, ExchCode = 'FRA' WHERE SecCode = 1555173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21499806998, ExchCode = 'STO' WHERE SecCode = 1555177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639604213, ExchCode = 'MUN' WHERE SecCode = 1568506 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 PermSecMapEndDate = NULL WHERE SecCode = 1571280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489792, ExchCode = 'QTX' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386019, ExchCode = 'LAS' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479450, ExchCode = 'QTX' WHERE SecCode = 1584599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308500, ExchCode = 'FRA' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704832, ExchCode = 'MXQ' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302351, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 1600705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505370327, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1601529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553068247, ExchCode = 'TDG' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705694, ExchCode = 'MXQ' WHERE SecCode = 1621273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950789, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-10', PermSecMapEndDate = NULL WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368066, Ticker = 'PV0D', ExchCode = 'SES', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513069367, ExchCode = 'TDG' WHERE SecCode = 1635476 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 = 21514317171, Ticker = 'FOI', ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-22' WHERE SecCode = 1656381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602971036, PermQuoteStatus = 'AC', Ticker = 'PJSBd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 1660702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485319, ExchCode = 'QTX' WHERE SecCode = 1675772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520358, ExchCode = 'FRA' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776251703, ExchCode = 'TDG', PermQuoteRetireDate = '2024-08-13' WHERE SecCode = 1696044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431652, ExchCode = 'FRA' WHERE SecCode = 1707747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641955323, ExchCode = 'DEU' WHERE SecCode = 1707749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927493, ExchCode = 'BER' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528495375, ExchCode = 'BTE' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811337244, ExchCode = 'STU' WHERE SecCode = 1723207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513762717, ExchCode = 'FRA' WHERE SecCode = 1736071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513239137, Ticker = 'BO4', ExchCode = 'DEU' WHERE SecCode = 1740287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538295288, ExchCode = 'FRA' WHERE SecCode = 1768937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513751840, ExchCode = 'STU' WHERE SecCode = 1795399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599860800, ExchCode = 'FRA' WHERE SecCode = 1905111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585026984, ExchCode = 'BTE' WHERE SecCode = 1931297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673265, ExchCode = 'BIV' WHERE SecCode = 2014210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798387630, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2043821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802863785, ExchCode = 'FRA' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434590, ExchCode = 'LAS' WHERE SecCode = 2087879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785264817, ExchCode = 'FRA' WHERE SecCode = 2087993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519124047, ExchCode = 'DEU' WHERE SecCode = 2102681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519268705, ExchCode = 'FRA' WHERE SecCode = 2110703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659437, ExchCode = 'GTX' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100421, ExchCode = 'QTX' WHERE SecCode = 2142278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786104642, ExchCode = 'DEU' WHERE SecCode = 2147795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769222052, ExchCode = 'BER' WHERE SecCode = 2173307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523128250, ExchCode = 'DEU' WHERE SecCode = 2195966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521581559, ExchCode = 'FRA' WHERE SecCode = 2200210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729890709, ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-16', PermSecMapEndDate = '2025-06-26' WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431292, ExchCode = 'FRA' WHERE SecCode = 2213927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522741364, ExchCode = 'FRA' WHERE SecCode = 2226882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306937, ExchCode = 'BEC' WHERE SecCode = 2226896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831441, ExchCode = 'DEU' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781570154, ExchCode = 'DUS' WHERE SecCode = 2239280 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 = 21807437652, ExchCode = 'STU' WHERE SecCode = 2240598 AND Type_ = 10;
UPDATE data_universe_permid SET QuoteClass = 'CHESS' WHERE SecCode = 2272513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732298243, ExchCode = 'DUS' WHERE SecCode = 2278251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529849856, ExchCode = 'BER' WHERE SecCode = 2288360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525927842, ExchCode = 'DEU', PermQuoteRetireDate = '2021-06-08' WHERE SecCode = 2289254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816905149, ExchCode = 'TDG' WHERE SecCode = 2321765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834371, ExchCode = 'DEU' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571803982, ExchCode = 'BCO' WHERE SecCode = 2350987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781180887, ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-16' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530263647, ExchCode = 'FRA' WHERE SecCode = 2357967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529719631, ExchCode = 'TDG' WHERE SecCode = 2357969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484790, ExchCode = 'QTX' WHERE SecCode = 2357974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704335, Ticker = 'BKIAN', ExchCode = 'MXQ' WHERE SecCode = 2361848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704400, ExchCode = 'MXQ' WHERE SecCode = 2362819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530485265, ExchCode = 'DEU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850703312, ExchCode = 'TDG' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369453, ExchCode = 'BEC' WHERE SecCode = 2377498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419067, ExchCode = 'LAS' WHERE SecCode = 2377960 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951677.0 WHERE SecCode = 2378942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480719, ExchCode = 'QTX' WHERE SecCode = 2381585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604521757, ExchCode = 'MUN' WHERE SecCode = 2382351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531130867, InstrPermID = 8590926370, OrgPermID = 4295858498, ValQuotePermID = 55835583224.0, PriInstrPermID = 8590926370.0, PermInstrStatus = 'AC', Ticker = 'MQG0d', ExchCode = 'BCO', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = 4294951922.0, PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2013-10-29' WHERE SecCode = 2387360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336720, ExchCode = 'FRA' WHERE SecCode = 2397377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491758, ExchCode = 'QTX' WHERE SecCode = 2403143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847717686, ExchCode = 'GTX' WHERE SecCode = 2404625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705370, ExchCode = 'MXQ' WHERE SecCode = 2407194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726938, ExchCode = 'MUN' WHERE SecCode = 2425600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22005177098, ExchCode = 'DEU' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533684531, ExchCode = 'DEU' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489670, ExchCode = 'QTX' WHERE SecCode = 2448345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493842, ExchCode = 'QTX' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768409198, ExchCode = 'DUS' WHERE SecCode = 2456856 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 = 21537245207, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 2466348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538229, ExchCode = 'GTX' WHERE SecCode = 2479012 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 QuotePermID = 21600289177, Ticker = '9OR', ExchCode = 'DUS', PermQuoteRetireDate = '2017-09-26' WHERE SecCode = 2511582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134690, ExchCode = 'DEU' WHERE SecCode = 2513070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430820, ExchCode = 'DEU' WHERE SecCode = 2513107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134819, ExchCode = 'FRA' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893352, ExchCode = 'TDG' WHERE SecCode = 2518731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851779859, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 2519541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609327643, ExchCode = 'TDG' WHERE SecCode = 2522906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869002235, ExchCode = 'DEU', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439508, ExchCode = 'DUS' WHERE SecCode = 2532821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539323911, ExchCode = 'FRA' WHERE SecCode = 2534073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673930, ExchCode = 'BIV' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688529407, Ticker = '53S1', ExchCode = 'DUS', PermQuoteRetireDate = '2021-06-25' WHERE SecCode = 2550286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542254187, ExchCode = 'DEU' WHERE SecCode = 2563203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704201, Ticker = 'AGNN', ExchCode = 'MXQ' WHERE SecCode = 2563205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683756999, ExchCode = 'TDG', PermQuoteRetireDate = '2024-02-07' WHERE SecCode = 2572309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704701, ExchCode = 'MXQ' WHERE SecCode = 2572316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545190668, ExchCode = 'FRA', PermQuoteRetireDate = '2014-12-29' WHERE SecCode = 2578855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830369, ExchCode = 'DUS' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284826, ExchCode = 'GTX' WHERE SecCode = 2585381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544213987, ExchCode = 'TDG', PermQuoteRetireDate = '2020-05-26' WHERE SecCode = 2593544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544726151, ExchCode = 'DEU' WHERE SecCode = 2599304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670880, ExchCode = 'AUX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22068008873, ExchCode = 'DXE' WHERE SecCode = 2600076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544378913, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-23' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545105822, ExchCode = 'FRA' WHERE SecCode = 2604390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652008404, ExchCode = 'TDG', PermQuoteRetireDate = '2025-02-13', PermSecMapEndDate = '2025-02-21' WHERE SecCode = 2622293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704351, ExchCode = 'MXQ' WHERE SecCode = 2625107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546596463, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 2627627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384982, ExchCode = 'LAS' WHERE SecCode = 2630989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062334, ExchCode = 'MUN' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634652632, ExchCode = 'MUN' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547157215, ExchCode = 'DEU' WHERE SecCode = 2635746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547457190, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2636990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659184279, ExchCode = 'MUN' WHERE SecCode = 2644157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414445, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2644161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840571, ExchCode = 'DEU' WHERE SecCode = 2649167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549411041, ExchCode = 'FRA', PermQuoteRetireDate = '2017-11-02' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549921078, ExchCode = 'BTE' WHERE SecCode = 2665921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596919201, ExchCode = 'CHI' WHERE SecCode = 2679866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551269259, ExchCode = 'TDG' WHERE SecCode = 2700708 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951778.0 WHERE SecCode = 2701631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955513813, ExchCode = 'DUS' WHERE SecCode = 2711152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198687, ExchCode = 'BIV' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554500349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-03' WHERE SecCode = 2750984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555272551, ExchCode = 'DEU' WHERE SecCode = 2764597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789940347, ExchCode = 'FRA' WHERE SecCode = 2764598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391628, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2766048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704388, ExchCode = 'MXQ' WHERE SecCode = 2767208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704882, ExchCode = 'MXQ' WHERE SecCode = 2769192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588924110, ExchCode = 'TDG', PermQuoteRetireDate = '2019-10-01' WHERE SecCode = 2770609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479008, ExchCode = 'QTX' WHERE SecCode = 2807599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322186, ExchCode = 'DEU' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704598, ExchCode = 'MXQ' 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 = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684294108, ExchCode = 'TDG', PermQuoteRetireDate = '2019-04-03' WHERE SecCode = 2855771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955946, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-02-19' WHERE SecCode = 2856999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603343761, ExchCode = 'TDG' WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650334, ExchCode = 'QTX' WHERE SecCode = 2858551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563864602, ExchCode = 'FRA' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704681, ExchCode = 'MXQ' WHERE SecCode = 2876241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385190, ExchCode = 'LAS' WHERE SecCode = 2880972 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2884682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564231392, ExchCode = 'TRQ', PermQuoteRetireDate = '2015-05-28' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564572205, ExchCode = 'TDG' WHERE SecCode = 2905610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478659, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2909243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285585, ExchCode = 'GTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679813, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 2924567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370656, ExchCode = 'SGO' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566883039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2930544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589809334, ExchCode = 'TDG', PermQuoteRetireDate = '2019-11-20' WHERE SecCode = 2930555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608858954, Ticker = '34L', ExchCode = 'GER', PermQuoteRetireDate = '2017-07-25', PermSecMapEndDate = '2024-05-20' WHERE SecCode = 2935091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033693, InstrPermID = 8590942120, OrgPermID = 4295862624, ValQuotePermID = 55838794989.0, PriInstrPermID = 8590942120.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'A4L', ExchCode = 'TDG', PermQuoteRetireDate = '2015-07-06', PermOrgIPODate = NULL WHERE SecCode = 2939990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100044, ExchCode = 'MUN' WHERE SecCode = 2946497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731165568, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659445, ExchCode = 'GTX' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706327513, ExchCode = 'TDG' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461911, ExchCode = 'STU' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573048228, ExchCode = 'BCO', PermQuoteRetireDate = '2015-10-12' WHERE SecCode = 2993543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573513525, ExchCode = 'FRA' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431770, ExchCode = 'DEU' WHERE SecCode = 3026614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591864421, ExchCode = 'STU' WHERE SecCode = 3030075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576576313, PermQuoteStatus = 'DC', Ticker = 'IWI', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3031598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21578812986, ExchCode = 'DEU' WHERE SecCode = 3056842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619609100, ExchCode = 'MUN' WHERE SecCode = 3065856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585828975, Ticker = 'RYAA', ExchCode = 'STU', PermQuoteRetireDate = '2023-12-08' WHERE SecCode = 3072584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582927995, ExchCode = 'FRA' WHERE SecCode = 3101224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763489945, ExchCode = 'FRA' WHERE SecCode = 3120784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953916121, ExchCode = 'GTX' WHERE SecCode = 3124235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320061, ExchCode = 'DEU' WHERE SecCode = 3124241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933107501, ExchCode = 'MUN' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552305555, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587220566, ExchCode = 'TDG' WHERE SecCode = 3153872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929444790, ExchCode = 'QTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MYS' WHERE SecCode = 3167840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887241129, ExchCode = 'BTE' WHERE SecCode = 3174320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705812, Ticker = 'TLRDQ*', ExchCode = 'MXQ' WHERE SecCode = 3177778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749466038, ExchCode = 'MUN' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798143359, ExchCode = 'FRA' WHERE SecCode = 3186751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011949508, ExchCode = 'AQX' WHERE SecCode = 3193718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589812234, ExchCode = 'DEU' WHERE SecCode = 3195401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460752, ExchCode = 'FRA' WHERE SecCode = 3195424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460735, ExchCode = 'FRA' WHERE SecCode = 3195425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460751, ExchCode = 'FRA' WHERE SecCode = 3195426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589742989, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3196346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179524217, ExchCode = 'STU', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 3198705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768480038, ExchCode = 'MUN' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629963304, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-22' WHERE SecCode = 3199703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448726, ExchCode = 'FRA' WHERE SecCode = 3213266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604452283, ExchCode = 'STU', PermQuoteRetireDate = '2023-06-12', PermSecMapEndDate = NULL WHERE SecCode = 3213267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783235612, ExchCode = 'STU' WHERE SecCode = 3213268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625006481, ExchCode = 'DEU' WHERE SecCode = 3215534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592182617, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-29', PermSecMapEndDate = '2023-09-29' WHERE SecCode = 3215568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609921006, ExchCode = 'STU' WHERE SecCode = 3222698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747327546, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595110980, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3229527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683901733, ExchCode = 'MUN', PermQuoteRetireDate = '2020-08-11' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718045329, ExchCode = 'MUN' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386950, Ticker = '0EF', ExchCode = 'LAS' WHERE SecCode = 3246454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478399, ExchCode = 'QTX' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591485238, Ticker = '1CBK', ExchCode = 'MIL' WHERE SecCode = 3247531 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 = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599532242, ExchCode = 'DEU' WHERE SecCode = 3269645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599774622, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 3271586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951931.0 WHERE SecCode = 3276285 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951711.0 WHERE SecCode = 3277003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754774965, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-10-24' WHERE SecCode = 3282701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760582105, ExchCode = 'TDG' WHERE SecCode = 3282881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604352845, ExchCode = 'STU' WHERE SecCode = 3283650 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 = 21638239090, ExchCode = 'BCO' WHERE SecCode = 3301720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690196182, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3301805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833126, ExchCode = 'FRA' WHERE SecCode = 3304184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782726136, ExchCode = 'AQX' WHERE SecCode = 3304228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607100433, ExchCode = 'MUN' WHERE SecCode = 3305420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546129, ExchCode = 'MUN' WHERE SecCode = 3308987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679737, ExchCode = 'BIV' WHERE SecCode = 3309397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743775985, ExchCode = 'DEU', PermQuoteRetireDate = '2022-02-14' WHERE SecCode = 3309705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608270955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679353, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22057914115, ExchCode = 'DEU' WHERE SecCode = 3315780 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 = 21608659181, ExchCode = 'STU' WHERE SecCode = 3316586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388165, ExchCode = 'LAS' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609137328, ExchCode = 'FRA' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679409, ExchCode = 'BIV' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609211563, ExchCode = 'FRA' WHERE SecCode = 3317714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610381430, ExchCode = 'DEU', PermQuoteRetireDate = '2022-12-02', PermSecMapEndDate = '2022-12-02' WHERE SecCode = 3318355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609745552, ExchCode = 'DEU' WHERE SecCode = 3318532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782646060, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133418, ExchCode = 'FRA' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753722337, ExchCode = 'DEU' WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443153, ExchCode = 'FRA' WHERE SecCode = 3320334 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 = 21612487102, ExchCode = 'DEU' WHERE SecCode = 3339668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612487416, ExchCode = 'DEU' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890665712, ExchCode = 'GTX' WHERE SecCode = 3346903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549117, ExchCode = 'GTX' WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621961481, Ticker = '4PSM', ExchCode = 'ETX' WHERE SecCode = 3347660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367733, ExchCode = 'CHA' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598843088, ExchCode = 'MEX' WHERE SecCode = 3357133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614525593, ExchCode = 'FRA', PermQuoteRetireDate = '2026-05-07' WHERE SecCode = 3357940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750146923, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3357943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614525574, ExchCode = 'DEU' WHERE SecCode = 3357972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614679451, ExchCode = 'STU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679354, ExchCode = 'BIV' WHERE SecCode = 3358164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615240978, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 3358228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615298321, ExchCode = 'TRQ' WHERE SecCode = 3358414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615253063, ExchCode = 'TDG' WHERE SecCode = 3358543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481705424, ExchCode = 'DEU' WHERE SecCode = 3358616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617014521, Ticker = '4EVK', ExchCode = 'ETX' 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 = 21615050419, ExchCode = 'DEU' WHERE SecCode = 3359272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807021734, Ticker = 'BAYNv', ExchCode = 'BCO' WHERE SecCode = 3364951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615998446, Ticker = '14G', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3366981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875267, ExchCode = 'TDG' WHERE SecCode = 3368562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648301745, ExchCode = 'STU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631611214, ExchCode = 'TDG' WHERE SecCode = 3377762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641457506, ExchCode = 'MUN' WHERE SecCode = 3378583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674239, ExchCode = 'BIV' WHERE SecCode = 3379186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765833817, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733749573, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3382234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766019467, ExchCode = 'DEU' WHERE SecCode = 3386374 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 = 21920549797, ExchCode = 'DEU' WHERE SecCode = 3392279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644928542, ExchCode = 'BER', PermQuoteRetireDate = '2022-06-21', PermSecMapEndDate = '2022-08-03' WHERE SecCode = 3393655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029262, ExchCode = 'SWX' WHERE SecCode = 3393999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029268, ExchCode = 'SWX' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029272, ExchCode = 'SWX' WHERE SecCode = 3394008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029277, ExchCode = 'SWX' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029271, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-07-04' WHERE SecCode = 3394028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390634, ExchCode = 'DEU' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623455650, ExchCode = 'BCO' WHERE SecCode = 3395249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169958746, ExchCode = 'DEU' WHERE SecCode = 3395352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792285260, Ticker = 'MEOv', ExchCode = 'BCO' WHERE SecCode = 3395686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750324117, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-02' WHERE SecCode = 3395882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623803395, ExchCode = 'FRA' WHERE SecCode = 3396014 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 3396785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624942707, ExchCode = 'TDG', PermQuoteRetireDate = '2023-03-10' WHERE SecCode = 3396885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334939, ExchCode = 'DEU' WHERE SecCode = 3396923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145793081, ExchCode = 'DEU' WHERE SecCode = 3401911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640356575, PermQuoteStatus = 'DC', Ticker = 'G0A1', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 3401914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764861300, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-01', PermSecMapEndDate = '2021-10-01' WHERE SecCode = 3402310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674061, ExchCode = 'BIV' WHERE SecCode = 3403875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779748, ExchCode = 'MUN' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141123, ExchCode = 'FRA' WHERE SecCode = 3405304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628652762, ExchCode = 'STU', PermQuoteRetireDate = '2024-09-30', PermSecMapEndDate = NULL WHERE SecCode = 3405438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628937008, ExchCode = 'TDG' WHERE SecCode = 3405439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709687546, PermQuoteStatus = 'AC', Ticker = 'S060', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3406028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628252946, ExchCode = 'DEU' WHERE SecCode = 3406379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334821, ExchCode = 'DEU' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679776, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624076993, ExchCode = 'SGO' WHERE SecCode = 3406544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628936507, ExchCode = 'TDG', PermQuoteRetireDate = '2022-11-17' WHERE SecCode = 3406929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256368, ExchCode = 'QTX' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784205314, ExchCode = 'FRA' WHERE SecCode = 3407871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702351505, ExchCode = 'FRA', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = NULL WHERE SecCode = 3408727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679932, ExchCode = 'BIV' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630022342, ExchCode = 'STU' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175400111, ExchCode = 'DEU' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805162201, ExchCode = 'FRA' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644146276, ExchCode = 'FRA' WHERE SecCode = 3409040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396615, ExchCode = 'DEU' WHERE SecCode = 3409090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655828146, ExchCode = 'FRA' WHERE SecCode = 3409091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668632583, ExchCode = 'DEU' WHERE SecCode = 3409175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786141622, ExchCode = 'MXQ' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630231279, Ticker = 'NMB', ExchCode = 'FRA' WHERE SecCode = 3409323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384246, ExchCode = 'LAS' WHERE SecCode = 3409373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631199559, ExchCode = 'STU' WHERE SecCode = 3410277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632630898, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-02-21', PermSecMapEndDate = '2026-01-29' WHERE SecCode = 3418906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905907543, ExchCode = 'GTX' WHERE SecCode = 3424652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632630922, ExchCode = 'FRA', PermQuoteRetireDate = '2025-02-26', PermSecMapEndDate = '2025-02-26' WHERE SecCode = 3428077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678582, ExchCode = 'BIV' WHERE SecCode = 3430824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761780224, ExchCode = 'FRA' WHERE SecCode = 3430952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634766459, ExchCode = 'DEU' WHERE SecCode = 3432164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633180258, Ticker = '0RNH', ExchCode = 'LSE' WHERE SecCode = 3433480 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3433491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714769258, ExchCode = 'TDG' WHERE SecCode = 3435060 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 3435533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 3436849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21834281133, ExchCode = 'TDG' WHERE SecCode = 3438714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643435020, ExchCode = 'FRA' WHERE SecCode = 3441171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643703119, ExchCode = 'DEU' WHERE SecCode = 3444720 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SRN' WHERE SecCode = 3445122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644367377, ExchCode = 'DEU' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679474, ExchCode = 'BIV' WHERE SecCode = 3446301 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 = 236782180687, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3446753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181250, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647637329, ExchCode = 'TDG' WHERE SecCode = 3490936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794206137, ExchCode = 'TDG' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669695686, ExchCode = 'BTE', PermQuoteRetireDate = '2022-07-12' WHERE SecCode = 3499290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679543, ExchCode = 'BIV' WHERE SecCode = 3501496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881520736, ExchCode = 'GTX' WHERE SecCode = 3501595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557761621, ExchCode = 'SGO' WHERE SecCode = 3501596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749465975, ExchCode = 'MUN' WHERE SecCode = 3503523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308229, ExchCode = 'GTX' WHERE SecCode = 3513998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651518719, ExchCode = 'BER' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275451, ExchCode = 'GTX' WHERE SecCode = 3518267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705225, Ticker = 'JOBSN', ExchCode = 'MXQ' WHERE SecCode = 3518311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284830, ExchCode = 'GTX' WHERE SecCode = 3525431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272845, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3526200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652485956, ExchCode = 'MUN', PermQuoteRetireDate = '2018-07-05', PermSecMapEndDate = '2018-07-05' WHERE SecCode = 3529083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830287256, ExchCode = 'GTX' WHERE SecCode = 3535855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655225300, Ticker = '28S', ExchCode = 'STU', PermQuoteRetireDate = '2024-09-03' 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 = 21923658469, ExchCode = 'EQD' WHERE SecCode = 3551896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288448, ExchCode = 'GTX' WHERE SecCode = 3555035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656850928, ExchCode = 'FRA' WHERE SecCode = 3558191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763476007, PermQuoteStatus = 'DC', Ticker = '0NBA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-06-11' WHERE SecCode = 3574017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705892, ExchCode = 'MXQ' WHERE SecCode = 3580734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301128, ExchCode = 'GTX' WHERE SecCode = 3584556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624891, Ticker = 'CSC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 3586971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598347923, ExchCode = 'AUX' WHERE SecCode = 3588027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616916071, Ticker = 'SANDS', ExchCode = 'LIS', PermQuoteRetireDate = '2017-07-18' WHERE SecCode = 3588029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552355, ExchCode = 'LAS' WHERE SecCode = 3588063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775216436, ExchCode = 'MUN' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704616, ExchCode = 'MXQ' WHERE SecCode = 3588107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569854, ExchCode = 'QTX' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952428, ExchCode = 'FRA' WHERE SecCode = 3591601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666113143, ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704243, ExchCode = 'MXQ' WHERE SecCode = 3604834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664171446, PermQuoteStatus = 'DC', Ticker = '2HQ', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28' WHERE SecCode = 3610775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664433945, ExchCode = 'STU' WHERE SecCode = 3610818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704823, ExchCode = 'MXQ' WHERE SecCode = 3629694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668783322, ExchCode = 'HAN' WHERE SecCode = 3642406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705588, ExchCode = 'MXQ' WHERE SecCode = 3644857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581867, ExchCode = 'QTX' WHERE SecCode = 3657811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723938636, PermQuoteStatus = 'DC', Ticker = 'EP2', ExchCode = 'QTX', PermQuoteRetireDate = '2023-09-05' WHERE SecCode = 3663204 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ALTRA' WHERE SecCode = 3671118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672845652, ExchCode = 'FRA' WHERE SecCode = 3675648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569892, ExchCode = 'QTX' WHERE SecCode = 3675861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673827389, ExchCode = 'MEX' WHERE SecCode = 3717229 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3736002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704309, ExchCode = 'MXQ' WHERE SecCode = 3756608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704929, Ticker = 'GNKN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3761051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272950, ExchCode = 'GTX' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800738274, ExchCode = 'QTX' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431754, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-28' WHERE SecCode = 3779971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705324, ExchCode = 'MXQ' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623734, ExchCode = 'TDG' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696168646, ExchCode = 'DEU' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373317, ExchCode = 'MEX' WHERE SecCode = 3843165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841723701, ExchCode = 'DUS' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387101, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3849234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373509, ExchCode = 'BIV' WHERE SecCode = 3854663 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 QuotePermID = 21702351475, ExchCode = 'DEU', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21635089488, Ticker = '0JOQl', ExchCode = 'BCO' WHERE SecCode = 3885297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380310, ExchCode = 'LAS' 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 = 21726139038, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3899638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702310121, ExchCode = 'STU', PermQuoteRetireDate = '2019-07-15' WHERE SecCode = 3899640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703815178, ExchCode = 'DEU' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704921848, ExchCode = 'DEU' WHERE SecCode = 3906532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820592777, ExchCode = 'QTX' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027153, Ticker = '1NEMX' WHERE SecCode = 3932654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383362, ExchCode = 'MEX' WHERE SecCode = 3934323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715393197, ExchCode = 'DEU' WHERE SecCode = 3977296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371513, ExchCode = 'BIV' WHERE SecCode = 3977379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924367776, ExchCode = 'MUN' WHERE SecCode = 3987746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719305235, ExchCode = 'QTX' WHERE SecCode = 3997065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298922, ExchCode = 'GTX' WHERE SecCode = 4004564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' 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 = 21730598077, ExchCode = 'FRA', PermSecMapEndDate = NULL WHERE SecCode = 4016771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359630, ExchCode = 'MEX' WHERE SecCode = 4024645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787826668, Ticker = '1BACm', ExchCode = 'BCO' WHERE SecCode = 4031699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011932, Ticker = '2BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026934, Ticker = '1MS' WHERE SecCode = 4031717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011905, Ticker = '2ABBV' WHERE SecCode = 4031772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011913, Ticker = '2AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027148, Ticker = '1DHER' WHERE SecCode = 4031842 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 = 236780026920, Ticker = '1MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013994, Ticker = '2CRM' WHERE SecCode = 4032071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143797, Ticker = '2AKZA', ExchCode = 'MIL' WHERE SecCode = 4032088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143822, Ticker = '2UCB', ExchCode = 'MIL' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010953, Ticker = '2ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011967, Ticker = '2DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774922624, ExchCode = 'BCO' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725971281, ExchCode = 'TDG' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796059848, ExchCode = 'FRA' WHERE SecCode = 4046669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788219439, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727356453, ExchCode = 'BIV' WHERE SecCode = 4090018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738253265, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 4090028 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 = 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 = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815144829, Ticker = '49Y', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-20' WHERE SecCode = 4110882 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 = 25727352698, ExchCode = 'BIV' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674204, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745360055, ExchCode = 'DEU' WHERE SecCode = 4195339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772833533, Ticker = '4U1A', ExchCode = 'STU', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = NULL WHERE SecCode = 4212367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910492, ExchCode = 'STU' WHERE SecCode = 4212561 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 = 21753424155, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4245389 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 = 21756148826, ExchCode = 'MXQ' WHERE SecCode = 4273980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757455927, ExchCode = 'DEU' 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 = 21699218038, ExchCode = 'FRA' WHERE SecCode = 4298602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159899270, ExchCode = 'DEU' WHERE SecCode = 4298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696686071, ExchCode = 'STU' WHERE SecCode = 4298604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720132349, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4298606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759524962, ExchCode = 'FRA' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760599386, ExchCode = 'FRA' WHERE SecCode = 4303570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760599450, ExchCode = 'FRA' WHERE SecCode = 4303583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760292838, ExchCode = 'MUN' WHERE SecCode = 4303589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488721, ExchCode = 'STU' WHERE SecCode = 4303635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727343769, ExchCode = 'MEX' WHERE SecCode = 4303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792091537, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4310575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761780301, ExchCode = 'DEU' WHERE SecCode = 4310576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761900677, ExchCode = 'STU' WHERE SecCode = 4312160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381904, ExchCode = 'LAS' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763596291, ExchCode = 'DUS' WHERE SecCode = 4321393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763489973, ExchCode = 'FRA' WHERE SecCode = 4324465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763722641, ExchCode = 'DUS' WHERE SecCode = 4324504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867342843, ExchCode = 'TDG' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771445002, ExchCode = 'QTX' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877510586, ExchCode = 'MUN' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782535999, ExchCode = 'QTX' WHERE SecCode = 4372550 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 = 21738812998, ExchCode = 'DUS' WHERE SecCode = 4383309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777652111, ExchCode = 'FRA' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777644978, ExchCode = 'BER' WHERE SecCode = 4394782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826495190, ExchCode = 'DUS' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21779056060, ExchCode = 'STU', PermQuoteRetireDate = '2020-11-13', PermSecMapEndDate = '2020-11-16' WHERE SecCode = 4400157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777647867, ExchCode = 'TDG' WHERE SecCode = 4402301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727304584, ExchCode = 'MEX' WHERE SecCode = 4421213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782664057, ExchCode = 'DEU', PermQuoteRetireDate = '2024-10-31', PermSecMapEndDate = '2024-10-31' WHERE SecCode = 4422563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775216637, ExchCode = 'TDG' WHERE SecCode = 4422567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312259, ExchCode = 'MEX' WHERE SecCode = 4424570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307225, ExchCode = 'MEX' WHERE SecCode = 4426954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782653669, ExchCode = 'GTX' WHERE SecCode = 4426955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727303272, ExchCode = 'MEX' WHERE SecCode = 4426957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928415121, ExchCode = 'SIU' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-23' WHERE SecCode = 4434255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785453356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4436991 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 = 21788257884, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-28', PermSecMapEndDate = '2023-06-28' WHERE SecCode = 4449703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727299958, ExchCode = 'BIV' WHERE SecCode = 4449704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301154, ExchCode = 'MEX' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727314620, ExchCode = 'MEX' WHERE SecCode = 4458998 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MYS' WHERE SecCode = 4463152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306964, ExchCode = 'BEC' WHERE SecCode = 4464699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396721, ExchCode = 'DEU' WHERE SecCode = 4472911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396957, ExchCode = 'DEU' WHERE SecCode = 4472926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793674463, ExchCode = 'DUS' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689591, ExchCode = 'FRA' WHERE SecCode = 4474387 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 = 21834002300, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4479279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367136, ExchCode = 'FRA' WHERE SecCode = 4482517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367409, ExchCode = 'FRA' WHERE SecCode = 4482720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795591035, Ticker = '0A6N', ExchCode = 'LSE' 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 = 21798577575, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 4502498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727286506, ExchCode = 'MEX' WHERE SecCode = 4505794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409263, ExchCode = 'FRA' WHERE SecCode = 4505803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955219315, ExchCode = 'TDG' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851613, ExchCode = 'STU', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386877, ExchCode = 'LAS' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801066618, ExchCode = 'DEU' WHERE SecCode = 4517642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181247, ExchCode = 'DUS' WHERE SecCode = 4517645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781361764, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4517877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387389, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4527883 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 = 25727301437, ExchCode = 'BIV' 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 = 21806550607, ExchCode = 'FRA' WHERE SecCode = 4553829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807265022, PermQuoteStatus = 'AC', Ticker = '3K7A', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4557860 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 = 21819144478, ExchCode = 'FRA' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808951033, ExchCode = 'DEU', PermQuoteRetireDate = '2024-11-27', PermSecMapEndDate = '2024-11-27' WHERE SecCode = 4568425 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 = 21999011220, Ticker = '2INVEB' WHERE SecCode = 4601877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815149494, ExchCode = 'STU' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549166, ExchCode = 'GTX' 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 = 21816288448, ExchCode = 'DEU' WHERE SecCode = 4609999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818256303, ExchCode = 'STU' WHERE SecCode = 4617716 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 = 21818967405, ExchCode = 'DEU' WHERE SecCode = 4620159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816912799, ExchCode = 'DEU', PermQuoteRetireDate = '2021-06-14' WHERE SecCode = 4620951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878863898, Ticker = 'VETIz', ExchCode = 'BCO' WHERE SecCode = 4620952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820389350, ExchCode = 'FRA' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 4633110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438919, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4637752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312167, ExchCode = 'GTX' WHERE SecCode = 4637756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854881328, ExchCode = 'GTX' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334921, ExchCode = 'DEU' WHERE SecCode = 4643318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824104173, ExchCode = 'DEU' WHERE SecCode = 4645553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825617109, ExchCode = 'DEU' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827621995, Ticker = 'FWR', ExchCode = 'FRA' WHERE SecCode = 4657695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388759, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4658881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831549319, ExchCode = 'TDG' WHERE SecCode = 4671286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388764, ExchCode = 'LAS' WHERE SecCode = 4676228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419029, ExchCode = 'LAS' WHERE SecCode = 4680383 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 = 21835618427, ExchCode = 'FRA' WHERE SecCode = 4685514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21838659452, ExchCode = 'TDG' WHERE SecCode = 4693646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837527952, Ticker = 'CARB', ExchCode = 'MIL' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727293350, ExchCode = 'MEX' WHERE SecCode = 4699231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026894, Ticker = '1STX' WHERE SecCode = 4699232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581874, ExchCode = 'QTX' WHERE SecCode = 4707177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840890430, ExchCode = 'FRA' WHERE SecCode = 4709618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842933521, ExchCode = 'FRA' WHERE SecCode = 4716089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842933962, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4716090 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4717125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954835, ExchCode = 'LAS' WHERE SecCode = 4718902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843909546, ExchCode = 'TDG' WHERE SecCode = 4718903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843589781, ExchCode = 'MUN' WHERE SecCode = 4720468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846029349, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097356, ExchCode = 'LAS' WHERE SecCode = 4720520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843597790, ExchCode = 'FRA' WHERE SecCode = 4722188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845531907, ExchCode = 'MUN' WHERE SecCode = 4724688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878863894, Ticker = 'VDOUz', ExchCode = 'BCO' WHERE SecCode = 4724692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845076876, ExchCode = 'FRA' WHERE SecCode = 4724746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954884, ExchCode = 'LAS' WHERE SecCode = 4726104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851127888, ExchCode = 'DUS' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846049961, ExchCode = 'DEU' WHERE SecCode = 4727660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851127815, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4730173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21848093361, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4733053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850866652, ExchCode = 'TDG' WHERE SecCode = 4733055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847351964, ExchCode = 'FRA' WHERE SecCode = 4733108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850708573, ExchCode = 'MUN' WHERE SecCode = 4745391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439517, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-05-26' WHERE SecCode = 4748503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850878709, ExchCode = 'FRA', PermQuoteRetireDate = '2022-08-09' WHERE SecCode = 4748504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850719955, ExchCode = 'FRA' WHERE SecCode = 4748506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851141782, ExchCode = 'STU', PermQuoteRetireDate = '2025-10-27', PermSecMapEndDate = '2025-10-27' WHERE SecCode = 4748531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852758887, ExchCode = 'STU' WHERE SecCode = 4752188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814076491, ExchCode = 'DEU' WHERE SecCode = 4752207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561792, ExchCode = 'GTX' WHERE SecCode = 4754742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853887005, ExchCode = 'DUS' WHERE SecCode = 4754869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852735329, ExchCode = 'FRA' WHERE SecCode = 4756369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852735300, ExchCode = 'DEU' WHERE SecCode = 4756378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439422, ExchCode = 'DUS' WHERE SecCode = 4756621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136607450, Ticker = 'ETHWl', ExchCode = 'BTE' WHERE SecCode = 4756631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853953634, Ticker = '7XU', ExchCode = 'QTX' WHERE SecCode = 4761545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932244742, ExchCode = 'BCO' WHERE SecCode = 4761550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854742239, ExchCode = 'FRA' WHERE SecCode = 4761587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853887138, ExchCode = 'GTX' WHERE SecCode = 4761589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867733, ExchCode = 'FRA' WHERE SecCode = 4762975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854744263, ExchCode = 'QTX' WHERE SecCode = 4766038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727231195, ExchCode = 'BIV' WHERE SecCode = 4766049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854914847, PermQuoteStatus = 'AC', Ticker = '3FNG', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855114065, ExchCode = 'GTX' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307219, ExchCode = 'BIV' WHERE SecCode = 4768117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854877140, ExchCode = 'DUS' WHERE SecCode = 4768286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905907535, ExchCode = 'GTX' WHERE SecCode = 4771746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018892, ExchCode = 'STU' WHERE SecCode = 4773770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856019028, ExchCode = 'MUN' WHERE SecCode = 4775072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856021925, ExchCode = 'DEU' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126858445, ExchCode = 'DEU' WHERE SecCode = 4775075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856722496, ExchCode = 'MUN' WHERE SecCode = 4775201 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 = 21857609722, ExchCode = 'DUS' 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 = 21858705511, ExchCode = 'STU' WHERE SecCode = 4786540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858098062, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-11', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4786544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546869, ExchCode = 'DEU' WHERE SecCode = 4794550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860831312, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4800552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860309686, ExchCode = 'MUN' WHERE SecCode = 4800558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954958, ExchCode = 'LAS' WHERE SecCode = 4802301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569860, ExchCode = 'QTX' WHERE SecCode = 4804831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861185786, Ticker = 'QQQ5', ExchCode = 'LSE' WHERE SecCode = 4806672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161390154, Ticker = 'CON3l', ExchCode = 'CHI' WHERE SecCode = 4806678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907559014, ExchCode = 'MUN', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799369659, ExchCode = 'CHI' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815777446, ExchCode = 'FRA' WHERE SecCode = 4815314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772241331, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-03' WHERE SecCode = 4815315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192887, ExchCode = 'DEU' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862998607, ExchCode = 'QTX' WHERE SecCode = 4818264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684618, ExchCode = 'DUS' WHERE SecCode = 4818275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863832485, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4819644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947043272, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4819881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290739, ExchCode = 'MUN' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4827909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873923001, ExchCode = 'DUS' WHERE SecCode = 4830767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580393, ExchCode = 'DEU' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580680, ExchCode = 'DEU' 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 = 236781830057, ExchCode = 'QTX' WHERE SecCode = 4834795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866893816 WHERE SecCode = 4841211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398389, ExchCode = 'GER', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' 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 = 21888021696, ExchCode = 'GTX' WHERE SecCode = 4846846 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'BIO1' WHERE SecCode = 4850230 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 PermOrgIPODate = NULL WHERE SecCode = 4854749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140095713, ExchCode = 'HAM' WHERE SecCode = 4854866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144452987, ExchCode = 'LAS' WHERE SecCode = 4854867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089452780, ExchCode = 'DXE' WHERE SecCode = 4854872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872098103, ExchCode = 'DEU' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871067926, ExchCode = 'DEU' WHERE SecCode = 4863020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871894898, ExchCode = 'DEU' WHERE SecCode = 4868662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874648333, Ticker = '9XK', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4873803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873061105, ExchCode = 'TDG' WHERE SecCode = 4878702 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 = 21874656927, ExchCode = 'FRA' WHERE SecCode = 4889264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885726, ExchCode = 'FRA' WHERE SecCode = 4890300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876864887, ExchCode = 'DEU', PermQuoteRetireDate = '2022-09-15' WHERE SecCode = 4893294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434498, ExchCode = 'QTX' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884787334, ExchCode = 'FRA', PermQuoteRetireDate = '2025-04-23' 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 = 236781650257, ExchCode = 'DUS' WHERE SecCode = 4960868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100807, ExchCode = 'DUS', PermQuoteRetireDate = '2024-04-17' WHERE SecCode = 4960909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22088974428, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4965018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179547064, Ticker = NULL, ExchCode = 'HAM' WHERE SecCode = 4965038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650269, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2025-10-22' WHERE SecCode = 4965060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097169, ExchCode = 'LAS' WHERE SecCode = 4973326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21926247930, PermQuoteStatus = 'DC', Ticker = 'V6M', ExchCode = 'FRA', PermQuoteRetireDate = '2022-10-31' WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650201, ExchCode = 'DUS' WHERE SecCode = 4973334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740549, ExchCode = 'LAS' WHERE SecCode = 4973342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580715, ExchCode = 'DUS' WHERE SecCode = 4991678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897771188, Ticker = '4COIN', ExchCode = 'ETX' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197369, ExchCode = 'BIV' WHERE SecCode = 5030308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898242757, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2026-03-19', PermSecMapEndDate = '2026-03-19' WHERE SecCode = 5038681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010091549, Ticker = 'ETHCHz', ExchCode = 'TQE' WHERE SecCode = 5038682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823905, ExchCode = 'AQX' WHERE SecCode = 5038689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388832, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976743, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5042969 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 = 21907031229, ExchCode = 'STU' WHERE SecCode = 5067269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902629320, ExchCode = 'QTX' WHERE SecCode = 5067289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238786, ExchCode = 'LAS' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931483023, ExchCode = 'MUN' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663797, ExchCode = 'DEU' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380640, ExchCode = 'LAS' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782329716, ExchCode = 'QTX' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727217398, ExchCode = 'BIV' WHERE SecCode = 5083954 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5085786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898584, ExchCode = 'FRA', PermQuoteRetireDate = '2024-07-31' WHERE SecCode = 5099027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729398003, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-31' WHERE SecCode = 5099028 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5114180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898202, PermQuoteStatus = 'AC', Ticker = '3SFBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5115635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911557492, ExchCode = 'STU' WHERE SecCode = 5115641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781637018, ExchCode = 'HAM' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923404247, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-21' WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642004, ExchCode = 'QTX' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947712258, ExchCode = 'GTX' WHERE SecCode = 5140200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381394, ExchCode = 'LAS' WHERE SecCode = 5153443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634297955, Ticker = '0M1Kl', ExchCode = 'BCO' WHERE SecCode = 5161267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508528400, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL 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 = 21793689627, ExchCode = 'DEU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836515912, Ticker = 'SQT', ExchCode = 'FRA', PermQuoteRetireDate = '2016-10-11' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475730650, ExchCode = 'GER', PermQuoteRetireDate = '2005-10-08' WHERE SecCode = 5161443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727196907, ExchCode = 'MEX' WHERE SecCode = 5161445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197642, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569896, ExchCode = 'QTX' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561584, ExchCode = 'DUS' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234849, ExchCode = 'QTX' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397388, ExchCode = 'GTX' WHERE SecCode = 5189106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421566, PermQuoteStatus = 'AC', Ticker = '3SZNm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5195447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904165, ExchCode = 'BCO' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872761574, Ticker = 'AFTT', ExchCode = 'PAR' WHERE SecCode = 5206274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871539362, Ticker = 'ALINK', ExchCode = 'AEX' WHERE SecCode = 5206286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833306231, Ticker = '3LNI', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5208067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47733359571, ExchCode = 'FRA' WHERE SecCode = 5209761 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 = 25727227059, ExchCode = 'MEX' WHERE SecCode = 5238268 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727192009, ExchCode = 'MEX' WHERE SecCode = 5251003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388879, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936132645, ExchCode = 'FRA' WHERE SecCode = 5258611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21934989086, ExchCode = 'STU' WHERE SecCode = 5260470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775222346, ExchCode = 'BIV' WHERE SecCode = 5267090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380702, ExchCode = 'LAS' WHERE SecCode = 5277530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938340072, ExchCode = 'STU' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938327486, ExchCode = 'DEU' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851306, ExchCode = 'LAS' WHERE SecCode = 5281346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780979385, ExchCode = 'DUS' WHERE SecCode = 5290322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956341568, ExchCode = 'HAN' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 5308065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077356, ExchCode = 'LAS', PermQuoteRetireDate = '2025-08-08', PermSecMapEndDate = NULL WHERE SecCode = 5311845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943095863, ExchCode = 'DUS', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 5313552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908505, PermQuoteStatus = 'DC', Ticker = '3QP0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5324087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776206905, ExchCode = 'MEX' WHERE SecCode = 5341594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789864381, ExchCode = 'TDG' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633707, ExchCode = 'DEU' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059916, ExchCode = 'DEU' WHERE SecCode = 5354968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510655, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-09' WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874420, ExchCode = 'GTX' WHERE SecCode = 5374941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803603455, ExchCode = 'TDG' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716837, ExchCode = 'FRA' WHERE SecCode = 5383598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520770967, ExchCode = 'DEU' WHERE SecCode = 5383600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535810, ExchCode = 'MEX' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777717367, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5413669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829302, ExchCode = 'TDG' WHERE SecCode = 5415164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47737705043, ExchCode = 'FRA' WHERE SecCode = 5444085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931510083, Ticker = '0ABM', ExchCode = 'LSE' WHERE SecCode = 5448761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47736749210, ExchCode = 'FRA' WHERE SecCode = 5453497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21974975281, ExchCode = 'DEU' WHERE SecCode = 5457243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416291, ExchCode = 'FRA' WHERE SecCode = 5476926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729828, ExchCode = 'FRA' WHERE SecCode = 5478214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585123, PermQuoteStatus = 'AC', ExchCode = 'MEX', PermQuoteRetireDate = NULL WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128275, ExchCode = 'BCO' WHERE SecCode = 5503898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085810217, ExchCode = 'BTE' WHERE SecCode = 5503900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861198674, Ticker = 'ARK3', ExchCode = 'LSE' WHERE SecCode = 5503901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836259, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110956, Ticker = 'SFTGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110937, Ticker = '3SFTm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22118178810, ExchCode = 'QTX' WHERE SecCode = 5540637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779515511, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5541732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471181, ExchCode = 'MEX' WHERE SecCode = 5542023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471183, ExchCode = 'BIV' WHERE SecCode = 5549613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777584027, ExchCode = 'BIV' WHERE SecCode = 5558570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834791, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512254, Ticker = '3SQEl', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5569214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882186850, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 5569241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110941, PermQuoteStatus = 'AC', Ticker = '3FNGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777360178, ExchCode = 'MEX' WHERE SecCode = 5581641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585114, ExchCode = 'MEX' WHERE SecCode = 5582137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997766265, Ticker = 'NGLS', ExchCode = 'LSE' WHERE SecCode = 5584733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780192624, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-29' WHERE SecCode = 5601088 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 5606775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22004617984, ExchCode = 'DEU' WHERE SecCode = 5607542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793574816, ExchCode = 'TDG' WHERE SecCode = 5623203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173432, ExchCode = 'BIV' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 5632223 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 = 22045078274, ExchCode = 'LAS' WHERE SecCode = 5636960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 5638703 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 = 22065452994, ExchCode = 'BRN' WHERE SecCode = 5645885 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 5650020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307748, ExchCode = 'BIV' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986191813, Ticker = '3TSE', ExchCode = 'GTX' WHERE SecCode = 5663514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197816, ExchCode = 'BIV' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778500348, ExchCode = 'BIV' WHERE SecCode = 5671941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863949657, ExchCode = 'PFT' WHERE SecCode = 5674188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779888282, ExchCode = 'BIV' WHERE SecCode = 5689842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782145877, ExchCode = 'BIV' WHERE SecCode = 5701236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099419639, Ticker = 'VPCUl', ExchCode = 'BCO' WHERE SecCode = 5702903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22026840053, ExchCode = 'STU' WHERE SecCode = 5703208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072896303, ExchCode = 'TDG' WHERE SecCode = 5715993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782653830, ExchCode = 'FRA' WHERE SecCode = 5731414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032608571, ExchCode = 'DEU' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032826044, ExchCode = 'DEU' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032827411, ExchCode = 'DEU' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782994251, ExchCode = 'STU' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937290998, ExchCode = 'DEU' WHERE SecCode = 5749952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419156, ExchCode = 'LAS' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782872491, ExchCode = 'MEX' WHERE SecCode = 5754129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22034763502, ExchCode = 'DEU' WHERE SecCode = 5764130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025956, ExchCode = 'LAS' WHERE SecCode = 5764717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353275, ExchCode = 'STU' WHERE SecCode = 5779319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181397, ExchCode = 'BIV' WHERE SecCode = 5779324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783236705, ExchCode = 'BIV' WHERE SecCode = 5779428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22036716457, ExchCode = 'DEU' WHERE SecCode = 5779432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22036716677, ExchCode = 'DEU' WHERE SecCode = 5779434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154585726, ExchCode = 'CHI' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802153233, Ticker = 'RZ8Bd', ExchCode = 'BCO' WHERE SecCode = 5782810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780991005, ExchCode = 'BIV' WHERE SecCode = 5790477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780479749, ExchCode = 'BIV' WHERE SecCode = 5798239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783782236, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5803178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22041834184, ExchCode = 'DEU' WHERE SecCode = 5814592 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 25727309689.0, ValQuotePermID = 21522153591.0 WHERE SecCode = 5814866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784418929, ExchCode = 'GTX' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551903, ExchCode = 'TDG' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'MK71' WHERE SecCode = 5833284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22113227758, ExchCode = 'STU' WHERE SecCode = 5839256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913582, ExchCode = 'DEU' WHERE SecCode = 5839462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600488, ExchCode = 'STU' WHERE SecCode = 5839464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601376, ExchCode = 'STU' WHERE SecCode = 5839466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913691, ExchCode = 'DEU' WHERE SecCode = 5839467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804071845, ExchCode = 'FRA' WHERE SecCode = 5853173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785217080, ExchCode = 'STU' WHERE SecCode = 5871394 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951318.0 WHERE SecCode = 5886924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785485963, ExchCode = 'TRQ' WHERE SecCode = 5886974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785605367, Ticker = '4WL0', ExchCode = 'FRA', PermQuoteRetireDate = '2025-04-30', PermSecMapEndDate = '2025-04-30' WHERE SecCode = 5894939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801352002, ExchCode = 'GTX' WHERE SecCode = 5894957 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 = 236786016617, ExchCode = 'STU' WHERE SecCode = 5908830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061950077, ExchCode = 'DEU' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787247684, ExchCode = 'MUN' WHERE SecCode = 5940279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798426772, ExchCode = 'MUN' WHERE SecCode = 5947065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786839717, ExchCode = 'STU' WHERE SecCode = 5947076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788815812, ExchCode = 'STU' WHERE SecCode = 5991096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789744668, ExchCode = 'LAS' WHERE SecCode = 6004713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714242, ExchCode = 'MEX' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136111007, Ticker = 'BITCl', ExchCode = 'CHI' WHERE SecCode = 6078418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136110997, Ticker = 'BITPl', ExchCode = 'BTE' WHERE SecCode = 6078420 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 = 21945886900, ExchCode = 'GTX' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110948, Ticker = '3GFMm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 6097282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151005, Ticker = 'FTNE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 6097285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679771, ExchCode = 'BIV' WHERE SecCode = 6097292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110935, Ticker = 'FTNGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-01' WHERE SecCode = 6097301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550078857, PermQuoteStatus = 'DC', Ticker = 'ECQ', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 6097302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421365, PermQuoteStatus = 'AC', Ticker = '3LNFm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 6097318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22088980768, ExchCode = 'BTE' WHERE SecCode = 6097329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078190, ExchCode = 'LAS' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151127, Ticker = '3SUE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 6097349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351672, ExchCode = 'MEX' WHERE SecCode = 6097355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566204, ExchCode = 'DEU' WHERE SecCode = 6097356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580190, ExchCode = 'FRA' WHERE SecCode = 6097360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799762, ExchCode = 'HAM' WHERE SecCode = 6097368 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 = 21917829806, ExchCode = 'DEU' 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 = 21917823853, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 6097452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779226797, PermQuoteStatus = 'DC', Ticker = '5VFC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-24' WHERE SecCode = 6097454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866394208, Ticker = '3SAM', ExchCode = 'MIL', PermQuoteRetireDate = '2025-10-07' WHERE SecCode = 6097566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354555, ExchCode = 'MEX' WHERE SecCode = 6097578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663670, ExchCode = 'AQX' WHERE SecCode = 6097580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784382116, ExchCode = 'LAS' WHERE SecCode = 6128378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799652797, ExchCode = 'LAS' WHERE SecCode = 6130384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089000964, ExchCode = 'DEU' WHERE SecCode = 6147594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791316273, ExchCode = 'FRA' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792959667, ExchCode = 'STU' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099147227, ExchCode = 'DEU' WHERE SecCode = 6232440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838443, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829970, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 6264074 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6264110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794006801, ExchCode = 'FRA' 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 = 21887549247, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793855800, ExchCode = 'TDG' WHERE SecCode = 6368981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795802495, ExchCode = 'QTX' WHERE SecCode = 6453946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451435, ExchCode = 'CHI' WHERE SecCode = 6456368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158030, ExchCode = 'CHI' WHERE SecCode = 6456369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154231077, ExchCode = 'BCO' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158021, ExchCode = 'CHI' WHERE SecCode = 6456372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141703201, ExchCode = 'CHI' WHERE SecCode = 6456373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451434, ExchCode = 'CHI' WHERE SecCode = 6456374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141447621, ExchCode = 'CHI' WHERE SecCode = 6456375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158040, ExchCode = 'CHI' WHERE SecCode = 6456376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451424, ExchCode = 'CHI' WHERE SecCode = 6456377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451440, ExchCode = 'BCO' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806835522, ExchCode = 'LAS' WHERE SecCode = 6464980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109805, ExchCode = 'DUS' WHERE SecCode = 6501107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938208, ExchCode = 'FRA' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938213, ExchCode = 'FRA' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938212, ExchCode = 'FRA' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938214, ExchCode = 'FRA' 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 = 236798746061, ExchCode = 'DUS' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798743592, ExchCode = 'DUS' WHERE SecCode = 6543898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727247403, Ticker = '9MW', ExchCode = 'BRN' WHERE SecCode = 6578375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792098121, ExchCode = 'BRN' 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 = 21903777191, ExchCode = 'HAN' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147097785, ExchCode = 'DEU' WHERE SecCode = 6603628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150005, ExchCode = 'SWX' WHERE SecCode = 6629465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802226956, ExchCode = 'GER' WHERE SecCode = 6635226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802588880, ExchCode = 'FRA' WHERE SecCode = 6645675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802593497, ExchCode = 'DUS' WHERE SecCode = 6645688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803460138, ExchCode = 'QTX' WHERE SecCode = 6686044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165601854, ExchCode = 'DEU' WHERE SecCode = 6716125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168342727, Ticker = 'DDUMl', ExchCode = 'SIG' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239278, ExchCode = 'TDG' WHERE SecCode = 6727870 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 QuotePermID = 236804755612, ExchCode = 'FRA' WHERE SecCode = 6737926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755696, ExchCode = 'FRA' WHERE SecCode = 6737927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755694, ExchCode = 'FRA' WHERE SecCode = 6737928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699530, ExchCode = 'MEX' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901586, ExchCode = 'CHI' WHERE SecCode = 6779523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805672065, ExchCode = 'FRA' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22094841699, ExchCode = 'TDG' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805997199, ExchCode = 'MEX' WHERE SecCode = 6802699 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'LVN1T' WHERE SecCode = 6806166 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 6813233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807018646, ExchCode = 'MUN' WHERE SecCode = 6813308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806467608, ExchCode = 'FRA' WHERE SecCode = 6826548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806467641, ExchCode = 'FRA' WHERE SecCode = 6826549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806467642, ExchCode = 'FRA' WHERE SecCode = 6826550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806467607, ExchCode = 'FRA' WHERE SecCode = 6826551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806467611, ExchCode = 'FRA' WHERE SecCode = 6826552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806468027, ExchCode = 'FRA' WHERE SecCode = 6826553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806468026, ExchCode = 'FRA' WHERE SecCode = 6826555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806468029, ExchCode = 'FRA' WHERE SecCode = 6826556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806467613, ExchCode = 'FRA' WHERE SecCode = 6826560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22177707113, ExchCode = 'DEU' WHERE SecCode = 6829248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178348922, ExchCode = 'DEU' WHERE SecCode = 6836182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178354350, ExchCode = 'DEU' WHERE SecCode = 6836183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178354486, ExchCode = 'DEU' WHERE SecCode = 6836184 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236806764869.0, PermInstrStatus = 'AC' WHERE SecCode = 6839609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179524402, ExchCode = 'STU' WHERE SecCode = 6843135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179518811, ExchCode = 'GTX' WHERE SecCode = 6843187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807024316, ExchCode = 'TDG' WHERE SecCode = 6843286 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6846676 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'DHR.H', ExchCode = 'NEX' WHERE SecCode = 10964736 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21565122724, ExchCode = 'GSB' WHERE SecCode = 10965319 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 10968126 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11002588 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11034601 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 25727309689.0, ValQuotePermID = 21522153591.0 WHERE SecCode = 11051526 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11068542 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11078359 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11111000 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11147281 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11172169 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'GXXM' WHERE SecCode = 11172296 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-14', PermSecMapEndDate = '2026-03-07' WHERE SecCode = 11191215 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727333428, ExchCode = 'LTM' WHERE SecCode = 11191702 AND Type_ = 1;
UPDATE data_universe_permid SET QuoteClass = 'CHESS' WHERE SecCode = 11204211 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11221982 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11229099 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11233976 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11236616 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-06-26' WHERE SecCode = 11249174 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727167715, IsPrimaryQuote = 0, Ticker = 'ALCUF', ExchCode = 'PNK' WHERE SecCode = 11252685 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727153242, IsPrimaryQuote = 0, Ticker = 'ALCYF', ExchCode = 'PNK' WHERE SecCode = 11254323 AND Type_ = 1;
UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11258099 AND Type_ = 1;
UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11260115 AND Type_ = 1;
UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11260116 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11268849 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'SNGPD' WHERE SecCode = 11269126 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11269370 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11273589 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11288034 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11288035 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11288036 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11288037 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11288047 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293016 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293017 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293018 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293019 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293020 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293021 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293022 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293023 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293024 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293025 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293026 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293027 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293028 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293029 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293030 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293031 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293032 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293033 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293034 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293035 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293036 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293037 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293038 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293039 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293040 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293041 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293042 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293043 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293044 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293045 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11293046 AND Type_ = 1;
