UPDATE data_universe_permid SET QuotePermID = 236796141212, PermQuoteStatus = 'AC', Ticker = 'GLBl', ExchCode = 'SIG', PermQuoteRetireDate = NULL WHERE SecCode = 946 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 2176 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 5421 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 7851 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 9949 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 15960 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 16142 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 16143 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 27741 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 27994 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 27995 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 28133 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 29527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837364027, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', PermSecMapEndDate = '2021-01-11' WHERE SecCode = 34018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033744, PermQuoteStatus = 'AC', Ticker = 'AMD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 36096 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21474904383, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 37202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475818377, ExchCode = 'STU' WHERE SecCode = 37216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475586089, PermQuoteStatus = 'DC', Ticker = 'CPAG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475543280, PermQuoteStatus = 'DC', Ticker = 'GOBG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506520538, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 37422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853561637, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 45959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624187, Ticker = 'SCX', ExchCode = 'MUN', PermQuoteRetireDate = '2009-02-19' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690620527, ExchCode = 'RTB' WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838502175, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 46907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295342, ExchCode = 'GTX' WHERE SecCode = 48327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033691, ExchCode = 'TDG' WHERE SecCode = 51520 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951338.0 WHERE SecCode = 53540 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667483439, ExchCode = 'QTX' WHERE SecCode = 53702 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 54680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835934, Ticker = 'STFd', ExchCode = 'BCO' WHERE SecCode = 57832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641483764, ExchCode = 'STU' WHERE SecCode = 57850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475609715, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 57884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737759339, ExchCode = 'FRA' WHERE SecCode = 57889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21484713079, ExchCode = 'STU' WHERE SecCode = 58060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475745773, ExchCode = 'STU' WHERE SecCode = 58064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327177, ExchCode = 'BER', PermQuoteRetireDate = '2020-08-10' WHERE SecCode = 58140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474860403, ExchCode = 'DEU' WHERE SecCode = 58245 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 58417 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836489836, ExchCode = 'FRA' WHERE SecCode = 60025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836518711, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475457930, Ticker = 'VTDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-05-23' WHERE SecCode = 60090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324566, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 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 = 21475846941, ExchCode = 'DEU' WHERE SecCode = 60596 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 = 55838349451, ExchCode = 'STU' WHERE SecCode = 61517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805237823, ExchCode = 'SIG' WHERE SecCode = 61705 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CLGUN' WHERE SecCode = 62728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474862261, ExchCode = 'DEU', PermQuoteRetireDate = '2019-02-14' WHERE SecCode = 65643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525212599, ExchCode = 'DEU', PermQuoteRetireDate = '2020-03-20' WHERE SecCode = 65700 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 66851 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '6051' WHERE SecCode = 75664 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 79135 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'VGLSD' WHERE SecCode = 80070 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'CLGUN' WHERE SecCode = 80910 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 83826 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 84557 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 85957 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 88379 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 90552 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '6051' WHERE SecCode = 92897 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-16' WHERE SecCode = 94094 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 94407 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 102904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853992380, Ticker = '6MIA', ExchCode = 'BER', PermQuoteRetireDate = '2015-05-11' WHERE SecCode = 111924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805777529, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 112064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616285133, ExchCode = 'FRA' WHERE SecCode = 112231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704207, ExchCode = 'MXQ' WHERE SecCode = 112233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 114152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805841644, Ticker = 'EL1', ExchCode = 'SWX', PermSecMapStartDate = '2024-08-22' WHERE SecCode = 126877 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 132780 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 133646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805841648, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-11-28', PermSecMapEndDate = NULL WHERE SecCode = 137415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801211989, ExchCode = 'HAN' WHERE SecCode = 137417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625195836, ExchCode = 'FRA' WHERE SecCode = 137437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805841645, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-16', PermSecMapEndDate = NULL WHERE SecCode = 137833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805841632, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-16', PermSecMapEndDate = NULL WHERE SecCode = 137834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21717056561, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 137944 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997854, ExchCode = 'DEU' WHERE SecCode = 138040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419294, ExchCode = 'HAM' WHERE SecCode = 138046 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801449002, ExchCode = 'DEU' WHERE SecCode = 138104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556645874, ExchCode = 'BER', PermQuoteRetireDate = '2025-08-18' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 139280 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 139759 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 139967 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 140344 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591385, ExchCode = 'DEU' WHERE SecCode = 140677 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 141558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813177351, ExchCode = 'DEU' WHERE SecCode = 141782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669469776, ExchCode = 'FRA' WHERE SecCode = 141797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756809664, ExchCode = 'DEU', PermQuoteRetireDate = '2025-03-18' WHERE SecCode = 141805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324953, ExchCode = 'BER', PermQuoteRetireDate = '2016-05-04' WHERE SecCode = 141829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330236, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 141914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793200776, ExchCode = 'FRA' WHERE SecCode = 141915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804826539, ExchCode = 'FRA' WHERE SecCode = 141918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379995, ExchCode = 'FRA' WHERE SecCode = 141927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550980989, ExchCode = 'HAM' WHERE SecCode = 142049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335295, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2021-07-01', PermSecMapEndDate = '2021-07-01' WHERE SecCode = 142159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482719, ExchCode = 'QTX' WHERE SecCode = 142384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460935, Ticker = 'H9I', ExchCode = 'HAN', PermQuoteRetireDate = '2022-05-06' WHERE SecCode = 142482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574086997, PermQuoteRetireDate = '2015-12-04' WHERE SecCode = 143248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634298080, Ticker = '0Y9Sl', ExchCode = 'BCO' WHERE SecCode = 143694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836519644, ExchCode = 'FRA' WHERE SecCode = 143864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718461396, Ticker = '0NOFl', ExchCode = 'BCO' WHERE SecCode = 144186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324017, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 144232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341012, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 144351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492260, ExchCode = 'QTX' WHERE SecCode = 144591 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836446498, PermQuoteStatus = 'AC', Ticker = 'H7K0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 145208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21487384984, ExchCode = 'STU' WHERE SecCode = 145375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475009558, ExchCode = 'DEU' WHERE SecCode = 145380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498231140, ExchCode = 'FRA' WHERE SecCode = 145407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492485720, ExchCode = 'GER' WHERE SecCode = 145435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734983534, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-17' WHERE SecCode = 145503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799369548, ExchCode = 'FRA' WHERE SecCode = 145505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337535, ExchCode = 'BER' WHERE SecCode = 145506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632622184, Ticker = '0QZOl', ExchCode = 'BCO' WHERE SecCode = 145533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533743848, ExchCode = 'STU' WHERE SecCode = 145554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341949, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 145558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340548, ExchCode = 'BER' WHERE SecCode = 145643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768112538, ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-27', PermSecMapEndDate = NULL WHERE SecCode = 147833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836555699, ExchCode = 'FRA' WHERE SecCode = 150272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837355169, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 150274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035891, ExchCode = 'TDG', PermQuoteRetireDate = '2013-08-20' WHERE SecCode = 151023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483629, ExchCode = 'QTX' WHERE SecCode = 165007 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489372, ExchCode = 'QTX', PermQuoteRetireDate = '2020-01-15' WHERE SecCode = 166319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333792, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 167012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21689298005, ExchCode = 'STU' WHERE SecCode = 168616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520146054, ExchCode = 'STU' WHERE SecCode = 168960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793348258, Ticker = '1INGAm', ExchCode = 'BTE' WHERE SecCode = 169546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853430062, ExchCode = 'GTX' WHERE SecCode = 169573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308492, ExchCode = 'GTX' WHERE SecCode = 169894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312017, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 171257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850436291, ExchCode = 'GER' WHERE SecCode = 173009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134573, ExchCode = 'TDG' WHERE SecCode = 173075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838240695, ExchCode = 'MUN' WHERE SecCode = 173076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548207656, ExchCode = 'DEU' WHERE SecCode = 177153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805777536, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2024-07-29', PermSecMapEndDate = NULL WHERE SecCode = 177186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859251486, ExchCode = 'GER' WHERE SecCode = 177375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782462821, ExchCode = 'TDG' WHERE SecCode = 177399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474855192, ExchCode = 'DEU' WHERE SecCode = 177427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537831580, ExchCode = 'STU' WHERE SecCode = 177431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328749, ExchCode = 'BER', PermQuoteRetireDate = '2021-10-06', PermSecMapEndDate = '2021-10-06' WHERE SecCode = 177461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333764, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 177502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140269967, ExchCode = 'DEU' WHERE SecCode = 177597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21891414654, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836414314, ExchCode = 'FRA' WHERE SecCode = 178031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519050, ExchCode = 'DUS' WHERE SecCode = 178059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660289166, ExchCode = 'MUN' WHERE SecCode = 178130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330777, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655926927, ExchCode = 'FRA' WHERE SecCode = 178149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819755640, ExchCode = 'DUS' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320129, ExchCode = 'DEU' WHERE SecCode = 178208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55844988218, ExchCode = 'FRA' WHERE SecCode = 178282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333820, ExchCode = 'BER' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957756017, ExchCode = 'STU' WHERE SecCode = 178295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141122, ExchCode = 'FRA' WHERE SecCode = 178338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431790, ExchCode = 'DEU' WHERE SecCode = 178363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811976557, ExchCode = 'BER', PermQuoteRetireDate = '2024-08-21' WHERE SecCode = 178410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830299272, ExchCode = 'GTX' WHERE SecCode = 178420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385676, ExchCode = 'LAS' WHERE SecCode = 178451 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486046, PermQuoteStatus = 'AC', Ticker = 'HJN1', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475787251, ExchCode = 'FRA' WHERE SecCode = 178737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694900848, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679753, ExchCode = 'GER' WHERE SecCode = 178849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035018, ExchCode = 'TDG' WHERE SecCode = 178970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803716825, ExchCode = 'QTX' WHERE SecCode = 179031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275503, ExchCode = 'GTX' WHERE SecCode = 180692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538563860, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 181907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474989125, ExchCode = 'DEU' WHERE SecCode = 181909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297992, ExchCode = 'DUS' WHERE SecCode = 181912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270184, ExchCode = 'DUS' WHERE SecCode = 183383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555647, ExchCode = 'DEU' WHERE SecCode = 183422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836488315, ExchCode = 'FRA' WHERE SecCode = 185835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 186400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798248748, ExchCode = 'DEU' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381654, ExchCode = 'LAS' WHERE SecCode = 186457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650270, ExchCode = 'DUS' WHERE SecCode = 186462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483698, ExchCode = 'QTX' WHERE SecCode = 186470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21555271725, ExchCode = 'DEU' WHERE SecCode = 186474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881522594, ExchCode = 'MUN' WHERE SecCode = 186478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838564276, ExchCode = 'STU' WHERE SecCode = 186488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569871, ExchCode = 'QTX' WHERE SecCode = 186492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858479220, ExchCode = 'FRA' WHERE SecCode = 187841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836393742, ExchCode = 'FRA' WHERE SecCode = 188522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519033, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 188523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55845348132, Ticker = 'PTMN.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 189538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331433, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 190124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531128580, PermQuoteStatus = 'DC', Ticker = 'HY7d', ExchCode = 'BCO', PermQuoteRetireDate = '2013-11-20' WHERE SecCode = 190214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954813, ExchCode = 'LAS' WHERE SecCode = 190498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662322265, ExchCode = 'MUN' WHERE SecCode = 190881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981535, Ticker = 'P8H', ExchCode = 'HAM', PermQuoteRetireDate = '2016-05-17' WHERE SecCode = 191863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797237713, ExchCode = 'STU', PermQuoteRetireDate = '2023-01-06', PermSecMapEndDate = '2023-01-06' WHERE SecCode = 192682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589641082, ExchCode = 'BER', PermQuoteRetireDate = '2021-10-21' WHERE SecCode = 192941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483655, ExchCode = 'QTX' WHERE SecCode = 194187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560967785, Ticker = 'BNF', ExchCode = 'STU' WHERE SecCode = 196120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473861, ExchCode = 'GER' WHERE SecCode = 196149 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805015324, ExchCode = 'MUN' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21765448129, ExchCode = 'BCO' WHERE SecCode = 196630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628061494, ExchCode = 'DEU' WHERE SecCode = 197081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850051800, ExchCode = 'GTX' WHERE SecCode = 197304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256366, ExchCode = 'QTX' WHERE SecCode = 197772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981642, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 201293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322199, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 201793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835820705, ExchCode = 'MEX' WHERE SecCode = 201846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704190, ExchCode = 'MXQ' WHERE SecCode = 201875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791481822, ExchCode = 'FRA' WHERE SecCode = 201937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386442, ExchCode = 'LAS' WHERE SecCode = 201941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871055593, ExchCode = 'GTX' WHERE SecCode = 201945 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646062328, ExchCode = 'MUN' WHERE SecCode = 201946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037302940, ExchCode = 'DEU' WHERE SecCode = 201962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835809070, ExchCode = 'MEX' WHERE SecCode = 201971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792268614, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2026-01-26' WHERE SecCode = 202264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733749487, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 202265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835455673, Ticker = 'SOYBP', ExchCode = 'PAR', PermQuoteRetireDate = '2013-05-08' WHERE SecCode = 202732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836596532, ExchCode = 'FRA' WHERE SecCode = 202733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519302085, ExchCode = 'DEU' WHERE SecCode = 202933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874419, ExchCode = 'GTX' WHERE SecCode = 202935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589493867, ExchCode = 'STU', PermQuoteRetireDate = '2017-08-03' WHERE SecCode = 202950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795295012, ExchCode = 'QTX' WHERE SecCode = 203057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950892, ExchCode = 'STU' WHERE SecCode = 203795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517579838, ExchCode = 'STU', PermQuoteRetireDate = '2014-10-07' WHERE SecCode = 204876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480921, ExchCode = 'QTX' WHERE SecCode = 205611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651373349, ExchCode = 'DEU' WHERE SecCode = 206769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956395290, ExchCode = 'DEU' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803385261, ExchCode = 'MUN' WHERE SecCode = 206847 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 = 21587111643, ExchCode = 'FRA' WHERE SecCode = 210734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286375, ExchCode = 'GTX' WHERE SecCode = 210739 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'AFFUD' WHERE SecCode = 221382 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21875579352, ExchCode = 'MUN', PermQuoteRetireDate = '2022-06-02' WHERE SecCode = 248740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791252433, ExchCode = 'GER', PermQuoteRetireDate = '2021-03-23' WHERE SecCode = 248746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836456226, ExchCode = 'FRA', PermQuoteRetireDate = '2009-05-07' WHERE SecCode = 248760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485908, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 248773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837356986, ExchCode = 'GER' WHERE SecCode = 248774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492252, ExchCode = 'QTX' WHERE SecCode = 248890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21495338828, ExchCode = 'STU' WHERE SecCode = 248901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575579850, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 248903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22158416975, ExchCode = 'DEU' WHERE SecCode = 248904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474917055, ExchCode = 'DEU' WHERE SecCode = 248925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836474868, ExchCode = 'FRA' WHERE SecCode = 248929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339429, ExchCode = 'BER' WHERE SecCode = 248942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905420487, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-08' WHERE SecCode = 248943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799025884, ExchCode = 'MUN' WHERE SecCode = 248951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731413759, ExchCode = 'MUN' WHERE SecCode = 248959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614269979, ExchCode = 'STU' WHERE SecCode = 248989 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 = 236800600238, ExchCode = 'FRA' WHERE SecCode = 249236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394740, ExchCode = 'FRA', PermQuoteRetireDate = '2011-08-11' WHERE SecCode = 249274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787268, ExchCode = 'DUS' WHERE SecCode = 249293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856726590, ExchCode = 'STU' WHERE SecCode = 249354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535831521, ExchCode = 'STU', PermQuoteRetireDate = '2020-04-15' WHERE SecCode = 249365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847021469, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836388640, ExchCode = 'FRA', PermQuoteRetireDate = '2008-08-08' WHERE SecCode = 249403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483182, ExchCode = 'QTX' WHERE SecCode = 249426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526396050, ExchCode = 'FRA' WHERE SecCode = 249427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956712495, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 249601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109803, ExchCode = 'DUS' WHERE SecCode = 249624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490419, ExchCode = 'QTX', PermQuoteRetireDate = '2020-10-07' WHERE SecCode = 249627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326625, Ticker = 'CKI2', ExchCode = 'BER', PermQuoteRetireDate = '2020-11-06' WHERE SecCode = 249643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710963783, ExchCode = 'TDG', PermQuoteRetireDate = '2021-05-25' WHERE SecCode = 249688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535408623, ExchCode = 'STU' WHERE SecCode = 249695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512748791, ExchCode = 'STU', PermQuoteRetireDate = '2019-05-07' WHERE SecCode = 249704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474904036, ExchCode = 'DEU' WHERE SecCode = 249713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474883485, ExchCode = 'DEU' WHERE SecCode = 249726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782434438, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485382, ExchCode = 'QTX' WHERE SecCode = 249828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836390087, ExchCode = 'FRA' WHERE SecCode = 249844 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 = 236784384470, ExchCode = 'LAS' WHERE SecCode = 259026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323933, ExchCode = 'BER' WHERE SecCode = 260155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138696948, ExchCode = 'HAM' WHERE SecCode = 278881 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-15', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 281981 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836493793, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 283718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787321, ExchCode = 'DUS' WHERE SecCode = 284280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337096, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 284282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295433, ExchCode = 'GTX' WHERE SecCode = 284283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517544285, ExchCode = 'BER', PermQuoteRetireDate = '2025-08-27' WHERE SecCode = 284305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324576, ExchCode = 'BER' WHERE SecCode = 286289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749838939, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 287571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836435377, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 291628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836467703, ExchCode = 'FRA' WHERE SecCode = 291854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327296, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836502666, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 296592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836461787, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 296595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419293, ExchCode = 'HAM' WHERE SecCode = 297377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680538270, ExchCode = 'TDG' WHERE SecCode = 297742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805841635, PermQuoteStatus = 'AC', Ticker = 'TTE', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2024-08-14' WHERE SecCode = 299179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21864927092, ExchCode = 'MXQ' WHERE SecCode = 299539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840060208, ExchCode = 'MEX' WHERE SecCode = 299540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419441, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 300181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531134931, Ticker = 'TCGd', ExchCode = 'BCO', PermQuoteRetireDate = '2020-03-27' WHERE SecCode = 300395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838433153, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-10' WHERE SecCode = 300831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540267896, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-03-27' WHERE SecCode = 301739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324730, ExchCode = 'BER' WHERE SecCode = 303347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585032919, ExchCode = 'BCO' WHERE SecCode = 309897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838234761, ExchCode = 'MUN', PermQuoteRetireDate = '2017-09-14' WHERE SecCode = 312934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328037, Ticker = 'K14', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-01' WHERE SecCode = 313560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550077092, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 315711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350338, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 316472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320668, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 318406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348023, ExchCode = 'FRA' WHERE SecCode = 319524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036311, ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-03' WHERE SecCode = 325342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585875044, ExchCode = 'STU' WHERE SecCode = 325643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320604, ExchCode = 'BER' WHERE SecCode = 326661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520192969, ExchCode = 'STU' WHERE SecCode = 327144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320982, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 333804 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840262354, ExchCode = 'MEX' WHERE SecCode = 333869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860860933, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 340167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479446, ExchCode = 'QTX', PermQuoteRetireDate = '2025-05-07' WHERE SecCode = 340533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510649, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 341926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479577, ExchCode = 'QTX' WHERE SecCode = 341959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381539, ExchCode = 'LAS' WHERE SecCode = 341961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321177, ExchCode = 'BER', PermQuoteRetireDate = '2017-08-08' WHERE SecCode = 341966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957529769, ExchCode = 'QTX' WHERE SecCode = 345100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825607959, ExchCode = 'MUN' WHERE SecCode = 345429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538768103, Ticker = 'CAZAl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-08-24' WHERE SecCode = 345783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116848257, ExchCode = 'DEU' WHERE SecCode = 345843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21895997542, ExchCode = 'DEU' WHERE SecCode = 345850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159147457, ExchCode = 'DEU' WHERE SecCode = 345851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419443, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2017-10-16' WHERE SecCode = 348130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438916, ExchCode = 'FRA' WHERE SecCode = 348479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475010636, ExchCode = 'DEU' WHERE SecCode = 350275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473201, ExchCode = 'GER' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033888, ExchCode = 'TDG', PermQuoteRetireDate = '2017-08-15' WHERE SecCode = 351504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830300937, ExchCode = 'GTX' WHERE SecCode = 352543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320508, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 355184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655827958, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-19', PermSecMapEndDate = NULL WHERE SecCode = 359919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836354188, ExchCode = 'FRA', PermQuoteRetireDate = '2011-03-01' WHERE SecCode = 362355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288726, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 363732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837351233, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 368808 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840949533, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 368820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350619, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 368836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704437, ExchCode = 'MXQ' WHERE SecCode = 372859 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 372861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834671011, PermQuoteStatus = 'AC', Ticker = '0O79', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 374278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838296613, Ticker = 'CAIR.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 374927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620916416, ExchCode = 'TDG' WHERE SecCode = 375326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547002144, Ticker = 'D69d', ExchCode = 'BCO' WHERE SecCode = 379671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840949580, ExchCode = 'FRA' WHERE SecCode = 389023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841103521, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-11' WHERE SecCode = 392352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685431734, ExchCode = 'DEU' WHERE SecCode = 401619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841617044, ExchCode = 'FRA' WHERE SecCode = 401621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841643565, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 401624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388965, Ticker = 'ZIM.RO', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 408476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475472362, ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 408478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704244, ExchCode = 'MXQ' WHERE SecCode = 409684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955877, ExchCode = 'TDG' WHERE SecCode = 412853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822777044, ExchCode = 'DUS' WHERE SecCode = 413132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523795704, ExchCode = 'STU' WHERE SecCode = 424779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843288026, ExchCode = 'BER' WHERE SecCode = 424919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843194281, ExchCode = 'FRA' WHERE SecCode = 425031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843333402, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-08' WHERE SecCode = 425411 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 = 21953597671, ExchCode = 'DUS' WHERE SecCode = 432012 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 PriInstrPermID = 8589939980.0 WHERE SecCode = 452443 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 = 21475022130, ExchCode = 'DEU' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616157068, ExchCode = 'MCX' WHERE SecCode = 500487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849448689, ExchCode = 'MEX' WHERE SecCode = 508999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492958, ExchCode = 'QTX' WHERE SecCode = 515043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850070208, ExchCode = 'FRA' WHERE SecCode = 518549 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 = 21830296198, ExchCode = 'GTX' WHERE SecCode = 524403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862774028, ExchCode = 'MXQ' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886808270, ExchCode = 'MUN' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523646821, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 533522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630225521, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 535506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475422413, Ticker = 'FISKS.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2009-09-03' WHERE SecCode = 536734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476991388, ExchCode = 'TDG' WHERE SecCode = 538783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581478612, ExchCode = 'HAM' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852220203, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 541456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522030496, ExchCode = 'TDG' WHERE SecCode = 541495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856846841, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 541974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852420890, ExchCode = 'STU', PermQuoteRetireDate = '2013-05-29' WHERE SecCode = 547537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301241, ExchCode = 'GTX' WHERE SecCode = 549236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785844948, ExchCode = 'TDG' WHERE SecCode = 549886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853660976, ExchCode = 'GER' WHERE SecCode = 552722 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 = 21575565347, ExchCode = 'STU', PermQuoteRetireDate = '2018-04-26' WHERE SecCode = 560723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294098, ExchCode = 'GTX' WHERE SecCode = 563087 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 = 21693152662, ExchCode = 'MUN' WHERE SecCode = 568338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540583981, ExchCode = 'STU', PermQuoteRetireDate = '2018-08-13' WHERE SecCode = 568829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853019549, ExchCode = 'MEX' WHERE SecCode = 580373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859177674, ExchCode = 'STU' WHERE SecCode = 592307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293928, InstrPermID = 8591391476, OrgPermID = 5000663094, ValQuotePermID = 55858425773.0, PriInstrPermID = 8591391476.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'ANK', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermOrgIPODate = '2010-04-01' WHERE SecCode = 601515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847342799, ExchCode = 'MUN' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290783, ExchCode = 'DUS' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492850, ExchCode = 'QTX' WHERE SecCode = 837909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428184, ExchCode = 'GTX' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 853945 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 = 236784596702, ExchCode = 'FRA' WHERE SecCode = 878880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554127327, Ticker = 'XSILz', ExchCode = 'CHI' WHERE SecCode = 880290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896158211, Ticker = NULL, ExchCode = 'DEU' WHERE SecCode = 881802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22103473248, ExchCode = 'DEU' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779809732, ExchCode = 'GTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223887, ExchCode = 'QTX' WHERE SecCode = 909718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492656, ExchCode = 'QTX' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55868604668, Ticker = 'CBBFDS', ExchCode = 'SWX', PermQuoteRetireDate = '2021-04-19' WHERE SecCode = 933460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785297550, ExchCode = 'QTX' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846603850, Ticker = 'FMT', ExchCode = 'MUN', PermQuoteRetireDate = '2011-01-31' WHERE SecCode = 985004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769668, Ticker = 'TYM', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 995830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800222853, ExchCode = 'FRA' WHERE SecCode = 1017380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521581557, ExchCode = 'FRA' WHERE SecCode = 1122776 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-15' WHERE SecCode = 1182141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797722, ExchCode = 'QTX' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 1451955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583580938, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-08-16', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1455200 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 = 21558280851, ExchCode = 'CHI', PermQuoteRetireDate = '2025-02-03' WHERE SecCode = 1472753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950893, ExchCode = 'STU' WHERE SecCode = 1485685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385946, ExchCode = 'LAS' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55886089498, Ticker = 'SLHO', ExchCode = 'MIL', PermQuoteRetireDate = '2019-09-17' WHERE SecCode = 1503000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653590213, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642014, ExchCode = 'QTX' WHERE SecCode = 1503058 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 = 21487020931, ExchCode = 'FRA' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488285610, ExchCode = 'DEU' WHERE SecCode = 1524542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857143091, ExchCode = 'DUS' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623750, ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-23', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793448735, ExchCode = 'TDG' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497908, ExchCode = 'FRA' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522741571, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-17' WHERE SecCode = 1527439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21489920274, ExchCode = 'FRA', PermQuoteRetireDate = '2012-08-22' WHERE SecCode = 1527466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659841732, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 1530627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490953291, ExchCode = 'DEU' WHERE SecCode = 1531694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492895638, ExchCode = 'DEU', PermQuoteRetireDate = '2014-04-08' WHERE SecCode = 1537137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067014491, ExchCode = 'DEU' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493901015, ExchCode = 'DEU' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766661889, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1538644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270024, ExchCode = 'DEU' WHERE SecCode = 1541369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508750705, ExchCode = 'STU' WHERE SecCode = 1554784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498305313, ExchCode = 'FRA' WHERE SecCode = 1555173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632884533, ExchCode = 'MUN', PermQuoteRetireDate = '2018-10-05' WHERE SecCode = 1571251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629962634, Ticker = '7O2', ExchCode = 'STU' WHERE SecCode = 1656414 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-04-15' WHERE SecCode = 1694061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528495375, ExchCode = 'BTE' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788111815, ExchCode = 'FRA' WHERE SecCode = 2042837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802863785, ExchCode = 'FRA' WHERE SecCode = 2048649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337983, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2126923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658947457, ExchCode = 'FRA' WHERE SecCode = 2142278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531116946, ExchCode = 'BCO', PermQuoteRetireDate = '2024-07-03' WHERE SecCode = 2195912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576247697, ExchCode = 'FRA' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528855671, ExchCode = 'STU' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687380736, Ticker = 'CECDl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-07-06' WHERE SecCode = 2350989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781213703, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255542, ExchCode = 'DEU' WHERE SecCode = 2357967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529795323, ExchCode = 'STU' WHERE SecCode = 2357969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530042418, ExchCode = 'DEU' WHERE SecCode = 2357974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22004161785, Ticker = 'XDN0', ExchCode = 'SWX' WHERE SecCode = 2363639 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530493513, ExchCode = 'FRA' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530579384, ExchCode = 'DEU' WHERE SecCode = 2373485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21532177823, ExchCode = 'FRA', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2409463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786676625, ExchCode = 'BIV' WHERE SecCode = 2414027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862726959, ExchCode = 'GTX' WHERE SecCode = 2425600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533684531, ExchCode = 'DEU' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535117810, ExchCode = 'BEC' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704199, ExchCode = 'MXQ' WHERE SecCode = 2455541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487244, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2458813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842579738, ExchCode = 'BER' WHERE SecCode = 2458822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134819, ExchCode = 'FRA' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379477, ExchCode = 'LAS' WHERE SecCode = 2524755 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 = 21539181649, ExchCode = 'FRA' WHERE SecCode = 2532821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673930, ExchCode = 'BIV' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2550252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835976, Ticker = '53S1d', ExchCode = 'BCO', PermQuoteRetireDate = '2021-09-27' WHERE SecCode = 2550286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103484, ExchCode = 'FRA' WHERE SecCode = 2554904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-04-15' WHERE SecCode = 2586428 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 = 21712051521, Ticker = '3HCS', ExchCode = 'MIL' WHERE SecCode = 2600076 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 = 21664823736, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2604394 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 = 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 = 21589446342, ExchCode = 'TDG' WHERE SecCode = 2649155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549116547, ExchCode = 'BER' WHERE SecCode = 2655948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549690613, ExchCode = 'TDG' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 2679897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451549, PermQuoteStatus = 'DC', Ticker = 'GLE', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28', PermSecMapEndDate = '2025-11-28' WHERE SecCode = 2682169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451552, PermQuoteStatus = 'DC', Ticker = 'RNO', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28' WHERE SecCode = 2682171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451565, PermQuoteStatus = 'DC', Ticker = 'IMB', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28' WHERE SecCode = 2682181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550451574, PermQuoteStatus = 'DC', Ticker = 'AZN', ExchCode = 'SWX', PermQuoteRetireDate = '2025-11-28', PermSecMapEndDate = '2025-11-28' WHERE SecCode = 2682187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805841636, ExchCode = 'SWX', PermSecMapStartDate = '2026-04-16' WHERE SecCode = 2682206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805841633, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-11-28', PermSecMapEndDate = NULL WHERE SecCode = 2682277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550459903, ExchCode = 'DEU' 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 = 236803385262, ExchCode = 'TDG' WHERE SecCode = 2725364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387967, ExchCode = 'LAS' WHERE SecCode = 2732754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675690, ExchCode = 'BIV' WHERE SecCode = 2747774 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 = 21667706109, Ticker = 'WFTN', ExchCode = 'MXQ' WHERE SecCode = 2767178 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 = 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 = 21557245542, ExchCode = 'STU' WHERE SecCode = 2809752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564228866, Ticker = 'IDV1d', ExchCode = 'BCO' WHERE SecCode = 2812145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557322226, ExchCode = 'DEU' WHERE SecCode = 2812146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791214983, ExchCode = 'BIV' WHERE SecCode = 2812150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308386, ExchCode = 'GTX' WHERE SecCode = 2824461 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 = 21559577677, ExchCode = 'DEU' WHERE SecCode = 2848442 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 = 21939948844, ExchCode = 'HAN' 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 = 21599521455, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2861791 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 = 21561682172, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 2868670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704681, ExchCode = 'MXQ' WHERE SecCode = 2876241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704154, ExchCode = 'MXQ' WHERE SecCode = 2876284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596035551, ExchCode = 'STU' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428180, ExchCode = 'GTX' WHERE SecCode = 2887226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386769, ExchCode = 'LAS' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647736991, ExchCode = 'FRA' WHERE SecCode = 2893040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701551, Ticker = 'EXX1', ExchCode = 'BRN' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480526, ExchCode = 'QTX' WHERE SecCode = 2902829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479042, ExchCode = 'QTX' WHERE SecCode = 2905610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073079957, ExchCode = 'TDG' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483136, PermQuoteStatus = 'DC', Ticker = 'CM3', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 2907243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296735, ExchCode = 'GTX' WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654537658, ExchCode = 'MUN', PermQuoteRetireDate = '2025-11-21' WHERE SecCode = 2907245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557759598, ExchCode = 'BEC' WHERE SecCode = 2907274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564939130, ExchCode = 'FRA' WHERE SecCode = 2909928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386051, ExchCode = 'LAS' WHERE SecCode = 2911859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704257, ExchCode = 'MXQ' WHERE SecCode = 2919671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585146, ExchCode = 'BIV' WHERE SecCode = 2919673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660104312, ExchCode = 'EBT', PermQuoteRetireDate = '2020-12-18' WHERE SecCode = 2919716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520291, ExchCode = 'QTX' WHERE SecCode = 2919723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779823342, ExchCode = 'GTX' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369228, ExchCode = 'BEC' WHERE SecCode = 2925435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21632625998, ExchCode = 'TDG', PermQuoteRetireDate = '2018-11-12' WHERE SecCode = 2928770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954293373, ExchCode = 'DUS' WHERE SecCode = 2930976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540992047, ExchCode = 'TDG', PermQuoteRetireDate = '2019-05-24', PermSecMapEndDate = '2019-05-24' WHERE SecCode = 2932394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913292298, PermQuoteStatus = 'AC', Ticker = 'VZLE', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2935960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100485, ExchCode = 'QTX' WHERE SecCode = 2937567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479103, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 2937569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487723, ExchCode = 'QTX' WHERE SecCode = 2947855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836510352, ExchCode = 'FRA', PermQuoteRetireDate = '2016-03-16' WHERE SecCode = 2947875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381763, ExchCode = 'LAS' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21568943063, ExchCode = 'FRA' WHERE SecCode = 2950211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569333990, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2952372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598532993, ExchCode = 'FRA' WHERE SecCode = 2963564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659445, ExchCode = 'GTX' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675024, ExchCode = 'BIV' WHERE SecCode = 2963604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787252, ExchCode = 'DUS' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787393, ExchCode = 'DUS' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792943751, ExchCode = 'GER', PermQuoteRetireDate = '2022-08-11' WHERE SecCode = 3010358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479551, ExchCode = 'QTX', PermQuoteRetireDate = '2022-11-16' WHERE SecCode = 3011183 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 = 21659181386, ExchCode = 'MUN' WHERE SecCode = 3032214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576247699, ExchCode = 'FRA' WHERE SecCode = 3032363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386809, ExchCode = 'LAS' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839048899, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3051795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21578812986, ExchCode = 'DEU' WHERE SecCode = 3056842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586927375, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-22', PermSecMapEndDate = '2020-07-09' WHERE SecCode = 3076717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460747, Ticker = 'OD7F', ExchCode = 'FRA' WHERE SecCode = 3076722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285720, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100417, ExchCode = 'QTX' WHERE SecCode = 3080538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022607, ExchCode = 'DEU' WHERE SecCode = 3083484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022534, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3083485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569839, ExchCode = 'QTX', PermQuoteRetireDate = '2024-07-08' WHERE SecCode = 3102662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586629555, Ticker = 'W47', ExchCode = 'TDG', PermQuoteRetireDate = '2025-05-02' WHERE SecCode = 3104810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308552, ExchCode = 'GTX' WHERE SecCode = 3109823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614465238, ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-02', PermSecMapEndDate = '2022-10-21' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544712, ExchCode = 'QTX' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636371658, ExchCode = 'STU' WHERE SecCode = 3153872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587931877, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173789583, PermQuoteStatus = 'AC', Ticker = 'USMV', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-16', PermSecMapEndDate = NULL WHERE SecCode = 3160030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929444790, ExchCode = 'QTX' 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 = 21662322270, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3183538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862038094, ExchCode = 'DUS' WHERE SecCode = 3196992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804997785, ExchCode = 'FRA' WHERE SecCode = 3196993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821257511, ExchCode = 'DUS' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629963304, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-22' WHERE SecCode = 3199703 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 3200605 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704383, ExchCode = 'MXQ' WHERE SecCode = 3200668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769880745, ExchCode = 'FRA' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016577, ExchCode = 'MUN' WHERE SecCode = 3215534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748306921, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 3215564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150007, Ticker = 'AD', ExchCode = 'SWX' WHERE SecCode = 3217753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629958134, ExchCode = 'TDG' WHERE SecCode = 3222698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629963315, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-11' WHERE SecCode = 3228677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863999663, ExchCode = 'FRA' WHERE SecCode = 3229528 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 = 21839306386, ExchCode = 'TDG', PermQuoteRetireDate = '2024-07-12' WHERE SecCode = 3242031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595640970, PermQuoteStatus = 'AC', Ticker = 'M850', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3244393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659429, ExchCode = 'GTX' WHERE SecCode = 3244403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597802960, ExchCode = 'STU' WHERE SecCode = 3244877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641748, ExchCode = 'DUS' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100768, ExchCode = 'DUS' WHERE SecCode = 3247170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787711120, Ticker = '1CBKm', ExchCode = 'BCO' WHERE SecCode = 3247531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597417408, ExchCode = 'DEU' WHERE SecCode = 3254976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597399146, ExchCode = 'FRA' WHERE SecCode = 3255012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597335837, ExchCode = 'DEU' WHERE SecCode = 3255028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599524546, ExchCode = 'STU' WHERE SecCode = 3255527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598110715, ExchCode = 'TDG' WHERE SecCode = 3258821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800109, ExchCode = 'BTE' WHERE SecCode = 3263198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604819939, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 3271586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679379, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3273583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673151, ExchCode = 'BIV' WHERE SecCode = 3273584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21600517628, ExchCode = 'DEU' WHERE SecCode = 3273585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678970, ExchCode = 'BIV' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601268298, ExchCode = 'DEU' WHERE SecCode = 3277475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856729928, Ticker = 'SLYG', ExchCode = 'DEU' WHERE SecCode = 3280089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793397049, ExchCode = 'FRA' WHERE SecCode = 3283696 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 = 21634479982, ExchCode = 'MUN' WHERE SecCode = 3285184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602047603, ExchCode = 'MUN' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638239090, ExchCode = 'BCO' WHERE SecCode = 3301720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835371, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 3301728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690196182, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3301805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675845, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3302683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607100433, ExchCode = 'MUN' WHERE SecCode = 3305420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100440, ExchCode = 'QTX' WHERE SecCode = 3308568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679737, ExchCode = 'BIV' WHERE SecCode = 3309397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22057914115, ExchCode = 'DEU' WHERE SecCode = 3315780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608278646, ExchCode = 'MUN' WHERE SecCode = 3315799 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 = 21781234907, ExchCode = 'BER' WHERE SecCode = 3317120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596834668, ExchCode = 'FRA' WHERE SecCode = 3317168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611220164, ExchCode = 'TDG' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609211563, Ticker = '3FA0', ExchCode = 'FRA' WHERE SecCode = 3317714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609619284, ExchCode = 'DEU', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = '2025-06-17' WHERE SecCode = 3318127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609745552, ExchCode = 'DEU' WHERE SecCode = 3318532 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3318543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379980, ExchCode = 'FRA' WHERE SecCode = 3319862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912102337, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-09' WHERE SecCode = 3319868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334888, ExchCode = 'DEU' WHERE SecCode = 3320079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286060, ExchCode = 'GTX' WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669843042, ExchCode = 'TDG', PermQuoteRetireDate = '2023-05-29', PermSecMapEndDate = '2025-05-19' WHERE SecCode = 3320334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610964345, ExchCode = 'STU' WHERE SecCode = 3322810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679671, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3327117 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 = 236784380129, ExchCode = 'LAS' WHERE SecCode = 3338534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613684839, ExchCode = 'BER' WHERE SecCode = 3339799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616627272, ExchCode = 'DEU' WHERE SecCode = 3347597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887550956, ExchCode = 'MUN', PermQuoteRetireDate = '2026-01-27', PermSecMapEndDate = NULL WHERE SecCode = 3347599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21621961481, Ticker = '4PSM', ExchCode = 'ETX' WHERE SecCode = 3347660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704218, Ticker = 'ALMN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3347669 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 3350569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598843085, ExchCode = 'MEX' WHERE SecCode = 3357131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598843088, ExchCode = 'MEX' WHERE SecCode = 3357133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627369817, ExchCode = 'BCO' WHERE SecCode = 3358414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705783, ExchCode = 'MXQ' WHERE SecCode = 3358492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481705424, ExchCode = 'DEU' WHERE SecCode = 3358616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617014521, Ticker = '4EVK', ExchCode = 'ETX' WHERE SecCode = 3358919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679386, ExchCode = 'BIV' WHERE SecCode = 3364922 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 = 21648301745, ExchCode = 'STU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631611214, ExchCode = 'TDG' WHERE SecCode = 3377762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100519, ExchCode = 'QTX' WHERE SecCode = 3378195 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641457506, ExchCode = 'MUN' WHERE SecCode = 3378583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733749573, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3382234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706424, ExchCode = 'MXQ' WHERE SecCode = 3384174 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620409821, ExchCode = 'BCO' WHERE SecCode = 3385974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766019467, ExchCode = 'DEU' WHERE SecCode = 3386374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650199, ExchCode = 'DUS' WHERE SecCode = 3392279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644928542, ExchCode = 'BER', PermQuoteRetireDate = '2022-06-21', PermSecMapEndDate = '2022-08-03' WHERE SecCode = 3393655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727378719, ExchCode = 'BRN' WHERE SecCode = 3394008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029271, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-07-04' WHERE SecCode = 3394028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272825, ExchCode = 'GTX' WHERE SecCode = 3395245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22169958746, ExchCode = 'DEU' WHERE SecCode = 3395352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623803395, ExchCode = 'FRA' WHERE SecCode = 3396014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810204931, ExchCode = 'DEU' WHERE SecCode = 3401365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428164, ExchCode = 'GTX' WHERE SecCode = 3401402 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951250.0 WHERE SecCode = 3402529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674061, ExchCode = 'BIV' WHERE SecCode = 3403875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796141123, ExchCode = 'FRA' WHERE SecCode = 3405304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709687546, PermQuoteStatus = 'AC', Ticker = 'S060', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3406028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334821, ExchCode = 'DEU' WHERE SecCode = 3406462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679776, Ticker = NULL, ExchCode = 'BIV', PermQuoteRetireDate = '2020-02-15' WHERE SecCode = 3406524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256368, ExchCode = 'QTX' 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 PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapStartDate = '2017-12-13', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 3408727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679932, ExchCode = 'BIV' WHERE SecCode = 3408939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630022342, ExchCode = 'STU' WHERE SecCode = 3408940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644146276, ExchCode = 'FRA' WHERE SecCode = 3409040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384246, ExchCode = 'LAS' WHERE SecCode = 3409373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631199559, ExchCode = 'STU' WHERE SecCode = 3410277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905907543, ExchCode = 'GTX' WHERE SecCode = 3424652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781060476, ExchCode = 'FRA', PermQuoteRetireDate = '2024-03-25' WHERE SecCode = 3429810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678582, ExchCode = 'BIV' WHERE SecCode = 3430824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761780224, ExchCode = 'FRA' WHERE SecCode = 3430952 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 3431944 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634766459, ExchCode = 'DEU' WHERE SecCode = 3432164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651603021, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-26' WHERE SecCode = 3434582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 3436849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21834281133, ExchCode = 'TDG' WHERE SecCode = 3438714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643703119, ExchCode = 'DEU' WHERE SecCode = 3444720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644367377, ExchCode = 'DEU' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644530905, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3445747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644530943, ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-29', PermSecMapEndDate = '2022-03-29' WHERE SecCode = 3445749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679474, ExchCode = 'BIV' WHERE SecCode = 3446301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830298408, ExchCode = 'GTX' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645305949, ExchCode = 'FRA' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645435116, ExchCode = 'BER', PermQuoteRetireDate = '2020-01-02' WHERE SecCode = 3446651 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 = 21647732095, ExchCode = 'STU' WHERE SecCode = 3493723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794206137, ExchCode = 'TDG' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830309287, ExchCode = 'GTX', PermQuoteRetireDate = '2025-11-11' WHERE SecCode = 3501431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21650788270, Ticker = NULL, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308229, ExchCode = 'GTX' WHERE SecCode = 3513998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056989, ExchCode = 'TDG' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679290, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3518311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830305699, ExchCode = 'GTX' WHERE SecCode = 3532734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685853416, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953341540, ExchCode = 'MUN' WHERE SecCode = 3549499 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 = 21656838842, ExchCode = 'STU' WHERE SecCode = 3558191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658217012, ExchCode = 'DEU' WHERE SecCode = 3572805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358321, Ticker = 'CS9', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 3586971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584408989, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-06' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572528819, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598347922, ExchCode = 'CHA' WHERE SecCode = 3588027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667846371, ExchCode = 'FRA' WHERE SecCode = 3589051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952428, ExchCode = 'FRA' WHERE SecCode = 3591601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661966608, ExchCode = 'EQD' WHERE SecCode = 3596589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664984725, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3615233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664987336, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3615235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893299383, ExchCode = 'GTX' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669468854, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685428815, ExchCode = 'TDG' WHERE SecCode = 3654098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672709111, ExchCode = 'FRA' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715145241, Ticker = 'ROAIz', ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672826743, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3673707 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 = 21673827389, ExchCode = 'MEX' WHERE SecCode = 3717229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679876423, ExchCode = 'DEU' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801047807, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22160094634, ExchCode = 'DEU' WHERE SecCode = 3756337 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 = 21685868276, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3783080 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 = 21690815100, ExchCode = 'DEU' WHERE SecCode = 3817679 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 3818112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774623734, ExchCode = 'TDG' 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 = 21801932282, ExchCode = 'DEU' WHERE SecCode = 3827962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734634078, ExchCode = 'STU' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841766443, ExchCode = 'QTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901088238, ExchCode = 'HAN' WHERE SecCode = 3849234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858543, ExchCode = 'QTX' WHERE SecCode = 3852867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701895290, ExchCode = 'DEU' WHERE SecCode = 3875755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703664105, ExchCode = 'STU' WHERE SecCode = 3898812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703664160, ExchCode = 'TDG' WHERE SecCode = 3898813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 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 PriInstrPermID = 8590923227.0 WHERE SecCode = 4001136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' 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 = 236780026866, Ticker = '1BIIB' WHERE SecCode = 4031705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011239, Ticker = '2T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011956, Ticker = '2GLW' WHERE SecCode = 4031714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012741, Ticker = '2MS' WHERE SecCode = 4031717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010591, Ticker = '2CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012517, Ticker = '2MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026878, Ticker = '1PYPL', ExchCode = 'MIL' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013288, Ticker = '2PM' WHERE SecCode = 4032067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999013994, Ticker = '2CRM' WHERE SecCode = 4032071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143797, Ticker = '2AKZA', ExchCode = 'MIL' WHERE SecCode = 4032088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726460845, ExchCode = 'FRA' WHERE SecCode = 4068293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732569357, ExchCode = 'DEU' WHERE SecCode = 4081943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907558991, ExchCode = 'MUN' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737508303, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4109380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586975, ExchCode = 'FRA' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963671, ExchCode = 'STU' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704289, ExchCode = 'MXQ' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739433458, ExchCode = 'DEU' WHERE SecCode = 4178604 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 4178880 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745348418, ExchCode = 'TDG' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803758400, ExchCode = 'STU' WHERE SecCode = 4201669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308365, PermQuoteStatus = 'AC', Ticker = '4R8', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611415, ExchCode = 'FRA', PermQuoteRetireDate = '2022-09-29', PermSecMapEndDate = '2022-09-29' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727354882, ExchCode = 'MEX' WHERE SecCode = 4211745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351838, ExchCode = 'MEX' WHERE SecCode = 4212554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026966, Ticker = '1SYK' WHERE SecCode = 4214397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699193157, Ticker = 'BYND', ExchCode = 'SWX' WHERE SecCode = 4214409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026883, Ticker = '1PLUG' WHERE SecCode = 4214415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750369190, ExchCode = 'QTX' WHERE SecCode = 4216412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830284401, ExchCode = 'GTX' WHERE SecCode = 4225963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349453, ExchCode = 'BIV' WHERE SecCode = 4228288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749843263, ExchCode = 'DEU' WHERE SecCode = 4228324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781486447, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4240637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752247732, ExchCode = 'DEU' WHERE SecCode = 4240638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348594, ExchCode = 'MEX' WHERE SecCode = 4242203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388456, ExchCode = 'LAS' WHERE SecCode = 4248820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21754200427, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4253036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760588255, ExchCode = 'STU', PermQuoteRetireDate = '2023-11-16', PermSecMapEndDate = NULL WHERE SecCode = 4259226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349640, ExchCode = 'MEX' WHERE SecCode = 4259231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727346424, ExchCode = 'MEX' WHERE SecCode = 4273980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756547830, ExchCode = 'DEU' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487958, ExchCode = 'DUS' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780843378, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4282400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759098760, ExchCode = 'DEU' WHERE SecCode = 4291265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173789579, PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-16', PermSecMapEndDate = NULL WHERE SecCode = 4295716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759692063, ExchCode = 'DEU' WHERE SecCode = 4295731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768111804, PermQuoteStatus = 'DC', Ticker = '9EG', ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-27' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699358937, ExchCode = 'STU' WHERE SecCode = 4298602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803110079, ExchCode = 'FRA' WHERE SecCode = 4298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696686138, ExchCode = 'DEU' WHERE SecCode = 4298604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735310251, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 4298606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705427, ExchCode = 'MXQ' WHERE SecCode = 4298620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759649335, ExchCode = 'QTX' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760973387, ExchCode = 'QTX' WHERE SecCode = 4303570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760875901, ExchCode = 'DUS' WHERE SecCode = 4303583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760875979, ExchCode = 'BER' WHERE SecCode = 4303589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760881359, ExchCode = 'DEU' WHERE SecCode = 4303635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727343768, ExchCode = 'BIV' WHERE SecCode = 4303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011157, Ticker = '2SPOT' WHERE SecCode = 4309035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026860, Ticker = '18TRA' WHERE SecCode = 4309041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580118, ExchCode = 'FRA' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580175, ExchCode = 'DEU' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381904, ExchCode = 'LAS' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763596291, ExchCode = 'DUS' WHERE SecCode = 4321393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709367298, ExchCode = 'MXQ' WHERE SecCode = 4324371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727341343, ExchCode = 'MEX' WHERE SecCode = 4324380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801716826, ExchCode = 'TDG' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763901196, ExchCode = 'QTX' WHERE SecCode = 4324504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763596387, ExchCode = 'MUN' WHERE SecCode = 4324622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763966475, ExchCode = 'FRA' WHERE SecCode = 4327051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112355, ExchCode = 'FRA' WHERE SecCode = 4328959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871880783, ExchCode = 'MUN' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768618356, Ticker = '0A3M', ExchCode = 'LSE' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727315776, ExchCode = 'BIV' WHERE SecCode = 4362644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782535999, ExchCode = 'QTX' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777644859, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776870580, ExchCode = 'DEU' WHERE SecCode = 4380751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794594488, ExchCode = 'FRA' WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738813552, ExchCode = 'STU' WHERE SecCode = 4383309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238824, ExchCode = 'LAS' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845531963, ExchCode = 'GTX' WHERE SecCode = 4388200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991740, ExchCode = 'FRA' WHERE SecCode = 4400153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778281540, ExchCode = 'STU' WHERE SecCode = 4402301 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236805784996.0 WHERE SecCode = 4404020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307742, ExchCode = 'BIV' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778680491 WHERE SecCode = 4406073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234893, ExchCode = 'BER' WHERE SecCode = 4413712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781439298, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2024-12-13', PermSecMapEndDate = '2024-12-13' WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786673386, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4422563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777025689, ExchCode = 'STU' WHERE SecCode = 4422567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999209, ExchCode = 'DEU' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370427, ExchCode = 'AQX' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307225, ExchCode = 'MEX' WHERE SecCode = 4426954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782653687, ExchCode = 'MUN' WHERE SecCode = 4426955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727303272, ExchCode = 'MEX' WHERE SecCode = 4426957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928415121, ExchCode = 'SIU' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394138, ExchCode = 'STU' WHERE SecCode = 4429683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785625919, ExchCode = 'FRA' WHERE SecCode = 4434305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787027751, PermQuoteStatus = 'DC', Ticker = '60P', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 4444005 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 4449576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791908410, ExchCode = 'TDG' WHERE SecCode = 4451262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301154, ExchCode = 'MEX' WHERE SecCode = 4452337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797412670, ExchCode = 'STU' WHERE SecCode = 4463145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689536, ExchCode = 'DEU' WHERE SecCode = 4463152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793533769, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-24' WHERE SecCode = 4470175 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528202, ExchCode = 'DUS' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781362966, ExchCode = 'DUS', PermQuoteRetireDate = '2024-02-20' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794817527, ExchCode = 'DEU' WHERE SecCode = 4481104 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 4481105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367255, ExchCode = 'DEU' WHERE SecCode = 4482517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306777, ExchCode = 'BIV' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795591035, Ticker = '0A6N', ExchCode = 'LSE' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797994407, ExchCode = 'STU' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727286505, ExchCode = 'BIV' 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 = 21802851613, ExchCode = 'STU', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 4511508 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 = 21802430411, ExchCode = 'DEU' WHERE SecCode = 4526143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829968, ExchCode = 'QTX' WHERE SecCode = 4526144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628079, ExchCode = 'DUS' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808935929, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804817015, ExchCode = 'STU' WHERE SecCode = 4536450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821271834, ExchCode = 'STU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804816877, ExchCode = 'STU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 4540648 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 4541011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301440, ExchCode = 'MEX' WHERE SecCode = 4547978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271947, ExchCode = 'MEX' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806896207, ExchCode = 'FRA' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812165966, ExchCode = 'STU' WHERE SecCode = 4553829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806748726, ExchCode = 'FRA' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807446197, ExchCode = 'FRA', PermQuoteRetireDate = '2025-08-04', PermSecMapEndDate = '2025-08-04' WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830303213, ExchCode = 'GTX' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 4577875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22135794225, Ticker = 'XLME', ExchCode = 'HAM' WHERE SecCode = 4579626 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 4585449 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 4585450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812636752, ExchCode = 'DEU', PermQuoteRetireDate = '2021-05-17' WHERE SecCode = 4589403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097262, ExchCode = 'LAS' WHERE SecCode = 4601728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293687, ExchCode = 'GTX' WHERE SecCode = 4601736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295798, ExchCode = 'GTX' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887549166, ExchCode = 'GTX' WHERE SecCode = 4603534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136782, ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-28' WHERE SecCode = 4607686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144470, ExchCode = 'FRA' WHERE SecCode = 4607717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818264918, ExchCode = 'FRA' WHERE SecCode = 4617743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527324, ExchCode = 'DEU' WHERE SecCode = 4618010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968004, ExchCode = 'FRA' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534591, ExchCode = 'QTX' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21899163259, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100454, ExchCode = 'QTX' WHERE SecCode = 4635203 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 PriInstrPermID = 8590923227.0 WHERE SecCode = 4638889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914249, ExchCode = 'MUN' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832244431, ExchCode = 'DUS' WHERE SecCode = 4658888 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4693643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21838659452, ExchCode = 'TDG' WHERE SecCode = 4693646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233438, ExchCode = 'BIV' WHERE SecCode = 4714894 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 = 21852758887, ExchCode = 'STU' WHERE SecCode = 4752188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853931452, PermQuoteStatus = 'DC', Ticker = 'GSP', ExchCode = 'LSE', PermQuoteRetireDate = '2024-07-01', PermSecMapEndDate = '2024-07-01' WHERE SecCode = 4761540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867733, ExchCode = 'FRA' WHERE SecCode = 4762975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834781, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21905907535, ExchCode = 'GTX' WHERE SecCode = 4771746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855820605, ExchCode = 'DEU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856727927, ExchCode = 'FRA' WHERE SecCode = 4777352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857866487, ExchCode = 'MUN' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858096579, ExchCode = 'DEU' 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 = 21862729112, ExchCode = 'BER' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863832485, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4819644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778241629, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4819881 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 = 21872098103, ExchCode = 'DEU' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 4882385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954831, ExchCode = 'LAS' WHERE SecCode = 4887246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380552, ExchCode = 'LAS' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884962075, ExchCode = 'STU' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883516418, ExchCode = 'FRA' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' 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 = 21975240638, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 4969407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889561153, PermQuoteStatus = 'DC', ExchCode = 'BER', 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 = 21892047320, ExchCode = 'MUN' WHERE SecCode = 4991559 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21980178367, ExchCode = 'DUS' WHERE SecCode = 5011657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894536981, ExchCode = 'DUS' WHERE SecCode = 5011663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894954725, ExchCode = 'DEU' WHERE SecCode = 5013561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727380611, Ticker = 'DC4', ExchCode = 'BRN' WHERE SecCode = 5047087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904431761, ExchCode = 'DEU' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908064114, ExchCode = 'FRA' WHERE SecCode = 5102905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012676, Ticker = '2KDP' WHERE SecCode = 5107765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535351, ExchCode = 'DEU' WHERE SecCode = 5134589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520648, ExchCode = 'DEU' WHERE SecCode = 5151167 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 = 21794279503, Ticker = '0A60', ExchCode = 'LSE' WHERE SecCode = 5161244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792173203, ExchCode = 'FRA' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727308116, Ticker = 'WPMl', ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667329289, ExchCode = 'FRA' WHERE SecCode = 5161350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853640013, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5161351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689627, ExchCode = 'DEU' WHERE SecCode = 5161403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305815, ExchCode = 'BIV' WHERE SecCode = 5161409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348366, ExchCode = 'MEX' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850513498, ExchCode = 'FRA' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836515912, Ticker = 'SQT', ExchCode = 'FRA', PermQuoteRetireDate = '2016-10-11' WHERE SecCode = 5161435 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954642019, ExchCode = 'QTX' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173433, ExchCode = 'BIV' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923930959, ExchCode = 'STU' WHERE SecCode = 5178622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627658, ExchCode = 'QTX' WHERE SecCode = 5178623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535364, ExchCode = 'MUN' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904165, ExchCode = 'BCO' WHERE SecCode = 5203369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552224, ExchCode = 'LAS' WHERE SecCode = 5230230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727227059, ExchCode = 'MEX' WHERE SecCode = 5238268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173435, ExchCode = 'MEX' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779328331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936132645, ExchCode = 'FRA' WHERE SecCode = 5258611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938327486, ExchCode = 'DEU' WHERE SecCode = 5277551 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775107112, ExchCode = 'BIV' WHERE SecCode = 5283390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5287493 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5322366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' 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 = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380716, ExchCode = 'LAS' 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 = 236776535810, ExchCode = 'MEX' WHERE SecCode = 5387237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961201424, ExchCode = 'FRA' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758792, ExchCode = 'GTX' WHERE SecCode = 5393777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727202568, ExchCode = 'MEX' WHERE SecCode = 5411550 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 5413651 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 5446053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21931510083, Ticker = '0ABM', ExchCode = 'LSE' WHERE SecCode = 5448761 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 5455472 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 = 236779165176, ExchCode = 'STU' WHERE SecCode = 5476926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729656, ExchCode = 'DEU' WHERE SecCode = 5478214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223819, ExchCode = 'QTX' WHERE SecCode = 5479512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778437244, ExchCode = 'BIV' WHERE SecCode = 5482856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585123, ExchCode = 'MEX' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893349, ExchCode = 'TDG' WHERE SecCode = 5493665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010091546, Ticker = 'BTCCHz', ExchCode = 'TQE' WHERE SecCode = 5509588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787446918, ExchCode = 'STU' WHERE SecCode = 5523278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151304, Ticker = '3FTE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5535000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779515511, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5541732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779608955, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5553227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882186850, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 5569241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110941, PermQuoteStatus = 'AC', Ticker = '3FNGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580283, ExchCode = 'DUS' WHERE SecCode = 5569302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873360059, Ticker = '3MRN', ExchCode = 'MIL' WHERE SecCode = 5569367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659489, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-22' WHERE SecCode = 5569960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'PNG' WHERE SecCode = 5579584 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 5623205 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 5624784 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 5626480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173432, ExchCode = 'BIV' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781012608, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780880115, ExchCode = 'HAM', PermQuoteRetireDate = '2024-01-19' WHERE SecCode = 5633493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21638000416, ExchCode = 'MUN' WHERE SecCode = 5638703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031904157, Ticker = 'LCO3l', ExchCode = 'BCO' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823715, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-15' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823853, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882433442, ExchCode = 'SWX' WHERE SecCode = 5645885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954864, ExchCode = 'LAS' WHERE SecCode = 5655040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22089214794, Ticker = '3TSEd', ExchCode = 'BTE' WHERE SecCode = 5663514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781580967, ExchCode = 'STU' WHERE SecCode = 5663580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22021922875, ExchCode = 'DEU' WHERE SecCode = 5687951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782109053, ExchCode = 'MEX' WHERE SecCode = 5709076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782489860, Ticker = '1HENS' WHERE SecCode = 5720895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028890988, ExchCode = 'DEU' WHERE SecCode = 5724940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793731712, ExchCode = 'TDG' WHERE SecCode = 5731414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025956, ExchCode = 'LAS' WHERE SecCode = 5764717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788207229, ExchCode = 'FRA' WHERE SecCode = 5822326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784278056, ExchCode = 'STU' WHERE SecCode = 5822327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551903, ExchCode = 'TDG' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 5828879 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 5834667 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804089043, ExchCode = 'QTX' WHERE SecCode = 5853173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22076466658, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2025-02-11' WHERE SecCode = 5897569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025933, ExchCode = 'LAS' WHERE SecCode = 5907872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784888214, ExchCode = 'BIV' WHERE SecCode = 5907884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381827, ExchCode = 'LAS' WHERE SecCode = 6065904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386194, ExchCode = 'FRA' WHERE SecCode = 6065905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945886900, ExchCode = 'GTX' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679771, ExchCode = 'BIV' WHERE SecCode = 6097292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171456, ExchCode = 'BIV' WHERE SecCode = 6097402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823825, PermQuoteStatus = 'AC', Ticker = '3KWBl', ExchCode = 'AQX', PermQuoteRetireDate = NULL WHERE SecCode = 6097422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823830, ExchCode = 'AQX' WHERE SecCode = 6097426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917823888, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 6097430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329758, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 6097431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779005194, PermQuoteStatus = 'AC', Ticker = '5VF', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6097454 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 = 22171710457, ExchCode = 'BCO' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993578569, ExchCode = 'CHI' WHERE SecCode = 6097606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833326, ExchCode = 'DUS' WHERE SecCode = 6139935 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792989476, ExchCode = 'LAS' WHERE SecCode = 6271498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793107258, ExchCode = 'MUN' WHERE SecCode = 6310331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658530124, ExchCode = 'FRA' WHERE SecCode = 6325196 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951250.0 WHERE SecCode = 6331882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887551041, ExchCode = 'MUN' 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 = 22121546541, ExchCode = 'DEU' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CLGUN' WHERE SecCode = 6409797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794542878, ExchCode = 'MEX' WHERE SecCode = 6416397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794594542, ExchCode = 'FRA' WHERE SecCode = 6416433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451440, ExchCode = 'BCO' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131539236, ExchCode = 'DEU' WHERE SecCode = 6480863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796887923, ExchCode = 'DUS' WHERE SecCode = 6480864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131541195, ExchCode = 'DEU' WHERE SecCode = 6480866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796059933, ExchCode = 'MUN', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 6480954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365452, ExchCode = 'DEU' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145080, ExchCode = 'DUS' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798269749, ExchCode = 'TDG' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109633, ExchCode = 'QTX' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138963810, ExchCode = 'GTX' WHERE SecCode = 6538893 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 6543914 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 6548033 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951282.0 WHERE SecCode = 6571951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143843399, ExchCode = 'DEU' WHERE SecCode = 6577960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727315149, Ticker = '5Q5', ExchCode = 'BRN' WHERE SecCode = 6578368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799474752, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2026-02-25', PermSecMapEndDate = '2026-02-25' WHERE SecCode = 6583721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238834, ExchCode = 'QTX' WHERE SecCode = 6587160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238832, ExchCode = 'QTX' WHERE SecCode = 6587161 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 = 21903777191, ExchCode = 'HAN' WHERE SecCode = 6599021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 6629297 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'PNG' WHERE SecCode = 6631786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 6638009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22156552523, ExchCode = 'STU' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802471032, ExchCode = 'FRA' WHERE SecCode = 6638341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802540440, ExchCode = 'FRA' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 6643288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21883771519, ExchCode = 'FRA' WHERE SecCode = 6667833 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590923227.0 WHERE SecCode = 6712514 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6721497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790866059, ExchCode = 'LAS' WHERE SecCode = 6728400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804302835, ExchCode = 'TDG' WHERE SecCode = 6731952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805095337, ExchCode = 'QTX' WHERE SecCode = 6753078 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 6756509 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 6762060 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 6762066 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 6773035 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-16' WHERE SecCode = 6779543 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 10989951 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11002064 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11111276 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11143934 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'CLGUN' WHERE SecCode = 11149268 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'GXXMD' WHERE SecCode = 11172296 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11195616 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236805784996.0, ExchCode = 'NAQ' WHERE SecCode = 11198767 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11204963 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11236900 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11247797 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236804914022, InstrPermID = 232870579239, OrgPermID = 5090726709, PriTrdQuotePermID = 236804914022.0, ValQuotePermID = 25727028989.0, PriInstrPermID = 232870579239.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'CYAB', PriTRBCIndPermID = 4294951203.0, PermQuoteRetireDate = NULL, PermOrgIPODate = '2026-03-27', PermSecMapStartDate = '2026-03-27', PermSecMapEndDate = NULL WHERE SecCode = 11252862 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 8589939980.0 WHERE SecCode = 11260982 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'PNG' WHERE SecCode = 11262296 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'NATQF' WHERE SecCode = 11271493 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11273963 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11274034 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16' WHERE SecCode = 11277349 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11280749 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11286972 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11286975 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11286977 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11286984 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11290671 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11290707 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11290708 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11290712 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11290716 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11290717 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11290718 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-16', PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11290719 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951282.0 WHERE SecCode = 11290728 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-16' WHERE SecCode = 11292168 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232918789762.0 WHERE SecCode = 11292424 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232915006505.0 WHERE SecCode = 11293452 AND Type_ = 1;
