UPDATE data_universe_permid SET QuotePermID = 55838299316, PermQuoteStatus = 'DC', Ticker = 'GL9.IE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 10081 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 232927583462.0 WHERE SecCode = 11927 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 232927583462.0, IsPrimaryInstr = 0, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11934 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BMU' WHERE SecCode = 28346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-15' WHERE SecCode = 33634 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 42608 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531592, ExchCode = 'FRA' WHERE SecCode = 46521 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-10' WHERE SecCode = 46850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837356038, ExchCode = 'GER' WHERE SecCode = 47291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801449047, ExchCode = 'DEU' WHERE SecCode = 47312 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 48002 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667485029, ExchCode = 'QTX' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298120, ExchCode = 'GTX' WHERE SecCode = 53702 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 56413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520168469, ExchCode = 'STU' WHERE SecCode = 56520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475435128, ExchCode = 'GER', PermQuoteRetireDate = '2008-10-07' WHERE SecCode = 56524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474874382, ExchCode = 'DEU' WHERE SecCode = 56529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630231241, Ticker = 'STF', ExchCode = 'STU' WHERE SecCode = 57832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325590, ExchCode = 'BER' WHERE SecCode = 57850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560955141, PermQuoteStatus = 'AC', Ticker = 'CUW', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 57884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419027, ExchCode = 'LAS' WHERE SecCode = 57889 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 57998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621680880, ExchCode = 'TDG' WHERE SecCode = 58060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475745795, ExchCode = 'BER' WHERE SecCode = 58064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838502924, ExchCode = 'STU', PermQuoteRetireDate = '2020-08-07' WHERE SecCode = 58140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585226757, ExchCode = 'STU' WHERE SecCode = 58245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399700, ExchCode = 'FRA', PermQuoteRetireDate = '2016-02-12' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835784245, ExchCode = 'DUS' WHERE SecCode = 60025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475457917, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2007-11-28' WHERE SecCode = 60090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589872687, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-17' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837362566, ExchCode = 'GER' WHERE SecCode = 60255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337787, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483861234, ExchCode = 'STU' WHERE SecCode = 60596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475572974, Ticker = 'NSUG.I', ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320785, ExchCode = 'BER' WHERE SecCode = 61517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485966, ExchCode = 'QTX' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 62870 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 63271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329646, ExchCode = 'BER' WHERE SecCode = 65414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487385255, ExchCode = 'STU', PermQuoteRetireDate = '2019-02-06' WHERE SecCode = 65643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346502, ExchCode = 'STU', PermQuoteRetireDate = '2019-08-01' WHERE SecCode = 65700 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BMU' WHERE SecCode = 77873 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BMU' WHERE SecCode = 82565 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 83946 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'BMU' WHERE SecCode = 84070 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 92379 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-16' WHERE SecCode = 94094 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-15' WHERE SecCode = 94354 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 94746 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'MAV' WHERE SecCode = 100885 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 100923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609211565, ExchCode = 'TDG' WHERE SecCode = 103792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341666, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 103840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836418073, ExchCode = 'FRA' WHERE SecCode = 103841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335490, ExchCode = 'BER' WHERE SecCode = 103863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475499889, ExchCode = 'STU' WHERE SecCode = 103891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474923635, ExchCode = 'DEU' WHERE SecCode = 103894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285139, ExchCode = 'DEU' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835799282, ExchCode = 'MEX' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298416, ExchCode = 'DEU' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381737, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823487855, ExchCode = 'DUS' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419464, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652457, ExchCode = 'FRA' WHERE SecCode = 140677 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'I6R0' WHERE SecCode = 141929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554252789, PermQuoteRetireDate = '2015-01-09' WHERE SecCode = 143248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646072207, ExchCode = 'STU' WHERE SecCode = 146365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593612748, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 178159 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BMU' WHERE SecCode = 178332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490776, ExchCode = 'QTX', PermQuoteRetireDate = '2025-12-10' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805705275, ExchCode = 'GTX', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 185281 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BMU' WHERE SecCode = 194187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544956008, ExchCode = 'DEU' WHERE SecCode = 208922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328659, ExchCode = 'BER' WHERE SecCode = 208947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035304, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2012-06-04' WHERE SecCode = 249049 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-15' WHERE SecCode = 249164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664062914, ExchCode = 'STU' WHERE SecCode = 278881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794261329, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820587345, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 318406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479406, ExchCode = 'QTX' WHERE SecCode = 325643 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-04-14', PermSecMapEndDate = NULL WHERE SecCode = 326237 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 327052 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21608397233, ExchCode = 'TDG' WHERE SecCode = 327144 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951884.0 WHERE SecCode = 330366 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 335310 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836352544, ExchCode = 'FRA' WHERE SecCode = 350275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474950915, ExchCode = 'DEU', PermQuoteRetireDate = '2017-12-15' WHERE SecCode = 351504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321591, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 362355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835814728, ExchCode = 'MEX' WHERE SecCode = 372859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838302063, PermQuoteStatus = 'DC', Ticker = 'MRLAV.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 374278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834671865, Ticker = '0NNH', ExchCode = 'LSE', PermQuoteRetireDate = '2015-04-30' WHERE SecCode = 374927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484743, ExchCode = 'QTX' WHERE SecCode = 375326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841613018, ExchCode = 'MEX' WHERE SecCode = 409684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800488, ExchCode = 'STU' WHERE SecCode = 412853 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-10' WHERE SecCode = 423163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840380357, ExchCode = 'PFT', PermQuoteRetireDate = '2017-01-23' WHERE SecCode = 433814 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536204619, ExchCode = 'STU' WHERE SecCode = 435796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842916429, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 439455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858584221, Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 480180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847283502, Ticker = 'XAXJ', ExchCode = 'LSE' WHERE SecCode = 481041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22150825819, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21925268568, ExchCode = 'GTX' WHERE SecCode = 484491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853787628, ExchCode = 'STU', PermQuoteRetireDate = '2011-12-20' WHERE SecCode = 499735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848865464, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 503830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725613667, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 503842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914681044, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 513278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541088571, ExchCode = 'STU' WHERE SecCode = 515043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21975240639, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 521464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481623766, ExchCode = 'DEU', PermQuoteRetireDate = '2019-05-13' WHERE SecCode = 524355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640208051, ExchCode = 'CHI', PermQuoteRetireDate = '2018-10-29' WHERE SecCode = 529911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850869660, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 532767 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951777.0 WHERE SecCode = 533556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478699, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-09', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 535506 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 = 21475024144, ExchCode = 'TDG' WHERE SecCode = 540531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536043310, ExchCode = 'STU' WHERE SecCode = 540563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476219200, ExchCode = 'STU' WHERE SecCode = 541495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474938108, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 542320 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 232927583462.0 WHERE SecCode = 548774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704213, Ticker = 'AKS*', ExchCode = 'MXQ' WHERE SecCode = 549537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617415257, ExchCode = 'MUN' WHERE SecCode = 550860 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 552951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475119976, ExchCode = 'FRA' WHERE SecCode = 557816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475771162, ExchCode = 'STU' WHERE SecCode = 557995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475653582, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-08-02' WHERE SecCode = 558809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814307220, PermQuoteStatus = 'AC', Ticker = 'OA5', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 560728 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951891.0 WHERE SecCode = 561073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529362096, ExchCode = 'STU' WHERE SecCode = 563087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857450136, ExchCode = 'BER', PermQuoteRetireDate = '2018-02-01' WHERE SecCode = 564035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762578358, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-16' WHERE SecCode = 565707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475805271, ExchCode = 'STU' WHERE SecCode = 565752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599770084, ExchCode = 'STU' WHERE SecCode = 597462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991761, ExchCode = 'MUN' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521102286, ExchCode = 'STU' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540229905, ExchCode = 'STU' WHERE SecCode = 701753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21895641350, ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-18' WHERE SecCode = 827254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528542094, ExchCode = 'TDG' WHERE SecCode = 881802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801717079, Ticker = 'CBBFFz', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 933460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388797, ExchCode = 'LAS' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145600723, ExchCode = 'DEU' WHERE SecCode = 1017380 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BMU' WHERE SecCode = 1104434 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-16' WHERE SecCode = 1182141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951777.0 WHERE SecCode = 1449176 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-15' WHERE SecCode = 1451955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482394593, Ticker = 'BLITs', ExchCode = 'BUR', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478615947, ExchCode = 'BUR' WHERE SecCode = 1465275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480227394, ExchCode = 'STU', PermQuoteRetireDate = '2013-05-20' WHERE SecCode = 1479224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481705363, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109485, ExchCode = 'FRA' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652933092, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483930016, ExchCode = 'FRA' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512147101, Ticker = 'BRDG', ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21486671125, ExchCode = 'STU' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179775, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646545320, PermQuoteStatus = 'DC', Ticker = '5EV', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 1525470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817610, ExchCode = 'FRA' WHERE SecCode = 1527439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492716295, ExchCode = 'STU' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796520014, ExchCode = 'GTX' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893351, ExchCode = 'STU' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705407, ExchCode = 'MXQ' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498532317, ExchCode = 'FRA' WHERE SecCode = 1556381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639604213, ExchCode = 'MUN' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461757, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-04' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489792, ExchCode = 'QTX' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479450, ExchCode = 'QTX' WHERE SecCode = 1584599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524609219, ExchCode = 'BTE' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308500, ExchCode = 'FRA' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704832, ExchCode = 'MXQ' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553068247, ExchCode = 'TDG' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506574448, ExchCode = 'MUN' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705694, ExchCode = 'MXQ' WHERE SecCode = 1621273 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951777.0 WHERE SecCode = 1622232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511441575, ExchCode = 'TDG', PermQuoteRetireDate = '2016-02-08' WHERE SecCode = 1624036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368066, Ticker = 'PV0D', ExchCode = 'SES', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513069367, ExchCode = 'TDG' WHERE SecCode = 1635476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805705273, ExchCode = 'HAN', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 1651704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701628, Ticker = 'IBCG', ExchCode = 'BRN' WHERE SecCode = 1652279 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 = 21504836182, Ticker = 'CHMT', ExchCode = 'PAR', PermQuoteRetireDate = '2017-04-25' WHERE SecCode = 1677246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511262189, ExchCode = 'DEU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520427, ExchCode = 'DEU' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679815, ExchCode = 'BIV' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515521924, ExchCode = 'FRA' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528495416, ExchCode = 'CHI' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '3SB' WHERE SecCode = 1940046 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BMU' WHERE SecCode = 1990909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518074502, ExchCode = 'DEU' WHERE SecCode = 2055361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517928750, ExchCode = 'FRA' WHERE SecCode = 2055381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658940658, ExchCode = 'MUN' WHERE SecCode = 2142278 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 2195628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521092450, ExchCode = 'STO', PermQuoteRetireDate = '2024-03-27' WHERE SecCode = 2195912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521578467, ExchCode = 'DEU' WHERE SecCode = 2200210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357671, ExchCode = 'FRA' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371241, ExchCode = 'SGO' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537129363, ExchCode = 'BER', PermQuoteRetireDate = '2025-06-12', PermSecMapEndDate = '2025-06-26' WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143697, Ticker = '2KPN', ExchCode = 'MIL' WHERE SecCode = 2225256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541308584, Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831441, ExchCode = 'DEU' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478541, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524063116, ExchCode = 'DEU' WHERE SecCode = 2240608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477221044, Ticker = NULL WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830026, ExchCode = 'QTX' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675187, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525929139, ExchCode = 'FRA' WHERE SecCode = 2288360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515724218, ExchCode = 'BER', PermQuoteRetireDate = '2021-06-04' WHERE SecCode = 2289254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854599, ExchCode = 'FRA' WHERE SecCode = 2326807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21686715439, Ticker = 'CECD', ExchCode = 'LSE', PermQuoteRetireDate = '2021-12-20' WHERE SecCode = 2350989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-16' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820384482, Ticker = 'XDN0l', ExchCode = 'BCO' WHERE SecCode = 2363639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530661727, ExchCode = 'FRA' WHERE SecCode = 2373485 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 = 21521371665, ExchCode = 'SGO' WHERE SecCode = 2377498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531130867, InstrPermID = 8590926370, OrgPermID = 4295858498, ValQuotePermID = 55835583224.0, PriInstrPermID = 8590926370.0, PermInstrStatus = 'AC', Ticker = 'MQG0d', ExchCode = 'BCO', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = 4294951922.0, PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2013-10-29' WHERE SecCode = 2387360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679407, ExchCode = 'BIV' WHERE SecCode = 2407194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786676622, ExchCode = 'MEX' WHERE SecCode = 2414027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532914219, ExchCode = 'STU' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756688641, ExchCode = 'MUN' WHERE SecCode = 2421101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538681, ExchCode = 'FRA' WHERE SecCode = 2429967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533561487, ExchCode = 'MUN' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842517697, ExchCode = 'SGO' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517626184, ExchCode = 'MUN' WHERE SecCode = 2448345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134691, ExchCode = 'DEU' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21869002235, ExchCode = 'DEU', PermSecMapEndDate = '2024-02-14' 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 = 21539609267, ExchCode = 'FRA' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431263, ExchCode = 'FRA' 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 = 21688529407, Ticker = '53S1', ExchCode = 'DUS', PermQuoteRetireDate = '2021-06-25' WHERE SecCode = 2550286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712262618, ExchCode = 'BER' WHERE SecCode = 2561218 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781821998, ExchCode = 'QTX' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782012516, ExchCode = 'DEU' WHERE SecCode = 2585381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544783558, Ticker = '2T41', ExchCode = 'BER', PermQuoteRetireDate = '2020-08-03' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544371203, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-28' WHERE SecCode = 2604155 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 = 21662105437, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2604394 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 = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478452, ExchCode = 'QTX' WHERE SecCode = 2649155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804841423, ExchCode = 'HAM' WHERE SecCode = 2725364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704488, ExchCode = 'MXQ' WHERE SecCode = 2747774 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 QuotePermID = 21656679952, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2767178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557191633, ExchCode = 'BER' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322146, Ticker = 'IDV1', ExchCode = 'DEU' 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 = 21503527105, ExchCode = 'MEX' WHERE SecCode = 2812150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21678893048, ExchCode = 'FRA' WHERE SecCode = 2824459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561432644, ExchCode = 'FRA' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562290887, ExchCode = 'STU' WHERE SecCode = 2870150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21577065352, ExchCode = 'DEU' WHERE SecCode = 2887226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180586, ExchCode = 'DEU' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615434084, Ticker = 'SX7EEz', ExchCode = 'BTE' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564447127, ExchCode = 'BTE', PermQuoteRetireDate = '2015-05-29' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077770, ExchCode = 'LAS' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731661976, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565402682, ExchCode = 'FRA' WHERE SecCode = 2910684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566935898, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2930544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900629, ExchCode = 'STU', PermQuoteRetireDate = '2019-12-04' WHERE SecCode = 2930555 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 2930562 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 = 21624461911, ExchCode = 'STU' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479590, ExchCode = 'QTX' WHERE SecCode = 3032363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908254953, ExchCode = 'DEU' WHERE SecCode = 3033925 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 = 21581022764, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL 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 = 236784385101, ExchCode = 'LAS' WHERE SecCode = 3098021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955916, ExchCode = 'TDG' WHERE SecCode = 3101224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800738271, ExchCode = 'QTX' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164689309, ExchCode = 'GTX' WHERE SecCode = 3121289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077929, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3121290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953916121, ExchCode = 'GTX' WHERE SecCode = 3124235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320061, ExchCode = 'DEU' WHERE SecCode = 3124241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552305555, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284723, ExchCode = 'GTX' WHERE SecCode = 3181133 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 = 21714463784, ExchCode = 'DXE' WHERE SecCode = 3186834 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 = 236784388055, ExchCode = 'LAS' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962344738, Ticker = '1VOW3m', ExchCode = 'BTE' WHERE SecCode = 3212165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591801382, ExchCode = 'BER' WHERE SecCode = 3212190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801449069, ExchCode = 'DEU' WHERE SecCode = 3213266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747575641, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596784671, PermQuoteStatus = 'DC', Ticker = 'M85', ExchCode = 'TDG', PermQuoteRetireDate = '2017-08-22' WHERE SecCode = 3244393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641955334, ExchCode = 'DEU' WHERE SecCode = 3244877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026729, Ticker = '1UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788491422, Ticker = '0EFd', ExchCode = 'BCO' WHERE SecCode = 3246454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100410, ExchCode = 'QTX' WHERE SecCode = 3247170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824694891, ExchCode = 'DUS' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591485238, Ticker = '1CBK', ExchCode = 'MIL' WHERE SecCode = 3247531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150560, ExchCode = 'CHA' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758732894, ExchCode = 'STU' WHERE SecCode = 3254976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651373312, ExchCode = 'DEU' WHERE SecCode = 3255012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617415254, ExchCode = 'MUN' WHERE SecCode = 3255028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21716782408, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597328149, ExchCode = 'MUN' WHERE SecCode = 3255527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684286324, Ticker = '3660', ExchCode = 'STU', PermQuoteRetireDate = '2023-08-02' WHERE SecCode = 3257169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598997838, ExchCode = 'DEU' WHERE SecCode = 3258821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800110, ExchCode = 'CHI' WHERE SecCode = 3263198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599774622, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 3271586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705332, Ticker = 'MBWSN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3273583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704158, ExchCode = 'MXQ' WHERE SecCode = 3273584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380027, ExchCode = 'LAS' WHERE SecCode = 3273585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601639661, ExchCode = 'TDG' WHERE SecCode = 3277475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782872444, Ticker = 'SLYGd', ExchCode = 'SIG' WHERE SecCode = 3280089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387859, ExchCode = 'LAS' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954945, ExchCode = 'LAS' WHERE SecCode = 3283696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632738581, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-27' WHERE SecCode = 3297215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638239121, ExchCode = 'BTE' WHERE SecCode = 3301720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606233655, PermQuoteStatus = 'AC', Ticker = 'SGLD', ExchCode = 'AEX', PermQuoteRetireDate = NULL WHERE SecCode = 3301728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152594, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3301805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704505, Ticker = 'CXO*', ExchCode = 'MXQ' WHERE SecCode = 3302683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857633427, ExchCode = 'QTX' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798239844, ExchCode = 'TDG' WHERE SecCode = 3305420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705487, ExchCode = 'STU' WHERE SecCode = 3308987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705763, ExchCode = 'MXQ' WHERE SecCode = 3309397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797988618, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-29' WHERE SecCode = 3309705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608278641, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705301, Ticker = 'LOGM*', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786016615, ExchCode = 'FRA' WHERE SecCode = 3315780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131153720, ExchCode = 'HAM' WHERE SecCode = 3315799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750316962, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815325346, ExchCode = 'MUN', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786651644, ExchCode = 'QTX' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784368437, ExchCode = 'MUN' WHERE SecCode = 3317120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596900305, ExchCode = 'MUN' WHERE SecCode = 3317168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609137333, ExchCode = 'DEU' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705372, ExchCode = 'MXQ' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766138099, ExchCode = 'STU' WHERE SecCode = 3317714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714769303, ExchCode = 'TDG' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237022, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-01', PermSecMapEndDate = NULL WHERE SecCode = 3318127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777378734, ExchCode = 'GTX' WHERE SecCode = 3318532 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3319533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133418, ExchCode = 'FRA' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610380131, ExchCode = 'DEU' WHERE SecCode = 3319862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380068, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3319868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100523, ExchCode = 'QTX' WHERE SecCode = 3320079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100435, ExchCode = 'QTX' WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443154, ExchCode = 'DEU' WHERE SecCode = 3320334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448682, ExchCode = 'FRA' WHERE SecCode = 3321109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042371, ExchCode = 'DEU' WHERE SecCode = 3322810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297982, ExchCode = 'DUS' WHERE SecCode = 3324152 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 = 21649841825, ExchCode = 'BER' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780911221, ExchCode = 'MUN' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295882, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587897, ExchCode = 'QTX' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612487102, ExchCode = 'DEU' WHERE SecCode = 3339668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645200699, ExchCode = 'TDG' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863182810, ExchCode = 'MUN' WHERE SecCode = 3347597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419047, ExchCode = 'LAS', PermQuoteRetireDate = '2025-12-17', PermSecMapEndDate = '2026-01-26' WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591485244, Ticker = '1PSM', ExchCode = 'MIL' WHERE SecCode = 3347660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673707, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3347669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773002549, ExchCode = 'FRA' WHERE SecCode = 3356351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678600, ExchCode = 'BIV' WHERE SecCode = 3357131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678608, ExchCode = 'BIV' WHERE SecCode = 3357133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614735175, ExchCode = 'DEU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659071012, ExchCode = 'BIV' WHERE SecCode = 3358492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011585, Ticker = '2EVK', ExchCode = 'MIL' WHERE SecCode = 3358919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705339, ExchCode = 'MXQ' WHERE SecCode = 3364922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615998446, Ticker = '14G', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3366981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152616, ExchCode = 'MUN' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627708, ExchCode = 'QTX' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819145774, PermQuoteStatus = 'AC', Ticker = '015A', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3375389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482433, ExchCode = 'QTX' WHERE SecCode = 3377762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320101, ExchCode = 'DEU' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100723, ExchCode = 'DUS' WHERE SecCode = 3378195 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647732131, ExchCode = 'STU' WHERE SecCode = 3378583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742595, PermQuoteStatus = 'DC', ExchCode = 'HAN', PermQuoteRetireDate = '2020-09-22' WHERE SecCode = 3382234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618324770, ExchCode = 'MEX' WHERE SecCode = 3384174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658642103, ExchCode = 'MUN' 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 = 21766019517, ExchCode = 'FRA' WHERE SecCode = 3386374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766440281, ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-29' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650357, ExchCode = 'QTX' WHERE SecCode = 3392279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645193083, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-03', PermSecMapEndDate = NULL WHERE SecCode = 3393655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378814, ExchCode = 'BRN' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378638, ExchCode = 'BRN' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575576966, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 3394028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390710, ExchCode = 'FRA' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21637054002, ExchCode = 'BTE' WHERE SecCode = 3395249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805094957, ExchCode = 'FRA' WHERE SecCode = 3395352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623803393, ExchCode = 'DEU' WHERE SecCode = 3396014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100517, ExchCode = 'QTX' WHERE SecCode = 3401365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704915, ExchCode = 'MXQ' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469772, ExchCode = 'DEU' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679739, ExchCode = 'BIV' WHERE SecCode = 3402264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625310757, ExchCode = 'DEU' WHERE SecCode = 3402309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764861300, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-01', PermSecMapEndDate = '2021-10-01' WHERE SecCode = 3402310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704264, ExchCode = 'MXQ' WHERE SecCode = 3403875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195409, ExchCode = 'DUS' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097182, ExchCode = 'LAS' WHERE SecCode = 3405304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630627945, ExchCode = 'FRA' WHERE SecCode = 3405439 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 = 236782100842, ExchCode = 'DUS' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705811, Ticker = 'TLNDN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256348, ExchCode = 'DUS' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-15' WHERE SecCode = 3408727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644149855, ExchCode = 'DEU' WHERE SecCode = 3409040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301441, ExchCode = 'MEX' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353175, ExchCode = 'FRA' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932188, ExchCode = 'DEU' WHERE SecCode = 3410277 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 QuotePermID = 236784380013, ExchCode = 'LAS' WHERE SecCode = 3424652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100439, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-02' WHERE SecCode = 3429810 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-10' WHERE SecCode = 3430482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704968, ExchCode = 'MXQ' WHERE SecCode = 3430824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761780026, ExchCode = 'DEU' WHERE SecCode = 3430952 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BMU' WHERE SecCode = 3431594 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3432039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380031, ExchCode = 'LAS' WHERE SecCode = 3432164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636049771, ExchCode = 'BER', PermQuoteRetireDate = '2018-06-28' WHERE SecCode = 3434582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636066861, ExchCode = 'DEU' WHERE SecCode = 3435060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782375294, ExchCode = 'STU' WHERE SecCode = 3436849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381246, ExchCode = 'LAS' WHERE SecCode = 3438714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186352, ExchCode = 'FRA' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520521, ExchCode = 'DUS' WHERE SecCode = 3444720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644011375, ExchCode = 'DEU' WHERE SecCode = 3445093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643807094, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3445201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644687554, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3445747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646838408, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-30', PermSecMapEndDate = NULL WHERE SecCode = 3445749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705440, ExchCode = 'MXQ' WHERE SecCode = 3446301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071844, ExchCode = 'FRA', PermQuoteRetireDate = '2019-12-30' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'BMU' WHERE SecCode = 3446893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938004022, ExchCode = 'GTX' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181250, ExchCode = 'DUS' WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800450347, ExchCode = 'MUN' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704432, ExchCode = 'MXQ' 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 QuotePermID = 25727169919, Ticker = 'NGIL', ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910203, ExchCode = 'DUS' WHERE SecCode = 3513998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705225, Ticker = 'JOBSN', ExchCode = 'MXQ' WHERE SecCode = 3518311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763474273, ExchCode = 'BER', PermQuoteRetireDate = '2025-09-02', PermSecMapEndDate = NULL WHERE SecCode = 3526167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727195, ExchCode = 'FRA' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656740299, Ticker = 'DNKl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-01-20' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624891, Ticker = 'CSC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 3586971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782645921, ExchCode = 'BER', PermQuoteRetireDate = '2021-04-07' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684118505, Ticker = 'AEJ', ExchCode = 'LSE' WHERE SecCode = 3587037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644367377, ExchCode = 'DEU' WHERE SecCode = 3587074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617115150, ExchCode = 'TRQ' WHERE SecCode = 3588029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752247684, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 3588035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787436, ExchCode = 'DUS' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662110032, ExchCode = 'AQX' WHERE SecCode = 3596589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287361, PermQuoteStatus = 'AC', Ticker = 'TLRY', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 3610775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777289547, ExchCode = 'TDG' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789515091, ExchCode = 'QTX', PermQuoteRetireDate = '2025-10-27' WHERE SecCode = 3623818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678046, ExchCode = 'BIV' WHERE SecCode = 3629694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668158989, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679574, ExchCode = 'BIV' WHERE SecCode = 3644857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681018002, ExchCode = 'FRA' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670450813, ExchCode = 'DEU' WHERE SecCode = 3657811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671049443, PermQuoteStatus = 'AC', Ticker = '1SS', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3663204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302234, ExchCode = 'GTX' WHERE SecCode = 3675861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21676198882, ExchCode = 'DEU', PermQuoteRetireDate = '2024-04-24' WHERE SecCode = 3716790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679877079, ExchCode = 'FRA' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947054171, ExchCode = 'FRA' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674386, ExchCode = 'BIV' WHERE SecCode = 3756608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678493, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3761051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682196938, Ticker = '0CMZ', ExchCode = 'LSE', PermQuoteRetireDate = '2019-02-13' WHERE SecCode = 3762759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461787, ExchCode = 'FRA' WHERE SecCode = 3793374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679373, ExchCode = 'BIV' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744453885, ExchCode = 'DEU' WHERE SecCode = 3809052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383302, ExchCode = 'MEX' WHERE SecCode = 3809094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496810, ExchCode = 'DUS' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394215, ExchCode = 'MEX' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930883, ExchCode = 'MUN' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285132, PermQuoteStatus = 'DC', Ticker = '2ZT0', ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-02' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744919357, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841147970, ExchCode = 'TDG' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387101, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3849234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21698786104, ExchCode = 'CHI', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702129365, ExchCode = 'BER', PermQuoteRetireDate = '2021-09-17' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702475114, ExchCode = 'FRA' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702467501, ExchCode = 'DEU' WHERE SecCode = 3886782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900276, ExchCode = 'TDG' WHERE SecCode = 3898812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703664166, ExchCode = 'STU' WHERE SecCode = 3898813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386695, ExchCode = 'LAS' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729404094, ExchCode = 'STU' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930903, ExchCode = 'FRA' WHERE SecCode = 3958735 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 = 21719403388, ExchCode = 'FRA' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359630, ExchCode = 'MEX' WHERE SecCode = 4024645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011932, Ticker = '2BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026934, Ticker = '1MS' WHERE SecCode = 4031717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011913, Ticker = '2AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011919, Ticker = '2ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011959, Ticker = '2DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026920, Ticker = '1MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026962, Ticker = '1PM' WHERE SecCode = 4032067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026885, Ticker = '1CRM' WHERE SecCode = 4032071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681023394, Ticker = '4AKZA', ExchCode = 'ETX' WHERE SecCode = 4032088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774922624, ExchCode = 'BCO' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734028297, ExchCode = 'MUN' WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739862119, PermQuoteStatus = 'DC', Ticker = 'JARUl', ExchCode = 'MAA', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587084065, PermQuoteStatus = 'AC', Ticker = 'XBJR', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383364, ExchCode = 'TDG' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976699, ExchCode = 'STU' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815144829, Ticker = '49Y', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-20' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586898, ExchCode = 'DEU' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738226580, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4124713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388439, ExchCode = 'LAS' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21740303517, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14', PermSecMapEndDate = NULL WHERE SecCode = 4124848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625622942, ExchCode = 'DEU' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745628089, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747487294, ExchCode = 'BER', PermQuoteRetireDate = '2022-09-27', PermSecMapEndDate = '2022-09-27' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679079, ExchCode = 'BIV' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 4236123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534208, PermQuoteStatus = 'AC', Ticker = '0YL0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4259224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349639, ExchCode = 'BIV' WHERE SecCode = 4259231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549155, ExchCode = 'FRA' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4280528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360719, ExchCode = 'BER' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759692047, ExchCode = 'FRA' WHERE SecCode = 4295731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759801437, ExchCode = 'FRA' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027131, Ticker = '1SPOT' WHERE SecCode = 4309035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761325018, Ticker = '4TKWY', ExchCode = 'ETX' WHERE SecCode = 4309036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026769, Ticker = '1AMS' WHERE SecCode = 4309037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026756, Ticker = '1NB' WHERE SecCode = 4309038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761324941, Ticker = '4RMS', ExchCode = 'ETX' WHERE SecCode = 4309039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761324824, Ticker = '4ASM', ExchCode = 'ETX' WHERE SecCode = 4309043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026753, Ticker = '1FSLR' WHERE SecCode = 4309045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761647098, ExchCode = 'DUS' WHERE SecCode = 4309050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762578377, ExchCode = 'TDG' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580218, ExchCode = 'FRA' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951255.0 WHERE SecCode = 4320768 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 = 21763724005, ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-02' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763901203, ExchCode = 'QTX' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112309, ExchCode = 'DEU' WHERE SecCode = 4328959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781601742, ExchCode = 'GER' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388426, ExchCode = 'LAS' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772740424, Ticker = '2ENR' WHERE SecCode = 4372484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772839734, ExchCode = 'DEU' WHERE SecCode = 4372550 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 = 21774613209, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' 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 = 21777652111, ExchCode = 'FRA' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826522500, ExchCode = 'QTX' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307749, ExchCode = 'MEX' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785622125, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377503, ExchCode = 'MEX' WHERE SecCode = 4417298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312696, ExchCode = 'MEX' WHERE SecCode = 4420916 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 = 21797999132, ExchCode = 'FRA' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991601, ExchCode = 'FRA' WHERE SecCode = 4429683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785087353, ExchCode = 'DEU' WHERE SecCode = 4434390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740545, ExchCode = 'LAS' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791470018, ExchCode = 'QTX' WHERE SecCode = 4451262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790867954, ExchCode = 'STU' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4464672 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 = 21793532320, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2024-10-25' 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 = 21897786131, ExchCode = 'MUN' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793526925, ExchCode = 'QTX' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817581, ExchCode = 'FRA' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796645883, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-05' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809915701, ExchCode = 'STU' WHERE SecCode = 4494227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956106, Ticker = '0A6Nl', ExchCode = 'BCO' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727286506, ExchCode = 'MEX' WHERE SecCode = 4505794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799284681, ExchCode = 'SWX' WHERE SecCode = 4506359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955514011, ExchCode = 'DUS' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813169859, ExchCode = 'TDG' WHERE SecCode = 4511506 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4524467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851345226, ExchCode = 'MUN' 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 = 236781627749, ExchCode = 'QTX' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851700, ExchCode = 'MUN' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806812473, ExchCode = 'DEU' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812659635, ExchCode = 'QTX' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4565443 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 4565445 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 4570289 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 = 236782100496, ExchCode = 'QTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406482, ExchCode = 'FRA' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813395103, ExchCode = 'FRA' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881522351, ExchCode = 'MUN' WHERE SecCode = 4601728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816245393, ExchCode = 'MUN' WHERE SecCode = 4601736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21944534852, ExchCode = 'STU' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4611072 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4611073 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4611074 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4611075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818266412, ExchCode = 'DEU' WHERE SecCode = 4617743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968078, ExchCode = 'DEU' WHERE SecCode = 4625009 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 = 21822771356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2021-08-16' WHERE SecCode = 4637752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822791593, ExchCode = 'FRA' WHERE SecCode = 4637756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823073549, ExchCode = 'DEU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4643279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312261, ExchCode = 'GTX' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831908634, ExchCode = 'GTX' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827621995, ExchCode = 'FRA' WHERE SecCode = 4657695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312374, ExchCode = 'GTX' WHERE SecCode = 4664721 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 = 21837529040, ExchCode = 'GER' WHERE SecCode = 4693646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837529343, ExchCode = 'FRA' 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 4703969 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951279.0 WHERE SecCode = 4705686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037614, ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-21' WHERE SecCode = 4707187 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4714893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843915142, ExchCode = 'STU' WHERE SecCode = 4718903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381548, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851127888, ExchCode = 'DUS' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867779, ExchCode = 'FRA' WHERE SecCode = 4752188 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4756634 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 = 236778220715, ExchCode = 'TDG' WHERE SecCode = 4762975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854914847, PermQuoteStatus = 'AC', Ticker = '3FNG', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905909279, ExchCode = 'MUN' WHERE SecCode = 4771746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439327, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-17' WHERE SecCode = 4773786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439467, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-18' WHERE SecCode = 4774934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856710535, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4777235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857898826, ExchCode = 'FRA' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4786512 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4786513 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4786514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705625, ExchCode = 'STU' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4804789 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4804790 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4804791 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4807541 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4807542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192589, ExchCode = 'FRA' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865900341, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4819644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866095400, ExchCode = 'HAM' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4841231 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4841232 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4841233 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 IncCntry = 'BMU' WHERE SecCode = 4854739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387394, ExchCode = 'LAS' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873522596, ExchCode = 'STU' WHERE SecCode = 4873680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892048749, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4908364 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4925701 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4938304 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4938305 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4938306 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4955643 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4955644 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4955645 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4955646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381606, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4959596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887745388, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4965060 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 = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21900329922, ExchCode = 'FRA' WHERE SecCode = 4970793 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 4972240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740514, ExchCode = 'LAS' WHERE SecCode = 4983996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100451, ExchCode = 'QTX' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910753865, Ticker = '1COIN' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910739462, Ticker = 'SGLY' WHERE SecCode = 5004801 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 = 21907308927, ExchCode = 'DUS' WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197376, ExchCode = 'MEX' WHERE SecCode = 5030308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928845, ExchCode = 'BCO' WHERE SecCode = 5038689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823918, ExchCode = 'AQX' WHERE SecCode = 5038692 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951255.0 WHERE SecCode = 5041438 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951279.0 WHERE SecCode = 5041692 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 5041714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902924195, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195445, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 5042969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607201, Ticker = 'DXCM', ExchCode = 'SWX' WHERE SecCode = 5047087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209210, ExchCode = 'FRA' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777507074, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-08' WHERE SecCode = 5063516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902573195, ExchCode = 'DUS' WHERE SecCode = 5067269 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5072136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903664236, ExchCode = 'FRA' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663662, ExchCode = 'DEU' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727217399, ExchCode = 'MEX' WHERE SecCode = 5083954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716301, ExchCode = 'DEU' WHERE SecCode = 5083964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381619, ExchCode = 'LAS' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907546209, ExchCode = 'DUS', PermQuoteRetireDate = '2024-11-29' WHERE SecCode = 5099027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908066901, ExchCode = 'DEU' WHERE SecCode = 5102905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716268, ExchCode = 'DEU' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816912714, ExchCode = 'FRA', PermQuoteRetireDate = '2023-01-12', PermSecMapEndDate = '2023-01-12' WHERE SecCode = 5112411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910867434, ExchCode = 'STU' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910877570, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912123776, ExchCode = 'DEU' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561704, ExchCode = 'DUS' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915977241, ExchCode = 'DEU' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607033, Ticker = 'NDAQ', ExchCode = 'SWX' WHERE SecCode = 5144089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942737484, ExchCode = 'STU' WHERE SecCode = 5151167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615655, ExchCode = 'STU' WHERE SecCode = 5153443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919459011, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5156836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807916823, ExchCode = 'MUN' WHERE SecCode = 5161225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634297955, Ticker = '0M1Kl', ExchCode = 'BCO' WHERE SecCode = 5161267 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 = 21721366997, ExchCode = 'STU' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22102173529, ExchCode = 'DEU' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777510265, Ticker = 'WPM', ExchCode = 'LSE' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180699, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667329377, ExchCode = 'DEU' WHERE SecCode = 5161350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827095404, ExchCode = 'MXQ' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21657632265, Ticker = 'FT5', ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-04' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781498592, ExchCode = 'MXQ' WHERE SecCode = 5161409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727360441, ExchCode = 'BIV' WHERE SecCode = 5161415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850514745, ExchCode = 'DEU' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820375290, Ticker = 'SQTA', ExchCode = 'TDG', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885781, ExchCode = 'FRA' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197642, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727207519, ExchCode = 'MEX' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919483609, ExchCode = 'DEU' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561584, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173437, ExchCode = 'MEX' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943651732, ExchCode = 'STU' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950518158, ExchCode = 'GTX' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904151, ExchCode = 'BTE' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5208095 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930042387, ExchCode = 'QTX' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783133624, ExchCode = 'TDG' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951901113, ExchCode = 'MUN' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727227057, ExchCode = 'BIV' WHERE SecCode = 5238268 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 = 25727173431, ExchCode = 'BIV' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948492664, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936132731, ExchCode = 'DEU' WHERE SecCode = 5258611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957756231, ExchCode = 'DUS' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935009367, ExchCode = 'CHA' WHERE SecCode = 5261340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775222348, ExchCode = 'MEX' WHERE SecCode = 5267090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381670, ExchCode = 'LAS' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537961037, ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-03', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 5283651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 5283708 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 5287493 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 5287506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780979385, ExchCode = 'DUS' 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 = 236778803186, ExchCode = 'QTX' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802775547, ExchCode = 'FRA' WHERE SecCode = 5310445 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 5322366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949478319, ExchCode = 'FRA' WHERE SecCode = 5338742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789864381, ExchCode = 'TDG' 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 = 21953963626, ExchCode = 'MUN' WHERE SecCode = 5354968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803603455, ExchCode = 'TDG' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959409338, ExchCode = 'DEU' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716964, ExchCode = 'DEU' WHERE SecCode = 5383598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785535434, ExchCode = 'DUS' WHERE SecCode = 5383599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520780621, ExchCode = 'FRA' WHERE SecCode = 5383600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380717, ExchCode = 'LAS' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5400815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778397152, ExchCode = 'FRA' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778500352, ExchCode = 'MEX' WHERE SecCode = 5481081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823760, ExchCode = 'AQX' WHERE SecCode = 5503898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807449510, ExchCode = 'BCO' WHERE SecCode = 5503900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663650, Ticker = 'ARK3l', ExchCode = 'AQX' WHERE SecCode = 5503901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619181, ExchCode = 'BTE' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835655, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471181, ExchCode = 'MEX' WHERE SecCode = 5542023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471183, ExchCode = 'BIV' WHERE SecCode = 5549613 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 = 21995583895, ExchCode = 'DEU' WHERE SecCode = 5565485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780192624, ExchCode = 'MUN', PermQuoteRetireDate = '2023-11-29' WHERE SecCode = 5601088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22004617984, ExchCode = 'DEU' WHERE SecCode = 5607542 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173436, ExchCode = 'MEX' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5628328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782375294, ExchCode = 'STU' WHERE SecCode = 5638703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923117428, Ticker = 'LCO3', ExchCode = 'LSE' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966732, ExchCode = 'TDG', PermQuoteRetireDate = '2020-01-23' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460797, ExchCode = 'GER' WHERE SecCode = 5638832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917827821, ExchCode = 'FRA', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917828152, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307748, ExchCode = 'BIV' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5671906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099419639, Ticker = 'VPCUl', ExchCode = 'BCO' WHERE SecCode = 5702903 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5702904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078152, ExchCode = 'LAS' WHERE SecCode = 5703208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782109056, ExchCode = 'BIV' WHERE SecCode = 5709076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22025806033, ExchCode = 'DEU' WHERE SecCode = 5710467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028649127, Ticker = '1SO1', ExchCode = 'DEU' WHERE SecCode = 5722406 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5738381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782930891, ExchCode = 'MUN' WHERE SecCode = 5753987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22034763502, ExchCode = 'DEU' WHERE SecCode = 5764130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955012, ExchCode = 'LAS' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784236560, ExchCode = 'STU' WHERE SecCode = 5822326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784236496, ExchCode = 'FRA' WHERE SecCode = 5822327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601266, ExchCode = 'FRA' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601265, ExchCode = 'FRA' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601263, ExchCode = 'FRA' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804071845, ExchCode = 'FRA' WHERE SecCode = 5853173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348220, ExchCode = 'STU' WHERE SecCode = 5857780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784888212, ExchCode = 'MEX' WHERE SecCode = 5907884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22061950077, ExchCode = 'DEU' WHERE SecCode = 5936516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798309817, ExchCode = 'FRA' WHERE SecCode = 5947065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786800651, ExchCode = 'FRA' WHERE SecCode = 5947076 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6002025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788207224, ExchCode = 'FRA' WHERE SecCode = 6010807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788327822, ExchCode = 'MUN' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795664148, ExchCode = 'MEX' WHERE SecCode = 6014420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788640939, ExchCode = 'FRA' WHERE SecCode = 6035234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788847043, ExchCode = 'MUN' WHERE SecCode = 6043475 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6043479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789380440, ExchCode = 'GTX' WHERE SecCode = 6065904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789414416, ExchCode = 'STU' WHERE SecCode = 6065905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22081001385, ExchCode = 'DEU' WHERE SecCode = 6075918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789657842, ExchCode = 'STU' WHERE SecCode = 6075919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834786, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705800, ExchCode = 'MXQ' WHERE SecCode = 6097292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834880, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834808, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827614120, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 6097328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835789, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' WHERE SecCode = 6097355 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 = 25727171457, ExchCode = 'MEX' 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 = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789902797, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-30', PermSecMapEndDate = '2025-01-30' WHERE SecCode = 6114320 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951777.0 WHERE SecCode = 6137728 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6159032 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6160876 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6163829 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6164271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791248887, ExchCode = 'STU' WHERE SecCode = 6190705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792942788, ExchCode = 'LAS' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6217549 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6240412 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6240413 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6240416 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6240417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133181713, Ticker = 'BTCE', ExchCode = 'SWX', PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6245909 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6256158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181395, ExchCode = 'MEX' WHERE SecCode = 6256406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22150315636, ExchCode = 'DEU' WHERE SecCode = 6256407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734886875, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745957943, PermQuoteStatus = 'AC', Ticker = '0BF0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909392, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6256420 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6258193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792342447, ExchCode = 'FRA' WHERE SecCode = 6270465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6302000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22109402118, ExchCode = 'DEU' WHERE SecCode = 6310331 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 6310618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349910, ExchCode = 'FRA' WHERE SecCode = 6334403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349773, ExchCode = 'GTX' WHERE SecCode = 6334404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349912, ExchCode = 'FRA' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6354175 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6363491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22118566912, ExchCode = 'DEU' WHERE SecCode = 6382149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792427653, ExchCode = 'LAS' WHERE SecCode = 6382150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297587, ExchCode = 'MXQ' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6440010 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6440014 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6440015 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6440016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451400, ExchCode = 'BTE' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6480284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109710, ExchCode = 'QTX' WHERE SecCode = 6501107 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6503855 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 QuotePermID = 236798948296, ExchCode = 'FRA' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607123, Ticker = 'SNOW', ExchCode = 'SWX' WHERE SecCode = 6578368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799651841, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6583721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484355, ExchCode = 'QTX' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430458, ExchCode = 'DEU' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6627068 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6627069 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6627070 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6627071 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6627072 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6627073 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6627074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150029, Ticker = 'UPST', ExchCode = 'SWX' WHERE SecCode = 6629463 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6649337 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6649338 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6649346 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6649358 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6649359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883770164, ExchCode = 'DEU' WHERE SecCode = 6667833 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6672558 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 6710098 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 6710111 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 6710112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167343880, ExchCode = 'DEU' WHERE SecCode = 6728367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167339493, ExchCode = 'DEU' WHERE SecCode = 6728368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167339476, ExchCode = 'DEU' WHERE SecCode = 6728370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167340591, ExchCode = 'DEU' WHERE SecCode = 6728371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167341909, ExchCode = 'DEU' WHERE SecCode = 6728372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167342837, ExchCode = 'DEU' WHERE SecCode = 6728373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167342067, ExchCode = 'DEU' WHERE SecCode = 6728374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167339591, ExchCode = 'DEU' WHERE SecCode = 6728375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167340584, ExchCode = 'DEU' WHERE SecCode = 6728377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167340486, ExchCode = 'DEU' WHERE SecCode = 6728378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799175959, ExchCode = 'BIV' WHERE SecCode = 6728383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167326401, ExchCode = 'GER' WHERE SecCode = 6728389 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 6762065 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 6768837 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 6768844 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 6769154 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6769257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805672299, IsPrimaryQuote = 1, Ticker = '751109', ExchCode = 'BSE' WHERE SecCode = 6779463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805672060, IsPrimaryQuote = 1, Ticker = 'TILPP', ExchCode = 'NSI' WHERE SecCode = 6779464 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236805674195.0, IsPrimaryQuote = 1, PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 6779471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805672765, IsPrimaryQuote = 1, ExchCode = 'FRA', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 6779681 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'GFTRF' WHERE SecCode = 10924415 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 11002056 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'RMVEY', PermQuoteRetireDate = NULL, PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11002064 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11037386 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232927583462.0, IsPrimaryInstr = 0 WHERE SecCode = 11047117 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 25769765357, PermQuoteStatus = 'AC', Ticker = 'WORX', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11162137 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'DUKR' WHERE SecCode = 11163329 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ELVG' WHERE SecCode = 11198346 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'NLD' WHERE SecCode = 11245917 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11247284 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236804538080, InstrPermID = 232926425992, OrgPermID = 6000067056, PriTrdQuotePermID = 236804538080.0, ValQuotePermID = 25727029722.0, PriInstrPermID = 232926425992.0, PermQuoteStatus = 'AC', Ticker = 'HQ', ExchCode = 'NAS', DomCntry = 'SGP', IncCntry = 'SGP', PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = '2026-03-20', PermSecMapStartDate = '2026-03-20' WHERE SecCode = 11247542 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11247797 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11280657 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11286829 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11286834 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11286848 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11290667 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11290668 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11290670 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11290673 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11290675 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11290676 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11290679 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-16' WHERE SecCode = 11292168 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11292836 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11293198 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-15' WHERE SecCode = 11293491 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805674162, PermSecMapStartDate = '2026-04-14' WHERE SecCode = 11293741 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11294451 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11294452 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11294453 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11294454 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11294455 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11294456 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 11294457 AND Type_ = 1;
