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 IsPrimaryInstr = 1 WHERE SecCode = 7851 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 27995 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 28133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18', PermSecMapEndDate = '2021-02-10' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475535468, PermQuoteStatus = 'DC', Ticker = 'AMDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481067, PermQuoteStatus = 'AC', Ticker = 'AEC1', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622059, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330930, ExchCode = 'BER', PermQuoteRetireDate = '2023-09-21' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469912, ExchCode = 'QTX' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034103, PermQuoteStatus = 'AC', Ticker = 'CPA', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 37361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035699, PermQuoteStatus = 'AC', Ticker = 'GOB', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 37392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859213206, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37893 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 43103 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475575870, Ticker = 'MACO.I', ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616156912, ExchCode = 'MCX' WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328604, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 46907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474843390, ExchCode = 'DEU' WHERE SecCode = 48131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689885806, ExchCode = 'TDG' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838243226, Ticker = 'MKA', ExchCode = 'MUN' WHERE SecCode = 48328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485029, ExchCode = 'QTX' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 53277 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236801607810, ExchCode = 'GTX' WHERE SecCode = 53597 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 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 = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 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 = 55836531963, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-15' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548206934, ExchCode = 'DEU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348427, ExchCode = 'FRA' WHERE SecCode = 61517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805161989, ExchCode = 'BTE' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659673, ExchCode = 'LAS' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018990, ExchCode = 'STU', PermQuoteRetireDate = '2023-08-16', PermSecMapEndDate = '2023-08-16' WHERE SecCode = 62512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 QuotePermID = 21624377340, ExchCode = 'DEU' WHERE SecCode = 66493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830299459, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 66530 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951624.0 WHERE SecCode = 66941 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 70619 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 79135 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 80070 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 83723 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475625797, ExchCode = 'PNK' WHERE SecCode = 88966 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 92379 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236796141120, ExchCode = 'FRA' WHERE SecCode = 100032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531043704, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 100052 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 102904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856943909, Ticker = '6MI', ExchCode = 'STU', PermQuoteRetireDate = '2011-12-19' WHERE SecCode = 111924 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 OrgTypeCode = 'COM', IncCntry = 'CHE' WHERE SecCode = 117369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298391, ExchCode = 'FRA' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660136963, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2023-02-03' WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525931704, ExchCode = 'STU' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475008736, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'CHE' WHERE SecCode = 120914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957798876, ExchCode = 'DEU' WHERE SecCode = 131976 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 132780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386561, ExchCode = 'LAS' WHERE SecCode = 136195 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787759877, ExchCode = 'DEU' WHERE SecCode = 136934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604646765, ExchCode = 'STU' WHERE SecCode = 136936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576164405, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 136946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787461, ExchCode = 'DUS', PermQuoteRetireDate = '2022-01-14', PermSecMapEndDate = NULL WHERE SecCode = 137285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492614, ExchCode = 'QTX' WHERE SecCode = 137300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556785810, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-24' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 139759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815760885, ExchCode = 'STU' WHERE SecCode = 141782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380937, ExchCode = 'LAS' WHERE SecCode = 141797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768726861, ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-01' WHERE SecCode = 141805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536204669, ExchCode = 'STU', PermQuoteRetireDate = '2016-04-27' WHERE SecCode = 141829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21924367319, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 141914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22111176653, ExchCode = 'DEU' WHERE SecCode = 141915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168877672, ExchCode = 'DEU' WHERE SecCode = 141918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552643769, ExchCode = 'DUS' WHERE SecCode = 141927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034538, ExchCode = 'TDG' WHERE SecCode = 142049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587882462, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 142159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572615818, ExchCode = 'FRA' WHERE SecCode = 142384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547304354, Ticker = 'H9Id', ExchCode = 'BCO', PermQuoteRetireDate = '2022-08-12' WHERE SecCode = 142482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633621200, Ticker = '0Y9S', ExchCode = 'LSE' WHERE SecCode = 143694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460007, ExchCode = 'HAN' WHERE SecCode = 143864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629381720, Ticker = '0NOF', ExchCode = 'LSE' WHERE SecCode = 144186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551269267, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664445764, ExchCode = 'FRA', PermQuoteRetireDate = '2019-01-24' WHERE SecCode = 144351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523563790, ExchCode = 'DEU' WHERE SecCode = 144591 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383340, PermQuoteStatus = 'DC', Ticker = 'H7K', ExchCode = 'TDG', PermQuoteRetireDate = '2025-02-03' WHERE SecCode = 145208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794070542, ExchCode = 'FRA' WHERE SecCode = 145375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836487956, ExchCode = 'FRA' WHERE SecCode = 145380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484032, ExchCode = 'QTX' WHERE SecCode = 145407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324849, ExchCode = 'BER' WHERE SecCode = 145435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035323, ExchCode = 'TDG', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 145503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143293940, ExchCode = 'DEU' WHERE SecCode = 145505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503066036, ExchCode = 'STU' WHERE SecCode = 145506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632441036, Ticker = '0QZO', ExchCode = 'LSE' WHERE SecCode = 145533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533662651, ExchCode = 'TDG' WHERE SecCode = 145554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794070572, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 145558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694218351, ExchCode = 'FRA' WHERE SecCode = 145643 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'IBIS-M' WHERE SecCode = 146133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679444829, ExchCode = 'STU', PermQuoteRetireDate = '2024-03-12', PermSecMapEndDate = '2024-03-21' WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498233890, ExchCode = 'STU' WHERE SecCode = 150272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836398769, ExchCode = 'FRA', PermQuoteRetireDate = '2015-02-19' WHERE SecCode = 150274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007976, ExchCode = 'DEU', PermQuoteRetireDate = '2019-03-20' WHERE SecCode = 151023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625070426, ExchCode = 'STU' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560390682, ExchCode = 'STU', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 166319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294418, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 167012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647854776, ExchCode = 'FRA' WHERE SecCode = 168616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514031334, ExchCode = 'DEU' WHERE SecCode = 168960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592418875, Ticker = '4INGA', ExchCode = 'ETX' WHERE SecCode = 169546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794654406, ExchCode = 'DEU' WHERE SecCode = 169573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264672, ExchCode = 'MUN' WHERE SecCode = 169894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474926887, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-03-11', PermSecMapEndDate = '2025-03-11' WHERE SecCode = 171257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850436290, ExchCode = 'FRA' WHERE SecCode = 173009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513801720, ExchCode = 'STU' WHERE SecCode = 173075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545507629, ExchCode = 'DEU' WHERE SecCode = 173076 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 173682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553398593, ExchCode = 'STU' WHERE SecCode = 177153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859251485, ExchCode = 'FRA' WHERE SecCode = 177375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478280, ExchCode = 'DEU' WHERE SecCode = 177399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870865178, ExchCode = 'MUN' WHERE SecCode = 177427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531478600, ExchCode = 'DEU' WHERE SecCode = 177431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782003605, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-07', PermSecMapEndDate = NULL WHERE SecCode = 177461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521223886, ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-14' WHERE SecCode = 177502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798827533, ExchCode = 'FRA' WHERE SecCode = 177597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328975, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 177599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327818, ExchCode = 'BER', PermQuoteRetireDate = '2021-08-23' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474922689, ExchCode = 'DEU' WHERE SecCode = 178031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007903, ExchCode = 'DEU' WHERE SecCode = 178059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955876, ExchCode = 'TDG' WHERE SecCode = 178130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926818, ExchCode = 'DEU' WHERE SecCode = 178149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320072, ExchCode = 'FRA' WHERE SecCode = 178208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341005, ExchCode = 'BER' WHERE SecCode = 178282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507329852, ExchCode = 'FRA' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772839712, ExchCode = 'DEU' WHERE SecCode = 178295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128769282, ExchCode = 'DEU' WHERE SecCode = 178338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685426317, ExchCode = 'MUN' WHERE SecCode = 178363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474987610, ExchCode = 'FRA', PermQuoteRetireDate = '2023-01-10' WHERE SecCode = 178410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612052439, ExchCode = 'DEU' WHERE SecCode = 178420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523649406, ExchCode = 'FRA' WHERE SecCode = 178451 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 178548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475770394, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'GER', PermQuoteRetireDate = '2018-01-12', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475787250, ExchCode = 'DEU' WHERE SecCode = 178737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673962902, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679752, ExchCode = 'FRA' WHERE SecCode = 178849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475011769, ExchCode = 'DEU' WHERE SecCode = 178970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803403432, ExchCode = 'FRA' WHERE SecCode = 179031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535137262, ExchCode = 'FRA' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545451887, ExchCode = 'DEU' WHERE SecCode = 180692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340733, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 181907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474988909, ExchCode = 'FRA' WHERE SecCode = 181909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703536253, ExchCode = 'BER' WHERE SecCode = 181912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800096568, ExchCode = 'FRA' WHERE SecCode = 183383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555849, ExchCode = 'FRA' WHERE SecCode = 183422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334821, ExchCode = 'BER' WHERE SecCode = 185835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294096, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 186400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798248733, ExchCode = 'FRA' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838540118, ExchCode = 'STU' WHERE SecCode = 186457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383425, ExchCode = 'FRA' WHERE SecCode = 186462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576116427, ExchCode = 'DEU' WHERE SecCode = 186470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555271475, ExchCode = 'FRA' WHERE SecCode = 186474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881521047, ExchCode = 'GTX' WHERE SecCode = 186478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21900738063, ExchCode = 'MUN' WHERE SecCode = 186488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390698, ExchCode = 'FRA' WHERE SecCode = 186492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326454, ExchCode = 'BER' WHERE SecCode = 187841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326642, ExchCode = 'BER' WHERE SecCode = 188522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490958372, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 188523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475590751, Ticker = 'PTMN.L', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 189538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611418, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 190124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521109986, PermQuoteStatus = 'AC', Ticker = 'HY7', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 190214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661437570, ExchCode = 'STU' WHERE SecCode = 190498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517436726, ExchCode = 'STU' WHERE SecCode = 190881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035798, Ticker = 'P8H1', ExchCode = 'TDG', PermQuoteRetireDate = '2019-09-20' WHERE SecCode = 191863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817613, ExchCode = 'DEU', PermQuoteRetireDate = '2023-03-01', PermSecMapEndDate = '2023-03-01' WHERE SecCode = 192682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474927898, ExchCode = 'DEU', PermQuoteRetireDate = '2021-10-25' WHERE SecCode = 192941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510070638, ExchCode = 'FRA' WHERE SecCode = 194187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547070064, Ticker = 'BNFd', ExchCode = 'BCO' WHERE SecCode = 196120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473860, ExchCode = 'FRA' WHERE SecCode = 196149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628831642, ExchCode = 'STU' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714469392, ExchCode = 'DXE' WHERE SecCode = 196630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339746, ExchCode = 'BER' WHERE SecCode = 197081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527545972, ExchCode = 'STU' WHERE SecCode = 197304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797003035, ExchCode = 'GTX' WHERE SecCode = 197772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034815, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 201293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760588747, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 201793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704490, ExchCode = 'MXQ' WHERE SecCode = 201846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531927275, ExchCode = 'MEX' WHERE SecCode = 201875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22095615019, ExchCode = 'DEU' WHERE SecCode = 201937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475130440, ExchCode = 'STU' WHERE SecCode = 201941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502336043, ExchCode = 'STU' WHERE SecCode = 201945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475887561, ExchCode = 'STU' WHERE SecCode = 201946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329734, ExchCode = 'FRA' WHERE SecCode = 201962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704310, ExchCode = 'MXQ' WHERE SecCode = 201971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792256366, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 202264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659841755, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 202265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509902864, Ticker = 'SOYP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 202732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339906, ExchCode = 'BER' WHERE SecCode = 202733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302068, ExchCode = 'FRA' WHERE SecCode = 202933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498931242, ExchCode = 'FRA' WHERE SecCode = 202935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340463, ExchCode = 'BER', PermQuoteRetireDate = '2017-08-15' WHERE SecCode = 202950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788425927, ExchCode = 'LAS' WHERE SecCode = 203057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509187534, ExchCode = 'DEU' WHERE SecCode = 203795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335347, ExchCode = 'BER', PermQuoteRetireDate = '2014-10-06' WHERE SecCode = 204876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625620888, ExchCode = 'TDG' WHERE SecCode = 205611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033438, ExchCode = 'TDG' WHERE SecCode = 206769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387779, ExchCode = 'LAS' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803385253, ExchCode = 'GTX' WHERE SecCode = 206847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587111640, ExchCode = 'DEU' WHERE SecCode = 210734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659184307, ExchCode = 'MUN' WHERE SecCode = 210739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991994, ExchCode = 'DEU', PermQuoteRetireDate = '2022-04-27' WHERE SecCode = 248740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669871254, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 248746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332085, ExchCode = 'BER', PermQuoteRetireDate = '2009-06-08' WHERE SecCode = 248760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566184392, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 248773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836411753, ExchCode = 'FRA' WHERE SecCode = 248774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474917330, ExchCode = 'DEU' WHERE SecCode = 248929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147089280, ExchCode = 'DEU' WHERE SecCode = 249236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475835886, ExchCode = 'BER', PermQuoteRetireDate = '2012-09-21' WHERE SecCode = 249274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565082887, ExchCode = 'FRA' WHERE SecCode = 249293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474925265, ExchCode = 'DEU' WHERE SecCode = 249354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474978939, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-20' WHERE SecCode = 249365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331035, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324507, ExchCode = 'BER', PermQuoteRetireDate = '2008-09-05' WHERE SecCode = 249403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476850902, ExchCode = 'TDG' WHERE SecCode = 249426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526392840, ExchCode = 'DEU' WHERE SecCode = 249427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956712462, ExchCode = 'DUS', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 249601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133899880, ExchCode = 'DEU' WHERE SecCode = 249624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581860194, ExchCode = 'BER', PermQuoteRetireDate = '2020-10-08' WHERE SecCode = 249627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617119543, Ticker = 'CKI', ExchCode = 'STU', PermQuoteRetireDate = '2019-08-14' WHERE SecCode = 249643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856190, ExchCode = 'DEU', PermQuoteRetireDate = '2021-05-26' WHERE SecCode = 249688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325708, ExchCode = 'BER' WHERE SecCode = 249695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474904311, ExchCode = 'DEU', PermQuoteRetireDate = '2019-05-09' WHERE SecCode = 249704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607709988, ExchCode = 'STU' WHERE SecCode = 249713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308695, ExchCode = 'GTX' WHERE SecCode = 249726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325926, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 249738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525576964, ExchCode = 'TDG' WHERE SecCode = 249828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544722925, ExchCode = 'STU' WHERE SecCode = 249844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835778048, Ticker = '85C', ExchCode = 'DUS' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960080108, ExchCode = 'MUN' WHERE SecCode = 259026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523736069, ExchCode = 'DEU' WHERE SecCode = 260155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341153, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 283718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21579894372, ExchCode = 'FRA' WHERE SecCode = 284280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646845918, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 284282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681761697, ExchCode = 'DEU' WHERE SecCode = 284283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840890582, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-08' WHERE SecCode = 284305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557105454, ExchCode = 'TDG' WHERE SecCode = 286289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325722, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329948, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 291628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475571725, ExchCode = 'STU' WHERE SecCode = 291854 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 = 55836330602, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336620, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296595 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 296704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533706424, ExchCode = 'DEU' WHERE SecCode = 297377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640834970, ExchCode = 'FRA' WHERE SecCode = 297742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475010144, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 300181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504951501, Ticker = 'TCG', ExchCode = 'GER', PermQuoteRetireDate = '2018-04-23' WHERE SecCode = 300395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850895857, ExchCode = 'QTX', PermQuoteRetireDate = '2021-11-01' WHERE SecCode = 300831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513072831, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 301739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483815345, ExchCode = 'TDG' WHERE SecCode = 303347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585027886, ExchCode = 'CHI' WHERE SecCode = 309897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349692, ExchCode = 'FRA', PermQuoteRetireDate = '2011-04-01' WHERE SecCode = 312934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034449, Ticker = 'EV7', ExchCode = 'TDG', PermQuoteRetireDate = '2014-10-17' WHERE SecCode = 313560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508030921, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 315711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349476, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 316472 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 317556 AND Type_ = 1;
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 = 55836320798, ExchCode = 'BER' WHERE SecCode = 319524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320881, ExchCode = 'BER', PermQuoteRetireDate = '2016-06-17' WHERE SecCode = 325342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568459988, ExchCode = 'STU' WHERE SecCode = 326661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885451397, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 333804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704226, ExchCode = 'MXQ' WHERE SecCode = 333869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321476, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 340167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515929419, ExchCode = 'DEU', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 340533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778456358, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 341926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538721081, ExchCode = 'STU' WHERE SecCode = 341959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911870720, ExchCode = 'GTX' WHERE SecCode = 341961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524267752, ExchCode = 'STU', PermQuoteRetireDate = '2017-03-29' WHERE SecCode = 341966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957499669, ExchCode = 'DUS' WHERE SecCode = 345100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821849074, ExchCode = 'TDG' WHERE SecCode = 345429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475550034, Ticker = 'CAZA', ExchCode = 'POS', PermQuoteRetireDate = '2008-04-26' WHERE SecCode = 345783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793845607, ExchCode = 'FRA' WHERE SecCode = 345843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21895997853, ExchCode = 'FRA' WHERE SecCode = 345850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914565, ExchCode = 'FRA' WHERE SecCode = 345851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589227637, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 348130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130920528, ExchCode = 'DEU' WHERE SecCode = 348479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473202, ExchCode = 'FRA' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651753006, ExchCode = 'STU' WHERE SecCode = 352543 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 355079 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21761303038, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 355184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543203134, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-14', PermSecMapEndDate = '2023-09-14' WHERE SecCode = 359919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799029787, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-11-21' WHERE SecCode = 363732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350583, ExchCode = 'FRA', PermQuoteRetireDate = '2024-11-29' WHERE SecCode = 368808 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475566805, PermQuoteStatus = 'DC', ExchCode = 'MUN', PermQuoteRetireDate = '2009-08-03' WHERE SecCode = 368820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350578, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 368836 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 372861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514709829, Ticker = 'D69', ExchCode = 'STU' WHERE SecCode = 379671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840856895, ExchCode = 'BER' WHERE SecCode = 389023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805846166, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-17', PermSecMapEndDate = NULL WHERE SecCode = 392352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431650, ExchCode = 'FRA' WHERE SecCode = 401619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475806545, ExchCode = 'STU' WHERE SecCode = 401621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841643563, ExchCode = 'BER', PermQuoteRetireDate = '2014-08-20' WHERE SecCode = 401624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478492476, Ticker = '0GKZ', ExchCode = 'LSE', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 408476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848856283, ExchCode = 'LSE', PermQuoteRetireDate = '2009-05-26' WHERE SecCode = 408478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482293, ExchCode = 'QTX' WHERE SecCode = 413132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843102675, ExchCode = 'BER' WHERE SecCode = 424779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487384961, ExchCode = 'STU' WHERE SecCode = 424919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294126, ExchCode = 'GTX' WHERE SecCode = 425031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511427254, ExchCode = 'STU', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 425411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517622815, ExchCode = 'STU' WHERE SecCode = 428335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396870, ExchCode = 'FRA' WHERE SecCode = 428966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302889, ExchCode = 'GTX' WHERE SecCode = 432012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599934396, ExchCode = 'TDG', PermQuoteRetireDate = '2023-12-14', PermSecMapEndDate = '2023-12-14' WHERE SecCode = 438364 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 471736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033434, ExchCode = 'TDG', PermQuoteRetireDate = '2021-11-30' WHERE SecCode = 471738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474993358, ExchCode = 'STU' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605425984, ExchCode = 'RTB' WHERE SecCode = 500487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704447, ExchCode = 'MXQ' WHERE SecCode = 508999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541088571, ExchCode = 'STU' WHERE SecCode = 515043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615370661, ExchCode = 'STU' WHERE SecCode = 518549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714444925, Ticker = 'WEATm', ExchCode = 'DXE' WHERE SecCode = 521420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781435219, ExchCode = 'MUN' WHERE SecCode = 524403 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 532611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521104643, ExchCode = 'STU' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475845507, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 533522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475422418, Ticker = '0B3F', ExchCode = 'LSE', PermQuoteRetireDate = '2009-09-18' WHERE SecCode = 536734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475867481, ExchCode = 'FRA' WHERE SecCode = 538783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478626, ExchCode = 'QTX' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852219705, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 541456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476219200, ExchCode = 'STU' WHERE SecCode = 541495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856846840, ExchCode = 'BER', PermQuoteRetireDate = '2014-03-25' WHERE SecCode = 541974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307223, ExchCode = 'MEX' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852831256, ExchCode = 'BER', PermQuoteRetireDate = '2013-07-11' WHERE SecCode = 547537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797390906, ExchCode = 'MUN' WHERE SecCode = 549236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21964831449, ExchCode = 'DEU' WHERE SecCode = 549886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853660975, ExchCode = 'FRA' WHERE SecCode = 552722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518455932, ExchCode = 'DEU', PermQuoteRetireDate = '2023-03-23', PermSecMapEndDate = NULL WHERE SecCode = 553231 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 554135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856721464, ExchCode = 'BER', PermQuoteRetireDate = '2018-04-27' WHERE SecCode = 560723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529362096, ExchCode = 'STU' WHERE SecCode = 563087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864886870, ExchCode = 'MUN' WHERE SecCode = 565861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474962557, ExchCode = 'DEU' WHERE SecCode = 565866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857959487, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 567636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622957126, ExchCode = 'DUS' WHERE SecCode = 568338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704164, ExchCode = 'MXQ' WHERE SecCode = 580373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858902712, ExchCode = 'BER' WHERE SecCode = 592307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475660385, InstrPermID = 8590922012, OrgPermID = 4295880615, ValQuotePermID = 55837430854.0, PriInstrPermID = 8590922012.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'YFM', ExchCode = 'GER', PermQuoteRetireDate = '2010-03-29', PermOrgIPODate = NULL WHERE SecCode = 601515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521225328, ExchCode = 'STU' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865088683, ExchCode = 'TDG' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532857661, ExchCode = 'TDG' WHERE SecCode = 837909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423013, ExchCode = 'FRA' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 853945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475136685, ExchCode = 'FRA' WHERE SecCode = 858901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379950, ExchCode = 'FRA' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913525, ExchCode = 'DEU' WHERE SecCode = 878880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55867148469, Ticker = 'XSIL', ExchCode = 'SWX' WHERE SecCode = 880290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275427, Ticker = 'S2S', ExchCode = 'GTX' WHERE SecCode = 881802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660807802, ExchCode = 'MUN' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928900998, ExchCode = 'QTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516262525, ExchCode = 'DEU' WHERE SecCode = 909718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545813896, ExchCode = 'DEU' WHERE SecCode = 931181 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 PriTRBCIndPermID = 4294951624.0 WHERE SecCode = 968993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475766062, Ticker = '29F', ExchCode = 'STU', PermQuoteRetireDate = '2015-03-23' WHERE SecCode = 985004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769605, Ticker = 'TYMA', ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 995830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145600723, ExchCode = 'DEU' WHERE SecCode = 1017380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521578326, ExchCode = 'DEU' WHERE SecCode = 1122776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797408685, ExchCode = 'FRA' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747333681, ExchCode = 'DEU' WHERE SecCode = 1447581 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'VR61' WHERE SecCode = 1451955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625073457, ExchCode = 'DEU' WHERE SecCode = 1453709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582997752, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1455200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477469688, ExchCode = 'STU', PermQuoteRetireDate = '2015-06-01' WHERE SecCode = 1457731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478443280, ExchCode = 'FRA' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478615947, ExchCode = 'BUR' WHERE SecCode = 1465275 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 1468604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792391622, ExchCode = 'DUS' WHERE SecCode = 1468807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419448, ExchCode = 'HAM' WHERE SecCode = 1472577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21479229300, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1472753 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 1476715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480946905, ExchCode = 'BER', PermQuoteRetireDate = '2013-06-17' WHERE SecCode = 1479224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530720649, ExchCode = 'STU' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481396381, ExchCode = 'STU' WHERE SecCode = 1482803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482228346, ExchCode = 'DEU' WHERE SecCode = 1485685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481643753, ExchCode = 'MUN' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673577, ExchCode = 'BIV' WHERE SecCode = 1489564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109482, ExchCode = 'DEU' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596919147, Ticker = 'SLHOm', ExchCode = 'BTE', PermQuoteRetireDate = '2019-09-18' WHERE SecCode = 1503000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561587, ExchCode = 'DUS' 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 = 21487384788, ExchCode = 'FRA' WHERE SecCode = 1522268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488288403, ExchCode = 'FRA' WHERE SecCode = 1524542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488289996, ExchCode = 'FRA' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488289855, ExchCode = 'FRA', PermQuoteRetireDate = '2022-05-31' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676639, ExchCode = 'BIV' WHERE SecCode = 1524554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488652814, ExchCode = 'FRA' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536289548, ExchCode = 'DEU' WHERE SecCode = 1524628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646184463, PermQuoteStatus = 'AC', Ticker = '5EV0', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 1525470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497767, ExchCode = 'DEU' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794818026, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1527439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21489507452, ExchCode = 'STU', PermQuoteRetireDate = '2012-02-14' WHERE SecCode = 1527466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071858, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098667, ExchCode = 'FRA' WHERE SecCode = 1527502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558559889, ExchCode = 'STU' WHERE SecCode = 1531694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531043659, ExchCode = 'STU' WHERE SecCode = 1532769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491111760, ExchCode = 'FRA' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524560434, Ticker = 'RBTQ', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 1533786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492888711, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-25' WHERE SecCode = 1537137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787321763, ExchCode = 'FRA' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492713347, ExchCode = 'STU' WHERE SecCode = 1537214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493834048, ExchCode = 'TDG' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630031903, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1538644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800721447, ExchCode = 'FRA' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494267747, ExchCode = 'FRA' WHERE SecCode = 1541369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511700265, PermQuoteStatus = 'AC', Ticker = '7NU1', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786220381, ExchCode = 'STU' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496860026, ExchCode = 'FRA' WHERE SecCode = 1546652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954843, ExchCode = 'LAS' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830305592, ExchCode = 'GTX' WHERE SecCode = 1547496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679444, ExchCode = 'BIV' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21497743025, ExchCode = 'DEU' WHERE SecCode = 1552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156877250, ExchCode = 'DEU' WHERE SecCode = 1553832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514434081, Ticker = '5GQA', ExchCode = 'BER', PermQuoteRetireDate = '2020-04-02' WHERE SecCode = 1554222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498230074, ExchCode = 'FRA' WHERE SecCode = 1554784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498302420, ExchCode = 'DEU' WHERE SecCode = 1555173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498521053, ExchCode = 'DEU' WHERE SecCode = 1556381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502150126, ExchCode = 'STU' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615254983, ExchCode = 'DEU' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576116533, ExchCode = 'TDG' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955234899, ExchCode = 'QTX' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503429462, ExchCode = 'FRA' WHERE SecCode = 1584599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524608957, ExchCode = 'CHI' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308444, ExchCode = 'STU' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678108, ExchCode = 'BIV' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505186360, ExchCode = 'BUR' WHERE SecCode = 1596529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505421178, ExchCode = 'STU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538181095, ExchCode = 'STU' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506514608, ExchCode = 'BER' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679673, ExchCode = 'BIV' WHERE SecCode = 1621273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742592, Ticker = 'KJ7', ExchCode = 'HAN', PermQuoteRetireDate = '2021-11-01' WHERE SecCode = 1623980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507477237, ExchCode = 'DEU', PermQuoteRetireDate = '2023-10-09', PermSecMapEndDate = '2023-10-09' WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510896202, ExchCode = 'MUN', PermQuoteRetireDate = '2016-10-25' WHERE SecCode = 1624036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537280920, ExchCode = 'STU', PermQuoteRetireDate = '2023-08-15' WHERE SecCode = 1630461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802789, Ticker = 'PV0D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509749786, ExchCode = 'STU' WHERE SecCode = 1635476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882713778, ExchCode = 'GTX' WHERE SecCode = 1651406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544218182, Ticker = 'IJPEz', ExchCode = 'BCO' WHERE SecCode = 1652279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512104207, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-09' WHERE SecCode = 1655572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513064834, Ticker = 'RF2', PermQuoteRetireDate = '2012-11-22', PermSecMapEndDate = '2012-11-08' WHERE SecCode = 1668708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511217511, ExchCode = 'STU' WHERE SecCode = 1675781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511202969, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 1675785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531120618, Ticker = 'CHMTp', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-08' WHERE SecCode = 1677246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613032675, ExchCode = 'STU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520358, ExchCode = 'FRA' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828343336, ExchCode = 'QTX' WHERE SecCode = 1694101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776251703, ExchCode = 'TDG', PermQuoteRetireDate = '2024-08-13' WHERE SecCode = 1696044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512394339, ExchCode = 'FRA' WHERE SecCode = 1699181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431652, ExchCode = 'FRA' WHERE SecCode = 1707747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641955323, ExchCode = 'DEU' WHERE SecCode = 1707749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515522117, ExchCode = 'DEU' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512769043, ExchCode = 'FRA' WHERE SecCode = 1717803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517428536, ExchCode = 'TRQ', PermQuoteRetireDate = '2023-06-22' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514715669, ExchCode = 'FRA' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320776, ExchCode = 'BER' WHERE SecCode = 1755109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792484745, ExchCode = 'FRA' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285770, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515423659, ExchCode = 'DEU' WHERE SecCode = 1967460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538768207, Ticker = 'ECXl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2013070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072144473, ExchCode = 'DEU' WHERE SecCode = 2042837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589938022, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2126923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658940658, ExchCode = 'MUN' WHERE SecCode = 2142278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519816623, ExchCode = 'FRA' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521092450, ExchCode = 'STO', PermQuoteRetireDate = '2024-03-27' WHERE SecCode = 2195912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379476, ExchCode = 'LAS', PermQuoteRetireDate = '2026-01-27', PermSecMapEndDate = NULL WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854591, ExchCode = 'STU', PermQuoteRetireDate = '2021-01-06' WHERE SecCode = 2288362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670714959, ExchCode = 'TDG' WHERE SecCode = 2338094 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 = 21530263647, ExchCode = 'FRA' WHERE SecCode = 2357967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529719631, ExchCode = 'TDG' WHERE SecCode = 2357969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484790, ExchCode = 'QTX' WHERE SecCode = 2357974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532252447, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-11' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 2397376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726938, ExchCode = 'MUN' WHERE SecCode = 2425600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533561487, ExchCode = 'MUN' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673567, ExchCode = 'BIV' WHERE SecCode = 2455541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694081314, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824100155, ExchCode = 'TDG' WHERE SecCode = 2458822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134691, ExchCode = 'DEU' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390644, ExchCode = 'FRA' WHERE SecCode = 2524755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817958767, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-09-23', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2529636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587290079, ExchCode = 'STU' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704247, ExchCode = 'MXQ' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540739504, ExchCode = 'FRA' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540108933, ExchCode = 'DEU' WHERE SecCode = 2554904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461882, ExchCode = 'FRA' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542191768, ExchCode = 'MUN' WHERE SecCode = 2567216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544783558, Ticker = '2T41', ExchCode = 'BER', PermQuoteRetireDate = '2020-08-03' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067757998, Ticker = '3HCSm', ExchCode = 'BCO' WHERE SecCode = 2600076 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 = 21606224224, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-01' WHERE SecCode = 2622293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606782728, ExchCode = 'FRA' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574200693, ExchCode = 'FRA' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 2633145 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 2644171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589641130, ExchCode = 'STU' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788448710, ExchCode = 'TDG' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549840232, ExchCode = 'FRA' WHERE SecCode = 2655948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 2668929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 2679897 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 2710417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629355954, ExchCode = 'TDG' WHERE SecCode = 2711152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776605626, ExchCode = 'MXQ' WHERE SecCode = 2715641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606359247, ExchCode = 'MUN' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264997, ExchCode = 'DEU' WHERE SecCode = 2732754 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951624.0 WHERE SecCode = 2743686 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 = 21656674963, ExchCode = 'BIV' WHERE SecCode = 2767208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367198, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 2770609 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 2784985 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557191633, ExchCode = 'BER' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322186, ExchCode = 'DEU' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843924533, ExchCode = 'FRA' WHERE SecCode = 2809752 AND Type_ = 10;
UPDATE data_universe_permid SET 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 DomCntry = 'USA' WHERE SecCode = 2812147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503527105, ExchCode = 'MEX' WHERE SecCode = 2812150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561432644, ExchCode = 'FRA' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535496482, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 2827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566120165, ExchCode = 'DEU' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763993243, Ticker = '8PSGd', ExchCode = 'BCO' WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559588394, ExchCode = 'FRA' WHERE SecCode = 2848442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684294108, ExchCode = 'TDG', PermQuoteRetireDate = '2019-04-03' WHERE SecCode = 2855771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460737, ExchCode = 'FRA' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650196, ExchCode = 'DUS' WHERE SecCode = 2858551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599175171, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2861791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460829, ExchCode = 'GER' WHERE SecCode = 2864471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563865313, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-15' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562290608, ExchCode = 'FRA' WHERE SecCode = 2870150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677051, ExchCode = 'BIV' WHERE SecCode = 2876241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673107, ExchCode = 'BIV' WHERE SecCode = 2876284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966774, ExchCode = 'TDG' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565180586, ExchCode = 'DEU' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563124035, ExchCode = 'FRA' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615434084, Ticker = 'SX7EEz', ExchCode = 'BTE' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564231392, ExchCode = 'TRQ', PermQuoteRetireDate = '2015-05-28' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564237670, ExchCode = 'DEU' WHERE SecCode = 2902829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564531293, ExchCode = 'STU' WHERE SecCode = 2905610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565633193, PermQuoteStatus = 'AC', Ticker = 'CM30', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2907243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644687444, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655017440, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557767351, ExchCode = 'SGO' WHERE SecCode = 2907274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564938913, ExchCode = 'DEU' WHERE SecCode = 2909928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565148442, ExchCode = 'MUN' WHERE SecCode = 2911859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673990, ExchCode = 'BIV' WHERE SecCode = 2919671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980729142, ExchCode = 'MXQ' WHERE SecCode = 2919673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585749663, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 2919716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561763, ExchCode = 'GTX' WHERE SecCode = 2919723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705855, Ticker = 'UGN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457862, ExchCode = 'FRA' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370656, ExchCode = 'SGO' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608122500, ExchCode = 'FRA', PermQuoteRetireDate = '2019-02-08' WHERE SecCode = 2928770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566883039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2930544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589809334, ExchCode = 'TDG', PermQuoteRetireDate = '2019-11-20' WHERE SecCode = 2930555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566806429, ExchCode = 'DEU' WHERE SecCode = 2930976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567022234, ExchCode = 'FRA', PermQuoteRetireDate = '2019-05-27', PermSecMapEndDate = NULL WHERE SecCode = 2932394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672243657, PermQuoteStatus = 'DC', Ticker = '16IE', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2935960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567567545, ExchCode = 'FRA' WHERE SecCode = 2937567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21567567756, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2937569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569155612, ExchCode = 'STU' WHERE SecCode = 2947855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370461, ExchCode = 'GTX' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568851024, ExchCode = 'DEU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568943065, ExchCode = 'DEU' WHERE SecCode = 2950211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569151527, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2952372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598532919, ExchCode = 'DEU' WHERE SecCode = 2963564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21570595729, ExchCode = 'DEU' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704396, ExchCode = 'MXQ' WHERE SecCode = 2963604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21706830026, ExchCode = 'QTX' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 2990814 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573513525, ExchCode = 'FRA' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 3002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488811, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3010358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574156091, ExchCode = 'DEU', PermQuoteRetireDate = '2023-01-09' WHERE SecCode = 3011183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724821997, Ticker = '9GL', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2024-04-10' WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 3025383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576175357, ExchCode = 'DEU' WHERE SecCode = 3032214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908254953, ExchCode = 'DEU' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822880896, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3051795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21578813192, ExchCode = 'FRA' WHERE SecCode = 3056842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587055379, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14', PermSecMapEndDate = '2020-06-16' WHERE SecCode = 3076717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285644, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756548866, ExchCode = 'FRA' WHERE SecCode = 3080538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783235696, ExchCode = 'DUS' WHERE SecCode = 3083484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608475923, ExchCode = 'STU' WHERE SecCode = 3085564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275202, ExchCode = 'GTX' WHERE SecCode = 3098021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582927995, ExchCode = 'FRA' WHERE SecCode = 3101224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583224723, ExchCode = 'DEU', PermQuoteRetireDate = '2024-07-16' WHERE SecCode = 3102662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583580936, Ticker = 'NMK', ExchCode = 'GER', PermQuoteRetireDate = '2017-05-15' WHERE SecCode = 3104810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584213518, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-21' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164689174, ExchCode = 'MUN' WHERE SecCode = 3121289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621432527, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3121290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077935, ExchCode = 'LAS' WHERE SecCode = 3124235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320104, ExchCode = 'FRA' WHERE SecCode = 3124241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432069, ExchCode = 'DEU' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544679, ExchCode = 'DUS' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536846008, ExchCode = 'FRA', PermQuoteRetireDate = '2018-07-11' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587220566, ExchCode = 'TDG' WHERE SecCode = 3153872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587931857, ExchCode = 'BTE' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887241129, ExchCode = 'BTE' WHERE SecCode = 3174320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679777, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3177778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21627445525, ExchCode = 'BTE' WHERE SecCode = 3186834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589835342, ExchCode = 'DEU' WHERE SecCode = 3196992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169497784, ExchCode = 'DEU' WHERE SecCode = 3196993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786090215, Ticker = 'PCFH', ExchCode = 'TDG' WHERE SecCode = 3198718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590371242, ExchCode = 'FRA' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674949, ExchCode = 'BIV' WHERE SecCode = 3200668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590831223, ExchCode = 'STU' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100717, ExchCode = 'QTX' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655814, Ticker = '4VOW3', ExchCode = 'ETX' WHERE SecCode = 3212165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591798940, ExchCode = 'TDG' WHERE SecCode = 3212190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448726, ExchCode = 'FRA' WHERE SecCode = 3213266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625006481, ExchCode = 'DEU' WHERE SecCode = 3215534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748078950, ExchCode = 'DEU', PermQuoteRetireDate = '2023-02-17', PermSecMapEndDate = '2023-02-17' WHERE SecCode = 3215564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535194629, Ticker = 'AHOG', ExchCode = 'BRN' WHERE SecCode = 3217753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609921006, ExchCode = 'STU' WHERE SecCode = 3222698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747327546, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593818616, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3228677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864000075, ExchCode = 'DEU' WHERE SecCode = 3229528 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 3240914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614079174, ExchCode = 'TDG', PermQuoteRetireDate = '2017-05-25' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599860813, ExchCode = 'FRA', PermQuoteRetireDate = '2024-07-11' WHERE SecCode = 3242031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623994531, ExchCode = 'DEU' WHERE SecCode = 3244403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011205, Ticker = '2UN' WHERE SecCode = 3244879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718045329, ExchCode = 'MUN' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301751, Ticker = '0EF', ExchCode = 'GTX' 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 = 21613476472, ExchCode = 'STU' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150562, ExchCode = 'AUX' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597458276, ExchCode = 'BER', PermQuoteRetireDate = '2020-07-27' 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 = 21597621641, ExchCode = 'DEU' WHERE SecCode = 3255528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647227260, Ticker = '366', ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 3257169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647013837, ExchCode = 'BCO' WHERE SecCode = 3275560 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 3277018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517543534, ExchCode = 'FRA' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602970799, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3283956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119327, ExchCode = 'BER' WHERE SecCode = 3285184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611219951, ExchCode = 'MUN', PermQuoteRetireDate = '2017-12-22' WHERE SecCode = 3297215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609616, ExchCode = 'DUS' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833203, ExchCode = 'DEU' WHERE SecCode = 3304184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546129, ExchCode = 'MUN' WHERE SecCode = 3308987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743775985, ExchCode = 'DEU', PermQuoteRetireDate = '2022-02-14' WHERE SecCode = 3309705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608270955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679353, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947516, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609327640, ExchCode = 'FRA', PermQuoteRetireDate = '2023-07-04' WHERE SecCode = 3315948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388165, ExchCode = 'LAS' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609137328, ExchCode = 'FRA' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679409, ExchCode = 'BIV' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489849, ExchCode = 'QTX' WHERE SecCode = 3317945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651645775, ExchCode = 'FRA' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 3319533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610513041, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753722337, ExchCode = 'DEU' WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443153, ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-06', PermSecMapEndDate = NULL WHERE SecCode = 3320334 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 3321532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482861, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611321674, ExchCode = 'FRA' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788762034, ExchCode = 'FRA' WHERE SecCode = 3337223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611445381, ExchCode = 'DEU' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745958313, ExchCode = 'DEU' WHERE SecCode = 3337707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690196163, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549117, ExchCode = 'GTX' WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367733, ExchCode = 'CHA' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 3350569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773003108, ExchCode = 'DEU' WHERE SecCode = 3356351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614679451, ExchCode = 'STU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615298321, ExchCode = 'TRQ' WHERE SecCode = 3358414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632742042, ExchCode = 'MUN' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744646634, Ticker = '90S', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3371094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237487, ExchCode = 'DEU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763116669, PermQuoteStatus = 'DC', Ticker = '015', ExchCode = 'BER', PermQuoteRetireDate = '2023-02-15', PermSecMapEndDate = '2023-02-15' WHERE SecCode = 3375389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320047, ExchCode = 'FRA' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663433249, ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-12' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029272, ExchCode = 'SWX' WHERE SecCode = 3394008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390710, ExchCode = 'FRA' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932183, ExchCode = 'FRA' WHERE SecCode = 3401402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624691050, Ticker = '2META', ExchCode = 'MIL' WHERE SecCode = 3401441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641222426, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31', PermSecMapEndDate = NULL WHERE SecCode = 3402310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779748, ExchCode = 'MUN' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628652762, ExchCode = 'STU', PermQuoteRetireDate = '2024-09-30', PermSecMapEndDate = NULL WHERE SecCode = 3405438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784205314, ExchCode = 'FRA' WHERE SecCode = 3407871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901491943, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932291, ExchCode = 'FRA' WHERE SecCode = 3409373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801066696, Ticker = 'C0B1', ExchCode = 'DEU' WHERE SecCode = 3410283 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 3431944 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 3432039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636056227, ExchCode = 'FRA' WHERE SecCode = 3435060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896368974, Ticker = 'AMSv', ExchCode = 'BTE', PermQuoteRetireDate = '2022-06-01' WHERE SecCode = 3435592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679999, ExchCode = 'BIV' WHERE SecCode = 3440422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186303, ExchCode = 'DEU' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688591124, ExchCode = 'STU' WHERE SecCode = 3445093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796141667, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3445201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388252, ExchCode = 'LAS' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648822392, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-08', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810854828, ExchCode = 'DEU' WHERE SecCode = 3521043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430834, ExchCode = 'DEU' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830259734, ExchCode = 'TDG' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753145831, ExchCode = 'BCO' WHERE SecCode = 3547843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663166737, ExchCode = 'DEU' WHERE SecCode = 3550423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710951331, ExchCode = 'CHI' WHERE SecCode = 3550579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796358598, ExchCode = 'TDG' WHERE SecCode = 3555037 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 = 21609269239, ExchCode = 'DEU' WHERE SecCode = 3586984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775216436, ExchCode = 'MUN' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527215, ExchCode = 'FRA' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661179149, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952421, ExchCode = 'DEU' WHERE SecCode = 3591601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777289547, ExchCode = 'TDG' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748602400, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-03' WHERE SecCode = 3623818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667202566, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3631179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918918, ExchCode = 'DEU' WHERE SecCode = 3675860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675091688, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3690817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675114234, ExchCode = 'DEU' WHERE SecCode = 3694578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673848109, ExchCode = 'BIV' WHERE SecCode = 3717229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872326, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785453299, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3756592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682194724, ExchCode = 'DEU' WHERE SecCode = 3756596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683763490, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198305, ExchCode = 'DEU' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373511, ExchCode = 'MEX' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932243, ExchCode = 'FRA' WHERE SecCode = 3827962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694235031, ExchCode = 'FRA' WHERE SecCode = 3830032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21697686068, ExchCode = 'BER' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727346663, Ticker = 'NVV1', ExchCode = 'BRN' WHERE SecCode = 3831364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696168646, ExchCode = 'DEU' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294114, ExchCode = 'GTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21697084889, ExchCode = 'DEU' WHERE SecCode = 3849234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371260, ExchCode = 'MEX' WHERE SecCode = 3851577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888021879, ExchCode = 'GTX' WHERE SecCode = 3852867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373509, ExchCode = 'BIV' WHERE SecCode = 3854663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245385, ExchCode = 'DEU' WHERE SecCode = 3871754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815153752, ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-05', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3877613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380310, ExchCode = 'LAS' WHERE SecCode = 3886781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702467120, ExchCode = 'FRA' WHERE SecCode = 3886782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727368208, ExchCode = 'BIV' WHERE SecCode = 3890234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386695, ExchCode = 'LAS' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209289, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710122305, ExchCode = 'STU' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729404094, ExchCode = 'STU' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403388, ExchCode = 'FRA' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010270, Ticker = '21COV' WHERE SecCode = 4031771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011913, Ticker = '2AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011911, Ticker = '2AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010294, Ticker = '2AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028682767, Ticker = '2BRE' WHERE SecCode = 4031818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22044966173, Ticker = '2BOD' WHERE SecCode = 4031822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009889, Ticker = '2DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026917, Ticker = '1EUZ' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010541, Ticker = '2GG' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012423, Ticker = '2HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010937, Ticker = '2HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010414, Ticker = '2HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012605, Ticker = '2INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010156, Ticker = '2LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010479, Ticker = '2NDX' WHERE SecCode = 4031953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143892, Ticker = '2RI', ExchCode = 'MIL' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042586, Ticker = '2PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013663, Ticker = '2PYPL' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013557, Ticker = '2REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009964, Ticker = '2RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010336, Ticker = '2SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143822, Ticker = '2UCB', ExchCode = 'MIL' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010953, Ticker = '2ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011967, Ticker = '2DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571646335, ExchCode = 'BEC' WHERE SecCode = 4046481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630041763, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21728977320, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4056300 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951949.0 WHERE SecCode = 4066630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731995390, ExchCode = 'DEU' WHERE SecCode = 4079321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776435514, Ticker = 'ZWIPEs', ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-21' WHERE SecCode = 4079329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732569272, ExchCode = 'DEU' WHERE SecCode = 4081944 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774922610, ExchCode = 'BCO', PermQuoteRetireDate = '2025-10-10' WHERE SecCode = 4081958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297913, ExchCode = 'DEU' WHERE SecCode = 4081959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732298218, ExchCode = 'DEU' WHERE SecCode = 4081961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727355173, ExchCode = 'BIV' WHERE SecCode = 4081964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733147228, ExchCode = 'FRA' WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260229, ExchCode = 'DEU' WHERE SecCode = 4099601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077946, ExchCode = 'LAS' 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, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766464069, Ticker = '49Y', ExchCode = 'FRA', 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 = 236784388439, ExchCode = 'LAS' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674204, ExchCode = 'BIV' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351672, ExchCode = 'MEX' WHERE SecCode = 4171586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829986, ExchCode = 'QTX' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097198, ExchCode = 'LAS' WHERE SecCode = 4178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' 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 = 21667482768, ExchCode = 'QTX' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745304635, ExchCode = 'DEU' WHERE SecCode = 4195320 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 = 21745958505, ExchCode = 'FRA' WHERE SecCode = 4201669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766439763, PermQuoteStatus = 'DC', Ticker = '4R80', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746674674, ExchCode = 'DEU' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488857, ExchCode = 'STU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611412, ExchCode = 'DEU' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354881, ExchCode = 'BIV' WHERE SecCode = 4211745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771675002, ExchCode = 'FRA' WHERE SecCode = 4212482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351836, ExchCode = 'BIV' WHERE SecCode = 4212554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910492, ExchCode = 'STU' WHERE SecCode = 4212561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013297, Ticker = '2SYK' WHERE SecCode = 4214397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371806, Ticker = '0Q3', ExchCode = 'BRN' WHERE SecCode = 4214409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013708, Ticker = '2PLUG' WHERE SecCode = 4214415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750318513, ExchCode = 'DUS' WHERE SecCode = 4216412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749838963, ExchCode = 'FRA' WHERE SecCode = 4225217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750196970, ExchCode = 'MUN' WHERE SecCode = 4225963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679079, ExchCode = 'BIV' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349456, ExchCode = 'MEX' WHERE SecCode = 4228288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749841407, ExchCode = 'FRA' WHERE SecCode = 4228324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752139678, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752244343, ExchCode = 'TDG' WHERE SecCode = 4240638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348593, ExchCode = 'BIV' WHERE SecCode = 4242203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752408872, ExchCode = 'FRA' WHERE SecCode = 4248820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754379229, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4253036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 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 = 21754534080, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-07', PermSecMapEndDate = '2023-11-07' WHERE SecCode = 4259226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349639, ExchCode = 'BIV' WHERE SecCode = 4259231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756148826, ExchCode = 'MXQ' WHERE SecCode = 4273980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756680510, ExchCode = 'MUN', PermQuoteRetireDate = '2020-07-03' WHERE SecCode = 4274159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215789, ExchCode = 'DEU' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756809738, ExchCode = 'FRA' WHERE SecCode = 4275420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549155, ExchCode = 'FRA' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767996853, ExchCode = 'DEU' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757260470, ExchCode = 'DEU' WHERE SecCode = 4278855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757506160, ExchCode = 'FRA' WHERE SecCode = 4278857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534178673, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4282397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757668911, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4282400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360718, ExchCode = 'HAN' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759098748, ExchCode = 'FRA' WHERE SecCode = 4291265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 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, PermQuoteStatus = 'AC', Ticker = '9EG0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699218038, ExchCode = 'FRA' WHERE SecCode = 4298602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159899270, ExchCode = 'DEU' WHERE SecCode = 4298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696686071, ExchCode = 'STU' WHERE SecCode = 4298604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720132349, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4298606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679461, ExchCode = 'BIV' WHERE SecCode = 4298620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759524962, ExchCode = 'FRA' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760599386, ExchCode = 'FRA' WHERE SecCode = 4303570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760599450, ExchCode = 'FRA' WHERE SecCode = 4303583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760292838, ExchCode = 'MUN' WHERE SecCode = 4303589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759488721, ExchCode = 'STU' WHERE SecCode = 4303635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727343769, ExchCode = 'MEX' WHERE SecCode = 4303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143914, Ticker = '2TKWY', ExchCode = 'MIL' WHERE SecCode = 4309036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010963, Ticker = '2AMS' WHERE SecCode = 4309037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011282, Ticker = '2NB' WHERE SecCode = 4309038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143959, Ticker = '2RMS', ExchCode = 'MIL' WHERE SecCode = 4309039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010863, Ticker = '28TRA' WHERE SecCode = 4309041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143858, Ticker = '2ASM', ExchCode = 'MIL' WHERE SecCode = 4309043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012280, Ticker = '2FSLR' WHERE SecCode = 4309045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432057, ExchCode = 'DEU' 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 PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4320782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709366460, ExchCode = 'BIV' WHERE SecCode = 4324371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727341342, ExchCode = 'BIV' WHERE SecCode = 4324380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763489973, ExchCode = 'FRA' WHERE SecCode = 4324465 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 = 21763722641, ExchCode = 'DUS' WHERE SecCode = 4324504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112353, ExchCode = 'FRA' WHERE SecCode = 4324622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387283, ExchCode = 'LAS' WHERE SecCode = 4324721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112309, ExchCode = 'DEU' WHERE SecCode = 4328959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21867342843, ExchCode = 'TDG' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770634972, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700183761, ExchCode = 'MEX' WHERE SecCode = 4362644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877510586, ExchCode = 'MUN' WHERE SecCode = 4369859 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236805846657.0 WHERE SecCode = 4369879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772839734, ExchCode = 'DEU' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773404609, ExchCode = 'FRA' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606760, ExchCode = 'DEU' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510674, ExchCode = 'QTX' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774624846, ExchCode = 'STU' WHERE SecCode = 4379790 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 = 21960079950, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870599, ExchCode = 'FRA' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122676110, ExchCode = 'DEU' WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909357, ExchCode = 'DEU' WHERE SecCode = 4383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738812998, ExchCode = 'DUS' WHERE SecCode = 4383309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775812056, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-15' WHERE SecCode = 4385267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740524, ExchCode = 'LAS' WHERE SecCode = 4388200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777652111, ExchCode = 'FRA' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826495190, ExchCode = 'DUS' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780150286, ExchCode = 'MUN' WHERE SecCode = 4400153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777647867, ExchCode = 'TDG' WHERE SecCode = 4402301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778680774 WHERE SecCode = 4406073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909499, ExchCode = 'FRA' WHERE SecCode = 4413712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377495, ExchCode = 'BIV' WHERE SecCode = 4417298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780353097, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782664057, ExchCode = 'DEU', PermQuoteRetireDate = '2024-10-31', PermSecMapEndDate = '2024-10-31' WHERE SecCode = 4422563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775216637, ExchCode = 'TDG' WHERE SecCode = 4422567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999132, ExchCode = 'FRA' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816908115, ExchCode = 'TQE' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307218, ExchCode = 'BIV' WHERE SecCode = 4426954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783652671, ExchCode = 'DEU' WHERE SecCode = 4426955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727303270, ExchCode = 'BIV' WHERE SecCode = 4426957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783670602, ExchCode = 'EQD' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879563641, ExchCode = 'MUN', PermQuoteRetireDate = '2024-03-05', PermSecMapEndDate = '2024-03-05' WHERE SecCode = 4427929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785625686, ExchCode = 'DEU' WHERE SecCode = 4434305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785087297, ExchCode = 'FRA' WHERE SecCode = 4434390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685893, PermQuoteStatus = 'AC', Ticker = '60P0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 4444005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787491381, ExchCode = 'BER', PermQuoteRetireDate = '2021-01-05' WHERE SecCode = 4446127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787035686, ExchCode = 'FRA' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387348, ExchCode = 'LAS' WHERE SecCode = 4447601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788257884, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-28', PermSecMapEndDate = '2023-06-28' WHERE SecCode = 4449703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727299958, ExchCode = 'BIV' WHERE SecCode = 4449704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791469822, ExchCode = 'DUS' WHERE SecCode = 4451262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301153, ExchCode = 'BIV' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790867954, ExchCode = 'STU' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367131, ExchCode = 'FRA' WHERE SecCode = 4463145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689543, ExchCode = 'FRA' WHERE SecCode = 4463152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794257515, ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793399825, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4470175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797398508, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4470353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793674463, ExchCode = 'DUS' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897784749, ExchCode = 'GTX' 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 = 21896842819, ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-07' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367136, ExchCode = 'FRA' WHERE SecCode = 4482517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795226688, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-29', PermSecMapEndDate = '2023-06-29' WHERE SecCode = 4482720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727291863, ExchCode = 'MEX' WHERE SecCode = 4485970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805426109, ExchCode = 'DUS' WHERE SecCode = 4491934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780165906, ExchCode = 'MXQ' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809367, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820703, ExchCode = 'DEU' WHERE SecCode = 4499152 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 = 21797409262, ExchCode = 'FRA' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727286506, ExchCode = 'MEX' WHERE SecCode = 4505794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955219315, ExchCode = 'TDG' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800479537, ExchCode = 'DEU' WHERE SecCode = 4511506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802419041, ExchCode = 'TDG', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800727363, ExchCode = 'DEU' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800727419, ExchCode = 'DEU' WHERE SecCode = 4513650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801053714, ExchCode = 'MUN' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780960627, ExchCode = 'STU' WHERE SecCode = 4517645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430441, ExchCode = 'DEU' WHERE SecCode = 4526142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381380, ExchCode = 'LAS' WHERE SecCode = 4526143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851345226, ExchCode = 'MUN' WHERE SecCode = 4526144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890670000, PermQuoteStatus = 'DC', ExchCode = 'GTX', PermQuoteRetireDate = '2025-10-27' WHERE SecCode = 4527883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799910403, ExchCode = 'DEU' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803607182, ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-11', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803771918, ExchCode = 'DEU' WHERE SecCode = 4536450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802587261, ExchCode = 'STU' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219724, ExchCode = 'DEU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219797, ExchCode = 'DEU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786141623, ExchCode = 'MXQ' WHERE SecCode = 4547978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271946, ExchCode = 'BIV' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-16' WHERE SecCode = 4550721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274062, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806535085, ExchCode = 'MUN' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806550607, ExchCode = 'FRA' WHERE SecCode = 4553829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807265022, PermQuoteStatus = 'AC', Ticker = '3K7A', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4557860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140273543, ExchCode = 'BCO' WHERE SecCode = 4563419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811337148, ExchCode = 'STU' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '6DJ0', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 4565430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811019112, ExchCode = 'TDG' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22076466680, Ticker = 'XLMEd', ExchCode = 'BCO' WHERE SecCode = 4579626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286428, ExchCode = 'GTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 4585450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406482, ExchCode = 'FRA' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812606578, ExchCode = 'MUN', PermQuoteRetireDate = '2021-05-18' WHERE SecCode = 4589403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812848268, ExchCode = 'DEU' WHERE SecCode = 4590581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814382045, ExchCode = 'DEU' WHERE SecCode = 4594421 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 = 21815149494, ExchCode = 'STU' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814722256, ExchCode = 'DEU' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815153830, ExchCode = 'FRA' WHERE SecCode = 4603534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817036435, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-09' WHERE SecCode = 4607686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275562, ExchCode = 'GTX' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816241209, ExchCode = 'STU' WHERE SecCode = 4607717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816477347, ExchCode = 'MUN' WHERE SecCode = 4609998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727263610, ExchCode = 'BIV' WHERE SecCode = 4610049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816916392, ExchCode = 'DEU', PermQuoteRetireDate = '2023-05-11' WHERE SecCode = 4611056 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818128449, PermQuoteStatus = 'AC', Ticker = 'WWT0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4615948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878863900, ExchCode = 'BCO' WHERE SecCode = 4617708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818266412, ExchCode = 'DEU' WHERE SecCode = 4617743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527622, ExchCode = 'FRA' WHERE SecCode = 4618010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288266, ExchCode = 'GTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968078, ExchCode = 'DEU' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820389350, ExchCode = 'FRA' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884462002, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821041967, Ticker = '4KL0', ExchCode = 'DEU' WHERE SecCode = 4629496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821283375, ExchCode = 'FRA' WHERE SecCode = 4630664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820739202, ExchCode = 'DEU' WHERE SecCode = 4631954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963642, ExchCode = 'STU' WHERE SecCode = 4635203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823073549, ExchCode = 'DEU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 4638889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100069, ExchCode = 'FRA' WHERE SecCode = 4639636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854881328, ExchCode = 'GTX' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21934228224, ExchCode = 'STU', PermQuoteRetireDate = '2025-02-07', PermSecMapEndDate = NULL WHERE SecCode = 4643054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815337201, ExchCode = 'FRA' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823073655, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-12-22', PermSecMapEndDate = '2025-12-22' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087098, ExchCode = 'DEU' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824693646, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4649878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831908634, ExchCode = 'GTX' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21828832812, ExchCode = 'STU' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4659794 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4665908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795845914, ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793284943, PermQuoteStatus = 'AC', Ticker = '94Y', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 4682737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835615671, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316539, ExchCode = 'STU' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835314248, ExchCode = 'GTX' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832850911, ExchCode = 'FRA' WHERE SecCode = 4689999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837528978, ExchCode = 'DEU' WHERE SecCode = 4693647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619187, Ticker = 'CARBm', ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933374646, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2023-01-02' WHERE SecCode = 4697438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845076965, Ticker = 'V96', ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = NULL WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842579647, ExchCode = 'MUN' WHERE SecCode = 4705895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773003141, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-23' WHERE SecCode = 4707187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843909546, ExchCode = 'TDG' WHERE SecCode = 4718903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853430101, ExchCode = 'GTX' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850051602, ExchCode = 'TDG' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845567605, ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-06' WHERE SecCode = 4726108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851345317, ExchCode = 'STU' WHERE SecCode = 4748505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854742239, ExchCode = 'FRA' WHERE SecCode = 4761587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387339, ExchCode = 'LAS' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855114065, ExchCode = 'GTX' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439582, ExchCode = 'MUN', PermQuoteRetireDate = '2021-11-15' WHERE SecCode = 4773786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856518308, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4777235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856729893, ExchCode = 'DEU' WHERE SecCode = 4777352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857142963, ExchCode = 'STU' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857642068, ExchCode = 'FRA' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858471109, ExchCode = 'DEU', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = '2025-06-17' WHERE SecCode = 4787454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380489, ExchCode = 'LAS' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860307416, ExchCode = 'TDG' WHERE SecCode = 4800673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859821791, ExchCode = 'STO' WHERE SecCode = 4802290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727216819, ExchCode = 'MEX' WHERE SecCode = 4802294 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-16' WHERE SecCode = 4806706 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-16' WHERE SecCode = 4808967 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-16' WHERE SecCode = 4811131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886807336, ExchCode = 'GTX', PermQuoteRetireDate = '2025-01-15' WHERE SecCode = 4811144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862748816, ExchCode = 'DEU' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860858404, ExchCode = 'DEU' WHERE SecCode = 4813526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947043272, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4819881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580393, ExchCode = 'DEU' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580680, ExchCode = 'DEU' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398386, ExchCode = 'DEU' WHERE SecCode = 4834793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379540, ExchCode = 'LAS' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398797, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580391, ExchCode = 'FRA' WHERE SecCode = 4845032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871055968, ExchCode = 'GTX' WHERE SecCode = 4845045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885446303, ExchCode = 'GTX' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872586664, ExchCode = 'DEU' WHERE SecCode = 4873682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874645094, ExchCode = 'TDG' WHERE SecCode = 4885603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877551047, ExchCode = 'DEU' WHERE SecCode = 4907129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898654, ExchCode = 'FRA' WHERE SecCode = 4929498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796694010, ExchCode = 'GTX' WHERE SecCode = 4940671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885478177, ExchCode = 'FRA' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884460465, ExchCode = 'MUN' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, ExchCode = 'QTX' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689480, ExchCode = 'FRA' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887564482, ExchCode = 'QTX' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889560981, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4980098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212161, ExchCode = 'BIV' WHERE SecCode = 4980103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-16' WHERE SecCode = 5037305 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-16' WHERE SecCode = 5038693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902367523, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 5041763 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 = 236784380636, ExchCode = 'LAS' WHERE SecCode = 5047099 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-16' WHERE SecCode = 5052564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777145391, ExchCode = 'STU' WHERE SecCode = 5082548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718186332, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5099028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908066901, ExchCode = 'DEU' WHERE SecCode = 5102905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416293, ExchCode = 'TDG' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913082644, ExchCode = 'BER' WHERE SecCode = 5129748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-16' WHERE SecCode = 5152328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508526620, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21667329377, ExchCode = 'DEU' WHERE SecCode = 5161350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034611, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 5161351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21850514745, ExchCode = 'DEU' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948058908, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650207, ExchCode = 'DUS' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380662, ExchCode = 'LAS' WHERE SecCode = 5168258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173437, ExchCode = 'MEX' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922262943, ExchCode = 'DEU' WHERE SecCode = 5178622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922262866, ExchCode = 'DEU' WHERE SecCode = 5178623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931188804, ExchCode = 'STU' WHERE SecCode = 5189077 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 QuotePermID = 21930013447, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5230330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930012307, ExchCode = 'DEU' WHERE SecCode = 5230331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930012813, PermQuoteStatus = 'AC', Ticker = 'VJ30', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5230332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930012474, ExchCode = 'DEU' 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 = 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 = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938339192, ExchCode = 'MUN' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793674806, ExchCode = 'LAS' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107117, ExchCode = 'MEX' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21942349169, ExchCode = 'QTX' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956352320, ExchCode = 'TDG' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782434087, ExchCode = 'STU' WHERE SecCode = 5343608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952265408, ExchCode = 'DEU' WHERE SecCode = 5347429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776104211, Ticker = 'ACAG', ExchCode = 'VIE' WHERE SecCode = 5372903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957797642, ExchCode = 'DEU' WHERE SecCode = 5374832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957768163, ExchCode = 'FRA', PermQuoteRetireDate = '2024-10-07' WHERE SecCode = 5374833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028052111, ExchCode = 'DEU' WHERE SecCode = 5374858 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 = 236782758791, ExchCode = 'MUN' WHERE SecCode = 5393777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777223518, ExchCode = 'FRA' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812181526, ExchCode = 'FRA' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727202565, ExchCode = 'BIV' WHERE SecCode = 5411550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777359860, ExchCode = 'FRA' WHERE SecCode = 5413669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727169122, Ticker = 'CAMBIo', ExchCode = 'SIG' WHERE SecCode = 5448761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21974979681, ExchCode = 'QTX' WHERE SecCode = 5458313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778108786, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726336464, ExchCode = 'FRA' WHERE SecCode = 5466446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778299986, ExchCode = 'FRA' WHERE SecCode = 5468673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193596, ExchCode = 'MEX' WHERE SecCode = 5474598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778397152, ExchCode = 'FRA' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416291, ExchCode = 'FRA' WHERE SecCode = 5476926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729828, ExchCode = 'FRA' WHERE SecCode = 5478214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778456487, ExchCode = 'FRA' WHERE SecCode = 5479512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778437243, ExchCode = 'MEX' WHERE SecCode = 5482856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778704118, ExchCode = 'FRA' WHERE SecCode = 5493665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727277710, ExchCode = 'BIV' WHERE SecCode = 5503675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835698, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538283057, PermQuoteStatus = 'AC', Ticker = 'ZE2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011031, Ticker = '2TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835708, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834825, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834837, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882467041, Ticker = 'BTCW', ExchCode = 'SWX' WHERE SecCode = 5509588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22002744025, Ticker = 'USFA', ExchCode = 'SWX' WHERE SecCode = 5516823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779059190, ExchCode = 'FRA' WHERE SecCode = 5516829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787393619, ExchCode = 'TDG' WHERE SecCode = 5523278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619181, ExchCode = 'BTE' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779292324, ExchCode = 'FRA' WHERE SecCode = 5527560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779292327, ExchCode = 'FRA' WHERE SecCode = 5527561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834912, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534998 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 = 21917834847, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471348, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5541732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608956, ExchCode = 'FRA' WHERE SecCode = 5551977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779690391, ExchCode = 'STU' WHERE SecCode = 5552002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786101497, ExchCode = 'DEU' WHERE SecCode = 5553189 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 = 21881555404, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580185, ExchCode = 'DEU' WHERE SecCode = 5569302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034589, ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-30' WHERE SecCode = 5569318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970293165, ExchCode = 'MUN' WHERE SecCode = 5569360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110915, Ticker = '3MRNm', ExchCode = 'BCO' WHERE SecCode = 5569367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982665105, ExchCode = 'MXQ' WHERE SecCode = 5569424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522671160, PermQuoteStatus = 'AC', Ticker = 'YE20', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883771506, ExchCode = 'FRA', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 5569960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780515980, ExchCode = 'FRA' WHERE SecCode = 5607542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852456313, ExchCode = 'BRN' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780661116, ExchCode = 'DUS' WHERE SecCode = 5620203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781224681, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780872941, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-22' WHERE SecCode = 5633493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966434, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-12' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460745, ExchCode = 'FRA' WHERE SecCode = 5638832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22065452994, ExchCode = 'BRN' WHERE SecCode = 5645885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781543275, ExchCode = 'STU' WHERE SecCode = 5655040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986191813, Ticker = '3TSE', ExchCode = 'GTX' WHERE SecCode = 5663514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781343894, ExchCode = 'TDG' WHERE SecCode = 5663580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607151, ExchCode = 'FRA' WHERE SecCode = 5663968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781954019, ExchCode = 'FRA' WHERE SecCode = 5687951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781981056, ExchCode = 'BIV' WHERE SecCode = 5701235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782144639, ExchCode = 'TDG' WHERE SecCode = 5703062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782254675, ExchCode = 'FRA' WHERE SecCode = 5710467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782563848, ExchCode = 'FRA' WHERE SecCode = 5722406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028890941, ExchCode = 'FRA' WHERE SecCode = 5724940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782605876, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5731401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22029843737, ExchCode = 'DEU' WHERE SecCode = 5731412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782653830, ExchCode = 'FRA' WHERE SecCode = 5731414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782771597, ExchCode = 'FRA' WHERE SecCode = 5740795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928831, Ticker = 'SOXLm', ExchCode = 'BCO' WHERE SecCode = 5740824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153928832, Ticker = 'MAG7m', ExchCode = 'BCO' WHERE SecCode = 5740826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22119690921, ExchCode = 'BCO' WHERE SecCode = 5740827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128284, Ticker = 'SMCIm', ExchCode = 'BCO' WHERE SecCode = 5740830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153246014, ExchCode = 'BTE' WHERE SecCode = 5740832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772235078, ExchCode = 'TDG' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783009907, ExchCode = 'STU' WHERE SecCode = 5758113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812186220, ExchCode = 'FRA' WHERE SecCode = 5760234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783529905, ExchCode = 'FRA' WHERE SecCode = 5764717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154587717, ExchCode = 'BCO' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22092544696, Ticker = 'RZ8B', ExchCode = 'DEU' WHERE SecCode = 5782810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608791, ExchCode = 'BIV' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784107272, ExchCode = 'FRA' WHERE SecCode = 5817022 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 = 236784377679, ExchCode = 'STU' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784377678, ExchCode = 'FRA' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421390, ExchCode = 'BIV' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 5842997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804071845, ExchCode = 'FRA' WHERE SecCode = 5853173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784890672, ExchCode = 'FRA' WHERE SecCode = 5857780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735452563, ExchCode = 'DEU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086035577, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5897569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785943776, ExchCode = 'FRA' WHERE SecCode = 5907872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784888212, ExchCode = 'MEX' WHERE SecCode = 5907884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790682427, PermQuoteStatus = 'DC', Ticker = '83W0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5928247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795664145, ExchCode = 'BIV' WHERE SecCode = 6014420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814536624, ExchCode = 'TDG' 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 = 21836309872, Ticker = '3SPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 6097408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829806, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409290, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6097431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21972857485, ExchCode = 'MXQ' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 6097473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999588395, ExchCode = 'TRQ' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993578552, ExchCode = 'BTE' WHERE SecCode = 6097606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086901855, ExchCode = 'GTX' WHERE SecCode = 6104636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791667937, ExchCode = 'BIV' WHERE SecCode = 6226138 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 6371486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794459345, ExchCode = 'FRA' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794542874, ExchCode = 'BIV' WHERE SecCode = 6416397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122679002, ExchCode = 'DEU' WHERE SecCode = 6416433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795246905, ExchCode = 'FRA' WHERE SecCode = 6443223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125760536, ExchCode = 'MIL' WHERE SecCode = 6453964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796521884, ExchCode = 'FRA' WHERE SecCode = 6480863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796521968, ExchCode = 'FRA' WHERE SecCode = 6480864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796521993, ExchCode = 'FRA' WHERE SecCode = 6480866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796059935, ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-26' WHERE SecCode = 6480954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938208, ExchCode = 'FRA' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938213, ExchCode = 'FRA' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938212, ExchCode = 'FRA' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938214, ExchCode = 'FRA' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107740, ExchCode = 'FRA' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798107743, ExchCode = 'FRA' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798269870, ExchCode = 'FRA' WHERE SecCode = 6528817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798269868, ExchCode = 'FRA' WHERE SecCode = 6528818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798142642, ExchCode = 'TDG' WHERE SecCode = 6528824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799474943, ExchCode = 'FRA' WHERE SecCode = 6577960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607052, Ticker = 'MRNA', ExchCode = 'SWX' WHERE SecCode = 6578363 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 = 236799607078, Ticker = 'ON', ExchCode = 'SWX' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799956966, ExchCode = 'QTX' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955916, ExchCode = 'FRA' WHERE SecCode = 6587160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957446, ExchCode = 'FRA' WHERE SecCode = 6587161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144809594, ExchCode = 'QTX' WHERE SecCode = 6587170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800096573, ExchCode = 'FRA' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800709238, ExchCode = 'QTX' WHERE SecCode = 6596130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778200748, ExchCode = 'FRA' WHERE SecCode = 6626357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833039, ExchCode = 'MEX' WHERE SecCode = 6628690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804071819, ExchCode = 'TDG' WHERE SecCode = 6628841 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 6629297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802226956, ExchCode = 'GER' WHERE SecCode = 6635226 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 6638009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172087694, ExchCode = 'FRA' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802456204, ExchCode = 'DUS' WHERE SecCode = 6638341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471207, ExchCode = 'QTX' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804168533, ExchCode = 'STU' WHERE SecCode = 6724297 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6724322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536844, ExchCode = 'FRA' WHERE SecCode = 6728367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536839, ExchCode = 'FRA' WHERE SecCode = 6728368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536834, ExchCode = 'FRA' WHERE SecCode = 6728370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536841, ExchCode = 'FRA' WHERE SecCode = 6728371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536846, ExchCode = 'FRA' WHERE SecCode = 6728372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536845, ExchCode = 'FRA' WHERE SecCode = 6728373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536945, ExchCode = 'FRA' WHERE SecCode = 6728374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536835, ExchCode = 'FRA' WHERE SecCode = 6728375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536836, ExchCode = 'FRA' WHERE SecCode = 6728377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804536831, ExchCode = 'FRA' WHERE SecCode = 6728378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799175957, ExchCode = 'MEX' WHERE SecCode = 6728383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167303875, ExchCode = 'DUS' WHERE SecCode = 6728389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804483784, ExchCode = 'STU' WHERE SecCode = 6728400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805095498, ExchCode = 'DUS' WHERE SecCode = 6753078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699530, ExchCode = 'MEX' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 6756509 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 6762066 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 6762075 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-17' WHERE SecCode = 6773035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173838136, ExchCode = 'TDG' WHERE SecCode = 6773143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805847059, ExchCode = 'QTX' WHERE SecCode = 6776286 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 6779467 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 6779510 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6782575 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-16' WHERE SecCode = 6782580 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6782589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805776179, ExchCode = 'MUN' WHERE SecCode = 6782676 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236805705796.0, IsPrimaryQuote = 1 WHERE SecCode = 6782702 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236805705798.0, IsPrimaryQuote = 1 WHERE SecCode = 6782703 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236805776087.0, IsPrimaryQuote = 1 WHERE SecCode = 6786366 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 236805776086.0, IsPrimaryQuote = 1 WHERE SecCode = 6786368 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6786369 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6786370 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6786373 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6786555 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 10964740 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'LCHIF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-16', PermSecMapEndDate = NULL WHERE SecCode = 11059884 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 11108968 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951740.0 WHERE SecCode = 11111361 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'P' WHERE SecCode = 11152585 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 11161525 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11190562 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11191167 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805784996, ExchCode = 'NAS', PermSecMapStartDate = '2026-04-16' WHERE SecCode = 11198767 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'RADLF' WHERE SecCode = 11199082 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 11199850 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11231953 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 11234694 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11269127 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 11277357 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11278158 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236804840324, InstrPermID = 232925343954, OrgPermID = 5097043523, PriTrdQuotePermID = NULL, ValQuotePermID = 236804840324.0, PriInstrPermID = 232925343954.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'XNDU', ExchCode = 'TOR', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951211.0, PermQuoteRetireDate = NULL, PermOrgIPODate = '2026-03-27', PermSecMapStartDate = '2026-03-26', PermSecMapEndDate = NULL WHERE SecCode = 11278379 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 11286987 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 11286990 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 11286992 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 11290715 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 11290773 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11292424 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-21' WHERE SecCode = 11292575 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11293452 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805703971, IsPrimaryQuote = 1, ExchCode = 'TOR' WHERE SecCode = 11294571 AND Type_ = 1;
