UPDATE data_universe_permid SET QuotePermID = 55847137216, Ticker = 'ABBY.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 24 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 2507 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25591 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25593 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25595 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25596 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25597 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25598 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25599 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25600 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25601 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25602 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25603 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25604 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25605 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25606 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 25607 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 29787 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 PermOrgIPODate = NULL WHERE SecCode = 32536 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 33290 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475033744, PermQuoteStatus = 'AC', Ticker = 'AMD', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 34385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475562064, PermQuoteStatus = 'DC', Ticker = 'AEC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 36029 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 36927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859213205, ExchCode = 'FRA', PermQuoteRetireDate = '2012-06-26' WHERE SecCode = 37893 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'QVCGQ' WHERE SecCode = 42293 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21532854931, ExchCode = 'AQX' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474913868, Ticker = 'MACO', ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475624203, Ticker = 'SCXG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 46239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838238293, ExchCode = 'MUN' WHERE SecCode = 46294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850939324, ExchCode = 'BER' WHERE SecCode = 46302 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 46582 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 46584 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836582583, ExchCode = 'FRA' WHERE SecCode = 48131 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475801256, Ticker = 'MKAd', ExchCode = 'SIG' WHERE SecCode = 48328 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 51449 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-18' WHERE SecCode = 53563 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236801607800, ExchCode = 'MUN' WHERE SecCode = 53597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633835934, Ticker = 'STFd', ExchCode = 'BCO' WHERE SecCode = 57832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641483764, ExchCode = 'STU' WHERE SecCode = 57850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475609715, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = '2004-10-01' WHERE SecCode = 57884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737759339, ExchCode = 'FRA' WHERE SecCode = 57889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21484713079, ExchCode = 'STU' WHERE SecCode = 58060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475745773, ExchCode = 'STU' WHERE SecCode = 58064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327177, ExchCode = 'BER', PermQuoteRetireDate = '2020-08-10' WHERE SecCode = 58140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474860403, ExchCode = 'DEU' WHERE SecCode = 58245 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 59374 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 59793 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 59794 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541368040, ExchCode = 'STU' WHERE SecCode = 61380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781938162, ExchCode = 'GTX' WHERE SecCode = 62212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856722233, ExchCode = 'MUN', PermQuoteRetireDate = '2023-01-05', PermSecMapEndDate = '2023-01-05' WHERE SecCode = 62512 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 70784 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5063245103, PriInstrPermID = NULL, IsPrimaryInstr = 0, IncCntry = 'HKG', PermOrgIPODate = NULL WHERE SecCode = 71995 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-11' WHERE SecCode = 83170 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 85178 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 98639 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 22128769414, ExchCode = 'DEU' WHERE SecCode = 100032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490953, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-20' WHERE SecCode = 100052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781756532, ExchCode = 'MUN' WHERE SecCode = 112548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298416, ExchCode = 'DEU' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381737, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823487855, ExchCode = 'DUS' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419464, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 122066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957764680, ExchCode = 'FRA' WHERE SecCode = 131976 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 132466 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 4297985723, OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951721.0 WHERE SecCode = 135487 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 141455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174126935, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-17', PermSecMapEndDate = NULL WHERE SecCode = 141999 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'CNTL' WHERE SecCode = 146022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336107, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 172773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617037034, ExchCode = 'FRA' WHERE SecCode = 172982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836451661, ExchCode = 'FRA', PermQuoteRetireDate = '2013-07-03' WHERE SecCode = 172995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332251, ExchCode = 'BER', PermQuoteRetireDate = '2023-08-01' WHERE SecCode = 172998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134573, ExchCode = 'TDG' WHERE SecCode = 173075 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838240695, ExchCode = 'MUN' WHERE SecCode = 173076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22126226638, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 178137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560429859, ExchCode = 'DEU' WHERE SecCode = 178154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535118681, ExchCode = 'DEU' WHERE SecCode = 179755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341941, ExchCode = 'BER' WHERE SecCode = 184376 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 184693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861358172, ExchCode = 'QTX' WHERE SecCode = 184941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823782672, ExchCode = 'DUS' WHERE SecCode = 185500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624665064, ExchCode = 'STU', PermQuoteRetireDate = '2021-03-01' WHERE SecCode = 185675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551603368, ExchCode = 'STU' WHERE SecCode = 185677 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 = 21667486290, ExchCode = 'QTX' WHERE SecCode = 185770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539524265, Ticker = 'GHNd', ExchCode = 'BCO', PermQuoteRetireDate = '2021-08-12' WHERE SecCode = 185771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796557193, ExchCode = 'FRA' WHERE SecCode = 185777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498942099, PermQuoteStatus = 'AC', Ticker = 'MAL2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 185835 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383621, ExchCode = 'FRA' WHERE SecCode = 186133 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 186177 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 190123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981535, Ticker = 'P8H', ExchCode = 'HAM', PermQuoteRetireDate = '2016-05-17' WHERE SecCode = 191863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836431429, ExchCode = 'FRA' WHERE SecCode = 192546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326664, ExchCode = 'BER' WHERE SecCode = 192797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954293455, ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-06' WHERE SecCode = 192940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589641082, ExchCode = 'BER', PermQuoteRetireDate = '2021-10-21' WHERE SecCode = 192941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794769110, ExchCode = 'LAS' WHERE SecCode = 192957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787784079, Ticker = '1KERm', ExchCode = 'BCO' WHERE SecCode = 194136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483655, ExchCode = 'QTX' WHERE SecCode = 194187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519039, ExchCode = 'DUS' WHERE SecCode = 194847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812326477, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 195545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805177406, ExchCode = 'MUN', PermQuoteRetireDate = '2025-01-15', PermSecMapEndDate = NULL WHERE SecCode = 196054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475510665, Ticker = 'DOCK.I', ExchCode = 'COO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 196096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560967785, Ticker = 'BNF', ExchCode = 'STU' WHERE SecCode = 196120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805015324, ExchCode = 'MUN' 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 = 21819929691, ExchCode = 'DUS' WHERE SecCode = 196887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628061494, ExchCode = 'DEU' WHERE SecCode = 197081 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339737, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-09' WHERE SecCode = 197286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850051800, ExchCode = 'GTX' WHERE SecCode = 197304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705955, Ticker = 'VIVN', ExchCode = 'MXQ', PermQuoteRetireDate = '2021-02-09' WHERE SecCode = 197334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797256366, ExchCode = 'QTX' WHERE SecCode = 197772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475593568, Ticker = 'FIGG.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 198936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805394556, ExchCode = 'GTX' WHERE SecCode = 199010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331715, ExchCode = 'BER' WHERE SecCode = 199016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338558, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 199022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517579838, ExchCode = 'STU', PermQuoteRetireDate = '2014-10-07' WHERE SecCode = 204876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480921, ExchCode = 'QTX' WHERE SecCode = 205611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803385261, ExchCode = 'MUN' WHERE SecCode = 206847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333218, ExchCode = 'BER', PermQuoteRetireDate = '2017-03-07', PermSecMapEndDate = '2017-03-07' WHERE SecCode = 208564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339399, ExchCode = 'BER' WHERE SecCode = 208570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681851532, PermQuoteStatus = 'DC', Ticker = 'X9CP', ExchCode = 'DUS', PermQuoteRetireDate = '2020-03-05' WHERE SecCode = 208904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544956008, ExchCode = 'DEU' WHERE SecCode = 208922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328659, ExchCode = 'BER' WHERE SecCode = 208947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510747, ExchCode = 'DUS' WHERE SecCode = 210734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286375, ExchCode = 'GTX' WHERE SecCode = 210739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550076897, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 214105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474962651, ExchCode = 'DEU' WHERE SecCode = 214142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475826525, ExchCode = 'TDG' WHERE SecCode = 214143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835824545, ExchCode = 'MEX' WHERE SecCode = 214292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835817048, ExchCode = 'MEX' WHERE SecCode = 214378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704511, ExchCode = 'MXQ' WHERE SecCode = 214889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387856, ExchCode = 'LAS' WHERE SecCode = 215110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 216383 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 = 55837362315, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 246361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589808, Ticker = 'CMGG.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 246441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800709244, ExchCode = 'QTX' WHERE SecCode = 248095 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858633247, ExchCode = 'MUN', PermQuoteRetireDate = '2013-08-06' WHERE SecCode = 248303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333041, ExchCode = 'BER', PermQuoteRetireDate = '2019-02-15' WHERE SecCode = 248318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795183119, ExchCode = 'LAS' WHERE SecCode = 248504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275541, ExchCode = 'GTX' WHERE SecCode = 248506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475827221, PermQuoteStatus = 'AC', Ticker = 'TCS', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 248522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837437935, Ticker = 'EMG', ExchCode = 'MIL', PermQuoteRetireDate = '2017-11-24' WHERE SecCode = 248524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788847198, ExchCode = 'DUS' WHERE SecCode = 248556 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836392550, ExchCode = 'FRA' WHERE SecCode = 248569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387919, ExchCode = 'LAS' WHERE SecCode = 248574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294182, ExchCode = 'GTX' WHERE SecCode = 248621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837355473, ExchCode = 'GER', PermQuoteRetireDate = '2010-12-09' WHERE SecCode = 248623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492775, ExchCode = 'QTX' WHERE SecCode = 248738 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 = 21830312134, ExchCode = 'GTX' WHERE SecCode = 248742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791252433, ExchCode = 'GER', PermQuoteRetireDate = '2021-03-23' WHERE SecCode = 248746 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387199, ExchCode = 'LAS' WHERE SecCode = 248748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388447, ExchCode = 'LAS' WHERE SecCode = 248754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380369, ExchCode = 'LAS', PermQuoteRetireDate = '2025-01-27' WHERE SecCode = 248756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485416, ExchCode = 'QTX' WHERE SecCode = 248758 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 = 21474864444, ExchCode = 'DEU' WHERE SecCode = 248767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646692615, ExchCode = 'STU', PermQuoteRetireDate = '2023-07-11' WHERE SecCode = 248769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485908, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-03' WHERE SecCode = 248773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837356986, ExchCode = 'GER' WHERE SecCode = 248774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474922422, ExchCode = 'DEU' WHERE SecCode = 248777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597412358, ExchCode = 'TDG' WHERE SecCode = 248895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308527, ExchCode = 'GTX' WHERE SecCode = 248901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589742994, ExchCode = 'STU', PermQuoteRetireDate = '2018-10-15' WHERE SecCode = 248903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802775549, ExchCode = 'FRA' WHERE SecCode = 248904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474920761, ExchCode = 'DEU', PermQuoteRetireDate = '2018-03-07' WHERE SecCode = 248917 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489317, PermQuoteStatus = 'AC', Ticker = 'OVER', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 248919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734475844, ExchCode = 'MUN' WHERE SecCode = 248920 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491328, ExchCode = 'QTX' WHERE SecCode = 248924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326742, ExchCode = 'BER' WHERE SecCode = 248927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475363283, ExchCode = 'GER' WHERE SecCode = 248928 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836474868, ExchCode = 'FRA' WHERE SecCode = 248929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718474194, ExchCode = 'DEU', PermQuoteRetireDate = '2023-11-21' WHERE SecCode = 248943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21605380573, ExchCode = 'DEU' WHERE SecCode = 248952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522632999, ExchCode = 'MUN' WHERE SecCode = 248967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491570, ExchCode = 'QTX' WHERE SecCode = 248987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755228131, ExchCode = 'TDG' WHERE SecCode = 248989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474879165, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 248992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341284, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 249048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035304, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2012-06-04' WHERE SecCode = 249049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805177384, PermQuoteRetireDate = '2022-03-23' WHERE SecCode = 249054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836333593, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249164 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324257, Ticker = 'BHQ1', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 249168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991681, ExchCode = 'DEU' WHERE SecCode = 249177 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805672063, ExchCode = 'FRA' WHERE SecCode = 249189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312271, ExchCode = 'GTX' WHERE SecCode = 249190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489182, ExchCode = 'QTX' WHERE SecCode = 249196 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 = 21475436628, ExchCode = 'STU' WHERE SecCode = 249208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520192827, ExchCode = 'STU' WHERE SecCode = 249211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601433377, ExchCode = 'TDG' WHERE SecCode = 249217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800600238, ExchCode = 'FRA' WHERE SecCode = 249236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330455, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-18' WHERE SecCode = 249264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394740, ExchCode = 'FRA', PermQuoteRetireDate = '2011-08-11' WHERE SecCode = 249274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769859897, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 249276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787268, ExchCode = 'DUS' WHERE SecCode = 249293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475631725, ExchCode = 'BER', PermQuoteRetireDate = '2006-10-30' WHERE SecCode = 249314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328104, ExchCode = 'BER', PermQuoteRetireDate = '2014-07-04' WHERE SecCode = 249315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836469631, ExchCode = 'FRA' WHERE SecCode = 249318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334939, ExchCode = 'BER', PermQuoteRetireDate = '2010-10-11' WHERE SecCode = 249325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532119852, ExchCode = 'DEU' WHERE SecCode = 249342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858768862, ExchCode = 'FRA', PermQuoteRetireDate = '2013-02-19' WHERE SecCode = 249351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308551, ExchCode = 'GTX' WHERE SecCode = 249355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836386191, ExchCode = 'FRA' WHERE SecCode = 249361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322849, ExchCode = 'BER', PermQuoteRetireDate = '2018-07-26' WHERE SecCode = 249362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563176056, ExchCode = 'STU' WHERE SecCode = 249364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836480581, ExchCode = 'FRA' WHERE SecCode = 249365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777943936, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330204, ExchCode = 'BER' WHERE SecCode = 249375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474844752, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 249377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474992946, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 249379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822353285, ExchCode = 'MUN', PermQuoteRetireDate = '2023-06-15', PermSecMapEndDate = NULL WHERE SecCode = 249387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573397788, ExchCode = 'TDG' WHERE SecCode = 249398 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823782714, PermQuoteStatus = 'DC', Ticker = 'INO', ExchCode = 'DUS', PermQuoteRetireDate = '2024-04-02' WHERE SecCode = 249400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528277070, ExchCode = 'FRA' WHERE SecCode = 249402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481625, ExchCode = 'QTX' WHERE SecCode = 249419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312110, ExchCode = 'GTX' WHERE SecCode = 249420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483182, ExchCode = 'QTX' WHERE SecCode = 249426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955944, ExchCode = 'TDG' WHERE SecCode = 249445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615298682, ExchCode = 'STU' WHERE SecCode = 249565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805754447, ExchCode = 'MUN' WHERE SecCode = 249571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481133, ExchCode = 'QTX' WHERE SecCode = 249573 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830300969, ExchCode = 'GTX' WHERE SecCode = 249589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562213698, ExchCode = 'TDG' WHERE SecCode = 249592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779461439, ExchCode = 'GTX' WHERE SecCode = 249597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492998, ExchCode = 'QTX', PermQuoteRetireDate = '2021-04-27' WHERE SecCode = 249598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659184253, ExchCode = 'STU' WHERE SecCode = 249599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956727919, ExchCode = 'QTX' WHERE SecCode = 249601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784909637, ExchCode = 'TDG', PermQuoteRetireDate = '2021-07-19' WHERE SecCode = 249606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836342055, ExchCode = 'BER', PermQuoteRetireDate = '2019-12-04' WHERE SecCode = 249609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788448839, Ticker = 'SFWd', ExchCode = 'BCO' WHERE SecCode = 249619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850695012, ExchCode = 'FRA' WHERE SecCode = 249622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109803, ExchCode = 'DUS' WHERE SecCode = 249624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490419, ExchCode = 'QTX', PermQuoteRetireDate = '2020-10-07' WHERE SecCode = 249627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324569, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475429068, ExchCode = 'FRA' WHERE SecCode = 249648 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475083520, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-25' WHERE SecCode = 249654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805754406, ExchCode = 'MUN' WHERE SecCode = 249668 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334703, PermQuoteStatus = 'DC', Ticker = 'PJR', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 249677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474855924, ExchCode = 'DEU' WHERE SecCode = 249683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779358971, ExchCode = 'GTX' WHERE SecCode = 249684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836526588, ExchCode = 'FRA' WHERE SecCode = 249685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334452, Ticker = 'QPH', ExchCode = 'BER', PermQuoteRetireDate = '2014-08-18' WHERE SecCode = 249694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731413773, ExchCode = 'MUN' WHERE SecCode = 249701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327452, ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09' WHERE SecCode = 249703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858768435, ExchCode = 'FRA' WHERE SecCode = 249704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836409875, ExchCode = 'FRA' WHERE SecCode = 249712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474904036, ExchCode = 'DEU' WHERE SecCode = 249713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799016537, ExchCode = 'TDG' WHERE SecCode = 249727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666131027, ExchCode = 'TDG', PermQuoteRetireDate = '2020-06-19' WHERE SecCode = 249728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782434438, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523834051, ExchCode = 'FRA' WHERE SecCode = 249760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327275, ExchCode = 'BER' WHERE SecCode = 249761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475732533, ExchCode = 'MUN' WHERE SecCode = 249762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474837424, ExchCode = 'DEU' WHERE SecCode = 249765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332536, ExchCode = 'BER', PermQuoteRetireDate = '2022-05-26', PermSecMapEndDate = '2022-05-26' WHERE SecCode = 249777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484794, ExchCode = 'QTX' WHERE SecCode = 249781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485099, ExchCode = 'QTX' WHERE SecCode = 249782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329295, ExchCode = 'BER' WHERE SecCode = 249787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587111637, ExchCode = 'DEU' WHERE SecCode = 249791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21609681523, ExchCode = 'STU' WHERE SecCode = 249796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785264818, ExchCode = 'FRA' WHERE SecCode = 249797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532684873, ExchCode = 'DEU' WHERE SecCode = 249801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328481, ExchCode = 'BER', PermQuoteRetireDate = '2016-01-04' WHERE SecCode = 249805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866534688, ExchCode = 'GTX' WHERE SecCode = 249811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860309351, ExchCode = 'MUN' WHERE SecCode = 249812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388561, ExchCode = 'LAS' WHERE SecCode = 249816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531426532, ExchCode = 'FRA' WHERE SecCode = 249824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823048947, ExchCode = 'DUS' WHERE SecCode = 249828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474978890, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-20' WHERE SecCode = 249834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535950976, PermQuoteStatus = 'AC', Ticker = '2DT', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 249836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836390087, ExchCode = 'FRA' WHERE SecCode = 249844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302183, ExchCode = 'GTX' WHERE SecCode = 249853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836400888, ExchCode = 'FRA' WHERE SecCode = 249855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836419614, ExchCode = 'FRA' WHERE SecCode = 249861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667487891, ExchCode = 'QTX' WHERE SecCode = 250132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714463535, Ticker = 'EM35m', ExchCode = 'DXE' WHERE SecCode = 252548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275430, ExchCode = 'GTX' WHERE SecCode = 252550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385006, ExchCode = 'LAS', PermQuoteRetireDate = '2025-12-16' WHERE SecCode = 254676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836338144, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 254873 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 255060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838563900, ExchCode = 'STU' WHERE SecCode = 255144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619083425, ExchCode = 'TDG', PermQuoteRetireDate = '2022-08-22' WHERE SecCode = 258666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475724602, ExchCode = 'FRA', PermQuoteRetireDate = '2007-06-13' WHERE SecCode = 258908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384470, ExchCode = 'LAS' WHERE SecCode = 259026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332533, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 259601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538345893, ExchCode = 'FRA' WHERE SecCode = 259657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694900851, ExchCode = 'QTX' WHERE SecCode = 259753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323933, ExchCode = 'BER' WHERE SecCode = 260155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336691, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 260490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475589799, Ticker = 'COLI.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 261710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476126068, ExchCode = 'STU', PermQuoteRetireDate = '2014-08-13' WHERE SecCode = 261908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21686713637, PermQuoteStatus = 'AC', Ticker = 'LEERd', ExchCode = 'BTE', PermQuoteRetireDate = NULL WHERE SecCode = 272752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804440375, ExchCode = 'FRA' WHERE SecCode = 273208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327852, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 277248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22012891135, Ticker = 'LYQ3d', ExchCode = 'AQE' WHERE SecCode = 278881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509894968, Ticker = 'THKU', ExchCode = 'LSE', PermQuoteRetireDate = '2008-10-01' WHERE SecCode = 279674 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553068251, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 282761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531116324, Ticker = 'AICm', ExchCode = 'BCO', PermQuoteRetireDate = '2014-10-09' WHERE SecCode = 283091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836388950, ExchCode = 'FRA' WHERE SecCode = 283709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836493793, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 283718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836522301, ExchCode = 'FRA', PermQuoteRetireDate = '2011-08-17' WHERE SecCode = 283842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836515133, ExchCode = 'FRA' WHERE SecCode = 284038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475802022, ExchCode = 'SIG', PermQuoteRetireDate = '2013-11-01' WHERE SecCode = 284278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787321, ExchCode = 'DUS' WHERE SecCode = 284280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650219, ExchCode = 'DUS' WHERE SecCode = 284282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295433, ExchCode = 'GTX' WHERE SecCode = 284283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670715014, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 284304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788450803, ExchCode = 'FRA' WHERE SecCode = 285188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836412859, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 285190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789232827, ExchCode = 'FRA' WHERE SecCode = 285541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475791849, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 286286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836391522, ExchCode = 'FRA' WHERE SecCode = 286289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836458250, ExchCode = 'FRA' WHERE SecCode = 287044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836473643, ExchCode = 'FRA' WHERE SecCode = 287047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492530, PermQuoteStatus = 'DC', Ticker = 'UTE1', ExchCode = 'QTX', PermQuoteRetireDate = '2020-02-26' WHERE SecCode = 287574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21526380308, ExchCode = 'CHI', PermQuoteRetireDate = '2013-08-13' WHERE SecCode = 288059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624376897, ExchCode = 'FRA' WHERE SecCode = 288083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481439, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 288243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531132922, PermQuoteStatus = 'AC', Ticker = 'OKLd', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 288296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493685, ExchCode = 'QTX' WHERE SecCode = 288836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836444919, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 288837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801287197, ExchCode = 'TDG' WHERE SecCode = 288842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486208, ExchCode = 'QTX' WHERE SecCode = 288843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836496427, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 289025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840969688, ExchCode = 'STU', PermQuoteRetireDate = '2008-10-01' WHERE SecCode = 289026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21645301996, ExchCode = 'MUN' WHERE SecCode = 289032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836326669, ExchCode = 'BER' WHERE SecCode = 289053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324225, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 289154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323233, ExchCode = 'BER', PermQuoteRetireDate = '2015-01-23' WHERE SecCode = 289440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521357857, ExchCode = 'DUS' WHERE SecCode = 289443 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329561, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 289461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341148, ExchCode = 'BER' WHERE SecCode = 289584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475141544, ExchCode = 'STU' WHERE SecCode = 289606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613032626, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 289607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836520595, ExchCode = 'FRA' WHERE SecCode = 289617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489325, ExchCode = 'QTX', PermQuoteRetireDate = '2023-03-06', PermSecMapEndDate = '2023-03-06' WHERE SecCode = 289619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836491800, ExchCode = 'FRA', PermQuoteRetireDate = '2009-01-13' WHERE SecCode = 289899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325116, ExchCode = 'BER' WHERE SecCode = 289915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836392243, ExchCode = 'FRA' WHERE SecCode = 290309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790265015, ExchCode = 'TDG' WHERE SecCode = 290846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791909618, PermQuoteStatus = 'AC', Ticker = 'SFY0', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 290848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033805, Ticker = 'A8M1', ExchCode = 'TDG', PermQuoteRetireDate = '2016-02-29' WHERE SecCode = 290850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475591627, ExchCode = 'MCX', PermQuoteRetireDate = '2008-12-01' WHERE SecCode = 291017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836388900, ExchCode = 'FRA', PermQuoteRetireDate = '2016-05-25' WHERE SecCode = 291257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598997799, ExchCode = 'TDG' WHERE SecCode = 291259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325363, Ticker = 'ECA1', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 291269 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 = 21773003127, ExchCode = 'DEU' WHERE SecCode = 291283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836392466, ExchCode = 'FRA' WHERE SecCode = 291575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331784, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 291583 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583580948, ExchCode = 'TDG' WHERE SecCode = 291585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836435377, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 291628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482072, ExchCode = 'QTX' WHERE SecCode = 291840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428140, ExchCode = 'GTX' WHERE SecCode = 291850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836467703, ExchCode = 'FRA' WHERE SecCode = 291854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475802522, ExchCode = 'TDG', PermQuoteRetireDate = '2013-09-27' WHERE SecCode = 291865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381147, ExchCode = 'LAS' WHERE SecCode = 292113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341609, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 292115 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 292909 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21667493070, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 292973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782413605, ExchCode = 'STU' WHERE SecCode = 292976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339128, ExchCode = 'BER', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 293703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625977418, ExchCode = 'TDG' WHERE SecCode = 293916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794249941, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 295285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475471595, ExchCode = 'GER' WHERE SecCode = 296127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327296, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794249903, ExchCode = 'MUN' WHERE SecCode = 296276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388871, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 296284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836502666, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 296592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836461787, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 296595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486847, ExchCode = 'QTX' WHERE SecCode = 296606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836393948, Ticker = 'CVE', ExchCode = 'FRA', PermQuoteRetireDate = '2020-09-15' WHERE SecCode = 296645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837365271, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 297228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419293, ExchCode = 'HAM' WHERE SecCode = 297377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597412361, ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-03' WHERE SecCode = 297491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830302156, ExchCode = 'GTX' WHERE SecCode = 297732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330753, ExchCode = 'BER' WHERE SecCode = 297742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272675, ExchCode = 'GTX' WHERE SecCode = 298194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388845, ExchCode = 'LAS', PermQuoteRetireDate = '2025-02-13' WHERE SecCode = 298207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836394794, ExchCode = 'FRA' WHERE SecCode = 298579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335814, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850354101, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 298815 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 = 21475034221, ExchCode = 'TDG' WHERE SecCode = 300369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531134931, Ticker = 'TCGd', ExchCode = 'BCO', PermQuoteRetireDate = '2020-03-27' WHERE SecCode = 300395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838433153, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-10' WHERE SecCode = 300831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323687, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 301717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482608, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 301718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484161, ExchCode = 'QTX' WHERE SecCode = 301739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790876936, ExchCode = 'FRA' WHERE SecCode = 302076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528495408, Ticker = 'GFHl', ExchCode = 'CHI', PermQuoteRetireDate = '2015-05-29' WHERE SecCode = 302658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573984403, PermQuoteStatus = 'AC', Ticker = 'C2U', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 302708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483736, ExchCode = 'QTX' WHERE SecCode = 303015 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843595648, ExchCode = 'FRA' WHERE SecCode = 303347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836530137, ExchCode = 'FRA' WHERE SecCode = 303353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836336781, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 303354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842352510, ExchCode = 'STU' WHERE SecCode = 303358 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475007244, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328354, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 303854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035599, ExchCode = 'TDG' WHERE SecCode = 304121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350087, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 305001 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474858069, ExchCode = 'DEU' WHERE SecCode = 305002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325588, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 305536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835821280, ExchCode = 'MEX' WHERE SecCode = 308939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836334963, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 309089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571572383, ExchCode = 'TDG' WHERE SecCode = 309339 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320701, ExchCode = 'BER', PermQuoteRetireDate = '2015-06-17' WHERE SecCode = 309349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585032919, ExchCode = 'BCO' WHERE SecCode = 309897 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585032968, ExchCode = 'BCO' WHERE SecCode = 309898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320432, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 310396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792573068, ExchCode = 'BIV' WHERE SecCode = 311169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016590, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 311970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515932843, ExchCode = 'STU', PermQuoteRetireDate = '2019-05-14' WHERE SecCode = 312346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273323, ExchCode = 'GTX' WHERE SecCode = 312460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842234317, ExchCode = 'STU' WHERE SecCode = 312673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349150, ExchCode = 'FRA' WHERE SecCode = 312932 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 = 55836320500, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-26', PermSecMapEndDate = '2024-07-26' WHERE SecCode = 313243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21544497999, ExchCode = 'TRQ' WHERE SecCode = 313522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531135120, Ticker = 'TP21d', ExchCode = 'BCO' WHERE SecCode = 313535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841559545, ExchCode = 'MUN' WHERE SecCode = 313545 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475425030, ExchCode = 'STU' WHERE SecCode = 313546 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 = 21642065223, ExchCode = 'TDG' WHERE SecCode = 314186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522408064, ExchCode = 'MUN' WHERE SecCode = 314206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550077092, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 315711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527198705, PermQuoteStatus = 'AC', Ticker = '3EO1', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 316264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320647, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 316450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822221, ExchCode = 'FRA' WHERE SecCode = 316458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350338, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 316472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350217, ExchCode = 'FRA' WHERE SecCode = 317225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348095, ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-25' WHERE SecCode = 317228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320657, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 317772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742612, ExchCode = 'HAN' WHERE SecCode = 317794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460519, ExchCode = 'HAN' WHERE SecCode = 317810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320668, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 318406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323723, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 318424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348023, ExchCode = 'FRA' WHERE SecCode = 319524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571254271, Ticker = '3G8A', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 320392 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 322449 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 322975 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836320974, Ticker = '45CN', ExchCode = 'BER', PermQuoteRetireDate = '2019-04-03' WHERE SecCode = 323043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036311, ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-03' WHERE SecCode = 325342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479406, ExchCode = 'QTX' WHERE SecCode = 325643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537344839, ExchCode = 'STU' 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 = 236777378775, ExchCode = 'STU' WHERE SecCode = 325661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836359971, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 326282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547152813, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-12-21', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 326284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321155, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-19' WHERE SecCode = 326659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320604, ExchCode = 'BER' WHERE SecCode = 326661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21623602679, ExchCode = 'MUN' WHERE SecCode = 327143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608397233, ExchCode = 'TDG' WHERE SecCode = 327144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294329, ExchCode = 'GTX' WHERE SecCode = 327723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474949558, ExchCode = 'DEU' WHERE SecCode = 328153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777489130, ExchCode = 'STU', PermQuoteRetireDate = '2022-09-20' WHERE SecCode = 328156 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796557198, ExchCode = 'FRA' WHERE SecCode = 328509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789435058, ExchCode = 'DUS' WHERE SecCode = 328511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836353704, ExchCode = 'FRA' WHERE SecCode = 328870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836346436, ExchCode = 'FRA' WHERE SecCode = 329370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339261, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26', PermSecMapEndDate = '2024-09-26' WHERE SecCode = 330634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730199351, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2023-07-21', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 330665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843042843, ExchCode = 'FRA' WHERE SecCode = 331281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863472363, Ticker = '3BH', ExchCode = 'HAM', PermQuoteRetireDate = '2017-06-07' WHERE SecCode = 331318 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 331813 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55852139949, PermQuoteStatus = 'AC', Ticker = '0K9W', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 332202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848856141, Ticker = '0M6F', ExchCode = 'LSE', PermQuoteRetireDate = '2013-06-27' WHERE SecCode = 332203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475558952, Ticker = 'PNZ.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2010-01-29' WHERE SecCode = 332227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834674934, PermQuoteStatus = 'AC', Ticker = '0MEF', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 332230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531116271, PermQuoteStatus = 'AC', Ticker = 'AGAPl', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 333083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836040818, Ticker = 'AGGP', ExchCode = 'LSE' WHERE SecCode = 333085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21565172549, Ticker = 'OLBPl', ExchCode = 'BTE', PermQuoteRetireDate = '2020-06-17' WHERE SecCode = 333091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836370746, ExchCode = 'FRA', PermQuoteRetireDate = '2009-04-20' WHERE SecCode = 333158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836350511, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-18' WHERE SecCode = 333180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320770, ExchCode = 'BER', PermQuoteRetireDate = '2017-07-31' WHERE SecCode = 333182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838303459, PermQuoteStatus = 'DC', Ticker = 'HEIO.NL', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 333386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838298456, PermQuoteStatus = 'DC', Ticker = 'MTX.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 333387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479330, ExchCode = 'QTX' WHERE SecCode = 333411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830289068, ExchCode = 'GTX' WHERE SecCode = 333421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321198, ExchCode = 'BER', PermQuoteRetireDate = '2020-09-21' WHERE SecCode = 333422 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 = 55836363186, ExchCode = 'FRA' 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 OrgTypeCode = 'GVTDA' WHERE SecCode = 334355 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21475545761, Ticker = 'IMAKO.GR', PermQuoteRetireDate = '2010-01-05' WHERE SecCode = 334816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320912, ExchCode = 'BER' WHERE SecCode = 334857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830300955, ExchCode = 'GTX' WHERE SecCode = 334888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837447989, Ticker = 'XGLE', ExchCode = 'MIL' WHERE SecCode = 335234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804396529, ExchCode = 'DUS' 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 = 21634652539, ExchCode = 'MUN' WHERE SecCode = 335661 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585027644, ExchCode = 'CHI' WHERE SecCode = 335975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834674630, Ticker = '0OFR', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-21' WHERE SecCode = 336187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320555, ExchCode = 'BER' WHERE SecCode = 336198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482766270, ExchCode = 'MUN', PermQuoteRetireDate = '2015-06-16' WHERE SecCode = 336200 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 = 55836351414, ExchCode = 'FRA', PermQuoteRetireDate = '2020-04-20' WHERE SecCode = 336790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349905, ExchCode = 'FRA', PermQuoteRetireDate = '2013-03-22' WHERE SecCode = 337012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789870377, Ticker = '3PJ1', ExchCode = 'QTX', PermQuoteRetireDate = '2025-08-07' WHERE SecCode = 337013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550085567, ExchCode = 'HAM' WHERE SecCode = 337400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834671877, Ticker = '0OQO', ExchCode = 'LSE', PermQuoteRetireDate = '2014-07-14' WHERE SecCode = 340071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860860933, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 340167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835810417, ExchCode = 'MEX' WHERE SecCode = 340246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476011534, ExchCode = 'MUN', PermQuoteRetireDate = '2016-11-30' WHERE SecCode = 340488 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479446, ExchCode = 'QTX', PermQuoteRetireDate = '2025-05-07' WHERE SecCode = 340533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836359938, ExchCode = 'FRA' WHERE SecCode = 341102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320662, ExchCode = 'BER' WHERE SecCode = 341124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296529, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 341129 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586927759, ExchCode = 'FRA' WHERE SecCode = 341781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321800, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 341785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862967733, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 341790 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 = 21667479339, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 342227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321115, ExchCode = 'BER' WHERE SecCode = 343026 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836353496, ExchCode = 'FRA' WHERE SecCode = 343073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479638, ExchCode = 'QTX' WHERE SecCode = 343807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852880802, Ticker = '0OEU', ExchCode = 'LSE', PermQuoteRetireDate = '2017-11-09' WHERE SecCode = 344514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564885326, ExchCode = 'FRA' WHERE SecCode = 344777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321245, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 345092 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957529769, ExchCode = 'QTX' WHERE SecCode = 345100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834800221, Ticker = NULL, ExchCode = 'HKG', PermQuoteRetireDate = '2018-04-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 = 21538768103, Ticker = 'CAZAl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-08-24' WHERE SecCode = 345783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531115649, Ticker = '47Ed', ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-10' WHERE SecCode = 345857 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 = 21485225744, ExchCode = 'STU', PermQuoteRetireDate = '2016-05-16' WHERE SecCode = 348104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321533, ExchCode = 'BER' WHERE SecCode = 348107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321391, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 348120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419443, PermQuoteStatus = 'DC', ExchCode = 'HAM', PermQuoteRetireDate = '2017-10-16' WHERE SecCode = 348130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836352305, ExchCode = 'FRA', PermQuoteRetireDate = '2015-09-21' WHERE SecCode = 348453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837445595, Ticker = '1RNO' WHERE SecCode = 348455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438916, ExchCode = 'FRA' WHERE SecCode = 348479 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475108673, Ticker = '0N06', ExchCode = 'LSE', PermQuoteRetireDate = '2012-02-13' WHERE SecCode = 348630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707243674, ExchCode = 'TDG' WHERE SecCode = 348709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419816, ExchCode = 'HAM' WHERE SecCode = 348719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838303566, Ticker = 'MEGA.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 349090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321139, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 350278 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 350758 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55838296349, Ticker = 'AVAC.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 351261 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834672212, Ticker = '0OA8', ExchCode = 'LSE', PermQuoteRetireDate = '2012-07-02' WHERE SecCode = 351265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55834673143, Ticker = '0NY0', ExchCode = 'LSE', PermQuoteRetireDate = '2015-09-30' WHERE SecCode = 351274 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 = 21475473201, ExchCode = 'GER' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836347634, ExchCode = 'FRA', PermQuoteRetireDate = '2009-09-28' WHERE SecCode = 351311 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 351424 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21830300937, ExchCode = 'GTX' WHERE SecCode = 352543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836348908, ExchCode = 'FRA' WHERE SecCode = 353324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838299763, PermQuoteStatus = 'DC', Ticker = 'POST.AT', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 353931 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 = 55834769656, PermQuoteStatus = 'AC', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 353978 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 OrgPermID = 6000040143, PriInstrPermID = 8591005052.0, PermOrgIPODate = '2008-06-12' WHERE SecCode = 355079 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836320508, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 355184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321371, ExchCode = 'BER' WHERE SecCode = 356548 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 = 21954642017, ExchCode = 'QTX' WHERE SecCode = 357673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655827958, ExchCode = 'DEU', PermQuoteRetireDate = '2023-09-19', PermSecMapEndDate = NULL WHERE SecCode = 359919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321584, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 362789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830311920, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 362801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609514, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 363732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475450726, ExchCode = 'FRA' WHERE SecCode = 363753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475489992, Ticker = 'BIOSP', ExchCode = 'PLU', PermQuoteRetireDate = '2009-01-27' WHERE SecCode = 363969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475474106, ExchCode = 'GER' WHERE SecCode = 364966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331961, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 368723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837351799, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 368806 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837351233, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 368808 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837351231, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 368818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840949533, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 368820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837350619, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 368836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730461617, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-25' WHERE SecCode = 369106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840407170, ExchCode = 'MEX' WHERE SecCode = 372861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836362069, ExchCode = 'FRA' WHERE SecCode = 376072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294185, ExchCode = 'GTX' WHERE SecCode = 376283 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 = 21547002144, Ticker = 'D69d', ExchCode = 'BCO' WHERE SecCode = 379671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322712, ExchCode = 'BER' WHERE SecCode = 383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835813469, ExchCode = 'MEX' WHERE SecCode = 383039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840770489, ExchCode = 'BER', PermQuoteRetireDate = '2023-11-23', PermSecMapEndDate = '2023-11-23' WHERE SecCode = 384412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782463487, ExchCode = 'QTX' 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 = 55852345883, ExchCode = 'GER' 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 = 55840857595, Ticker = '4QQN', ExchCode = 'BER', PermQuoteRetireDate = '2022-05-02' WHERE SecCode = 389019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55840949580, ExchCode = 'FRA' WHERE SecCode = 389023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550085548, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 389475 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 = 55840913294, ExchCode = 'FRA' WHERE SecCode = 389775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295315, ExchCode = 'GTX' WHERE SecCode = 390369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475760801, ExchCode = 'STU' WHERE SecCode = 392214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955513841, ExchCode = 'DUS' WHERE SecCode = 395256 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 = 21799281035, ExchCode = 'FRA' WHERE SecCode = 396303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810843369, ExchCode = 'STU', PermQuoteRetireDate = '2021-06-16' 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 = 55841643564, ExchCode = 'FRA' WHERE SecCode = 401624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475796462, ExchCode = 'STU', PermQuoteRetireDate = '2014-02-27' WHERE SecCode = 404077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841814629, ExchCode = 'BER', PermQuoteRetireDate = '2018-03-26' WHERE SecCode = 404717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539608463, ExchCode = 'TDG', PermQuoteRetireDate = '2019-11-01' WHERE SecCode = 404833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475388965, Ticker = 'ZIM.RO', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 408476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475472362, ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05' WHERE SecCode = 408478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842464917, Ticker = '1ENGI' WHERE SecCode = 408548 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 = 21822777044, ExchCode = 'DUS' WHERE SecCode = 413132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475108927, PermQuoteStatus = 'AC', Ticker = 'ZCT', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 416445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523795704, ExchCode = 'STU' WHERE SecCode = 424779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843288026, ExchCode = 'BER' WHERE SecCode = 424919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843194281, ExchCode = 'FRA' WHERE SecCode = 425031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474878624, Ticker = '0KJT', ExchCode = 'LSE', PermQuoteRetireDate = '2010-07-26' WHERE SecCode = 425350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55843333402, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-08' WHERE SecCode = 425411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488504, ExchCode = 'QTX' WHERE SecCode = 428332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528679708, ExchCode = 'DEU' WHERE SecCode = 428335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478465278, ExchCode = 'STU', PermQuoteRetireDate = '2024-07-02' WHERE SecCode = 428966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836330574, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 432012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859809796, ExchCode = 'UAX', PermQuoteRetireDate = '2016-02-05' WHERE SecCode = 433812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859809742, ExchCode = 'UAX', PermQuoteRetireDate = '2015-12-08' WHERE SecCode = 433814 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477787209, ExchCode = 'TDG' WHERE SecCode = 435796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21600289193, ExchCode = 'DUS', PermQuoteRetireDate = '2023-12-15', PermSecMapEndDate = NULL WHERE SecCode = 438364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684824, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 439455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475766995, ExchCode = 'FRA', PermQuoteRetireDate = '2019-08-19' WHERE SecCode = 446617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55841619375, ExchCode = 'MEX' WHERE SecCode = 462658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22118826258, ExchCode = 'SIG' 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 = 55847185526, Ticker = '0AO', ExchCode = 'BER', PermQuoteRetireDate = '2021-11-23' WHERE SecCode = 479615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55847545159, ExchCode = 'BER', PermQuoteRetireDate = '2018-09-21', PermSecMapEndDate = '2018-09-21' WHERE SecCode = 484246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475022130, ExchCode = 'DEU' WHERE SecCode = 486276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616157068, ExchCode = 'MCX' WHERE SecCode = 500487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55848865465, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 503830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21627494176, PermQuoteStatus = 'DC', ExchCode = 'SWX', PermQuoteRetireDate = '2019-12-16', PermSecMapEndDate = '2019-12-17' WHERE SecCode = 503842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296759, ExchCode = 'GTX' WHERE SecCode = 504529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519824496, Ticker = 'S0CB', ExchCode = 'DUS', PermQuoteRetireDate = '2014-05-05' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849448689, ExchCode = 'MEX' 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 = 55849477549, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 513278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849902699, ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-10' WHERE SecCode = 513850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531115401, Ticker = '0GAd', ExchCode = 'BCO', PermQuoteRetireDate = '2017-09-12' WHERE SecCode = 513937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849681521, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 514961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492958, ExchCode = 'QTX' WHERE SecCode = 515043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55850070208, ExchCode = 'FRA' WHERE SecCode = 518549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836423986, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 519509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428165, ExchCode = 'GTX' WHERE SecCode = 519511 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837441656, Ticker = 'HOGS', ExchCode = 'MIL' WHERE SecCode = 521415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837446990, Ticker = 'WEAT', ExchCode = 'MIL' WHERE SecCode = 521420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296198, ExchCode = 'GTX' WHERE SecCode = 524403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943359795, ExchCode = 'TDG' WHERE SecCode = 527096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214202, ExchCode = 'MEX' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640210344, ExchCode = 'BCO', PermQuoteRetireDate = '2020-08-17' WHERE SecCode = 529911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784580341, Ticker = '9EAA', PermQuoteRetireDate = '2022-09-13' WHERE SecCode = 531956 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 532116 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886808270, ExchCode = 'MUN' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523646821, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 533522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856295357, ExchCode = 'STU' WHERE SecCode = 534603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518942, ExchCode = 'DUS' WHERE SecCode = 535315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851360620, ExchCode = 'FRA', PermQuoteRetireDate = '2019-02-21' WHERE SecCode = 535417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849997680, Ticker = 'SBUL', ExchCode = 'MIL' WHERE SecCode = 536401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475422413, Ticker = 'FISKS.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2009-09-03' WHERE SecCode = 536734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476991388, ExchCode = 'TDG' WHERE SecCode = 538783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581478612, ExchCode = 'HAM' WHERE SecCode = 539438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335096, ExchCode = 'BER' WHERE SecCode = 540563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522030496, ExchCode = 'TDG' WHERE SecCode = 541495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607765095, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 541523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856846841, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 541974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035999, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2015-08-14' WHERE SecCode = 542320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307216, ExchCode = 'BIV' WHERE SecCode = 542395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807916878, ExchCode = 'TDG' WHERE SecCode = 542943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852420890, ExchCode = 'STU', PermQuoteRetireDate = '2013-05-29' WHERE SecCode = 547537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522128043, ExchCode = 'MUN' WHERE SecCode = 548067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301241, ExchCode = 'GTX' WHERE SecCode = 549236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789555706, ExchCode = 'QTX' WHERE SecCode = 549886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667483965, ExchCode = 'QTX' WHERE SecCode = 550860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859092913, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 551262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853660976, ExchCode = 'GER' WHERE SecCode = 552722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853693620, ExchCode = 'MUN', PermQuoteRetireDate = '2022-11-01', PermSecMapEndDate = '2022-11-01' WHERE SecCode = 553231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769222039, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 553799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850857947, ExchCode = 'DUS', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 553921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852277935, ExchCode = 'MEX' WHERE SecCode = 554302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779471152, ExchCode = 'GTX' WHERE SecCode = 556254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856027323, ExchCode = 'FRA', PermQuoteRetireDate = '2013-07-04' WHERE SecCode = 556535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859197737, ExchCode = 'BER' WHERE SecCode = 557816 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474957849, ExchCode = 'DEU' WHERE SecCode = 557818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856214006, ExchCode = 'GER' WHERE SecCode = 558032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184301, ExchCode = 'FRA' WHERE SecCode = 558485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856395007, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 559256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856606623, ExchCode = 'FRA' WHERE SecCode = 559437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575565347, ExchCode = 'STU', PermQuoteRetireDate = '2018-04-26' 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 OrgTypeCode = 'COM' WHERE SecCode = 561231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856859125, ExchCode = 'FRA', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 561328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856960400, ExchCode = 'FRA' WHERE SecCode = 561861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512281634, ExchCode = 'TRQ' WHERE SecCode = 563059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294098, ExchCode = 'GTX' WHERE SecCode = 563087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858521801, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 564035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487603, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 564417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475108946, ExchCode = 'STU' WHERE SecCode = 565316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857657672, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 565330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857726268, ExchCode = 'BER', PermQuoteRetireDate = '2014-03-27' WHERE SecCode = 565586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857740936, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 565707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857579082, ExchCode = 'FRA' WHERE SecCode = 565861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857541012, ExchCode = 'FRA' WHERE SecCode = 565866 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 567369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857958579, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 567636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152662, ExchCode = 'MUN' WHERE SecCode = 568338 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851903472, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 572386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705724, ExchCode = 'MXQ' WHERE SecCode = 573267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853019549, ExchCode = 'MEX' WHERE SecCode = 580373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981529, ExchCode = 'HAM', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 583151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859177674, ExchCode = 'STU' WHERE SecCode = 592307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859254285, ExchCode = 'FRA', PermQuoteRetireDate = '2015-10-01' WHERE SecCode = 599978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293928, InstrPermID = 8591391476, OrgPermID = 5000663094, ValQuotePermID = 55858425773.0, PriInstrPermID = 8591391476.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'ANK', ExchCode = 'GTX', PermQuoteRetireDate = NULL, PermOrgIPODate = '2010-04-01' WHERE SecCode = 601515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859255779, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 602090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802542707, ExchCode = 'FRA' WHERE SecCode = 602147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475859202, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13' WHERE SecCode = 602656 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780105425, ExchCode = 'QTX' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474991501, ExchCode = 'STU' WHERE SecCode = 652498 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391671, ExchCode = 'GTX' WHERE SecCode = 696378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492779045, ExchCode = 'STU', PermQuoteRetireDate = '2022-07-14' WHERE SecCode = 696379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290783, ExchCode = 'DUS' WHERE SecCode = 744688 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 QuotePermID = 21667492850, ExchCode = 'QTX' WHERE SecCode = 837909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428184, ExchCode = 'GTX' WHERE SecCode = 844009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475136959, ExchCode = 'DEU' WHERE SecCode = 858901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610380111, ExchCode = 'DEU' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22103473248, ExchCode = 'DEU' WHERE SecCode = 882870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779809732, ExchCode = 'GTX' WHERE SecCode = 883866 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 903596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667492656, ExchCode = 'QTX' WHERE SecCode = 931181 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785297550, ExchCode = 'QTX' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55846603850, Ticker = 'FMT', ExchCode = 'MUN', PermQuoteRetireDate = '2011-01-31' WHERE SecCode = 985004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769668, Ticker = 'TYM', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 995830 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 1107137 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1130580 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1157295 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1205075 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1205683 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134143721, ExchCode = 'DEU' WHERE SecCode = 1425621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21625073340, ExchCode = 'FRA' WHERE SecCode = 1453709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504490118, ExchCode = 'FRA', PermQuoteRetireDate = '2015-06-02' WHERE SecCode = 1457731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798768605, ExchCode = 'HAM' WHERE SecCode = 1468807 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770742468, ExchCode = 'HAN' WHERE SecCode = 1472577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480227394, ExchCode = 'STU', PermQuoteRetireDate = '2013-05-20' WHERE SecCode = 1479224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478367, ExchCode = 'QTX' WHERE SecCode = 1480257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21481705363, ExchCode = 'DEU' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704200, ExchCode = 'MXQ' WHERE SecCode = 1489564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587109485, ExchCode = 'FRA' WHERE SecCode = 1494186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21486671125, ExchCode = 'STU' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514028112, ExchCode = 'TDG' WHERE SecCode = 1522268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646545320, PermQuoteStatus = 'DC', Ticker = '5EV', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 1525470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21693152677, ExchCode = 'MUN' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098687, ExchCode = 'DEU' WHERE SecCode = 1527502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490958523, ExchCode = 'FRA' WHERE SecCode = 1531694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480768, ExchCode = 'QTX' WHERE SecCode = 1532769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529849881, Ticker = 'RBT', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1533786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067014491, ExchCode = 'DEU' WHERE SecCode = 1537196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273313, ExchCode = 'GTX' WHERE SecCode = 1537214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480207, PermQuoteStatus = 'DC', Ticker = '7NU', ExchCode = 'QTX', PermQuoteRetireDate = '2023-08-03', PermSecMapEndDate = '2025-06-13' WHERE SecCode = 1544692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796520014, ExchCode = 'GTX' WHERE SecCode = 1546625 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21496864672, ExchCode = 'DEU' WHERE SecCode = 1546652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893351, ExchCode = 'STU' WHERE SecCode = 1546662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802875945, ExchCode = 'LAS' WHERE SecCode = 1547496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650254, ExchCode = 'DUS' WHERE SecCode = 1552856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21499307444, Ticker = '5GQ', ExchCode = 'TDG', PermQuoteRetireDate = '2019-10-08' WHERE SecCode = 1554222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461757, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-04' WHERE SecCode = 1571251 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 = 21667479450, ExchCode = 'QTX' WHERE SecCode = 1584599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503838088, ExchCode = 'BER', PermQuoteRetireDate = '2017-05-30' WHERE SecCode = 1587478 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524609219, ExchCode = 'BTE' WHERE SecCode = 1589643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21504308500, ExchCode = 'FRA' WHERE SecCode = 1594714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505184781, ExchCode = 'STO' WHERE SecCode = 1596529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553068247, ExchCode = 'TDG' WHERE SecCode = 1604982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21506574448, ExchCode = 'MUN' WHERE SecCode = 1610786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331619, Ticker = 'KJ7A', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1623980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21511441575, ExchCode = 'TDG', PermQuoteRetireDate = '2016-02-08' WHERE SecCode = 1624036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493518, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 1630461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513069367, ExchCode = 'TDG' WHERE SecCode = 1635476 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100401, ExchCode = 'QTX' WHERE SecCode = 1651406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701628, Ticker = 'IBCG', ExchCode = 'BRN' WHERE SecCode = 1652279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655822423, ExchCode = 'FRA' WHERE SecCode = 1655502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510957458, Ticker = 'Q7X', PermQuoteRetireDate = '2012-10-10', PermSecMapEndDate = '2012-10-10' WHERE SecCode = 1668708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320060, ExchCode = 'DEU' WHERE SecCode = 1675781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522286896, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 1675785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795183066, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-18' WHERE SecCode = 1696044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685426483, ExchCode = 'MUN' WHERE SecCode = 1707747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641955269, ExchCode = 'FRA' WHERE SecCode = 1707749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528495375, ExchCode = 'BTE', PermQuoteRetireDate = '2022-03-08' WHERE SecCode = 1722300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22108941010, ExchCode = 'DEU' WHERE SecCode = 1733285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515423685, ExchCode = 'FRA' WHERE SecCode = 1967460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543576489, ExchCode = 'MUN' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 1992878 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 1996411 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 2006243 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 2006264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516696149, Ticker = 'ECX', ExchCode = 'LSE', PermQuoteRetireDate = '2014-08-27' WHERE SecCode = 2013070 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 2043821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21814536775, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-21' WHERE SecCode = 2072760 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337983, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2126923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786104642, ExchCode = 'DEU' WHERE SecCode = 2147795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519818958, ExchCode = 'DEU' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 2178813 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 2200277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537129363, ExchCode = 'BER', PermQuoteRetireDate = '2025-06-12', PermSecMapEndDate = '2025-06-26' WHERE SecCode = 2205173 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 2226891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306937, ExchCode = 'BEC' WHERE SecCode = 2226896 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346547, Ticker = 'YE2', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750324152, ExchCode = 'FRA' WHERE SecCode = 2232877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475831441, ExchCode = 'DEU' WHERE SecCode = 2235767 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569830, ExchCode = 'QTX' WHERE SecCode = 2239280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524108941, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2240547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784838122, ExchCode = 'QTX' WHERE SecCode = 2246863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642068249, ExchCode = 'FRA' WHERE SecCode = 2257444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531135776, ExchCode = 'BCO' WHERE SecCode = 2257484 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576247697, ExchCode = 'FRA' WHERE SecCode = 2272696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525845974, ExchCode = 'TDG' WHERE SecCode = 2278245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656675187, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 2279732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854585, ExchCode = 'BER', PermQuoteRetireDate = '2020-12-29' WHERE SecCode = 2288362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783783671, ExchCode = 'QTX' WHERE SecCode = 2328709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21535834371, ExchCode = 'DEU' WHERE SecCode = 2338094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993732862, ExchCode = 'CHI' WHERE SecCode = 2346276 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 2346277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993732826, ExchCode = 'BTE' WHERE SecCode = 2346281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21993732824, ExchCode = 'BTE' WHERE SecCode = 2346282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594380294, ExchCode = 'FRA', PermQuoteRetireDate = '2024-05-16' WHERE SecCode = 2356509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676252, ExchCode = 'BIV' WHERE SecCode = 2359427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780375187, ExchCode = 'TDG' WHERE SecCode = 2365611 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21790876764, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2023-10-26', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 2366514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530840197, ExchCode = 'FRA' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756136975, ExchCode = 'FRA' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130921495, ExchCode = 'DEU' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2379725 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 = 21532177823, ExchCode = 'FRA', PermQuoteRetireDate = '2019-11-06' WHERE SecCode = 2396449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532984899, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532811302, ExchCode = 'FRA' WHERE SecCode = 2403143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786676622, ExchCode = 'MEX' WHERE SecCode = 2414027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532914219, ExchCode = 'STU' WHERE SecCode = 2414149 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 2433100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842517697, ExchCode = 'SGO' WHERE SecCode = 2435334 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2438996 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704199, ExchCode = 'MXQ' WHERE SecCode = 2455541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537245207, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 2466348 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21753896162, ExchCode = 'DUS', PermQuoteRetireDate = '2020-10-27' WHERE SecCode = 2484919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797555632, ExchCode = 'DEU' WHERE SecCode = 2502550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597458278, Ticker = '22N', ExchCode = 'BER', PermQuoteRetireDate = '2023-10-03' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2515724 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784385079, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2529636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545188944, ExchCode = 'STU' WHERE SecCode = 2532821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539609267, ExchCode = 'FRA' WHERE SecCode = 2536096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619324261, ExchCode = 'FRA', PermQuoteRetireDate = '2021-03-12' WHERE SecCode = 2539010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629786303, ExchCode = 'DEU' WHERE SecCode = 2539933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541776155, ExchCode = 'BER', PermQuoteRetireDate = '2016-05-06' WHERE SecCode = 2541461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673930, ExchCode = 'BIV' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21620652670, ExchCode = 'STU' WHERE SecCode = 2545065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540103484, ExchCode = 'FRA' WHERE SecCode = 2554904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21713461691, ExchCode = 'DEU' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542469532, ExchCode = 'DEU' WHERE SecCode = 2567216 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548652886, ExchCode = 'STU' WHERE SecCode = 2568910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782012631, ExchCode = 'FRA' WHERE SecCode = 2585381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121993813, ExchCode = 'BTE' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800228279, ExchCode = 'FRA' WHERE SecCode = 2593543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 2599278 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 2600076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22067641916, ExchCode = 'BCO' WHERE SecCode = 2600378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663939434, PermQuoteStatus = 'DC', Ticker = 'L003', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 2604394 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 2606472 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 2606508 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 2606509 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 2606510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381402, ExchCode = 'LAS' WHERE SecCode = 2616472 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722349014, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 2627627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384982, ExchCode = 'LAS' WHERE SecCode = 2630989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548046381, ExchCode = 'STU' WHERE SecCode = 2642452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587934135, ExchCode = 'FRA' WHERE SecCode = 2649166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549411041, ExchCode = 'FRA', PermQuoteRetireDate = '2017-11-02' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842460842, ExchCode = 'HAN' WHERE SecCode = 2659980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550189612, ExchCode = 'FRA' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550408230, ExchCode = 'DEU' WHERE SecCode = 2679857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480323, ExchCode = 'QTX' WHERE SecCode = 2694712 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727309229, ExchCode = 'MEX' WHERE SecCode = 2715641 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5063245103, PriInstrPermID = NULL, IsPrimaryInstr = 0, IncCntry = 'HKG', PermOrgIPODate = NULL WHERE SecCode = 2720693 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 2724328 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 2727772 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-12-10' WHERE SecCode = 2727843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273765, ExchCode = 'GTX' WHERE SecCode = 2731233 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553634480, Ticker = 'TUINl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-05-20' WHERE SecCode = 2731347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554504075, ExchCode = 'FRA' WHERE SecCode = 2750981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554500349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-03' WHERE SecCode = 2750984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335786, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2770609 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-12-10' WHERE SecCode = 2785001 AND Type_ = 10;
UPDATE data_universe_permid SET QuoteClass = 'ORD', InstrClass = 'ORD', PermSecMapEndDate = '2026-04-18' WHERE SecCode = 2796968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 2810907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634749387, ExchCode = 'MUN' WHERE SecCode = 2830909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386757, ExchCode = 'LAS' WHERE SecCode = 2835193 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642375032, ExchCode = 'DEU' WHERE SecCode = 2849922 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2851643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561140926, ExchCode = 'DEU' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460777, ExchCode = 'FRA' WHERE SecCode = 2864471 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569832692, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-03' WHERE SecCode = 2880970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596035551, ExchCode = 'STU' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386769, ExchCode = 'LAS' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667480199, ExchCode = 'QTX' WHERE SecCode = 2887325 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 2891367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701551, Ticker = 'EXX1', ExchCode = 'BRN' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045077770, ExchCode = 'LAS' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 2906382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478659, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2909243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957529794, ExchCode = 'QTX' WHERE SecCode = 2909909 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667493096, ExchCode = 'QTX' WHERE SecCode = 2919727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915623096, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 2921698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21618470319, ExchCode = 'GER', PermQuoteRetireDate = '2017-08-21', PermSecMapEndDate = '2024-05-20' WHERE SecCode = 2935091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21941765774, ExchCode = 'BER' WHERE SecCode = 2940839 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 = 21645306003, ExchCode = 'DEU' WHERE SecCode = 2955208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659445, ExchCode = 'GTX' WHERE SecCode = 2963601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488199, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21573048228, ExchCode = 'BCO', PermQuoteRetireDate = '2015-10-12' WHERE SecCode = 2993543 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3002454 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-12-10' WHERE SecCode = 3004064 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000040143, PriInstrPermID = 8591005052.0, PermOrgIPODate = '2008-06-12' WHERE SecCode = 3025383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21576069516, ExchCode = 'DEU' WHERE SecCode = 3031579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659181386, ExchCode = 'MUN' WHERE SecCode = 3032214 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 3033824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386809, ExchCode = 'LAS' WHERE SecCode = 3033925 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3046326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861160325, ExchCode = 'QTX' WHERE SecCode = 3069354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295850, ExchCode = 'GTX' WHERE SecCode = 3074354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786875321, ExchCode = 'DEU' WHERE SecCode = 3076712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787344, Ticker = '42P', ExchCode = 'DUS', PermQuoteRetireDate = '2021-03-16' WHERE SecCode = 3096965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219349, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 3116971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650245, ExchCode = 'DUS' WHERE SecCode = 3130985 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3130994 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3150847 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3150848 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3150849 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3150850 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636371658, ExchCode = 'STU' WHERE SecCode = 3153872 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3156223 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3157224 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3157226 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3157227 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3157232 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3160165 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3160166 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3162597 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3162600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587662536, ExchCode = 'STU' WHERE SecCode = 3165880 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3166455 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3166456 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3166457 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3166458 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3167371 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3167372 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3167373 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3167381 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3167788 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779790760, ExchCode = 'GTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3169817 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3169818 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3169819 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3169820 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3169821 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3169822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782414421, ExchCode = 'STU' WHERE SecCode = 3172340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887241163, ExchCode = 'CHI' WHERE SecCode = 3174320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21631076036, ExchCode = 'TDG', PermQuoteRetireDate = '2024-10-17' WHERE SecCode = 3177608 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3181384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21662322270, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3183538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21901754747, ExchCode = 'BCO' WHERE SecCode = 3193718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22066264761, Ticker = '3EMSl', ExchCode = 'BTE' WHERE SecCode = 3193774 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3194941 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 3198702 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 3198703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768480038, ExchCode = 'MUN' WHERE SecCode = 3199702 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3200923 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 3200928 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 3200929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21769880745, ExchCode = 'FRA' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21962344738, Ticker = '1VOW3m', ExchCode = 'BTE' WHERE SecCode = 3212165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591801382, ExchCode = 'BER' WHERE SecCode = 3212190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783235612, ExchCode = 'STU' WHERE SecCode = 3213268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607191, Ticker = 'GLW', ExchCode = 'SWX' WHERE SecCode = 3222694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593186021, ExchCode = 'DEU' WHERE SecCode = 3223011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789234589, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3223076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21683901733, ExchCode = 'MUN', PermQuoteRetireDate = '2020-08-11' WHERE SecCode = 3241570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780659429, ExchCode = 'GTX' WHERE SecCode = 3244403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821641748, ExchCode = 'DUS' WHERE SecCode = 3245391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478399, ExchCode = 'QTX' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591485238, Ticker = '1CBK', ExchCode = 'MIL' WHERE SecCode = 3247531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599524546, ExchCode = 'STU' WHERE SecCode = 3255527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597621838, ExchCode = 'FRA' WHERE SecCode = 3255528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597702791, ExchCode = 'DEU' WHERE SecCode = 3257180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643695294, ExchCode = 'FRA' WHERE SecCode = 3257553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166738, ExchCode = 'DEU' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3260772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21995867781, ExchCode = 'TRQ' WHERE SecCode = 3275560 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3275657 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3275693 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3275694 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21601639661, ExchCode = 'TDG' WHERE SecCode = 3277475 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520286, ExchCode = 'QTX' WHERE SecCode = 3281992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387859, ExchCode = 'LAS' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755986454, ExchCode = 'QTX' WHERE SecCode = 3282701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603342349, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3283956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561791, ExchCode = 'GTX' WHERE SecCode = 3284992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21603214883, ExchCode = 'STU', PermQuoteRetireDate = '2026-02-06' WHERE SecCode = 3285135 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 3285733 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 3289752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857633427, ExchCode = 'QTX' WHERE SecCode = 3303268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606833126, ExchCode = 'FRA' WHERE SecCode = 3304184 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 = 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 = 21611220164, ExchCode = 'TDG' WHERE SecCode = 3317384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705372, ExchCode = 'MXQ' WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609516, ExchCode = 'DUS' WHERE SecCode = 3319220 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610682901, Ticker = 'VEONa', ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286060, ExchCode = 'GTX' WHERE SecCode = 3320207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297854, ExchCode = 'DUS' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793910667, ExchCode = 'QTX' WHERE SecCode = 3337223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419079, ExchCode = 'LAS' WHERE SecCode = 3337707 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3338464 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3338465 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3338466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295882, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3338530 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3339538 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643067252, ExchCode = 'TDG' WHERE SecCode = 3339668 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3347764 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3348764 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773002549, ExchCode = 'FRA' WHERE SecCode = 3356351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614735175, ExchCode = 'DEU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-03-19' WHERE SecCode = 3358234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627708, ExchCode = 'QTX' WHERE SecCode = 3367946 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875267, ExchCode = 'TDG' WHERE SecCode = 3368562 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749591716, Ticker = '90S1', ExchCode = 'STU', PermQuoteRetireDate = '2024-08-14' WHERE SecCode = 3371094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648301745, ExchCode = 'STU' WHERE SecCode = 3374718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762320101, ExchCode = 'DEU' WHERE SecCode = 3378003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658642103, ExchCode = 'MUN' WHERE SecCode = 3385212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100894, ExchCode = 'DUS' WHERE SecCode = 3394481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659667, ExchCode = 'LAS' WHERE SecCode = 3394497 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3397141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800300158, ExchCode = 'FRA' WHERE SecCode = 3397198 AND Type_ = 10;
UPDATE data_universe_permid SET QuoteClass = 'ORD', InstrClass = 'ORD', PermSecMapEndDate = '2026-04-18' WHERE SecCode = 3403875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195409, ExchCode = 'DUS' WHERE SecCode = 3403947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714657389, ExchCode = 'DEU' WHERE SecCode = 3405059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796757245, ExchCode = 'FRA' WHERE SecCode = 3407867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800223463, ExchCode = 'LAS' WHERE SecCode = 3407871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786105863, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-21' WHERE SecCode = 3408942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396811, ExchCode = 'FRA' WHERE SecCode = 3409090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801287178, Ticker = 'C0B', ExchCode = 'STU' WHERE SecCode = 3410283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780314324, ExchCode = 'GTX' WHERE SecCode = 3430576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387007, ExchCode = 'LAS', PermQuoteRetireDate = '2026-03-17', PermSecMapEndDate = NULL WHERE SecCode = 3431060 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'GVTDA' WHERE SecCode = 3432664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21636066861, ExchCode = 'DEU' WHERE SecCode = 3435060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706312, ExchCode = 'MXQ' WHERE SecCode = 3440422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642186352, ExchCode = 'FRA' WHERE SecCode = 3441258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643435010, ExchCode = 'FRA' WHERE SecCode = 3441711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644011375, ExchCode = 'DEU' WHERE SecCode = 3445093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643807094, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3445201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21644367377, ExchCode = 'DEU' WHERE SecCode = 3445258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071844, ExchCode = 'FRA', PermQuoteRetireDate = '2019-12-30' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3446899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21925498341, ExchCode = 'STU' WHERE SecCode = 3490818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647042623, ExchCode = 'FRA' WHERE SecCode = 3490819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647042502, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647200544, ExchCode = 'FRA', PermQuoteRetireDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647152171, ExchCode = 'FRA' WHERE SecCode = 3490823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647142964, ExchCode = 'DEU' WHERE SecCode = 3490824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776247331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3503523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690813059, Ticker = 'REL', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-14' WHERE SecCode = 3510596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21660431273, ExchCode = 'FRA' WHERE SecCode = 3529093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778241860, ExchCode = 'A2X' WHERE SecCode = 3531591 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21653848411, Ticker = 'TGL', ExchCode = 'LSE', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3536053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664223, ExchCode = 'MUN' WHERE SecCode = 3539018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21922259627, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296299, ExchCode = 'GTX' WHERE SecCode = 3543197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21994180608, ExchCode = 'BTE' WHERE SecCode = 3547843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663166796, ExchCode = 'FRA' WHERE SecCode = 3550423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710951296, ExchCode = 'BTE' WHERE SecCode = 3550579 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923658469, ExchCode = 'EQD' WHERE SecCode = 3551896 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3553153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797237688, ExchCode = 'STU' WHERE SecCode = 3555037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656740299, Ticker = 'DNKl', ExchCode = 'BCO', PermQuoteRetireDate = '2022-01-20' WHERE SecCode = 3557524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656850928, ExchCode = 'FRA' WHERE SecCode = 3558191 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'CSQ0' WHERE SecCode = 3558196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688418703, ExchCode = 'QTX', PermQuoteRetireDate = '2023-02-07', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 3565802 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837358321, Ticker = 'CS9', ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 3586971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647732047, ExchCode = 'TDG' WHERE SecCode = 3586984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21908250210, ExchCode = 'TDG' WHERE SecCode = 3587019 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559909557, ExchCode = 'TDG' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 3587041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296175, ExchCode = 'GTX' WHERE SecCode = 3588083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544661, ExchCode = 'DUS' WHERE SecCode = 3588111 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663316444, ExchCode = 'FRA', PermQuoteRetireDate = '2020-04-16' WHERE SecCode = 3588341 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952428, ExchCode = 'FRA' WHERE SecCode = 3591601 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3610328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893299383, ExchCode = 'GTX' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3619203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308437, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 3629856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21669468854, ExchCode = 'MUN', PermQuoteRetireDate = '2024-01-09' WHERE SecCode = 3644854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 3672934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918858, ExchCode = 'FRA' WHERE SecCode = 3675860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675373923, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3690817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21675114251, ExchCode = 'FRA' WHERE SecCode = 3694578 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3713259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21838659590, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3719703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679877079, ExchCode = 'FRA' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21947054171, ExchCode = 'FRA' WHERE SecCode = 3738157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21680901263, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-03' WHERE SecCode = 3738158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830306678, ExchCode = 'GTX' WHERE SecCode = 3746657 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803135585, ExchCode = 'FRA' WHERE SecCode = 3756337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788220426, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 3756592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682712565, ExchCode = 'STU' WHERE SecCode = 3756596 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800738274, ExchCode = 'QTX', PermQuoteRetireDate = '2023-06-02' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240701, ExchCode = 'MUN', PermQuoteRetireDate = '2025-04-25', PermSecMapEndDate = NULL WHERE SecCode = 3773515 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727381710, ExchCode = 'MEX' WHERE SecCode = 3774540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688007392, ExchCode = 'MUN', PermQuoteRetireDate = '2022-12-01' WHERE SecCode = 3775420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758727556, ExchCode = 'MUN', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3779971 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 QuotePermID = 236784380275, ExchCode = 'LAS' WHERE SecCode = 3787147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21687895438, ExchCode = 'STU' WHERE SecCode = 3793375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21725198213, ExchCode = 'FRA' WHERE SecCode = 3794696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673884743, Ticker = 'IPCON', ExchCode = 'MXQ', PermQuoteRetireDate = '2021-08-17' WHERE SecCode = 3796494 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-03-19' WHERE SecCode = 3800520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21749597748, ExchCode = 'FRA' WHERE SecCode = 3800553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734047256, ExchCode = 'TDG' WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747496810, ExchCode = 'DUS' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690339113, ExchCode = 'TDG' WHERE SecCode = 3809861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21690636309, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3812238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679917567, Ticker = 'WUBAN', ExchCode = 'MXQ' WHERE SecCode = 3814192 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694900840, ExchCode = 'QTX' WHERE SecCode = 3817314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21691003037, ExchCode = 'DEU' WHERE SecCode = 3817316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21691134946, ExchCode = 'FRA' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561794, ExchCode = 'GTX' WHERE SecCode = 3818167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799611251, ExchCode = 'GTX', PermQuoteRetireDate = '2026-04-01' WHERE SecCode = 3819180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774911159, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3821931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394215, ExchCode = 'MEX' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789617001, ExchCode = 'BIV' WHERE SecCode = 3827965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650319, ExchCode = 'QTX' WHERE SecCode = 3829975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21694642699, Ticker = 'UT8d', ExchCode = 'BCO' WHERE SecCode = 3830032 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732297937, Ticker = 'BM5', ExchCode = 'DUS', PermQuoteRetireDate = '2020-02-03' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607048, Ticker = 'NVAX', ExchCode = 'SWX' WHERE SecCode = 3831364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803902914, ExchCode = 'FRA' WHERE SecCode = 3831366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21744918923, ExchCode = 'FRA' WHERE SecCode = 3832749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581795, ExchCode = 'DUS' WHERE SecCode = 3832750 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 QuotePermID = 21865864997, ExchCode = 'BER', PermQuoteRetireDate = '2022-08-18' WHERE SecCode = 3847122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21841766443, ExchCode = 'QTX' WHERE SecCode = 3848225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387101, ExchCode = 'LAS' WHERE SecCode = 3849234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727371245, ExchCode = 'BIV' WHERE SecCode = 3851577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727373517, ExchCode = 'MEX' WHERE SecCode = 3854663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787746616, ExchCode = 'SIU', PermQuoteRetireDate = '2025-01-04' WHERE SecCode = 3856714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781830030, ExchCode = 'QTX' WHERE SecCode = 3863388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21705621141, ExchCode = 'QTX' WHERE SecCode = 3871754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727381720, ExchCode = 'BIV' WHERE SecCode = 3875536 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21701895330, ExchCode = 'STU' WHERE SecCode = 3875755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783353726, ExchCode = 'QTX', PermQuoteRetireDate = '2026-01-05', PermSecMapEndDate = '2026-01-05' WHERE SecCode = 3877613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633180217, Ticker = '0JOQ', ExchCode = 'LSE' WHERE SecCode = 3885297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727368210, ExchCode = 'MEX' WHERE SecCode = 3890234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381786, ExchCode = 'LAS' WHERE SecCode = 3894966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569884, ExchCode = 'QTX' WHERE SecCode = 3899637 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709209283, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3912532 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 3912534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820592777, ExchCode = 'QTX' WHERE SecCode = 3921329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679348107, ExchCode = 'BIV' WHERE SecCode = 3934323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272890, ExchCode = 'GTX' WHERE SecCode = 3951450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712452863, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3955660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731991069, ExchCode = 'MUN' WHERE SecCode = 3977296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659626, ExchCode = 'LAS' WHERE SecCode = 3997065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718474201, ExchCode = 'FRA' WHERE SecCode = 3998157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273865, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4001066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098633, ExchCode = 'STU' WHERE SecCode = 4004564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359626, ExchCode = 'BIV' WHERE SecCode = 4024645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359395, ExchCode = 'SIG' WHERE SecCode = 4024795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026823, Ticker = '1T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026845, Ticker = '1GLW' WHERE SecCode = 4031714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027121, Ticker = '1CVX' WHERE SecCode = 4031716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026831, Ticker = '1AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027042, Ticker = '1AAD' WHERE SecCode = 4031778 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011579, Ticker = '2AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782489778, Ticker = '1BRE' WHERE SecCode = 4031818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784327741, Ticker = '1BOD' WHERE SecCode = 4031822 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026770, Ticker = '1DE' WHERE SecCode = 4031840 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011005, Ticker = '2DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999009871, Ticker = '2EUZ' WHERE SecCode = 4031863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026810, Ticker = '1G' WHERE SecCode = 4031878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026915, Ticker = '1HOG' WHERE SecCode = 4031890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655813, Ticker = '4HEIA', ExchCode = 'ETX' WHERE SecCode = 4031893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027132, Ticker = '1HFG' WHERE SecCode = 4031894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026954, Ticker = '1HOT' WHERE SecCode = 4031902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026869, Ticker = '1INTU' WHERE SecCode = 4031911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026971, Ticker = '1LXS' WHERE SecCode = 4031934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026785, Ticker = '1NDX' WHERE SecCode = 4031953 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597655815, Ticker = '4RI', ExchCode = 'ETX' WHERE SecCode = 4031971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027139, Ticker = '1PAH' WHERE SecCode = 4031975 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787861869, Ticker = '1PYPLm', ExchCode = 'BCO' WHERE SecCode = 4031977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026822, Ticker = '1REGN' WHERE SecCode = 4031980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026833, Ticker = '1RHM' WHERE SecCode = 4031982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682843016, Ticker = '4UCB', ExchCode = 'ETX' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026881, Ticker = '1ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026796, Ticker = '1IAG' WHERE SecCode = 4032120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143990, Ticker = '2DSY', ExchCode = 'MIL' WHERE SecCode = 4032132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21723633853, ExchCode = 'MUN' WHERE SecCode = 4032148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195044, ExchCode = 'STU' WHERE SecCode = 4032154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026759, Ticker = '1DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796184449, ExchCode = 'SIG' WHERE SecCode = 4033113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179786, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779134244, ExchCode = 'AQX' WHERE SecCode = 4035746 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4041303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571645915, ExchCode = 'SGO' WHERE SecCode = 4046481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838220597, Ticker = 'OCPET', ExchCode = 'BRU', PermQuoteRetireDate = '2023-10-02' WHERE SecCode = 4046600 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681997890, ExchCode = 'FRA' WHERE SecCode = 4046659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796330824, ExchCode = 'HAM' WHERE SecCode = 4046669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788219439, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4046673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729105331, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4056300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729412447, ExchCode = 'FRA' WHERE SecCode = 4059429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21729887692, ExchCode = 'STU', PermQuoteRetireDate = '2025-09-05', PermSecMapEndDate = NULL WHERE SecCode = 4062000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870301372, ExchCode = 'MUN' WHERE SecCode = 4068293 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 = 236782414982, ExchCode = 'QTX' WHERE SecCode = 4080599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732154086, ExchCode = 'DEU' WHERE SecCode = 4080678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732779663, ExchCode = 'MUN' WHERE SecCode = 4081943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783583592, ExchCode = 'CHI', PermQuoteRetireDate = '2025-06-10' WHERE SecCode = 4081958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732286747, ExchCode = 'FRA' WHERE SecCode = 4081959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388401, ExchCode = 'LAS' WHERE SecCode = 4081961 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727355175, ExchCode = 'MEX' WHERE SecCode = 4081964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734028297, ExchCode = 'MUN' WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727356458, ExchCode = 'MEX' WHERE SecCode = 4090018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738262837, Ticker = '5C8', ExchCode = 'FRA' WHERE SecCode = 4090028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739443375, PermQuoteStatus = 'AC', Ticker = 'JARU', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4092157 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21743260354, ExchCode = 'FRA' WHERE SecCode = 4099601 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4101078 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 4103442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587084065, ExchCode = 'STU' WHERE SecCode = 4103598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387195, ExchCode = 'LAS' WHERE SecCode = 4103690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976737, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4106680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21737082360, ExchCode = 'DUS' 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 = 21830308301, ExchCode = 'GTX' WHERE SecCode = 4110887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586975, ExchCode = 'FRA' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963671, ExchCode = 'STU' WHERE SecCode = 4124714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858461751, ExchCode = 'STU', PermQuoteRetireDate = '2024-11-05', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4124848 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704289, ExchCode = 'MXQ' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' WHERE SecCode = 4171586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381466, ExchCode = 'LAS' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745664579, ExchCode = 'STU' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755406168, ExchCode = 'STU' WHERE SecCode = 4195320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963695, ExchCode = 'TDG', PermQuoteRetireDate = '2025-03-17' WHERE SecCode = 4204823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746262875, ExchCode = 'DEU' WHERE SecCode = 4209695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788611415, ExchCode = 'FRA' WHERE SecCode = 4209753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772634388, ExchCode = 'DUS' WHERE SecCode = 4212482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747988879, ExchCode = 'QTX' WHERE SecCode = 4212561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740527, ExchCode = 'LAS' WHERE SecCode = 4225217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727347435, ExchCode = 'MEX' WHERE SecCode = 4256652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349640, ExchCode = 'MEX' WHERE SecCode = 4259231 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755406183, ExchCode = 'DEU' WHERE SecCode = 4267228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756549060, ExchCode = 'DEU', PermQuoteRetireDate = '2020-07-08' WHERE SecCode = 4274159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684880, ExchCode = 'QTX' WHERE SecCode = 4274161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056950, ExchCode = 'DUS' WHERE SecCode = 4275166 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756809736, ExchCode = 'DEU' WHERE SecCode = 4275420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756809734, ExchCode = 'FRA' WHERE SecCode = 4275421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487599, ExchCode = 'QTX' WHERE SecCode = 4278854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757260444, ExchCode = 'FRA' WHERE SecCode = 4278855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781628095, ExchCode = 'DUS' WHERE SecCode = 4278857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552518785, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 4282397 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755360719, ExchCode = 'BER' WHERE SecCode = 4288879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22063011499, ExchCode = 'DEU' WHERE SecCode = 4294160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759692063, ExchCode = 'DEU' WHERE SecCode = 4295731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763122567, ExchCode = 'MUN' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21760973387, ExchCode = 'QTX' WHERE SecCode = 4303570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580118, ExchCode = 'FRA' WHERE SecCode = 4316189 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21762580175, ExchCode = 'DEU' WHERE SecCode = 4316190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782582731, ExchCode = 'MUN' WHERE SecCode = 4324465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801716826, ExchCode = 'TDG' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21766441949, ExchCode = 'STU' WHERE SecCode = 4324721 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21764112355, ExchCode = 'FRA' WHERE SecCode = 4328959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781601742, PermQuoteStatus = 'AC', ExchCode = 'GER', PermQuoteRetireDate = NULL WHERE SecCode = 4359837 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768618356, Ticker = '0A3M', ExchCode = 'LSE' WHERE SecCode = 4359924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791494702, PermQuoteStatus = 'AC', ExchCode = 'JAX', PermQuoteRetireDate = NULL WHERE SecCode = 4365821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799675, ExchCode = 'HAM' WHERE SecCode = 4365921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805846657, ExchCode = 'GER' WHERE SecCode = 4369879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380457, ExchCode = 'LAS' WHERE SecCode = 4372550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538206, ExchCode = 'GTX' WHERE SecCode = 4372740 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606711, ExchCode = 'FRA' WHERE SecCode = 4375237 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510749, ExchCode = 'DUS' WHERE SecCode = 4375238 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650250, ExchCode = 'DUS' WHERE SecCode = 4379790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777644859, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794594488, ExchCode = 'FRA' WHERE SecCode = 4380755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830294239, ExchCode = 'GTX' WHERE SecCode = 4383000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21738813552, ExchCode = 'STU' WHERE SecCode = 4383309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238824, ExchCode = 'LAS' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775812436, ExchCode = 'FRA', PermQuoteRetireDate = '2022-08-09' WHERE SecCode = 4385267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307749, ExchCode = 'MEX' WHERE SecCode = 4404027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234893, ExchCode = 'BER' WHERE SecCode = 4413712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783161157, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377503, ExchCode = 'MEX' WHERE SecCode = 4417298 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312696, ExchCode = 'MEX' WHERE SecCode = 4420916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803077161, ExchCode = 'FRA' WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727304579, ExchCode = 'BIV' WHERE SecCode = 4421213 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 4423829 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999209, ExchCode = 'DEU' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782846259, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2026-02-11', PermSecMapEndDate = '2026-02-11' WHERE SecCode = 4423907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370427, ExchCode = 'AQX' WHERE SecCode = 4423997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727312259, ExchCode = 'MEX' WHERE SecCode = 4424570 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727303272, ExchCode = 'MEX' WHERE SecCode = 4426957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928415121, ExchCode = 'SIU' WHERE SecCode = 4426958 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779047734, ExchCode = 'BER', PermQuoteRetireDate = '2024-04-05', PermSecMapEndDate = NULL WHERE SecCode = 4427929 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4433927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785454242, ExchCode = 'STU' WHERE SecCode = 4434247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784912086, ExchCode = 'DEU' WHERE SecCode = 4434248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785625919, ExchCode = 'FRA' WHERE SecCode = 4434305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784600486, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4436991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787027751, PermQuoteStatus = 'DC', Ticker = '60P', ExchCode = 'STU', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4444001 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 4444652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21787553936, ExchCode = 'DEU', PermQuoteRetireDate = '2021-01-07' WHERE SecCode = 4446127 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788448773, ExchCode = 'STU' WHERE SecCode = 4447601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740612, ExchCode = 'LAS' WHERE SecCode = 4449679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854730428, ExchCode = 'STU', PermQuoteRetireDate = '2023-07-31', PermSecMapEndDate = NULL WHERE SecCode = 4449703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727299967, ExchCode = 'MEX' WHERE SecCode = 4449704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791908410, ExchCode = 'TDG' WHERE SecCode = 4451262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475503804, ExchCode = 'SGO' WHERE SecCode = 4456118 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793689536, ExchCode = 'DEU' WHERE SecCode = 4463152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956950, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4466620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794060560, ExchCode = 'STU' WHERE SecCode = 4472910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396601, ExchCode = 'FRA' WHERE SecCode = 4472926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830307201, ExchCode = 'GTX' WHERE SecCode = 4474245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21897786131, ExchCode = 'MUN' WHERE SecCode = 4474389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794070549, ExchCode = 'DEU' WHERE SecCode = 4476795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793528202, ExchCode = 'DUS' WHERE SecCode = 4476811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659480, ExchCode = 'LAS' WHERE SecCode = 4477048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781362966, ExchCode = 'DUS', PermQuoteRetireDate = '2024-02-20' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797545446, ExchCode = 'TDG' WHERE SecCode = 4479186 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794808262, ExchCode = 'STU' WHERE SecCode = 4479188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367255, ExchCode = 'DEU' WHERE SecCode = 4482517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367200, ExchCode = 'DEU', PermQuoteRetireDate = '2023-06-30', PermSecMapEndDate = NULL WHERE SecCode = 4482720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795956114, ValQuotePermID = NULL, IsPrimaryQuote = 0, Ticker = 'AKHo', ExchCode = 'BCO' WHERE SecCode = 4484488 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = NULL WHERE SecCode = 4484496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727291861, ExchCode = 'BIV' WHERE SecCode = 4485970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796870257, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805539059, ExchCode = 'QTX' WHERE SecCode = 4491934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797238012, ExchCode = 'DEU' WHERE SecCode = 4494227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797809534, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4499132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820607, ExchCode = 'FRA' WHERE SecCode = 4499152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799006387, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-24', PermSecMapEndDate = NULL WHERE SecCode = 4499277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795591035, Ticker = '0A6N', ExchCode = 'LSE' WHERE SecCode = 4500467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797994407, ExchCode = 'STU' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830285966, ExchCode = 'GTX' WHERE SecCode = 4505789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727286505, ExchCode = 'BIV' WHERE SecCode = 4505794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802851613, ExchCode = 'STU', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386877, ExchCode = 'LAS' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386713, ExchCode = 'LAS' WHERE SecCode = 4513650 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296365, ExchCode = 'GTX' WHERE SecCode = 4513651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181247, ExchCode = 'DUS' WHERE SecCode = 4517645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097130, ExchCode = 'LAS' WHERE SecCode = 4517834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781458722, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4517877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801723138, ExchCode = 'FRA' WHERE SecCode = 4521258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802440518, ExchCode = 'QTX' WHERE SecCode = 4524458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802422923, ExchCode = 'FRA' WHERE SecCode = 4526142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802430411, ExchCode = 'DEU' WHERE SecCode = 4526143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954971, ExchCode = 'LAS' WHERE SecCode = 4536359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808935929, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02', PermSecMapEndDate = NULL WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821271834, ExchCode = 'STU' WHERE SecCode = 4537890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804816877, ExchCode = 'STU' WHERE SecCode = 4537893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271947, ExchCode = 'MEX' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4550497 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4550499 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857143288, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2024-08-08' WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806896207, ExchCode = 'FRA' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4550806 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4550807 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4552179 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4552182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806812473, ExchCode = 'DEU' WHERE SecCode = 4557784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808388561, PermQuoteStatus = 'DC', Ticker = '3K70', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-10' WHERE SecCode = 4557860 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4557906 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4557907 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4558020 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 4561699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140274066, ExchCode = 'BTE' WHERE SecCode = 4563419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830303213, ExchCode = 'GTX' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811980857, ExchCode = 'MUN' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22135794225, Ticker = 'XLME', ExchCode = 'HAM' WHERE SecCode = 4579626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100496, ExchCode = 'QTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810406475, ExchCode = 'DEU' WHERE SecCode = 4586633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830312301, ExchCode = 'GTX' WHERE SecCode = 4590581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097262, ExchCode = 'LAS' WHERE SecCode = 4601728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830293687, ExchCode = 'GTX' WHERE SecCode = 4601736 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830295798, ExchCode = 'GTX' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-05-15' WHERE SecCode = 4608541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860843349, ExchCode = 'MUN' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816905312, ExchCode = 'TDG' WHERE SecCode = 4609998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727263611, ExchCode = 'MEX' WHERE SecCode = 4610049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837829658, ExchCode = 'STU', PermQuoteRetireDate = '2023-05-08' WHERE SecCode = 4611056 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816887015, PermQuoteStatus = 'AC', Ticker = 'ABTC', ExchCode = 'PAR', PermQuoteRetireDate = NULL WHERE SecCode = 4611064 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387260, PermQuoteStatus = 'DC', Ticker = 'WWT', ExchCode = 'LAS', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4615948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010091542, ExchCode = 'TQE' WHERE SecCode = 4617708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821642083, ExchCode = 'BTE', PermQuoteRetireDate = '2025-08-05' WHERE SecCode = 4617741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818264918, ExchCode = 'FRA' WHERE SecCode = 4617743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527324, ExchCode = 'DEU' WHERE SecCode = 4618010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534591, ExchCode = 'QTX' WHERE SecCode = 4626836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21899163259, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852758913, Ticker = '4KL', ExchCode = 'STU' WHERE SecCode = 4629496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21821283441, ExchCode = 'DEU' WHERE SecCode = 4630664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820739194, ExchCode = 'FRA' WHERE SecCode = 4631954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778677427, ExchCode = 'QTX' WHERE SecCode = 4632109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782629839, ExchCode = 'STU' WHERE SecCode = 4633100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799608110, ExchCode = 'LAS' WHERE SecCode = 4639636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650261, ExchCode = 'DUS', PermQuoteRetireDate = '2025-01-16', PermSecMapEndDate = '2025-01-17' WHERE SecCode = 4643054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963759, ExchCode = 'STU' WHERE SecCode = 4643141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780368954, ExchCode = 'TDG' WHERE SecCode = 4648214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824701678, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4649878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825617109, ExchCode = 'DEU' WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792996699, ExchCode = 'LAS' WHERE SecCode = 4651892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388759, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4658881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914397, ExchCode = 'STU' WHERE SecCode = 4671286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419029, ExchCode = 'LAS' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793314093, PermQuoteStatus = 'DC', Ticker = '94Y0', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 4682737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387315, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-15' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835319557, ExchCode = 'FRA' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316576, ExchCode = 'MUN' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388765, ExchCode = 'LAS' WHERE SecCode = 4689999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851139181, Ticker = '6XZ', ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-25', PermSecMapEndDate = '2023-08-10' WHERE SecCode = 4699239 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380604, ExchCode = 'LAS' WHERE SecCode = 4705895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933381561, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381548, ExchCode = 'LAS' WHERE SecCode = 4720518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851127888, ExchCode = 'DUS' WHERE SecCode = 4726106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21848757202, ExchCode = 'QTX' WHERE SecCode = 4727664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21846049959, ExchCode = 'FRA' WHERE SecCode = 4729059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852098536, ExchCode = 'DUS' WHERE SecCode = 4748505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859546343, ExchCode = 'GTX' WHERE SecCode = 4767878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855801983, ExchCode = 'DUS' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018892, ExchCode = 'STU' WHERE SecCode = 4773770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853439327, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-17' WHERE SecCode = 4773786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856710535, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4777235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856519699, ExchCode = 'STU' WHERE SecCode = 4777352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609722, ExchCode = 'DUS' 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 = 21857898826, ExchCode = 'FRA' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21858705625, ExchCode = 'STU' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789552638, ExchCode = 'LAS', PermQuoteRetireDate = '2025-06-19', PermSecMapEndDate = NULL WHERE SecCode = 4787454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615834, ExchCode = 'MUN' WHERE SecCode = 4800673 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172912433, ExchCode = 'SWX' WHERE SecCode = 4802290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727216812, ExchCode = 'BIV' WHERE SecCode = 4802294 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 = 21862739872, ExchCode = 'FRA' WHERE SecCode = 4812244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860859987, ExchCode = 'FRA' WHERE SecCode = 4813526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192644, ExchCode = 'DEU' WHERE SecCode = 4815350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863513304, ExchCode = 'DEU' WHERE SecCode = 4818264 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' WHERE SecCode = 4834793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789616854, ExchCode = 'QTX' WHERE SecCode = 4845025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888954019, ExchCode = 'MUN', PermQuoteRetireDate = '2022-08-19', PermSecMapEndDate = NULL WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 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 = 236783783667, ExchCode = 'QTX' WHERE SecCode = 4852142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871068068, ExchCode = 'FRA' WHERE SecCode = 4863017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872584363, ExchCode = 'FRA' WHERE SecCode = 4873682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781520266, ExchCode = 'QTX' WHERE SecCode = 4887144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877510550, ExchCode = 'STU' WHERE SecCode = 4887246 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 4887334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932177205, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876897799, Ticker = '2TRV', ExchCode = 'MIL' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510678, ExchCode = 'QTX' WHERE SecCode = 4911198 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21880715135, ExchCode = 'QTX' WHERE SecCode = 4927268 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907898780, ExchCode = 'DEU' WHERE SecCode = 4929498 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 = 236802471210, ExchCode = 'TDG' WHERE SecCode = 4940671 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 = 21883524288, ExchCode = 'DEU' WHERE SecCode = 4946404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21953910370, ExchCode = 'DUS' WHERE SecCode = 4952514 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951924.0 WHERE SecCode = 4956739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21887740504, ExchCode = 'STU' WHERE SecCode = 4969490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21936307256, ExchCode = 'MUN' WHERE SecCode = 4969558 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 21933953328, ExchCode = 'STU' WHERE SecCode = 5011695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387449, ExchCode = 'LAS' WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22153246013, ExchCode = 'BTE' WHERE SecCode = 5038692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21902924195, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5041763 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21735976743, ExchCode = 'TDG', PermQuoteRetireDate = '2023-08-24' WHERE SecCode = 5042969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727380611, Ticker = 'DC4', ExchCode = 'BRN' WHERE SecCode = 5047087 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788890733, ExchCode = 'QTX' WHERE SecCode = 5047099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238786, ExchCode = 'LAS' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076711, ExchCode = 'LAS' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911085, ExchCode = 'MUN' WHERE SecCode = 5075859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380635, ExchCode = 'LAS' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740520, ExchCode = 'LAS' WHERE SecCode = 5082548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026880, Ticker = '1KDP' WHERE SecCode = 5107765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779370469, ExchCode = 'GTX' WHERE SecCode = 5123687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913101536, ExchCode = 'QTX' WHERE SecCode = 5129748 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912121144, ExchCode = 'FRA' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535489, ExchCode = 'FRA' WHERE SecCode = 5134589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21915977241, ExchCode = 'DEU' WHERE SecCode = 5140247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830273208, ExchCode = 'GTX' WHERE SecCode = 5161225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633621506, Ticker = '0M1K', ExchCode = 'LSE' WHERE SecCode = 5161267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21758567887, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5161278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21730598077, ExchCode = 'FRA' WHERE SecCode = 5161282 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341320, Ticker = 'RPG', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 5161292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755973706, ExchCode = 'DUS' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792173203, ExchCode = 'FRA' WHERE SecCode = 5161343 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793473641, Ticker = 'WPMl', ExchCode = 'CHI' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348309, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667329289, ExchCode = 'FRA' WHERE SecCode = 5161350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752240683, Ticker = 'FT5A', ExchCode = 'MUN', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 5161374 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367923, ExchCode = 'BEC' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305815, ExchCode = 'BIV' WHERE SecCode = 5161409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348366, ExchCode = 'MEX' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727360442, ExchCode = 'MEX' WHERE SecCode = 5161415 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850513498, ExchCode = 'FRA' WHERE SecCode = 5161417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954561584, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650379, ExchCode = 'QTX' WHERE SecCode = 5166812 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783316559, ExchCode = 'STU' WHERE SecCode = 5168258 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 QuotePermID = 21933953345, ExchCode = 'TDG' WHERE SecCode = 5189077 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659585, ExchCode = 'LAS' WHERE SecCode = 5194304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945430509, ExchCode = 'STU' WHERE SecCode = 5194305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783782321, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5230330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21930005423, ExchCode = 'FRA' WHERE SecCode = 5230331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780478262, PermQuoteStatus = 'DC', Ticker = 'VJ3', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5230332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951901113, ExchCode = 'MUN' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793845610, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-26' WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 = 236780027032, Ticker = '1HU3' WHERE SecCode = 5258607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21938340072, ExchCode = 'STU' WHERE SecCode = 5277532 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851306, ExchCode = 'LAS' WHERE SecCode = 5281346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758789, ExchCode = 'MUN', PermQuoteRetireDate = '2025-06-17', PermSecMapEndDate = NULL WHERE SecCode = 5283651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795036242, ExchCode = 'LAS' WHERE SecCode = 5283694 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'P*' WHERE SecCode = 5292533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380705, ExchCode = 'LAS' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778803327, ExchCode = 'DUS' WHERE SecCode = 5297998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380709, ExchCode = 'LAS' WHERE SecCode = 5343608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791510353, ExchCode = 'MUN' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633707, ExchCode = 'DEU' 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 = 21958061854, Ticker = 'ACAGv', ExchCode = 'BCO' WHERE SecCode = 5372903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21957771304, ExchCode = 'FRA' WHERE SecCode = 5374832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783749193, ExchCode = 'QTX', PermQuoteRetireDate = '2024-10-01' WHERE SecCode = 5374833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782487235, ExchCode = 'FRA' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716837, ExchCode = 'FRA' WHERE SecCode = 5383598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21960776871, ExchCode = 'STU' WHERE SecCode = 5387257 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 5407861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874410, ExchCode = 'GTX' WHERE SecCode = 5413669 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 5417608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777481353, ExchCode = 'FRA' WHERE SecCode = 5422843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777481357, ExchCode = 'FRA' WHERE SecCode = 5422844 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777892527, ExchCode = 'FRA' WHERE SecCode = 5444086 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-12-10' WHERE SecCode = 5452236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078258, ExchCode = 'LAS' WHERE SecCode = 5458313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21975266861, ExchCode = 'DEU' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790015169, ExchCode = 'LAS', PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 5463054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21976165199, ExchCode = 'DEU' WHERE SecCode = 5463055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726334950, ExchCode = 'DEU' WHERE SecCode = 5466446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778299981, ExchCode = 'FRA' WHERE SecCode = 5468679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585123, ExchCode = 'MEX' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026804, Ticker = '1TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898176, PermQuoteStatus = 'AC', Ticker = '3LUBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22010091546, Ticker = 'BTCCHz', ExchCode = 'TQE' WHERE SecCode = 5509588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21986459012, Ticker = 'USFAl', ExchCode = 'SIG' WHERE SecCode = 5516823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223797, ExchCode = 'QTX' WHERE SecCode = 5516829 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-21' WHERE SecCode = 5525173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-17' WHERE SecCode = 5526352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781906283, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5527546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805096669, ExchCode = 'HAM' WHERE SecCode = 5527547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779309034, ExchCode = 'MUN' WHERE SecCode = 5527560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21988984185, ExchCode = 'DEU' WHERE SecCode = 5527561 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 5531902 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 5531903 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 5531908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110956, Ticker = 'SFTGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110937, Ticker = '3SFTm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779515511, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5541732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419116, ExchCode = 'LAS' WHERE SecCode = 5547972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882186850, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 5569241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110941, PermQuoteStatus = 'AC', Ticker = '3FNGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151033, PermQuoteStatus = 'AC', Ticker = '3FNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5569246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778760132, ExchCode = 'MEX' WHERE SecCode = 5569424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541308584, PermQuoteStatus = 'DC', Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 5569431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789659489, ExchCode = 'LAS', PermQuoteRetireDate = '2025-04-22' WHERE SecCode = 5569960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793530266, ExchCode = 'DEU' WHERE SecCode = 5577589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780193394, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-30' WHERE SecCode = 5601088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22004617984, ExchCode = 'DEU' WHERE SecCode = 5607542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815640610, ExchCode = 'SWX' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780978843, ExchCode = 'FRA' WHERE SecCode = 5620203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781012608, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5631688 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780880115, ExchCode = 'HAM', PermQuoteRetireDate = '2024-01-19' WHERE SecCode = 5633493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923117428, Ticker = 'LCO3', ExchCode = 'LSE' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460797, ExchCode = 'GER' WHERE SecCode = 5638832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848440, ExchCode = 'QTX', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848459, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882433442, ExchCode = 'SWX' WHERE SecCode = 5645885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307755, ExchCode = 'MEX' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223838, ExchCode = 'QTX' WHERE SecCode = 5663968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781981055, ExchCode = 'MEX' WHERE SecCode = 5701235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028682766, Ticker = '2HENS' WHERE SecCode = 5720895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028890988, ExchCode = 'DEU' WHERE SecCode = 5724940 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 QuotePermID = 236784379581, ExchCode = 'LAS' WHERE SecCode = 5749952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799474968, ExchCode = 'LAS' WHERE SecCode = 5758113 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 5760048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812185857, ExchCode = 'DEU' WHERE SecCode = 5760234 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 5762144 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 5764159 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 5764160 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 5764163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025956, ExchCode = 'LAS' WHERE SecCode = 5764717 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 5772372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22154585726, ExchCode = 'CHI' WHERE SecCode = 5782798 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802153233, Ticker = 'RZ8Bd', ExchCode = 'BCO' WHERE SecCode = 5782810 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 = 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 = 236784418929, ExchCode = 'GTX' WHERE SecCode = 5827592 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786551903, ExchCode = 'TDG' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421384, ExchCode = 'MEX' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22046913691, ExchCode = 'DEU' WHERE SecCode = 5839467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386159, ExchCode = 'DEU' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22047386100, ExchCode = 'DEU' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785348220, ExchCode = 'STU' WHERE SecCode = 5857780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21736195111, ExchCode = 'STU' WHERE SecCode = 5886971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416444, ExchCode = 'BIV' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791001789, PermQuoteStatus = 'AC', Ticker = '83W', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5928247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788245572, ExchCode = 'DUS' WHERE SecCode = 6010815 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795664148, ExchCode = 'MEX' WHERE SecCode = 6014420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788759413, ExchCode = 'STU' WHERE SecCode = 6035234 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5040692042, PriInstrPermID = 232816269309.0, IsPrimaryInstr = 1, PriTRBCIndPermID = 4294951272.0, PermOrgIPODate = NULL WHERE SecCode = 6039856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788847036, ExchCode = 'TDG' WHERE SecCode = 6043475 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 5040692042, PriInstrPermID = 232816269309.0, IsPrimaryInstr = 1, PriTRBCIndPermID = 4294951272.0, PermOrgIPODate = NULL WHERE SecCode = 6071757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587649, ExchCode = 'FRA' WHERE SecCode = 6075918 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789587648, ExchCode = 'FRA' WHERE SecCode = 6075919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789803299, ExchCode = 'TDG' WHERE SecCode = 6078492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945886900, ExchCode = 'GTX' WHERE SecCode = 6097270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521367925, ExchCode = 'SGO' WHERE SecCode = 6097304 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351672, ExchCode = 'MEX' WHERE SecCode = 6097355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970566204, ExchCode = 'DEU' WHERE SecCode = 6097356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580190, ExchCode = 'FRA' WHERE SecCode = 6097360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797799762, ExchCode = 'HAM' WHERE SecCode = 6097368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380561, ExchCode = 'LAS' WHERE SecCode = 6097395 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674562, ExchCode = 'BIV' WHERE SecCode = 6097401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823963, ExchCode = 'AQE' WHERE SecCode = 6097426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329758, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 6097431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779226797, PermQuoteStatus = 'DC', Ticker = '5VFC', ExchCode = 'TDG', PermQuoteRetireDate = '2024-05-24' WHERE SecCode = 6097454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704338, ExchCode = 'MXQ' WHERE SecCode = 6097473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22171710457, ExchCode = 'BCO' WHERE SecCode = 6097604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086925583, ExchCode = 'MUN' WHERE SecCode = 6104636 AND Type_ = 10;
UPDATE data_universe_permid SET ExchCode = 'TAI' WHERE SecCode = 6213117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791667911, ExchCode = 'MEX' WHERE SecCode = 6226138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801123684, ExchCode = 'FRA' WHERE SecCode = 6256407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818713443, PermQuoteStatus = 'DC', Ticker = '4E40', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-05' WHERE SecCode = 6256409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759798861, PermQuoteStatus = 'DC', Ticker = '0BF1', ExchCode = 'TDG', PermQuoteRetireDate = '2025-07-04' WHERE SecCode = 6256412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811034765, ExchCode = 'MXQ' WHERE SecCode = 6256413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819293760, PermQuoteStatus = 'DC', Ticker = '2IU0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 6256420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792173202, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6260557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787788323, ExchCode = 'BIV' WHERE SecCode = 6321016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793500279, Ticker = 'GGPl', ExchCode = 'BCO' WHERE SecCode = 6334328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793574817, ExchCode = 'TDG' WHERE SecCode = 6334403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349913, ExchCode = 'MUN' WHERE SecCode = 6334404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795182977, ExchCode = 'DUS' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793644481, ExchCode = 'GTX' WHERE SecCode = 6341809 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843989720, ExchCode = 'MXQ' WHERE SecCode = 6368810 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22116655583, ExchCode = 'GER' WHERE SecCode = 6368868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793855800, ExchCode = 'TDG' WHERE SecCode = 6368981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789745448, ExchCode = 'BIV' WHERE SecCode = 6375301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866541, ExchCode = 'MEX' WHERE SecCode = 6375353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793934516, ExchCode = 'DUS' WHERE SecCode = 6377085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794030748, ExchCode = 'QTX' WHERE SecCode = 6383874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794246881, ExchCode = 'FRA' WHERE SecCode = 6392491 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789515593, ExchCode = 'BIV' WHERE SecCode = 6394335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22120375079, ExchCode = 'DEU' WHERE SecCode = 6396772 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297712, ExchCode = 'BIV' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121546541, ExchCode = 'DEU' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799203643, ExchCode = 'ASX' WHERE SecCode = 6421140 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22130904343, ExchCode = 'GTX' WHERE SecCode = 6421142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794669392, ExchCode = 'MEX' WHERE SecCode = 6423213 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797800232, ExchCode = 'HAM' WHERE SecCode = 6426995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22125348556, ExchCode = 'DEU' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17' WHERE SecCode = 6441630 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805815561, InstrPermID = 232930681234, OrgPermID = 5083342999, ValQuotePermID = 236805815561.0, PriInstrPermID = 232806531672.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = '2940', QuoteClass = 'ORD', InstrClass = 'ORD', DomCntry = 'CHN', PriTRBCIndPermID = 4294951190.0, PermQuoteRetireDate = '2026-05-28', PermOrgIPODate = '2024-01-12', PermSecMapStartDate = '2026-04-16', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 6443232 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802152101, ExchCode = 'TDG' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796057730, ExchCode = 'GTX' WHERE SecCode = 6448294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131539236, ExchCode = 'DEU' WHERE SecCode = 6480863 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796887923, ExchCode = 'DUS' WHERE SecCode = 6480864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131541195, ExchCode = 'DEU' WHERE SecCode = 6480866 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796059933, ExchCode = 'MUN', PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 6480954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109805, ExchCode = 'DUS' WHERE SecCode = 6501107 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365452, ExchCode = 'DEU' WHERE SecCode = 6518574 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145080, ExchCode = 'DUS' WHERE SecCode = 6518576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746059, ExchCode = 'DUS' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109633, ExchCode = 'QTX' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798597964, ExchCode = 'TDG' WHERE SecCode = 6528817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22137771215, ExchCode = 'DEU' WHERE SecCode = 6528818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798270114, ExchCode = 'FRA' WHERE SecCode = 6528824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798746061, ExchCode = 'DUS' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727346662, Ticker = '0QF', ExchCode = 'BRN' WHERE SecCode = 6578363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727315149, Ticker = '5Q5', ExchCode = 'BRN' WHERE SecCode = 6578368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727379902, Ticker = 'XS4', ExchCode = 'BRN' WHERE SecCode = 6578369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901814, ExchCode = 'TDG' WHERE SecCode = 6580828 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238834, ExchCode = 'QTX' WHERE SecCode = 6587160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238832, ExchCode = 'QTX' WHERE SecCode = 6587161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22144775461, ExchCode = 'DUS' WHERE SecCode = 6587170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22145793223, ExchCode = 'DEU' WHERE SecCode = 6593800 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800660438, ExchCode = 'DUS' WHERE SecCode = 6596132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21976165242, ExchCode = 'DEU' WHERE SecCode = 6626357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784357085, ExchCode = 'BRN' WHERE SecCode = 6629473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22173814070, ExchCode = 'TDG' WHERE SecCode = 6638013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802540440, ExchCode = 'FRA' WHERE SecCode = 6642929 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6710026 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6737819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699531, ExchCode = 'BIV' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6768901 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'AC' WHERE SecCode = 6773035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901586, Ticker = 'COLTa', ExchCode = 'CHI' 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-17', PermSecMapEndDate = '2026-04-17' WHERE SecCode = 6782585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805705305, ExchCode = 'FRA', PriTRBCIndPermID = 4294951924.0 WHERE SecCode = 6782676 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6786367 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6786585 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6789602 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 22173832019.0, IsPrimaryQuote = 1 WHERE SecCode = 6793362 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 22173833633.0, IsPrimaryQuote = 1 WHERE SecCode = 6793364 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 22173829548.0, IsPrimaryQuote = 1 WHERE SecCode = 6793365 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10785162 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10892722 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-18' WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 11026385 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11030393 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11036222 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5063245103, PriInstrPermID = NULL, IsPrimaryInstr = 0, IncCntry = 'HKG', PermOrgIPODate = NULL WHERE SecCode = 11052831 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11057638 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-18' WHERE SecCode = 11065371 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11136205 AND Type_ = 1;
UPDATE data_universe_permid SET QuoteClass = 'ORD', InstrClass = 'ORD', PermSecMapEndDate = '2026-04-18' WHERE SecCode = 11144354 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951924.0 WHERE SecCode = 11148037 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'SPIEQ' WHERE SecCode = 11155526 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 11158155 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 46667339561, PriTrdQuotePermID = NULL, Ticker = 'QVCDQ', ExchCode = 'PNK' WHERE SecCode = 11189948 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11195616 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 11202462 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-18' WHERE SecCode = 11213058 AND Type_ = 1;
UPDATE data_universe_permid SET ValQuotePermID = NULL WHERE SecCode = 11221896 AND Type_ = 1;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11224337 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5097107845, PriInstrPermID = 25727207517.0, PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11235756 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 11239159 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'CNTMD' WHERE SecCode = 11243411 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-18' WHERE SecCode = 11248163 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-18' WHERE SecCode = 11258156 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-18' WHERE SecCode = 11267015 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'TMITF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-17', PermSecMapEndDate = NULL WHERE SecCode = 11269371 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 11277286 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 6000025079, PriInstrPermID = 232870815371.0, PriTRBCIndPermID = 4294951954.0 WHERE SecCode = 11278158 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-18' WHERE SecCode = 11281132 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 11287041 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 11287047 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 11287051 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 11287053 AND Type_ = 1;
UPDATE data_universe_permid SET OrgPermID = 5097047896, PriInstrPermID = 232907992601.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11291143 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 11292158 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232917873735.0, IsPrimaryInstr = 0 WHERE SecCode = 11292491 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232903010784.0, IsPrimaryInstr = 0 WHERE SecCode = 11292538 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232924298753.0, IsPrimaryInstr = 0 WHERE SecCode = 11292544 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232915447852.0, IsPrimaryInstr = 0 WHERE SecCode = 11292620 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 232916506743.0, IsPrimaryInstr = 0 WHERE SecCode = 11293143 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 11293712 AND Type_ = 1;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-20' WHERE SecCode = 11294180 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'TRAX' WHERE SecCode = 11294194 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-04-14' WHERE SecCode = 11294499 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805784967, IsPrimaryQuote = 1, ExchCode = 'NSM' WHERE SecCode = 11294537 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805848395, PriTrdQuotePermID = 236805848395.0, ValQuotePermID = 25727026114.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1, ExchCode = 'NSM' WHERE SecCode = 11294599 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805509207, PriTrdQuotePermID = 236805509207.0, ValQuotePermID = 25727027785.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1, ExchCode = 'NSM' WHERE SecCode = 11294619 AND Type_ = 1;
UPDATE data_universe_permid SET ValQuotePermID = 236805847110.0, IsPrimaryQuote = 1, IsPrimaryInstr = 1 WHERE SecCode = 11294620 AND Type_ = 1;
UPDATE data_universe_permid SET ValQuotePermID = 236805847175.0, IsPrimaryQuote = 1 WHERE SecCode = 11294625 AND Type_ = 1;
