UPDATE data_universe_permid SET QuotePermID = 21475562090, Ticker = 'AAT.L', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 13 AND Type_ = 10;
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 = 21474988450, PermQuoteStatus = 'AC', Ticker = '0M6S', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 622 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 2180 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 7851 AND Type_ = 1;
UPDATE data_universe_permid SET ExchCode = 'NYS' WHERE SecCode = 10388 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 13251 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 31387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364027, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', PermSecMapEndDate = '2021-01-11' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481067, PermQuoteStatus = 'AC', Ticker = 'AEC1', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622059, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401342, Ticker = 'NTHd', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 35423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330930, ExchCode = 'BER', PermQuoteRetireDate = '2023-09-21' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469912, ExchCode = 'QTX' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034103, PermQuoteStatus = 'AC', Ticker = 'CPA', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 37361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035699, PermQuoteStatus = 'AC', Ticker = 'GOB', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 37392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518925174, PermQuoteStatus = 'AC', Ticker = 'DSE', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 38247 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-07' WHERE SecCode = 39205 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836329513, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 39906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475527566, Ticker = 'HRMJ.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 40538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837365697, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 40670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830300963, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 40706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624655, Ticker = 'HJHG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 40732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836496557, ExchCode = 'FRA' WHERE SecCode = 40805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475333517, ExchCode = 'FRA', PermQuoteRetireDate = '2006-12-18' WHERE SecCode = 40806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340086, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 40818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475194878, ExchCode = 'MUN', PermQuoteRetireDate = '2005-01-27' WHERE SecCode = 40933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954104507, ExchCode = 'DUS', PermQuoteRetireDate = '2025-07-14' WHERE SecCode = 41008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336872, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 41010 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 41106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837367615, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 41200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836506211, ExchCode = 'FRA', PermQuoteRetireDate = '2011-06-28' WHERE SecCode = 41201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475414999, ExchCode = 'FRA' WHERE SecCode = 41202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493104, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 41383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619418594, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 41416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716914, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 41442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475305331, ExchCode = 'BER' WHERE SecCode = 41457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475290163, ExchCode = 'MUN' WHERE SecCode = 41512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836481845, ExchCode = 'FRA', PermQuoteRetireDate = '2008-09-25' WHERE SecCode = 41583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478511787, PermQuoteStatus = 'AC', Ticker = 'PJXA', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 41715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475904141, PermQuoteStatus = 'AC', Ticker = 'KMRi', ExchCode = 'BTE', PermQuoteRetireDate = NULL WHERE SecCode = 41818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545350230, ExchCode = 'STU' WHERE SecCode = 42034 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475634703, Ticker = NULL, ExchCode = 'MUN', PermQuoteRetireDate = '2006-06-16' WHERE SecCode = 42056 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652953776, ExchCode = 'TDG', PermQuoteRetireDate = '2018-12-10' WHERE SecCode = 42067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331947, ExchCode = 'BER' WHERE SecCode = 42071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840303115, ExchCode = 'BER', PermQuoteRetireDate = '2004-05-31' WHERE SecCode = 42183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475423707, Ticker = 'AL', ExchCode = 'SWX', PermQuoteRetireDate = '2008-01-30' WHERE SecCode = 42230 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 = 21550451682, Ticker = 'CL', ExchCode = 'SWX' WHERE SecCode = 42322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177550, Ticker = 'RYz', ExchCode = 'TRQ', PermQuoteRetireDate = '2023-03-21' WHERE SecCode = 42490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535196997, Ticker = 'BAC', ExchCode = 'BRN' WHERE SecCode = 42536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836476715, ExchCode = 'FRA' WHERE SecCode = 43238 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 = 55853656282, ExchCode = 'FRA' WHERE SecCode = 43265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475188833, ExchCode = 'FRA', PermQuoteRetireDate = '2007-02-20' WHERE SecCode = 43351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835485961, Ticker = 'MRK', ExchCode = 'PAR', PermQuoteRetireDate = '2023-06-09' WHERE SecCode = 43401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308629, ExchCode = 'GTX' WHERE SecCode = 43512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323413, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 43574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836524782, ExchCode = 'FRA' WHERE SecCode = 43579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824525549, ExchCode = 'DUS' WHERE SecCode = 43583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853674552, ExchCode = 'FRA' WHERE SecCode = 43587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507376335, ExchCode = 'STU' WHERE SecCode = 43597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581385252, ExchCode = 'DEU' WHERE SecCode = 43705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769583, ExchCode = 'MUN' WHERE SecCode = 44050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520650353, ExchCode = 'MUN' WHERE SecCode = 44086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790722443, ExchCode = 'GER', PermQuoteRetireDate = '2021-03-23' WHERE SecCode = 44176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732784567, ExchCode = 'DEU' WHERE SecCode = 44254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533839980, ExchCode = 'FRA' WHERE SecCode = 44260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702459158, Ticker = 'CPZ1d', ExchCode = 'BCO' WHERE SecCode = 44270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312363, ExchCode = 'GTX' WHERE SecCode = 44292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931186423, ExchCode = 'GTX' WHERE SecCode = 44296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679669, ExchCode = 'DEU' WHERE SecCode = 44312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308538, ExchCode = 'GTX', PermQuoteRetireDate = '2025-07-14' WHERE SecCode = 44313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850934143, ExchCode = 'BER' WHERE SecCode = 44395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364010, ExchCode = 'GER' WHERE SecCode = 44612 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489580, ExchCode = 'QTX' WHERE SecCode = 45029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133161, PermQuoteStatus = 'AC', Ticker = 'PBCd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 45367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324683, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 45854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837354839, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 45916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328604, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 46907 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 50986 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485029, ExchCode = 'QTX' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475417281, ExchCode = 'GER' WHERE SecCode = 53474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475644098, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'BER', PermQuoteRetireDate = '2005-04-12' WHERE SecCode = 53479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556863860, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 53509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332265, ExchCode = 'BER', PermQuoteRetireDate = '2011-11-02' WHERE SecCode = 53520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469997, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 54192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838618066, ExchCode = 'STU' WHERE SecCode = 54198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475436120, ExchCode = 'DUS', PermQuoteRetireDate = '2009-01-28' WHERE SecCode = 54208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475298681, ExchCode = 'HAN', PermQuoteRetireDate = '2005-07-05' WHERE SecCode = 54276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339400, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 54337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836507338, ExchCode = 'FRA' WHERE SecCode = 54339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475608059, Ticker = 'AFFU.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 54367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329741, ExchCode = 'BER', PermQuoteRetireDate = '2017-12-29' WHERE SecCode = 54371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469666, ExchCode = 'QTX' WHERE SecCode = 54398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850209306, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 54422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327041, ExchCode = 'BER' WHERE SecCode = 54430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327216, Ticker = 'EFI', ExchCode = 'BER', PermQuoteRetireDate = '2019-07-25' WHERE SecCode = 54512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492463, ExchCode = 'QTX' WHERE SecCode = 54540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21918984188, Ticker = 'QH9d', ExchCode = 'TRQ' WHERE SecCode = 54545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837365015, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 54552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837357043, ExchCode = 'GER' WHERE SecCode = 54614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326707, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 54623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475733540, PermQuoteStatus = 'DC', Ticker = 'TEVG.I', ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23' WHERE SecCode = 54655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519095, ExchCode = 'DUS' WHERE SecCode = 54668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475443147, ExchCode = 'DUS', PermQuoteRetireDate = '2005-04-06' WHERE SecCode = 54708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493156, ExchCode = 'QTX' WHERE SecCode = 54728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475518407, PermQuoteStatus = 'DC', Ticker = 'BRMG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 54769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535566184, PermQuoteStatus = 'DC', Ticker = 'RTL', ExchCode = 'GER', PermQuoteRetireDate = '2015-02-10', PermSecMapEndDate = '2022-04-12' WHERE SecCode = 54776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475296943, ExchCode = 'MUN', PermQuoteRetireDate = '2005-07-15' WHERE SecCode = 54778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337571, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 54839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492709, ExchCode = 'QTX' WHERE SecCode = 54843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475606794, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 54890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326895, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 54931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475536670, PermQuoteStatus = 'DC', Ticker = 'PHMZ.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 54975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475588138, Ticker = 'VA.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 55003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475518546, ExchCode = 'DUS', PermQuoteRetireDate = '2010-03-31' WHERE SecCode = 55035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837354576, ExchCode = 'GER', PermQuoteRetireDate = '2010-05-03' WHERE SecCode = 55049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335628, ExchCode = 'BER' WHERE SecCode = 55083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337952, Ticker = 'PGS1', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-02' WHERE SecCode = 55086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475621697, Ticker = 'GTRG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 55089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475220407, ExchCode = 'DUS' WHERE SecCode = 55096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016573, ExchCode = 'TDG' WHERE SecCode = 55116 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042365, PermQuoteStatus = 'AC', Ticker = 'EAR', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 55118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016582, ExchCode = 'TDG' WHERE SecCode = 55121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836386260, ExchCode = 'FRA' WHERE SecCode = 55142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336761, ExchCode = 'BER' WHERE SecCode = 55144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475615558, ExchCode = 'HAN', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 55175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536548830, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2015-09-16' WHERE SecCode = 55201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475365146, ExchCode = 'STU' WHERE SecCode = 55205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475184515, ExchCode = 'MUN', PermQuoteRetireDate = '2006-03-17' WHERE SecCode = 55210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243655, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 55213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489887, ExchCode = 'QTX' WHERE SecCode = 55223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332421, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 55234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475183772, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2006-01-24' WHERE SecCode = 55248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487103, ExchCode = 'QTX' WHERE SecCode = 55252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842459836, ExchCode = 'HAN' WHERE SecCode = 55286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490899, PermQuoteStatus = 'AC', Ticker = 'SEBA', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 55351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475099703, PermQuoteStatus = 'DC', ExchCode = 'XIM', PermQuoteRetireDate = '2013-12-14' WHERE SecCode = 55385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475721792, Ticker = 'WHLJ.I', ExchCode = 'CHI' WHERE SecCode = 55420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475361037, Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 55446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688418764, ExchCode = 'QTX' WHERE SecCode = 55477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541776002, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 55495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323958, Ticker = 'BBP2', ExchCode = 'BER', PermQuoteRetireDate = '2018-10-11' WHERE SecCode = 55517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198259, PermQuoteStatus = 'AC', ExchCode = 'GER', PermQuoteRetireDate = NULL WHERE SecCode = 55560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399276, ExchCode = 'FRA', PermQuoteRetireDate = '2011-01-21' WHERE SecCode = 55562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475179124, ExchCode = 'STU' WHERE SecCode = 55564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837362222, ExchCode = 'GER' WHERE SecCode = 55574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547153457, Ticker = 'SCA', ExchCode = 'GER', PermQuoteRetireDate = '2018-04-23' WHERE SecCode = 55577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293718, ExchCode = 'GTX' WHERE SecCode = 55581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491972, ExchCode = 'QTX' WHERE SecCode = 55585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518925209, PermQuoteStatus = 'AC', Ticker = '0WP', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 55589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475556011, PermQuoteStatus = 'DC', Ticker = 'AKUG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 55592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836433997, ExchCode = 'FRA' WHERE SecCode = 55627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293996, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 55631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484095, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 55656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572141349, ExchCode = 'HAM' WHERE SecCode = 55657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624639, PermQuoteStatus = 'DC', Ticker = 'HCLG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 55666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501625448, ExchCode = 'TDG' WHERE SecCode = 55696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522214476, ExchCode = 'MUN' WHERE SecCode = 55702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475446640, ExchCode = 'STU' WHERE SecCode = 55704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835793530, Ticker = 'VIP', ExchCode = 'DUS', PermQuoteRetireDate = '2010-05-14' WHERE SecCode = 55706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475520530, Ticker = 'ALL', ExchCode = 'PAR', PermQuoteRetireDate = '2010-04-03' WHERE SecCode = 55714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475372173, ExchCode = 'STU', PermQuoteRetireDate = '2005-06-07' WHERE SecCode = 55716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338231, ExchCode = 'BER', PermQuoteRetireDate = '2013-09-19' WHERE SecCode = 55762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837361015, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 55770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819929980, ExchCode = 'DUS' WHERE SecCode = 55948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475214243, ExchCode = 'STU' WHERE SecCode = 56044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835779680, ExchCode = 'DUS', PermQuoteRetireDate = '2011-04-12' WHERE SecCode = 56163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632625982, ExchCode = 'TDG' WHERE SecCode = 56216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484207, Ticker = 'E65F', ExchCode = 'QTX', PermQuoteRetireDate = '2020-08-24' WHERE SecCode = 56224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339609, ExchCode = 'BER', PermQuoteRetireDate = '2012-12-14' WHERE SecCode = 56247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835791722, ExchCode = 'DUS' WHERE SecCode = 56256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838237210, ExchCode = 'MUN', PermQuoteRetireDate = '2008-10-06' WHERE SecCode = 56393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327898, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 56454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520168469, ExchCode = 'STU' WHERE SecCode = 56520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475435128, ExchCode = 'GER', PermQuoteRetireDate = '2008-10-07' WHERE SecCode = 56524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474874382, ExchCode = 'DEU' WHERE SecCode = 56529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475531699, PermQuoteStatus = 'DC', Ticker = 'HDIG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 56533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590786433, ExchCode = 'TDG' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589825, PermQuoteStatus = 'DC', Ticker = 'CHKG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 56683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323329, Ticker = 'AVD', ExchCode = 'BER', PermQuoteRetireDate = '2014-04-09' WHERE SecCode = 56739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490208, ExchCode = 'QTX' WHERE SecCode = 56803 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CLGUN' WHERE SecCode = 56811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475623994, PermQuoteStatus = 'DC', Ticker = 'TFBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 56835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835777403, Ticker = 'ADU1', ExchCode = 'DUS', PermQuoteRetireDate = '2010-12-13' WHERE SecCode = 56894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475612012, Ticker = 'AXPG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 56929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597039967, ExchCode = 'TDG' WHERE SecCode = 56982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288234, ExchCode = 'DEU' WHERE SecCode = 56992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475364844, ExchCode = 'MUN', PermQuoteRetireDate = '2005-12-07' WHERE SecCode = 57063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475815371, ExchCode = 'STU' WHERE SecCode = 57072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850729381, ExchCode = 'FRA', PermQuoteRetireDate = '2013-06-11' WHERE SecCode = 57073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675100776, Ticker = '1S4', ExchCode = 'TDG', PermQuoteRetireDate = '2019-03-29' WHERE SecCode = 57098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475211478, ExchCode = 'STU', PermQuoteRetireDate = '2007-02-01' WHERE SecCode = 57541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475345690, ExchCode = 'MUN' WHERE SecCode = 57571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475516549, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 57597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475287509, ExchCode = 'HAM', PermQuoteRetireDate = '2007-09-28' WHERE SecCode = 57608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474881490, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2016-04-27', PermSecMapEndDate = '2017-04-12' WHERE SecCode = 57612 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519177, ExchCode = 'DUS' WHERE SecCode = 57651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835934, Ticker = 'STFd', ExchCode = 'BCO' WHERE SecCode = 57832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475416610, ExchCode = 'STU', PermQuoteRetireDate = '2009-04-20' WHERE SecCode = 57840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478786, ExchCode = 'QTX' WHERE SecCode = 57846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325590, ExchCode = 'BER' WHERE SecCode = 57850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560955141, PermQuoteStatus = 'AC', Ticker = 'CUW', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 57884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492759, ExchCode = 'QTX' WHERE SecCode = 58052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331754, ExchCode = 'BER' WHERE SecCode = 58062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481759, ExchCode = 'QTX' WHERE SecCode = 58160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474860403, ExchCode = 'DEU' WHERE SecCode = 58245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836401122, ExchCode = 'FRA', PermQuoteRetireDate = '2010-08-02' WHERE SecCode = 58485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475142048, ExchCode = 'FRA' WHERE SecCode = 58503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475292809, ExchCode = 'STU', PermQuoteRetireDate = '2005-08-11' WHERE SecCode = 58545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475315089, ExchCode = 'FRA', PermQuoteRetireDate = '2007-08-13' WHERE SecCode = 58554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336738, ExchCode = 'BER', PermQuoteRetireDate = '2012-05-11' WHERE SecCode = 58558 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NOR' WHERE SecCode = 58710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747575653, ExchCode = 'QTX' WHERE SecCode = 58729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474869771, ExchCode = 'DEU' WHERE SecCode = 58734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324124, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 58756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644529466, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-08', PermSecMapEndDate = '2024-01-09' WHERE SecCode = 58804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297844, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 58930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836421596, ExchCode = 'FRA', PermQuoteRetireDate = '2009-10-27' WHERE SecCode = 59024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842911827, ExchCode = 'FRA' WHERE SecCode = 59028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475571185, PermQuoteStatus = 'DC', Ticker = 'SNWF.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 59041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556336620, ExchCode = 'TDG' WHERE SecCode = 59096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838797952, Ticker = 'ASD', ExchCode = 'OSL', PermQuoteRetireDate = '2011-11-22' WHERE SecCode = 59115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492659, PermQuoteStatus = 'AC', Ticker = 'VAN', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 59249 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CLGUN' WHERE SecCode = 59405 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667493138, ExchCode = 'QTX' WHERE SecCode = 59466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557034371, ExchCode = 'STU' WHERE SecCode = 59618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809757591, ExchCode = 'STU' WHERE SecCode = 59806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585187543, ExchCode = 'HAM' WHERE SecCode = 59853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475317849, ExchCode = 'MUN' WHERE SecCode = 59872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838238912, ExchCode = 'MUN' WHERE SecCode = 59881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475436174, ExchCode = 'GER' WHERE SecCode = 59906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607379214, ExchCode = 'TDG' WHERE SecCode = 59920 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613489654, ExchCode = 'TDG', PermQuoteRetireDate = '2023-03-06' WHERE SecCode = 59963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399700, ExchCode = 'FRA', PermQuoteRetireDate = '2016-02-12' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474909293, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2017-12-29' WHERE SecCode = 60016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835784245, ExchCode = 'DUS' WHERE SecCode = 60025 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 = 21475457917, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2007-11-28' WHERE SecCode = 60090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401354, Ticker = 'IX1d', ExchCode = 'CHI', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 60267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337787, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475846941, ExchCode = 'DEU' WHERE SecCode = 60596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368040, ExchCode = 'STU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805161989, ExchCode = 'BTE' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485966, ExchCode = 'QTX' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474898042, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 61930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789211097, ExchCode = 'DEU' WHERE SecCode = 63138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338795, Ticker = 'NC91', ExchCode = 'BER', PermQuoteRetireDate = '2025-11-07' WHERE SecCode = 63145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572141335, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 63146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334154, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590303360, ExchCode = 'STU', PermQuoteRetireDate = '2016-10-19' WHERE SecCode = 63292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836502832, ExchCode = 'FRA', PermQuoteRetireDate = '2016-07-05' WHERE SecCode = 63293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836458730, ExchCode = 'FRA', PermQuoteRetireDate = '2009-01-06' WHERE SecCode = 63319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488243, ExchCode = 'QTX' WHERE SecCode = 63324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836424153, ExchCode = 'FRA', PermQuoteRetireDate = '2016-12-05' WHERE SecCode = 63332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475745545, ExchCode = 'HAN', PermQuoteRetireDate = '2010-02-17' WHERE SecCode = 63460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784383741, ExchCode = 'LAS' WHERE SecCode = 63567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532734310, ExchCode = 'TDG' WHERE SecCode = 63684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475446092, ExchCode = 'GER' WHERE SecCode = 63686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790407362, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2021-03-23' WHERE SecCode = 63693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592924041, ExchCode = 'HAM', PermQuoteRetireDate = '2019-08-12' WHERE SecCode = 63694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486483, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 63757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364071, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 63767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955953, ExchCode = 'TDG' WHERE SecCode = 63841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837366172, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 63854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323229, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386749, ExchCode = 'LAS' WHERE SecCode = 63882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460200, ExchCode = 'HAN' WHERE SecCode = 63905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475353323, ExchCode = 'MUN' WHERE SecCode = 63915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836509044, ExchCode = 'FRA', PermQuoteRetireDate = '2022-12-13', PermSecMapEndDate = '2022-12-13' WHERE SecCode = 63933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836393104, ExchCode = 'FRA' WHERE SecCode = 63936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782003465, PermQuoteStatus = 'DC', Ticker = 'VCT', ExchCode = 'STU', PermQuoteRetireDate = '2025-12-02' WHERE SecCode = 63954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488565, ExchCode = 'QTX' WHERE SecCode = 63957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835787177, Ticker = 'TRBA', ExchCode = 'DUS', PermQuoteRetireDate = '2024-05-02' WHERE SecCode = 63973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650239, ExchCode = 'DUS' WHERE SecCode = 63982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531119599, Ticker = 'BYTEy', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-14' WHERE SecCode = 63991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331246, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 63995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475613885, Ticker = 'QNMG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 64028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627587358, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-12' WHERE SecCode = 64049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553067798, ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-21' WHERE SecCode = 64078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461700, ExchCode = 'STU', PermQuoteRetireDate = '2019-12-06', PermSecMapEndDate = '2019-12-06' WHERE SecCode = 64093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329595, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 64125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474840407, ExchCode = 'DEU' WHERE SecCode = 64139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475287215, ExchCode = 'FRA', PermQuoteRetireDate = '2006-02-27' WHERE SecCode = 64165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334363, Ticker = 'GTJ1', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 64174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838610809, ExchCode = 'STU' WHERE SecCode = 64190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830488, ExchCode = 'DUS' WHERE SecCode = 64213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564887191, PermQuoteStatus = 'DC', Ticker = 'HEC', ExchCode = 'DEU', PermQuoteRetireDate = '2021-11-22', PermSecMapEndDate = '2025-07-16' WHERE SecCode = 64215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486274, ExchCode = 'QTX' WHERE SecCode = 64219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327845, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 64220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475190572, ExchCode = 'GER' WHERE SecCode = 64222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035195, ExchCode = 'TDG' WHERE SecCode = 64223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339459, ExchCode = 'BER', PermQuoteRetireDate = '2022-11-17', PermSecMapEndDate = '2022-11-17' WHERE SecCode = 64228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341568, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 64256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475225541, ExchCode = 'STU' WHERE SecCode = 64307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836523761, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 64314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836547832, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 64315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503066531, PermQuoteStatus = 'AC', Ticker = 'RPL', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 64330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660289186, PermQuoteStatus = 'AC', Ticker = 'AJ8', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 64365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841571827, ExchCode = 'FRA' WHERE SecCode = 64369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380523, ExchCode = 'LAS' WHERE SecCode = 64407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606777645, ExchCode = 'TDG' WHERE SecCode = 64422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388774, ExchCode = 'LAS' WHERE SecCode = 64431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328758, ExchCode = 'BER' WHERE SecCode = 64435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486299, PermQuoteStatus = 'DC', Ticker = 'HVP', ExchCode = 'QTX', PermQuoteRetireDate = '2021-08-04' WHERE SecCode = 64448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550079029, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 64496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519182, ExchCode = 'DUS' WHERE SecCode = 64503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836393944, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 64512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475084602, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 64524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289113, ExchCode = 'GTX' WHERE SecCode = 64536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326367, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 64654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475453223, ExchCode = 'BER' WHERE SecCode = 64659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339328, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 64671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836506216, Ticker = 'NAM1', ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 64713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475190317, ExchCode = 'GER', PermQuoteRetireDate = '2007-08-06' WHERE SecCode = 64721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871056052, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27', PermSecMapEndDate = NULL WHERE SecCode = 64727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331910, ExchCode = 'BER' WHERE SecCode = 64728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837360499, Ticker = 'VDY', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 64741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325839, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 64761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475183992, ExchCode = 'MUN', PermQuoteRetireDate = '2006-06-28' WHERE SecCode = 64789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335540, Ticker = 'SPJ', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 64845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853121910, PermQuoteStatus = 'DC', Ticker = 'EFO2', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 64863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475177822, ExchCode = 'MUN' WHERE SecCode = 64974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856802989, Ticker = 'MSF', ExchCode = 'BRU', PermQuoteRetireDate = '2023-10-02' WHERE SecCode = 65004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308464, PermQuoteStatus = 'AC', Ticker = 'SS9', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 65007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532810550, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-03-29' WHERE SecCode = 65011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475430349, ExchCode = 'STU' WHERE SecCode = 65024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308302, ExchCode = 'GTX' WHERE SecCode = 65025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531134288, Ticker = 'SHP5d', ExchCode = 'BCO', PermQuoteRetireDate = '2022-11-07' WHERE SecCode = 65029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491040, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 65032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838242411, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 65035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475573468, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-09-19' WHERE SecCode = 65078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531479068, ExchCode = 'FRA' WHERE SecCode = 65089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359995, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 65092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547153109, ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 65107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849155188, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 65135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475251973, ExchCode = 'MUN' WHERE SecCode = 65143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475308428, ExchCode = 'STU', PermQuoteRetireDate = '2006-04-10' WHERE SecCode = 65207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837355728, ExchCode = 'GER' WHERE SecCode = 65314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836435147, ExchCode = 'FRA', PermQuoteRetireDate = '2008-11-28' WHERE SecCode = 65327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460673, ExchCode = 'HAN' WHERE SecCode = 65358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836495768, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 65368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747575649, ExchCode = 'QTX', PermQuoteRetireDate = '2021-07-14' WHERE SecCode = 65393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836411094, ExchCode = 'FRA' WHERE SecCode = 65414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836524005, ExchCode = 'FRA' WHERE SecCode = 65419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475570968, Ticker = 'NOKN.I', ExchCode = 'CAM', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 65470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835779851, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 65521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475725172, ExchCode = 'MUN', PermQuoteRetireDate = '2007-11-30' WHERE SecCode = 65526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836425590, ExchCode = 'FRA', PermQuoteRetireDate = '2011-07-22' WHERE SecCode = 65529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660591345, ExchCode = 'MUN' WHERE SecCode = 65548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487584, ExchCode = 'QTX' WHERE SecCode = 65586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475616741, ExchCode = 'FRA' WHERE SecCode = 65641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329314, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 65657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346502, ExchCode = 'STU', PermQuoteRetireDate = '2019-08-01' WHERE SecCode = 65700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836388961, ExchCode = 'FRA' WHERE SecCode = 65807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491475, ExchCode = 'QTX' WHERE SecCode = 65894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474842540, ExchCode = 'DEU', PermQuoteRetireDate = '2018-03-12', PermSecMapEndDate = '2018-03-12' WHERE SecCode = 65963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838450820, ExchCode = 'STU', PermQuoteRetireDate = '2014-02-11' WHERE SecCode = 65966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401344, Ticker = 'XS4d', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 65975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324627, ExchCode = 'BER' WHERE SecCode = 65990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836478751, ExchCode = 'FRA' WHERE SecCode = 66026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836480997, ExchCode = 'FRA' WHERE SecCode = 66058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337960, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 66139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326420, ExchCode = 'BER' WHERE SecCode = 66166 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NOR' WHERE SecCode = 66177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685426341, ExchCode = 'MUN' WHERE SecCode = 66191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615434177, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 66192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669166144, ExchCode = 'STU' WHERE SecCode = 66201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475541870, Ticker = 'LJPC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 66228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835781423, Ticker = 'CGE', ExchCode = 'DUS', PermQuoteRetireDate = '2016-11-29' WHERE SecCode = 66263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822258, ExchCode = 'FRA' WHERE SecCode = 66265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533326442, ExchCode = 'STU' WHERE SecCode = 66279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802136346, ExchCode = 'FRA' WHERE SecCode = 66281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545616600, ExchCode = 'DEU', PermQuoteRetireDate = '2015-04-09' WHERE SecCode = 66357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498047897, ExchCode = 'STU', PermQuoteRetireDate = '2023-05-22', PermSecMapEndDate = NULL WHERE SecCode = 66382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851158619, ExchCode = 'DEU' WHERE SecCode = 66385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624377340, ExchCode = 'DEU' WHERE SecCode = 66493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830299459, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 66530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498521055, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 66532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55839691418, ExchCode = 'BER' WHERE SecCode = 66547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475344124, ExchCode = 'FRA' WHERE SecCode = 66674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489007, ExchCode = 'QTX' WHERE SecCode = 66913 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-04-07' WHERE SecCode = 74741 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838763451, PermQuoteStatus = 'AC', Ticker = '4338', ExchCode = 'HKG', PermQuoteRetireDate = NULL WHERE SecCode = 76509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838755824, PermQuoteStatus = 'AC', Ticker = '4336', ExchCode = 'HKG', PermQuoteRetireDate = NULL WHERE SecCode = 76513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838763460, Ticker = '4363', ExchCode = 'HKG', PermQuoteRetireDate = NULL WHERE SecCode = 79980 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 81073 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 83826 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 83933 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 88662 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 94218 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 99340 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 99899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21697821979, ExchCode = 'RTB' WHERE SecCode = 100947 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 101286 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 102517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538510584, Ticker = 'XPBRe', ExchCode = 'BCO' WHERE SecCode = 102966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474964536, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2010-10-02' WHERE SecCode = 103013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521652536, ExchCode = 'BER' WHERE SecCode = 103792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914302350, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 103840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520627613, ExchCode = 'DEU' WHERE SecCode = 103841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528804114, ExchCode = 'STU' WHERE SecCode = 103863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791479911, ExchCode = 'FRA' WHERE SecCode = 104270 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 104284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531132814, Ticker = 'OFCd', ExchCode = 'BCO', PermQuoteRetireDate = '2019-02-11' WHERE SecCode = 111691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843891697, ExchCode = 'DUS', PermQuoteRetireDate = '2024-12-20' WHERE SecCode = 111847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817612, ExchCode = 'FRA' WHERE SecCode = 111858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836433962, ExchCode = 'FRA', PermQuoteRetireDate = '2012-02-28' WHERE SecCode = 111866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035968, ExchCode = 'TDG' WHERE SecCode = 111867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21834002262, ExchCode = 'STU' WHERE SecCode = 111869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853992380, Ticker = '6MIA', ExchCode = 'BER', PermQuoteRetireDate = '2015-05-11' WHERE SecCode = 111924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571420277, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 111938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486937555, ExchCode = 'STU' WHERE SecCode = 112025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335260, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 112035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544726152, ExchCode = 'DEU' WHERE SecCode = 112043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836587169, ExchCode = 'FRA' WHERE SecCode = 112149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475544094, ExchCode = 'GER' WHERE SecCode = 112152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846128373, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 112218 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379871, ExchCode = 'LAS' WHERE SecCode = 112228 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 112427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475847107, ExchCode = 'DEU' WHERE SecCode = 113614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838505062, ExchCode = 'STU' WHERE SecCode = 113656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575930540, ExchCode = 'DEU' WHERE SecCode = 113659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308508, ExchCode = 'GTX' WHERE SecCode = 113809 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-07' WHERE SecCode = 113835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773002576, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 113864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595534595, ExchCode = 'DEU' WHERE SecCode = 113978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536043361, ExchCode = 'STU', PermQuoteRetireDate = '2022-07-08', PermSecMapEndDate = NULL WHERE SecCode = 113979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503066207, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 114128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333137, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 114129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506128613, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 114130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505946014, ExchCode = 'STU', PermQuoteRetireDate = '2022-12-15', PermSecMapEndDate = NULL WHERE SecCode = 114132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513072814, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 114133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21963886897, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 114136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483978618, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 114138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21479243744, ExchCode = 'TDG' WHERE SecCode = 114141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502568805, ExchCode = 'STU' WHERE SecCode = 114162 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585674844, ExchCode = 'TDG' WHERE SecCode = 114455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484724, ExchCode = 'QTX', PermQuoteRetireDate = '2023-06-23' WHERE SecCode = 114476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838736418, ExchCode = 'LAT', PermQuoteRetireDate = '2016-02-01' WHERE SecCode = 114943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794048989, ExchCode = 'TDG' WHERE SecCode = 115232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590303368, ExchCode = 'DEU' WHERE SecCode = 115234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837424519, ExchCode = 'TYO' WHERE SecCode = 115378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508449990, ExchCode = 'MUN', PermQuoteRetireDate = '2018-12-12' WHERE SecCode = 115464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22054464761, ExchCode = 'DEU' WHERE SecCode = 115623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538235, ExchCode = 'GTX' WHERE SecCode = 115779 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 117168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337704, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381737, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823487855, ExchCode = 'DUS' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419464, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838240669, ExchCode = 'MUN', PermQuoteRetireDate = '2019-01-09' WHERE SecCode = 118148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474928478, ExchCode = 'DEU' WHERE SecCode = 119129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835820564, ExchCode = 'MEX' WHERE SecCode = 121226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835820080, ExchCode = 'MEX' WHERE SecCode = 121615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835800170, ExchCode = 'MEX' WHERE SecCode = 121616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835819737, ExchCode = 'MEX' WHERE SecCode = 121619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712126456, ExchCode = 'DEU' WHERE SecCode = 122073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475080635, ExchCode = 'DEU' WHERE SecCode = 122888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475472647, ExchCode = 'BER', PermQuoteRetireDate = '2009-09-02' WHERE SecCode = 122890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791667926, ExchCode = 'BIV' WHERE SecCode = 122907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677140, ExchCode = 'BIV' WHERE SecCode = 122909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704502, ExchCode = 'MXQ' WHERE SecCode = 122911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835822173, ExchCode = 'MEX' WHERE SecCode = 122914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704391, ExchCode = 'MXQ' WHERE SecCode = 122927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835824637, ExchCode = 'MEX' WHERE SecCode = 122931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835821116, ExchCode = 'MEX' WHERE SecCode = 122934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161742211, ExchCode = 'DEU' WHERE SecCode = 124108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492709803, ExchCode = 'STU' WHERE SecCode = 124115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475620985, ExchCode = 'GER' WHERE SecCode = 124562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341899, ExchCode = 'BER', PermQuoteRetireDate = '2016-10-28' WHERE SecCode = 124574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704476, ExchCode = 'MXQ' WHERE SecCode = 124579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536222831, ExchCode = 'MEX' WHERE SecCode = 124586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819276478, ExchCode = 'DUS' WHERE SecCode = 124617 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 127427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330949, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 130530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512941442, ExchCode = 'DEU' WHERE SecCode = 131497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475131808, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-05-26', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 131865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840000435, ExchCode = 'BER', PermQuoteRetireDate = '2005-09-21' WHERE SecCode = 132168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301603, ExchCode = 'GTX' WHERE SecCode = 132188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337118, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 132593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552653, ExchCode = 'LAS' WHERE SecCode = 132606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981159, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 132611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836446227, ExchCode = 'FRA' WHERE SecCode = 132708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856250068, ExchCode = 'DUS' WHERE SecCode = 132787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713340729, PermQuoteStatus = 'AC', Ticker = 'UH40', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 132790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273239, ExchCode = 'GTX' WHERE SecCode = 132792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838239668, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 132852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594636239, PermQuoteStatus = 'AC', Ticker = 'DTI0', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 132877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298236, ExchCode = 'GTX' WHERE SecCode = 132945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836398727, ExchCode = 'FRA' WHERE SecCode = 133027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401316, Ticker = 'ONKd', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 133034 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786510506, ExchCode = 'GTX' WHERE SecCode = 133153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954131221, ExchCode = 'FRA' WHERE SecCode = 133163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589043, PermQuoteStatus = 'DC', Ticker = 'GPIG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 133226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475137351, ExchCode = 'FRA', PermQuoteRetireDate = '2014-07-02' WHERE SecCode = 133291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486913, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 133354 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 133489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22124811611, ExchCode = 'DEU' WHERE SecCode = 133778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475760850, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 137364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801211989, ExchCode = 'HAN' WHERE SecCode = 137417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625195836, ExchCode = 'FRA' WHERE SecCode = 137437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599860349, ExchCode = 'DUS', PermQuoteRetireDate = '2024-04-09', PermSecMapEndDate = '2024-04-09' WHERE SecCode = 137668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 137669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359225, ExchCode = 'GER' WHERE SecCode = 137682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842898586, ExchCode = 'FRA', PermQuoteRetireDate = '2011-06-24' WHERE SecCode = 137794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804440376, ExchCode = 'FRA' WHERE SecCode = 137820 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 PriInstrPermID = NULL WHERE SecCode = 139759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492104, ExchCode = 'QTX' WHERE SecCode = 141107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335871, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836539796, ExchCode = 'FRA' WHERE SecCode = 141172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323345, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705175, ExchCode = 'MXQ' WHERE SecCode = 141450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401338, Ticker = 'IC2d', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 141785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554497078, ExchCode = 'BER' WHERE SecCode = 142150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526956546, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 142154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623551875, ExchCode = 'TDG' WHERE SecCode = 142191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294416, ExchCode = 'GTX' WHERE SecCode = 142223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817679353, ExchCode = 'TDG' WHERE SecCode = 142224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482719, ExchCode = 'QTX' WHERE SecCode = 142384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324383, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 142505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21830275207, ExchCode = 'GTX' WHERE SecCode = 142826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588166933, ExchCode = 'DEU' WHERE SecCode = 142944 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 = 21474936011, ExchCode = 'DEU' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790727362, Ticker = 'IPCl', ExchCode = 'SIG' WHERE SecCode = 143961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894937105, ExchCode = 'GTX' WHERE SecCode = 144797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475720989, Ticker = 'G0660', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 145816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334976, ExchCode = 'DEU' WHERE SecCode = 145923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293767, Ticker = 'LZO1', ExchCode = 'GTX' WHERE SecCode = 146103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836527326, ExchCode = 'FRA' WHERE SecCode = 146127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006540, ExchCode = 'FRA' WHERE SecCode = 146151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489070, ExchCode = 'QTX' WHERE SecCode = 146155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509797897, Ticker = 'GEIG.L', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 146851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754774965, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-10-24' WHERE SecCode = 147388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22087215782, ExchCode = 'DEU' WHERE SecCode = 147554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915101821, ExchCode = 'FRA' WHERE SecCode = 147555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726460041, ExchCode = 'DEU' WHERE SecCode = 147556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915101861, ExchCode = 'FRA' WHERE SecCode = 147559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506666662, ExchCode = 'STU', PermQuoteRetireDate = '2014-12-04' WHERE SecCode = 147560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491206370, ExchCode = 'STU' WHERE SecCode = 147562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522079315, ExchCode = 'DEU' WHERE SecCode = 147569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336744, ExchCode = 'FRA' WHERE SecCode = 147570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545752458, ExchCode = 'STU', PermQuoteRetireDate = '2025-12-01' WHERE SecCode = 147805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112538, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-27', PermSecMapEndDate = NULL WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528682235, ExchCode = 'QMF', PermQuoteRetireDate = '2012-09-03' WHERE SecCode = 164836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324693, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2015-12-17', PermSecMapEndDate = '2015-12-17' WHERE SecCode = 175239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810854771, ExchCode = 'DEU' WHERE SecCode = 177325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856949142, ExchCode = 'GER' WHERE SecCode = 177328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926944, ExchCode = 'DEU' WHERE SecCode = 177340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517511603, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-04', PermSecMapEndDate = '2024-04-04' WHERE SecCode = 177409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836489072, ExchCode = 'FRA' WHERE SecCode = 177415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836483124, ExchCode = 'FRA' WHERE SecCode = 177675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593612748, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330777, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834373, ExchCode = 'DEU' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535137262, ExchCode = 'FRA' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 180212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490776, ExchCode = 'QTX', PermQuoteRetireDate = '2025-12-10' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517719870, Ticker = 'VLGe', ExchCode = 'SIG', PermQuoteRetireDate = '2013-08-12' WHERE SecCode = 182166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22024222229, ExchCode = 'DEU' WHERE SecCode = 187719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475130180, ExchCode = 'TDG', PermQuoteRetireDate = '2023-02-21' WHERE SecCode = 187830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337399, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 195530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285804, ExchCode = 'GTX' WHERE SecCode = 197050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493668, ExchCode = 'QTX' WHERE SecCode = 201597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704537, ExchCode = 'MXQ' WHERE SecCode = 201842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704190, ExchCode = 'MXQ' WHERE SecCode = 201875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791481822, ExchCode = 'FRA' WHERE SecCode = 201937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871055593, ExchCode = 'GTX' WHERE SecCode = 201945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956395290, ExchCode = 'DEU' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 214105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704511, ExchCode = 'MXQ' WHERE SecCode = 214889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520192827, ExchCode = 'STU' WHERE SecCode = 249211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394740, ExchCode = 'FRA', PermQuoteRetireDate = '2011-08-11' WHERE SecCode = 249274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787268, ExchCode = 'DUS' WHERE SecCode = 249293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856726590, ExchCode = 'STU' WHERE SecCode = 249354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474842918, ExchCode = 'DEU' WHERE SecCode = 249361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536896590, ExchCode = 'TDG' WHERE SecCode = 249364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535831521, ExchCode = 'STU', PermQuoteRetireDate = '2020-04-15' WHERE SecCode = 249365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847021469, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836400888, ExchCode = 'FRA' WHERE SecCode = 249855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333525, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 255144 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 255791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836388950, ExchCode = 'FRA' WHERE SecCode = 283709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885821, ExchCode = 'TDG' WHERE SecCode = 292366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349150, ExchCode = 'FRA' WHERE SecCode = 312932 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401347, Ticker = '33Ld', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 313548 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-07' WHERE SecCode = 324270 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667479406, ExchCode = 'QTX' WHERE SecCode = 325643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608397233, ExchCode = 'TDG' WHERE SecCode = 327144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804396433, ExchCode = 'QTX' WHERE SecCode = 335262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620411337, ExchCode = 'STU', PermQuoteRetireDate = '2023-11-17' WHERE SecCode = 336764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401339, PermQuoteStatus = 'AC', Ticker = '3HMd', ExchCode = 'BTE', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 340550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838799125, Ticker = NULL, ExchCode = 'PRA' WHERE SecCode = 346537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835817375, ExchCode = 'MEX' WHERE SecCode = 349684 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 349771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321278, ExchCode = 'BER' WHERE SecCode = 353324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475450726, ExchCode = 'FRA' WHERE SecCode = 363753 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 372861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835813469, ExchCode = 'MEX' WHERE SecCode = 383039 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 384508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523795704, ExchCode = 'STU' WHERE SecCode = 424779 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 454277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 458246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521102408, ExchCode = 'STU' WHERE SecCode = 513937 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 232929042873.0 WHERE SecCode = 519858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837441656, Ticker = 'HOGS', ExchCode = 'MIL' WHERE SecCode = 521415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307216, ExchCode = 'BIV' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852277935, ExchCode = 'MEX' WHERE SecCode = 554302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528540521, ExchCode = 'BTE', PermQuoteRetireDate = '2020-03-25' WHERE SecCode = 554481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480012, ExchCode = 'QTX' WHERE SecCode = 554696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981295, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 556230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858811523, ExchCode = 'FRA' WHERE SecCode = 556254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856214006, ExchCode = 'GER' WHERE SecCode = 558032 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 QuotePermID = 21865088683, ExchCode = 'TDG' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287357, ExchCode = 'MEX' WHERE SecCode = 780513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475065655, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 782787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475105966, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 826159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423013, ExchCode = 'FRA' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915623112, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 848018 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 853945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475136685, ExchCode = 'FRA' WHERE SecCode = 858901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379950, ExchCode = 'FRA' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913525, ExchCode = 'DEU' WHERE SecCode = 878880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55867148469, Ticker = 'XSIL', ExchCode = 'SWX' WHERE SecCode = 880290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275427, ExchCode = 'GTX' WHERE SecCode = 881802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928900998, ExchCode = 'QTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545813896, ExchCode = 'DEU' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388797, ExchCode = 'LAS' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494357256, Ticker = '0HFW', ExchCode = 'LSE', PermQuoteRetireDate = '2013-01-14' WHERE SecCode = 961652 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 968951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475766062, Ticker = '29F', ExchCode = 'STU', PermQuoteRetireDate = '2015-03-23' WHERE SecCode = 985004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769605, Ticker = 'TYMA', ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 995830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145600723, ExchCode = 'DEU' WHERE SecCode = 1017380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22166504395, ExchCode = 'DEU' WHERE SecCode = 1072550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521578326, ExchCode = 'DEU' WHERE SecCode = 1122776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55876477262, Ticker = 'XGLI', ExchCode = 'LSE', PermQuoteRetireDate = '2013-09-20' WHERE SecCode = 1192765 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 1204766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475892461, ExchCode = 'GER', PermQuoteRetireDate = '2012-04-10' WHERE SecCode = 1265152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797408685, ExchCode = 'FRA' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747333681, ExchCode = 'DEU' WHERE SecCode = 1447581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625073457, ExchCode = 'DEU' WHERE SecCode = 1453709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582997752, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1455200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504490118, ExchCode = 'FRA', PermQuoteRetireDate = '2015-06-02' WHERE SecCode = 1457731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478443280, ExchCode = 'FRA' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478615947, ExchCode = 'BUR' WHERE SecCode = 1465275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792391622, ExchCode = 'DUS' WHERE SecCode = 1468807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419448, ExchCode = 'HAM' WHERE SecCode = 1472577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21479229300, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1472753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480946905, ExchCode = 'BER', PermQuoteRetireDate = '2013-06-17' WHERE SecCode = 1479224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530720649, ExchCode = 'STU' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481396381, ExchCode = 'STU' WHERE SecCode = 1482803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482228346, ExchCode = 'DEU' WHERE SecCode = 1485685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481643753, ExchCode = 'MUN' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490171461, ExchCode = 'FRA', PermQuoteRetireDate = '2014-03-07' WHERE SecCode = 1489390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673577, ExchCode = 'BIV' WHERE SecCode = 1489564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109482, ExchCode = 'DEU' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596919147, Ticker = 'SLHOm', ExchCode = 'BTE', PermQuoteRetireDate = '2019-09-18' WHERE SecCode = 1503000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561587, ExchCode = 'DUS' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512147101, Ticker = 'BRDG', ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494566098, ExchCode = 'STU' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802786, Ticker = 'PU7D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487384788, ExchCode = 'FRA' WHERE SecCode = 1522268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488288403, ExchCode = 'FRA' WHERE SecCode = 1524542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629706417, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488654213, ExchCode = 'STU', PermQuoteRetireDate = '2022-12-19', PermSecMapEndDate = NULL WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488652814, ExchCode = 'FRA' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536289548, ExchCode = 'DEU' WHERE SecCode = 1524628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646184463, PermQuoteStatus = 'AC', Ticker = '5EV0', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 1525470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497767, ExchCode = 'DEU' WHERE SecCode = 1525756 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 = 21489507452, ExchCode = 'STU', PermQuoteRetireDate = '2012-02-14' WHERE SecCode = 1527466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071858, ExchCode = 'TDG' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098667, ExchCode = 'FRA' WHERE SecCode = 1527502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558559889, ExchCode = 'STU' WHERE SecCode = 1531694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531043659, ExchCode = 'STU' WHERE SecCode = 1532769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491111760, ExchCode = 'FRA' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524560434, Ticker = 'RBTQ', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 1533786 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 = 236787321763, ExchCode = 'FRA' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492713347, ExchCode = 'STU' WHERE SecCode = 1537214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270027, ExchCode = 'DEU' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493834048, ExchCode = 'TDG' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630031903, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1538644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800721447, ExchCode = 'FRA' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511700265, PermQuoteStatus = 'AC', Ticker = '7NU1', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786220381, ExchCode = 'STU' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496860026, ExchCode = 'FRA' WHERE SecCode = 1546652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954843, ExchCode = 'LAS' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830305592, ExchCode = 'GTX' WHERE SecCode = 1547496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679444, ExchCode = 'BIV' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21497743025, ExchCode = 'DEU' WHERE SecCode = 1552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156877250, ExchCode = 'DEU' WHERE SecCode = 1553832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498305313, ExchCode = 'FRA' WHERE SecCode = 1555173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498521053, ExchCode = 'DEU' WHERE SecCode = 1556381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502150126, ExchCode = 'STU' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615254983, ExchCode = 'DEU' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET ExchCode = 'TAI' WHERE SecCode = 1582266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503429462, ExchCode = 'FRA' WHERE SecCode = 1584599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524608957, ExchCode = 'CHI' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308444, ExchCode = 'STU' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678108, ExchCode = 'BIV' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505186360, ExchCode = 'BUR' WHERE SecCode = 1596529 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 1599564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505421178, ExchCode = 'STU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538181095, ExchCode = 'STU' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506514608, ExchCode = 'BER' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679673, ExchCode = 'BIV' WHERE SecCode = 1621273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742592, Ticker = 'KJ7', ExchCode = 'HAN', PermQuoteRetireDate = '2021-11-01' WHERE SecCode = 1623980 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 = 21510896202, ExchCode = 'MUN', PermQuoteRetireDate = '2016-10-25' WHERE SecCode = 1624036 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 1625747 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 1625748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537280920, ExchCode = 'STU', PermQuoteRetireDate = '2023-08-15' WHERE SecCode = 1630461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802789, Ticker = 'PV0D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509749786, ExchCode = 'STU' WHERE SecCode = 1635476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882713778, ExchCode = 'GTX' WHERE SecCode = 1651406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544218182, Ticker = 'IJPEz', ExchCode = 'BCO' WHERE SecCode = 1652279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512104207, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-09' WHERE SecCode = 1655572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511217511, ExchCode = 'STU' WHERE SecCode = 1675781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511202969, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 1675785 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 = 21656679815, ExchCode = 'BIV' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312304, ExchCode = 'GTX' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 1694231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512394339, ExchCode = 'FRA' WHERE SecCode = 1699181 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 = 21517428536, ExchCode = 'TRQ', PermQuoteRetireDate = '2023-06-22' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320776, ExchCode = 'BER' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285770, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538768207, Ticker = 'ECXl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2013070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517582338, ExchCode = 'STU' WHERE SecCode = 2039989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788111815, ExchCode = 'FRA' WHERE SecCode = 2042837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625195856, ExchCode = 'FRA' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521327198, ExchCode = 'DEU' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519816623, ExchCode = 'FRA' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644523837, ExchCode = 'STU' WHERE SecCode = 2195754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521581559, ExchCode = 'FRA' WHERE SecCode = 2200210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21717463490, ExchCode = 'MUN' WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532444506, ExchCode = 'STU' WHERE SecCode = 2221995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644782383, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2026-02-16' WHERE SecCode = 2222230 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 = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523650202, ExchCode = 'FRA', PermQuoteRetireDate = '2018-02-14' WHERE SecCode = 2232834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750324152, ExchCode = 'FRA' WHERE SecCode = 2232877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068269, ExchCode = 'DEU' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652141579, ExchCode = 'EQD' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830026, ExchCode = 'QTX' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525927737, ExchCode = 'FRA' WHERE SecCode = 2278244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525845974, ExchCode = 'TDG' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529849856, ExchCode = 'BER' WHERE SecCode = 2288360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525927842, ExchCode = 'DEU', PermQuoteRetireDate = '2021-06-08' WHERE SecCode = 2289254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367928, ExchCode = 'SGO' WHERE SecCode = 2293144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521368350, ExchCode = 'SGO' WHERE SecCode = 2302032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854583, ExchCode = 'STU' WHERE SecCode = 2325728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687380736, Ticker = 'CECDl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-07-06' WHERE SecCode = 2350989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781213703, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530493513, ExchCode = 'FRA' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 2370529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369453, ExchCode = 'BEC' WHERE SecCode = 2377498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607612, ExchCode = 'DUS' WHERE SecCode = 2391333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532252447, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-11' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705370, ExchCode = 'MXQ' WHERE SecCode = 2407194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532996934, ExchCode = 'FRA' WHERE SecCode = 2421101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22005177098, ExchCode = 'DEU' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533684531, ExchCode = 'DEU' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489670, ExchCode = 'QTX' WHERE SecCode = 2448345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521368602, ExchCode = 'BEC' WHERE SecCode = 2452538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694081314, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544716999, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2487616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536651291, ExchCode = 'FRA' WHERE SecCode = 2487630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815141967, ExchCode = 'MUN' WHERE SecCode = 2511591 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591015805, ExchCode = 'BER' WHERE SecCode = 2513107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591563754, ExchCode = 'BCO', PermQuoteRetireDate = '2026-03-18' WHERE SecCode = 2527880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817958767, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-23', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2529636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587574218, ExchCode = 'FRA' WHERE SecCode = 2536084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587290079, ExchCode = 'STU' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707494401, ExchCode = 'TDG' WHERE SecCode = 2543647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103168, ExchCode = 'FRA', PermQuoteRetireDate = '2018-11-29' WHERE SecCode = 2543648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533918698, ExchCode = 'CAQ' WHERE SecCode = 2544436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850059046, ExchCode = 'MUN' WHERE SecCode = 2545065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370135, ExchCode = 'SGO' WHERE SecCode = 2545788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540108933, ExchCode = 'DEU' WHERE SecCode = 2554904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542469532, ExchCode = 'DEU' WHERE SecCode = 2567216 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 2578193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543101908, ExchCode = 'DEU' WHERE SecCode = 2579445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782012631, ExchCode = 'FRA' WHERE SecCode = 2585381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121993910, ExchCode = 'BCO' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544378913, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-23' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566715663, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2604391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664823736, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2604394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606224224, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-01' WHERE SecCode = 2622293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062334, ExchCode = 'MUN' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634652632, ExchCode = 'MUN' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819966448, ExchCode = 'TDG' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2649124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549052746, ExchCode = 'FRA' WHERE SecCode = 2655940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549690613, ExchCode = 'TDG' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549893799, ExchCode = 'DEU' WHERE SecCode = 2668929 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 2679897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803385262, ExchCode = 'TDG' WHERE SecCode = 2725364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704676, ExchCode = 'MXQ' WHERE SecCode = 2743610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557003843, ExchCode = 'FRA' WHERE SecCode = 2807599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763993243, Ticker = '8PSGd', ExchCode = 'BCO' WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650196, ExchCode = 'DUS' WHERE SecCode = 2858551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561140926, ExchCode = 'DEU' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460829, ExchCode = 'GER' WHERE SecCode = 2864471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563865313, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-15' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562290608, ExchCode = 'FRA' WHERE SecCode = 2870150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677051, ExchCode = 'BIV' WHERE SecCode = 2876241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531671068, ExchCode = 'CHA' WHERE SecCode = 2887121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564231392, ExchCode = 'TRQ', PermQuoteRetireDate = '2015-05-28' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564531293, ExchCode = 'STU' WHERE SecCode = 2905610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585209876, ExchCode = 'BCO' WHERE SecCode = 2906408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644687444, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564846532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 2909243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457862, ExchCode = 'FRA' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370656, ExchCode = 'SGO' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566883039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2930544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589809334, ExchCode = 'TDG', PermQuoteRetireDate = '2019-11-20' WHERE SecCode = 2930555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568851024, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724821997, Ticker = '9GL', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2024-04-10' WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582997825, Ticker = 'RYA', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3072584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285720, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608475923, ExchCode = 'STU' WHERE SecCode = 3085564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641139161, Ticker = 'J75', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-18' WHERE SecCode = 3096965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275202, ExchCode = 'GTX' WHERE SecCode = 3098021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582927995, ExchCode = 'FRA' WHERE SecCode = 3101224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 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 QuotePermID = 22164689174, ExchCode = 'MUN' WHERE SecCode = 3121289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621432527, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3121290 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 = 21761432069, ExchCode = 'DEU' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536846008, ExchCode = 'FRA', PermQuoteRetireDate = '2018-07-11' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587931857, ExchCode = 'BTE' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790760, ExchCode = 'GTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056939, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3169823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679777, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3177778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22137202074, ExchCode = 'DEU' WHERE SecCode = 3186751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627445525, ExchCode = 'BTE' WHERE SecCode = 3186834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786090215, Ticker = 'PCFH', ExchCode = 'TDG' WHERE SecCode = 3198718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590371242, ExchCode = 'FRA' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590429261, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-01' WHERE SecCode = 3199703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100717, ExchCode = 'QTX' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448726, ExchCode = 'FRA' WHERE SecCode = 3213266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865877693, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-23' WHERE SecCode = 3223076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747327546, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614079174, ExchCode = 'TDG', PermQuoteRetireDate = '2017-05-25' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718045329, ExchCode = 'MUN' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301751, Ticker = '0EF', ExchCode = 'GTX' WHERE SecCode = 3246454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613476472, ExchCode = 'STU' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150562, ExchCode = 'AUX' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597458276, ExchCode = 'BER', PermQuoteRetireDate = '2020-07-27' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684286324, Ticker = '3660', ExchCode = 'STU', PermQuoteRetireDate = '2023-08-02' WHERE SecCode = 3257169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598341840, ExchCode = 'FRA', PermQuoteRetireDate = '2024-08-13', PermSecMapEndDate = '2024-08-13' WHERE SecCode = 3260030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604819939, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 3271586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678970, ExchCode = 'BIV' 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 = 21602970799, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3283956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602047603, ExchCode = 'MUN' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611219951, ExchCode = 'MUN', PermQuoteRetireDate = '2017-12-22' WHERE SecCode = 3297215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609616, ExchCode = 'DUS' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639800655, Ticker = 'KYH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-09' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743775985, ExchCode = 'DEU', PermQuoteRetireDate = '2022-02-14' WHERE SecCode = 3309705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609327640, ExchCode = 'FRA', PermQuoteRetireDate = '2023-07-04' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388165, ExchCode = 'LAS' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609137328, ExchCode = 'FRA' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679409, ExchCode = 'BIV' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489849, ExchCode = 'QTX' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912102337, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-09' WHERE SecCode = 3319868 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5001229431, PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = NULL WHERE SecCode = 3320106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753722337, ExchCode = 'DEU' WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448682, ExchCode = 'FRA' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482861, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705691, Ticker = 'SMIN', ExchCode = 'MXQ' WHERE SecCode = 3327117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611321674, ExchCode = 'FRA' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611445381, ExchCode = 'DEU' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690196163, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613684839, ExchCode = 'BER' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549117, ExchCode = 'GTX' WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 3350569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773003108, ExchCode = 'DEU' WHERE SecCode = 3356351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614679451, ExchCode = 'STU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678126, ExchCode = 'BIV' WHERE SecCode = 3359195 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237487, ExchCode = 'DEU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763116669, PermQuoteStatus = 'DC', Ticker = '015', ExchCode = 'BER', PermQuoteRetireDate = '2023-02-15', PermSecMapEndDate = '2023-02-15' WHERE SecCode = 3375389 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-08' WHERE SecCode = 3385582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625753506, ExchCode = 'BTE' WHERE SecCode = 3385974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663294277, ExchCode = 'MUN', PermQuoteRetireDate = '2022-09-12' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029268, ExchCode = 'SWX' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029277, ExchCode = 'SWX' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029271, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-07-04' WHERE SecCode = 3394028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390634, ExchCode = 'DEU' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623455650, ExchCode = 'BCO' WHERE SecCode = 3395249 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-07' WHERE SecCode = 3397168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810204931, ExchCode = 'DEU' WHERE SecCode = 3401365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624691050, Ticker = '2META', ExchCode = 'MIL' WHERE SecCode = 3401441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779748, ExchCode = 'MUN' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141123, ExchCode = 'FRA' WHERE SecCode = 3405304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628652762, ExchCode = 'STU', PermQuoteRetireDate = '2024-09-30', PermSecMapEndDate = NULL WHERE SecCode = 3405438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334821, ExchCode = 'DEU' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679776, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624076993, ExchCode = 'SGO' WHERE SecCode = 3406544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796757245, ExchCode = 'FRA' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784205314, ExchCode = 'FRA' WHERE SecCode = 3407871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 236805162201, ExchCode = 'FRA' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644146276, ExchCode = 'FRA' WHERE SecCode = 3409040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396615, ExchCode = 'DEU' WHERE SecCode = 3409090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801066696, Ticker = 'C0B1', ExchCode = 'DEU' WHERE SecCode = 3410283 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 PriInstrPermID = NULL WHERE SecCode = 3431944 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186303, ExchCode = 'DEU' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688591124, ExchCode = 'STU' WHERE SecCode = 3445093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796141667, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3445201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388252, ExchCode = 'LAS' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644782384, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3446081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298408, ExchCode = 'GTX' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645305949, ExchCode = 'FRA' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645435116, ExchCode = 'BER', PermQuoteRetireDate = '2020-01-02' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938003820, ExchCode = 'MUN' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647221128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647732095, ExchCode = 'STU' WHERE SecCode = 3493723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704432, ExchCode = 'MXQ' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830309287, ExchCode = 'GTX', PermQuoteRetireDate = '2025-11-11' WHERE SecCode = 3501431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' 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 = 21656679290, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3518311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652485956, ExchCode = 'MUN', PermQuoteRetireDate = '2018-07-05', PermSecMapEndDate = '2018-07-05' WHERE SecCode = 3529083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781734353, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 3529087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830305699, ExchCode = 'GTX' WHERE SecCode = 3532734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685853416, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830259734, ExchCode = 'TDG' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452965, ExchCode = 'FRA' WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953341540, ExchCode = 'MUN' WHERE SecCode = 3549499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796358598, ExchCode = 'TDG' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656632105, Ticker = 'DNK', ExchCode = 'LSE', PermQuoteRetireDate = '2021-09-24' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656838842, ExchCode = 'STU' WHERE SecCode = 3558191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 3562840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731163509, ExchCode = 'FRA' WHERE SecCode = 3584663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609269239, ExchCode = 'DEU' WHERE SecCode = 3586984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782645921, ExchCode = 'BER', PermQuoteRetireDate = '2021-04-07' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572528819, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544508318, ExchCode = 'STU' WHERE SecCode = 3587041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388252, ExchCode = 'LAS' WHERE SecCode = 3587074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761303077, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3588035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775216436, ExchCode = 'MUN' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527215, ExchCode = 'FRA' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667846371, ExchCode = 'FRA' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952421, ExchCode = 'DEU' WHERE SecCode = 3591601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666113143, ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664171446, PermQuoteStatus = 'DC', Ticker = '2HQ', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28' WHERE SecCode = 3610775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664433945, ExchCode = 'STU' WHERE SecCode = 3610818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893299383, ExchCode = 'GTX' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21650068290, Ticker = 'XBEC', ExchCode = 'SWX' WHERE SecCode = 3619554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748602400, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-03' WHERE SecCode = 3623818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704823, ExchCode = 'MXQ' WHERE SecCode = 3629694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668632710, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668783311, ExchCode = 'HAM' WHERE SecCode = 3642406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710963601, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705588, ExchCode = 'MXQ' WHERE SecCode = 3644857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690033954, ExchCode = 'MUN' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672709111, ExchCode = 'FRA' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670410338, Ticker = 'ROAI', ExchCode = 'SWX', PermQuoteRetireDate = '2023-09-22' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293822, ExchCode = 'GTX' WHERE SecCode = 3657811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308294, ExchCode = 'GTX' WHERE SecCode = 3658775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723938636, PermQuoteStatus = 'DC', Ticker = 'EP2', ExchCode = 'QTX', PermQuoteRetireDate = '2023-09-05' WHERE SecCode = 3663204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672845652, ExchCode = 'FRA' WHERE SecCode = 3675648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569892, ExchCode = 'QTX' WHERE SecCode = 3675861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675091688, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3690817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812659612, ExchCode = 'QTX', PermQuoteRetireDate = '2021-12-10' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297867, ExchCode = 'DUS', PermQuoteRetireDate = '2021-10-21' WHERE SecCode = 3716790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679876423, ExchCode = 'DEU' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288603, ExchCode = 'GTX' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679876256, ExchCode = 'STU' WHERE SecCode = 3739134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682712573, ExchCode = 'STU' WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704309, ExchCode = 'MXQ' WHERE SecCode = 3756608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704929, Ticker = 'GNKN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3761051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620914214, Ticker = 'CZBl', ExchCode = 'BCO', PermQuoteRetireDate = '2019-11-26' WHERE SecCode = 3762759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272950, ExchCode = 'GTX' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685505912, ExchCode = 'MXQ' WHERE SecCode = 3783012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713593778, ExchCode = 'MUN' WHERE SecCode = 3793374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705324, ExchCode = 'MXQ' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733938467, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-05', PermSecMapEndDate = NULL WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388235, ExchCode = 'LAS' WHERE SecCode = 3809052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679916088, ExchCode = 'MXQ' WHERE SecCode = 3809094 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 3818112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373511, ExchCode = 'MEX' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623734, ExchCode = 'TDG' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21697686068, ExchCode = 'BER' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 3835559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696168646, ExchCode = 'DEU' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659513, PermQuoteStatus = 'AC', Ticker = '2ZT1', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865590408, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841766443, ExchCode = 'QTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373509, ExchCode = 'BIV' WHERE SecCode = 3854663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787746616, ExchCode = 'SIU', PermQuoteRetireDate = '2025-01-04' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830030, ExchCode = 'QTX' WHERE SecCode = 3863388 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 = 21938950149, Ticker = 'UPRl', ExchCode = 'BCO' 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 = 21702467120, ExchCode = 'FRA' WHERE SecCode = 3886782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703664105, ExchCode = 'STU' WHERE SecCode = 3898812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703664160, ExchCode = 'TDG' WHERE SecCode = 3898813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755619, ExchCode = 'FRA' WHERE SecCode = 3913159 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 3919574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820576474, ExchCode = 'DUS' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679348107, ExchCode = 'BIV' WHERE SecCode = 3934323 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 = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718474201, ExchCode = 'FRA' WHERE SecCode = 3998157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 4001136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359626, ExchCode = 'BIV' WHERE SecCode = 4024645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011932, Ticker = '2BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012741, Ticker = '2MS' WHERE SecCode = 4031717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027112, Ticker = '1BA' WHERE SecCode = 4031741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010270, Ticker = '21COV' WHERE SecCode = 4031771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026770, Ticker = '1DE' 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 PermQuoteRetireDate = '2026-04-08' WHERE SecCode = 4031901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012517, Ticker = '2MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013288, Ticker = '2PM' WHERE SecCode = 4032067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013994, Ticker = '2CRM' WHERE SecCode = 4032071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143797, Ticker = '2AKZA', ExchCode = 'MIL' WHERE SecCode = 4032088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779134244, ExchCode = 'AQX' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833427601, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-07' WHERE SecCode = 4049121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733147228, ExchCode = 'FRA' WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727356453, ExchCode = 'BIV' WHERE SecCode = 4090018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738253265, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 4090028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818713443, PermQuoteStatus = 'DC', Ticker = '4E40', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 4101126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587301011, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735442278, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4106680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908303, ExchCode = 'DUS' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787721995, ExchCode = 'MUN' WHERE SecCode = 4110887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737759433, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4119578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727358586, ExchCode = 'BIV' WHERE SecCode = 4119581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586975, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738226580, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4124713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963671, ExchCode = 'STU' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727352698, ExchCode = 'BIV' WHERE SecCode = 4134210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734634060, ExchCode = 'FRA' WHERE SecCode = 4139227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571646335, ExchCode = 'BEC' WHERE SecCode = 4139247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388438, ExchCode = 'LAS' WHERE SecCode = 4169152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958505, ExchCode = 'FRA' WHERE SecCode = 4201669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262892, ExchCode = 'DEU' WHERE SecCode = 4201732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963695, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-17' WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488857, ExchCode = 'STU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767422123, ExchCode = 'FRA' WHERE SecCode = 4210918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727350451, ExchCode = 'BIV' WHERE SecCode = 4212368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012792, Ticker = '2HCA' WHERE SecCode = 4214370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999014130, Ticker = '2NOW' WHERE SecCode = 4214371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011916, Ticker = '2AMT' WHERE SecCode = 4214372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011917, Ticker = '2AWK' WHERE SecCode = 4214377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012327, Ticker = '2GD' WHERE SecCode = 4214384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012556, Ticker = '2HLT' WHERE SecCode = 4214387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013434, Ticker = '2SPG' WHERE SecCode = 4214395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013297, Ticker = '2SYK' WHERE SecCode = 4214397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013876, Ticker = '2TROW' WHERE SecCode = 4214399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013596, Ticker = '2WEC' WHERE SecCode = 4214401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22069067182, Ticker = '2APH', ExchCode = 'MIL' WHERE SecCode = 4214403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371806, Ticker = '0Q3', ExchCode = 'BRN' WHERE SecCode = 4214409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013708, Ticker = '2PLUG', ExchCode = 'MIL' WHERE SecCode = 4214415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349456, ExchCode = 'MEX' WHERE SecCode = 4228288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749841407, ExchCode = 'FRA' WHERE SecCode = 4228324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750887012, ExchCode = 'TDG' WHERE SecCode = 4231470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752408872, ExchCode = 'FRA' WHERE SecCode = 4248820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754379229, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4253036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754200423, ExchCode = 'FRA' WHERE SecCode = 4253037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755406183, ExchCode = 'DEU' WHERE SecCode = 4267228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756148826, ExchCode = 'MXQ' WHERE SecCode = 4273980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756548990, ExchCode = 'FRA' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767996853, ExchCode = 'DEU' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757260470, ExchCode = 'DEU' WHERE SecCode = 4278855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757506160, ExchCode = 'FRA' WHERE SecCode = 4278857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757668911, ExchCode = 'FRA' WHERE SecCode = 4282400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758703400, ExchCode = 'DEU' WHERE SecCode = 4288863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727356005, ExchCode = 'BIV' WHERE SecCode = 4291615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763122567, PermQuoteStatus = 'AC', Ticker = '9EG0', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760599386, ExchCode = 'FRA' WHERE SecCode = 4303570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143914, Ticker = '2TKWY', ExchCode = 'MIL' WHERE SecCode = 4309036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011282, Ticker = '2NB' WHERE SecCode = 4309038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143959, Ticker = '2RMS', ExchCode = 'MIL' WHERE SecCode = 4309039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010863, Ticker = '28TRA' WHERE SecCode = 4309041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143858, Ticker = '2ASM', ExchCode = 'MIL' WHERE SecCode = 4309043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012751, Ticker = '2OXY' WHERE SecCode = 4309046 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011966, Ticker = '2DOW' WHERE SecCode = 4309048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432057, ExchCode = 'DEU' WHERE SecCode = 4309050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842459237, ExchCode = 'HAN' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763690130, ExchCode = 'QTX' WHERE SecCode = 4321393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709366460, ExchCode = 'BIV' WHERE SecCode = 4324371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727341342, ExchCode = 'BIV' WHERE SecCode = 4324380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867342843, ExchCode = 'TDG' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771445002, ExchCode = 'QTX' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770221758, ExchCode = 'DEU' WHERE SecCode = 4360099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877510586, ExchCode = 'MUN' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606760, ExchCode = 'DEU' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510674, ExchCode = 'QTX' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 4377196 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 4377438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452791, ExchCode = 'FRA' WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960079950, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870599, ExchCode = 'FRA' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122676110, ExchCode = 'DEU' WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826495190, ExchCode = 'DUS' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777647867, ExchCode = 'TDG' WHERE SecCode = 4402301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307749, ExchCode = 'MEX' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783161157, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4415732 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 = 236779370420, ExchCode = 'AQE' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307218, ExchCode = 'BIV' WHERE SecCode = 4426954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783652671, ExchCode = 'DEU' WHERE SecCode = 4426955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727303270, ExchCode = 'BIV' WHERE SecCode = 4426957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783670602, ExchCode = 'EQD' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013269, Ticker = '2VTRS' WHERE SecCode = 4427826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779047734, ExchCode = 'BER', PermQuoteRetireDate = '2024-04-05', PermSecMapEndDate = NULL WHERE SecCode = 4427929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394138, ExchCode = 'STU' WHERE SecCode = 4429683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600486, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4436991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685893, PermQuoteStatus = 'AC', Ticker = '60P0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 4444005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387348, ExchCode = 'LAS' WHERE SecCode = 4447601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788257884, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-28', PermSecMapEndDate = '2023-06-28' WHERE SecCode = 4449703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727299958, ExchCode = 'BIV' WHERE SecCode = 4449704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301154, ExchCode = 'MEX' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789567035, ExchCode = 'DEU' WHERE SecCode = 4458936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789568350, ExchCode = 'DEU' WHERE SecCode = 4458938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689543, ExchCode = 'FRA' WHERE SecCode = 4463152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793399825, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4470175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797398508, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4470353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396762, ExchCode = 'DEU' WHERE SecCode = 4472909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396957, ExchCode = 'DEU' WHERE SecCode = 4472926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793674463, ExchCode = 'DUS' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776786558, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'A2X', PermQuoteRetireDate = '2024-05-24' WHERE SecCode = 4477796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780165906, ExchCode = 'MXQ' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555598, ExchCode = 'FRA' WHERE SecCode = 4496736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798558522, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4502468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409262, ExchCode = 'FRA' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287355, ExchCode = 'BIV' WHERE SecCode = 4505578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955219315, ExchCode = 'TDG' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802419041, ExchCode = 'TDG', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800727363, ExchCode = 'DEU' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780960627, ExchCode = 'STU' WHERE SecCode = 4517645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381380, ExchCode = 'LAS' WHERE SecCode = 4526143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851675957, ExchCode = 'STU' WHERE SecCode = 4526144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799910403, ExchCode = 'DEU' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803607182, Ticker = '0RW0', ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803771918, ExchCode = 'DEU' WHERE SecCode = 4536450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802587261, ExchCode = 'STU' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219724, ExchCode = 'DEU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219797, ExchCode = 'DEU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 4540648 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 4541011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786141623, ExchCode = 'MXQ' WHERE SecCode = 4547978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271946, ExchCode = 'BIV' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806535085, ExchCode = 'MUN' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806550607, ExchCode = 'FRA' WHERE SecCode = 4553829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097393503, ExchCode = 'FRA' WHERE SecCode = 4553852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806748726, ExchCode = 'FRA' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807446197, ExchCode = 'FRA', PermQuoteRetireDate = '2025-08-04', PermSecMapEndDate = '2025-08-04' WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144478, ExchCode = 'FRA' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808951005, ExchCode = 'DEU' WHERE SecCode = 4568423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286428, ExchCode = 'GTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812848426, ExchCode = 'FRA' WHERE SecCode = 4591965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812836218, ExchCode = 'TDG' WHERE SecCode = 4592022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380574, ExchCode = 'LAS' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814382045, ExchCode = 'DEU' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305821, ExchCode = 'MEX' WHERE SecCode = 4597223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881522351, ExchCode = 'MUN' WHERE SecCode = 4601728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815149494, ExchCode = 'STU' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814722256, ExchCode = 'DEU' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275562, ExchCode = 'GTX' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816241209, ExchCode = 'STU' WHERE SecCode = 4607717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138517569, ExchCode = 'BTE' WHERE SecCode = 4609997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045075404, ExchCode = 'LAS' WHERE SecCode = 4613099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527622, ExchCode = 'FRA' WHERE SecCode = 4618010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968078, ExchCode = 'DEU' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820389350, ExchCode = 'FRA' 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 PermOrgIPODate = '2021-06-24' WHERE SecCode = 4634350 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 4638889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854881328, ExchCode = 'GTX' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727256658, ExchCode = 'MEX' WHERE SecCode = 4654595 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 4658647 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 = 21835316539, ExchCode = 'STU' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244581, ExchCode = 'MEX' WHERE SecCode = 4684128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835314248, ExchCode = 'GTX' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873118953, ExchCode = 'BCO' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244576, ExchCode = 'BIV' WHERE SecCode = 4695806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026894, Ticker = '1STX' WHERE SecCode = 4699232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773003141, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-23' WHERE SecCode = 4707187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 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 = 21853430101, ExchCode = 'GTX' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897365, ExchCode = 'FRA', PermQuoteRetireDate = '2024-09-05' WHERE SecCode = 4726108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867566, ExchCode = 'FRA', PermQuoteRetireDate = '2025-10-29', PermSecMapEndDate = NULL WHERE SecCode = 4748531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830015, ExchCode = 'QTX' WHERE SecCode = 4754742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133181621, Ticker = 'ETHW', ExchCode = 'SWX' WHERE SecCode = 4756631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388646, ExchCode = 'LAS' WHERE SecCode = 4761545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854186426, ExchCode = 'DEU' WHERE SecCode = 4761589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861324024, ExchCode = 'STU' WHERE SecCode = 4766038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854914847, PermQuoteStatus = 'AC', Ticker = '3FNG', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855838898, ExchCode = 'QTX' WHERE SecCode = 4773770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439582, ExchCode = 'MUN', PermQuoteRetireDate = '2021-11-15' WHERE SecCode = 4773786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856500053, ExchCode = 'STU' WHERE SecCode = 4775072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726920, ExchCode = 'GTX' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795695818, ExchCode = 'TDG' WHERE SecCode = 4775075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961970528, ExchCode = 'MUN' WHERE SecCode = 4794550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860598008, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4800552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860831449, ExchCode = 'STU' WHERE SecCode = 4802301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380494, ExchCode = 'LAS', PermQuoteRetireDate = '2026-02-12' WHERE SecCode = 4811141 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 = 21860858404, ExchCode = 'DEU' WHERE SecCode = 4813526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799418543, ExchCode = 'SIG' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863182410, ExchCode = 'MUN' WHERE SecCode = 4815314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804716445, ExchCode = 'HAM' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192589, ExchCode = 'FRA' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580195, ExchCode = 'DUS' WHERE SecCode = 4834791 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 = 236784379540, ExchCode = 'LAS' WHERE SecCode = 4845025 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 = 21871056172, ExchCode = 'MUN' WHERE SecCode = 4845045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144452985, ExchCode = 'LAS' WHERE SecCode = 4854866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22111478365, ExchCode = 'TDG' WHERE SecCode = 4854867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089453110, ExchCode = 'BTE' WHERE SecCode = 4854872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876129776, ExchCode = 'QTX' WHERE SecCode = 4885603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877510550, ExchCode = 'STU' WHERE SecCode = 4887246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892048749, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018979, ExchCode = 'STU' WHERE SecCode = 4890295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828334184, ExchCode = 'STU' WHERE SecCode = 4890300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905908990, ExchCode = 'MUN', PermQuoteRetireDate = '2022-09-20' WHERE SecCode = 4893294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877551047, ExchCode = 'DEU' WHERE SecCode = 4907129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727210604, ExchCode = 'MEX' WHERE SecCode = 4938350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781980293, PermQuoteStatus = 'DC', Ticker = '62U1', ExchCode = 'BER', PermQuoteRetireDate = '2025-09-01' WHERE SecCode = 4943250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884189014, ExchCode = 'QTX', PermQuoteRetireDate = '2024-08-15' WHERE SecCode = 4943410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884962075, ExchCode = 'STU' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883524288, ExchCode = 'DEU' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, ExchCode = 'QTX' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884973298, ExchCode = 'MUN' WHERE SecCode = 4957875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891723924, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 4959596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689488, ExchCode = 'DEU' WHERE SecCode = 4959597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907555781, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4969375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21975240638, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 4969407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419011, ExchCode = 'LAS' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887564482, ExchCode = 'QTX' 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 = 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 = 21888279622, ExchCode = 'MUN' WHERE SecCode = 4983996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100827, ExchCode = 'DUS' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910753865, Ticker = '1COIN' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910739462, Ticker = 'SGLY' WHERE SecCode = 5004801 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 = 21897338416, ExchCode = 'DEU' WHERE SecCode = 5025182 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 5028071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928845, ExchCode = 'BCO' WHERE SecCode = 5038689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898852880, ExchCode = 'FRA' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381611, ExchCode = 'LAS' WHERE SecCode = 5067269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902629320, ExchCode = 'QTX' WHERE SecCode = 5067289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907031273, ExchCode = 'STU' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931483023, ExchCode = 'MUN' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663797, ExchCode = 'DEU' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380640, ExchCode = 'LAS' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727217398, ExchCode = 'BIV' WHERE SecCode = 5083954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779601759, ExchCode = 'STU' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727204807, ExchCode = 'MEX' WHERE SecCode = 5099007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907558521, ExchCode = 'MUN', PermQuoteRetireDate = '2024-04-19' WHERE SecCode = 5099027 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 25727367956.0, Ticker = 'KEEL' WHERE SecCode = 5101460 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 25727367956.0, Ticker = 'KEELD' WHERE SecCode = 5104592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716500, ExchCode = 'FRA' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875317, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27', PermSecMapEndDate = '2023-10-27' WHERE SecCode = 5112411 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2015-04-16', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 5114180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898202, PermQuoteStatus = 'AC', Ticker = '3SFBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5115635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781637018, ExchCode = 'HAM' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923404247, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-21' WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912121144, ExchCode = 'FRA' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642004, ExchCode = 'QTX' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607033, Ticker = 'NDAQ', ExchCode = 'SWX' WHERE SecCode = 5144089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520648, ExchCode = 'DEU' WHERE SecCode = 5151167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830485, ExchCode = 'DUS' WHERE SecCode = 5153443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423065, ExchCode = 'FRA' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790867, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843186265, Ticker = '0A60l', ExchCode = 'BCO' WHERE SecCode = 5161244 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 = 21508528400, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755973706, ExchCode = 'DUS' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727308116, ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727248292, ExchCode = 'MEX' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387325, ExchCode = 'LAS' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924150711, ExchCode = 'STU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820375290, Ticker = 'SQTA', ExchCode = 'TDG', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381527, ExchCode = 'LAS' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893559951, Ticker = 'AZPN1*', ExchCode = 'MXQ' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871079564, ExchCode = 'MXQ' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569896, ExchCode = 'QTX' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173433, ExchCode = 'BIV' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 5168492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955191864, ExchCode = 'DUS' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921849641, ExchCode = 'FRA' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778838011, ExchCode = 'DUS', PermQuoteRetireDate = '2025-11-26' WHERE SecCode = 5182664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923425218, ExchCode = 'DEU' 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 QuotePermID = 21932421566, PermQuoteStatus = 'AC', Ticker = '3SZNm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5195447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535364, ExchCode = 'MUN' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872761574, Ticker = 'AFTT', ExchCode = 'PAR' WHERE SecCode = 5206274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871539362, Ticker = 'ALINK', ExchCode = 'AEX' WHERE SecCode = 5206286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140088087, ExchCode = 'HAM' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801543852, ExchCode = 'HAM' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388873, ExchCode = 'LAS' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727227059, ExchCode = 'MEX' WHERE SecCode = 5238268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173435, ExchCode = 'MEX' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932224534, ExchCode = 'GTX' WHERE SecCode = 5247621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787664879, ExchCode = 'QTX' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387487, ExchCode = 'LAS' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936306959, ExchCode = 'DUS' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775222346, ExchCode = 'BIV' WHERE SecCode = 5267090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397479, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5269462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100719, ExchCode = 'QTX' WHERE SecCode = 5272089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938340072, ExchCode = 'STU' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938327486, ExchCode = 'DEU' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758789, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = NULL WHERE SecCode = 5283651 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 5286272 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 5287499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781180723, ExchCode = 'GTX' WHERE SecCode = 5290322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956341568, ExchCode = 'HAN' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803327, ExchCode = 'DUS' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943067733, ExchCode = 'FRA' WHERE SecCode = 5301896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077356, ExchCode = 'LAS', PermQuoteRetireDate = '2025-08-08', PermSecMapEndDate = NULL WHERE SecCode = 5311845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908505, PermQuoteStatus = 'DC', Ticker = '3QP0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5324087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581879, ExchCode = 'QTX' WHERE SecCode = 5338742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000083106, DomCntry = NULL, IncCntry = 'USA', PermOrgIPODate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5344695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633707, ExchCode = 'DEU' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952832311, ExchCode = 'STU' WHERE SecCode = 5347429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510655, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-09' WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381676, ExchCode = 'LAS' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874420, ExchCode = 'GTX' WHERE SecCode = 5374941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959007472, ExchCode = 'DEU' WHERE SecCode = 5381858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959007494, ExchCode = 'DEU' WHERE SecCode = 5381859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959007540, ExchCode = 'FRA' WHERE SecCode = 5381860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959007249, ExchCode = 'FRA' WHERE SecCode = 5381861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776581931, ExchCode = 'MEX' WHERE SecCode = 5381916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727195024, ExchCode = 'BIV' WHERE SecCode = 5381947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961201424, ExchCode = 'FRA' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '4JX0' WHERE SecCode = 5430768 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 5446053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727169122, Ticker = 'CAMBIo', ExchCode = 'SIG' WHERE SecCode = 5448761 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 5455472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21974975593, ExchCode = 'DEU' WHERE SecCode = 5457304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21974975187, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5457305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193596, ExchCode = 'MEX' WHERE SecCode = 5474598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416291, ExchCode = 'FRA' WHERE SecCode = 5476926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729828, ExchCode = 'FRA' WHERE SecCode = 5478214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778659884, ExchCode = 'MEX' WHERE SecCode = 5496143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834799, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5496168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982253324, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5496242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21983506605, Ticker = '3BASm', ExchCode = 'BCO' WHERE SecCode = 5496244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394120, ExchCode = 'TDG' WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011031, Ticker = '2TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512065, Ticker = '3PYPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5503776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580217, ExchCode = 'GER' WHERE SecCode = 5503779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823777, ExchCode = 'AQX' WHERE SecCode = 5503780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 5503781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663656, ExchCode = 'AQX' WHERE SecCode = 5503782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823760, ExchCode = 'AQX' WHERE SecCode = 5503898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807449510, ExchCode = 'BCO' WHERE SecCode = 5503900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663650, Ticker = 'ARK3l', ExchCode = 'AQX' WHERE SecCode = 5503901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836104, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5506501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882467041, Ticker = 'BTCW', ExchCode = 'SWX' WHERE SecCode = 5509588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804440435, ExchCode = 'TDG' WHERE SecCode = 5527547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535806, ExchCode = 'MEX' WHERE SecCode = 5539536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471348, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5541732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561938, ExchCode = 'FRA', PermQuoteRetireDate = '2025-07-23', PermSecMapEndDate = '2025-07-23' WHERE SecCode = 5550739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836233, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881555404, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580185, ExchCode = 'DEU' WHERE SecCode = 5569302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823771, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-15' WHERE SecCode = 5569303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604521803, Ticker = '4BB', ExchCode = 'MUN', PermQuoteRetireDate = '2019-01-10' WHERE SecCode = 5569431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659489, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-22' WHERE SecCode = 5569960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777360178, ExchCode = 'MEX' WHERE SecCode = 5581641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997766265, Ticker = 'NGLS', ExchCode = 'LSE' WHERE SecCode = 5584733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780515980, ExchCode = 'FRA' WHERE SecCode = 5607542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793574816, ExchCode = 'TDG' WHERE SecCode = 5623203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727210601, ExchCode = 'BIV' WHERE SecCode = 5629067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942899, ExchCode = 'BIV' WHERE SecCode = 5631516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780872941, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-22' WHERE SecCode = 5633493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781060493, ExchCode = 'FRA' WHERE SecCode = 5633895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460745, ExchCode = 'FRA' WHERE SecCode = 5638832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823715, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-15' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823853, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'C6E0' WHERE SecCode = 5655038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781543275, ExchCode = 'STU' WHERE SecCode = 5655040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307755, ExchCode = 'MEX' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986191813, Ticker = '3TSE', ExchCode = 'GTX' WHERE SecCode = 5663514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781954019, ExchCode = 'FRA' WHERE SecCode = 5687951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782254675, ExchCode = 'FRA' WHERE SecCode = 5710467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782563848, ExchCode = 'FRA' WHERE SecCode = 5722406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782871477, ExchCode = 'STU' WHERE SecCode = 5745665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937290553, ExchCode = 'FRA' WHERE SecCode = 5749952 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 5760048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787198171, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785264814, ExchCode = 'FRA' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22044538463, ExchCode = 'DEU' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 5828879 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 5834667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031122900, Ticker = 'CO3Sl', ExchCode = 'BCO' WHERE SecCode = 5839249 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 = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735452563, ExchCode = 'DEU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785461020, ExchCode = 'FRA' WHERE SecCode = 5888374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416443, ExchCode = 'MEX' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800227924, ExchCode = 'TDG' WHERE SecCode = 5894957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22076466658, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2025-02-11' WHERE SecCode = 5897569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785943776, ExchCode = 'FRA' WHERE SecCode = 5907872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784888212, ExchCode = 'MEX' WHERE SecCode = 5907884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386725, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-25', PermSecMapEndDate = '2025-04-25' WHERE SecCode = 5911970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386190, ExchCode = 'TDG' WHERE SecCode = 6010807 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 6014512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788759413, ExchCode = 'STU' WHERE SecCode = 6035234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136111007, Ticker = 'BITCl', ExchCode = 'CHI' WHERE SecCode = 6078418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136110997, Ticker = 'BITPl', ExchCode = 'BTE' WHERE SecCode = 6078420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571976516, ExchCode = 'BEC' WHERE SecCode = 6095641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083162878, ExchCode = 'DEU' WHERE SecCode = 6095673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110935, Ticker = 'FTNGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-01' WHERE SecCode = 6097301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421365, PermQuoteStatus = 'AC', Ticker = '3LNFm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 6097318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970308382, ExchCode = 'BCO' 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 QuotePermID = 25727351672, ExchCode = 'MEX' WHERE SecCode = 6097355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580190, ExchCode = 'FRA' WHERE SecCode = 6097360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22016170429, PermQuoteStatus = 'DC', Ticker = 'SCO3', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 6097382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814699350, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21906823830, ExchCode = 'AQX' WHERE SecCode = 6097426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823888, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409290, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6097431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886404022, ExchCode = 'GER' WHERE SecCode = 6097585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835913, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834940, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782860079, Ticker = '3OIS', ExchCode = 'LSE' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790283706, ExchCode = 'FRA' WHERE SecCode = 6119927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792959667, ExchCode = 'STU' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791696289, ExchCode = 'BIV' WHERE SecCode = 6223976 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 = 22136111001, Ticker = 'BTCFl', ExchCode = 'BTE' WHERE SecCode = 6245909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580182, ExchCode = 'DUS' WHERE SecCode = 6256405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181397, ExchCode = 'BIV' WHERE SecCode = 6256406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801123684, OrgPermID = 5001229431, ExchCode = 'FRA', PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = NULL WHERE SecCode = 6256407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818713443, PermQuoteStatus = 'DC', Ticker = '4E40', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 6256409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759798861, PermQuoteStatus = 'DC', Ticker = '0BF1', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811034765, ExchCode = 'MXQ' WHERE SecCode = 6256413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819293760, PermQuoteStatus = 'DC', Ticker = '2IU0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 6256420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22082089941, ExchCode = 'QTX' WHERE SecCode = 6256447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401320, Ticker = '1RGLDm', ExchCode = 'BCO' WHERE SecCode = 6264247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269530, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 6269028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269527, ExchCode = 'HAM' WHERE SecCode = 6269033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792988435, ExchCode = 'GTX' WHERE SecCode = 6310651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910459, ExchCode = 'STU' WHERE SecCode = 6325196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549247, ExchCode = 'GTX' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808950961, ExchCode = 'DEU' WHERE SecCode = 6364834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989720, ExchCode = 'MXQ' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793855800, ExchCode = 'TDG' WHERE SecCode = 6368981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794030291, ExchCode = 'FRA' WHERE SecCode = 6382149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792141851, ExchCode = 'TDG' WHERE SecCode = 6382150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794188795, ExchCode = 'DUS' WHERE SecCode = 6392491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789515593, ExchCode = 'BIV' WHERE SecCode = 6394335 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 = 22130904343, ExchCode = 'GTX' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125770690, ExchCode = 'DEU' WHERE SecCode = 6443261 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6448289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788837447, ExchCode = 'BIV' WHERE SecCode = 6448789 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 PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 6480275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22132054140, ExchCode = 'QTX' WHERE SecCode = 6482759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796557202, ExchCode = 'FRA' WHERE SecCode = 6482768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365452, ExchCode = 'DEU' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145080, ExchCode = 'DUS' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746061, ExchCode = 'DUS' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 6548033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797392, ExchCode = 'TDG' WHERE SecCode = 6548155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799207727, ExchCode = 'MUN' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799474943, ExchCode = 'FRA' WHERE SecCode = 6577960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799956966, ExchCode = 'QTX' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 6587291 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000083106, Ticker = 'KEEL*', DomCntry = NULL, IncCntry = 'USA', PermOrgIPODate = NULL WHERE SecCode = 6590595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800096573, ExchCode = 'FRA' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484355, ExchCode = 'QTX' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134134351, ExchCode = 'STU' WHERE SecCode = 6617649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798361864, ExchCode = 'MEX' WHERE SecCode = 6625876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21976165242, ExchCode = 'DEU' WHERE SecCode = 6626357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781821981, ExchCode = 'QTX' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451401, ExchCode = 'BTE' WHERE SecCode = 6627463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833039, ExchCode = 'MEX' WHERE SecCode = 6628690 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 6629297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802136610, ExchCode = 'FRA' WHERE SecCode = 6629415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 6631817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802456204, ExchCode = 'DUS' WHERE SecCode = 6638341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471843, ExchCode = 'DUS' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471092, ExchCode = 'FRA' WHERE SecCode = 6642930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798361873, ExchCode = 'MEX' WHERE SecCode = 6661586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883771519, ExchCode = 'FRA' WHERE SecCode = 6667833 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-07' WHERE SecCode = 6689497 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 6712514 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 6719138 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 6724297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795337244, ExchCode = 'MEX' WHERE SecCode = 6741058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805095498, ExchCode = 'DUS' WHERE SecCode = 6753078 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5001229431, PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = NULL WHERE SecCode = 10988860 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 11108466 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2015-04-16' WHERE SecCode = 11147281 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11153171 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11154766 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 11195201 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11196048 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000083106, DomCntry = NULL, IncCntry = 'USA', PermOrgIPODate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11198774 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11201582 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11204164 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11206308 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11216256 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11216266 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2021-06-24' WHERE SecCode = 11226194 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11233600 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11238338 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11245955 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951871.0 WHERE SecCode = 11259864 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'DCBG', ExchCode = 'NYS' WHERE SecCode = 11266887 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11270459 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11270872 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805164661, InstrPermID = 232920113324, OrgPermID = 6000002517, PriTrdQuotePermID = 236805164661.0, ValQuotePermID = 25727028610.0, PriInstrPermID = 232920113324.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'CSHR', ExchCode = 'NSM', DomCntry = 'JEY', IncCntry = 'JEY', PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = '2026-04-01', PermSecMapStartDate = '2026-04-01', PermSecMapEndDate = NULL WHERE SecCode = 11270991 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'SLCND', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11271927 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11272366 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11273677 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11276395 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11277167 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 11278351 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 11279077 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'TELY', ExchCode = 'TOR', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11287208 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11290393 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11290394 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11290396 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11290401 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11290402 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-07', PermSecMapEndDate = '2026-04-07' WHERE SecCode = 11292823 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232927526703.0, IsPrimaryInstr = 1, Ticker = 'CFTZP' WHERE SecCode = 11293937 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'NXG RT' WHERE SecCode = 11294022 AND Type_ = 1;
