UPDATE data_universe_permid SET QuotePermID = 55838296539, Ticker = 'AAT.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 13 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475530971, ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 24 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531116153, Ticker = 'ABTl', ExchCode = 'BCO', PermQuoteRetireDate = '2017-02-01' WHERE SecCode = 31 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836050580, Ticker = 'IBM', ExchCode = 'LSE', PermQuoteRetireDate = '2024-11-06' WHERE SecCode = 479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474988450, PermQuoteStatus = 'AC', Ticker = '0M6S', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475869392, Ticker = 'HNDA.GB', ExchCode = 'ISD' WHERE SecCode = 6240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836052858, PermQuoteStatus = 'AC', Ticker = 'HKLB', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 6257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515262838, Ticker = 'H78', ExchCode = 'LSE', PermQuoteRetireDate = '2015-06-22' WHERE SecCode = 6260 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-15' WHERE SecCode = 18762 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475732246, Ticker = 'SKM.I', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 27054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842591690, Ticker = '0HKPl', ExchCode = 'BCO' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-14' WHERE SecCode = 30236 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 30546 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667704656, Ticker = 'ELEKTRA*', ExchCode = 'MXQ' WHERE SecCode = 31370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848820360, Ticker = NULL, PermQuoteRetireDate = '2018-01-12' WHERE SecCode = 34184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809063920, ExchCode = 'QTX' WHERE SecCode = 34314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803962980, ExchCode = 'STU' WHERE SecCode = 34813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781701954, ExchCode = 'TDG' WHERE SecCode = 35450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851139058, ExchCode = 'TDG' WHERE SecCode = 38188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489858, ExchCode = 'QTX', PermQuoteRetireDate = '2025-07-22' WHERE SecCode = 38789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475750408, ExchCode = 'MUN', PermQuoteRetireDate = '2004-05-28' WHERE SecCode = 42183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475522580, Ticker = 'IAW_I.TQ', ExchCode = 'TRQ', PermQuoteRetireDate = '2008-08-21' WHERE SecCode = 42203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451768, Ticker = 'INTC', ExchCode = 'SWX' WHERE SecCode = 42255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568941339, ExchCode = 'CHI' WHERE SecCode = 42265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607257, Ticker = 'IP', ExchCode = 'SWX' WHERE SecCode = 42269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607177, ExchCode = 'SWX' WHERE SecCode = 42327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774922528, Ticker = 'MMMz', ExchCode = 'BCO' WHERE SecCode = 42437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835548325, ExchCode = 'SWX' WHERE SecCode = 42470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784382742, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-16' WHERE SecCode = 43244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799043649, ExchCode = 'LAS' WHERE SecCode = 43249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790876722, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2021-03-23', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 43257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856248871, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2021-08-02' WHERE SecCode = 43267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302399, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 43282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475625258, Ticker = 'SRDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 43427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777584291, ExchCode = 'STU' WHERE SecCode = 43705 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 55836486581.0 WHERE SecCode = 45307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475081838, Ticker = 'RKKK', ExchCode = 'XIM', PermQuoteRetireDate = '2013-12-14' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838403118, ExchCode = 'STU' WHERE SecCode = 45854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474913868, Ticker = 'MACO', ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838240996, ExchCode = 'MUN' WHERE SecCode = 46009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858236052, Ticker = 'SCX', ExchCode = 'BER', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475289897, ExchCode = 'GER' WHERE SecCode = 46302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272806, ExchCode = 'GTX' WHERE SecCode = 53240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836460989, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 53704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383493, ExchCode = 'FRA' WHERE SecCode = 54647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803902479, ExchCode = 'TDG' WHERE SecCode = 54866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836518711, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294174, ExchCode = 'GTX' WHERE SecCode = 60424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324575, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 60499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475846941, ExchCode = 'DEU' WHERE SecCode = 60596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526399804, ExchCode = 'FRA' WHERE SecCode = 60669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841619543, ExchCode = 'GER' WHERE SecCode = 60778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549131651, ExchCode = 'GER', PermQuoteRetireDate = '2014-11-20' WHERE SecCode = 61188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838349451, ExchCode = 'STU' WHERE SecCode = 61517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838237693, ExchCode = 'MUN' WHERE SecCode = 61992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957419, ExchCode = 'DUS' WHERE SecCode = 62000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519199, ExchCode = 'DUS' WHERE SecCode = 62006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867727417, PermQuoteRetireDate = '2025-03-04' WHERE SecCode = 62125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475625197, Ticker = 'MOAG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 62660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035786, ExchCode = 'TDG', PermQuoteRetireDate = '2011-05-04' WHERE SecCode = 62666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475607361, PermQuoteStatus = 'DC', Ticker = 'UTHG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 62708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809578582, Ticker = 'OLLd', ExchCode = 'BCO' WHERE SecCode = 63014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273151, ExchCode = 'GTX' WHERE SecCode = 63055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531119240, Ticker = 'BRW1d', ExchCode = 'BCO', PermQuoteRetireDate = '2018-01-22' WHERE SecCode = 63058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475428779, ExchCode = 'STU' WHERE SecCode = 63096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823259770, ExchCode = 'DUS' WHERE SecCode = 63101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21499629939, Ticker = 'UNM', ExchCode = 'TDG', PermQuoteRetireDate = '2013-09-05' WHERE SecCode = 63112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475549907, ExchCode = 'STU', PermQuoteRetireDate = '2007-07-23' WHERE SecCode = 63119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223759, ExchCode = 'QTX' WHERE SecCode = 63625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503798483, ExchCode = 'DEU' WHERE SecCode = 63693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475583420, ExchCode = 'GER', PermQuoteRetireDate = '2008-07-07' WHERE SecCode = 65172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804396054, ExchCode = 'FRA' WHERE SecCode = 65372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709020879, ExchCode = 'FRA' WHERE SecCode = 66191 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365420.0 WHERE SecCode = 68527 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-17' WHERE SecCode = 74991 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-14' WHERE SecCode = 76701 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365420.0 WHERE SecCode = 84546 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = NULL WHERE SecCode = 86002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824100195, ExchCode = 'DUS' WHERE SecCode = 104360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784382991, ExchCode = 'LAS' WHERE SecCode = 104387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484409, ExchCode = 'QTX' WHERE SecCode = 112018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490159931, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 112522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769528, ExchCode = 'FRA' WHERE SecCode = 112541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236812998508, ExchCode = 'FRA' WHERE SecCode = 112667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945236187, ExchCode = 'FRA' WHERE SecCode = 113361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21495337454, ExchCode = 'STU' WHERE SecCode = 113424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560429291, ExchCode = 'FRA' WHERE SecCode = 114573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504014530, ExchCode = 'BER' WHERE SecCode = 114612 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853086158, ExchCode = 'FRA' WHERE SecCode = 114613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332491, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 124677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858110476, InstrPermID = 8589943435, OrgPermID = 4295873246, ValQuotePermID = 55858110476.0, PriInstrPermID = 8589943435.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'ABBOTINDIA', ExchCode = 'NSI', PermQuoteRetireDate = NULL, PermOrgIPODate = '1994-11-03', PermSecMapStartDate = '1995-11-20', PermSecMapEndDate = NULL WHERE SecCode = 126825 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 131132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885457496, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 131497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529040359, ExchCode = 'STU' WHERE SecCode = 132188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620915753, ExchCode = 'TDG' WHERE SecCode = 137720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521224187, ExchCode = 'STU' WHERE SecCode = 137791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842886562, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 137794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474882287, ExchCode = 'DEU', PermQuoteRetireDate = '2021-04-20' WHERE SecCode = 137873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556645874, ExchCode = 'BER', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 138995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804826539, ExchCode = 'FRA' WHERE SecCode = 141918 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-15' WHERE SecCode = 142426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490084, ExchCode = 'QTX' WHERE SecCode = 153410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784046619, ExchCode = 'STU' WHERE SecCode = 161948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803110069, ExchCode = 'FRA' WHERE SecCode = 164792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798580195, ExchCode = 'GTX' WHERE SecCode = 174506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608278652, ExchCode = 'STU' WHERE SecCode = 177445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21600289198, ExchCode = 'STU' WHERE SecCode = 177459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953597653, ExchCode = 'DUS' WHERE SecCode = 177460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684961126, ExchCode = 'FRA' WHERE SecCode = 177465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515832311, PermQuoteStatus = 'AC', ExchCode = 'HAN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738226557, ExchCode = 'STU', PermQuoteRetireDate = '2023-02-21' WHERE SecCode = 177474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786355600, ExchCode = 'QTX' WHERE SecCode = 177477 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 177991 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365420.0 WHERE SecCode = 178600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21990443457, ExchCode = 'BCO' WHERE SecCode = 178972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535118681, ExchCode = 'DEU' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 180086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836450778, ExchCode = 'FRA' WHERE SecCode = 187839 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 202287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634652662, ExchCode = 'MUN', PermQuoteRetireDate = '2020-12-23' WHERE SecCode = 208000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786572592, Ticker = 'HENI', ExchCode = 'VIE' WHERE SecCode = 241262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474844752, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 249377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929161390, ExchCode = 'MUN' WHERE SecCode = 249380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804826538, ExchCode = 'FRA' WHERE SecCode = 291229 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 295475 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21539411525, ExchCode = 'STU' WHERE SecCode = 297377 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 300815 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21695367977, ExchCode = 'STU' WHERE SecCode = 313533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525845979, ExchCode = 'STU' WHERE SecCode = 313561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792255713, ExchCode = 'TDG' WHERE SecCode = 332777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548651799, ExchCode = 'BEC' WHERE SecCode = 340247 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 55836486581.0 WHERE SecCode = 341249 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 551344 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522213543, ExchCode = 'STU' WHERE SecCode = 552003 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 557043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856428988, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 564417 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 568065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521102286, ExchCode = 'STU' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808392960, Ticker = 'XBLCm', ExchCode = 'BTE' WHERE SecCode = 737768 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 810401 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797836703, ExchCode = 'FRA' WHERE SecCode = 899770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883037235, ExchCode = 'MXQ' WHERE SecCode = 941913 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561940, ExchCode = 'TDG' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 1485705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502889367, ExchCode = 'STU', PermQuoteRetireDate = '2016-07-11' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483519165, ExchCode = 'STU' WHERE SecCode = 1545283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608184877, Ticker = 'ADIDAt', ExchCode = 'BCO' WHERE SecCode = 1607132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705266, ExchCode = 'MXQ' WHERE SecCode = 1929873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850059282, ExchCode = 'MUN' WHERE SecCode = 1929888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563717439, Ticker = 'NATTO', ExchCode = 'STO', PermQuoteRetireDate = '2018-09-26' WHERE SecCode = 1929967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21779912896, ExchCode = 'STU' WHERE SecCode = 2222037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612597102, ExchCode = 'TRQ', PermQuoteRetireDate = '2019-11-18' WHERE SecCode = 2300959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670892655, ExchCode = 'QTX' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530485265, ExchCode = 'DEU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534032284, ExchCode = 'DEU', PermQuoteRetireDate = '2018-11-30' WHERE SecCode = 2445257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443169, ExchCode = 'TDG', PermQuoteRetireDate = '2020-04-15' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537162833, ExchCode = 'FRA' WHERE SecCode = 2497940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705830, ExchCode = 'MXQ' WHERE SecCode = 2502360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576569001, ExchCode = 'STU' WHERE SecCode = 2503641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675150, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 2508168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543091461, ExchCode = 'BTE' WHERE SecCode = 2530826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542941379, ExchCode = 'BER', PermQuoteRetireDate = '2015-07-27' WHERE SecCode = 2579431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543673753, ExchCode = 'MUN' WHERE SecCode = 2584739 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2593531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678573, ExchCode = 'BIV' WHERE SecCode = 2644180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236810637935, ExchCode = 'FRA' WHERE SecCode = 2648321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673698, ExchCode = 'BIV' WHERE SecCode = 2682301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604748574, ExchCode = 'MEX' WHERE SecCode = 2715222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915374305, ExchCode = 'FRA' WHERE SecCode = 2724348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556645802, PermQuoteStatus = 'DC', Ticker = 'A71', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2796968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557245542, ExchCode = 'STU' WHERE SecCode = 2809752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803135586, ExchCode = 'FRA' WHERE SecCode = 2887314 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 2924553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566935898, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2930544 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 55836486581.0 WHERE SecCode = 3155134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22202786243, ExchCode = 'BTE' WHERE SecCode = 3198703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3276032 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3283798 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'SWE' WHERE SecCode = 3303273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22057914115, ExchCode = 'DEU' WHERE SecCode = 3315780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662322267, ExchCode = 'MUN' WHERE SecCode = 3337222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615255056, PermQuoteStatus = 'AC', Ticker = 'J5B0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3359146 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 PermOrgIPODate = NULL WHERE SecCode = 3378469 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3386780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872586460, ExchCode = 'DEU' WHERE SecCode = 3395311 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 3396703 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'SWE' WHERE SecCode = 3401777 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'SWE' WHERE SecCode = 3405343 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-16' WHERE SecCode = 3432015 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772839683, ExchCode = 'FRA' WHERE SecCode = 3436708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705514, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-04' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555698, ExchCode = 'FRA' WHERE SecCode = 3507596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359772, ExchCode = 'STU' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 3540531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784374485, ExchCode = 'MUN' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679944, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3566723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658213704, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-03', PermSecMapEndDate = NULL WHERE SecCode = 3566804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663197987, ExchCode = 'BIV' WHERE SecCode = 3605796 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3610783 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3629680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469691, ExchCode = 'DEU' WHERE SecCode = 3648237 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3661153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673827389, ExchCode = 'MEX' WHERE SecCode = 3717229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179537372, ExchCode = 'DEU' WHERE SecCode = 3739134 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365420.0 WHERE SecCode = 3761029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727370350, ExchCode = 'MEX' WHERE SecCode = 3862213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699218063, ExchCode = 'FRA' WHERE SecCode = 3862230 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'SWE' WHERE SecCode = 3862254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727376590, ExchCode = 'BIV' WHERE SecCode = 3886856 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 3941017 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3968091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731261056, Ticker = '0A2Zl', ExchCode = 'BCO' WHERE SecCode = 3986787 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'SWE' WHERE SecCode = 3993841 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3998244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013738, Ticker = '2WMT' WHERE SecCode = 4031748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791001594, Ticker = '1OMV', ExchCode = 'MIL' WHERE SecCode = 4031755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791001525, Ticker = '1RRTL', ExchCode = 'MIL' WHERE SecCode = 4031758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011959, Ticker = '2DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011005, Ticker = '2DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999014017, Ticker = '2WBDA' WHERE SecCode = 4031843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009630, Ticker = '2DUE' WHERE SecCode = 4031852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801047178, Ticker = '2FRVIA', ExchCode = 'MIL' WHERE SecCode = 4031858 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 55836486581.0 WHERE SecCode = 4031972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026822, Ticker = '1REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026833, Ticker = '1RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808928220, Ticker = '1RDCm', ExchCode = 'BCO' WHERE SecCode = 4031987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026942, Ticker = '1SHA', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4031994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026759, Ticker = '1DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737966407, ExchCode = 'STU' WHERE SecCode = 4119578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746425611, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4134386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298554, ExchCode = 'DEU' WHERE SecCode = 4134450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520230, ExchCode = 'QTX', PermQuoteRetireDate = '2024-10-03' WHERE SecCode = 4134496 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 4153236 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4231627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751449553, ExchCode = 'DEU' WHERE SecCode = 4237792 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 4245391 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4254671 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 4262434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663622, ExchCode = 'AQX' WHERE SecCode = 4296947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931482979, ExchCode = 'MUN' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365420.0 WHERE SecCode = 4366353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21779579416, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4402246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307339, ExchCode = 'MEX' WHERE SecCode = 4415716 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 = 25727303010, ExchCode = 'BIV' WHERE SecCode = 4433916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784909623, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-19' WHERE SecCode = 4433918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784912245, ExchCode = 'FRA' WHERE SecCode = 4434248 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 4437167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817581, ExchCode = 'FRA' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727292336, ExchCode = 'MEX' WHERE SecCode = 4487633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807449504, ExchCode = 'BCO', PermQuoteRetireDate = '2023-08-18' WHERE SecCode = 4536428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807449499, ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-20' WHERE SecCode = 4536433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512158, PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 4536443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800450259, ExchCode = 'FRA' WHERE SecCode = 4537791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763723985, ExchCode = 'MUN', PermQuoteRetireDate = '2024-02-22', PermSecMapEndDate = '2024-02-22' WHERE SecCode = 4570138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835753, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4579666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727264469, ExchCode = 'BIV' WHERE SecCode = 4585499 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4586595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727264473, ExchCode = 'MEX' WHERE SecCode = 4601841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805522537, ExchCode = 'FRA' WHERE SecCode = 4624222 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 4640279 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 4640280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726970, ExchCode = 'MUN' WHERE SecCode = 4655597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857140705, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4656762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727246903, ExchCode = 'BIV' WHERE SecCode = 4662851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835615671, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866356620, ExchCode = 'STU' WHERE SecCode = 4690000 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 = 21847342669, ExchCode = 'MUN' WHERE SecCode = 4730169 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-16' WHERE SecCode = 4761385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853931452, PermQuoteStatus = 'DC', Ticker = 'GSP', ExchCode = 'LSE', PermQuoteRetireDate = '2024-07-01', PermSecMapEndDate = '2024-07-01' WHERE SecCode = 4761540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859001450, ExchCode = 'BER', PermQuoteRetireDate = '2021-12-13', PermSecMapEndDate = '2021-12-13' WHERE SecCode = 4788710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172912433, ExchCode = 'SWX' WHERE SecCode = 4802290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861191374, Ticker = '3AIE', ExchCode = 'LSE' WHERE SecCode = 4807553 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 4818275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380529, ExchCode = 'LAS' WHERE SecCode = 4845047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781124629, ExchCode = 'STU' WHERE SecCode = 4936101 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = NULL WHERE SecCode = 4969540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888279764, ExchCode = 'MUN' WHERE SecCode = 4972276 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-15' WHERE SecCode = 4983978 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-15' WHERE SecCode = 4983992 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-15' WHERE SecCode = 5005711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22188010891, ExchCode = 'LAS' WHERE SecCode = 5152288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22202493535, Ticker = 'KOR3d', ExchCode = 'BCO' WHERE SecCode = 5152301 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365420.0 WHERE SecCode = 5174435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921901229, ExchCode = 'DEU' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-15' WHERE SecCode = 5188807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171884, ExchCode = 'MEX' WHERE SecCode = 5197417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171457, ExchCode = 'MEX' WHERE SecCode = 5209760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928854434, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5209798 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933395774, ExchCode = 'DEU' WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933396208, ExchCode = 'DEU' WHERE SecCode = 5253711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933396592, ExchCode = 'DEU' WHERE SecCode = 5253715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933396669, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5253716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933396231, ExchCode = 'DEU' WHERE SecCode = 5253717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787451122, ExchCode = 'FRA' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933669600, ExchCode = 'FRA' WHERE SecCode = 5256605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933670106, ExchCode = 'DEU' WHERE SecCode = 5256606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775732430, ExchCode = 'MEX' WHERE SecCode = 5308052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775782162, ExchCode = 'MEX' WHERE SecCode = 5308058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958776675, ExchCode = 'DEU', PermSecMapStartDate = '2026-09-14', PermSecMapEndDate = NULL WHERE SecCode = 5380631 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 5395771 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5440944 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 5455474 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5470929 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 5521904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21985339535, ExchCode = 'DEU', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 5525234 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 5563526 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 5569226 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 5569227 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 5579581 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 5579582 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-09-14' WHERE SecCode = 5600661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078273, ExchCode = 'LAS', PermQuoteRetireDate = '2025-08-29', PermSecMapEndDate = '2025-09-03' WHERE SecCode = 5668471 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-15' WHERE SecCode = 5717716 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 5772358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22111477357, ExchCode = 'TDG', PermSecMapEndDate = '2025-12-17' WHERE SecCode = 5785810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785844728, ExchCode = 'STU' WHERE SecCode = 5903170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786609283, ExchCode = 'FRA' WHERE SecCode = 5938646 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5974289 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6002018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795664148, ExchCode = 'MEX' WHERE SecCode = 6014420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788815806, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6041432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659466, ExchCode = 'LAS' WHERE SecCode = 6041433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789870076, ExchCode = 'HAN', PermQuoteRetireDate = '2025-01-31', PermSecMapEndDate = NULL WHERE SecCode = 6114320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121804339, ExchCode = 'STU' WHERE SecCode = 6217549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791666942, ExchCode = 'TDG' WHERE SecCode = 6222262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791699555, ExchCode = 'QTX' WHERE SecCode = 6222270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159093915, Ticker = 'ET32', ExchCode = 'SWX' WHERE SecCode = 6240413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133442749, Ticker = 'BTCE', ExchCode = 'SWX' WHERE SecCode = 6240416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792206094, ExchCode = 'QTX' WHERE SecCode = 6264277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159901582, ExchCode = 'LAS' WHERE SecCode = 6291969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783392421, ExchCode = 'MEX' WHERE SecCode = 6295346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122894403, ExchCode = 'DEU' WHERE SecCode = 6418487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794652101, ExchCode = 'DUS' WHERE SecCode = 6418488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799042091, ExchCode = 'FRA' WHERE SecCode = 6418489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142158040, ExchCode = 'CHI' WHERE SecCode = 6456376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797571630, ExchCode = 'BIV' WHERE SecCode = 6507152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22137456933, ExchCode = 'STU' WHERE SecCode = 6520811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798309550, ExchCode = 'STU' WHERE SecCode = 6533454 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 6546268 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 6552465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143582263, ExchCode = 'DEU' WHERE SecCode = 6578061 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-09-14', PermSecMapEndDate = NULL WHERE SecCode = 6583721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801670234, ExchCode = 'TDG' WHERE SecCode = 6608463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147802599, ExchCode = 'DEU' WHERE SecCode = 6608464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173814070, ExchCode = 'TDG' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802588880, ExchCode = 'FRA' WHERE SecCode = 6645675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22157763909, ExchCode = 'DEU' WHERE SecCode = 6645687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803400605, ExchCode = 'MUN' WHERE SecCode = 6664707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798269903, ExchCode = 'BIV' WHERE SecCode = 6672554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803604762, ExchCode = 'FRA' WHERE SecCode = 6692050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803604763, ExchCode = 'FRA' WHERE SecCode = 6692051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803959215, ExchCode = 'GTX' WHERE SecCode = 6702489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804713488, ExchCode = 'MUN' WHERE SecCode = 6721527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168877362, ExchCode = 'DEU' WHERE SecCode = 6741050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236814548124, ExchCode = 'MUN' WHERE SecCode = 6741053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22202255570, ExchCode = 'GTX' WHERE SecCode = 6808925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176032128, ExchCode = 'DEU' WHERE SecCode = 6813309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176031969, ExchCode = 'DEU' WHERE SecCode = 6813310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802293285, ExchCode = 'BIV' WHERE SecCode = 6813378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22187918387, Ticker = 'EASDl', ExchCode = 'BCO' WHERE SecCode = 6813403 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 6820110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804912364, ExchCode = 'BIV' WHERE SecCode = 6832757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807273591, ExchCode = 'TDG' WHERE SecCode = 6854883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179531994, ExchCode = 'DEU' WHERE SecCode = 6854884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807105940, ExchCode = 'GTX' WHERE SecCode = 6854888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807109354, ExchCode = 'MEX' WHERE SecCode = 6862277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807882960, ExchCode = 'TDG' WHERE SecCode = 6880256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22182598106, ExchCode = 'DEU' WHERE SecCode = 6880260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809578556, Ticker = 'T9A0d', ExchCode = 'BCO' WHERE SecCode = 6880263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807668649, ExchCode = 'FRA' WHERE SecCode = 6882173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807668646, ExchCode = 'FRA' WHERE SecCode = 6882175 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 55836486581.0, PermQuoteRetireDate = '2026-09-16' WHERE SecCode = 6901947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808191721, ExchCode = 'HAM' WHERE SecCode = 6902193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22193020541, ExchCode = 'QTX' WHERE SecCode = 6930689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22188306890, ExchCode = 'DEU' WHERE SecCode = 6934884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22189193163, ExchCode = 'DEU' WHERE SecCode = 6941647 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6951855 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6951856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22191688614, ExchCode = 'DEU' WHERE SecCode = 6969119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809845566, ExchCode = 'MEX' WHERE SecCode = 6986009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809894414, ExchCode = 'FRA' WHERE SecCode = 6989284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236813041638, ExchCode = 'LAS' WHERE SecCode = 7000409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22195187223, ExchCode = 'DEU' WHERE SecCode = 7006676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236811204332, ExchCode = 'FRA' WHERE SecCode = 7014969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236811207401, ExchCode = 'FRA' WHERE SecCode = 7014971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236811732141, ExchCode = 'FRA' WHERE SecCode = 7025960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22200192746, ExchCode = 'DEU' WHERE SecCode = 7055262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22201226348, ExchCode = 'DEU' WHERE SecCode = 7064216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22202012044, ExchCode = 'DEU' WHERE SecCode = 7067766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22202012921, ExchCode = 'DEU' WHERE SecCode = 7067776 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-14' WHERE SecCode = 7075703 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-14' WHERE SecCode = 7080323 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-16' WHERE SecCode = 7081303 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-16' WHERE SecCode = 7088921 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-14' WHERE SecCode = 7088924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236814210239, ExchCode = 'FRA' WHERE SecCode = 7093138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803099509, ExchCode = 'MEX' WHERE SecCode = 7101284 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-09-15', PermSecMapEndDate = NULL WHERE SecCode = 10830315 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236814548115, PermQuoteStatus = 'AC', Ticker = 'ZIGUF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-09-15', PermSecMapEndDate = NULL WHERE SecCode = 10922871 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 10925336 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11019097 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11030426 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 11056198 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11059921 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11065371 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 11135097 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000370490, PriInstrPermID = 8589990137.0, PriTRBCIndPermID = 4294951688.0, PermOrgIPODate = NULL WHERE SecCode = 11146600 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 11158473 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11193719 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11226560 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11230023 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11285239 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11285365 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11289520 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11297552 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11297554 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11297555 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11297560 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11297561 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11297563 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11297565 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-15' WHERE SecCode = 11297567 AND Type_ = 1;