UPDATE data_universe_permid SET QuotePermID = 55836048756, Ticker = 'HON', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-02' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296006, PermQuoteStatus = 'DC', Ticker = 'ALV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 622 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 6150 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 7456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718461406, Ticker = '0P4Fl', ExchCode = 'BCO' WHERE SecCode = 12970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18', PermSecMapEndDate = '2021-02-10' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358466, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 34155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033744, PermQuoteStatus = 'AC', Ticker = 'AMD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475562064, PermQuoteStatus = 'DC', Ticker = 'AEC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21497273980, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-12' WHERE SecCode = 39278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596035518, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-18' WHERE SecCode = 39373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493393, PermQuoteStatus = 'DC', Ticker = 'XPG', ExchCode = 'QTX', PermQuoteRetireDate = '2025-10-28' WHERE SecCode = 39443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655824017, ExchCode = 'DEU' WHERE SecCode = 43249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302063, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 43574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520627498, ExchCode = 'DEU' WHERE SecCode = 43579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777584291, ExchCode = 'STU' WHERE SecCode = 43705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836565430, ExchCode = 'FRA' WHERE SecCode = 44050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140269822, ExchCode = 'DEU' WHERE SecCode = 44151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520627262, ExchCode = 'DEU' WHERE SecCode = 44154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539585000, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 44176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381432, ExchCode = 'LAS' WHERE SecCode = 44254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852201118, ExchCode = 'GTX' WHERE SecCode = 44260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520627424, Ticker = 'CPZ1', ExchCode = 'DEU' WHERE SecCode = 44270 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 = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624187, Ticker = 'SCX', ExchCode = 'MUN', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616156912, ExchCode = 'MCX' WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801449047, ExchCode = 'DEU' WHERE SecCode = 47312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801607800, ExchCode = 'MUN' WHERE SecCode = 53597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475591438, ExchCode = 'MUN', PermQuoteRetireDate = '2008-02-18' WHERE SecCode = 53922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491141, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 55948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475606530, ExchCode = 'HAN', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 56163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516194644, ExchCode = 'STU' WHERE SecCode = 56216 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 = 21667483123, ExchCode = 'QTX' WHERE SecCode = 56520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243527, ExchCode = 'MUN', PermQuoteRetireDate = '2008-10-06' WHERE SecCode = 56524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783641141, ExchCode = 'MUN' WHERE SecCode = 56529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591308334, ExchCode = 'STU' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621680880, ExchCode = 'TDG' WHERE SecCode = 58060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169214943, ExchCode = 'DEU', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 58107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327177, ExchCode = 'BER', PermQuoteRetireDate = '2020-08-10' WHERE SecCode = 58140 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 58561 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21474858081, PermQuoteStatus = 'AC', Ticker = 'D2MN', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 58933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681575808, ExchCode = 'STU' WHERE SecCode = 58939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553398590, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 59531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699373266, ExchCode = 'DEU' WHERE SecCode = 59881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475436169, ExchCode = 'STU' WHERE SecCode = 59906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492066, ExchCode = 'QTX', PermQuoteRetireDate = '2023-03-07' WHERE SecCode = 59963 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 60052 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 60060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 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 = 21475030486, ExchCode = 'FRA' WHERE SecCode = 60596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856728229, ExchCode = 'TDG' WHERE SecCode = 60667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034225, ExchCode = 'TDG' WHERE SecCode = 61975 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 62226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475704691, ExchCode = 'MUN', PermQuoteRetireDate = '2008-09-16' WHERE SecCode = 62285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532325019, ExchCode = 'BER' WHERE SecCode = 64907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535832346, ExchCode = 'STU' WHERE SecCode = 64908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842779987, Ticker = 'TLOG', ExchCode = 'STO', PermQuoteRetireDate = '2008-04-29' WHERE SecCode = 65616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474862261, ExchCode = 'DEU', PermQuoteRetireDate = '2019-02-14' WHERE SecCode = 65643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525212599, ExchCode = 'DEU', PermQuoteRetireDate = '2020-03-20' WHERE SecCode = 65700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324715, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 66530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339510, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 66532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448687, ExchCode = 'FRA' WHERE SecCode = 66655 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-15' WHERE SecCode = 69654 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 75414 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-03-30' WHERE SecCode = 76579 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-27' WHERE SecCode = 83159 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 86092 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-27' WHERE SecCode = 87101 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232927376180.0 WHERE SecCode = 89250 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 92746 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 94697 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-27' WHERE SecCode = 95711 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 97746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128769414, ExchCode = 'DEU' WHERE SecCode = 100032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490953, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-20' WHERE SecCode = 100052 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 100589 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21609211565, ExchCode = 'TDG' WHERE SecCode = 103792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341666, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 103840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836418073, ExchCode = 'FRA' WHERE SecCode = 103841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335490, ExchCode = 'BER' WHERE SecCode = 103863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475499889, ExchCode = 'STU' WHERE SecCode = 103891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474923635, ExchCode = 'DEU' WHERE SecCode = 103894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513801692, Ticker = 'OFC', ExchCode = 'STU', PermQuoteRetireDate = '2015-07-03' WHERE SecCode = 111691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836559542, ExchCode = 'FRA', PermQuoteRetireDate = '2025-04-02' WHERE SecCode = 111847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794818049, ExchCode = 'DEU' WHERE SecCode = 111858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359282, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 111866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517582825, ExchCode = 'STU' WHERE SecCode = 111867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838237040, ExchCode = 'MUN' WHERE SecCode = 111869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856943909, Ticker = '6MI', ExchCode = 'STU', PermQuoteRetireDate = '2011-12-19' WHERE SecCode = 111924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821670376, ExchCode = 'QTX', PermQuoteRetireDate = '2023-06-14' WHERE SecCode = 111938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241914, ExchCode = 'MUN' WHERE SecCode = 112025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589493827, ExchCode = 'STU', PermQuoteRetireDate = '2025-12-19' WHERE SecCode = 112035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295813, ExchCode = 'GTX' WHERE SecCode = 112043 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 113201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475030105, ExchCode = 'FRA' WHERE SecCode = 113614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381665, ExchCode = 'LAS' WHERE SecCode = 113656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575930915, ExchCode = 'FRA' WHERE SecCode = 113659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328976, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 113864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474870209, ExchCode = 'DEU' WHERE SecCode = 114455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785486228, ExchCode = 'FRA' WHERE SecCode = 115623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522213024, ExchCode = 'MUN' WHERE SecCode = 115781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705696, ExchCode = 'MXQ' WHERE SecCode = 121226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704294, ExchCode = 'MXQ' WHERE SecCode = 121616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434487, ExchCode = 'LAS' WHERE SecCode = 122073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475080320, ExchCode = 'FRA' WHERE SecCode = 122888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838626835, ExchCode = 'STU', PermQuoteRetireDate = '2009-09-03' WHERE SecCode = 122890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097037081, ExchCode = 'MXQ' WHERE SecCode = 122907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835814077, ExchCode = 'MEX' WHERE SecCode = 122909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835813052, ExchCode = 'MEX' WHERE SecCode = 122911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835813466, ExchCode = 'MEX' WHERE SecCode = 122927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705816, ExchCode = 'MXQ' WHERE SecCode = 122931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706104, ExchCode = 'MXQ' WHERE SecCode = 122934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042374, Ticker = 'GHD', ExchCode = 'DEU', PermQuoteRetireDate = '2025-07-29' WHERE SecCode = 123120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803403425, ExchCode = 'FRA' WHERE SecCode = 124108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329559, ExchCode = 'BER' WHERE SecCode = 124115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55839747930, ExchCode = 'FRA' WHERE SecCode = 124562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528684368, ExchCode = 'TDG', PermQuoteRetireDate = '2014-10-27' WHERE SecCode = 124574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835819889, ExchCode = 'MEX' WHERE SecCode = 124579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679371, ExchCode = 'BIV' WHERE SecCode = 124586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475129817, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 131865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475631053, ExchCode = 'FRA', PermQuoteRetireDate = '2006-05-10' WHERE SecCode = 132168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679838, ExchCode = 'BIV' WHERE SecCode = 132170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529040359, ExchCode = 'STU' WHERE SecCode = 132188 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 132380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475008958, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 132508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473389, ExchCode = 'GER' WHERE SecCode = 133773 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-26' WHERE SecCode = 136022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331577, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 137364 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 140166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324195, ExchCode = 'BER' WHERE SecCode = 140727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475431314, Ticker = 'GASO.I', ExchCode = 'COO', PermQuoteRetireDate = '2008-08-01' WHERE SecCode = 141248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22109817256, ExchCode = 'DEU' WHERE SecCode = 141307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22106090319, ExchCode = 'DEU' WHERE SecCode = 141384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153748680, ExchCode = 'DEU' WHERE SecCode = 141386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705175, ExchCode = 'MXQ' WHERE SecCode = 141450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537344593, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 142505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037625, ExchCode = 'MUN' WHERE SecCode = 142650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475425498, ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 142661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387689, ExchCode = 'LAS' WHERE SecCode = 142718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475878362, ExchCode = 'STU' WHERE SecCode = 142742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501927589, ExchCode = 'STU' WHERE SecCode = 142822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507878763, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-27' WHERE SecCode = 142997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487049, ExchCode = 'QTX' WHERE SecCode = 143069 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475425789, ExchCode = 'FRA' WHERE SecCode = 143162 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475417691, ExchCode = 'BER', PermQuoteRetireDate = '2008-07-24' WHERE SecCode = 143196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838235310, ExchCode = 'MUN' WHERE SecCode = 143197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474896727, ExchCode = 'DEU' WHERE SecCode = 143198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510896217, ExchCode = 'TDG' WHERE SecCode = 143201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779191373, ExchCode = 'FRA' WHERE SecCode = 143418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329711, ExchCode = 'BER', PermQuoteRetireDate = '2021-08-30' WHERE SecCode = 143427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336196, ExchCode = 'BER' WHERE SecCode = 143432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394144, PermQuoteStatus = 'AC', Ticker = 'CD5', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 143563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633621377, Ticker = '0HQW', ExchCode = 'LSE' WHERE SecCode = 143692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633621200, Ticker = '0Y9S', ExchCode = 'LSE' WHERE SecCode = 143694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660711237, ExchCode = 'FRA', PermQuoteRetireDate = '2023-10-27' WHERE SecCode = 143730 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673942, ExchCode = 'LSE', PermQuoteRetireDate = '2023-02-15' WHERE SecCode = 143899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327368, PermQuoteStatus = 'DC', Ticker = 'DME', ExchCode = 'BER', PermQuoteRetireDate = '2019-09-16' WHERE SecCode = 143937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790170765, Ticker = 'IPC', ExchCode = 'LSE' WHERE SecCode = 143961 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 = 21565229404, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718461396, Ticker = '0NOFl', ExchCode = 'BCO' WHERE SecCode = 144186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480750, ExchCode = 'QTX' WHERE SecCode = 144293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823782711, ExchCode = 'DUS' WHERE SecCode = 144300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787407, ExchCode = 'DUS' WHERE SecCode = 144320 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 = 236782196285, ExchCode = 'QTX' 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 PermInstrStatus = 'DC' WHERE SecCode = 144431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329443, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 144472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394035, Ticker = 'D3S4', ExchCode = 'FRA', PermQuoteRetireDate = '2020-05-25' WHERE SecCode = 144547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485183, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 144731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469577, ExchCode = 'QTX' WHERE SecCode = 144735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569877, ExchCode = 'QTX' WHERE SecCode = 144797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475447517, Ticker = 'SSBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 144817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338891, ExchCode = 'BER' WHERE SecCode = 144819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611106182, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-05' WHERE SecCode = 144853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339223, Ticker = 'YGF', ExchCode = 'BER', PermQuoteRetireDate = '2014-04-03' WHERE SecCode = 144907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329184, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034838, PermQuoteStatus = 'DC', Ticker = 'INF', ExchCode = 'TDG', PermQuoteRetireDate = '2017-10-16' WHERE SecCode = 144928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333622, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 144989 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 144992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327973, ExchCode = 'BER', PermQuoteRetireDate = '2019-04-30' WHERE SecCode = 145208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820744, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 145274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836342050, Ticker = 'XA3', ExchCode = 'BER', PermQuoteRetireDate = '2012-06-14' WHERE SecCode = 145282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836435892, ExchCode = 'FRA' WHERE SecCode = 145323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338844, ExchCode = 'BER' WHERE SecCode = 145335 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 = 55836328090, ExchCode = 'BER' WHERE SecCode = 145428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331804, ExchCode = 'BER' WHERE SecCode = 145477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799369548, ExchCode = 'FRA' WHERE SecCode = 145505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337535, ExchCode = 'BER' WHERE SecCode = 145506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475530695, Ticker = 'BLK.I', ExchCode = 'CIR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 145528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492610, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-02-12' WHERE SecCode = 145530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622184, Ticker = '0QZOl', ExchCode = 'BCO' WHERE SecCode = 145533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545752451, ExchCode = 'FRA', PermQuoteRetireDate = '2018-03-28' 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 = 21896589109, ExchCode = 'QTX' WHERE SecCode = 145600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526396053, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2017-04-24', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 145644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836049376, Ticker = 'HYXS', ExchCode = 'LSE', PermQuoteRetireDate = '2011-03-29' WHERE SecCode = 145816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804912301, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-03-26', PermSecMapEndDate = NULL WHERE SecCode = 146536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836051528, Ticker = 'GCLS', ExchCode = 'LSE', PermQuoteRetireDate = '2011-02-08' WHERE SecCode = 146851 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 147518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532682354, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 147667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333892, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 147838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837357368, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 150620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491141379, ExchCode = 'STU' WHERE SecCode = 150697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836427695, ExchCode = 'FRA' WHERE SecCode = 153404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836551908, ExchCode = 'FRA', PermQuoteRetireDate = '2013-01-04' WHERE SecCode = 161401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836412159, ExchCode = 'FRA' WHERE SecCode = 164349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323148, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 165009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336418, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-26' WHERE SecCode = 165818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981685, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 167981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705740, ExchCode = 'MXQ' WHERE SecCode = 168676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520146054, ExchCode = 'STU' WHERE SecCode = 168960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308492, ExchCode = 'GTX' WHERE SecCode = 169894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612598956, ExchCode = 'FRA' WHERE SecCode = 170656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836435233, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 172985 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538295314, ExchCode = 'STU' WHERE SecCode = 172989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332251, ExchCode = 'BER', PermQuoteRetireDate = '2023-08-01' WHERE SecCode = 172998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850436291, ExchCode = 'GER' WHERE SecCode = 173009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836422574, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591015783, ExchCode = 'STU', PermQuoteRetireDate = '2020-05-18' WHERE SecCode = 177350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858577, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28', PermSecMapEndDate = '2024-03-28' WHERE SecCode = 177409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837357816, ExchCode = 'GER' WHERE SecCode = 177415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474855192, ExchCode = 'DEU' WHERE SecCode = 177427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537831580, ExchCode = 'STU' WHERE SecCode = 177431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523325339, ExchCode = 'DEU' WHERE SecCode = 177440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855345734, ExchCode = 'GTX' WHERE SecCode = 177491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333764, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 177502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475029261, ExchCode = 'FRA' WHERE SecCode = 177528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943807754, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836420637, ExchCode = 'FRA' WHERE SecCode = 177707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538212, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177724 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845359789, ExchCode = 'FRA' WHERE SecCode = 177732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836391762, ExchCode = 'FRA' WHERE SecCode = 177735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782605829, ExchCode = 'QTX' WHERE SecCode = 177738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757667035, ExchCode = 'BER' WHERE SecCode = 177739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820586403, ExchCode = 'TDG' WHERE SecCode = 177769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100379, ExchCode = 'QTX' WHERE SecCode = 177779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659447, ExchCode = 'GTX' WHERE SecCode = 177936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836455554, ExchCode = 'FRA' WHERE SecCode = 177955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931186247, ExchCode = 'GTX' WHERE SecCode = 177960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488084, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 177981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592567060, ExchCode = 'TDG', PermQuoteRetireDate = '2019-10-01' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493261, ExchCode = 'QTX' WHERE SecCode = 178130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789211055, ExchCode = 'DEU' WHERE SecCode = 178144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836500542, Ticker = 'REZ', ExchCode = 'FRA' WHERE SecCode = 178157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491862, ExchCode = 'QTX' WHERE SecCode = 178159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475780385, ExchCode = 'FRA' WHERE SecCode = 178163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058755, ExchCode = 'FRA' WHERE SecCode = 178186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141122, ExchCode = 'FRA' WHERE SecCode = 178338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852382952, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 178342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284811, ExchCode = 'GTX' WHERE SecCode = 178363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731995402, ExchCode = 'DEU' WHERE SecCode = 178369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834373, ExchCode = 'DEU' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547005305, Ticker = 'IM9', ExchCode = 'STU', PermQuoteRetireDate = '2021-09-30' WHERE SecCode = 178410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381323, PermQuoteStatus = 'DC', Ticker = 'BZS', ExchCode = 'LAS', PermQuoteRetireDate = '2024-12-02' WHERE SecCode = 178420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514031381, ExchCode = 'STU', PermQuoteRetireDate = '2013-06-24' WHERE SecCode = 178447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847681611, InstrPermID = 8591288124, OrgPermID = 5052536757, ValQuotePermID = 21910130143.0, PriInstrPermID = 8591288124.0, PermInstrStatus = 'AC', Ticker = 'IFIC', ExchCode = 'HAM', DomCntry = 'NLD', IncCntry = 'NLD', PriTRBCIndPermID = 4294951841.0, PermQuoteRetireDate = '2012-07-11', PermOrgIPODate = '2016-12-12' WHERE SecCode = 178448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385676, ExchCode = 'LAS' WHERE SecCode = 178451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838505143, ExchCode = 'STU' WHERE SecCode = 178488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534044070, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 178498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754922611, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 178507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836431170, ExchCode = 'FRA' WHERE SecCode = 178511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849806518, ExchCode = 'GTX' WHERE SecCode = 178514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198267, ExchCode = 'FRA' WHERE SecCode = 178520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475499985, ExchCode = 'MUN', PermQuoteRetireDate = '2008-01-16' WHERE SecCode = 178582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414739, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842265543, ExchCode = 'FRA' WHERE SecCode = 178655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330312, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 178657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779534795, ExchCode = 'GTX' WHERE SecCode = 178688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486046, PermQuoteStatus = 'AC', Ticker = 'HJN1', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285876, ExchCode = 'GTX' WHERE SecCode = 178720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475148721, ExchCode = 'DEU' WHERE SecCode = 178724 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772667, ExchCode = 'DEU' WHERE SecCode = 178732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679753, ExchCode = 'GER' WHERE SecCode = 178849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289031, PermQuoteStatus = 'AC', Ticker = 'BOZA', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 179089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550079044, ExchCode = 'HAM' WHERE SecCode = 180213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786447973, ExchCode = 'FRA' WHERE SecCode = 180215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483940, ExchCode = 'QTX' WHERE SecCode = 180252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322930, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 180258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419324, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 180263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903777205, ExchCode = 'HAN' WHERE SecCode = 180354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533564239, ExchCode = 'STU', PermQuoteRetireDate = '2025-12-08' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275503, ExchCode = 'GTX' WHERE SecCode = 180692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337360, ExchCode = 'BER' WHERE SecCode = 180695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474989125, ExchCode = 'DEU' WHERE SecCode = 181909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954293405, ExchCode = 'DUS' WHERE SecCode = 181992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838736391, Ticker = 'VLG', ExchCode = 'MCE', PermQuoteRetireDate = '2013-08-09' WHERE SecCode = 182166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270184, ExchCode = 'DUS' WHERE SecCode = 183383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555647, ExchCode = 'DEU' WHERE SecCode = 183422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926943, ExchCode = 'DEU' WHERE SecCode = 183471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336201, ExchCode = 'BER' WHERE SecCode = 184373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341941, ExchCode = 'BER' WHERE SecCode = 184376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566116516, ExchCode = 'STU' WHERE SecCode = 186400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536544263, ExchCode = 'DEU' WHERE SecCode = 186428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650270, ExchCode = 'DUS' WHERE SecCode = 186462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489954, ExchCode = 'QTX' WHERE SecCode = 186469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483698, ExchCode = 'QTX' WHERE SecCode = 186470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881522594, ExchCode = 'MUN' WHERE SecCode = 186478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21900738127, ExchCode = 'GTX' WHERE SecCode = 186488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488602, Ticker = 'NCGB', ExchCode = 'QTX' WHERE SecCode = 186489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836415519, ExchCode = 'FRA' WHERE SecCode = 186493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493990006, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 186608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792426806, ExchCode = 'FRA' WHERE SecCode = 186739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238725, ExchCode = 'LAS' WHERE SecCode = 186740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860309238, ExchCode = 'MUN' WHERE SecCode = 186744 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487864, ExchCode = 'QTX' WHERE SecCode = 186810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387716, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 187234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509911818, ExchCode = 'TDG', PermQuoteRetireDate = '2022-07-04' WHERE SecCode = 187752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475135121, ExchCode = 'MUN', PermQuoteRetireDate = '2024-12-27' WHERE SecCode = 187830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475420098, ExchCode = 'POS' WHERE SecCode = 188480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486975, ExchCode = 'QTX' WHERE SecCode = 188521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836393742, ExchCode = 'FRA' WHERE SecCode = 188522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519033, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 188523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324515, ExchCode = 'BER' WHERE SecCode = 189024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323361, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 189025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294352, ExchCode = 'GTX', PermQuoteRetireDate = '2025-06-11' WHERE SecCode = 189566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624758, Ticker = NULL, ExchCode = 'BER', PermQuoteRetireDate = '2006-03-01' WHERE SecCode = 189574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659576, ExchCode = 'QTX' 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 = 21585875048, ExchCode = 'FRA' WHERE SecCode = 190229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954813, ExchCode = 'LAS' WHERE SecCode = 190498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667471562, ExchCode = 'QTX' WHERE SecCode = 194654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519039, ExchCode = 'DUS' WHERE SecCode = 194847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812165943, ExchCode = 'MUN' WHERE SecCode = 195545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482302, Ticker = 'BNF', ExchCode = 'QTX' WHERE SecCode = 196120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473861, ExchCode = 'GER' WHERE SecCode = 196149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805015324, ExchCode = 'MUN' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765448129, ExchCode = 'BCO' WHERE SecCode = 196630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681116518, ExchCode = 'DEU' WHERE SecCode = 196829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819929691, ExchCode = 'DUS' WHERE SecCode = 196887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628061494, ExchCode = 'DEU' WHERE SecCode = 197081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836461104, ExchCode = 'FRA' WHERE SecCode = 197192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784107267, ExchCode = 'FRA' WHERE SecCode = 197197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560955189, ExchCode = 'TDG' WHERE SecCode = 199016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485543, ExchCode = 'QTX' WHERE SecCode = 199021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196302, ExchCode = 'QTX' WHERE SecCode = 200581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846995154, ExchCode = 'FRA', PermQuoteRetireDate = '2012-08-06' WHERE SecCode = 200970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981642, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 201293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638242806, ExchCode = 'TDG' WHERE SecCode = 201593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704190, ExchCode = 'MXQ' WHERE SecCode = 201875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836388635, ExchCode = 'FRA' WHERE SecCode = 201945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062328, ExchCode = 'MUN' WHERE SecCode = 201946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937822314, ExchCode = 'HAN' WHERE SecCode = 201949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787230, ExchCode = 'DUS' WHERE SecCode = 201951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488851, ExchCode = 'QTX' WHERE SecCode = 202621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953597674, ExchCode = 'DUS' WHERE SecCode = 202767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841903622, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 202787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794060561, ExchCode = 'MUN' WHERE SecCode = 202933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874526, ExchCode = 'MUN' WHERE SecCode = 202935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795295012, ExchCode = 'QTX' WHERE SecCode = 203057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575204757, ExchCode = 'HAM', PermQuoteRetireDate = '2016-05-18' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332121, ExchCode = 'BER', PermQuoteRetireDate = '2017-04-05' WHERE SecCode = 203925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732298150, ExchCode = 'DUS' WHERE SecCode = 205611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486925, ExchCode = 'QTX' WHERE SecCode = 206769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857653403, Ticker = 'FFEF', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 206829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544956008, ExchCode = 'DEU' WHERE SecCode = 208922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328659, ExchCode = 'BER' WHERE SecCode = 208947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819276162, ExchCode = 'MUN' WHERE SecCode = 210734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486342, ExchCode = 'QTX', PermQuoteRetireDate = '2022-11-29' WHERE SecCode = 210757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837356315, ExchCode = 'GER' WHERE SecCode = 211823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387856, ExchCode = 'LAS' WHERE SecCode = 215110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837362315, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 246361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589808, Ticker = 'CMGG.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 246441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275541, ExchCode = 'GTX' WHERE SecCode = 248506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475827221, PermQuoteStatus = 'AC', Ticker = 'TCS', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 248522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837437935, Ticker = 'EMG', ExchCode = 'MIL', PermQuoteRetireDate = '2017-11-24' WHERE SecCode = 248524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780383910, ExchCode = 'GTX' WHERE SecCode = 248556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836392550, ExchCode = 'FRA' WHERE SecCode = 248569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492775, ExchCode = 'QTX' WHERE SecCode = 248738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823259719, ExchCode = 'DUS', PermQuoteRetireDate = '2024-09-17' WHERE SecCode = 248749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485908, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 248773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837356986, ExchCode = 'GER' WHERE SecCode = 248774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492126, ExchCode = 'QTX' WHERE SecCode = 248970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491570, ExchCode = 'QTX' WHERE SecCode = 248987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755228131, ExchCode = 'TDG' WHERE SecCode = 248989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341284, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 249048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035304, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2012-06-04' WHERE SecCode = 249049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805177384, PermQuoteRetireDate = '2022-03-23' WHERE SecCode = 249054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475646482, PermQuoteStatus = 'AC', Ticker = 'OSI2', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 249172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991681, ExchCode = 'DEU' WHERE SecCode = 249177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475631725, ExchCode = 'BER', PermQuoteRetireDate = '2006-10-30' WHERE SecCode = 249314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328104, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-04' WHERE SecCode = 249315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836469631, ExchCode = 'FRA' WHERE SecCode = 249318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616062980, ExchCode = 'TDG' WHERE SecCode = 249355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322849, ExchCode = 'BER', PermQuoteRetireDate = '2018-07-26' WHERE SecCode = 249362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777943936, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791320620, ExchCode = 'QTX' WHERE SecCode = 249370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573397788, ExchCode = 'TDG' WHERE SecCode = 249398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823782714, PermQuoteStatus = 'DC', Ticker = 'INO', ExchCode = 'DUS', PermQuoteRetireDate = '2024-04-02' WHERE SecCode = 249400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836388640, ExchCode = 'FRA', PermQuoteRetireDate = '2008-08-08' WHERE SecCode = 249403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483182, ExchCode = 'QTX' WHERE SecCode = 249426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526396050, ExchCode = 'FRA' WHERE SecCode = 249427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615298682, ExchCode = 'STU' WHERE SecCode = 249565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21580960889, ExchCode = 'MUN' WHERE SecCode = 249573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562213698, ExchCode = 'TDG' WHERE SecCode = 249592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629957583, ExchCode = 'TDG' WHERE SecCode = 249598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109803, ExchCode = 'DUS' WHERE SecCode = 249624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490419, ExchCode = 'QTX' WHERE SecCode = 249627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326625, Ticker = 'CKI2', ExchCode = 'BER', PermQuoteRetireDate = '2020-11-06' WHERE SecCode = 249643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475429068, ExchCode = 'FRA' WHERE SecCode = 249648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723076690, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2022-09-26', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475083520, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-25' WHERE SecCode = 249654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334703, PermQuoteStatus = 'DC', Ticker = 'PJR', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 249677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474855924, ExchCode = 'DEU' WHERE SecCode = 249683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779358971, ExchCode = 'GTX' WHERE SecCode = 249684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836526588, ExchCode = 'FRA' WHERE SecCode = 249685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475878501, Ticker = 'QPH', ExchCode = 'TDG', PermQuoteRetireDate = '2014-08-18' WHERE SecCode = 249694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475606932, PermQuoteStatus = 'DC', Ticker = 'COZG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836409875, ExchCode = 'FRA' WHERE SecCode = 249712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859031911, ExchCode = 'FRA' WHERE SecCode = 249719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483907, ExchCode = 'QTX' WHERE SecCode = 249723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836559389, ExchCode = 'FRA' WHERE SecCode = 249726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799016537, ExchCode = 'TDG' WHERE SecCode = 249727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308054, ExchCode = 'GTX' WHERE SecCode = 249765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332536, ExchCode = 'BER', PermQuoteRetireDate = '2022-05-26', PermSecMapEndDate = '2022-05-26' WHERE SecCode = 249777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782463467, ExchCode = 'QTX' WHERE SecCode = 249786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587111637, ExchCode = 'DEU' WHERE SecCode = 249791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609681523, ExchCode = 'STU' WHERE SecCode = 249796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475471083, ExchCode = 'GER', PermQuoteRetireDate = '2009-04-28' WHERE SecCode = 249843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837354134, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 249844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755977745, ExchCode = 'DUS' WHERE SecCode = 249853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836419614, ExchCode = 'FRA' WHERE SecCode = 249861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487891, ExchCode = 'QTX' WHERE SecCode = 250132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286142, ExchCode = 'GTX' WHERE SecCode = 254358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034768, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2015-12-04' WHERE SecCode = 257977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509894968, Ticker = 'THKU', ExchCode = 'LSE', PermQuoteRetireDate = '2008-10-01' WHERE SecCode = 279674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836493793, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 283718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836522301, ExchCode = 'FRA', PermQuoteRetireDate = '2011-08-17' WHERE SecCode = 283842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836391522, ExchCode = 'FRA' WHERE SecCode = 286289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515990971, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 288296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840969688, ExchCode = 'STU', PermQuoteRetireDate = '2008-10-01' WHERE SecCode = 289026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584775592, ExchCode = 'TDG' WHERE SecCode = 289154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341148, ExchCode = 'BER' WHERE SecCode = 289584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836520595, ExchCode = 'FRA' WHERE SecCode = 289617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489325, ExchCode = 'QTX', PermQuoteRetireDate = '2023-03-06', PermSecMapEndDate = '2023-03-06' WHERE SecCode = 289619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325363, Ticker = 'ECA1', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 291269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836388942, ExchCode = 'FRA', PermQuoteRetireDate = '2009-01-07' WHERE SecCode = 291270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773003127, ExchCode = 'DEU' WHERE SecCode = 291283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331784, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 291583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339128, ExchCode = 'BER', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 293703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794249941, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 295285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475471595, ExchCode = 'GER' WHERE SecCode = 296127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836392190, ExchCode = 'FRA', PermQuoteRetireDate = '2008-08-05' WHERE SecCode = 296278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836502666, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 296592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539411525, ExchCode = 'STU' WHERE SecCode = 297377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531134931, Ticker = 'TCGd', ExchCode = 'BCO', PermQuoteRetireDate = '2020-03-27' WHERE SecCode = 300395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845318193, Ticker = 'SE..GB', ExchCode = 'PLU', PermQuoteRetireDate = '2010-11-08' WHERE SecCode = 300803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838433153, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-10' WHERE SecCode = 300831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614932906, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 301718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335365, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 303342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843595648, ExchCode = 'FRA' WHERE SecCode = 303347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007244, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475107367, ExchCode = 'STU', PermQuoteRetireDate = '2016-02-10' WHERE SecCode = 303844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328354, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 303854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836362584, ExchCode = 'FRA', PermQuoteRetireDate = '2012-02-22' WHERE SecCode = 304083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035599, ExchCode = 'TDG' WHERE SecCode = 304121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836356570, ExchCode = 'FRA' WHERE SecCode = 304967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350087, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 305001 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'TSGO' WHERE SecCode = 306890 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21571572383, ExchCode = 'TDG' WHERE SecCode = 309339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792573068, ExchCode = 'BIV' WHERE SecCode = 311169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349112, ExchCode = 'FRA' WHERE SecCode = 313246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475425030, ExchCode = 'STU' WHERE SecCode = 313546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642065223, ExchCode = 'TDG' WHERE SecCode = 314186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550077092, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 315711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822221, ExchCode = 'FRA' WHERE SecCode = 316458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350338, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 316472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348095, ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-25' WHERE SecCode = 317228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320668, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 318406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323723, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 318424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348023, ExchCode = 'FRA' WHERE SecCode = 319524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571254271, Ticker = '3G8A', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 320392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537344839, ExchCode = 'STU' WHERE SecCode = 325645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378775, ExchCode = 'STU' WHERE SecCode = 325661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479469, ExchCode = 'QTX', PermQuoteRetireDate = '2021-08-09' WHERE SecCode = 326285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320604, ExchCode = 'BER' WHERE SecCode = 326661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730199351, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2023-07-21', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 330665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863472363, Ticker = '3BH', ExchCode = 'HAM', PermQuoteRetireDate = '2017-06-07' WHERE SecCode = 331318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836370746, ExchCode = 'FRA', PermQuoteRetireDate = '2009-04-20' WHERE SecCode = 333158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350511, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 333180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836363186, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 333804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838302681, Ticker = 'SILP.FR', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 334460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804396529, ExchCode = 'DUS' WHERE SecCode = 335262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834674630, Ticker = '0OFR', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-21' WHERE SecCode = 336187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320555, ExchCode = 'BER' WHERE SecCode = 336198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520440561, ExchCode = 'DEU' WHERE SecCode = 337400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704905, ExchCode = 'MXQ' WHERE SecCode = 339973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836359938, ExchCode = 'FRA' WHERE SecCode = 341102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320662, ExchCode = 'BER' WHERE SecCode = 341124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479577, ExchCode = 'QTX' WHERE SecCode = 341959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381539, ExchCode = 'LAS' WHERE SecCode = 341961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321177, ExchCode = 'BER', PermQuoteRetireDate = '2017-08-08' WHERE SecCode = 341966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479339, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 342227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836353496, ExchCode = 'FRA' WHERE SecCode = 343073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834800221, Ticker = NULL, ExchCode = 'HKG', PermQuoteRetireDate = '2018-04-24' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116848257, ExchCode = 'DEU' WHERE SecCode = 345843 AND Type_ = 10;
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 = 55836321391, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 348120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475108673, Ticker = '0N06', ExchCode = 'LSE', PermQuoteRetireDate = '2012-02-13' WHERE SecCode = 348630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707243674, ExchCode = 'TDG' WHERE SecCode = 348709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419816, ExchCode = 'HAM' WHERE SecCode = 348719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838303566, Ticker = 'MEGA.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 349090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321139, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 350278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473201, ExchCode = 'GER' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509807554, Ticker = '0D39', ExchCode = 'POS' WHERE SecCode = 353941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320508, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 355184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321371, ExchCode = 'BER' WHERE SecCode = 356548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288726, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 363732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475474106, ExchCode = 'GER' WHERE SecCode = 364966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475432895, Ticker = 'MULT.GR', ExchCode = 'PLU', PermQuoteRetireDate = '2009-08-27' WHERE SecCode = 374930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484743, ExchCode = 'QTX' WHERE SecCode = 375326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836362069, ExchCode = 'FRA' WHERE SecCode = 376072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834676604, Ticker = '0ND5', ExchCode = 'LSE', PermQuoteRetireDate = '2022-06-09' WHERE SecCode = 378013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547002144, Ticker = 'D69d', ExchCode = 'BCO' WHERE SecCode = 379671 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-03-27' WHERE SecCode = 380600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782463487, ExchCode = 'QTX' WHERE SecCode = 385281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840913294, ExchCode = 'FRA' WHERE SecCode = 389775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840901357, ExchCode = 'BER', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 389776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475760801, ExchCode = 'STU' WHERE SecCode = 392214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841103521, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-11' WHERE SecCode = 392352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841643564, ExchCode = 'FRA' WHERE SecCode = 401624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388965, Ticker = 'ZIM.RO', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 408476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475472362, ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 408478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704362, ExchCode = 'MXQ' WHERE SecCode = 411789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800488, ExchCode = 'STU' WHERE SecCode = 412853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822777044, ExchCode = 'DUS' WHERE SecCode = 413132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523795704, ExchCode = 'STU' WHERE SecCode = 424779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843194281, ExchCode = 'FRA' WHERE SecCode = 425031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474878624, Ticker = '0KJT', ExchCode = 'LSE', PermQuoteRetireDate = '2010-07-26' WHERE SecCode = 425350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843333402, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-08' WHERE SecCode = 425411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647637521, ExchCode = 'TDG' WHERE SecCode = 425918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953597671, ExchCode = 'DUS' WHERE SecCode = 432012 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 = 55858584221, Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475022130, ExchCode = 'DEU' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850070208, ExchCode = 'FRA' WHERE SecCode = 518549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475454143, ExchCode = 'BER', PermQuoteRetireDate = '2006-07-31' WHERE SecCode = 519337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836423986, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 519509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428165, ExchCode = 'GTX' WHERE SecCode = 519511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837446990, Ticker = 'WEAT', ExchCode = 'MIL' WHERE SecCode = 521420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296198, ExchCode = 'GTX' WHERE SecCode = 524403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830307861, ExchCode = 'GTX', PermQuoteRetireDate = '2025-10-24' WHERE SecCode = 527096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886808270, ExchCode = 'MUN' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849997680, Ticker = 'SBUL', ExchCode = 'MIL' WHERE SecCode = 536401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480923684, ExchCode = 'BER', PermQuoteRetireDate = '2019-12-17' WHERE SecCode = 536609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607765095, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 541523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856846841, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 541974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474839548, ExchCode = 'STO', PermQuoteRetireDate = '2018-10-15' WHERE SecCode = 547513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852420890, ExchCode = 'STU', PermQuoteRetireDate = '2013-05-29' WHERE SecCode = 547537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301241, ExchCode = 'GTX' WHERE SecCode = 549236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785844948, ExchCode = 'TDG' WHERE SecCode = 549886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853693620, ExchCode = 'MUN', PermQuoteRetireDate = '2022-11-01', PermSecMapEndDate = '2022-11-01' WHERE SecCode = 553231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531126587, ExchCode = 'BCO', PermQuoteRetireDate = '2020-07-16' WHERE SecCode = 554481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659867268, ExchCode = 'TDG' WHERE SecCode = 554696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520392600, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 556230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856027323, ExchCode = 'FRA', PermQuoteRetireDate = '2013-07-04' WHERE SecCode = 556535 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 557690 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 557995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856214005, ExchCode = 'FRA' WHERE SecCode = 558032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856606623, ExchCode = 'FRA' WHERE SecCode = 559437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575565347, ExchCode = 'STU', PermQuoteRetireDate = '2018-04-26' WHERE SecCode = 560723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856859125, ExchCode = 'FRA', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 561328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856960400, ExchCode = 'FRA' WHERE SecCode = 561861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512281634, ExchCode = 'TRQ' WHERE SecCode = 563059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294098, ExchCode = 'GTX' WHERE SecCode = 563087 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 QuotePermID = 21550981529, ExchCode = 'HAM', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 583151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859177674, ExchCode = 'STU' WHERE SecCode = 592307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847342799, ExchCode = 'MUN' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290783, ExchCode = 'DUS' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428184, ExchCode = 'GTX' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22103473248, ExchCode = 'DEU' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492656, ExchCode = 'QTX' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846603850, Ticker = 'FMT', ExchCode = 'MUN', PermQuoteRetireDate = '2011-01-31' WHERE SecCode = 985004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769668, Ticker = 'TYM', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 995830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482228292, Ticker = 'BLIT', ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478615947, ExchCode = 'BUR' WHERE SecCode = 1465275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480921413, ExchCode = 'FRA' WHERE SecCode = 1481937 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-03-26', PermSecMapEndDate = NULL WHERE SecCode = 1513718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488289996, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488289855, ExchCode = 'FRA', PermQuoteRetireDate = '2022-05-31', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676639, ExchCode = 'BIV' WHERE SecCode = 1524554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794818026, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1527439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071858, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492888711, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-25' WHERE SecCode = 1537137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494267747, ExchCode = 'FRA' WHERE SecCode = 1541369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796520014, ExchCode = 'GTX' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893351, ExchCode = 'STU' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514434081, Ticker = '5GQA', ExchCode = 'BER', PermQuoteRetireDate = '2020-04-02' WHERE SecCode = 1554222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502150126, ExchCode = 'STU' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461757, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-04' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576116533, ExchCode = 'TDG' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524609219, ExchCode = 'BTE' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546492020, ExchCode = 'MUN' WHERE SecCode = 1607154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506574448, ExchCode = 'MUN' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507477237, ExchCode = 'DEU', PermQuoteRetireDate = '2023-10-09', PermSecMapEndDate = '2023-10-09' WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701628, Ticker = 'IBCG', ExchCode = 'BRN' WHERE SecCode = 1652279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629962634, Ticker = '7O2', ExchCode = 'STU' WHERE SecCode = 1656414 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 = 21531120618, Ticker = 'CHMTp', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-08' WHERE SecCode = 1677246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613032675, ExchCode = 'STU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520358, ExchCode = 'FRA' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511796493, ExchCode = 'DEU' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515522117, ExchCode = 'DEU' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512769043, ExchCode = 'FRA' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514715669, ExchCode = 'FRA' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516696149, Ticker = 'ECX', ExchCode = 'LSE', PermQuoteRetireDate = '2014-08-27' WHERE SecCode = 2013070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802866853, ExchCode = 'DEU' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519818958, ExchCode = 'DEU' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537129363, ExchCode = 'BER', PermQuoteRetireDate = '2025-06-12' WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430949, ExchCode = 'DEU' WHERE SecCode = 2213927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532444506, ExchCode = 'STU' WHERE SecCode = 2221995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522213264, ExchCode = 'FRA' WHERE SecCode = 2222349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834002, ExchCode = 'FRA' WHERE SecCode = 2225286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750324152, ExchCode = 'FRA' WHERE SecCode = 2232877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523563544, ExchCode = 'FRA' WHERE SecCode = 2239343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784838122, ExchCode = 'QTX' WHERE SecCode = 2246863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367932, ExchCode = 'SGO' WHERE SecCode = 2255742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477221044, Ticker = NULL WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525642046, ExchCode = 'DEU' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367928, ExchCode = 'SGO' WHERE SecCode = 2293144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664433951, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2332152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670892655, ExchCode = 'QTX' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21686715439, Ticker = 'CECD', ExchCode = 'LSE', PermQuoteRetireDate = '2021-12-20' WHERE SecCode = 2350989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-16' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530579384, ExchCode = 'DEU' WHERE SecCode = 2373485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371665, ExchCode = 'SGO' WHERE SecCode = 2377498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531130867, InstrPermID = 8590926370, OrgPermID = 4295858498, ValQuotePermID = 55835583224.0, PriInstrPermID = 8590926370.0, PermInstrStatus = 'AC', Ticker = 'MQG0d', ExchCode = 'BCO', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = 4294951922.0, PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2013-10-29' WHERE SecCode = 2387360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532811302, ExchCode = 'FRA' WHERE SecCode = 2403143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047304, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2412432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756688641, ExchCode = 'MUN' WHERE SecCode = 2421101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538681, ExchCode = 'FRA' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521327155, ExchCode = 'STU' WHERE SecCode = 2429992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533561487, ExchCode = 'MUN' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517626184, ExchCode = 'MUN' WHERE SecCode = 2448345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370397, ExchCode = 'SGO' WHERE SecCode = 2452538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537245207, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 2466348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999786358, ExchCode = 'BTE' 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 = 21625753531, ExchCode = 'CHI', PermQuoteRetireDate = '2025-11-11' WHERE SecCode = 2527880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538885258, ExchCode = 'DEU' WHERE SecCode = 2529651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618954036, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2532826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673930, ExchCode = 'BIV' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620652670, ExchCode = 'STU' WHERE SecCode = 2545065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540739504, ExchCode = 'FRA' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461691, ExchCode = 'DEU' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708867, ExchCode = 'FRA' WHERE SecCode = 2585326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996424, ExchCode = 'MUN' WHERE SecCode = 2585381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 2599278 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 = 21521369113, ExchCode = 'SGO' WHERE SecCode = 2625122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673660, ExchCode = 'BIV' WHERE SecCode = 2630981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606782728, ExchCode = 'FRA' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574200693, ExchCode = 'FRA' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548046381, ExchCode = 'STU' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673317, ExchCode = 'BIV' WHERE SecCode = 2644179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550408230, ExchCode = 'DEU' WHERE SecCode = 2679857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803385262, ExchCode = 'TDG' WHERE SecCode = 2725364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561687496, PermQuoteStatus = 'DC', Ticker = '5WP', ExchCode = 'GER', PermQuoteRetireDate = '2017-01-03' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784881963, ExchCode = 'QTX' WHERE SecCode = 2747510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890060428, ExchCode = 'MXQ' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554503916, ExchCode = 'DEU' WHERE SecCode = 2750981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679952, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2767178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561432644, ExchCode = 'FRA' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634749387, ExchCode = 'MUN' WHERE SecCode = 2830909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569832692, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-03' WHERE SecCode = 2880970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562688444, ExchCode = 'FRA' WHERE SecCode = 2880971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563614493, ExchCode = 'STU' WHERE SecCode = 2880972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386769, ExchCode = 'LAS' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563124035, ExchCode = 'FRA' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285585, ExchCode = 'GTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2916825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679813, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370656, ExchCode = 'SGO' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836510352, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-16' WHERE SecCode = 2947875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670295233, ExchCode = 'STU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722919701, ExchCode = 'BER' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5078528829, PriInstrPermID = 8590936747.0, DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951349.0, PermOrgIPODate = NULL WHERE SecCode = 3076712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584213518, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-21', PermSecMapEndDate = '2022-10-21' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-27' WHERE SecCode = 3119164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077935, ExchCode = 'LAS' WHERE SecCode = 3124235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320104, ExchCode = 'FRA' WHERE SecCode = 3124241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548007973, ExchCode = 'DEU' WHERE SecCode = 3177608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901754747, ExchCode = 'BCO' WHERE SecCode = 3193718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590831223, ExchCode = 'STU' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655814, Ticker = '4VOW3', ExchCode = 'ETX' WHERE SecCode = 3212165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591798940, ExchCode = 'TDG' WHERE SecCode = 3212190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720719093, ExchCode = 'BER', PermQuoteRetireDate = '2023-10-02', PermSecMapEndDate = NULL WHERE SecCode = 3215568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591959265, ExchCode = 'STU' WHERE SecCode = 3215818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634749168, ExchCode = 'MUN' WHERE SecCode = 3236427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659429, ExchCode = 'GTX' WHERE SecCode = 3244403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026729, Ticker = '1UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787711120, Ticker = '1CBKm', ExchCode = 'BCO' WHERE SecCode = 3247531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647227260, Ticker = '366', ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 3257169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598615492, ExchCode = 'STU', PermQuoteRetireDate = '2016-11-08' WHERE SecCode = 3260094 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 = 21517582787, ExchCode = 'STU' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797988618, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-29' WHERE SecCode = 3309705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608270955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679353, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947516, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3315888 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 = 21714769303, ExchCode = 'TDG' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443154, ExchCode = 'DEU' WHERE SecCode = 3320334 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 = 21887550956, ExchCode = 'MUN' WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621961481, Ticker = '4PSM', ExchCode = 'ETX' WHERE SecCode = 3347660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617014521, Ticker = '4EVK', ExchCode = 'ETX' WHERE SecCode = 3358919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819145774, PermQuoteStatus = 'AC', Ticker = '015A', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3375389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620409821, ExchCode = 'BCO' WHERE SecCode = 3385974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663433249, ExchCode = 'TDG' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650199, ExchCode = 'DUS' WHERE SecCode = 3392279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644928542, ExchCode = 'BER', PermQuoteRetireDate = '2022-06-21', PermSecMapEndDate = '2022-08-03' WHERE SecCode = 3393655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390710, ExchCode = 'FRA' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21637054002, ExchCode = 'BTE' WHERE SecCode = 3395249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623803395, ExchCode = 'FRA' WHERE SecCode = 3396014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195409, ExchCode = 'DUS' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630627945, ExchCode = 'FRA' WHERE SecCode = 3405439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709687546, PermQuoteStatus = 'AC', Ticker = 'S060', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3406028 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 3408093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679932, ExchCode = 'BIV' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630022342, ExchCode = 'STU' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786141622, ExchCode = 'MXQ' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631199559, ExchCode = 'STU' WHERE SecCode = 3410277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781060476, ExchCode = 'FRA', PermQuoteRetireDate = '2024-03-25' WHERE SecCode = 3429810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678582, ExchCode = 'BIV' WHERE SecCode = 3430824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761780224, ExchCode = 'FRA' WHERE SecCode = 3430952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705439, ExchCode = 'MXQ' WHERE SecCode = 3430968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634766459, ExchCode = 'DEU' WHERE SecCode = 3432164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651603021, ExchCode = 'STU' WHERE SecCode = 3434582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705861, ExchCode = 'MXQ' WHERE SecCode = 3434746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 3436849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836351977, ExchCode = 'QTX' WHERE SecCode = 3438714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796441340, ExchCode = 'HAM' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3440122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644011375, ExchCode = 'DEU' WHERE SecCode = 3445093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643807094, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3445201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644367377, ExchCode = 'DEU' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705440, ExchCode = 'MXQ' WHERE SecCode = 3446301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647430161, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649268603, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836509485, PermQuoteStatus = 'AC', Ticker = 'RLXB', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3499431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704432, ExchCode = 'MXQ' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056989, ExchCode = 'TDG' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653986688, Ticker = 'TGLl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-28' WHERE SecCode = 3536053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296299, ExchCode = 'GTX' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655132827, ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-30' WHERE SecCode = 3545357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795072494, ExchCode = 'LAS' WHERE SecCode = 3549499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656740299, Ticker = 'DNKl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-01-20' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681761612, ExchCode = 'DEU' WHERE SecCode = 3569619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584408989, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-06' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660609678, ExchCode = 'DEU' WHERE SecCode = 3588082 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296175, ExchCode = 'GTX' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706067030, ExchCode = 'CHI', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893299383, ExchCode = 'GTX' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804756095, ValQuotePermID = 236804756095.0, Ticker = 'BCPL', ExchCode = 'NSI' WHERE SecCode = 3619752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704823, ExchCode = 'MXQ' WHERE SecCode = 3629694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668158989, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672709111, ExchCode = 'FRA' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715145241, Ticker = 'ROAIz', ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670450813, ExchCode = 'DEU' WHERE SecCode = 3657811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505131, ExchCode = 'MUN' WHERE SecCode = 3658775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872230, ExchCode = 'DEU' WHERE SecCode = 3671114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675532883, ExchCode = 'DEU' WHERE SecCode = 3703433 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-03-26' WHERE SecCode = 3738156 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680901263, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-03' WHERE SecCode = 3738158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722345192, ExchCode = 'STU', PermQuoteRetireDate = '2021-12-20' WHERE SecCode = 3749084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872326, ExchCode = 'DEU' WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380275, ExchCode = 'LAS' WHERE SecCode = 3787147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713593778, ExchCode = 'MUN' WHERE SecCode = 3793374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687635991, ExchCode = 'TDG' WHERE SecCode = 3793375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705324, ExchCode = 'MXQ' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198305, ExchCode = 'DEU' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749597748, ExchCode = 'FRA' WHERE SecCode = 3800553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734047256, ExchCode = 'TDG', PermQuoteRetireDate = '2023-03-28', PermSecMapEndDate = '2023-03-30' WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690339113, ExchCode = 'TDG' WHERE SecCode = 3809861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679917567, Ticker = 'WUBAN', ExchCode = 'MXQ' WHERE SecCode = 3814192 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3817685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932243, ExchCode = 'FRA' WHERE SecCode = 3827962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789617001, ExchCode = 'BIV' WHERE SecCode = 3827965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694642699, Ticker = 'UT8d', ExchCode = 'BCO' WHERE SecCode = 3830032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930883, ExchCode = 'MUN' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757864191, ExchCode = 'DEU' WHERE SecCode = 3832750 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294114, ExchCode = 'GTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702351475, ExchCode = 'DEU', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703557839, Ticker = 'UPR', ExchCode = 'LSE' WHERE SecCode = 3883708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789792374, ExchCode = 'DUS' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774624811, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3899638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755619, ExchCode = 'FRA' WHERE SecCode = 3913159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820576474, ExchCode = 'DUS' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712452863, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3955660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21727350190, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3956835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731812579, ExchCode = 'TDG' WHERE SecCode = 3977296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718474201, ExchCode = 'FRA' WHERE SecCode = 3998157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098633, ExchCode = 'STU' WHERE SecCode = 4004564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655813, Ticker = '4HEIA', ExchCode = 'ETX' WHERE SecCode = 4031893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026796, Ticker = '1IAG' WHERE SecCode = 4032120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143990, Ticker = '2DSY', ExchCode = 'MIL' WHERE SecCode = 4032132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723633853, ExchCode = 'MUN' WHERE SecCode = 4032148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195044, ExchCode = 'STU' WHERE SecCode = 4032154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184449, ExchCode = 'SIG' WHERE SecCode = 4033113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779134244, ExchCode = 'AQX' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725978350, ExchCode = 'DEU' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838220597, Ticker = 'OCPET', ExchCode = 'BRU', PermQuoteRetireDate = '2023-10-02' WHERE SecCode = 4046600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732154086, ExchCode = 'DEU' WHERE SecCode = 4080678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976737, ExchCode = 'DEU' WHERE SecCode = 4106680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951941315, Ticker = '49Y0', ExchCode = 'QTX', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858461751, ExchCode = 'STU', PermQuoteRetireDate = '2024-11-05', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4124848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910492, ExchCode = 'STU' WHERE SecCode = 4212561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749838963, ExchCode = 'FRA' WHERE SecCode = 4225217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778023555, ExchCode = 'FRA', PermQuoteRetireDate = '2023-12-28' WHERE SecCode = 4228115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534014, ExchCode = 'TDG' WHERE SecCode = 4256876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349640, ExchCode = 'MEX' WHERE SecCode = 4259231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760973387, ExchCode = 'QTX' WHERE SecCode = 4303570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871880783, ExchCode = 'MUN' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781601742, ExchCode = 'GER' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772740424, Ticker = '2ENR' WHERE SecCode = 4372484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782535999, ExchCode = 'QTX' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960077472, ExchCode = 'GTX' WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794594488, ExchCode = 'FRA' WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780150286, ExchCode = 'MUN' WHERE SecCode = 4400153 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '6CP' WHERE SecCode = 4400160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312696, ExchCode = 'MEX' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996426, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785453356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4436991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787027751, PermQuoteStatus = 'DC', Ticker = '60P', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792098251, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528202, ExchCode = 'DUS' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781362966, ExchCode = 'DUS', PermQuoteRetireDate = '2024-02-20' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817527, ExchCode = 'DEU' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367255, ExchCode = 'DEU' WHERE SecCode = 4482517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797238012, ExchCode = 'DEU' WHERE SecCode = 4494227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795591035, Ticker = '0A6N', ExchCode = 'LSE' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797994407, ExchCode = 'STU' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727286505, ExchCode = 'BIV' WHERE SecCode = 4505794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851613, ExchCode = 'STU', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 4517642 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 4521354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808935929, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821271834, ExchCode = 'STU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804816877, ExchCode = 'STU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'COIL' WHERE SecCode = 4539312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271947, ExchCode = 'MEX' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830303213, ExchCode = 'GTX' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100496, ExchCode = 'QTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295798, ExchCode = 'GTX' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818264918, ExchCode = 'FRA' WHERE SecCode = 4617743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534591, ExchCode = 'QTX' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821858149, ExchCode = 'DEU' WHERE SecCode = 4633101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650261, ExchCode = 'DUS', PermQuoteRetireDate = '2025-01-16', PermSecMapEndDate = '2025-01-17' WHERE SecCode = 4643054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835319557, ExchCode = 'FRA' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316576, ExchCode = 'MUN' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837527952, Ticker = 'CARB', ExchCode = 'MIL' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851139181, Ticker = '6XZ', ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-25', PermSecMapEndDate = '2023-08-10' WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843915142, ExchCode = 'STU' WHERE SecCode = 4718903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846029349, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878863894, Ticker = 'VDOUz', ExchCode = 'BCO' WHERE SecCode = 4724692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845535652, ExchCode = 'FRA' WHERE SecCode = 4726104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851841869, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4730173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850878465, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-15' WHERE SecCode = 4748504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851345317, ExchCode = 'STU' WHERE SecCode = 4748505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853262569, ExchCode = 'FRA' WHERE SecCode = 4754869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169206727, Ticker = 'CO2Pl', ExchCode = 'BTE' WHERE SecCode = 4759573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861324024, ExchCode = 'STU' WHERE SecCode = 4766038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307226, ExchCode = 'MEX' WHERE SecCode = 4768117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552670, ExchCode = 'LAS' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439327, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-17' WHERE SecCode = 4773786 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 = 21857633448, ExchCode = 'QTX' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705625, ExchCode = 'STU' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886807336, ExchCode = 'GTX', PermQuoteRetireDate = '2025-01-15' WHERE SecCode = 4811144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862739872, ExchCode = 'FRA' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862998607, ExchCode = 'QTX' WHERE SecCode = 4818264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727258451, ExchCode = 'MEX' WHERE SecCode = 4827927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865902197, ExchCode = 'FRA' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580163, ExchCode = 'GER' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580240, ExchCode = 'GER' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398298, ExchCode = 'GER', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 4834793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419008, ExchCode = 'LAS' WHERE SecCode = 4834795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866892386 WHERE SecCode = 4841211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888954019, ExchCode = 'MUN', PermQuoteRetireDate = '2022-08-19', PermSecMapEndDate = NULL WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888953971, ExchCode = 'MUN', PermQuoteRetireDate = '2023-04-17' WHERE SecCode = 4845030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580736, ExchCode = 'GER' WHERE SecCode = 4845032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876129773, Ticker = '9XK0', ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-21' WHERE SecCode = 4873803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877551047, ExchCode = 'DEU' WHERE SecCode = 4907129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898780, ExchCode = 'DEU' WHERE SecCode = 4929498 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 = 236784380552, ExchCode = 'LAS' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914321191, ExchCode = 'MUN', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 4943410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936307256, ExchCode = 'MUN' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888705427, ExchCode = 'MUN' WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889560981, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4980098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212161, ExchCode = 'BIV' WHERE SecCode = 4980103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894951764, ExchCode = 'DUS' WHERE SecCode = 4991558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580276, ExchCode = 'FRA' WHERE SecCode = 4991678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727202566, ExchCode = 'BIV' WHERE SecCode = 4991681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100451, ExchCode = 'QTX' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072401492, ExchCode = 'DEU' WHERE SecCode = 5009346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980198448, ExchCode = 'FRA' WHERE SecCode = 5011657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387447, ExchCode = 'LAS' WHERE SecCode = 5011663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907308927, ExchCode = 'DUS' WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823918, ExchCode = 'AQX' WHERE SecCode = 5038692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976743, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5042969 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5045206 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 5052443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777507074, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-08' WHERE SecCode = 5063516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902573195, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 5067269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872147438, ExchCode = 'MXQ' WHERE SecCode = 5067670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903664236, ExchCode = 'FRA' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076711, ExchCode = 'LAS' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663662, ExchCode = 'DEU' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380635, ExchCode = 'LAS' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910179774, ExchCode = 'QTX' WHERE SecCode = 5094355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718186332, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5099028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816912714, ExchCode = 'FRA', PermQuoteRetireDate = '2023-01-12', PermSecMapEndDate = '2023-01-12' WHERE SecCode = 5112411 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5112423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910867434, ExchCode = 'STU' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910877570, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913514545, ExchCode = 'DEU' WHERE SecCode = 5130678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912123776, ExchCode = 'DEU' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520648, ExchCode = 'DEU' WHERE SecCode = 5151167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919459011, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633621506, Ticker = '0M1K', ExchCode = 'LSE' WHERE SecCode = 5161267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348309, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367923, ExchCode = 'BEC' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727360441, ExchCode = 'BIV' WHERE SecCode = 5161415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836515912, Ticker = 'SQT', ExchCode = 'FRA', PermQuoteRetireDate = '2016-10-11' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173437, ExchCode = 'MEX' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947744427, ExchCode = 'STU', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 5182664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932177240, ExchCode = 'MUN' WHERE SecCode = 5183106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397388, ExchCode = 'GTX' WHERE SecCode = 5189106 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5195338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421566, PermQuoteStatus = 'AC', Ticker = '3SZNm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5195447 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5197418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22093287267, Ticker = 'ALINKa', ExchCode = 'BCO' WHERE SecCode = 5206286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836113, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5208067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937069015, ExchCode = 'STU' WHERE SecCode = 5272089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851306, ExchCode = 'LAS' WHERE SecCode = 5281346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107112, ExchCode = 'BIV' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943067733, ExchCode = 'FRA' WHERE SecCode = 5301896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397462, ExchCode = 'BTE' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791510353, ExchCode = 'MUN' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633707, ExchCode = 'DEU' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874420, ExchCode = 'GTX' WHERE SecCode = 5374941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803603455, ExchCode = 'TDG' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5380636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534615, ExchCode = 'QTX' WHERE SecCode = 5383599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791798850, ExchCode = 'LAS' WHERE SecCode = 5457243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778299981, ExchCode = 'FRA' WHERE SecCode = 5468679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585123, ExchCode = 'MEX' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893349, ExchCode = 'TDG' WHERE SecCode = 5493665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704565734, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898176, PermQuoteStatus = 'AC', Ticker = '3LUBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 5526338 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 5526339 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 5526340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110956, Ticker = 'SFTGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110937, Ticker = '3SFTm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152999678, Ticker = 'NGLSl', ExchCode = 'AQX' WHERE SecCode = 5584733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942898, ExchCode = 'MEX' WHERE SecCode = 5631516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078274, ExchCode = 'LAS' WHERE SecCode = 5636960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966434, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-12' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22065452994, ExchCode = 'BRN' WHERE SecCode = 5645885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22025806033, ExchCode = 'DEU' WHERE SecCode = 5710467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028649127, ExchCode = 'DEU' WHERE SecCode = 5722406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22034763502, ExchCode = 'DEU' WHERE SecCode = 5764130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608791, ExchCode = 'BIV' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784107272, ExchCode = 'FRA' WHERE SecCode = 5817022 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-14' WHERE SecCode = 5819566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784418929, ExchCode = 'GTX' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551903, ExchCode = 'TDG' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '92T0' WHERE SecCode = 5836010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596707, ExchCode = 'FRA' WHERE SecCode = 5839460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596711, ExchCode = 'FRA' WHERE SecCode = 5839461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596713, ExchCode = 'FRA' WHERE SecCode = 5839464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596706, ExchCode = 'FRA' WHERE SecCode = 5839466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596709, ExchCode = 'FRA' WHERE SecCode = 5839467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785978750, ExchCode = 'STU' WHERE SecCode = 5907872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784888214, ExchCode = 'BIV' WHERE SecCode = 5907884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799223625, ExchCode = 'TQE' WHERE SecCode = 5959461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788207224, ExchCode = 'FRA' WHERE SecCode = 6010807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788245572, ExchCode = 'DUS' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788640939, ExchCode = 'FRA' WHERE SecCode = 6035234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587649, ExchCode = 'FRA' WHERE SecCode = 6075918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587648, ExchCode = 'FRA' WHERE SecCode = 6075919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945886900, ExchCode = 'GTX' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835874, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663690, ExchCode = 'AQX' WHERE SecCode = 6097325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22017341387, ExchCode = 'STU' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 6097353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836167, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823825, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329758, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 6097431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689580, ExchCode = 'BTE' WHERE SecCode = 6097546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22026330416, ExchCode = 'MXQ' WHERE SecCode = 6097558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790713136, ExchCode = 'FRA' WHERE SecCode = 6151862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790713137, ExchCode = 'FRA' WHERE SecCode = 6151863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791248887, ExchCode = 'STU' WHERE SecCode = 6190705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792942788, ExchCode = 'LAS' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838441, ExchCode = 'STU' WHERE SecCode = 6232187 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 = 22133181713, Ticker = 'BTCE', ExchCode = 'SWX' WHERE SecCode = 6245909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580180, ExchCode = 'DEU' WHERE SecCode = 6256405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181395, ExchCode = 'MEX' WHERE SecCode = 6256406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22150315636, ExchCode = 'DEU' WHERE SecCode = 6256407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734886875, PermQuoteStatus = 'AC', Ticker = '4E4', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745957943, PermQuoteStatus = 'AC', Ticker = '0BF0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909392, PermQuoteStatus = 'AC', Ticker = '2IU1', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6256420 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 = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787704640, ExchCode = 'MEX' WHERE SecCode = 6315107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787788319, ExchCode = 'MEX' WHERE SecCode = 6321016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793448738, ExchCode = 'FRA' WHERE SecCode = 6341809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887551041, ExchCode = 'MUN' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866542, ExchCode = 'BIV' WHERE SecCode = 6375353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22120375079, ExchCode = 'DEU' WHERE SecCode = 6396772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794459345, ExchCode = 'FRA' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122679002, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-03-26', PermSecMapEndDate = NULL WHERE SecCode = 6416433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795182771, ExchCode = 'FRA' WHERE SecCode = 6441867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795294192, ExchCode = 'FRA' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451414, ExchCode = 'BTE' WHERE SecCode = 6456368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157927, ExchCode = 'BTE' WHERE SecCode = 6456369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152233865, ExchCode = 'AQX' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157937, ExchCode = 'BTE' WHERE SecCode = 6456372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141703185, ExchCode = 'BTE' WHERE SecCode = 6456373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451415, ExchCode = 'BTE' WHERE SecCode = 6456374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141447615, ExchCode = 'BTE' WHERE SecCode = 6456375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157950, ExchCode = 'BTE' WHERE SecCode = 6456376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451405, ExchCode = 'BTE' WHERE SecCode = 6456377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109805, ExchCode = 'DUS' WHERE SecCode = 6501107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938208, ExchCode = 'FRA' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938213, ExchCode = 'FRA' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938212, ExchCode = 'FRA' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938214, ExchCode = 'FRA' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798105812, ExchCode = 'QTX' WHERE SecCode = 6520702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746059, ExchCode = 'DUS' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462190, ExchCode = 'GTX' WHERE SecCode = 6541041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798948296, ExchCode = 'FRA' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238834, ExchCode = 'QTX' WHERE SecCode = 6587160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238832, ExchCode = 'QTX' WHERE SecCode = 6587161 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '0AG0' WHERE SecCode = 6593890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903777191, ExchCode = 'HAN' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800268422, ExchCode = 'TDG' WHERE SecCode = 6626384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '6Y0' WHERE SecCode = 6684033 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6702431 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 6715935 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 6721482 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 6724482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169205257, ExchCode = 'TDG' WHERE SecCode = 6727919 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 6731959 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6737921 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6737933 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6737976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804823846, IsPrimaryQuote = 1, Ticker = 'GENO', ExchCode = 'OSL' WHERE SecCode = 6741012 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6741037 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5078528829, PriInstrPermID = 8590936747.0, DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 4294951349.0, PermOrgIPODate = NULL WHERE SecCode = 10902425 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 10925215 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 10999173 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11004566 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11133709 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 11142971 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 11145834 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 11149433 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000043933, PriInstrPermID = 8591362195.0, PriTRBCIndPermID = NULL WHERE SecCode = 11157785 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11188500 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11198280 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-26', PermSecMapEndDate = '2026-03-26' WHERE SecCode = 11215481 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11218234 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11227993 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'PTRVF' WHERE SecCode = 11228019 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11243792 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'KRNUF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-03-27', PermSecMapEndDate = NULL WHERE SecCode = 11245966 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11252862 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11252863 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727159260, PermQuoteStatus = 'AC', Ticker = 'DTCKF', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11257345 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11274307 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11275975 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11276615 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11277711 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11278379 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11278380 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11278442 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11279226 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11279227 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11279603 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11279908 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11285889 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11285893 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11285954 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11285959 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11285969 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-03-27' WHERE SecCode = 11285976 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232904895855.0 WHERE SecCode = 11291562 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232918015194.0 WHERE SecCode = 11292078 AND Type_ = 1;
