UPDATE data_universe_permid SET QuotePermID = 21531116153, Ticker = 'ABTl', ExchCode = 'BCO', PermQuoteRetireDate = '2017-02-01' WHERE SecCode = 31 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807274366, ExchCode = 'OCU' WHERE SecCode = 1879 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951520.0 WHERE SecCode = 3541 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951520.0 WHERE SecCode = 3543 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951642.0 WHERE SecCode = 4619 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951836.0 WHERE SecCode = 5279 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 6154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475869392, Ticker = 'HNDA.GB', ExchCode = 'ISD' WHERE SecCode = 6240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836052858, PermQuoteStatus = 'AC', Ticker = 'HKLB', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 6257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21515262838, Ticker = 'H78', ExchCode = 'LSE', PermQuoteRetireDate = '2015-06-22' WHERE SecCode = 6260 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951523.0 WHERE SecCode = 7166 AND Type_ = 10;
UPDATE data_universe_permid SET OrgPermID = 6000248912, OrgTypeCode = 'UNK', PriTRBCIndPermID = NULL WHERE SecCode = 10591 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 14415 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 22457 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21742935323, Ticker = 'SKMDl', ExchCode = 'BCO', PermQuoteRetireDate = '2023-11-09' WHERE SecCode = 27054 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-17' WHERE SecCode = 31065 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-17' WHERE SecCode = 31066 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21633145058, ExchCode = 'EBT', PermQuoteRetireDate = '2019-06-17' WHERE SecCode = 31850 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 32045 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 33005 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-21' WHERE SecCode = 33523 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 33868 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782686844, ExchCode = 'TDG' WHERE SecCode = 33892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836399887, ExchCode = 'FRA' WHERE SecCode = 34072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836470412, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 34311 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951367.0 WHERE SecCode = 34709 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236800237940, ExchCode = 'TDG' WHERE SecCode = 35017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780538185, ExchCode = 'GTX' WHERE SecCode = 35450 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800449418, ExchCode = 'DUS' WHERE SecCode = 35680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808726031, ExchCode = 'FRA' WHERE SecCode = 35870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491211, PermQuoteStatus = 'AC', Ticker = 'SN20', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 35878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861549460, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 36005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475422367, ExchCode = 'DUS', PermQuoteRetireDate = '2006-06-05' WHERE SecCode = 36125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058756, ExchCode = 'DEU' WHERE SecCode = 37524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836511554, ExchCode = 'FRA' WHERE SecCode = 37677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475608917, PermQuoteStatus = 'DC', Ticker = 'MRCY.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 37854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616850046, ExchCode = 'STU' WHERE SecCode = 37856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475437280, ExchCode = 'GER' WHERE SecCode = 37861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475748488, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'BER', PermQuoteRetireDate = '2005-05-24' WHERE SecCode = 37875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474862297, ExchCode = 'DEU', PermQuoteRetireDate = '2016-03-30' WHERE SecCode = 37920 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837365008, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 37971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475625660, ExchCode = 'BER' WHERE SecCode = 37981 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510496144, ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 38264 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951182.0 WHERE SecCode = 38495 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-09-18' WHERE SecCode = 43149 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21830296024, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 43267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824525549, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 43583 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 45475 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21830272953, ExchCode = 'GTX' WHERE SecCode = 45854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838512918, PermQuoteStatus = 'AC', Ticker = 'EGID', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 45916 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951727.0 WHERE SecCode = 46495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332736, ExchCode = 'BER' WHERE SecCode = 46516 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 47185 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 47273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801449047, ExchCode = 'DEU' WHERE SecCode = 47312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340900, PermQuoteStatus = 'DC', Ticker = 'ZWC1', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 49643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016560, ExchCode = 'TDG' WHERE SecCode = 51369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809727282, ExchCode = 'LAS' WHERE SecCode = 52755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830272806, ExchCode = 'GTX' WHERE SecCode = 53240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667491916, PermQuoteStatus = 'AC', Ticker = 'TKD', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 53311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519006, ExchCode = 'DUS', PermQuoteRetireDate = '2020-10-15' WHERE SecCode = 53447 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-21' WHERE SecCode = 53749 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857585867, ExchCode = 'GER' WHERE SecCode = 53813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574510968, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-06' WHERE SecCode = 53833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475555697, Ticker = 'MKE.I', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 53853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490422, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 54587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475036113, ExchCode = 'TDG' WHERE SecCode = 54675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21710738249, ExchCode = 'MUN' WHERE SecCode = 54684 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836391253, ExchCode = 'FRA', PermQuoteRetireDate = '2010-05-03' WHERE SecCode = 55049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541076311, ExchCode = 'DEU' WHERE SecCode = 57437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842911827, ExchCode = 'FRA' WHERE SecCode = 59028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532018361, ExchCode = 'DUS' WHERE SecCode = 59096 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332407, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 59531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509736165, ExchCode = 'STU' WHERE SecCode = 59577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331757, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 60013 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836518711, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836409687, PermQuoteStatus = 'AC', Ticker = 'FNWA', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 60102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589872687, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-17' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474961910, ExchCode = 'DEU', PermQuoteRetireDate = '2021-02-03' WHERE SecCode = 60202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778838014, ExchCode = 'DUS' WHERE SecCode = 60208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858551, ExchCode = 'QTX' WHERE SecCode = 60314 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836443537, ExchCode = 'FRA', PermQuoteRetireDate = '2012-05-21' WHERE SecCode = 60364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809578568, Ticker = 'KLI1d', ExchCode = 'BCO' WHERE SecCode = 60427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531427929, ExchCode = 'DEU' WHERE SecCode = 60506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386455, ExchCode = 'LAS' WHERE SecCode = 60608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527545912, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 60633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787048574, ExchCode = 'TDG' WHERE SecCode = 60745 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549200292, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 61188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759098635, ExchCode = 'STU', PermQuoteRetireDate = '2022-05-27', PermSecMapEndDate = NULL WHERE SecCode = 61355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830297090, ExchCode = 'GTX' WHERE SecCode = 61431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21528269264, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 61528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322927, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 61635 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667489833, ExchCode = 'QTX' WHERE SecCode = 61651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547152803, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-12-12', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 61702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807278715, ExchCode = 'HAM' WHERE SecCode = 62188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836475280, ExchCode = 'FRA' WHERE SecCode = 62438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542768798, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 62492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488660, PermQuoteStatus = 'AC', Ticker = 'NEQ', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 62765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836422887, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 62874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667486943, ExchCode = 'QTX' WHERE SecCode = 62901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587111646, ExchCode = 'DEU' WHERE SecCode = 63504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805519783, ExchCode = 'MUN' WHERE SecCode = 63507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475524032, Ticker = 'OSCI.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 63522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836331733, Ticker = 'ISC1', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 64275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587780409, PermQuoteRetireDate = '2025-04-30' WHERE SecCode = 64308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808159418, ExchCode = 'FRA' WHERE SecCode = 65173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22166292609, ExchCode = 'DEU' WHERE SecCode = 65372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183626868, ExchCode = 'DEU' WHERE SecCode = 66040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21585320848, ExchCode = 'TDG' WHERE SecCode = 66061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332063, Ticker = 'LJP1', ExchCode = 'BER', PermQuoteRetireDate = '2010-04-04' WHERE SecCode = 66228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21571803984, Ticker = 'CGEd', ExchCode = 'BCO', PermQuoteRetireDate = '2017-03-30' WHERE SecCode = 66263 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655821566, ExchCode = 'DEU' WHERE SecCode = 66265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035704, ExchCode = 'TDG' WHERE SecCode = 66279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22155211005, ExchCode = 'DEU' WHERE SecCode = 66281 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951891.0 WHERE SecCode = 67183 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 67240 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-21' WHERE SecCode = 67667 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = 236814633273.0 WHERE SecCode = 68136 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951727.0 WHERE SecCode = 68149 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951942.0 WHERE SecCode = 69109 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951710.0 WHERE SecCode = 69160 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951300.0 WHERE SecCode = 70349 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 70842 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951943.0 WHERE SecCode = 72736 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 76701 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951182.0 WHERE SecCode = 76973 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-17' WHERE SecCode = 79918 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 80041 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 80890 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-21' WHERE SecCode = 81657 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 82950 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 83328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236814633332, ExchCode = 'MID' WHERE SecCode = 86766 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ADID' WHERE SecCode = 86794 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-17' WHERE SecCode = 88408 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 89956 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951238.0 WHERE SecCode = 90371 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 91007 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 91434 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 91435 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 91436 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ANT' WHERE SecCode = 91543 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951803.0 WHERE SecCode = 92917 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951986.0 WHERE SecCode = 93652 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 94726 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'PHL' WHERE SecCode = 94756 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 94937 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951996.0 WHERE SecCode = 97450 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951943.0 WHERE SecCode = 98007 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 98694 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'NZL' WHERE SecCode = 98910 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510051260, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 99682 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838222447, Ticker = 'RORA', ExchCode = 'AEX', PermQuoteRetireDate = '2023-11-20' WHERE SecCode = 100279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563665075, ExchCode = 'BTE', PermQuoteRetireDate = '2024-12-23' WHERE SecCode = 100331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898257745, ExchCode = 'BTE' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951738.0 WHERE SecCode = 100479 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-21' WHERE SecCode = 100657 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951610.0 WHERE SecCode = 101252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804440368, ExchCode = 'FRA' WHERE SecCode = 112091 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419772, ExchCode = 'HAM' WHERE SecCode = 112135 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803604100, ExchCode = 'FRA' WHERE SecCode = 112136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850895861, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 112185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143294028, ExchCode = 'DEU' WHERE SecCode = 112420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475513138, ExchCode = 'DEU' WHERE SecCode = 112469 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475769528, ExchCode = 'FRA' WHERE SecCode = 112541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379768, ExchCode = 'LAS' WHERE SecCode = 112548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853085559, ExchCode = 'GER' WHERE SecCode = 112814 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379772, ExchCode = 'LAS' WHERE SecCode = 112889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803245236, ExchCode = 'FRA' WHERE SecCode = 112894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21642374740, ExchCode = 'DEU' WHERE SecCode = 112896 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 113859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837359744, PermQuoteStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 114048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785707344, ExchCode = 'QTX' WHERE SecCode = 114422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174651970, ExchCode = 'DEU' WHERE SecCode = 114496 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'WTS' WHERE SecCode = 114735 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337680, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 114831 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830288989, ExchCode = 'GTX' WHERE SecCode = 114833 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838736418, ExchCode = 'LAT', PermQuoteRetireDate = '2016-02-01' WHERE SecCode = 114943 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 115222 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951735.0 WHERE SecCode = 121401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332491, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 124677 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835808928, ExchCode = 'MEX' WHERE SecCode = 125073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564887456, ExchCode = 'DEU', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 125219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787999327, Ticker = 'IBMv', ExchCode = 'BCO' WHERE SecCode = 125274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22054464972, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 126858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21666123478, ExchCode = 'DEU' WHERE SecCode = 126859 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818125583, ExchCode = 'STU' WHERE SecCode = 127079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954293173, ExchCode = 'DUS' WHERE SecCode = 128080 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785774924, ExchCode = 'DEU' WHERE SecCode = 128487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836329157, ExchCode = 'BER' WHERE SecCode = 128489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909445, ExchCode = 'FRA' WHERE SecCode = 128495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475044182, ExchCode = 'HAM' WHERE SecCode = 128496 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951627.0 WHERE SecCode = 129885 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 130714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236814295287, ExchCode = 'TDG' WHERE SecCode = 132790 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838239668, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-31' WHERE SecCode = 132852 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21594636239, PermQuoteStatus = 'AC', Ticker = 'DTI0', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 132877 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951642.0 WHERE SecCode = 135187 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951662.0 WHERE SecCode = 136225 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 137097 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 137136 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 137529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836526218, ExchCode = 'FRA' WHERE SecCode = 137791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842898586, ExchCode = 'FRA', PermQuoteRetireDate = '2011-06-24' WHERE SecCode = 137794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21516376146, ExchCode = 'STU', PermQuoteRetireDate = '2021-04-19' WHERE SecCode = 137873 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21724373360, ExchCode = 'DEU', PermQuoteRetireDate = '2024-04-26' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475524556, Ticker = 'H1B', ExchCode = 'STU', PermQuoteRetireDate = '2009-09-14' WHERE SecCode = 138286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954817, ExchCode = 'LAS' WHERE SecCode = 139455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684827, ExchCode = 'QTX' WHERE SecCode = 139456 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 140236 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-21' WHERE SecCode = 140966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950823997, ExchCode = 'FRA' WHERE SecCode = 141520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517543297, ExchCode = 'FRA' WHERE SecCode = 141534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836323759, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 144470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22206800002, ExchCode = 'DEU' WHERE SecCode = 145421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527770884, ExchCode = 'DEU' WHERE SecCode = 145508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533743848, ExchCode = 'STU' WHERE SecCode = 145554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21640834982, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 145645 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951166.0 WHERE SecCode = 146271 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951166.0 WHERE SecCode = 146275 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951481.0 WHERE SecCode = 146888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236814570220, ExchCode = 'LAS' WHERE SecCode = 147011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836335089, ExchCode = 'BER', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 147392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543671469, ExchCode = 'TDG' WHERE SecCode = 147425 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542522415, ExchCode = 'STU', PermQuoteRetireDate = '2026-03-27' WHERE SecCode = 147470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21684961175, ExchCode = 'MUN' WHERE SecCode = 147900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782821783, ExchCode = 'MUN' WHERE SecCode = 147907 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951481.0 WHERE SecCode = 147983 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275556, ExchCode = 'GTX' WHERE SecCode = 150697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475501720, ExchCode = 'FRA' WHERE SecCode = 150782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778538487, ExchCode = 'FRA', PriTRBCIndPermID = 4294951986.0 WHERE SecCode = 150783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21574029664, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 161420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21577273820, ExchCode = 'DEU' WHERE SecCode = 164093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21514316877, ExchCode = 'STU' WHERE SecCode = 164791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859269580, PermQuoteStatus = 'DC', Ticker = 'G7F1', ExchCode = 'BER', PermQuoteRetireDate = '2017-02-21' WHERE SecCode = 165793 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629955879, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2019-08-16' WHERE SecCode = 171307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838240695, ExchCode = 'MUN' WHERE SecCode = 173076 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858592, ExchCode = 'QTX' WHERE SecCode = 177382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786291415, ExchCode = 'FRA' WHERE SecCode = 177477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799474965, ExchCode = 'LAS' WHERE SecCode = 177485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519747072, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 177695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21485216733, ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-06' WHERE SecCode = 177697 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21768600966, ExchCode = 'FRA' WHERE SecCode = 177698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492890099, ExchCode = 'STU' WHERE SecCode = 177699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793501846, ExchCode = 'FRA', PermQuoteRetireDate = '2026-07-21', PermSecMapEndDate = '2026-07-21' WHERE SecCode = 178005 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21524063641, ExchCode = 'STU' WHERE SecCode = 178009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836327818, ExchCode = 'BER', PermQuoteRetireDate = '2021-08-23' WHERE SecCode = 178014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798767858, ExchCode = 'FRA' WHERE SecCode = 178022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772839712, ExchCode = 'DEU' WHERE SecCode = 178295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732784776, ExchCode = 'DEU' WHERE SecCode = 178466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21641358574, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 178496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836325409, ExchCode = 'BER', PermQuoteRetireDate = '2014-09-23' WHERE SecCode = 178563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839309244, ExchCode = 'DEU' WHERE SecCode = 179171 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 179452 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 180002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21476171291, ExchCode = 'DEU' WHERE SecCode = 181912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474990648, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 186468 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569833, ExchCode = 'QTX' WHERE SecCode = 186811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159747742, ExchCode = 'DEU' WHERE SecCode = 190012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782179201, ExchCode = 'GTX' WHERE SecCode = 203057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956395290, ExchCode = 'DEU' WHERE SecCode = 206832 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634652662, ExchCode = 'MUN', PermQuoteRetireDate = '2020-12-23' WHERE SecCode = 208000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147785188, ExchCode = 'DEU' WHERE SecCode = 248095 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767422119, ExchCode = 'DEU' WHERE SecCode = 248753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172748620, ExchCode = 'DEU' WHERE SecCode = 249189 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951836.0 WHERE SecCode = 249373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474844752, ExchCode = 'DEU', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 249377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929161390, ExchCode = 'MUN' WHERE SecCode = 249380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793396790, ExchCode = 'DEU' WHERE SecCode = 249845 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21755228081, ExchCode = 'TDG' WHERE SecCode = 249853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667490363, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 249860 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951385.0 WHERE SecCode = 252418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799608119, ExchCode = 'LAS' WHERE SecCode = 255607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21664062914, ExchCode = 'STU' WHERE SecCode = 278881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804826538, ExchCode = 'FRA' WHERE SecCode = 291229 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951986.0 WHERE SecCode = 294527 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 295300 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21654538579, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 298603 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951986.0 WHERE SecCode = 303056 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951986.0 WHERE SecCode = 306284 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21711630349, ExchCode = 'TDG' WHERE SecCode = 311970 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836320461, ExchCode = 'BER', PermQuoteRetireDate = '2017-10-03' WHERE SecCode = 312934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615766736, ExchCode = 'TDG' WHERE SecCode = 313781 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 315602 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951196.0 WHERE SecCode = 319012 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552519091, ExchCode = 'DUS' WHERE SecCode = 319526 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 319543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836349249, ExchCode = 'FRA', PermQuoteRetireDate = '2013-04-24' WHERE SecCode = 325340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777156620, ExchCode = 'FRA' WHERE SecCode = 326662 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 326850 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951668.0 WHERE SecCode = 327103 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 331512 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-18' WHERE SecCode = 336207 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951270.0 WHERE SecCode = 336226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838863101, ExchCode = 'SGO' WHERE SecCode = 340247 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951208.0 WHERE SecCode = 346107 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836321075, ExchCode = 'BER', PermQuoteRetireDate = '2016-02-24' WHERE SecCode = 348104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536122466, PermQuoteStatus = 'AC', Ticker = '5CFA', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 348117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419816, ExchCode = 'HAM' WHERE SecCode = 348719 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509807554, Ticker = '0D39', ExchCode = 'POS' WHERE SecCode = 353941 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920545385, ExchCode = 'FRA' WHERE SecCode = 354063 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951196.0 WHERE SecCode = 356755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474949418, ExchCode = 'DEU', PermQuoteRetireDate = '2013-09-17' WHERE SecCode = 375090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794060331, ExchCode = 'MUN', PermQuoteRetireDate = '2026-09-01' WHERE SecCode = 387911 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678169, ExchCode = 'BIV' WHERE SecCode = 391198 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 395092 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 396035 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 408224 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ANT' WHERE SecCode = 450208 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 455250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21547032917, Ticker = 'K900d', ExchCode = 'BCO' WHERE SecCode = 458145 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951803.0 WHERE SecCode = 522182 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727214201, ExchCode = 'BIV' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 532114 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 536703 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 547445 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 547521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522213543, ExchCode = 'STU' WHERE SecCode = 552003 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951166.0 WHERE SecCode = 557855 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951166.0 WHERE SecCode = 557885 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 561094 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 565523 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783162833, ExchCode = 'DEU' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 770631 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 780397 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 783007 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951357.0 WHERE SecCode = 879925 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554127327, Ticker = 'XSILz', ExchCode = 'CHI' WHERE SecCode = 880290 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951203.0 WHERE SecCode = 894610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561940, ExchCode = 'TDG' WHERE SecCode = 943158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784998442, ExchCode = 'BIV' WHERE SecCode = 1013249 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951208.0 WHERE SecCode = 1024901 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'WTS' WHERE SecCode = 1187964 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 1189765 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951353.0 WHERE SecCode = 1240100 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 1264144 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-09-17' WHERE SecCode = 1459521 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21478824473, ExchCode = 'TDG' WHERE SecCode = 1480701 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 1482696 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181315457, ExchCode = 'OCE' WHERE SecCode = 1510139 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799955018, ExchCode = 'LAS' WHERE SecCode = 1534950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483519165, ExchCode = 'STU' WHERE SecCode = 1545283 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474931375, ExchCode = 'DEU' WHERE SecCode = 1547522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21500616577, ExchCode = 'STO' WHERE SecCode = 1566627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21503946795, ExchCode = 'FRA' WHERE SecCode = 1591059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780912767, ExchCode = 'MXQ' WHERE SecCode = 1591107 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 1591241 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 1592790 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 1592796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21505548787, Ticker = 'ADIDAS', ExchCode = 'BUD' WHERE SecCode = 1607132 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 1660626 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951996.0 WHERE SecCode = 1666143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22108941010, ExchCode = 'DEU' WHERE SecCode = 1733285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21513489767, ExchCode = 'FRA' WHERE SecCode = 1778982 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285770, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 2049301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21546935312, ExchCode = 'STU' WHERE SecCode = 2055322 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 2057279 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 2127715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801448989, ExchCode = 'DEU' WHERE SecCode = 2194277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21523701250, ExchCode = 'DEU' WHERE SecCode = 2239414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21612597102, ExchCode = 'TRQ', PermQuoteRetireDate = '2019-11-18' WHERE SecCode = 2300959 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 2339260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530493513, ExchCode = 'FRA' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530258030, ExchCode = 'FRA' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2384518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532914282, ExchCode = 'DEU' WHERE SecCode = 2412432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21554847086, ExchCode = 'DEU' WHERE SecCode = 2453146 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 2467267 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 2469419 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21536674787, ExchCode = 'STU' WHERE SecCode = 2487654 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538511120, ExchCode = 'DEU' WHERE SecCode = 2523899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539179038, ExchCode = 'DEU' WHERE SecCode = 2532820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539906288, ExchCode = 'FRA' WHERE SecCode = 2540723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807264642, ExchCode = 'STU' WHERE SecCode = 2552971 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ALREE' WHERE SecCode = 2559083 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21541883612, ExchCode = 'BER' WHERE SecCode = 2560597 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542048992, PermQuoteStatus = 'DC', Ticker = 'XBUCz', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-08', PermSecMapEndDate = '2018-04-19' WHERE SecCode = 2563900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21542817473, ExchCode = 'DEU' WHERE SecCode = 2570568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575706654, ExchCode = 'STU' WHERE SecCode = 2579449 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 2580219 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 2593533 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 2594268 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 2605871 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545938139, ExchCode = 'DEU', PermQuoteRetireDate = '2025-02-21', PermSecMapEndDate = '2025-02-21' WHERE SecCode = 2622293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21658998299, ExchCode = 'MEX' WHERE SecCode = 2630116 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782535985, ExchCode = 'QTX', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 2644169 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 2646548 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553991731, ExchCode = 'FRA' WHERE SecCode = 2732760 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951353.0 WHERE SecCode = 2782858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556645802, PermQuoteStatus = 'DC', Ticker = 'A71', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2796968 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 2905765 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 2950209 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 2976011 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 3021804 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 3023865 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3062337 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 3139240 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 3139241 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805429438, ExchCode = 'QTX' WHERE SecCode = 3169964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22202786243, ExchCode = 'BTE' WHERE SecCode = 3198703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21643695279, ExchCode = 'FRA' WHERE SecCode = 3228617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634471937, ExchCode = 'MUN' WHERE SecCode = 3241011 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 3247626 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22139860968, ExchCode = 'DEU' WHERE SecCode = 3255118 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 3257364 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 3271700 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 3271747 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951710.0 WHERE SecCode = 3277003 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602050155, ExchCode = 'AUX' WHERE SecCode = 3282789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677909, ExchCode = 'BIV' WHERE SecCode = 3285069 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 3285137 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951854.0 WHERE SecCode = 3285690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782181263, ExchCode = 'DUS' WHERE SecCode = 3317906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610964451, ExchCode = 'FRA' WHERE SecCode = 3321513 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 3341063 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779561825, ExchCode = 'GTX' WHERE SecCode = 3345927 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 3348750 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614331635, ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26', PermSecMapEndDate = '2017-06-26' WHERE SecCode = 3356353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21626174573, PermQuoteStatus = 'DC', Ticker = 'D4G0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3396400 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 3398661 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 3404526 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 3405221 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21647640867, ExchCode = 'DEU' WHERE SecCode = 3405306 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 3406476 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3408492 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951481.0 WHERE SecCode = 3408495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21844353068, ExchCode = 'DEU' WHERE SecCode = 3409607 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'ANT' WHERE SecCode = 3409870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629735247, InstrPermID = 21628797032, ValQuotePermID = 21629735247.0, Ticker = '750603', PermQuoteRetireDate = '2018-08-08', PermSecMapEndDate = '2017-12-27' WHERE SecCode = 3410233 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951610.0 WHERE SecCode = 3418750 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 3435594 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 3490964 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 3503571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678578, ExchCode = 'BIV' WHERE SecCode = 3512964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651601869, Ticker = '1Y1', ExchCode = 'BER', PermQuoteRetireDate = '2019-11-19' WHERE SecCode = 3520001 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 3552999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21663316530, ExchCode = 'FRA', PermQuoteRetireDate = '2020-10-26' WHERE SecCode = 3604897 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 3607561 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 3639212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21672709111, ExchCode = 'FRA' WHERE SecCode = 3656405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670410338, Ticker = 'ROAI', ExchCode = 'SWX', PermQuoteRetireDate = '2023-09-22' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 3671100 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3691603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727384244, ExchCode = 'BIV' WHERE SecCode = 3713250 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3725540 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22179537372, ExchCode = 'DEU' WHERE SecCode = 3739134 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 3771109 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 3776449 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 3806311 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727375365, ExchCode = 'BIV' WHERE SecCode = 3806450 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-17' WHERE SecCode = 3812315 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 3827755 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951559.0 WHERE SecCode = 3897411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727299601, ExchCode = 'A2X' WHERE SecCode = 3952738 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3986680 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 3998188 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 4018442 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 4030517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809064437, Ticker = '1SREm', ExchCode = 'BCO' WHERE SecCode = 4032097 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 = 236780026911, Ticker = '1MAP' WHERE SecCode = 4032116 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 4034268 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 4056136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21746425611, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4134386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298554, ExchCode = 'DEU' WHERE SecCode = 4134450 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 4168437 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 4178602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727377504, ExchCode = 'MEX' WHERE SecCode = 4178879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727351440, ExchCode = 'MEX' WHERE SecCode = 4178885 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 4209243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012792, Ticker = '2HCA' WHERE SecCode = 4214370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21756697174, ExchCode = 'FRA' WHERE SecCode = 4275426 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159899270, ExchCode = 'DEU' WHERE SecCode = 4298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21770221758, ExchCode = 'DEU' WHERE SecCode = 4360099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772241268, ExchCode = 'DEU' WHERE SecCode = 4369854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772241568, ExchCode = 'DEU' WHERE SecCode = 4369858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727322134, ExchCode = 'BIV' WHERE SecCode = 4372522 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773606535, ExchCode = 'DEU' WHERE SecCode = 4372742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22059482190, ExchCode = 'DEU' WHERE SecCode = 4381884 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773601121, ExchCode = 'BTE' WHERE SecCode = 4385232 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4401340 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 4401493 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 4402281 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 4419245 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21784912245, Ticker = '5Y7A', ExchCode = 'FRA' WHERE SecCode = 4434248 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 4440257 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 4451244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704253, ExchCode = 'MXQ' WHERE SecCode = 4462864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791932285, ExchCode = 'DUS' WHERE SecCode = 4462870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789572419, ExchCode = 'DEU' WHERE SecCode = 4463052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789568603, ExchCode = 'DEU' WHERE SecCode = 4463053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791196635, ExchCode = 'BER', PermQuoteRetireDate = '2021-01-14' WHERE SecCode = 4463088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21791480063, ExchCode = 'DEU' WHERE SecCode = 4463150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792091446, ExchCode = 'MUN' WHERE SecCode = 4463154 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 4477739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727289057, ExchCode = 'BIV' WHERE SecCode = 4495603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727287898, ExchCode = 'MEX' WHERE SecCode = 4499294 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951167.0 WHERE SecCode = 4500401 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951167.0 WHERE SecCode = 4502469 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 4506014 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800722506, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4511455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800479515, ExchCode = 'DEU' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800479400, ExchCode = 'DEU' WHERE SecCode = 4511503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800479439, ExchCode = 'DEU' WHERE SecCode = 4511504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800479449, ExchCode = 'DEU' WHERE SecCode = 4511505 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800479386, ExchCode = 'DEU' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727207693, ExchCode = 'MEX' WHERE SecCode = 4524342 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21804209124, ExchCode = 'STU', PermQuoteRetireDate = '2021-06-17' WHERE SecCode = 4529757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806286541, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4550722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825319875, ExchCode = 'STU' WHERE SecCode = 4563480 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763604068, ExchCode = 'FRA', PermQuoteRetireDate = '2024-02-14', PermSecMapEndDate = '2024-02-14' WHERE SecCode = 4570138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810191528, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4573513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727265274, ExchCode = 'MEX' WHERE SecCode = 4579631 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286428, ExchCode = 'GTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22056459759, ExchCode = 'TRQ' WHERE SecCode = 4579658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151257, Ticker = '3S2E', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 4579666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774928181, ExchCode = 'FRA' WHERE SecCode = 4580561 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 4582489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727264475, ExchCode = 'MEX' WHERE SecCode = 4585499 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 4586606 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 4588278 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812848146, ExchCode = 'DEU', PermQuoteRetireDate = '2026-09-14', PermSecMapEndDate = '2026-09-14' WHERE SecCode = 4592022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813177254, ExchCode = 'DEU' WHERE SecCode = 4592047 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815329217, ExchCode = 'TDG' WHERE SecCode = 4592050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866160226, ExchCode = 'STU' WHERE SecCode = 4594427 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727264467, ExchCode = 'BIV' WHERE SecCode = 4601841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815149494, ExchCode = 'STU' WHERE SecCode = 4603527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21813567140, ExchCode = 'DEU' WHERE SecCode = 4605986 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136872823, ExchCode = 'BTE' WHERE SecCode = 4611079 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 4620961 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951203.0 WHERE SecCode = 4634180 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727253238, ExchCode = 'BIV' WHERE SecCode = 4635342 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 4655595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727246903, ExchCode = 'BIV' WHERE SecCode = 4662851 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727248982, ExchCode = 'BIV' WHERE SecCode = 4668670 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727247752, ExchCode = 'MEX' WHERE SecCode = 4684110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22167619187, ExchCode = 'DXE' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840890324, ExchCode = 'DEU' WHERE SecCode = 4713803 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 4716071 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727230886, ExchCode = 'MEX' WHERE SecCode = 4718904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806834960, ExchCode = 'MUN' WHERE SecCode = 4727610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727229218, ExchCode = 'BIV' WHERE SecCode = 4727658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847343480, ExchCode = 'GTX' WHERE SecCode = 4730169 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 4733056 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727225424, ExchCode = 'BIV' WHERE SecCode = 4746942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851867533, ExchCode = 'DEU' WHERE SecCode = 4752212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853461111, ExchCode = 'FRA' WHERE SecCode = 4757849 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110941, PermQuoteStatus = 'AC', Ticker = '3FNGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4767862 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951322.0 WHERE SecCode = 4777328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856518896, ExchCode = 'DEU' WHERE SecCode = 4777333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856518420, ExchCode = 'FRA' WHERE SecCode = 4777350 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951322.0 WHERE SecCode = 4784317 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898176, PermQuoteStatus = 'AC', Ticker = '3LUBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4792289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238769, ExchCode = 'LAS' WHERE SecCode = 4794547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862298626, ExchCode = 'STU' WHERE SecCode = 4811142 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862298001, ExchCode = 'DEU' WHERE SecCode = 4811143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863512966, ExchCode = 'FRA' WHERE SecCode = 4811144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865900411, ExchCode = 'DEU' WHERE SecCode = 4827942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886399088, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 4854870 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836229, PermQuoteStatus = 'DC', ExchCode = 'EQD', PermQuoteRetireDate = '2023-03-27' WHERE SecCode = 4871212 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781272975, ExchCode = 'DUS' WHERE SecCode = 4898132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876897799, Ticker = '2TRV', ExchCode = 'MIL' WHERE SecCode = 4898137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21876897885, Ticker = '2CAR', ExchCode = 'MIL' WHERE SecCode = 4898138 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21878336732, ExchCode = 'BER' WHERE SecCode = 4903819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544689, ExchCode = 'DUS' WHERE SecCode = 4903820 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886391593, ExchCode = 'GTX' WHERE SecCode = 4903821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21877146809, ExchCode = 'STU' WHERE SecCode = 4903823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21880753667, PermQuoteStatus = 'AC', Ticker = '89E1', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4927414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781124629, ExchCode = 'STU' WHERE SecCode = 4936101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884772946, ExchCode = 'DUS' WHERE SecCode = 4949680 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884787278, ExchCode = 'FRA' WHERE SecCode = 4954565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727201434, ExchCode = 'MEX' WHERE SecCode = 4955623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884966423, ExchCode = 'DEU' WHERE SecCode = 4955636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22206807898, ExchCode = 'STU' WHERE SecCode = 4965018 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22090085336, ExchCode = 'GTX' WHERE SecCode = 4965039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22066264764, ExchCode = 'BTE' WHERE SecCode = 4969409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888279764, ExchCode = 'MUN' WHERE SecCode = 4972276 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21894234885, ExchCode = 'STU' WHERE SecCode = 5002456 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197814, ExchCode = 'BIV' WHERE SecCode = 5005047 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 5091145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787198172, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5096931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22199362353, Ticker = 'NGXAd', ExchCode = 'AQX' WHERE SecCode = 5104590 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 5119084 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 5152279 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22202493535, Ticker = 'KOR3d', ExchCode = 'BCO' WHERE SecCode = 5152301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923404073, PermQuoteStatus = 'DC', Ticker = '7KO0', ExchCode = 'TDG', PermQuoteRetireDate = '2026-02-05' WHERE SecCode = 5162437 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5168041 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921901229, ExchCode = 'DEU' WHERE SecCode = 5176821 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5182663 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309769, Ticker = '3LMO', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5183026 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5183095 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 5183110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836207, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5206284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917836215, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5206289 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138965750, ExchCode = 'BTE' WHERE SecCode = 5206290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22093287266, Ticker = 'AAVEp', ExchCode = 'BCO' WHERE SecCode = 5206299 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 5230330 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 5247309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948492664, ExchCode = 'GTX' WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21934228055, ExchCode = 'STU' WHERE SecCode = 5253711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933395608, ExchCode = 'FRA' WHERE SecCode = 5253715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777415246, PermQuoteStatus = 'DC', ExchCode = 'STU', PermQuoteRetireDate = '2025-01-03' WHERE SecCode = 5253716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933395088, ExchCode = 'FRA' WHERE SecCode = 5253717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787472635, ExchCode = 'GTX' WHERE SecCode = 5253719 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 5265008 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 5279829 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 5281334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775294004, ExchCode = 'BIV' WHERE SecCode = 5283359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775645817, ExchCode = 'MEX' WHERE SecCode = 5295105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781650301, ExchCode = 'QTX' WHERE SecCode = 5301963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775732424, ExchCode = 'BIV' WHERE SecCode = 5308052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943369956, ExchCode = 'DEU' WHERE SecCode = 5308057 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775782160, ExchCode = 'BIV' WHERE SecCode = 5308058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21945910440, ExchCode = 'FRA' WHERE SecCode = 5320938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955219428, ExchCode = 'STU', PermQuoteRetireDate = '2024-11-26', PermSecMapEndDate = NULL WHERE SecCode = 5320940 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 5328424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776051441, ExchCode = 'MEX' WHERE SecCode = 5346700 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 5360811 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 5360874 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037286507, ExchCode = 'BCO' WHERE SecCode = 5363621 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 5374842 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 5391387 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777177159, ExchCode = 'FRA' WHERE SecCode = 5403084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777248728, PermQuoteStatus = 'AC', Ticker = 'T2I2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5407846 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777584189, ExchCode = 'GTX' WHERE SecCode = 5426676 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777360221, ExchCode = 'BIV' WHERE SecCode = 5449618 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778397540, ExchCode = 'MEX' WHERE SecCode = 5479936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581884, ExchCode = 'QTX' WHERE SecCode = 5489281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779516033, ExchCode = 'BIV' WHERE SecCode = 5546637 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951208.0 WHERE SecCode = 5549558 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 5591609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780338117, ExchCode = 'FRA' WHERE SecCode = 5598928 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 5603324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045078273, ExchCode = 'LAS', PermQuoteRetireDate = '2025-08-29', PermSecMapEndDate = '2025-09-03' WHERE SecCode = 5668471 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5671920 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5674214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781782677, ExchCode = 'MEX' WHERE SecCode = 5679079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781858187, ExchCode = 'FRA' WHERE SecCode = 5679100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22020600429, ExchCode = 'DEU' WHERE SecCode = 5687957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782994248, ExchCode = 'STU' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783209096, ExchCode = 'FRA' WHERE SecCode = 5772640 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22111477357, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 5785810 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 5842652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784960654, ExchCode = 'MEX' WHERE SecCode = 5917759 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5938447 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 5950381 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-17' WHERE SecCode = 5963924 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 5963936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787477276, ExchCode = 'QTX' WHERE SecCode = 5974295 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 5975844 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 5975846 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 5985403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22082082523, ExchCode = 'DUS' WHERE SecCode = 5999093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071047085, ExchCode = 'FRA' WHERE SecCode = 5999095 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22071773241, ExchCode = 'DUS' WHERE SecCode = 5999103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22083389753, ExchCode = 'BRN' WHERE SecCode = 6002025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787788322, ExchCode = 'BIV' WHERE SecCode = 6002048 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138965751, ExchCode = 'BTE' WHERE SecCode = 6006783 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072149776, ExchCode = 'DEU' WHERE SecCode = 6006787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787861720, ExchCode = 'FRA' WHERE SecCode = 6012971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788328461, ExchCode = 'MEX' WHERE SecCode = 6020909 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 6024983 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788967709, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6050973 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789655528, ExchCode = 'GTX' WHERE SecCode = 6056912 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22078028826, ExchCode = 'DEU' WHERE SecCode = 6056913 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789386194, ExchCode = 'FRA' WHERE SecCode = 6065905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789657842, ExchCode = 'STU' WHERE SecCode = 6075919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22016170429, PermQuoteStatus = 'DC', Ticker = 'SCO3', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 6097382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789870076, ExchCode = 'HAN', PermQuoteRetireDate = '2025-01-31', PermSecMapEndDate = NULL WHERE SecCode = 6114320 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790344019, ExchCode = 'BIV' WHERE SecCode = 6125784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790416920, ExchCode = 'FRA' WHERE SecCode = 6128248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086925831, ExchCode = 'DEU' WHERE SecCode = 6130376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798142643, ExchCode = 'TDG' WHERE SecCode = 6130385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790441179, ExchCode = 'STU' WHERE SecCode = 6134755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790514189, ExchCode = 'FRA' WHERE SecCode = 6134784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790514192, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6134785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790479522, ExchCode = 'BIV' WHERE SecCode = 6135117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22087522161, ExchCode = 'DEU' WHERE SecCode = 6135247 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22087520756, ExchCode = 'DEU' WHERE SecCode = 6135248 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790442094, ExchCode = 'BIV' WHERE SecCode = 6135250 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 6137594 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 6137595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791039883, ExchCode = 'DUS' WHERE SecCode = 6139932 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22088523002, ExchCode = 'DEU' WHERE SecCode = 6144914 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790891794, ExchCode = 'TDG' WHERE SecCode = 6144915 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22088523235, ExchCode = 'DEU' WHERE SecCode = 6144916 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22096740154, ExchCode = 'DEU' WHERE SecCode = 6177669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791109238, ExchCode = 'FRA' WHERE SecCode = 6177690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791108502, ExchCode = 'FRA' WHERE SecCode = 6177693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791266479, Ticker = 'SATG', ExchCode = 'VIE' WHERE SecCode = 6190664 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22096749101, ExchCode = 'QTX' WHERE SecCode = 6217549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791666942, ExchCode = 'TDG' WHERE SecCode = 6222262 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791699555, ExchCode = 'QTX' WHERE SecCode = 6222270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791757429, ExchCode = 'FRA' WHERE SecCode = 6226095 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099147197, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136111004, ExchCode = 'CHI' WHERE SecCode = 6240412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099793608, Ticker = 'ET33', ExchCode = 'LSE' WHERE SecCode = 6240413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136110999, Ticker = 'BTCEl', ExchCode = 'BTE' WHERE SecCode = 6240416 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6258300 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 6270401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791406432, ExchCode = 'MEX' WHERE SecCode = 6272288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792386873, ExchCode = 'FRA' WHERE SecCode = 6272292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792386877, ExchCode = 'FRA' WHERE SecCode = 6272294 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792386874, ExchCode = 'FRA' WHERE SecCode = 6272295 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797797395, ExchCode = 'TDG' WHERE SecCode = 6285534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 47754884525, ExchCode = 'DEU' WHERE SecCode = 6285535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105162186, ExchCode = 'DEU' WHERE SecCode = 6285537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792558889, ExchCode = 'FRA' WHERE SecCode = 6286085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22105862270, ExchCode = 'GTX' WHERE SecCode = 6286094 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793934077, ExchCode = 'TDG' WHERE SecCode = 6289750 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22202028155, ExchCode = 'HAM' WHERE SecCode = 6333889 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793314440, ExchCode = 'FRA' WHERE SecCode = 6333902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796747746, ExchCode = 'GTX' WHERE SecCode = 6341717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793574852, ExchCode = 'STU' WHERE SecCode = 6351557 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793575164, ExchCode = 'FRA' WHERE SecCode = 6352009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793574849, ExchCode = 'STU' WHERE SecCode = 6352011 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6389710 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 6394416 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794616561, ExchCode = 'FRA' WHERE SecCode = 6418487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794616600, ExchCode = 'STU' WHERE SecCode = 6418489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795104268, ExchCode = 'QTX' WHERE SecCode = 6438325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795129521, ExchCode = 'FRA' WHERE SecCode = 6438418 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795129522, ExchCode = 'FRA' WHERE SecCode = 6438424 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6450887 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796059847, ExchCode = 'FRA' WHERE SecCode = 6460655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797408795, Ticker = 'FRMIl', ExchCode = 'BCO' WHERE SecCode = 6480841 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796757244, ExchCode = 'FRA' WHERE SecCode = 6490077 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-18' WHERE SecCode = 6503954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136579888, ExchCode = 'DUS' WHERE SecCode = 6520811 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 6533441 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 6533442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798464714, ExchCode = 'QTX' WHERE SecCode = 6541068 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799016699, ExchCode = 'FRA' WHERE SecCode = 6556288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143843399, ExchCode = 'DEU' WHERE SecCode = 6577960 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22143582263, ExchCode = 'DEU' WHERE SecCode = 6578061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802152103, ExchCode = 'TDG' WHERE SecCode = 6580799 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802153218, Ticker = 'U5Td', ExchCode = 'BCO' WHERE SecCode = 6603571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800229279, ExchCode = 'BIV' WHERE SecCode = 6603572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147089246, ExchCode = 'DEU' WHERE SecCode = 6603604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147089036, ExchCode = 'DEU' WHERE SecCode = 6603609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22147089100, ExchCode = 'DEU' WHERE SecCode = 6603624 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799175956, ExchCode = 'MEX' WHERE SecCode = 6608199 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800708426, ExchCode = 'FRA' WHERE SecCode = 6608461 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800708692, ExchCode = 'FRA' WHERE SecCode = 6608462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22148628460, ExchCode = 'DEU' WHERE SecCode = 6612553 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22148628531, ExchCode = 'DEU' WHERE SecCode = 6612554 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951996.0 WHERE SecCode = 6612569 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22148630268, ExchCode = 'QTX' WHERE SecCode = 6612571 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800862378, ExchCode = 'FRA' WHERE SecCode = 6617627 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801010066, ExchCode = 'FRA' WHERE SecCode = 6617628 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22134087350, ExchCode = 'FRA' WHERE SecCode = 6617649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801210625, ExchCode = 'FRA' WHERE SecCode = 6625921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778200748, ExchCode = 'FRA' WHERE SecCode = 6626357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22151458116, ExchCode = 'DEU' WHERE SecCode = 6626386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22151445360, ExchCode = 'DEU' WHERE SecCode = 6626388 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801413028, ExchCode = 'MUN' WHERE SecCode = 6626389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22183909494, Ticker = 'XDWL', ExchCode = 'SWX' WHERE SecCode = 6626392 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801424686, ExchCode = 'FRA' WHERE SecCode = 6626619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801527107, ExchCode = 'BIV' WHERE SecCode = 6626938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802025817, ExchCode = 'FRA' WHERE SecCode = 6628994 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802228284, ExchCode = 'FRA' WHERE SecCode = 6632006 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 6643379 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184177632, ExchCode = 'SWX' WHERE SecCode = 6649326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184176660, ExchCode = 'SWX' WHERE SecCode = 6649337 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803111004, ExchCode = 'FRA' WHERE SecCode = 6672563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803111007, ExchCode = 'FRA' WHERE SecCode = 6672565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803111008, ExchCode = 'FRA' WHERE SecCode = 6672567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22162383537, ExchCode = 'DEU' WHERE SecCode = 6691932 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803833721, ExchCode = 'DUS' WHERE SecCode = 6702489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22164325040, ExchCode = 'DEU' WHERE SecCode = 6708165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804072212, ExchCode = 'FRA' WHERE SecCode = 6708292 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165039814, ExchCode = 'DEU' WHERE SecCode = 6710099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804396438, ExchCode = 'QTX' WHERE SecCode = 6710100 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165039242, ExchCode = 'DEU' WHERE SecCode = 6710101 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165039207, ExchCode = 'DEU' WHERE SecCode = 6710102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165039015, ExchCode = 'DEU' WHERE SecCode = 6710103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165040074, ExchCode = 'DEU' WHERE SecCode = 6710104 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165040831, ExchCode = 'DEU' WHERE SecCode = 6710107 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 6712354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239276, ExchCode = 'FRA' WHERE SecCode = 6716119 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239275, ExchCode = 'FRA' WHERE SecCode = 6716121 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239931, ExchCode = 'FRA' WHERE SecCode = 6716122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239929, ExchCode = 'FRA' WHERE SecCode = 6716123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239978, ExchCode = 'FRA' WHERE SecCode = 6716124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239905, ExchCode = 'FRA' WHERE SecCode = 6716125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239927, ExchCode = 'FRA' WHERE SecCode = 6716126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804239906, ExchCode = 'FRA' WHERE SecCode = 6716128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784382055, ExchCode = 'LAS' WHERE SecCode = 6724297 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951939.0 WHERE SecCode = 6728358 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 6728376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168877362, ExchCode = 'DEU' WHERE SecCode = 6741050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170324839, ExchCode = 'DEU' WHERE SecCode = 6755756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172098910, ExchCode = 'DEU' WHERE SecCode = 6773146 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806019658, ExchCode = 'MEX' WHERE SecCode = 6797367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807273594, ExchCode = 'GTX' WHERE SecCode = 6806252 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806330919, ExchCode = 'MUN' WHERE SecCode = 6806253 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 22191127145.0 WHERE SecCode = 6813223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809000062, ExchCode = 'LAS' WHERE SecCode = 6820147 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804912364, ExchCode = 'BIV' WHERE SecCode = 6832757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807612972, ExchCode = 'TDG' WHERE SecCode = 6836185 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806949407, ExchCode = 'FRA' WHERE SecCode = 6843285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236806949408, ExchCode = 'FRA' WHERE SecCode = 6843286 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 6862154 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807109364, ExchCode = 'BIV' WHERE SecCode = 6862277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807348219, ExchCode = 'FRA' WHERE SecCode = 6868228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22181633481, ExchCode = 'DEU' WHERE SecCode = 6870865 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-18' WHERE SecCode = 6876622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807421874, ExchCode = 'BIV' WHERE SecCode = 6876843 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236807977900, ExchCode = 'TDG' WHERE SecCode = 6896919 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184239300, ExchCode = 'DEU' WHERE SecCode = 6896922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22184238320, ExchCode = 'DEU' WHERE SecCode = 6896923 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 6896924 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22187105161, Ticker = 'ST4Rd', ExchCode = 'BCO' WHERE SecCode = 6902754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22185822423, ExchCode = 'DEU' WHERE SecCode = 6911516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236808893306, ExchCode = 'QTX' WHERE SecCode = 6923754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22187911592, ExchCode = 'DEU' WHERE SecCode = 6930659 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22203616288, Ticker = 'GLD2', ExchCode = 'SWX' WHERE SecCode = 6930689 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951681.0 WHERE SecCode = 6937612 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809169125, ExchCode = 'FRA' WHERE SecCode = 6951893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236811595573, ExchCode = 'FRA' WHERE SecCode = 6967241 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 22191127145.0 WHERE SecCode = 6967309 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 22191127145.0 WHERE SecCode = 6969122 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809511910, ExchCode = 'TDG' WHERE SecCode = 6982407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809727615, ExchCode = 'MUN' WHERE SecCode = 6982411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809732422, ExchCode = 'FRA' WHERE SecCode = 6982412 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22193226739, ExchCode = 'DEU' WHERE SecCode = 6985099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236809893754, ExchCode = 'FRA' WHERE SecCode = 6986017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236810391927, ExchCode = 'BIV' WHERE SecCode = 7003908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236811875421, ExchCode = 'MEX' WHERE SecCode = 7037206 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 7044194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787660860, ExchCode = 'TDG' WHERE SecCode = 7050902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104904066, ExchCode = 'DUS' WHERE SecCode = 7050904 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-17' WHERE SecCode = 7050905 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22201493540, ExchCode = 'DEU' WHERE SecCode = 7067552 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22201499356, ExchCode = 'DEU' WHERE SecCode = 7067560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236812881086, ExchCode = 'BIV' WHERE SecCode = 7067561 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-18' WHERE SecCode = 7073108 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-10-01' WHERE SecCode = 7080317 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-17' WHERE SecCode = 7080713 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-18' WHERE SecCode = 7081201 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-09-18' WHERE SecCode = 7086858 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-17' WHERE SecCode = 7091079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236814721436, ExchCode = 'LAS' WHERE SecCode = 7101466 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 7102976 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 7103279 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 7103280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236814549770, ExchCode = 'MEX' WHERE SecCode = 7105053 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 7107691 AND Type_ = 10;
UPDATE data_universe_permid SET ValQuotePermID = 22191127145.0 WHERE SecCode = 7107705 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 7107709 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'PLSNF', PermQuoteRetireDate = NULL WHERE SecCode = 10839159 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55849985225, PermQuoteStatus = 'AC', Ticker = 'SOBR', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2009-01-26', PermSecMapEndDate = NULL WHERE SecCode = 10902627 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 10928741 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 10959307 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-10-02' WHERE SecCode = 11005364 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21479511882, IsPrimaryQuote = 1, Ticker = 'MNT', ExchCode = 'TOR', PermSecMapStartDate = '2011-11-28' WHERE SecCode = 11016110 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 11020220 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11047867 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951944.0 WHERE SecCode = 11058045 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 11110709 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 11129429 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 11133291 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 11139661 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 11147476 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 11151066 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11156266 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11190922 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11192708 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 11192863 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-18' WHERE SecCode = 11199570 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11200399 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = NULL WHERE SecCode = 11206523 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'SDOHF', PermQuoteRetireDate = NULL WHERE SecCode = 11207146 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951203.0 WHERE SecCode = 11208886 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 11212837 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951953.0 WHERE SecCode = 11226687 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-09-18' WHERE SecCode = 11228762 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11229179 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-18' WHERE SecCode = 11241155 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 11245629 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11247335 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11249144 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-21' WHERE SecCode = 11259224 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 11268687 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = NULL WHERE SecCode = 11275776 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'DCFBS', PermQuoteRetireDate = NULL WHERE SecCode = 11284024 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-09-21' WHERE SecCode = 11285143 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11285369 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11285426 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-18' WHERE SecCode = 11285491 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11293317 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11293329 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11293335 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11293337 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11293444 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11293447 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11293448 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11297615 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11297616 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11297619 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 11297622 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11298493 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11299498 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11299614 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11299690 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11301064 AND Type_ = 1;
UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11301272 AND Type_ = 1;