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 OrgPermID = 5095371175, PriInstrPermID = 8590923017.0, PermOrgIPODate = NULL WHERE SecCode = 2565 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 12465 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 24105 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 24106 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 24107 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21842591690, Ticker = '0HKPl', ExchCode = 'BCO' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 29843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836041527, Ticker = 'AH20', ExchCode = 'LSE', PermQuoteRetireDate = '2015-11-10' WHERE SecCode = 32244 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5097002744, PriInstrPermID = 8590928853.0, PriTRBCIndPermID = 4294951709.0, PermOrgIPODate = NULL WHERE SecCode = 33634 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838241280, ExchCode = 'MUN', PermQuoteRetireDate = '2021-01-18', PermSecMapEndDate = '2021-02-10' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851139058, ExchCode = 'TDG' WHERE SecCode = 38188 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 = 55836328604, Ticker = 'FRZS', ExchCode = 'BER', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 46907 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-30' WHERE SecCode = 51698 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 56413 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 56648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475628897, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2008-04-18', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 56895 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 57998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838414562, ExchCode = 'STU', PermQuoteRetireDate = '2016-03-01' WHERE SecCode = 60009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782196451, ExchCode = 'DUS' WHERE SecCode = 60024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363120, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475457917, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2007-11-28' WHERE SecCode = 60090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836584093, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837363654, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 61256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763961578, ExchCode = 'DUS' WHERE SecCode = 61900 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 63271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836411094, ExchCode = 'FRA' WHERE SecCode = 65414 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 76579 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 78585 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL WHERE SecCode = 79483 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951594.0 WHERE SecCode = 80148 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 82051 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-03-30' WHERE SecCode = 82762 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 82893 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 85909 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 86115 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 91068 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 91810 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 92776 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 94656 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 97807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128769414, ExchCode = 'DEU' WHERE SecCode = 100032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490953, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-20' WHERE SecCode = 100052 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2001-04-25' WHERE SecCode = 100472 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 100923 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 105579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727369672, ExchCode = 'BIV' WHERE SecCode = 113051 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 114244 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 114245 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 118018 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5095371175, PriInstrPermID = 8590923017.0, PermOrgIPODate = NULL WHERE SecCode = 132378 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2001-04-25' WHERE SecCode = 137778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610380000, ExchCode = 'FRA' WHERE SecCode = 142150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336503, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 142154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615119219, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 142223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21727351962, ExchCode = 'DEU' WHERE SecCode = 142224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531427396, ExchCode = 'STU' WHERE SecCode = 142347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035698, ExchCode = 'TDG' WHERE SecCode = 142366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572615818, ExchCode = 'FRA' WHERE SecCode = 142384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033911, ExchCode = 'TDG' WHERE SecCode = 142387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526206227, ExchCode = 'TDG' WHERE SecCode = 142440 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 142448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589809465, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 142481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547304354, Ticker = 'H9Id', ExchCode = 'BCO', PermQuoteRetireDate = '2022-08-12' WHERE SecCode = 142482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475659779, Ticker = NULL, ExchCode = 'STU', PermQuoteRetireDate = '2005-12-08' WHERE SecCode = 142521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525688846, ExchCode = 'MUN', PermQuoteRetireDate = '2017-03-24' WHERE SecCode = 142529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475617077, Ticker = 'NVAG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 142533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475425489, ExchCode = 'LSE' WHERE SecCode = 142661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033748, ExchCode = 'TDG' WHERE SecCode = 142822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275207, PermQuoteStatus = 'AC', Ticker = 'P6U', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 142826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55839664515, ExchCode = 'BER' WHERE SecCode = 142848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542388403, ExchCode = 'STU' WHERE SecCode = 142864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836048252, Ticker = 'AHI', ExchCode = 'LSE' WHERE SecCode = 142938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507878763, ExchCode = 'STU' WHERE SecCode = 142997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952830598, ExchCode = 'DEU' WHERE SecCode = 143038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475821321, ExchCode = 'DEU' WHERE SecCode = 143059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474874175, ExchCode = 'DEU' WHERE SecCode = 143060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033496, ExchCode = 'TDG' WHERE SecCode = 143168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475539998, ExchCode = 'MUN', PermQuoteRetireDate = '2009-04-27' WHERE SecCode = 143177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475566783, PermQuoteRetireDate = '2008-04-16' WHERE SecCode = 143195 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475417697, ExchCode = 'MUN', PermQuoteRetireDate = '2008-02-08' WHERE SecCode = 143196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296552, ExchCode = 'GTX' WHERE SecCode = 143197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295736, ExchCode = 'GTX' WHERE SecCode = 143198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21497500363, ExchCode = 'STU' WHERE SecCode = 143201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705582, ExchCode = 'MXQ' WHERE SecCode = 143254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475530293, Ticker = 'OLDM.I', ExchCode = 'CST', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 143320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21987788468, ExchCode = 'DEU' WHERE SecCode = 143418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836487466, ExchCode = 'FRA', PermQuoteRetireDate = '2017-02-20' WHERE SecCode = 143423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821267197, ExchCode = 'TDG', PermQuoteRetireDate = '2021-08-25' WHERE SecCode = 143427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475781102, ExchCode = 'TDG' WHERE SecCode = 143432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552379557, ExchCode = 'STU' WHERE SecCode = 143506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632440910, Ticker = '0R1O', ExchCode = 'LSE' WHERE SecCode = 143515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981599, ExchCode = 'HAM' WHERE SecCode = 143526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475387714, PermQuoteStatus = 'DC', Ticker = 'ABB.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 143542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542058474, ExchCode = 'STU', PermQuoteRetireDate = '2017-12-29' WHERE SecCode = 143544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333323, ExchCode = 'BER' WHERE SecCode = 143545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564846287, PermQuoteStatus = 'DC', Ticker = 'CD5N', ExchCode = 'STU', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 143563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323013, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 143637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630034238, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 143638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323660, ExchCode = 'BER' WHERE SecCode = 143716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475568896, ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 143899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475794421, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 143908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197112, Ticker = '6758', ExchCode = 'BRN', PermQuoteRetireDate = '2017-12-29' WHERE SecCode = 143917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799652656, ExchCode = 'FRA' WHERE SecCode = 144104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332871, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487452, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 144107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336716, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331343, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327506, ExchCode = 'BER', PermQuoteRetireDate = '2015-09-24' WHERE SecCode = 144176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629381720, Ticker = '0NOF', ExchCode = 'LSE' WHERE SecCode = 144186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327850, ExchCode = 'BER' WHERE SecCode = 144289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609137350, ExchCode = 'TDG' WHERE SecCode = 144293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823495681, ExchCode = 'TDG' WHERE SecCode = 144300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629957951, ExchCode = 'TDG' WHERE SecCode = 144320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664445764, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2019-01-24' WHERE SecCode = 144351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633621391, Ticker = '0LBI', ExchCode = 'LSE', PermQuoteRetireDate = '2020-07-09' WHERE SecCode = 144371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517582535, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-13' WHERE SecCode = 144377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804419087, ExchCode = 'DEU' WHERE SecCode = 144392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474949119, Ticker = 'TUIl', ExchCode = 'EQD', PermQuoteRetireDate = '2024-06-24' WHERE SecCode = 144410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475073728, PermQuoteStatus = 'AC', Ticker = '0MV8', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 144414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330935, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475810904, ExchCode = 'TDG', PermQuoteRetireDate = '2011-07-04' WHERE SecCode = 144472 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 144506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623456805, ExchCode = 'DEU' WHERE SecCode = 144526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593293540, ExchCode = 'FRA', PermQuoteRetireDate = '2023-12-21', PermSecMapEndDate = '2023-12-21' WHERE SecCode = 144528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475019766, ExchCode = 'STU' WHERE SecCode = 144535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836444738, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 144537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836591336, Ticker = 'W8O1', ExchCode = 'FRA', PermQuoteRetireDate = '2014-01-31' WHERE SecCode = 144540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034293, Ticker = 'D3S', ExchCode = 'TDG', PermQuoteRetireDate = '2015-12-01' WHERE SecCode = 144547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513255000, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-03-29' WHERE SecCode = 144731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335951, ExchCode = 'BER', PermQuoteRetireDate = '2024-01-19' WHERE SecCode = 144853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474840578, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 144989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796527245, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 145117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383340, ExchCode = 'TDG', PermQuoteRetireDate = '2025-02-03' WHERE SecCode = 145208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593866244, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2018-12-14', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 145274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475552695, Ticker = 'NMCG.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 145282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474985820, ExchCode = 'DEU' WHERE SecCode = 145323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21489056077, ExchCode = 'STU' WHERE SecCode = 145335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481377161, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-22', PermSecMapEndDate = '2023-09-22' WHERE SecCode = 145350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593918475, ExchCode = 'DEU' WHERE SecCode = 145477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475441163, ExchCode = 'GER' WHERE SecCode = 148733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033940, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2015-12-09' WHERE SecCode = 148734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035224, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-21' WHERE SecCode = 148737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845996588, Ticker = 'AA51', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 149529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474924131, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2012-07-11' WHERE SecCode = 150492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293943, ExchCode = 'GTX' WHERE SecCode = 150496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331636, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 150498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475795467, ExchCode = 'STU', PermQuoteRetireDate = '2012-11-28' WHERE SecCode = 150501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757667055, ExchCode = 'STU' WHERE SecCode = 150502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522214062, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 150503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330759, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 150504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034807, ExchCode = 'TDG', PermQuoteRetireDate = '2014-12-01' WHERE SecCode = 150512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475543998, ExchCode = 'MUN', PermQuoteRetireDate = '2010-03-05' WHERE SecCode = 150515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339053, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 150516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340467, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 150614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836427551, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 150620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275556, ExchCode = 'GTX' WHERE SecCode = 150697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007976, ExchCode = 'DEU', PermQuoteRetireDate = '2019-03-20' WHERE SecCode = 151023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273884, ExchCode = 'GTX' WHERE SecCode = 151025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597039956, ExchCode = 'TDG' WHERE SecCode = 151026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474871644, ExchCode = 'DEU' WHERE SecCode = 153404 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 161471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475756822, PermQuoteStatus = 'AC', Ticker = 'SC5A', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 162463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21577273820, ExchCode = 'DEU' WHERE SecCode = 164093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512564419, ExchCode = 'STU', PermQuoteRetireDate = '2020-08-25' WHERE SecCode = 164346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197563, ExchCode = 'DUS' WHERE SecCode = 164737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335381, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 164809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528681544, ExchCode = 'NQX', PermQuoteRetireDate = '2010-07-02' WHERE SecCode = 164836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625070426, ExchCode = 'STU' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474894216, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 165009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475530918, Ticker = 'PTR', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 165548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296596, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 165818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745304634, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 166414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679714, ExchCode = 'BIV' WHERE SecCode = 168676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514031334, ExchCode = 'DEU' WHERE SecCode = 168960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55844861861, Ticker = 'HDJ0', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 169566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264672, ExchCode = 'MUN' WHERE SecCode = 169894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612598754, ExchCode = 'DEU' WHERE SecCode = 170656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331930, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 172985 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474983741, ExchCode = 'DEU' WHERE SecCode = 172989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21495338652, ExchCode = 'STU', PermQuoteRetireDate = '2020-10-27' WHERE SecCode = 172998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850436290, ExchCode = 'FRA' WHERE SecCode = 173009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585829135, ExchCode = 'STU' WHERE SecCode = 175229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21578072857, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 175239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035434, ExchCode = 'TDG' WHERE SecCode = 175562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584697976, ExchCode = 'STU' WHERE SecCode = 176809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551603303, ExchCode = 'STU' WHERE SecCode = 177155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597621820, ExchCode = 'TDG' WHERE SecCode = 177162 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884460181, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 177180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327534, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 177186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197835, ExchCode = 'FRA' WHERE SecCode = 177245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409290, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 177280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564939020, ExchCode = 'DEU' WHERE SecCode = 177301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22162018384, ExchCode = 'DEU' WHERE SecCode = 177314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622517895, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475789302, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 177361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22007599469, ExchCode = 'DEU' WHERE SecCode = 177402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609137349, ExchCode = 'STU' WHERE SecCode = 177403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329926, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 177463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051150, PermQuoteStatus = 'AC', Ticker = 'Z0Y', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786355600, ExchCode = 'QTX' WHERE SecCode = 177477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332332, ExchCode = 'BER', PermQuoteRetireDate = '2013-10-18' WHERE SecCode = 177483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680653259, ExchCode = 'STU' WHERE SecCode = 177491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774179910, ExchCode = 'DEU' WHERE SecCode = 177494 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521223886, ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-14' WHERE SecCode = 177502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340304, ExchCode = 'BER' WHERE SecCode = 177528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474992895, ExchCode = 'FRA' WHERE SecCode = 177592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21649328303, ExchCode = 'STU' WHERE SecCode = 177594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215721, ExchCode = 'FRA' WHERE SecCode = 177634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733576076, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474867216, ExchCode = 'DEU' WHERE SecCode = 177707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474891708, ExchCode = 'DEU' WHERE SecCode = 177732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474888417, ExchCode = 'DEU' WHERE SecCode = 177735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564889106, ExchCode = 'DEU' WHERE SecCode = 177738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547157157, ExchCode = 'DEU' WHERE SecCode = 177739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520168610, ExchCode = 'STU' WHERE SecCode = 177745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327740, ExchCode = 'BER', PermQuoteRetireDate = '2009-09-14' WHERE SecCode = 177757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548019612, ExchCode = 'DEU' WHERE SecCode = 177769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047337, ExchCode = 'MUN' WHERE SecCode = 177779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068273, ExchCode = 'DEU' WHERE SecCode = 177936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474853300, ExchCode = 'DEU' WHERE SecCode = 177955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807437703, ExchCode = 'STU' WHERE SecCode = 177960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035144, ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-20' WHERE SecCode = 177981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327818, ExchCode = 'BER', PermQuoteRetireDate = '2021-08-23' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732784554, ExchCode = 'DEU' WHERE SecCode = 178090 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 178104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955876, ExchCode = 'TDG' WHERE SecCode = 178130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126226638, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215874, ExchCode = 'FRA' WHERE SecCode = 178144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926818, ExchCode = 'DEU' WHERE SecCode = 178149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560429859, ExchCode = 'DEU' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007668, Ticker = 'CPNR', ExchCode = 'DEU' WHERE SecCode = 178157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548652765, ExchCode = 'FRA', IncCntry = 'ITA' WHERE SecCode = 178159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475780283, ExchCode = 'DEU' WHERE SecCode = 178163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591731729, ExchCode = 'STU' WHERE SecCode = 178186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320072, ExchCode = 'FRA' WHERE SecCode = 178208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22054464956, ExchCode = 'DEU', PermQuoteRetireDate = '2025-09-16', PermSecMapEndDate = '2025-09-16' WHERE SecCode = 178267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333234, Ticker = 'FMBA', ExchCode = 'BER', PermQuoteRetireDate = '2022-07-11' WHERE SecCode = 178270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340833, ExchCode = 'BER', PermQuoteRetireDate = '2020-08-18' WHERE SecCode = 178271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341005, ExchCode = 'BER' WHERE SecCode = 178282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507329852, ExchCode = 'FRA', PermQuoteRetireDate = '2023-03-16', PermSecMapEndDate = '2023-03-16' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772839712, ExchCode = 'DEU' WHERE SecCode = 178295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035800, ExchCode = 'TDG' WHERE SecCode = 178306 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141240100, ExchCode = 'DEU' WHERE SecCode = 178326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128769282, ExchCode = 'DEU' WHERE SecCode = 178338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341857, ExchCode = 'BER', PermQuoteRetireDate = '2016-01-26' WHERE SecCode = 178342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685426317, ExchCode = 'MUN' WHERE SecCode = 178363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612052439, PermQuoteStatus = 'AC', Ticker = 'BZS0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 178420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330550, ExchCode = 'BER', PermQuoteRetireDate = '2013-06-27' WHERE SecCode = 178447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475523632, ExchCode = 'FRA' WHERE SecCode = 178448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523649406, ExchCode = 'FRA' WHERE SecCode = 178451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602606942, ExchCode = 'FRA' WHERE SecCode = 178488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841197033, ExchCode = 'MUN', PermQuoteRetireDate = '2020-08-17' WHERE SecCode = 178498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754534043, ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 178507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474896334, ExchCode = 'DEU' WHERE SecCode = 178511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648685622, ExchCode = 'DEU' WHERE SecCode = 178514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198207, ExchCode = 'DEU' WHERE SecCode = 178520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327846, Ticker = 'HYZ5', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332281, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336348, ExchCode = 'BER' WHERE SecCode = 178655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531978942, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 178657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531119533, Ticker = 'BVTd', ExchCode = 'BCO', PermQuoteRetireDate = '2024-05-21', PermSecMapEndDate = NULL WHERE SecCode = 178675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580132, ExchCode = 'FRA' WHERE SecCode = 178679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845522388, ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 178680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564886888, ExchCode = 'DEU' WHERE SecCode = 178688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966453, ExchCode = 'STU' WHERE SecCode = 178720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475787250, ExchCode = 'DEU' WHERE SecCode = 178737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673962902, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679752, ExchCode = 'FRA' WHERE SecCode = 178849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475623674, PermQuoteStatus = 'DC', Ticker = 'BOZA.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 179089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535118681, ExchCode = 'DEU' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260266, ExchCode = 'DEU' WHERE SecCode = 180354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490776, ExchCode = 'QTX', PermQuoteRetireDate = '2025-12-10' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542096549, ExchCode = 'STU' WHERE SecCode = 180695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474988909, ExchCode = 'FRA' WHERE SecCode = 181909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036000, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2016-12-05', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 181917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517719870, Ticker = 'VLGe', ExchCode = 'SIG', PermQuoteRetireDate = '2013-08-12' WHERE SecCode = 182166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555849, ExchCode = 'FRA' WHERE SecCode = 183422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604266613, ExchCode = 'STU' WHERE SecCode = 183471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475098888, ExchCode = 'TDG' WHERE SecCode = 184373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843801987, ExchCode = 'FRA' WHERE SecCode = 184692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607100268, ExchCode = 'STU' WHERE SecCode = 184941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294096, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 186400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035187, ExchCode = 'TDG' WHERE SecCode = 186432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035941, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2015-12-09' WHERE SecCode = 186433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632625972, ExchCode = 'TDG' WHERE SecCode = 186451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798248733, ExchCode = 'FRA' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838540118, ExchCode = 'STU' WHERE SecCode = 186457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655511418, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 186458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383425, ExchCode = 'FRA' WHERE SecCode = 186462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035495, ExchCode = 'TDG' WHERE SecCode = 186469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576116427, ExchCode = 'DEU' WHERE SecCode = 186470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881521047, ExchCode = 'GTX' WHERE SecCode = 186478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547304362, Ticker = 'NCGBd', ExchCode = 'BCO' WHERE SecCode = 186489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474890546, ExchCode = 'DEU' WHERE SecCode = 186493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336819, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 186608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838418714, ExchCode = 'STU' WHERE SecCode = 186739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793472406, ExchCode = 'GTX' WHERE SecCode = 186740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785774710, ExchCode = 'FRA' WHERE SecCode = 186744 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475387181, ExchCode = 'FRA', PermQuoteRetireDate = '2023-02-02' WHERE SecCode = 186810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655824036, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2024-11-06' WHERE SecCode = 187234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782121639, ExchCode = 'FRA' WHERE SecCode = 187719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509897034, ExchCode = 'DEU', PermQuoteRetireDate = '2022-06-27' WHERE SecCode = 187752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836043466, ExchCode = 'LSE' WHERE SecCode = 188480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504206673, ExchCode = 'TDG' WHERE SecCode = 188521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326642, ExchCode = 'BER' WHERE SecCode = 188522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490958372, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 188523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21489055626, ExchCode = 'STU' WHERE SecCode = 189024 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866363950, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 189025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611418, ExchCode = 'DEU' WHERE SecCode = 190124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521109986, PermQuoteStatus = 'AC', Ticker = 'HY7', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 190214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585320838, ExchCode = 'TDG' WHERE SecCode = 190229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661437570, ExchCode = 'STU' WHERE SecCode = 190498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509911581, ExchCode = 'TDG' WHERE SecCode = 194654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486309684, ExchCode = 'STU' WHERE SecCode = 194847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491975, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 195530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623456318, ExchCode = 'TDG' WHERE SecCode = 195545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523803142, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-14', PermSecMapEndDate = '2025-01-14' WHERE SecCode = 196054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547070064, Ticker = 'BNFd', ExchCode = 'BCO' WHERE SecCode = 196120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628831642, ExchCode = 'STU' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714469392, ExchCode = 'DXE' WHERE SecCode = 196630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489393, ExchCode = 'QTX' WHERE SecCode = 196829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484082, ExchCode = 'QTX' WHERE SecCode = 197050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339746, ExchCode = 'BER' WHERE SecCode = 197081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474866750, ExchCode = 'DEU' WHERE SecCode = 197192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22042835568, ExchCode = 'DEU' WHERE SecCode = 197197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527545972, ExchCode = 'STU' WHERE SecCode = 197304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550906574, ExchCode = 'STU' WHERE SecCode = 199016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604647201, ExchCode = 'TDG' WHERE SecCode = 199021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474912303, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 199022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777195252, ExchCode = 'STU' WHERE SecCode = 200581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506132846, ExchCode = 'DEU' WHERE SecCode = 200713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335190, ExchCode = 'BER', PermQuoteRetireDate = '2011-03-25' WHERE SecCode = 200970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034815, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 201293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537702696, ExchCode = 'DEU' WHERE SecCode = 201372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475416900, ExchCode = 'FRA' WHERE SecCode = 201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536288764, ExchCode = 'STU' WHERE SecCode = 201593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475906502, ExchCode = 'STU' WHERE SecCode = 201597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835814655, ExchCode = 'MEX' WHERE SecCode = 201842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531927275, ExchCode = 'MEX' WHERE SecCode = 201875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22095615019, ExchCode = 'DEU' WHERE SecCode = 201937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502336043, ExchCode = 'STU' WHERE SecCode = 201945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475887561, ExchCode = 'STU' WHERE SecCode = 201946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21518995421, ExchCode = 'DEU' WHERE SecCode = 201949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520168525, ExchCode = 'STU' WHERE SecCode = 201951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704310, ExchCode = 'MXQ' WHERE SecCode = 201971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474925423, ExchCode = 'DEU' WHERE SecCode = 202621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509902864, Ticker = 'SOYP.I', ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 202732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21650787950, ExchCode = 'TDG' WHERE SecCode = 202767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328930, ExchCode = 'BER', PermQuoteRetireDate = '2021-02-18' WHERE SecCode = 202787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302068, ExchCode = 'FRA' WHERE SecCode = 202933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498931242, ExchCode = 'FRA' WHERE SecCode = 202935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521985590, ExchCode = 'STU', PermQuoteRetireDate = '2017-04-04' WHERE SecCode = 203925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625620888, ExchCode = 'TDG' WHERE SecCode = 205611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033438, ExchCode = 'TDG' WHERE SecCode = 206769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55839091903, Ticker = NULL, PermQuoteRetireDate = '2014-04-14' WHERE SecCode = 206829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474902041, ExchCode = 'DEU', PermQuoteRetireDate = '2020-12-28' WHERE SecCode = 208000 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 = 21587111640, ExchCode = 'DEU' WHERE SecCode = 210734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475780721, ExchCode = 'TDG', PermQuoteRetireDate = '2018-12-18' WHERE SecCode = 210736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659184307, ExchCode = 'MUN' WHERE SecCode = 210739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475592408, ExchCode = 'MUN', PermQuoteRetireDate = '2009-12-17' WHERE SecCode = 210757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836401622, ExchCode = 'FRA' WHERE SecCode = 211823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675875, ExchCode = 'BIV' WHERE SecCode = 214889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830292595, ExchCode = 'GTX' WHERE SecCode = 215110 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 226023 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 242815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836454824, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 246361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033457, Ticker = 'CHA', ExchCode = 'TDG', PermQuoteRetireDate = '2013-08-15' WHERE SecCode = 246441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660609207, ExchCode = 'FRA' WHERE SecCode = 248506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475605129, PermQuoteStatus = 'DC', Ticker = 'TCSG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 248522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561267915, Ticker = 'EMGm', ExchCode = 'BTE', PermQuoteRetireDate = '2017-11-23' WHERE SecCode = 248524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087089, ExchCode = 'DEU' WHERE SecCode = 248556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475050981, ExchCode = 'TDG' WHERE SecCode = 248738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517229259, ExchCode = 'STU' WHERE SecCode = 248758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566184392, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 248773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836411753, ExchCode = 'FRA' WHERE SecCode = 248774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475051002, ExchCode = 'TDG' WHERE SecCode = 248970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517164539, ExchCode = 'MUN' WHERE SecCode = 248987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474846109, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 249049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991446, ExchCode = 'FRA' WHERE SecCode = 249177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611444799, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 249189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475436627, ExchCode = 'FRA' WHERE SecCode = 249208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512042331, ExchCode = 'TDG' WHERE SecCode = 249211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475631730, ExchCode = 'GER', PermQuoteRetireDate = '2006-09-18' WHERE SecCode = 249314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475782841, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-03' WHERE SecCode = 249315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474875634, ExchCode = 'DEU' WHERE SecCode = 249318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858765745, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 249351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611365799, ExchCode = 'STU' WHERE SecCode = 249355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474842918, ExchCode = 'DEU' WHERE SecCode = 249361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536721623, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-20' WHERE SecCode = 249362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536896590, ExchCode = 'TDG' WHERE SecCode = 249364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331035, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785087454, ExchCode = 'FRA', PermQuoteRetireDate = '2023-07-03', PermSecMapEndDate = NULL WHERE SecCode = 249371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756680503, ExchCode = 'BER', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 249377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524268362, ExchCode = 'STU' WHERE SecCode = 249398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599530590, PermQuoteStatus = 'AC', Ticker = 'INO0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 249400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615253053, ExchCode = 'TDG' WHERE SecCode = 249565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617237021, ExchCode = 'STU' WHERE SecCode = 249571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642375165, ExchCode = 'FRA' WHERE SecCode = 249589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337490, ExchCode = 'BER' WHERE SecCode = 249592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474892286, ExchCode = 'DEU' WHERE SecCode = 249597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610023483, ExchCode = 'STU', PermQuoteRetireDate = '2021-05-03' WHERE SecCode = 249598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955840356, ExchCode = 'TDG', PermQuoteRetireDate = '2026-01-02' WHERE SecCode = 249601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870513, ExchCode = 'FRA' WHERE SecCode = 249606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475452550, ExchCode = 'MUN' WHERE SecCode = 249622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133899880, ExchCode = 'DEU' WHERE SecCode = 249624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581860194, ExchCode = 'BER', PermQuoteRetireDate = '2020-10-08' WHERE SecCode = 249627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789215797, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617119543, Ticker = 'CKI', ExchCode = 'STU', PermQuoteRetireDate = '2019-08-14' WHERE SecCode = 249643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475429067, ExchCode = 'GER' WHERE SecCode = 249648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483537, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474854296, ExchCode = 'DEU', PermQuoteRetireDate = '2021-05-04' WHERE SecCode = 249654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916531978, PermQuoteStatus = 'AC', Ticker = '62C', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 249677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527005240, ExchCode = 'STU' WHERE SecCode = 249683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790403565, ExchCode = 'FRA' WHERE SecCode = 249684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475524376, ExchCode = 'BER' WHERE SecCode = 249685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475577403, Ticker = 'QSC.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 249694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602144530, ExchCode = 'STU' WHERE SecCode = 249701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474904311, ExchCode = 'DEU' WHERE SecCode = 249704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034203, PermQuoteStatus = 'AC', Ticker = 'COZ', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474885620, ExchCode = 'DEU' WHERE SecCode = 249712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474876206, ExchCode = 'DEU' WHERE SecCode = 249719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308695, ExchCode = 'GTX' WHERE SecCode = 249726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830297789, ExchCode = 'GTX' WHERE SecCode = 249727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636632018, ExchCode = 'STU', PermQuoteRetireDate = '2020-08-26' WHERE SecCode = 249728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548019744, ExchCode = 'FRA' WHERE SecCode = 249761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475732532, ExchCode = 'GER' WHERE SecCode = 249762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507269971, ExchCode = 'TDG' WHERE SecCode = 249765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593287072, ExchCode = 'STU', PermQuoteRetireDate = '2022-05-27', PermSecMapEndDate = NULL WHERE SecCode = 249777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474997548, ExchCode = 'FRA' WHERE SecCode = 249786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587111648, ExchCode = 'FRA' WHERE SecCode = 249791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179587, ExchCode = 'DEU' WHERE SecCode = 249796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485382, ExchCode = 'QTX' WHERE SecCode = 249828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544722925, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 249844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755228081, ExchCode = 'TDG' WHERE SecCode = 249853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475454256, ExchCode = 'GER' WHERE SecCode = 249855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329232, ExchCode = 'BER' WHERE SecCode = 249861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21592924027, ExchCode = 'HAM' WHERE SecCode = 250132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608276954, ExchCode = 'TDG' WHERE SecCode = 254358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475538245, ExchCode = 'MUN', PermQuoteRetireDate = '2009-03-04' WHERE SecCode = 255061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645193106, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 255144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475034768, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2015-12-04' WHERE SecCode = 257977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033439, Ticker = 'SMI', ExchCode = 'TDG', PermQuoteRetireDate = '2024-11-06' WHERE SecCode = 261710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509896504, Ticker = 'L2800', ExchCode = 'CLO', PermQuoteRetireDate = '2008-10-02' WHERE SecCode = 279674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474900132, ExchCode = 'DEU' WHERE SecCode = 283709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340809, ExchCode = 'BER', PermQuoteRetireDate = '2011-10-25' WHERE SecCode = 283842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557105454, ExchCode = 'TDG' WHERE SecCode = 286289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475570497, PermQuoteStatus = 'DC', Ticker = 'ORKG.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 288296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143294154, ExchCode = 'DEU' WHERE SecCode = 288353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475431726, ExchCode = 'FRA', PermQuoteRetireDate = '2008-10-13' WHERE SecCode = 289026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530950056, ExchCode = 'STU' WHERE SecCode = 289154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652595015, ExchCode = 'TDG' WHERE SecCode = 289584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334074, ExchCode = 'BER' WHERE SecCode = 289617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550946088, ExchCode = 'STU', PermQuoteRetireDate = '2023-03-07', PermSecMapEndDate = NULL WHERE SecCode = 289619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475563481, Ticker = 'ECA', ExchCode = 'STU', PermQuoteRetireDate = '2009-11-19' WHERE SecCode = 291269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323505, ExchCode = 'BER', PermQuoteRetireDate = '2009-01-08' WHERE SecCode = 291270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773002465, ExchCode = 'FRA' WHERE SecCode = 291283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530095670, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 291583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469734, ExchCode = 'QTX' WHERE SecCode = 292366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035865, ExchCode = 'TDG', PermQuoteRetireDate = '2013-04-19' WHERE SecCode = 293703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625833576, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 295285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330602, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296592 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 299010 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21474946646, ExchCode = 'HAM' WHERE SecCode = 300369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504951501, Ticker = 'TCG', ExchCode = 'GER', PermQuoteRetireDate = '2018-04-23' WHERE SecCode = 300395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850895857, ExchCode = 'QTX', PermQuoteRetireDate = '2021-11-01' WHERE SecCode = 300831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475587010, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2008-07-07' WHERE SecCode = 301718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790876548, ExchCode = 'DEU' WHERE SecCode = 302076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483815345, ExchCode = 'TDG' WHERE SecCode = 303347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492893704, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035628, ExchCode = 'TDG', PermQuoteRetireDate = '2015-06-10' WHERE SecCode = 303844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131850953, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 303854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474989966, ExchCode = 'STU' WHERE SecCode = 304121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474901442, ExchCode = 'DEU' WHERE SecCode = 304967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350444, ExchCode = 'FRA', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 305001 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2007-07-26' WHERE SecCode = 306890 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21585027886, ExchCode = 'CHI' WHERE SecCode = 309897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792573020, ExchCode = 'MEX' WHERE SecCode = 311169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320719, ExchCode = 'BER' WHERE SecCode = 312932 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321117, ExchCode = 'BER', PermQuoteRetireDate = '2012-02-28' WHERE SecCode = 312933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755613, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 313243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475425026, ExchCode = 'GER' WHERE SecCode = 313546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517295565, ExchCode = 'STU' WHERE SecCode = 313548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576306511, ExchCode = 'STU' WHERE SecCode = 314186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508030921, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 315711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349476, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 316472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820587345, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 318406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320798, ExchCode = 'BER' WHERE SecCode = 319524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585875044, ExchCode = 'STU' WHERE SecCode = 325643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520752473, ExchCode = 'HAN' WHERE SecCode = 325645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999290, ExchCode = 'DEU' WHERE SecCode = 325661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556336682, ExchCode = 'TDG', PermQuoteRetireDate = '2021-08-10' WHERE SecCode = 326285 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-30' WHERE SecCode = 326556 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21568459988, ExchCode = 'STU' WHERE SecCode = 326661 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 327052 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21520192969, ExchCode = 'STU' WHERE SecCode = 327144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475451582, ExchCode = 'GER' WHERE SecCode = 328870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848717422, Ticker = NULL, ExchCode = 'GER', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 331318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321769, ExchCode = 'BER', PermQuoteRetireDate = '2009-04-22' WHERE SecCode = 333158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576789997, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-15' WHERE SecCode = 333180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503112746, ExchCode = 'TDG', PermQuoteRetireDate = '2015-12-08' WHERE SecCode = 333182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885451397, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 333804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526983523, Ticker = 'SILp', ExchCode = 'SIG', PermQuoteRetireDate = '2013-07-31' WHERE SecCode = 334460 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2001-04-25' WHERE SecCode = 334776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164720656, ExchCode = 'DEU' WHERE SecCode = 335262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475569303, Ticker = '0FLM', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 336187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520390384, ExchCode = 'STU' WHERE SecCode = 336198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550085567, ExchCode = 'HAM' WHERE SecCode = 337400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320712, ExchCode = 'BER' WHERE SecCode = 341102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540228781, ExchCode = 'STU' WHERE SecCode = 341124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538721081, ExchCode = 'STU' WHERE SecCode = 341959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911870720, ExchCode = 'GTX' WHERE SecCode = 341961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524267752, ExchCode = 'STU', PermQuoteRetireDate = '2017-03-29' WHERE SecCode = 341966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524822343, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2020-05-26' WHERE SecCode = 342227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321347, ExchCode = 'BER' WHERE SecCode = 343073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476459275, Ticker = '1893.H', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 345331 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236793845607, ExchCode = 'FRA' WHERE SecCode = 345843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21895997853, ExchCode = 'FRA' WHERE SecCode = 345850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802914565, ExchCode = 'FRA' WHERE SecCode = 345851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783662836, Ticker = 'VGPk', ExchCode = 'TQE' WHERE SecCode = 346537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790869646, ExchCode = 'TDG', PermQuoteRetireDate = '2025-10-20' WHERE SecCode = 348120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513927540, Ticker = '2RNO' WHERE SecCode = 348455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296862, Ticker = 'FAIF.LU', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 348630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559584715, ExchCode = 'STU' WHERE SecCode = 348709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571558397, ExchCode = 'MUN' WHERE SecCode = 348719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475073719, Ticker = '0MIG', ExchCode = 'LSE', PermQuoteRetireDate = '2017-08-31' WHERE SecCode = 349090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705243, ExchCode = 'MXQ' WHERE SecCode = 349684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473202, ExchCode = 'FRA' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321209, ExchCode = 'BER', PermQuoteRetireDate = '2009-09-29' WHERE SecCode = 351311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509807554, Ticker = '0D39', ExchCode = 'POS' WHERE SecCode = 353941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761303038, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 355184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761900692, ExchCode = 'STU' WHERE SecCode = 356548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799029787, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-11-21' WHERE SecCode = 363732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475450750, ExchCode = 'GER' WHERE SecCode = 363753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475489994, Ticker = '0JJ7', ExchCode = 'LSE', PermQuoteRetireDate = '2009-05-20' WHERE SecCode = 363969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475432906, Ticker = '0FCC', ExchCode = 'LSE', PermQuoteRetireDate = '2009-12-10' WHERE SecCode = 374930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474952194, ExchCode = 'DEU' WHERE SecCode = 376072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514709829, Ticker = 'D69', ExchCode = 'STU' WHERE SecCode = 379671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704399, ExchCode = 'MXQ' WHERE SecCode = 383039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840770489, ExchCode = 'BER', PermQuoteRetireDate = '2023-11-23', PermSecMapEndDate = '2023-11-23' WHERE SecCode = 384412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916561972, ExchCode = 'MUN' WHERE SecCode = 385281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794060331, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 387911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840905043, ExchCode = 'BER' WHERE SecCode = 389775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814454509, ExchCode = 'MUN' WHERE SecCode = 390369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033780, ExchCode = 'TDG' WHERE SecCode = 392214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841102164, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 392352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799280763, ExchCode = 'DEU' WHERE SecCode = 396303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841643563, ExchCode = 'BER' WHERE SecCode = 401624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841814629, ExchCode = 'BER', PermQuoteRetireDate = '2018-03-26' WHERE SecCode = 404717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539608463, ExchCode = 'TDG', PermQuoteRetireDate = '2019-11-01' WHERE SecCode = 404833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478492476, Ticker = '0GKZ', ExchCode = 'LSE', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 408476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482293, ExchCode = 'QTX' WHERE SecCode = 413132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475108927, PermQuoteStatus = 'AC', Ticker = 'ZCT', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 416445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843288026, ExchCode = 'BER' WHERE SecCode = 424919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475545775, Ticker = 'MKTG.SI', ExchCode = 'PLU', PermQuoteRetireDate = '2009-11-18' WHERE SecCode = 425350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511427254, ExchCode = 'STU', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 425411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469529, ExchCode = 'QTX' WHERE SecCode = 425918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488504, ExchCode = 'QTX' WHERE SecCode = 428332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679708, ExchCode = 'DEU' WHERE SecCode = 428335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396938, ExchCode = 'DEU' WHERE SecCode = 428966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330574, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 432012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474924381 WHERE SecCode = 433675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859809796, ExchCode = 'UAX', PermQuoteRetireDate = '2016-02-05' WHERE SecCode = 433812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859809742, ExchCode = 'UAX', PermQuoteRetireDate = '2015-12-08' WHERE SecCode = 433814 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308332, ExchCode = 'GTX' WHERE SecCode = 434993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518877, ExchCode = 'DUS' WHERE SecCode = 435796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530872359, ExchCode = 'BTE' WHERE SecCode = 437391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21600289193, ExchCode = 'DUS', PermQuoteRetireDate = '2023-12-15', PermSecMapEndDate = NULL WHERE SecCode = 438364 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 454277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852879056, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-12' WHERE SecCode = 462475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841619375, ExchCode = 'MEX' WHERE SecCode = 462658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847014207, Ticker = 'BXX', ExchCode = 'MIL' WHERE SecCode = 464174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847269156, Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 471737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518886, ExchCode = 'DUS', PermQuoteRetireDate = '2020-12-15' WHERE SecCode = 471738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853458925, ExchCode = 'STU', PermQuoteRetireDate = '2013-02-28' WHERE SecCode = 479915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847283501, ExchCode = 'LSE' WHERE SecCode = 481044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847545159, ExchCode = 'BER', PermQuoteRetireDate = '2018-09-21', PermSecMapEndDate = '2018-09-21' WHERE SecCode = 484246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952832290, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 484491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289131, ExchCode = 'GTX' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851569298, ExchCode = 'BER', PermQuoteRetireDate = '2012-11-13' WHERE SecCode = 499735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616157068, ExchCode = 'MCX' WHERE SecCode = 500487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475073605, Ticker = '0OE0', ExchCode = 'LSE', PermQuoteRetireDate = '2011-02-04' WHERE SecCode = 501839 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848865465, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 503830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627494176, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-12-16', PermSecMapEndDate = '2019-12-17' WHERE SecCode = 503842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296759, ExchCode = 'GTX' WHERE SecCode = 504529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474956325 WHERE SecCode = 507255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849266247, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 507407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849448689, ExchCode = 'MEX' WHERE SecCode = 508999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476991409, ExchCode = 'MUN', PermQuoteRetireDate = '2013-03-12' WHERE SecCode = 510380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849615524, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 512041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849477549, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 513278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849902700, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 513850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849681521, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 514961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849660297, ExchCode = 'BER' WHERE SecCode = 515043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849370148, ExchCode = 'BER', PermQuoteRetireDate = '2016-02-10' WHERE SecCode = 515819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836423986, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 519509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428165, ExchCode = 'GTX' WHERE SecCode = 519511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837446990, Ticker = 'WEAT', ExchCode = 'MIL' WHERE SecCode = 521420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837437193, Ticker = 'AIGE', ExchCode = 'MIL' WHERE SecCode = 521423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837436792, Ticker = 'AIGI', ExchCode = 'MIL' WHERE SecCode = 521425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714446430, ExchCode = 'DXE' WHERE SecCode = 521436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835439836, PermQuoteStatus = 'AC', Ticker = 'CRUDP', ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 521464 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856951179, PermQuoteStatus = 'AC', Ticker = 'PHPT', ExchCode = 'AEX', PermQuoteRetireDate = '2100-01-05' WHERE SecCode = 521843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498939327, ExchCode = 'STU', PermQuoteRetireDate = '2022-08-03' WHERE SecCode = 524355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850150954, Ticker = 'GOK', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 527096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705317, ExchCode = 'MXQ' WHERE SecCode = 528977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214201, ExchCode = 'BIV' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640210344, ExchCode = 'BCO', PermQuoteRetireDate = '2020-08-17' WHERE SecCode = 529911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784580341, Ticker = '9EAA', PermQuoteRetireDate = '2022-09-13' WHERE SecCode = 531956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850896054, ExchCode = 'FRA', PermQuoteRetireDate = '2020-05-22' WHERE SecCode = 532767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480578, ExchCode = 'QTX', PermQuoteRetireDate = '2020-09-01' WHERE SecCode = 532772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850870170, ExchCode = 'FRA', PermQuoteRetireDate = '2014-08-19' WHERE SecCode = 533487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062340, ExchCode = 'MUN' WHERE SecCode = 533522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856295357, ExchCode = 'STU' WHERE SecCode = 534603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55879711383, Ticker = 'USEB.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 535214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519097, ExchCode = 'DUS' WHERE SecCode = 535314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475082592, ExchCode = 'STU', PermQuoteRetireDate = '2019-02-25' WHERE SecCode = 535417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478699, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-09', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 535506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852525112, ExchCode = 'STU', PermQuoteRetireDate = '2015-02-09' WHERE SecCode = 536609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851223600, ExchCode = 'BER' WHERE SecCode = 538783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851836620, Ticker = 'XGLE', ExchCode = 'LSE' WHERE SecCode = 539253 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851863667, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 539328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581478612, ExchCode = 'HAM' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799115741, ExchCode = 'LAS' WHERE SecCode = 539801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852284014, ExchCode = 'BER' WHERE SecCode = 540241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851907674, ExchCode = 'FRA' WHERE SecCode = 540531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335096, ExchCode = 'BER' WHERE SecCode = 540563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858727490, ExchCode = 'STU' WHERE SecCode = 541276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851865348, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 541442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035999, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2015-08-14' WHERE SecCode = 542320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835813082, ExchCode = 'MEX', PermSecMapEndDate = NULL WHERE SecCode = 544311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475529491, ExchCode = 'NGM', PermQuoteRetireDate = '2010-03-27' WHERE SecCode = 547513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852831256, ExchCode = 'BER', PermQuoteRetireDate = '2013-07-11' WHERE SecCode = 547537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522128043, ExchCode = 'MUN' WHERE SecCode = 548067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853070617, ExchCode = 'BER' WHERE SecCode = 548626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853076828, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-23' WHERE SecCode = 549287 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789555706, ExchCode = 'QTX' WHERE SecCode = 549886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531427744, ExchCode = 'STU' WHERE SecCode = 550860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859092913, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 551262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033537, ExchCode = 'TDG', PermQuoteRetireDate = '2024-12-12', PermSecMapEndDate = '2024-12-12' WHERE SecCode = 551472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289106, ExchCode = 'GTX' WHERE SecCode = 552621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853660976, ExchCode = 'GER' WHERE SecCode = 552722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853580515, ExchCode = 'FRA' WHERE SecCode = 552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479915, ExchCode = 'QTX' WHERE SecCode = 552948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853693620, ExchCode = 'MUN', PermQuoteRetireDate = '2022-11-01', PermSecMapEndDate = '2022-11-01' WHERE SecCode = 553231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640344252, ExchCode = 'BCO' WHERE SecCode = 553351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823049000, ExchCode = 'DUS' WHERE SecCode = 553799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850895884, ExchCode = 'QTX', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 553921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480012, ExchCode = 'QTX' WHERE SecCode = 554696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853892984, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 554906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981295, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 556230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327989, ExchCode = 'BER' WHERE SecCode = 556234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471152, ExchCode = 'GTX' WHERE SecCode = 556254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859197737, ExchCode = 'BER' WHERE SecCode = 557816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474957849, ExchCode = 'DEU' WHERE SecCode = 557818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475855781, ExchCode = 'TDG' WHERE SecCode = 557995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856214005, ExchCode = 'FRA' WHERE SecCode = 558032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857265244, ExchCode = 'FRA' WHERE SecCode = 558044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184301, ExchCode = 'FRA' WHERE SecCode = 558485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538720984, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 558809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485192, ExchCode = 'QTX' WHERE SecCode = 558811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856395007, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 559256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856606623, ExchCode = 'FRA' WHERE SecCode = 559437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804090704, ExchCode = 'HAM' WHERE SecCode = 559903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802229172, PermQuoteStatus = 'DC', Ticker = '7TM', ExchCode = 'QTX', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 560717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856711423, ExchCode = 'FRA' WHERE SecCode = 560728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856960400, ExchCode = 'FRA' WHERE SecCode = 561861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550980921, ExchCode = 'HAM' WHERE SecCode = 562914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633740802, ExchCode = 'TDG' WHERE SecCode = 563028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474874909, ExchCode = 'DEU' WHERE SecCode = 563938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858521801, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 564035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487603, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 564417 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 564492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587932514, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2017-02-03' WHERE SecCode = 564862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475108946, ExchCode = 'STU' WHERE SecCode = 565316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857657672, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 565330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857726268, ExchCode = 'BER', PermQuoteRetireDate = '2014-03-27' WHERE SecCode = 565586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857740936, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 565707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489086, ExchCode = 'QTX' WHERE SecCode = 565752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857579082, ExchCode = 'FRA' WHERE SecCode = 565861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857541012, ExchCode = 'FRA' WHERE SecCode = 565866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857958579, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 567636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036180, PermQuoteStatus = 'DC', Ticker = 'XLE', ExchCode = 'TDG', PermQuoteRetireDate = '2013-04-19' WHERE SecCode = 568823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858319818, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-26' WHERE SecCode = 568829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705724, ExchCode = 'MXQ' WHERE SecCode = 573267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787219, ExchCode = 'DUS' WHERE SecCode = 575072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858527370, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-23' WHERE SecCode = 577333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858761330, ExchCode = 'FRA', PermQuoteRetireDate = '2015-07-21' WHERE SecCode = 580444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475127703, ExchCode = 'DEU', PermQuoteRetireDate = '2017-10-20' WHERE SecCode = 591764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475793862, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 593104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521814018, ExchCode = 'STU', PermQuoteRetireDate = '2014-04-25' WHERE SecCode = 594093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475141963, ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 594099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859132030, ExchCode = 'GER' WHERE SecCode = 594191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859254285, ExchCode = 'FRA', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 599978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255888, ExchCode = 'FRA', PermQuoteRetireDate = '2013-10-17' WHERE SecCode = 600391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475660385, InstrPermID = 8590922012, OrgPermID = 4295880615, ValQuotePermID = 55837430854.0, PriInstrPermID = 8590922012.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'YFM', ExchCode = 'GER', PermQuoteRetireDate = '2010-03-29', PermOrgIPODate = NULL WHERE SecCode = 601515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475859202, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22132756017, ExchCode = 'STO' WHERE SecCode = 602882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647852573, ExchCode = 'STU' WHERE SecCode = 607486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859760619, ExchCode = 'FRA' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581498976, ExchCode = 'MUN' WHERE SecCode = 701753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863112368, Ticker = 'BABC.GB', ExchCode = 'PLU' WHERE SecCode = 703518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287353, ExchCode = 'BIV' WHERE SecCode = 780513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749996718, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 826159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475136959, ExchCode = 'DEU' WHERE SecCode = 858901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610380111, ExchCode = 'DEU' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779809732, ExchCode = 'GTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 898441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223887, ExchCode = 'QTX' WHERE SecCode = 909718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785297550, ExchCode = 'QTX' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 997867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800222853, ExchCode = 'FRA' WHERE SecCode = 1017380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55876389121, Ticker = 'XGLI.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 1192765 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 1298142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747333716, ExchCode = 'FRA' WHERE SecCode = 1447581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480912846, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1447851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625073340, ExchCode = 'FRA' WHERE SecCode = 1453709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391706, ExchCode = 'GTX' WHERE SecCode = 1460338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704338, ExchCode = 'MXQ' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478615946, ExchCode = 'STO' WHERE SecCode = 1465275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798768605, ExchCode = 'HAM' WHERE SecCode = 1468807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742468, ExchCode = 'HAN' WHERE SecCode = 1472577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480227394, ExchCode = 'STU', PermQuoteRetireDate = '2013-05-20' WHERE SecCode = 1479224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478367, ExchCode = 'QTX' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481623767, ExchCode = 'DEU' WHERE SecCode = 1482803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488606, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704200, ExchCode = 'MXQ' WHERE SecCode = 1489564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109485, ExchCode = 'FRA' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531119071, Ticker = 'BRDGl', ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 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 QuotePermID = 21514028112, ExchCode = 'TDG' WHERE SecCode = 1522268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850857936, ExchCode = 'MUN' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179775, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704626, ExchCode = 'MXQ' WHERE SecCode = 1524554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536289597, ExchCode = 'FRA' WHERE SecCode = 1524628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497908, ExchCode = 'FRA' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152677, ExchCode = 'MUN' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098687, ExchCode = 'DEU' WHERE SecCode = 1527502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490958523, ExchCode = 'FRA' WHERE SecCode = 1531694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535039956, ExchCode = 'STU' WHERE SecCode = 1532859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529849881, Ticker = 'RBT', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1533786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067014491, ExchCode = 'DEU' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273313, ExchCode = 'GTX' WHERE SecCode = 1537214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379929, ExchCode = 'LAS' WHERE SecCode = 1539987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480207, PermQuoteStatus = 'DC', Ticker = '7NU', ExchCode = 'QTX', PermQuoteRetireDate = '2023-08-03', PermSecMapEndDate = '2025-06-13' WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496864672, ExchCode = 'DEU' WHERE SecCode = 1546652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893351, ExchCode = 'STU' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802875945, ExchCode = 'LAS' WHERE SecCode = 1547496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705407, ExchCode = 'MXQ' WHERE SecCode = 1552111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650254, ExchCode = 'DUS' WHERE SecCode = 1552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802455291, ExchCode = 'FRA' WHERE SecCode = 1553832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514434081, Ticker = '5GQA', ExchCode = 'BER', PermQuoteRetireDate = '2020-04-02' WHERE SecCode = 1554222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502328853, ExchCode = 'FRA' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386019, ExchCode = 'LAS' WHERE SecCode = 1578153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524609219, ExchCode = 'BTE' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308500, ExchCode = 'FRA' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704832, ExchCode = 'MXQ' WHERE SecCode = 1595975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505184781, ExchCode = 'STO' WHERE SecCode = 1596529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515927789, ExchCode = 'DEU' WHERE SecCode = 1601542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705694, ExchCode = 'MXQ' WHERE SecCode = 1621273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331619, Ticker = 'KJ7A', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1623980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950789, ExchCode = 'STU', PermQuoteRetireDate = '2023-10-10', PermSecMapEndDate = NULL WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493518, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 1630461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482368066, Ticker = 'PV0D', ExchCode = 'SES', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 1630565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320060, ExchCode = 'DEU' WHERE SecCode = 1675781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522286896, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 1675785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613032675, ExchCode = 'STU' WHERE SecCode = 1677273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627697, ExchCode = 'QTX' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512395856, ExchCode = 'DEU' WHERE SecCode = 1699181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515522117, ExchCode = 'DEU' WHERE SecCode = 1713829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792907733, ExchCode = 'FRA' WHERE SecCode = 1733285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513762717, ExchCode = 'FRA' WHERE SecCode = 1736071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514707492, ExchCode = 'DEU' WHERE SecCode = 1748432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538295288, ExchCode = 'FRA' WHERE SecCode = 1768937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513489767, ExchCode = 'FRA' WHERE SecCode = 1778982 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 1920980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673265, ExchCode = 'BIV' WHERE SecCode = 2014210 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387857, ExchCode = 'LAS' WHERE SecCode = 2039989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561784, ExchCode = 'GTX' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517928750, ExchCode = 'FRA' WHERE SecCode = 2055381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814536775, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-21' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302126, ExchCode = 'STU' WHERE SecCode = 2115211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659437, ExchCode = 'GTX' WHERE SecCode = 2115214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658940658, ExchCode = 'MUN' WHERE SecCode = 2142278 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 2195628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357671, ExchCode = 'FRA' WHERE SecCode = 2201310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371241, ExchCode = 'SGO' WHERE SecCode = 2201320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537129363, ExchCode = 'BER', PermQuoteRetireDate = '2025-06-12', PermSecMapEndDate = '2025-06-26' WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522213264, ExchCode = 'FRA' WHERE SecCode = 2222349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834002, ExchCode = 'FRA' WHERE SecCode = 2225286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346547, Ticker = 'YE2', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606147777, ExchCode = 'STU', PermQuoteRetireDate = '2018-05-09' WHERE SecCode = 2232834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831441, ExchCode = 'DEU' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781570154, ExchCode = 'DUS' WHERE SecCode = 2239280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524108941, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784838122, ExchCode = 'QTX' WHERE SecCode = 2246863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068249, ExchCode = 'FRA' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531135776, ExchCode = 'BCO' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477221044, Ticker = NULL WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830026, ExchCode = 'QTX' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525642046, ExchCode = 'DEU' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675187, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854585, ExchCode = 'BER', PermQuoteRetireDate = '2020-12-29' WHERE SecCode = 2288362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527318087, ExchCode = 'FRA' WHERE SecCode = 2319580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-16' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484790, ExchCode = 'QTX' WHERE SecCode = 2357974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530840197, ExchCode = 'FRA' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756136975, ExchCode = 'FRA' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130921495, ExchCode = 'DEU' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381501, ExchCode = 'LAS' WHERE SecCode = 2379809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531721248, InstrPermID = 8590005814, OrgPermID = 4295915565, ValQuotePermID = 55838797234.0, PriInstrPermID = 8590005814.0, PermInstrStatus = 'DC', Ticker = '56A', ExchCode = 'BER', QuoteClass = 'ORD', InstrClass = 'ORD', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951348.0, PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2020-09-09' WHERE SecCode = 2387360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532119904, ExchCode = 'DEU' WHERE SecCode = 2394797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532177823, ExchCode = 'FRA', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892047304, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2412432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532914219, ExchCode = 'STU' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2441702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478385, ExchCode = 'QTX' WHERE SecCode = 2455543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694081314, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824100155, ExchCode = 'TDG' WHERE SecCode = 2458822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537245207, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 2466348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536043370, ExchCode = 'FRA' WHERE SecCode = 2467266 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555632, ExchCode = 'DEU' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999786358, ExchCode = 'BTE' WHERE SecCode = 2510129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815141967, ExchCode = 'MUN' WHERE SecCode = 2511591 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591015805, ExchCode = 'BER' WHERE SecCode = 2513107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597458278, Ticker = '22N', ExchCode = 'BER', PermQuoteRetireDate = '2023-10-03' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385079, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2529636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538885258, ExchCode = 'DEU' WHERE SecCode = 2529651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629786303, ExchCode = 'DEU' WHERE SecCode = 2539933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673930, ExchCode = 'BIV' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542003679, ExchCode = 'STU' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103484, ExchCode = 'FRA' WHERE SecCode = 2554904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730461583, ExchCode = 'MUN', PermQuoteRetireDate = '2022-04-05' WHERE SecCode = 2556600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542003936, ExchCode = 'FRA', PermQuoteRetireDate = '2015-05-21' WHERE SecCode = 2560597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541408600, ExchCode = 'BER', PermQuoteRetireDate = '2023-07-17', PermSecMapEndDate = NULL WHERE SecCode = 2560601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542469532, ExchCode = 'DEU' WHERE SecCode = 2567216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807916873, ExchCode = 'MUN', PermQuoteRetireDate = '2024-03-01', PermSecMapEndDate = '2024-03-01' WHERE SecCode = 2572309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673451, ExchCode = 'BIV' WHERE SecCode = 2572318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542813327, ExchCode = 'TDG' WHERE SecCode = 2573038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543102507, ExchCode = 'FRA' WHERE SecCode = 2579445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830369, ExchCode = 'DUS' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543708913, ExchCode = 'DEU' WHERE SecCode = 2585326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284826, ExchCode = 'GTX' WHERE SecCode = 2585381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792941383, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2021-03-10' WHERE SecCode = 2591696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369809, ExchCode = 'SGO' WHERE SecCode = 2598717 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 QuotePermID = 21544378913, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-23' WHERE SecCode = 2604155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611446145, ExchCode = 'FRA' WHERE SecCode = 2604394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675457, ExchCode = 'BIV' WHERE SecCode = 2604399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609149462, Ticker = '3ITS', ExchCode = 'LSE' WHERE SecCode = 2604404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704472, ExchCode = 'MXQ' WHERE SecCode = 2605847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545350134, ExchCode = 'DEU' WHERE SecCode = 2605866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659522, ExchCode = 'LAS' WHERE SecCode = 2605870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634474245, ExchCode = 'MUN' WHERE SecCode = 2616461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545617420, ExchCode = 'DEU' WHERE SecCode = 2617118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651407157, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2622293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521371263, ExchCode = 'BEC' WHERE SecCode = 2625122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546332345, PermQuoteStatus = 'AC', Ticker = '14S0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2625801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062334, ExchCode = 'MUN' WHERE SecCode = 2631562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634652632, ExchCode = 'MUN' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585102646, ExchCode = 'STU' WHERE SecCode = 2635746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781870182, ExchCode = 'STU' WHERE SecCode = 2642447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109508, ExchCode = 'DEU' WHERE SecCode = 2643269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548544384, ExchCode = 'DEU' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704172, ExchCode = 'MXQ' WHERE SecCode = 2644179 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-03-31' WHERE SecCode = 2649124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478452, ExchCode = 'QTX' WHERE SecCode = 2649155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549690613, ExchCode = 'TDG' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460842, ExchCode = 'HAN' WHERE SecCode = 2659980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549893799, ExchCode = 'DEU' WHERE SecCode = 2668929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535197344, Ticker = '7HP', ExchCode = 'BRN' WHERE SecCode = 2679919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451855, Ticker = 'QCOM', ExchCode = 'SWX' WHERE SecCode = 2679937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623807327, ExchCode = 'MUN' WHERE SecCode = 2682326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955513813, ExchCode = 'DUS' WHERE SecCode = 2711152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552534617, ExchCode = 'STU' WHERE SecCode = 2711203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727309229, ExchCode = 'MEX' WHERE SecCode = 2715641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705935887, ExchCode = 'BIV' WHERE SecCode = 2724356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273765, ExchCode = 'GTX' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387967, ExchCode = 'LAS' WHERE SecCode = 2732754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677010, ExchCode = 'BIV' WHERE SecCode = 2743610 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 = 21555271601, ExchCode = 'FRA' WHERE SecCode = 2764597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704388, ExchCode = 'MXQ' WHERE SecCode = 2767208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335786, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2770609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755558882, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2774739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652008408, ExchCode = 'TDG' WHERE SecCode = 2807599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21716468870, ExchCode = 'DEU' WHERE SecCode = 2824459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308386, ExchCode = 'GTX' WHERE SecCode = 2824461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805177422, ExchCode = 'MUN' WHERE SecCode = 2826670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535495575, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 2827915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289547, Ticker = '8PSG', ExchCode = 'GTX' WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589220365, ExchCode = 'DEU', PermQuoteRetireDate = '2019-04-05' WHERE SecCode = 2855771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560761404, ExchCode = 'FRA' WHERE SecCode = 2855773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650334, ExchCode = 'QTX' WHERE SecCode = 2858551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561140926, ExchCode = 'DEU' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460777, ExchCode = 'FRA' WHERE SecCode = 2864471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478711, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561687595, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19', PermSecMapEndDate = '2021-08-19' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562290887, ExchCode = 'STU' WHERE SecCode = 2870150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704681, ExchCode = 'MXQ' WHERE SecCode = 2876241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564447127, ExchCode = 'BTE', PermQuoteRetireDate = '2015-05-29' WHERE SecCode = 2900876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564572205, ExchCode = 'TDG' WHERE SecCode = 2905610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731661976, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564680222, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-19' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478659, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2909243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564938913, ExchCode = 'DEU' WHERE SecCode = 2909928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830042, ExchCode = 'QTX' WHERE SecCode = 2910709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493096, ExchCode = 'QTX' WHERE SecCode = 2919727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679813, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369228, ExchCode = 'BEC' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 2928723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566935898, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2930544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900629, ExchCode = 'STU', PermQuoteRetireDate = '2019-12-04' WHERE SecCode = 2930555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100044, ExchCode = 'MUN' WHERE SecCode = 2946497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836510352, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-16' WHERE SecCode = 2947875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381763, ExchCode = 'LAS' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731165568, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787459, ExchCode = 'DUS', PermQuoteRetireDate = '2023-11-09' WHERE SecCode = 2963590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659445, ExchCode = 'GTX' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787252, ExchCode = 'DUS' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573048228, ExchCode = 'BCO', PermQuoteRetireDate = '2015-10-12' WHERE SecCode = 2993543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3018639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890669833, Ticker = '9GLA', ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585829107, PermQuoteStatus = 'AC', Ticker = 'IWIA', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3031598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479590, ExchCode = 'QTX' WHERE SecCode = 3032363 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 3033823 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2001-04-25' WHERE SecCode = 3076712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022764, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3083485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582352174, ExchCode = 'FRA' WHERE SecCode = 3085564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787344, Ticker = '42P', ExchCode = 'DUS', PermQuoteRetireDate = '2021-03-16' WHERE SecCode = 3096965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385101, ExchCode = 'LAS' WHERE SecCode = 3098021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955916, ExchCode = 'TDG' WHERE SecCode = 3101224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800738271, ExchCode = 'QTX' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164689309, ExchCode = 'GTX' WHERE SecCode = 3121289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077929, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3121290 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3124160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294042, ExchCode = 'GTX' WHERE SecCode = 3125028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552305555, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 3153817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587220566, ExchCode = 'TDG' WHERE SecCode = 3153872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790760, ExchCode = 'GTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705812, Ticker = 'TLRDQ*', ExchCode = 'MXQ' WHERE SecCode = 3177778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798143359, ExchCode = 'FRA' WHERE SecCode = 3186751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608121119, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 3196346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768480038, ExchCode = 'MUN' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769880745, ExchCode = 'FRA' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937100717, ExchCode = 'QTX' WHERE SecCode = 3208355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962344738, Ticker = '1VOW3m', ExchCode = 'BTE' WHERE SecCode = 3212165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591801382, ExchCode = 'BER' WHERE SecCode = 3212190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783235612, ExchCode = 'STU' WHERE SecCode = 3213268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789234589, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3223076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747575641, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683901733, ExchCode = 'MUN', PermQuoteRetireDate = '2020-08-11' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641748, ExchCode = 'DUS' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301751, ExchCode = 'GTX' WHERE SecCode = 3246454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824694891, ExchCode = 'DUS' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597150560, ExchCode = 'CHA' WHERE SecCode = 3247975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597702791, ExchCode = 'DEU' WHERE SecCode = 3257180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678970, ExchCode = 'BIV' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520286, ExchCode = 'QTX' WHERE SecCode = 3281992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387859, ExchCode = 'LAS' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603342349, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3283956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100774, ExchCode = 'DUS' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546129, ExchCode = 'MUN' WHERE SecCode = 3308987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743775985, ExchCode = 'DEU', PermQuoteRetireDate = '2022-02-14' WHERE SecCode = 3309705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608270955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679353, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710324067, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3315888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611220164, ExchCode = 'TDG' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644443154, ExchCode = 'DEU' WHERE SecCode = 3320334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632742048, ExchCode = 'MUN' WHERE SecCode = 3320375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297982, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297854, ExchCode = 'DUS' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793910667, ExchCode = 'QTX' WHERE SecCode = 3337223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611445381, ExchCode = 'DEU' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018876, ExchCode = 'MUN' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643067252, ExchCode = 'TDG' WHERE SecCode = 3339668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645200699, ExchCode = 'TDG' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614735175, ExchCode = 'DEU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3358227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616850045, Ticker = '14G0', ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-31' WHERE SecCode = 3366981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661803849, ExchCode = 'FRA' WHERE SecCode = 3367035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632742042, ExchCode = 'MUN' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875267, ExchCode = 'TDG' WHERE SecCode = 3368562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648301745, ExchCode = 'STU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663294277, ExchCode = 'MUN', PermQuoteRetireDate = '2022-09-12' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029268, ExchCode = 'SWX' WHERE SecCode = 3394005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029277, ExchCode = 'SWX' WHERE SecCode = 3394011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659667, ExchCode = 'LAS' WHERE SecCode = 3394497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808390634, ExchCode = 'DEU' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623455650, ExchCode = 'BCO' WHERE SecCode = 3395249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169958746, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-03-30', PermSecMapEndDate = NULL WHERE SecCode = 3395352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660711293, ExchCode = 'DEU' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628937008, ExchCode = 'TDG' WHERE SecCode = 3405439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796757245, ExchCode = 'FRA' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800223463, ExchCode = 'LAS' WHERE SecCode = 3407871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901491943, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396811, ExchCode = 'FRA' WHERE SecCode = 3409090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801287178, Ticker = 'C0B', ExchCode = 'STU' WHERE SecCode = 3410283 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-31', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 3429553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100504, ExchCode = 'QTX' WHERE SecCode = 3430025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879249284, ExchCode = 'QTX', PermQuoteRetireDate = '2026-02-04', PermSecMapEndDate = '2026-03-13' WHERE SecCode = 3431060 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-03-31' WHERE SecCode = 3431612 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 3432019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636053310, ExchCode = 'MUN' WHERE SecCode = 3432164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636056227, ExchCode = 'FRA' WHERE SecCode = 3435060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782375294, ExchCode = 'STU' WHERE SecCode = 3436849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788404566, ExchCode = 'QTX' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-31', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 3439565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643223177, ExchCode = 'FRA' WHERE SecCode = 3444252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688591124, ExchCode = 'STU' WHERE SecCode = 3445093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796141667, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3445201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388252, ExchCode = 'LAS' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705440, ExchCode = 'MXQ' WHERE SecCode = 3446301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646184428, ExchCode = 'TDG' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733749545, ExchCode = 'FRA' WHERE SecCode = 3446652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705376, ExchCode = 'MXQ' WHERE SecCode = 3446696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782180687, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3446753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682304337, PermQuoteStatus = 'AC', Ticker = '1YI0', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3446931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938003820, ExchCode = 'MUN' 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 = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800450347, ExchCode = 'MUN' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669695686, ExchCode = 'BTE', PermQuoteRetireDate = '2022-07-12' WHERE SecCode = 3499290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675265, ExchCode = 'BIV' WHERE SecCode = 3501208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776247331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3503523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' WHERE SecCode = 3513992 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-03-31', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 3519877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660430834, ExchCode = 'DEU' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653848411, Ticker = 'TGL', ExchCode = 'LSE', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3536053 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3538957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685853416, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757243010, ExchCode = 'STU' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780478263, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3544433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452801, ExchCode = 'DEU' WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953637183, ExchCode = 'STU' WHERE SecCode = 3549499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655727195, ExchCode = 'FRA' WHERE SecCode = 3551874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796358598, ExchCode = 'TDG' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656632105, Ticker = 'DNK', ExchCode = 'LSE', PermQuoteRetireDate = '2021-09-24' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688418703, ExchCode = 'QTX', PermQuoteRetireDate = '2023-02-07', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 3565802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805015471, ExchCode = 'MUN' WHERE SecCode = 3569619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731163509, ExchCode = 'FRA' WHERE SecCode = 3584663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21879563449, ExchCode = 'MUN' WHERE SecCode = 3587019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544508318, ExchCode = 'STU' WHERE SecCode = 3587041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836427906, ExchCode = 'FRA', PermQuoteRetireDate = '2020-03-05' WHERE SecCode = 3588045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952428, ExchCode = 'FRA' WHERE SecCode = 3591601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777289547, ExchCode = 'TDG' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667209671, ExchCode = 'DEU' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667202566, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668632710, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3639274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21668783322, ExchCode = 'HAN' WHERE SecCode = 3642406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670290646, ExchCode = 'QTX', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670410338, Ticker = 'ROAI', ExchCode = 'SWX', PermQuoteRetireDate = '2023-09-22' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670722964, ExchCode = 'QTX' WHERE SecCode = 3657810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581867, ExchCode = 'QTX' WHERE SecCode = 3657811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505131, ExchCode = 'MUN' WHERE SecCode = 3658775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671049443, PermQuoteStatus = 'AC', Ticker = '1SS', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3663204 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684599537, ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-15' WHERE SecCode = 3669986 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673638002, ExchCode = 'QTX' WHERE SecCode = 3673707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302234, ExchCode = 'GTX' WHERE SecCode = 3675861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21676198882, ExchCode = 'DEU', PermQuoteRetireDate = '2024-04-24' WHERE SecCode = 3716790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383886, ExchCode = 'MEX' WHERE SecCode = 3732368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659502, ExchCode = 'LAS' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680538261, ExchCode = 'DEU', PermQuoteRetireDate = '2022-12-15' WHERE SecCode = 3738158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722345192, ExchCode = 'STU', PermQuoteRetireDate = '2021-12-20' WHERE SecCode = 3749084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872326, ExchCode = 'DEU' WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674386, ExchCode = 'BIV' WHERE SecCode = 3756608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21683763490, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431754, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-28' WHERE SecCode = 3779971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377692, ExchCode = 'BIV' WHERE SecCode = 3783012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685868276, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461787, ExchCode = 'FRA' WHERE SecCode = 3793374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687635991, ExchCode = 'TDG' WHERE SecCode = 3793375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679373, ExchCode = 'BIV' WHERE SecCode = 3793436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719386690, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-28', PermSecMapEndDate = '2023-03-30' WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707022417, ExchCode = 'MUN' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690334717, ExchCode = 'DUS' WHERE SecCode = 3809861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690462879, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3812238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690815100, ExchCode = 'DEU' WHERE SecCode = 3817679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527274, ExchCode = 'DEU' WHERE SecCode = 3818167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373511, ExchCode = 'MEX' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394501, ExchCode = 'MXQ' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789617000, ExchCode = 'MEX' WHERE SecCode = 3827965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650229, ExchCode = 'DUS' WHERE SecCode = 3829975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711930883, ExchCode = 'MUN' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734634078, ExchCode = 'STU' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723480105, ExchCode = 'MUN' WHERE SecCode = 3841484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367137, ExchCode = 'DEU' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-06-27' WHERE SecCode = 3847091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744919357, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373509, ExchCode = 'BIV' WHERE SecCode = 3854663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812350912, ExchCode = 'DEU' WHERE SecCode = 3863388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701456710, ExchCode = 'BER' WHERE SecCode = 3881176 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702351475, ExchCode = 'DEU', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 3883551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703075521, ExchCode = 'MUN' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773918983, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3899638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21702310122, ExchCode = 'DEU', PermQuoteRetireDate = '2019-07-17' WHERE SecCode = 3899640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386695, ExchCode = 'LAS' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749296489, ExchCode = 'TDG' WHERE SecCode = 3908080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432094, ExchCode = 'FRA' WHERE SecCode = 3908081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320126, ExchCode = 'FRA' WHERE SecCode = 3908087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168601313, ExchCode = 'DEU' WHERE SecCode = 3913159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732144859, ExchCode = 'TDG' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383362, ExchCode = 'MEX' WHERE SecCode = 3934323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812338413, ExchCode = 'MUN' WHERE SecCode = 3951450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712452863, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3955660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403388, ExchCode = 'FRA' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722747312, ExchCode = 'BCO' WHERE SecCode = 4024795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011239, Ticker = '2T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011919, Ticker = '2ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011911, Ticker = '2AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011959, Ticker = '2DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027148, Ticker = '1DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143843, Ticker = '2HEIA', ExchCode = 'MIL' WHERE SecCode = 4031893 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 = 21774922624, ExchCode = 'BCO' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725971281, ExchCode = 'TDG' WHERE SecCode = 4046521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634821003, Ticker = 'OCPETb', ExchCode = 'BCO', PermQuoteRetireDate = '2024-01-31' WHERE SecCode = 4046600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652454, ExchCode = 'FRA' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726460845, ExchCode = 'FRA' WHERE SecCode = 4068293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782414982, ExchCode = 'QTX' WHERE SecCode = 4080599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734028297, ExchCode = 'MUN' WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739862119, PermQuoteStatus = 'DC', Ticker = 'JARUl', ExchCode = 'MAA', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587301011, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735442278, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4106680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383364, ExchCode = 'TDG' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815144829, Ticker = '49Y', ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-20' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787721995, ExchCode = 'MUN' WHERE SecCode = 4110887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21740303517, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14', PermSecMapEndDate = NULL WHERE SecCode = 4124848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674204, ExchCode = 'BIV' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829986, ExchCode = 'QTX' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097198, ExchCode = 'LAS' WHERE SecCode = 4178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745664579, ExchCode = 'STU' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611415, ExchCode = 'FRA' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771675002, ExchCode = 'FRA' WHERE SecCode = 4212482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740527, ExchCode = 'LAS' WHERE SecCode = 4225217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679079, ExchCode = 'BIV' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756547830, ExchCode = 'DEU' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487599, ExchCode = 'QTX' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757260444, ExchCode = 'FRA' WHERE SecCode = 4278855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628095, ExchCode = 'DUS' WHERE SecCode = 4278857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842459237, ExchCode = 'HAN' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763690130, ExchCode = 'QTX' WHERE SecCode = 4321393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387283, ExchCode = 'LAS' WHERE SecCode = 4324721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112309, ExchCode = 'DEU' WHERE SecCode = 4328959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842591687, Ticker = '0A3Ml', ExchCode = 'BCO' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782583016, ExchCode = 'DUS' WHERE SecCode = 4365804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772653309, Ticker = '1ENR' WHERE SecCode = 4372484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772839734, ExchCode = 'DEU' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606760, ExchCode = 'DEU' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510674, ExchCode = 'QTX' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650381, ExchCode = 'QTX' WHERE SecCode = 4379790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774613209, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777647867, ExchCode = 'TDG' WHERE SecCode = 4402301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307749, ExchCode = 'MEX' WHERE SecCode = 4404027 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 = 236779370427, ExchCode = 'AQX' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785453356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4436991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786685893, PermQuoteStatus = 'AC', Ticker = '60P0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788257884, ExchCode = 'FRA', PermQuoteRetireDate = '2023-06-28', PermSecMapEndDate = '2023-06-28' WHERE SecCode = 4449703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727299958, ExchCode = 'BIV' WHERE SecCode = 4449704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301153, ExchCode = 'BIV' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790867954, ExchCode = 'STU' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689536, ExchCode = 'DEU' WHERE SecCode = 4463152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956950, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794060560, ExchCode = 'STU' WHERE SecCode = 4472910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830307201, ExchCode = 'GTX' WHERE SecCode = 4474245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386726, ExchCode = 'LAS' WHERE SecCode = 4474387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897784749, ExchCode = 'GTX' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793526925, ExchCode = 'QTX' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817527, ExchCode = 'DEU' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367409, ExchCode = 'FRA' WHERE SecCode = 4482720 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 4489235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796645883, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-05' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956106, Ticker = '0A6Nl', ExchCode = 'BCO' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409262, ExchCode = 'FRA' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727286506, ExchCode = 'MEX' WHERE SecCode = 4505794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852456562, ExchCode = 'BRN' WHERE SecCode = 4506359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386877, ExchCode = 'LAS' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181247, ExchCode = 'DUS' WHERE SecCode = 4517645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851675957, ExchCode = 'STU' WHERE SecCode = 4526144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799910403, ExchCode = 'DEU' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803607182, ExchCode = 'DEU', PermQuoteRetireDate = '2025-04-11', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219724, ExchCode = 'DEU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804219797, ExchCode = 'DEU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271946, ExchCode = 'BIV' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806535085, ExchCode = 'MUN' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823056706, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = NULL WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 4568357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813395103, ExchCode = 'FRA' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814382045, ExchCode = 'DEU' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881522351, ExchCode = 'MUN' WHERE SecCode = 4601728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21817036435, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-09' WHERE SecCode = 4607686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275562, ExchCode = 'GTX' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816916392, ExchCode = 'DEU', PermQuoteRetireDate = '2023-05-11' WHERE SecCode = 4611056 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800012350, ExchCode = 'LAS' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821642083, ExchCode = 'BTE', PermQuoteRetireDate = '2025-08-05' WHERE SecCode = 4617741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888689541, ExchCode = 'STU' WHERE SecCode = 4620159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820389350, ExchCode = 'FRA' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438919, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4637752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312167, ExchCode = 'GTX' WHERE SecCode = 4637756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21934228224, ExchCode = 'STU', PermQuoteRetireDate = '2025-02-07', PermSecMapEndDate = NULL WHERE SecCode = 4643054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388759, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4658881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831549319, ExchCode = 'TDG' WHERE SecCode = 4671286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21833145669, ExchCode = 'FRA' WHERE SecCode = 4677605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835319557, ExchCode = 'FRA' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316576, ExchCode = 'MUN' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837527952, Ticker = 'CARB', ExchCode = 'MIL' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026894, Ticker = '1STX' WHERE SecCode = 4699232 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 4717141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843915142, ExchCode = 'STU' WHERE SecCode = 4718903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850051602, ExchCode = 'TDG' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864897365, ExchCode = 'FRA', PermQuoteRetireDate = '2024-09-05' WHERE SecCode = 4726108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098536, ExchCode = 'DUS' WHERE SecCode = 4748505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814076491, ExchCode = 'DEU' WHERE SecCode = 4752207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561792, ExchCode = 'GTX' WHERE SecCode = 4754742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853887005, ExchCode = 'DUS' WHERE SecCode = 4754869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852735329, ExchCode = 'FRA' WHERE SecCode = 4756369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439422, ExchCode = 'DUS' WHERE SecCode = 4756621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854742271, ExchCode = 'DEU' WHERE SecCode = 4761587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854877140, ExchCode = 'DUS' WHERE SecCode = 4768286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018892, ExchCode = 'STU' WHERE SecCode = 4773770 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 Ticker = 'EBRDA', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 4780386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921513349, ExchCode = 'QTX' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860831312, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4800552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860309686, ExchCode = 'MUN' WHERE SecCode = 4800558 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 4804556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886807336, ExchCode = 'GTX', PermQuoteRetireDate = '2025-01-15' WHERE SecCode = 4811144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862998607, ExchCode = 'QTX' WHERE SecCode = 4818264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379540, ExchCode = 'LAS' WHERE SecCode = 4845025 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 = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580179, ExchCode = 'GER' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874648333, Ticker = '9XK', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4873803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892048749, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885726, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4890300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898166, Ticker = '2TRVm', ExchCode = 'BCO' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21880715135, ExchCode = 'QTX' WHERE SecCode = 4927268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898654, ExchCode = 'FRA' WHERE SecCode = 4929498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380552, ExchCode = 'LAS' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883516418, ExchCode = 'FRA' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890421877, ExchCode = 'MUN' WHERE SecCode = 4950864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953965734, ExchCode = 'QTX' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779515510, ExchCode = 'FRA' WHERE SecCode = 4973342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889561153, PermQuoteStatus = 'DC', ExchCode = 'BER', OrgTypeCode = 'COM', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4980098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212169, ExchCode = 'MEX' WHERE SecCode = 4980103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100451, ExchCode = 'QTX' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980198448, ExchCode = 'FRA' WHERE SecCode = 5011657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387447, ExchCode = 'LAS' WHERE SecCode = 5011663 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-03-31' WHERE SecCode = 5037224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908059227, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5038681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898865529, ExchCode = 'DEU' WHERE SecCode = 5041758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195445, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 5042969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901209210, ExchCode = 'FRA' WHERE SecCode = 5052451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777507074, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-08' WHERE SecCode = 5063516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902573195, ExchCode = 'DUS' WHERE SecCode = 5067269 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238786, ExchCode = 'LAS' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931482934, ExchCode = 'GTX' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903664236, ExchCode = 'FRA' WHERE SecCode = 5072164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076711, ExchCode = 'LAS' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21903663662, ExchCode = 'DEU' WHERE SecCode = 5072166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380635, ExchCode = 'LAS' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777145391, ExchCode = 'STU' WHERE SecCode = 5082548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727217399, ExchCode = 'MEX' WHERE SecCode = 5083954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381619, ExchCode = 'LAS' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876909126, ExchCode = 'MXQ' WHERE SecCode = 5099007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907546209, ExchCode = 'DUS', PermQuoteRetireDate = '2024-11-29' WHERE SecCode = 5099027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718186332, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5099028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908064114, ExchCode = 'FRA' WHERE SecCode = 5102905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716268, ExchCode = 'DEU' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816912714, ExchCode = 'FRA', PermQuoteRetireDate = '2023-01-12', PermSecMapEndDate = '2023-01-12' WHERE SecCode = 5112411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834841, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5115635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910867434, ExchCode = 'STU' WHERE SecCode = 5119165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910877570, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 5119167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198694, ExchCode = 'BIV' WHERE SecCode = 5120588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778416293, ExchCode = 'TDG' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913082644, ExchCode = 'BER' WHERE SecCode = 5129748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659492, ExchCode = 'LAS' WHERE SecCode = 5130678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912121144, ExchCode = 'FRA' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915977241, ExchCode = 'DEU' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430438, ExchCode = 'DEU' WHERE SecCode = 5153443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430452, ExchCode = 'DEU' WHERE SecCode = 5153444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919459011, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5155392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794279503, Ticker = '0A60', ExchCode = 'LSE' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634297955, Ticker = '0M1Kl', ExchCode = 'BCO' WHERE SecCode = 5161267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758567887, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347143, ExchCode = 'MEX' WHERE SecCode = 5161305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727308116, ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667329377, ExchCode = 'DEU' WHERE SecCode = 5161350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21827095404, ExchCode = 'MXQ' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21657632265, Ticker = 'FT5', ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-04' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781498592, ExchCode = 'MXQ' WHERE SecCode = 5161409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727360441, ExchCode = 'BIV' WHERE SecCode = 5161415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850514745, ExchCode = 'DEU' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820375290, Ticker = 'SQTA', ExchCode = 'TDG', PermQuoteRetireDate = '2021-09-20' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825885781, ExchCode = 'FRA' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21919483609, ExchCode = 'DEU' WHERE SecCode = 5162435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920271921, ExchCode = 'DEU' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920271908, ExchCode = 'DEU' WHERE SecCode = 5166813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921901229, ExchCode = 'DEU' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922262943, ExchCode = 'DEU' WHERE SecCode = 5178622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922262866, ExchCode = 'DEU' WHERE SecCode = 5178623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947744427, ExchCode = 'STU', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 5182664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923425218, ExchCode = 'DEU' WHERE SecCode = 5183106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933953345, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923944044, ExchCode = 'DEU' WHERE SecCode = 5189106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834872, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5195447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950518158, ExchCode = 'GTX' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904151, ExchCode = 'BTE' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836196, Ticker = 'AFTTp', ExchCode = 'EQD' WHERE SecCode = 5206274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22093287267, Ticker = 'ALINKa', ExchCode = 'BCO' WHERE SecCode = 5206286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836113, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5208067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47733359573, ExchCode = 'DEU' WHERE SecCode = 5209761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930042387, ExchCode = 'QTX' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552224, ExchCode = 'LAS' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951901113, ExchCode = 'MUN' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727227057, ExchCode = 'BIV' WHERE SecCode = 5238268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794004180, ExchCode = 'QTX' WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779979676, ExchCode = 'DUS' WHERE SecCode = 5247621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727192008, ExchCode = 'BIV' WHERE SecCode = 5251003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787472777, ExchCode = 'MUN' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938339192, ExchCode = 'MUN' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21937069015, ExchCode = 'STU' WHERE SecCode = 5272089 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 5272184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381670, ExchCode = 'LAS' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793674806, ExchCode = 'LAS' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 5281305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21939245708, ExchCode = 'FRA' WHERE SecCode = 5283384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780979385, ExchCode = 'DUS' WHERE SecCode = 5290322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380705, ExchCode = 'LAS' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943068314, ExchCode = 'DEU' WHERE SecCode = 5301896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953922612, ExchCode = 'GTX', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = '2025-08-06' WHERE SecCode = 5311845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159093914, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2026-02-25' WHERE SecCode = 5315560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777397469, ExchCode = 'CHI' WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951358875, PermQuoteStatus = 'AC', Ticker = '3QP', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5324087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21949936569, ExchCode = 'DEU' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059910, ExchCode = 'FRA' WHERE SecCode = 5354968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954130974, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5357353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21958059866, ExchCode = 'FRA' WHERE SecCode = 5374941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727195025, ExchCode = 'MEX' WHERE SecCode = 5381947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959409338, ExchCode = 'DEU' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716837, ExchCode = 'FRA' WHERE SecCode = 5383598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785535434, ExchCode = 'DUS' WHERE SecCode = 5383599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776535810, ExchCode = 'MEX' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380717, ExchCode = 'LAS' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777481353, ExchCode = 'FRA' WHERE SecCode = 5422843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777481357, ExchCode = 'FRA' WHERE SecCode = 5422844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921820703, ExchCode = 'BER', PermQuoteRetireDate = '2024-12-17', PermSecMapEndDate = '2024-12-17' WHERE SecCode = 5434319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21977157700, ExchCode = 'DEU' WHERE SecCode = 5468672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778372898, ExchCode = 'STU' WHERE SecCode = 5468679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193595, ExchCode = 'BIV' WHERE SecCode = 5474598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729656, ExchCode = 'DEU' WHERE SecCode = 5478214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778437244, ExchCode = 'BIV' WHERE SecCode = 5482856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779515511, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5541732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834791, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837512254, Ticker = '3SQEl', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5569214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834875, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881554208, ExchCode = 'GTX' WHERE SecCode = 5569235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151033, PermQuoteStatus = 'AC', Ticker = '3FNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5569246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997766265, Ticker = 'NGLS', ExchCode = 'LSE' WHERE SecCode = 5584733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212174, ExchCode = 'MEX' WHERE SecCode = 5604481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22004617984, ExchCode = 'DEU' WHERE SecCode = 5607542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966434, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-12' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'SG00', PermSecMapEndDate = NULL WHERE SecCode = 5658561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781607151, ExchCode = 'FRA' WHERE SecCode = 5663968 AND Type_ = 10;
UPDATE data_universe_permid SET ExchCode = 'PAR' WHERE SecCode = 5678857 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5719322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782872476, ExchCode = 'FRA' WHERE SecCode = 5749727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891343, ExchCode = 'FRA' WHERE SecCode = 5749886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782891391, ExchCode = 'FRA' WHERE SecCode = 5749887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782928373, ExchCode = 'FRA' WHERE SecCode = 5749901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782954307, ExchCode = 'FRA' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783112234, ExchCode = 'FRA' WHERE SecCode = 5764130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025956, ExchCode = 'LAS' WHERE SecCode = 5764717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133181433, Ticker = 'BTCW', ExchCode = 'SWX' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783329295, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040670142, ExchCode = 'GTX' WHERE SecCode = 5785805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037308993, ExchCode = 'DEU' WHERE SecCode = 5786123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037302983, ExchCode = 'DEU' WHERE SecCode = 5786125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783782319, ExchCode = 'STU' WHERE SecCode = 5786132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783963980, ExchCode = 'STU' WHERE SecCode = 5786133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534609, ExchCode = 'QTX' WHERE SecCode = 5786134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955012, ExchCode = 'LAS' WHERE SecCode = 5804329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776608791, ExchCode = 'BIV' WHERE SecCode = 5816988 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784107272, ExchCode = 'FRA' WHERE SecCode = 5817022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327233, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5827163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784326338, ExchCode = 'STU' WHERE SecCode = 5827164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327232, ExchCode = 'FRA' WHERE SecCode = 5827165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784418929, ExchCode = 'GTX' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551903, ExchCode = 'TDG' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784596709, ExchCode = 'FRA' WHERE SecCode = 5839467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601266, ExchCode = 'FRA' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601265, ExchCode = 'FRA' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601263, ExchCode = 'FRA' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735452563, ExchCode = 'DEU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788448869, ExchCode = 'BCO' WHERE SecCode = 5886974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785533896, Ticker = '4WL', ExchCode = 'STU', PermQuoteRetireDate = '2024-12-02', PermSecMapEndDate = '2024-12-02' WHERE SecCode = 5894939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801352002, ExchCode = 'GTX' WHERE SecCode = 5894957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785943776, ExchCode = 'FRA' WHERE SecCode = 5907872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784888212, ExchCode = 'MEX' WHERE SecCode = 5907884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951582651, ExchCode = 'MXQ' WHERE SecCode = 5958705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788004437, ExchCode = 'FRA' WHERE SecCode = 6001792 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787714242, ExchCode = 'MEX' WHERE SecCode = 6004772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386190, ExchCode = 'TDG' WHERE SecCode = 6010807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22070354815, ExchCode = 'DEU' WHERE SecCode = 6012971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788847043, ExchCode = 'MUN' WHERE SecCode = 6043475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22081001385, ExchCode = 'DEU' WHERE SecCode = 6075918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789657842, ExchCode = 'STU' WHERE SecCode = 6075919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133180917, Ticker = 'BITC', ExchCode = 'SWX' WHERE SecCode = 6078420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367925, ExchCode = 'SGO' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663690, ExchCode = 'AQX' WHERE SecCode = 6097325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22017341387, ExchCode = 'STU' WHERE SecCode = 6097334 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 = 21799311189, ExchCode = 'QTX' WHERE SecCode = 6097372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354996, ExchCode = 'MEX' WHERE SecCode = 6097383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784422712, ExchCode = 'BIV' WHERE SecCode = 6097386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727345444, ExchCode = 'MEX' WHERE SecCode = 6097390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380561, ExchCode = 'LAS' WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309872, Ticker = '3SPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 6097408 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823830, ExchCode = 'AQX' WHERE SecCode = 6097426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917829806, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128284, Ticker = 'SMCIm', ExchCode = 'BCO' WHERE SecCode = 6097447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21909689580, ExchCode = 'BTE' WHERE SecCode = 6097546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980178367, ExchCode = 'DUS' WHERE SecCode = 6097549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354555, ExchCode = 'MEX' WHERE SecCode = 6097578 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663670, ExchCode = 'AQX' WHERE SecCode = 6097580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086925583, ExchCode = 'MUN' WHERE SecCode = 6104636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089463033, ExchCode = 'DEU' WHERE SecCode = 6151862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790959257, ExchCode = 'GTX' WHERE SecCode = 6151863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791248887, ExchCode = 'STU' WHERE SecCode = 6190705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791456499, ExchCode = 'QTX' WHERE SecCode = 6204566 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792942788, ExchCode = 'LAS' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791696288, ExchCode = 'MEX' WHERE SecCode = 6223976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22133181713, Ticker = 'BTCE', ExchCode = 'SWX' WHERE SecCode = 6245909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890440366, ExchCode = 'DEU' WHERE SecCode = 6256382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888293867, Ticker = 'SMHSl', ExchCode = 'AQX' WHERE SecCode = 6256398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580180, ExchCode = 'DEU' WHERE SecCode = 6256405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181395, ExchCode = 'MEX' WHERE SecCode = 6256406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22150315636, ExchCode = 'DEU' WHERE SecCode = 6256407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734886875, PermQuoteStatus = 'AC', Ticker = '4E4', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745957943, PermQuoteStatus = 'AC', Ticker = '0BF0', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909392, PermQuoteStatus = 'AC', Ticker = '2IU1', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6256420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823991, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256440 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 6264181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801670227, ExchCode = 'GTX' WHERE SecCode = 6297520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787704640, ExchCode = 'MEX' WHERE SecCode = 6315107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787788319, ExchCode = 'MEX' WHERE SecCode = 6321016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549247, ExchCode = 'GTX' WHERE SecCode = 6358857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989711, ExchCode = 'MEX' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655560, ExchCode = 'FRA' WHERE SecCode = 6368868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655688, ExchCode = 'GER' WHERE SecCode = 6368869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655569, ExchCode = 'FRA' WHERE SecCode = 6368870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789745447, ExchCode = 'MEX' WHERE SecCode = 6375301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866542, ExchCode = 'BIV' WHERE SecCode = 6375353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22118566912, ExchCode = 'DEU' WHERE SecCode = 6382149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792427653, ExchCode = 'LAS' WHERE SecCode = 6382150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794320484, ExchCode = 'FRA' WHERE SecCode = 6396772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297587, ExchCode = 'MXQ' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121546541, ExchCode = 'DEU' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22122894403, ExchCode = 'DEU' WHERE SecCode = 6418487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794652101, ExchCode = 'DUS' WHERE SecCode = 6418488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799042091, ExchCode = 'FRA' WHERE SecCode = 6418489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083975572, ExchCode = 'QTX' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793789294, ExchCode = 'TDG' WHERE SecCode = 6426995 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 6438335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451414, ExchCode = 'BTE' WHERE SecCode = 6456368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157927, ExchCode = 'BTE' WHERE SecCode = 6456369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22152233865, ExchCode = 'AQX' WHERE SecCode = 6456371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157937, ExchCode = 'BTE' WHERE SecCode = 6456372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141703185, ExchCode = 'BTE' WHERE SecCode = 6456373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451415, ExchCode = 'BTE' WHERE SecCode = 6456374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22141447615, ExchCode = 'BTE' WHERE SecCode = 6456375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142157950, ExchCode = 'BTE' WHERE SecCode = 6456376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451405, ExchCode = 'BTE' WHERE SecCode = 6456377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796887960, ExchCode = 'QTX' WHERE SecCode = 6493213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938208, ExchCode = 'FRA' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938213, ExchCode = 'FRA' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938212, ExchCode = 'FRA' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797938214, ExchCode = 'FRA' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746061, ExchCode = 'DUS' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798743814, ExchCode = 'QTX' WHERE SecCode = 6543898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798768097, ExchCode = 'DUS' WHERE SecCode = 6548155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798948296, ExchCode = 'FRA' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 6578374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607261, Ticker = 'MRVL', ExchCode = 'SWX' WHERE SecCode = 6578375 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6580851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800269662, ExchCode = 'FRA' WHERE SecCode = 6596130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800658724, ExchCode = 'QTX' WHERE SecCode = 6596132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430458, ExchCode = 'DEU' WHERE SecCode = 6626587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-03-30', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 6664706 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-03-30' WHERE SecCode = 6683885 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-03-30' WHERE SecCode = 6683888 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 6694499 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 6699552 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-29' WHERE SecCode = 6705486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165599099, ExchCode = 'DEU' WHERE SecCode = 6716122 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'KF60', PermSecMapEndDate = NULL WHERE SecCode = 6721472 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 6724295 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-03-31' WHERE SecCode = 6724392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169958643, ExchCode = 'TDG' WHERE SecCode = 6727920 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 6728347 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-03-30' WHERE SecCode = 6728359 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 6741001 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-03-30' WHERE SecCode = 6741005 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2001-04-25' WHERE SecCode = 10902425 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 10960962 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-30' WHERE SecCode = 11022531 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11036683 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11056046 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-30' WHERE SecCode = 11060412 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'GTHOF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-03-30', PermSecMapEndDate = NULL WHERE SecCode = 11060606 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-30' WHERE SecCode = 11071727 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2001-04-25' WHERE SecCode = 11105813 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11137936 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-30' WHERE SecCode = 11143397 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11179435 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11186631 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-03-30' WHERE SecCode = 11221767 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-03-31' WHERE SecCode = 11224837 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11245885 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'ITA' WHERE SecCode = 11245917 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11270614 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11270615 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2025-06-27' WHERE SecCode = 11271269 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11274307 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 11276615 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-02' WHERE SecCode = 11292921 AND Type_ = 1;