UPDATE data_universe_permid SET QuotePermID = 55836047499, Ticker = 'AAT', ExchCode = 'LSE', PermQuoteRetireDate = '2012-11-12' WHERE SecCode = 13 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 9321 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'CFNBD' WHERE SecCode = 11748 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 13060 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 13061 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 18369 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 27902 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0, IsPrimaryInstr = 0 WHERE SecCode = 28602 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0, IsPrimaryInstr = 1 WHERE SecCode = 28624 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 30185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358466, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 34155 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-11' WHERE SecCode = 35592 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836330930, ExchCode = 'BER', PermQuoteRetireDate = '2023-09-21' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469912, ExchCode = 'QTX' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 37680 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836334267, ExchCode = 'BER', PermQuoteRetireDate = '2019-04-17' WHERE SecCode = 38580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475608783, ExchCode = 'GER', PermQuoteRetireDate = '2010-03-05' WHERE SecCode = 38608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331050, ExchCode = 'BER' WHERE SecCode = 38610 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 42546 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 44800 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ALPVL' WHERE SecCode = 45232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836496377, ExchCode = 'FRA' WHERE SecCode = 46302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531592, ExchCode = 'FRA' WHERE SecCode = 46521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616156912, ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399711, ExchCode = 'FRA', PermQuoteRetireDate = '2010-05-03' WHERE SecCode = 47291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475576317, ExchCode = 'STU', PermQuoteRetireDate = '2008-01-07' WHERE SecCode = 54284 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 54521 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 55440 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 57755 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 = 236782196283, ExchCode = 'QTX' WHERE SecCode = 60024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475457930, Ticker = 'VTDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-05-23' WHERE SecCode = 60090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374661, ExchCode = 'DEU' WHERE SecCode = 61355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339451, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223877, ExchCode = 'QTX' WHERE SecCode = 63011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333924, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63016 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 65836 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SHOE' WHERE SecCode = 69532 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ATH' WHERE SecCode = 75379 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0, IsPrimaryInstr = 1 WHERE SecCode = 86977 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0, IsPrimaryInstr = 1 WHERE SecCode = 86978 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 89348 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'JUN.A' WHERE SecCode = 97343 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21656727011, ExchCode = 'STU' WHERE SecCode = 111811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144559499, ExchCode = 'DEU' WHERE SecCode = 114475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541115118, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 114476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805995522, ExchCode = 'FRA' WHERE SecCode = 114496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21485225160, ExchCode = 'STU', PermQuoteRetireDate = '2024-06-27', PermSecMapEndDate = '2024-06-27' WHERE SecCode = 114758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21626522639, ExchCode = 'STU' WHERE SecCode = 114759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836430625, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-20' WHERE SecCode = 114828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337680, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 114831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288989, ExchCode = 'GTX' WHERE SecCode = 114833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838236737, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 114837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331367, ExchCode = 'BER', PermQuoteRetireDate = '2024-04-03' WHERE SecCode = 114840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334482, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 114845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332480, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 114850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838242354, ExchCode = 'MUN' WHERE SecCode = 114852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788378180, ExchCode = 'FRA' WHERE SecCode = 114853 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 117055 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951781.0 WHERE SecCode = 122591 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666123478, ExchCode = 'DEU' WHERE SecCode = 126859 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 134044 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 141076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540736583, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513441597, ExchCode = 'STU' WHERE SecCode = 147511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334422, ExchCode = 'BER' WHERE SecCode = 147516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836488434, ExchCode = 'FRA', PermQuoteRetireDate = '2012-02-28' WHERE SecCode = 147518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845062901, ExchCode = 'STU', PermQuoteRetireDate = '2024-12-05', PermSecMapEndDate = NULL WHERE SecCode = 147523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550781966, ExchCode = 'TDG' WHERE SecCode = 147524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22087215782, ExchCode = 'DEU' WHERE SecCode = 147554 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 147711 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0, IsPrimaryInstr = 1 WHERE SecCode = 164341 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0, IsPrimaryInstr = 0 WHERE SecCode = 164342 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 171749 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0, IsPrimaryInstr = 1 WHERE SecCode = 201922 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0, IsPrimaryInstr = 0 WHERE SecCode = 201923 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYP' WHERE SecCode = 223207 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 243444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808273309, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 249716 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 317486 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 349874 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'GRAT.H', ExchCode = 'NEX' WHERE SecCode = 351150 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836348908, ExchCode = 'FRA' WHERE SecCode = 353324 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 391197 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 392099 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 511898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307223, ExchCode = 'MEX' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547316142, ExchCode = 'STU' WHERE SecCode = 548626 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 575470 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 593104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255778, ExchCode = 'FRA', PermQuoteRetireDate = '2012-05-07' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22157401812, ExchCode = 'DEU' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475858943, ExchCode = 'BTE', PermQuoteRetireDate = '2023-12-20' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808392960, Ticker = 'XBLCm', ExchCode = 'BTE' WHERE SecCode = 737768 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 940796 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 1011917 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 1012045 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 1012112 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 1012242 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 1037726 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 1037730 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 1149727 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 = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22176932253, ExchCode = 'DEU' WHERE SecCode = 1622873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512412458, Ticker = 'CTY1SN011', ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511262189, ExchCode = 'DEU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907733, ExchCode = 'FRA' WHERE SecCode = 1733285 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951252.0 WHERE SecCode = 1931452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704166, ExchCode = 'MXQ' WHERE SecCode = 2014210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387857, ExchCode = 'LAS' WHERE SecCode = 2039989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788111815, ExchCode = 'FRA' WHERE SecCode = 2042837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802863785, ExchCode = 'FRA' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814536775, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-21' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519498812, ExchCode = 'DEU' WHERE SecCode = 2115211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607386, ExchCode = 'QTX' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947457, ExchCode = 'FRA' WHERE SecCode = 2142278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112547, ExchCode = 'DUS' WHERE SecCode = 2195754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531116946, ExchCode = 'BCO', PermQuoteRetireDate = '2024-07-03' WHERE SecCode = 2195912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538154, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2221995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522133570, ExchCode = 'STU' WHERE SecCode = 2222349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474891021, Ticker = '4KPN', ExchCode = 'ETX' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834226, ExchCode = 'DEU' WHERE SecCode = 2225286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604521803, Ticker = '4BB', ExchCode = 'MUN', PermQuoteRetireDate = '2019-01-10' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750324218, ExchCode = 'DEU' WHERE SecCode = 2232877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782890682, ExchCode = 'STU' WHERE SecCode = 2239280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523563646, ExchCode = 'DEU' WHERE SecCode = 2239343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524199496, ExchCode = 'DEU' WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789017062, ExchCode = 'DUS' WHERE SecCode = 2246863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869920397, ExchCode = 'MUN' WHERE SecCode = 2255684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652141579, ExchCode = 'EQD' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539606835, ExchCode = 'DUS' WHERE SecCode = 2278227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967852, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2278243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967851, ExchCode = 'MUN' WHERE SecCode = 2278244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723974163, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-10-17' WHERE SecCode = 2332152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670714959, ExchCode = 'TDG' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520237, ExchCode = 'QTX' WHERE SecCode = 2339259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704580, ExchCode = 'MXQ' WHERE SecCode = 2359427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530098344, ExchCode = 'FRA' WHERE SecCode = 2362509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807341682, ExchCode = 'OCE' WHERE SecCode = 2365610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419067, ExchCode = 'LAS' WHERE SecCode = 2377960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21779363674, ExchCode = 'FRA' WHERE SecCode = 2379809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531377381, ExchCode = 'DEU' WHERE SecCode = 2381665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531721248, InstrPermID = 8590005814, OrgPermID = 4295915565, ValQuotePermID = 55838797234.0, PriInstrPermID = 8590005814.0, PermInstrStatus = 'DC', Ticker = '56A', ExchCode = 'BER', QuoteClass = 'ORD', InstrClass = 'ORD', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951348.0, PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2020-09-09' WHERE SecCode = 2387360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536966570, ExchCode = 'STU' WHERE SecCode = 2391345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538722817, ExchCode = 'STU' WHERE SecCode = 2391351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803110077, ExchCode = 'FRA' WHERE SecCode = 2391353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532122979, ExchCode = 'STU' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542388488, PermQuoteStatus = 'DC', Ticker = 'GKO0', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 2397376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620411353, ExchCode = 'STU' WHERE SecCode = 2397377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535281436, ExchCode = 'STU' WHERE SecCode = 2403143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535117810, ExchCode = 'BEC' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384965, ExchCode = 'LAS' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297989, ExchCode = 'DUS' WHERE SecCode = 2453131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842579738, ExchCode = 'BER' WHERE SecCode = 2458822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787783, ExchCode = 'DUS' WHERE SecCode = 2462633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535492269, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 2466348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536043370, ExchCode = 'FRA' WHERE SecCode = 2467266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780660022, ExchCode = 'TDG' WHERE SecCode = 2479012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537032595, ExchCode = 'BER' WHERE SecCode = 2495669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555767, ExchCode = 'FRA' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181315008, ExchCode = 'OCE' WHERE SecCode = 2510129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134690, ExchCode = 'DEU' WHERE SecCode = 2513070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430820, ExchCode = 'DEU' WHERE SecCode = 2513107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641549, ExchCode = 'DUS' WHERE SecCode = 2515738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551088336, ExchCode = 'FRA' WHERE SecCode = 2519534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851779770, ExchCode = 'MUN', PermQuoteRetireDate = '2022-04-12', PermSecMapEndDate = '2022-04-12' WHERE SecCode = 2519541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806101512, ExchCode = 'FRA' 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 = 21475000070, Ticker = 'PREVIS-OSA', ExchCode = 'SGO' WHERE SecCode = 2524756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367747, ExchCode = 'BEC' WHERE SecCode = 2524779 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 PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 2529649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294325, ExchCode = 'GTX' WHERE SecCode = 2536886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540230612, ExchCode = 'DEU' WHERE SecCode = 2542459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103484, ExchCode = 'FRA' WHERE SecCode = 2554904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378777, ExchCode = 'MUN' WHERE SecCode = 2554953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478415, ExchCode = 'QTX' WHERE SecCode = 2556599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731262060, ExchCode = 'BER' WHERE SecCode = 2556600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550101775, ExchCode = 'FRA' WHERE SecCode = 2559800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792808948, ExchCode = 'FRA' WHERE SecCode = 2568912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542768665, ExchCode = 'MUN' WHERE SecCode = 2572311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705735, ExchCode = 'MXQ' WHERE SecCode = 2572313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705667, ExchCode = 'MXQ' WHERE SecCode = 2572314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705247, ExchCode = 'MXQ' WHERE SecCode = 2572315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704187, ExchCode = 'MXQ' WHERE SecCode = 2572318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705290, Ticker = 'LINN', ExchCode = 'MXQ' WHERE SecCode = 2572322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543101908, ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13' WHERE SecCode = 2579445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550101787, ExchCode = 'FRA' WHERE SecCode = 2579447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181314867, ExchCode = 'OCE' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792941413, ExchCode = 'FRA' WHERE SecCode = 2591696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629958117, ExchCode = 'TDG' WHERE SecCode = 2599304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670880, ExchCode = 'AUX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067641975, ExchCode = 'CHI' WHERE SecCode = 2600378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384980, ExchCode = 'LAS' WHERE SecCode = 2617118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374749, ExchCode = 'DEU' WHERE SecCode = 2621782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846693416, PermQuoteStatus = 'DC', Ticker = '14S', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-04' WHERE SecCode = 2625801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722349014, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 2627627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548012753, ExchCode = 'DEU' WHERE SecCode = 2640373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782381281, ExchCode = 'QTX' WHERE SecCode = 2642446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538237, ExchCode = 'GTX' WHERE SecCode = 2642455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109507, ExchCode = 'FRA', PermQuoteRetireDate = '2018-06-11' WHERE SecCode = 2643269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288297, ExchCode = 'GTX' WHERE SecCode = 2644157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548204121, ExchCode = 'FRA' WHERE SecCode = 2644168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840146, ExchCode = 'FRA' WHERE SecCode = 2649167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840232, ExchCode = 'FRA' WHERE SecCode = 2655948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549921085, ExchCode = 'CHI' WHERE SecCode = 2665921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379555, Ticker = 'HCL', ExchCode = 'BRN' WHERE SecCode = 2682233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550459903, ExchCode = 'DEU' WHERE SecCode = 2682326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605933864, ExchCode = 'MUN' WHERE SecCode = 2698369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551920812, ExchCode = 'MUN' WHERE SecCode = 2700708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552008104, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2711155 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 QuotePermID = 236799954950, InstrPermID = 8590932786, OrgPermID = 4295893865, ValQuotePermID = 55836043261.0, PriInstrPermID = 8590932786.0, PermQuoteStatus = 'AC', Ticker = 'FVQ1', ExchCode = 'LAS', OrgTypeCode = 'COM', DomCntry = 'GBR', IncCntry = 'GBR', PriTRBCIndPermID = 4294951361.0, PermQuoteRetireDate = NULL, PermOrgIPODate = '2000-12-06' WHERE SecCode = 2718429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552507986, Ticker = 'SRE', ExchCode = 'JNB' WHERE SecCode = 2718458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552464621, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 2718461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553012298, ExchCode = 'FRA' WHERE SecCode = 2718469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273765, PermQuoteStatus = 'AC', Ticker = '5WP0', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673120, ExchCode = 'BIV' WHERE SecCode = 2743609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789017040, ExchCode = 'DUS' WHERE SecCode = 2747510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198716, ExchCode = 'MEX' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554504075, ExchCode = 'FRA' WHERE SecCode = 2750981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555271601, ExchCode = 'FRA' WHERE SecCode = 2764597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790104617, ExchCode = 'QTX' WHERE SecCode = 2764598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557191633, ExchCode = 'BER' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322234, Ticker = 'IDV1', ExchCode = 'FRA' WHERE SecCode = 2812145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322223, ExchCode = 'FRA' WHERE SecCode = 2812146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558551421, ExchCode = 'DEU' WHERE SecCode = 2827908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558758041, ExchCode = 'FRA' WHERE SecCode = 2830909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274949, ExchCode = 'GTX' WHERE SecCode = 2855817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563865313, ExchCode = 'DEU' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486519, ExchCode = 'BIV' WHERE SecCode = 2870132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561797862, ExchCode = 'FRA' WHERE SecCode = 2872657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732998267, Ticker = 'A2PL', ExchCode = 'QTX', PermQuoteRetireDate = '2021-06-09' WHERE SecCode = 2872658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137724, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-02' WHERE SecCode = 2873688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619609060, ExchCode = 'MUN' WHERE SecCode = 2887282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562944846, ExchCode = 'FRA' WHERE SecCode = 2887317 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563124035, ExchCode = 'FRA' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615434298, Ticker = 'SX7EEz', ExchCode = 'BCO' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943057400, ExchCode = 'STU' WHERE SecCode = 2906394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565633193, ExchCode = 'STU' WHERE SecCode = 2907243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644687444, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL 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 = 21564939250, ExchCode = 'DEU' WHERE SecCode = 2909242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808951032, ExchCode = 'FRA' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609211564, Ticker = '34LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-21', PermSecMapEndDate = NULL WHERE SecCode = 2935091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184797997, ExchCode = 'LAS' WHERE SecCode = 2935962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569155612, ExchCode = 'STU' WHERE SecCode = 2947855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836510352, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-16' WHERE SecCode = 2947875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778891239, ExchCode = 'STU' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645305996, ExchCode = 'FRA' WHERE SecCode = 2955208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570595729, ExchCode = 'DEU' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851158658, ExchCode = 'DEU' WHERE SecCode = 2975172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787393, ExchCode = 'DUS' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687895439, ExchCode = 'STU' WHERE SecCode = 3008027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286312, ExchCode = 'GTX' WHERE SecCode = 3026614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576625962, ExchCode = 'FRA' WHERE SecCode = 3026615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885152284, ExchCode = 'STU' WHERE SecCode = 3031579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818952836, ExchCode = 'DUS' WHERE SecCode = 3045201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750433751, ExchCode = 'STU' WHERE SecCode = 3055016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386888, ExchCode = 'LAS' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991744, ExchCode = 'DEU' WHERE SecCode = 3074354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700996629, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3083484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597186085, ExchCode = 'FRA' WHERE SecCode = 3090270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264715, ExchCode = 'MUN', PermQuoteRetireDate = '2022-03-15', PermSecMapEndDate = NULL WHERE SecCode = 3090272 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-11' WHERE SecCode = 3099396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779496553, ExchCode = 'GTX' WHERE SecCode = 3120784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794739726, ExchCode = 'FRA' WHERE SecCode = 3124127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077935, ExchCode = 'LAS' WHERE SecCode = 3124235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320104, ExchCode = 'FRA' WHERE SecCode = 3124241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285715, ExchCode = 'DUS' WHERE SecCode = 3160205 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077947, ExchCode = 'LAS' WHERE SecCode = 3160206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790760, ExchCode = 'GTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587934131, ExchCode = 'FRA' WHERE SecCode = 3172332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658137738, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3183538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769880745, ExchCode = 'FRA' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597107042, ExchCode = 'FRA', PermQuoteRetireDate = '2024-07-01' WHERE SecCode = 3237127 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-12', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 3245596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636051429, ExchCode = 'CHI' WHERE SecCode = 3246406 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 3247395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597328149, ExchCode = 'MUN' WHERE SecCode = 3255527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647013837, ExchCode = 'BCO' WHERE SecCode = 3275560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601639661, ExchCode = 'TDG' WHERE SecCode = 3277475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604748306, ExchCode = 'FRA' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609616, ExchCode = 'DUS' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609137333, ExchCode = 'DEU' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679409, ExchCode = 'BIV' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685841805, ExchCode = 'STU' WHERE SecCode = 3317931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489849, ExchCode = 'QTX' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645775, ExchCode = 'FRA' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133418, ExchCode = 'FRA' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610513041, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448965, ExchCode = 'DEU' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705691, Ticker = 'SMIN', ExchCode = 'MXQ' WHERE SecCode = 3327117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864390169, ExchCode = 'MUN' WHERE SecCode = 3337692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620456907, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3338477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690196163, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 21898477060.0 WHERE SecCode = 3339539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890669874, ExchCode = 'MUN' WHERE SecCode = 3346903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615298321, ExchCode = 'TRQ' WHERE SecCode = 3358414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761303085, ExchCode = 'STU' WHERE SecCode = 3358616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050419, ExchCode = 'DEU' WHERE SecCode = 3359272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616850045, Ticker = '14G0', ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-31' WHERE SecCode = 3366981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743475404, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3378582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624691050, Ticker = '2META', ExchCode = 'MIL' WHERE SecCode = 3401441 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 = 21816905223, PermQuoteStatus = 'DC', Ticker = 'S06', ExchCode = 'TDG', PermQuoteRetireDate = '2023-10-13' WHERE SecCode = 3406028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796757245, ExchCode = 'FRA' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630755583, ExchCode = 'STU', PermQuoteRetireDate = '2020-02-25' WHERE SecCode = 3408843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679932, ExchCode = 'BIV' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630022342, ExchCode = 'STU' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805162201, ExchCode = 'FRA' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633327894, ExchCode = 'STU' WHERE SecCode = 3409091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 3431773 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 3432606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997875, ExchCode = 'FRA' WHERE SecCode = 3439465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679515, ExchCode = 'BIV' WHERE SecCode = 3439528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673859, ExchCode = 'BIV' WHERE SecCode = 3439529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788404566, ExchCode = 'QTX' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640560144, ExchCode = 'DEU' WHERE SecCode = 3439542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186303, ExchCode = 'DEU' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569555, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3446753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647430161, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649268603, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647633189, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3491217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651518719, ExchCode = 'BER' WHERE SecCode = 3518265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645825, ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-01', PermSecMapEndDate = '2025-09-01' WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799956241, InstrPermID = 8590940137, OrgPermID = 4295898939, ValQuotePermID = 55836051280.0, PriInstrPermID = 8590940137.0, Ticker = 'A1Z1', ExchCode = 'LAS', PriTRBCIndPermID = 4294951812.0, PermOrgIPODate = '2005-04-04' WHERE SecCode = 3529090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753145831, ExchCode = 'BCO' WHERE SecCode = 3547843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663166737, ExchCode = 'DEU' WHERE SecCode = 3550423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872575770, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3553157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058710, ExchCode = 'FRA' WHERE SecCode = 3555050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661179149, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878957446, ExchCode = 'SIG', PermQuoteRetireDate = '2023-09-23' WHERE SecCode = 3601109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21665422440, Ticker = 'NBPU', ExchCode = 'LSE' WHERE SecCode = 3616805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308437, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099419588, Ticker = '2NFLl', ExchCode = 'BTE' WHERE SecCode = 3669927 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 3675728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812659612, ExchCode = 'QTX' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 3721197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682584419, ExchCode = 'FRA' WHERE SecCode = 3769372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780314322, ExchCode = 'GTX' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21692561684, ExchCode = 'DEU' WHERE SecCode = 3818674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918923, ExchCode = 'FRA' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371260, ExchCode = 'MEX' WHERE SecCode = 3851577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703553666, ExchCode = 'DEU' WHERE SecCode = 3897396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209289, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710752190, ExchCode = 'FRA' WHERE SecCode = 3949028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363709, ExchCode = 'BIV' WHERE SecCode = 3966586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727363706, ExchCode = 'BIV' WHERE SecCode = 3966587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720001076, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 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 PriInstrPermID = 8590933020.0 WHERE SecCode = 4036674 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 4036675 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '3DADA', QuoteClass = 'CHESS', InstrClass = 'CHESS', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 4036738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077946, PermQuoteStatus = 'AC', Ticker = 'XBJR', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907558991, ExchCode = 'MUN' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 4201658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750154407, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-19' WHERE SecCode = 4228115 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '2AA0' WHERE SecCode = 4256650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756680510, ExchCode = 'MUN', PermQuoteRetireDate = '2020-07-03' WHERE SecCode = 4274159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360718, ExchCode = 'HAN' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112309, ExchCode = 'DEU' WHERE SecCode = 4328959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770634972, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377495, ExchCode = 'BIV' WHERE SecCode = 4417298 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 4426889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897784749, ExchCode = 'GTX' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796082418, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2021-10-13', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4487640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820703, ExchCode = 'DEU' WHERE SecCode = 4499152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811593352, ExchCode = 'QTX' WHERE SecCode = 4575120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811019112, ExchCode = 'TDG' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22076466680, Ticker = 'XLMEd', ExchCode = 'BCO' WHERE SecCode = 4579626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812848268, ExchCode = 'DEU' WHERE SecCode = 4590581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816245393, ExchCode = 'MUN' WHERE SecCode = 4601736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816477347, ExchCode = 'MUN' WHERE SecCode = 4609998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727263610, ExchCode = 'BIV' WHERE SecCode = 4610049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878863900, ExchCode = 'BCO' WHERE SecCode = 4617708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818266412, ExchCode = 'DEU' WHERE SecCode = 4617743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884462002, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821041967, PermQuoteStatus = 'AC', Ticker = '4KL0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4629496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821283375, ExchCode = 'FRA' WHERE SecCode = 4630664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21934228224, ExchCode = 'STU', PermQuoteRetireDate = '2025-02-07', PermSecMapEndDate = NULL WHERE SecCode = 4643054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815337201, ExchCode = 'FRA' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824693646, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4649878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828832812, ExchCode = 'STU' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954880, ExchCode = 'LAS', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = NULL WHERE SecCode = 4664716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833158985, ExchCode = 'DEU' WHERE SecCode = 4677605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795845914, Ticker = '9KK0', ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793284943, PermQuoteStatus = 'AC', Ticker = '94Y', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4682737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832850911, ExchCode = 'FRA' WHERE SecCode = 4689999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619187, ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845076965, Ticker = 'V96', ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = NULL WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842579647, ExchCode = 'MUN' WHERE SecCode = 4705895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845535652, ExchCode = 'FRA' WHERE SecCode = 4726104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845534968, ExchCode = 'MUN' WHERE SecCode = 4726105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845814031, ExchCode = 'HAM' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236808191556.0, ValQuotePermID = 25727395486.0 WHERE SecCode = 4733055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851158441, ExchCode = 'DEU' WHERE SecCode = 4748566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854409786, PermQuoteStatus = 'AC', Ticker = 'GSPl', ExchCode = 'TRQ', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4761540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854742271, ExchCode = 'DEU' WHERE SecCode = 4761587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854895784, ExchCode = 'FRA' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855114065, ExchCode = 'GTX' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858471109, ExchCode = 'DEU', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = '2025-06-17' WHERE SecCode = 4787454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618957147, ExchCode = 'FRA', PermQuoteRetireDate = '2023-05-12' WHERE SecCode = 4804834 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4806673 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4807562 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 4810073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862298482, ExchCode = 'DEU', PermQuoteRetireDate = '2026-02-10' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192887, ExchCode = 'DEU' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864000077, ExchCode = 'FRA' WHERE SecCode = 4823658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865590398, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4823660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866536829, ExchCode = 'STU' WHERE SecCode = 4823661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866160214, ExchCode = 'TDG' WHERE SecCode = 4823663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290739, ExchCode = 'MUN' WHERE SecCode = 4823664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897370, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4823669 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 21942062497.0 WHERE SecCode = 4825109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866536811, ExchCode = 'STU' WHERE SecCode = 4827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873923001, ExchCode = 'DUS' WHERE SecCode = 4830767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580216, ExchCode = 'DUS' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872586664, ExchCode = 'DEU' WHERE SecCode = 4873682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898654, ExchCode = 'FRA' WHERE SecCode = 4929498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883757511, PermQuoteStatus = 'DC', Ticker = '7U6', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4949680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, ExchCode = 'QTX' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716228, ExchCode = 'DEU' WHERE SecCode = 4960863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885992168, ExchCode = 'FRA' WHERE SecCode = 4960864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886409923, ExchCode = 'DEU' WHERE SecCode = 4965055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887564482, ExchCode = 'QTX' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072401492, ExchCode = 'DEU' WHERE SecCode = 5009346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209303, ExchCode = 'DEU' WHERE SecCode = 5059308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777464944, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5063516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779601759, ExchCode = 'STU' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716500, ExchCode = 'FRA' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416293, ExchCode = 'TDG' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913082644, ExchCode = 'BER' WHERE SecCode = 5129748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520648, ExchCode = 'DEU' WHERE SecCode = 5151167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273208, ExchCode = 'GTX' WHERE SecCode = 5161225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843186265, Ticker = '0A60l', ExchCode = 'BCO' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508528400, ExchCode = 'DEU' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730598077, ExchCode = 'FRA' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753424486, ExchCode = 'MUN' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792173203, ExchCode = 'FRA' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727308116, Ticker = 'WPMl', ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034611, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 5161351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387325, ExchCode = 'LAS' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924150711, ExchCode = 'STU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348366, ExchCode = 'MEX' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727360442, ExchCode = 'MEX' WHERE SecCode = 5161415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650207, ExchCode = 'DUS' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173433, ExchCode = 'BIV' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943651732, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921849641, ExchCode = 'FRA' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928045645, ExchCode = 'STU' WHERE SecCode = 5218830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930806960, ExchCode = 'DEU', PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 5220960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140088087, ExchCode = 'HAM' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173431, ExchCode = 'BIV' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727190993, ExchCode = 'BIV' WHERE SecCode = 5250998 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 = 21934228055, ExchCode = 'STU' WHERE SecCode = 5253711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933395668, ExchCode = 'FRA' WHERE SecCode = 5253712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933395608, ExchCode = 'FRA' WHERE SecCode = 5253715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751536, ExchCode = 'QTX' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935825325, ExchCode = 'TDG' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935008523, ExchCode = 'FRA' WHERE SecCode = 5261587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935906810, ExchCode = 'DEU' WHERE SecCode = 5265006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935906348, ExchCode = 'DEU' WHERE SecCode = 5265007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587852, ExchCode = 'QTX' WHERE SecCode = 5277530 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 21942062497.0 WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381676, ExchCode = 'LAS' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535810, ExchCode = 'MEX' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21964248992, ExchCode = 'DEU' WHERE SecCode = 5403084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874394, ExchCode = 'GTX' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812179638, ExchCode = 'DEU' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21990734878, ExchCode = 'QTX' WHERE SecCode = 5434328 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 5524305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151304, Ticker = '3FTE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5535000 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'VRTE' WHERE SecCode = 5540637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852456313, ExchCode = 'BRN' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837511990, Ticker = '2STSa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5638905 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'H7P0' WHERE SecCode = 5649739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072896303, ExchCode = 'TDG' WHERE SecCode = 5715993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772643122, ExchCode = 'FRA' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032608571, ExchCode = 'DEU' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032826044, ExchCode = 'DEU' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22032827411, ExchCode = 'DEU' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782994251, ExchCode = 'STU' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812186220, ExchCode = 'FRA' WHERE SecCode = 5760234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181310368, ExchCode = 'OCU' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784377679, ExchCode = 'STU' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784377678, ExchCode = 'FRA' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421390, ExchCode = 'BIV' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784890672, ExchCode = 'FRA' WHERE SecCode = 5857780 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5908827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571976516, ExchCode = 'BEC' WHERE SecCode = 6095641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083162878, ExchCode = 'DEU' WHERE SecCode = 6095673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370126, ExchCode = 'BEC' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682858978, ExchCode = 'FRA' WHERE SecCode = 6097372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354995, ExchCode = 'BIV' WHERE SecCode = 6097383 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 = 21917823888, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790283706, ExchCode = 'FRA' WHERE SecCode = 6119927 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 PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 6263937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549247, ExchCode = 'GTX' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866541, ExchCode = 'MEX' WHERE SecCode = 6375353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122894403, ExchCode = 'DEU' WHERE SecCode = 6418487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794652101, ExchCode = 'DUS' WHERE SecCode = 6418488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799042091, ExchCode = 'FRA' WHERE SecCode = 6418489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130904343, ExchCode = 'GTX' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794739725, ExchCode = 'FRA' WHERE SecCode = 6426995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795182771, ExchCode = 'FRA' WHERE SecCode = 6441867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795246905, ExchCode = 'FRA' WHERE SecCode = 6443223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795182992, ExchCode = 'FRA' WHERE SecCode = 6443261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802152101, ExchCode = 'TDG' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128281486, ExchCode = 'QTX' 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 PermSecMapEndDate = '2026-06-11' WHERE SecCode = 6474420 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'O6Q0' WHERE SecCode = 6478318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803716826, ExchCode = 'QTX' WHERE SecCode = 6490079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365452, ExchCode = 'DEU' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145080, ExchCode = 'DUS' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107740, ExchCode = 'FRA' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107743, ExchCode = 'FRA' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798598065, ExchCode = 'FRA' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-11' WHERE SecCode = 6569505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379902, Ticker = 'XS4', ExchCode = 'BRN' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903777191, ExchCode = 'HAN' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 6610302 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 6628800 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-11' WHERE SecCode = 6628841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 6632006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802540440, ExchCode = 'FRA' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6686029 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = NULL WHERE SecCode = 6705492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805095498, ExchCode = 'DUS' WHERE SecCode = 6753078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808332134, ExchCode = 'LAS' WHERE SecCode = 6753080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805672065, ExchCode = 'FRA' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'VAML' WHERE SecCode = 6806345 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'VEDPOWER' WHERE SecCode = 6806346 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'VISL' WHERE SecCode = 6806347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179524277, ExchCode = 'GER' WHERE SecCode = 6808918 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'VOGL' WHERE SecCode = 6829246 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 6849658 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-11' WHERE SecCode = 6849750 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 6881998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808329918, ExchCode = 'GTX' WHERE SecCode = 6887871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808187810, ExchCode = 'QTX' WHERE SecCode = 6887874 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 6890745 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 6890752 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 6890754 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 6890756 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 6897212 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6897216 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 6900870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807978130, ExchCode = 'FRA' WHERE SecCode = 6901104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535196167, PermQuoteStatus = 'AC', Ticker = 'NVJP', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 6901138 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6902729 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6902747 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6902748 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 6908109 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951254.0 WHERE SecCode = 6908111 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6908217 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-11' WHERE SecCode = 10960373 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11048234 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 11056477 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11072399 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'FITB PR I', ExchCode = 'NYS' WHERE SecCode = 11112032 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11140035 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 11144467 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'VCBDD' WHERE SecCode = 11156270 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11160389 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11160390 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11189015 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808191556, PriTrdQuotePermID = 236808191556.0, ValQuotePermID = 25727395486.0, PermQuoteStatus = 'AC', Ticker = 'TRLV', ExchCode = 'NYS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-10', PermSecMapEndDate = NULL WHERE SecCode = 11190437 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ALDSD' WHERE SecCode = 11197024 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11198984 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11199570 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'FITB PR A', ExchCode = 'NYS' WHERE SecCode = 11199938 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'FITB PR K', ExchCode = 'NYS' WHERE SecCode = 11200229 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'AURO' WHERE SecCode = 11215356 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'VRNOD' WHERE SecCode = 11219488 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, QuoteClass = 'CHESS', InstrClass = 'CHESS', PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 11221597 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11235729 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'EVNT' WHERE SecCode = 11239946 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11243216 AND Type_ = 1;
UPDATE data_universe_permid SET ValQuotePermID = 21942062497.0 WHERE SecCode = 11243837 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11259985 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11268281 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000127426, PriInstrPermID = 232854772507.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951176.0, PermOrgIPODate = '2024-08-29' WHERE SecCode = 11268849 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'SNGPF' WHERE SecCode = 11269126 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'VRXA' WHERE SecCode = 11270117 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11272673 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11274371 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'AVAT', ExchCode = 'NAS' WHERE SecCode = 11274579 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11274580 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11289335 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11289336 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11289340 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11289347 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 8590933020.0 WHERE SecCode = 11290250 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'FITB PR M', ExchCode = 'NYS' WHERE SecCode = 11291429 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11293135 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11293136 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11293137 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11293138 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11293139 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11293140 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11293184 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11293186 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232917829583.0, IsPrimaryInstr = 0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-11', PermSecMapEndDate = '2026-06-11' WHERE SecCode = 11295855 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25727273180, InstrPermID = 25727273206, OrgPermID = 5080043909, PriTrdQuotePermID = 25727273180.0, ValQuotePermID = 25727273181.0, PriInstrPermID = 25727273206.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'APCPU', ExchCode = 'NYS', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = '2026-02-10', PermSecMapEndDate = '2026-03-03' WHERE SecCode = 11296309 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-12' WHERE SecCode = 11296754 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 11297295 AND Type_ = 1;
