UPDATE data_universe_permid SET QuotePermID = 55836047499, Ticker = 'AAT', ExchCode = 'LSE', PermQuoteRetireDate = '2012-11-12' WHERE SecCode = 13 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836052415, Ticker = 'ZHEH', ExchCode = 'LSE', PermQuoteRetireDate = '2023-05-19' WHERE SecCode = 9121 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718461399, Ticker = '0Q1Nl', ExchCode = 'BCO' WHERE SecCode = 9338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836049459, Ticker = 'PACC', ExchCode = 'LSE', PermQuoteRetireDate = '2016-03-07' WHERE SecCode = 9856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475556856, Ticker = 'KPN', ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 9908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'GEVI' WHERE SecCode = 29687 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 32930 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475429707, ExchCode = 'MUN', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 34074 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836394620, ExchCode = 'FRA', PermQuoteRetireDate = '2022-04-01' WHERE SecCode = 34155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667481067, PermQuoteStatus = 'AC', Ticker = 'AEC1', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 34462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632622059, ExchCode = 'BER' WHERE SecCode = 34937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837366078, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 35746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859213205, ExchCode = 'FRA', PermQuoteRetireDate = '2012-06-26' WHERE SecCode = 37893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830303797, ExchCode = 'GTX' WHERE SecCode = 38625 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531126213, Ticker = 'EICd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-05-02' WHERE SecCode = 38658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21573767893, ExchCode = 'STU' WHERE SecCode = 38731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475605956, Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 38771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662115397, ExchCode = 'TDG', PermQuoteRetireDate = '2019-07-11' WHERE SecCode = 38789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475624187, Ticker = 'SCX', ExchCode = 'MUN', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792268563, PermQuoteStatus = 'AC', Ticker = 'GVM0', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 46388 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690620527, ExchCode = 'RTB' WHERE SecCode = 46535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475801256, Ticker = 'MKAd', ExchCode = 'SIG' WHERE SecCode = 48328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475604368, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2006-03-08' WHERE SecCode = 55766 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 56011 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21550289362, ExchCode = 'STU', PermQuoteRetireDate = '2019-01-09' WHERE SecCode = 57589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21491259017, ExchCode = 'STU', PermQuoteRetireDate = '2012-04-10' WHERE SecCode = 57595 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 PermSecMapEndDate = '2025-09-26' WHERE SecCode = 59951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837358186, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842305273, ExchCode = 'STU' WHERE SecCode = 60190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836439407, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838243010, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 60261 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337787, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 60304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492943, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 60564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475030486, ExchCode = 'FRA' WHERE SecCode = 60596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837359160, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836339538, ExchCode = 'BER' WHERE SecCode = 60831 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781938162, ExchCode = 'GTX' WHERE SecCode = 62212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474854031, ExchCode = 'DEU' WHERE SecCode = 62694 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 71866 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 78585 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 5095645950, Ticker = '416A', PermOrgIPODate = '2025-10-01', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 80309 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'TMIUF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-26', PermSecMapEndDate = NULL WHERE SecCode = 86364 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-26' WHERE SecCode = 97202 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 99030 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5095636250, PriInstrPermID = NULL, IsPrimaryInstr = 0, Ticker = '417A', PermOrgIPODate = '2025-10-01', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 99138 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836528997, Ticker = 'SKG1', ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 104043 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 110311 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 111747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561140807, ExchCode = 'FRA' WHERE SecCode = 113074 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 114630 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835799001, ExchCode = 'MEX' WHERE SecCode = 122906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835799363, ExchCode = 'MEX' 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 = 21525792698, ExchCode = 'DEU' WHERE SecCode = 131777 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 137691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21787765870, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-20', PermSecMapEndDate = '2025-01-20' WHERE SecCode = 138990 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 144125 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 144506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552519207, ExchCode = 'DUS', PermQuoteRetireDate = '2014-12-16' WHERE SecCode = 144542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21526396053, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2017-04-24' WHERE SecCode = 145644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547457028, ExchCode = 'STU' WHERE SecCode = 145923 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 PermSecMapEndDate = '2025-09-26' WHERE SecCode = 169894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22126226638, ExchCode = 'DEU' 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 = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759692070, ExchCode = 'FRA' WHERE SecCode = 178391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566116516, ExchCode = 'STU' WHERE SecCode = 186400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536544263, ExchCode = 'DEU' WHERE SecCode = 186428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782179201, ExchCode = 'GTX' WHERE SecCode = 203057 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849054917, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 203070 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784278058, ExchCode = 'STU' WHERE SecCode = 255607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749838939, ExchCode = 'FRA' WHERE SecCode = 287571 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794261329, ExchCode = 'DEU' WHERE SecCode = 296129 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 304979 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836320461, ExchCode = 'BER', PermQuoteRetireDate = '2017-10-03' WHERE SecCode = 312934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531772020, ExchCode = 'STU' WHERE SecCode = 319526 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 323828 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-25', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 326895 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21667479301, ExchCode = 'QTX' WHERE SecCode = 330665 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21950784269, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 330668 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 331506 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55834671261, PermQuoteStatus = 'AC', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 335172 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 336022 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 336183 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 350834 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862774028, ExchCode = 'MXQ' WHERE SecCode = 529546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307223, ExchCode = 'MEX' WHERE SecCode = 542395 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-26' WHERE SecCode = 551335 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859743506, ExchCode = 'FRA', PermQuoteRetireDate = '2015-12-22' WHERE SecCode = 637343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886391671, ExchCode = 'GTX' WHERE SecCode = 696378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55863005195, Ticker = 'BABC', ExchCode = 'LSE' WHERE SecCode = 703518 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475065837, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 780725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55876477262, Ticker = 'XGLI', ExchCode = 'LSE', PermQuoteRetireDate = '2013-09-20' WHERE SecCode = 1192765 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482394593, Ticker = 'BLITs', ExchCode = 'BUR', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 1456636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494566098, ExchCode = 'STU' WHERE SecCode = 1514883 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482802786, Ticker = 'PU7D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1514908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492897197, ExchCode = 'STU' WHERE SecCode = 1539178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21505572951, Ticker = NULL, ExchCode = 'ISE', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 1603990 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514715669, ExchCode = 'FRA' WHERE SecCode = 1748432 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21628061495, ExchCode = 'DEU' WHERE SecCode = 1755109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517016445, ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 2018342 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780428233, ExchCode = 'GTX' WHERE SecCode = 2050473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369367, ExchCode = 'SGO' WHERE SecCode = 2195863 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 = 25727306937, ExchCode = 'BEC' WHERE SecCode = 2226896 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370247, ExchCode = 'SGO' WHERE SecCode = 2232870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705392, ExchCode = 'MXQ' WHERE SecCode = 2292972 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732298199, ExchCode = 'DUS' WHERE SecCode = 2366514 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 2366515 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 2380633 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384965, ExchCode = 'LAS' WHERE SecCode = 2452397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644443169, ExchCode = 'TDG', PermQuoteRetireDate = '2020-04-15' WHERE SecCode = 2453131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21534233299, ExchCode = 'DEU' WHERE SecCode = 2453132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782629896, Ticker = 'HM6A', ExchCode = 'FRA' WHERE SecCode = 2453144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805177421, ExchCode = 'MUN' WHERE SecCode = 2453146 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727167, ExchCode = 'FRA' WHERE SecCode = 2487645 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535535867, ExchCode = 'BCO', PermQuoteRetireDate = '2014-05-14' WHERE SecCode = 2494242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537032595, ExchCode = 'BER' WHERE SecCode = 2495669 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'BTF' WHERE SecCode = 2495862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430820, ExchCode = 'DEU' WHERE SecCode = 2513107 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21622038833, Ticker = '22N0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 2513110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538082108, ExchCode = 'DEU' WHERE SecCode = 2514695 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = 'SCHLR', PermQuoteRetireDate = '2025-02-14', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 2515727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538369189, ExchCode = 'FRA' WHERE SecCode = 2521751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538369359, ExchCode = 'FRA' WHERE SecCode = 2521752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609327643, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-07-22' WHERE SecCode = 2522906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539179038, ExchCode = 'DEU' WHERE SecCode = 2532820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21618954036, ExchCode = 'STU' WHERE SecCode = 2532826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535196434, Ticker = 'PCE1', ExchCode = 'BRN' WHERE SecCode = 2537377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540268047, ExchCode = 'FRA' WHERE SecCode = 2544431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21688529407, Ticker = '53S1', ExchCode = 'DUS', PermQuoteRetireDate = '2021-06-25' WHERE SecCode = 2550286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542817374, ExchCode = 'FRA' WHERE SecCode = 2570568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543087948, ExchCode = 'DEU' WHERE SecCode = 2572303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545190668, ExchCode = 'FRA', PermQuoteRetireDate = '2014-12-29' WHERE SecCode = 2578855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543101908, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13' WHERE SecCode = 2579445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550101787, ExchCode = 'FRA' WHERE SecCode = 2579447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543709073, ExchCode = 'FRA' WHERE SecCode = 2584743 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545670880, ExchCode = 'AUX' WHERE SecCode = 2600061 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545107336, ExchCode = 'DEU' WHERE SecCode = 2604390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545264705, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-15' WHERE SecCode = 2613148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384980, ExchCode = 'LAS' WHERE SecCode = 2617118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642374749, ExchCode = 'DEU' WHERE SecCode = 2621782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796405572, PermQuoteStatus = 'AC', Ticker = 'MTX1N', ExchCode = 'MEX', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-09-26', PermSecMapEndDate = NULL WHERE SecCode = 2625105 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557589745, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-30' WHERE SecCode = 2642445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782381281, ExchCode = 'QTX' WHERE SecCode = 2642446 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370299, ExchCode = 'GTX' WHERE SecCode = 2642447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548045877, ExchCode = 'DEU' WHERE SecCode = 2642451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548046381, ExchCode = 'STU' WHERE SecCode = 2642452 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785534619, ExchCode = 'QTX' WHERE SecCode = 2642453 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538237, ExchCode = 'GTX' WHERE SecCode = 2642455 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478457, ExchCode = 'QTX' WHERE SecCode = 2642458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548204121, ExchCode = 'FRA' WHERE SecCode = 2644168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782535985, ExchCode = 'QTX', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 2644169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777698966, ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-25' WHERE SecCode = 2650629 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548773265, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2653612 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589641130, ExchCode = 'STU' WHERE SecCode = 2654800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173515, Ticker = 'RNL', ExchCode = 'BRN' WHERE SecCode = 2682171 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605933864, ExchCode = 'MUN' WHERE SecCode = 2698369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551920812, ExchCode = 'MUN' WHERE SecCode = 2700708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584014278, ExchCode = 'BTE', PermQuoteRetireDate = '2021-06-01' WHERE SecCode = 2720682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630041766, ExchCode = 'TDG' WHERE SecCode = 2720693 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656673120, ExchCode = 'BIV' WHERE SecCode = 2743609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533308745, ExchCode = 'FRA' WHERE SecCode = 2747656 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727198716, ExchCode = 'MEX' WHERE SecCode = 2750976 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790104617, ExchCode = 'QTX' WHERE SecCode = 2764598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367198, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2770609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322186, ExchCode = 'DEU' WHERE SecCode = 2809751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557589784, ExchCode = 'DEU' WHERE SecCode = 2810887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557265431, ExchCode = 'DEU' WHERE SecCode = 2810889 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387968, ExchCode = 'LAS' WHERE SecCode = 2821450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558551421, ExchCode = 'DEU' WHERE SecCode = 2827908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634749387, ExchCode = 'MUN' WHERE SecCode = 2830909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557544170, ExchCode = 'MUN', PermQuoteRetireDate = '2018-07-05' WHERE SecCode = 2837420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560390655, ExchCode = 'STU' WHERE SecCode = 2841897 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830274949, ExchCode = 'GTX' WHERE SecCode = 2855817 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598465846, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 2857019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460829, ExchCode = 'GER' WHERE SecCode = 2864471 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563865313, ExchCode = 'DEU' WHERE SecCode = 2867587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17' WHERE SecCode = 2868670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732998267, ExchCode = 'QTX' WHERE SecCode = 2872658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629955940, ExchCode = 'TDG' WHERE SecCode = 2876219 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21619609060, ExchCode = 'MUN' WHERE SecCode = 2887282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562944695, ExchCode = 'DEU' WHERE SecCode = 2887317 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564309877, ExchCode = 'FRA' WHERE SecCode = 2902752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943057400, ExchCode = 'STU' WHERE SecCode = 2906394 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-26' WHERE SecCode = 2909909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564888920, ExchCode = 'FRA' WHERE SecCode = 2909921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779358960, ExchCode = 'GTX' WHERE SecCode = 2909922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565402682, ExchCode = 'FRA' WHERE SecCode = 2910684 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2910685 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830285585, ExchCode = 'GTX' WHERE SecCode = 2910709 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565404048, ExchCode = 'FRA' WHERE SecCode = 2912969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565696892, ExchCode = 'FRA' WHERE SecCode = 2918012 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 = 21915623096, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 2921698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21568560697, ExchCode = 'FRA' WHERE SecCode = 2929653 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609211564, Ticker = '34LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-21', PermSecMapEndDate = NULL WHERE SecCode = 2935091 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672243657, PermQuoteStatus = 'DC', Ticker = '16IE', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2935960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953914119, ExchCode = 'GTX' WHERE SecCode = 2935971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21567481828, ExchCode = 'FRA', PermQuoteRetireDate = '2020-05-07' WHERE SecCode = 2936005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856730657, ExchCode = 'STU' WHERE SecCode = 2944415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704188, ExchCode = 'MXQ' WHERE SecCode = 2944451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762568152, ExchCode = 'MUN', PermQuoteRetireDate = '2022-06-07' WHERE SecCode = 2944460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21569155612, ExchCode = 'STU' WHERE SecCode = 2947855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778891239, ExchCode = 'STU' 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 = 21645306003, ExchCode = 'DEU' WHERE SecCode = 2955208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21641460082, ExchCode = 'BER' WHERE SecCode = 2958533 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21722919701, ExchCode = 'BER' WHERE SecCode = 2963590 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862726926, ExchCode = 'MUN' WHERE SecCode = 2975172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667488199, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591511845, ExchCode = 'BER' WHERE SecCode = 2998198 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606219347, ExchCode = 'MUN' WHERE SecCode = 2998199 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3001072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21687895439, ExchCode = 'STU' WHERE SecCode = 3008027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21573513500, ExchCode = 'DEU' WHERE SecCode = 3015987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21574472931, ExchCode = 'STU' WHERE SecCode = 3024440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704999, ExchCode = 'MXQ' WHERE SecCode = 3024446 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884459792, ExchCode = 'GTX' WHERE SecCode = 3025383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830286312, ExchCode = 'GTX' WHERE SecCode = 3026614 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576625962, ExchCode = 'FRA' WHERE SecCode = 3026615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21743260230, ExchCode = 'FRA' WHERE SecCode = 3030075 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885152284, ExchCode = 'STU' WHERE SecCode = 3031579 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585829107, ExchCode = 'STU' WHERE SecCode = 3031598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21603201534, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-04', PermSecMapEndDate = NULL WHERE SecCode = 3033923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740543, ExchCode = 'LAS' WHERE SecCode = 3038477 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818952836, ExchCode = 'DUS' WHERE SecCode = 3045201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21509907547, ExchCode = 'SGO' WHERE SecCode = 3054221 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21578813192, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-26' WHERE SecCode = 3056842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661537406, ExchCode = 'BER' WHERE SecCode = 3059437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788253479, ExchCode = 'BIV' WHERE SecCode = 3060652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611487587, ExchCode = 'FRA' WHERE SecCode = 3069354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811991744, ExchCode = 'DEU' WHERE SecCode = 3074354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792293391, ExchCode = 'FRA' WHERE SecCode = 3074402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587055379, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14', PermSecMapEndDate = '2020-06-16' WHERE SecCode = 3076717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916285720, ExchCode = 'DUS' WHERE SecCode = 3076725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21700996629, ExchCode = 'BER' WHERE SecCode = 3083484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21580910339, ExchCode = 'DEU' WHERE SecCode = 3090322 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21583964280, ExchCode = 'FRA' WHERE SecCode = 3112921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587109521, ExchCode = 'DEU' WHERE SecCode = 3116969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779496553, ExchCode = 'GTX' WHERE SecCode = 3120784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045077935, ExchCode = 'LAS' WHERE SecCode = 3124235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761432069, ExchCode = 'DEU' WHERE SecCode = 3125028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781544679, ExchCode = 'DUS' WHERE SecCode = 3125957 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2023-12-21', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 3128125 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704364, Ticker = 'BRSS*', ExchCode = 'MXQ' WHERE SecCode = 3130990 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632622175, Ticker = '0R9Ul', ExchCode = 'BCO' WHERE SecCode = 3156022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599860501, ExchCode = 'STU' WHERE SecCode = 3169823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749466038, ExchCode = 'MUN' WHERE SecCode = 3181133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21588626416, ExchCode = 'FRA' WHERE SecCode = 3181677 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21993578551, Ticker = '3EMLl', ExchCode = 'BTE' WHERE SecCode = 3193773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589591762, ExchCode = 'FRA' WHERE SecCode = 3195464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667481833, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 3196331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782758877, ExchCode = 'SIG' WHERE SecCode = 3197040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21590371242, ExchCode = 'FRA' WHERE SecCode = 3199702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21590429261, ExchCode = 'DEU' WHERE SecCode = 3199703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608121110, ExchCode = 'TDG', PermQuoteRetireDate = '2017-07-14' WHERE SecCode = 3201372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781343900, ExchCode = 'STU' WHERE SecCode = 3206355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21937100717, ExchCode = 'QTX' WHERE SecCode = 3208355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655926812, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-08', PermSecMapEndDate = '2023-06-08' WHERE SecCode = 3213267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732126690, ExchCode = 'MUN', PermQuoteRetireDate = '2023-09-29', PermSecMapEndDate = '2023-09-29' WHERE SecCode = 3215568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821641516, ExchCode = 'DUS', PermQuoteRetireDate = '2025-08-21', PermSecMapEndDate = NULL WHERE SecCode = 3219383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21868288662, ExchCode = 'BER' WHERE SecCode = 3222984 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801066780, ExchCode = 'DEU' WHERE SecCode = 3223419 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747327546, ExchCode = 'BER' WHERE SecCode = 3228617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386946, ExchCode = 'LAS' WHERE SecCode = 3230847 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598163107, ExchCode = 'STU' WHERE SecCode = 3236427 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614079174, ExchCode = 'TDG', PermQuoteRetireDate = '2017-05-25' WHERE SecCode = 3241570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595700790, ExchCode = 'TDG' WHERE SecCode = 3247292 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785348456, ExchCode = 'DUS' WHERE SecCode = 3247427 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779584053, ExchCode = 'GTX' WHERE SecCode = 3247560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21601632367, Ticker = 'DRGd', ExchCode = 'BCO', PermQuoteRetireDate = '2020-04-16' WHERE SecCode = 3247729 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597660312, ExchCode = 'AUX' WHERE SecCode = 3256336 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21643695294, ExchCode = 'FRA' WHERE SecCode = 3257553 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598801020, ExchCode = 'DEU' WHERE SecCode = 3260792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598617552, ExchCode = 'CHA' WHERE SecCode = 3261247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681742828, ExchCode = 'DEU' WHERE SecCode = 3266309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882266791, ExchCode = 'HAN' WHERE SecCode = 3269645 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21604819939, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 3271586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598843077, ExchCode = 'MEX' WHERE SecCode = 3275597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679808, ExchCode = 'BIV' WHERE SecCode = 3275598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679283, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3275604 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858452378, ExchCode = 'BER', PermQuoteRetireDate = '2023-02-23' WHERE SecCode = 3280089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792256326, ExchCode = 'MUN' WHERE SecCode = 3282366 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21755977768, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3282701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21604346350, ExchCode = 'BER', PermQuoteRetireDate = '2022-01-06' WHERE SecCode = 3283289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793397049, ExchCode = 'FRA' WHERE SecCode = 3283696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602606939, ExchCode = 'TDG', PermQuoteRetireDate = '2019-02-01' WHERE SecCode = 3283717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605132679, ExchCode = 'STU', PermQuoteRetireDate = '2019-02-06' WHERE SecCode = 3283966 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624943992, ExchCode = 'FRA' WHERE SecCode = 3288205 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611042214, Ticker = '73M', ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3295278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478588, ExchCode = 'QTX' WHERE SecCode = 3295294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606316234, ExchCode = 'DEU' WHERE SecCode = 3301693 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835371, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 3301728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606471109, ExchCode = 'DEU' WHERE SecCode = 3301863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609616, ExchCode = 'DUS' WHERE SecCode = 3303268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21639800655, PermQuoteStatus = 'DC', Ticker = 'KYH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-09' WHERE SecCode = 3305367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667482882, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 3305485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552260, ExchCode = 'LAS' WHERE SecCode = 3307824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21993741793, Ticker = 'SGBXl', ExchCode = 'AQX' WHERE SecCode = 3309467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658651750, ExchCode = 'TDG' WHERE SecCode = 3315888 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781234907, ExchCode = 'BER' WHERE SecCode = 3317120 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658809885, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3317174 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609269032, ExchCode = 'DEU' WHERE SecCode = 3317854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782181314, ExchCode = 'QTX' WHERE SecCode = 3317906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685841805, ExchCode = 'STU' WHERE SecCode = 3317931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611219956, ExchCode = 'MUN', PermQuoteRetireDate = '2022-12-08', PermSecMapEndDate = '2022-12-08' WHERE SecCode = 3318355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21651645775, ExchCode = 'FRA' WHERE SecCode = 3319220 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610379931, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-10', PermSecMapEndDate = NULL WHERE SecCode = 3319844 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21912102337, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-09' WHERE SecCode = 3319868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21753722337, ExchCode = 'DEU' WHERE SecCode = 3320207 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801448965, ExchCode = 'DEU' WHERE SecCode = 3321109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387046, ExchCode = 'LAS' WHERE SecCode = 3322821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615835543, ExchCode = 'FRA', PermQuoteRetireDate = '2022-09-27' WHERE SecCode = 3324152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611321674, ExchCode = 'FRA' WHERE SecCode = 3327824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21612598732, ExchCode = 'DEU' WHERE SecCode = 3342863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647220847, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-04' WHERE SecCode = 3347668 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788220383, ExchCode = 'STU' WHERE SecCode = 3352147 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679488, ExchCode = 'BIV' WHERE SecCode = 3357132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656673877, ExchCode = 'BIV' WHERE SecCode = 3357134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679466, ExchCode = 'BIV' WHERE SecCode = 3358352 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615253063, ExchCode = 'TDG' WHERE SecCode = 3358543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615498721, ExchCode = 'FRA' WHERE SecCode = 3363519 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615998446, Ticker = '14G', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3366981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632742042, ExchCode = 'MUN' WHERE SecCode = 3367946 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783783668, ExchCode = 'QTX' WHERE SecCode = 3367998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21631611214, ExchCode = 'TDG' WHERE SecCode = 3377762 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617889189, ExchCode = 'AUX' WHERE SecCode = 3378309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381342, ExchCode = 'LAS' WHERE SecCode = 3378316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21618954032, ExchCode = 'STU' WHERE SecCode = 3379346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625753506, ExchCode = 'BTE' WHERE SecCode = 3385974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21622425444, PermQuoteStatus = 'AC', Ticker = 'C5B0', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3391113 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796141211, ExchCode = 'SIG' WHERE SecCode = 3392282 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3396332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790014898, ExchCode = 'BER' WHERE SecCode = 3401720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21764861300, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-01', PermSecMapEndDate = '2021-10-01' WHERE SecCode = 3402310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624461914, ExchCode = 'STU', PermQuoteRetireDate = '2017-10-26', PermSecMapEndDate = '2017-10-26' WHERE SecCode = 3402759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718790665, ExchCode = 'BTE' WHERE SecCode = 3404188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704620, ExchCode = 'MXQ' WHERE SecCode = 3404480 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629642715, ExchCode = 'BER' WHERE SecCode = 3407252 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630755583, ExchCode = 'STU', PermQuoteRetireDate = '2020-02-25' WHERE SecCode = 3408843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381227, ExchCode = 'LAS', PermQuoteRetireDate = '2025-02-04' WHERE SecCode = 3408942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818264981, ExchCode = 'FRA' WHERE SecCode = 3409089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729890620, ExchCode = 'FRA' WHERE SecCode = 3409161 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 = 236784388177, ExchCode = 'LAS' WHERE SecCode = 3409178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752240759, ExchCode = 'MUN', PermQuoteRetireDate = '2023-01-23', PermSecMapEndDate = NULL WHERE SecCode = 3409186 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784235976, ExchCode = 'FRA' WHERE SecCode = 3430350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633808516, Ticker = 'LEMSE', ExchCode = 'STO' WHERE SecCode = 3430374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674899, ExchCode = 'BIV' WHERE SecCode = 3430658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796870307, PermQuoteStatus = 'DC', Ticker = '1GQ', ExchCode = 'DEU', PermQuoteRetireDate = '2021-11-22' WHERE SecCode = 3430801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809128702, Ticker = '1JF', ExchCode = 'DEU', PermQuoteRetireDate = '2021-11-22' WHERE SecCode = 3430802 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 3432019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858470979, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-03' WHERE SecCode = 3436782 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3437929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997875, ExchCode = 'FRA' WHERE SecCode = 3439465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788404566, ExchCode = 'QTX' WHERE SecCode = 3439533 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640560144, ExchCode = 'DEU' WHERE SecCode = 3439542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796141667, ExchCode = 'TDG' WHERE SecCode = 3445201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644992133, Ticker = 'CASl', ExchCode = 'BCO', PermQuoteRetireDate = '2019-11-26' WHERE SecCode = 3446120 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788075106, ExchCode = 'TDG' WHERE SecCode = 3490864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100415, ExchCode = 'QTX' WHERE SecCode = 3509155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803757309, ExchCode = 'DUS' WHERE SecCode = 3531554 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21653402147, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-26' WHERE SecCode = 3532701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812350928, ExchCode = 'FRA' WHERE SecCode = 3532727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720015426, ExchCode = 'FRA' WHERE SecCode = 3533827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762721933, ExchCode = 'BER' WHERE SecCode = 3535859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21654538231, ExchCode = 'STU' WHERE SecCode = 3543305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21680887156, ExchCode = 'MUN' WHERE SecCode = 3545291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727195, ExchCode = 'FRA' WHERE SecCode = 3551874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380197, ExchCode = 'LAS' WHERE SecCode = 3555035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660706887, ExchCode = 'STU' WHERE SecCode = 3555038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656850928, ExchCode = 'FRA' WHERE SecCode = 3558191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21657694230, ExchCode = 'BIV' WHERE SecCode = 3573698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856218033, ExchCode = 'SGO' WHERE SecCode = 3587010 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21619168949, ExchCode = 'STU' WHERE SecCode = 3587019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660609678, ExchCode = 'DEU' WHERE SecCode = 3588082 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21775216436, ExchCode = 'MUN' WHERE SecCode = 3588083 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731995361, ExchCode = 'DEU' WHERE SecCode = 3588110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681872250, ExchCode = 'FRA' WHERE SecCode = 3588112 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734197812, ExchCode = 'FRA' WHERE SecCode = 3588113 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770642439, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-04-09' WHERE SecCode = 3619536 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667202587, ExchCode = 'MUN' WHERE SecCode = 3629787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681018002, ExchCode = 'FRA' WHERE SecCode = 3654098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099419588, Ticker = '2NFLl', ExchCode = 'BTE' WHERE SecCode = 3669927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21675114251, ExchCode = 'FRA' WHERE SecCode = 3694578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21947054171, ExchCode = 'FRA' WHERE SecCode = 3738157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788220426, ExchCode = 'TDG' WHERE SecCode = 3756592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917520379, ExchCode = 'FRA' WHERE SecCode = 3784710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21687527636, ExchCode = 'BER' WHERE SecCode = 3791543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735310231, ExchCode = 'STU' WHERE SecCode = 3832752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373316, ExchCode = 'BIV' WHERE SecCode = 3843165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388256, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3844919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854173220, ExchCode = 'DUS' WHERE SecCode = 3849234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781544655, ExchCode = 'DUS' WHERE SecCode = 3875222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702427526, ExchCode = 'GER' WHERE SecCode = 3875223 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 = 21709209283, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727367066, ExchCode = 'MEX' WHERE SecCode = 3909638 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725178113, ExchCode = 'BER' WHERE SecCode = 3956835 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779115555, ExchCode = 'STU' WHERE SecCode = 3959923 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713324973, Ticker = '2TE', ExchCode = 'STU', PermQuoteRetireDate = '2024-07-01' WHERE SecCode = 3965202 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '351' WHERE SecCode = 3968253 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21924367856, ExchCode = 'GTX' WHERE SecCode = 3987746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718910978, ExchCode = 'FRA' WHERE SecCode = 4001066 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718911035, ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-07' WHERE SecCode = 4001067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21719305244, ExchCode = 'QTX' WHERE SecCode = 4001204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727361949, ExchCode = 'BIV' WHERE SecCode = 4001279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720521413, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-12', PermSecMapEndDate = '2024-08-21' WHERE SecCode = 4010838 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026873, Ticker = '1BAC', ExchCode = 'MIL' WHERE SecCode = 4031699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026866, Ticker = '1BIIB' WHERE SecCode = 4031705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787711134, Ticker = '1ADEm', ExchCode = 'BCO' WHERE SecCode = 4031783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727358933, ExchCode = 'MEX' WHERE SecCode = 4033123 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21751582009, ExchCode = 'MUN' WHERE SecCode = 4034103 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21726901115, ExchCode = 'QTX' WHERE SecCode = 4038748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788219439, ExchCode = 'BER' WHERE SecCode = 4046673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727358597, ExchCode = 'MEX' WHERE SecCode = 4058582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21870301372, ExchCode = 'MUN' WHERE SecCode = 4068293 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781158017, ExchCode = 'STU' WHERE SecCode = 4080599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818713443, PermQuoteStatus = 'DC', Ticker = '4E40', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 4101126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774179873, Ticker = '7M4', ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 4103711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21738226580, ExchCode = 'BER' WHERE SecCode = 4124713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388439, ExchCode = 'LAS' WHERE SecCode = 4124714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727352699, ExchCode = 'MEX' WHERE SecCode = 4134210 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4139243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' 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 = 21744918743, ExchCode = 'DEU' WHERE SecCode = 4193439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958418, ExchCode = 'DEU' WHERE SecCode = 4209245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781858560, ExchCode = 'QTX' WHERE SecCode = 4209247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958036, ExchCode = 'DEU' WHERE SecCode = 4209248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772833533, PermQuoteStatus = 'AC', Ticker = '4U1A', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4212367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727350455, ExchCode = 'MEX' WHERE SecCode = 4212368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388481, ExchCode = 'LAS' WHERE SecCode = 4248831 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781684880, ExchCode = 'QTX' WHERE SecCode = 4274161 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757456175, ExchCode = 'FRA' WHERE SecCode = 4277594 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759454138, ExchCode = 'FRA' WHERE SecCode = 4291629 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 5095636250, PriInstrPermID = NULL, IsPrimaryInstr = 0, PermOrgIPODate = '2025-10-01', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 4303572 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727342155, ExchCode = 'BIV' WHERE SecCode = 4315098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762580130, ExchCode = 'FRA' WHERE SecCode = 4315115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381904, ExchCode = 'LAS' WHERE SecCode = 4321331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763596291, ExchCode = 'DUS' WHERE SecCode = 4321393 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766441949, ExchCode = 'STU' WHERE SecCode = 4324721 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791430982, ExchCode = 'GTX' WHERE SecCode = 4333278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727340440, ExchCode = 'BIV' WHERE SecCode = 4333534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21768596580, ExchCode = 'TDG' WHERE SecCode = 4351435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777156626, ExchCode = 'STU' WHERE SecCode = 4355923 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SCGP-R' WHERE SecCode = 4388305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778281522, ExchCode = 'STU', PermQuoteRetireDate = '2025-03-14' WHERE SecCode = 4394756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21826495190, ExchCode = 'DUS', PermQuoteRetireDate = '2022-05-31', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 4395464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778893656, ExchCode = 'DEU', PermQuoteRetireDate = '2020-11-23' WHERE SecCode = 4400157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307749, ExchCode = 'MEX' WHERE SecCode = 4404027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778680491 WHERE SecCode = 4406073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21783161157, PermQuoteStatus = 'AC', ExchCode = 'BER', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4415732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803077161, ExchCode = 'FRA' 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 = 21815337110, ExchCode = 'DEU' WHERE SecCode = 4423907 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779047734, ExchCode = 'BER', PermQuoteRetireDate = '2024-04-05', PermSecMapEndDate = NULL WHERE SecCode = 4427929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786088087, ExchCode = 'BER' WHERE SecCode = 4438384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788448773, ExchCode = 'STU' WHERE SecCode = 4447601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727306258, ExchCode = 'BIV' WHERE SecCode = 4456073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791932285, ExchCode = 'DUS' WHERE SecCode = 4462870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793689591, ExchCode = 'FRA' WHERE SecCode = 4474387 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794817527, ExchCode = 'DEU' WHERE SecCode = 4481104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727291861, ExchCode = 'BIV' WHERE SecCode = 4485970 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807264731, ExchCode = 'MUN' WHERE SecCode = 4485993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798564611, ExchCode = 'DEU' WHERE SecCode = 4502501 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830285167, ExchCode = 'GTX' WHERE SecCode = 4511507 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800727409, ExchCode = 'DEU' WHERE SecCode = 4513651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801066759, ExchCode = 'DEU' WHERE SecCode = 4517641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802423082, ExchCode = 'FRA' WHERE SecCode = 4526148 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4542550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22097656226, ExchCode = 'DEU' WHERE SecCode = 4553852 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381354, ExchCode = 'LAS' WHERE SecCode = 4557929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777449320, ExchCode = 'TDG' WHERE SecCode = 4568460 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 = 21819145875, ExchCode = 'TDG' WHERE SecCode = 4592046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778820333, ExchCode = 'QTX' WHERE SecCode = 4595746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727305821, ExchCode = 'MEX' WHERE SecCode = 4597223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816288537, ExchCode = 'FRA' WHERE SecCode = 4609999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387260, Ticker = 'WWT', ExchCode = 'LAS' WHERE SecCode = 4615948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818967405, ExchCode = 'DEU' WHERE SecCode = 4620159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816912799, ExchCode = 'DEU', PermQuoteRetireDate = '2021-06-14' WHERE SecCode = 4620951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778181553, ExchCode = 'STU' WHERE SecCode = 4623226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818729626, ExchCode = 'FRA', PermQuoteRetireDate = '2021-06-22', PermSecMapEndDate = NULL WHERE SecCode = 4631952 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820739194, ExchCode = 'FRA' WHERE SecCode = 4631954 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312167, ExchCode = 'GTX' WHERE SecCode = 4637756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823819949, ExchCode = 'QTX' WHERE SecCode = 4640283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650261, ExchCode = 'DUS', PermQuoteRetireDate = '2025-01-16', PermSecMapEndDate = '2025-01-17' WHERE SecCode = 4643054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21824689924, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 4649982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21827621995, ExchCode = 'FRA' WHERE SecCode = 4657695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21838659452, ExchCode = 'TDG' WHERE SecCode = 4693646 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851139181, Ticker = '6XZ', ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-25', PermSecMapEndDate = '2023-08-10' WHERE SecCode = 4699239 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'PIXFAM' WHERE SecCode = 4712678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887745393, ExchCode = 'GTX' WHERE SecCode = 4713798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842619599, ExchCode = 'FRA' WHERE SecCode = 4713800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788449235, ExchCode = 'TDG' WHERE SecCode = 4724684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845567605, ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-06' WHERE SecCode = 4726108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852758887, ExchCode = 'STU' WHERE SecCode = 4752188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854895784, ExchCode = 'FRA' WHERE SecCode = 4767878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856710535, ExchCode = 'BER' WHERE SecCode = 4777235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857898826, ExchCode = 'FRA' WHERE SecCode = 4784525 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552638, ExchCode = 'LAS', PermQuoteRetireDate = '2025-06-19', PermSecMapEndDate = NULL WHERE SecCode = 4787454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859334827, ExchCode = 'DEU' WHERE SecCode = 4792475 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 4804556 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21618957147, ExchCode = 'FRA', PermQuoteRetireDate = '2023-05-12' WHERE SecCode = 4804834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823760, ExchCode = 'AQX' WHERE SecCode = 4806676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904417561, ExchCode = 'MUN' WHERE SecCode = 4810002 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 = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4819878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866536811, ExchCode = 'STU' WHERE SecCode = 4827915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861142851, ExchCode = 'DEU' WHERE SecCode = 4829216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487241, ExchCode = 'FRA' WHERE SecCode = 4845067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872586664, ExchCode = 'DEU' WHERE SecCode = 4873682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727204885, ExchCode = 'MEX' WHERE SecCode = 4911170 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779515354, ExchCode = 'GTX' WHERE SecCode = 4918607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21880159462, ExchCode = 'DUS' WHERE SecCode = 4925631 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882178034, ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-29', PermSecMapEndDate = '2022-03-29' WHERE SecCode = 4934327 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21911875594, PermQuoteStatus = 'AC', Ticker = 'VC9', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4952514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727200981, ExchCode = 'MEX' WHERE SecCode = 4956738 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21936307256, ExchCode = 'MUN' WHERE SecCode = 4969558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888276703, ExchCode = 'GTX' WHERE SecCode = 4972276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902368752, ExchCode = 'STU' WHERE SecCode = 4973332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888279622, ExchCode = 'MUN' WHERE SecCode = 4983996 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21894951764, ExchCode = 'DUS' WHERE SecCode = 4991558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580261, ExchCode = 'GER' WHERE SecCode = 4991678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21891752426, ExchCode = 'DEU', PermQuoteRetireDate = '2024-07-09' WHERE SecCode = 4991682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902921017, ExchCode = 'DUS' WHERE SecCode = 5041763 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902946895, ExchCode = 'DEU' WHERE SecCode = 5067501 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 5072231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777910905, ExchCode = 'GTX' WHERE SecCode = 5075859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21905202976, ExchCode = 'GTX' WHERE SecCode = 5083963 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910168364, ExchCode = 'DUS' WHERE SecCode = 5094355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21908064114, ExchCode = 'FRA' WHERE SecCode = 5102905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727193104, ExchCode = 'BIV' WHERE SecCode = 5107678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910416267, ExchCode = 'FRA' WHERE SecCode = 5115641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370469, ExchCode = 'GTX' WHERE SecCode = 5123687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913292330, ExchCode = 'GER' WHERE SecCode = 5129708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913101536, ExchCode = 'QTX' WHERE SecCode = 5129748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796327838, Ticker = 'RHETAN', ExchCode = 'NSI' WHERE SecCode = 5144072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917841458, ExchCode = 'DEU' WHERE SecCode = 5152350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21508528400, ExchCode = 'DEU' WHERE SecCode = 5161278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792173203, ExchCode = 'FRA' WHERE SecCode = 5161343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727308116, Ticker = 'WPMl', ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921223663, ExchCode = 'STU' WHERE SecCode = 5166540 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21919946283, ExchCode = 'DEU' WHERE SecCode = 5166568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380662, ExchCode = 'LAS' WHERE SecCode = 5168258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388864, ExchCode = 'LAS' WHERE SecCode = 5174430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933953345, ExchCode = 'TDG' WHERE SecCode = 5189077 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727198685, PermQuoteStatus = 'AC', ExchCode = 'BIV', PermQuoteRetireDate = NULL WHERE SecCode = 5206281 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21928854434, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5209798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21928837077, ExchCode = 'BER' WHERE SecCode = 5218830 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 = 236780027032, Ticker = '1HU3' WHERE SecCode = 5258607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938039570, ExchCode = 'DEU' WHERE SecCode = 5277529 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 5281305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775107117, ExchCode = 'MEX' WHERE SecCode = 5283390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943068431, ExchCode = 'DEU', PermQuoteRetireDate = '2025-08-15' WHERE SecCode = 5299987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21937480514, ExchCode = 'BER' WHERE SecCode = 5310445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775732426, ExchCode = 'BIV' WHERE SecCode = 5329511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957548196, ExchCode = 'DEU' WHERE SecCode = 5370902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21958061854, Ticker = 'ACAGv', ExchCode = 'BCO' WHERE SecCode = 5372903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776581931, ExchCode = 'MEX' WHERE SecCode = 5381916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21960524424, ExchCode = 'DEU' WHERE SecCode = 5388849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777336250, ExchCode = 'FRA' WHERE SecCode = 5399892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21964596409, ExchCode = 'DEU' WHERE SecCode = 5403196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045078258, ExchCode = 'LAS' WHERE SecCode = 5458313 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778622371, ExchCode = 'BER' WHERE SecCode = 5490578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21986459012, Ticker = 'USFAl', ExchCode = 'SIG' WHERE SecCode = 5516823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223797, ExchCode = 'QTX' WHERE SecCode = 5516829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780228916, ExchCode = 'MUN' WHERE SecCode = 5541689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223803, ExchCode = 'QTX' WHERE SecCode = 5541690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21990415641, ExchCode = 'DEU' WHERE SecCode = 5541691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471348, ExchCode = 'STU' WHERE SecCode = 5541732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471351, ExchCode = 'STU' WHERE SecCode = 5541733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779461582, ExchCode = 'FRA' WHERE SecCode = 5542014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778760132, ExchCode = 'MEX' WHERE SecCode = 5569424 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541308584, PermQuoteStatus = 'DC', Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 5569431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780978843, ExchCode = 'FRA' WHERE SecCode = 5620203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781224681, ExchCode = 'BER' WHERE SecCode = 5631688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781981055, ExchCode = 'MEX' WHERE SecCode = 5701235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22077468957, Ticker = 'SOXLl', ExchCode = 'BCO' WHERE SecCode = 5702908 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22026840053, ExchCode = 'STU' WHERE SecCode = 5703208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782109053, ExchCode = 'MEX' WHERE SecCode = 5709076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031887415, ExchCode = 'DEU' WHERE SecCode = 5742856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031887387, ExchCode = 'DEU' WHERE SecCode = 5742857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22033339866, ExchCode = 'DEU' WHERE SecCode = 5749956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783309192, ExchCode = 'BIV' WHERE SecCode = 5801442 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783847363, ExchCode = 'STU' WHERE SecCode = 5805681 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783878429, ExchCode = 'FRA' WHERE SecCode = 5805700 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783879182, ExchCode = 'FRA' WHERE SecCode = 5805706 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783933614, ExchCode = 'FRA' WHERE SecCode = 5807637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783933611, ExchCode = 'FRA' WHERE SecCode = 5807638 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783934287, ExchCode = 'TDG' WHERE SecCode = 5807639 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601266, ExchCode = 'FRA' WHERE SecCode = 5842621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601265, ExchCode = 'FRA' WHERE SecCode = 5842622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601263, ExchCode = 'FRA' WHERE SecCode = 5842623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785217028, ExchCode = 'FRA' WHERE SecCode = 5881402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785217025, ExchCode = 'FRA' WHERE SecCode = 5881403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785461020, ExchCode = 'FRA' WHERE SecCode = 5888374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785605367, Ticker = '4WL0', ExchCode = 'FRA', PermQuoteRetireDate = '2025-04-30', PermSecMapEndDate = '2025-04-30' WHERE SecCode = 5894939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786553288, ExchCode = 'FRA' WHERE SecCode = 5936516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22070354815, ExchCode = 'DEU' WHERE SecCode = 6012971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727354996, ExchCode = 'MEX' WHERE SecCode = 6097383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784422712, ExchCode = 'BIV' WHERE SecCode = 6097386 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727345444, ExchCode = 'MEX' WHERE SecCode = 6097390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21972857485, ExchCode = 'MXQ' WHERE SecCode = 6097467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 6097473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790283706, ExchCode = 'FRA' WHERE SecCode = 6119927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790713136, ExchCode = 'FRA' WHERE SecCode = 6151862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790713137, ExchCode = 'FRA' WHERE SecCode = 6151863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22093081351, ExchCode = 'DEU' WHERE SecCode = 6186428 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099430639, ExchCode = 'QTX' WHERE SecCode = 6240370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798226363, ExchCode = 'BER' WHERE SecCode = 6256420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22101906830, ExchCode = 'DEU' WHERE SecCode = 6258508 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 6264181 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793538137, ExchCode = 'FRA' WHERE SecCode = 6289750 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793789294, ExchCode = 'TDG' WHERE SecCode = 6426995 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 6431522 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 6440008 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'CAMAROE' WHERE SecCode = 6441634 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795294193, ExchCode = 'FRA' WHERE SecCode = 6445725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795294192, ExchCode = 'FRA' WHERE SecCode = 6445726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796266831, IsPrimaryQuote = 1, ExchCode = 'TYO' WHERE SecCode = 6448820 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 6449023 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 6456237 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2025-09-29' WHERE SecCode = 6457846 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128784882, ExchCode = 'QTX' WHERE SecCode = 6462856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22129582236, ExchCode = 'DEU' WHERE SecCode = 6467534 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6472013 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236796328295.0, IsPrimaryQuote = 1 WHERE SecCode = 6472158 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236796348986.0 WHERE SecCode = 6472160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796368089, ExchCode = 'GTC', PermSecMapStartDate = '2025-09-25' WHERE SecCode = 11049978 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11059176 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11072382 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 11107687 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11134171 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11134234 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11144261 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'BHICD' WHERE SecCode = 11211233 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11215120 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11216608 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727266635, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'PNK', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11222812 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'LYTHD' WHERE SecCode = 11242832 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11244761 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11257617 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11273603 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11273609 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11276819 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11276820 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11280073 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11280077 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11280078 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11280079 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11280081 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11280083 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-09-26', PermSecMapEndDate = '2025-09-26' WHERE SecCode = 11280084 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236796330784, PermSecMapStartDate = '2025-09-25' WHERE SecCode = 11285503 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11285716 AND Type_ = 1; UPDATE data_universe_permid SET ValQuotePermID = 236796330793.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1 WHERE SecCode = 11285809 AND Type_ = 1;