UPDATE data_universe_permid SET QuotePermID = 55836048756, Ticker = 'HON', ExchCode = 'LSE', PermQuoteRetireDate = '2022-11-02' WHERE SecCode = 229 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 1541 AND Type_ = 10; UPDATE data_universe_permid SET ExchCode = 'NYS' WHERE SecCode = 3853 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 6913 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', IncCntry = 'CYM' WHERE SecCode = 9688 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 10214 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10433 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 19146 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 23471 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 24610 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 27134 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 29418 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-03-27', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 29844 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 30005 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 31171 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 31231 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951440.0 WHERE SecCode = 33161 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951440.0 WHERE SecCode = 33164 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55837364027, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', PermSecMapEndDate = '2021-01-11' WHERE SecCode = 34018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667481067, PermQuoteStatus = 'AC', Ticker = 'AEC1', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 34462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632622059, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 34937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667486043, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 35064 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 35618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55837366078, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 35746 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 36033 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 36082 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'SUPN' WHERE SecCode = 36873 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 37662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21518925174, PermQuoteStatus = 'AC', Ticker = 'DSE', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 38247 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 39143 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951440.0 WHERE SecCode = 40732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805530047, Ticker = 'COYd', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 44054 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 44368 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', Ticker = NULL WHERE SecCode = 45554 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 46170 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'MEX' WHERE SecCode = 46582 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'MEX' WHERE SecCode = 46584 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21667485029, ExchCode = 'QTX' WHERE SecCode = 51520 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 52607 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 53280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475801368, Ticker = NULL, ExchCode = 'SIG', PermQuoteRetireDate = '2018-10-03' WHERE SecCode = 54237 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 54951 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 55940 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 56126 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 56790 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 57520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630231241, Ticker = 'STF', ExchCode = 'STU' WHERE SecCode = 57832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836325590, ExchCode = 'BER' WHERE SecCode = 57850 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560955141, PermQuoteStatus = 'AC', Ticker = 'CUW', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 57884 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419027, ExchCode = 'LAS' WHERE SecCode = 57889 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621680880, ExchCode = 'TDG' WHERE SecCode = 58060 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475745795, ExchCode = 'BER' WHERE SecCode = 58064 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838502924, ExchCode = 'STU', PermQuoteRetireDate = '2020-08-07' WHERE SecCode = 58140 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21585226757, ExchCode = 'STU' WHERE SecCode = 58245 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09' WHERE SecCode = 59436 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 59737 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 59809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805530045, Ticker = 'SE4d', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 59894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836399700, ExchCode = 'FRA', PermQuoteRetireDate = '2016-02-12' WHERE SecCode = 60009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836518711, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60039 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', Ticker = NULL WHERE SecCode = 60070 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475457930, Ticker = 'VTDG.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-05-23' WHERE SecCode = 60090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033818, ExchCode = 'TDG' WHERE SecCode = 60108 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324566, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 60348 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667492943, ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02' WHERE SecCode = 60564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475572974, Ticker = 'NSUG.I', ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836339538, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 60831 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 61061 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805530588, Ticker = 'TKEd', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 61478 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951279.0 WHERE SecCode = 61506 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951279.0 WHERE SecCode = 61577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667485966, ExchCode = 'QTX' WHERE SecCode = 61900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836339184, ExchCode = 'BER', PermQuoteRetireDate = '2019-04-24' WHERE SecCode = 62115 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 62423 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296554, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 62511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475875221, ExchCode = 'TDG' WHERE SecCode = 62558 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667490258, ExchCode = 'QTX' WHERE SecCode = 62613 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552519124, ExchCode = 'DUS' WHERE SecCode = 62618 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836397028, ExchCode = 'FRA', PermQuoteRetireDate = '2013-04-12' WHERE SecCode = 62627 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 63055 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 63097 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 63129 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 63643 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 63736 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613747263, ExchCode = 'TDG' WHERE SecCode = 64099 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21524267907, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 64101 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 64111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474840407, ExchCode = 'DEU' WHERE SecCode = 64139 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474997617, ExchCode = 'FRA' WHERE SecCode = 64180 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 64314 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 64362 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 64398 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 64869 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 65056 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 65204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836329646, ExchCode = 'BER' WHERE SecCode = 65414 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 65679 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 66325 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 66436 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 67136 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 68839 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 69151 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 69439 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 70099 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 70361 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 72392 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 72983 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 73109 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 73158 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 73285 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 73581 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 73688 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 74321 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 75034 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 76090 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 76659 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-04-09' WHERE SecCode = 76710 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-04-09' WHERE SecCode = 76799 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 77346 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'HKG' WHERE SecCode = 77873 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 78064 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000089263, OrgTypeCode = 'COM', IncCntry = NULL, PriTRBCIndPermID = 4294951333.0, PermOrgIPODate = '2026-04-07' WHERE SecCode = 78081 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 78958 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 79306 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 79378 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 80202 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 80802 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 81458 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 81460 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 81592 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 81636 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 81676 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236805427814.0 WHERE SecCode = 81820 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 81841 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'HKG' WHERE SecCode = 82565 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 82665 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 82898 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 82954 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 83863 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 83894 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 83992 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 83998 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 84001 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 84011 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84022 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84030 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 84097 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84170 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84293 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84304 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84378 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84487 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 84663 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84748 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84783 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 84899 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84934 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84979 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 85075 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 85083 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 85113 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 85194 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 85206 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 86123 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 87100 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 87365 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 87376 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 87377 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 87779 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 88258 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 89001 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-09' WHERE SecCode = 91025 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 91251 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 91276 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 91975 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 91976 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 93063 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 94395 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 94697 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 95536 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 96441 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 97105 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 97193 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 97194 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 97746 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 97928 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 98119 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 99680 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 99762 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 99763 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 100680 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 104412 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 105524 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 111657 AND Type_ = 10; UPDATE data_universe_permid SET OrgPermID = 6000089263, OrgTypeCode = 'COM', IncCntry = NULL, PriTRBCIndPermID = 4294951333.0, PermOrgIPODate = '2026-04-07' WHERE SecCode = 112091 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616285139, ExchCode = 'DEU' WHERE SecCode = 112231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835799282, ExchCode = 'MEX' WHERE SecCode = 112233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475772715, ExchCode = 'FRA' WHERE SecCode = 112619 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 112692 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 112948 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727369672, ExchCode = 'BIV' WHERE SecCode = 113051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595534595, ExchCode = 'DEU' WHERE SecCode = 113978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536043361, ExchCode = 'STU', PermQuoteRetireDate = '2022-07-08', PermSecMapEndDate = NULL WHERE SecCode = 113979 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 115849 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 127614 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 127620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805530051, Ticker = 'CB1Ad', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 127624 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21555271462, ExchCode = 'STU' WHERE SecCode = 128080 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785774660, ExchCode = 'FRA' WHERE SecCode = 128487 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836348689, ExchCode = 'FRA' WHERE SecCode = 129176 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474962049, ExchCode = 'DEU' WHERE SecCode = 129179 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 129262 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 129493 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'UKR' WHERE SecCode = 130255 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 130874 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 132015 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 132603 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 134527 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 135425 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'DEU' WHERE SecCode = 137665 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 138088 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 139225 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 139835 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 139858 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'UKR' WHERE SecCode = 139892 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 140001 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 140657 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 140663 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 140934 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 141041 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 141097 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 141228 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 141232 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 141236 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540736583, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 141439 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'MEX' WHERE SecCode = 141455 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 142134 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 142219 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 142348 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 142401 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 142629 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 142650 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 143166 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 143200 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 143560 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 143585 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172098816, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-04-09', PermSecMapEndDate = NULL WHERE SecCode = 143615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650192, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 143637 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 145495 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 145744 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 146130 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 146311 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 146536 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 146587 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 147098 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 149687 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 151022 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 161337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805530603, Ticker = 'TR4d', ExchCode = 'BTE', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 164737 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 177186 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 177263 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 177291 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 177392 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 177617 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 178076 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 178099 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 178225 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'HKG' WHERE SecCode = 178332 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 178608 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 178843 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 185632 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 188903 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 189566 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 191039 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 191863 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 192285 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236805426972.0, PriInstrPermID = 8589948973.0, IsPrimaryInstr = 1, PermOrgIPODate = '2026-04-09' WHERE SecCode = 196399 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 198951 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 204642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480921, ExchCode = 'QTX' WHERE SecCode = 205611 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857653403, Ticker = 'FFEF', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 206829 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951279.0 WHERE SecCode = 206836 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 211762 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 214630 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 214709 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 216222 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 216554 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 223449 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 224191 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 247962 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 249048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563176056, ExchCode = 'STU' WHERE SecCode = 249364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799016537, ExchCode = 'TDG' WHERE SecCode = 249727 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 269222 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 269250 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'IMN' WHERE SecCode = 283950 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 285603 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 292200 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 292517 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 292581 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 292614 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 292702 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 292722 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 292739 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 292749 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 292752 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 294590 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 DomCntry = 'HKG' WHERE SecCode = 296445 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 299144 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 299550 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 299990 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 302755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836324730, ExchCode = 'BER' WHERE SecCode = 303347 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 303357 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 303626 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 306047 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 311131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792573068, ExchCode = 'BIV' WHERE SecCode = 311169 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 313608 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 317581 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 318067 AND Type_ = 1; 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 PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 319996 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 321642 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 323093 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 323487 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 324373 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21537344839, ExchCode = 'STU' WHERE SecCode = 325645 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 325855 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 326998 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 328228 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 328255 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 328360 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 334399 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236804396433, ExchCode = 'QTX' WHERE SecCode = 335262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320555, ExchCode = 'BER' WHERE SecCode = 336198 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 336830 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21520440561, ExchCode = 'DEU' WHERE SecCode = 337400 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 = 55836353496, ExchCode = 'FRA' WHERE SecCode = 343073 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IMN' WHERE SecCode = 345598 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 346209 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'WWIDA', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 347684 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IMN' WHERE SecCode = 348091 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'IMN' WHERE SecCode = 348103 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 DomCntry = 'HKG' WHERE SecCode = 349255 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 356652 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 359624 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 362271 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21830288726, PermQuoteStatus = 'AC', ExchCode = 'GTX', DomCntry = 'HKG', PermQuoteRetireDate = NULL WHERE SecCode = 363732 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 365268 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 366358 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 369996 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951279.0 WHERE SecCode = 376523 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 379415 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 DomCntry = 'HKG' WHERE SecCode = 384029 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 384296 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 387636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781439239, ExchCode = 'DEU', PermQuoteRetireDate = '2023-12-21' WHERE SecCode = 391170 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21877137536, ExchCode = 'MUN' WHERE SecCode = 391171 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55841103521, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-11' WHERE SecCode = 392352 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838298639, Ticker = 'KAN.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 397851 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838299157, Ticker = 'NEM.CY', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 407812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419818, ExchCode = 'HAM' WHERE SecCode = 409650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704244, ExchCode = 'MXQ' WHERE SecCode = 409684 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822777044, ExchCode = 'DUS' WHERE SecCode = 413132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521101375, PermQuoteStatus = 'AC', Ticker = 'TRC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 415856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538722594, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 421788 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 423160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21487384961, ExchCode = 'STU' WHERE SecCode = 424919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843194281, ExchCode = 'FRA' WHERE SecCode = 425031 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55843333402, ExchCode = 'BER', PermQuoteRetireDate = '2019-11-08' WHERE SecCode = 425411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517679507, ExchCode = 'STU' WHERE SecCode = 427679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475388101, Ticker = 'BLIN.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 427894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793396870, ExchCode = 'FRA' WHERE SecCode = 428966 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953597671, ExchCode = 'DUS' WHERE SecCode = 432012 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 432497 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 433792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55840380357, ExchCode = 'PFT', PermQuoteRetireDate = '2017-01-23' WHERE SecCode = 433814 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646062312, ExchCode = 'MUN' WHERE SecCode = 434993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536204619, ExchCode = 'STU' WHERE SecCode = 435796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21599934396, ExchCode = 'TDG', PermQuoteRetireDate = '2023-12-14', PermSecMapEndDate = '2023-12-14' WHERE SecCode = 438364 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842916429, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 439455 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55853026615, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 442574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475095903, ExchCode = 'FRA', PermQuoteRetireDate = '2015-07-27' WHERE SecCode = 456391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704501, ExchCode = 'MXQ' WHERE SecCode = 462658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21575865316, Ticker = 'BXXm', ExchCode = 'BCO' WHERE SecCode = 464174 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847269156, Ticker = 'C3I0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 471737 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033434, ExchCode = 'TDG', PermQuoteRetireDate = '2021-11-30' WHERE SecCode = 471738 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 479615 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847283502, Ticker = 'XAXJ', ExchCode = 'LSE' WHERE SecCode = 481041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22150825819, ExchCode = 'SWX' WHERE SecCode = 481044 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21925268568, ExchCode = 'GTX' WHERE SecCode = 484491 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475022130, ExchCode = 'DEU' WHERE SecCode = 486276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475388774, Ticker = 'SWZ.PL', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 501839 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 502603 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 502605 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55848865464, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 503830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21725613667, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 503842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849266246, ExchCode = 'FRA', PermQuoteRetireDate = '2012-04-12' WHERE SecCode = 507407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704447, ExchCode = 'MXQ' WHERE SecCode = 508999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475388339, Ticker = 'LMED.SE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 512425 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21914681044, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 513278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55849681520, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' 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 = 55834673063, Ticker = '0O16', ExchCode = 'LSE', PermQuoteRetireDate = '2012-09-06' WHERE SecCode = 515577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851531698, ExchCode = 'FRA' WHERE SecCode = 515658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850070208, ExchCode = 'FRA' WHERE SecCode = 518549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781569887, ExchCode = 'QTX' WHERE SecCode = 520411 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 = 21714445246, Ticker = 'AIGEm', ExchCode = 'DXE' WHERE SecCode = 521423 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21975240639, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 521464 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21621433367, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2020-01-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 521905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296198, ExchCode = 'GTX' WHERE SecCode = 524403 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 524466 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805519519, ExchCode = 'MUN', PermQuoteRetireDate = '2025-10-24' WHERE SecCode = 527096 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 532384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850869660, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 532767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521650121, ExchCode = 'MUN', PermQuoteRetireDate = '2020-09-02' WHERE SecCode = 532772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474893887, Ticker = '8EC0', ExchCode = 'DEU', PermQuoteRetireDate = '2024-07-31' WHERE SecCode = 533384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886808270, ExchCode = 'MUN' WHERE SecCode = 533520 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851190611, ExchCode = 'BER' WHERE SecCode = 534603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532071708, ExchCode = 'MUN' WHERE SecCode = 535314 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 535482 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630225521, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 535506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475422413, Ticker = 'FISKS.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2009-09-03' WHERE SecCode = 536734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55851785873, ExchCode = 'FRA' WHERE SecCode = 538090 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034164, ExchCode = 'TDG', PermQuoteRetireDate = '2018-04-17' WHERE SecCode = 539328 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667478626, ExchCode = 'QTX' WHERE SecCode = 539438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21476219200, ExchCode = 'STU' WHERE SecCode = 541495 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474938108, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 542320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21512564421, Ticker = '324', ExchCode = 'STU', PermQuoteRetireDate = '2017-08-15' WHERE SecCode = 542445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799025517, ExchCode = 'MUN' WHERE SecCode = 542943 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 543178 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704727, ExchCode = 'MXQ', PermSecMapEndDate = '2016-11-07' WHERE SecCode = 544311 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 545312 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 545470 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 545910 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 DomCntry = 'BMU' WHERE SecCode = 548032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547316142, ExchCode = 'STU' WHERE SecCode = 548626 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 548700 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301241, ExchCode = 'GTX' WHERE SecCode = 549236 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704213, Ticker = 'AKS*', ExchCode = 'MXQ' WHERE SecCode = 549537 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785844948, ExchCode = 'TDG' WHERE SecCode = 549886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617415257, ExchCode = 'MUN' WHERE SecCode = 550860 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 DomCntry = 'HKG' WHERE SecCode = 553444 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 554344 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 554345 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 554967 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 555156 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 556253 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 556656 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21534813444, ExchCode = 'DUS' WHERE SecCode = 557818 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475771162, ExchCode = 'STU' WHERE SecCode = 557995 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55856214005, ExchCode = 'FRA' WHERE SecCode = 558032 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 558346 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 558718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55847307588, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2016-01-28', PermSecMapEndDate = '2016-01-28' WHERE SecCode = 560139 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727383300, Ticker = NULL, ExchCode = 'MEX' WHERE SecCode = 560263 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 PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-10', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 561073 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475779870, ExchCode = 'QMF' WHERE SecCode = 563059 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857693044, ExchCode = 'FRA', PermQuoteRetireDate = '2012-01-16' WHERE SecCode = 564353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474958339, ExchCode = 'DEU' WHERE SecCode = 565316 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492892892, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 565330 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762578358, ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-16' WHERE SecCode = 565707 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475805271, ExchCode = 'STU' WHERE SecCode = 565752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55857541012, ExchCode = 'FRA' WHERE SecCode = 565866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474994386, ExchCode = 'STU' WHERE SecCode = 566694 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 = 21667705724, ExchCode = 'MXQ' WHERE SecCode = 573267 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55835820729, ExchCode = 'MEX' WHERE SecCode = 580079 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 DomCntry = 'HKG' WHERE SecCode = 587491 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859177674, ExchCode = 'STU' WHERE SecCode = 592307 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589742988, ExchCode = 'STU' WHERE SecCode = 593055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859005911, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 593132 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 598679 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859254286, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 599978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475660385, InstrPermID = 8590922012, OrgPermID = 4295880615, ValQuotePermID = 55837430854.0, PriInstrPermID = 8590922012.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'YFM', ExchCode = 'GER', PermQuoteRetireDate = '2010-03-29', PermOrgIPODate = NULL WHERE SecCode = 601515 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22145756635, ExchCode = 'SWX' WHERE SecCode = 602882 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 649889 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55868335680, Ticker = 'OCS.GB', ExchCode = 'PLU' WHERE SecCode = 649936 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474991761, ExchCode = 'MUN' WHERE SecCode = 652498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540229905, ExchCode = 'STU' WHERE SecCode = 701753 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 702391 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 703517 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 737735 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 822049 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475105966, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 826159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21895641350, ExchCode = 'TDG', PermQuoteRetireDate = '2023-01-18' WHERE SecCode = 827254 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 830007 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532857661, ExchCode = 'TDG' WHERE SecCode = 837909 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 839268 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 850477 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035327, ExchCode = 'TDG', PermQuoteRetireDate = '2025-06-02' WHERE SecCode = 863481 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 880546 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 882233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660807802, ExchCode = 'MUN' WHERE SecCode = 882870 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 883102 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21928900998, ExchCode = 'QTX' WHERE SecCode = 883866 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 890366 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 890755 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 890820 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 903275 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 903675 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 907542 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 918855 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 927209 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55868604668, Ticker = 'CBBFDS', ExchCode = 'SWX', PermQuoteRetireDate = '2021-04-19' WHERE SecCode = 933460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388797, ExchCode = 'LAS' WHERE SecCode = 943158 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 966413 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 968715 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 977206 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 982550 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 DomCntry = 'BMU' WHERE SecCode = 990250 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 PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 1092978 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 1124186 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 1211489 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 1220309 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1244702 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 1261036 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 1335466 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 1435641 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21480912846, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1447851 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21583580938, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-08-16', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1455200 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 1460241 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21478443280, ExchCode = 'FRA' WHERE SecCode = 1460338 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704338, ExchCode = 'MXQ' WHERE SecCode = 1460771 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792391622, ExchCode = 'DUS' WHERE SecCode = 1468807 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 1472045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21480946905, ExchCode = 'BER', PermQuoteRetireDate = '2013-06-17' WHERE SecCode = 1479224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530720649, ExchCode = 'STU' WHERE SecCode = 1480257 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21481396381, ExchCode = 'STU' WHERE SecCode = 1482803 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21481643753, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1485688 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21490145914, Ticker = NULL, ExchCode = 'DEU', PermQuoteRetireDate = '2014-03-07' WHERE SecCode = 1489390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587109482, ExchCode = 'DEU' WHERE SecCode = 1494186 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531119071, Ticker = 'BRDGl', ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21487020931, ExchCode = 'FRA' WHERE SecCode = 1519184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21488285610, ExchCode = 'DEU' WHERE SecCode = 1524542 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21774623750, ExchCode = 'TDG', PermQuoteRetireDate = '2022-05-23', PermSecMapEndDate = '2022-05-31' WHERE SecCode = 1524544 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646184463, PermQuoteStatus = 'AC', Ticker = '5EV0', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 1525470 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854497908, ExchCode = 'FRA' WHERE SecCode = 1525756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646071858, ExchCode = 'TDG' WHERE SecCode = 1527486 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852098667, ExchCode = 'FRA' WHERE SecCode = 1527502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21558559889, ExchCode = 'STU' WHERE SecCode = 1531694 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 1534154 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21491257231, ExchCode = 'STU' WHERE SecCode = 1534251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492895638, ExchCode = 'DEU', PermQuoteRetireDate = '2014-04-08' WHERE SecCode = 1537137 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787321763, ExchCode = 'FRA' WHERE SecCode = 1537196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21492713347, ExchCode = 'STU' WHERE SecCode = 1537214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494270483, ExchCode = 'FRA' WHERE SecCode = 1538607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21493834048, ExchCode = 'TDG' WHERE SecCode = 1538642 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800727357, ExchCode = 'DEU' WHERE SecCode = 1539987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511700265, PermQuoteStatus = 'AC', Ticker = '7NU1', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1544692 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 1545713 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21496860026, ExchCode = 'FRA' WHERE SecCode = 1546652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830305592, ExchCode = 'GTX' WHERE SecCode = 1547496 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 1548445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21497743025, ExchCode = 'DEU' WHERE SecCode = 1552856 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22156877250, ExchCode = 'DEU' WHERE SecCode = 1553832 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21498532317, ExchCode = 'FRA' WHERE SecCode = 1556381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21639604213, ExchCode = 'MUN' WHERE SecCode = 1568506 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632884533, ExchCode = 'MUN', PermQuoteRetireDate = '2018-10-05' WHERE SecCode = 1571251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667489792, ExchCode = 'QTX' WHERE SecCode = 1572867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21503429462, ExchCode = 'FRA' WHERE SecCode = 1584599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21504308444, ExchCode = 'STU' WHERE SecCode = 1594714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21510896202, ExchCode = 'MUN', PermQuoteRetireDate = '2016-10-25' WHERE SecCode = 1624036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482368066, Ticker = 'PV0D', ExchCode = 'SES', PermQuoteRetireDate = '2013-03-01' WHERE SecCode = 1630565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21882713778, ExchCode = 'GTX' WHERE SecCode = 1651406 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951440.0 WHERE SecCode = 1660560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511222796, ExchCode = 'DEU' WHERE SecCode = 1675772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917520427, ExchCode = 'DEU' WHERE SecCode = 1689167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679815, ExchCode = 'BIV' WHERE SecCode = 1690204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21511796493, ExchCode = 'DEU' WHERE SecCode = 1694101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21515521924, ExchCode = 'FRA' WHERE SecCode = 1713829 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836320776, ExchCode = 'BER' WHERE SecCode = 1755109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21513489767, ExchCode = 'FRA' WHERE SecCode = 1778982 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 1839781 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 1856460 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21515423685, ExchCode = 'FRA' WHERE SecCode = 1967460 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'HKG' WHERE SecCode = 1990909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538768207, Ticker = 'ECXl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2013070 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2014147 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2029160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788111815, ExchCode = 'FRA' WHERE SecCode = 2042837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802863785, ExchCode = 'FRA' WHERE SecCode = 2048649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21518074502, ExchCode = 'DEU' WHERE SecCode = 2055361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517928750, ExchCode = 'FRA' WHERE SecCode = 2055381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21519498812, ExchCode = 'DEU' WHERE SecCode = 2115211 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780659437, ExchCode = 'GTX' WHERE SecCode = 2115214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21589938022, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2126923 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 2206947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522133570, ExchCode = 'STU' WHERE SecCode = 2222349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000143697, Ticker = '2KPN', ExchCode = 'MIL' WHERE SecCode = 2225256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523834226, ExchCode = 'DEU' WHERE SecCode = 2225286 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727306937, ExchCode = 'BEC' WHERE SecCode = 2226896 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475831394, ExchCode = 'FRA' WHERE SecCode = 2235767 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 2239273 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2239411 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2241769 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 2262556 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 2264290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21477220302, Ticker = 'BN' WHERE SecCode = 2270001 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704416, Ticker = 'CELG*', ExchCode = 'MXQ' WHERE SecCode = 2279732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532303445, ExchCode = 'FRA' WHERE SecCode = 2324950 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2339258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781213703, ExchCode = 'QTX', PermQuoteRetireDate = '2024-05-17' WHERE SecCode = 2356509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2379762 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2381660 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2386507 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2396434 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2409463 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786676622, ExchCode = 'MEX' WHERE SecCode = 2414027 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2433071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842517697, ExchCode = 'SGO' WHERE SecCode = 2435334 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2445238 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704199, ExchCode = 'MXQ' WHERE SecCode = 2455541 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2490822 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2503666 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660431319, ExchCode = 'FRA' WHERE SecCode = 2511591 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 DomCntry = 'USA' WHERE SecCode = 2514700 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798387416, ExchCode = 'HAM' WHERE SecCode = 2518731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21869002235, ExchCode = 'DEU', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 2529650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629786303, ExchCode = 'DEU' WHERE SecCode = 2539933 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 2545660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540739504, ExchCode = 'FRA' WHERE SecCode = 2550284 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 2553229 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2563198 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543101908, ExchCode = 'DEU' WHERE SecCode = 2579445 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2579462 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830369, ExchCode = 'DUS' WHERE SecCode = 2584258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543708867, ExchCode = 'FRA' WHERE SecCode = 2585326 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2585343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21782012516, ExchCode = 'DEU' WHERE SecCode = 2585381 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2585474 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2593532 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370251, ExchCode = 'BEC' WHERE SecCode = 2598717 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566715663, ExchCode = 'FRA' WHERE SecCode = 2604391 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636233577, Ticker = '3ITS.GB', ExchCode = 'NXX' WHERE SecCode = 2604404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805530048, Ticker = 'SFEd', ExchCode = 'BCO', PermSecMapStartDate = '2026-01-01' WHERE SecCode = 2605866 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 2613148 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM', PriTRBCIndPermID = 4294951191.0 WHERE SecCode = 2617098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784384980, ExchCode = 'LAS' WHERE SecCode = 2617118 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2622280 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369113, ExchCode = 'SGO' WHERE SecCode = 2625122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21846693416, PermQuoteStatus = 'DC', Ticker = '14S', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-04' WHERE SecCode = 2625801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606782728, ExchCode = 'FRA' WHERE SecCode = 2631562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21574200693, ExchCode = 'FRA' WHERE SecCode = 2631564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370299, ExchCode = 'GTX' WHERE SecCode = 2642447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587109507, ExchCode = 'FRA' WHERE SecCode = 2643269 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656673317, ExchCode = 'BIV' WHERE SecCode = 2644179 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548381242, ExchCode = 'DEU' WHERE SecCode = 2647456 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2650540 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS' WHERE SecCode = 2659169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549893649, ExchCode = 'FRA' WHERE SecCode = 2668929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550451762, Ticker = 'HPQ', ExchCode = 'SWX' WHERE SecCode = 2679919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535196967, Ticker = 'QCI', ExchCode = 'BRN' WHERE SecCode = 2679937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550835484, ExchCode = 'STU' WHERE SecCode = 2682326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21550944607, ExchCode = 'BER' WHERE SecCode = 2694711 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09' WHERE SecCode = 2695633 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2697156 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697157 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697173 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697194 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2697202 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2697203 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2697213 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697214 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697220 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697230 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2697231 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697233 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2697240 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2697256 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2697267 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2697270 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 2697281 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2697284 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697312 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2697320 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2697331 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697337 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2697367 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697374 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2700315 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551920728, ExchCode = 'MUN' WHERE SecCode = 2708937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551804538, ExchCode = 'MUN' WHERE SecCode = 2708938 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'IRL' WHERE SecCode = 2710278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552463360, ExchCode = 'FRA' WHERE SecCode = 2711203 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2715169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21705935887, ExchCode = 'BIV' WHERE SecCode = 2724356 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2725378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704676, ExchCode = 'MXQ' WHERE SecCode = 2743610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675690, ExchCode = 'BIV' WHERE SecCode = 2747774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727198716, ExchCode = 'MEX' WHERE SecCode = 2750976 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2770572 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754377738, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2774739 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2802740 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557003843, ExchCode = 'FRA' WHERE SecCode = 2807599 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 2809820 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 2809821 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 2819101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21561432644, ExchCode = 'FRA' WHERE SecCode = 2824461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535496482, ExchCode = 'FRA', PermQuoteRetireDate = '2019-09-27' WHERE SecCode = 2827915 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21559577677, ExchCode = 'DEU' WHERE SecCode = 2848442 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560671440, ExchCode = 'FRA' WHERE SecCode = 2855770 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21560761414, ExchCode = 'DEU' WHERE SecCode = 2855773 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650196, ExchCode = 'DUS' WHERE SecCode = 2858551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460829, ExchCode = 'GER' WHERE SecCode = 2864471 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798228200, ExchCode = 'BER', PermQuoteRetireDate = '2023-05-17', PermSecMapEndDate = '2023-02-28' WHERE SecCode = 2868670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656677051, ExchCode = 'BIV' WHERE SecCode = 2876241 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2879965 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2879969 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2879970 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2879973 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 2891291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647736991, ExchCode = 'FRA' WHERE SecCode = 2893040 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 2899674 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 2900667 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 2902827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564531293, ExchCode = 'STU' WHERE SecCode = 2905610 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21644687444, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907244 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655017440, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2907245 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2909239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564938913, ExchCode = 'DEU' WHERE SecCode = 2909928 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2910659 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 2911291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21565148442, ExchCode = 'MUN' WHERE SecCode = 2911859 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2913387 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 2921493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566942520, ExchCode = 'FRA' WHERE SecCode = 2921712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531457862, ExchCode = 'FRA' WHERE SecCode = 2923399 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'IRL' WHERE SecCode = 2924502 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951990.0 WHERE SecCode = 2924553 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370656, ExchCode = 'SGO' WHERE SecCode = 2925435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033693, InstrPermID = 8590942120, OrgPermID = 4295862624, ValQuotePermID = 55838794989.0, PriInstrPermID = 8590942120.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = 'A4L', ExchCode = 'TDG', PermQuoteRetireDate = '2015-07-06', PermOrgIPODate = NULL WHERE SecCode = 2939990 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779370461, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 2947926 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2963479 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704396, ExchCode = 'MXQ' WHERE SecCode = 2963604 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21724821997, Ticker = '9GL', ExchCode = 'BER', PermQuoteRetireDate = '2020-09-09', PermSecMapEndDate = '2024-04-10' WHERE SecCode = 3020820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576175357, ExchCode = 'DEU' WHERE SecCode = 3032214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576247699, ExchCode = 'FRA' WHERE SecCode = 3032363 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3033805 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3037826 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3058467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916285644, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460750, Ticker = 'OD7I', ExchCode = 'FRA' WHERE SecCode = 3076725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21581022534, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3083485 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830275202, ExchCode = 'GTX' WHERE SecCode = 3098021 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800715032, ExchCode = 'DUS' WHERE SecCode = 3109823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584213518, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-21', PermSecMapEndDate = '2022-10-21' WHERE SecCode = 3116971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22164689309, ExchCode = 'GTX' WHERE SecCode = 3121289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045077929, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3121290 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21536846008, ExchCode = 'FRA', PermQuoteRetireDate = '2018-07-11' WHERE SecCode = 3153817 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587220566, ExchCode = 'TDG' WHERE SecCode = 3153872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21929444790, ExchCode = 'QTX' WHERE SecCode = 3167791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21548007992, ExchCode = 'FRA' WHERE SecCode = 3177608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21588924118, ExchCode = 'DEU' WHERE SecCode = 3177801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798143359, ExchCode = 'FRA' WHERE SecCode = 3186751 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'AVARDA' WHERE SecCode = 3196330 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786342003, Ticker = 'XMW2', ExchCode = 'STU' WHERE SecCode = 3198718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21590371242, ExchCode = 'FRA' WHERE SecCode = 3199702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21590429261, ExchCode = 'DEU', PermQuoteRetireDate = '2020-04-01' WHERE SecCode = 3199703 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21937100717, ExchCode = 'QTX' WHERE SecCode = 3208355 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591674218, ExchCode = 'TDG' WHERE SecCode = 3208863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778730196, ExchCode = 'FRA' WHERE SecCode = 3215565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595464532, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3229527 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3241310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011205, Ticker = '2UN' WHERE SecCode = 3244879 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'IRL' WHERE SecCode = 3246406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788491422, Ticker = '0EFd', ExchCode = 'BCO' WHERE SecCode = 3246454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100410, ExchCode = 'QTX' WHERE SecCode = 3247170 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 = 21589227699, ExchCode = 'FRA' WHERE SecCode = 3247556 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3247780 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598409316, ExchCode = 'DEU', PermQuoteRetireDate = '2016-11-11' WHERE SecCode = 3260094 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21663194058, ExchCode = 'MEX' WHERE SecCode = 3271811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705082, ExchCode = 'MXQ' WHERE SecCode = 3275857 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3277021 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277022 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3277045 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277066 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277076 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277077 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277079 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277080 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3277122 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3277141 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3277150 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3277163 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3277168 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3277169 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277182 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277185 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277232 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277235 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277259 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277272 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277273 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277275 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3277281 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277290 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277306 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277310 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277316 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277328 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 3277330 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3277334 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277350 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277357 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277376 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277388 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277405 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782872444, Ticker = 'SLYGd', ExchCode = 'SIG' WHERE SecCode = 3280089 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3281875 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3281878 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3281889 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3281893 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3281897 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3281900 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836545363, ExchCode = 'FRA' WHERE SecCode = 3282311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21602150243, ExchCode = 'TDG' WHERE SecCode = 3282950 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21604352845, ExchCode = 'STU' WHERE SecCode = 3283650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798383543, ExchCode = 'DEU' WHERE SecCode = 3285135 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632738581, ExchCode = 'BER', PermQuoteRetireDate = '2018-11-27' WHERE SecCode = 3297215 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21858705487, ExchCode = 'STU' WHERE SecCode = 3308987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21609327640, ExchCode = 'FRA', PermQuoteRetireDate = '2023-07-04' WHERE SecCode = 3315948 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3316500 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3316987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786551901, ExchCode = 'TDG' WHERE SecCode = 3317115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21617237022, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-01', PermSecMapEndDate = NULL WHERE SecCode = 3318127 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3318440 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3319130 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 3321102 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611042371, ExchCode = 'DEU' WHERE SecCode = 3322810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732297982, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705691, Ticker = 'SMIN', ExchCode = 'MXQ' WHERE SecCode = 3327117 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21649841825, ExchCode = 'BER' WHERE SecCode = 3327824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780911221, ExchCode = 'MUN' WHERE SecCode = 3337226 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21612487102, ExchCode = 'DEU' WHERE SecCode = 3339668 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645200699, ExchCode = 'TDG' WHERE SecCode = 3339799 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3345921 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21614367734, ExchCode = 'AUX' WHERE SecCode = 3347816 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21631068545, Ticker = 'BIOSs', ExchCode = 'BCO', PermQuoteRetireDate = '2024-05-21' WHERE SecCode = 3350742 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3353729 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761303085, ExchCode = 'STU' WHERE SecCode = 3358616 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3379085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766019467, ExchCode = 'DEU' WHERE SecCode = 3386374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21766440281, ExchCode = 'DUS', PermQuoteRetireDate = '2022-09-29' WHERE SecCode = 3391721 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645193083, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-03', PermSecMapEndDate = NULL WHERE SecCode = 3393655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21575576966, PermQuoteStatus = 'AC', ExchCode = 'BRN', PermQuoteRetireDate = NULL WHERE SecCode = 3394028 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3394122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21623803393, ExchCode = 'DEU' WHERE SecCode = 3396014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100517, ExchCode = 'QTX' WHERE SecCode = 3401365 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624461914, ExchCode = 'STU', PermQuoteRetireDate = '2017-10-26', PermSecMapEndDate = '2017-10-26' WHERE SecCode = 3402759 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21736195409, ExchCode = 'DUS' WHERE SecCode = 3403947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21718790665, ExchCode = 'BTE' WHERE SecCode = 3404188 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 3405230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21630627945, ExchCode = 'FRA' WHERE SecCode = 3405439 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791216285, ExchCode = 'STU' WHERE SecCode = 3407871 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 3408712 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 3409309 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3430481 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3430482 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3430624 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21761780224, ExchCode = 'FRA' WHERE SecCode = 3430952 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380031, ExchCode = 'LAS' WHERE SecCode = 3432164 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'IRL' WHERE SecCode = 3432327 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3432344 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 3433218 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636066861, ExchCode = 'DEU' WHERE SecCode = 3435060 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3435132 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3436791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796441340, ExchCode = 'HAM' WHERE SecCode = 3439533 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3439568 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3439698 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3439699 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3439700 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3439701 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3440083 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 3440122 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3440262 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3441217 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21643703119, ExchCode = 'DEU' WHERE SecCode = 3444720 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 = 21644687554, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3445747 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646838408, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-30', PermSecMapEndDate = NULL WHERE SecCode = 3445749 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3446472 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781569555, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3446753 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'HKG' WHERE SecCode = 3446893 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3465524 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938003820, ExchCode = 'MUN' WHERE SecCode = 3490819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647430161, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3490820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21649268603, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 3490821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21760582049, ExchCode = 'TDG' WHERE SecCode = 3490824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21680653099, ExchCode = 'MUN' WHERE SecCode = 3493723 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794206137, ExchCode = 'TDG' WHERE SecCode = 3495930 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3497019 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727169919, Ticker = 'NGIL', ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21613367926, ExchCode = 'STU' WHERE SecCode = 3513992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757505148, ExchCode = 'STU' WHERE SecCode = 3514006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789434494, ExchCode = 'LAS' WHERE SecCode = 3532734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296299, ExchCode = 'GTX' WHERE SecCode = 3543197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21663166737, ExchCode = 'DEU' WHERE SecCode = 3550423 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710951331, ExchCode = 'CHI' WHERE SecCode = 3550579 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727171, ExchCode = 'DEU' WHERE SecCode = 3551874 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 PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3586902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475624891, Ticker = 'CSC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 3586971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584408989, ExchCode = 'STU' WHERE SecCode = 3587027 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3589017 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3599694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21706067030, ExchCode = 'CHI', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 3601109 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 3610254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21731983529, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3615233 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759798879, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-13' WHERE SecCode = 3615235 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3620745 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 DomCntry = 'CYM' WHERE SecCode = 3634363 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3634379 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3634400 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3634405 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3634410 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3634429 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3635500 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3635507 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21685428815, ExchCode = 'TDG' WHERE SecCode = 3654098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21673637996, ExchCode = 'QTX' WHERE SecCode = 3656405 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 3669984 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3690670 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21947054171, ExchCode = 'FRA' WHERE SecCode = 3738157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22160094634, ExchCode = 'DEU' WHERE SecCode = 3756337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21687636010, ExchCode = 'TDG', PermQuoteRetireDate = '2022-08-18' WHERE SecCode = 3775420 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 3777677 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 DomCntry = 'CYM' WHERE SecCode = 3787375 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 3811205 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3817690 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 3818109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373503, ExchCode = 'BIV' WHERE SecCode = 3821865 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3825565 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 3827933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373317, ExchCode = 'MEX' WHERE SecCode = 3843165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21841147970, ExchCode = 'TDG' WHERE SecCode = 3848225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21701895330, ExchCode = 'STU' WHERE SecCode = 3875755 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 3909019 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3956854 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21711930903, ExchCode = 'FRA' WHERE SecCode = 3958735 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4001148 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727359630, ExchCode = 'MEX' 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 = 236787826668, Ticker = '1BACm', ExchCode = 'BCO' WHERE SecCode = 4031699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011932, Ticker = '2BIIB' WHERE SecCode = 4031705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026823, Ticker = '1T' WHERE SecCode = 4031711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026865, Ticker = '11COV' WHERE SecCode = 4031771 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 = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 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 = 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 = 236780026920, Ticker = '1MAR' WHERE SecCode = 4031937 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 = 236780026962, Ticker = '1PM' WHERE SecCode = 4032067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026885, Ticker = '1CRM' WHERE SecCode = 4032071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681023394, Ticker = '4AKZA', ExchCode = 'ETX' WHERE SecCode = 4032088 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 = 236780026759, Ticker = '1DD' WHERE SecCode = 4032277 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 = 21571645915, ExchCode = 'SGO' WHERE SecCode = 4046481 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 4079151 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 4079163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388406, ExchCode = 'LAS' WHERE SecCode = 4081944 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 4087374 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 = 236784387195, ExchCode = 'LAS' WHERE SecCode = 4103690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21735310153, Ticker = '7M40', ExchCode = 'STU', PermQuoteRetireDate = '2024-02-02' WHERE SecCode = 4103711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21737082360, ExchCode = 'DUS' WHERE SecCode = 4109380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21751586898, ExchCode = 'DEU' WHERE SecCode = 4121689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727352699, ExchCode = 'MEX' WHERE SecCode = 4134210 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727351670, ExchCode = 'BIV' WHERE SecCode = 4171586 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 4178608 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4178879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727364667, ExchCode = 'BIV' WHERE SecCode = 4187947 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21625622942, ExchCode = 'DEU' WHERE SecCode = 4188130 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 DomCntry = 'HKG' WHERE SecCode = 4201929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21788611415, ExchCode = 'FRA' WHERE SecCode = 4209753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21771675002, ExchCode = 'FRA' WHERE SecCode = 4212482 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 4220049 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 4220773 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 4226180 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754200427, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4253036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754200308, ExchCode = 'DEU' WHERE SecCode = 4253037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21754533500, ExchCode = 'FRA' WHERE SecCode = 4256876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780942187, ExchCode = 'STU' WHERE SecCode = 4267228 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756809736, ExchCode = 'DEU' WHERE SecCode = 4275420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756549155, ExchCode = 'FRA' WHERE SecCode = 4277546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21755360719, ExchCode = 'BER' WHERE SecCode = 4288879 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759098760, ExchCode = 'DEU' WHERE SecCode = 4291265 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4319483 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381904, ExchCode = 'LAS' WHERE SecCode = 4321331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763596291, ExchCode = 'DUS' WHERE SecCode = 4321393 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763724005, ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-02' WHERE SecCode = 4324497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763901203, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 4324503 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763966475, ExchCode = 'FRA' WHERE SecCode = 4327051 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 4335839 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 4351440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781601742, ExchCode = 'GER' WHERE SecCode = 4359837 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772839734, ExchCode = 'DEU' WHERE SecCode = 4372550 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 4385211 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238824, ExchCode = 'LAS' WHERE SecCode = 4385213 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 4385238 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4391264 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778679902, ExchCode = 'MUN' WHERE SecCode = 4394781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21777644978, ExchCode = 'BER' WHERE SecCode = 4394782 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4395458 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778285116, ExchCode = 'DEU' WHERE SecCode = 4396578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778281540, ExchCode = 'STU' WHERE SecCode = 4402301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778680774 WHERE SecCode = 4406073 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 4410630 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780909499, ExchCode = 'FRA' WHERE SecCode = 4413712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21783161157, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4415732 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781996426, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4420922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727304584, ExchCode = 'MEX' WHERE SecCode = 4421213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797999209, ExchCode = 'DEU' WHERE SecCode = 4423904 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 = 236780026948, Ticker = '1VTRS' WHERE SecCode = 4427826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785083437, ExchCode = 'TDG' WHERE SecCode = 4434247 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21784912245, ExchCode = 'FRA' WHERE SecCode = 4434248 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785625686, ExchCode = 'DEU' 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 = 236794740545, ExchCode = 'LAS' WHERE SecCode = 4446128 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 4456070 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21789191252, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4456112 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21807264695, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4462869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797412670, ExchCode = 'STU' WHERE SecCode = 4463145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727306964, ExchCode = 'BEC' WHERE SecCode = 4464699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795956950, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4466620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793532320, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 4470175 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21798225679, PermQuoteStatus = 'DC', ExchCode = 'DUS', PermQuoteRetireDate = '2025-02-12', PermSecMapEndDate = '2025-02-12' WHERE SecCode = 4470353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21793895569, ExchCode = 'QTX' WHERE SecCode = 4472927 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4479287 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727342536, ExchCode = 'MEX' WHERE SecCode = 4492131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797555797, ExchCode = 'DEU' WHERE SecCode = 4496736 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 = 25727287359, ExchCode = 'MEX' WHERE SecCode = 4505578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955514011, ExchCode = 'DUS' WHERE SecCode = 4511502 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800479537, ExchCode = 'DEU' WHERE SecCode = 4511506 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 = 21800727363, ExchCode = 'DEU' WHERE SecCode = 4513649 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4517838 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802422923, ExchCode = 'FRA' WHERE SecCode = 4526142 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851345226, ExchCode = 'MUN' WHERE SecCode = 4526144 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781628079, ExchCode = 'DUS' WHERE SecCode = 4527891 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 4534860 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4536316 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4536330 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 4539304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727301437, ExchCode = 'BIV' WHERE SecCode = 4547978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727271947, ExchCode = 'MEX' WHERE SecCode = 4549301 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 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 DomCntry = 'HKG' WHERE SecCode = 4554175 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893554092, ExchCode = 'DEU' WHERE SecCode = 4554184 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 4557784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22143000521, ExchCode = 'DEU' WHERE SecCode = 4557948 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 4561714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22140274066, ExchCode = 'BTE' WHERE SecCode = 4563419 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21811980857, ExchCode = 'MUN' WHERE SecCode = 4576474 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4586482 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 4586603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784379572, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4598716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800097262, ExchCode = 'LAS' WHERE SecCode = 4601728 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781581925, ExchCode = 'QTX' WHERE SecCode = 4603537 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 4605827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21817036435, ExchCode = 'STU', PermQuoteRetireDate = '2024-05-09' WHERE SecCode = 4607686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21860843349, ExchCode = 'MUN' WHERE SecCode = 4608705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22138517605, ExchCode = 'CHI' WHERE SecCode = 4609997 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 4613738 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818527324, ExchCode = 'DEU' WHERE SecCode = 4618010 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21897338595, ExchCode = 'GER' WHERE SecCode = 4623220 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782994602, ExchCode = 'MEX' WHERE SecCode = 4625008 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21819968078, ExchCode = 'DEU' WHERE SecCode = 4625009 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820389350, ExchCode = 'FRA' WHERE SecCode = 4626836 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 4626848 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 DomCntry = 'USA' WHERE SecCode = 4634351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799608110, ExchCode = 'LAS' WHERE SecCode = 4639636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854881328, ExchCode = 'GTX' WHERE SecCode = 4639654 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4646582 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4648185 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21825617109, ExchCode = 'DEU' WHERE SecCode = 4651786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21832260332, ExchCode = 'FRA' WHERE SecCode = 4658888 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 4667228 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21831914397, ExchCode = 'STU' WHERE SecCode = 4671286 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 PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 4692294 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 4693643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837528978, ExchCode = 'DEU' WHERE SecCode = 4693647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167619187, ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802153605, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 4697438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933381561, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 4720517 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4724752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21845567127, ExchCode = 'MUN', PermQuoteRetireDate = '2024-09-06' WHERE SecCode = 4726108 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'FRA', IncCntry = 'FRA' WHERE SecCode = 4759539 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854742271, ExchCode = 'DEU' WHERE SecCode = 4761587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21859546343, ExchCode = 'GTX' WHERE SecCode = 4767878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21855820605, ExchCode = 'DEU' WHERE SecCode = 4773769 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853439467, ExchCode = 'BER', PermQuoteRetireDate = '2021-11-18' WHERE SecCode = 4774934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21856518308, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4777235 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857866487, ExchCode = 'MUN' WHERE SecCode = 4784525 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788376836, Ticker = 'A6Id', ExchCode = 'BCO' WHERE SecCode = 4792475 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 DomCntry = 'GBR' WHERE SecCode = 4810005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886808179, ExchCode = 'MUN', PermQuoteRetireDate = '2025-03-06' WHERE SecCode = 4811144 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4830961 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580163, ExchCode = 'GER' WHERE SecCode = 4834791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580240, ExchCode = 'GER' WHERE SecCode = 4834792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886398298, ExchCode = 'GER', PermQuoteRetireDate = '2023-09-25' WHERE SecCode = 4834793 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784379540, ExchCode = 'LAS' WHERE SecCode = 4845025 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888954019, ExchCode = 'MUN', PermQuoteRetireDate = '2022-08-19', PermSecMapEndDate = NULL WHERE SecCode = 4845029 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888953971, ExchCode = 'MUN', PermQuoteRetireDate = '2023-04-17' WHERE SecCode = 4845030 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580736, ExchCode = 'GER' WHERE SecCode = 4845032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21871056172, ExchCode = 'MUN' WHERE SecCode = 4845045 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884968894, ExchCode = 'DEU' WHERE SecCode = 4847005 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388723, ExchCode = 'LAS' WHERE SecCode = 4868662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874645094, ExchCode = 'TDG' WHERE SecCode = 4885603 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21929410708, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874656832, ExchCode = 'DEU' WHERE SecCode = 4889264 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4913069 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781980293, PermQuoteStatus = 'DC', Ticker = '62U1', ExchCode = 'BER', PermQuoteRetireDate = '2025-09-01' WHERE SecCode = 4943250 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884962075, ExchCode = 'STU' WHERE SecCode = 4946106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883516418, ExchCode = 'FRA' WHERE SecCode = 4946404 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885447241, ExchCode = 'DUS', PermQuoteRetireDate = '2025-04-22' WHERE SecCode = 4954564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21891723924, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-01-14' WHERE SecCode = 4959596 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885689488, ExchCode = 'DEU' WHERE SecCode = 4959597 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 4965014 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830059, ExchCode = 'QTX' WHERE SecCode = 4969490 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21900329999, ExchCode = 'DEU' WHERE SecCode = 4970793 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888276703, ExchCode = 'GTX' WHERE SecCode = 4972276 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4975844 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4977689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21889560981, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4980098 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727212161, ExchCode = 'BIV' WHERE SecCode = 4980103 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21888279622, ExchCode = 'MUN' WHERE SecCode = 4983996 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892952930, ExchCode = 'FRA' WHERE SecCode = 5002370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892953045, ExchCode = 'DEU' WHERE SecCode = 5002372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100827, ExchCode = 'DUS' WHERE SecCode = 5002456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21910739434, Ticker = '2COIN' WHERE SecCode = 5004800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916269903, Ticker = '2SGLY' WHERE SecCode = 5004801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22072401492, ExchCode = 'DEU' WHERE SecCode = 5009346 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 = 236784387449, ExchCode = 'LAS' WHERE SecCode = 5020949 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 5031864 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22153246013, ExchCode = 'BTE' WHERE SecCode = 5038692 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863949618 WHERE SecCode = 5040232 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21898852880, ExchCode = 'FRA' WHERE SecCode = 5041758 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 5052443 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21901210223, ExchCode = 'DEU' WHERE SecCode = 5052451 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902626358, Ticker = 'XWD1', ExchCode = 'LSE' WHERE SecCode = 5067183 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 5078480 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 5085769 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 5089305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026880, Ticker = '1KDP' WHERE SecCode = 5107765 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21911875317, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27', PermSecMapEndDate = '2023-10-27' WHERE SecCode = 5112411 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21912121144, ExchCode = 'FRA' WHERE SecCode = 5130680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21950535351, ExchCode = 'DEU' WHERE SecCode = 5134589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917520648, ExchCode = 'DEU' WHERE SecCode = 5151167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781830485, ExchCode = 'DUS' WHERE SecCode = 5153443 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830273208, ExchCode = 'GTX' WHERE SecCode = 5161225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21730598077, ExchCode = 'FRA' WHERE SecCode = 5161282 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5161290 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5161291 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21753424486, ExchCode = 'MUN' WHERE SecCode = 5161303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792173203, ExchCode = 'FRA' WHERE SecCode = 5161343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727308116, Ticker = 'WPMl', ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667329289, ExchCode = 'FRA' WHERE SecCode = 5161350 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727344849, ExchCode = 'BIV' WHERE SecCode = 5161363 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776266575, ExchCode = 'FRA' WHERE SecCode = 5161371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521369386, ExchCode = 'SGO' 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 = 21921849641, ExchCode = 'FRA' WHERE SecCode = 5176821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933953345, ExchCode = 'TDG' WHERE SecCode = 5189077 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21950535364, ExchCode = 'MUN' WHERE SecCode = 5203361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727198685, ExchCode = 'BIV' WHERE SecCode = 5206281 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 5218812 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5220908 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 5220909 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 5220910 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21930806960, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 5220960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933629891, ExchCode = 'TDG' WHERE SecCode = 5229902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794004180, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5239813 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727173431, ExchCode = 'BIV' WHERE SecCode = 5241334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779979676, ExchCode = 'DUS' WHERE SecCode = 5247621 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 5249135 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21948492664, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027032, Ticker = '1HU3' WHERE SecCode = 5258607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387487, ExchCode = 'LAS' WHERE SecCode = 5258620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775107112, ExchCode = 'BIV' WHERE SecCode = 5283390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21945573264, ExchCode = 'HAM' WHERE SecCode = 5283694 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380705, ExchCode = 'LAS' WHERE SecCode = 5292722 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21956352320, ExchCode = 'TDG' WHERE SecCode = 5297998 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 5315605 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775732431, ExchCode = 'MEX' WHERE SecCode = 5329511 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21949478319, ExchCode = 'FRA' WHERE SecCode = 5338742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791510353, ExchCode = 'MUN' WHERE SecCode = 5343623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21853633841, ExchCode = 'FRA' WHERE SecCode = 5347222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21952832311, ExchCode = 'STU' WHERE SecCode = 5347429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954130974, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5357353 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776535810, ExchCode = 'MEX' WHERE SecCode = 5387237 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'VGB' WHERE SecCode = 5387266 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 5395742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850700539, ExchCode = 'STU' WHERE SecCode = 5403242 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727202565, ExchCode = 'BIV' WHERE SecCode = 5411550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21966355571, ExchCode = 'DEU' WHERE SecCode = 5413668 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776535797, ExchCode = 'MEX' WHERE SecCode = 5416155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776416446, ExchCode = 'BIV' WHERE SecCode = 5417748 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780942209, ExchCode = 'STU' WHERE SecCode = 5422843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21967957484, ExchCode = 'DEU' WHERE SecCode = 5422844 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236775107109, ExchCode = 'BIV' WHERE SecCode = 5430834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21921820703, ExchCode = 'BER', PermQuoteRetireDate = '2024-12-17', PermSecMapEndDate = '2024-12-17' WHERE SecCode = 5434319 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 5440946 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727169122, Ticker = 'CAMBIo', ExchCode = 'SIG' WHERE SecCode = 5448761 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 5453381 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236776268320, ExchCode = 'MEX' WHERE SecCode = 5455239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21726336464, ExchCode = 'FRA' WHERE SecCode = 5466446 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727193596, ExchCode = 'MEX' WHERE SecCode = 5474598 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 5478289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778437243, ExchCode = 'MEX' WHERE SecCode = 5482856 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5487993 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778704118, ExchCode = 'FRA' WHERE SecCode = 5493665 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917834837, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503720 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 5503721 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837512065, Ticker = '3PYPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5503776 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823777, ExchCode = 'AQX' WHERE SecCode = 5503780 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580173, ExchCode = 'DEU' WHERE SecCode = 5503781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663656, ExchCode = 'AQX' WHERE SecCode = 5503782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21953657244, ExchCode = 'MXQ' WHERE SecCode = 5503860 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917836119, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917836104, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5506501 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789414734, ExchCode = 'LAS' WHERE SecCode = 5507430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779282458, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 5527546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779282595, ExchCode = 'FRA' WHERE SecCode = 5527547 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917836259, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5534997 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 5547975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786107921, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2024-10-25' WHERE SecCode = 5553189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779771106, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5553227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21932421397, PermQuoteStatus = 'AC', Ticker = '3LALm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835780, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21933110928, PermQuoteStatus = 'AC', Ticker = 'FANGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21881555404, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569241 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 = 21896580185, ExchCode = 'DEU' WHERE SecCode = 5569302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917823771, ExchCode = 'BER', PermQuoteRetireDate = '2024-11-15' WHERE SecCode = 5569303 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034589, ExchCode = 'TDG', PermQuoteRetireDate = '2013-05-30' WHERE SecCode = 5569318 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970293165, ExchCode = 'MUN' WHERE SecCode = 5569360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21982665105, ExchCode = 'MXQ' WHERE SecCode = 5569424 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21522671160, PermQuoteStatus = 'AC', Ticker = 'YE20', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5569431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883771506, ExchCode = 'FRA', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 5569960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21997766265, Ticker = 'NGLS', ExchCode = 'LSE' WHERE SecCode = 5584733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727212166, ExchCode = 'BIV' WHERE SecCode = 5604481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793574816, ExchCode = 'TDG' WHERE SecCode = 5623203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781060493, ExchCode = 'FRA' WHERE SecCode = 5633895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21595966434, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-12' WHERE SecCode = 5638827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22065452994, ExchCode = 'BRN' 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 DomCntry = 'HKG' WHERE SecCode = 5663500 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22089214794, Ticker = '3TSEd', ExchCode = 'BTE' WHERE SecCode = 5663514 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223838, ExchCode = 'QTX' WHERE SecCode = 5663968 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5677491 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781858187, ExchCode = 'FRA' WHERE SecCode = 5679100 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781954019, ExchCode = 'FRA' WHERE SecCode = 5687951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22020600429, ExchCode = 'DEU' WHERE SecCode = 5687957 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805530042, PermQuoteStatus = 'AC', Ticker = 'ZK70d', ExchCode = 'BCO', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-01-25' WHERE SecCode = 5697992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782180690, ExchCode = 'STU' WHERE SecCode = 5703062 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782254675, ExchCode = 'FRA' WHERE SecCode = 5710467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172089143, PermQuoteStatus = 'AC', ExchCode = 'GER', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 5710735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782381254, ExchCode = 'QTX' WHERE SecCode = 5712413 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782563848, ExchCode = 'FRA' WHERE SecCode = 5722406 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 5729695 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 = 22032608571, ExchCode = 'DEU' WHERE SecCode = 5749727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22032826044, ExchCode = 'DEU' WHERE SecCode = 5749886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22032827411, ExchCode = 'DEU' WHERE SecCode = 5749887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782994251, ExchCode = 'STU' WHERE SecCode = 5749901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799419156, ExchCode = 'LAS' WHERE SecCode = 5749956 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783529905, ExchCode = 'FRA' WHERE SecCode = 5764717 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 = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788207229, ExchCode = 'FRA' WHERE SecCode = 5822326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784278056, ExchCode = 'STU' WHERE SecCode = 5822327 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784438281, ExchCode = 'STU' WHERE SecCode = 5827593 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784357764, ExchCode = 'MEX' WHERE SecCode = 5836309 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784809121, ExchCode = 'GTX' WHERE SecCode = 5842623 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804089043, ExchCode = 'QTX' WHERE SecCode = 5853173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236786355845, ExchCode = 'BIV' WHERE SecCode = 5985969 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795664148, ExchCode = 'MEX' WHERE SecCode = 6014420 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 6043593 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 6043647 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151005, Ticker = 'FTNE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 6097285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370126, ExchCode = 'BEC' WHERE SecCode = 6097304 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 6097315 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970308382, ExchCode = 'BCO' WHERE SecCode = 6097325 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22045078190, ExchCode = 'LAS' WHERE SecCode = 6097334 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151127, Ticker = '3SUE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 6097349 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 = 25727171457, ExchCode = 'MEX' WHERE SecCode = 6097402 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 = 236777911612, ExchCode = 'BIV' WHERE SecCode = 6097467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21980198469, ExchCode = 'GER' WHERE SecCode = 6097549 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727354555, ExchCode = 'MEX' WHERE SecCode = 6097578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874663670, ExchCode = 'AQX' WHERE SecCode = 6097580 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22086901855, ExchCode = 'GTX' WHERE SecCode = 6104636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790170885, ExchCode = 'QTX' WHERE SecCode = 6109630 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790283699, ExchCode = 'TDG' WHERE SecCode = 6109726 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784572542, ExchCode = 'MEX' WHERE SecCode = 6130315 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22086925748, ExchCode = 'DEU' WHERE SecCode = 6130377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788550181, ExchCode = 'BIV' WHERE SecCode = 6134764 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22074453370, Ticker = 'VPBU', ExchCode = 'LSE' WHERE SecCode = 6134788 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791039841, ExchCode = 'QTX' WHERE SecCode = 6139932 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791039842, ExchCode = 'QTX' WHERE SecCode = 6139934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801833326, ExchCode = 'DUS' WHERE SecCode = 6139935 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22087852594, ExchCode = 'DEU' WHERE SecCode = 6139937 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790609845, ExchCode = 'STU' WHERE SecCode = 6139938 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22087852513, ExchCode = 'DEU' WHERE SecCode = 6139939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788928244, ExchCode = 'MEX' WHERE SecCode = 6141564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22089000964, ExchCode = 'DEU' WHERE SecCode = 6147594 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793109030, ExchCode = 'LAS' WHERE SecCode = 6151861 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 6160888 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 6186390 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22094064244, ExchCode = 'DEU' WHERE SecCode = 6197566 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792959667, ExchCode = 'STU' WHERE SecCode = 6204567 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 6213106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791969104, ExchCode = 'FRA' WHERE SecCode = 6232187 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099147227, ExchCode = 'DEU' WHERE SecCode = 6232440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236791838443, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22133181713, Ticker = 'BTCE', ExchCode = 'SWX' WHERE SecCode = 6245909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21743775323, Ticker = '4E4', ExchCode = 'STU', PermQuoteRetireDate = '2023-09-05' WHERE SecCode = 6256409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917829970, ExchCode = 'DEU' WHERE SecCode = 6256440 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22082089941, ExchCode = 'QTX' WHERE SecCode = 6256447 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'IRL' WHERE SecCode = 6264116 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792269530, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-25' WHERE SecCode = 6269028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792269527, ExchCode = 'HAM' WHERE SecCode = 6269033 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 6291847 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6291848 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6295325 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6295326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236803099318, ExchCode = 'STU' WHERE SecCode = 6341809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794499501, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 6347434 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6366682 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843989720, ExchCode = 'MXQ' WHERE SecCode = 6368810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22118566912, ExchCode = 'DEU' WHERE SecCode = 6382149 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792427653, ExchCode = 'LAS' WHERE SecCode = 6382150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794030748, ExchCode = 'QTX' WHERE SecCode = 6383874 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 DomCntry = 'BMU' WHERE SecCode = 6429307 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795182771, ExchCode = 'FRA' WHERE SecCode = 6441867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795294193, ExchCode = 'FRA' WHERE SecCode = 6445725 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795294192, ExchCode = 'FRA' WHERE SecCode = 6445726 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 6450942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22128281486, ExchCode = 'QTX' WHERE SecCode = 6457998 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796140988, ExchCode = 'STU' WHERE SecCode = 6462849 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 6480920 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 = 236798107740, ExchCode = 'FRA' WHERE SecCode = 6522492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798107743, ExchCode = 'FRA' WHERE SecCode = 6522493 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798746061, ExchCode = 'DUS' WHERE SecCode = 6541040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798743814, ExchCode = 'QTX' WHERE SecCode = 6543898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727379902, Ticker = 'XS4', ExchCode = 'BRN' WHERE SecCode = 6578369 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 = 236800096573, ExchCode = 'FRA' WHERE SecCode = 6590614 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667484355, ExchCode = 'QTX' WHERE SecCode = 6599021 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800286614, ExchCode = 'MUN' WHERE SecCode = 6626384 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21955514041, ExchCode = 'STU' WHERE SecCode = 6626587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802150023, ExchCode = 'SWX' WHERE SecCode = 6629473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22172087694, ExchCode = 'FRA' WHERE SecCode = 6638013 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802807019, ExchCode = 'MEX' WHERE SecCode = 6664680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802914563, ExchCode = 'FRA' WHERE SecCode = 6664705 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 47763436106, ExchCode = 'DEU' WHERE SecCode = 6664706 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236802914867, ExchCode = 'FRA' WHERE SecCode = 6664707 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883770164, ExchCode = 'DEU' WHERE SecCode = 6667833 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6686347 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-09' WHERE SecCode = 6694372 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'IRL' WHERE SecCode = 6712353 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'IRL' WHERE SecCode = 6716130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804778696, ExchCode = 'MUN' WHERE SecCode = 6721535 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 6728359 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167343880, ExchCode = 'DEU' WHERE SecCode = 6728367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339493, ExchCode = 'DEU' WHERE SecCode = 6728368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339476, ExchCode = 'DEU' WHERE SecCode = 6728370 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167340591, ExchCode = 'DEU' WHERE SecCode = 6728371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167341909, ExchCode = 'DEU' WHERE SecCode = 6728372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167342837, ExchCode = 'DEU' WHERE SecCode = 6728373 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167342067, ExchCode = 'DEU' WHERE SecCode = 6728374 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339591, ExchCode = 'DEU' WHERE SecCode = 6728375 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167340584, ExchCode = 'DEU' WHERE SecCode = 6728377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167340486, ExchCode = 'DEU' WHERE SecCode = 6728378 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799175959, ExchCode = 'BIV' WHERE SecCode = 6728383 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167326401, ExchCode = 'GER' WHERE SecCode = 6728389 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236790866059, ExchCode = 'LAS' WHERE SecCode = 6728400 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805530357, ExchCode = 'MUN' WHERE SecCode = 6737927 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 6737933 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795337293, ExchCode = 'BIV' WHERE SecCode = 6741058 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 6748871 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805095337, ExchCode = 'QTX' WHERE SecCode = 6753078 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 6755589 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22170662378, ExchCode = 'DEU' WHERE SecCode = 6756502 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 10783567 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10784483 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10784523 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 10813020 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10813039 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10813302 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10814074 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'SGP' WHERE SecCode = 10814353 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 10870569 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10888325 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10892565 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10897585 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10901055 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10901069 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 10901085 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 10902423 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 10908152 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10913588 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10924858 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10929976 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10932619 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10959604 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10964866 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10967859 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10973822 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10985477 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 10998957 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11000594 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11002700 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11003299 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11009908 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11015357 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11015359 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11021184 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11021297 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11021549 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11022043 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11025975 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11029621 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11033963 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11034514 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11035304 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11035720 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11036659 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11036829 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 11037026 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11039295 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11053002 AND Type_ = 1; UPDATE data_universe_permid SET OrgPermID = 6000089263, OrgTypeCode = 'COM', IncCntry = NULL, PriTRBCIndPermID = 4294951333.0, PermOrgIPODate = '2026-04-07' WHERE SecCode = 11053619 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11058015 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11058856 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11059922 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11064300 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11068543 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11106007 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11111276 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11131378 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11135945 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11136229 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM', PriTRBCIndPermID = 4294951191.0 WHERE SecCode = 11138578 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11141392 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11147616 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11150269 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11152701 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11152702 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11152703 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11152704 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11160140 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11169432 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 11173051 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11173629 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11182335 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 11186527 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11193133 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727255535, ExchCode = 'NMS', PermSecMapStartDate = '2021-06-19' WHERE SecCode = 11198774 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11198876 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 11202636 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11202674 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 11209821 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11210535 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11218248 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11223856 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'TRCTF' WHERE SecCode = 11233691 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11236268 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 11237291 AND Type_ = 1; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11240537 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11245086 AND Type_ = 1; UPDATE data_universe_permid SET ExchCode = 'NAS' WHERE SecCode = 11248790 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11250693 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11253112 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11253113 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = 'SCAI' WHERE SecCode = 11253247 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC', Ticker = NULL WHERE SecCode = 11255668 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 11256581 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11257235 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11263123 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-10' WHERE SecCode = 11263462 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11277226 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11277227 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11277231 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290443 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290444 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290446 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290448 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290449 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290450 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290451 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290454 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290455 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290459 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290463 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290465 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290466 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290471 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-09', PermSecMapEndDate = '2026-04-09' WHERE SecCode = 11290473 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951899.0 WHERE SecCode = 11293820 AND Type_ = 1; UPDATE data_universe_permid SET PriTrdQuotePermID = 236805431637.0, Ticker = 'CFTR PR A', ExchCode = 'NYQ' WHERE SecCode = 11293937 AND Type_ = 1;