UPDATE data_universe_permid SET QuotePermID = 55838296539, Ticker = 'AAT.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 13 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531128468, Ticker = 'HONl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-16' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296006, PermQuoteStatus = 'DC', Ticker = 'ALV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838299316, PermQuoteStatus = 'DC', Ticker = 'GL9.IE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 2180 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 7851 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 31531 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 33731 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18', PermSecMapEndDate = '2021-02-10' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475562064, PermQuoteStatus = 'DC', Ticker = 'AEC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475622710, PermQuoteStatus = 'DC', Ticker = 'DSEG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 38247 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951610.0 WHERE SecCode = 38658 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21720372472, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 39906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835479948, Ticker = 'HG', ExchCode = 'PAR', PermQuoteRetireDate = '2010-08-31' WHERE SecCode = 40538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838766910, ExchCode = 'HAM', PermQuoteRetireDate = '2012-07-11' WHERE SecCode = 40670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478468816, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 40706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624654, Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 40732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034972, ExchCode = 'TDG' WHERE SecCode = 40805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475333531, ExchCode = 'MUN', PermQuoteRetireDate = '2008-01-30' WHERE SecCode = 40806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688299118, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 40818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475194877, ExchCode = 'STU', PermQuoteRetireDate = '2005-01-26' WHERE SecCode = 40933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535281474, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-11' WHERE SecCode = 41008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051132, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 41010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836546056, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 41200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475595678, ExchCode = 'MUN', PermQuoteRetireDate = '2009-07-01' WHERE SecCode = 41201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475415002, ExchCode = 'STU' WHERE SecCode = 41202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051272, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 41383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034251, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2016-05-20' WHERE SecCode = 41416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575706624, PermQuoteStatus = 'DC', ExchCode = 'MUN', PermQuoteRetireDate = '2020-03-19' WHERE SecCode = 41442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475305332, ExchCode = 'FRA' WHERE SecCode = 41457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475290166, ExchCode = 'STU' WHERE SecCode = 41512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475435930, ExchCode = 'STU', PermQuoteRetireDate = '2008-09-29' WHERE SecCode = 41583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475748139, PermQuoteStatus = 'DC', Ticker = 'PBRY.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 41715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475581769, PermQuoteStatus = 'DC', Ticker = 'KMR.I', ExchCode = 'CIR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 41818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033932, ExchCode = 'TDG' WHERE SecCode = 42034 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55839725690, Ticker = 'CM3A', ExchCode = 'BER', PermQuoteRetireDate = '2008-02-18' WHERE SecCode = 42056 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652337149, ExchCode = 'DEU', PermQuoteRetireDate = '2021-11-03' WHERE SecCode = 42067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475037021, ExchCode = 'TDG' WHERE SecCode = 42071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475750408, ExchCode = 'MUN', PermQuoteRetireDate = '2004-05-28' WHERE SecCode = 42183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475423750, Ticker = 'AL.I', ExchCode = 'CHI', PermQuoteRetireDate = '2008-02-03' WHERE SecCode = 42230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568941336, ExchCode = 'BTE' WHERE SecCode = 42265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379525, Ticker = 'INP', ExchCode = 'BRN' WHERE SecCode = 42269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535195197, Ticker = 'CPA', ExchCode = 'BRN' WHERE SecCode = 42322 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 42368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197086, Ticker = 'RY', ExchCode = 'BRN', PermQuoteRetireDate = '2017-12-29' WHERE SecCode = 42490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451921, Ticker = 'VZ', ExchCode = 'SWX' WHERE SecCode = 42536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474849493, ExchCode = 'DEU' WHERE SecCode = 43238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474887699, ExchCode = 'DEU' WHERE SecCode = 43265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475188832, ExchCode = 'MUN', PermQuoteRetireDate = '2007-02-21' WHERE SecCode = 43351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531130904, Ticker = 'MRKp', ExchCode = 'BCO', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 43401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548019894, ExchCode = 'DEU' WHERE SecCode = 43512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302063, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 43574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520627498, ExchCode = 'DEU' WHERE SecCode = 43579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519893986, ExchCode = 'STU' WHERE SecCode = 43583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474874293, ExchCode = 'DEU' WHERE SecCode = 43587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507329856, ExchCode = 'FRA' WHERE SecCode = 43597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777584291, ExchCode = 'STU' WHERE SecCode = 43705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836565430, ExchCode = 'FRA' WHERE SecCode = 44050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475759882, ExchCode = 'STU' WHERE SecCode = 44086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539585000, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 44176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381432, ExchCode = 'LAS' WHERE SecCode = 44254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852201118, ExchCode = 'GTX' WHERE SecCode = 44260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520627424, Ticker = 'CPZ1', ExchCode = 'DEU' WHERE SecCode = 44270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834249, ExchCode = 'FRA' WHERE SecCode = 44292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754193916, ExchCode = 'STU' WHERE SecCode = 44296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869550648, ExchCode = 'GTX' WHERE SecCode = 44312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599532241, ExchCode = 'DEU', PermQuoteRetireDate = '2025-07-24' WHERE SecCode = 44313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836470961, ExchCode = 'FRA' WHERE SecCode = 44395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836544492, ExchCode = 'FRA' WHERE SecCode = 44612 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035416, ExchCode = 'TDG' WHERE SecCode = 45029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528040354, PermQuoteStatus = 'DC', Ticker = 'PBCB', ExchCode = 'TDG', PermQuoteRetireDate = '2019-07-11' WHERE SecCode = 45367 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 45554 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838512918, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 45916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836496377, ExchCode = 'FRA' WHERE SecCode = 46302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033691, ExchCode = 'TDG' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474963192, Ticker = 'KKBB', ExchCode = 'DEU', PermQuoteRetireDate = '2017-07-18', PermSecMapEndDate = '2017-07-13' WHERE SecCode = 53561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642065321, ExchCode = 'TDG' WHERE SecCode = 53584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801607810, ExchCode = 'GTX' WHERE SecCode = 53597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562290755, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 54192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241011, ExchCode = 'MUN' WHERE SecCode = 54198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475436107, ExchCode = 'MUN', PermQuoteRetireDate = '2009-01-27' WHERE SecCode = 54208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475298674, ExchCode = 'MUN', PermQuoteRetireDate = '2005-01-11' WHERE SecCode = 54276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878335155, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 54337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474878425, ExchCode = 'DEU' WHERE SecCode = 54339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033686, Ticker = 'AFF', ExchCode = 'TDG', PermQuoteRetireDate = '2016-04-04' WHERE SecCode = 54367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559111051, ExchCode = 'STU', PermQuoteRetireDate = '2017-12-28' WHERE SecCode = 54371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475094302, ExchCode = 'STU' WHERE SecCode = 54398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596035518, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-18' WHERE SecCode = 54422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475143166, ExchCode = 'XIM' WHERE SecCode = 54430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475609490, Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 54512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036008, ExchCode = 'TDG' WHERE SecCode = 54540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474895146, Ticker = 'QH9', ExchCode = 'DEU' WHERE SecCode = 54545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336419, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 54552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836386351, ExchCode = 'FRA' WHERE SecCode = 54614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509793729, ExchCode = 'DEU', PermQuoteRetireDate = '2021-11-22' WHERE SecCode = 54623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035887, PermQuoteStatus = 'AC', Ticker = 'TEV', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 54655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034986, ExchCode = 'TDG' WHERE SecCode = 54668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475443138, ExchCode = 'GER', PermQuoteRetireDate = '2005-04-02' WHERE SecCode = 54708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036145, ExchCode = 'TDG' WHERE SecCode = 54728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033928, PermQuoteStatus = 'AC', Ticker = 'BRM', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 54769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133861, PermQuoteStatus = 'AC', Ticker = 'RTLd', ExchCode = 'BCO', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 54776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475296948, ExchCode = 'STU', PermQuoteRetireDate = '2005-07-19' WHERE SecCode = 54778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478511850, ExchCode = 'TDG', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 54839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646312554, ExchCode = 'TDG' WHERE SecCode = 54843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034431, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 54890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474961799, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 54931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035155, PermQuoteStatus = 'AC', Ticker = 'PHM7', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 54975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835468685, Ticker = 'VA', ExchCode = 'PAR', PermQuoteRetireDate = '2011-12-23' WHERE SecCode = 55003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475518543, ExchCode = 'BER', PermQuoteRetireDate = '2010-03-29' WHERE SecCode = 55035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324700, ExchCode = 'BER', PermQuoteRetireDate = '2010-05-04' WHERE SecCode = 55049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532933193, ExchCode = 'STU' WHERE SecCode = 55083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133281, Ticker = 'PGS1d', ExchCode = 'BCO', PermQuoteRetireDate = '2025-01-29' WHERE SecCode = 55086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474844006, Ticker = 'GTR', ExchCode = 'HAM', PermQuoteRetireDate = '2012-07-11' WHERE SecCode = 55089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475220384, ExchCode = 'GER' WHERE SecCode = 55096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490906, ExchCode = 'QTX' WHERE SecCode = 55116 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475623835, PermQuoteStatus = 'DC', Ticker = 'EARG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 55118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488034, ExchCode = 'QTX' WHERE SecCode = 55121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323313, ExchCode = 'BER' WHERE SecCode = 55142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537244841, ExchCode = 'TDG' WHERE SecCode = 55144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033953, ExchCode = 'TDG', PermQuoteRetireDate = '2016-02-01' WHERE SecCode = 55175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051088, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 55201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475365142, ExchCode = 'FRA' WHERE SecCode = 55205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475184516, ExchCode = 'STU', PermQuoteRetireDate = '2006-03-16' WHERE SecCode = 55210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338727, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 55213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474849706, ExchCode = 'DEU' WHERE SecCode = 55223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830305826, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 55234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475183770, Ticker = 'VNW', ExchCode = 'MUN', PermQuoteRetireDate = '2007-03-30' WHERE SecCode = 55248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530419744, ExchCode = 'TDG' WHERE SecCode = 55252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538164352, ExchCode = 'DEU' WHERE SecCode = 55286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475571166, PermQuoteStatus = 'DC', Ticker = 'SEBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 55351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034177, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 55385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55839470403, Ticker = 'WOWD', ExchCode = 'LSE' WHERE SecCode = 55420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475361020, Ticker = 'APW', ExchCode = 'FRA', PermQuoteRetireDate = '2007-01-16' WHERE SecCode = 55446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035914, ExchCode = 'TDG' WHERE SecCode = 55477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514772175, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 55495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531117798, Ticker = 'BBP2d', ExchCode = 'BCO', PermQuoteRetireDate = '2019-02-11' WHERE SecCode = 55517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475513537, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 55560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475515189, ExchCode = 'HAM', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 55562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475179119, ExchCode = 'GER' WHERE SecCode = 55564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836458393, ExchCode = 'FRA' WHERE SecCode = 55574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475575211, Ticker = 'SVEF.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 55577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487990, ExchCode = 'QTX' WHERE SecCode = 55581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475567213, PermQuoteStatus = 'DC', Ticker = 'PAU', ExchCode = 'STU', PermQuoteRetireDate = '2008-11-24' WHERE SecCode = 55589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033718, PermQuoteStatus = 'AC', Ticker = 'AKU1', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 55592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475430743, ExchCode = 'MUN' WHERE SecCode = 55627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475704092, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 55631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475621904, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 55656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051186, ExchCode = 'TDG' WHERE SecCode = 55657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034729, PermQuoteStatus = 'AC', Ticker = 'HCL', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 55666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051201, ExchCode = 'TDG' WHERE SecCode = 55702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475446600, ExchCode = 'GER' WHERE SecCode = 55704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475749053, Ticker = 'VIPG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 55706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475520559, Ticker = 'ALL.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 55714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475372168, ExchCode = 'BER', PermQuoteRetireDate = '2005-06-08' WHERE SecCode = 55716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515780129, ExchCode = 'MUN', PermQuoteRetireDate = '2014-03-13' WHERE SecCode = 55762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836496151, ExchCode = 'FRA', PermQuoteRetireDate = '2011-07-01' WHERE SecCode = 55770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491141, ExchCode = 'QTX' WHERE SecCode = 55948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475214238, ExchCode = 'GER' WHERE SecCode = 56044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475606530, ExchCode = 'HAN', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 56163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516194644, ExchCode = 'STU' WHERE SecCode = 56216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475750109, Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 56224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514777561, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-13' WHERE SecCode = 56247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308396, ExchCode = 'GTX' WHERE SecCode = 56256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475431208, ExchCode = 'GER', PermQuoteRetireDate = '2008-10-07' WHERE SecCode = 56393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919732556, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 56454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483123, ExchCode = 'QTX' WHERE SecCode = 56520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243527, ExchCode = 'MUN', PermQuoteRetireDate = '2008-10-06' WHERE SecCode = 56524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783641141, ExchCode = 'MUN' WHERE SecCode = 56529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034730, PermQuoteStatus = 'AC', Ticker = 'HDI', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 56533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591308334, ExchCode = 'STU' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474841626, PermQuoteStatus = 'AC', Ticker = 'CHK', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 56683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475609861, Ticker = 'AVDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 56739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531978923, ExchCode = 'TDG' WHERE SecCode = 56803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474871845, PermQuoteStatus = 'AC', Ticker = 'TFBF', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 56835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589960, Ticker = NULL, ExchCode = 'HAM', PermQuoteRetireDate = '2006-05-17' WHERE SecCode = 56894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051096, Ticker = 'AXP', ExchCode = 'TDG', PermQuoteRetireDate = '2021-07-22' WHERE SecCode = 56929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521327186, ExchCode = 'STU' WHERE SecCode = 56982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288136, ExchCode = 'FRA' WHERE SecCode = 56992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475364846, ExchCode = 'STU', PermQuoteRetireDate = '2005-12-06' WHERE SecCode = 57063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474961352, ExchCode = 'DEU' WHERE SecCode = 57072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840728137, ExchCode = 'MUN', PermQuoteRetireDate = '2013-05-21' WHERE SecCode = 57073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576812942, Ticker = '2TG', ExchCode = 'DEU', PermQuoteRetireDate = '2019-06-26' WHERE SecCode = 57098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475211473, ExchCode = 'GER', PermQuoteRetireDate = '2007-01-31' WHERE SecCode = 57541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475345677, ExchCode = 'GER' WHERE SecCode = 57571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033867, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 57597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475287482, ExchCode = 'FRA', PermQuoteRetireDate = '2007-09-26' WHERE SecCode = 57608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587014930, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 57612 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542058666, ExchCode = 'STU' WHERE SecCode = 57651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475416593, ExchCode = 'GER', PermQuoteRetireDate = '2009-05-13' WHERE SecCode = 57840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559637690, ExchCode = 'STU' WHERE SecCode = 57846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641483764, ExchCode = 'STU' WHERE SecCode = 57850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475609715, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 57884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737759339, ExchCode = 'FRA' WHERE SecCode = 57889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517019505, ExchCode = 'DUS' WHERE SecCode = 58052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21484713079, ExchCode = 'STU' WHERE SecCode = 58060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034885, ExchCode = 'TDG' WHERE SecCode = 58062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475745773, ExchCode = 'STU' WHERE SecCode = 58064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327177, ExchCode = 'BER', PermQuoteRetireDate = '2020-08-10' WHERE SecCode = 58140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033816, ExchCode = 'TDG' WHERE SecCode = 58160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475571086, PermQuoteStatus = 'DC', Ticker = 'REPG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 58416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325924, ExchCode = 'BER', PermQuoteRetireDate = '2010-07-30' WHERE SecCode = 58485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322890, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 58512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332422, ExchCode = 'BER' WHERE SecCode = 58521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475292810, ExchCode = 'BER', PermQuoteRetireDate = '2005-08-12' WHERE SecCode = 58545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475315085, ExchCode = 'BER', PermQuoteRetireDate = '2006-08-30' WHERE SecCode = 58554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035689, ExchCode = 'TDG', PermQuoteRetireDate = '2012-05-10' WHERE SecCode = 58558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535412623, ExchCode = 'STU' WHERE SecCode = 58729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797548524, ExchCode = 'STU' WHERE SecCode = 58734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539181244, ExchCode = 'GER', PermQuoteRetireDate = '2015-10-23' WHERE SecCode = 58756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789195685, ExchCode = 'STU', PermQuoteRetireDate = '2024-02-21', PermSecMapEndDate = '2024-02-21' WHERE SecCode = 58804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621219277, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 58930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475443568, ExchCode = 'STU', PermQuoteRetireDate = '2010-02-03' WHERE SecCode = 59024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051172, ExchCode = 'TDG' WHERE SecCode = 59028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035645, PermQuoteStatus = 'AC', Ticker = 'SNW', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 59041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530337676, ExchCode = 'STU' WHERE SecCode = 59096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475562924, Ticker = 'ASD.I', ExchCode = 'COO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 59115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475622195, PermQuoteStatus = 'DC', Ticker = 'VANG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 59249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551434932, ExchCode = 'TDG' WHERE SecCode = 59466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419000, ExchCode = 'LAS' WHERE SecCode = 59618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808950925, ExchCode = 'FRA' WHERE SecCode = 59806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512093309, ExchCode = 'STU' WHERE SecCode = 59853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475317830, ExchCode = 'GER' WHERE SecCode = 59872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699373266, ExchCode = 'DEU' WHERE SecCode = 59881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475436169, ExchCode = 'STU' WHERE SecCode = 59906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474849847, ExchCode = 'DEU' WHERE SecCode = 59920 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492066, ExchCode = 'QTX', PermQuoteRetireDate = '2023-03-07' WHERE SecCode = 59963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838414562, ExchCode = 'STU', PermQuoteRetireDate = '2016-03-01' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804714594, PermQuoteStatus = 'AC', Ticker = 'PAJA', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363120, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 60070 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475457916, PermQuoteRetireDate = '2005-10-03' WHERE SecCode = 60090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589872687, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-17' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401370, ExchCode = 'DXE' WHERE SecCode = 60267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531132175, Ticker = 'NSUd', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856728229, ExchCode = 'TDG' WHERE SecCode = 60667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339451, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215725, ExchCode = 'FRA' WHERE SecCode = 63138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475548758, Ticker = 'NCOD.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 63145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475565837, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2008-07-07', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 63146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490111, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 63251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475765841, ExchCode = 'FRA', PermQuoteRetireDate = '2016-10-21' WHERE SecCode = 63292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337711, ExchCode = 'BER', PermQuoteRetireDate = '2016-06-30' WHERE SecCode = 63293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338776, ExchCode = 'BER', PermQuoteRetireDate = '2008-01-05' WHERE SecCode = 63319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475082140, ExchCode = 'STU' WHERE SecCode = 63324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330556, ExchCode = 'BER', PermQuoteRetireDate = '2016-12-07' WHERE SecCode = 63332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475745519, ExchCode = 'MUN', PermQuoteRetireDate = '2010-02-16' WHERE SecCode = 63460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285125, ExchCode = 'GTX' WHERE SecCode = 63567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474904485, ExchCode = 'DEU' WHERE SecCode = 63684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475446081, ExchCode = 'FRA' WHERE SecCode = 63686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503798483, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 63693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051144, ExchCode = 'TDG', PermQuoteRetireDate = '2019-08-09' WHERE SecCode = 63694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475102340, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 63757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339751, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 63767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615370664, ExchCode = 'STU' WHERE SecCode = 63841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836559611, ExchCode = 'FRA', PermQuoteRetireDate = '2012-01-05' WHERE SecCode = 63854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855827473, ExchCode = 'GER', PermQuoteRetireDate = '2022-05-23' WHERE SecCode = 63877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785979676, ExchCode = 'FRA' WHERE SecCode = 63882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624943856, ExchCode = 'STU' WHERE SecCode = 63905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475353324, ExchCode = 'STU' WHERE SecCode = 63915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035642, ExchCode = 'TDG', PermQuoteRetireDate = '2022-12-16', PermSecMapEndDate = NULL WHERE SecCode = 63933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679702, ExchCode = 'DEU' WHERE SecCode = 63936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774179923, PermQuoteStatus = 'AC', Ticker = 'VCT0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 63954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474872894, ExchCode = 'DEU' WHERE SecCode = 63957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776251714, Ticker = 'TRB', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-24' WHERE SecCode = 63973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789408176, ExchCode = 'FRA' WHERE SecCode = 63982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838803618, Ticker = NULL, ExchCode = 'ATH', PermQuoteRetireDate = '2022-11-18' WHERE SecCode = 63991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487556, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 63995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035790, Ticker = 'QNMA', ExchCode = 'TDG', PermQuoteRetireDate = '2016-09-09' WHERE SecCode = 64028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533309420, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 64049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504953554, ExchCode = 'GER', PermQuoteRetireDate = '2013-01-15' WHERE SecCode = 64078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616627259, ExchCode = 'DEU', PermQuoteRetireDate = '2019-12-05', PermSecMapEndDate = '2019-12-05' WHERE SecCode = 64093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476124466, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 64125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646692462, ExchCode = 'STU' WHERE SecCode = 64139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475287223, ExchCode = 'HAN', PermQuoteRetireDate = '2004-04-23' WHERE SecCode = 64165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506910241, Ticker = 'GTJ2', PermQuoteRetireDate = '2015-11-20' WHERE SecCode = 64174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241776, ExchCode = 'MUN' WHERE SecCode = 64190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047440, ExchCode = 'MUN' WHERE SecCode = 64213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564885286, PermQuoteStatus = 'AC', Ticker = 'HEC0', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 64215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594955070, ExchCode = 'TDG' WHERE SecCode = 64219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521224635, ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 64220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475190573, ExchCode = 'MUN' WHERE SecCode = 64222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474870696, ExchCode = 'DEU' WHERE SecCode = 64223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547360083, ExchCode = 'STU', PermQuoteRetireDate = '2022-11-18', PermSecMapEndDate = NULL WHERE SecCode = 64228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838619161, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 64256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475225539, ExchCode = 'GER' WHERE SecCode = 64307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336953, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 64314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335125, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 64315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475570508, PermQuoteStatus = 'DC', Ticker = 'RPLG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 64330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529683236, PermQuoteStatus = 'DC', Ticker = 'AJ81', ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 64365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474878291, ExchCode = 'DEU' WHERE SecCode = 64369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383588, ExchCode = 'DEU' WHERE SecCode = 64407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474846133, ExchCode = 'DEU' WHERE SecCode = 64422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840890510, ExchCode = 'FRA' WHERE SecCode = 64431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520470, ExchCode = 'DEU' WHERE SecCode = 64435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521225233, PermQuoteStatus = 'AC', Ticker = 'HVP0', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 64448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035327, ExchCode = 'TDG', PermQuoteRetireDate = '2025-06-02' WHERE SecCode = 64496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475792943, ExchCode = 'TDG' WHERE SecCode = 64503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326169, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 64512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475084580, ExchCode = 'FRA', PermQuoteRetireDate = '2013-03-08' WHERE SecCode = 64524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524374191, ExchCode = 'STU' WHERE SecCode = 64536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847717670, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 64654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475453225, ExchCode = 'STU' WHERE SecCode = 64659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647732067, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 64671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475524097, Ticker = 'NAM', ExchCode = 'MUN', PermQuoteRetireDate = '2009-12-18' WHERE SecCode = 64713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475190316, ExchCode = 'BER', PermQuoteRetireDate = '2007-08-07' WHERE SecCode = 64721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526206229, ExchCode = 'BER', PermQuoteRetireDate = '2022-08-18', PermSecMapEndDate = '2022-08-18' WHERE SecCode = 64727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036172, ExchCode = 'TDG' WHERE SecCode = 64728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475590254, Ticker = 'VDSI.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 64741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474839949, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 64761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475183993, ExchCode = 'BER', PermQuoteRetireDate = '2006-06-29' WHERE SecCode = 64789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475610158, Ticker = 'SPJG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 64845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474896593, PermQuoteStatus = 'AC', Ticker = 'EFO3', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 64863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475177812, ExchCode = 'FRA' WHERE SecCode = 64974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531130978, Ticker = 'MSFa', ExchCode = 'BCO', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 65004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705260424, PermQuoteStatus = 'DC', Ticker = 'SS91', ExchCode = 'STU', PermQuoteRetireDate = '2024-04-11' WHERE SecCode = 65007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474852171, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 65011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339033, ExchCode = 'BER' WHERE SecCode = 65024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474961764, ExchCode = 'DEU' WHERE SecCode = 65025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474843645, Ticker = 'SHP5', ExchCode = 'DEU', PermQuoteRetireDate = '2022-07-01' WHERE SecCode = 65029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478511422, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 65032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492514589, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 65035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033488, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 65078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531478664, ExchCode = 'DEU' WHERE SecCode = 65089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836503837, ExchCode = 'FRA', PermQuoteRetireDate = '2026-02-26' WHERE SecCode = 65092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475875223, ExchCode = 'TDG', PermQuoteRetireDate = '2019-01-08' WHERE SecCode = 65107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848877680, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 65135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475251974, ExchCode = 'BER' WHERE SecCode = 65143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475308427, ExchCode = 'MUN', PermQuoteRetireDate = '2006-01-12' WHERE SecCode = 65207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836401152, ExchCode = 'FRA' WHERE SecCode = 65314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475443285, ExchCode = 'MUN', PermQuoteRetireDate = '2008-12-01' WHERE SecCode = 65327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663166850, ExchCode = 'FRA' WHERE SecCode = 65358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 65368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743255311, ExchCode = 'TDG', PermQuoteRetireDate = '2021-07-15' WHERE SecCode = 65393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474863818, ExchCode = 'DEU' WHERE SecCode = 65419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838220198, Ticker = 'NOKA', ExchCode = 'AEX', PermQuoteRetireDate = '2015-11-12' WHERE SecCode = 65470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589740, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2008-02-19' WHERE SecCode = 65521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325589, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 65526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327940, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-10' WHERE SecCode = 65529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429055, ExchCode = 'SIG', PermSecMapStartDate = '2026-04-08' WHERE SecCode = 65541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474889561, ExchCode = 'DEU' WHERE SecCode = 65586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475616740, ExchCode = 'GER' WHERE SecCode = 65641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487385255, ExchCode = 'STU', PermQuoteRetireDate = '2019-02-06' WHERE SecCode = 65643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474912087, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 65657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324104, ExchCode = 'BER' WHERE SecCode = 65807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533744295, ExchCode = 'TDG' WHERE SecCode = 65894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612598804, ExchCode = 'STU', PermQuoteRetireDate = '2018-03-20', PermSecMapEndDate = '2018-03-13' WHERE SecCode = 65963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538261141, ExchCode = 'FRA' WHERE SecCode = 65990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333497, ExchCode = 'BER' WHERE SecCode = 66026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474885197, ExchCode = 'DEU' WHERE SecCode = 66058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531478149, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 66139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21484717310, ExchCode = 'TDG' WHERE SecCode = 66166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709020879, ExchCode = 'FRA' WHERE SecCode = 66191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331626, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 66192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836390596, ExchCode = 'FRA' WHERE SecCode = 66201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836473503, Ticker = 'LJP2', ExchCode = 'FRA', PermQuoteRetireDate = '2012-02-28' WHERE SecCode = 66228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571803984, Ticker = 'CGEd', ExchCode = 'BCO', PermQuoteRetireDate = '2017-03-30' WHERE SecCode = 66263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655821566, ExchCode = 'DEU' WHERE SecCode = 66265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035704, ExchCode = 'TDG' WHERE SecCode = 66279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22155211005, ExchCode = 'DEU' WHERE SecCode = 66281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838570857, ExchCode = 'STU', PermQuoteRetireDate = '2015-04-13' WHERE SecCode = 66357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492771, ExchCode = 'QTX', PermQuoteRetireDate = '2023-04-17', PermSecMapEndDate = '2023-04-17' WHERE SecCode = 66382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241404, ExchCode = 'MUN' WHERE SecCode = 66385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272844, ExchCode = 'GTX' WHERE SecCode = 66493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324715, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 66530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339510, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 66532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836551140, ExchCode = 'FRA' WHERE SecCode = 66547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475344126, ExchCode = 'GER' WHERE SecCode = 66674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856303, ExchCode = 'DEU' WHERE SecCode = 66913 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 73423 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21476459696, PermQuoteStatus = 'DC', Ticker = '4338.H', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 76509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476459694, PermQuoteStatus = 'DC', Ticker = '4336.H', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 76513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509913517, Ticker = '4363.H', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 79980 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'XLPID' WHERE SecCode = 82755 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 83933 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 87218 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616156315, ExchCode = 'MCX' WHERE SecCode = 100947 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 101286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838736430, Ticker = 'XPBR', ExchCode = 'LAT' WHERE SecCode = 102966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838736398, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 103013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609211565, ExchCode = 'TDG' WHERE SecCode = 103792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341666, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 103840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836418073, ExchCode = 'FRA' WHERE SecCode = 103841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335490, ExchCode = 'BER' WHERE SecCode = 103863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273756, ExchCode = 'GTX' WHERE SecCode = 104270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513801692, Ticker = 'OFC', ExchCode = 'STU', PermQuoteRetireDate = '2015-07-03' WHERE SecCode = 111691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836559542, ExchCode = 'FRA', PermQuoteRetireDate = '2025-04-02' WHERE SecCode = 111847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794818049, ExchCode = 'DEU' WHERE SecCode = 111858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359282, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 111866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517582825, ExchCode = 'STU' WHERE SecCode = 111867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838237040, ExchCode = 'MUN' WHERE SecCode = 111869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856943909, Ticker = '6MI', ExchCode = 'STU', PermQuoteRetireDate = '2011-12-19' WHERE SecCode = 111924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821670376, ExchCode = 'QTX', PermQuoteRetireDate = '2023-06-14' WHERE SecCode = 111938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241914, ExchCode = 'MUN' WHERE SecCode = 112025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589493827, ExchCode = 'STU', PermQuoteRetireDate = '2025-12-19' WHERE SecCode = 112035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295813, ExchCode = 'GTX' WHERE SecCode = 112043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475720660, ExchCode = 'GER' WHERE SecCode = 112149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475544095, ExchCode = 'FRA' WHERE SecCode = 112152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846128372, ExchCode = 'FRA', PermQuoteRetireDate = '2011-09-27' WHERE SecCode = 112218 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627587771, ExchCode = 'DEU' WHERE SecCode = 112228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285133, ExchCode = 'FRA' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704207, ExchCode = 'MXQ' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700183753, ExchCode = 'MXQ' WHERE SecCode = 113051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475030105, ExchCode = 'FRA' WHERE SecCode = 113614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381665, ExchCode = 'LAS' WHERE SecCode = 113656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575930915, ExchCode = 'FRA' WHERE SecCode = 113659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336807, ExchCode = 'FRA' WHERE SecCode = 113809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328976, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 113864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272816, ExchCode = 'GTX' WHERE SecCode = 113978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333992, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-01', PermSecMapEndDate = '2022-07-01' WHERE SecCode = 113979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340228, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26', PermSecMapEndDate = '2024-09-26' WHERE SecCode = 114128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836480168, ExchCode = 'FRA', PermQuoteRetireDate = '2012-08-03' WHERE SecCode = 114129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333476, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26', PermSecMapEndDate = '2024-09-26' WHERE SecCode = 114130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332694, ExchCode = 'BER', PermQuoteRetireDate = '2022-04-28', PermSecMapEndDate = '2022-04-28' WHERE SecCode = 114132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333890, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26', PermSecMapEndDate = '2024-09-26' WHERE SecCode = 114133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836480715, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2011-04-11', PermSecMapEndDate = '2024-09-26' WHERE SecCode = 114136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332433, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 114138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492380, ExchCode = 'QTX' WHERE SecCode = 114141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836480160, ExchCode = 'FRA' WHERE SecCode = 114162 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474870209, ExchCode = 'DEU' WHERE SecCode = 114455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727155, ExchCode = 'TDG', PermQuoteRetireDate = '2023-03-29' WHERE SecCode = 114476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474965294, ExchCode = 'MAD', PermQuoteRetireDate = '2010-10-02' WHERE SecCode = 114943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22118201106, ExchCode = 'DEU' WHERE SecCode = 115232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590303334, ExchCode = 'FRA' WHERE SecCode = 115234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474928708, ExchCode = 'JNX' WHERE SecCode = 115378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529525719, ExchCode = 'STU', PermQuoteRetireDate = '2019-01-09' WHERE SecCode = 115464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785486228, ExchCode = 'FRA' WHERE SecCode = 115623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587383841, ExchCode = 'FRA' WHERE SecCode = 115779 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 117168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298391, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660136963, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2023-02-03' WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525931704, ExchCode = 'STU' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475008736, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474929225, ExchCode = 'DEU', PermQuoteRetireDate = '2019-01-08' WHERE SecCode = 118148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488397, ExchCode = 'QTX' WHERE SecCode = 119129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705696, ExchCode = 'MXQ' WHERE SecCode = 121226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705396, ExchCode = 'MXQ' WHERE SecCode = 121615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704294, ExchCode = 'MXQ' WHERE SecCode = 121616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705298, ExchCode = 'MXQ' WHERE SecCode = 121619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434487, ExchCode = 'LAS' WHERE SecCode = 122073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475080320, ExchCode = 'FRA' WHERE SecCode = 122888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838626835, ExchCode = 'STU', PermQuoteRetireDate = '2009-09-03' WHERE SecCode = 122890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22097037081, ExchCode = 'MXQ' WHERE SecCode = 122907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835814077, ExchCode = 'MEX' WHERE SecCode = 122909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835813052, ExchCode = 'MEX' WHERE SecCode = 122911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705487, ExchCode = 'MXQ' WHERE SecCode = 122914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835813466, ExchCode = 'MEX' WHERE SecCode = 122927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705816, ExchCode = 'MXQ' WHERE SecCode = 122931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706104, ExchCode = 'MXQ' WHERE SecCode = 122934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803403425, ExchCode = 'FRA' WHERE SecCode = 124108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329559, ExchCode = 'BER' WHERE SecCode = 124115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55839747930, ExchCode = 'FRA' WHERE SecCode = 124562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528684368, ExchCode = 'TDG', PermQuoteRetireDate = '2014-10-27' WHERE SecCode = 124574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835819889, ExchCode = 'MEX' WHERE SecCode = 124579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679371, ExchCode = 'BIV' WHERE SecCode = 124586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556336781, ExchCode = 'STU' WHERE SecCode = 124617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838515728, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 130530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885457531, ExchCode = 'STU' WHERE SecCode = 131497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475129817, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 131865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475631053, ExchCode = 'FRA', PermQuoteRetireDate = '2006-05-10' WHERE SecCode = 132168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529040359, ExchCode = 'STU' WHERE SecCode = 132188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21485575397, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 132593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792941430, ExchCode = 'FRA' WHERE SecCode = 132606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475008417, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 132611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536966476, ExchCode = 'STU' WHERE SecCode = 132708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474851270, ExchCode = 'DEU' WHERE SecCode = 132787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610036121, PermQuoteStatus = 'DC', Ticker = 'UH4', ExchCode = 'TDG', PermQuoteRetireDate = '2019-03-18', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 132790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514186845, ExchCode = 'STU' WHERE SecCode = 132792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538295457, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 132852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484045, PermQuoteStatus = 'DC', Ticker = 'DTI', ExchCode = 'QTX', PermQuoteRetireDate = '2021-03-12' WHERE SecCode = 132877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492896698, ExchCode = 'STU' WHERE SecCode = 132945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474836980, ExchCode = 'DEU' WHERE SecCode = 133027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947053569, ExchCode = 'DEU' WHERE SecCode = 133153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954131052, ExchCode = 'DEU' WHERE SecCode = 133163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475312008, PermQuoteStatus = 'AC', Ticker = 'GPI1', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 133226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526528181, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 133354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795104269, ExchCode = 'QTX' WHERE SecCode = 133778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331577, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 137364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801211984, ExchCode = 'HAM' WHERE SecCode = 137417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625198385, ExchCode = 'DEU' WHERE SecCode = 137437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599860013, ExchCode = 'TDG', PermQuoteRetireDate = '2024-04-10', PermSecMapEndDate = '2024-04-10' WHERE SecCode = 137668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21728401545, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 137669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836418088, ExchCode = 'FRA' WHERE SecCode = 137682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842886562, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 137794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22166504723, ExchCode = 'DEU' WHERE SecCode = 137820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516376146, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-19' WHERE SecCode = 137873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556785810, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-24' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 139759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591385, ExchCode = 'DEU' WHERE SecCode = 140677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21484038403, ExchCode = 'MUN' WHERE SecCode = 141107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962594881, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 141169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901489652, ExchCode = 'GTX' WHERE SecCode = 141172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475140561, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 141175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835815171, ExchCode = 'MEX' WHERE SecCode = 141450 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 141647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610380000, ExchCode = 'FRA' WHERE SecCode = 142150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336503, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 142154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623811909, ExchCode = 'FRA' WHERE SecCode = 142191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615119219, ExchCode = 'FRA' WHERE SecCode = 142223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21727351962, ExchCode = 'DEU' WHERE SecCode = 142224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572615818, ExchCode = 'FRA' WHERE SecCode = 142384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537344593, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 142505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885909284, ExchCode = 'STU' WHERE SecCode = 142718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475009275, ExchCode = 'DEU' WHERE SecCode = 142742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625977903, ExchCode = 'DEU' WHERE SecCode = 142826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588166916, ExchCode = 'FRA' WHERE SecCode = 142944 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825607984, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-19' WHERE SecCode = 143730 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790170765, Ticker = 'IPC', ExchCode = 'LSE' WHERE SecCode = 143961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429051, ExchCode = 'SIG', PermSecMapStartDate = '2026-04-08' WHERE SecCode = 144767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569877, ExchCode = 'QTX' WHERE SecCode = 144797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836049376, Ticker = 'HYXS', ExchCode = 'LSE', PermQuoteRetireDate = '2011-03-29' WHERE SecCode = 145816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547457028, ExchCode = 'STU' WHERE SecCode = 145923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640507311, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 146103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340455, ExchCode = 'BER' WHERE SecCode = 146127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537004604, ExchCode = 'DEU' WHERE SecCode = 146151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542388498, ExchCode = 'STU' WHERE SecCode = 146155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836051528, Ticker = 'GCLS', ExchCode = 'LSE', PermQuoteRetireDate = '2011-02-08' WHERE SecCode = 146851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294415, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 147388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790478897, ExchCode = 'FRA' WHERE SecCode = 147554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915101968, ExchCode = 'DEU' WHERE SecCode = 147555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726460310, ExchCode = 'FRA' WHERE SecCode = 147556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915101908, ExchCode = 'DEU' WHERE SecCode = 147559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328928, ExchCode = 'BER', PermQuoteRetireDate = '2016-09-22' WHERE SecCode = 147560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336583, ExchCode = 'BER' WHERE SecCode = 147562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522077518, ExchCode = 'FRA' WHERE SecCode = 147569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336780, ExchCode = 'DEU' WHERE SecCode = 147570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534005004, ExchCode = 'MUN', PermQuoteRetireDate = '2025-12-04' WHERE SecCode = 147805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679444829, ExchCode = 'STU', PermQuoteRetireDate = '2024-03-12', PermSecMapEndDate = '2024-03-21' WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 161412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528681544, ExchCode = 'NQX', PermQuoteRetireDate = '2010-07-02' WHERE SecCode = 164836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21578072857, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 175239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810854712, ExchCode = 'FRA' WHERE SecCode = 177325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856949141, ExchCode = 'FRA' WHERE SecCode = 177328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926842, ExchCode = 'FRA' WHERE SecCode = 177340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858577, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28', PermSecMapEndDate = '2024-03-28' WHERE SecCode = 177409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837357816, ExchCode = 'GER' WHERE SecCode = 177415 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951610.0 WHERE SecCode = 177480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475530491, ExchCode = 'STU' WHERE SecCode = 177675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327818, ExchCode = 'BER', PermQuoteRetireDate = '2021-08-23' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126226638, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560429859, ExchCode = 'DEU' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679752, ExchCode = 'FRA' WHERE SecCode = 178849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535118681, ExchCode = 'DEU' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782121639, ExchCode = 'FRA' WHERE SecCode = 187719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475135121, ExchCode = 'MUN', PermQuoteRetireDate = '2024-12-27' WHERE SecCode = 187830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491975, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 195530 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 196399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484082, ExchCode = 'QTX' WHERE SecCode = 197050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475906502, ExchCode = 'STU' WHERE SecCode = 201597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835814655, ExchCode = 'MEX' WHERE SecCode = 201842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531927275, ExchCode = 'MEX' WHERE SecCode = 201875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22095615019, ExchCode = 'DEU' WHERE SecCode = 201937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502336043, ExchCode = 'STU' WHERE SecCode = 201945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509902864, Ticker = 'SOYP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 202732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387779, ExchCode = 'LAS' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675875, ExchCode = 'BIV' WHERE SecCode = 214889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512042331, ExchCode = 'TDG' WHERE SecCode = 249211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475835886, ExchCode = 'BER', PermQuoteRetireDate = '2012-09-21' WHERE SecCode = 249274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565082887, ExchCode = 'FRA' WHERE SecCode = 249293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474925265, ExchCode = 'DEU' WHERE SecCode = 249354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474978939, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-20' WHERE SecCode = 249365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331035, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 249718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429054, ExchCode = 'SIG', PermSecMapStartDate = '2026-04-08' WHERE SecCode = 249766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525576964, ExchCode = 'TDG' WHERE SecCode = 249828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475454256, ExchCode = 'GER' WHERE SecCode = 249855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835778048, Ticker = '85C', ExchCode = 'DUS' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645193106, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 255144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474900132, ExchCode = 'DEU' WHERE SecCode = 283709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469734, ExchCode = 'QTX' WHERE SecCode = 292366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794261329, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 302153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794768749, PermQuoteStatus = 'AC', Ticker = 'CESVF', ExchCode = 'GTC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-08-22', PermSecMapEndDate = NULL WHERE SecCode = 309283 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836320719, ExchCode = 'BER' WHERE SecCode = 312932 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401378, ExchCode = 'DXE', PermSecMapStartDate = '2026-04-07' WHERE SecCode = 313548 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'JSYSF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-08', PermSecMapEndDate = NULL WHERE SecCode = 323673 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21585875044, ExchCode = 'STU' WHERE SecCode = 325643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520192969, ExchCode = 'STU' WHERE SecCode = 327144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164720656, ExchCode = 'DEU' WHERE SecCode = 335262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561687455, ExchCode = 'TDG', PermQuoteRetireDate = '2022-12-08' WHERE SecCode = 336764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550085567, ExchCode = 'HAM' WHERE SecCode = 337400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401380, ExchCode = 'DXE', PermSecMapStartDate = '2026-04-07' WHERE SecCode = 340550 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 345722 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21783662836, Ticker = 'VGPk', ExchCode = 'TQE' WHERE SecCode = 346537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705243, ExchCode = 'MXQ' WHERE SecCode = 349684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475450750, ExchCode = 'GER' WHERE SecCode = 363753 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 372861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704399, ExchCode = 'MXQ' WHERE SecCode = 383039 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 384508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834672639, Ticker = '0O9H', ExchCode = 'LSE', PermQuoteRetireDate = '2013-03-25' WHERE SecCode = 397851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673103, Ticker = '0FDW', ExchCode = 'LSE', PermQuoteRetireDate = '2017-03-07' WHERE SecCode = 407812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582412675, ExchCode = 'DEU' WHERE SecCode = 409650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841613018, ExchCode = 'MEX' WHERE SecCode = 409684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492119, PermQuoteStatus = 'DC', Ticker = 'TRC1', ExchCode = 'QTX', PermQuoteRetireDate = '2024-10-03' WHERE SecCode = 415856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842974618, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 421788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843288026, ExchCode = 'BER' WHERE SecCode = 424919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294005, ExchCode = 'GTX' WHERE SecCode = 427679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850199553, Ticker = '0KL3', ExchCode = 'LSE', PermQuoteRetireDate = '2011-09-09' WHERE SecCode = 427894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396938, ExchCode = 'DEU' WHERE SecCode = 428966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859809742, ExchCode = 'UAX', PermQuoteRetireDate = '2015-12-08' WHERE SecCode = 433814 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308332, ExchCode = 'GTX' WHERE SecCode = 434993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477787209, ExchCode = 'TDG' WHERE SecCode = 435796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21600289193, ExchCode = 'DUS', PermQuoteRetireDate = '2023-12-15', PermSecMapEndDate = NULL WHERE SecCode = 438364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684824, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 439455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845177678, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 442574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846123779, ExchCode = 'BER', PermQuoteRetireDate = '2015-07-30' WHERE SecCode = 456391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841619375, ExchCode = 'MEX' WHERE SecCode = 462658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847014207, Ticker = 'BXX', ExchCode = 'MIL' WHERE SecCode = 464174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858584221, Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518886, ExchCode = 'DUS', PermQuoteRetireDate = '2020-12-15' WHERE SecCode = 471738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010413709, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847283501, ExchCode = 'LSE' WHERE SecCode = 481044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952621493, ExchCode = 'TDG' WHERE SecCode = 484491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475021715, ExchCode = 'FRA' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616157068, ExchCode = 'MCX' WHERE SecCode = 500487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475073605, Ticker = '0OE0', ExchCode = 'LSE', PermQuoteRetireDate = '2011-02-04' WHERE SecCode = 501839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848865465, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 503830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627494176, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-12-16', PermSecMapEndDate = '2019-12-17' WHERE SecCode = 503842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849266247, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 507407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849448689, ExchCode = 'MEX' WHERE SecCode = 508999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834675802, Ticker = '0O9J', ExchCode = 'LSE', PermQuoteRetireDate = '2016-06-10' WHERE SecCode = 512425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849477549, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 513278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475860102, ExchCode = 'BER' WHERE SecCode = 513937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849681521, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 514961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692101709, ExchCode = 'MUN' WHERE SecCode = 515043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388527, Ticker = 'PAXA.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 515577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851531713, ExchCode = 'GER' WHERE SecCode = 515658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837437193, Ticker = 'AIGE', ExchCode = 'MIL' WHERE SecCode = 521423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835439836, PermQuoteStatus = 'AC', Ticker = 'CRUDP', ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 521464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077517, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 521905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214201, ExchCode = 'BIV' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850896054, ExchCode = 'FRA', PermQuoteRetireDate = '2020-05-22' WHERE SecCode = 532767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480578, ExchCode = 'QTX', PermQuoteRetireDate = '2020-09-01' WHERE SecCode = 532772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543053439, Ticker = '8EC', ExchCode = 'STU', PermQuoteRetireDate = '2023-09-05' WHERE SecCode = 533384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856295357, ExchCode = 'STU' WHERE SecCode = 534603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519097, ExchCode = 'DUS' WHERE SecCode = 535314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478699, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-09', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 535506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851859830, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 539328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581478612, ExchCode = 'HAM' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522030496, ExchCode = 'TDG' WHERE SecCode = 541495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856846841, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 541974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035999, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2015-08-14' WHERE SecCode = 542320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531115545, Ticker = '324d', ExchCode = 'BCO', PermQuoteRetireDate = '2018-01-22' WHERE SecCode = 542445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807916878, ExchCode = 'TDG' WHERE SecCode = 542943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835813082, ExchCode = 'MEX', PermSecMapEndDate = NULL WHERE SecCode = 544311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852995454, ExchCode = 'FRA' WHERE SecCode = 548626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851510082, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 549537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531427744, ExchCode = 'STU' WHERE SecCode = 550860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531126587, ExchCode = 'BCO', PermQuoteRetireDate = '2020-07-16' WHERE SecCode = 554481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429048, ExchCode = 'SIG', PermSecMapStartDate = '2026-04-08' WHERE SecCode = 554690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471152, ExchCode = 'GTX' WHERE SecCode = 556254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474957849, ExchCode = 'DEU' WHERE SecCode = 557818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475855781, ExchCode = 'TDG' WHERE SecCode = 557995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856606623, ExchCode = 'FRA' WHERE SecCode = 559437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21580811071, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 560139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679918574, Ticker = 'ETFC*', ExchCode = 'MXQ' WHERE SecCode = 560263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856960400, ExchCode = 'FRA' WHERE SecCode = 561861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512281634, ExchCode = 'TRQ' WHERE SecCode = 563059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294098, ExchCode = 'GTX' WHERE SecCode = 563087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857746346, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 564353 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 564492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475108946, ExchCode = 'STU' WHERE SecCode = 565316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857657672, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 565330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857740936, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 565707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601873557, ExchCode = 'TDG' WHERE SecCode = 565752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035735, ExchCode = 'TDG' WHERE SecCode = 566694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851903472, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 572386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379754, ExchCode = 'LAS' WHERE SecCode = 593055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859005912, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 593132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859254285, ExchCode = 'FRA', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 599978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293928, InstrPermID = 8591391476, OrgPermID = 5000663094, ValQuotePermID = 55858425773.0, PriInstrPermID = 8591391476.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'ANK', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermOrgIPODate = '2010-04-01' WHERE SecCode = 601515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255779, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802542707, ExchCode = 'FRA' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475859202, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22132756017, ExchCode = 'STO' WHERE SecCode = 602882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847342799, ExchCode = 'MUN' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991501, ExchCode = 'STU' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581498976, ExchCode = 'MUN' WHERE SecCode = 701753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290783, ExchCode = 'DUS' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749996718, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 826159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780160052, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 827254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428184, ExchCode = 'GTX' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 853945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550079029, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 863481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830276525, ExchCode = 'GTX' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779809732, ExchCode = 'GTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492656, ExchCode = 'QTX' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 940758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785297550, ExchCode = 'QTX' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800222853, ExchCode = 'FRA' WHERE SecCode = 1017380 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1142124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514433429, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1447851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625073340, ExchCode = 'FRA' WHERE SecCode = 1453709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391706, ExchCode = 'GTX' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478615946, ExchCode = 'STO' WHERE SecCode = 1465275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798768605, ExchCode = 'HAM' WHERE SecCode = 1468807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742468, ExchCode = 'HAN' WHERE SecCode = 1472577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480227394, ExchCode = 'STU', PermQuoteRetireDate = '2013-05-20' WHERE SecCode = 1479224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478367, ExchCode = 'QTX' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481623767, ExchCode = 'DEU' WHERE SecCode = 1482803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488606, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490163342, ExchCode = 'STU', PermQuoteRetireDate = '2014-03-06' WHERE SecCode = 1489390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704200, ExchCode = 'MXQ' WHERE SecCode = 1489564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109485, ExchCode = 'FRA' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652933092, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483930016, ExchCode = 'FRA' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591674214, ExchCode = 'TDG' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368530, Ticker = 'PU7D', ExchCode = 'SES', PermQuoteRetireDate = '2018-09-12' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486671125, ExchCode = 'STU' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514028112, ExchCode = 'TDG' WHERE SecCode = 1522268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850857936, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179775, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646545320, PermQuoteStatus = 'DC', Ticker = '5EV', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 1525470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152677, ExchCode = 'MUN' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098687, ExchCode = 'DEU' WHERE SecCode = 1527502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490958523, ExchCode = 'FRA' WHERE SecCode = 1531694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480768, ExchCode = 'QTX' WHERE SecCode = 1532769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535039956, ExchCode = 'STU' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529849881, Ticker = 'RBT', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1533786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067014491, ExchCode = 'DEU' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273313, ExchCode = 'GTX' WHERE SecCode = 1537214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379929, ExchCode = 'LAS' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494267747, ExchCode = 'FRA' WHERE SecCode = 1541369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480207, PermQuoteStatus = 'DC', Ticker = '7NU', ExchCode = 'QTX', PermQuoteRetireDate = '2023-08-03', PermSecMapEndDate = '2025-06-13' WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796520014, ExchCode = 'GTX' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496864672, ExchCode = 'DEU' WHERE SecCode = 1546652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893351, ExchCode = 'STU' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802875945, ExchCode = 'LAS' WHERE SecCode = 1547496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650254, ExchCode = 'DUS' WHERE SecCode = 1552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802455291, ExchCode = 'FRA' WHERE SecCode = 1553832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498302420, ExchCode = 'DEU' WHERE SecCode = 1555173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502328853, ExchCode = 'FRA' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461757, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-04' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479450, ExchCode = 'QTX' WHERE SecCode = 1584599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524609219, ExchCode = 'BTE' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308500, ExchCode = 'FRA' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704832, ExchCode = 'MXQ' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505184781, ExchCode = 'STO' WHERE SecCode = 1596529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515927789, ExchCode = 'DEU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553068247, ExchCode = 'TDG' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506574448, ExchCode = 'MUN' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705694, ExchCode = 'MXQ' WHERE SecCode = 1621273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331619, Ticker = 'KJ7A', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1623980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950789, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-10', PermSecMapEndDate = NULL WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511441575, ExchCode = 'TDG', PermQuoteRetireDate = '2016-02-08' WHERE SecCode = 1624036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493518, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 1630461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513069367, ExchCode = 'TDG' WHERE SecCode = 1635476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100401, ExchCode = 'QTX' WHERE SecCode = 1651406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701628, Ticker = 'IBCG', ExchCode = 'BRN' WHERE SecCode = 1652279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627202983, ExchCode = 'TDG', PermQuoteRetireDate = '2018-07-10' WHERE SecCode = 1655572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485319, ExchCode = 'QTX' WHERE SecCode = 1675772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320060, ExchCode = 'DEU' WHERE SecCode = 1675781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522286896, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 1675785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627697, ExchCode = 'QTX' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799113029, ExchCode = 'LAS' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512395856, ExchCode = 'DEU' WHERE SecCode = 1699181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927493, ExchCode = 'BER' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528495375, ExchCode = 'BTE', PermQuoteRetireDate = '2022-03-08' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628061495, ExchCode = 'DEU' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480142, ExchCode = 'QTX' WHERE SecCode = 1778982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939948839, PermQuoteStatus = 'DC', Ticker = 'OD7L', ExchCode = 'HAN', PermQuoteRetireDate = '2024-03-05' WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515423659, ExchCode = 'DEU' WHERE SecCode = 1967460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516696149, Ticker = 'ECX', ExchCode = 'LSE', PermQuoteRetireDate = '2014-08-27' WHERE SecCode = 2013070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387857, ExchCode = 'LAS' WHERE SecCode = 2039989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072144473, ExchCode = 'DEU' WHERE SecCode = 2042837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518083315, ExchCode = 'FRA' WHERE SecCode = 2055361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517928782, ExchCode = 'DEU' WHERE SecCode = 2055381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815142016, ExchCode = 'MUN' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607386, ExchCode = 'QTX' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112547, ExchCode = 'DUS' WHERE SecCode = 2195754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521578467, ExchCode = 'DEU' WHERE SecCode = 2200210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357671, ExchCode = 'FRA' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371241, ExchCode = 'SGO' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379476, ExchCode = 'LAS', PermQuoteRetireDate = '2026-01-27', PermSecMapEndDate = NULL WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538154, ExchCode = 'GTX' WHERE SecCode = 2221995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308485, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2222230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474891021, Ticker = '4KPN', ExchCode = 'ETX' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606147777, ExchCode = 'STU', PermQuoteRetireDate = '2018-05-09' WHERE SecCode = 2232834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750324218, ExchCode = 'DEU' WHERE SecCode = 2232877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831441, ExchCode = 'DEU' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386834, ExchCode = 'LAS' WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524063116, ExchCode = 'DEU' WHERE SecCode = 2240608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477221044, Ticker = NULL WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967851, ExchCode = 'MUN' WHERE SecCode = 2278244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967894, ExchCode = 'MUN' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675187, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525929139, ExchCode = 'FRA' WHERE SecCode = 2288360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515724218, ExchCode = 'BER', PermQuoteRetireDate = '2021-06-04' WHERE SecCode = 2289254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521368911, ExchCode = 'BEC' WHERE SecCode = 2293144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369369, ExchCode = 'BEC' WHERE SecCode = 2302032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784383948, ExchCode = 'LAS' WHERE SecCode = 2324950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527789441, ExchCode = 'FRA' WHERE SecCode = 2325728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21686715439, Ticker = 'CECD', ExchCode = 'LSE', PermQuoteRetireDate = '2021-12-20' WHERE SecCode = 2350989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-16' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530840197, ExchCode = 'FRA' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756136975, ExchCode = 'FRA' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130921495, ExchCode = 'DEU' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371665, ExchCode = 'SGO' WHERE SecCode = 2377498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607391, ExchCode = 'QTX' WHERE SecCode = 2391333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679407, ExchCode = 'BIV' WHERE SecCode = 2407194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786676625, ExchCode = 'BIV' WHERE SecCode = 2414027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532914219, ExchCode = 'STU' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756688641, ExchCode = 'MUN' WHERE SecCode = 2421101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538681, ExchCode = 'FRA' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533561487, ExchCode = 'MUN' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517626184, ExchCode = 'MUN' WHERE SecCode = 2448345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370397, ExchCode = 'SGO' WHERE SecCode = 2452538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536385132, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2487616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536651649, ExchCode = 'DEU' WHERE SecCode = 2487630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134691, ExchCode = 'DEU' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625753531, ExchCode = 'CHI', PermQuoteRetireDate = '2025-11-11' WHERE SecCode = 2527880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869000361, ExchCode = 'FRA', PermSecMapEndDate = NULL WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545188944, ExchCode = 'STU' WHERE SecCode = 2532821 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 2533432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587574216, ExchCode = 'DEU' WHERE SecCode = 2536084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539609267, ExchCode = 'FRA' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103119, ExchCode = 'FRA' WHERE SecCode = 2543647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540098774, ExchCode = 'TDG', PermQuoteRetireDate = '2015-08-12' WHERE SecCode = 2543648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512775558, ExchCode = 'OMG' WHERE SecCode = 2544436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371134, ExchCode = 'BEC' WHERE SecCode = 2545788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461691, ExchCode = 'DEU' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543102507, ExchCode = 'FRA' WHERE SecCode = 2579445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781821998, ExchCode = 'QTX' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369809, ExchCode = 'SGO' WHERE SecCode = 2598717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544371203, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-28' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595464451, ExchCode = 'STU' WHERE SecCode = 2604391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609149462, Ticker = '3ITS', ExchCode = 'LSE' WHERE SecCode = 2604404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545617420, ExchCode = 'DEU' WHERE SecCode = 2617118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546332345, PermQuoteStatus = 'AC', Ticker = '14S0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2625801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781870182, ExchCode = 'STU' WHERE SecCode = 2642447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109508, ExchCode = 'DEU' WHERE SecCode = 2643269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478452, ExchCode = 'QTX' WHERE SecCode = 2649155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549052722, ExchCode = 'DEU' WHERE SecCode = 2655940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 2679897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197344, Ticker = '7HP', ExchCode = 'BRN' WHERE SecCode = 2679919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451855, Ticker = 'QCOM', ExchCode = 'SWX' WHERE SecCode = 2679937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623807327, ExchCode = 'MUN' WHERE SecCode = 2682326 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-08' WHERE SecCode = 2695633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785264811, ExchCode = 'FRA' WHERE SecCode = 2695638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837147070, ExchCode = 'DUS' WHERE SecCode = 2708937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488257, ExchCode = 'QTX' WHERE SecCode = 2708938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552534617, ExchCode = 'STU' WHERE SecCode = 2711203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552934405, ExchCode = 'MEX' WHERE SecCode = 2724356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677010, ExchCode = 'BIV' WHERE SecCode = 2743610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704488, ExchCode = 'MXQ' WHERE SecCode = 2747774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198687, ExchCode = 'BIV' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679952, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2767178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674963, ExchCode = 'BIV' WHERE SecCode = 2767208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755558882, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2774739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479008, ExchCode = 'QTX' WHERE SecCode = 2807599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322186, ExchCode = 'DEU' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535495575, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 2827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289547, Ticker = '8PSG', ExchCode = 'GTX' WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766660550, ExchCode = 'MUN' WHERE SecCode = 2855770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560761404, ExchCode = 'FRA' WHERE SecCode = 2855773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939948844, ExchCode = 'HAN' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650334, ExchCode = 'QTX' WHERE SecCode = 2858551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460777, ExchCode = 'FRA' WHERE SecCode = 2864471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561687595, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19', PermSecMapEndDate = '2021-08-19' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562290887, ExchCode = 'STU' WHERE SecCode = 2870150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704681, ExchCode = 'MXQ' WHERE SecCode = 2876241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564447127, ExchCode = 'BTE', PermQuoteRetireDate = '2015-05-29' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564572205, ExchCode = 'TDG' WHERE SecCode = 2905610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296735, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654537658, ExchCode = 'MUN', PermQuoteRetireDate = '2025-11-21' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564939130, ExchCode = 'FRA' WHERE SecCode = 2909928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386051, ExchCode = 'LAS' WHERE SecCode = 2911859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705855, Ticker = 'UGN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369228, ExchCode = 'BEC' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566935898, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2930544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900629, ExchCode = 'STU', PermQuoteRetireDate = '2019-12-04' WHERE SecCode = 2930555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567104630, InstrPermID = 21575328144, OrgPermID = 5093618813, ValQuotePermID = 21575328161.0, PriInstrPermID = 21575328144.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = '1AL', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermOrgIPODate = '2015-07-06' WHERE SecCode = 2939990 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783066619, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670295233, ExchCode = 'STU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675024, ExchCode = 'BIV' WHERE SecCode = 2963604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573513525, ExchCode = 'FRA' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890669833, Ticker = '9GLA', ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659181386, ExchCode = 'MUN' WHERE SecCode = 3032214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479590, ExchCode = 'QTX' WHERE SecCode = 3032363 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 3049344 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951358.0 WHERE SecCode = 3068301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460747, Ticker = 'OD7F', ExchCode = 'FRA' WHERE SecCode = 3076722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022764, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3083485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582352174, ExchCode = 'FRA' WHERE SecCode = 3085564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401730, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-07', PermSecMapEndDate = NULL WHERE SecCode = 3092391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385101, ExchCode = 'LAS' WHERE SecCode = 3098021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955916, ExchCode = 'TDG' WHERE SecCode = 3101224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800738271, ExchCode = 'QTX' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552305555, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636371658, ExchCode = 'STU' WHERE SecCode = 3153872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429438, ExchCode = 'QTX' WHERE SecCode = 3169964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714463784, ExchCode = 'DXE' WHERE SecCode = 3186834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821257511, ExchCode = 'DUS' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629963304, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-22' WHERE SecCode = 3199703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388055, ExchCode = 'LAS' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801449069, ExchCode = 'DEU' WHERE SecCode = 3213266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747575641, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595110980, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3229527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026729, Ticker = '1UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100768, ExchCode = 'DUS' WHERE SecCode = 3247170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478399, ExchCode = 'QTX' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787711120, Ticker = '1CBKm', ExchCode = 'BCO' WHERE SecCode = 3247531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150560, ExchCode = 'CHA' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21716782408, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647227260, Ticker = '366', ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 3257169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387859, ExchCode = 'LAS' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007430, ExchCode = 'DEU' WHERE SecCode = 3282311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383457, ExchCode = 'FRA' WHERE SecCode = 3285135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401737, ExchCode = 'LAS', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 3304225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639225339, Ticker = 'KYH0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815325346, ExchCode = 'MUN', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705372, ExchCode = 'MXQ' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685841805, ExchCode = 'STU' WHERE SecCode = 3317931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714769303, ExchCode = 'TDG' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2011-02-24' WHERE SecCode = 3320106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286060, ExchCode = 'GTX' WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401005, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-08', PermSecMapEndDate = NULL WHERE SecCode = 3324158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679671, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3327117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788762034, ExchCode = 'FRA' WHERE SecCode = 3337223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295882, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380129, ExchCode = 'LAS' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643067252, ExchCode = 'TDG' WHERE SecCode = 3339668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367733, ExchCode = 'CHA' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 3350569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613758643, Ticker = 'BIOS', ExchCode = 'STO', PermQuoteRetireDate = '2024-01-12' WHERE SecCode = 3350742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773002549, ExchCode = 'FRA' WHERE SecCode = 3356351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22098741670, ExchCode = 'CHI' WHERE SecCode = 3359183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616850045, Ticker = '14G0', ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-31' WHERE SecCode = 3366981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658642103, ExchCode = 'MUN' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-04-08' WHERE SecCode = 3385582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620409821, ExchCode = 'BCO' WHERE SecCode = 3385974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766019517, ExchCode = 'FRA' WHERE SecCode = 3386374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908261084, Ticker = '1FBm', ExchCode = 'EQD' WHERE SecCode = 3401441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625006753, ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-30', PermSecMapEndDate = '2017-10-30' WHERE SecCode = 3402759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660711293, ExchCode = 'DEU' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718790762, ExchCode = 'CHI' WHERE SecCode = 3404188 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951358.0 WHERE SecCode = 3405062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901491943, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353175, ExchCode = 'FRA' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3419102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285330, ExchCode = 'GTX' WHERE SecCode = 3430952 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3431867 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3431868 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 3431944 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-09' WHERE SecCode = 3433126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636056227, ExchCode = 'FRA' WHERE SecCode = 3435060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782375294, ExchCode = 'STU' WHERE SecCode = 3436849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186352, ExchCode = 'FRA' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520236, ExchCode = 'QTX' WHERE SecCode = 3444720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644928541, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3446081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705440, ExchCode = 'MXQ' WHERE SecCode = 3446301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071844, ExchCode = 'FRA', PermQuoteRetireDate = '2019-12-30' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782180687, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3446753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938004022, ExchCode = 'GTX' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648822392, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-08', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21650788270, Ticker = NULL, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652485962, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-04', PermSecMapEndDate = '2018-07-04' WHERE SecCode = 3529083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431273, ExchCode = 'FRA' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653986688, Ticker = 'TGLl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-28' WHERE SecCode = 3536053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664223, ExchCode = 'MUN' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797237688, ExchCode = 'STU' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 3560278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658217012, ExchCode = 'DEU' WHERE SecCode = 3572805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731165516, ExchCode = 'DEU' WHERE SecCode = 3584663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358321, Ticker = 'CS9', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 3586971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647732047, ExchCode = 'TDG' WHERE SecCode = 3586984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559909557, ExchCode = 'TDG', PermQuoteRetireDate = '2021-04-06' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544783558, ExchCode = 'BER' WHERE SecCode = 3587041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644367377, ExchCode = 'DEU' WHERE SecCode = 3587074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296175, ExchCode = 'GTX' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544661, ExchCode = 'DUS' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663316444, ExchCode = 'FRA', PermQuoteRetireDate = '2020-04-16' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878957446, ExchCode = 'SIG', PermQuoteRetireDate = '2023-09-23' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287361, PermQuoteStatus = 'AC', Ticker = 'TLRY', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 3610775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664433940, ExchCode = 'MUN' WHERE SecCode = 3610818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664984725, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3615233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664987336, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3615235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777289547, ExchCode = 'TDG' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21650508158, Ticker = 'XBECz', ExchCode = 'BCO' WHERE SecCode = 3619554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678046, ExchCode = 'BIV' WHERE SecCode = 3629694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667202566, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668158989, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290646, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679574, ExchCode = 'BIV' WHERE SecCode = 3644857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715145241, Ticker = 'ROAIz', ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670450813, ExchCode = 'DEU' WHERE SecCode = 3657811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505131, ExchCode = 'MUN' WHERE SecCode = 3658775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671049443, PermQuoteStatus = 'AC', Ticker = '1SS', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3663204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672845691, ExchCode = 'DEU' WHERE SecCode = 3675648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302234, ExchCode = 'GTX' WHERE SecCode = 3675861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401734, ExchCode = 'LAS', PermSecMapStartDate = '2026-04-07' WHERE SecCode = 3685213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675373923, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3690817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21676198882, ExchCode = 'DEU', PermQuoteRetireDate = '2024-04-24' WHERE SecCode = 3716790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381782, ExchCode = 'LAS' WHERE SecCode = 3739134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872326, ExchCode = 'DEU' WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674386, ExchCode = 'BIV' WHERE SecCode = 3756608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678493, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3761051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682196938, Ticker = '0CMZ', ExchCode = 'LSE', PermQuoteRetireDate = '2019-02-13' WHERE SecCode = 3762759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683763490, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688007392, ExchCode = 'MUN', PermQuoteRetireDate = '2022-12-01' WHERE SecCode = 3775420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431754, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-28' WHERE SecCode = 3779971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377692, ExchCode = 'BIV' WHERE SecCode = 3783012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685868276, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461787, ExchCode = 'FRA' WHERE SecCode = 3793374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679373, ExchCode = 'BIV' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719386690, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-28', PermSecMapEndDate = '2023-03-30' WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744453885, ExchCode = 'DEU' WHERE SecCode = 3809052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383302, ExchCode = 'MEX' WHERE SecCode = 3809094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707022417, ExchCode = 'MUN' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932243, ExchCode = 'FRA' WHERE SecCode = 3827962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285132, PermQuoteStatus = 'DC', Ticker = '2ZT0', ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-02' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744919357, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294114, ExchCode = 'GTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21698786104, ExchCode = 'CHI', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812350912, ExchCode = 'DEU' WHERE SecCode = 3863388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710448, Ticker = 'GOLDa', ExchCode = 'BCO' WHERE SecCode = 3875637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701895290, ExchCode = 'DEU' WHERE SecCode = 3875755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702129365, ExchCode = 'BER', PermQuoteRetireDate = '2021-09-17' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703557839, Ticker = 'UPR', ExchCode = 'LSE' WHERE SecCode = 3883708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702475114, ExchCode = 'FRA' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702467501, ExchCode = 'DEU' WHERE SecCode = 3886782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401742, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-07', PermSecMapEndDate = NULL WHERE SecCode = 3899642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386695, ExchCode = 'LAS' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168601313, ExchCode = 'DEU' WHERE SecCode = 3913159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729404094, ExchCode = 'STU' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383362, ExchCode = 'MEX' WHERE SecCode = 3934323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711927625, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3955660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294452, ExchCode = 'GTX' WHERE SecCode = 3998157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720001076, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403388, ExchCode = 'FRA' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-08' WHERE SecCode = 4006851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722747312, ExchCode = 'BCO' WHERE SecCode = 4024795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026866, Ticker = '1BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011239, Ticker = '2T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011934, Ticker = '2BA' WHERE SecCode = 4031741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011913, Ticker = '2AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011919, Ticker = '2ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011911, Ticker = '2AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010294, Ticker = '2AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011959, Ticker = '2DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009889, Ticker = '2DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027148, Ticker = '1DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026917, Ticker = '1EUZ' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010541, Ticker = '2GG' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012423, Ticker = '2HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010937, Ticker = '2HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 4031901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010414, Ticker = '2HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012605, Ticker = '2INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010156, Ticker = '2LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010479, Ticker = '2NDX' WHERE SecCode = 4031953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143892, Ticker = '2RI', ExchCode = 'MIL' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042586, Ticker = '2PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013663, Ticker = '2PYPL', ExchCode = 'MIL' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013557, Ticker = '2REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009964, Ticker = '2RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010336, Ticker = '2SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143822, Ticker = '2UCB', ExchCode = 'MIL' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010953, Ticker = '2ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011967, Ticker = '2DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751582009, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774922624, ExchCode = 'BCO' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571646335, ExchCode = 'BEC' WHERE SecCode = 4046481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788219439, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732569272, ExchCode = 'DEU' WHERE SecCode = 4081944 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739862119, PermQuoteStatus = 'DC', Ticker = 'JARUl', ExchCode = 'MAA', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587084065, PermQuoteStatus = 'AC', Ticker = 'XBJR', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907558991, ExchCode = 'MUN' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383364, ExchCode = 'TDG' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976699, ExchCode = 'STU' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766464069, Ticker = '49Y', ExchCode = 'FRA', PermQuoteRetireDate = '2025-03-20' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21740303517, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14', PermSecMapEndDate = NULL WHERE SecCode = 4124848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674204, ExchCode = 'BIV' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351672, ExchCode = 'MEX' WHERE SecCode = 4171586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745348418, ExchCode = 'TDG' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482768, ExchCode = 'QTX' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745628089, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746674674, ExchCode = 'DEU' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791223141, ExchCode = 'STU' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767422310, ExchCode = 'DEU' WHERE SecCode = 4210918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679079, ExchCode = 'BIV' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534014, ExchCode = 'TDG' WHERE SecCode = 4256876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534208, PermQuoteStatus = 'AC', Ticker = '0YL0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4259224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349639, ExchCode = 'BIV' WHERE SecCode = 4259231 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 4261224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756809738, ExchCode = 'FRA' WHERE SecCode = 4275420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487599, ExchCode = 'QTX' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757260444, ExchCode = 'FRA' WHERE SecCode = 4278855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628095, ExchCode = 'DUS' WHERE SecCode = 4278857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360718, ExchCode = 'HAN' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828827479, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763966496, ExchCode = 'DEU' WHERE SecCode = 4327051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738812998, ExchCode = 'DUS' WHERE SecCode = 4383309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777652111, ExchCode = 'FRA' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778680491 WHERE SecCode = 4406073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785622125, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803077161, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727304579, ExchCode = 'BIV' WHERE SecCode = 4421213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999132, ExchCode = 'FRA' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370427, ExchCode = 'AQX' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785454242, ExchCode = 'STU' WHERE SecCode = 4434247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784912086, ExchCode = 'DEU' WHERE SecCode = 4434248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785625919, ExchCode = 'FRA' WHERE SecCode = 4434305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785453356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4436991 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 4444005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788448773, ExchCode = 'STU' WHERE SecCode = 4447601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301153, ExchCode = 'BIV' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790867954, ExchCode = 'STU' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792098251, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793526925, ExchCode = 'QTX' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710449, Ticker = 'GLDDl', ExchCode = 'BCO' WHERE SecCode = 4485855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956106, Ticker = '0A6Nl', ExchCode = 'BCO' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813169859, ExchCode = 'TDG' WHERE SecCode = 4511506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386877, ExchCode = 'LAS' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430441, ExchCode = 'DEU' WHERE SecCode = 4526142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627749, ExchCode = 'QTX' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274062, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823056706, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = NULL WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140273543, ExchCode = 'BCO' WHERE SecCode = 4563419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810843361, ExchCode = 'STU' WHERE SecCode = 4575120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811019112, ExchCode = 'TDG' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829998, ExchCode = 'QTX' WHERE SecCode = 4591965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812848146, ExchCode = 'DEU' WHERE SecCode = 4592022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813395103, ExchCode = 'FRA' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136782, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28' WHERE SecCode = 4607686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819758641, ExchCode = 'TDG' WHERE SecCode = 4623220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401702, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-07', PermSecMapEndDate = NULL WHERE SecCode = 4623227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22033566336, ExchCode = 'MXQ' WHERE SecCode = 4625008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968004, ExchCode = 'FRA' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534591, ExchCode = 'QTX' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821041967, Ticker = '4KL0', ExchCode = 'DEU' WHERE SecCode = 4629496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281505, ExchCode = 'DUS' WHERE SecCode = 4632109 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 4638889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100069, ExchCode = 'FRA' WHERE SecCode = 4639636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727256655, ExchCode = 'BIV' WHERE SecCode = 4654595 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 4658647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387315, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837529343, ExchCode = 'FRA' WHERE SecCode = 4693647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037614, ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-21' WHERE SecCode = 4707187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233438, ExchCode = 'BIV' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 4746805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851141782, ExchCode = 'STU', PermQuoteRetireDate = '2025-10-27', PermSecMapEndDate = '2025-10-27' WHERE SecCode = 4748531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561792, ExchCode = 'GTX' WHERE SecCode = 4754742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136607450, Ticker = 'ETHWl', ExchCode = 'BTE' WHERE SecCode = 4756631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854409786, PermQuoteStatus = 'AC', Ticker = 'GSPl', ExchCode = 'TRQ', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4761540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853953634, ExchCode = 'QTX' WHERE SecCode = 4761545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853887138, ExchCode = 'GTX' WHERE SecCode = 4761589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854744263, ExchCode = 'QTX' WHERE SecCode = 4766038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387339, ExchCode = 'LAS' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439327, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-17' WHERE SecCode = 4773786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439459, ExchCode = 'MUN', PermQuoteRetireDate = '2021-11-15' WHERE SecCode = 4774934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856019028, ExchCode = 'MUN' WHERE SecCode = 4775072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856021925, ExchCode = 'DEU' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126858445, ExchCode = 'DEU' WHERE SecCode = 4775075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705625, ExchCode = 'STU' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380489, Ticker = 'A6I', ExchCode = 'LAS' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546869, ExchCode = 'DEU' WHERE SecCode = 4794550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954958, ExchCode = 'LAS' WHERE SecCode = 4802301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907559014, ExchCode = 'MUN', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862748816, ExchCode = 'DEU' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860859987, ExchCode = 'FRA' WHERE SecCode = 4813526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799369659, ExchCode = 'CHI' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815777446, ExchCode = 'FRA' WHERE SecCode = 4815314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192887, ExchCode = 'DEU' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580393, ExchCode = 'DEU' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580680, ExchCode = 'DEU' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888953884, ExchCode = 'MUN', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 4834793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830057, ExchCode = 'QTX' WHERE SecCode = 4834795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866893816 WHERE SecCode = 4841211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789616854, ExchCode = 'QTX' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398389, ExchCode = 'GER', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398299, ExchCode = 'FRA', PermQuoteRetireDate = '2024-06-13' WHERE SecCode = 4845030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580391, ExchCode = 'FRA' WHERE SecCode = 4845032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871055968, ExchCode = 'GTX' WHERE SecCode = 4845045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869320421, ExchCode = 'DUS' WHERE SecCode = 4847005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140095713, ExchCode = 'HAM' WHERE SecCode = 4854866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089452780, ExchCode = 'DXE' WHERE SecCode = 4854872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954831, ExchCode = 'LAS' WHERE SecCode = 4887246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829806151, ExchCode = 'DEU' WHERE SecCode = 4890295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885726, ExchCode = 'FRA' WHERE SecCode = 4890300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876864887, ExchCode = 'DEU', PermQuoteRetireDate = '2022-09-15' WHERE SecCode = 4893294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876897799, Ticker = '2TRV', ExchCode = 'MIL' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954949, ExchCode = 'LAS' WHERE SecCode = 4907129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434498, ExchCode = 'QTX' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778071457, PermQuoteStatus = 'AC', Ticker = '62U2', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4943250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884460465, ExchCode = 'MUN' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884973234, ExchCode = 'GTX' WHERE SecCode = 4957875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381606, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4959596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689378, ExchCode = 'FRA' WHERE SecCode = 4959597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887740504, ExchCode = 'STU' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936307256, ExchCode = 'MUN' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888704331, ExchCode = 'GTX' WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902368752, ExchCode = 'STU' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889561153, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4980098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212169, ExchCode = 'MEX' WHERE SecCode = 4980103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740514, ExchCode = 'LAS' WHERE SecCode = 4983996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710458, Ticker = 'BOLDd', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 4991558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953078, ExchCode = 'FRA' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100451, ExchCode = 'QTX' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894278989, ExchCode = 'STU' WHERE SecCode = 5009346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980178367, ExchCode = 'DUS' WHERE SecCode = 5011657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894536981, ExchCode = 'DUS' WHERE SecCode = 5011663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907308927, ExchCode = 'DUS' WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897339624, ExchCode = 'FRA' WHERE SecCode = 5025182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710462, Ticker = 'KOR3l', ExchCode = 'BCO' WHERE SecCode = 5037291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823918, ExchCode = 'AQX' WHERE SecCode = 5038692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863949562 WHERE SecCode = 5040232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195445, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 5042969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607201, Ticker = 'DXCM', ExchCode = 'SWX' WHERE SecCode = 5047087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209210, ExchCode = 'FRA' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902573195, ExchCode = 'DUS' WHERE SecCode = 5067269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902617420, ExchCode = 'DEU' WHERE SecCode = 5067289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903664236, ExchCode = 'FRA' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663662, ExchCode = 'DEU' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727217399, ExchCode = 'MEX' WHERE SecCode = 5083954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401000, PermQuoteStatus = 'AC', Ticker = 'GPS', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-07', PermSecMapEndDate = NULL WHERE SecCode = 5089305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876909126, ExchCode = 'MXQ' WHERE SecCode = 5099007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907546209, ExchCode = 'DUS', PermQuoteRetireDate = '2024-11-29' WHERE SecCode = 5099027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718186332, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5099028 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5101460 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5104592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012676, Ticker = '2KDP' WHERE SecCode = 5107765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816912714, ExchCode = 'FRA', PermQuoteRetireDate = '2023-01-12', PermSecMapEndDate = '2023-01-12' WHERE SecCode = 5112411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834841, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5115635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910867434, ExchCode = 'STU' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910877570, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912123776, ExchCode = 'DEU' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942737484, ExchCode = 'STU' WHERE SecCode = 5151167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615655, ExchCode = 'STU' WHERE SecCode = 5153443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919459011, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807916823, ExchCode = 'MUN', DomCntry = 'USA' WHERE SecCode = 5161225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634297955, Ticker = '0M1Kl', ExchCode = 'BCO' WHERE SecCode = 5161267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508526620, ExchCode = 'FRA' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21721366997, ExchCode = 'STU' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180699, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667329377, ExchCode = 'DEU' WHERE SecCode = 5161350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827095404, ExchCode = 'MXQ' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727344850, ExchCode = 'MEX' WHERE SecCode = 5161363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367923, ExchCode = 'BEC' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689627, ExchCode = 'DEU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781498592, ExchCode = 'MXQ' WHERE SecCode = 5161409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727360441, ExchCode = 'BIV' WHERE SecCode = 5161415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850514745, ExchCode = 'DEU' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885781, ExchCode = 'FRA' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197642, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919483609, ExchCode = 'DEU' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948058908, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173437, ExchCode = 'MEX' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943651732, ExchCode = 'STU' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921901229, ExchCode = 'DEU' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947744427, ExchCode = 'STU', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 5182664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931188804, ExchCode = 'STU' WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923944044, ExchCode = 'DEU' WHERE SecCode = 5189106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834872, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5195447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950518158, ExchCode = 'GTX' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904151, ExchCode = 'BTE' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836196, Ticker = 'AFTTp', ExchCode = 'EQD' WHERE SecCode = 5206274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105049597, ExchCode = 'MXQ' WHERE SecCode = 5206281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22093287267, Ticker = 'ALINKa', ExchCode = 'BCO' WHERE SecCode = 5206286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47733359573, ExchCode = 'DEU' WHERE SecCode = 5209761 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 5216108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931108954, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 5220960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727227057, ExchCode = 'BIV' WHERE SecCode = 5238268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793845610, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-26' WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751536, ExchCode = 'QTX' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935825325, ExchCode = 'TDG' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775222348, ExchCode = 'MEX' WHERE SecCode = 5267090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397466, PermQuoteStatus = 'DC', ExchCode = 'CHI', PermQuoteRetireDate = '2026-03-12' WHERE SecCode = 5269462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381670, ExchCode = 'LAS' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793674806, ExchCode = 'LAS' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537961037, ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-03', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 5283651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780979385, ExchCode = 'DUS' WHERE SecCode = 5290322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943068314, ExchCode = 'DEU' WHERE SecCode = 5301896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953922612, ExchCode = 'GTX', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = '2025-08-06' WHERE SecCode = 5311845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951358875, PermQuoteStatus = 'AC', Ticker = '3QP', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5324087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 25727255535.0, ValQuotePermID = 25727366156.0, DomCntry = 'USA' WHERE SecCode = 5344695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952265408, ExchCode = 'DEU' WHERE SecCode = 5347429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059866, ExchCode = 'FRA' WHERE SecCode = 5374941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380717, ExchCode = 'LAS' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401744, ExchCode = 'LAS' WHERE SecCode = 5403196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792996696, ExchCode = 'LAS' WHERE SecCode = 5403242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727202568, ExchCode = 'MEX' WHERE SecCode = 5411550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359843, ExchCode = 'FRA' WHERE SecCode = 5413668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535809, ExchCode = 'BIV' WHERE SecCode = 5416155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416441, ExchCode = 'MEX' WHERE SecCode = 5417748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777481353, ExchCode = 'FRA' WHERE SecCode = 5422843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777481357, ExchCode = 'FRA' WHERE SecCode = 5422844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107116, ExchCode = 'MEX' WHERE SecCode = 5430834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076773, ExchCode = 'LAS', PermQuoteRetireDate = '2024-12-16', PermSecMapEndDate = '2024-12-16' WHERE SecCode = 5434319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931510083, Ticker = '0ABM', ExchCode = 'LSE' WHERE SecCode = 5448761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776268322, ExchCode = 'BIV' WHERE SecCode = 5455239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193595, ExchCode = 'BIV' WHERE SecCode = 5474598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778437244, ExchCode = 'BIV' WHERE SecCode = 5482856 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'XK7A', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 5487993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893349, ExchCode = 'TDG' WHERE SecCode = 5493665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026804, Ticker = '1TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835157, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823945, ExchCode = 'AQE' WHERE SecCode = 5503780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 5503781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663720, ExchCode = 'AQE' WHERE SecCode = 5503782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776471888, ExchCode = 'MEX' WHERE SecCode = 5503860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309751, Ticker = '3LPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5503872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128275, ExchCode = 'BCO' WHERE SecCode = 5503898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085810217, ExchCode = 'BTE' WHERE SecCode = 5503900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861198674, Ticker = 'ARK3', ExchCode = 'LSE' WHERE SecCode = 5503901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309769, Ticker = '3LMO', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5506501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778891290, ExchCode = 'FRA' WHERE SecCode = 5507430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831436884, Ticker = 'SFTG', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5534997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381500, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5553189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882186850, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 5569241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110941, PermQuoteStatus = 'AC', Ticker = '3FNGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580283, ExchCode = 'DUS' WHERE SecCode = 5569302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917830166, ExchCode = 'DEU', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5569303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110915, Ticker = '3MRNm', ExchCode = 'BCO' WHERE SecCode = 5569367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 5569431 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 5574869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152999678, Ticker = 'NGLSl', ExchCode = 'AQX' WHERE SecCode = 5584733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212174, ExchCode = 'MEX' WHERE SecCode = 5604481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794769105, ExchCode = 'LAS' WHERE SecCode = 5623203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173436, ExchCode = 'MEX' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781095333, ExchCode = 'STU' WHERE SecCode = 5633895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923117428, Ticker = 'LCO3', ExchCode = 'LSE' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460797, ExchCode = 'GER' WHERE SecCode = 5638832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848440, ExchCode = 'QTX', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848459, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5655038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307748, ExchCode = 'BIV' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607151, ExchCode = 'FRA' WHERE SecCode = 5663968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22020600393, ExchCode = 'DEU' WHERE SecCode = 5679100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22021922875, ExchCode = 'DEU' WHERE SecCode = 5687951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858189, ExchCode = 'FRA' WHERE SecCode = 5687957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782381306, ExchCode = 'QTX' WHERE SecCode = 5703062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22025806033, ExchCode = 'DEU' WHERE SecCode = 5710467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782376739, ExchCode = 'FRA' WHERE SecCode = 5712413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028649127, ExchCode = 'DEU' WHERE SecCode = 5722406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028890941, ExchCode = 'FRA' WHERE SecCode = 5724940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782771597, ExchCode = 'FRA' WHERE SecCode = 5740795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928831, Ticker = 'SOXLm', ExchCode = 'BCO' WHERE SecCode = 5740824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928832, Ticker = 'MAG7m', ExchCode = 'BCO' WHERE SecCode = 5740826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22119690921, ExchCode = 'BCO' WHERE SecCode = 5740827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128284, Ticker = 'SMCIm', ExchCode = 'BCO' WHERE SecCode = 5740830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153246014, ExchCode = 'BTE' WHERE SecCode = 5740832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772235078, ExchCode = 'TDG' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782872476, ExchCode = 'FRA' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891343, ExchCode = 'FRA' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891391, ExchCode = 'FRA' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782928373, ExchCode = 'FRA' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782954307, ExchCode = 'FRA' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025956, ExchCode = 'LAS' WHERE SecCode = 5764717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914265, Ticker = 'RZ8B', ExchCode = 'STU' WHERE SecCode = 5782810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851316, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955012, ExchCode = 'LAS' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608791, ExchCode = 'BIV' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784107272, ExchCode = 'FRA' WHERE SecCode = 5817022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784236560, ExchCode = 'STU' WHERE SecCode = 5822326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784236496, ExchCode = 'FRA' WHERE SecCode = 5822327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327233, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784326338, ExchCode = 'STU' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327232, ExchCode = 'FRA' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357765, ExchCode = 'BIV' WHERE SecCode = 5836309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600489, ExchCode = 'STU' WHERE SecCode = 5839460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913642, ExchCode = 'DEU' WHERE SecCode = 5839461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600488, ExchCode = 'STU' WHERE SecCode = 5839464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601376, ExchCode = 'STU' WHERE SecCode = 5839466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913691, ExchCode = 'DEU' WHERE SecCode = 5839467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386888, ExchCode = 'LAS' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804071845, ExchCode = 'FRA' WHERE SecCode = 5853173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710465, Ticker = 'WSLVl', ExchCode = 'BCO' WHERE SecCode = 5888339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22054245159, ExchCode = 'DEU' WHERE SecCode = 5888374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786044119, ExchCode = 'GTX', PermQuoteRetireDate = '2025-05-09', PermSecMapEndDate = NULL WHERE SecCode = 5911970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710447, Ticker = 'TTFWl', ExchCode = 'BCO' WHERE SecCode = 5923305 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'X6U0' WHERE SecCode = 5985685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788207224, ExchCode = 'FRA' WHERE SecCode = 6010807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788640939, ExchCode = 'FRA' WHERE SecCode = 6035234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133180991, Ticker = 'BITC', ExchCode = 'SWX' WHERE SecCode = 6078418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133180917, Ticker = 'BITC', ExchCode = 'SWX' WHERE SecCode = 6078420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834880, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367925, ExchCode = 'SGO' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834808, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663690, ExchCode = 'AQX' WHERE SecCode = 6097325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' WHERE SecCode = 6097355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580161, ExchCode = 'DEU' WHERE SecCode = 6097360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380561, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309872, Ticker = '3SPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 6097408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823963, ExchCode = 'AQE' WHERE SecCode = 6097426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829806, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689582, ExchCode = 'CHI' WHERE SecCode = 6097546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980198448, ExchCode = 'FRA' WHERE SecCode = 6097549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782305154, ExchCode = 'MEX' WHERE SecCode = 6097558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354550, ExchCode = 'BIV' WHERE SecCode = 6097578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822798834, ExchCode = 'BCO' WHERE SecCode = 6097580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886399005, ExchCode = 'QTX' WHERE SecCode = 6097585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512196, Ticker = 'NVDEl', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512005, Ticker = '2AAPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999588395, Ticker = '3OISl', ExchCode = 'TRQ' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790492416, ExchCode = 'QTX' WHERE SecCode = 6119927 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'B1003' WHERE SecCode = 6154012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791248887, ExchCode = 'STU' WHERE SecCode = 6190705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791316273, ExchCode = 'FRA' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792942788, ExchCode = 'LAS' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791696288, ExchCode = 'MEX' WHERE SecCode = 6223976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580180, ExchCode = 'DEU' WHERE SecCode = 6256405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181395, ExchCode = 'MEX' WHERE SecCode = 6256406 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2011-02-24' WHERE SecCode = 6256407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727264760, ExchCode = 'BIV' WHERE SecCode = 6256413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848456, ExchCode = 'QTX' WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071047025, ExchCode = 'DEU' WHERE SecCode = 6256447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792270095, ExchCode = 'QTX', PermQuoteRetireDate = '2025-11-26' WHERE SecCode = 6269028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269534, ExchCode = 'FRA' WHERE SecCode = 6269033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47754884525, ExchCode = 'DEU' WHERE SecCode = 6285535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105162186, ExchCode = 'DEU' WHERE SecCode = 6285537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796366874, ExchCode = 'TDG' WHERE SecCode = 6285539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792486363, ExchCode = 'MEX' WHERE SecCode = 6285560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105365896, ExchCode = 'DEU' WHERE SecCode = 6285588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658530124, ExchCode = 'FRA' WHERE SecCode = 6325196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710454, Ticker = 'SPUTl', ExchCode = 'BCO' WHERE SecCode = 6351665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989711, ExchCode = 'MEX' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794094894, ExchCode = 'QTX' WHERE SecCode = 6392491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789515592, ExchCode = 'MEX' WHERE SecCode = 6394335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794320484, ExchCode = 'FRA' WHERE SecCode = 6396772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083975572, ExchCode = 'QTX' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 6429304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802152101, ExchCode = 'TDG' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788837443, ExchCode = 'MEX' WHERE SecCode = 6448789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140986, ExchCode = 'MUN' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938208, ExchCode = 'FRA' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938213, ExchCode = 'FRA' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938212, ExchCode = 'FRA' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938214, ExchCode = 'FRA' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746059, ExchCode = 'DUS' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798598065, ExchCode = 'FRA' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798743592, ExchCode = 'DUS' WHERE SecCode = 6543898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798948296, ExchCode = 'FRA' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607078, Ticker = 'ON', ExchCode = 'SWX' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955916, ExchCode = 'FRA' WHERE SecCode = 6587160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957446, ExchCode = 'FRA' WHERE SecCode = 6587161 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 25727255535.0, ValQuotePermID = 25727366156.0, DomCntry = 'USA', PermSecMapEndDate = NULL WHERE SecCode = 6590595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903777191, ExchCode = 'HAN' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800268422, ExchCode = 'TDG' WHERE SecCode = 6626384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430458, ExchCode = 'DEU' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 6629297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357085, ExchCode = 'BRN' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429437, ExchCode = 'QTX' WHERE SecCode = 6635297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401735, ExchCode = 'LAS' WHERE SecCode = 6672564 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ZN40' WHERE SecCode = 6672570 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-08' WHERE SecCode = 6691950 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 6696830 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 6699562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804778699, ExchCode = 'GTX' WHERE SecCode = 6721535 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 6724297 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 6724387 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 6734288 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 6737834 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 18068907541.0 WHERE SecCode = 6755830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805232354, ExchCode = 'FRA' WHERE SecCode = 6756496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805232359, ExchCode = 'FRA' WHERE SecCode = 6756497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805237572, ExchCode = 'FRA' WHERE SecCode = 6756501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805237865, ExchCode = 'FRA' WHERE SecCode = 6756502 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6765403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401746, ExchCode = 'LAS' WHERE SecCode = 6768884 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 10986008 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2011-02-24' WHERE SecCode = 10988860 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 11027686 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'TKUNF' WHERE SecCode = 11062785 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11131140 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11131887 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951358.0 WHERE SecCode = 11155145 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11180728 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11180729 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11181557 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 25727255535.0, ValQuotePermID = 25727366156.0, DomCntry = 'USA' WHERE SecCode = 11198774 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11209821 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11212180 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 11213538 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'MOND' WHERE SecCode = 11221272 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727225239, PermQuoteStatus = 'AC', Ticker = 'IOBTQ', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11233600 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11239219 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11255668 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 11271913 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11271927 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236804841102, InstrPermID = 232916301644, OrgPermID = 5096997405, PriTrdQuotePermID = 236804841102.0, ValQuotePermID = 25727029106.0, PriInstrPermID = 232916301644.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'GLND', IncCntry = 'USA', PriTRBCIndPermID = 4294951998.0, PermQuoteRetireDate = NULL, PermOrgIPODate = '2026-03-26', PermSecMapStartDate = '2026-03-26', PermSecMapEndDate = NULL WHERE SecCode = 11279226 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 11281627 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-08', PermSecMapEndDate = '2026-04-08' WHERE SecCode = 11285598 AND Type_ = 1;
