UPDATE data_universe_permid SET QuotePermID = 55838296539, Ticker = 'AAT.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 13 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847137216, Ticker = 'ABBY.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 24 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531128468, Ticker = 'HONl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-03-16' WHERE SecCode = 229 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 1677 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 1977 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'VGB' WHERE SecCode = 6195 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'VGB' WHERE SecCode = 12711 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 19538 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21842591690, Ticker = '0HKPl', ExchCode = 'BCO' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331426, ExchCode = 'BER', PermQuoteRetireDate = '2008-12-30' WHERE SecCode = 34074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622059, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'VGB' WHERE SecCode = 35569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859213206, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37893 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 42619 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55837360180, ExchCode = 'GER' WHERE SecCode = 46009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838238293, ExchCode = 'MUN' WHERE SecCode = 46294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474989882, Ticker = 'FRZ', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 46907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474843390, ExchCode = 'DEU' WHERE SecCode = 48131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243226, Ticker = 'MKA', ExchCode = 'MUN' WHERE SecCode = 48328 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '3NOV25' WHERE SecCode = 52526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801607810, ExchCode = 'GTX' WHERE SecCode = 53597 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 56040 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21591308334, ExchCode = 'STU' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 58563 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2017-07-03' WHERE SecCode = 59737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838238912, ExchCode = 'MUN' WHERE SecCode = 59881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474840787, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-22', PermSecMapEndDate = NULL WHERE SecCode = 59895 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 = 55836489836, ExchCode = 'FRA' 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 = 21538134678, ExchCode = 'FRA' WHERE SecCode = 60316 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'VGB' WHERE SecCode = 60823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608399459, ExchCode = 'DEU' WHERE SecCode = 61371 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ISR' WHERE SecCode = 61826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659673, ExchCode = 'LAS' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 62290 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 64489 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-22' WHERE SecCode = 66540 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 68527 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 71995 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 77346 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 83114 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-23' WHERE SecCode = 83347 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 84546 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 84599 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'ISR' WHERE SecCode = 86608 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'VGB' WHERE SecCode = 86954 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'PAN' WHERE SecCode = 87093 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-21' WHERE SecCode = 87690 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838797189, ExchCode = 'JNB' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 88744 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 95041 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SCL' WHERE SecCode = 95920 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 99340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141120, ExchCode = 'FRA' WHERE SecCode = 100032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531043704, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 100052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822354, ExchCode = 'DEU' WHERE SecCode = 111811 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2020-10-12', PermSecMapEndDate = NULL WHERE SecCode = 112299 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531794419, ExchCode = 'FRA' WHERE SecCode = 112544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781756532, ExchCode = 'MUN' WHERE SecCode = 112548 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 114410 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 115534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298391, ExchCode = 'FRA' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660136963, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2023-02-03' WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525931704, ExchCode = 'STU' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475008736, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951679.0 WHERE SecCode = 126342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836390769, ExchCode = 'FRA' WHERE SecCode = 133773 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 134523 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 135436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997893, ExchCode = 'FRA' WHERE SecCode = 138040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474933538, PermQuoteStatus = 'AC', Ticker = 'E3X1', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-22' WHERE SecCode = 139179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624943903, PermQuoteStatus = 'AC', Ticker = 'YAJ', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-14', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 140068 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803716657, ExchCode = 'FRA' WHERE SecCode = 140136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591385, ExchCode = 'DEU' WHERE SecCode = 140677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037625, ExchCode = 'MUN' WHERE SecCode = 142650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387689, ExchCode = 'LAS' WHERE SecCode = 142718 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 143585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474936011, ExchCode = 'DEU' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419305, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 146027 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'IMN' WHERE SecCode = 146743 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'IMN' WHERE SecCode = 146923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112538, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-27', PermSecMapEndDate = NULL WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684961175, ExchCode = 'MUN' WHERE SecCode = 147900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782821783, ExchCode = 'MUN' WHERE SecCode = 147907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521106330, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-09' WHERE SecCode = 147913 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330777, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 178600 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 178694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528277070, ExchCode = 'FRA' WHERE SecCode = 249402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568175738, ExchCode = 'STU', PermQuoteRetireDate = '2019-12-05' WHERE SecCode = 249609 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 249719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 252408 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 252478 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 270174 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667472878, ExchCode = 'QTX' WHERE SecCode = 278881 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 292749 AND Type_ = 1;
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 PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 303358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474989966, ExchCode = 'STU' WHERE SecCode = 304121 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-22' WHERE SecCode = 306578 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-23' WHERE SecCode = 327369 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 328220 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 331611 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55834673708, PermQuoteStatus = 'AC', Ticker = '0G77', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 333102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321769, ExchCode = 'BER', PermQuoteRetireDate = '2009-04-22' WHERE SecCode = 333158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503112746, ExchCode = 'TDG', PermQuoteRetireDate = '2015-12-08' WHERE SecCode = 333182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805996349, PermQuoteStatus = 'AC', Ticker = 'XINRY', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-21', PermSecMapEndDate = NULL WHERE SecCode = 334399 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21523039680, ExchCode = 'TDG' WHERE SecCode = 334857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164720656, ExchCode = 'DEU' WHERE SecCode = 335262 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 340882 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 22175074087, ExchCode = 'DEU', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 346201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852383889, ExchCode = 'GTX', PermQuoteRetireDate = '2025-10-24', PermSecMapEndDate = '2025-11-07' WHERE SecCode = 346209 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 347790 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 349625 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475034683, Ticker = '45G', ExchCode = 'TDG', PermQuoteRetireDate = '2012-10-23' WHERE SecCode = 360278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620916416, ExchCode = 'TDG' WHERE SecCode = 375326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547002144, Ticker = 'D69d', ExchCode = 'BCO' WHERE SecCode = 379671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916561972, ExchCode = 'MUN' WHERE SecCode = 385281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840857595, Ticker = '4QQN', ExchCode = 'BER', PermQuoteRetireDate = '2022-05-02' WHERE SecCode = 389019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840913294, ExchCode = 'FRA' WHERE SecCode = 389775 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 391862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727380416, Ticker = 'NMM', ExchCode = 'BRN' WHERE SecCode = 392615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799280763, ExchCode = 'DEU' WHERE SecCode = 396303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841643564, ExchCode = 'FRA' WHERE SecCode = 401624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955877, ExchCode = 'TDG' WHERE SecCode = 412853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523795704, ExchCode = 'STU' WHERE SecCode = 424779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843194281, ExchCode = 'FRA' WHERE SecCode = 425031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843333402, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-08' WHERE SecCode = 425411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488504, ExchCode = 'QTX' WHERE SecCode = 428332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679708, ExchCode = 'DEU' WHERE SecCode = 428335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953597671, ExchCode = 'DUS' WHERE SecCode = 432012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477787209, ExchCode = 'TDG' WHERE SecCode = 435796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21600289193, ExchCode = 'DUS', PermQuoteRetireDate = '2023-12-15', PermSecMapEndDate = NULL WHERE SecCode = 438364 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 440328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845459608, ExchCode = 'BER', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 442574 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-02-17', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 451098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 460976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841619375, ExchCode = 'MEX' WHERE SecCode = 462658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847269156, Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 478546 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 = 21475107600, ExchCode = 'MUN' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616157068, ExchCode = 'MCX' WHERE SecCode = 500487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848865465, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 503830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627494176, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-12-16', PermSecMapEndDate = '2019-12-17' WHERE SecCode = 503842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849477549, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 513278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428165, ExchCode = 'GTX' WHERE SecCode = 519511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214202, ExchCode = 'MEX' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784580341, Ticker = '9EAA', PermQuoteRetireDate = '2022-09-13' WHERE SecCode = 531956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543053439, Ticker = '8EC', ExchCode = 'STU', PermQuoteRetireDate = '2023-09-05' WHERE SecCode = 533384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521104643, ExchCode = 'STU' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475845507, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 533522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519097, ExchCode = 'DUS' WHERE SecCode = 535314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851203490, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 535316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475082592, ExchCode = 'STU', PermQuoteRetireDate = '2019-02-25' WHERE SecCode = 535417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714450686, Ticker = 'SBULm', ExchCode = 'DXE' WHERE SecCode = 536401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852525112, ExchCode = 'STU', PermQuoteRetireDate = '2015-02-09' WHERE SecCode = 536609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475422418, Ticker = '0B3F', ExchCode = 'LSE', PermQuoteRetireDate = '2009-09-18' WHERE SecCode = 536734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581478612, ExchCode = 'HAM' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511306868, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2023-03-13' WHERE SecCode = 539801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858727490, ExchCode = 'STU' WHERE SecCode = 541276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852220203, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 541456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514772172, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 541523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856846841, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 541974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035999, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2015-08-14' WHERE SecCode = 542320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307216, ExchCode = 'BIV' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799025517, ExchCode = 'MUN' WHERE SecCode = 542943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474839548, ExchCode = 'STO', PermQuoteRetireDate = '2018-10-15' WHERE SecCode = 547513 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 549141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853076828, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-23' WHERE SecCode = 549287 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 549860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853660976, ExchCode = 'GER' WHERE SecCode = 552722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503219887, ExchCode = 'STU' WHERE SecCode = 552948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706181, ExchCode = 'MXQ' WHERE SecCode = 554302 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 554615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858811523, ExchCode = 'FRA' WHERE SecCode = 556254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55854015367, ExchCode = 'BER', PermQuoteRetireDate = '2013-07-08' WHERE SecCode = 556535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727200540, ExchCode = 'MEX' WHERE SecCode = 557690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859197737, ExchCode = 'BER' WHERE SecCode = 557816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475855781, ExchCode = 'TDG' WHERE SecCode = 557995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856214006, ExchCode = 'GER' WHERE SecCode = 558032 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 558221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184301, ExchCode = 'FRA' WHERE SecCode = 558485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036088, ExchCode = 'TDG' WHERE SecCode = 558811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856395007, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 559256 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 559363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804090704, ExchCode = 'HAM' WHERE SecCode = 559903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856811283, PermQuoteStatus = 'DC', Ticker = '7TM', ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 560717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856721464, ExchCode = 'BER', PermQuoteRetireDate = '2018-04-27' WHERE SecCode = 560723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856703002, PermQuoteStatus = 'DC', Ticker = 'DGF', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 560728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850811719, ExchCode = 'BER', PermQuoteRetireDate = '2015-05-06' WHERE SecCode = 561328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525342898, ExchCode = 'STU' WHERE SecCode = 561861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294098, ExchCode = 'GTX' WHERE SecCode = 563087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858521801, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 564035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857657672, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 565330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857726268, ExchCode = 'BER', PermQuoteRetireDate = '2014-03-27' WHERE SecCode = 565586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607812061, ExchCode = 'MUN' WHERE SecCode = 565752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857541012, ExchCode = 'FRA' WHERE SecCode = 565866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791908479, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 566221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857857467, ExchCode = 'STU' WHERE SecCode = 566528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622957126, ExchCode = 'DUS' WHERE SecCode = 568338 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 = 21732787219, ExchCode = 'DUS' WHERE SecCode = 575072 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 588859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475127703, ExchCode = 'DEU', PermQuoteRetireDate = '2017-10-20' WHERE SecCode = 591764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379754, ExchCode = 'LAS' WHERE SecCode = 593055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475793862, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 593104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954835919, ExchCode = 'DUS' WHERE SecCode = 597462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293928, InstrPermID = 8591391476, OrgPermID = 5000663094, ValQuotePermID = 55858425773.0, PriInstrPermID = 8591391476.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'ANK', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermOrgIPODate = '2010-04-01' WHERE SecCode = 601515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255779, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802542707, ExchCode = 'FRA' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475859202, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647852573, ExchCode = 'STU' WHERE SecCode = 607486 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 612114 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 657955 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 657956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806021353, ExchCode = 'HAN', PermSecMapStartDate = '2026-04-22' WHERE SecCode = 661153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391671, ExchCode = 'GTX' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581498976, ExchCode = 'MUN' WHERE SecCode = 701753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865088683, ExchCode = 'TDG' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 788509 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 795766 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 804585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749996718, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 826159 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 833608 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 844066 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 845687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55866710248, PermQuoteStatus = 'AC', Ticker = 'XAD6', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 848018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475136959, ExchCode = 'DEU' WHERE SecCode = 858901 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 866994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596702, ExchCode = 'FRA' WHERE SecCode = 878880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528542094, ExchCode = 'TDG' WHERE SecCode = 881802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655396854, ExchCode = 'DEU' WHERE SecCode = 882427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660807802, ExchCode = 'MUN' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779809732, ExchCode = 'GTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727382916, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 885999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677151, ExchCode = 'BIV' WHERE SecCode = 888213 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 894193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545813177, ExchCode = 'FRA' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785297550, ExchCode = 'QTX' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838301302, Ticker = 'MBTGV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2013-02-22' WHERE SecCode = 961652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800222853, ExchCode = 'FRA' WHERE SecCode = 1017380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804482265, ExchCode = 'MUN' WHERE SecCode = 1072550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481551, ExchCode = 'QTX' WHERE SecCode = 1113268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521581557, ExchCode = 'FRA' WHERE SecCode = 1122776 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1140655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840060201, ExchCode = 'MEX' WHERE SecCode = 1162639 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 1210482 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 1230252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747333716, ExchCode = 'FRA' WHERE SecCode = 1447581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583580938, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-08-16', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1455200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504490118, ExchCode = 'FRA', PermQuoteRetireDate = '2015-06-02' WHERE SecCode = 1457731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704338, ExchCode = 'MXQ' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558280851, ExchCode = 'CHI', PermQuoteRetireDate = '2025-02-03' WHERE SecCode = 1472753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950893, ExchCode = 'STU' WHERE SecCode = 1485685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385946, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 1493830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55886089498, Ticker = 'SLHO', ExchCode = 'MIL', PermQuoteRetireDate = '2019-09-17' WHERE SecCode = 1503000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653590213, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642014, ExchCode = 'QTX' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1507655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591674214, ExchCode = 'TDG' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368530, Ticker = 'PU7D', ExchCode = 'SES', PermQuoteRetireDate = '2018-09-12' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704850, ExchCode = 'MXQ' WHERE SecCode = 1518823 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1518934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486671125, ExchCode = 'STU' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488285610, ExchCode = 'DEU' WHERE SecCode = 1524542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857143091, ExchCode = 'DUS' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623750, ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-23', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 1524562 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 1524615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793448735, ExchCode = 'TDG' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497908, ExchCode = 'FRA' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522741571, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-17' WHERE SecCode = 1527439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21489920274, ExchCode = 'FRA', PermQuoteRetireDate = '2012-08-22' WHERE SecCode = 1527466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152677, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1528083 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1533846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492895638, ExchCode = 'DEU', PermQuoteRetireDate = '2014-04-08' WHERE SecCode = 1537137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270483, ExchCode = 'FRA' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493420, ExchCode = 'QTX' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766661889, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1538644 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951244.0 WHERE SecCode = 1541388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775091189, ExchCode = 'DEU' WHERE SecCode = 1541396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492779440, ExchCode = 'CPH' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 1544242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508750705, ExchCode = 'STU' WHERE SecCode = 1554784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498305313, ExchCode = 'FRA' WHERE SecCode = 1555173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498532317, ExchCode = 'FRA' WHERE SecCode = 1556381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21501626987, ExchCode = 'STU' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951829.0 WHERE SecCode = 1568468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639604213, ExchCode = 'MUN' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503838088, ExchCode = 'BER', PermQuoteRetireDate = '2017-05-30' WHERE SecCode = 1587478 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951875.0 WHERE SecCode = 1622903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331619, Ticker = 'KJ7A', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1623980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950789, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-10', PermSecMapEndDate = NULL WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510008303, ExchCode = 'DEU' WHERE SecCode = 1653506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627202983, ExchCode = 'TDG', PermQuoteRetireDate = '2018-07-10' 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 = 21602971036, PermQuoteStatus = 'AC', Ticker = 'PJSBd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 1660702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485319, ExchCode = 'QTX' WHERE SecCode = 1675772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627697, ExchCode = 'QTX' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 1703312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528495375, ExchCode = 'BTE' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628061495, ExchCode = 'DEU' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939948839, PermQuoteStatus = 'DC', Ticker = 'OD7L', ExchCode = 'HAN', PermQuoteRetireDate = '2024-03-05' WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513751840, ExchCode = 'STU' WHERE SecCode = 1795399 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1860087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951770.0 WHERE SecCode = 1994294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516696149, Ticker = 'ECX', ExchCode = 'LSE', PermQuoteRetireDate = '2014-08-27' WHERE SecCode = 2013070 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 2068084 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 2122875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519818958, ExchCode = 'DEU', PriTRBCIndPermID = 4294951770.0 WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952626732, ExchCode = 'FRA' WHERE SecCode = 2220730 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474891021, Ticker = '4KPN', ExchCode = 'ETX' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524108941, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524070827, ExchCode = 'FRA' WHERE SecCode = 2240608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576247697, ExchCode = 'FRA' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967894, ExchCode = 'MUN' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854585, ExchCode = 'BER', PermQuoteRetireDate = '2020-12-29' WHERE SecCode = 2288362 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951244.0 WHERE SecCode = 2334616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045908153, ExchCode = 'MXQ' WHERE SecCode = 2337158 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2343132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530263647, ExchCode = 'FRA' WHERE SecCode = 2357967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529719631, ExchCode = 'TDG' WHERE SecCode = 2357969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484790, ExchCode = 'QTX' WHERE SecCode = 2357974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2373506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530840197, ExchCode = 'FRA' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756136975, ExchCode = 'FRA' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130921495, ExchCode = 'DEU' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2382328 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2390263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532177823, ExchCode = 'FRA', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786676625, ExchCode = 'BIV' WHERE SecCode = 2414027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533561487, ExchCode = 'MUN' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 2460004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535482346, ExchCode = 'DEU' WHERE SecCode = 2466343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535535339, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-02' WHERE SecCode = 2466346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537245207, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 2466348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597458278, Ticker = '22N', ExchCode = 'BER', PermQuoteRetireDate = '2023-10-03' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134691, ExchCode = 'DEU' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798387416, ExchCode = 'HAM' WHERE SecCode = 2518731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609327643, ExchCode = 'TDG' WHERE SecCode = 2522906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101512, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-22', PermSecMapEndDate = NULL WHERE SecCode = 2524752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390644, ExchCode = 'FRA' WHERE SecCode = 2524755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385079, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2529636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869000361, ExchCode = 'FRA', PermSecMapEndDate = NULL WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545188944, ExchCode = 'STU' WHERE SecCode = 2532821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539323911, ExchCode = 'FRA' WHERE SecCode = 2534073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587290079, ExchCode = 'STU' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629786303, ExchCode = 'DEU' WHERE SecCode = 2539933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798387589, ExchCode = 'HAM' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540739504, ExchCode = 'FRA' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835976, Ticker = '53S1d', ExchCode = 'BCO', PermQuoteRetireDate = '2021-09-27' WHERE SecCode = 2550286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103484, ExchCode = 'FRA' WHERE SecCode = 2554904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542191768, ExchCode = 'MUN' WHERE SecCode = 2567216 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951470.0 WHERE SecCode = 2583457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430409, ExchCode = 'DEU' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121993813, ExchCode = 'BTE' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951470.0 WHERE SecCode = 2593544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670880, ExchCode = 'AUX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545105789, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2014-10-22', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2604391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545264705, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-15' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 2621757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651407157, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2622293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606782728, ExchCode = 'FRA' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574200693, ExchCode = 'FRA' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781870182, ExchCode = 'STU' WHERE SecCode = 2642447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548046381, ExchCode = 'STU' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 2654777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549116547, ExchCode = 'BER' WHERE SecCode = 2655948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549411041, ExchCode = 'FRA', PermQuoteRetireDate = '2017-11-02' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596919201, ExchCode = 'CHI' WHERE SecCode = 2679866 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617877526, Ticker = 'BWOv', ExchCode = 'EBT', PermQuoteRetireDate = '2021-06-01' 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 = 21776605626, ExchCode = 'MXQ' WHERE SecCode = 2715641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553011650, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2718428 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 2720693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705935887, ExchCode = 'BIV' WHERE SecCode = 2724356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553466682, Ticker = 'TUIN', ExchCode = 'LSE', PermQuoteRetireDate = '2015-02-11' WHERE SecCode = 2731347 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2732713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387967, ExchCode = 'LAS' WHERE SecCode = 2732754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704676, ExchCode = 'MXQ' WHERE SecCode = 2743610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554451923, ExchCode = 'TDG', PermQuoteRetireDate = '2019-01-14' WHERE SecCode = 2750984 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 2753903 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 2763353 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 2764599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704388, ExchCode = 'MXQ' WHERE SecCode = 2767208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676152, ExchCode = 'BIV' WHERE SecCode = 2770567 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 = 21549893799, ExchCode = 'DEU' WHERE SecCode = 2784985 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556646386, ExchCode = 'DEU' WHERE SecCode = 2800411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322186, ExchCode = 'DEU' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843924533, ExchCode = 'FRA' WHERE SecCode = 2809752 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 2812061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558476903, ExchCode = 'FRA' WHERE SecCode = 2813079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557544156, ExchCode = 'FRA' WHERE SecCode = 2817416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558155337, ExchCode = 'FRA' WHERE SecCode = 2823565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535496482, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 2827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763993243, PermQuoteStatus = 'AC', Ticker = '8PSGd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559588394, ExchCode = 'FRA' WHERE SecCode = 2848442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560671440, ExchCode = 'FRA' WHERE SecCode = 2855770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684294108, ExchCode = 'TDG', PermQuoteRetireDate = '2019-04-03' WHERE SecCode = 2855771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560761414, ExchCode = 'DEU' WHERE SecCode = 2855773 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951945.0 WHERE SecCode = 2855813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939948844, ExchCode = 'HAN' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650196, ExchCode = 'DUS' WHERE SecCode = 2858551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952406, ExchCode = 'FRA' WHERE SecCode = 2858567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599175171, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2861791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561140926, ExchCode = 'DEU' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460829, ExchCode = 'GER' WHERE SecCode = 2864471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478711, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561796936, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2870145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562290608, ExchCode = 'FRA' WHERE SecCode = 2870150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677051, ExchCode = 'BIV' WHERE SecCode = 2876241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478695, ExchCode = 'QTX' WHERE SecCode = 2880971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564231392, ExchCode = 'TRQ', PermQuoteRetireDate = '2015-05-28' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951771.0 WHERE SecCode = 2900881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564531293, ExchCode = 'STU' WHERE SecCode = 2905610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779690645, ExchCode = 'AQX' WHERE SecCode = 2906408 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 = 21655017440, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564677908, ExchCode = 'FRA' WHERE SecCode = 2909231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21600289186, Ticker = 'MMAT', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 2909232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478659, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL 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 = 21564938913, ExchCode = 'DEU' WHERE SecCode = 2909928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565148442, ExchCode = 'MUN' WHERE SecCode = 2911859 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 2912848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679813, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457862, ExchCode = 'FRA' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370656, ExchCode = 'SGO' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21566806429, ExchCode = 'DEU' WHERE SecCode = 2930976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567022234, ExchCode = 'FRA', PermQuoteRetireDate = '2019-05-27', PermSecMapEndDate = NULL WHERE SecCode = 2932394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672243657, PermQuoteStatus = 'DC', Ticker = '16IE', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2935960 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2936032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675252, ExchCode = 'BIV' WHERE SecCode = 2944454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370461, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568851024, ExchCode = 'DEU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569151527, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2952372 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 2953264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704396, ExchCode = 'MXQ' WHERE SecCode = 2963604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787393, ExchCode = 'DUS' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951875.0 WHERE SecCode = 2989585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573513525, ExchCode = 'FRA' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488811, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3010358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724821997, Ticker = '9GL', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2024-04-10' WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576175357, ExchCode = 'DEU' WHERE SecCode = 3032214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786322025, ExchCode = 'BER' WHERE SecCode = 3065856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585828975, Ticker = 'RYAA', ExchCode = 'STU', PermQuoteRetireDate = '2023-12-08' WHERE SecCode = 3072584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587055379, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14', PermSecMapEndDate = '2020-06-16' WHERE SecCode = 3076717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285644, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460750, Ticker = 'OD7I', ExchCode = 'FRA' WHERE SecCode = 3076725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022534, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3083485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582352174, ExchCode = 'FRA' WHERE SecCode = 3085564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787344, Ticker = '42P', ExchCode = 'DUS', PermQuoteRetireDate = '2021-03-16' 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 = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432069, ExchCode = 'DEU' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544679, ExchCode = 'DUS' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536846008, ExchCode = 'FRA', PermQuoteRetireDate = '2018-07-11' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587220566, ExchCode = 'TDG' WHERE SecCode = 3153872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790760, ExchCode = 'GTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798143359, ExchCode = 'FRA' WHERE SecCode = 3186751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627445525, ExchCode = 'BTE' WHERE SecCode = 3186834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589835342, ExchCode = 'DEU' WHERE SecCode = 3196992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169497784, ExchCode = 'DEU' WHERE SecCode = 3196993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786342003, Ticker = 'XMW2', ExchCode = 'STU' WHERE SecCode = 3198718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768480038, ExchCode = 'MUN' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100717, ExchCode = 'QTX' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 3211310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625006481, ExchCode = 'DEU' WHERE SecCode = 3215534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748078950, ExchCode = 'DEU', PermQuoteRetireDate = '2023-02-17', PermSecMapEndDate = '2023-02-17' WHERE SecCode = 3215564 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 = 21591959265, ExchCode = 'STU' WHERE SecCode = 3215818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535194629, Ticker = 'AHOG', ExchCode = 'BRN' WHERE SecCode = 3217753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789234589, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3223076 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 = 21683901733, ExchCode = 'MUN', PermQuoteRetireDate = '2020-08-11' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011205, Ticker = '2UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 3247164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824694891, ExchCode = 'DUS' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787711120, Ticker = '1CBKm', ExchCode = 'BCO' WHERE SecCode = 3247531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597458276, ExchCode = 'BER', PermQuoteRetireDate = '2020-07-27' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799025630, ExchCode = 'MUN', PermQuoteRetireDate = '2024-08-14', PermSecMapEndDate = NULL WHERE SecCode = 3260030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387859, ExchCode = 'LAS' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 3282950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603342349, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3283956 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951829.0 WHERE SecCode = 3288149 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 3288272 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3289825 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3305658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743775985, ExchCode = 'DEU', PermQuoteRetireDate = '2022-02-14' WHERE SecCode = 3309705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609327640, ExchCode = 'FRA', PermQuoteRetireDate = '2023-07-04' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611220164, ExchCode = 'TDG' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 3324099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297982, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3327820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297854, ExchCode = 'DUS' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 3327841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793910667, ExchCode = 'QTX' WHERE SecCode = 3337223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780911221, ExchCode = 'MUN' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3337527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367734, ExchCode = 'AUX' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3349700 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 3354570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623820791, ExchCode = 'EQD' WHERE SecCode = 3358414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659071012, ExchCode = 'BIV' WHERE SecCode = 3358492 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3358548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050419, ExchCode = 'DEU' WHERE SecCode = 3359272 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951805.0 WHERE SecCode = 3359489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616206400, ExchCode = 'DEU' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744646634, Ticker = '90S', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3371094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648301745, ExchCode = 'STU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706044918, PermQuoteStatus = 'DC', Ticker = '015', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01', PermSecMapEndDate = '2023-02-15' WHERE SecCode = 3375389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100723, ExchCode = 'DUS' WHERE SecCode = 3378195 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3384464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625753506, ExchCode = 'BTE' WHERE SecCode = 3385974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663294277, ExchCode = 'MUN', PermQuoteRetireDate = '2022-09-12' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-22' WHERE SecCode = 3392529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029268, ExchCode = 'SWX' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029277, ExchCode = 'SWX' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390634, ExchCode = 'DEU' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623455650, ExchCode = 'BCO' WHERE SecCode = 3395249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100517, ExchCode = 'QTX' WHERE SecCode = 3401365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932183, ExchCode = 'FRA' WHERE SecCode = 3401402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145793081, ExchCode = 'DEU' WHERE SecCode = 3401911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640356575, PermQuoteStatus = 'DC', Ticker = 'G0A1', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 3401914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660711279, ExchCode = 'FRA' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718790665, ExchCode = 'BTE' WHERE SecCode = 3404188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629355998, ExchCode = 'TDG', PermQuoteRetireDate = '2024-07-31', PermSecMapEndDate = '2024-08-30' WHERE SecCode = 3405438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100842, ExchCode = 'DUS' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705811, Ticker = 'TLNDN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624076661, ExchCode = 'BEC' WHERE SecCode = 3406544 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951593.0 WHERE SecCode = 3406750 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800223463, ExchCode = 'LAS' WHERE SecCode = 3407871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644149855, ExchCode = 'DEU' WHERE SecCode = 3409040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396811, ExchCode = 'FRA' WHERE SecCode = 3409090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301441, ExchCode = 'MEX' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 3409864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801287178, Ticker = 'C0B', ExchCode = 'STU' WHERE SecCode = 3410283 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3429793 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951592.0 WHERE SecCode = 3429806 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3432360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636056227, ExchCode = 'FRA' WHERE SecCode = 3435060 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 3435136 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3435536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896368974, Ticker = 'AMSv', ExchCode = 'BTE', PermQuoteRetireDate = '2022-06-01' WHERE SecCode = 3435592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836351977, ExchCode = 'QTX' WHERE SecCode = 3438714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796441340, ExchCode = 'HAM' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951392.0 WHERE SecCode = 3440080 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 3440156 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 3445984 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 = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 3490906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800450347, ExchCode = 'MUN' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675265, ExchCode = 'BIV' WHERE SecCode = 3501208 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 DomCntry = 'CHN' WHERE SecCode = 3514007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430834, ExchCode = 'DEU' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 3532727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 3543173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452965, ExchCode = 'FRA' WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663166737, ExchCode = 'DEU' WHERE SecCode = 3550423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710951331, ExchCode = 'CHI' WHERE SecCode = 3550579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656632105, Ticker = 'DNK', ExchCode = 'LSE', PermQuoteRetireDate = '2021-09-24' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3569670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584408989, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-06' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572528792, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952428, ExchCode = 'FRA' WHERE SecCode = 3591601 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3612329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777289547, ExchCode = 'TDG' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 3622411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779823334, ExchCode = 'GTX' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668783322, ExchCode = 'HAN' WHERE SecCode = 3642406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679574, ExchCode = 'BIV' WHERE SecCode = 3644857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690033954, ExchCode = 'MUN' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670410338, Ticker = 'ROAI', ExchCode = 'SWX', PermQuoteRetireDate = '2023-09-22' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812659612, ExchCode = 'QTX', PermQuoteRetireDate = '2021-12-10' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673827389, ExchCode = 'MEX' WHERE SecCode = 3717229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679876423, ExchCode = 'DEU' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750787655, ExchCode = 'FRA' WHERE SecCode = 3731132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383888, ExchCode = 'BIV' WHERE SecCode = 3732368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22002744325, PermQuoteStatus = 'AC', Ticker = 'VUSA', ExchCode = 'SWX', PermQuoteRetireDate = NULL WHERE SecCode = 3736025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801047807, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803135585, ExchCode = 'FRA' WHERE SecCode = 3756337 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 3761029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272950, ExchCode = 'GTX' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683763490, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 3773536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431754, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-28' WHERE SecCode = 3779971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707022417, ExchCode = 'MUN' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690815100, ExchCode = 'DEU' WHERE SecCode = 3817679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780314322, ExchCode = 'GTX' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623734, ExchCode = 'TDG' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930883, ExchCode = 'MUN' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734634078, ExchCode = 'STU' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659513, ExchCode = 'LAS' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841766443, ExchCode = 'QTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888021879, ExchCode = 'GTX' WHERE SecCode = 3852867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701895290, ExchCode = 'DEU' WHERE SecCode = 3875755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702351475, ExchCode = 'DEU', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789792374, ExchCode = 'DUS' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505144, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-16' WHERE SecCode = 3905161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804755619, ExchCode = 'FRA' WHERE SecCode = 3913159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820592777, ExchCode = 'QTX' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3938564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715718959, ExchCode = 'STU' WHERE SecCode = 3980005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843603104, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4008980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359626, ExchCode = 'BIV' WHERE SecCode = 4024645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359395, ExchCode = 'SIG' WHERE SecCode = 4024795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026873, Ticker = '1BAC', ExchCode = 'MIL' WHERE SecCode = 4031699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026823, Ticker = '1T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026831, Ticker = '1AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010294, Ticker = '2AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028682767, Ticker = '2BRE' WHERE SecCode = 4031818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22044966173, Ticker = '2BOD' WHERE SecCode = 4031822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009889, Ticker = '2DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026917, Ticker = '1EUZ' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010541, Ticker = '2GG' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012423, Ticker = '2HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010937, Ticker = '2HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010414, Ticker = '2HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012605, Ticker = '2INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010156, Ticker = '2LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012517, Ticker = '2MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143892, Ticker = '2RI', ExchCode = 'MIL' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042586, Ticker = '2PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013663, Ticker = '2PYPL', ExchCode = 'MIL' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013557, Ticker = '2REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009964, Ticker = '2RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010336, Ticker = '2SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682843016, Ticker = '4UCB', ExchCode = 'ETX' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026881, Ticker = '1ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026759, Ticker = '1DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179786, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779134244, ExchCode = 'AQX' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951791.0 WHERE SecCode = 4069934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734028297, ExchCode = 'MUN' WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 4087765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735962079, ExchCode = 'MUN' WHERE SecCode = 4103595 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 = 21951941315, ExchCode = 'QTX' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586975, ExchCode = 'FRA' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571645915, ExchCode = 'SGO' WHERE SecCode = 4139247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704289, ExchCode = 'MXQ' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789555719, ExchCode = 'QTX' WHERE SecCode = 4169152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381466, ExchCode = 'LAS' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097198, ExchCode = 'LAS' WHERE SecCode = 4178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745664579, ExchCode = 'STU' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820365518, ExchCode = 'DUS' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755406168, ExchCode = 'STU' WHERE SecCode = 4195320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803758400, ExchCode = 'STU' WHERE SecCode = 4201669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746822092, ExchCode = 'STU' WHERE SecCode = 4201732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308365, PermQuoteStatus = 'AC', Ticker = '4R8', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'VGB' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958418, ExchCode = 'DEU' WHERE SecCode = 4209245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958218, ExchCode = 'DEU' WHERE SecCode = 4209246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858560, ExchCode = 'QTX' WHERE SecCode = 4209247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951632.0 WHERE SecCode = 4210900 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 = 21778023555, ExchCode = 'FRA', PermQuoteRetireDate = '2023-12-28' WHERE SecCode = 4228115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349453, ExchCode = 'BIV' WHERE SecCode = 4228288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749843263, ExchCode = 'DEU' WHERE SecCode = 4228324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750894848, ExchCode = 'FRA' WHERE SecCode = 4231470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388456, ExchCode = 'LAS' WHERE SecCode = 4248820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754200427, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4253036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754200308, ExchCode = 'DEU' WHERE SecCode = 4253037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754533500, ExchCode = 'FRA' WHERE SecCode = 4256876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760588255, ExchCode = 'STU', PermQuoteRetireDate = '2023-11-16', PermSecMapEndDate = NULL WHERE SecCode = 4259226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727346424, ExchCode = 'MEX' WHERE SecCode = 4273980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756548916, ExchCode = 'FRA' WHERE SecCode = 4274159 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 = 21759098760, ExchCode = 'DEU' WHERE SecCode = 4291265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727356006, ExchCode = 'MEX' WHERE SecCode = 4291615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759692063, ExchCode = 'DEU' WHERE SecCode = 4295731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768111804, PermQuoteStatus = 'DC', Ticker = '9EG', ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-27' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699358937, ExchCode = 'STU' WHERE SecCode = 4298602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803110079, ExchCode = 'FRA' WHERE SecCode = 4298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696686138, ExchCode = 'DEU' WHERE SecCode = 4298604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735310251, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 4298606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705427, ExchCode = 'MXQ' WHERE SecCode = 4298620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760973387, ExchCode = 'QTX' WHERE SecCode = 4303570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727343769, ExchCode = 'MEX' WHERE SecCode = 4303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761325018, Ticker = '4TKWY', ExchCode = 'ETX' WHERE SecCode = 4309036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026756, Ticker = '1NB' WHERE SecCode = 4309038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761324941, Ticker = '4RMS', ExchCode = 'ETX' WHERE SecCode = 4309039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026860, Ticker = '18TRA' WHERE SecCode = 4309041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761324824, Ticker = '4ASM', ExchCode = 'ETX' WHERE SecCode = 4309043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21761647098, ExchCode = 'DUS' WHERE SecCode = 4309050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751526, ExchCode = 'QTX' WHERE SecCode = 4310575 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 4317563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842459237, ExchCode = 'HAN' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763690130, ExchCode = 'QTX' WHERE SecCode = 4321393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709367298, ExchCode = 'MXQ' WHERE SecCode = 4324371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727341343, ExchCode = 'MEX' WHERE SecCode = 4324380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380423, ExchCode = 'LAS' WHERE SecCode = 4324465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801716826, ExchCode = 'TDG' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 4328965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867342843, ExchCode = 'TDG' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781601742, ExchCode = 'GER' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768618356, Ticker = '0A3M', ExchCode = 'LSE' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770221779, ExchCode = 'FRA' WHERE SecCode = 4360099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727315776, ExchCode = 'BIV' WHERE SecCode = 4362644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799675, ExchCode = 'HAM' WHERE SecCode = 4365921 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 4366353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388426, ExchCode = 'LAS' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782605835, ExchCode = 'QTX' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606711, ExchCode = 'FRA' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510749, ExchCode = 'DUS' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777644859, ExchCode = 'STU' WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783391809, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870580, ExchCode = 'DEU' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794594488, ExchCode = 'FRA' WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238824, ExchCode = 'LAS' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845531963, ExchCode = 'GTX' WHERE SecCode = 4388200 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4393398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826522500, ExchCode = 'QTX' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780150286, ExchCode = 'MUN' WHERE SecCode = 4400153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938004017, ExchCode = 'GTX', PermQuoteRetireDate = '2024-11-25' WHERE SecCode = 4401406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778680774 WHERE SecCode = 4406073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785622125, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996426, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786673386, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4422563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777025689, ExchCode = 'STU' WHERE SecCode = 4422567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999132, ExchCode = 'FRA' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307225, ExchCode = 'MEX' WHERE SecCode = 4426954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782653687, ExchCode = 'MUN' WHERE SecCode = 4426955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727303272, ExchCode = 'MEX' WHERE SecCode = 4426957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928415121, ExchCode = 'SIU' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026948, Ticker = '1VTRS' WHERE SecCode = 4427826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991601, ExchCode = 'FRA' WHERE SecCode = 4429683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799778, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-21', PermSecMapEndDate = NULL WHERE SecCode = 4434385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785087297, ExchCode = 'FRA' WHERE SecCode = 4434390 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 4440273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685950, ExchCode = 'DEU' WHERE SecCode = 4444002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740545, ExchCode = 'LAS' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387348, ExchCode = 'LAS' WHERE SecCode = 4447601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301153, ExchCode = 'BIV' WHERE SecCode = 4452337 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 = 21793689536, ExchCode = 'DEU' WHERE SecCode = 4463152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956950, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21796647312, ExchCode = 'STU' WHERE SecCode = 4472909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396601, ExchCode = 'FRA' WHERE SecCode = 4472926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780942173, ExchCode = 'STU' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781362966, ExchCode = 'DUS', PermQuoteRetireDate = '2024-02-20' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796870257, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951396.0 WHERE SecCode = 4491673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555797, ExchCode = 'DEU' WHERE SecCode = 4496736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797994407, ExchCode = 'STU' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287359, ExchCode = 'MEX' WHERE SecCode = 4505578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955514011, ExchCode = 'DUS' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800479537, ExchCode = 'DEU' WHERE SecCode = 4511506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851613, ExchCode = 'STU', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386877, ExchCode = 'LAS' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181247, ExchCode = 'DUS' WHERE SecCode = 4517645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430411, ExchCode = 'DEU' WHERE SecCode = 4526143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829968, ExchCode = 'QTX' WHERE SecCode = 4526144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387389, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4527883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628079, ExchCode = 'DUS' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809121292, Ticker = '0RW', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-22', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851700, ExchCode = 'MUN' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271947, ExchCode = 'MEX' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857143288, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-08' WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 4550766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806896207, ExchCode = 'FRA' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812165966, ExchCode = 'STU' WHERE SecCode = 4553829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807916822, ExchCode = 'TDG' WHERE SecCode = 4557761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823056706, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = NULL WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-22', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 4563452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830303213, ExchCode = 'GTX' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808950973, ExchCode = 'FRA' WHERE SecCode = 4568423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100496, ExchCode = 'QTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 4579643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811034765, ExchCode = 'MXQ' WHERE SecCode = 4580740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813395103, ExchCode = 'FRA' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305820, ExchCode = 'BIV' WHERE SecCode = 4597223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026913, Ticker = '1INVEB' WHERE SecCode = 4601877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295798, ExchCode = 'GTX' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782463495, ExchCode = 'QTX' 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 = 21818136782, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28' WHERE SecCode = 4607686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21944534852, ExchCode = 'STU' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144470, ExchCode = 'FRA' WHERE SecCode = 4607717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860843349, ExchCode = 'MUN' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138518181, ExchCode = 'BCO' WHERE SecCode = 4609997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128985397, ExchCode = 'TDG' WHERE SecCode = 4613099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780747375, ExchCode = 'FRA' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527324, ExchCode = 'DEU' WHERE SecCode = 4618010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968004, ExchCode = 'FRA' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778677427, ExchCode = 'QTX' WHERE SecCode = 4632109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825617109, ExchCode = 'DEU' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387315, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835319557, ExchCode = 'FRA' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316576, ExchCode = 'MUN' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837528978, ExchCode = 'DEU' WHERE SecCode = 4693647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802153605, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4697438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098679, ExchCode = 'FRA' WHERE SecCode = 4753666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855801983, ExchCode = 'DUS' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018892, ExchCode = 'STU' WHERE SecCode = 4773770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439459, ExchCode = 'MUN', PermQuoteRetireDate = '2021-11-15' WHERE SecCode = 4774934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726920, ExchCode = 'GTX' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795695818, ExchCode = 'TDG' WHERE SecCode = 4775075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609722, ExchCode = 'DUS' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705625, ExchCode = 'STU' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788376836, Ticker = 'A6Id', ExchCode = 'BCO' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860831312, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4800552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192644, ExchCode = 'DEU' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 4819741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951770.0 WHERE SecCode = 4838006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398797, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885446303, ExchCode = 'GTX' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144452987, ExchCode = 'LAS' WHERE SecCode = 4854867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872586858, ExchCode = 'DEU' WHERE SecCode = 4873679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876129776, ExchCode = 'QTX' WHERE SecCode = 4885603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520266, ExchCode = 'QTX' WHERE SecCode = 4887144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932177205, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312379, ExchCode = 'GTX' WHERE SecCode = 4890295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21875612276, ExchCode = 'QTX', PermQuoteRetireDate = '2022-09-13' WHERE SecCode = 4893294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727204791, ExchCode = 'BIV' WHERE SecCode = 4914666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879577473, ExchCode = 'DEU' WHERE SecCode = 4925667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434498, ExchCode = 'QTX' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781980293, PermQuoteStatus = 'DC', Ticker = '62U1', ExchCode = 'BER', PermQuoteRetireDate = '2025-09-01' WHERE SecCode = 4943250 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4956712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689480, ExchCode = 'FRA' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887686666, PermQuoteStatus = 'AC', Ticker = 'WATT', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4969407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888704331, ExchCode = 'GTX' WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902368752, ExchCode = 'STU' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740549, ExchCode = 'LAS' WHERE SecCode = 4973342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889561153, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4980098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212169, ExchCode = 'MEX' WHERE SecCode = 4980103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980198448, ExchCode = 'FRA' WHERE SecCode = 5011657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387447, ExchCode = 'LAS' WHERE SecCode = 5011663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387449, ExchCode = 'LAS' WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805995535, ExchCode = 'FRA' WHERE SecCode = 5031899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153246013, ExchCode = 'BTE' WHERE SecCode = 5038692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976743, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5042969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907031229, ExchCode = 'STU' WHERE SecCode = 5067269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381619, ExchCode = 'LAS' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012676, Ticker = '2KDP' WHERE SecCode = 5107765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781637018, ExchCode = 'HAM' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923404247, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-21' WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912121144, ExchCode = 'FRA' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951945.0 WHERE SecCode = 5135962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915977241, ExchCode = 'DEU' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727380482, Ticker = 'NAQ', ExchCode = 'BRN' WHERE SecCode = 5144089 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 5152268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430438, ExchCode = 'DEU' WHERE SecCode = 5153443 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 = 21794279503, Ticker = '0A60', ExchCode = 'LSE' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758567887, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730598077, ExchCode = 'FRA' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-23' WHERE SecCode = 5161345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793473649, ExchCode = 'BTE' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827095404, ExchCode = 'MXQ' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550581300, ExchCode = 'TDG' WHERE SecCode = 5161404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569896, ExchCode = 'QTX' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642019, ExchCode = 'QTX' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-21' WHERE SecCode = 5168280 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 5174435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659585, ExchCode = 'LAS' 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 = 21936132706, ExchCode = 'FRA' WHERE SecCode = 5218830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801543852, ExchCode = 'HAM' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794004180, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779328331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026953, Ticker = '1FEY2' WHERE SecCode = 5258602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027114, Ticker = '1FDO' WHERE SecCode = 5258603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027113, Ticker = '1CVA' WHERE SecCode = 5258605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026773, Ticker = '1CYTH' WHERE SecCode = 5258609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027115, Ticker = '1USX1' WHERE SecCode = 5258612 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751536, ExchCode = 'QTX' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935009046, ExchCode = 'DEU' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938340072, ExchCode = 'STU' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851306, ExchCode = 'LAS' WHERE SecCode = 5281346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107112, ExchCode = 'BIV' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935872308, Ticker = '750740', ExchCode = 'BSE' WHERE SecCode = 5290241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780979391, ExchCode = 'QTX' WHERE SecCode = 5290322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380705, ExchCode = 'LAS' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949478319, ExchCode = 'FRA' WHERE SecCode = 5338742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791510353, ExchCode = 'MUN' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633841, ExchCode = 'FRA' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952832311, ExchCode = 'STU' WHERE SecCode = 5347429 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 5360821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544723, ExchCode = 'QTX' WHERE SecCode = 5381858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520284, ExchCode = 'QTX' WHERE SecCode = 5381859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960776852, ExchCode = 'GTX' WHERE SecCode = 5381860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380714, ExchCode = 'LAS' WHERE SecCode = 5381861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776581953, ExchCode = 'BIV' WHERE SecCode = 5381916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727195025, ExchCode = 'MEX' WHERE SecCode = 5381947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716964, ExchCode = 'DEU' WHERE SecCode = 5383598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535822, ExchCode = 'BIV' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380717, ExchCode = 'LAS' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792996696, ExchCode = 'LAS' WHERE SecCode = 5403242 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 5415160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535809, ExchCode = 'BIV' WHERE SecCode = 5416155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416441, ExchCode = 'MEX' WHERE SecCode = 5417748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107116, ExchCode = 'MEX' WHERE SecCode = 5430834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171621, ExchCode = 'BIV' WHERE SecCode = 5443497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777360221, ExchCode = 'BIV' WHERE SecCode = 5449618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776268322, ExchCode = 'BIV' WHERE SecCode = 5455239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778108785, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5457242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21976165300, ExchCode = 'DEU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 5463054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779165176, ExchCode = 'STU' WHERE SecCode = 5476926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776850453, ExchCode = 'BIV' WHERE SecCode = 5482838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789434588, ExchCode = 'LAS' WHERE SecCode = 5493663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528245, ExchCode = 'STU' WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836119, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836104, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5506501 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 5517580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781813986, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5521928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794769077, ExchCode = 'LAS' WHERE SecCode = 5523278 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 5527524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535820, ExchCode = 'BIV' WHERE SecCode = 5539536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777360208, ExchCode = 'BIV' WHERE SecCode = 5541703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779515511, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5541732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776857975, ExchCode = 'BIV' WHERE SecCode = 5551974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608956, ExchCode = 'FRA' WHERE SecCode = 5551977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21995078680, ExchCode = 'DEU' WHERE SecCode = 5563110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828704528, Ticker = 'FANG', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5569236 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 = 236779927385, ExchCode = 'BIV' WHERE SecCode = 5574878 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 5590335 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 5620315 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 5623990 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 5632189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780880115, ExchCode = 'HAM', PermQuoteRetireDate = '2024-01-19' WHERE SecCode = 5633493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910569139, ExchCode = 'CHJ', PermQuoteRetireDate = '2025-09-04' WHERE SecCode = 5638831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460790, ExchCode = 'GER' WHERE SecCode = 5638838 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460803, ExchCode = 'GER' WHERE SecCode = 5638843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803622939, Ticker = 'TS2S', ExchCode = 'LSE' WHERE SecCode = 5638844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917830325, ExchCode = 'GER' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 5644510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954864, ExchCode = 'LAS' WHERE SecCode = 5655040 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 5658289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781580967, ExchCode = 'STU' WHERE SecCode = 5663580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863949657 WHERE SecCode = 5674188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782376739, ExchCode = 'FRA' WHERE SecCode = 5712413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782489860, Ticker = '1HENS' WHERE SecCode = 5720895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758336, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5740527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783112234, ExchCode = 'FRA' WHERE SecCode = 5764130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914265, Ticker = 'RZ8B', ExchCode = 'STU' WHERE SecCode = 5782810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040671244, ExchCode = 'MUN' WHERE SecCode = 5785805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783330017, ExchCode = 'FRA' WHERE SecCode = 5786123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329733, ExchCode = 'FRA' WHERE SecCode = 5786125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353647, ExchCode = 'FRA' WHERE SecCode = 5786132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353632, ExchCode = 'FRA' WHERE SecCode = 5786133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353639, ExchCode = 'FRA' WHERE SecCode = 5786134 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951844.0 WHERE SecCode = 5798224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551903, ExchCode = 'TDG' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 5848707 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-22', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 5857697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785217080, ExchCode = 'STU' WHERE SecCode = 5871394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801352002, ExchCode = 'GTX' WHERE SecCode = 5894957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025933, ExchCode = 'LAS' WHERE SecCode = 5907872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784888214, ExchCode = 'BIV' WHERE SecCode = 5907884 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5920829 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5920830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795664145, ExchCode = 'BIV' WHERE SecCode = 6014420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945886900, ExchCode = 'GTX' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380561, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836167, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823825, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329758, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 6097431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086925583, ExchCode = 'MUN' WHERE SecCode = 6104636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22087849922, ExchCode = 'DEU' WHERE SecCode = 6139879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790573154, ExchCode = 'FRA' WHERE SecCode = 6139935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790573152, ExchCode = 'FRA' WHERE SecCode = 6139937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790573156, ExchCode = 'FRA' WHERE SecCode = 6139938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790573153, ExchCode = 'FRA' WHERE SecCode = 6139939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790573150, ExchCode = 'FRA' WHERE SecCode = 6141518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790792402, ExchCode = 'FRA' WHERE SecCode = 6155958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026853, Ticker = '1PLTR' WHERE SecCode = 6185541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22093081351, ExchCode = 'DEU' WHERE SecCode = 6186428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791287038, ExchCode = 'FRA' WHERE SecCode = 6190705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791316273, ExchCode = 'FRA' WHERE SecCode = 6197566 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 6205878 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 6213108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823991, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792173202, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6260557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101769, Ticker = '1FASTm', ExchCode = 'BCO' WHERE SecCode = 6264098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101767, Ticker = '1FICOm', ExchCode = 'BCO' WHERE SecCode = 6264100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101768, Ticker = '1SEZLm', ExchCode = 'BCO' WHERE SecCode = 6264245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269530, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 6269028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792269527, ExchCode = 'HAM' WHERE SecCode = 6269033 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 6278579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796366874, ExchCode = 'TDG' WHERE SecCode = 6285539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792988748, ExchCode = 'MUN' WHERE SecCode = 6310651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22110907760, ExchCode = 'STO' WHERE SecCode = 6324051 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 6331876 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 6333951 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6334010 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6336169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793855803, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 6347434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887551041, ExchCode = 'MUN' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823056707, ExchCode = 'STU' WHERE SecCode = 6364834 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 = 236793855800, ExchCode = 'TDG' WHERE SecCode = 6368981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866542, ExchCode = 'BIV' WHERE SecCode = 6375353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793934516, ExchCode = 'DUS' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 6383731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794188795, ExchCode = 'DUS' WHERE SecCode = 6392491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121546541, ExchCode = 'DEU' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125348556, ExchCode = 'DEU' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795246905, ExchCode = 'FRA' WHERE SecCode = 6443223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795294193, ExchCode = 'FRA' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795294192, ExchCode = 'FRA' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6450893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128134015, ExchCode = 'DUS' WHERE SecCode = 6457998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438835, ExchCode = 'ASX' WHERE SecCode = 6480251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438808, ExchCode = 'TDG' WHERE SecCode = 6480271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131538896, ExchCode = 'DEU' WHERE SecCode = 6480272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796439130, ExchCode = 'MEX' WHERE SecCode = 6480273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438942, ExchCode = 'TDG' WHERE SecCode = 6480274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796466809, ExchCode = 'FRA' WHERE SecCode = 6480324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796467310, ExchCode = 'FRA' WHERE SecCode = 6480325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796466918, ExchCode = 'FRA' WHERE SecCode = 6480326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796467786, ExchCode = 'QTX' WHERE SecCode = 6480327 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 = 236797155417, ExchCode = 'MUN' WHERE SecCode = 6495428 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797407379, ExchCode = 'MUN' WHERE SecCode = 6495429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109805, ExchCode = 'DUS' WHERE SecCode = 6501107 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 6509307 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 6513188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746059, ExchCode = 'DUS' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794669394, ExchCode = 'BIV' WHERE SecCode = 6543895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798768097, ExchCode = 'DUS' WHERE SecCode = 6548155 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 6569460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143843399, ExchCode = 'DEU' WHERE SecCode = 6577960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101771, Ticker = 'MAz', ExchCode = 'BCO' WHERE SecCode = 6578406 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 6583651 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6583797 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 6583818 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 6603580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22135602762, ExchCode = 'GTX' WHERE SecCode = 6617649 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6622353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451443, ExchCode = 'BCO' WHERE SecCode = 6627463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801543940, ExchCode = 'HAM' WHERE SecCode = 6628842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22155220901, ExchCode = 'DEU' WHERE SecCode = 6629415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156552523, ExchCode = 'STU' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471032, ExchCode = 'FRA' WHERE SecCode = 6638341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802540440, ExchCode = 'FRA' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22157135278, ExchCode = 'DEU' WHERE SecCode = 6642930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802807019, ExchCode = 'MEX' WHERE SecCode = 6664680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914563, ExchCode = 'FRA' WHERE SecCode = 6664705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47763436106, ExchCode = 'DEU' WHERE SecCode = 6664706 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914867, ExchCode = 'FRA' WHERE SecCode = 6664707 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951945.0 WHERE SecCode = 6678530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101752, Ticker = 'CYBRn', ExchCode = 'BCO' WHERE SecCode = 6681099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161742060, ExchCode = 'DEU' WHERE SecCode = 6691979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22162720064, ExchCode = 'DEU' WHERE SecCode = 6692049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22162715613, ExchCode = 'DEU' WHERE SecCode = 6692050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22162715717, ExchCode = 'DEU' WHERE SecCode = 6692051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803385260, ExchCode = 'TDG' WHERE SecCode = 6694389 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951893.0 WHERE SecCode = 6710027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165018416, ExchCode = 'DUS' WHERE SecCode = 6710093 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-22' WHERE SecCode = 6719038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804778699, ExchCode = 'GTX' WHERE SecCode = 6721535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784382055, ExchCode = 'LAS' WHERE SecCode = 6724297 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-22' WHERE SecCode = 6724322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175074093, ExchCode = 'STU' WHERE SecCode = 6727919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175073961, ExchCode = 'STU' WHERE SecCode = 6727920 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536844, ExchCode = 'FRA' WHERE SecCode = 6728367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536839, ExchCode = 'FRA' WHERE SecCode = 6728368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536834, ExchCode = 'FRA' WHERE SecCode = 6728370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536841, ExchCode = 'FRA' WHERE SecCode = 6728371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536846, ExchCode = 'FRA' WHERE SecCode = 6728372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536845, ExchCode = 'FRA' WHERE SecCode = 6728373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536945, ExchCode = 'FRA' WHERE SecCode = 6728374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536835, ExchCode = 'FRA' WHERE SecCode = 6728375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536836, ExchCode = 'FRA' WHERE SecCode = 6728377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536831, ExchCode = 'FRA' WHERE SecCode = 6728378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799175957, ExchCode = 'MEX' WHERE SecCode = 6728383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167303875, ExchCode = 'DUS' WHERE SecCode = 6728389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804483784, ExchCode = 'STU' WHERE SecCode = 6728400 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-23' WHERE SecCode = 6737976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168877362, ExchCode = 'DEU' WHERE SecCode = 6741050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168913655, ExchCode = 'DEU' WHERE SecCode = 6741051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168913266, ExchCode = 'DEU' WHERE SecCode = 6741052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168913300, ExchCode = 'DEU' WHERE SecCode = 6741053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168913534, ExchCode = 'DEU' WHERE SecCode = 6741055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795337293, ExchCode = 'BIV' WHERE SecCode = 6741058 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-23' WHERE SecCode = 6748910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699530, ExchCode = 'MEX' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805162154, ExchCode = 'FRA' WHERE SecCode = 6755756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805162199, ExchCode = 'FRA' WHERE SecCode = 6755757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805162200, ExchCode = 'FRA' WHERE SecCode = 6755758 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-22', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 6769161 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-23' WHERE SecCode = 6773060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172382097, ExchCode = 'DEU' WHERE SecCode = 6779510 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-23' WHERE SecCode = 6782578 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-22', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 6789478 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 6789603 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 6793367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174126934, ExchCode = 'DEU' WHERE SecCode = 6793382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805902026, ExchCode = 'FRA' WHERE SecCode = 6793389 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-22', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 6796779 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 10771857 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'IMN' WHERE SecCode = 10891426 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10906610 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 10925875 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 10964860 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10972466 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10986798 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'SGP', IncCntry = 'SGP' WHERE SecCode = 10987202 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 11051803 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 11052831 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11059253 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805847727, Ticker = 'PDI', ExchCode = 'CXX', PermSecMapStartDate = '2026-04-17' WHERE SecCode = 11059865 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951244.0 WHERE SecCode = 11061419 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'SGP', IncCntry = 'SGP' WHERE SecCode = 11132846 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11156632 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 11161916 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11165638 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'SGP', IncCntry = 'SGP' WHERE SecCode = 11177762 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727418467, PermQuoteStatus = 'AC', Ticker = 'SOHOO', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2017-10-11', PermSecMapEndDate = NULL WHERE SecCode = 11177805 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11184214 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11185713 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727374905, PermQuoteStatus = 'AC', Ticker = 'SOHON', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2019-04-12', PermSecMapEndDate = NULL WHERE SecCode = 11195911 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-22', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 11198932 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11211470 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951697.0 WHERE SecCode = 11220026 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951697.0 WHERE SecCode = 11223114 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'CHMMD' WHERE SecCode = 11226685 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 11231386 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 11243696 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 11253322 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951592.0 WHERE SecCode = 11263390 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 11268687 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11278234 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951770.0 WHERE SecCode = 11285696 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 11290884 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 11290885 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 11290886 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 11290887 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-22' WHERE SecCode = 11290888 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11294697 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11294698 AND Type_ = 1;
