UPDATE data_universe_permid SET QuotePermID = 55836048756, Ticker = 'HON', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-02' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 925 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838299316, PermQuoteStatus = 'DC', Ticker = 'GL9.IE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2298 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-01' WHERE SecCode = 2565 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3649 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3651 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3652 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3653 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 3948 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 6913 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 7202 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 7222 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 7479 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55852417171, PermQuoteStatus = 'DC', Ticker = 'TKA.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 7986 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836028512, Ticker = 'IJF', ExchCode = 'ISE' WHERE SecCode = 8027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836052415, Ticker = 'ZHEH', ExchCode = 'LSE', PermQuoteRetireDate = '2023-05-19' WHERE SecCode = 9121 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 9331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718461399, Ticker = '0Q1Nl', ExchCode = 'BCO' WHERE SecCode = 9338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836049459, Ticker = 'PACC', ExchCode = 'LSE', PermQuoteRetireDate = '2016-03-07' WHERE SecCode = 9856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475556856, Ticker = 'KPN', ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 9908 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 12180 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21718461406, Ticker = '0P4Fl', ExchCode = 'BCO' WHERE SecCode = 12970 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 13284 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 14049 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 14192 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 19681 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 19950 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 24297 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'MEX' WHERE SecCode = 28414 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MEX' WHERE SecCode = 29073 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MEX' WHERE SecCode = 29074 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MEX' WHERE SecCode = 29075 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MEX' WHERE SecCode = 29076 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MEX' WHERE SecCode = 29113 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 30271 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 30557 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 31280 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 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 = 21553114144, ExchCode = 'EQD', PermQuoteRetireDate = '2017-02-03' WHERE SecCode = 35293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329689, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 35419 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951907.0 WHERE SecCode = 36209 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951907.0 WHERE SecCode = 36210 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951907.0 WHERE SecCode = 36508 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951907.0 WHERE SecCode = 36509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513072773, ExchCode = 'STU' WHERE SecCode = 37118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474904383, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475818377, ExchCode = 'STU' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475586089, PermQuoteStatus = 'DC', Ticker = 'CPAG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475543280, PermQuoteStatus = 'DC', Ticker = 'GOBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506520538, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838625777, ExchCode = 'STU' WHERE SecCode = 37524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787448, ExchCode = 'DUS' WHERE SecCode = 37745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333918, ExchCode = 'BER' WHERE SecCode = 37757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077813, ExchCode = 'LAS' WHERE SecCode = 37853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859213206, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364005, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 38363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836519050, ExchCode = 'FRA' WHERE SecCode = 38379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475381474, ExchCode = 'GER' WHERE SecCode = 38380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518956, ExchCode = 'DUS', PermQuoteRetireDate = '2018-04-11' WHERE SecCode = 38400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830303797, ExchCode = 'GTX' WHERE SecCode = 38625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531126213, Ticker = 'EICd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-05-02' WHERE SecCode = 38658 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 39477 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-01' WHERE SecCode = 41253 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475624187, Ticker = 'SCX', ExchCode = 'MUN', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616156912, ExchCode = 'MCX' WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448686, ExchCode = 'FRA' WHERE SecCode = 47312 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 47913 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 48307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 48361 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 48362 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 48364 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 48374 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 48375 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'CZE', PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 49189 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 49360 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 49362 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 50755 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 50858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033691, ExchCode = 'TDG' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531134703, PermQuoteStatus = 'AC', Ticker = 'SSUd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 53023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491448, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2023-06-23' WHERE SecCode = 53027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469997, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 54192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617880508, PermQuoteStatus = 'DC', Ticker = 'NDASEs', ExchCode = 'EBT', PermQuoteRetireDate = '2018-11-28' WHERE SecCode = 54237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475515201, Ticker = 'BAIG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 55562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492006471, ExchCode = 'TDG' WHERE SecCode = 55581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601433380, ExchCode = 'TDG' WHERE SecCode = 55585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590786433, ExchCode = 'TDG' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835934, Ticker = 'STFd', ExchCode = 'BCO' WHERE SecCode = 57832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641483764, ExchCode = 'STU' WHERE SecCode = 57850 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 59311 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 59808 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838238912, ExchCode = 'MUN' WHERE SecCode = 59881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475457917, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2007-11-28' WHERE SecCode = 60090 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 60348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481583, ExchCode = 'QTX' WHERE SecCode = 60573 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 61061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836386409, ExchCode = 'FRA' WHERE SecCode = 61127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836515730, ExchCode = 'FRA', PermQuoteRetireDate = '2012-11-22' WHERE SecCode = 61232 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 61350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368040, ExchCode = 'STU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805237823, ExchCode = 'SIG' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836463221, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 61930 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SWE' WHERE SecCode = 61966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336523, ExchCode = 'BER' WHERE SecCode = 61978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339451, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA' WHERE SecCode = 62619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348334, ExchCode = 'QTX' WHERE SecCode = 63263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841114683, ExchCode = 'STU' WHERE SecCode = 64369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380523, ExchCode = 'LAS' WHERE SecCode = 64407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836495768, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 65368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836411094, ExchCode = 'FRA' WHERE SecCode = 65414 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 65443 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 68937 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 72237 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951728.0 WHERE SecCode = 75798 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 78958 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 79403 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 81392 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 82223 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'QXL' WHERE SecCode = 83030 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 83863 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 84099 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 84170 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 84236 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 84887 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-29' WHERE SecCode = 86877 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 86929 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 87014 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 87191 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-05' WHERE SecCode = 87258 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-01' WHERE SecCode = 87416 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'KAIFF' WHERE SecCode = 87690 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 87779 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 88591 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 88779 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 91896 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-29' WHERE SecCode = 93467 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-01' WHERE SecCode = 95815 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 97751 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 0 WHERE SecCode = 99726 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 100680 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951168.0 WHERE SecCode = 101516 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 105524 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951728.0 WHERE SecCode = 111658 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 111786 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-29' WHERE SecCode = 114560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704234, ExchCode = 'MXQ' WHERE SecCode = 114699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679719, ExchCode = 'BIV' WHERE SecCode = 114700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704159, Ticker = 'AABA*', ExchCode = 'MXQ' WHERE SecCode = 114703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328907, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 114717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655821546, ExchCode = 'DEU', PermQuoteRetireDate = '2024-04-30', PermSecMapEndDate = NULL WHERE SecCode = 114758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787270, ExchCode = 'DUS' WHERE SecCode = 114759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22054464761, ExchCode = 'DEU' WHERE SecCode = 115623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538235, ExchCode = 'GTX' WHERE SecCode = 115779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337704, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381737, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823487855, ExchCode = 'DUS' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419464, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 120426 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 121064 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 121068 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 127537 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 132577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473389, ExchCode = 'GER' WHERE SecCode = 133773 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 137592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997854, ExchCode = 'DEU' WHERE SecCode = 138040 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'AUS' WHERE SecCode = 138759 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 139293 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 139559 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 139768 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 140234 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 140532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652457, ExchCode = 'FRA' WHERE SecCode = 140677 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 140812 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 141509 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 141585 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 141971 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 142397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-29' WHERE SecCode = 144424 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 144866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547457028, ExchCode = 'STU' WHERE SecCode = 145923 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'AUS' WHERE SecCode = 146559 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ARE' WHERE SecCode = 146743 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 146781 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ARE' WHERE SecCode = 146923 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 147403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112538, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-27', PermSecMapEndDate = NULL WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 DomCntry = 'CHN' WHERE SecCode = 149687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330777, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834373, ExchCode = 'DEU' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679752, ExchCode = 'FRA' WHERE SecCode = 178849 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 189566 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'AHNRF' WHERE SecCode = 197405 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236795295012, ExchCode = 'QTX' WHERE SecCode = 203057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 204642 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 224191 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 249610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835778048, Ticker = '85C', ExchCode = 'DUS' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951168.0 WHERE SecCode = 292115 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 295385 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 DomCntry = 'CHE' WHERE SecCode = 300121 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-01' WHERE SecCode = 300593 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 302092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176596853, PermQuoteStatus = 'AC', Ticker = 'L7U', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-29', PermSecMapEndDate = NULL WHERE SecCode = 311948 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 321310 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-30' WHERE SecCode = 323776 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 324538 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 326743 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'AUS' WHERE SecCode = 326960 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 333423 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 333427 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 336196 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 336307 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 336739 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21550085567, ExchCode = 'HAM' WHERE SecCode = 337400 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 340697 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN', PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 349255 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951168.0 WHERE SecCode = 354384 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 357324 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN', PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 366358 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN', PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 369996 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0, PermOrgIPODate = NULL WHERE SecCode = 376026 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 376073 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 377133 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 377846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704399, ExchCode = 'MXQ' WHERE SecCode = 383039 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 386864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521224477, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 408562 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 411398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843102675, ExchCode = 'BER' WHERE SecCode = 424779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272923, ExchCode = 'GTX' WHERE SecCode = 442830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847283502, Ticker = 'XAXJ', ExchCode = 'LSE' WHERE SecCode = 481041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847671835, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-01' WHERE SecCode = 486270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849266246, ExchCode = 'FRA', PermQuoteRetireDate = '2012-04-12' WHERE SecCode = 507407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034088, ExchCode = 'TDG', PermQuoteRetireDate = '2014-04-02' WHERE SecCode = 510380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714460362, Ticker = 'HOGSm', ExchCode = 'DXE' WHERE SecCode = 521415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714445358, Ticker = 'AIGIm', ExchCode = 'DXE' WHERE SecCode = 521425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21975240639, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 521464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621433367, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-01-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 521905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481623766, ExchCode = 'DEU', PermQuoteRetireDate = '2019-05-13' WHERE SecCode = 524355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214201, ExchCode = 'BIV' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640208051, ExchCode = 'CHI', PermQuoteRetireDate = '2018-10-29' WHERE SecCode = 529911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838297415, Ticker = 'BEFIT.BE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 531909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531428211, ExchCode = 'BEC' WHERE SecCode = 532209 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850869660, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 532767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521650121, ExchCode = 'MUN', PermQuoteRetireDate = '2020-09-02' WHERE SecCode = 532772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475855783, ExchCode = 'TDG', PermQuoteRetireDate = '2014-07-09' WHERE SecCode = 533487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521104643, ExchCode = 'STU' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475845507, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 533522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532071708, ExchCode = 'MUN' WHERE SecCode = 535314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630225521, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 535506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714450686, Ticker = 'SBULm', ExchCode = 'DXE' WHERE SecCode = 536401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475422418, Ticker = '0B3F', ExchCode = 'LSE', PermQuoteRetireDate = '2009-09-18' WHERE SecCode = 536734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22013678020, Ticker = 'XGLEl', ExchCode = 'AQX' WHERE SecCode = 539253 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857277432, ExchCode = 'STU' WHERE SecCode = 540241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475024144, ExchCode = 'TDG' WHERE SecCode = 540531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536043310, ExchCode = 'STU' WHERE SecCode = 540563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034065, ExchCode = 'TDG', PermQuoteRetireDate = '2015-03-17' WHERE SecCode = 541442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476219200, ExchCode = 'STU' WHERE SecCode = 541495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514772172, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 541523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474938108, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 542320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799025517, ExchCode = 'MUN' WHERE SecCode = 542943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704727, ExchCode = 'MXQ', PermSecMapEndDate = '2016-11-07' WHERE SecCode = 544311 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 547504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474839548, ExchCode = 'STO', PermQuoteRetireDate = '2018-10-15' WHERE SecCode = 547513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478506436, ExchCode = 'STU' WHERE SecCode = 548067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672230145, ExchCode = 'DUS' WHERE SecCode = 548626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825883651, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 548782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797390906, ExchCode = 'MUN' WHERE SecCode = 549236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636054188, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-24' WHERE SecCode = 549287 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 549433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704213, Ticker = 'AKS*', ExchCode = 'MXQ' WHERE SecCode = 549537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617415257, ExchCode = 'MUN' WHERE SecCode = 550860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474952371, ExchCode = 'DEU', PermQuoteRetireDate = '2025-11-07', PermSecMapEndDate = NULL WHERE SecCode = 551472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474993209, ExchCode = 'MUN' WHERE SecCode = 552621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853660975, ExchCode = 'FRA' WHERE SecCode = 552722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21944002637, ExchCode = 'TDG' WHERE SecCode = 552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21499583580, ExchCode = 'TDG' WHERE SecCode = 552948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518455932, ExchCode = 'DEU', PermQuoteRetireDate = '2023-03-23', PermSecMapEndDate = NULL WHERE SecCode = 553231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640344088, ExchCode = 'CHI' WHERE SecCode = 553351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480465, ExchCode = 'QTX' WHERE SecCode = 553799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790387228, ExchCode = 'STU', PermQuoteRetireDate = '2023-01-12', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 553921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706181, ExchCode = 'MXQ' WHERE SecCode = 554302 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 554344 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857025319, ExchCode = 'BER' WHERE SecCode = 554534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853852376, ExchCode = 'BER', PermQuoteRetireDate = '2013-10-29' WHERE SecCode = 554906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474954379, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 554915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673084, PermQuoteStatus = 'AC', Ticker = '0R6Z', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 554925 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 555156 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510721868, ExchCode = 'DEU' WHERE SecCode = 556234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55854012972, ExchCode = 'STU' WHERE SecCode = 556254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55854015367, ExchCode = 'BER', PermQuoteRetireDate = '2013-07-08' WHERE SecCode = 556535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727200539, ExchCode = 'BIV' WHERE SecCode = 557690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475119976, ExchCode = 'FRA' WHERE SecCode = 557816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534813444, ExchCode = 'DUS' WHERE SecCode = 557818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475771162, ExchCode = 'STU' WHERE SecCode = 557995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856214005, ExchCode = 'FRA' WHERE SecCode = 558032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128988850, ExchCode = 'DEU' WHERE SecCode = 558485 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 558545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475653582, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-08-02' WHERE SecCode = 558809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036088, ExchCode = 'TDG' WHERE SecCode = 558811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856218481, ExchCode = 'BER', PermQuoteRetireDate = '2013-02-08' WHERE SecCode = 559256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856606624, ExchCode = 'GER' WHERE SecCode = 559437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833319, ExchCode = 'LAS' WHERE SecCode = 559903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704435, Ticker = 'CHKAQ*', ExchCode = 'MXQ' WHERE SecCode = 560087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475750109, Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 560405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575579847, PermQuoteStatus = 'AC', Ticker = '7TM0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 560717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856721464, ExchCode = 'BER', PermQuoteRetireDate = '2018-04-27' WHERE SecCode = 560723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814307220, ExchCode = 'TDG' WHERE SecCode = 560728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850811719, ExchCode = 'BER', PermQuoteRetireDate = '2015-05-06' WHERE SecCode = 561328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525342898, ExchCode = 'STU' WHERE SecCode = 561861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035863, ExchCode = 'TDG' WHERE SecCode = 562914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610776904, ExchCode = 'STU' WHERE SecCode = 563028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857527840, ExchCode = 'FRA' WHERE SecCode = 563938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857450136, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 564035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21580382275, PermQuoteStatus = 'AC', ExchCode = 'BTE', PermQuoteRetireDate = NULL WHERE SecCode = 564862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034792, ExchCode = 'TDG' WHERE SecCode = 565294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474958339, ExchCode = 'DEU' WHERE SecCode = 565316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492892892, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 565330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475822753, ExchCode = 'DEU', PermQuoteRetireDate = '2013-10-01' WHERE SecCode = 565586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762578358, ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-16' WHERE SecCode = 565707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475805271, ExchCode = 'STU' WHERE SecCode = 565752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864886870, ExchCode = 'MUN' WHERE SecCode = 565861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474962557, ExchCode = 'DEU' WHERE SecCode = 565866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174126940, ExchCode = 'DEU' WHERE SecCode = 566528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857959487, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 567636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622957126, ExchCode = 'DUS' WHERE SecCode = 568338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991500, PermQuoteStatus = 'AC', Ticker = 'XLE1', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 568823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540583981, ExchCode = 'STU', PermQuoteRetireDate = '2018-08-13' WHERE SecCode = 568829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858358353, ExchCode = 'FRA', PermQuoteRetireDate = '2015-06-03' WHERE SecCode = 569981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522667431, ExchCode = 'STU' WHERE SecCode = 571383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22150905590, ExchCode = 'DEU' WHERE SecCode = 573544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475782323, Ticker = 'S6OB', ExchCode = 'STU', PermQuoteRetireDate = '2020-04-22', PermSecMapEndDate = '2020-04-22' WHERE SecCode = 574243 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 574399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858572959, ExchCode = 'BER', PermQuoteRetireDate = '2015-07-20' WHERE SecCode = 580444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511793851, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 583151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910180906, ExchCode = 'DEU' WHERE SecCode = 588124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858902712, ExchCode = 'BER' WHERE SecCode = 592307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474967930, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 593104 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 594191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859254285, ExchCode = 'FRA', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 599978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531671030, ExchCode = 'STU' WHERE SecCode = 604212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622957124, ExchCode = 'DUS' WHERE SecCode = 612103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521225328, ExchCode = 'STU' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 649889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863402759, Ticker = 'OCSP', ExchCode = 'LSE' WHERE SecCode = 649936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991761, ExchCode = 'MUN' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951829.0 WHERE SecCode = 674803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475001222, ExchCode = 'FRA' WHERE SecCode = 680739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475745081, Ticker = '0NP6', ExchCode = 'LSE', PermQuoteRetireDate = '2015-09-09' WHERE SecCode = 693688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521102286, ExchCode = 'STU' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474962484, ExchCode = 'DEU', PermQuoteRetireDate = '2022-07-22', PermSecMapEndDate = '2022-07-22' WHERE SecCode = 696379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540229905, ExchCode = 'STU' WHERE SecCode = 701753 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951829.0 WHERE SecCode = 702439 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 703029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863005195, Ticker = 'BABC', ExchCode = 'LSE' WHERE SecCode = 703518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865088683, ExchCode = 'TDG' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 758296 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 767311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806409997, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 771838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287357, ExchCode = 'MEX' WHERE SecCode = 780513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749996718, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 826159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423013, ExchCode = 'FRA' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379950, ExchCode = 'FRA' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913525, ExchCode = 'DEU' WHERE SecCode = 878880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55867148469, Ticker = 'XSIL', ExchCode = 'SWX' WHERE SecCode = 880290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528542094, ExchCode = 'TDG' WHERE SecCode = 881802 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 882517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660807802, ExchCode = 'MUN' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 907542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545813896, ExchCode = 'DEU' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 983288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769605, Ticker = 'TYMA', ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 995830 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 1246734 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 1294820 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 1425611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582997752, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1455200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482394593, Ticker = 'BLITs', ExchCode = 'BUR', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-05-01' WHERE SecCode = 1465007 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 1485661 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 = 21488288403, ExchCode = 'FRA' WHERE SecCode = 1524542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850857936, ExchCode = 'MUN' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179775, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488652814, ExchCode = 'FRA', DomCntry = 'CHN' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497767, ExchCode = 'DEU' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494267747, ExchCode = 'FRA' WHERE SecCode = 1541369 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'AUS' WHERE SecCode = 1542749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494609083, ExchCode = 'FRA', PermQuoteRetireDate = '2016-09-12' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 1550881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461757, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-04' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'AUS' WHERE SecCode = 1651338 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 1707750 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515521924, ExchCode = 'FRA' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 1856460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538768207, Ticker = 'ECXl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2013070 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 2055290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815142016, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 2087901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589938022, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2126923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947457, ExchCode = 'FRA' WHERE SecCode = 2142278 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 = 21522133570, ExchCode = 'STU' WHERE SecCode = 2222349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474891021, Ticker = '4KPN', ExchCode = 'ETX' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834226, ExchCode = 'DEU' WHERE SecCode = 2225286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478541, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068269, ExchCode = 'DEU' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652141579, ExchCode = 'EQD' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 2260564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967894, ExchCode = 'MUN' WHERE SecCode = 2278245 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 = 21530263647, ExchCode = 'FRA' WHERE SecCode = 2357967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529719631, ExchCode = 'TDG' WHERE SecCode = 2357969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484790, ExchCode = 'QTX' WHERE SecCode = 2357974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' 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 = 21843587991, ExchCode = 'GTX' 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 PermQuoteRetireDate = '2026-07-01' WHERE SecCode = 2394793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532252447, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-11' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535281436, ExchCode = 'STU' WHERE SecCode = 2403143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777643090, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2412432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786676625, ExchCode = 'BIV' WHERE SecCode = 2414027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704199, ExchCode = 'MXQ' WHERE SecCode = 2455541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535492269, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 2466348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999786388, ExchCode = 'DXE' WHERE SecCode = 2510129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312128, ExchCode = 'GTX' WHERE SecCode = 2515738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798387416, ExchCode = 'HAM' WHERE SecCode = 2518731 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ARE' WHERE SecCode = 2524705 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 2524748 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ARE' WHERE SecCode = 2527967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817958767, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-23', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2529636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587290079, ExchCode = 'STU' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850059046, ExchCode = 'MUN' WHERE SecCode = 2545065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544722891, ExchCode = 'STU' WHERE SecCode = 2556581 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2563198 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2564920 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2570568 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2572310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542813327, ExchCode = 'TDG' WHERE SecCode = 2573038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545190668, ExchCode = 'FRA', PermQuoteRetireDate = '2014-12-29' WHERE SecCode = 2578855 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2578880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121993910, ExchCode = 'BCO' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 2591696 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 = 21545670880, ExchCode = 'AUX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566715663, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2604391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664823736, ExchCode = 'MUN' WHERE SecCode = 2604394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609149462, Ticker = '3ITS', ExchCode = 'LSE' WHERE SecCode = 2604404 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 2618912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606782728, ExchCode = 'FRA' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574200693, ExchCode = 'FRA' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819966448, ExchCode = 'TDG' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478452, ExchCode = 'QTX' WHERE SecCode = 2649155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397387, ExchCode = 'GTX' WHERE SecCode = 2649166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549411041, ExchCode = 'FRA', PermQuoteRetireDate = '2017-11-02' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742655, ExchCode = 'HAN' WHERE SecCode = 2679857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451762, Ticker = 'HPQ', ExchCode = 'SWX' WHERE SecCode = 2679919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535196967, Ticker = 'QCI', ExchCode = 'BRN' WHERE SecCode = 2679937 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'KEN' WHERE SecCode = 2694699 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 2697231 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2697334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837147070, ExchCode = 'DUS' WHERE SecCode = 2708937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629355954, ExchCode = 'TDG' WHERE SecCode = 2711152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552934405, ExchCode = 'MEX' WHERE SecCode = 2724356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264997, ExchCode = 'DEU' WHERE SecCode = 2732754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706109, Ticker = 'WFTN', ExchCode = 'MXQ' WHERE SecCode = 2767178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674963, ExchCode = 'BIV' WHERE SecCode = 2767208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367198, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 2770609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843924533, ExchCode = 'FRA' WHERE SecCode = 2809752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558476903, ExchCode = 'FRA' WHERE SecCode = 2813079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557544156, ExchCode = 'FRA' WHERE SecCode = 2817416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558155337, ExchCode = 'FRA' WHERE SecCode = 2823565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561432644, ExchCode = 'FRA' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559401588, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2836268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557544170, ExchCode = 'MUN', PermQuoteRetireDate = '2018-07-05' WHERE SecCode = 2837420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763993243, Ticker = '8PSGd', ExchCode = 'BCO' WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559588394, ExchCode = 'FRA' WHERE SecCode = 2848442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560671440, ExchCode = 'FRA' WHERE SecCode = 2855770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560761799, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2856999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21579730411, ExchCode = 'DEU' WHERE SecCode = 2857019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952406, ExchCode = 'FRA' WHERE SecCode = 2858567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599175171, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2861791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478711, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677051, ExchCode = 'BIV' WHERE SecCode = 2876241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478695, ExchCode = 'QTX' WHERE SecCode = 2880971 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951870.0 WHERE SecCode = 2882459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563177962, ExchCode = 'FRA' WHERE SecCode = 2887312 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2890504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 2898790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430845, ExchCode = 'DEU' WHERE SecCode = 2900911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479042, ExchCode = 'QTX' WHERE SecCode = 2905610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565633193, PermQuoteStatus = 'AC', Ticker = 'CM30', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2907243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731661976, ExchCode = 'MUN' WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564680222, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-19' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564846532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 2909243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564938913, ExchCode = 'DEU' WHERE SecCode = 2909928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565148442, ExchCode = 'MUN' WHERE SecCode = 2911859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370656, ExchCode = 'SGO' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566806429, ExchCode = 'DEU' WHERE SecCode = 2930976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567022234, ExchCode = 'FRA', PermQuoteRetireDate = '2019-05-27', PermSecMapEndDate = NULL WHERE SecCode = 2932394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672243657, PermQuoteStatus = 'DC', Ticker = '16IE', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2935960 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 2945279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836510352, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-16' WHERE SecCode = 2947875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670295233, ExchCode = 'STU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569151527, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2952372 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 2955168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704396, ExchCode = 'MXQ' WHERE SecCode = 2963604 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 2966346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573047978, ExchCode = 'BTE', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 2993543 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 = 21576175357, ExchCode = 'DEU' WHERE SecCode = 3032214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594331200, ExchCode = 'MUN' WHERE SecCode = 3059437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582997825, Ticker = 'RYA', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3072584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641139161, Ticker = 'J75', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-18' WHERE SecCode = 3096965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800738271, ExchCode = 'QTX' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587220566, ExchCode = 'TDG' WHERE SecCode = 3153872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587931857, ExchCode = 'BTE' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705845, ExchCode = 'MXQ' WHERE SecCode = 3166848 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3174272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749466038, ExchCode = 'MUN' WHERE SecCode = 3181133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22137202074, ExchCode = 'DEU' WHERE SecCode = 3186751 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 3194838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589742989, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3196346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786342003, Ticker = 'XMW2', ExchCode = 'STU' WHERE SecCode = 3198718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590371242, ExchCode = 'FRA' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21714016577, ExchCode = 'MUN' WHERE SecCode = 3215534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748306921, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 3215564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150007, Ticker = 'AD', ExchCode = 'SWX' WHERE SecCode = 3217753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865877693, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-23' WHERE SecCode = 3223076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614079174, ExchCode = 'TDG', PermQuoteRetireDate = '2017-05-25' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 3244402 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 3244404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718045329, ExchCode = 'MUN' WHERE SecCode = 3245391 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 DomCntry = 'CYM' WHERE SecCode = 3247786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597045213, ExchCode = 'DEU' WHERE SecCode = 3247982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651373312, ExchCode = 'DEU' WHERE SecCode = 3255012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617415254, ExchCode = 'MUN' WHERE SecCode = 3255028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651750989, ExchCode = 'DEU' WHERE SecCode = 3257170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597702989, ExchCode = 'DEU' WHERE SecCode = 3260047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800110, ExchCode = 'CHI' WHERE SecCode = 3263198 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 3274531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704422, Ticker = 'CERN*', ExchCode = 'MXQ' WHERE SecCode = 3275597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 3277040 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277079 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 3277168 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760588308, ExchCode = 'STU' WHERE SecCode = 3281992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007430, ExchCode = 'DEU' WHERE SecCode = 3282311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954945, ExchCode = 'LAS' WHERE SecCode = 3283696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602970799, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3283956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604748306, ExchCode = 'FRA' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 3300833 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 = 21857609616, ExchCode = 'DUS' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607711783, ExchCode = 'FRA' WHERE SecCode = 3308987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797988618, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-29' WHERE SecCode = 3309705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608278641, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705301, Ticker = 'LOGM*', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379972, ExchCode = 'FRA' WHERE SecCode = 3316586 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3317103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786651644, ExchCode = 'QTX' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609137328, ExchCode = 'FRA' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237022, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-01', PermSecMapEndDate = NULL WHERE SecCode = 3318127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610776896, ExchCode = 'STU' WHERE SecCode = 3320375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649841825, ExchCode = 'BER' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788762034, ExchCode = 'FRA' WHERE SecCode = 3337223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510732, ExchCode = 'DUS' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887550956, ExchCode = 'MUN' WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 3347821 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 3350482 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR', PriTRBCIndPermID = 4294951400.0 WHERE SecCode = 3358056 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793387209, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3358543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050504, ExchCode = 'FRA' WHERE SecCode = 3359272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805023784, ExchCode = 'DEU' WHERE SecCode = 3368562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237487, ExchCode = 'DEU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819145774, PermQuoteStatus = 'AC', Ticker = '015A', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3375389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674480, ExchCode = 'BIV' WHERE SecCode = 3385617 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3393973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378814, ExchCode = 'BRN' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378719, ExchCode = 'BRN' WHERE SecCode = 3394008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378638, ExchCode = 'BRN' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390710, ExchCode = 'FRA' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21637054002, ExchCode = 'BTE' WHERE SecCode = 3395249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624541573, ExchCode = 'FRA' WHERE SecCode = 3400265 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 3403353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718790762, ExchCode = 'CHI' WHERE SecCode = 3404188 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3404447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629355998, ExchCode = 'TDG', PermQuoteRetireDate = '2024-07-31', PermSecMapEndDate = '2024-08-30' WHERE SecCode = 3405438 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 3407480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256368, ExchCode = 'QTX' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784205314, ExchCode = 'FRA' WHERE SecCode = 3407871 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951907.0 WHERE SecCode = 3408122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396615, ExchCode = 'DEU' WHERE SecCode = 3409090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301441, ExchCode = 'MEX' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 3430823 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 3433213 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 3437196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796441340, ExchCode = 'HAM' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643223564, ExchCode = 'DEU' WHERE SecCode = 3444252 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2005-09-02' WHERE SecCode = 3445791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298408, ExchCode = 'GTX' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645305949, ExchCode = 'FRA' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645435116, ExchCode = 'BER', PermQuoteRetireDate = '2020-01-02' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938004022, ExchCode = 'GTX' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647221128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648822392, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-08', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388282, ExchCode = 'LAS', PermQuoteRetireDate = '2025-07-29' WHERE SecCode = 3501431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749468782, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3503523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505148, ExchCode = 'STU' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 3523383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763474273, ExchCode = 'BER', PermQuoteRetireDate = '2025-09-02', PermSecMapEndDate = NULL WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284691, ExchCode = 'GTX' WHERE SecCode = 3531554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434494, ExchCode = 'LAS' WHERE SecCode = 3532734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 3543194 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3546415 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3546511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795072494, ExchCode = 'LAS' WHERE SecCode = 3549499 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 3551893 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3562797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997896, ExchCode = 'DEU', PermQuoteRetireDate = '2023-06-08', PermSecMapEndDate = '2023-06-08' WHERE SecCode = 3565802 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 3566802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705145, ExchCode = 'MXQ' WHERE SecCode = 3569558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388326, ExchCode = 'LAS' WHERE SecCode = 3569563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808198553, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 3578524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705892, ExchCode = 'MXQ' WHERE SecCode = 3580734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731165516, ExchCode = 'DEU' WHERE SecCode = 3584663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479953, ExchCode = 'QTX', PermQuoteRetireDate = '2024-11-21', PermSecMapEndDate = NULL WHERE SecCode = 3586984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879562247, ExchCode = 'GTX' WHERE SecCode = 3587019 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 QuotePermID = 21993741453, Ticker = 'AEJl', ExchCode = 'AQX' WHERE SecCode = 3587037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388252, ExchCode = 'LAS' WHERE SecCode = 3587074 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 = 21617123544, ExchCode = 'SIG' 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 = 21656673826, ExchCode = 'BIV' WHERE SecCode = 3588038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296175, ExchCode = 'GTX' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704616, ExchCode = 'MXQ' WHERE SecCode = 3588107 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 = 236781569854, ExchCode = 'QTX' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661362251, ExchCode = 'STU' WHERE SecCode = 3589054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952421, ExchCode = 'DEU' WHERE SecCode = 3591601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704534, ExchCode = 'MXQ' WHERE SecCode = 3593773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862967432, ExchCode = 'GTX' WHERE SecCode = 3603616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704243, ExchCode = 'MXQ' WHERE SecCode = 3604834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664171446, PermQuoteStatus = 'DC', Ticker = '2HQ', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28' WHERE SecCode = 3610775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664433945, ExchCode = 'STU' WHERE SecCode = 3610818 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 3615187 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 = 21830273950, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3619536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704823, ExchCode = 'MXQ' WHERE SecCode = 3629694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779823334, ExchCode = 'GTX' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 3634378 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3635502 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3635507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290518, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668783311, ExchCode = 'HAM' WHERE SecCode = 3642406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732298100, ExchCode = 'DUS', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705588, ExchCode = 'MXQ' WHERE SecCode = 3644857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690033954, ExchCode = 'MUN' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670410338, Ticker = 'ROAI', ExchCode = 'SWX', PermQuoteRetireDate = '2023-09-22' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581867, ExchCode = 'QTX' WHERE SecCode = 3657811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308294, ExchCode = 'GTX' WHERE SecCode = 3658775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723938636, PermQuoteStatus = 'DC', Ticker = 'EP2', ExchCode = 'QTX', PermQuoteRetireDate = '2023-09-05' WHERE SecCode = 3663204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670090378, ExchCode = 'BER' WHERE SecCode = 3664306 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 3665621 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 3675449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569892, ExchCode = 'QTX' WHERE SecCode = 3675861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818953054, ExchCode = 'DUS' WHERE SecCode = 3703433 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951989.0 WHERE SecCode = 3713262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297867, ExchCode = 'DUS', PermQuoteRetireDate = '2021-10-21' WHERE SecCode = 3716790 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 3727966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750787655, ExchCode = 'FRA' WHERE SecCode = 3731132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383888, ExchCode = 'BIV' WHERE SecCode = 3732368 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 = 21801047807, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803135585, ExchCode = 'FRA' WHERE SecCode = 3756337 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 PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30' WHERE SecCode = 3762893 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 = 21758727556, ExchCode = 'MUN', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3779971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377692, ExchCode = 'BIV' WHERE SecCode = 3783012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690636322, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687895445, ExchCode = 'STU' WHERE SecCode = 3793435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705324, ExchCode = 'MXQ' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 3794697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733938467, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-05', PermSecMapEndDate = NULL WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 236780314322, ExchCode = 'GTX' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 3818214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623734, ExchCode = 'TDG' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394215, ExchCode = 'MEX' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3825565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932282, ExchCode = 'DEU' WHERE SecCode = 3827962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650319, ExchCode = 'QTX' WHERE SecCode = 3829975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930883, Ticker = 'BM51', ExchCode = 'MUN', PermQuoteRetireDate = '2022-05-17' 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 PriTRBCIndPermID = 4294951569.0 WHERE SecCode = 3833953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696168646, ExchCode = 'DEU' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659513, PermQuoteStatus = 'AC', Ticker = '2ZT1', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865590408, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841766443, ExchCode = 'QTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787746616, ExchCode = 'SIU', PermQuoteRetireDate = '2025-01-04' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 3857957 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 3858206 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 3862212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830030, ExchCode = 'QTX' WHERE SecCode = 3863388 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951416.0 WHERE SecCode = 3868549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701895330, ExchCode = 'STU' WHERE SecCode = 3875755 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951716.0 WHERE SecCode = 3875786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702351475, ExchCode = 'DEU', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703557839, Ticker = 'UPR', ExchCode = 'LSE' WHERE SecCode = 3883708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789792374, ExchCode = 'DUS' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785083485, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-03-26' WHERE SecCode = 3890307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900276, ExchCode = 'TDG' WHERE SecCode = 3898812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703664166, ExchCode = 'STU' WHERE SecCode = 3898813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3899672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820365544, ExchCode = 'DUS', PermQuoteRetireDate = '2025-12-02' WHERE SecCode = 3905161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209283, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705085367, ExchCode = 'FRA' WHERE SecCode = 3908080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432052, ExchCode = 'DEU' WHERE SecCode = 3908081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320066, ExchCode = 'DEU' WHERE SecCode = 3908087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755619, ExchCode = 'FRA' WHERE SecCode = 3913159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820576474, ExchCode = 'DUS' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 3947539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272890, ExchCode = 'GTX' WHERE SecCode = 3951450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712452863, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3955660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 3987649 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 3987717 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 PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 4010838 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 4010949 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951449.0 WHERE SecCode = 4024642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359395, ExchCode = 'SIG' WHERE SecCode = 4024795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026823, Ticker = '1T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026845, Ticker = '1GLW' WHERE SecCode = 4031714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026831, Ticker = '1AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027042, Ticker = '1AAD' WHERE SecCode = 4031778 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 = 236780027148, Ticker = '1DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009871, Ticker = '2EUZ' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026810, Ticker = '1G' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026915, Ticker = '1HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027132, Ticker = '1HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026954, Ticker = '1HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026869, Ticker = '1INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026971, Ticker = '1LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026785, Ticker = '1NDX' WHERE SecCode = 4031953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027139, Ticker = '1PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787861869, Ticker = '1PYPLm', ExchCode = 'BCO' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 4032010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013288, Ticker = '2PM' WHERE SecCode = 4032067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013994, Ticker = '2CRM' WHERE SecCode = 4032071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143797, Ticker = '2AKZA', ExchCode = 'MIL' WHERE SecCode = 4032088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011235, Ticker = '2IAG' WHERE SecCode = 4032120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822947768, Ticker = '4DSY', ExchCode = 'ETX' WHERE SecCode = 4032132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723633857, ExchCode = 'STU' WHERE SecCode = 4032148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723632161, ExchCode = 'DEU' WHERE SecCode = 4032154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179786, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779134244, ExchCode = 'AQX' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571645915, ExchCode = 'SGO' WHERE SecCode = 4046481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725978350, ExchCode = 'DEU' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652454, ExchCode = 'FRA' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997868, ExchCode = 'DEU' WHERE SecCode = 4046659 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 4046692 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 4054258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732154152, ExchCode = 'FRA' WHERE SecCode = 4080678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260354, ExchCode = 'FRA' WHERE SecCode = 4099601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818713443, PermQuoteStatus = 'DC', Ticker = '4E40', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 4101126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587084065, ExchCode = 'STU' WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 4103685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774179873, Ticker = '7M4', ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 4103711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737082360, ExchCode = 'DUS' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586975, ExchCode = 'FRA' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738226580, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4124713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858461751, ExchCode = 'STU', PermQuoteRetireDate = '2024-11-05', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4124848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674204, ExchCode = 'BIV' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381466, ExchCode = 'LAS' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739433458, ExchCode = 'DEU' WHERE SecCode = 4178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745348418, ExchCode = 'TDG' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755406168, ExchCode = 'STU' WHERE SecCode = 4195320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', Ticker = 'Z620', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963695, PermQuoteStatus = 'DC', Ticker = '4R80', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-17', PermSecMapEndDate = '2026-04-23' WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772634388, ExchCode = 'DUS' WHERE SecCode = 4212482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999014130, Ticker = '2NOW' WHERE SecCode = 4214371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011916, Ticker = '2AMT' WHERE SecCode = 4214372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011917, Ticker = '2AWK' WHERE SecCode = 4214377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012327, Ticker = '2GD' WHERE SecCode = 4214384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012556, Ticker = '2HLT' WHERE SecCode = 4214387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013434, Ticker = '2SPG' WHERE SecCode = 4214395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013297, Ticker = '2SYK' WHERE SecCode = 4214397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013876, Ticker = '2TROW' WHERE SecCode = 4214399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013596, Ticker = '2WEC' WHERE SecCode = 4214401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371806, Ticker = '0Q3', ExchCode = 'BRN' WHERE SecCode = 4214409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013708, Ticker = '2PLUG', ExchCode = 'MIL' WHERE SecCode = 4214415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740527, ExchCode = 'LAS' WHERE SecCode = 4225217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349456, ExchCode = 'MEX' WHERE SecCode = 4228288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749841407, ExchCode = 'FRA' WHERE SecCode = 4228324 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4243433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756548990, ExchCode = 'FRA' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487958, ExchCode = 'DUS' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA', PriTRBCIndPermID = 4294951260.0 WHERE SecCode = 4291578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759692063, ExchCode = 'DEU' WHERE SecCode = 4295731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763122567, ExchCode = 'MUN' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727343768, ExchCode = 'BIV' 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 = 21762580130, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4315115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842459237, ExchCode = 'HAN' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763690130, ExchCode = 'QTX' WHERE SecCode = 4321393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839048914, ExchCode = 'MUN' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763966475, ExchCode = 'FRA' WHERE SecCode = 4327051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871880783, ExchCode = 'MUN' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771445002, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799675, ExchCode = 'HAM' WHERE SecCode = 4365921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877510586, ExchCode = 'MUN' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606760, ExchCode = 'DEU' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510674, ExchCode = 'QTX' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4376012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870599, ExchCode = 'FRA' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 4382172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738813552, ExchCode = 'STU' WHERE SecCode = 4383309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845531963, ExchCode = 'GTX' WHERE SecCode = 4388200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777507955, ExchCode = 'MUN' WHERE SecCode = 4394782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826495190, ExchCode = 'DUS' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4396708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991740, ExchCode = 'FRA' WHERE SecCode = 4400153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778893656, ExchCode = 'DEU', PermQuoteRetireDate = '2020-11-23' WHERE SecCode = 4400157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281540, ExchCode = 'STU' WHERE SecCode = 4402301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307581, ExchCode = 'MEX' WHERE SecCode = 4403942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307749, ExchCode = 'MEX' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778680774 WHERE SecCode = 4406073 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4406352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234893, ExchCode = 'BER' WHERE SecCode = 4413712 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 4415704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785622125, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377503, ExchCode = 'MEX' WHERE SecCode = 4417298 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4420889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727304579, ExchCode = 'BIV' WHERE SecCode = 4421213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307328, ExchCode = 'BIV', DomCntry = 'SGP' WHERE SecCode = 4422396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999132, ExchCode = 'FRA' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370427, ExchCode = 'AQX' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 4425514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782653669, ExchCode = 'GTX' WHERE SecCode = 4426955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013269, Ticker = '2VTRS' WHERE SecCode = 4427826 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-04-29', PermSecMapEndDate = NULL WHERE SecCode = 4427868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779047734, ExchCode = 'BER', PriTRBCIndPermID = 4294951880.0, PermQuoteRetireDate = '2024-04-05', PermSecMapEndDate = NULL WHERE SecCode = 4427929 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 PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4442088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787027751, PermQuoteStatus = 'DC', Ticker = '60P', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685950, ExchCode = 'DEU' WHERE SecCode = 4444002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791908410, ExchCode = 'TDG' WHERE SecCode = 4451262 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 4456159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727314620, ExchCode = 'MEX' WHERE SecCode = 4458998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954828, ExchCode = 'LAS' WHERE SecCode = 4459009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797412670, ExchCode = 'STU' WHERE SecCode = 4463145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689543, ExchCode = 'FRA' WHERE SecCode = 4463152 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'CHM' WHERE SecCode = 4470097 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793399825, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4470175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797398508, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4470353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396762, ExchCode = 'DEU' WHERE SecCode = 4472909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396957, ExchCode = 'DEU' WHERE SecCode = 4472926 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4472928 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4472930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955013, ExchCode = 'LAS' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528202, ExchCode = 'DUS' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21834002300, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4479279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367255, ExchCode = 'DEU' WHERE SecCode = 4482517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367200, ExchCode = 'DEU' WHERE SecCode = 4482720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796870257, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306777, ExchCode = 'BIV' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809534, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820607, ExchCode = 'FRA' WHERE SecCode = 4499152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797994407, ExchCode = 'STU' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727286505, ExchCode = 'BIV' WHERE SecCode = 4505794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386877, ExchCode = 'LAS' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296365, ExchCode = 'GTX' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381380, ExchCode = 'LAS' WHERE SecCode = 4526143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851345226, ExchCode = 'MUN' WHERE SecCode = 4526144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627749, ExchCode = 'QTX' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803607182, Ticker = '0RW0', ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803771918, ExchCode = 'DEU' WHERE SecCode = 4536450 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 4539304 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 = 25727349196, ExchCode = 'BIV' WHERE SecCode = 4550708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812165966, ExchCode = 'STU' WHERE SecCode = 4553829 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143000521, ExchCode = 'DEU' WHERE SecCode = 4557948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144478, ExchCode = 'FRA' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808950993, ExchCode = 'FRA' WHERE SecCode = 4568422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811980857, ExchCode = 'MUN' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22135794225, Ticker = 'XLME', ExchCode = 'HAM' WHERE SecCode = 4579626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814382045, ExchCode = 'DEU' WHERE SecCode = 4594421 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 = 236781581925, ExchCode = 'QTX' WHERE SecCode = 4603537 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 4605827 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4607553 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 = 21816288448, ExchCode = 'DEU' WHERE SecCode = 4609999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727263611, ExchCode = 'MEX' WHERE SecCode = 4610049 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4611003 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4612251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985397, ExchCode = 'TDG' WHERE SecCode = 4613099 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4616759 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4618016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968078, ExchCode = 'DEU' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951559.0 WHERE SecCode = 4630506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778677427, ExchCode = 'QTX' WHERE SecCode = 4632109 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4633110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963759, ExchCode = 'STU' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914249, ExchCode = 'MUN' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792996699, ExchCode = 'LAS' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839048901, Ticker = 'FWR0', ExchCode = 'MUN' WHERE SecCode = 4657695 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4658657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833158985, ExchCode = 'DEU' WHERE SecCode = 4677605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795845914, ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835615671, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873118953, Ticker = 'CARBm', ExchCode = 'BCO' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA', PriTRBCIndPermID = 4294951260.0 WHERE SecCode = 4693722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026894, Ticker = '1STX', DomCntry = 'SGP' WHERE SecCode = 4699232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037614, ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-21' WHERE SecCode = 4707187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233438, ExchCode = 'BIV' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799043657, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850051602, ExchCode = 'TDG' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21849806512, ExchCode = 'FRA', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 4741132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098665, ExchCode = 'FRA' WHERE SecCode = 4745391 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4752191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853931452, PermQuoteStatus = 'DC', Ticker = 'GSP', ExchCode = 'LSE', PermQuoteRetireDate = '2024-07-01', PermSecMapEndDate = '2024-07-01' WHERE SecCode = 4761540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855820605, ExchCode = 'DEU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 4777220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856729893, ExchCode = 'DEU' WHERE SecCode = 4777352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609722, ExchCode = 'DUS' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'PAK' WHERE SecCode = 4784485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857866487, ExchCode = 'MUN' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788376836, Ticker = 'A6Id', ExchCode = 'BCO' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860598008, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4800552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615834, ExchCode = 'MUN' WHERE SecCode = 4800673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380494, ExchCode = 'LAS', PermQuoteRetireDate = '2026-02-12' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951546.0 WHERE SecCode = 4838006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22137440329, Ticker = 'BTICz', ExchCode = 'CHI' WHERE SecCode = 4842798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789616854, ExchCode = 'QTX' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885446303, ExchCode = 'GTX' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580179, ExchCode = 'GER' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4863021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876129776, ExchCode = 'QTX' WHERE SecCode = 4885603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954831, ExchCode = 'LAS' WHERE SecCode = 4887246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932177205, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954949, ExchCode = 'LAS' WHERE SecCode = 4907129 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 4929497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882166752, PermQuoteStatus = 'DC', Ticker = 'Y23', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4934325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478060, ExchCode = 'DEU' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781980293, PermQuoteStatus = 'DC', Ticker = '62U1', ExchCode = 'BER', PermQuoteRetireDate = '2025-09-01' WHERE SecCode = 4943250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914321191, ExchCode = 'MUN', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 4943410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884962075, ExchCode = 'STU' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883516418, ExchCode = 'FRA' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890422385, ExchCode = 'GTX' WHERE SecCode = 4950864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 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 = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936307256, ExchCode = 'MUN' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' 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 = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100827, ExchCode = 'DUS' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894278989, ExchCode = 'STU' WHERE SecCode = 5009346 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 PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5018957 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5019830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387449, ExchCode = 'LAS' WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805995535, ExchCode = 'FRA' WHERE SecCode = 5031899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153246013, ExchCode = 'BTE' WHERE SecCode = 5038692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898852880, ExchCode = 'FRA' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388832, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976743, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5042969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727380611, Ticker = 'DC4', ExchCode = 'BRN' WHERE SecCode = 5047087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907031229, ExchCode = 'STU' WHERE SecCode = 5067269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907031273, ExchCode = 'STU' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663797, ExchCode = 'DEU' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973577618, ExchCode = 'TDG' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380640, ExchCode = 'LAS' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799900, ExchCode = 'HAM' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779601759, ExchCode = 'STU' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910168364, ExchCode = 'DUS' WHERE SecCode = 5094355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716500, ExchCode = 'FRA' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875317, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27', PermSecMapEndDate = '2023-10-27' WHERE SecCode = 5112411 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 5116861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781637018, ExchCode = 'HAM' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923404247, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-21' WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912121144, ExchCode = 'FRA' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535351, ExchCode = 'DEU' WHERE SecCode = 5134589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642004, ExchCode = 'QTX' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365408.0 WHERE SecCode = 5152259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830485, ExchCode = 'DUS' WHERE SecCode = 5153443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423065, ExchCode = 'FRA' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790867, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273208, ExchCode = 'GTX' WHERE SecCode = 5161225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706246, ExchCode = 'MXQ' WHERE SecCode = 5161230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795000643, Ticker = '0A65', ExchCode = 'LSE', PermQuoteRetireDate = '2025-08-08' WHERE SecCode = 5161239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843186265, Ticker = '0A60l', ExchCode = 'BCO' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633621506, Ticker = '0M1K', ExchCode = 'LSE' WHERE SecCode = 5161267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730598077, ExchCode = 'FRA' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793473641, ExchCode = 'CHI' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180699, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727248292, ExchCode = 'MEX' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727344849, ExchCode = 'BIV' 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 = 21521369386, ExchCode = 'SGO' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924150711, ExchCode = 'STU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381527, ExchCode = 'LAS' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475730650, ExchCode = 'GER', PermQuoteRetireDate = '2005-10-08' WHERE SecCode = 5161443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727196907, ExchCode = 'MEX' WHERE SecCode = 5161445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569896, ExchCode = 'QTX' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561584, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MUS' WHERE SecCode = 5188864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933953345, ExchCode = 'TDG' WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923944044, ExchCode = 'DEU' WHERE SecCode = 5189106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421566, PermQuoteStatus = 'AC', Ticker = '3SZNm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5195447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535364, ExchCode = 'MUN' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5206280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140088087, ExchCode = 'HAM' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801543852, ExchCode = 'HAM' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388873, ExchCode = 'LAS' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787664879, ExchCode = 'QTX' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387487, ExchCode = 'LAS' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775222346, ExchCode = 'BIV' WHERE SecCode = 5267090 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5269471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100719, ExchCode = 'QTX' WHERE SecCode = 5272089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938340072, ExchCode = 'STU' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851306, ExchCode = 'LAS' WHERE SecCode = 5281346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107117, ExchCode = 'MEX' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781180723, ExchCode = 'GTX' WHERE SecCode = 5290322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803327, ExchCode = 'DUS' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077356, ExchCode = 'LAS', PermQuoteRetireDate = '2025-08-08', PermSecMapEndDate = NULL WHERE SecCode = 5311845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775732426, ExchCode = 'BIV' WHERE SecCode = 5329511 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951260.0 WHERE SecCode = 5332093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581879, ExchCode = 'QTX' WHERE SecCode = 5338742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791510353, ExchCode = 'MUN' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633707, ExchCode = 'DEU' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952290566, ExchCode = 'STU', PermQuoteRetireDate = '2025-01-07' WHERE SecCode = 5347430 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 5360706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381676, ExchCode = 'LAS' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380716, ExchCode = 'LAS' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962356959, ExchCode = 'DEU' WHERE SecCode = 5395767 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5403438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874394, ExchCode = 'GTX' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812179638, ExchCode = 'DEU' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5415160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378859, ExchCode = 'FRA' WHERE SecCode = 5415164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107109, ExchCode = 'BIV' WHERE SecCode = 5430834 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5447504 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5447505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380730, PermQuoteStatus = 'DC', ExchCode = 'LAS', PermQuoteRetireDate = '2025-03-17' WHERE SecCode = 5457242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348315, ExchCode = 'QTX' WHERE SecCode = 5466221 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951973.0 WHERE SecCode = 5470927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729828, ExchCode = 'FRA' WHERE SecCode = 5478214 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 5479496 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 5482522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 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 = 21874663656, ExchCode = 'AQX' WHERE SecCode = 5503782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128275, ExchCode = 'BCO' WHERE SecCode = 5503898 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 PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 5526261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779309034, ExchCode = 'MUN' WHERE SecCode = 5527560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21988984185, ExchCode = 'DEU' WHERE SecCode = 5527561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21988688380, ExchCode = 'MXQ' WHERE SecCode = 5531898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110956, Ticker = 'SFTGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110937, Ticker = '3SFTm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471348, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5541732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776857965, ExchCode = 'MEX' WHERE SecCode = 5551974 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951829.0 WHERE SecCode = 5565405 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'Z4U0' WHERE SecCode = 5568010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873360059, Ticker = '3MRN', ExchCode = 'MIL' WHERE SecCode = 5569367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883771506, ExchCode = 'FRA', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 5569960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780193394, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-30' WHERE SecCode = 5601088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942899, ExchCode = 'BIV' WHERE SecCode = 5631516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781224681, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22065452994, ExchCode = 'BRN' WHERE SecCode = 5645885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781543275, ExchCode = 'STU' WHERE SecCode = 5655040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307755, ExchCode = 'MEX' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951260.0 WHERE SecCode = 5693834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072896303, ExchCode = 'TDG' WHERE SecCode = 5715993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028682766, Ticker = '2HENS' WHERE SecCode = 5720895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028890988, ExchCode = 'DEU' WHERE SecCode = 5724940 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'O920' WHERE SecCode = 5726746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379581, ExchCode = 'LAS' WHERE SecCode = 5749952 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5758217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783529905, ExchCode = 'FRA' WHERE SecCode = 5764717 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 = 236780479748, ExchCode = 'MEX' WHERE SecCode = 5798239 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5805682 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 5805683 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 = 236788207229, ExchCode = 'FRA' WHERE SecCode = 5822326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784278056, ExchCode = 'STU' 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 = 236784418929, ExchCode = 'GTX' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551903, ExchCode = 'TDG' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357764, ExchCode = 'MEX' WHERE SecCode = 5836309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596707, ExchCode = 'FRA' WHERE SecCode = 5839460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596711, ExchCode = 'FRA' WHERE SecCode = 5839461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596713, ExchCode = 'FRA' WHERE SecCode = 5839464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596706, ExchCode = 'FRA' WHERE SecCode = 5839466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416444, ExchCode = 'BIV' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 5890322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800227924, ExchCode = 'TDG' WHERE SecCode = 5894957 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 5917726 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 5923157 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'PAK' WHERE SecCode = 5953916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 6043636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587649, ExchCode = 'FRA' WHERE SecCode = 6075918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587648, ExchCode = 'FRA' WHERE SecCode = 6075919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571976518, ExchCode = 'SGO' WHERE SecCode = 6095641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789902796, ExchCode = 'FRA' WHERE SecCode = 6095673 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'THA' WHERE SecCode = 6097255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370126, ExchCode = 'BEC' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 6097315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22017341387, ExchCode = 'STU' WHERE SecCode = 6097334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089781512, PermQuoteStatus = 'AC', Ticker = 'A4AN9W', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 6097382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171968, ExchCode = 'BIV' WHERE SecCode = 6097384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171457, ExchCode = 'MEX' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970308398, Ticker = 'NV3Sl', ExchCode = 'BCO' WHERE SecCode = 6097438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911612, ExchCode = 'BIV' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354550, ExchCode = 'BIV' WHERE SecCode = 6097578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822798834, ExchCode = 'BCO' WHERE SecCode = 6097580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791287038, ExchCode = 'FRA' WHERE SecCode = 6190705 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 6229972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791969104, ExchCode = 'FRA' WHERE SecCode = 6232187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136111001, Ticker = 'BTCFl', ExchCode = 'BTE' WHERE SecCode = 6245909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890431098, ExchCode = 'FRA' WHERE SecCode = 6256382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861193011, Ticker = 'SMHS', ExchCode = 'LSE' WHERE SecCode = 6256398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181397, ExchCode = 'BIV' WHERE SecCode = 6256406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801123684, ExchCode = 'FRA' WHERE SecCode = 6256407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818713443, PermQuoteStatus = 'DC', Ticker = '4E40', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 6256409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759798861, PermQuoteStatus = 'DC', Ticker = '0BF1', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819293760, PermQuoteStatus = 'DC', Ticker = '2IU0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 6256420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22082089941, ExchCode = 'QTX' WHERE SecCode = 6256447 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 6264136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269530, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 6269028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269527, ExchCode = 'HAM' WHERE SecCode = 6269033 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796404945, ExchCode = 'STU' WHERE SecCode = 6285539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801670228, ExchCode = 'MUN' WHERE SecCode = 6297520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792988435, ExchCode = 'GTX' WHERE SecCode = 6310651 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 6320984 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 6324152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910459, ExchCode = 'STU' WHERE SecCode = 6325196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655583, ExchCode = 'GER' WHERE SecCode = 6368868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793855800, ExchCode = 'TDG' WHERE SecCode = 6368981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789745448, ExchCode = 'BIV' WHERE SecCode = 6375301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866541, ExchCode = 'MEX' WHERE SecCode = 6375353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794030748, ExchCode = 'QTX' WHERE SecCode = 6383874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794188795, ExchCode = 'DUS' WHERE SecCode = 6392491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789515593, ExchCode = 'BIV' WHERE SecCode = 6394335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22120375079, ExchCode = 'DEU' WHERE SecCode = 6396772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297712, ExchCode = 'BIV' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951322.0 WHERE SecCode = 6418147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130904343, ExchCode = 'GTX' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794739725, ExchCode = 'FRA' WHERE SecCode = 6426995 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 6429307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795182771, ExchCode = 'FRA' WHERE SecCode = 6441867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142096843, ExchCode = 'SWX' WHERE SecCode = 6453964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128134015, ExchCode = 'DUS' WHERE SecCode = 6457998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128988769, ExchCode = 'DEU' WHERE SecCode = 6464979 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 6480867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109805, ExchCode = 'DUS' WHERE SecCode = 6501107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797836700, ExchCode = 'FRA' WHERE SecCode = 6513209 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 PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 6538857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797392, ExchCode = 'TDG' WHERE SecCode = 6548155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799207727, ExchCode = 'MUN' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-04-30' WHERE SecCode = 6562602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727247403, Ticker = '9MW', ExchCode = 'BRN' WHERE SecCode = 6578375 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 6583644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 6603571 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 6614117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21976165242, ExchCode = 'DEU' WHERE SecCode = 6626357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781821981, ExchCode = 'QTX' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451401, ExchCode = 'BTE' WHERE SecCode = 6627463 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 6627853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802456204, ExchCode = 'DUS' WHERE SecCode = 6638341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471843, ExchCode = 'DUS' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802807020, ExchCode = 'BIV' WHERE SecCode = 6664680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883770164, ExchCode = 'DEU' WHERE SecCode = 6667833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803478723, ExchCode = 'DUS' WHERE SecCode = 6686044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165234298, ExchCode = 'GTX' WHERE SecCode = 6710093 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 6712504 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30' WHERE SecCode = 6724270 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 6724298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804483784, ExchCode = 'STU' WHERE SecCode = 6728400 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 6734291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699530, ExchCode = 'MEX' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-29' WHERE SecCode = 6765362 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-29' WHERE SecCode = 6782591 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 6793550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806409090, ExchCode = 'GTX' WHERE SecCode = 6796826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791406431, ExchCode = 'MEX' WHERE SecCode = 6797364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806409092, ExchCode = 'MUN' WHERE SecCode = 6797368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101944, ExchCode = 'FRA' WHERE SecCode = 6802839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101943, ExchCode = 'FRA' WHERE SecCode = 6802840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806102102, ExchCode = 'MEX' WHERE SecCode = 6802842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806102142, ExchCode = 'FRA' WHERE SecCode = 6802844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806102138, ExchCode = 'FRA' WHERE SecCode = 6802846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168121, ExchCode = 'FRA' WHERE SecCode = 6802856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806168117, ExchCode = 'FRA' WHERE SecCode = 6802861 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 6806177 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 6806178 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 6806179 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 6806183 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-01' WHERE SecCode = 6813230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806332266, IsPrimaryQuote = 1, Ticker = 'CITIUSINVT', ExchCode = 'NSI', PriTRBCIndPermID = 4294951722.0 WHERE SecCode = 6813829 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 10783567 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 10812480 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'ARE' WHERE SecCode = 10891426 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 10897586 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 10924424 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10932619 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10970843 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 10973532 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11001026 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11022042 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 11044365 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 11052036 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11078425 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-01' WHERE SecCode = 11079898 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11111000 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'ARE' WHERE SecCode = 11131657 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11142929 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 11153630 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11158630 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR', PriTRBCIndPermID = 4294951400.0 WHERE SecCode = 11172672 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11178969 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11180183 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11182728 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11183460 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11185279 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11185444 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11189994 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11192687 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-01' WHERE SecCode = 11196578 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 11197962 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951449.0 WHERE SecCode = 11199544 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11202028 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA', PriTRBCIndPermID = 4294951260.0 WHERE SecCode = 11209363 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-01' WHERE SecCode = 11209450 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951716.0 WHERE SecCode = 11210922 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-01' WHERE SecCode = 11211046 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11212375 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11215761 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11221982 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11226889 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 11227993 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11229567 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11233717 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11238911 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 11241003 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11243147 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11244158 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951973.0 WHERE SecCode = 11249865 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11251373 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 11256232 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermOrgIPODate = NULL WHERE SecCode = 11256988 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951194.0 WHERE SecCode = 11258994 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'PAK' WHERE SecCode = 11261394 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 11261930 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ZUUZD' WHERE SecCode = 11262773 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11269908 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11271077 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951973.0 WHERE SecCode = 11277133 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951977.0 WHERE SecCode = 11277553 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11287500 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11287501 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11287504 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11290009 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11291316 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11291318 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11291320 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11291323 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11291327 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11291328 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11291331 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11291338 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11291339 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-30' WHERE SecCode = 11294022 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 11294421 AND Type_ = 1;
