UPDATE data_universe_permid SET QuotePermID = 55838296006, PermQuoteStatus = 'DC', Ticker = 'ALV.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 622 AND Type_ = 10; 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 PermInstrStatus = 'DC' WHERE SecCode = 2565 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 14660 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 16973 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 19538 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-06' WHERE SecCode = 25455 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 28992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 36561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836330930, ExchCode = 'BER', PermQuoteRetireDate = '2023-09-21' WHERE SecCode = 37202 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667469912, ExchCode = 'QTX' WHERE SecCode = 37216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034103, PermQuoteStatus = 'AC', Ticker = 'CPA', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 37361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035699, PermQuoteStatus = 'AC', Ticker = 'GOB', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 37392 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836495769, ExchCode = 'FRA', PermQuoteRetireDate = '2018-12-31' WHERE SecCode = 37422 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 38223 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 42637 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 42948 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 43356 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 43706 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324683, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 45854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475289897, ExchCode = 'GER' WHERE SecCode = 46302 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 46850 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836328604, ExchCode = 'BER', PermQuoteRetireDate = '2021-07-02' WHERE SecCode = 46907 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 49092 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21537831369, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 55286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492006471, ExchCode = 'TDG' WHERE SecCode = 55581 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21601433380, ExchCode = 'TDG' WHERE SecCode = 55585 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836399700, ExchCode = 'FRA', PermQuoteRetireDate = '2016-02-12' WHERE SecCode = 60009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836518711, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60039 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 60083 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55836337787, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 60304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805161989, ExchCode = 'BTE' WHERE SecCode = 61705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485966, ExchCode = 'QTX' WHERE SecCode = 61900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474898042, ExchCode = 'DEU', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 61930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475036978, PermQuoteStatus = 'DC', Ticker = 'IFGA', ExchCode = 'TDG', PermQuoteRetireDate = '2013-11-20', PermSecMapStartDate = '2026-05-04' WHERE SecCode = 63567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856248191, ExchCode = 'DUS', PermQuoteRetireDate = '2016-04-06' WHERE SecCode = 63618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223759, ExchCode = 'QTX' WHERE SecCode = 63625 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 68111 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 71922 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SRNDB' WHERE SecCode = 72565 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL WHERE SecCode = 73402 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 73639 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 73894 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 75538 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 77317 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 77521 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'XLPI' WHERE SecCode = 82755 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 84025 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951600.0 WHERE SecCode = 84930 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951600.0 WHERE SecCode = 84931 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951600.0 WHERE SecCode = 85084 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 85239 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 86877 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951600.0 WHERE SecCode = 86912 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-04' WHERE SecCode = 87258 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 90990 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 95172 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 101281 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 101803 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 112948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667481528, ExchCode = 'QTX' WHERE SecCode = 113151 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 113879 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'WNH' WHERE SecCode = 113941 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 114084 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 115748 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 116474 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951188.0 WHERE SecCode = 116848 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'CHE' WHERE SecCode = 120838 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 123732 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 126438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21957764680, ExchCode = 'FRA' WHERE SecCode = 131976 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 132603 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 137521 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22144763093, ExchCode = 'DEU' WHERE SecCode = 137616 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806599703, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 137782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536043362, ExchCode = 'STU' WHERE SecCode = 137851 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550451605, Ticker = 'NOMU', ExchCode = 'SWX', PermQuoteRetireDate = '2018-06-27' WHERE SecCode = 137856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560378012, ExchCode = 'CHI' WHERE SecCode = 137860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474882287, ExchCode = 'DEU', PermQuoteRetireDate = '2021-04-20' WHERE SecCode = 137873 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714765728, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 137944 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997893, ExchCode = 'FRA' WHERE SecCode = 138040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034965, ExchCode = 'TDG' WHERE SecCode = 138046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430965, ExchCode = 'STU' WHERE SecCode = 138123 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837357536, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 140024 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337625, ExchCode = 'BER' WHERE SecCode = 140048 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 140663 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 140934 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 140965 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823782876, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141114 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 141153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335871, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836539796, ExchCode = 'FRA' WHERE SecCode = 141172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22144719054, ExchCode = 'HAM' WHERE SecCode = 141439 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 141666 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419278, ExchCode = 'HAM' WHERE SecCode = 141993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805901659, ExchCode = 'FRA' WHERE SecCode = 141999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564842271, ExchCode = 'STU' WHERE SecCode = 142481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324383, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-05' WHERE SecCode = 142505 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21817036561, ExchCode = 'TDG' WHERE SecCode = 142650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885909284, ExchCode = 'STU' WHERE SecCode = 142718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475009275, ExchCode = 'DEU' WHERE SecCode = 142742 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 142919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21588166916, ExchCode = 'FRA' WHERE SecCode = 142944 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660711237, ExchCode = 'FRA', PermQuoteRetireDate = '2023-10-27' WHERE SecCode = 143730 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21966768812, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 144713 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05' WHERE SecCode = 144789 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 145495 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 145744 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830293767, Ticker = 'LZO1', ExchCode = 'GTX' WHERE SecCode = 146103 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836527326, ExchCode = 'FRA' WHERE SecCode = 146127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537006540, ExchCode = 'FRA' WHERE SecCode = 146151 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489070, ExchCode = 'QTX' WHERE SecCode = 146155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806599403, ExchCode = 'TDG', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 146226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475036013, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 146280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21509818348, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-05-29' WHERE SecCode = 146333 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842833249, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 147266 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807916842, ExchCode = 'MUN' WHERE SecCode = 147425 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836332880, Ticker = 'MC2', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 147455 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324870, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 147693 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 147694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836482024, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 147856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836555699, ExchCode = 'FRA' WHERE SecCode = 150272 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385935, ExchCode = 'LAS' WHERE SecCode = 151025 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 155319 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 22045077310, ExchCode = 'LAS' WHERE SecCode = 161035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475632882, ExchCode = 'GER' WHERE SecCode = 161036 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 162938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836412159, ExchCode = 'FRA' WHERE SecCode = 164349 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 164811 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 165084 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836336418, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-26' WHERE SecCode = 165818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836329583, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 166414 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 167982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836336292, ExchCode = 'BER', PermQuoteRetireDate = '2017-02-09' WHERE SecCode = 168962 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838585686, ExchCode = 'STU' WHERE SecCode = 172982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836435233, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 172985 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524820302, ExchCode = 'STU' WHERE SecCode = 172988 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 174898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563865064, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 177463 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855345734, ExchCode = 'GTX' WHERE SecCode = 177491 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331775, ExchCode = 'BER' WHERE SecCode = 177594 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836333542, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 177640 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 177693 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757667035, ExchCode = 'BER' WHERE SecCode = 177739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836455554, ExchCode = 'FRA' WHERE SecCode = 177955 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312227, ExchCode = 'GTX' WHERE SecCode = 177972 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784385676, ExchCode = 'LAS' WHERE SecCode = 178451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754922611, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 178507 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836431170, ExchCode = 'FRA' WHERE SecCode = 178511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605132652, ExchCode = 'STU' WHERE SecCode = 178657 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806599401, PermQuoteStatus = 'AC', Ticker = 'INU0', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-04', PermSecMapEndDate = NULL WHERE SecCode = 178667 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324285, Ticker = 'BVT', ExchCode = 'BER', PermQuoteRetireDate = '2023-12-08', PermSecMapEndDate = '2023-12-08' WHERE SecCode = 178675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807704216, ExchCode = 'MUN' WHERE SecCode = 178679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21847722078, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 178680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564885395, ExchCode = 'FRA' WHERE SecCode = 178688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528679753, ExchCode = 'GER' WHERE SecCode = 178849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830289031, PermQuoteStatus = 'AC', Ticker = 'BOZA', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 179089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535137262, ExchCode = 'FRA' WHERE SecCode = 179755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533564239, ExchCode = 'STU', PermQuoteRetireDate = '2025-12-08' WHERE SecCode = 180684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836337360, ExchCode = 'BER' WHERE SecCode = 180695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954293405, ExchCode = 'DUS' WHERE SecCode = 181992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55848349309, ExchCode = 'GER' WHERE SecCode = 185678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485116, ExchCode = 'QTX' WHERE SecCode = 185684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838610027, ExchCode = 'STU' WHERE SecCode = 185686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667488602, Ticker = 'NCGB', ExchCode = 'QTX' WHERE SecCode = 186489 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475482761, ExchCode = 'DEU' WHERE SecCode = 186810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547070064, Ticker = 'BNFd', ExchCode = 'BCO' WHERE SecCode = 196120 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21628831642, ExchCode = 'STU' WHERE SecCode = 196618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21680653336, ExchCode = 'MUN' WHERE SecCode = 196829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642186351, ExchCode = 'DEU' WHERE SecCode = 196887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21724928500, ExchCode = 'TDG' WHERE SecCode = 197762 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474912303, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 199022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667493689, ExchCode = 'QTX' WHERE SecCode = 200713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537702855, ExchCode = 'FRA' WHERE SecCode = 201372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667493668, ExchCode = 'QTX' WHERE SecCode = 201597 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 = 55841903622, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 202787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777874419, ExchCode = 'GTX' WHERE SecCode = 202935 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836332121, ExchCode = 'BER', PermQuoteRetireDate = '2017-04-05' WHERE SecCode = 203925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22177472492, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-05', PermSecMapEndDate = NULL WHERE SecCode = 206835 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667469561, ExchCode = 'QTX', PermQuoteRetireDate = '2018-12-19' WHERE SecCode = 210736 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475592408, ExchCode = 'MUN', PermQuoteRetireDate = '2009-12-17' WHERE SecCode = 210757 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704511, ExchCode = 'MXQ' WHERE SecCode = 214889 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830292595, ExchCode = 'GTX' WHERE SecCode = 215110 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 239060 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419518, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 245886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836454824, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 246361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836339735, PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 246616 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035830, Ticker = 'WRW', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-13' WHERE SecCode = 246694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474867329, ExchCode = 'DEU' WHERE SecCode = 247651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800708418, ExchCode = 'FRA' WHERE SecCode = 248095 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660609207, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 248506 AND Type_ = 10; 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 = 21521856858, ExchCode = 'STU', PermQuoteRetireDate = '2024-08-08' WHERE SecCode = 248749 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 = 55836411753, ExchCode = 'FRA' WHERE SecCode = 248774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474917330, ExchCode = 'DEU' WHERE SecCode = 248929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605379119, ExchCode = 'FRA' WHERE SecCode = 248952 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475130447, ExchCode = 'STU' WHERE SecCode = 248967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21484680882, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 248987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614269979, ExchCode = 'STU' WHERE SecCode = 248989 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475568611, ExchCode = 'MUN', PermQuoteRetireDate = '2010-02-12' WHERE SecCode = 249054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837367328, Ticker = 'RBQN', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 249199 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896834958, ExchCode = 'STU' WHERE SecCode = 249232 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800600238, ExchCode = 'FRA' WHERE SecCode = 249236 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474925265, ExchCode = 'DEU' WHERE SecCode = 249354 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536721623, ExchCode = 'STU', PermQuoteRetireDate = '2018-06-20' WHERE SecCode = 249362 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536896590, ExchCode = 'TDG' WHERE SecCode = 249364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836331035, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324467, ExchCode = 'BER', PermQuoteRetireDate = '2011-10-06' WHERE SecCode = 249379 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524268362, ExchCode = 'STU' WHERE SecCode = 249398 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599530590, PermQuoteStatus = 'AC', Ticker = 'INO0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 249400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 = 21615253053, ExchCode = 'TDG' WHERE SecCode = 249565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830300969, ExchCode = 'GTX' WHERE SecCode = 249589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779461439, ExchCode = 'GTX' WHERE SecCode = 249597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21659184253, ExchCode = 'STU' WHERE SecCode = 249599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21956712462, ExchCode = 'DUS', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 249601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776870528, ExchCode = 'DEU' WHERE SecCode = 249606 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589367501, ExchCode = 'STU' WHERE SecCode = 249627 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789215797, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21947054465, ExchCode = 'TDG' WHERE SecCode = 249656 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21495336695, ExchCode = 'STU' WHERE SecCode = 249668 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602144530, ExchCode = 'STU' WHERE SecCode = 249701 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 249719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308695, ExchCode = 'GTX' WHERE SecCode = 249726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830297789, ExchCode = 'GTX' WHERE SecCode = 249727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636632018, ExchCode = 'STU', PermQuoteRetireDate = '2020-08-26' WHERE SecCode = 249728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548019744, ExchCode = 'FRA' WHERE SecCode = 249761 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593287072, ExchCode = 'STU', PermQuoteRetireDate = '2022-05-27', PermSecMapEndDate = NULL WHERE SecCode = 249777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475127463, ExchCode = 'FRA' WHERE SecCode = 249782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474997548, ExchCode = 'FRA' WHERE SecCode = 249786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21516948702, ExchCode = 'STU' WHERE SecCode = 249787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767179587, ExchCode = 'DEU' WHERE SecCode = 249796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22052572098, ExchCode = 'DEU' WHERE SecCode = 249797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532691717, ExchCode = 'FRA' WHERE SecCode = 249801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538241626, ExchCode = 'DEU', PermQuoteRetireDate = '2016-01-05' WHERE SecCode = 249805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860308852, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793530311, ExchCode = 'DEU' WHERE SecCode = 249816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525576964, ExchCode = 'TDG' WHERE SecCode = 249828 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474891803, PermQuoteStatus = 'DC', Ticker = 'ILR', ExchCode = 'DEU', PermQuoteRetireDate = '2018-06-22', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249836 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475471081, ExchCode = 'BER', PermQuoteRetireDate = '2009-04-29' WHERE SecCode = 249843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475609721, Ticker = 'COCL.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 249849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475454256, ExchCode = 'GER' WHERE SecCode = 249855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836329232, ExchCode = 'BER' WHERE SecCode = 249861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474878463, ExchCode = 'DEU' WHERE SecCode = 250095 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830278708, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 250100 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608397232, ExchCode = 'TDG' WHERE SecCode = 250132 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 253624 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033971, PermQuoteStatus = 'AC', Ticker = 'Q23', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 255769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475077443, ExchCode = 'STU', PermQuoteRetireDate = '2015-11-09' WHERE SecCode = 259601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474926380, ExchCode = 'HAM' WHERE SecCode = 259753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836340478, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 259830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804440375, ExchCode = 'FRA' WHERE SecCode = 273208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836388950, ExchCode = 'FRA' WHERE SecCode = 283709 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341153, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 283718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836522301, ExchCode = 'FRA', PermQuoteRetireDate = '2011-08-17' WHERE SecCode = 283842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788147697, ExchCode = 'STU' WHERE SecCode = 286042 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531135221, Ticker = 'TSUo', ExchCode = 'BCO', PermQuoteRetireDate = '2015-02-04' WHERE SecCode = 286474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808531461, ExchCode = 'FRA' WHERE SecCode = 286479 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22143294154, ExchCode = 'DEU' WHERE SecCode = 288353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21626353880, ExchCode = 'FRA' WHERE SecCode = 288662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033480, ExchCode = 'TDG' WHERE SecCode = 289443 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21700198266, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 289461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836388942, ExchCode = 'FRA', PermQuoteRetireDate = '2009-01-07' WHERE SecCode = 291270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836323533, ExchCode = 'BER', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 291271 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21773002465, ExchCode = 'FRA' WHERE SecCode = 291283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21583580948, ExchCode = 'TDG' WHERE SecCode = 291585 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776448514, ExchCode = 'STU' WHERE SecCode = 291850 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 292679 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 292761 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21897985709, ExchCode = 'FRA' WHERE SecCode = 292976 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587662542, ExchCode = 'STU' WHERE SecCode = 294092 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794261329, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 296129 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836329143, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21516375944, ExchCode = 'STU', PermQuoteRetireDate = '2026-04-30', PermSecMapEndDate = NULL WHERE SecCode = 296276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324213, ExchCode = 'BER', PermQuoteRetireDate = '2008-08-06' WHERE SecCode = 296278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475060400, ExchCode = 'STU', PermQuoteRetireDate = '2020-08-06', PermSecMapEndDate = '2020-08-06' WHERE SecCode = 296279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933395726, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 296284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836330602, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529362164, ExchCode = 'TDG' WHERE SecCode = 296606 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335229, ExchCode = 'BER' WHERE SecCode = 296646 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22028051912, ExchCode = 'DEU' WHERE SecCode = 296731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786321993, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 297732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21680538270, ExchCode = 'TDG' WHERE SecCode = 297742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21654538579, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 298603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835800492, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 299537 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727212170, ExchCode = 'MEX' WHERE SecCode = 299539 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 = 21474946646, ExchCode = 'HAM' WHERE SecCode = 300369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850895857, ExchCode = 'QTX', PermQuoteRetireDate = '2021-11-01' WHERE SecCode = 300831 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 301331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475587010, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2008-07-07' WHERE SecCode = 301718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475721017, Ticker = 'GFH.I', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 302658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341653, ExchCode = 'BER', PermQuoteRetireDate = '2018-12-18', PermSecMapEndDate = '2018-12-18' WHERE SecCode = 302710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21483815345, ExchCode = 'TDG' WHERE SecCode = 303347 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836336531, ExchCode = 'BER' WHERE SecCode = 303353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863182888, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 303357 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801722954, ExchCode = 'FRA' WHERE SecCode = 303358 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474989966, ExchCode = 'STU' WHERE SecCode = 304121 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935904588, ExchCode = 'FRA' WHERE SecCode = 304553 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21612317653, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 304966 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474901442, ExchCode = 'DEU' WHERE SecCode = 304967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475147361, ExchCode = 'STU' WHERE SecCode = 305002 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 306047 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21585029092, ExchCode = 'CHI' WHERE SecCode = 309898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836328807, ExchCode = 'BER', PermQuoteRetireDate = '2015-09-04' WHERE SecCode = 310710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21713340724, PermQuoteStatus = 'AC', ExchCode = 'FRA', DomCntry = 'USA', PermQuoteRetireDate = NULL WHERE SecCode = 311970 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836346844, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 312700 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838351572, ExchCode = 'STU', PermQuoteRetireDate = '2011-05-25' WHERE SecCode = 312933 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 = 21819755613, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 313243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514317546, Ticker = 'TP21', ExchCode = 'STU' WHERE SecCode = 313535 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 = 21475538550, PermQuoteStatus = 'DC', Ticker = 'BMW-U', ExchCode = 'ETX', PermQuoteRetireDate = '2009-12-28' WHERE SecCode = 314400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860086807, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 316450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793968534, ExchCode = 'FRA' WHERE SecCode = 316451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658947465, ExchCode = 'STU' WHERE SecCode = 317810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475009266, ExchCode = 'DEU' WHERE SecCode = 318408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320798, ExchCode = 'BER' WHERE SecCode = 319524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531428173, ExchCode = 'BEC', PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 319996 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21571803950, ExchCode = 'BCO' WHERE SecCode = 321679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840202950, ExchCode = 'MEX' WHERE SecCode = 321680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21758740684, ExchCode = 'TDG' WHERE SecCode = 323298 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781627683, ExchCode = 'QTX' WHERE SecCode = 324562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520752473, ExchCode = 'HAN' WHERE SecCode = 325645 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856239637, ExchCode = 'DUS' WHERE SecCode = 325648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797999290, ExchCode = 'DEU' WHERE SecCode = 325661 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 325855 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55837350120, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 326282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21568459988, ExchCode = 'STU' WHERE SecCode = 326661 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608397233, ExchCode = 'TDG' WHERE SecCode = 327144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806599397, Ticker = 'WILC', ExchCode = 'TDG', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 327711 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 328300 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55852372426, ExchCode = 'STU', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 328871 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320592, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 329370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419277, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 329388 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629957388, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 330665 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55848717422, Ticker = NULL, ExchCode = 'GER', PermQuoteRetireDate = '2017-07-13' WHERE SecCode = 331318 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 331611 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21635896884, Ticker = 'AGGP.GB', ExchCode = 'AQS' WHERE SecCode = 333085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532305080, Ticker = 'OILBl', ExchCode = 'SIG', PermQuoteRetireDate = '2017-12-21' WHERE SecCode = 333091 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834673708, PermQuoteStatus = 'AC', Ticker = '0G77', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 333102 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836321769, ExchCode = 'BER', PermQuoteRetireDate = '2009-04-22' WHERE SecCode = 333158 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320770, ExchCode = 'BER' WHERE SecCode = 333182 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475073762, PermQuoteStatus = 'AC', Ticker = '0NBD', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 333386 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21505949054, ExchCode = 'STU' WHERE SecCode = 333421 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802152416, PermQuoteStatus = 'DC', Ticker = 'B9P0', ExchCode = 'STU', PermQuoteRetireDate = '2026-02-23' WHERE SecCode = 333423 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 = 21526983523, Ticker = 'SILp', ExchCode = 'SIG', PermQuoteRetireDate = '2013-07-31' WHERE SecCode = 334460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523039680, ExchCode = 'TDG' WHERE SecCode = 334857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22164720656, ExchCode = 'DEU' WHERE SecCode = 335262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320947, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 335658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800222858, ExchCode = 'FRA' WHERE SecCode = 335659 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475569303, Ticker = '0FLM', ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 336187 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520390384, ExchCode = 'STU' WHERE SecCode = 336198 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620411337, ExchCode = 'STU', PermQuoteRetireDate = '2023-11-17' WHERE SecCode = 336764 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836553012, ExchCode = 'FRA', PermQuoteRetireDate = '2014-01-03' WHERE SecCode = 336766 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772995918, Ticker = '3PJ1', ExchCode = 'DUS', PermQuoteRetireDate = '2025-08-07' WHERE SecCode = 337013 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21520440561, ExchCode = 'DEU' WHERE SecCode = 337400 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 338708 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21540228781, ExchCode = 'STU' WHERE SecCode = 341124 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 = 21823782722, ExchCode = 'DUS', PermQuoteRetireDate = '2021-08-19', PermSecMapEndDate = '2021-09-24' WHERE SecCode = 341956 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 = 21667479701, ExchCode = 'QTX' WHERE SecCode = 341963 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 = 55836321347, ExchCode = 'BER' WHERE SecCode = 343073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535281403, ExchCode = 'STU' WHERE SecCode = 343807 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21623230049, ExchCode = 'STU', PermQuoteRetireDate = '2022-02-25' WHERE SecCode = 344003 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22024222793, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 344005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21476459275, Ticker = '1893.H', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 345190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825607959, ExchCode = 'MUN' WHERE SecCode = 345429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798428786, ExchCode = 'FRA' WHERE SecCode = 345431 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 = 55838799125, Ticker = NULL, ExchCode = 'PRA' WHERE SecCode = 346537 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21790869646, ExchCode = 'TDG', PermQuoteRetireDate = '2025-10-20' WHERE SecCode = 348120 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513927540, Ticker = '2RNO' WHERE SecCode = 348455 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547083329, ExchCode = 'STU', PermQuoteRetireDate = '2016-01-08' WHERE SecCode = 350269 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834673962, PermQuoteStatus = 'AC', Ticker = '0OGK', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 351284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475473202, ExchCode = 'FRA' WHERE SecCode = 351305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21509803171, Ticker = NULL, ExchCode = 'LSE' WHERE SecCode = 353941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475073674, PermQuoteStatus = 'AC', Ticker = '0MHW', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 353961 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834675302, Ticker = '0NEV', ExchCode = 'LSE', PermQuoteRetireDate = '2012-03-13' WHERE SecCode = 353982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55834672978, Ticker = '0FRP', ExchCode = 'LSE', PermQuoteRetireDate = '2010-07-26' WHERE SecCode = 355329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836350281, ExchCode = 'FRA' WHERE SecCode = 357185 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837351159, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 357657 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836382381, ExchCode = 'FRA' WHERE SecCode = 357672 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954561673, ExchCode = 'DUS' WHERE SecCode = 357673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320953, ExchCode = 'BER' WHERE SecCode = 358997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034683, Ticker = '45G', ExchCode = 'TDG', PermQuoteRetireDate = '2012-10-23' WHERE SecCode = 360278 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 362271 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21799029787, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-11-21' WHERE SecCode = 363732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21620916416, ExchCode = 'TDG' WHERE SecCode = 375326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669469822, ExchCode = 'FRA' WHERE SecCode = 377102 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629963324, PermQuoteStatus = 'DC', Ticker = '4LT', ExchCode = 'TDG', PermQuoteRetireDate = '2020-12-08' WHERE SecCode = 377460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475387879, Ticker = 'LUN.DK', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 378013 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514709829, Ticker = 'D69', ExchCode = 'STU' WHERE SecCode = 379671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916561972, ExchCode = 'MUN' WHERE SecCode = 385281 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301252, ExchCode = 'GTX' WHERE SecCode = 387911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55852345881, ExchCode = 'FRA' WHERE SecCode = 387914 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475476679, ExchCode = 'FRA' WHERE SecCode = 389009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21962595022, ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-15' WHERE SecCode = 389476 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840905043, ExchCode = 'BER' WHERE SecCode = 389775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840906149, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-04' WHERE SecCode = 389776 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033780, ExchCode = 'TDG' WHERE SecCode = 392214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550451829, Ticker = 'NEM', ExchCode = 'SWX' WHERE SecCode = 392615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841648239, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 396297 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799280763, ExchCode = 'DEU' WHERE SecCode = 396303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792907732, ExchCode = 'GER' WHERE SecCode = 396306 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685431734, ExchCode = 'DEU' WHERE SecCode = 401619 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841565727, ExchCode = 'GER' WHERE SecCode = 401620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841617044, ExchCode = 'FRA' WHERE SecCode = 401621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841643563, ExchCode = 'BER', PermQuoteRetireDate = '2014-08-20' WHERE SecCode = 401624 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21539533292, ExchCode = 'MUN', PermQuoteRetireDate = '2019-11-07' WHERE SecCode = 404833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21478492476, Ticker = '0GKZ', ExchCode = 'LSE', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 408476 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667479309, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 408562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704362, ExchCode = 'MXQ' WHERE SecCode = 411789 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667482293, ExchCode = 'QTX' WHERE SecCode = 413132 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 423163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843102675, ExchCode = 'BER' WHERE SecCode = 424779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294126, ExchCode = 'GTX' WHERE SecCode = 425031 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396938, ExchCode = 'DEU' WHERE SecCode = 428966 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55839878219 WHERE SecCode = 433675 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859809742, ExchCode = 'UAX', PermQuoteRetireDate = '2015-12-08' WHERE SecCode = 433814 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21477787209, ExchCode = 'TDG' WHERE SecCode = 435796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781684824, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 439455 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-04' WHERE SecCode = 450705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838299278, PermQuoteStatus = 'DC', Ticker = 'BMW3.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 451110 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 456391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667487014, Ticker = 'K900', ExchCode = 'QTX' WHERE SecCode = 458145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21575865316, ExchCode = 'BCO' WHERE SecCode = 464174 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847269156, Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 471737 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033434, ExchCode = 'TDG', PermQuoteRetireDate = '2021-11-30' WHERE SecCode = 471738 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847185526, Ticker = '0AO', ExchCode = 'BER', PermQuoteRetireDate = '2021-11-23' WHERE SecCode = 479615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847283502, Ticker = 'XAXJ', ExchCode = 'LSE' WHERE SecCode = 481041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035525, ExchCode = 'TDG', PermQuoteRetireDate = '2014-12-09', PermSecMapEndDate = '2018-09-19' WHERE SecCode = 484246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55848865464, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 503830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725613667, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 503842 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 505369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704447, ExchCode = 'MXQ' WHERE SecCode = 508999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849615524, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 512041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492958, ExchCode = 'QTX' WHERE SecCode = 515043 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554745286, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 519578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714444925, Ticker = 'WEATm', ExchCode = 'DXE' WHERE SecCode = 521420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591308348, ExchCode = 'STU', PermQuoteRetireDate = '2025-10-09' WHERE SecCode = 527096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727214201, ExchCode = 'BIV' WHERE SecCode = 529546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521104643, ExchCode = 'STU' WHERE SecCode = 533520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532071651, ExchCode = 'MUN' WHERE SecCode = 535313 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714450686, Ticker = 'SBULm', ExchCode = 'DXE' WHERE SecCode = 536401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21480923684, ExchCode = 'BER', PermQuoteRetireDate = '2019-12-17' WHERE SecCode = 536609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475422418, Ticker = '0B3F', ExchCode = 'LSE', PermQuoteRetireDate = '2009-09-18' WHERE SecCode = 536734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836335096, ExchCode = 'BER' WHERE SecCode = 540563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55852219705, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 541456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21514772172, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 541523 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807916878, ExchCode = 'TDG' WHERE SecCode = 542943 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 543178 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 543795 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 547454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21964831449, ExchCode = 'DEU' WHERE SecCode = 549886 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 550307 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859092912, ExchCode = 'FRA', PermQuoteRetireDate = '2014-08-08' WHERE SecCode = 551262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55854012972, ExchCode = 'STU' WHERE SecCode = 556254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55854015367, ExchCode = 'BER', PermQuoteRetireDate = '2013-07-08' WHERE SecCode = 556535 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951245.0 WHERE SecCode = 557938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856218481, ExchCode = 'BER', PermQuoteRetireDate = '2013-02-08' WHERE SecCode = 559256 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951245.0 WHERE SecCode = 559424 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856606624, ExchCode = 'GER' WHERE SecCode = 559437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856721464, ExchCode = 'BER', PermQuoteRetireDate = '2018-04-27' WHERE SecCode = 560723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856711423, ExchCode = 'FRA' WHERE SecCode = 560728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21525342898, ExchCode = 'STU' WHERE SecCode = 561861 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529362096, ExchCode = 'STU' WHERE SecCode = 563087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552518788, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 563096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474908406, ExchCode = 'DEU', PermQuoteRetireDate = '2018-02-05' WHERE SecCode = 564280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782254162, ExchCode = 'GTX' WHERE SecCode = 564417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475108946, ExchCode = 'STU' WHERE SecCode = 565316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475822753, ExchCode = 'DEU' WHERE SecCode = 565586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475805335, PermQuoteStatus = 'DC', Ticker = 'OAA', ExchCode = 'TDG', PermQuoteRetireDate = '2013-04-19' WHERE SecCode = 565752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864886870, ExchCode = 'MUN' 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 = 55857857467, ExchCode = 'STU' WHERE SecCode = 566528 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 568065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787219, ExchCode = 'DUS' WHERE SecCode = 575072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853019549, ExchCode = 'MEX' WHERE SecCode = 580373 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 581682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521225328, ExchCode = 'STU' WHERE SecCode = 627565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55868335680, Ticker = 'OCS.GB', ExchCode = 'PLU' WHERE SecCode = 649936 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474991501, ExchCode = 'STU' WHERE SecCode = 652498 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 683529 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951674.0 WHERE SecCode = 683638 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 690352 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 690436 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 717246 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 785756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780160052, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 827254 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 832249 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 833765 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802423013, ExchCode = 'FRA' WHERE SecCode = 844009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475136685, ExchCode = 'FRA' WHERE SecCode = 858901 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-08' WHERE SecCode = 873717 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 = 21660807802, ExchCode = 'MUN' WHERE SecCode = 882870 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 918892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545813896, ExchCode = 'DEU' WHERE SecCode = 931181 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494700995, ExchCode = 'FRA' WHERE SecCode = 982229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475766062, Ticker = '29F', ExchCode = 'STU', PermQuoteRetireDate = '2015-03-23' WHERE SecCode = 985004 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 1043297 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 1061200 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 1245915 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 1262951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797797722, ExchCode = 'QTX' WHERE SecCode = 1425621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21747333681, ExchCode = 'DEU' WHERE SecCode = 1447581 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21582997752, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1455200 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 1460771 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2013-11-09' WHERE SecCode = 1464838 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 = 21596919147, Ticker = 'SLHOm', ExchCode = 'BTE', PermQuoteRetireDate = '2019-09-18' WHERE SecCode = 1503000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652933092, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1503040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21483930016, ExchCode = 'FRA' WHERE SecCode = 1503058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21487020931, ExchCode = 'FRA' WHERE SecCode = 1519184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767179775, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 1524544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794818026, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1527439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21490958523, ExchCode = 'FRA' WHERE SecCode = 1531694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494270027, ExchCode = 'DEU' WHERE SecCode = 1538607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494267747, ExchCode = 'FRA' WHERE SecCode = 1541369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494609083, ExchCode = 'FRA', PermQuoteRetireDate = '2016-09-12' WHERE SecCode = 1544112 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 1544676 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 1565080 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21502130370, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-22' WHERE SecCode = 1572762 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21515837864, ExchCode = 'DEU' WHERE SecCode = 1572867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21503359450, ExchCode = 'DEU' WHERE SecCode = 1583290 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 1617059 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21507421341, ExchCode = 'STU' WHERE SecCode = 1622873 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621433340, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-01-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1655579 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633835904, Ticker = '7O2d', ExchCode = 'BCO' WHERE SecCode = 1656414 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 1660082 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527481178, PermQuoteStatus = 'DC', Ticker = 'PJSB', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1660702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511222796, ExchCode = 'DEU' WHERE SecCode = 1675772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531120618, Ticker = 'CHMTp', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-08' WHERE SecCode = 1677246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781627697, ExchCode = 'QTX' WHERE SecCode = 1689167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705857, ExchCode = 'MXQ' WHERE SecCode = 1690204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21528495416, ExchCode = 'CHI' WHERE SecCode = 1722300 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792907733, ExchCode = 'FRA' WHERE SecCode = 1733285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513762821, ExchCode = 'DEU' WHERE SecCode = 1736071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538295458, ExchCode = 'DEU' WHERE SecCode = 1768937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916285770, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 1793899 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681116521, ExchCode = 'DEU' WHERE SecCode = 1795399 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387846, ExchCode = 'LAS' WHERE SecCode = 1905111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21515423659, ExchCode = 'DEU' WHERE SecCode = 1967460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704166, ExchCode = 'MXQ' WHERE SecCode = 2014210 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796238002, ExchCode = 'GTX' WHERE SecCode = 2085430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519498812, ExchCode = 'DEU' WHERE SecCode = 2115211 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658947457, ExchCode = 'FRA' WHERE SecCode = 2142278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519818958, ExchCode = 'DEU' WHERE SecCode = 2151455 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05' WHERE SecCode = 2162009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799280835, ExchCode = 'TDG' WHERE SecCode = 2204916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524070827, ExchCode = 'FRA' WHERE SecCode = 2240608 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 = 21525642309, ExchCode = 'FRA', PermQuoteRetireDate = '2024-04-10' WHERE SecCode = 2279777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21527854591, ExchCode = 'STU', PermQuoteRetireDate = '2021-01-06' WHERE SecCode = 2288362 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796761080, ExchCode = 'DUS' WHERE SecCode = 2333017 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784376233, ExchCode = 'GTX' WHERE SecCode = 2357230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530263647, ExchCode = 'FRA' WHERE SecCode = 2357967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21529719631, ExchCode = 'TDG' WHERE SecCode = 2357969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484790, ExchCode = 'QTX' WHERE SecCode = 2357974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554842071, ExchCode = 'STU' WHERE SecCode = 2365655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2372649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22130921495, ExchCode = 'DEU' WHERE SecCode = 2375433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531130867, InstrPermID = 8590926370, OrgPermID = 4295858498, ValQuotePermID = 55835583224.0, PriInstrPermID = 8590926370.0, PermInstrStatus = 'AC', Ticker = 'MQG0d', ExchCode = 'BCO', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = 4294951922.0, PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2013-10-29' WHERE SecCode = 2387360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538437331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2391345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589743018, ExchCode = 'FRA' WHERE SecCode = 2407193 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786676622, ExchCode = 'MEX' WHERE SecCode = 2414027 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756688641, ExchCode = 'MUN', PermQuoteRetireDate = '2024-02-01', PermSecMapEndDate = '2024-02-01' WHERE SecCode = 2421101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21862726938, ExchCode = 'MUN' WHERE SecCode = 2425600 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538681, ExchCode = 'FRA' WHERE SecCode = 2429967 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533730592, ExchCode = 'FRA' WHERE SecCode = 2435329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535117810, ExchCode = 'BEC' WHERE SecCode = 2435334 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 2450648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370397, ExchCode = 'SGO' WHERE SecCode = 2452538 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560442473, ExchCode = 'STU' WHERE SecCode = 2455543 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05' WHERE SecCode = 2458784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381214, ExchCode = 'LAS' WHERE SecCode = 2466343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544716999, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2487616 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536651291, ExchCode = 'FRA' WHERE SecCode = 2487630 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 2496924 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591015805, ExchCode = 'BER' WHERE SecCode = 2513107 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 2522904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21618954036, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2532826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587574218, ExchCode = 'FRA' WHERE SecCode = 2536084 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951559.0 WHERE SecCode = 2536845 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951559.0 WHERE SecCode = 2540730 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540103119, ExchCode = 'FRA' WHERE SecCode = 2543647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540098774, ExchCode = 'TDG', PermQuoteRetireDate = '2015-08-12' WHERE SecCode = 2543648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371134, ExchCode = 'BEC' WHERE SecCode = 2545788 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541115296, ExchCode = 'DEU' WHERE SecCode = 2556581 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 2560607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543101908, ExchCode = 'DEU' WHERE SecCode = 2579445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21847715339, ExchCode = 'MUN' WHERE SecCode = 2584258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543708867, ExchCode = 'FRA' WHERE SecCode = 2585326 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2585474 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2585497 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2593532 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 2593534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544378913, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-23' WHERE SecCode = 2604155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611446145, ExchCode = 'FRA' WHERE SecCode = 2604394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606224224, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-01' WHERE SecCode = 2622293 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521371263, ExchCode = 'BEC' WHERE SecCode = 2625122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21546332345, PermQuoteStatus = 'AC', Ticker = '14S0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2625801 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 2628633 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312212, ExchCode = 'GTX' WHERE SecCode = 2630989 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370299, ExchCode = 'GTX' WHERE SecCode = 2642447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704172, ExchCode = 'MXQ' WHERE SecCode = 2644179 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951618.0 WHERE SecCode = 2646533 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549840571, ExchCode = 'DEU' WHERE SecCode = 2649167 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2655938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549052722, ExchCode = 'DEU' WHERE SecCode = 2655940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS', PermQuoteRetireDate = '2017-11-01' 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 PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 2671255 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2693656 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480323, ExchCode = 'QTX' WHERE SecCode = 2694712 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955513813, ExchCode = 'DUS' WHERE SecCode = 2711152 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2725378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387967, ExchCode = 'LAS' WHERE SecCode = 2732754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21555271601, ExchCode = 'FRA' WHERE SecCode = 2764597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679952, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2767178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367198, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 2770609 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754377738, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2774739 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557191633, ExchCode = 'BER' 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 = 21843924533, ExchCode = 'FRA' WHERE SecCode = 2809752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322146, Ticker = 'IDV1', ExchCode = 'DEU' WHERE SecCode = 2812145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322223, ExchCode = 'FRA' WHERE SecCode = 2812146 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656676401, ExchCode = 'BIV' WHERE SecCode = 2812158 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558476903, ExchCode = 'FRA' WHERE SecCode = 2813079 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558155337, ExchCode = 'FRA' WHERE SecCode = 2823565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535496482, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 2827915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763993243, PermQuoteStatus = 'AC', Ticker = '8PSGd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 2846585 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21559588394, ExchCode = 'FRA' WHERE SecCode = 2848442 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642375032, ExchCode = 'DEU' WHERE SecCode = 2849922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560671440, ExchCode = 'FRA' WHERE SecCode = 2855770 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21684294108, ExchCode = 'TDG', PermQuoteRetireDate = '2019-04-03' WHERE SecCode = 2855771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560761414, ExchCode = 'DEU' WHERE SecCode = 2855773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21939948844, ExchCode = 'HAN' WHERE SecCode = 2855819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560976379, ExchCode = 'FRA' WHERE SecCode = 2857038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661952406, ExchCode = 'FRA' WHERE SecCode = 2858567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599175171, ExchCode = 'MUN' WHERE SecCode = 2861791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460829, ExchCode = 'GER' WHERE SecCode = 2864471 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 2868670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561796936, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2870145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21562290608, ExchCode = 'FRA' WHERE SecCode = 2870150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656677051, ExchCode = 'BIV' WHERE SecCode = 2876241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656673107, ExchCode = 'BIV' WHERE SecCode = 2876284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625073295, ExchCode = 'FRA', PermQuoteRetireDate = '2022-03-09' WHERE SecCode = 2880970 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531671070, ExchCode = 'AUX' WHERE SecCode = 2887121 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21577065352, ExchCode = 'DEU' WHERE SecCode = 2887226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647737024, ExchCode = 'DEU' WHERE SecCode = 2893040 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 2904310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564531293, ExchCode = 'STU' WHERE SecCode = 2905610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565633193, PermQuoteStatus = 'AC', Ticker = 'CM30', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2907243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644687444, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655017440, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564888886, Ticker = 'H3D', ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 2909900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564888736, ExchCode = 'DEU' WHERE SecCode = 2909901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564938913, ExchCode = 'DEU' WHERE SecCode = 2909928 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565402682, ExchCode = 'FRA' WHERE SecCode = 2910684 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 2911289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565148442, ExchCode = 'MUN' WHERE SecCode = 2911859 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2919788 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21568459998, ExchCode = 'STU' WHERE SecCode = 2924580 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 2924593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566806429, ExchCode = 'DEU' WHERE SecCode = 2930976 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21567022234, ExchCode = 'FRA', PermQuoteRetireDate = '2019-05-27', PermSecMapEndDate = NULL WHERE SecCode = 2932394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21672243657, PermQuoteStatus = 'DC', Ticker = '16IE', ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 2935960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21569155612, ExchCode = 'STU' WHERE SecCode = 2947855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836341299, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 2947875 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370461, ExchCode = 'GTX' WHERE SecCode = 2947926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21569151527, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2952372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704396, ExchCode = 'MXQ' WHERE SecCode = 2963604 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759488811, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3010358 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589498061, ExchCode = 'FRA' WHERE SecCode = 3030770 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21659181386, ExchCode = 'MUN' WHERE SecCode = 3032214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21643809700, ExchCode = 'FRA' WHERE SecCode = 3036806 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822880896, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3051795 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21594331200, ExchCode = 'MUN' WHERE SecCode = 3059437 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587055379, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14', PermSecMapEndDate = '2020-06-16' WHERE SecCode = 3076717 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 3079168 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951257.0 WHERE SecCode = 3109366 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 = 21584924434, ExchCode = 'MUN' WHERE SecCode = 3121331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781544679, ExchCode = 'DUS' WHERE SecCode = 3125957 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552305555, ExchCode = 'STU', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 3153817 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587931877, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587055393, ExchCode = 'STU' WHERE SecCode = 3166812 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 = 21830284723, ExchCode = 'GTX' WHERE SecCode = 3181133 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3196947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589835342, ExchCode = 'DEU' WHERE SecCode = 3196992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169497784, ExchCode = 'DEU' WHERE SecCode = 3196993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821257511, ExchCode = 'DUS' WHERE SecCode = 3199702 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3200926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21769880745, ExchCode = 'FRA' WHERE SecCode = 3201375 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 3208330 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388055, ExchCode = 'LAS' WHERE SecCode = 3208355 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3210058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783209095, ExchCode = 'FRA' WHERE SecCode = 3213268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21748078950, ExchCode = 'DEU', PermQuoteRetireDate = '2023-02-17', PermSecMapEndDate = '2023-02-17' WHERE SecCode = 3215564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609921006, ExchCode = 'STU' WHERE SecCode = 3222698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593186021, ExchCode = 'DEU' WHERE SecCode = 3223011 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 = 21595110980, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3229527 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21821670370, ExchCode = 'QTX' WHERE SecCode = 3245391 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 3247550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21651373312, ExchCode = 'DEU' WHERE SecCode = 3255012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617415254, ExchCode = 'MUN' WHERE SecCode = 3255028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597673887, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-06', PermSecMapEndDate = '2023-11-06' WHERE SecCode = 3256376 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705837, ExchCode = 'MXQ' WHERE SecCode = 3257336 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21626020413, ExchCode = 'FRA' WHERE SecCode = 3257550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645063299, ExchCode = 'DEU' WHERE SecCode = 3257551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21643695294, ExchCode = 'FRA' WHERE SecCode = 3257553 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781684752, ExchCode = 'QTX' WHERE SecCode = 3259344 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 3263272 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704422, Ticker = 'CERN*', ExchCode = 'MXQ' WHERE SecCode = 3275597 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679465, ExchCode = 'BIV' WHERE SecCode = 3275797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606224258, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-21', PermSecMapEndDate = NULL WHERE SecCode = 3275862 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 3277071 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277080 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782872444, Ticker = 'SLYGd', ExchCode = 'SIG' WHERE SecCode = 3280089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954945, ExchCode = 'LAS' WHERE SecCode = 3283696 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602970799, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3283956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803771948, ExchCode = 'DEU' WHERE SecCode = 3284992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634479982, ExchCode = 'MUN' WHERE SecCode = 3285184 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-04' WHERE SecCode = 3288678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602047603, ExchCode = 'MUN' WHERE SecCode = 3288791 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3288938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785774590, ExchCode = 'DEU' WHERE SecCode = 3296206 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951188.0 WHERE SecCode = 3297209 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21638239121, ExchCode = 'BTE' WHERE SecCode = 3301720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609616, ExchCode = 'DUS' WHERE SecCode = 3303268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782726136, ExchCode = 'AQX' WHERE SecCode = 3304228 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21639800655, Ticker = 'KYH', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-09' WHERE SecCode = 3305367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388152, ExchCode = 'LAS' 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 = 21608278641, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3312546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705301, Ticker = 'LOGM*', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3312549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21567130803, ExchCode = 'TDG' WHERE SecCode = 3315799 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750316962, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 3315888 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21608659181, ExchCode = 'STU' WHERE SecCode = 3316586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21784368437, ExchCode = 'MUN' WHERE SecCode = 3317120 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596900305, ExchCode = 'MUN' WHERE SecCode = 3317168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766138099, ExchCode = 'STU' WHERE SecCode = 3317714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617237022, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-01', PermSecMapEndDate = NULL WHERE SecCode = 3318127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777378758, ExchCode = 'MUN' WHERE SecCode = 3318532 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 3318953 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380068, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3319868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100523, ExchCode = 'QTX' WHERE SecCode = 3320079 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100435, ExchCode = 'QTX' WHERE SecCode = 3320207 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21610776896, ExchCode = 'STU' WHERE SecCode = 3320375 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 3321108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611042371, ExchCode = 'DEU' WHERE SecCode = 3322810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667482861, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781510732, ExchCode = 'DUS' WHERE SecCode = 3337226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480059, ExchCode = 'QTX' WHERE SecCode = 3339799 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591485244, Ticker = '1PSM', ExchCode = 'MIL' WHERE SecCode = 3347660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21790722364, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2022-08-11' WHERE SecCode = 3352147 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615298321, ExchCode = 'TRQ' WHERE SecCode = 3358414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21659071012, ExchCode = 'BIV' WHERE SecCode = 3358492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615253063, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3358543 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011585, Ticker = '2EVK', ExchCode = 'MIL' WHERE SecCode = 3358919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704834, ExchCode = 'MXQ' WHERE SecCode = 3359195 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21615050419, ExchCode = 'DEU' WHERE SecCode = 3359272 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805023784, ExchCode = 'DEU' WHERE SecCode = 3368562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763116669, PermQuoteStatus = 'DC', Ticker = '015', ExchCode = 'BER', PermQuoteRetireDate = '2023-02-15', PermSecMapEndDate = '2023-02-15' WHERE SecCode = 3375389 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3377753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100723, ExchCode = 'DUS' WHERE SecCode = 3378195 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647732131, ExchCode = 'STU' WHERE SecCode = 3378583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864390192, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 3379451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704322, ExchCode = 'MXQ' WHERE SecCode = 3385617 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625753506, ExchCode = 'BTE' WHERE SecCode = 3385974 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766019517, ExchCode = 'FRA' WHERE SecCode = 3386374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650357, ExchCode = 'QTX' WHERE SecCode = 3392279 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796141211, Ticker = 'PEYSl', ExchCode = 'SIG' WHERE SecCode = 3392282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645193083, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-03', PermSecMapEndDate = NULL WHERE SecCode = 3393655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21575576966, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 3394028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659667, ExchCode = 'LAS' WHERE SecCode = 3394497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805094957, ExchCode = 'FRA' WHERE SecCode = 3395352 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806598716, PermQuoteStatus = 'AC', Ticker = 'CPRI', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-04', PermSecMapEndDate = NULL WHERE SecCode = 3395559 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 3395998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21623803393, ExchCode = 'DEU' WHERE SecCode = 3396014 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 3403847 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704264, ExchCode = 'MXQ' WHERE SecCode = 3403875 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 3403921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718790665, ExchCode = 'BTE' WHERE SecCode = 3404188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761303133, ExchCode = 'TDG' WHERE SecCode = 3404546 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 3405065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800097182, ExchCode = 'LAS' WHERE SecCode = 3405304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629355998, ExchCode = 'TDG', PermQuoteRetireDate = '2024-07-31', PermSecMapEndDate = '2024-08-30' WHERE SecCode = 3405438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799027103, ExchCode = 'DUS' WHERE SecCode = 3405439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21816905223, PermQuoteStatus = 'DC', Ticker = 'S06', ExchCode = 'TDG', PermQuoteRetireDate = '2023-10-13' WHERE SecCode = 3406028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100842, ExchCode = 'DUS' WHERE SecCode = 3406462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705811, Ticker = 'TLNDN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3406524 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 21627526402.0 WHERE SecCode = 3407480 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797256348, ExchCode = 'DUS' WHERE SecCode = 3407867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21901491943, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 3408942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22170325785, ExchCode = 'DEU' WHERE SecCode = 3408943 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644149855, ExchCode = 'DEU' WHERE SecCode = 3409040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396811, ExchCode = 'FRA' WHERE SecCode = 3409090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21817679431, ExchCode = 'TDG' WHERE SecCode = 3409176 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388177, ExchCode = 'LAS' WHERE SecCode = 3409178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777397561, ExchCode = 'FRA' WHERE SecCode = 3409182 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752240759, ExchCode = 'MUN', PermQuoteRetireDate = '2023-01-23', PermSecMapEndDate = NULL WHERE SecCode = 3409186 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802292832, ExchCode = 'FRA' WHERE SecCode = 3409193 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801932188, ExchCode = 'DEU' WHERE SecCode = 3410277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807446075, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-08' WHERE SecCode = 3410283 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380013, ExchCode = 'LAS' WHERE SecCode = 3424652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845076948, ExchCode = 'DEU' WHERE SecCode = 3427817 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951377.0 WHERE SecCode = 3429345 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3430218 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3430482 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830285330, ExchCode = 'GTX' WHERE SecCode = 3430952 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21879249284, ExchCode = 'QTX', PermQuoteRetireDate = '2026-02-04', PermSecMapEndDate = '2026-03-13' WHERE SecCode = 3431060 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3431577 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3431854 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951188.0 WHERE SecCode = 3432080 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380031, ExchCode = 'LAS' WHERE SecCode = 3432164 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 3432601 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 3432656 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636049771, ExchCode = 'BER', PermQuoteRetireDate = '2018-06-28' WHERE SecCode = 3434582 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782375294, ExchCode = 'STU' WHERE SecCode = 3436849 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381246, ExchCode = 'LAS' WHERE SecCode = 3438714 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'PER' WHERE SecCode = 3438892 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642488699, ExchCode = 'TDG' WHERE SecCode = 3438919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997875, ExchCode = 'FRA' WHERE SecCode = 3439465 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788404566, ExchCode = 'QTX' WHERE SecCode = 3439533 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640560144, ExchCode = 'DEU' WHERE SecCode = 3439542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480054, ExchCode = 'QTX' WHERE SecCode = 3441171 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3441217 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727378772, ExchCode = 'BRN' WHERE SecCode = 3441556 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781520521, ExchCode = 'DUS' WHERE SecCode = 3444720 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'SRNDB' WHERE SecCode = 3445122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388252, ExchCode = 'LAS' WHERE SecCode = 3445258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644687554, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3445747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646838408, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-30', PermSecMapEndDate = NULL WHERE SecCode = 3445749 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3446015 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705440, ExchCode = 'MXQ' WHERE SecCode = 3446301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380059, ExchCode = 'LAS' WHERE SecCode = 3446352 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646071844, ExchCode = 'FRA' WHERE SecCode = 3446651 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782180687, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3446753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782181250, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21649268603, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3490821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21680653099, ExchCode = 'MUN' WHERE SecCode = 3493723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800450347, ExchCode = 'MUN' WHERE SecCode = 3495930 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388282, ExchCode = 'LAS', PermQuoteRetireDate = '2025-07-29' WHERE SecCode = 3501431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727169919, Ticker = 'NGIL', ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704965, ExchCode = 'MXQ' WHERE SecCode = 3512964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953910203, ExchCode = 'DUS' WHERE SecCode = 3513998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757505148, ExchCode = 'STU' WHERE SecCode = 3514006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705225, Ticker = 'JOBSN', ExchCode = 'MXQ' WHERE SecCode = 3518311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789434494, ExchCode = 'LAS' 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 PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 3540525 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3547833 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795072494, ExchCode = 'LAS' WHERE SecCode = 3549499 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744277118, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-22' WHERE SecCode = 3553174 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566536708, ExchCode = 'DEU' WHERE SecCode = 3557529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656850928, ExchCode = 'FRA' WHERE SecCode = 3558191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485132, Ticker = 'FT5', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 3562840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806599404, ExchCode = 'TDG', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 3569624 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21658530084, ExchCode = 'DUS' WHERE SecCode = 3572805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836535700, ExchCode = 'FRA' WHERE SecCode = 3587019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21572528792, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544783558, Ticker = '2T41', ExchCode = 'BER', PermQuoteRetireDate = '2020-08-03' WHERE SecCode = 3587041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602632389, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3588020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761303077, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3588035 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787436, ExchCode = 'DUS' WHERE SecCode = 3589051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661952428, ExchCode = 'FRA' WHERE SecCode = 3591601 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731983529, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3615233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759798879, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 3615235 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3620745 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21748602400, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-03' WHERE SecCode = 3623818 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3634429 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 3635504 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668783322, ExchCode = 'HAN' WHERE SecCode = 3642406 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 DomCntry = 'USA' WHERE SecCode = 3648205 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727384186, ExchCode = 'BIV' WHERE SecCode = 3717243 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681872326, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3754712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803135585, ExchCode = 'FRA' WHERE SecCode = 3756337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800715066, ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-02' WHERE SecCode = 3767947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690636322, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3783080 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3787386 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951813.0 WHERE SecCode = 3789372 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951488.0 WHERE SecCode = 3796468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21733938467, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-05', PermSecMapEndDate = NULL WHERE SecCode = 3806448 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 3809725 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 3818199 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21693548553, ExchCode = 'DEU' WHERE SecCode = 3821931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789659513, PermQuoteStatus = 'AC', Ticker = '2ZT1', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3841485 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermQuoteRetireDate = NULL WHERE SecCode = 3841486 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21744919357, ExchCode = 'DEU', PermQuoteRetireDate = '2024-02-14' WHERE SecCode = 3847122 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951388.0 WHERE SecCode = 3847123 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21841147970, ExchCode = 'TDG' WHERE SecCode = 3848225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858452393, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3849234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888021879, ExchCode = 'GTX' WHERE SecCode = 3852867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938950149, Ticker = 'UPRl', ExchCode = 'BCO' WHERE SecCode = 3883708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702475114, ExchCode = 'FRA' WHERE SecCode = 3886781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702467501, ExchCode = 'DEU' WHERE SecCode = 3886782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830284409, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3899638 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168601313, ExchCode = 'DEU' WHERE SecCode = 3913159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729404094, ExchCode = 'STU' WHERE SecCode = 3921329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478423, ExchCode = 'QTX' WHERE SecCode = 3936141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711930903, ExchCode = 'FRA' WHERE SecCode = 3958735 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3986739 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 3991810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720001076, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4001067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011913, Ticker = '2AAL' WHERE SecCode = 4031774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011911, Ticker = '2AA' WHERE SecCode = 4031777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026920, Ticker = '1MAR' WHERE SecCode = 4031937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000143822, Ticker = '2UCB', ExchCode = 'MIL' WHERE SecCode = 4032109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999010953, Ticker = '2ACS' WHERE SecCode = 4032115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011967, Ticker = '2DD' WHERE SecCode = 4032277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388381, ExchCode = 'LAS' WHERE SecCode = 4079321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21730198054, Ticker = 'ZWIPE', ExchCode = 'STO', PermQuoteRetireDate = '2025-03-07' WHERE SecCode = 4079329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781158017, ExchCode = 'STU' WHERE SecCode = 4080599 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4087374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782582943, ExchCode = 'QTX' WHERE SecCode = 4101141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587301011, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2020-04-14' WHERE SecCode = 4103598 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21737082360, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4109380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951941315, Ticker = '49Y0', ExchCode = 'QTX', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388439, ExchCode = 'LAS' WHERE SecCode = 4124714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21868559772, ExchCode = 'QTX' WHERE SecCode = 4169151 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21739433458, ExchCode = 'DEU' WHERE SecCode = 4178604 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625622942, ExchCode = 'DEU' WHERE SecCode = 4188130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667482768, ExchCode = 'QTX' WHERE SecCode = 4188457 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735328851, ExchCode = 'STU' WHERE SecCode = 4196900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746674674, ExchCode = 'DEU' WHERE SecCode = 4204825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958582, ExchCode = 'FRA' WHERE SecCode = 4209245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958647, ExchCode = 'FRA' WHERE SecCode = 4209246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958373, ExchCode = 'FRA' WHERE SecCode = 4209247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759488857, ExchCode = 'STU' WHERE SecCode = 4209695 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012792, Ticker = '2HCA' WHERE SecCode = 4214370 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4220049 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750196970, ExchCode = 'MUN' WHERE SecCode = 4225963 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4226180 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679079, ExchCode = 'BIV' WHERE SecCode = 4226196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727349456, ExchCode = 'MEX' WHERE SecCode = 4228288 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749841407, ExchCode = 'FRA' WHERE SecCode = 4228324 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752139678, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4240637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752244343, ExchCode = 'TDG' WHERE SecCode = 4240638 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapStartDate = '2026-05-04', PermSecMapEndDate = NULL WHERE SecCode = 4243424 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754377772, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4243768 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21752408872, ExchCode = 'FRA' WHERE SecCode = 4248820 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 4251166 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754379229, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4253036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754534014, ExchCode = 'TDG' WHERE SecCode = 4256876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754534208, PermQuoteStatus = 'AC', Ticker = '0YL0', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4259224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754534080, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-07', PermSecMapEndDate = '2023-11-07' WHERE SecCode = 4259226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727349639, ExchCode = 'BIV' WHERE SecCode = 4259231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756148826, ExchCode = 'MXQ' WHERE SecCode = 4273980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756547830, ExchCode = 'DEU' WHERE SecCode = 4275166 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757668911, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4282400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759098748, ExchCode = 'FRA' WHERE SecCode = 4291265 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951875.0 WHERE SecCode = 4291603 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 4294153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786680756, ExchCode = 'FRA' WHERE SecCode = 4294160 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951550.0 WHERE SecCode = 4295603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21699218038, ExchCode = 'FRA' WHERE SecCode = 4298602 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22159899270, ExchCode = 'DEU' WHERE SecCode = 4298603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21696686071, ExchCode = 'STU' WHERE SecCode = 4298604 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720132349, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4298606 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679461, ExchCode = 'BIV' WHERE SecCode = 4298620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759524962, ExchCode = 'FRA' WHERE SecCode = 4298644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760599386, ExchCode = 'FRA' WHERE SecCode = 4303570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760599450, ExchCode = 'FRA' WHERE SecCode = 4303583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760292838, ExchCode = 'MUN' WHERE SecCode = 4303589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759488721, ExchCode = 'STU' WHERE SecCode = 4303635 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761647098, ExchCode = 'DUS' WHERE SecCode = 4309050 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295374, ExchCode = 'GTX' WHERE SecCode = 4310575 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-16' WHERE SecCode = 4320782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842459237, ExchCode = 'HAN' WHERE SecCode = 4321331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763690130, ExchCode = 'QTX' WHERE SecCode = 4321393 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21709366460, ExchCode = 'BIV' WHERE SecCode = 4324371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727341342, ExchCode = 'BIV' WHERE SecCode = 4324380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4326990 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05' WHERE SecCode = 4339225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21867342843, ExchCode = 'TDG' WHERE SecCode = 4346668 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4359806 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 4360064 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21700183761, ExchCode = 'MEX' WHERE SecCode = 4362644 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 4369901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780538206, ExchCode = 'GTX' WHERE SecCode = 4372740 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21773606760, ExchCode = 'DEU' WHERE SecCode = 4375237 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781510674, ExchCode = 'QTX' WHERE SecCode = 4375238 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783391809, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4380746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776870599, ExchCode = 'FRA' WHERE SecCode = 4380751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21738812998, ExchCode = 'DUS' WHERE SecCode = 4383309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740524, ExchCode = 'LAS' WHERE SecCode = 4388200 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777647867, ExchCode = 'TDG' WHERE SecCode = 4402301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785622125, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4415732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727304579, ExchCode = 'BIV' WHERE SecCode = 4421213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782664057, ExchCode = 'DEU', PermQuoteRetireDate = '2024-10-31', PermSecMapEndDate = '2024-10-31' WHERE SecCode = 4422563 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21775216637, ExchCode = 'TDG' WHERE SecCode = 4422567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797999132, ExchCode = 'FRA' WHERE SecCode = 4423904 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727312259, ExchCode = 'MEX' WHERE SecCode = 4424570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307218, ExchCode = 'BIV' WHERE SecCode = 4426954 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21783652671, ExchCode = 'DEU' WHERE SecCode = 4426955 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793394138, ExchCode = 'STU' WHERE SecCode = 4429683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785087297, ExchCode = 'FRA' WHERE SecCode = 4434390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785453356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4436991 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794740612, ExchCode = 'LAS' WHERE SecCode = 4449679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818250497, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4449683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788456990, ExchCode = 'FRA' WHERE SecCode = 4451258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788456777, ExchCode = 'DEU' WHERE SecCode = 4451259 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791908410, ExchCode = 'TDG' WHERE SecCode = 4451262 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 4456052 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 4456112 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4456372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367131, ExchCode = 'FRA' WHERE SecCode = 4463145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21792098251, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4466620 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4468591 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793399825, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4470175 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797398508, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4470353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396601, ExchCode = 'FRA' WHERE SecCode = 4472926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100521, ExchCode = 'QTX', PermQuoteRetireDate = '2024-06-25' WHERE SecCode = 4472931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830307201, ExchCode = 'GTX' WHERE SecCode = 4474245 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386726, ExchCode = 'LAS' WHERE SecCode = 4474387 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795367200, ExchCode = 'DEU' WHERE SecCode = 4482720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796645883, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-05' WHERE SecCode = 4489240 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799698913, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4502498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955560981, ExchCode = 'QTX' WHERE SecCode = 4511502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21801287200, ExchCode = 'STU' WHERE SecCode = 4517642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851345480, ExchCode = 'GTX' WHERE SecCode = 4526144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21890670000, PermQuoteStatus = 'DC', ExchCode = 'GTX', PermQuoteRetireDate = '2025-10-27' WHERE SecCode = 4527883 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781627749, ExchCode = 'QTX' WHERE SecCode = 4527891 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951550.0 WHERE SecCode = 4534774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809121292, Ticker = '0RW', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-22', PermSecMapEndDate = '2025-04-11' WHERE SecCode = 4536360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803771918, ExchCode = 'DEU' WHERE SecCode = 4536450 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802587261, ExchCode = 'STU' WHERE SecCode = 4536481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727301440, ExchCode = 'MEX' WHERE SecCode = 4547978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727271946, ExchCode = 'BIV' WHERE SecCode = 4549301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21812165966, ExchCode = 'STU' WHERE SecCode = 4553829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806812473, ExchCode = 'DEU' WHERE SecCode = 4557784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823056706, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = NULL WHERE SecCode = 4557926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381354, ExchCode = 'LAS' WHERE SecCode = 4557929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811019112, ExchCode = 'TDG' WHERE SecCode = 4576474 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4582740 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811992005, ExchCode = 'FRA' WHERE SecCode = 4586561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810406482, ExchCode = 'FRA' WHERE SecCode = 4586633 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 4588483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21815153830, ExchCode = 'FRA' WHERE SecCode = 4603534 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951388.0 WHERE SecCode = 4612240 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380579, ExchCode = 'LAS' WHERE SecCode = 4617716 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 4618150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 4621029 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4623166 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779442609, ExchCode = 'EQD', PermQuoteRetireDate = '2024-10-22' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778281505, ExchCode = 'DUS' WHERE SecCode = 4632109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823963642, ExchCode = 'STU' WHERE SecCode = 4635203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859334921, ExchCode = 'DEU' WHERE SecCode = 4643318 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-04' WHERE SecCode = 4650985 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21832850871, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4651786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381815, ExchCode = 'LAS' WHERE SecCode = 4658662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21832260332, ExchCode = 'FRA' WHERE SecCode = 4658888 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831914397, ExchCode = 'STU' WHERE SecCode = 4671286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388764, ExchCode = 'LAS' WHERE SecCode = 4676228 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795845914, ExchCode = 'TDG' WHERE SecCode = 4680383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167619187, Ticker = 'CARBm', ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727293349, ExchCode = 'BIV' WHERE SecCode = 4699231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011348, Ticker = '2STX' WHERE SecCode = 4699232 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21840890126, ExchCode = 'DEU' WHERE SecCode = 4709618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842933392, ExchCode = 'DEU' WHERE SecCode = 4716089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777568050, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-12-19' WHERE SecCode = 4716090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843915272, ExchCode = 'STU' WHERE SecCode = 4718902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799043657, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4720517 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843597933, ExchCode = 'DEU' WHERE SecCode = 4722188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794769101, PermQuoteStatus = 'DC', ExchCode = 'LAS', PermQuoteRetireDate = '2025-12-04' WHERE SecCode = 4724684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845533132, ExchCode = 'GTX' WHERE SecCode = 4724688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845076827, ExchCode = 'DEU' WHERE SecCode = 4724746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799954980, ExchCode = 'LAS' WHERE SecCode = 4727660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851345464, ExchCode = 'STU' WHERE SecCode = 4733055 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 4741129 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 4751204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853235597, ExchCode = 'STU' WHERE SecCode = 4756369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388646, ExchCode = 'LAS' WHERE SecCode = 4761545 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21909689585, ExchCode = 'DXE' WHERE SecCode = 4761548 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22165249368, ExchCode = 'BTE' WHERE SecCode = 4761550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854186426, ExchCode = 'DEU' WHERE SecCode = 4761589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854914847, PermQuoteStatus = 'AC', Ticker = '3FNG', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4767862 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552670, ExchCode = 'LAS' WHERE SecCode = 4773769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830085, ExchCode = 'QTX' WHERE SecCode = 4775201 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857633448, ExchCode = 'QTX' WHERE SecCode = 4781733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21961970528, ExchCode = 'MUN' WHERE SecCode = 4794550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861191996, Ticker = 'CON3', ExchCode = 'LSE' WHERE SecCode = 4806678 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21866365601, ExchCode = 'DEU' WHERE SecCode = 4813578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21880186249, ExchCode = 'QTX', PermQuoteRetireDate = '2023-11-06' WHERE SecCode = 4815315 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804716445, ExchCode = 'HAM' WHERE SecCode = 4815349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863513304, ExchCode = 'DEU' WHERE SecCode = 4818264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781684876, ExchCode = 'QTX' WHERE SecCode = 4818275 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865900341, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4819644 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 4830791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580163, ExchCode = 'GER' WHERE SecCode = 4834791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580240, ExchCode = 'GER' WHERE SecCode = 4834792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886398298, ExchCode = 'GER', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 4834793 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888954019, ExchCode = 'MUN', PermQuoteRetireDate = '2022-08-19', PermSecMapEndDate = NULL WHERE SecCode = 4845029 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888953971, ExchCode = 'MUN', PermQuoteRetireDate = '2023-04-17' WHERE SecCode = 4845030 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580736, ExchCode = 'GER' WHERE SecCode = 4845032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21871056172, ExchCode = 'MUN' WHERE SecCode = 4845045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951823.0 WHERE SecCode = 4847018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580567, ExchCode = 'DEU' WHERE SecCode = 4850978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 4850979 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387394, ExchCode = 'LAS' WHERE SecCode = 4857302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388723, ExchCode = 'LAS' WHERE SecCode = 4868662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21876129773, Ticker = '9XK0', ExchCode = 'QTX', PermQuoteRetireDate = '2024-03-21' WHERE SecCode = 4873803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21876129776, ExchCode = 'QTX' WHERE SecCode = 4885603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959379953, ExchCode = 'TDG' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874656832, ExchCode = 'DEU' WHERE SecCode = 4889264 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951201.0 WHERE SecCode = 4890352 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4903983 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21880715135, ExchCode = 'QTX' WHERE SecCode = 4927268 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882167707, PermQuoteStatus = 'AC', Ticker = 'Y232', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4934325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380552, ExchCode = 'LAS' WHERE SecCode = 4940672 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781980293, PermQuoteStatus = 'DC', Ticker = '62U1', ExchCode = 'BER', PermQuoteRetireDate = '2025-09-01' WHERE SecCode = 4943250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884962075, ExchCode = 'STU' WHERE SecCode = 4946106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 PriTRBCIndPermID = 4294951201.0 WHERE SecCode = 4969375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887686666, PermQuoteStatus = 'AC', Ticker = 'WATT', ExchCode = 'MIL', PermQuoteRetireDate = NULL WHERE SecCode = 4969407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419011, ExchCode = 'LAS' WHERE SecCode = 4969490 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902368752, ExchCode = 'STU' WHERE SecCode = 4973332 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 = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21980198448, ExchCode = 'FRA' WHERE SecCode = 5011657 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387447, ExchCode = 'LAS' WHERE SecCode = 5011663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805995535, ExchCode = 'FRA' WHERE SecCode = 5031899 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21898852880, ExchCode = 'FRA' WHERE SecCode = 5041758 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 5059329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777507074, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-08' WHERE SecCode = 5063516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902617420, ExchCode = 'DEU' WHERE SecCode = 5067289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21872147438, ExchCode = 'MXQ' WHERE SecCode = 5067670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21903664236, ExchCode = 'FRA' WHERE SecCode = 5072164 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045076711, ExchCode = 'LAS' WHERE SecCode = 5072165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21903663662, ExchCode = 'DEU' WHERE SecCode = 5072166 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380635, ExchCode = 'LAS' WHERE SecCode = 5082547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21912121144, ExchCode = 'FRA' WHERE SecCode = 5130680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916915441, ExchCode = 'FRA' WHERE SecCode = 5147805 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 = 21830273208, ExchCode = 'GTX' WHERE SecCode = 5161225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843186265, Ticker = '0A60l', ExchCode = 'BCO' WHERE SecCode = 5161244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21730598077, ExchCode = 'FRA' WHERE SecCode = 5161282 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756093175, ExchCode = 'QTX' WHERE SecCode = 5161303 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5161317 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21633620943, Ticker = '0IL1', ExchCode = 'LSE' WHERE SecCode = 5161361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727344849, ExchCode = 'BIV' WHERE SecCode = 5161363 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387325, ExchCode = 'LAS' WHERE SecCode = 5161371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21924150711, ExchCode = 'STU' WHERE SecCode = 5161403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550581300, ExchCode = 'TDG' WHERE SecCode = 5161404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954642019, ExchCode = 'QTX' WHERE SecCode = 5162437 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 5166512 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173433, ExchCode = 'BIV' WHERE SecCode = 5168285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955191864, ExchCode = 'DUS' WHERE SecCode = 5174473 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 5207903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794004180, ExchCode = 'QTX' WHERE SecCode = 5239813 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 5241270 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 = 236787664879, ExchCode = 'QTX' WHERE SecCode = 5253719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21936132731, ExchCode = 'DEU' WHERE SecCode = 5258611 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938339192, ExchCode = 'MUN' WHERE SecCode = 5258620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381670, ExchCode = 'LAS' WHERE SecCode = 5277532 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'WF8' WHERE SecCode = 5288745 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 5290321 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778803327, ExchCode = 'DUS' WHERE SecCode = 5297998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727198673, ExchCode = 'BIV' WHERE SecCode = 5301207 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 5301614 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943068314, ExchCode = 'DEU' WHERE SecCode = 5301896 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953922612, ExchCode = 'GTX', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = '2025-08-06' WHERE SecCode = 5311845 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792486000, ExchCode = 'BIV' WHERE SecCode = 5323925 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21947053585, ExchCode = 'DEU' WHERE SecCode = 5324085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951358875, PermQuoteStatus = 'AC', Ticker = '3QP', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5324087 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775962843, ExchCode = 'BIV' WHERE SecCode = 5328418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775962850, ExchCode = 'BIV' WHERE SecCode = 5328421 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 5329474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781581879, ExchCode = 'QTX' WHERE SecCode = 5338742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853633841, ExchCode = 'FRA' WHERE SecCode = 5347222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21952832311, ExchCode = 'STU' WHERE SecCode = 5347429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21952626860, ExchCode = 'FRA', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 5347430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21952832380, ExchCode = 'FRA' WHERE SecCode = 5350576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953910298, ExchCode = 'MUN' WHERE SecCode = 5354973 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5357733 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5360843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782487235, ExchCode = 'FRA' WHERE SecCode = 5374858 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21958059866, ExchCode = 'FRA' WHERE SecCode = 5374941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727195024, ExchCode = 'BIV' WHERE SecCode = 5381947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21959716964, ExchCode = 'DEU' WHERE SecCode = 5383598 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 5384434 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21962356959, ExchCode = 'DEU' WHERE SecCode = 5395767 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5403085 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 5411329 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 5422625 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21977157931, ExchCode = 'DEU' WHERE SecCode = 5468673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818729828, ExchCode = 'FRA' WHERE SecCode = 5478214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778437243, ExchCode = 'MEX' WHERE SecCode = 5482856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834837, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503720 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953657244, ExchCode = 'MXQ' WHERE SecCode = 5503860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823760, ExchCode = 'AQX' WHERE SecCode = 5503898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663650, Ticker = 'ARK3l', ExchCode = 'AQX' WHERE SecCode = 5503901 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5521892 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5521893 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787393619, ExchCode = 'TDG' WHERE SecCode = 5523278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167619181, ExchCode = 'BTE' WHERE SecCode = 5526345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779292324, ExchCode = 'FRA' WHERE SecCode = 5527560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779292327, ExchCode = 'FRA' WHERE SecCode = 5527561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831436884, Ticker = 'SFTG', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5534997 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834912, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834847, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5535008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471348, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5541732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419116, ExchCode = 'LAS' WHERE SecCode = 5547972 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932421397, PermQuoteStatus = 'AC', Ticker = '3LALm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835780, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151033, PermQuoteStatus = 'AC', Ticker = '3FNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5569246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034589, ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-30' WHERE SecCode = 5569318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970293165, ExchCode = 'MUN' WHERE SecCode = 5569360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933110915, Ticker = '3MRNm', ExchCode = 'BCO' WHERE SecCode = 5569367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779979307, ExchCode = 'FRA', PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 5577509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22152999678, Ticker = 'NGLSl', ExchCode = 'AQX' WHERE SecCode = 5584733 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5604444 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727212166, ExchCode = 'BIV' WHERE SecCode = 5604481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173432, ExchCode = 'BIV' WHERE SecCode = 5628244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780942899, ExchCode = 'BIV' WHERE SecCode = 5631516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782375294, ExchCode = 'STU' WHERE SecCode = 5638703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595966434, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-12' WHERE SecCode = 5638827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727307748, ExchCode = 'BIV' WHERE SecCode = 5658305 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 = 236781343894, ExchCode = 'TDG' WHERE SecCode = 5663580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781858187, ExchCode = 'FRA' WHERE SecCode = 5679100 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22020600429, ExchCode = 'DEU' WHERE SecCode = 5687957 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 5693827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782254675, ExchCode = 'FRA' WHERE SecCode = 5710467 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 5710690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782563848, ExchCode = 'FRA' WHERE SecCode = 5722406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782653830, ExchCode = 'FRA' WHERE SecCode = 5731414 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799652775, ExchCode = 'LAS' WHERE SecCode = 5740795 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031489244, Ticker = 'SOXL', ExchCode = 'MIL' WHERE SecCode = 5740824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031488834, Ticker = 'MAG7', ExchCode = 'MIL' WHERE SecCode = 5740826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22119690931, ExchCode = 'BTE' WHERE SecCode = 5740827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031488954, Ticker = 'SMCI', ExchCode = 'MIL' WHERE SecCode = 5740830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22153246029, ExchCode = 'CHI' WHERE SecCode = 5740832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772643122, ExchCode = 'FRA' WHERE SecCode = 5740839 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 5749886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22154585726, Ticker = 'WXBTl', ExchCode = 'CHI' WHERE SecCode = 5782798 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802914265, Ticker = 'RZ8B', ExchCode = 'STU' WHERE SecCode = 5782810 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951488.0 WHERE SecCode = 5782811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801851316, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5782813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22040670142, ExchCode = 'GTX' WHERE SecCode = 5785805 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22037308993, ExchCode = 'DEU' WHERE SecCode = 5786123 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22037302983, ExchCode = 'DEU' WHERE SecCode = 5786125 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783782319, ExchCode = 'STU' WHERE SecCode = 5786132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783963980, ExchCode = 'STU' WHERE SecCode = 5786133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785534609, ExchCode = 'QTX' WHERE SecCode = 5786134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799955012, ExchCode = 'LAS' WHERE SecCode = 5804329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776608793, ExchCode = 'MEX' WHERE SecCode = 5816988 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22042870510, ExchCode = 'DEU' WHERE SecCode = 5817022 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784236560, ExchCode = 'STU' WHERE SecCode = 5822326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784236496, ExchCode = 'FRA' WHERE SecCode = 5822327 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787198171, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5827163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785264814, ExchCode = 'FRA' WHERE SecCode = 5827164 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22044538463, ExchCode = 'DEU' WHERE SecCode = 5827165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784357764, ExchCode = 'MEX' WHERE SecCode = 5836309 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 5839222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031122900, Ticker = 'CO3Sl', ExchCode = 'BCO' WHERE SecCode = 5839249 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784600489, ExchCode = 'STU' WHERE SecCode = 5839460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22046913642, ExchCode = 'DEU' WHERE SecCode = 5839461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784600488, ExchCode = 'STU' WHERE SecCode = 5839464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601376, ExchCode = 'STU' WHERE SecCode = 5839466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22046913691, ExchCode = 'DEU' WHERE SecCode = 5839467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601266, ExchCode = 'FRA' WHERE SecCode = 5842621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601265, ExchCode = 'FRA' WHERE SecCode = 5842622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784601263, ExchCode = 'FRA' WHERE SecCode = 5842623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785217080, ExchCode = 'STU' WHERE SecCode = 5871394 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22053017262, ExchCode = 'DEU' WHERE SecCode = 5886926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22053017645, ExchCode = 'DEU' WHERE SecCode = 5886927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785412345, ExchCode = 'MUN' WHERE SecCode = 5886928 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786090195, ExchCode = 'STU' WHERE SecCode = 5886944 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951488.0 WHERE SecCode = 5893212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22061950077, ExchCode = 'DEU' WHERE SecCode = 5936516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798426612, ExchCode = 'GTX' WHERE SecCode = 5947065 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786839717, ExchCode = 'STU' WHERE SecCode = 5947076 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951582651, ExchCode = 'MXQ' WHERE SecCode = 5958705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799223628, ExchCode = 'TRQ' WHERE SecCode = 5959461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793448736, ExchCode = 'TDG' WHERE SecCode = 5969012 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788075088, ExchCode = 'FRA' WHERE SecCode = 5978470 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787589834, ExchCode = 'MUN' WHERE SecCode = 5978474 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22089452738, Ticker = 'MST3d', ExchCode = 'CHI' WHERE SecCode = 5999093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22071047085, ExchCode = 'FRA' WHERE SecCode = 5999095 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22071786786, ExchCode = 'QTX' WHERE SecCode = 5999096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22071046984, ExchCode = 'GER' WHERE SecCode = 5999098 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951930.0 WHERE SecCode = 5999157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788245572, ExchCode = 'DUS' WHERE SecCode = 6010815 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782564342, ExchCode = 'BIV' WHERE SecCode = 6032854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788962501, Ticker = '1HUT', ExchCode = 'MIL' WHERE SecCode = 6047903 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21571976516, ExchCode = 'BEC' WHERE SecCode = 6095641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22083162878, ExchCode = 'DEU' WHERE SecCode = 6095673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22127566762, ExchCode = 'TDG' WHERE SecCode = 6097270 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151005, Ticker = 'FTNE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 6097285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705800, ExchCode = 'MXQ' WHERE SecCode = 6097292 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834880, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970308382, ExchCode = 'BCO' WHERE SecCode = 6097325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045078190, ExchCode = 'LAS' WHERE SecCode = 6097334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22030766403, ExchCode = 'BTE' WHERE SecCode = 6097336 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22016170429, PermQuoteStatus = 'DC', Ticker = 'SCO3', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 6097382 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21836309872, Ticker = '3SPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 6097408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22031488954, Ticker = 'SMCI', ExchCode = 'MIL' WHERE SecCode = 6097447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727354555, ExchCode = 'MEX' WHERE SecCode = 6097578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663670, ExchCode = 'AQX' WHERE SecCode = 6097580 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 6137613 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797408472, ExchCode = 'STU' WHERE SecCode = 6147594 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791287038, ExchCode = 'FRA' WHERE SecCode = 6190705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22094064244, ExchCode = 'DEU' WHERE SecCode = 6197566 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792959667, ExchCode = 'STU' WHERE SecCode = 6204567 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22133181713, Ticker = 'BTCE', ExchCode = 'SWX' WHERE SecCode = 6245909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782181395, ExchCode = 'MEX' WHERE SecCode = 6256406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22150315636, ExchCode = 'DEU' WHERE SecCode = 6256407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21734886875, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745957943, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 6256412 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780909392, PermQuoteStatus = 'AC', Ticker = '2IU1', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6256420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917823991, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256440 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 6258500 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792340963, ExchCode = 'DUS' WHERE SecCode = 6270465 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 6281777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22109402118, ExchCode = 'DEU' WHERE SecCode = 6310331 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'MYS' WHERE SecCode = 6318870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21748074425, ExchCode = 'MUN' WHERE SecCode = 6325196 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 6341712 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951214.0 WHERE SecCode = 6361848 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793828558, ExchCode = 'STU' WHERE SecCode = 6368981 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806228183, ExchCode = 'TDG' WHERE SecCode = 6371577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793934079, ExchCode = 'TDG' WHERE SecCode = 6371578 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951214.0 WHERE SecCode = 6377085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794542874, ExchCode = 'BIV' WHERE SecCode = 6416397 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22122679002, ExchCode = 'DEU' WHERE SecCode = 6416433 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451414, ExchCode = 'BTE' WHERE SecCode = 6456368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142157927, ExchCode = 'BTE' WHERE SecCode = 6456369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22152233865, ExchCode = 'AQX' WHERE SecCode = 6456371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142157937, ExchCode = 'BTE' WHERE SecCode = 6456372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22141703185, ExchCode = 'BTE' WHERE SecCode = 6456373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451415, ExchCode = 'BTE' WHERE SecCode = 6456374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22141447615, ExchCode = 'BTE' WHERE SecCode = 6456375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142157950, ExchCode = 'BTE' WHERE SecCode = 6456376 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451405, ExchCode = 'BTE' WHERE SecCode = 6456377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22141703178, ExchCode = 'BTE' WHERE SecCode = 6456420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451420, ExchCode = 'CHI' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804778697, ExchCode = 'TDG' WHERE SecCode = 6464980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797938208, ExchCode = 'FRA' WHERE SecCode = 6518574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797938213, ExchCode = 'FRA' WHERE SecCode = 6518575 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797938212, ExchCode = 'FRA' WHERE SecCode = 6518576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797938214, ExchCode = 'FRA' WHERE SecCode = 6518577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798105812, ExchCode = 'QTX' WHERE SecCode = 6520702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798462190, ExchCode = 'GTX' WHERE SecCode = 6541041 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 6548131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798768097, ExchCode = 'DUS' WHERE SecCode = 6548155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799207727, ExchCode = 'MUN' WHERE SecCode = 6554915 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236806467614.0, PermSecMapStartDate = '2025-11-18' WHERE SecCode = 6562602 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6589128 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 6617616 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 6622347 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801075200, IsPrimaryQuote = 1, PermQuoteStatus = 'DC', Ticker = 'LSSNV', ExchCode = 'PAR', PermQuoteRetireDate = '2026-05-04' WHERE SecCode = 6622348 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802430458, ExchCode = 'DEU' WHERE SecCode = 6626587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22152236620, ExchCode = 'DEU' WHERE SecCode = 6627152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22152237029, ExchCode = 'DEU' WHERE SecCode = 6627153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22152242301, ExchCode = 'DEU' WHERE SecCode = 6627155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794616564, ExchCode = 'TDG' WHERE SecCode = 6628842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172087694, ExchCode = 'FRA' WHERE SecCode = 6638013 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802471843, ExchCode = 'DUS' WHERE SecCode = 6642929 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 6649306 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951214.0 WHERE SecCode = 6649307 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951214.0 WHERE SecCode = 6649308 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802872782, ExchCode = 'FRA' WHERE SecCode = 6658380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801974003, ExchCode = 'FRA' WHERE SecCode = 6661570 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 6705485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804071834, ExchCode = 'FRA' WHERE SecCode = 6708286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804071829, ExchCode = 'FRA' WHERE SecCode = 6708287 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804072209, ExchCode = 'FRA' WHERE SecCode = 6708288 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804071960, ExchCode = 'FRA' WHERE SecCode = 6708289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804072208, ExchCode = 'FRA' WHERE SecCode = 6708290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804072212, ExchCode = 'FRA' WHERE SecCode = 6708292 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792996715, ExchCode = 'LAS' WHERE SecCode = 6712480 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804778696, ExchCode = 'MUN' WHERE SecCode = 6721535 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339217, Ticker = 'DDUM', ExchCode = 'LSE' WHERE SecCode = 6727855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804483809, ExchCode = 'QTX' WHERE SecCode = 6727870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22175073961, ExchCode = 'STU' WHERE SecCode = 6727920 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804536389, ExchCode = 'FRA', PriTRBCIndPermID = 4294951914.0 WHERE SecCode = 6728364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804536392, ExchCode = 'FRA' WHERE SecCode = 6728365 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-05-04' WHERE SecCode = 6737828 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804998607, ExchCode = 'QTX' WHERE SecCode = 6737926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805530357, ExchCode = 'MUN' WHERE SecCode = 6737927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22168605391, ExchCode = 'DEU' WHERE SecCode = 6737928 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795337244, ExchCode = 'MEX' WHERE SecCode = 6741058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805232356, ExchCode = 'FRA' WHERE SecCode = 6756491 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22170639813, ExchCode = 'DEU' WHERE SecCode = 6756496 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22170639977, ExchCode = 'DEU' WHERE SecCode = 6756497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22170653580, ExchCode = 'DEU' WHERE SecCode = 6756501 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805699078, ExchCode = 'TDG' WHERE SecCode = 6756502 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6765362 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799956057, ExchCode = 'FRA' WHERE SecCode = 6773256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805901582, ExchCode = 'BTE' WHERE SecCode = 6779523 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172748632, ExchCode = 'DEU' WHERE SecCode = 6779525 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 6793359 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6793550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22094841699, ExchCode = 'TDG' WHERE SecCode = 6796811 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 6796818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791406431, ExchCode = 'MEX' WHERE SecCode = 6797364 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'AMBAAUTO' WHERE SecCode = 6806165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806409996, ExchCode = 'FRA' WHERE SecCode = 6820242 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 10773013 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951980.0 WHERE SecCode = 10900997 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10901069 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 10902812 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 10911494 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 10925336 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 10933004 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ISR' WHERE SecCode = 11005254 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11006190 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11014866 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11023815 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11033963 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-04' WHERE SecCode = 11046923 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 11056454 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951332.0 WHERE SecCode = 11059132 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 11109689 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11111000 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951559.0 WHERE SecCode = 11133365 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11140993 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11142190 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11144171 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 11148547 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11149466 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11149514 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 11149565 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-16' WHERE SecCode = 11153361 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11153443 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 11155526 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11163321 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11178183 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11186707 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11186768 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11193133 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 11195367 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11195932 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 11196231 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11196578 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 11196932 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 11196933 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951617.0 WHERE SecCode = 11199112 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11213416 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 11213680 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 11215250 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11216101 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-05-06' WHERE SecCode = 11218773 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11219879 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 11220339 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11221146 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11221982 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 11222359 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11223968 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11224331 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 11225117 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951875.0 WHERE SecCode = 11225688 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951201.0 WHERE SecCode = 11226406 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11227595 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11229567 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11246642 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 11250258 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 11257015 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 11257436 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11258993 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 11259574 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 11259629 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11260506 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951798.0 WHERE SecCode = 11261801 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'IPTND', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11261939 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11262534 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11262535 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11263502 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11269908 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'SLCNF' WHERE SecCode = 11271927 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11277444 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 11280405 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951214.0 WHERE SecCode = 11280667 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11287500 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11287501 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11287504 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11287719 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11287721 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11287723 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11287726 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 11288867 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951214.0 WHERE SecCode = 11288994 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291316 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291318 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291320 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291323 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291327 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291328 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291331 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291338 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11291339 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11291473 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11291474 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11291477 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11291520 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11291524 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11291526 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', PermSecMapEndDate = '2026-05-05' WHERE SecCode = 11292705 AND Type_ = 1; UPDATE data_universe_permid SET PriInstrPermID = 232923523003.0 WHERE SecCode = 11293243 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11294022 AND Type_ = 1;