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 = 21538767932, Ticker = 'ABBYl', ExchCode = 'BCO', PermQuoteRetireDate = '2021-08-11' WHERE SecCode = 24 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531116153, Ticker = 'ABTl', ExchCode = 'BCO', PermQuoteRetireDate = '2017-02-01' WHERE SecCode = 31 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531128468, Ticker = 'HONl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-16' WHERE SecCode = 229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633621299, Ticker = '0OAL', ExchCode = 'LSE' WHERE SecCode = 323 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836050580, Ticker = 'IBM', ExchCode = 'LSE', PermQuoteRetireDate = '2024-11-06' WHERE SecCode = 479 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 9076 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838282281, IsPrimaryQuote = 0, PermQuoteStatus = 'DC', Ticker = 'COLO3', PermQuoteRetireDate = '2024-05-27', PermSecMapStartDate = '1994-02-26', PermSecMapEndDate = '2024-05-27' WHERE SecCode = 28027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835814087, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 31370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531116276, Ticker = 'AGDl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-22' WHERE SecCode = 33148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836574233, ExchCode = 'FRA' WHERE SecCode = 33922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385453, ExchCode = 'LAS' WHERE SecCode = 35450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475422367, ExchCode = 'DUS', PermQuoteRetireDate = '2006-06-05' WHERE SecCode = 36125 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 37867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836325567, ExchCode = 'BER' WHERE SecCode = 38014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489858, ExchCode = 'QTX', PermQuoteRetireDate = '2025-07-22' WHERE SecCode = 38789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836334846, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 38963 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 42408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774922528, Ticker = 'MMMz', ExchCode = 'BCO' WHERE SecCode = 42437 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 45483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474913868, Ticker = 'MACO', ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55848763257, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'GER', PermQuoteRetireDate = '2018-01-12' WHERE SecCode = 45916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838639237, ExchCode = 'STU' WHERE SecCode = 46009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858236052, Ticker = 'SCX', ExchCode = 'BER', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475289897, ExchCode = 'GER' WHERE SecCode = 46302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838761774, ExchCode = 'HAM', PermQuoteRetireDate = '2015-06-16' WHERE SecCode = 46516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341602, ExchCode = 'BER' WHERE SecCode = 46521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836399711, ExchCode = 'FRA' WHERE SecCode = 47291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801449047, ExchCode = 'DEU' WHERE SecCode = 47312 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 49163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809727282, ExchCode = 'LAS' WHERE SecCode = 52755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830272806, ExchCode = 'GTX' WHERE SecCode = 53240 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474898637, Ticker = NULL, ExchCode = 'VIE', PermQuoteRetireDate = '2014-12-12' WHERE SecCode = 53853 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836470085, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 54333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836532537, ExchCode = 'FRA' WHERE SecCode = 54337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837361015, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 55770 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 55867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324124, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 58756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475416805, Ticker = NULL, ExchCode = 'MUN', PermQuoteRetireDate = '2004-10-11' WHERE SecCode = 58925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621219277, PermQuoteStatus = 'DC', Ticker = '6D81', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 58930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21914308556, ExchCode = 'GTX' WHERE SecCode = 58939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811593365, ExchCode = 'QTX' WHERE SecCode = 59023 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585187543, ExchCode = 'HAM' WHERE SecCode = 59853 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 = 55837353857, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60059 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530135142, ExchCode = 'STU', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 60202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836443537, ExchCode = 'FRA', PermQuoteRetireDate = '2012-05-21' WHERE SecCode = 60364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324575, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 60499 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21526399804, ExchCode = 'FRA' WHERE SecCode = 60669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605378798, ExchCode = 'STU' WHERE SecCode = 61290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759098635, ExchCode = 'STU' WHERE SecCode = 61355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21498597722, ExchCode = 'FRA', PermQuoteRetireDate = '2018-01-02' WHERE SecCode = 61507 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836322927, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 61635 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552519208, ExchCode = 'DUS' WHERE SecCode = 61996 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799957419, ExchCode = 'DUS' WHERE SecCode = 62000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667486943, ExchCode = 'QTX' WHERE SecCode = 62901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667482551, ExchCode = 'QTX' WHERE SecCode = 63004 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223877, ExchCode = 'QTX' WHERE SecCode = 63011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809578582, Ticker = 'OLLd', ExchCode = 'BCO' WHERE SecCode = 63014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836333924, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63016 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830273151, ExchCode = 'GTX' WHERE SecCode = 63055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531119240, Ticker = 'BRW1d', ExchCode = 'BCO', PermQuoteRetireDate = '2018-01-22' WHERE SecCode = 63058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475428779, ExchCode = 'STU' WHERE SecCode = 63096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823259770, ExchCode = 'DUS' WHERE SecCode = 63101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21499629939, Ticker = 'UNM', ExchCode = 'TDG', PermQuoteRetireDate = '2013-09-05' WHERE SecCode = 63112 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475549907, ExchCode = 'STU', PermQuoteRetireDate = '2007-07-23' WHERE SecCode = 63119 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667469757, ExchCode = 'QTX', PermQuoteRetireDate = '2022-06-22' WHERE SecCode = 64078 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331733, Ticker = 'ISC1', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 64275 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803827969, ExchCode = 'FRA' WHERE SecCode = 64295 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587780409, PermQuoteRetireDate = '2025-04-30' WHERE SecCode = 64308 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808190091, ExchCode = 'DUS' WHERE SecCode = 65173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836332063, Ticker = 'LJP1', ExchCode = 'BER', PermQuoteRetireDate = '2010-04-04' 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 DomCntry = 'NLD' WHERE SecCode = 71554 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000281648, PermOrgIPODate = NULL WHERE SecCode = 90404 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000281648, IsPrimaryInstr = 0, PermOrgIPODate = NULL WHERE SecCode = 90405 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 91396 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 94048 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'CIV' WHERE SecCode = 95293 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788945141, PermQuoteStatus = 'AC', ExchCode = 'NGO', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 98177 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 100358 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 100730 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616157076, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 102656 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474909625, ExchCode = 'DEU' WHERE SecCode = 104360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21898461617, ExchCode = 'GTX' WHERE SecCode = 104387 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 111500 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22166504778, ExchCode = 'DEU' WHERE SecCode = 112091 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557034633, ExchCode = 'FRA' WHERE SecCode = 112135 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850703502, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 112185 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799606984, ExchCode = 'TDG' WHERE SecCode = 112420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857170641, ExchCode = 'QTX' WHERE SecCode = 112468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387792, ExchCode = 'LAS' WHERE SecCode = 112665 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 114020 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 115397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22208195921, PermQuoteStatus = 'AC', Ticker = 'M9W', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-09-21', PermSecMapEndDate = NULL WHERE SecCode = 128961 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'EGY' WHERE SecCode = 130009 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 = 21830301603, ExchCode = 'GTX' WHERE SecCode = 132188 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 134035 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 134735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954446, ExchCode = 'FRA' WHERE SecCode = 137616 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 139676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807916884, ExchCode = 'MUN' WHERE SecCode = 139792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804826539, ExchCode = 'FRA' WHERE SecCode = 141918 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799652656, ExchCode = 'FRA' WHERE SecCode = 144104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806640334, ExchCode = 'FRA' WHERE SecCode = 164924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872266716, ExchCode = 'MUN' WHERE SecCode = 165793 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545507629, ExchCode = 'DEU' WHERE SecCode = 173076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519747072, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 177695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21485216733, ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-06' WHERE SecCode = 177697 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768600966, ExchCode = 'FRA' WHERE SecCode = 177698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492890099, ExchCode = 'STU' WHERE SecCode = 177699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22188304213, ExchCode = 'DEU' WHERE SecCode = 177715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525218371, ExchCode = 'FRA' WHERE SecCode = 177724 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836336627, ExchCode = 'BER' WHERE SecCode = 177726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21498208225, ExchCode = 'BER', PermQuoteRetireDate = '2014-08-06' WHERE SecCode = 177732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836340185, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 177741 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22162372909, ExchCode = 'DEU' WHERE SecCode = 177750 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22140069477, ExchCode = 'DEU' WHERE SecCode = 177764 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892045199, ExchCode = 'GTX' WHERE SecCode = 177779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520043264, ExchCode = 'DEU' WHERE SecCode = 177783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787518979, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803403432, ExchCode = 'FRA' WHERE SecCode = 179031 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485116, ExchCode = 'QTX' WHERE SecCode = 185684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838610027, ExchCode = 'STU' WHERE SecCode = 185686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782121639, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 187719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492512279, ExchCode = 'STU', PermQuoteRetireDate = '2026-09-22', PermSecMapEndDate = NULL WHERE SecCode = 191220 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788425927, ExchCode = 'LAS' WHERE SecCode = 203057 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387779, ExchCode = 'LAS' WHERE SecCode = 206832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21790403420, ExchCode = 'DEU' WHERE SecCode = 249684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396967, ExchCode = 'FRA' WHERE SecCode = 249845 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21491138487, ExchCode = 'STU' WHERE SecCode = 249853 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576217363, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21572141339, ExchCode = 'HAM' WHERE SecCode = 289897 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21627202983, ExchCode = 'TDG', PermQuoteRetireDate = '2018-07-10' WHERE SecCode = 289915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804826538, ExchCode = 'FRA' WHERE SecCode = 291229 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-21' WHERE SecCode = 317813 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-22' WHERE SecCode = 323058 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 325933 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-23' WHERE SecCode = 332187 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 336410 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21586927759, ExchCode = 'FRA' WHERE SecCode = 341781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836321374, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 344005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784439422, ExchCode = 'FRA' WHERE SecCode = 352544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475961015, ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-20' WHERE SecCode = 387911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841145046, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 392215 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22208195912, ExchCode = 'DEU' WHERE SecCode = 507136 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851788339, InstrPermID = 8591342940, ValQuotePermID = 55851744316.0, Ticker = '000152934' WHERE SecCode = 538765 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522213543, ExchCode = 'STU' WHERE SecCode = 552003 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-21' WHERE SecCode = 554603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796184301, ExchCode = 'FRA' WHERE SecCode = 558485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856606624, ExchCode = 'GER' WHERE SecCode = 559437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801210148, ExchCode = 'FRA' WHERE SecCode = 587958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883771520, ExchCode = 'FRA' WHERE SecCode = 587985 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858781944, Ticker = '5OTZ', ExchCode = 'BER', PermQuoteRetireDate = '2014-12-18' WHERE SecCode = 587990 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910181876, ExchCode = 'FRA' WHERE SecCode = 588124 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801424687, ExchCode = 'FRA' WHERE SecCode = 588158 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727363720, ExchCode = 'MEX' WHERE SecCode = 612874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22037525784, ExchCode = 'DEU' WHERE SecCode = 909539 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883037235, ExchCode = 'MXQ' WHERE SecCode = 941913 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779561940, ExchCode = 'TDG' WHERE SecCode = 943158 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-09-22' WHERE SecCode = 948742 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 1221019 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-09-23', PermSecMapStartDate = '2011-07-08', PermSecMapEndDate = '2015-09-18' WHERE SecCode = 1235249 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CIV' WHERE SecCode = 1434690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511374004, ExchCode = 'STU' WHERE SecCode = 1480701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22181315457, ExchCode = 'OCE' WHERE SecCode = 1510139 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386003, ExchCode = 'LAS' WHERE SecCode = 1555435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532179505, ExchCode = 'STU' WHERE SecCode = 1555473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537129370, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2015-02-10' WHERE SecCode = 1555489 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21505548787, Ticker = 'ADIDAS', ExchCode = 'BUD' WHERE SecCode = 1607132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513238724, Ticker = 'BO4', ExchCode = 'FRA' WHERE SecCode = 1740287 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850059282, ExchCode = 'MUN' WHERE SecCode = 1929888 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544843699, ExchCode = 'FRA' WHERE SecCode = 2055322 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797256258, ExchCode = 'FRA' WHERE SecCode = 2239417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525967851, ExchCode = 'MUN' WHERE SecCode = 2278244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21555567980, ExchCode = 'STU' WHERE SecCode = 2365695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791287037, ExchCode = 'FRA' WHERE SecCode = 2379780 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532252447, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-11' WHERE SecCode = 2396449 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22181314611, ExchCode = 'OCE' WHERE SecCode = 2436778 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714451229, ExchCode = 'DXE' WHERE SecCode = 2436779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537405059, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 2505947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538883509, ExchCode = 'FRA' WHERE SecCode = 2529651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806536954, ExchCode = 'STU' WHERE SecCode = 2616472 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704962, ExchCode = 'MXQ' WHERE SecCode = 2644180 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704217, ExchCode = 'MXQ' WHERE SecCode = 2682301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785264811, ExchCode = 'FRA' WHERE SecCode = 2695638 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21915381162, ExchCode = 'DEU' WHERE SecCode = 2724348 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21555161223, ExchCode = 'MUN' WHERE SecCode = 2796969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803135586, ExchCode = 'FRA' WHERE SecCode = 2887314 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 3010342 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3029997 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 3119738 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3131033 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798143359, ExchCode = 'FRA' WHERE SecCode = 3186751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22202786243, ExchCode = 'BTE' WHERE SecCode = 3198703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614269130, ExchCode = 'MUN' WHERE SecCode = 3228617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596404721, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3247249 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597399146, ExchCode = 'FRA' WHERE SecCode = 3255012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798745908, ExchCode = 'FRA' WHERE SecCode = 3255118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597702395, ExchCode = 'FRA' WHERE SecCode = 3260047 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598617552, ExchCode = 'CHA' WHERE SecCode = 3261247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615255056, PermQuoteStatus = 'AC', Ticker = 'J5B0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3359146 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 3392502 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 3394015 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872584415, ExchCode = 'FRA' WHERE SecCode = 3395311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787474478, Ticker = 'UCGv', ExchCode = 'BCO' WHERE SecCode = 3395516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787359688, Ticker = 'STLAv', ExchCode = 'BCO' WHERE SecCode = 3395573 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809511768, Ticker = 'PCv', ExchCode = 'BCO' WHERE SecCode = 3395653 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792285260, Ticker = 'MEO2v', ExchCode = 'BCO' WHERE SecCode = 3395686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800300158, ExchCode = 'FRA' WHERE SecCode = 3397198 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797938211, ExchCode = 'FRA' WHERE SecCode = 3401535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655827920, ExchCode = 'FRA' WHERE SecCode = 3405605 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21627782972, ExchCode = 'FRA' WHERE SecCode = 3405606 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21628049890, ExchCode = 'FRA' WHERE SecCode = 3406027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802775523, ExchCode = 'FRA' WHERE SecCode = 3409155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801974006, ExchCode = 'FRA' WHERE SecCode = 3409158 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630052863, Ticker = 'CJC', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 3409167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662910606, ExchCode = 'DEU' WHERE SecCode = 3409176 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21839054794, ExchCode = 'DEU' WHERE SecCode = 3409178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21751443364, ExchCode = 'BER', PermQuoteRetireDate = '2023-01-20', PermSecMapEndDate = NULL WHERE SecCode = 3409186 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802292832, ExchCode = 'FRA' WHERE SecCode = 3409193 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545616304, InstrPermID = 21545616305, ValQuotePermID = 21545616304.0, Ticker = '750554', PermQuoteRetireDate = '2017-12-11', PermSecMapEndDate = '2017-12-11' WHERE SecCode = 3410233 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-21' WHERE SecCode = 3432500 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705592, ExchCode = 'MXQ' WHERE SecCode = 3434146 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 3434642 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 3435060 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 3436044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678578, ExchCode = 'BIV' WHERE SecCode = 3512964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777359772, ExchCode = 'STU' WHERE SecCode = 3518265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796646073, ExchCode = 'MUN' WHERE SecCode = 3525431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679944, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3566723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658213704, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-03', PermSecMapEndDate = NULL WHERE SecCode = 3566804 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669469691, ExchCode = 'DEU' WHERE SecCode = 3648237 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21673848109, ExchCode = 'BIV' WHERE SecCode = 3717229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381782, ExchCode = 'LAS' WHERE SecCode = 3739134 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000281648, IsPrimaryInstr = 0, PermOrgIPODate = NULL WHERE SecCode = 3747813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727370350, ExchCode = 'MEX' WHERE SecCode = 3862213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21699218063, ExchCode = 'FRA' WHERE SecCode = 3862230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22199369133, ExchCode = 'AQX' WHERE SecCode = 3875223 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 = 25727376591, ExchCode = 'MEX' WHERE SecCode = 3886856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727299601, ExchCode = 'A2X' WHERE SecCode = 3952738 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714798635, Ticker = '0A2Z', ExchCode = 'LSE' WHERE SecCode = 3986787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757864209, ExchCode = 'DEU' WHERE SecCode = 4018119 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787826668, Ticker = '1BACm', ExchCode = 'BCO' WHERE SecCode = 4031699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026781, Ticker = '1QCOM' WHERE SecCode = 4031700 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026748, Ticker = '1ELE' WHERE SecCode = 4031704 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809064403, Ticker = '1MSIm', ExchCode = 'BCO' WHERE SecCode = 4031708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026888, Ticker = '1HD' WHERE SecCode = 4031709 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026778, Ticker = '1IBM' WHERE SecCode = 4031713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027034, Ticker = '1JNPR' WHERE SecCode = 4031715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026934, Ticker = '1MS' WHERE SecCode = 4031717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026861, Ticker = '1PG' WHERE SecCode = 4031719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026732, Ticker = '1MRKX' WHERE SecCode = 4031720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026891, Ticker = '1ORCL' WHERE SecCode = 4031724 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 4032003 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012617, Ticker = '2PPG' WHERE SecCode = 4032642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999013524, Ticker = '2PH' WHERE SecCode = 4032644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792173541, Ticker = '1VLO', ExchCode = 'MIL' WHERE SecCode = 4032652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727357679, ExchCode = 'MEX' WHERE SecCode = 4049099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21739310110, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4134386 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771298503, ExchCode = 'FRA' WHERE SecCode = 4134450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756697174, ExchCode = 'FRA' WHERE SecCode = 4275426 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-23' WHERE SecCode = 4275853 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22181309700, ExchCode = 'OCU' WHERE SecCode = 4296947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770221779, ExchCode = 'FRA' WHERE SecCode = 4360099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21773606535, ExchCode = 'DEU' WHERE SecCode = 4372742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727211093, ExchCode = 'MEX' WHERE SecCode = 4381889 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767126615, ExchCode = 'DUS' WHERE SecCode = 4427933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786341373, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4443927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953217, ExchCode = 'FRA' WHERE SecCode = 4449787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727299966, ExchCode = 'MEX' WHERE SecCode = 4451248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788448754, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4451256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22208195927, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-09-21', PermSecMapEndDate = NULL WHERE SecCode = 4468561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22198133556, ExchCode = 'DEU' WHERE SecCode = 4468570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798227093, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4468572 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789568661, ExchCode = 'DEU' WHERE SecCode = 4468597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782121640, ExchCode = 'FRA' WHERE SecCode = 4500451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807429435, PermQuoteStatus = 'DC', Ticker = 'OXIA', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4500453 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727286505, ExchCode = 'BIV' WHERE SecCode = 4505794 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138127348, ExchCode = 'BCO' WHERE SecCode = 4506359 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801682142, ExchCode = 'UAX' WHERE SecCode = 4566926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810191528, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4573513 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-23' WHERE SecCode = 4576450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727265274, ExchCode = 'MEX' WHERE SecCode = 4579631 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830286428, ExchCode = 'GTX' WHERE SecCode = 4579634 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4615934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21827057976, ExchCode = 'DEU' WHERE SecCode = 4655597 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-22', PermSecMapEndDate = '2026-09-22' WHERE SecCode = 4656816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789434591, ExchCode = 'LAS', PermQuoteRetireDate = '2025-06-23' WHERE SecCode = 4687754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837527952, Ticker = 'CARB', ExchCode = 'MIL' WHERE SecCode = 4693652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244841, ExchCode = 'BIV' WHERE SecCode = 4695799 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-22', PermSecMapEndDate = '2026-09-22' WHERE SecCode = 4705896 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797256261, ExchCode = 'FRA' WHERE SecCode = 4733056 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858714593, ExchCode = 'STU', PermQuoteRetireDate = '2021-12-13', PermSecMapEndDate = '2021-12-13' WHERE SecCode = 4788710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22161390154, ExchCode = 'CHI' WHERE SecCode = 4806678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865296314, ExchCode = 'TDG' WHERE SecCode = 4810060 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22206808077, ExchCode = 'STU' WHERE SecCode = 4850980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21876879873, ExchCode = 'FRA' WHERE SecCode = 4898132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932898156, Ticker = '2CARm', ExchCode = 'BCO' WHERE SecCode = 4898138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21878340867, ExchCode = 'STU' WHERE SecCode = 4903819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781544706, ExchCode = 'QTX' WHERE SecCode = 4903820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886391659, ExchCode = 'MUN' WHERE SecCode = 4903821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21880172298, ExchCode = 'MUN' WHERE SecCode = 4903823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21880753667, PermQuoteStatus = 'AC', Ticker = '89E1', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4927414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22204824714, ExchCode = 'LAS' WHERE SecCode = 4965039 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22203115967, ExchCode = 'LAS' WHERE SecCode = 4965040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886412706, ExchCode = 'FRA' WHERE SecCode = 4965055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783262068, ExchCode = 'FRA' WHERE SecCode = 4970796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893554184, ExchCode = 'DEU' WHERE SecCode = 5002456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727197815, ExchCode = 'MEX' WHERE SecCode = 5005047 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21897111887, ExchCode = 'FRA' WHERE SecCode = 5028209 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21895366746, ExchCode = 'DEU' WHERE SecCode = 5037318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22188010891, ExchCode = 'LAS' WHERE SecCode = 5152288 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21923931000, PermQuoteStatus = 'AC', Ticker = '7KO1', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5162437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21920795449, ExchCode = 'CHA' WHERE SecCode = 5168048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775294004, ExchCode = 'BIV' WHERE SecCode = 5283359 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955770266, ExchCode = 'HAM' WHERE SecCode = 5297998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955219428, ExchCode = 'STU', PermQuoteRetireDate = '2024-11-26' WHERE SecCode = 5320940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21958059910, ExchCode = 'FRA' WHERE SecCode = 5354968 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380742, ExchCode = 'LAS' WHERE SecCode = 5515080 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21985646563, ExchCode = 'DEU' WHERE SecCode = 5515081 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779022885, ExchCode = 'STU' WHERE SecCode = 5515082 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388785, ExchCode = 'LAS', PermQuoteRetireDate = '2025-05-07' WHERE SecCode = 5515083 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778951124, ExchCode = 'BIV' WHERE SecCode = 5515087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22143010651, ExchCode = 'QTX' WHERE SecCode = 5535019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793574816, ExchCode = 'TDG' WHERE SecCode = 5623203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780960634, PermQuoteStatus = 'DC', Ticker = '8KD1', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5629239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781373925, ExchCode = 'BIV' WHERE SecCode = 5658309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781782677, ExchCode = 'MEX' WHERE SecCode = 5679079 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22032608571, ExchCode = 'DEU' WHERE SecCode = 5749727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22034763502, ExchCode = 'DEU' WHERE SecCode = 5764130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783529905, ExchCode = 'FRA' WHERE SecCode = 5764717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783158087, ExchCode = 'STU' WHERE SecCode = 5764783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22036716457, ExchCode = 'DEU' WHERE SecCode = 5779432 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22036716677, ExchCode = 'DEU' WHERE SecCode = 5779434 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000281648, PermOrgIPODate = NULL WHERE SecCode = 5785679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22111477357, ExchCode = 'TDG', PermSecMapEndDate = '2025-12-17' WHERE SecCode = 5785810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783671621, ExchCode = 'FRA' WHERE SecCode = 5799761 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783675132, ExchCode = 'FRA' WHERE SecCode = 5799763 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 5807949 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045401561, ExchCode = 'DEU' WHERE SecCode = 5833285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785347881, ExchCode = 'FRA' WHERE SecCode = 5886927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785347888, ExchCode = 'FRA' WHERE SecCode = 5886928 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785377120, ExchCode = 'FRA' WHERE SecCode = 5886944 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22054931225, ExchCode = 'DEU' WHERE SecCode = 5893286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22061495886, ExchCode = 'GTX' WHERE SecCode = 5920851 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5963924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787474514, ExchCode = 'FRA' WHERE SecCode = 5974296 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787517562, ExchCode = 'MUN' WHERE SecCode = 5974299 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795664148, ExchCode = 'MEX' WHERE SecCode = 6014420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788550183, ExchCode = 'BIV' WHERE SecCode = 6032901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789655528, ExchCode = 'GTX' WHERE SecCode = 6056912 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22078028826, ExchCode = 'DEU' WHERE SecCode = 6056913 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789695997, ExchCode = 'TDG' WHERE SecCode = 6063928 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22087520756, ExchCode = 'DEU' WHERE SecCode = 6135248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22087647673, ExchCode = 'DEU' WHERE SecCode = 6137619 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22087648369, ExchCode = 'DEU' WHERE SecCode = 6137620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790958707, ExchCode = 'GTX' WHERE SecCode = 6139932 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22089237738, ExchCode = 'DEU' WHERE SecCode = 6153859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791285966, PermQuoteStatus = 'DC', Ticker = 'WF70', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6198771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22096544023, ExchCode = 'DEU' WHERE SecCode = 6215308 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792547771, ExchCode = 'TDG' WHERE SecCode = 6258388 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792142925, ExchCode = 'FRA' WHERE SecCode = 6258511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792142924, ExchCode = 'FRA' WHERE SecCode = 6258512 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789803304, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-03-06', PermSecMapEndDate = '2026-03-06' WHERE SecCode = 6260557 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792305432, ExchCode = 'DUS', PermQuoteRetireDate = '2025-05-07' WHERE SecCode = 6271099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22104430810, ExchCode = 'DEU' WHERE SecCode = 6278572 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792558889, ExchCode = 'FRA' WHERE SecCode = 6286085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22105862270, ExchCode = 'GTX' WHERE SecCode = 6286094 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22156160741, ExchCode = 'GER' WHERE SecCode = 6291969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22115361512, ExchCode = 'DEU' WHERE SecCode = 6360726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22115361444, ExchCode = 'DEU' WHERE SecCode = 6360727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22115361658, ExchCode = 'DEU' WHERE SecCode = 6360728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22122894403, ExchCode = 'DEU' WHERE SecCode = 6418487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795129519, ExchCode = 'FRA' WHERE SecCode = 6438419 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'INDISA-OSA', PermQuoteRetireDate = '2026-10-20' WHERE SecCode = 6456382 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796143247, ExchCode = 'BIV' WHERE SecCode = 6465090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796367248, ExchCode = 'FRA' WHERE SecCode = 6474639 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22130335826, ExchCode = 'DEU' WHERE SecCode = 6482843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803309106, ExchCode = 'TDG' WHERE SecCode = 6490079 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22132979947, ExchCode = 'DEU' WHERE SecCode = 6492958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22135108793, ExchCode = 'DEU' WHERE SecCode = 6509466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22135125387, ExchCode = 'DEU' WHERE SecCode = 6509468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22135124892, ExchCode = 'DEU' WHERE SecCode = 6509469 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22135632203, ExchCode = 'DEU' WHERE SecCode = 6513064 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136103458, ExchCode = 'DEU' WHERE SecCode = 6515902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797894172, ExchCode = 'FRA' WHERE SecCode = 6515941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797894164, ExchCode = 'FRA' WHERE SecCode = 6515942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797894170, ExchCode = 'FRA' WHERE SecCode = 6515944 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797938214, ExchCode = 'FRA' WHERE SecCode = 6518577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798109633, ExchCode = 'QTX' WHERE SecCode = 6522493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798309550, ExchCode = 'STU' WHERE SecCode = 6533454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798384581, ExchCode = 'FRA' WHERE SecCode = 6533467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138976427, ExchCode = 'DEU' WHERE SecCode = 6538897 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798745906, ExchCode = 'FRA' WHERE SecCode = 6546195 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798743822, ExchCode = 'HAM' WHERE SecCode = 6546196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22139861440, ExchCode = 'DEU' WHERE SecCode = 6546267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22139861247, ExchCode = 'DEU' WHERE SecCode = 6546268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798745904, ExchCode = 'FRA' WHERE SecCode = 6546297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798947739, ExchCode = 'TDG' WHERE SecCode = 6548130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807670411, ExchCode = 'LAS' WHERE SecCode = 6562722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142175791, ExchCode = 'DEU' WHERE SecCode = 6564772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22141221275, ExchCode = 'MUN' WHERE SecCode = 6564781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142175888, ExchCode = 'DEU' WHERE SecCode = 6564784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142175677, ExchCode = 'DEU' WHERE SecCode = 6564786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799175964, ExchCode = 'FRA' WHERE SecCode = 6564787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799474943, ExchCode = 'FRA' WHERE SecCode = 6577960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800095946, ExchCode = 'MUN' WHERE SecCode = 6587280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22147089036, ExchCode = 'DEU' WHERE SecCode = 6603609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800748170, ExchCode = 'BIV' WHERE SecCode = 6612770 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22135541141, ExchCode = 'LAS' WHERE SecCode = 6617649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22151136920, ExchCode = 'DEU' WHERE SecCode = 6626033 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801425226, Ticker = 'J8J', ExchCode = 'FRA' WHERE SecCode = 6626774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801425230, ExchCode = 'FRA' WHERE SecCode = 6626775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22152475455, ExchCode = 'DEU' WHERE SecCode = 6627257 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801670239, ExchCode = 'FRA' WHERE SecCode = 6627688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802153068, ExchCode = 'FRA' WHERE SecCode = 6628699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22157135425, ExchCode = 'DEU' WHERE SecCode = 6642932 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802472349, ExchCode = 'BIV' WHERE SecCode = 6642943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22158115258, ExchCode = 'MIL' WHERE SecCode = 6649326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22158115255, ExchCode = 'MIL' WHERE SecCode = 6649337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 47763435966, ExchCode = 'FRA' WHERE SecCode = 6664706 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803400605, ExchCode = 'MUN' WHERE SecCode = 6664707 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798269903, ExchCode = 'BIV' WHERE SecCode = 6672554 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22161741374, ExchCode = 'DEU' WHERE SecCode = 6686046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22161764453, ExchCode = 'DEU' WHERE SecCode = 6686051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165249112, ExchCode = 'DEU' WHERE SecCode = 6712512 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165249067, ExchCode = 'DEU' WHERE SecCode = 6712513 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165249006, ExchCode = 'DEU' WHERE SecCode = 6712517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165927032, ExchCode = 'DEU' WHERE SecCode = 6721472 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165924852, ExchCode = 'DEU' WHERE SecCode = 6721473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165924835, ExchCode = 'DEU' WHERE SecCode = 6721474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165924009, ExchCode = 'DEU' WHERE SecCode = 6721475 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784382055, ExchCode = 'LAS' WHERE SecCode = 6724297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339217, Ticker = 'DDUM', ExchCode = 'LSE' WHERE SecCode = 6727855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804483809, ExchCode = 'QTX' WHERE SecCode = 6727870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168877362, ExchCode = 'DEU' WHERE SecCode = 6741050 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169958818, ExchCode = 'DEU' WHERE SecCode = 6753068 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169968263, ExchCode = 'DEU' WHERE SecCode = 6753069 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172111638, ExchCode = 'DEU' WHERE SecCode = 6773254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805995896, ExchCode = 'FRA' WHERE SecCode = 6796765 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805995898, ExchCode = 'FRA' WHERE SecCode = 6796766 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805995897, ExchCode = 'FRA' WHERE SecCode = 6796767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22093088014, ExchCode = 'MUN' WHERE SecCode = 6796811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22093088123, ExchCode = 'MUN' WHERE SecCode = 6796812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806017770, ExchCode = 'FRA' WHERE SecCode = 6796826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806017769, ExchCode = 'FRA' WHERE SecCode = 6796827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22175399896, ExchCode = 'DEU' WHERE SecCode = 6802854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806768822, ExchCode = 'FRA' WHERE SecCode = 6802855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806601936, ExchCode = 'TDG' WHERE SecCode = 6802856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22175402128, ExchCode = 'DEU' WHERE SecCode = 6802860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22179524855, ExchCode = 'DEU' WHERE SecCode = 6808918 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22180069249, ExchCode = 'QTX' WHERE SecCode = 6808922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22175714273, ExchCode = 'DEU' WHERE SecCode = 6813221 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22175714122, ExchCode = 'DEU' WHERE SecCode = 6813222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22202027951, ExchCode = 'HAM' WHERE SecCode = 6813223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257624, ExchCode = 'GER' WHERE SecCode = 6813269 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22176273238, ExchCode = 'DEU' WHERE SecCode = 6813914 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806412072, ExchCode = 'FRA' WHERE SecCode = 6820147 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22176579241, ExchCode = 'DEU' WHERE SecCode = 6820244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806467609, ExchCode = 'FRA' WHERE SecCode = 6826539 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806467608, ExchCode = 'FRA' WHERE SecCode = 6826548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806640335, ExchCode = 'FRA' WHERE SecCode = 6829248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22177706816, ExchCode = 'DEU' WHERE SecCode = 6829318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804912364, ExchCode = 'BIV' WHERE SecCode = 6832757 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805846159, ExchCode = 'TDG' WHERE SecCode = 6843130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806835443, ExchCode = 'FRA' WHERE SecCode = 6843132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806835441, ExchCode = 'FRA' WHERE SecCode = 6843133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806835442, ExchCode = 'FRA' WHERE SecCode = 6843134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22129769879, Ticker = NULL, ExchCode = 'GTX' WHERE SecCode = 6843135 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22179515385, ExchCode = 'MUN' WHERE SecCode = 6843187 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807255715, ExchCode = 'MUN' WHERE SecCode = 6862202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807347581, ExchCode = 'FRA' WHERE SecCode = 6868247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807481801, ExchCode = 'FRA' WHERE SecCode = 6873669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257598, ExchCode = 'DEU' WHERE SecCode = 6876677 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257592, ExchCode = 'DEU' WHERE SecCode = 6876680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257574, ExchCode = 'DEU' WHERE SecCode = 6876681 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257582, ExchCode = 'FRA' WHERE SecCode = 6876686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22173257701, ExchCode = 'DEU' WHERE SecCode = 6876691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807682207, ExchCode = 'FRA' WHERE SecCode = 6882001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22183258591, ExchCode = 'DEU' WHERE SecCode = 6887794 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22183962702, ExchCode = 'DEU' WHERE SecCode = 6890826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22183954222, ExchCode = 'DEU' WHERE SecCode = 6893691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807886146, ExchCode = 'BIV' WHERE SecCode = 6893698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807581063, ExchCode = 'MEX' WHERE SecCode = 6893701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807884625, ExchCode = 'LAS', PermQuoteRetireDate = '2026-07-20', PermSecMapEndDate = '2026-07-17' WHERE SecCode = 6893703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802592912, ExchCode = 'GTX' WHERE SecCode = 6897245 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951866.0 WHERE SecCode = 6900868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22185056479, ExchCode = 'DEU' WHERE SecCode = 6902190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22185377078, ExchCode = 'DEU' WHERE SecCode = 6902754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808190090, ExchCode = 'DUS' WHERE SecCode = 6911513 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808261246, ExchCode = 'GER' WHERE SecCode = 6914648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22186460351, ExchCode = 'QTX' WHERE SecCode = 6917600 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22186460349, ExchCode = 'QTX' WHERE SecCode = 6917602 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808548190, ExchCode = 'FRA' WHERE SecCode = 6923754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808548193, ExchCode = 'FRA' WHERE SecCode = 6923755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808682081, ExchCode = 'FRA' WHERE SecCode = 6930659 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22187911298, Ticker = 'G2LD', ExchCode = 'FRA' WHERE SecCode = 6930689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808682080, ExchCode = 'FRA' WHERE SecCode = 6939199 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808715498, ExchCode = 'TDG' WHERE SecCode = 6939205 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22191670865, ExchCode = 'MUN' WHERE SecCode = 6955205 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809058855, ExchCode = 'MEX' WHERE SecCode = 6955338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809271128, ExchCode = 'MEX' WHERE SecCode = 6960515 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236811595573, ExchCode = 'FRA' WHERE SecCode = 6967241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22192131052, ExchCode = 'DEU' WHERE SecCode = 6969118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809511917, ExchCode = 'MEX' WHERE SecCode = 6974573 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809511910, ExchCode = 'TDG' WHERE SecCode = 6982407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809727615, ExchCode = 'MUN' WHERE SecCode = 6982411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809732422, ExchCode = 'FRA' WHERE SecCode = 6982412 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236809892291, ExchCode = 'MUN' WHERE SecCode = 6986008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236810391926, ExchCode = 'MEX' WHERE SecCode = 7003908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236810455058, ExchCode = 'FRA' WHERE SecCode = 7006676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236811393930, ExchCode = 'FRA' WHERE SecCode = 7020272 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236811393928, ExchCode = 'FRA' WHERE SecCode = 7020275 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236812368622, ExchCode = 'QTX' WHERE SecCode = 7037235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236811589404, ExchCode = 'TDG' WHERE SecCode = 7044310 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 7064203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236812998751, ExchCode = 'FRA' WHERE SecCode = 7067766 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236812998767, ExchCode = 'FRA' WHERE SecCode = 7067776 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 7073108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236813132091, ExchCode = 'FRA' WHERE SecCode = 7073132 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-21' WHERE SecCode = 7093153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236814397965, ExchCode = 'MEX' WHERE SecCode = 7101475 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-22' WHERE SecCode = 7102978 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 10988877 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = NULL, PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11025338 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11077579 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11150378 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-23' WHERE SecCode = 11155739 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11165204 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 11166786 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 11180081 AND Type_ = 1; UPDATE data_universe_permid SET IncCntry = 'ESP' WHERE SecCode = 11211798 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11224809 AND Type_ = 1; UPDATE data_universe_permid SET PriTrdQuotePermID = 236799613258.0 WHERE SecCode = 11241835 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11260721 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11264576 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11275439 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NSM' WHERE SecCode = 11277492 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11285543 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11285565 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11285570 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11285620 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11285629 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11285632 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11285676 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11285750 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11285752 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-22' WHERE SecCode = 11285756 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2026-09-17' WHERE SecCode = 11301986 AND Type_ = 1;