UPDATE data_universe_permid SET QuotePermID = 21531128468, Ticker = 'HONl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-16' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838299316, PermQuoteStatus = 'DC', Ticker = 'GL9.IE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 2991 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 4568 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'JAM' WHERE SecCode = 28135 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'JAM' WHERE SecCode = 28136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475562064, PermQuoteStatus = 'DC', Ticker = 'AEC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-11', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 35843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624203, Ticker = 'SCXG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475289897, ExchCode = 'GER' WHERE SecCode = 46302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531592, ExchCode = 'FRA' WHERE SecCode = 46521 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 49683 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475033691, ExchCode = 'TDG' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838414562, ExchCode = 'STU', PermQuoteRetireDate = '2016-03-01' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474903504, ExchCode = 'DEU' WHERE SecCode = 60025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363120, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363654, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368040, ExchCode = 'STU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018990, ExchCode = 'STU', PermQuoteRetireDate = '2023-08-16', PermSecMapEndDate = '2023-08-16' WHERE SecCode = 62512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 65089 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 77382 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 77383 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'TBSP-R' WHERE SecCode = 80720 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-10' WHERE SecCode = 83170 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 83949 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-12', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 83994 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 85593 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-04' WHERE SecCode = 88511 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-29' WHERE SecCode = 89348 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 90764 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 91007 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL WHERE SecCode = 91604 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'TBSP' WHERE SecCode = 97054 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 102878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609211565, ExchCode = 'TDG' WHERE SecCode = 103792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341666, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 103840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836418073, ExchCode = 'FRA' WHERE SecCode = 103841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335490, ExchCode = 'BER' WHERE SecCode = 103863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475499889, ExchCode = 'STU' WHERE SecCode = 103891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474923635, ExchCode = 'DEU' WHERE SecCode = 103894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298416, ExchCode = 'DEU' 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 OrgTypeCode = 'COM', IncCntry = 'FRA' WHERE SecCode = 125208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957798876, ExchCode = 'DEU' WHERE SecCode = 131976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-05-12' WHERE SecCode = 147178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625070426, ExchCode = 'STU' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'EIY' WHERE SecCode = 168616 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 178085 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 214185 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 249276 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 286262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325722, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-11', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 287574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327296, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475010144, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 300181 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 309340 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 324940 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21593419443, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2017-10-16' WHERE SecCode = 348130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927540, Ticker = '2RNO' WHERE SecCode = 348455 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 353989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321591, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 362355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321584, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 362789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723938606, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-05' WHERE SecCode = 362801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836363189, ExchCode = 'FRA', PermQuoteRetireDate = '2015-02-27' WHERE SecCode = 369463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836488578, ExchCode = 'FRA', PermQuoteRetireDate = '2015-03-20' WHERE SecCode = 370287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704899, Ticker = 'GFAN', ExchCode = 'MXQ' WHERE SecCode = 371435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585027764, ExchCode = 'CHI' WHERE SecCode = 372403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836361589, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 372834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036104, PermQuoteStatus = 'AC', Ticker = '3V64', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 373242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296613, Ticker = 'CAIR.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 374927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475432906, Ticker = '0FCC', ExchCode = 'LSE', PermQuoteRetireDate = '2009-12-10' WHERE SecCode = 374930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21499306527, ExchCode = 'TDG' WHERE SecCode = 375279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620916416, ExchCode = 'TDG' WHERE SecCode = 375326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474948783, ExchCode = 'DEU', PermQuoteRetireDate = '2021-02-11' WHERE SecCode = 375327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836362930, ExchCode = 'FRA', PermQuoteRetireDate = '2011-10-21' WHERE SecCode = 381809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535566294, ExchCode = 'GER', PermQuoteRetireDate = '2015-02-10', PermSecMapEndDate = '2022-08-03' WHERE SecCode = 381896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840699482, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 384210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631772204, ExchCode = 'TDG', PermQuoteRetireDate = '2022-11-02', PermSecMapEndDate = '2023-09-12' WHERE SecCode = 384412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035068, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-14' WHERE SecCode = 385283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678434, ExchCode = 'BIV' WHERE SecCode = 385655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475890001, ExchCode = 'TDG' WHERE SecCode = 387326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475119907, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-12-30', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 387856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840949580, ExchCode = 'FRA' WHERE SecCode = 389023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296792, PermQuoteStatus = 'DC', Ticker = 'BVD.FR', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 389366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840913920, ExchCode = 'BER', PermQuoteRetireDate = '2023-12-19' WHERE SecCode = 389476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295315, ExchCode = 'GTX' WHERE SecCode = 390369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841055107, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 391527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850903229, Ticker = '0MM5', ExchCode = 'LSE', PermQuoteRetireDate = '2013-07-18' WHERE SecCode = 391965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051026, ExchCode = 'TDG', PermQuoteRetireDate = '2015-06-12' WHERE SecCode = 392196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475760801, ExchCode = 'STU' WHERE SecCode = 392214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451829, Ticker = 'NEM', ExchCode = 'SWX' WHERE SecCode = 392615 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'EMOBILITY' WHERE SecCode = 395052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664443549, ExchCode = 'DEU', PermQuoteRetireDate = '2019-01-24' WHERE SecCode = 395621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673056, Ticker = '0FFE', ExchCode = 'LSE', PermQuoteRetireDate = '2013-09-02' WHERE SecCode = 396143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21918242411, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 396297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907732, ExchCode = 'GER' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834675162, Ticker = '0EBO', ExchCode = 'LSE', PermQuoteRetireDate = '2015-04-30' WHERE SecCode = 401544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841643563, ExchCode = 'BER' WHERE SecCode = 401624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548012938, ExchCode = 'FRA' WHERE SecCode = 403552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838303043, Ticker = 'EMP.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 404675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505934502, ExchCode = 'DEU', PermQuoteRetireDate = '2018-04-04' WHERE SecCode = 404717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539533292, ExchCode = 'MUN', PermQuoteRetireDate = '2019-11-07' WHERE SecCode = 404833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388965, Ticker = 'ZIM.RO', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 408476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475472362, ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 408478 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 QuotePermID = 21667704244, ExchCode = 'MXQ' WHERE SecCode = 409684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704362, ExchCode = 'MXQ' WHERE SecCode = 411789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521101375, PermQuoteStatus = 'AC', Ticker = 'TRC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 415856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036216, PermQuoteStatus = 'DC', Ticker = 'ZCT1', ExchCode = 'TDG', PermQuoteRetireDate = '2025-05-12' WHERE SecCode = 416445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843102675, ExchCode = 'BER' WHERE SecCode = 424779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843288026, ExchCode = 'BER' WHERE SecCode = 424919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396351, ExchCode = 'FRA' WHERE SecCode = 425691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878344107, ExchCode = 'MUN' WHERE SecCode = 429168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55839878219 WHERE SecCode = 433675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845312523, ExchCode = 'FRA' WHERE SecCode = 436499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530871393, ExchCode = 'CHI' WHERE SecCode = 437391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55844955333 WHERE SecCode = 437916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545451828, ExchCode = 'FRA' WHERE SecCode = 440283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845037622, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 440782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853026615, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 442574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612598640, ExchCode = 'STU' WHERE SecCode = 443141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475387511, Ticker = '5IC.BG', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 450252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914266, ExchCode = 'MUN' WHERE SecCode = 454940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487014, ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852879056, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-12' WHERE SecCode = 462475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22118826258, ExchCode = 'SIG' WHERE SecCode = 464174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858584221, Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847269040, ExchCode = 'BER', PermQuoteRetireDate = '2013-07-23' WHERE SecCode = 479915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010413709, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22150825819, ExchCode = 'SWX' WHERE SecCode = 481044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21925268568, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 484491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690985826, Ticker = '0MO8l', ExchCode = 'BCO' WHERE SecCode = 485330 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 = 21475388774, Ticker = 'SWZ.PL', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 501839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848865464, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 503830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725613667, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 503842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388355, Ticker = 'HEMX.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 505602 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 = 55849902699, ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-10' WHERE SecCode = 513850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492958, ExchCode = 'QTX' WHERE SecCode = 515043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035835, ExchCode = 'TDG', PermQuoteRetireDate = '2016-02-09' WHERE SecCode = 515819 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 = 21569267651, ExchCode = 'BTE' WHERE SecCode = 521436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835441545, Ticker = 'COFFP', ExchCode = 'PAR', PermQuoteRetireDate = '2013-05-08' WHERE SecCode = 521460 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 = 21666607680, PermQuoteStatus = 'DC', Ticker = 'PHPTa', ExchCode = 'EQD', PermQuoteRetireDate = '2018-12-03' WHERE SecCode = 521843 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 = 55843605384, Ticker = 'SJK.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 526379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850150953, PermQuoteStatus = 'AC', Ticker = 'GOKA', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 527096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679368, ExchCode = 'BIV' WHERE SecCode = 528977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528628493, ExchCode = 'TDG', PermQuoteRetireDate = '2019-10-01' WHERE SecCode = 529878 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 = 21474893887, ExchCode = 'DEU' WHERE SecCode = 533384 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 = 21852735887, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 534433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851190611, ExchCode = 'BER' WHERE SecCode = 534603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851202994, Ticker = 'USEB', ExchCode = 'LSE', PermQuoteRetireDate = '2014-09-16' WHERE SecCode = 535214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532071651, ExchCode = 'MUN' WHERE SecCode = 535313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532071708, ExchCode = 'MUN' WHERE SecCode = 535314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851203489, ExchCode = 'FRA', PermQuoteRetireDate = '2014-04-01' WHERE SecCode = 535316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851360620, ExchCode = 'FRA', PermQuoteRetireDate = '2019-02-21' WHERE SecCode = 535417 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 PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 535611 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 535612 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476991388, ExchCode = 'TDG' WHERE SecCode = 538783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22013678020, PermQuoteStatus = 'AC', Ticker = 'XGLEl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 539253 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475024144, ExchCode = 'TDG' WHERE SecCode = 540531 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 = 55852219705, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 541456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726971, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 543609 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 QuotePermID = 21565173129, ExchCode = 'STU', PermQuoteRetireDate = '2019-04-18' WHERE SecCode = 548655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483965, ExchCode = 'QTX' 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 = 21944002637, ExchCode = 'TDG' WHERE SecCode = 552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531115944, Ticker = '6CMBd', ExchCode = 'BCO' WHERE SecCode = 552948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640344088, ExchCode = 'CHI' WHERE SecCode = 553351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769222039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 553799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850857947, ExchCode = 'DUS' WHERE SecCode = 553921 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 = 55834673084, PermQuoteStatus = 'AC', Ticker = '0R6Z', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 554925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510721868, ExchCode = 'DEU' WHERE SecCode = 556234 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 = 55857028867, ExchCode = 'BER' WHERE SecCode = 558044 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 = 21667485192, ExchCode = 'QTX' WHERE SecCode = 558811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833319, ExchCode = 'LAS' WHERE SecCode = 559903 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 = 21580382275, PermQuoteStatus = 'AC', ExchCode = 'BTE', PermQuoteRetireDate = NULL WHERE SecCode = 564862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034998, ExchCode = 'TDG', PermQuoteRetireDate = '2014-10-16' WHERE SecCode = 565706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475805335, PermQuoteStatus = 'DC', Ticker = 'OAA', ExchCode = 'TDG', PermQuoteRetireDate = '2013-04-19' WHERE SecCode = 565752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834672477, Ticker = '0ESW', ExchCode = 'LSE', PermQuoteRetireDate = '2011-07-12' WHERE SecCode = 568280 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 = 55851903472, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 572386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566935915, ExchCode = 'STU' WHERE SecCode = 575072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858525918, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 577333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853019549, ExchCode = 'MEX' WHERE SecCode = 580373 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 = 21589742988, ExchCode = 'STU' WHERE SecCode = 593055 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 QuotePermID = 55859005911, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 593132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503500605, ExchCode = 'TDG', PermQuoteRetireDate = '2014-04-24' WHERE SecCode = 594093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474990640, ExchCode = 'BER', PermQuoteRetireDate = '2017-01-19' WHERE SecCode = 594099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859132029, ExchCode = 'FRA' WHERE SecCode = 594191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068246, ExchCode = 'FRA' WHERE SecCode = 596843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859254286, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 599978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255889, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 600391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145756635, ExchCode = 'SWX' WHERE SecCode = 602882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647852573, ExchCode = 'STU' WHERE SecCode = 607486 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 = 21475745081, Ticker = '0NP6', ExchCode = 'LSE', PermQuoteRetireDate = '2015-09-09' WHERE SecCode = 693688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540229905, ExchCode = 'STU' WHERE SecCode = 701753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287357, ExchCode = 'MEX' WHERE SecCode = 780513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475105966, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 826159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379950, ExchCode = 'FRA' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528542094, ExchCode = 'TDG' WHERE SecCode = 881802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660807802, ExchCode = 'MUN' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223887, ExchCode = 'QTX' WHERE SecCode = 909718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801717079, Ticker = 'CBBFFz', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 933460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527398158, ExchCode = 'FRA' WHERE SecCode = 1062623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22177710975, ExchCode = 'DEU' WHERE SecCode = 1111460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55876477262, Ticker = 'XGLI', ExchCode = 'LSE', PermQuoteRetireDate = '2013-09-20' WHERE SecCode = 1192765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747333681, ExchCode = 'DEU' WHERE SecCode = 1447581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482228292, Ticker = 'BLIT', ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1459284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530720649, ExchCode = 'STU' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481705363, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490145914, Ticker = NULL, ExchCode = 'DEU', PermQuoteRetireDate = '2014-03-07' WHERE SecCode = 1489390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512147101, Ticker = 'BRDG', ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488289996, ExchCode = 'FRA' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488289855, ExchCode = 'FRA', PermQuoteRetireDate = '2022-05-31', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676639, ExchCode = 'BIV' WHERE SecCode = 1524554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488652814, ExchCode = 'FRA' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536289548, ExchCode = 'DEU' WHERE SecCode = 1524628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497767, ExchCode = 'DEU' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491111760, ExchCode = 'FRA' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270027, ExchCode = 'DEU' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800721447, ExchCode = 'FRA' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679444, ExchCode = 'BIV' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156877250, ExchCode = 'DEU' WHERE SecCode = 1553832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501626987, ExchCode = 'STU' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502150126, ExchCode = 'STU' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461757, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-04' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234899, ExchCode = 'QTX' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678108, ExchCode = 'BIV' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505421178, ExchCode = 'STU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679673, ExchCode = 'BIV' WHERE SecCode = 1621273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802789, Ticker = 'PV0D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510008303, ExchCode = 'DEU' WHERE SecCode = 1653506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512104207, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-09' WHERE SecCode = 1655572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835904, Ticker = '7O2d', ExchCode = 'BCO' WHERE SecCode = 1656414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531120618, Ticker = 'CHMTp', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-08' WHERE SecCode = 1677246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613032675, ExchCode = 'STU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520427, ExchCode = 'DEU' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679815, ExchCode = 'BIV' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828343336, ExchCode = 'QTX' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320776, ExchCode = 'BER' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285770, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-11', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 2065783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521327105, ExchCode = 'FRA' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143697, Ticker = '2KPN', ExchCode = 'MIL' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569830, ExchCode = 'QTX' WHERE SecCode = 2239280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524063116, ExchCode = 'DEU' WHERE SecCode = 2240608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784838122, ExchCode = 'QTX' WHERE SecCode = 2246863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950995, ExchCode = 'STU' WHERE SecCode = 2255684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615737, ExchCode = 'MUN' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255542, ExchCode = 'DEU' WHERE SecCode = 2357967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529795323, ExchCode = 'STU' WHERE SecCode = 2357969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530042418, ExchCode = 'DEU' WHERE SecCode = 2357974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676252, ExchCode = 'BIV' WHERE SecCode = 2359427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675065, ExchCode = 'BIV' WHERE SecCode = 2362819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530493513, ExchCode = 'FRA' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531130867, InstrPermID = 8590926370, OrgPermID = 4295858498, ValQuotePermID = 55835583224.0, PriInstrPermID = 8590926370.0, PermInstrStatus = 'AC', Ticker = 'MQG0d', ExchCode = 'BCO', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = 4294951922.0, PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2013-10-29' WHERE SecCode = 2387360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834662, PermQuoteStatus = 'AC', Ticker = 'C68', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2397376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532336720, ExchCode = 'FRA' WHERE SecCode = 2397377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786676622, ExchCode = 'MEX' WHERE SecCode = 2414027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842517697, ExchCode = 'SGO' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530710111, ExchCode = 'RTS', PermQuoteRetireDate = '2021-02-13' WHERE SecCode = 2498012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555632, ExchCode = 'DEU' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999786388, ExchCode = 'DXE' WHERE SecCode = 2510129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696140082, ExchCode = 'QTX' WHERE SecCode = 2522906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869002235, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619324261, ExchCode = 'FRA', PermQuoteRetireDate = '2021-03-12' WHERE SecCode = 2539010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430828, ExchCode = 'DEU' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673930, ExchCode = 'BIV' 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 = 21562942131, ExchCode = 'TDG' WHERE SecCode = 2556599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544783558, Ticker = '2T41', ExchCode = 'BER', PermQuoteRetireDate = '2020-08-03' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670873, ExchCode = 'ASX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544371203, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-28' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586820372, PermQuoteStatus = 'AC', Ticker = '14S0', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2625801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312212, ExchCode = 'GTX' WHERE SecCode = 2630989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MYS' WHERE SecCode = 2655938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714636898, ExchCode = 'STU' WHERE SecCode = 2659980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 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 QuotePermID = 21551225720, ExchCode = 'STU' WHERE SecCode = 2700370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540948191, Ticker = '0QTP', ExchCode = 'LSE', PermQuoteRetireDate = '2020-03-10' WHERE SecCode = 2710438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629355954, ExchCode = 'TDG' WHERE SecCode = 2711152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552463360, ExchCode = 'FRA' WHERE SecCode = 2711203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419033, ExchCode = 'LAS' WHERE SecCode = 2715189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553011784, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-29' WHERE SecCode = 2718428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264997, ExchCode = 'DEU' WHERE SecCode = 2732754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198687, ExchCode = 'BIV' WHERE SecCode = 2750976 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 = 21754377738, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2774739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843924761, ExchCode = 'DEU' WHERE SecCode = 2809752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558155460, ExchCode = 'DEU' WHERE SecCode = 2823565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21635527168, Ticker = 'PJS1z', ExchCode = 'BTE', PermSecMapEndDate = NULL WHERE SecCode = 2835312 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951470.0 WHERE SecCode = 2845467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915623088, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560671527, ExchCode = 'DEU' WHERE SecCode = 2855770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684294108, ExchCode = 'TDG', PermQuoteRetireDate = '2019-04-03' WHERE SecCode = 2855771 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951470.0 WHERE SecCode = 2855772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560761414, ExchCode = 'DEU' WHERE SecCode = 2855773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563864602, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2024-03-15' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561687595, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19', PermSecMapEndDate = '2021-08-19' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562290608, ExchCode = 'FRA' WHERE SecCode = 2870150 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 = 21644687444, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654537658, ExchCode = 'MUN', PermQuoteRetireDate = '2025-11-21' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21564888886, Ticker = 'H3D', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 2909900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564888736, ExchCode = 'DEU' WHERE SecCode = 2909901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564939130, ExchCode = 'FRA' 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 = 21565820495, ExchCode = 'MUN' WHERE SecCode = 2919727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566883039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2930544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589809334, ExchCode = 'TDG', PermQuoteRetireDate = '2019-11-20' WHERE SecCode = 2930555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540992047, ExchCode = 'TDG', PermQuoteRetireDate = '2019-05-24', PermSecMapEndDate = '2019-05-24' WHERE SecCode = 2932394 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 = 236783066619, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2947926 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 QuotePermID = 21722919701, ExchCode = 'BER', PermQuoteRetireDate = '2023-11-13' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704396, ExchCode = 'MXQ' WHERE SecCode = 2963604 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 2992081 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 = 21792943751, ExchCode = 'GER', PermQuoteRetireDate = '2022-08-11' WHERE SecCode = 3010358 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951470.0 WHERE SecCode = 3012304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285644, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285720, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608475923, ExchCode = 'STU' WHERE SecCode = 3085564 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 = 21830275202, ExchCode = 'GTX' WHERE SecCode = 3098021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584213518, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-21', PermSecMapEndDate = '2022-10-21' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584924434, ExchCode = 'MUN' WHERE SecCode = 3121331 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 3125027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536846008, ExchCode = 'FRA', PermQuoteRetireDate = '2018-07-11' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587931857, ExchCode = 'BTE' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588032923, ExchCode = 'FRA' WHERE SecCode = 3165880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865085103, ExchCode = 'GTX' WHERE SecCode = 3172340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679777, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3177778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22137202074, ExchCode = 'DEU' WHERE SecCode = 3186751 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 = 21590371242, ExchCode = 'FRA' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655814, Ticker = '4VOW3', ExchCode = 'ETX' WHERE SecCode = 3212165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591798940, ExchCode = 'TDG' WHERE SecCode = 3212190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448726, ExchCode = 'FRA' WHERE SecCode = 3213266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783209095, ExchCode = 'FRA' WHERE SecCode = 3213268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592182710, ExchCode = 'FRA', PermQuoteRetireDate = '2023-09-29', PermSecMapEndDate = '2023-09-29' WHERE SecCode = 3215568 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 PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 3223413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496462, ExchCode = 'DUS' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595110980, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3229527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614079174, ExchCode = 'TDG', PermQuoteRetireDate = '2017-05-25' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026729, Ticker = '1UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718045329, ExchCode = 'MUN' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613476472, ExchCode = 'STU' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150562, ExchCode = 'AUX' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597802970, ExchCode = 'STU' WHERE SecCode = 3257180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684609, ExchCode = 'DUS' WHERE SecCode = 3259344 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760588308, ExchCode = 'STU' WHERE SecCode = 3281992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517543534, ExchCode = 'FRA' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007430, ExchCode = 'DEU' WHERE SecCode = 3282311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760582105, ExchCode = 'TDG' WHERE SecCode = 3282881 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 = 21602047603, ExchCode = 'MUN' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857633427, ExchCode = 'QTX' 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 = 21858705487, ExchCode = 'STU' 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 = 21658947516, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815325346, ExchCode = 'MUN', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551901, ExchCode = 'TDG' 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 PriTRBCIndPermID = 4294951675.0 WHERE SecCode = 3318059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753722337, ExchCode = 'DEU' WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443153, ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-06', PermSecMapEndDate = NULL WHERE SecCode = 3320334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610776896, ExchCode = 'STU' WHERE SecCode = 3320375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448965, ExchCode = 'DEU' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482861, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679671, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3327117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611321674, ExchCode = 'FRA' 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 Ticker = 'TBSP-F' WHERE SecCode = 3338456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380129, ExchCode = 'LAS' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673494, ExchCode = 'BIV' WHERE SecCode = 3338588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613684839, ExchCode = 'BER' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887550956, ExchCode = 'MUN' WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367733, ExchCode = 'CHA' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773003108, ExchCode = 'DEU' WHERE SecCode = 3356351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614679451, ExchCode = 'STU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'J5B0' WHERE SecCode = 3359146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627708, ExchCode = 'QTX' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805023784, ExchCode = 'DEU' WHERE SecCode = 3368562 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 PermSecMapEndDate = NULL WHERE SecCode = 3379024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658642103, ExchCode = 'MUN' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920549797, ExchCode = 'DEU' WHERE SecCode = 3392279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777289554, ExchCode = 'STU' WHERE SecCode = 3394497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810204931, ExchCode = 'DEU' WHERE SecCode = 3401365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704915, ExchCode = 'MXQ' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469772, ExchCode = 'DEU' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800228480, ExchCode = 'FRA' WHERE SecCode = 3401911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380142, PermQuoteStatus = 'AC', Ticker = 'DV4', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3401914 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 3403370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779748, ExchCode = 'MUN' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 3404649 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2017-11-24' WHERE SecCode = 3407480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784205314, ExchCode = 'FRA' WHERE SecCode = 3407871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679932, ExchCode = 'BIV' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630022342, ExchCode = 'STU' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175400111, ExchCode = 'DEU' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396615, ExchCode = 'DEU' WHERE SecCode = 3409090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801066696, Ticker = 'C0B1', ExchCode = 'DEU' WHERE SecCode = 3410283 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 3410320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781060476, ExchCode = 'FRA', PermQuoteRetireDate = '2024-03-25' WHERE SecCode = 3429810 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 3431765 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 3433376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636066861, ExchCode = 'DEU' WHERE SecCode = 3435060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727356606, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2020-04-21' WHERE SecCode = 3435592 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 3436906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997875, ExchCode = 'FRA' WHERE SecCode = 3439465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643223564, ExchCode = 'DEU' WHERE SecCode = 3444252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688591124, ExchCode = 'STU' WHERE SecCode = 3445093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796141667, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3445201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388252, ExchCode = 'LAS' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644782384, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3446081 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 = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794206137, ExchCode = 'TDG' WHERE SecCode = 3495930 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 = 21656679543, ExchCode = 'BIV' WHERE SecCode = 3501496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881520736, ExchCode = 'GTX' WHERE SecCode = 3501595 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 = 25727169919, Ticker = 'NGIL', ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679290, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3518311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652137392, ExchCode = 'STU' WHERE SecCode = 3526149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811976566, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-04-23' WHERE SecCode = 3526200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736203569, ExchCode = 'TDG' WHERE SecCode = 3532733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653848411, Ticker = 'TGL', ExchCode = 'LSE', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3536053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664223, ExchCode = 'MUN' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296299, ExchCode = 'GTX' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452801, ExchCode = 'DEU' WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797237688, ExchCode = 'STU' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656057042, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3555045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656740299, Ticker = 'DNKl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-01-20' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656850928, ExchCode = 'FRA' WHERE SecCode = 3558191 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 QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731163509, ExchCode = 'FRA' WHERE SecCode = 3584663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879562247, ExchCode = 'GTX' WHERE SecCode = 3587019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572528792, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474893887, Ticker = '8EC0', ExchCode = 'DEU', PermQuoteRetireDate = '2024-07-31' WHERE SecCode = 3587066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328076, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 3588045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527215, ExchCode = 'FRA' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663316444, ExchCode = 'FRA', PermQuoteRetireDate = '2020-04-16' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952421, ExchCode = 'DEU' WHERE SecCode = 3591601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893299383, ExchCode = 'GTX' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308437, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668783311, ExchCode = 'HAM' WHERE SecCode = 3642406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505131, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3658775 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 = 21794979494, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3719703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679876423, ExchCode = 'DEU' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860843948, ExchCode = 'MUN', PermQuoteRetireDate = '2023-12-21', PermSecMapEndDate = NULL WHERE SecCode = 3731132 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-11', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 3736002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947053161, ExchCode = 'DEU' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803135585, ExchCode = 'FRA' WHERE SecCode = 3756337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685505912, ExchCode = 'MXQ' WHERE SecCode = 3783012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687995487, ExchCode = 'TDG' WHERE SecCode = 3793374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785774556, ExchCode = 'DEU' WHERE SecCode = 3793376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21691003477, ExchCode = 'FRA' WHERE SecCode = 3799544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727376095, ExchCode = 'BIV' WHERE SecCode = 3799556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719386690, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-28', PermSecMapEndDate = '2023-03-30' WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707022417, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387076, ExchCode = 'LAS', PermQuoteRetireDate = '2025-10-03' WHERE SecCode = 3809957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690196142, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3809958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780314322, ExchCode = 'GTX' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782197171, ExchCode = 'QTX' WHERE SecCode = 3818674 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 3820524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21697686068, ExchCode = 'BER' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918923, ExchCode = 'FRA' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371516, ExchCode = 'MEX' WHERE SecCode = 3849233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888021879, ExchCode = 'GTX' WHERE SecCode = 3852867 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 = 21703075521, ExchCode = 'MUN' 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 = 236778220719, ExchCode = 'TDG' WHERE SecCode = 3906532 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 QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 3961772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363517, ExchCode = 'MEX' WHERE SecCode = 3980893 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 3987648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22150825814, ExchCode = 'SWX' WHERE SecCode = 3991555 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 3993764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718474201, ExchCode = 'FRA' WHERE SecCode = 3998157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011005, Ticker = '2DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655813, Ticker = '4HEIA', ExchCode = 'ETX' WHERE SecCode = 4031893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026796, Ticker = '1IAG' WHERE SecCode = 4032120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143990, Ticker = '2DSY', ExchCode = 'MIL' WHERE SecCode = 4032132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723633853, ExchCode = 'MUN' WHERE SecCode = 4032148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195044, ExchCode = 'STU' WHERE SecCode = 4032154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184449, ExchCode = 'SIG' WHERE SecCode = 4033113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725971281, ExchCode = 'TDG' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997868, ExchCode = 'DEU' WHERE SecCode = 4046659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796059848, ExchCode = 'FRA' WHERE SecCode = 4046669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369676, Ticker = 'NEWR*', ExchCode = 'BIV' WHERE SecCode = 4054118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026731, Ticker = '1NDA' WHERE SecCode = 4054275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690044337, Ticker = '4LI', ExchCode = 'ETX' WHERE SecCode = 4054280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026882, Ticker = '1VOLVB' WHERE SecCode = 4054287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21728977320, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4056300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858578, ExchCode = 'QTX' WHERE SecCode = 4068293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727322400, ExchCode = 'MEX' WHERE SecCode = 4087443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733147228, ExchCode = 'FRA' WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727356453, ExchCode = 'BIV' WHERE SecCode = 4090018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738253265, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 4090028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720099009, ExchCode = 'QTX', PermQuoteRetireDate = '2026-03-05' WHERE SecCode = 4095965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354554, ExchCode = 'MEX' WHERE SecCode = 4095969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587301011, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908303, ExchCode = 'DUS' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738226623, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4119578 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 = 21823963671, ExchCode = 'STU' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768111793, ExchCode = 'DUS' WHERE SecCode = 4134386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744012999, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767422123, ExchCode = 'FRA' WHERE SecCode = 4210918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727350455, ExchCode = 'MEX' WHERE SecCode = 4212368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910492, ExchCode = 'STU' WHERE SecCode = 4212561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026889, Ticker = '1HCA' WHERE SecCode = 4214370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026841, Ticker = '1NOW' WHERE SecCode = 4214371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026766, Ticker = '1AMT' WHERE SecCode = 4214372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026951, Ticker = '1AWK' WHERE SecCode = 4214377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026829, Ticker = '1GD' WHERE SecCode = 4214384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026900, Ticker = '1HLT' WHERE SecCode = 4214387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026939, Ticker = '1SPG' WHERE SecCode = 4214395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026966, Ticker = '1SYK' WHERE SecCode = 4214397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026844, Ticker = '1TROW' WHERE SecCode = 4214399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026809, Ticker = '1WEC' WHERE SecCode = 4214401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787665340, Ticker = '4APH', ExchCode = 'ETX' WHERE SecCode = 4214403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699193157, Ticker = 'BYND', ExchCode = 'SWX' WHERE SecCode = 4214409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600490, Ticker = '1PLUGm', ExchCode = 'BCO' WHERE SecCode = 4214415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749838963, ExchCode = 'FRA' WHERE SecCode = 4225217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754377772, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4243768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755406183, ExchCode = 'DEU' WHERE SecCode = 4267228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056950, ExchCode = 'DUS' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757456175, ExchCode = 'FRA' WHERE SecCode = 4277594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487599, ExchCode = 'QTX' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757260444, ExchCode = 'FRA' WHERE SecCode = 4278855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628095, ExchCode = 'DUS' WHERE SecCode = 4278857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780843378, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4282400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758727587, ExchCode = 'DUS' WHERE SecCode = 4288863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011157, Ticker = '2SPOT' WHERE SecCode = 4309035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010963, Ticker = '2AMS' WHERE SecCode = 4309037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026860, Ticker = '18TRA' WHERE SecCode = 4309041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012280, Ticker = '2FSLR' WHERE SecCode = 4309045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027111, Ticker = '1OXY' WHERE SecCode = 4309046 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026929, Ticker = '1DOW' WHERE SecCode = 4309048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381904, ExchCode = 'LAS' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763596291, ExchCode = 'DUS' WHERE SecCode = 4321393 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'AGNT*' WHERE SecCode = 4345474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298369, ExchCode = 'DEU' WHERE SecCode = 4365804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910570378, PermQuoteStatus = 'DC', ExchCode = 'CHJ', PermQuoteRetireDate = '2025-09-04' WHERE SecCode = 4365821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799675, ExchCode = 'HAM' WHERE SecCode = 4365921 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 4368576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650250, ExchCode = 'DUS' WHERE SecCode = 4379790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991660, ExchCode = 'FRA' WHERE SecCode = 4381892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909432, ExchCode = 'FRA' WHERE SecCode = 4383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773600935, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 4385232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307749, ExchCode = 'MEX' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783161157, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312696, ExchCode = 'MEX' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803077161, ExchCode = 'FRA' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727304579, ExchCode = 'BIV' WHERE SecCode = 4421213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999132, ExchCode = 'FRA' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370420, ExchCode = 'AQE' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312259, ExchCode = 'MEX' WHERE SecCode = 4424570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026948, Ticker = '1VTRS' WHERE SecCode = 4427826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394138, ExchCode = 'STU' WHERE SecCode = 4429683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785087297, ExchCode = 'FRA' WHERE SecCode = 4434390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785453356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4436991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879562192, ExchCode = 'GTX' WHERE SecCode = 4449679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790713764, ExchCode = 'STU' WHERE SecCode = 4458936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789562275, ExchCode = 'FRA' WHERE SecCode = 4458938 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 PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 4466448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792098251, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793533769, PermQuoteStatus = 'DC', ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-24' WHERE SecCode = 4470175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798225679, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-12', PermSecMapEndDate = '2025-02-12' 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 = 21793396931, ExchCode = 'FRA' WHERE SecCode = 4472910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396957, ExchCode = 'DEU' WHERE SecCode = 4472926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789408355, ExchCode = 'DEU' WHERE SecCode = 4474245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817527, ExchCode = 'DEU' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367200, ExchCode = 'DEU' WHERE SecCode = 4482720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555797, ExchCode = 'DEU' WHERE SecCode = 4496736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805179555, ExchCode = 'STU' WHERE SecCode = 4505789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800727363, ExchCode = 'DEU' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800727419, ExchCode = 'DEU' WHERE SecCode = 4513650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780960627, ExchCode = 'STU' WHERE SecCode = 4517645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802440518, ExchCode = 'QTX' WHERE SecCode = 4524458 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 4527824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808935929, Ticker = '0RW0', ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806748726, ExchCode = 'FRA' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807265022, PermQuoteStatus = 'AC', Ticker = '3K7A', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4557860 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 4558211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811980857, ExchCode = 'MUN' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286428, ExchCode = 'GTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380574, ExchCode = 'LAS' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 4594358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881522351, ExchCode = 'MUN' WHERE SecCode = 4601728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026913, Ticker = '1INVEB' WHERE SecCode = 4601877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549166, ExchCode = 'GTX' WHERE SecCode = 4603534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144470, ExchCode = 'FRA' WHERE SecCode = 4607717 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 4608546 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 4608547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816887015, PermQuoteStatus = 'AC', Ticker = 'ABTC', ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 4611064 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '91E1', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 4613736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818254739, ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-13' WHERE SecCode = 4617741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SONALILIFE' WHERE SecCode = 4632973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438919, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4637752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312167, ExchCode = 'GTX' WHERE SecCode = 4637756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822879298, IsPrimaryQuote = 0, Ticker = 'WISEl', ExchCode = 'AQX', PermSecMapEndDate = NULL WHERE SecCode = 4638781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381815, ExchCode = 'LAS' WHERE SecCode = 4658662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952621466, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4658881 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 4676234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244578, ExchCode = 'BIV' WHERE SecCode = 4684128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837528978, ExchCode = 'DEU' WHERE SecCode = 4693647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727244579, ExchCode = 'MEX' WHERE SecCode = 4695806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011348, Ticker = '2STX' WHERE SecCode = 4699232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773003141, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-23' WHERE SecCode = 4707187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033920, Ticker = '3JO', ExchCode = 'TDG', PermQuoteRetireDate = '2024-04-10' WHERE SecCode = 4717099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843915272, ExchCode = 'STU' WHERE SecCode = 4718902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853430101, ExchCode = 'GTX' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851127841, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4742663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852758887, ExchCode = 'STU' WHERE SecCode = 4752188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853262569, ExchCode = 'FRA' WHERE SecCode = 4754869 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 = 21855838898, ExchCode = 'QTX' WHERE SecCode = 4773770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439467, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-18' WHERE SecCode = 4774934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380489, ExchCode = 'LAS' 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 = 21863192589, ExchCode = 'FRA' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879552085, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4827911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867521056, Ticker = 'BTIC', ExchCode = 'SWX' WHERE SecCode = 4842798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885446303, ExchCode = 'GTX' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874656954, ExchCode = 'FRA' 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 = 21830259871, ExchCode = 'MUN' WHERE SecCode = 4890295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388746, ExchCode = 'LAS' WHERE SecCode = 4927268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795183109, ExchCode = 'LAS' WHERE SecCode = 4940670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434498, ExchCode = 'QTX' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884189014, ExchCode = 'QTX', PermQuoteRetireDate = '2024-08-15' WHERE SecCode = 4943410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689480, ExchCode = 'FRA' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 4965050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 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 = 21906823905, ExchCode = 'AQX' WHERE SecCode = 5038689 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 = 21902954507, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5041763 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 = 21907031273, ExchCode = 'STU' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727217398, ExchCode = 'BIV' WHERE SecCode = 5083954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910179774, ExchCode = 'QTX' WHERE SecCode = 5094355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718186332, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5099028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913514545, ExchCode = 'DEU' WHERE SecCode = 5130678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642004, ExchCode = 'QTX' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790867, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529719645, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 5161223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273208, ExchCode = 'GTX' WHERE SecCode = 5161225 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'TBSP-F' WHERE SecCode = 5161260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508526620, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589470, Ticker = 'RPGG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 5161292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348309, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727344850, ExchCode = 'MEX' WHERE SecCode = 5161363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367923, ExchCode = 'BEC' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381527, ExchCode = 'LAS' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893559951, Ticker = 'AZPN1*', ExchCode = 'MXQ' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871079564, ExchCode = 'MXQ' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561584, ExchCode = 'DUS', PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943651732, ExchCode = 'STU' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684828, ExchCode = 'QTX' WHERE SecCode = 5194304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945430509, ExchCode = 'STU' WHERE SecCode = 5194305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904165, ExchCode = 'BCO' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872761574, Ticker = 'AFTT', ExchCode = 'PAR' WHERE SecCode = 5206274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930806960, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 5220960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933629891, ExchCode = 'TDG' 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 = 236793845610, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-26' WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751536, ExchCode = 'QTX' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935009046, ExchCode = 'DEU' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956341568, ExchCode = 'HAN' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803186, ExchCode = 'QTX' 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 = 236777397462, ExchCode = 'BTE' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908505, PermQuoteStatus = 'DC', Ticker = '3QP0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5324087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791510353, ExchCode = 'MUN' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510655, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-09' WHERE SecCode = 5357353 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 = 236785534615, ExchCode = 'QTX' WHERE SecCode = 5383599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535810, ExchCode = 'MEX' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961201424, ExchCode = 'FRA' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829302, ExchCode = 'TDG' WHERE SecCode = 5415164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777481353, ExchCode = 'FRA' WHERE SecCode = 5422843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777481357, ExchCode = 'FRA' WHERE SecCode = 5422844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171626, ExchCode = 'MEX' WHERE SecCode = 5443497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778299981, ExchCode = 'FRA' WHERE SecCode = 5468679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778659884, ExchCode = 'MEX' WHERE SecCode = 5496143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834799, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5496168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982253324, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5496242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21983506605, Ticker = '3BASm', ExchCode = 'BCO' WHERE SecCode = 5496244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585144, ExchCode = 'BIV' WHERE SecCode = 5502269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309769, Ticker = '3LMO', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5506501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778891290, ExchCode = 'FRA' WHERE SecCode = 5507430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776850442, ExchCode = 'MEX' WHERE SecCode = 5516778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787446918, ExchCode = 'STU' WHERE SecCode = 5523278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779256326, ExchCode = 'MEX' WHERE SecCode = 5531898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535806, ExchCode = 'MEX' WHERE SecCode = 5539536 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 = 236779471184, ExchCode = 'BIV' WHERE SecCode = 5542023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471180, ExchCode = 'MEX' WHERE SecCode = 5549613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21992342600, ExchCode = 'DEU' WHERE SecCode = 5550738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776857965, ExchCode = 'MEX' WHERE SecCode = 5551974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777584027, ExchCode = 'BIV' WHERE SecCode = 5558570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771107, ExchCode = 'FRA' WHERE SecCode = 5563110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835651, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777360178, ExchCode = 'MEX' WHERE SecCode = 5581641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212174, ExchCode = 'MEX' WHERE SecCode = 5604481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780515980, ExchCode = 'FRA' WHERE SecCode = 5607542 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5635825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078274, ExchCode = 'LAS' WHERE SecCode = 5636960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569267651, ExchCode = 'BTE' WHERE SecCode = 5638833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460738, ExchCode = 'FRA' WHERE SecCode = 5638838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848440, ExchCode = 'QTX', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848459, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837511990, Ticker = '2STSa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5638905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781543275, ExchCode = 'STU' WHERE SecCode = 5655040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22019369619, ExchCode = 'DEU' WHERE SecCode = 5663579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781580967, ExchCode = 'STU' WHERE SecCode = 5663580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796541657, ExchCode = 'GTX' WHERE SecCode = 5674580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22024905296, Ticker = 'VPCU', ExchCode = 'LSE' WHERE SecCode = 5702903 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 5745664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782871477, ExchCode = 'STU' WHERE SecCode = 5745665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136364064, ExchCode = 'CHI' WHERE SecCode = 5782854 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 PermSecMapEndDate = '2026-05-11' WHERE SecCode = 5833284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785217080, ExchCode = 'STU' WHERE SecCode = 5871394 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '3ST0' WHERE SecCode = 5885543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416444, ExchCode = 'BIV' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800227924, ExchCode = 'TDG' WHERE SecCode = 5894957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785978750, ExchCode = 'STU' WHERE SecCode = 5907872 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '0XW0', PermSecMapEndDate = NULL WHERE SecCode = 6006787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795664145, ExchCode = 'BIV' WHERE SecCode = 6014420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814699350, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704334, ExchCode = 'MXQ' WHERE SecCode = 6097401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911611, ExchCode = 'MEX' 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 PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 6139857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089872374, ExchCode = 'DEU' WHERE SecCode = 6153962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089867315, ExchCode = 'DEU' WHERE SecCode = 6153964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791248887, ExchCode = 'STU' WHERE SecCode = 6190705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22094064244, ExchCode = 'DEU' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-12' WHERE SecCode = 6263984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792342447, ExchCode = 'FRA' WHERE SecCode = 6270465 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 6333956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793644481, ExchCode = 'GTX' WHERE SecCode = 6341809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887551041, ExchCode = 'MUN' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989720, ExchCode = 'MXQ' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655560, ExchCode = 'FRA' WHERE SecCode = 6368868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794094894, ExchCode = 'QTX' WHERE SecCode = 6392491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794459345, ExchCode = 'FRA' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451414, ExchCode = 'BTE' WHERE SecCode = 6456368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157927, ExchCode = 'BTE' WHERE SecCode = 6456369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152233865, ExchCode = 'AQX' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157937, ExchCode = 'BTE' WHERE SecCode = 6456372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141703185, ExchCode = 'BTE' WHERE SecCode = 6456373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451415, ExchCode = 'BTE' WHERE SecCode = 6456374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141447615, ExchCode = 'BTE' WHERE SecCode = 6456375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157950, ExchCode = 'BTE' WHERE SecCode = 6456376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451405, ExchCode = 'BTE' WHERE SecCode = 6456377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136096482, ExchCode = 'MUN' WHERE SecCode = 6482759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131851181, ExchCode = 'DEU' WHERE SecCode = 6482768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109805, ExchCode = 'DUS' WHERE SecCode = 6501107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107740, ExchCode = 'FRA' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107743, ExchCode = 'FRA' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797392, ExchCode = 'TDG' WHERE SecCode = 6548155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800096573, ExchCode = 'FRA' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800600756, ExchCode = 'FRA' WHERE SecCode = 6603628 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 6622165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357085, ExchCode = 'BRN' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798361873, ExchCode = 'MEX' WHERE SecCode = 6661586 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-02-27' WHERE SecCode = 6689495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167339217, Ticker = 'DDUM', ExchCode = 'LSE' WHERE SecCode = 6727855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804483809, ExchCode = 'QTX' WHERE SecCode = 6727870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22166833124, ExchCode = 'GER' WHERE SecCode = 6727920 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699531, ExchCode = 'BIV' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-12' WHERE SecCode = 6773253 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 6789510 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 6789511 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 6802646 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6806184 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-12', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 6813250 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 6813273 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 10934601 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 10961584 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11005254 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11049340 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11051804 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11061263 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'MYS' WHERE SecCode = 11140993 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951470.0 WHERE SecCode = 11148900 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11154666 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 11185277 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11186317 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11195314 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11196226 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 11200913 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951476.0 WHERE SecCode = 11202484 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11210863 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 11211578 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11211909 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL WHERE SecCode = 11226945 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11228283 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11228341 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11229735 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11234105 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 11236980 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11242346 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11266043 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11271538 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11281412 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11284217 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11284218 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-11' WHERE SecCode = 11294294 AND Type_ = 1;
