UPDATE data_universe_permid SET QuotePermID = 21531128468, Ticker = 'HONl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-16' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296006, PermQuoteStatus = 'DC', Ticker = 'ALV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 622 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 4784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757506064, Ticker = 'GECl', ExchCode = 'BCO', PermQuoteRetireDate = '2024-11-11' WHERE SecCode = 5363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475106512, Ticker = 'T6C', ExchCode = 'XIM', PermQuoteRetireDate = '2013-12-14' WHERE SecCode = 6070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575636421, Ticker = '0REH', ExchCode = 'LSE', PermQuoteRetireDate = '2016-02-18' WHERE SecCode = 6369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852139947, PermQuoteStatus = 'AC', Ticker = '0O1C', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 7986 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475107301, Ticker = 'IJFi', ExchCode = 'BTE' WHERE SecCode = 8027 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-01' WHERE SecCode = 27556 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-01', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 32631 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836399887, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 34072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838646696, ExchCode = 'STU' WHERE SecCode = 34242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835777336, ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-02' WHERE SecCode = 34391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722222275, Ticker = 'BTL', ExchCode = 'GER', PermQuoteRetireDate = '2022-08-15' WHERE SecCode = 34672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488569, ExchCode = 'QTX' WHERE SecCode = 35018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475575259, Ticker = 'BENE.I', ExchCode = 'CHE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 36266 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 QuotePermID = 21474904383, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475818377, ExchCode = 'STU' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506520538, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 37526 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 37567 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667482455, ExchCode = 'QTX' WHERE SecCode = 37812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337849, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 37823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509917171, ExchCode = 'TDG' WHERE SecCode = 37853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531520132, ExchCode = 'DEU' WHERE SecCode = 38209 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 PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 40000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288961, PermQuoteStatus = 'AC', Ticker = 'ISM', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 41356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296467, ExchCode = 'GTX' WHERE SecCode = 41736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652342644, ExchCode = 'FRA', PermQuoteRetireDate = '2021-11-03' WHERE SecCode = 42067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177550, Ticker = 'RYz', ExchCode = 'TRQ', PermQuoteRetireDate = '2023-03-21' WHERE SecCode = 42490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517229667, ExchCode = 'STU' WHERE SecCode = 44084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475759882, ExchCode = 'STU' WHERE SecCode = 44086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520627262, ExchCode = 'DEU' WHERE SecCode = 44154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475749257, Ticker = 'PRTY.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2022-08-31' WHERE SecCode = 44172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332647, Ticker = 'SI2', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19', PermSecMapEndDate = '2023-09-06' WHERE SecCode = 44174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324683, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 45854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474913868, Ticker = 'MACO', ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837367820, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 46294 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 46814 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951771.0 WHERE SecCode = 46915 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838489254, ExchCode = 'STU' WHERE SecCode = 47291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474922647, PermQuoteStatus = 'AC', Ticker = 'XMF', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 47703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838634755, ExchCode = 'STU' WHERE SecCode = 47823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308587, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 47966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033916, Ticker = 'BIL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-28' WHERE SecCode = 48081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836509476, ExchCode = 'FRA', PermQuoteRetireDate = '2019-04-15' WHERE SecCode = 48122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718618352, Ticker = 'DYH', ExchCode = 'GER' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034685, ExchCode = 'TDG' WHERE SecCode = 48468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492562, ExchCode = 'QTX' WHERE SecCode = 49173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836027147, Ticker = 'WLG', ExchCode = 'ISE', PermQuoteRetireDate = '2016-10-24' WHERE SecCode = 51130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690644536, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 51563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475047482, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 51564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642496487, ExchCode = 'CHI' WHERE SecCode = 52632 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475420970, ExchCode = 'GER' WHERE SecCode = 52842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535194629, Ticker = 'AHOG', ExchCode = 'BRN' WHERE SecCode = 52844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474978888, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL 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 = 21475721140, Ticker = 'HYUG.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 53627 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 = 55857585867, ExchCode = 'GER' WHERE SecCode = 53813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574510968, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-06' WHERE SecCode = 53833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033479, PermQuoteStatus = 'AC', Ticker = 'LHL', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 53991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508750038, ExchCode = 'TDG' WHERE SecCode = 54302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474961860, PermQuoteStatus = 'AC', Ticker = 'MGY', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 54416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679489, ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-20' WHERE SecCode = 54422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512066320, ExchCode = 'DEU' WHERE SecCode = 54435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491901, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 54552 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 = 21537831369, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 55286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475431208, ExchCode = 'GER', PermQuoteRetireDate = '2008-10-07' WHERE SecCode = 56393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608949117, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 58289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649420924, ExchCode = 'STU' WHERE SecCode = 58298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035551, PermQuoteStatus = 'AC', Ticker = 'REP', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 58416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486786, ExchCode = 'QTX' WHERE SecCode = 58663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837352812, ExchCode = 'GER' WHERE SecCode = 60008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838414562, ExchCode = 'STU', PermQuoteRetireDate = '2016-03-01' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196451, ExchCode = 'DUS' WHERE SecCode = 60024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836489836, ExchCode = 'FRA' WHERE SecCode = 60025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363120, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838669799, ExchCode = 'STU', PermQuoteRetireDate = '2016-04-27' WHERE SecCode = 60050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358839, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589872687, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-17' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474903931, ExchCode = 'DEU' WHERE SecCode = 60123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385404, ExchCode = 'LAS' WHERE SecCode = 60133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358580, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334120, ExchCode = 'BER' WHERE SecCode = 60186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838244070, ExchCode = 'MUN', PermQuoteRetireDate = '2010-06-04' WHERE SecCode = 60187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379521, ExchCode = 'LAS' WHERE SecCode = 60203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336124, ExchCode = 'BER' WHERE SecCode = 60210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838503938, ExchCode = 'STU' WHERE SecCode = 60217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475588644, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2008-07-14' WHERE SecCode = 60224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338601, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 60243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531516, ExchCode = 'FRA' WHERE SecCode = 60286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474847300, ExchCode = 'DEU' WHERE SecCode = 60330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475387334, ExchCode = 'GER', PermQuoteRetireDate = '2010-12-28' WHERE SecCode = 60523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514188341, ExchCode = 'STU' WHERE SecCode = 60537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340716, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 60560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531132175, Ticker = 'NSUd', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836470953, ExchCode = 'FRA' WHERE SecCode = 61209 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363654, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488119, ExchCode = 'QTX' WHERE SecCode = 61338 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 61367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837355176, ExchCode = 'GER' WHERE SecCode = 61599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521415202, ExchCode = 'FRA' WHERE SecCode = 61608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766464037, ExchCode = 'FRA' WHERE SecCode = 61631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536290532, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 61644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035470, ExchCode = 'TDG' WHERE SecCode = 61651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327869, Ticker = 'IMG', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 61667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329424, ExchCode = 'BER', PermQuoteRetireDate = '2008-12-22' WHERE SecCode = 61676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799474966, ExchCode = 'LAS' WHERE SecCode = 61685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782536024, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 61691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805237823, ExchCode = 'SIG' WHERE SecCode = 61705 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 = 21475607241, PermQuoteStatus = 'DC', Ticker = 'AKDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 62376 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 = 21856722233, ExchCode = 'MUN', PermQuoteRetireDate = '2023-01-05', PermSecMapEndDate = '2023-01-05' WHERE SecCode = 62512 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 QuotePermID = 236782223877, ExchCode = 'QTX' WHERE SecCode = 63011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333924, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63016 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 = 21475809804, ExchCode = 'DEU' WHERE SecCode = 63292 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 = 21732298297, ExchCode = 'DUS' WHERE SecCode = 64549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835798417, Ticker = 'ST7C', ExchCode = 'DUS', PermQuoteRetireDate = '2018-08-27' WHERE SecCode = 64555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331912, ExchCode = 'BER', PermQuoteRetireDate = '2014-09-04' WHERE SecCode = 64558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006551, ExchCode = 'STU' WHERE SecCode = 64559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488610, ExchCode = 'QTX' WHERE SecCode = 64572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551225766, ExchCode = 'STU', PermQuoteRetireDate = '2022-08-17', PermSecMapEndDate = '2022-08-18' WHERE SecCode = 64727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838406258, ExchCode = 'STU' WHERE SecCode = 64907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324514, ExchCode = 'BER' WHERE SecCode = 64908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394801, ExchCode = 'FRA', PermQuoteRetireDate = '2010-05-25' WHERE SecCode = 64923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036558, ExchCode = 'TDG', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 64936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475428113, ExchCode = 'BER' WHERE SecCode = 64940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836498264, Ticker = 'RD2D', ExchCode = 'FRA', PermQuoteRetireDate = '2020-06-04' WHERE SecCode = 64945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486531, ExchCode = 'QTX' WHERE SecCode = 64949 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 = 21552519304, ExchCode = 'DUS' WHERE SecCode = 65014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492738, ExchCode = 'QTX' WHERE SecCode = 65181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892235294, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 65300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482532, ExchCode = 'QTX' WHERE SecCode = 65308 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 = 21525792637, ExchCode = 'DEU', PermQuoteRetireDate = '2014-02-12' WHERE SecCode = 65966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742524, ExchCode = 'HAN' WHERE SecCode = 66686 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 86401 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-31' WHERE SecCode = 87641 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 93886 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 94475 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-31' WHERE SecCode = 97844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783660901, Ticker = 'HIGDx', ExchCode = 'TQE' WHERE SecCode = 102840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474966848, PermQuoteRetireDate = '2010-10-02' WHERE SecCode = 103118 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 103799 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 = 236800222855, ExchCode = 'FRA' WHERE SecCode = 112636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332675, ExchCode = 'BER' WHERE SecCode = 121215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835822357, ExchCode = 'MEX' WHERE SecCode = 121221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705741, ExchCode = 'MXQ' WHERE SecCode = 121223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835820564, ExchCode = 'MEX' WHERE SecCode = 121226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704744, ExchCode = 'MXQ' WHERE SecCode = 121613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704768, ExchCode = 'MXQ' WHERE SecCode = 121614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624077684, ExchCode = 'DEU' WHERE SecCode = 128489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909428, ExchCode = 'DEU' WHERE SecCode = 128495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885457531, ExchCode = 'STU' WHERE SecCode = 131497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836475370, ExchCode = 'FRA', PermQuoteRetireDate = '2015-09-15' WHERE SecCode = 132559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791248533, ExchCode = 'FRA' WHERE SecCode = 132592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337118, ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 132593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552653, ExchCode = 'LAS' WHERE SecCode = 132606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981159, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 132611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273239, ExchCode = 'GTX' WHERE SecCode = 132792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838239668, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 132852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298236, ExchCode = 'GTX' WHERE SecCode = 132945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742560, ExchCode = 'HAN' WHERE SecCode = 132970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474864051, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 133025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474836980, ExchCode = 'DEU' WHERE SecCode = 133027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324586, ExchCode = 'BER', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 133030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538437376, ExchCode = 'BER', PermQuoteRetireDate = '2015-04-03' WHERE SecCode = 133080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490407, ExchCode = 'QTX' WHERE SecCode = 133118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475137351, ExchCode = 'FRA', PermQuoteRetireDate = '2014-07-02' WHERE SecCode = 133291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807782309, ValQuotePermID = 236807782309.0, Ticker = 'MERCURYEV', ExchCode = 'NSI' WHERE SecCode = 135748 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 136909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955897, ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-13', PermSecMapEndDate = '2022-01-13' WHERE SecCode = 137285 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 = 21667492299, ExchCode = 'QTX' WHERE SecCode = 137720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448701, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-08', PermSecMapEndDate = NULL WHERE SecCode = 138259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855827479, ExchCode = 'GER', PermQuoteRetireDate = '2022-05-03' WHERE SecCode = 138261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780784306, ExchCode = 'FRA' WHERE SecCode = 138279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955011, ExchCode = 'LAS' WHERE SecCode = 138280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324001, ExchCode = 'BER' WHERE SecCode = 138285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330438, Ticker = 'H1BN', ExchCode = 'BER', PermQuoteRetireDate = '2013-07-19' WHERE SecCode = 138286 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 = 21554252789, PermQuoteRetireDate = '2015-01-09' WHERE SecCode = 143248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545907993, ExchCode = 'STU' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144566191, ExchCode = 'DEU' WHERE SecCode = 144104 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 QuotePermID = 21718787365, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807882965, ExchCode = 'STU', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 144302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827327700, ExchCode = 'FRA' WHERE SecCode = 144336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664445764, ExchCode = 'FRA', PermQuoteRetireDate = '2019-01-24' WHERE SecCode = 144351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836480998, ExchCode = 'FRA', PermQuoteRetireDate = '2020-08-19' WHERE SecCode = 144377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330934, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633145097, Ticker = 'TUI1l', ExchCode = 'EBT', PermQuoteRetireDate = '2019-06-18' WHERE SecCode = 144410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838302347, PermQuoteStatus = 'DC', Ticker = 'TMS.FR', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 144414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808378819, ExchCode = 'MUN', PermQuoteRetireDate = '2023-09-25', PermSecMapEndDate = NULL WHERE SecCode = 145350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794070542, ExchCode = 'FRA' WHERE SecCode = 145375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836487956, ExchCode = 'FRA' WHERE SecCode = 145380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484032, ExchCode = 'QTX' WHERE SecCode = 145407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324849, ExchCode = 'BER' WHERE SecCode = 145435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503066036, ExchCode = 'STU' WHERE SecCode = 145506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533743848, ExchCode = 'STU' WHERE SecCode = 145554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341949, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 145558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322959, ExchCode = 'BER', PermQuoteRetireDate = '2021-08-31' WHERE SecCode = 145685 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 = 21509797360, ExchCode = 'DEU' WHERE SecCode = 146333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537909404, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 147005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763556002, ExchCode = 'QTX' WHERE SecCode = 147295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790478897, ExchCode = 'FRA' WHERE SecCode = 147554 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 = 236799419095, ExchCode = 'LAS' WHERE SecCode = 147632 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 = 55836500310, ExchCode = 'FRA' WHERE SecCode = 147655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337980, ExchCode = 'BER' WHERE SecCode = 147869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488639, ExchCode = 'QTX' WHERE SecCode = 172988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838240695, ExchCode = 'MUN' WHERE SecCode = 173076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288493, ExchCode = 'DEU' WHERE SecCode = 174875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729890738, ExchCode = 'DEU' WHERE SecCode = 177156 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 = 236782726106, ExchCode = 'TDG' WHERE SecCode = 177487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331775, ExchCode = 'BER' WHERE SecCode = 177594 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 = 21535834373, ExchCode = 'DEU' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330994, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 180248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331433, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 190124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531128580, PermQuoteStatus = 'DC', Ticker = 'HY7d', ExchCode = 'BCO', PermQuoteRetireDate = '2013-11-20' WHERE SecCode = 190214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954813, ExchCode = 'LAS' WHERE SecCode = 190498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867512386, ExchCode = 'FRA', PermQuoteRetireDate = '2026-01-08' WHERE SecCode = 192685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475796465, ExchCode = 'STU', PermQuoteRetireDate = '2013-10-30' WHERE SecCode = 199065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836574074, ExchCode = 'FRA' WHERE SecCode = 199359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21918242402, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 201295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340929, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 201298 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 = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956395290, ExchCode = 'DEU' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634652662, ExchCode = 'MUN', PermQuoteRetireDate = '2020-12-23' WHERE SecCode = 208000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704511, ExchCode = 'MXQ' WHERE SecCode = 214889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576057288, ExchCode = 'STU' WHERE SecCode = 249726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589742990, Ticker = 'AHR1', ExchCode = 'STU', PermQuoteRetireDate = '2021-03-10' WHERE SecCode = 249735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684969111, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22052572098, ExchCode = 'DEU' WHERE SecCode = 249797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532691717, ExchCode = 'FRA' WHERE SecCode = 249801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538241626, ExchCode = 'DEU', PermQuoteRetireDate = '2016-01-05' WHERE SecCode = 249805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860308852, ExchCode = 'GTX' WHERE SecCode = 249812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552007785, ExchCode = 'TDG' WHERE SecCode = 254070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788075090, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 286042 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 291899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533706424, ExchCode = 'DEU' WHERE SecCode = 297377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481981571, ExchCode = 'STU' WHERE SecCode = 304579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629361931, Ticker = 'CVY', ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 304581 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 310812 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 310833 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 317489 AND Type_ = 1;
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 = 21722613462, ExchCode = 'STU', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 318425 AND Type_ = 10;
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 = 21506942102, ExchCode = 'STU' WHERE SecCode = 326261 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 PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 327142 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21629957388, ExchCode = 'TDG' WHERE SecCode = 330665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475510699, Ticker = '0E5X', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 332179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474988453, PermQuoteStatus = 'AC', Ticker = '0MG1', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 332194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834672362, Ticker = '0DFR', ExchCode = 'LSE', PermQuoteRetireDate = '2014-05-01' WHERE SecCode = 332205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838301423, Ticker = 'KQIP.NL', ExchCode = 'PLU', PermQuoteRetireDate = '2010-06-15' WHERE SecCode = 332212 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 = 21887549150, ExchCode = 'GTX' WHERE SecCode = 332324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321769, ExchCode = 'BER', PermQuoteRetireDate = '2009-04-22' WHERE SecCode = 333158 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 = 21627273049, ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-22' WHERE SecCode = 333806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533645772, ExchCode = 'BCO', PermQuoteRetireDate = '2020-03-30' WHERE SecCode = 333820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22178668432, ExchCode = 'DEU' WHERE SecCode = 336756 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 339968 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21895997542, ExchCode = 'DEU' WHERE SecCode = 345850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159147457, ExchCode = 'DEU' WHERE SecCode = 345851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502570914, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 345858 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 = 55834672474, Ticker = '0EQ8', ExchCode = 'LSE', PermQuoteRetireDate = '2010-07-26' WHERE SecCode = 353920 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 = 21920545385, ExchCode = 'FRA' WHERE SecCode = 354063 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 = 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 PermInstrStatus = 'DC', PermSecMapEndDate = '2026-05-31' WHERE SecCode = 378468 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 PermInstrStatus = 'DC' WHERE SecCode = 383140 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 = 55841225077, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 395621 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 = 21475766995, ExchCode = 'FRA', PermQuoteRetireDate = '2019-08-19' WHERE SecCode = 446617 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 = 22010413709, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481041 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 = 21484166997, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 486270 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 520557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856295357, ExchCode = 'STU' WHERE SecCode = 534603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522128043, ExchCode = 'MUN' WHERE SecCode = 548067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620057804, ExchCode = 'TDG' WHERE SecCode = 550860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475855781, ExchCode = 'TDG' WHERE SecCode = 557995 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 561525 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 561542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475061840, ExchCode = 'HFT', PermQuoteRetireDate = '2013-10-29' WHERE SecCode = 563059 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 = 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 = 55857958579, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 567636 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 569284 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 580055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859132030, ExchCode = 'GER' WHERE SecCode = 594191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859254281, ExchCode = 'FRA', PermQuoteRetireDate = '2020-12-01' WHERE SecCode = 601659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802542707, ExchCode = 'FRA' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538883522, ExchCode = 'STU' WHERE SecCode = 623935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859812767, Ticker = 'SVV', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 637382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55868335680, Ticker = 'OCS.GB', ExchCode = 'PLU' WHERE SecCode = 649936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991761, ExchCode = 'MUN' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525580464, ExchCode = 'FRA' WHERE SecCode = 692786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391671, ExchCode = 'GTX' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492779045, ExchCode = 'STU', PermQuoteRetireDate = '2022-07-14' WHERE SecCode = 696379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287353, ExchCode = 'BIV' WHERE SecCode = 780513 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 797952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749996718, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 826159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492850, ExchCode = 'QTX' WHERE SecCode = 837909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475136959, ExchCode = 'DEU' WHERE SecCode = 858901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610380111, ExchCode = 'DEU' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 863709 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 877516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596702, ExchCode = 'FRA' WHERE SecCode = 878880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554127327, Ticker = 'XSILz', ExchCode = 'CHI' WHERE SecCode = 880290 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'S2S' WHERE SecCode = 881802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779809732, ExchCode = 'GTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 900837 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL WHERE SecCode = 933273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785297550, ExchCode = 'QTX' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 946145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838301302, Ticker = 'MBTGV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2013-02-22' WHERE SecCode = 961652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846603850, Ticker = 'FMT', ExchCode = 'MUN', PermQuoteRetireDate = '2011-01-31' WHERE SecCode = 985004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55861166354, Ticker = 'SEED', ExchCode = 'LSE', PermQuoteRetireDate = '2016-02-01' WHERE SecCode = 1004402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890382, ExchCode = 'AQX' WHERE SecCode = 1108496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806640336, ExchCode = 'FRA' WHERE SecCode = 1111460 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1149657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55876477262, Ticker = 'XGLI', ExchCode = 'LSE', PermQuoteRetireDate = '2013-09-20' WHERE SecCode = 1192765 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1253090 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1262951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133937, Ticker = 'S7Id', ExchCode = 'BCO', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 1265673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797800257, ExchCode = 'DUS' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302232, ExchCode = 'GTX' WHERE SecCode = 1441088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747333716, ExchCode = 'FRA' WHERE SecCode = 1447581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513584728, ExchCode = 'CHI', PermQuoteRetireDate = '2020-06-25' WHERE SecCode = 1449053 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 PermOrgIPODate = NULL WHERE SecCode = 1459271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391706, ExchCode = 'GTX' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704338, ExchCode = 'MXQ' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419448, ExchCode = 'HAM' WHERE SecCode = 1472577 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 = 21667488606, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490145914, Ticker = NULL, ExchCode = 'DEU', PermQuoteRetireDate = '2014-03-07' WHERE SecCode = 1489390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109485, ExchCode = 'FRA' WHERE SecCode = 1494186 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 = 21667704850, ExchCode = 'MXQ' WHERE SecCode = 1518823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486937345, ExchCode = 'STU' WHERE SecCode = 1519143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487020931, ExchCode = 'FRA' 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 = 21488289996, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2026-06-01', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623750, ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-23', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 1524544 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 = 21535039956, ExchCode = 'STU' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491257231, ExchCode = 'STU' WHERE SecCode = 1534251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768731670, ExchCode = 'DEU' WHERE SecCode = 1534950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270483, ExchCode = 'FRA' WHERE SecCode = 1538607 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 = 236784379929, ExchCode = 'LAS' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511700265, PermQuoteStatus = 'AC', Ticker = '7NU1', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705407, ExchCode = 'MXQ' WHERE SecCode = 1552111 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 = 21807437495, ExchCode = 'STU', PermQuoteRetireDate = '2025-11-10', PermSecMapEndDate = '2025-11-10' WHERE SecCode = 1564475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502335108, ExchCode = 'FRA' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632884533, ExchCode = 'MUN', PermQuoteRetireDate = '2018-10-05' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386019, ExchCode = 'LAS' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704832, ExchCode = 'MXQ' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704269, ExchCode = 'MXQ' WHERE SecCode = 1597246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780314342, ExchCode = 'GTX' WHERE SecCode = 1597247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545936600, Ticker = 'AYPi', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 1603990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538181095, ExchCode = 'STU' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546492020, ExchCode = 'MUN' WHERE SecCode = 1607154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506712070, ExchCode = 'FRA' WHERE SecCode = 1613992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559894314, ExchCode = 'STU' WHERE SecCode = 1613993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705694, ExchCode = 'MXQ' WHERE SecCode = 1621273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802789, Ticker = 'PV0D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1644134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510008303, ExchCode = 'DEU' WHERE SecCode = 1653506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822238, ExchCode = 'DEU' WHERE SecCode = 1655502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835904, Ticker = '7O2d', ExchCode = 'BCO' WHERE SecCode = 1656414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518462361, ExchCode = 'FRA' WHERE SecCode = 1658177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510434507, ExchCode = 'DEU' WHERE SecCode = 1660578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510957458, Ticker = 'Q7X', PermQuoteRetireDate = '2012-10-10', PermSecMapEndDate = '2012-10-10' WHERE SecCode = 1668708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512412458, Ticker = 'CTY1SN011', ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511262189, ExchCode = 'DEU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520427, ExchCode = 'DEU' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799113029, ExchCode = 'LAS' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795183066, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-18' WHERE SecCode = 1696044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512395856, ExchCode = 'DEU' WHERE SecCode = 1699181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515521924, ExchCode = 'FRA' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927493, ExchCode = 'BER' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197687, ExchCode = 'STU', PermQuoteRetireDate = '2023-11-10' WHERE SecCode = 1735686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513762821, ExchCode = 'DEU' WHERE SecCode = 1736071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628061495, ExchCode = 'DEU' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939948839, PermQuoteStatus = 'DC', Ticker = 'OD7L', ExchCode = 'HAN', PermQuoteRetireDate = '2024-03-05' WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517016445, ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 2018342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520168579, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 2043507 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 = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519686519, ExchCode = 'DEU' WHERE SecCode = 2056161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519498812, ExchCode = 'DEU' WHERE SecCode = 2115211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519816623, ExchCode = 'FRA' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 2203395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522133570, ExchCode = 'STU' WHERE SecCode = 2222349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834226, ExchCode = 'DEU' WHERE SecCode = 2225286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2240516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789017062, ExchCode = 'DUS' WHERE SecCode = 2246863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068269, ExchCode = 'DEU' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652141579, ExchCode = 'EQD' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576247697, ExchCode = 'FRA' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525274948, ExchCode = 'FRA' WHERE SecCode = 2278225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854591, ExchCode = 'STU', PermQuoteRetireDate = '2021-01-06' WHERE SecCode = 2288362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045908023, ExchCode = 'MEX' WHERE SecCode = 2337158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183909510, Ticker = 'LYCEC', ExchCode = 'SWX' WHERE SecCode = 2350989 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2356424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781213703, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820384482, Ticker = 'XDN0l', ExchCode = 'BCO' WHERE SecCode = 2363639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' 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 = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532122979, ExchCode = 'STU' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487244, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842579738, ExchCode = 'BER' WHERE SecCode = 2458822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298337, ExchCode = 'DEU', PermQuoteRetireDate = '2023-08-04' WHERE SecCode = 2465278 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2496924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555767, ExchCode = 'FRA' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181315008, ExchCode = 'OCE' WHERE SecCode = 2510129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134691, ExchCode = 'DEU' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851779770, ExchCode = 'MUN', PermQuoteRetireDate = '2022-04-12', PermSecMapEndDate = '2022-04-12' WHERE SecCode = 2519541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869000361, ExchCode = 'FRA', PermSecMapEndDate = NULL WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538883509, ExchCode = 'FRA' WHERE SecCode = 2529651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539906153, ExchCode = 'FRA' WHERE SecCode = 2539866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585062789, ExchCode = 'BEC' WHERE SecCode = 2539930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798387589, ExchCode = 'HAM' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850059046, ExchCode = 'MUN' WHERE SecCode = 2545065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371134, ExchCode = 'BEC' WHERE SecCode = 2545788 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 PermSecMapEndDate = NULL WHERE SecCode = 2555911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708867, ExchCode = 'FRA' WHERE SecCode = 2585326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544371203, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-28' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384980, ExchCode = 'LAS' WHERE SecCode = 2617118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819966448, ExchCode = 'TDG' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397387, ExchCode = 'GTX' WHERE SecCode = 2649166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742655, ExchCode = 'HAN' WHERE SecCode = 2679857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705935887, ExchCode = 'BIV' WHERE SecCode = 2724356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675690, ExchCode = 'BIV' WHERE SecCode = 2747774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198716, ExchCode = 'MEX' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554995304, ExchCode = 'STU' WHERE SecCode = 2750981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843924533, ExchCode = 'FRA' WHERE SecCode = 2809752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939948844, ExchCode = 'HAN' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561140926, ExchCode = 'DEU' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386769, ExchCode = 'LAS' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701551, Ticker = 'EXX1', ExchCode = 'BRN' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563865170, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2900692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564447127, ExchCode = 'BTE', PermQuoteRetireDate = '2015-05-29' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073079957, ExchCode = 'TDG' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557767351, ExchCode = 'SGO' WHERE SecCode = 2907274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285585, ExchCode = 'GTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012890828, PermQuoteStatus = 'AC', Ticker = 'VZLBd', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457862, ExchCode = 'FRA' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608122500, ExchCode = 'FRA', PermQuoteRetireDate = '2019-02-08' WHERE SecCode = 2928770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370461, ExchCode = 'GTX' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670295233, ExchCode = 'STU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-31' WHERE SecCode = 2955168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645306003, ExchCode = 'DEU' WHERE SecCode = 2955208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573607460, ExchCode = 'DUS' WHERE SecCode = 2956411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589220364, ExchCode = 'DEU', PermQuoteRetireDate = '2021-03-19' WHERE SecCode = 2976573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574156091, ExchCode = 'DEU', PermQuoteRetireDate = '2023-01-09' WHERE SecCode = 3011183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724821997, Ticker = '9GL', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2024-04-10' WHERE SecCode = 3020820 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 = 236784386809, ExchCode = 'LAS' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520298, ExchCode = 'QTX' WHERE SecCode = 3038439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750433751, ExchCode = 'STU' WHERE SecCode = 3055016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386888, ExchCode = 'LAS' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 3096980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794739726, ExchCode = 'FRA' WHERE SecCode = 3124127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 3133393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916283528, ExchCode = 'BER' WHERE SecCode = 3160205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22027361754, ExchCode = 'STU' WHERE SecCode = 3160206 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 3162417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077944, ExchCode = 'LAS' WHERE SecCode = 3166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887241129, ExchCode = 'BTE' WHERE SecCode = 3174320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679777, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3177778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993578551, Ticker = '3EMLl', ExchCode = 'BTE' WHERE SecCode = 3193773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786090185, ExchCode = 'TDG' WHERE SecCode = 3198703 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 = 21708527581, ExchCode = 'MUN' WHERE SecCode = 3200605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704844, ExchCode = 'MXQ' WHERE SecCode = 3211298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591292762, ExchCode = 'STU' WHERE SecCode = 3211299 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009729, Ticker = '2DB1' WHERE SecCode = 3211322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009927, Ticker = '2CON' WHERE SecCode = 3211325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077968, ExchCode = 'LAS' WHERE SecCode = 3221850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629958134, ExchCode = 'TDG' WHERE SecCode = 3222698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797998187, Ticker = 'RIGOz', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 3223354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496462, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL 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 = 21594292935, ExchCode = 'FRA' WHERE SecCode = 3232615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806156912, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-09' WHERE SecCode = 3232617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026729, Ticker = '1UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641748, ExchCode = 'DUS' WHERE SecCode = 3245391 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 PermInstrStatus = 'DC' WHERE SecCode = 3247550 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 3247784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651373312, ExchCode = 'DEU' WHERE SecCode = 3255012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301868, ExchCode = 'GTX' WHERE SecCode = 3255028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598409316, ExchCode = 'DEU', PermQuoteRetireDate = '2016-11-11' WHERE SecCode = 3260094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800110, ExchCode = 'CHI' WHERE SecCode = 3263198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21995867781, ExchCode = 'TRQ' WHERE SecCode = 3275560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 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 = 21634479982, ExchCode = 'MUN' WHERE SecCode = 3285184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632738581, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-27' WHERE SecCode = 3297215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857633427, ExchCode = 'QTX' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705487, ExchCode = 'STU' WHERE SecCode = 3308987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608278641, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705301, Ticker = 'LOGM*', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608278646, ExchCode = 'MUN' WHERE SecCode = 3315799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815325346, ExchCode = 'MUN', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551901, ExchCode = 'TDG' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705372, ExchCode = 'MXQ' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609516, ExchCode = 'DUS' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380068, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3319868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610682901, Ticker = 'VEONa', ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042371, ExchCode = 'DEU' WHERE SecCode = 3322810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510732, ExchCode = 'DUS' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295882, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367734, ExchCode = 'AUX' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614735175, ExchCode = 'DEU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 3372300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320101, ExchCode = 'DEU' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864390192, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658642103, ExchCode = 'MUN' 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 = 21766440281, ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-29' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378814, ExchCode = 'BRN' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951218.0 WHERE SecCode = 3394388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623803395, ExchCode = 'FRA' WHERE SecCode = 3396014 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3396069 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 3401818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704915, ExchCode = 'MXQ' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469772, ExchCode = 'DEU' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800228480, ExchCode = 'FRA' WHERE SecCode = 3401911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380142, PermQuoteStatus = 'AC', Ticker = 'DV4', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3401914 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 = 236797256348, ExchCode = 'DUS' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3408432 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3408433 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3408600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175400111, ExchCode = 'DEU' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301441, ExchCode = 'MEX' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651603021, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-26' WHERE SecCode = 3434582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788404566, ExchCode = 'QTX' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186352, ExchCode = 'FRA' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938004022, ExchCode = 'GTX' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647732095, ExchCode = 'STU' WHERE SecCode = 3493723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704432, ExchCode = 'MXQ' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388282, ExchCode = 'LAS', PermQuoteRetireDate = '2025-07-29' WHERE SecCode = 3501431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727169919, Ticker = 'NGIL', ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359772, ExchCode = 'STU' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431273, ExchCode = 'FRA' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664223, ExchCode = 'MUN' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296299, ExchCode = 'GTX' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21994180608, ExchCode = 'BTE' WHERE SecCode = 3547843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663166796, ExchCode = 'FRA' WHERE SecCode = 3550423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797237688, ExchCode = 'STU' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296175, ExchCode = 'GTX' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663316444, ExchCode = 'FRA', PermQuoteRetireDate = '2020-04-16' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951747.0 WHERE SecCode = 3593569 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-01', PermSecMapEndDate = NULL WHERE SecCode = 3620663 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3629678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779823334, ExchCode = 'GTX' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308437, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669468854, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 3682014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675373923, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3690817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383888, ExchCode = 'BIV' WHERE SecCode = 3732368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803135585, ExchCode = 'FRA' WHERE SecCode = 3756337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683763490, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758727556, ExchCode = 'MUN', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3779971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685868276, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198213, ExchCode = 'FRA' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780314322, ExchCode = 'GTX' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 3818906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789360052, ExchCode = 'DEU' WHERE SecCode = 3837309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285132, PermQuoteStatus = 'DC', Ticker = '2ZT0', ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-02' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373316, ExchCode = 'BIV' WHERE SecCode = 3843165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371245, ExchCode = 'BIV' WHERE SecCode = 3851577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584837232, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 3919559 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ALFALAVN' WHERE SecCode = 3946842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026873, Ticker = '1BAC', ExchCode = 'MIL' WHERE SecCode = 4031699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026866, Ticker = '1BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011956, Ticker = '2GLW' WHERE SecCode = 4031714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026934, Ticker = '1MS' WHERE SecCode = 4031717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010270, Ticker = '21COV' WHERE SecCode = 4031771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009889, Ticker = '2DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143892, Ticker = '2RI', ExchCode = 'MIL' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042586, Ticker = '2PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013663, Ticker = '2PYPL', ExchCode = 'MIL' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013557, Ticker = '2REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009964, Ticker = '2RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042587, Ticker = '2SHA', PermQuoteRetireDate = '2024-10-01' WHERE SecCode = 4031994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010336, Ticker = '2SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013792, Ticker = '2SNAP' WHERE SecCode = 4032002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681023394, Ticker = '4AKZA', ExchCode = 'ETX' WHERE SecCode = 4032088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682843016, Ticker = '4UCB', ExchCode = 'ETX' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026881, Ticker = '1ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652454, ExchCode = 'FRA' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260229, ExchCode = 'DEU' WHERE SecCode = 4099601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727352699, ExchCode = 'MEX' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767422310, ExchCode = 'DEU' WHERE SecCode = 4210918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756680510, ExchCode = 'MUN', PermQuoteRetireDate = '2020-07-03' WHERE SecCode = 4274159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757455927, ExchCode = 'DEU' WHERE SecCode = 4277594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360718, ExchCode = 'HAN' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 4295716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015162, ExchCode = 'LAS' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760292838, ExchCode = 'MUN' WHERE SecCode = 4303589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342160, ExchCode = 'MEX' WHERE SecCode = 4315098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803438809, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 4315115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580118, ExchCode = 'FRA' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580175, ExchCode = 'DEU' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782582731, ExchCode = 'MUN' WHERE SecCode = 4324465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112309, ExchCode = 'DEU' WHERE SecCode = 4328959 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4339135 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4346656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770634972, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770832967, ExchCode = 'DEU' WHERE SecCode = 4362675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771983377, ExchCode = 'DUS' WHERE SecCode = 4362679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388426, ExchCode = 'LAS' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650250, ExchCode = 'DUS' WHERE SecCode = 4379790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960079950, ExchCode = 'MUN' WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307570, ExchCode = 'BIV' WHERE SecCode = 4403942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377495, ExchCode = 'BIV' WHERE SecCode = 4417298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780353097, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816908115, ExchCode = 'TQE' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787553936, ExchCode = 'DEU', PermQuoteRetireDate = '2021-01-07' WHERE SecCode = 4446127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791908410, ExchCode = 'TDG' WHERE SecCode = 4451262 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-05-31' WHERE SecCode = 4456235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794257515, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897784749, ExchCode = 'GTX' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801282977, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4487598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796082418, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2021-10-13', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4487640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796870257, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820703, ExchCode = 'DEU' WHERE SecCode = 4499152 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2021-02-15' WHERE SecCode = 4502156 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 4521317 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274062, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806535085, ExchCode = 'MUN' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806748726, ExchCode = 'FRA' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 4570371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811019112, ExchCode = 'TDG' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22076466680, Ticker = 'XLMEd', ExchCode = 'BCO' WHERE SecCode = 4579626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286428, ExchCode = 'GTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 4586455 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4589182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812848268, ExchCode = 'DEU' WHERE SecCode = 4590581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814382045, ExchCode = 'DEU' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816245393, ExchCode = 'MUN' WHERE SecCode = 4601736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816477347, ExchCode = 'MUN' WHERE SecCode = 4609998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878863900, ExchCode = 'BCO' WHERE SecCode = 4617708 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 4618044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884462002, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22' WHERE SecCode = 4626906 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 = 236782100069, ExchCode = 'FRA' WHERE SecCode = 4639636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815337201, ExchCode = 'FRA' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828832812, ExchCode = 'STU' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954880, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4664716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795845914, ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793284943, PermQuoteStatus = 'AC', Ticker = '94Y', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4682737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387315, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316539, ExchCode = 'STU' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835314248, ExchCode = 'GTX' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832850911, ExchCode = 'FRA' WHERE SecCode = 4689999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845076965, Ticker = 'V96', ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = NULL WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842579647, ExchCode = 'MUN' WHERE SecCode = 4705895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781822280, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-06-05' WHERE SecCode = 4709616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954835, ExchCode = 'LAS' WHERE SecCode = 4718902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851158441, ExchCode = 'DEU' WHERE SecCode = 4748566 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 4751026 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 = 21854914847, PermQuoteStatus = 'AC', Ticker = '3FNG', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855801983, ExchCode = 'DUS' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 4770126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726920, ExchCode = 'GTX' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795665928, ExchCode = 'FRA' 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 = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705511, ExchCode = 'STU' WHERE SecCode = 4786540 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 = 21858471109, ExchCode = 'DEU', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = '2025-06-17' WHERE SecCode = 4787454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727227056, ExchCode = 'BIV' WHERE SecCode = 4794541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859828342, ExchCode = 'GTX' WHERE SecCode = 4794547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546351, ExchCode = 'DEU' WHERE SecCode = 4794549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860309686, ExchCode = 'MUN' WHERE SecCode = 4800558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618957147, ExchCode = 'FRA', PermQuoteRetireDate = '2023-05-12' WHERE SecCode = 4804834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861324005, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4806669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861132292, ExchCode = 'MUN' WHERE SecCode = 4806670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083389750, ExchCode = 'BRN' WHERE SecCode = 4809017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083389751, ExchCode = 'BRN' WHERE SecCode = 4809026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862298482, ExchCode = 'DEU', PermQuoteRetireDate = '2026-02-10' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21863192644, ExchCode = 'DEU' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862998607, ExchCode = 'QTX' WHERE SecCode = 4818264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864000077, ExchCode = 'FRA' WHERE SecCode = 4823658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865590398, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4823660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866536829, ExchCode = 'STU' WHERE SecCode = 4823661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866160214, ExchCode = 'TDG' WHERE SecCode = 4823663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290739, ExchCode = 'MUN' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897370, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4823669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874018782, ExchCode = 'QTX' WHERE SecCode = 4830767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580216, ExchCode = 'DUS' WHERE SecCode = 4834792 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 = 236792865438, ExchCode = 'GTX' WHERE SecCode = 4841234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789616854, ExchCode = 'QTX' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398427, ExchCode = 'FRA', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884968894, ExchCode = 'DEU' WHERE SecCode = 4847005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 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 = 21829806151, ExchCode = 'DEU' WHERE SecCode = 4890295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885726, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL 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 = 21876897799, Ticker = '2TRV', ExchCode = 'MIL' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4903982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879829844, ExchCode = 'STU' WHERE SecCode = 4921189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882166752, PermQuoteStatus = 'DC', Ticker = 'Y23', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4934325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727234438, ExchCode = 'BIV' WHERE SecCode = 4938297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796694010, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4940671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380552, ExchCode = 'LAS' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883516418, ExchCode = 'FRA' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883757511, PermQuoteStatus = 'DC', Ticker = '7U6', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4949680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689378, ExchCode = 'FRA' WHERE SecCode = 4959597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727205509, ExchCode = 'BIV' WHERE SecCode = 4962789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886858323, ExchCode = 'FRA' WHERE SecCode = 4969368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892045292, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4969375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886193412, ExchCode = 'DEU' WHERE SecCode = 4969376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898128, PermQuoteStatus = 'AC', Ticker = 'WATTm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4969407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898198, ExchCode = 'BCO' WHERE SecCode = 4969408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22066264764, ExchCode = 'BTE' WHERE SecCode = 4969409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887740504, ExchCode = 'STU' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902148575, ExchCode = 'FRA' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072401492, ExchCode = 'DEU' WHERE SecCode = 5009346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097175, ExchCode = 'LAS' WHERE SecCode = 5011695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183909427, ExchCode = 'SWX' WHERE SecCode = 5013560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174654874, ExchCode = 'DEU' WHERE SecCode = 5031899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863949618 WHERE SecCode = 5040232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902367523, ExchCode = 'MUN' WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209210, ExchCode = 'FRA' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782329716, ExchCode = 'QTX' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740520, ExchCode = 'LAS' WHERE SecCode = 5082548 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 QuotePermID = 236778416293, ExchCode = 'TDG' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508526620, ExchCode = 'FRA' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21721366997, ExchCode = 'STU' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827095404, ExchCode = 'MXQ' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727344850, ExchCode = 'MEX' WHERE SecCode = 5161363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387325, ExchCode = 'LAS' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367923, ExchCode = 'BEC' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689627, ExchCode = 'DEU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885781, ExchCode = 'FRA' WHERE SecCode = 5161439 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 = 21921849641, ExchCode = 'FRA' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183909421, ExchCode = 'SWX' WHERE SecCode = 5206345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183909423, ExchCode = 'SWX' WHERE SecCode = 5206346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933629891, ExchCode = 'TDG' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173431, ExchCode = 'BIV' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948492664, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935009046, ExchCode = 'DEU' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397463, ExchCode = 'BTE' WHERE SecCode = 5269462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397469, ExchCode = 'CHI' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782434087, ExchCode = 'STU' WHERE SecCode = 5343608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952265408, ExchCode = 'DEU' WHERE SecCode = 5347429 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 5360702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776104211, Ticker = 'ACAG', ExchCode = 'VIE' WHERE SecCode = 5372903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381676, ExchCode = 'LAS' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534615, ExchCode = 'QTX' WHERE SecCode = 5383599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791141195, ExchCode = 'FRA' WHERE SecCode = 5407840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378859, ExchCode = 'FRA' WHERE SecCode = 5415164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183909432, ExchCode = 'SWX' WHERE SecCode = 5436569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667447, ExchCode = 'STU' WHERE SecCode = 5436573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779667355, ExchCode = 'STU' WHERE SecCode = 5436574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778172838, ExchCode = 'FRA' WHERE SecCode = 5454711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778288799, ExchCode = 'FRA' WHERE SecCode = 5466447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667975336, ExchCode = 'FRA' WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835698, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538283057, PermQuoteStatus = 'AC', Ticker = 'ZE2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011031, Ticker = '2TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835708, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512065, Ticker = '3PYPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5503776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22002744025, Ticker = 'USFA', ExchCode = 'SWX' WHERE SecCode = 5516823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779059190, ExchCode = 'FRA' WHERE SecCode = 5516829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619181, ExchCode = 'BTE' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21988688380, ExchCode = 'MXQ' WHERE SecCode = 5531898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835655, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786101497, ExchCode = 'DEU' WHERE SecCode = 5553189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034589, ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-30' WHERE SecCode = 5569318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793530318, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-08', PermSecMapEndDate = '2023-11-08' WHERE SecCode = 5577589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852456313, ExchCode = 'BRN' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837511990, Ticker = '2STSa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5638905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782563848, ExchCode = 'FRA' WHERE SecCode = 5722406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028682924, ExchCode = 'STU' WHERE SecCode = 5724938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028890941, ExchCode = 'FRA', PermQuoteRetireDate = '2025-12-30' WHERE SecCode = 5724940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028890792, ExchCode = 'DEU', PermQuoteRetireDate = '2025-12-30' WHERE SecCode = 5724941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782653830, ExchCode = 'FRA' WHERE SecCode = 5731414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772643122, ExchCode = 'FRA' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782872476, ExchCode = 'FRA' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891343, ExchCode = 'FRA' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891391, ExchCode = 'FRA' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782928373, ExchCode = 'FRA' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181310368, ExchCode = 'OCU' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040670142, ExchCode = 'GTX' WHERE SecCode = 5785805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037308993, ExchCode = 'DEU' WHERE SecCode = 5786123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037302983, ExchCode = 'DEU' WHERE SecCode = 5786125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783782319, ExchCode = 'STU' WHERE SecCode = 5786132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783963980, ExchCode = 'STU' WHERE SecCode = 5786133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534609, ExchCode = 'QTX' WHERE SecCode = 5786134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608793, ExchCode = 'MEX' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421384, ExchCode = 'MEX' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416444, ExchCode = 'BIV' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851320, ExchCode = 'LAS' WHERE SecCode = 5908829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22058332105, ExchCode = 'DEU' WHERE SecCode = 5914176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784315655, ExchCode = 'BIV' WHERE SecCode = 5917882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061495886, ExchCode = 'GTX' WHERE SecCode = 5920851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786553288, ExchCode = 'FRA' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795664148, ExchCode = 'MEX' WHERE SecCode = 6014420 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL WHERE SecCode = 6075931 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951747.0 WHERE SecCode = 6082610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814699350, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911612, ExchCode = 'BIV' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089872374, ExchCode = 'DEU' WHERE SecCode = 6153962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089867315, ExchCode = 'DEU' WHERE SecCode = 6153964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838445, ExchCode = 'FRA' WHERE SecCode = 6232440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099147197, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823991, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907994, ExchCode = 'FRA' WHERE SecCode = 6308566 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-01', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 6318935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793393667, ExchCode = 'STU' WHERE SecCode = 6334403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349913, ExchCode = 'MUN' WHERE SecCode = 6334404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794559562, ExchCode = 'GTX' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22114565349, ExchCode = 'DEU' WHERE SecCode = 6352009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793578954, ExchCode = 'MUN' WHERE SecCode = 6352010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793575237, ExchCode = 'FRA' WHERE SecCode = 6352011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183909445, ExchCode = 'SWX' WHERE SecCode = 6363491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989711, ExchCode = 'MEX' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655560, ExchCode = 'FRA' WHERE SecCode = 6368868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125760536, ExchCode = 'MIL' WHERE SecCode = 6453964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451400, ExchCode = 'BTE' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6469583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797894164, ExchCode = 'FRA' WHERE SecCode = 6515942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798269749, ExchCode = 'TDG' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109633, ExchCode = 'QTX' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798743814, ExchCode = 'QTX' WHERE SecCode = 6543898 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6569505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379902, Ticker = 'XS4', ExchCode = 'BRN' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955916, ExchCode = 'FRA' WHERE SecCode = 6587160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957446, ExchCode = 'FRA' WHERE SecCode = 6587161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955917, ExchCode = 'FRA' WHERE SecCode = 6587165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799956020, ExchCode = 'FRA' WHERE SecCode = 6587166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799956019, ExchCode = 'FRA' WHERE SecCode = 6587168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799956646, ExchCode = 'FRA' WHERE SecCode = 6587169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144809594, ExchCode = 'QTX' WHERE SecCode = 6587170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144809611, ExchCode = 'QTX' WHERE SecCode = 6587171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955919, ExchCode = 'FRA' WHERE SecCode = 6587172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799956921, ExchCode = 'FRA' WHERE SecCode = 6587173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799956022, ExchCode = 'FRA' WHERE SecCode = 6587174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955911, ExchCode = 'FRA' WHERE SecCode = 6587175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955918, ExchCode = 'FRA' WHERE SecCode = 6587176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955910, ExchCode = 'FRA' WHERE SecCode = 6587177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955923, ExchCode = 'FRA' WHERE SecCode = 6587178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955921, ExchCode = 'FRA' WHERE SecCode = 6587179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955913, ExchCode = 'FRA' WHERE SecCode = 6587180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955912, ExchCode = 'FRA' WHERE SecCode = 6587181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799956021, ExchCode = 'FRA' WHERE SecCode = 6587182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955922, ExchCode = 'FRA' WHERE SecCode = 6587183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955966, ExchCode = 'FRA' WHERE SecCode = 6587184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955965, ExchCode = 'FRA' WHERE SecCode = 6587185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955914, ExchCode = 'FRA' WHERE SecCode = 6587186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800096565, ExchCode = 'FRA' WHERE SecCode = 6590583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22135607728, ExchCode = 'MUN' WHERE SecCode = 6617649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183909494, Ticker = 'XDWL', ExchCode = 'SWX' WHERE SecCode = 6626392 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 6628704 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 6628706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802292831, ExchCode = 'FRA' WHERE SecCode = 6635297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802292829, ExchCode = 'FRA' WHERE SecCode = 6635298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802292830, ExchCode = 'FRA' WHERE SecCode = 6635299 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802293399, ExchCode = 'FRA' WHERE SecCode = 6635300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802293189, ExchCode = 'FRA' WHERE SecCode = 6635301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802456204, ExchCode = 'DUS' WHERE SecCode = 6638341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802540440, ExchCode = 'FRA' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-01', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 6654493 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236807784319.0 WHERE SecCode = 6661570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883770164, ExchCode = 'DEU' WHERE SecCode = 6667833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011191253, ExchCode = 'BEC' WHERE SecCode = 6678589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22162018269, ExchCode = 'DEU' WHERE SecCode = 6686515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803813144, ExchCode = 'GTX' WHERE SecCode = 6686516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22162027408, ExchCode = 'DEU' WHERE SecCode = 6686517 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SQN2' WHERE SecCode = 6708280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804168533, ExchCode = 'STU' WHERE SecCode = 6724297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795337293, ExchCode = 'BIV' WHERE SecCode = 6741058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805095498, ExchCode = 'DUS' WHERE SecCode = 6753078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699530, ExchCode = 'MEX' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805672065, ExchCode = 'FRA' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22096729407, ExchCode = 'STU' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-06-02' WHERE SecCode = 6802647 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-31' WHERE SecCode = 6802657 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-01' WHERE SecCode = 6806149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22180069245, ExchCode = 'QTX' WHERE SecCode = 6808918 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 6820112 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-01', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 6826577 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 6829099 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 6836138 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 6849763 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-02' WHERE SecCode = 6849874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807168148, ExchCode = 'TDG' WHERE SecCode = 6862202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807275295, ExchCode = 'FRA' WHERE SecCode = 6865151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807275239, ExchCode = 'FRA' WHERE SecCode = 6865152 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-31' WHERE SecCode = 6868108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173257729, ExchCode = 'GER' WHERE SecCode = 6868124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807481801, ExchCode = 'FRA' WHERE SecCode = 6873669 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 6876664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173257704, ExchCode = 'GER' WHERE SecCode = 6876680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807882960, ExchCode = 'TDG' WHERE SecCode = 6880256 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 10970511 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 10985467 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-01', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11003221 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-03' WHERE SecCode = 11045356 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11106007 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11112972 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'AOWDF', PermQuoteRetireDate = NULL WHERE SecCode = 11136222 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-30' WHERE SecCode = 11158560 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11194223 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11205034 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951923.0 WHERE SecCode = 11209346 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'DUKMF', PermQuoteRetireDate = NULL WHERE SecCode = 11211909 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 11221509 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11229735 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11253748 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11255356 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11255357 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951747.0 WHERE SecCode = 11259019 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11269037 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11269373 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11278677 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11284328 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11284333 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236807784319, PriTrdQuotePermID = 236807784319.0, ExchCode = 'ASE', PermSecMapStartDate = '2026-05-30' WHERE SecCode = 11290249 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11291332 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11291334 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-01' WHERE SecCode = 11296510 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236807784392, IsPrimaryQuote = 1, ExchCode = 'NSM' WHERE SecCode = 11296654 AND Type_ = 1;
