UPDATE data_universe_permid SET QuotePermID = 55847137216, Ticker = 'ABBY.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 24 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141212, PermQuoteStatus = 'AC', Ticker = 'GLBl', ExchCode = 'SIG', PermQuoteRetireDate = NULL WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727202014, ExchCode = 'SIG' WHERE SecCode = 1879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531136784, Ticker = 'ZHEHl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-08-29' WHERE SecCode = 9121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629381057, Ticker = '0Q1N', ExchCode = 'LSE' WHERE SecCode = 9338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475530716, Ticker = 'OAK', ExchCode = 'VTX', PermQuoteRetireDate = '2006-09-21' WHERE SecCode = 9856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475556855, Ticker = '31QX', ExchCode = 'LSE', PermQuoteRetireDate = '2008-04-25' WHERE SecCode = 9908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634297975, Ticker = '0KXAl', ExchCode = 'BCO' WHERE SecCode = 10268 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-20' WHERE SecCode = 27786 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 29674 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 31046 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 31059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 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, PermSecMapEndDate = NULL WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622059, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837366078, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 35746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330930, ExchCode = 'BER', PermQuoteRetireDate = '2023-09-21' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469912, ExchCode = 'QTX' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034103, PermQuoteStatus = 'AC', Ticker = 'CPA', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 37361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035699, PermQuoteStatus = 'AC', Ticker = 'GOB', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 37392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518925174, PermQuoteStatus = 'AC', Ticker = 'DSE', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 38247 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 44481 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325490, ExchCode = 'BER', PermQuoteRetireDate = '2010-04-30' WHERE SecCode = 47291 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 49081 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667485029, ExchCode = 'QTX' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 52185 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21584354094, ExchCode = 'TDG', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 54284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475417017, ExchCode = 'STU', PermQuoteRetireDate = '2009-11-18' WHERE SecCode = 54686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591308334, ExchCode = 'STU' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630231241, Ticker = 'STF', ExchCode = 'STU' WHERE SecCode = 57832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325590, ExchCode = 'BER' WHERE SecCode = 57850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399700, ExchCode = 'FRA', PermQuoteRetireDate = '2016-02-12' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836518711, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 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 = 21475572974, Ticker = 'NSUG.I', ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339538, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' 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 = 21548206934, ExchCode = 'DEU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ZAAGD' WHERE SecCode = 61432 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805161989, ExchCode = 'BTE' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485966, ExchCode = 'QTX' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339184, ExchCode = 'BER', PermQuoteRetireDate = '2019-04-24' WHERE SecCode = 62115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475428110, ExchCode = 'GER' WHERE SecCode = 64940 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 65204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329646, ExchCode = 'BER' WHERE SecCode = 65414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487385255, ExchCode = 'STU', PermQuoteRetireDate = '2019-02-06' WHERE SecCode = 65643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346502, ExchCode = 'STU', PermQuoteRetireDate = '2019-08-01' WHERE SecCode = 65700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419375, ExchCode = 'HAM' WHERE SecCode = 66686 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 68350 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ZYLM' WHERE SecCode = 73937 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'TKMOD' WHERE SecCode = 76663 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 77892 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 81841 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-19' WHERE SecCode = 83612 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 84304 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 84612 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 84990 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 86949 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'BYOGD' WHERE SecCode = 87243 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 88334 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2004-04-01' WHERE SecCode = 98629 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21898260294, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369672, ExchCode = 'BIV' WHERE SecCode = 113051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330072, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 136933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540736583, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334976, ExchCode = 'DEU' WHERE SecCode = 145923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308280, ExchCode = 'GTX' WHERE SecCode = 147900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308439, ExchCode = 'GTX' WHERE SecCode = 147907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339056, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-12' WHERE SecCode = 147913 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273282, ExchCode = 'GTX' WHERE SecCode = 164791 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 165534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858577, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28', PermSecMapEndDate = '2024-03-28' WHERE SecCode = 177409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837357816, ExchCode = 'GER' WHERE SecCode = 177415 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 178064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838699115, ExchCode = 'STU' WHERE SecCode = 179171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714469392, Ticker = 'SELm', ExchCode = 'DXE' WHERE SecCode = 196630 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-05-20' WHERE SecCode = 243253 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794261329, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519091, ExchCode = 'DUS' WHERE SecCode = 319526 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-20' WHERE SecCode = 327476 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236804396433, ExchCode = 'QTX' WHERE SecCode = 335262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214201, ExchCode = 'BIV' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851190611, ExchCode = 'BER' WHERE SecCode = 534603 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 556442 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2024-11-11' WHERE SecCode = 577384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255889, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 600391 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'OMA' WHERE SecCode = 968923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996312, ExchCode = 'MUN' WHERE SecCode = 1303639 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 1397379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109482, ExchCode = 'DEU' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653590213, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561587, ExchCode = 'DUS' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512147101, Ticker = 'BRDG', ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494566098, ExchCode = 'STU' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802786, Ticker = 'PU7D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487020931, ExchCode = 'FRA' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487384788, ExchCode = 'FRA' WHERE SecCode = 1522268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629706417, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488654213, ExchCode = 'STU', PermQuoteRetireDate = '2022-12-19' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646184463, PermQuoteStatus = 'AC', Ticker = '5EV0', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 1525470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497767, ExchCode = 'DEU' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071858, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098667, ExchCode = 'FRA' WHERE SecCode = 1527502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490780237, ExchCode = 'FRA' WHERE SecCode = 1529275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558559889, ExchCode = 'STU' WHERE SecCode = 1531694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531043659, ExchCode = 'STU' WHERE SecCode = 1532769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524560434, Ticker = 'RBTQ', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 1533786 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 1535709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492888711, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-25' WHERE SecCode = 1537137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787321763, ExchCode = 'FRA' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492713347, ExchCode = 'STU' WHERE SecCode = 1537214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270027, ExchCode = 'DEU' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493834048, ExchCode = 'TDG' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800721447, ExchCode = 'FRA' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775091198, ExchCode = 'FRA' WHERE SecCode = 1541396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492779438, ExchCode = 'BUR' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502889367, ExchCode = 'STU', PermQuoteRetireDate = '2016-07-11' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511700265, PermQuoteStatus = 'AC', Ticker = '7NU1', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786220381, ExchCode = 'STU' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496860026, ExchCode = 'FRA' WHERE SecCode = 1546652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830305592, ExchCode = 'GTX' WHERE SecCode = 1547496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679444, ExchCode = 'BIV' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21497743025, ExchCode = 'DEU' WHERE SecCode = 1552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583635011, ExchCode = 'FRA' WHERE SecCode = 1552943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21499307444, Ticker = '5GQ', ExchCode = 'TDG', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 1554222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498521053, ExchCode = 'DEU' WHERE SecCode = 1556381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501626987, ExchCode = 'STU' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502150126, ExchCode = 'STU' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615254983, ExchCode = 'DEU' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234899, ExchCode = 'QTX' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308444, ExchCode = 'STU' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505186360, ExchCode = 'BUR' WHERE SecCode = 1596529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505421178, ExchCode = 'STU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506514608, ExchCode = 'BER' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537280920, ExchCode = 'STU', PermQuoteRetireDate = '2023-08-15' WHERE SecCode = 1630461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512104207, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-09' WHERE SecCode = 1655572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629962634, Ticker = '7O2', ExchCode = 'STU' WHERE SecCode = 1656414 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 1660083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511217511, ExchCode = 'STU' WHERE SecCode = 1675781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511202969, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 1675785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531120618, Ticker = 'CHMTp', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-08' WHERE SecCode = 1677246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613032675, ExchCode = 'STU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520358, ExchCode = 'FRA' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679815, ExchCode = 'BIV' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512394339, ExchCode = 'FRA' WHERE SecCode = 1699181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512769043, ExchCode = 'FRA' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528495416, ExchCode = 'CHI' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514715669, ExchCode = 'FRA', PermQuoteRetireDate = '2015-08-11' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513489767, ExchCode = 'FRA' WHERE SecCode = 1778982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 1924626 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 2082530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521327105, ExchCode = 'FRA' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337983, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2126923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519816623, ExchCode = 'FRA' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379476, ExchCode = 'LAS', PermQuoteRetireDate = '2026-01-27', PermSecMapEndDate = NULL WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951460.0 WHERE SecCode = 2229093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524070827, ExchCode = 'FRA' WHERE SecCode = 2240608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967851, ExchCode = 'MUN' WHERE SecCode = 2278244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529849856, ExchCode = 'BER' WHERE SecCode = 2288360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670714959, ExchCode = 'TDG' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781213703, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255542, ExchCode = 'DEU' WHERE SecCode = 2357967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529795323, ExchCode = 'STU' WHERE SecCode = 2357969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530042418, ExchCode = 'DEU' WHERE SecCode = 2357974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530493513, ExchCode = 'FRA' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369453, ExchCode = 'BEC' WHERE SecCode = 2377498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705370, ExchCode = 'MXQ' WHERE SecCode = 2407194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532996934, ExchCode = 'FRA' WHERE SecCode = 2421101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22005177098, ExchCode = 'DEU' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842517697, ExchCode = 'SGO' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489670, ExchCode = 'QTX' WHERE SecCode = 2448345 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 = 21696140082, ExchCode = 'QTX' WHERE SecCode = 2522906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835976, Ticker = '53S1d', ExchCode = 'BCO', PermQuoteRetireDate = '2021-09-27' WHERE SecCode = 2550286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542469532, ExchCode = 'DEU' WHERE SecCode = 2567216 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 2568211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542889448, ExchCode = 'MUN', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 2578855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712051521, Ticker = '3HCS', ExchCode = 'MIL' WHERE SecCode = 2600076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544378913, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-23' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549690613, ExchCode = 'TDG' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 2682415 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 2696813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804841423, ExchCode = 'HAM' WHERE SecCode = 2725364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554500349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-03' WHERE SecCode = 2750984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652008408, ExchCode = 'TDG' WHERE SecCode = 2807599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308386, ExchCode = 'GTX' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557589734, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-25' WHERE SecCode = 2837420 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 2854331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955946, ExchCode = 'TDG' WHERE SecCode = 2856999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603343761, ExchCode = 'TDG' WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561660659, ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-16', PermSecMapEndDate = '2021-08-19' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428180, ExchCode = 'GTX' WHERE SecCode = 2887226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563124035, ExchCode = 'FRA' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564939130, ExchCode = 'FRA' WHERE SecCode = 2909928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830042, ExchCode = 'QTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100485, ExchCode = 'QTX' WHERE SecCode = 2937567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479103, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 2937569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568851024, ExchCode = 'DEU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675024, ExchCode = 'BIV' WHERE SecCode = 2963604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3002458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792943751, ExchCode = 'GER', PermQuoteRetireDate = '2022-08-11' WHERE SecCode = 3010358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479551, ExchCode = 'QTX', PermQuoteRetireDate = '2022-11-16' WHERE SecCode = 3011183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724821997, Ticker = '9GL', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2024-04-10' WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21579812407, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3068301 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 = 21581022534, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3083485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608475923, ExchCode = 'STU' WHERE SecCode = 3085564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275202, ExchCode = 'GTX' WHERE SecCode = 3098021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582927995, ExchCode = 'FRA' WHERE SecCode = 3101224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583580936, Ticker = 'NMK', ExchCode = 'GER', PermQuoteRetireDate = '2017-05-15' WHERE SecCode = 3104810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584213518, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-21', PermSecMapEndDate = '2022-10-21' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673910, ExchCode = 'BIV' WHERE SecCode = 3120787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953916121, ExchCode = 'GTX' WHERE SecCode = 3124235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320061, ExchCode = 'DEU' WHERE SecCode = 3124241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544679, ExchCode = 'DUS' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-19' WHERE SecCode = 3148614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536846008, ExchCode = 'FRA', PermQuoteRetireDate = '2018-07-11' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587290084, ExchCode = 'MUN' WHERE SecCode = 3160192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916283528, ExchCode = 'BER' WHERE SecCode = 3160205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22027361754, ExchCode = 'STU' WHERE SecCode = 3160206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705845, ExchCode = 'MXQ' WHERE SecCode = 3166848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588488685, PermQuoteStatus = 'DC', ExchCode = 'BCO', PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2025-02-03' WHERE SecCode = 3177550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548007973, ExchCode = 'DEU' WHERE SecCode = 3177608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588924118, ExchCode = 'DEU' WHERE SecCode = 3177801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284723, ExchCode = 'GTX' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627445525, ExchCode = 'BTE' WHERE SecCode = 3186834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901754747, ExchCode = 'BCO' WHERE SecCode = 3193718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460752, ExchCode = 'FRA' WHERE SecCode = 3195424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460735, ExchCode = 'FRA' WHERE SecCode = 3195425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460751, ExchCode = 'FRA' WHERE SecCode = 3195426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589835342, ExchCode = 'DEU' WHERE SecCode = 3196992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169497784, ExchCode = 'DEU' WHERE SecCode = 3196993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786090185, ExchCode = 'TDG' WHERE SecCode = 3198703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768480038, ExchCode = 'MUN' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590446182, ExchCode = 'DEU' WHERE SecCode = 3200605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590831223, ExchCode = 'STU' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388055, ExchCode = 'LAS' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591674218, ExchCode = 'TDG' WHERE SecCode = 3208863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655814, Ticker = '4VOW3', ExchCode = 'ETX' WHERE SecCode = 3212165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591798940, ExchCode = 'TDG' WHERE SecCode = 3212190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448726, ExchCode = 'FRA' WHERE SecCode = 3213266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625006481, ExchCode = 'DEU' WHERE SecCode = 3215534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077242, ExchCode = 'LAS' WHERE SecCode = 3219367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592711298, ExchCode = 'DEU', PermQuoteRetireDate = '2025-08-20', PermSecMapEndDate = '2025-08-20' WHERE SecCode = 3219383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747575641, ExchCode = 'QTX' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864000075, ExchCode = 'DEU' WHERE SecCode = 3229528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634471937, ExchCode = 'MUN' WHERE SecCode = 3241011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788491422, Ticker = '0EFd', ExchCode = 'BCO' WHERE SecCode = 3246454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100768, ExchCode = 'DUS' WHERE SecCode = 3247170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478399, ExchCode = 'QTX' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597399146, ExchCode = 'FRA' WHERE SecCode = 3255012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597335837, ExchCode = 'DEU' WHERE SecCode = 3255028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598615492, ExchCode = 'STU', PermQuoteRetireDate = '2016-11-08' WHERE SecCode = 3260094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800109, ExchCode = 'BTE' WHERE SecCode = 3263198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704183, ExchCode = 'MXQ' WHERE SecCode = 3271811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517543534, ExchCode = 'FRA' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602047609, ExchCode = 'MUN' WHERE SecCode = 3282881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602528931, ExchCode = 'DEU' WHERE SecCode = 3283650 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 = 21693152594, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3301805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833126, ExchCode = 'FRA' WHERE SecCode = 3304184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639800655, Ticker = 'KYH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-09' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 3306846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947516, ExchCode = 'STU' WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482861, ExchCode = 'QTX' 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 = 21762320047, ExchCode = 'FRA' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864390192, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650199, ExchCode = 'DUS' WHERE SecCode = 3392279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644928542, ExchCode = 'BER', PermQuoteRetireDate = '2022-06-21', PermSecMapEndDate = '2022-08-03' WHERE SecCode = 3393655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378719, ExchCode = 'BRN' WHERE SecCode = 3394008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623803395, ExchCode = 'FRA' WHERE SecCode = 3396014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624541573, ExchCode = 'FRA' WHERE SecCode = 3400265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761303133, ExchCode = 'TDG' WHERE SecCode = 3404546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097182, ExchCode = 'LAS' WHERE SecCode = 3405304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100842, ExchCode = 'DUS' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705811, Ticker = 'TLNDN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256348, ExchCode = 'DUS' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791407498, ExchCode = 'LAS', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 3408727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168120, ExchCode = 'FRA' WHERE SecCode = 3408941 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 = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932188, ExchCode = 'DEU' WHERE SecCode = 3410277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632884570, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3418906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644441070, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2025-05-02' WHERE SecCode = 3428077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100439, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-02' WHERE SecCode = 3429810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380031, ExchCode = 'LAS' WHERE SecCode = 3432164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636049771, ExchCode = 'BER', PermQuoteRetireDate = '2018-06-28' WHERE SecCode = 3434582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782375294, ExchCode = 'STU' WHERE SecCode = 3436849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381246, ExchCode = 'LAS' WHERE SecCode = 3438714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520521, ExchCode = 'DUS' WHERE SecCode = 3444720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388252, ExchCode = 'LAS' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705440, ExchCode = 'MXQ' WHERE SecCode = 3446301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782180687, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3446753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647640876, ExchCode = 'DEU' WHERE SecCode = 3490936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647227760, ExchCode = 'STU', PermQuoteRetireDate = '2019-10-21' WHERE SecCode = 3490972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800450347, ExchCode = 'MUN' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669695686, ExchCode = 'BTE', PermQuoteRetireDate = '2022-07-12' WHERE SecCode = 3499290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705539, ExchCode = 'MXQ' WHERE SecCode = 3501496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387110, ExchCode = 'LAS' WHERE SecCode = 3501595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557759000, ExchCode = 'BEC' WHERE SecCode = 3501596 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3507389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727169919, Ticker = 'NGIL', ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705225, Ticker = 'JOBSN', ExchCode = 'MXQ' WHERE SecCode = 3518311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652333996, ExchCode = 'DEU' WHERE SecCode = 3526149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955513852, ExchCode = 'DUS', PermQuoteRetireDate = '2025-08-29', PermSecMapEndDate = '2025-09-01' WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272845, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3526200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783487481, ExchCode = 'QTX' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'AAV', ExchCode = 'UPC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-20', PermSecMapEndDate = NULL WHERE SecCode = 3531558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830311889, ExchCode = 'GTX' WHERE SecCode = 3532733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434494, ExchCode = 'LAS' WHERE SecCode = 3532734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653986688, Ticker = 'TGLl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-28' WHERE SecCode = 3536053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731165599, ExchCode = 'MUN' WHERE SecCode = 3539019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685853416, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780478263, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3544433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949649601, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-12-12' WHERE SecCode = 3545357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795072494, ExchCode = 'LAS' WHERE SecCode = 3549499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656740299, Ticker = 'DNKl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-01-20' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660711274, ExchCode = 'TDG' WHERE SecCode = 3558191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705892, ExchCode = 'MXQ' WHERE SecCode = 3580734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782645921, ExchCode = 'BER', PermQuoteRetireDate = '2021-04-07' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572528792, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3587035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757667031, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 3588020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598347923, ExchCode = 'AUX' WHERE SecCode = 3588027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616916071, Ticker = 'SANDS', ExchCode = 'LIS', PermQuoteRetireDate = '2017-07-18' WHERE SecCode = 3588029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761303077, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3588035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552355, ExchCode = 'LAS' WHERE SecCode = 3588063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663433260, ExchCode = 'TDG', PermQuoteRetireDate = '2020-04-07' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787436, ExchCode = 'DUS' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731983529, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3615233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759798879, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 3615235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893299383, ExchCode = 'GTX' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668632710, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705588, ExchCode = 'MXQ' WHERE SecCode = 3644857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690033954, ExchCode = 'MUN' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670410338, Ticker = 'ROAI', ExchCode = 'SWX', PermQuoteRetireDate = '2023-09-22' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293822, ExchCode = 'GTX' WHERE SecCode = 3657811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308294, ExchCode = 'GTX' WHERE SecCode = 3658775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750787655, ExchCode = 'FRA' WHERE SecCode = 3731132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288603, ExchCode = 'GTX' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947054171, ExchCode = 'FRA' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682712573, ExchCode = 'STU' WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704309, ExchCode = 'MXQ' WHERE SecCode = 3756608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704929, Ticker = 'GNKN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3761051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620914214, Ticker = 'CZBl', ExchCode = 'BCO', PermQuoteRetireDate = '2019-11-26' WHERE SecCode = 3762759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272950, ExchCode = 'GTX' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715066, ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-02' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496810, ExchCode = 'DUS' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694900840, ExchCode = 'QTX' WHERE SecCode = 3817314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544674, ExchCode = 'DUS' WHERE SecCode = 3817679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692561684, ExchCode = 'DEU' WHERE SecCode = 3818674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394215, ExchCode = 'MEX' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21697686068, ExchCode = 'BER' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918923, ExchCode = 'FRA' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20' WHERE SecCode = 3840551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841766443, ExchCode = 'QTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787746616, ExchCode = 'SIU', PermQuoteRetireDate = '2025-01-04' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727370524, ExchCode = 'MEX' WHERE SecCode = 3869732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701456710, ExchCode = 'BER' WHERE SecCode = 3881176 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 = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849806468, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3894966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732144859, ExchCode = 'TDG' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-05-19' WHERE SecCode = 3945211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845526470, ExchCode = 'STU' WHERE SecCode = 3968106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403388, ExchCode = 'FRA' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359626, ExchCode = 'BIV' WHERE SecCode = 4024645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011932, Ticker = '2BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026865, Ticker = '11COV' WHERE SecCode = 4031771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011919, Ticker = '2ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026856, Ticker = '1ADJ' WHERE SecCode = 4031785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026770, Ticker = '1DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655813, Ticker = '4HEIA', ExchCode = 'ETX' WHERE SecCode = 4031893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012517, Ticker = '2MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682843016, Ticker = '4UCB', ExchCode = 'ETX' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026881, Ticker = '1ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026759, Ticker = '1DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128315297, ExchCode = 'DEU' WHERE SecCode = 4046669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630041763, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733147228, ExchCode = 'FRA' WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383364, ExchCode = 'TDG' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951941315, ExchCode = 'QTX' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830082, ExchCode = 'QTX' WHERE SecCode = 4110884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308301, ExchCode = 'GTX' WHERE SecCode = 4110887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739433458, ExchCode = 'DEU' WHERE SecCode = 4178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803758400, ExchCode = 'STU' WHERE SecCode = 4201669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349453, ExchCode = 'BIV' WHERE SecCode = 4228288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749843263, ExchCode = 'DEU' WHERE SecCode = 4228324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22114551386, ExchCode = 'BCO' WHERE SecCode = 4230722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753907395, ExchCode = 'FRA' WHERE SecCode = 4245389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388456, ExchCode = 'LAS' WHERE SecCode = 4248820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754200427, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4253036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754200308, ExchCode = 'DEU' WHERE SecCode = 4253037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942187, ExchCode = 'STU' WHERE SecCode = 4267228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756547830, ExchCode = 'DEU' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757455927, ExchCode = 'DEU' WHERE SecCode = 4277594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768111804, PermQuoteStatus = 'DC', Ticker = '9EG', ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-27' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727343769, ExchCode = 'MEX' WHERE SecCode = 4303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027131, Ticker = '1SPOT' WHERE SecCode = 4309035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761325018, Ticker = '4TKWY', ExchCode = 'ETX' WHERE SecCode = 4309036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026769, Ticker = '1AMS' WHERE SecCode = 4309037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026756, Ticker = '1NB' WHERE SecCode = 4309038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761324941, Ticker = '4RMS', ExchCode = 'ETX' WHERE SecCode = 4309039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761324824, Ticker = '4ASM', ExchCode = 'ETX' WHERE SecCode = 4309043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026753, Ticker = '1FSLR' WHERE SecCode = 4309045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761647098, ExchCode = 'DUS' WHERE SecCode = 4309050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709367298, ExchCode = 'MXQ' WHERE SecCode = 4324371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727341343, ExchCode = 'MEX' WHERE SecCode = 4324380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839048914, ExchCode = 'MUN' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763901196, ExchCode = 'QTX' WHERE SecCode = 4324504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764864768, ExchCode = 'DEU' WHERE SecCode = 4334568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 4365043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606760, ExchCode = 'DEU' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510674, ExchCode = 'QTX' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122676110, ExchCode = 'DEU' WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349092, ExchCode = 'BIV' WHERE SecCode = 4382991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738813552, ExchCode = 'STU' WHERE SecCode = 4383309 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 4386307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740524, ExchCode = 'LAS' WHERE SecCode = 4388200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778023548, ExchCode = 'FRA' WHERE SecCode = 4394781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777507955, ExchCode = 'MUN' WHERE SecCode = 4394782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909499, ExchCode = 'FRA' WHERE SecCode = 4413712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370420, ExchCode = 'AQE' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085311658, ExchCode = 'DEU' WHERE SecCode = 4425728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928415121, ExchCode = 'SIU' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013269, Ticker = '2VTRS' WHERE SecCode = 4427826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663670, ExchCode = 'AQX' WHERE SecCode = 4429632 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394138, ExchCode = 'STU' WHERE SecCode = 4429683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785087297, ExchCode = 'FRA' WHERE SecCode = 4434390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600486, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4436991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858570, ExchCode = 'QTX' WHERE SecCode = 4443921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786869407, ExchCode = 'MUN' WHERE SecCode = 4443924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296248, ExchCode = 'GTX' WHERE SecCode = 4443926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685967, ExchCode = 'FRA' WHERE SecCode = 4444002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789567035, ExchCode = 'DEU' WHERE SecCode = 4458936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789568350, ExchCode = 'DEU' WHERE SecCode = 4458938 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4459007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367131, ExchCode = 'FRA' WHERE SecCode = 4463145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792050282, ExchCode = 'QTX' WHERE SecCode = 4463150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307029, ExchCode = 'SGO' WHERE SecCode = 4464699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888293855, PermQuoteStatus = 'AC', Ticker = 'STSLa', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 4466437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956950, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793399825, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4470175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797398508, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4470353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727302429, ExchCode = 'BIV' WHERE SecCode = 4472876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793674463, ExchCode = 'DUS' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793526925, ExchCode = 'QTX' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896842819, ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-07' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817566, ExchCode = 'FRA' WHERE SecCode = 4481115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367136, ExchCode = 'FRA' WHERE SecCode = 4482517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512118, PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 4487664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727342533, ExchCode = 'BIV' WHERE SecCode = 4492131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780165906, ExchCode = 'MXQ' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555598, ExchCode = 'FRA' WHERE SecCode = 4496736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956106, Ticker = '0A6Nl', ExchCode = 'BCO' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 4502466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383553, ExchCode = 'DEU' WHERE SecCode = 4502474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287355, ExchCode = 'BIV' WHERE SecCode = 4505578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727286506, ExchCode = 'MEX' WHERE SecCode = 4505794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802419041, ExchCode = 'TDG', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800727363, ExchCode = 'DEU' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381380, ExchCode = 'LAS' WHERE SecCode = 4526143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803771947, ExchCode = 'DEU' WHERE SecCode = 4536359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802587261, ExchCode = 'STU' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301440, ExchCode = 'MEX' WHERE SecCode = 4547978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271946, ExchCode = 'BIV' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349197, ExchCode = 'MEX' WHERE SecCode = 4550708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893554100, ExchCode = 'FRA' WHERE SecCode = 4554184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806812473, ExchCode = 'DEU' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823056706, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = NULL WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799305062, ExchCode = 'FRA' WHERE SecCode = 4557948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808950993, ExchCode = 'FRA' WHERE SecCode = 4568422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808951005, ExchCode = 'DEU' WHERE SecCode = 4568423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615572, ExchCode = 'STU' WHERE SecCode = 4585453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380574, ExchCode = 'LAS' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305821, ExchCode = 'MEX' WHERE SecCode = 4597223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836865415, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4598716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815149494, ExchCode = 'STU' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136782, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28' WHERE SecCode = 4607686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816241209, ExchCode = 'STU' WHERE SecCode = 4607717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138517569, ExchCode = 'BTE' WHERE SecCode = 4609997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816288448, ExchCode = 'DEU' WHERE SecCode = 4609999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045075404, ExchCode = 'LAS' WHERE SecCode = 4613099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527387, ExchCode = 'DEU' WHERE SecCode = 4617804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968078, ExchCode = 'DEU' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821849497, ExchCode = 'FRA' WHERE SecCode = 4633101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438919, ExchCode = 'FRA' WHERE SecCode = 4637752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823512132, ExchCode = 'DEU' WHERE SecCode = 4641628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334865, ExchCode = 'FRA' WHERE SecCode = 4643318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914249, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832260332, ExchCode = 'FRA' WHERE SecCode = 4658888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831549319, ExchCode = 'TDG' WHERE SecCode = 4671286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832851078, ExchCode = 'DEU' WHERE SecCode = 4676228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419029, ExchCode = 'LAS' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244581, ExchCode = 'MEX' WHERE SecCode = 4684128 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 = 25727244576, ExchCode = 'BIV' WHERE SecCode = 4695806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843909546, ExchCode = 'TDG' WHERE SecCode = 4718903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846029349, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897585, ExchCode = 'DEU', PermQuoteRetireDate = '2024-09-05' WHERE SecCode = 4726108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633723, ExchCode = 'DEU' WHERE SecCode = 4757851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857633448, ExchCode = 'QTX' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380489, Ticker = 'A6I', ExchCode = 'LAS' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961970528, ExchCode = 'MUN' WHERE SecCode = 4794550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860097813, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-17' WHERE SecCode = 4800489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860100436, ExchCode = 'DEU' WHERE SecCode = 4800490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860100491, ExchCode = 'DEU' WHERE SecCode = 4800491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867357547, ExchCode = 'DEU' WHERE SecCode = 4800492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727216396, ExchCode = 'MEX' WHERE SecCode = 4800493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859821791, ExchCode = 'STO' WHERE SecCode = 4802290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161389948, Ticker = 'CON3l', ExchCode = 'BTE' WHERE SecCode = 4806678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823813, ExchCode = 'AQX' WHERE SecCode = 4808966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779461575, ExchCode = 'BER', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 4811144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777464947, ExchCode = 'TDG' WHERE SecCode = 4815315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804716445, ExchCode = 'HAM' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865900341, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4819644 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 = 236778241629, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4819881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863999651, ExchCode = 'DEU' WHERE SecCode = 4819882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865296250, ExchCode = 'TDG' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381839, ExchCode = 'LAS' WHERE SecCode = 4829219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834795, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4830968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896583135, ExchCode = 'QTX' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419008, ExchCode = 'LAS' WHERE SecCode = 4834795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866892386 WHERE SecCode = 4841211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510714, ExchCode = 'DUS' WHERE SecCode = 4845006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380528, ExchCode = 'LAS' WHERE SecCode = 4845007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419195, ExchCode = 'LAS' WHERE SecCode = 4846846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580567, ExchCode = 'DEU' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387395, ExchCode = 'LAS' WHERE SecCode = 4852140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783783667, ExchCode = 'QTX' WHERE SecCode = 4852142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089453110, ExchCode = 'BTE' WHERE SecCode = 4854872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387394, ExchCode = 'LAS' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388723, ExchCode = 'LAS' WHERE SecCode = 4868662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873145829, ExchCode = 'QTX' WHERE SecCode = 4878702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788448824, Ticker = 'E7Sd', ExchCode = 'BCO' WHERE SecCode = 4885536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876129776, ExchCode = 'QTX' WHERE SecCode = 4885603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874656832, ExchCode = 'DEU' WHERE SecCode = 4889264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018979, ExchCode = 'STU' WHERE SecCode = 4890295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387300, ExchCode = 'LAS' WHERE SecCode = 4890300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727229220, ExchCode = 'BIV' WHERE SecCode = 4890352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905908990, ExchCode = 'MUN', PermQuoteRetireDate = '2022-09-20' WHERE SecCode = 4893294 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4914438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882944805, PermQuoteStatus = 'DC', Ticker = 'Y23', ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-06' WHERE SecCode = 4934325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882178104, ExchCode = 'FRA', PermQuoteRetireDate = '2022-03-29', PermSecMapEndDate = '2022-03-29' WHERE SecCode = 4934327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795183109, ExchCode = 'LAS' WHERE SecCode = 4940670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380552, ExchCode = 'LAS' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914321191, ExchCode = 'MUN', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 4943410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380553, ExchCode = 'LAS', PermQuoteRetireDate = '2024-09-11', PermSecMapEndDate = NULL WHERE SecCode = 4952512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885463799, ExchCode = 'QTX', PermQuoteRetireDate = '2025-04-22' WHERE SecCode = 4954564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884973298, ExchCode = 'MUN' WHERE SecCode = 4957875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891723924, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 4959596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689488, ExchCode = 'DEU' WHERE SecCode = 4959597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650257, ExchCode = 'DUS' WHERE SecCode = 4960868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650269, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2025-10-22' WHERE SecCode = 4965060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419011, ExchCode = 'LAS' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21900329999, ExchCode = 'DEU' WHERE SecCode = 4970793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888705427, ExchCode = 'MUN' WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902368752, ExchCode = 'STU' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889561153, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4980098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212169, ExchCode = 'MEX' WHERE SecCode = 4980103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888279622, ExchCode = 'MUN' WHERE SecCode = 4983996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100827, ExchCode = 'DUS' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810200238, ExchCode = 'STU', PermQuoteRetireDate = '2025-05-20', PermSecMapEndDate = NULL WHERE SecCode = 5002458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980198448, ExchCode = 'FRA' WHERE SecCode = 5011657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387447, ExchCode = 'LAS' WHERE SecCode = 5011663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908059227, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5038681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863949562 WHERE SecCode = 5040232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898852880, ExchCode = 'FRA' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902954507, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22058331391, Ticker = 'XWD1l', ExchCode = 'CHI' WHERE SecCode = 5067183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872147438, ExchCode = 'MXQ' WHERE SecCode = 5067670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740567, ExchCode = 'LAS' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5085769 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5089305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876909126, ExchCode = 'MXQ' WHERE SecCode = 5099007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607113, Ticker = 'GOOG', ExchCode = 'SWX' WHERE SecCode = 5099022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718186332, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5099028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716500, ExchCode = 'FRA' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781637018, ExchCode = 'HAM' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923404247, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-21' WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642004, ExchCode = 'QTX' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942737484, ExchCode = 'STU' WHERE SecCode = 5151167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423065, ExchCode = 'FRA' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790867, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508528400, ExchCode = 'DEU' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730598077, ExchCode = 'FRA' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755973706, ExchCode = 'DUS' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793473641, ExchCode = 'CHI' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727344850, ExchCode = 'MEX' WHERE SecCode = 5161363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387325, ExchCode = 'LAS' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924150711, ExchCode = 'STU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642019, ExchCode = 'QTX' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5166779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234849, ExchCode = 'QTX' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921901229, ExchCode = 'DEU' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834872, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5195447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535364, ExchCode = 'MUN' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836196, Ticker = 'AFTTp', ExchCode = 'EQD' WHERE SecCode = 5206274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140088087, ExchCode = 'HAM' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388873, ExchCode = 'LAS' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727192008, ExchCode = 'BIV' WHERE SecCode = 5251003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779328331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775222346, ExchCode = 'BIV' WHERE SecCode = 5267090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397466, PermQuoteStatus = 'DC', ExchCode = 'CHI', PermQuoteRetireDate = '2026-03-12' WHERE SecCode = 5269462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100719, ExchCode = 'QTX' WHERE SecCode = 5272089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758789, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = NULL WHERE SecCode = 5283651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781180723, ExchCode = 'GTX' WHERE SecCode = 5290322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956341568, ExchCode = 'HAN' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953922612, ExchCode = 'GTX', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = '2025-08-06' WHERE SecCode = 5311845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159093914, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2026-02-25' WHERE SecCode = 5315560 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 5357677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727195025, ExchCode = 'MEX' WHERE SecCode = 5381947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716837, ExchCode = 'FRA' WHERE SecCode = 5383598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534615, ExchCode = 'QTX' WHERE SecCode = 5383599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535822, ExchCode = 'BIV' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961201424, ExchCode = 'FRA' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780747349, ExchCode = 'STU' WHERE SecCode = 5395770 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5402782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812179638, ExchCode = 'DEU' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727202565, ExchCode = 'BIV' WHERE SecCode = 5411550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378859, ExchCode = 'FRA' WHERE SecCode = 5415164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193596, ExchCode = 'MEX' WHERE SecCode = 5474598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778456487, ExchCode = 'FRA' WHERE SecCode = 5479512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778704118, ExchCode = 'FRA' WHERE SecCode = 5493665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834799, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5496168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904149, ExchCode = 'BTE' WHERE SecCode = 5503692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394120, ExchCode = 'TDG' WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834837, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512065, Ticker = '3PYPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5503776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580217, ExchCode = 'GER' WHERE SecCode = 5503779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823777, ExchCode = 'AQX' WHERE SecCode = 5503780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 5503781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663656, ExchCode = 'AQX' WHERE SecCode = 5503782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953657244, ExchCode = 'MXQ' WHERE SecCode = 5503860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836119, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836104, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5506501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414734, ExchCode = 'LAS' WHERE SecCode = 5507430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882467041, Ticker = 'BTCW', ExchCode = 'SWX' WHERE SecCode = 5509588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787393619, ExchCode = 'TDG' WHERE SecCode = 5523278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779292324, ExchCode = 'FRA' WHERE SecCode = 5527560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21988688380, ExchCode = 'MXQ' WHERE SecCode = 5531898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779309028, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5533603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836259, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534997 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5547975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561935, ExchCode = 'FRA' WHERE SecCode = 5550738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771107, ExchCode = 'FRA' WHERE SecCode = 5563110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836128, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421397, PermQuoteStatus = 'AC', Ticker = '3LALm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836233, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823771, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-15' WHERE SecCode = 5569303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970293338, ExchCode = 'MUN' WHERE SecCode = 5569313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970293082, ExchCode = 'GTX' WHERE SecCode = 5569354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566091, ExchCode = 'FRA' WHERE SecCode = 5569360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659489, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-22' WHERE SecCode = 5569960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779926873, ExchCode = 'FRA', PermQuoteRetireDate = '2025-05-07' WHERE SecCode = 5570015 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997766265, Ticker = 'NGLS', ExchCode = 'LSE' WHERE SecCode = 5584733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778659885, ExchCode = 'MEX' WHERE SecCode = 5590170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173432, ExchCode = 'BIV' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942898, ExchCode = 'MEX' WHERE SecCode = 5631516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781060493, ExchCode = 'FRA' WHERE SecCode = 5633895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904157, Ticker = 'LCO3l', ExchCode = 'BCO' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604521787, ExchCode = 'MUN', PermQuoteRetireDate = '2023-09-11' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823715, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-15' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823853, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778712185, ExchCode = 'MEX' WHERE SecCode = 5644662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781343894, ExchCode = 'TDG' WHERE SecCode = 5663580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863949657, ExchCode = 'PFT' WHERE SecCode = 5674188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985327, ExchCode = 'TDG' WHERE SecCode = 5674239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782145874, ExchCode = 'MEX' WHERE SecCode = 5701236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153246014, ExchCode = 'BTE' WHERE SecCode = 5740832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772235078, ExchCode = 'TDG' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 5745665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782872476, ExchCode = 'FRA' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891343, ExchCode = 'FRA' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891391, ExchCode = 'FRA' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782928373, ExchCode = 'FRA' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937290553, ExchCode = 'FRA' WHERE SecCode = 5749952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782954307, ExchCode = 'FRA' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783081066, ExchCode = 'FRA' WHERE SecCode = 5764020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154585726, ExchCode = 'CHI' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914265, Ticker = 'RZ8B', ExchCode = 'STU' WHERE SecCode = 5782810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851316, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136364064, ExchCode = 'CHI' WHERE SecCode = 5782854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608793, ExchCode = 'MEX' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22042870510, ExchCode = 'DEU' WHERE SecCode = 5817022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784236560, ExchCode = 'STU' WHERE SecCode = 5822326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784236496, ExchCode = 'FRA' WHERE SecCode = 5822327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787198171, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785264814, ExchCode = 'FRA' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22044538463, ExchCode = 'DEU' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421390, ExchCode = 'BIV' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031122900, Ticker = 'CO3Sl', ExchCode = 'BCO' WHERE SecCode = 5839249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386888, ExchCode = 'LAS' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416444, ExchCode = 'BIV' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786127339, ExchCode = 'GTX' WHERE SecCode = 5908830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22058332105, ExchCode = 'DEU' WHERE SecCode = 5914176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784960655, ExchCode = 'BIV' WHERE SecCode = 5917759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784315655, ExchCode = 'BIV' WHERE SecCode = 5917882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061495886, ExchCode = 'GTX' WHERE SecCode = 5920851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786490279, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 5931956 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 5936371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798426772, ExchCode = 'MUN' WHERE SecCode = 5947065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786839717, ExchCode = 'STU' WHERE SecCode = 5947076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788145983, Ticker = '7YGd', ExchCode = 'BCO' WHERE SecCode = 5949087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799223628, ExchCode = 'TRQ' WHERE SecCode = 5959461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793448736, ExchCode = 'TDG' WHERE SecCode = 5969012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788075088, ExchCode = 'FRA' WHERE SecCode = 5978470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787589834, ExchCode = 'MUN' WHERE SecCode = 5978474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786355844, ExchCode = 'MEX' WHERE SecCode = 5985969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089452738, Ticker = 'MST3d', ExchCode = 'CHI' WHERE SecCode = 5999093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071047085, ExchCode = 'FRA' WHERE SecCode = 5999095 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071786786, ExchCode = 'QTX' WHERE SecCode = 5999096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071046984, ExchCode = 'GER' WHERE SecCode = 5999098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071312228, ExchCode = 'DEU' WHERE SecCode = 6001792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789744668, ExchCode = 'LAS' WHERE SecCode = 6004713 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 6004781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET ExchCode = 'TAI' WHERE SecCode = 6012718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782564342, ExchCode = 'BIV' WHERE SecCode = 6032854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788759413, ExchCode = 'STU' WHERE SecCode = 6035234 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 6037422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788847043, ExchCode = 'MUN' WHERE SecCode = 6043475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788962501, Ticker = '1HUT', ExchCode = 'MIL' WHERE SecCode = 6047903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789143417, ExchCode = 'MEX' WHERE SecCode = 6064006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136111007, Ticker = 'BITCl', ExchCode = 'CHI' WHERE SecCode = 6078418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136110997, Ticker = 'BITPl', ExchCode = 'BTE' WHERE SecCode = 6078420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571976516, ExchCode = 'BEC' WHERE SecCode = 6095641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083162878, ExchCode = 'DEU' WHERE SecCode = 6095673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110948, Ticker = '3GFMm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 6097282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110935, Ticker = 'FTNGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-01' WHERE SecCode = 6097301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421365, PermQuoteStatus = 'AC', Ticker = '3LNFm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 6097318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22088980768, ExchCode = 'BTE' WHERE SecCode = 6097329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078190, ExchCode = 'LAS' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151127, Ticker = '3SUE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 6097349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22016170429, PermQuoteStatus = 'DC', Ticker = 'SCO3', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 6097382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784422711, ExchCode = 'MEX' WHERE SecCode = 6097386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814699350, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704334, ExchCode = 'MXQ' WHERE SecCode = 6097401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829806, ExchCode = 'DEU' WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745365417, PermQuoteStatus = 'DC', Ticker = 'TSLASx', ExchCode = 'CHI', PermQuoteRetireDate = '2022-03-25' WHERE SecCode = 6097440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152475848, ExchCode = 'AQX' WHERE SecCode = 6097445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031488954, Ticker = 'SMCI', ExchCode = 'MIL' WHERE SecCode = 6097447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823853, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 6097452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779226797, PermQuoteStatus = 'DC', Ticker = '5VFC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-24' WHERE SecCode = 6097454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911612, ExchCode = 'BIV' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051258, ExchCode = 'TDG' WHERE SecCode = 6097577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792942692, ExchCode = 'STU' WHERE SecCode = 6151861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144452413, PermQuoteStatus = 'DC', Ticker = 'BTC1', ExchCode = 'SWX', PermQuoteRetireDate = '2026-02-25' WHERE SecCode = 6159032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22094064244, ExchCode = 'DEU' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794054782, ExchCode = 'FRA' WHERE SecCode = 6204565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792959667, ExchCode = 'STU' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22100679954, ExchCode = 'DEU' WHERE SecCode = 6256166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818713443, Ticker = '4E40', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 6256409 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 6264200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792270095, ExchCode = 'QTX', PermQuoteRetireDate = '2025-11-26' WHERE SecCode = 6269028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269534, ExchCode = 'FRA' WHERE SecCode = 6269033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22103473262, ExchCode = 'DEU', PermSecMapStartDate = '2026-05-19' WHERE SecCode = 6270388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792342447, ExchCode = 'FRA' WHERE SecCode = 6270465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787788319, ExchCode = 'MEX' WHERE SecCode = 6321016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910459, ExchCode = 'STU' WHERE SecCode = 6325196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793578955, ExchCode = 'TDG' WHERE SecCode = 6341809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793855803, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 6347434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808950961, ExchCode = 'DEU' WHERE SecCode = 6364834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793595970, ExchCode = 'FRA' WHERE SecCode = 6368840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655583, ExchCode = 'GER' WHERE SecCode = 6368868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793828558, ExchCode = 'STU' WHERE SecCode = 6368981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794320484, ExchCode = 'FRA' WHERE SecCode = 6396772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794459345, ExchCode = 'FRA' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799304965, ExchCode = 'CHA' WHERE SecCode = 6421140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802152101, ExchCode = 'TDG' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795801696, ExchCode = 'FRA' WHERE SecCode = 6453946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142096843, ExchCode = 'SWX' WHERE SecCode = 6453964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131539236, ExchCode = 'DEU' WHERE SecCode = 6480863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796887923, ExchCode = 'DUS' WHERE SecCode = 6480864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131541195, ExchCode = 'DEU' WHERE SecCode = 6480866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796059933, ExchCode = 'MUN', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 6480954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136096482, ExchCode = 'MUN' WHERE SecCode = 6482759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131851181, ExchCode = 'DEU' WHERE SecCode = 6482768 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 6492959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797391, ExchCode = 'TDG' WHERE SecCode = 6520702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798597964, ExchCode = 'TDG' WHERE SecCode = 6528817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22137771215, ExchCode = 'DEU' WHERE SecCode = 6528818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798270114, ExchCode = 'FRA' WHERE SecCode = 6528824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746061, ExchCode = 'DUS' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798462193, ExchCode = 'MUN' WHERE SecCode = 6541041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799161271, ExchCode = 'GTX' WHERE SecCode = 6548128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797392, ExchCode = 'TDG' WHERE SecCode = 6548155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521985467, Ticker = 'UNV0', ExchCode = 'TDG' WHERE SecCode = 6551100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799207727, ExchCode = 'MUN' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607163, Ticker = 'AI', ExchCode = 'SWX' WHERE SecCode = 6578367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379501, Ticker = 'KOG', ExchCode = 'BRN' WHERE SecCode = 6578370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168734, ExchCode = 'SIG' WHERE SecCode = 6578406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799651841, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6583721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800228281, ExchCode = 'FRA' WHERE SecCode = 6593800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800228284, ExchCode = 'FRA' WHERE SecCode = 6593801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800229276, ExchCode = 'FRA' WHERE SecCode = 6593803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800228885, ExchCode = 'FRA' WHERE SecCode = 6593805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800228883, ExchCode = 'FRA' WHERE SecCode = 6593806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145977584, ExchCode = 'DEU' WHERE SecCode = 6593866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147097785, ExchCode = 'DEU' WHERE SecCode = 6603628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134134351, ExchCode = 'STU' WHERE SecCode = 6617649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955514041, ExchCode = 'STU' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451401, ExchCode = 'BTE' WHERE SecCode = 6627463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153255398, ExchCode = 'DEU' WHERE SecCode = 6627853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801973480, ExchCode = 'TDG' WHERE SecCode = 6628840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802136610, ExchCode = 'FRA' WHERE SecCode = 6629415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173814070, ExchCode = 'TDG' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471092, ExchCode = 'FRA' WHERE SecCode = 6642930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883771519, ExchCode = 'FRA' WHERE SecCode = 6667833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165234298, ExchCode = 'GTX' WHERE SecCode = 6710093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239275, ExchCode = 'FRA' WHERE SecCode = 6716121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239931, ExchCode = 'FRA' WHERE SecCode = 6716122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239929, ExchCode = 'FRA' WHERE SecCode = 6716123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239978, ExchCode = 'FRA' WHERE SecCode = 6716124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239905, ExchCode = 'FRA' WHERE SecCode = 6716125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804778696, ExchCode = 'MUN' WHERE SecCode = 6721535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168342727, Ticker = 'DDUMl', ExchCode = 'SIG' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804823846, IsPrimaryQuote = 1, Ticker = 'GENO', ExchCode = 'OSL' WHERE SecCode = 6741012 AND Type_ = 10;
UPDATE data_universe_permid SET InstrPermID = 232924875827, ValQuotePermID = NULL, IsPrimaryInstr = 1, PermInstrStatus = 'NA' WHERE SecCode = 6748864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806638776, ExchCode = 'TDG' WHERE SecCode = 6753080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699530, ExchCode = 'MEX' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805672065, ExchCode = 'FRA' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806330926, ExchCode = 'MUN' WHERE SecCode = 6782677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791406431, ExchCode = 'MEX' WHERE SecCode = 6797364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806019658, ExchCode = 'MEX' WHERE SecCode = 6797367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806018739, ExchCode = 'FRA' WHERE SecCode = 6797368 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 = 22175399920, ExchCode = 'DEU' WHERE SecCode = 6802861 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-20' WHERE SecCode = 6806180 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 PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 6820230 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 6820245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806467612, ExchCode = 'FRA' WHERE SecCode = 6826554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806710348, ExchCode = 'FRA' WHERE SecCode = 6832571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806711019, ExchCode = 'FRA' WHERE SecCode = 6832572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806711016, ExchCode = 'FRA' WHERE SecCode = 6832574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806711023, ExchCode = 'FRA' WHERE SecCode = 6832575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806711017, ExchCode = 'FRA' WHERE SecCode = 6832576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806711018, ExchCode = 'FRA' WHERE SecCode = 6832577 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, ExchCode = 'GTX' WHERE SecCode = 6843135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181122907, ExchCode = 'LAS' WHERE SecCode = 6843187 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-05-20' WHERE SecCode = 6846681 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-05-20' WHERE SecCode = 6846841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807025949, ExchCode = 'FRA' WHERE SecCode = 6849998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807273591, ExchCode = 'TDG' WHERE SecCode = 6854883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807105940, ExchCode = 'GTX' WHERE SecCode = 6854888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807024320, ExchCode = 'TDG' WHERE SecCode = 6857310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807272398, ExchCode = 'MUN' WHERE SecCode = 6862205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807109364, ExchCode = 'BIV' WHERE SecCode = 6862277 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 10901037 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11052723 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 11077577 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-19' WHERE SecCode = 11139994 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11185275 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 11198134 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 11200202 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-05-19', PermSecMapEndDate = NULL WHERE SecCode = 11201407 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236804760288, Ticker = NULL, PermQuoteRetireDate = '2026-05-19', PermSecMapStartDate = '2026-03-24', PermSecMapEndDate = '2026-05-19' WHERE SecCode = 11211313 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11218121 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236793806642, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'GTC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11222037 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'QTEX' WHERE SecCode = 11222088 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11226283 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 11232859 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11237323 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11264491 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11277474 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 11278339 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11278370 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11288580 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11288583 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11288587 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11288589 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232902764891.0 WHERE SecCode = 11291637 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11292283 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11292284 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11292285 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11292286 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11292287 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11292289 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11292294 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11293243 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232925935066.0 WHERE SecCode = 11295153 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11295354 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11295355 AND Type_ = 1;
