UPDATE data_universe_permid SET QuotePermID = 55838296539, Ticker = 'AAT.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 13 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838299316, PermQuoteStatus = 'DC', Ticker = 'GL9.IE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475209432, InstrPermID = 21475209431, ValQuotePermID = 21475209432.0 WHERE SecCode = 3582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475788761, Ticker = 'KFXl', ExchCode = 'BTE', PermQuoteRetireDate = '2015-03-31' WHERE SecCode = 3735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475264179, InstrPermID = 21475264178, ValQuotePermID = 21475264179.0 WHERE SecCode = 4311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836055300, PermQuoteStatus = 'AC', Ticker = '0P6O', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538768656, Ticker = 'PCIl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-09-27' WHERE SecCode = 4613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622176, Ticker = '0R1Ml', ExchCode = 'BCO' WHERE SecCode = 4727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475442988, Ticker = NULL, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757506064, Ticker = 'GECl', ExchCode = 'BCO', PermQuoteRetireDate = '2024-11-11' WHERE SecCode = 5363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847126763, Ticker = 'HTIA.GB', ExchCode = 'PLU' WHERE SecCode = 5899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475106512, Ticker = 'T6C', ExchCode = 'XIM', PermQuoteRetireDate = '2013-12-14' WHERE SecCode = 6070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836052858, PermQuoteStatus = 'AC', Ticker = 'HKLB', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 6257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515262838, Ticker = 'H78', ExchCode = 'LSE', PermQuoteRetireDate = '2015-06-22' WHERE SecCode = 6260 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 14577 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 15286 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 25213 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951550.0 WHERE SecCode = 26952 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667704560, ExchCode = 'MXQ' WHERE SecCode = 30131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705493, ExchCode = 'MXQ' WHERE SecCode = 30156 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 30893 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 30894 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 30895 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836394620, ExchCode = 'FRA', PermQuoteRetireDate = '2022-04-01' WHERE SecCode = 34155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481323, PermQuoteStatus = 'AC', Ticker = 'ALD', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 34314 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 = 21475645951, Ticker = 'APCd', ExchCode = 'CXE', PermQuoteRetireDate = '2012-02-13' WHERE SecCode = 34584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722222275, Ticker = 'BTL', ExchCode = 'GER', PermQuoteRetireDate = '2022-08-15' WHERE SecCode = 34672 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 = 21521794348, ExchCode = 'SIG', PermQuoteRetireDate = '2013-10-04' WHERE SecCode = 35062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475201904, Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 35078 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 = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337359, ExchCode = 'BER' WHERE SecCode = 37437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851139058, ExchCode = 'TDG' WHERE SecCode = 38188 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 38240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688299118, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 40818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535281474, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-11' WHERE SecCode = 41008 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951441.0 WHERE SecCode = 41285 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 42032 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 42761 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 42884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805530600, PermQuoteStatus = 'DC', Ticker = 'COYd', ExchCode = 'BTE', PermQuoteRetireDate = '2026-04-21', PermSecMapStartDate = '2026-06-09' WHERE SecCode = 44054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474859691, ExchCode = 'DEU' WHERE SecCode = 44084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520650353, ExchCode = 'MUN' WHERE SecCode = 44086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140269822, ExchCode = 'DEU' WHERE SecCode = 44151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732784567, ExchCode = 'DEU' WHERE SecCode = 44254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533839980, ExchCode = 'FRA' WHERE SecCode = 44260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702459158, Ticker = 'CPZ1d', ExchCode = 'BCO' WHERE SecCode = 44270 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951344.0 WHERE SecCode = 45372 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 45542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475508564, PermQuoteStatus = 'DC', Ticker = 'RHP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399711, ExchCode = 'FRA' WHERE SecCode = 47291 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 48205 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 49805 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 49809 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 49931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908261107, Ticker = '6MKd', ExchCode = 'EQD' WHERE SecCode = 50904 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 51004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016560, ExchCode = 'TDG' WHERE SecCode = 51369 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 51541 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 51929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475090488, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-06' WHERE SecCode = 52116 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642496487, ExchCode = 'CHI' WHERE SecCode = 52632 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 53105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519377, PermQuoteStatus = 'AC', Ticker = 'CPF', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 53315 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2018-12-17', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 53341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589629, Ticker = NULL, ExchCode = 'HAM', DomCntry = 'USA', PermQuoteRetireDate = '2006-05-17' WHERE SecCode = 53991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475576317, ExchCode = 'STU', PermQuoteRetireDate = '2008-01-07' WHERE SecCode = 54284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835776502, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2017-02-06', PermSecMapEndDate = '2017-02-06' WHERE SecCode = 54449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491562, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 54451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21918984188, Ticker = 'QH9d', ExchCode = 'TRQ' WHERE SecCode = 54545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475417008, ExchCode = 'MUN', PermQuoteRetireDate = '2009-11-19' WHERE SecCode = 54686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293996, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 55631 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951641.0 WHERE SecCode = 57526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712107760, ExchCode = 'MUN' WHERE SecCode = 58724 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805530587, PermQuoteStatus = 'DC', Ticker = 'SE4d', ExchCode = 'BTE', PermQuoteRetireDate = '2026-04-21', PermSecMapStartDate = '2026-06-09' WHERE SecCode = 59894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475248717, ExchCode = 'STU', PermQuoteRetireDate = '2005-12-20' WHERE SecCode = 59993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475453806, Ticker = 'GTGG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 60026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485512, ExchCode = 'QTX' WHERE SecCode = 60224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805534514, PermQuoteStatus = 'DC', Ticker = 'IX1d', ExchCode = 'SIU', PermQuoteRetireDate = '2026-04-22', PermSecMapStartDate = '2026-06-09' WHERE SecCode = 60267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399460, PermQuoteStatus = 'AC', Ticker = 'ESH', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 60348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334940, ExchCode = 'BER' WHERE SecCode = 60373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293945, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 60456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531132175, Ticker = 'NSUd', ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790766, ExchCode = 'GTX' WHERE SecCode = 60683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838542274, ExchCode = 'STU', PermQuoteRetireDate = '2011-06-08' WHERE SecCode = 60772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836529681, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950806, ExchCode = 'STU' WHERE SecCode = 61012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548206934, ExchCode = 'DEU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805161989, ExchCode = 'BTE' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475360809, ExchCode = 'GER' WHERE SecCode = 61743 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 61754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836463221, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 61930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641550, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 61952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475575563, Ticker = 'ACOM.I', ExchCode = 'CST', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 61968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323024, ExchCode = 'BER' WHERE SecCode = 62105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475607241, PermQuoteStatus = 'DC', Ticker = 'AKDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 62376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339451, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 62511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856722233, ExchCode = 'MUN', PermQuoteRetireDate = '2023-01-05', PermSecMapEndDate = '2023-01-05' WHERE SecCode = 62512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521936083, ExchCode = 'STU' WHERE SecCode = 62558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838751244, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL WHERE SecCode = 62963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482551, ExchCode = 'QTX' WHERE SecCode = 63004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223877, ExchCode = 'QTX' WHERE SecCode = 63011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333924, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 63016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789211097, ExchCode = 'DEU' WHERE SecCode = 63138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338795, Ticker = 'NC91', ExchCode = 'BER', PermQuoteRetireDate = '2025-11-07' WHERE SecCode = 63145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475611317, Ticker = 'ESDA.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 63218 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034856, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 63223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856248191, ExchCode = 'DUS', PermQuoteRetireDate = '2016-04-06' WHERE SecCode = 63618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955953, ExchCode = 'TDG' WHERE SecCode = 63841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564888808, ExchCode = 'DEU' WHERE SecCode = 63846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331733, Ticker = 'ISC1', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 64275 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 64492 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 64983 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475429918, ExchCode = 'GER' WHERE SecCode = 65261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475608426, Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 65270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474994385, ExchCode = 'STU' WHERE SecCode = 65298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474894114, ExchCode = 'DEU' WHERE SecCode = 65308 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236808161669.0, Ticker = 'ELOX', ExchCode = 'NAQ' WHERE SecCode = 69221 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 69402 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 75203 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 85031 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 85334 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 89094 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 89948 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 94249 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'TEA.H', ExchCode = 'NEX' WHERE SecCode = 99954 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 101069 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 101206 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 101371 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 101487 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 101520 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 101556 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 101835 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102205 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102211 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102229 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102410 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102413 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102537 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102602 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102626 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102628 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102635 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102636 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102637 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102638 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102641 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102642 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102658 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102737 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102859 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102983 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 102999 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 103159 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 103162 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 103818 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 104425 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 111499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369672, ExchCode = 'BIV' WHERE SecCode = 113051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805613142, PermQuoteStatus = 'DC', Ticker = 'WB2d', ExchCode = 'CHI', PermQuoteRetireDate = '2026-04-21', PermSecMapStartDate = '2026-06-09' WHERE SecCode = 113190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490519, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 113217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537960958, ExchCode = 'FRA' WHERE SecCode = 113326 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 115256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298416, ExchCode = 'DEU' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381737, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419464, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179548619, ExchCode = 'DEU' WHERE SecCode = 119132 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 120408 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 123713 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21819276478, ExchCode = 'DUS' WHERE SecCode = 124617 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 125302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682712570, ExchCode = 'STU', PermQuoteRetireDate = '2022-04-05' WHERE SecCode = 128755 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 132607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486913, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 133354 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 134720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997854, ExchCode = 'DEU' WHERE SecCode = 138040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556645874, ExchCode = 'BER', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758740665, ExchCode = 'TDG', PermQuoteRetireDate = '2024-12-19' WHERE SecCode = 138261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22008268303, ExchCode = 'DEU' WHERE SecCode = 138279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807446056, ExchCode = 'DEU' WHERE SecCode = 138280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492707893, ExchCode = 'STU' WHERE SecCode = 138285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475524556, Ticker = 'H1B', ExchCode = 'STU', PermQuoteRetireDate = '2009-09-14' WHERE SecCode = 138286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843446933, ExchCode = 'GER' WHERE SecCode = 138806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620652758, ExchCode = 'DEU', PermQuoteRetireDate = '2017-10-11' WHERE SecCode = 139011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543203134, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-14' WHERE SecCode = 139013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481367141, ExchCode = 'STU' WHERE SecCode = 139159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840759896, ExchCode = 'BER', PermQuoteRetireDate = '2012-02-23' WHERE SecCode = 139165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834295, ExchCode = 'DEU', PermQuoteRetireDate = '2014-12-29' WHERE SecCode = 139167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770643591, ExchCode = 'FRA' WHERE SecCode = 139233 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 140784 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 142401 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 142567 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 142629 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 142650 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2019-04-12' WHERE SecCode = 142898 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 144526 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 144730 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808183780, ExchCode = 'TDG', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 145502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799369548, ExchCode = 'FRA' WHERE SecCode = 145505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527792570, ExchCode = 'FRA' WHERE SecCode = 145508 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 145910 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 146306 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951358.0 WHERE SecCode = 147015 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 147098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799115746, ExchCode = 'QTX' WHERE SecCode = 147190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051248, ExchCode = 'TDG' WHERE SecCode = 160971 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 174635 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951441.0 WHERE SecCode = 177493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818252156, ExchCode = 'MUN' WHERE SecCode = 178350 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 189269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954813, ExchCode = 'LAS' WHERE SecCode = 190498 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 199021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544954898, ExchCode = 'FRA' WHERE SecCode = 208922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527643731, ExchCode = 'STU' WHERE SecCode = 208947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175714363, ExchCode = 'DEU' WHERE SecCode = 208948 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 209904 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 223449 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 248895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805232600, PermQuoteStatus = 'DC', Ticker = 'CXUd', ExchCode = 'BTE', PermQuoteRetireDate = '2026-04-22', PermSecMapStartDate = '2026-06-09' WHERE SecCode = 249652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732157066, ExchCode = 'FRA' WHERE SecCode = 249655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548019324, ExchCode = 'DEU' WHERE SecCode = 249656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506591483, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 249666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790403565, ExchCode = 'FRA' WHERE SecCode = 249684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710963783, ExchCode = 'TDG', PermQuoteRetireDate = '2021-05-25' WHERE SecCode = 249688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535408623, ExchCode = 'STU' WHERE SecCode = 249695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512748791, ExchCode = 'STU', PermQuoteRetireDate = '2019-05-07' WHERE SecCode = 249704 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236808161669.0 WHERE SecCode = 249865 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 292722 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 294802 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951609.0 WHERE SecCode = 317351 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 317486 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951177.0 WHERE SecCode = 347979 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 391687 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'IDN' WHERE SecCode = 393864 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951344.0 WHERE SecCode = 412570 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 434236 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 507747 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 510592 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 519169 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 519171 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 519353 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 519434 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 519564 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 522526 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 529484 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 534984 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 534986 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 534987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307216, ExchCode = 'BIV' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 545002 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 547504 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 549433 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SHR' WHERE SecCode = 551009 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 552448 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 553420 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 554246 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 555882 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 555937 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 555942 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 555955 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 555974 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 556045 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 556058 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 557679 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 557727 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 557728 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 557775 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 557893 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 557916 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 557920 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951177.0 WHERE SecCode = 565302 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 593164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859230062, ExchCode = 'FRA', PermQuoteRetireDate = '2016-11-03' WHERE SecCode = 598098 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991761, ExchCode = 'MUN' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 656218 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391671, ExchCode = 'GTX' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703147 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703153 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703154 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703166 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703167 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703174 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703176 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703177 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703179 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703181 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703182 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703186 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703205 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703207 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703218 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703232 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703235 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703239 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703241 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703254 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703255 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703288 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703302 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703308 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703310 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703318 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703321 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703350 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703353 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703358 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703373 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703374 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703377 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703382 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703385 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703397 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703410 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703440 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 703484 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 706299 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 706300 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 709575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475065394, ExchCode = 'FRA', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 780725 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 802721 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 802726 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09' WHERE SecCode = 863099 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 890820 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 896531 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 903275 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 907511 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 907513 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 907514 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 907582 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1012880 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2015-08-03' WHERE SecCode = 1012884 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1065401 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1095599 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1104376 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1109391 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1111756 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1126867 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 1185872 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 1226331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 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 PermInstrStatus = 'DC' WHERE SecCode = 1469481 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 1480259 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 1488108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494566098, ExchCode = 'STU' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802786, Ticker = 'PU7D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1538561 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1538563 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 1569478 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1588841 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1619944 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631772 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631778 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631784 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631787 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631802 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631803 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631807 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631808 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631813 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631816 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631827 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631828 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631832 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631838 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631852 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631853 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631854 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631860 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631869 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631877 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631885 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631886 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631887 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631897 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631905 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631911 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631912 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631923 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631926 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631927 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631928 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631932 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631937 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631938 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631943 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631954 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631955 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2017-01-11' WHERE SecCode = 1631958 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631960 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631963 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631971 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631976 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631981 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631982 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631983 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631986 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631988 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631991 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1631998 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632000 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632003 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632007 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632017 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632019 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632022 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632024 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632028 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapStartDate = '2016-04-06' WHERE SecCode = 1632031 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632037 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632041 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632042 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632044 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1632046 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1633675 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1633677 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1633688 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1647855 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1649936 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1668712 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1673137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512412458, Ticker = 'CTY1SN011', ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511262189, ExchCode = 'DEU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1694050 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1703164 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1703166 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1703167 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1703205 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1703209 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1705620 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1705621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685426483, ExchCode = 'MUN' WHERE SecCode = 1707747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641955269, ExchCode = 'FRA' WHERE SecCode = 1707749 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1708941 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1708945 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1708950 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1712314 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1712320 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1713647 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1720509 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1721140 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1721141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22108941010, ExchCode = 'DEU' WHERE SecCode = 1733285 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 1975143 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1996002 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2013022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802866853, ExchCode = 'DEU' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2071779 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2071785 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2071788 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2082539 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2082567 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2082568 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2101001 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2101002 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2101004 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2101006 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2101043 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2102890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659437, ExchCode = 'GTX' WHERE SecCode = 2115214 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 PermInstrStatus = 'DC' WHERE SecCode = 2160634 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2164413 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2164415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531116946, ExchCode = 'BCO', PermQuoteRetireDate = '2024-07-03' WHERE SecCode = 2195912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SUZ' WHERE SecCode = 2204916 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2217667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681375843, ExchCode = 'MUN' WHERE SecCode = 2222230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522133570, ExchCode = 'STU' WHERE SecCode = 2222349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834226, ExchCode = 'DEU' WHERE SecCode = 2225286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604521803, Ticker = '4BB', ExchCode = 'MUN', PermQuoteRetireDate = '2019-01-10' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2227871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 2239273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781570154, ExchCode = 'DUS' WHERE SecCode = 2239280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523563646, ExchCode = 'DEU' WHERE SecCode = 2239343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531603865, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 2241776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789017062, ExchCode = 'DUS' WHERE SecCode = 2246863 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2249223 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2249225 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2249235 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2251490 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2251491 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2251492 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2251493 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2251494 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2251497 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2251498 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2251500 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2253357 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2255730 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068269, ExchCode = 'DEU' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652141579, ExchCode = 'EQD' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590303284, ExchCode = 'TDG' WHERE SecCode = 2267521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525967894, ExchCode = 'MUN' WHERE SecCode = 2278245 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 PermInstrStatus = 'DC' WHERE SecCode = 2282834 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2282837 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2282838 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2282843 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2282844 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2289239 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2289244 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2289268 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2292943 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2324942 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2333778 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2350924 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2350926 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2350931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781180887, ExchCode = 'TDG' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2368132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21779363674, ExchCode = 'FRA' WHERE SecCode = 2379809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384853, ExchCode = 'LAS' WHERE SecCode = 2388898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538722817, ExchCode = 'STU' WHERE SecCode = 2391351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803110077, ExchCode = 'FRA' WHERE SecCode = 2391353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532252447, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-11' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535281436, ExchCode = 'STU' WHERE SecCode = 2403143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272916, ExchCode = 'GTX' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2430010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21534457668, ExchCode = 'FRA' WHERE SecCode = 2452397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842579738, ExchCode = 'BER' WHERE SecCode = 2458822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787783, ExchCode = 'DUS' WHERE SecCode = 2462633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197362, Ticker = 'MRK', ExchCode = 'BRN' WHERE SecCode = 2465112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536043370, ExchCode = 'FRA', PermQuoteRetireDate = '2018-11-19' WHERE SecCode = 2467266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387906, ExchCode = 'LAS' WHERE SecCode = 2470092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800660442, ExchCode = 'DUS' WHERE SecCode = 2482710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537032595, ExchCode = 'BER' WHERE SecCode = 2495669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907918, ExchCode = 'FRA' WHERE SecCode = 2518703 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 = 21869000361, ExchCode = 'FRA', PermSecMapEndDate = NULL WHERE SecCode = 2529650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539179038, ExchCode = 'DEU' WHERE SecCode = 2532820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618954036, ExchCode = 'STU' WHERE SecCode = 2532826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798387589, ExchCode = 'HAM' WHERE SecCode = 2542451 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2554962 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2554964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368826, ExchCode = 'DEU' WHERE SecCode = 2558484 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2558507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2583483 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2583484 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2583486 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2583488 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2584774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181314867, ExchCode = 'OCE' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2598106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2600914 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2601941 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2601943 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2603275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664823736, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2604394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805530590, PermQuoteStatus = 'DC', Ticker = 'SFEd', ExchCode = 'BTE', PermQuoteRetireDate = '2026-04-21', PermSecMapStartDate = '2026-06-09' WHERE SecCode = 2605866 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 2616460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548012753, ExchCode = 'DEU' WHERE SecCode = 2640373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557589745, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-30' WHERE SecCode = 2642445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779391120, ExchCode = 'GTX' WHERE SecCode = 2642446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370299, ExchCode = 'GTX' WHERE SecCode = 2642447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548204121, ExchCode = 'FRA' WHERE SecCode = 2644168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2650540 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2650624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2658238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549411041, ExchCode = 'FRA', PermQuoteRetireDate = '2017-11-02' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2682197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607245, Ticker = 'HL', ExchCode = 'SWX' WHERE SecCode = 2682233 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 2696735 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2697132 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697157 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533308745, ExchCode = 'FRA' WHERE SecCode = 2747656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198687, ExchCode = 'BIV' WHERE SecCode = 2750976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554500349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-03' WHERE SecCode = 2750984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790104617, ExchCode = 'QTX' WHERE SecCode = 2764598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367198, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 2770609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557544156, ExchCode = 'FRA' WHERE SecCode = 2817416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770216367, Ticker = 'T05', ExchCode = 'BER', PermQuoteRetireDate = '2024-12-20' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275235, ExchCode = 'GTX' WHERE SecCode = 2830909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2857044 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2866618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561901515, ExchCode = 'FRA', PermQuoteRetireDate = '2023-10-03' WHERE SecCode = 2873688 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2882492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 2897580 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 2902829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073079957, ExchCode = 'TDG' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564677908, ExchCode = 'FRA' WHERE SecCode = 2909231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21600289186, Ticker = 'MMAT', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 2909232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 2926138 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 2934138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062311, ExchCode = 'MUN' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851158658, ExchCode = 'DEU' WHERE SecCode = 2975172 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2980488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488199, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 3011194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431770, ExchCode = 'DEU' WHERE SecCode = 3026614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575706656, ExchCode = 'STU' WHERE SecCode = 3026615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591864421, ExchCode = 'STU' WHERE SecCode = 3030075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575930919, ExchCode = 'FRA' WHERE SecCode = 3031598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589172354, ExchCode = 'STU' WHERE SecCode = 3032214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830306482, ExchCode = 'GTX' WHERE SecCode = 3038477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872272, ExchCode = 'DEU' WHERE SecCode = 3055016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640538037, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-17' WHERE SecCode = 3056842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788253475, ExchCode = 'MEX' WHERE SecCode = 3060652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619609100, ExchCode = 'MUN' WHERE SecCode = 3065856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759241355, ExchCode = 'MUN' WHERE SecCode = 3074354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586927375, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-22', PermSecMapEndDate = '2020-07-09' WHERE SecCode = 3076717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597183902, ExchCode = 'DEU' WHERE SecCode = 3090270 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 3167381 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 = 21667492372, ExchCode = 'QTX' WHERE SecCode = 3184009 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3213381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21966235983, ExchCode = 'DEU' WHERE SecCode = 3215818 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'KEOC' WHERE SecCode = 3219525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629958134, ExchCode = 'TDG' WHERE SecCode = 3222698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595464532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3229527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478399, ExchCode = 'QTX' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597621838, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2016-12-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 3255528 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3277251 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277333 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277376 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3281889 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 3285598 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951177.0 WHERE SecCode = 3289392 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-09' WHERE SecCode = 3289743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21639225339, Ticker = 'KYH0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3305367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3316989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679409, ExchCode = 'BIV' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613133530, ExchCode = 'DEU' WHERE SecCode = 3319856 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 3341056 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614367734, ExchCode = 'AUX' WHERE SecCode = 3347816 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'IDN' WHERE SecCode = 3352133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627708, ExchCode = 'QTX' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819145774, PermQuoteStatus = 'AC', Ticker = '015A', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3375389 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 3377791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320047, ExchCode = 'FRA' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864390192, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 3379451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378814, ExchCode = 'BRN' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378638, ExchCode = 'BRN' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3394972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100842, ExchCode = 'DUS' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705811, Ticker = 'TLNDN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624076661, ExchCode = 'BEC' WHERE SecCode = 3406544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679932, ExchCode = 'BIV' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630022342, ExchCode = 'STU' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175400111, ExchCode = 'DEU' WHERE SecCode = 3408941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644149855, ExchCode = 'DEU' WHERE SecCode = 3409040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301441, ExchCode = 'MEX' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236808161669.0 WHERE SecCode = 3410190 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3430206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21635529353, ExchCode = 'DEU' WHERE SecCode = 3434582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796441340, ExchCode = 'HAM' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3440258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22185588051, Ticker = 'DB35v', ExchCode = 'BCO' WHERE SecCode = 3446009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644928541, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3446081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938004022, ExchCode = 'GTX' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647221128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3490820 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 = 21647640876, ExchCode = 'DEU' WHERE SecCode = 3490936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680653099, ExchCode = 'MUN' WHERE SecCode = 3493723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705453, ExchCode = 'MXQ' WHERE SecCode = 3495824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308571, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3495847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669695686, ExchCode = 'BTE', PermQuoteRetireDate = '2022-07-12' WHERE SecCode = 3499290 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3501408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388282, ExchCode = 'LAS', PermQuoteRetireDate = '2025-07-29' WHERE SecCode = 3501431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706320, ExchCode = 'MXQ' WHERE SecCode = 3510566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505148, ExchCode = 'STU' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275451, ExchCode = 'GTX' WHERE SecCode = 3518267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705225, Ticker = 'JOBSN', ExchCode = 'MXQ' WHERE SecCode = 3518311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652333996, ExchCode = 'DEU' WHERE SecCode = 3526149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272845, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3526200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654538571, ExchCode = 'FRA' WHERE SecCode = 3540682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949649601, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-12-12' WHERE SecCode = 3545357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656740299, Ticker = 'DNKl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-01-20' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705145, ExchCode = 'MXQ' WHERE SecCode = 3569558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388326, ExchCode = 'LAS' WHERE SecCode = 3569563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681761692, ExchCode = 'FRA' WHERE SecCode = 3569619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808198553, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 3578524 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3587023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598347923, ExchCode = 'AUX' WHERE SecCode = 3588027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552355, ExchCode = 'LAS' WHERE SecCode = 3588063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704616, ExchCode = 'MXQ' WHERE SecCode = 3588107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544661, ExchCode = 'DUS' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787436, ExchCode = 'DUS' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3597827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664171446, PermQuoteStatus = 'DC', Ticker = '2HQ', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28' WHERE SecCode = 3610775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664433945, ExchCode = 'STU' WHERE SecCode = 3610818 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 3615170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704823, ExchCode = 'MXQ' WHERE SecCode = 3629694 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3635500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668632710, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669468854, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705588, ExchCode = 'MXQ' WHERE SecCode = 3644857 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951177.0 WHERE SecCode = 3656403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3656493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670410338, Ticker = 'ROAI', ExchCode = 'SWX', PermQuoteRetireDate = '2023-09-22' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723938636, PermQuoteStatus = 'DC', Ticker = 'EP2', ExchCode = 'QTX', PermQuoteRetireDate = '2023-09-05' WHERE SecCode = 3663204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3732299 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-09' WHERE SecCode = 3738092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288603, ExchCode = 'GTX' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704309, ExchCode = 'MXQ' WHERE SecCode = 3756608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704929, Ticker = 'GNKN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3761051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620914214, Ticker = 'CZBl', ExchCode = 'BCO', PermQuoteRetireDate = '2019-11-26' WHERE SecCode = 3762759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715066, ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-02' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684229246, ExchCode = 'DEU' WHERE SecCode = 3771411 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3776419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705324, ExchCode = 'MXQ' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198213, ExchCode = 'FRA' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21691134946, ExchCode = 'FRA' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623734, ExchCode = 'TDG' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650263, ExchCode = 'DUS' WHERE SecCode = 3832747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918923, ExchCode = 'FRA' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285132, PermQuoteStatus = 'DC', Ticker = '2ZT0', ExchCode = 'GTX', PermQuoteRetireDate = '2024-09-02' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 3848178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373517, ExchCode = 'MEX' WHERE SecCode = 3854663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369830, ExchCode = 'BIV' WHERE SecCode = 3868466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '0E90' WHERE SecCode = 3913161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584837232, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 3919559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732144859, ExchCode = 'TDG' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727293094, Ticker = NULL, ExchCode = 'MEX', PermQuoteRetireDate = '2026-06-03' WHERE SecCode = 3952658 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = NULL WHERE SecCode = 3961764 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 3965132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714765661, ExchCode = 'STU' WHERE SecCode = 3972240 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 3975647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294452, ExchCode = 'GTX' WHERE SecCode = 3998157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 4009052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536123190, ExchCode = 'DEU' WHERE SecCode = 4030457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026831, Ticker = '1AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010294, Ticker = '2AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009889, Ticker = '2DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026917, Ticker = '1EUZ' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010541, Ticker = '2GG' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012423, Ticker = '2HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010937, Ticker = '2HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010414, Ticker = '2HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012605, Ticker = '2INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010156, Ticker = '2LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012517, Ticker = '2MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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', ExchCode = 'MIL' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013557, Ticker = '2REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009964, Ticker = '2RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999042587, Ticker = '2SHA', PermQuoteRetireDate = '2024-10-01' WHERE SecCode = 4031994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010336, Ticker = '2SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013792, Ticker = '2SNAP' WHERE SecCode = 4032002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682843016, Ticker = '4UCB', ExchCode = 'ETX' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751582009, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388381, ExchCode = 'LAS' WHERE SecCode = 4079321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730198054, Ticker = 'ZWIPE', ExchCode = 'STO', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 4079329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260354, ExchCode = 'FRA' 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 = 236784387195, ExchCode = 'LAS' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737082360, ExchCode = 'DUS' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766464069, ExchCode = 'FRA' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586975, ExchCode = 'FRA' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829986, ExchCode = 'QTX' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 4195324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791223141, ExchCode = 'STU' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740527, ExchCode = 'LAS' WHERE SecCode = 4225217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 4242465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754533500, ExchCode = 'FRA' WHERE SecCode = 4256876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549060, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-08' WHERE SecCode = 4274159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756809738, ExchCode = 'FRA' WHERE SecCode = 4275420 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2018-12-14' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360718, ExchCode = 'HAN' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763122567, ExchCode = 'MUN' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801716826, ExchCode = 'TDG' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763966496, ExchCode = 'DEU' WHERE SecCode = 4327051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782629845, ExchCode = 'STU', PermQuoteRetireDate = '2025-02-03', PermSecMapEndDate = NULL WHERE SecCode = 4348280 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 = 236782535999, ExchCode = 'QTX' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960079950, ExchCode = 'MUN' WHERE SecCode = 4380746 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 4382914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281491, ExchCode = 'FRA' WHERE SecCode = 4395458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21826495190, ExchCode = 'DUS', PermQuoteRetireDate = '2022-05-31', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 4395464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307749, ExchCode = 'MEX' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234893, ExchCode = 'BER' WHERE SecCode = 4413712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783161157, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377495, ExchCode = 'BIV' WHERE SecCode = 4417298 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = 'LGO', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 4419208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312696, ExchCode = 'MEX' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781996426, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816908115, ExchCode = 'TQE' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 4456234 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951624.0 WHERE SecCode = 4457144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796082418, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2021-10-13', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4487640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809915701, ExchCode = 'STU' WHERE SecCode = 4494227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809534, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296365, ExchCode = 'GTX' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799903115, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4524454 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'NA' WHERE SecCode = 4526132 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 4537807 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 = 21808388561, PermQuoteStatus = 'DC', Ticker = '3K70', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-10' WHERE SecCode = 4557860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812659635, ExchCode = 'QTX' WHERE SecCode = 4565422 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 PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 4588255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812848268, ExchCode = 'DEU' WHERE SecCode = 4590581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816245393, ExchCode = 'MUN' WHERE SecCode = 4601736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727263610, ExchCode = 'BIV' WHERE SecCode = 4610049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800012350, ExchCode = 'LAS' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821041967, PermQuoteStatus = 'AC', Ticker = '4KL0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4629496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815337201, ExchCode = 'FRA' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825617109, ExchCode = 'DEU' 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 QuotePermID = 21884954175, PermQuoteStatus = 'DC', ExchCode = 'MUN', PermQuoteRetireDate = '2026-05-04', PermSecMapEndDate = '2026-05-04' WHERE SecCode = 4664716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388764, ExchCode = 'LAS' WHERE SecCode = 4676228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619187, ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845076965, Ticker = 'V96', ExchCode = 'FRA', PermQuoteRetireDate = '2025-09-15', PermSecMapEndDate = NULL WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781822280, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-06-05' WHERE SecCode = 4709616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933381561, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4724752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850051602, ExchCode = 'TDG' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851158441, ExchCode = 'DEU' WHERE SecCode = 4748566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853887005, ExchCode = 'DUS' WHERE SecCode = 4754869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854409786, PermQuoteStatus = 'AC', Ticker = 'GSPl', ExchCode = 'TRQ', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4761540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21862726920, ExchCode = 'GTX' WHERE SecCode = 4775074 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795665928, ExchCode = 'FRA' WHERE SecCode = 4775075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857142963, ExchCode = 'STU' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799043646, ExchCode = 'LAS' WHERE SecCode = 4790646 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 4792283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886808179, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 4811144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580163, ExchCode = 'GER' WHERE SecCode = 4834791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580240, ExchCode = 'GER' WHERE SecCode = 4834792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886398298, ExchCode = 'GER', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 4834793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888954019, ExchCode = 'MUN', PermQuoteRetireDate = '2022-08-19', PermSecMapEndDate = NULL WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888953971, ExchCode = 'MUN', PermQuoteRetireDate = '2023-04-17' WHERE SecCode = 4845030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580736, ExchCode = 'GER' WHERE SecCode = 4845032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884968894, ExchCode = 'DEU' WHERE SecCode = 4847005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580567, ExchCode = 'DEU' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872584687, ExchCode = 'FRA' WHERE SecCode = 4873679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872789092, ExchCode = 'FRA' WHERE SecCode = 4876061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873145829, ExchCode = 'QTX' WHERE SecCode = 4878702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876129776, ExchCode = 'QTX' WHERE SecCode = 4885603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932177205, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954949, ExchCode = 'LAS' WHERE SecCode = 4907129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882167707, PermQuoteStatus = 'AC', Ticker = 'Y232', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4934325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727234444, ExchCode = 'MEX' WHERE SecCode = 4938297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781980293, PermQuoteStatus = 'DC', Ticker = '62U1', ExchCode = 'BER', PermQuoteRetireDate = '2025-09-01' WHERE SecCode = 4943250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884962075, ExchCode = 'STU' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883516418, ExchCode = 'FRA' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893303383, ExchCode = 'MUN' WHERE SecCode = 4952512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884973298, ExchCode = 'MUN' WHERE SecCode = 4957875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689480, ExchCode = 'FRA' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381606, ExchCode = 'LAS' WHERE SecCode = 4959596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179871224, Ticker = '2MUE', ExchCode = 'HAM' WHERE SecCode = 4965038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419011, ExchCode = 'LAS' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21900329999, ExchCode = 'DEU' WHERE SecCode = 4970793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784278069, ExchCode = 'FRA' WHERE SecCode = 4975850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740613, ExchCode = 'LAS' WHERE SecCode = 4975854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779979308, ExchCode = 'FRA' WHERE SecCode = 4975855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782414389, ExchCode = 'FRA' WHERE SecCode = 4975859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888279622, ExchCode = 'MUN' WHERE SecCode = 4983996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198071, ExchCode = 'BIV' WHERE SecCode = 4992094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100827, ExchCode = 'DUS' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097175, ExchCode = 'LAS' WHERE SecCode = 5011695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894948499, ExchCode = 'PAR' WHERE SecCode = 5013560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 5019011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387449, ExchCode = 'LAS' WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805995535, ExchCode = 'FRA' WHERE SecCode = 5031899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153246013, ExchCode = 'BTE' WHERE SecCode = 5038692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898852880, ExchCode = 'FRA' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902954507, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727380611, Ticker = 'DC4', ExchCode = 'BRN' WHERE SecCode = 5047087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931483023, ExchCode = 'MUN' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076711, ExchCode = 'LAS' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5072185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782329716, ExchCode = 'QTX' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380635, ExchCode = 'LAS' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740520, ExchCode = 'LAS' WHERE SecCode = 5082548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805401000, ExchCode = 'FRA' WHERE SecCode = 5089305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779601759, ExchCode = 'STU' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026880, Ticker = '1KDP' WHERE SecCode = 5107765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716500, ExchCode = 'FRA' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923404247, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-21' WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642004, ExchCode = 'QTX' WHERE SecCode = 5137254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802423065, ExchCode = 'FRA' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790867, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273208, ExchCode = 'GTX' WHERE SecCode = 5161225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843186265, Ticker = '0A60l', ExchCode = 'BCO' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508528400, ExchCode = 'DEU' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730598077, ExchCode = 'FRA' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753424486, ExchCode = 'MUN' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792173203, ExchCode = 'FRA' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727308116, Ticker = 'WPMl', ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727248292, ExchCode = 'MEX' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387325, ExchCode = 'LAS' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348366, ExchCode = 'MEX' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727360442, ExchCode = 'MEX' WHERE SecCode = 5161415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381527, ExchCode = 'LAS' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893559951, Ticker = 'AZPN1*', ExchCode = 'MXQ' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871079564, ExchCode = 'MXQ' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-10' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'K470' WHERE SecCode = 5162438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173433, ExchCode = 'BIV' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955191864, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535364, ExchCode = 'MUN' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793845610, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-26' WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173431, ExchCode = 'BIV' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779328331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957751536, ExchCode = 'QTX' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5261592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937485181, ExchCode = 'STU' WHERE SecCode = 5265003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935904590, ExchCode = 'FRA' WHERE SecCode = 5265006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959379813, ExchCode = 'TDG' WHERE SecCode = 5265007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388889, ExchCode = 'LAS' WHERE SecCode = 5296146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803327, ExchCode = 'DUS' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397469, ExchCode = 'CHI' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581879, ExchCode = 'QTX' WHERE SecCode = 5338742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950823856, ExchCode = 'FRA' WHERE SecCode = 5343608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791510353, ExchCode = 'MUN' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5360791 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5360880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381676, ExchCode = 'LAS' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380716, ExchCode = 'LAS' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534615, ExchCode = 'QTX' WHERE SecCode = 5383599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780747349, ExchCode = 'STU' WHERE SecCode = 5395770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874394, ExchCode = 'GTX' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812179638, ExchCode = 'DEU' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5426674 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5446098 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 5450871 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5454700 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380732, ExchCode = 'LAS' WHERE SecCode = 5466447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778372898, ExchCode = 'STU' WHERE SecCode = 5468679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21700245046, ExchCode = 'STU' WHERE SecCode = 5503680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394120, PermQuoteStatus = 'DC', Ticker = '1L8', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-01' WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026804, Ticker = '1TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151100, PermQuoteStatus = 'AC', Ticker = '3LUE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835157, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503776 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 5513351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151304, Ticker = '3FTE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5535000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793530318, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-08', PermSecMapEndDate = '2023-11-08' WHERE SecCode = 5577589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966732, ExchCode = 'TDG', PermQuoteRetireDate = '2020-01-23' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197818, ExchCode = 'MEX' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772643122, ExchCode = 'FRA' WHERE SecCode = 5740839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181310368, ExchCode = 'OCU' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851316, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608793, ExchCode = 'MEX' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782536307, ExchCode = 'BIV' WHERE SecCode = 5822279 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5827321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21967216830, Ticker = 'CO3S', ExchCode = 'LSE' WHERE SecCode = 5839249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600489, ExchCode = 'STU' WHERE SecCode = 5839460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913642, ExchCode = 'DEU' WHERE SecCode = 5839461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600488, ExchCode = 'STU' WHERE SecCode = 5839464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601376, ExchCode = 'STU' WHERE SecCode = 5839466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913691, ExchCode = 'DEU' WHERE SecCode = 5839467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 5859846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416444, ExchCode = 'BIV' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786957975, ExchCode = 'MUN' WHERE SecCode = 5908829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386725, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-25', PermSecMapEndDate = '2025-04-25' WHERE SecCode = 5911970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174666338, ExchCode = 'DXE' WHERE SecCode = 5920812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791001789, PermQuoteStatus = 'AC', Ticker = '83W', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5928247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776334351, ExchCode = 'MEX' WHERE SecCode = 5958705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793448736, ExchCode = 'TDG' WHERE SecCode = 5969012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788075088, ExchCode = 'FRA' WHERE SecCode = 5978470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787589834, ExchCode = 'MUN' WHERE SecCode = 5978474 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 5981857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786355844, ExchCode = 'MEX' WHERE SecCode = 5985969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788245572, ExchCode = 'DUS' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782564342, ExchCode = 'BIV' WHERE SecCode = 6032854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788759413, ExchCode = 'STU' WHERE SecCode = 6035234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788962501, Ticker = '1HUT', ExchCode = 'MIL' WHERE SecCode = 6047903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571976516, ExchCode = 'BEC' WHERE SecCode = 6095641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083162878, ExchCode = 'DEU' WHERE SecCode = 6095673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663696, PermQuoteStatus = 'AC', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 6097328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351672, ExchCode = 'MEX' WHERE SecCode = 6097355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566204, ExchCode = 'DEU' WHERE SecCode = 6097356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580190, ExchCode = 'FRA' WHERE SecCode = 6097360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799762, ExchCode = 'HAM' WHERE SecCode = 6097368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22016170429, PermQuoteStatus = 'DC', Ticker = 'SCO3', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 6097382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836167, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823825, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031488954, Ticker = 'SMCI', ExchCode = 'MIL' WHERE SecCode = 6097447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779226797, PermQuoteStatus = 'DC', Ticker = '5VFC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-24' WHERE SecCode = 6097454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835913, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834940, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710457, ExchCode = 'BCO' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786069824, ExchCode = 'MEX' WHERE SecCode = 6097612 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 6101727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790492416, ExchCode = 'QTX' WHERE SecCode = 6119927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22092285949, ExchCode = 'DEU' WHERE SecCode = 6177691 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791287038, ExchCode = 'FRA' WHERE SecCode = 6190705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22185588026, Ticker = 'DK18v', ExchCode = 'BCO' WHERE SecCode = 6258447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793315748, ExchCode = 'LAS' WHERE SecCode = 6303058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747910459, ExchCode = 'STU' WHERE SecCode = 6325196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793393667, ExchCode = 'STU' WHERE SecCode = 6334403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349913, ExchCode = 'MUN' WHERE SecCode = 6334404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794559562, ExchCode = 'GTX' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22185588046, Ticker = 'AN01v', ExchCode = 'BCO' WHERE SecCode = 6356464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887551041, ExchCode = 'MUN' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 6361774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655560, ExchCode = 'FRA' WHERE SecCode = 6368868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125770690, ExchCode = 'DEU' WHERE SecCode = 6443261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22185588045, Ticker = 'AN22v', ExchCode = 'BCO' WHERE SecCode = 6469395 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 = 236798597964, ExchCode = 'TDG' WHERE SecCode = 6528817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22137771215, ExchCode = 'DEU' WHERE SecCode = 6528818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798270114, ExchCode = 'FRA' WHERE SecCode = 6528824 AND Type_ = 10;
UPDATE data_universe_permid SET InstrPermID = 8590927652, PriTrdQuotePermID = 55835354171.0, ValQuotePermID = 55839307794.0, IsPrimaryQuote = 0, IsPrimaryInstr = 1, PermSecMapEndDate = '2026-06-09' WHERE SecCode = 6528934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727346662, Ticker = '0QF', ExchCode = 'BRN' 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 = 236806168734, ExchCode = 'SIG' WHERE SecCode = 6578406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800096565, ExchCode = 'FRA' WHERE SecCode = 6590583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238848, ExchCode = 'QTX' WHERE SecCode = 6593876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800566531, ExchCode = 'TDG' WHERE SecCode = 6593880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800566528, ExchCode = 'TDG' WHERE SecCode = 6593881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145988926, ExchCode = 'DEU' WHERE SecCode = 6593883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145984972, ExchCode = 'DEU' WHERE SecCode = 6593884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145984745, ExchCode = 'DEU' WHERE SecCode = 6593886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800658723, ExchCode = 'QTX' WHERE SecCode = 6593887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22135607728, ExchCode = 'MUN' WHERE SecCode = 6617649 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 6622164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800286614, ExchCode = 'MUN' WHERE SecCode = 6626384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955514041, ExchCode = 'STU' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801727826, ExchCode = 'FRA' WHERE SecCode = 6627853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429437, ExchCode = 'QTX' WHERE SecCode = 6635297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156173553, ExchCode = 'DEU' WHERE SecCode = 6635298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156172449, ExchCode = 'DEU' WHERE SecCode = 6635299 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156173537, ExchCode = 'DEU' WHERE SecCode = 6635300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156192489, ExchCode = 'DEU' WHERE SecCode = 6635301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802540440, ExchCode = 'FRA' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22157135278, ExchCode = 'DEU' WHERE SecCode = 6642930 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 6667827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883770164, ExchCode = 'DEU' WHERE SecCode = 6667833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011191253, ExchCode = 'BEC' WHERE SecCode = 6678589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803385941, ExchCode = 'FRA' WHERE SecCode = 6684031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803385723, ExchCode = 'FRA' WHERE SecCode = 6684032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803385722, ExchCode = 'FRA' WHERE SecCode = 6684033 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 6691958 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951194.0 WHERE SecCode = 6705487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804305881, ExchCode = 'FRA' WHERE SecCode = 6721467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804778699, ExchCode = 'GTX' WHERE SecCode = 6721535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795337293, ExchCode = 'BIV' WHERE SecCode = 6741058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699531, ExchCode = 'BIV' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-06', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 6768898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901586, ExchCode = 'CHI' WHERE SecCode = 6779523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805705305, ExchCode = 'FRA' WHERE SecCode = 6782676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22096729407, ExchCode = 'STU' WHERE SecCode = 6796811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791406435, ExchCode = 'BIV' WHERE SecCode = 6797364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806019660, ExchCode = 'BIV' WHERE SecCode = 6797367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806409092, ExchCode = 'MUN' WHERE SecCode = 6797368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22175399826, ExchCode = 'DEU' WHERE SecCode = 6802859 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-10' WHERE SecCode = 6809154 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6832521 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6843176 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 6850009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154587823, PermQuoteStatus = 'AC', Ticker = '3GDXa', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 6857276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807166338, ExchCode = 'MUN' WHERE SecCode = 6857306 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6870725 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 6880024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807682207, ExchCode = 'FRA' WHERE SecCode = 6882001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807782588, ExchCode = 'FRA' WHERE SecCode = 6887868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807782486, Ticker = 'C1W0', ExchCode = 'FRA' WHERE SecCode = 6887870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807782485, ExchCode = 'FRA' WHERE SecCode = 6887874 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-09' WHERE SecCode = 6890759 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-09' WHERE SecCode = 6890760 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 6893654 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 6893662 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 6897216 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 6897217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807978130, ExchCode = 'FRA' WHERE SecCode = 6901104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535196167, PermQuoteStatus = 'AC', Ticker = 'NVJP', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 6901138 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-04' WHERE SecCode = 6902160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807900088, ExchCode = 'TDG' WHERE SecCode = 6902222 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10814074 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10831337 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10970843 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11001026 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'WNRS' WHERE SecCode = 11009061 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11025975 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 11026516 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11028391 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 11039295 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11045883 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'LTELF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-09', PermSecMapEndDate = NULL WHERE SecCode = 11047944 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'CROTF' WHERE SecCode = 11053050 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294952001.0 WHERE SecCode = 11062571 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11065371 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 11067506 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 11072123 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 11105137 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 11148269 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'NLD' WHERE SecCode = 11152523 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 11157009 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 11165130 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11181738 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11190437 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2018-12-14' WHERE SecCode = 11192690 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ZAIRD' WHERE SecCode = 11198984 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11205267 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11225909 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11228344 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11229681 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11238076 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11239425 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11243216 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11261977 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11275347 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11275921 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11285129 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236808161776, Ticker = 'AIBZ', ExchCode = 'SCN', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-09' WHERE SecCode = 11289183 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11289237 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11289238 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11289239 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11289240 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11289245 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11289247 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11289250 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11289275 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11289279 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11289280 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11289282 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11292989 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11292990 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11292997 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11293000 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11293002 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11293003 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11293005 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-09', PermSecMapEndDate = '2026-06-09' WHERE SecCode = 11293006 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293086 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293087 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293088 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293090 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293095 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293098 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293099 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293101 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293102 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293104 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293105 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293106 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293108 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 11293109 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11296309 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-06-04' WHERE SecCode = 11297059 AND Type_ = 1;
