UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 430 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 847 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 885 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 1682 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951534.0 WHERE SecCode = 2065 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951534.0 WHERE SecCode = 2066 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2083 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951227.0 WHERE SecCode = 2119 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 2372 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629381588, PermQuoteStatus = 'AC', Ticker = '0Q18', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 2447 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951534.0 WHERE SecCode = 3200 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951534.0 WHERE SecCode = 3223 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 3532 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3617 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951479.0 WHERE SecCode = 3982 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 6718 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 6727 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 8559 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 8706 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 8775 AND Type_ = 10; UPDATE data_universe_permid SET IncCntry = 'GBR' WHERE SecCode = 8914 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'GGY' WHERE SecCode = 9558 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'GGY' WHERE SecCode = 9666 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 9728 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951632.0 WHERE SecCode = 10302 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951632.0 WHERE SecCode = 10303 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951987.0 WHERE SecCode = 10644 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951987.0 WHERE SecCode = 10683 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 10711 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951694.0 WHERE SecCode = 11050 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 11945 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 12133 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 12950 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 14703 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = NULL WHERE SecCode = 17171 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 17271 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 17358 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 18802 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 18836 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 19781 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 23502 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 23826 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 27615 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21634404450, Ticker = '0HKP', ExchCode = 'LSE' WHERE SecCode = 27686 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 28249 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 30013 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951184.0, PermOrgIPODate = NULL WHERE SecCode = 31111 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 32038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531129708, Ticker = 'LGCDl', ExchCode = 'BCO', PermQuoteRetireDate = '2016-02-25' WHERE SecCode = 32244 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951310.0 WHERE SecCode = 32314 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 33326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836394620, ExchCode = 'FRA', PermQuoteRetireDate = '2022-04-01' WHERE SecCode = 34155 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951543.0 WHERE SecCode = 34506 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 34611 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 36206 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 36382 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 36952 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 37039 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 37239 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 37319 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 37347 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 37677 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 38661 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 38702 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 38891 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 38907 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 39653 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951730.0 WHERE SecCode = 42317 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 42671 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 42853 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 43048 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951910.0 WHERE SecCode = 43445 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 44464 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 45012 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951857.0 WHERE SecCode = 45461 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 45578 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55850939324, ExchCode = 'BER' WHERE SecCode = 46302 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616156912, ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 46535 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 46863 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 49873 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 50014 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951841.0 WHERE SecCode = 50988 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 50995 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951527.0 WHERE SecCode = 51161 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 51230 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 51541 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 51704 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 51925 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 51930 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 52094 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 52171 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 53217 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951709.0 WHERE SecCode = 53390 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 53944 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 54408 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 54989 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 55014 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 55512 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 55527 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 55863 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 56330 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 57112 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 57835 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951405.0 WHERE SecCode = 61961 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475033713, PermQuoteStatus = 'AC', Ticker = 'AK3', ExchCode = 'TDG', PermQuoteRetireDate = NULL WHERE SecCode = 62376 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 62565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21874654411, ExchCode = 'GTX' WHERE SecCode = 63011 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917173961, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 63016 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951860.0 WHERE SecCode = 64017 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 64538 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 66093 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 67156 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 67717 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 68148 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 68649 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 69064 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 69150 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0, PermOrgIPODate = NULL WHERE SecCode = 69539 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 69553 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951533.0 WHERE SecCode = 70193 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 71172 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 73870 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 74505 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 74634 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 74698 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 74898 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 75217 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 75218 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951512.0 WHERE SecCode = 75593 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 75610 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 76157 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 76982 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951542.0 WHERE SecCode = 77452 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 77555 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 78713 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 79016 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-14' WHERE SecCode = 79403 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 79499 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 79730 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 79733 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 79835 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 80193 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951323.0 WHERE SecCode = 81909 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 81932 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 82254 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 82298 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 82485 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 82770 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 82820 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 83046 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 84123 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84811 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 84849 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951310.0 WHERE SecCode = 85100 AND Type_ = 1; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 85118 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951951.0 WHERE SecCode = 85467 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 85561 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 85587 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 86117 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 86284 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 87392 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 87407 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 88455 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 88456 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 88457 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 88683 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 89386 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793818998, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, ExchCode = 'GTC', PermQuoteRetireDate = '2026-06-25', PermSecMapEndDate = '2014-04-02' WHERE SecCode = 89496 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 89690 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 89691 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 89692 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 89693 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951703.0 WHERE SecCode = 89787 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 90028 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 90195 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 90338 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 90339 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 90461 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 91011 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 91351 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 91354 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 91864 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 91981 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 92617 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 92783 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 93500 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 93608 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 93763 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 93859 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 93860 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 93970 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 94024 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 94276 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 94669 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365417.0 WHERE SecCode = 95086 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 95189 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951360.0 WHERE SecCode = 95893 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951208.0 WHERE SecCode = 96280 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 96476 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 96703 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951672.0 WHERE SecCode = 96838 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 96935 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 98215 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 99164 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951237.0 WHERE SecCode = 99260 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951587.0 WHERE SecCode = 99350 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 99374 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 99535 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 99536 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 99650 AND Type_ = 1; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 99777 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 100109 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21898260294, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 100607 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 100749 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 101490 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 104046 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 104466 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951310.0 WHERE SecCode = 112145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21616285133, ExchCode = 'FRA' WHERE SecCode = 112231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704207, ExchCode = 'MXQ' WHERE SecCode = 112233 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951266.0 WHERE SecCode = 112239 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22143294028, ExchCode = 'DEU' WHERE SecCode = 112420 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 112611 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475772676, ExchCode = 'DEU' WHERE SecCode = 112619 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 114300 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951184.0 WHERE SecCode = 114311 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55836328907, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 114717 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 117050 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0, PermOrgIPODate = NULL WHERE SecCode = 118157 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807026221, ExchCode = 'FRA' WHERE SecCode = 119132 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 122105 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 125084 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 125132 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 126057 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 126329 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 126441 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 126639 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 127390 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 127621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997865, ExchCode = 'DEU', PermQuoteRetireDate = '2022-03-23' WHERE SecCode = 128755 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 128977 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 129843 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 130642 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951915.0, PermOrgIPODate = NULL WHERE SecCode = 131621 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475472972, ExchCode = 'FRA' WHERE SecCode = 132940 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 134000 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 136156 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 136508 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642186346, ExchCode = 'DEU' WHERE SecCode = 136909 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776858458, ExchCode = 'STU' WHERE SecCode = 136916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781307318, ExchCode = 'QTX' WHERE SecCode = 136934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656058705, ExchCode = 'DEU' WHERE SecCode = 136936 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655822360, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 136946 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951243.0 WHERE SecCode = 137488 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 138007 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21681997893, ExchCode = 'FRA' WHERE SecCode = 138040 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = NULL WHERE SecCode = 139442 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 140765 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 140900 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 142026 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 143572 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 144227 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 147043 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 147044 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 147045 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 147644 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21474940370, ExchCode = 'DEU' WHERE SecCode = 160971 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 163236 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951401.0 WHERE SecCode = 164267 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 164802 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540866207, ExchCode = 'TDG' WHERE SecCode = 165007 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 165090 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 174945 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808844351, PermQuoteStatus = 'AC', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL WHERE SecCode = 177534 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 177700 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 178004 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535836512, ExchCode = 'FRA' WHERE SecCode = 178389 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 178603 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951587.0 WHERE SecCode = 178653 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 187263 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 193532 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 193848 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475035970, ExchCode = 'TDG' WHERE SecCode = 203893 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 206733 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 207668 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 214638 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 237745 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 243354 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21829397685, Ticker = 'BABB', ExchCode = 'FRA' WHERE SecCode = 250460 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 252453 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 255752 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 257967 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 269156 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 269157 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 269158 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 278187 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 282134 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951677.0 WHERE SecCode = 283100 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 287058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21749838939, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 287571 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 289906 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 291871 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 297251 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 298247 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 301024 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 313751 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 316204 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 321969 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 323306 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-23', PermSecMapEndDate = NULL WHERE SecCode = 326286 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 331004 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 331011 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 331794 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951587.0 WHERE SecCode = 332142 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 333856 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 334208 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 55834676318, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-25', PermSecMapStartDate = '2007-10-27', PermSecMapEndDate = '2017-12-08' WHERE SecCode = 334454 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21593419413, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 334537 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 334603 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 336702 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 348674 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 355182 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951556.0 WHERE SecCode = 357581 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 359988 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 361410 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 361411 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'GBR' WHERE SecCode = 363554 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'GBR' WHERE SecCode = 363555 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 367663 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 21475387513, PermQuoteStatus = 'DC', Ticker = '6AR.BG', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17', PermSecMapStartDate = '2011-11-10', PermSecMapEndDate = '2017-12-08' WHERE SecCode = 368624 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 373889 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 381994 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 383213 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951354.0 WHERE SecCode = 385284 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 388240 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 389890 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951676.0 WHERE SecCode = 392485 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 396025 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951730.0 WHERE SecCode = 411248 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 433876 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 438371 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 454084 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 456593 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 OrgTypeCode = 'COM', DomCntry = 'GBR' WHERE SecCode = 466371 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55858584221, Ticker = 'C3IA', ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' WHERE SecCode = 471737 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951709.0 WHERE SecCode = 480116 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22010413709, Ticker = 'XAXD', ExchCode = 'SWX' WHERE SecCode = 481041 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22073604520, Ticker = 'XAXDl', ExchCode = 'BTE' WHERE SecCode = 481044 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 482434 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 495631 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 513503 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 519478 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 519516 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951542.0 WHERE SecCode = 520159 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 520392 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 521493 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 521934 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951310.0 WHERE SecCode = 522189 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 527096 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951587.0 WHERE SecCode = 548378 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 552582 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 552584 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 552602 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951589.0 WHERE SecCode = 557412 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951589.0 WHERE SecCode = 557413 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'TWN' WHERE SecCode = 558297 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 559254 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 562896 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 566135 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55859230062, ExchCode = 'FRA', PermQuoteRetireDate = '2016-11-03' WHERE SecCode = 598098 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 649936 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'ALEFA', ExchCode = 'PAR' WHERE SecCode = 669718 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886391671, ExchCode = 'GTX' WHERE SecCode = 696378 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 798142 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 843995 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951794.0 WHERE SecCode = 854257 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 946895 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 997699 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 1064591 AND Type_ = 10; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 1096272 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 1138003 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1172588 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1172630 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1172661 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1172761 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1173128 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1173361 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1173473 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1173553 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1173851 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1174077 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1174655 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1174729 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1174825 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1174853 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1174901 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 1174954 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1204784 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 1293222 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951210.0, PermOrgIPODate = NULL WHERE SecCode = 1418341 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 1453237 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1454299 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 1458976 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 1458996 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 1459023 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 1459110 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 1459148 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 1459213 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1459314 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365474.0, PermOrgIPODate = NULL WHERE SecCode = 1459328 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 1459417 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1465062 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 1476676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21652933092, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1503040 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21483930016, ExchCode = 'FRA' WHERE SecCode = 1503058 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 1540016 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21494609083, ExchCode = 'FRA', PermQuoteRetireDate = '2016-09-12' WHERE SecCode = 1544112 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705407, ExchCode = 'MXQ' WHERE SecCode = 1552111 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537006536, ExchCode = 'STU', PermQuoteRetireDate = '2020-07-24' WHERE SecCode = 1572762 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21576116533, ExchCode = 'TDG' WHERE SecCode = 1572867 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386019, ExchCode = 'LAS' WHERE SecCode = 1578153 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1585785 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21506574448, ExchCode = 'MUN' WHERE SecCode = 1610786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21482802789, Ticker = 'PV0D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1630565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538768058, Ticker = 'BMZl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-07-31' WHERE SecCode = 1635481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655822423, ExchCode = 'FRA' WHERE SecCode = 1655502 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1656694 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1665227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21510957458, Ticker = 'Q7X', PermQuoteRetireDate = '2012-10-10', PermSecMapEndDate = '2012-10-10' WHERE SecCode = 1668708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387414, ExchCode = 'LAS' WHERE SecCode = 1723207 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792907733, ExchCode = 'FRA' WHERE SecCode = 1733285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1940343 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1962813 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 2004117 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784387857, ExchCode = 'LAS' WHERE SecCode = 2039989 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802866853, ExchCode = 'DEU' WHERE SecCode = 2048649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21518074502, ExchCode = 'DEU' WHERE SecCode = 2055361 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21517928750, ExchCode = 'FRA' WHERE SecCode = 2055381 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 2065799 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521327105, ExchCode = 'FRA' WHERE SecCode = 2115214 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 2136667 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521357685, ExchCode = 'DEU' WHERE SecCode = 2201310 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21521370441, ExchCode = 'BEC' WHERE SecCode = 2201320 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 2202352 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951713.0 WHERE SecCode = 2204054 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22000143697, Ticker = '2KPN', ExchCode = 'MIL' WHERE SecCode = 2225256 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21750324152, ExchCode = 'FRA' WHERE SecCode = 2232877 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21523563544, ExchCode = 'FRA' WHERE SecCode = 2239343 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 2244332 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789017062, ExchCode = 'DUS' WHERE SecCode = 2246863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535950995, ExchCode = 'STU' WHERE SecCode = 2255684 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951587.0 WHERE SecCode = 2271002 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789386762, ExchCode = 'LAS' WHERE SecCode = 2278225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21526080169, ExchCode = 'DEU' WHERE SecCode = 2278251 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21662115406, ExchCode = 'FRA' WHERE SecCode = 2339259 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21530094550, ExchCode = 'MUN' WHERE SecCode = 2362509 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308547, ExchCode = 'GTX' WHERE SecCode = 2377960 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2379774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381501, ExchCode = 'LAS' WHERE SecCode = 2379809 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 2386513 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531130867, InstrPermID = 8590926370, OrgPermID = 4295858498, ValQuotePermID = 55835583224.0, PriInstrPermID = 8590926370.0, PermInstrStatus = 'AC', Ticker = 'MQG0d', ExchCode = 'BCO', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = 4294951922.0, PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2013-10-29' WHERE SecCode = 2387360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21531978999, ExchCode = 'FRA' WHERE SecCode = 2391351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532071614, ExchCode = 'MUN' WHERE SecCode = 2394797 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21532336874, ExchCode = 'DEU' WHERE SecCode = 2397377 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21892047304, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2412432 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55842517697, ExchCode = 'SGO' WHERE SecCode = 2435334 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = NULL WHERE SecCode = 2448344 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21533895781, ExchCode = 'FRA', PermQuoteRetireDate = '2023-12-29', PermSecMapEndDate = '2023-12-29' WHERE SecCode = 2450650 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667493842, ExchCode = 'QTX' WHERE SecCode = 2453131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21537245207, ExchCode = 'DEU', PermQuoteRetireDate = '2024-05-22', PermSecMapEndDate = '2024-05-22' WHERE SecCode = 2466348 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21535774912, ExchCode = 'BER', PermQuoteRetireDate = '2018-09-21' WHERE SecCode = 2467266 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797555632, ExchCode = 'DEU' WHERE SecCode = 2502550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21591015805, ExchCode = 'BER' WHERE SecCode = 2513107 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2513984 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551088215, ExchCode = 'DEU' WHERE SecCode = 2519534 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538410778, ExchCode = 'FRA' WHERE SecCode = 2522912 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784379477, ExchCode = 'LAS' WHERE SecCode = 2524755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538885258, ExchCode = 'DEU' WHERE SecCode = 2529651 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2531714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21587290079, ExchCode = 'STU' WHERE SecCode = 2536096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624461758, ExchCode = 'TDG', PermQuoteRetireDate = '2023-02-24' WHERE SecCode = 2557503 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542469532, ExchCode = 'DEU' WHERE SecCode = 2567216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793909715, ExchCode = 'TDG' WHERE SecCode = 2568912 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21542768596, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 2573038 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2578222 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21543708913, ExchCode = 'DEU' WHERE SecCode = 2585326 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22181314867, ExchCode = 'OCE' WHERE SecCode = 2586441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21545616500, Ticker = '2T4', ExchCode = 'FRA', PermQuoteRetireDate = '2017-10-18' WHERE SecCode = 2599278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21544378913, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-23' WHERE SecCode = 2604155 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21546596463, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 2627627 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21646062334, ExchCode = 'MUN' WHERE SecCode = 2631562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21634652632, ExchCode = 'MUN' WHERE SecCode = 2631564 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21547450530, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2636990 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549202532, ExchCode = 'FRA' WHERE SecCode = 2654800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756697295, ExchCode = 'DEU' WHERE SecCode = 2654801 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21549690613, ExchCode = 'TDG' WHERE SecCode = 2659169 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951266.0 WHERE SecCode = 2696786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21552534617, ExchCode = 'STU' WHERE SecCode = 2711203 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 2736322 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 2747503 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21554500349, ExchCode = 'MUN', PriTRBCIndPermID = 4294951179.0, PermQuoteRetireDate = '2025-06-03' WHERE SecCode = 2750984 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557399299, ExchCode = 'DEU' WHERE SecCode = 2808038 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21564228866, Ticker = 'IDV1d', ExchCode = 'BCO' WHERE SecCode = 2812145 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21557322226, ExchCode = 'DEU' WHERE SecCode = 2812146 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830308386, ExchCode = 'GTX' WHERE SecCode = 2824461 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21566118486, ExchCode = 'FRA' WHERE SecCode = 2830894 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 2830906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21916460789, ExchCode = 'GER' WHERE SecCode = 2855819 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704681, ExchCode = 'MXQ' WHERE SecCode = 2876241 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 2881062 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21596035551, ExchCode = 'STU' WHERE SecCode = 2883460 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2887231 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21682701551, Ticker = 'EXX1', ExchCode = 'BRN' WHERE SecCode = 2897593 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 2919783 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21645306003, ExchCode = 'DEU' WHERE SecCode = 2955208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21722919701, ExchCode = 'BER' WHERE SecCode = 2963590 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780659445, ExchCode = 'GTX' WHERE SecCode = 2963601 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 2972683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732787252, ExchCode = 'DUS' WHERE SecCode = 2982598 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 3024423 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951854.0 WHERE SecCode = 3044062 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21605933862, ExchCode = 'MUN' WHERE SecCode = 3105902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21800738271, ExchCode = 'QTX' WHERE SecCode = 3109823 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21584213518, ExchCode = 'DEU', PermQuoteRetireDate = '2022-10-21', PermSecMapEndDate = '2022-10-21' WHERE SecCode = 3116971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794739726, ExchCode = 'FRA' WHERE SecCode = 3124127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 3276517 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 3277046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21606833126, ExchCode = 'FRA' WHERE SecCode = 3304184 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21639225339, Ticker = 'KYH0', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3305367 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21714769303, ExchCode = 'TDG' WHERE SecCode = 3317945 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656679671, Ticker = NULL, ExchCode = 'BIV' WHERE SecCode = 3327117 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864390169, ExchCode = 'MUN' WHERE SecCode = 3337692 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3337842 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 3379230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21632119348, ExchCode = 'BER' WHERE SecCode = 3385212 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365417.0 WHERE SecCode = 3395687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21624691050, Ticker = '2META', ExchCode = 'MIL' WHERE SecCode = 3401441 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656678446, ExchCode = 'BIV' WHERE SecCode = 3401905 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21669469679, ExchCode = 'FRA' WHERE SecCode = 3401906 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22145793081, ExchCode = 'DEU' WHERE SecCode = 3401911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21640356575, PermQuoteStatus = 'DC', Ticker = 'G0A1', ExchCode = 'TDG', PermQuoteRetireDate = '2020-10-13' WHERE SecCode = 3401914 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 3405230 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951447.0 WHERE SecCode = 3408076 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 3408330 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21629966004, ExchCode = 'FRA', PermQuoteRetireDate = '2020-02-26' WHERE SecCode = 3408843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667706051, ExchCode = 'MXQ' WHERE SecCode = 3408939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21655727177, ExchCode = 'FRA' WHERE SecCode = 3408940 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236806168120, ExchCode = 'FRA' WHERE SecCode = 3408941 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784381227, ExchCode = 'LAS', PermQuoteRetireDate = '2025-02-04' WHERE SecCode = 3408942 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805162201, ExchCode = 'FRA' WHERE SecCode = 3408943 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3419087 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 3432046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896368974, Ticker = 'AMSv', ExchCode = 'BTE', PermQuoteRetireDate = '2022-06-01' WHERE SecCode = 3435592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21642186303, ExchCode = 'DEU' WHERE SecCode = 3441258 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21647221128, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-09-26' WHERE SecCode = 3490820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21648822392, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-08', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759516907, ExchCode = 'STU' WHERE SecCode = 3490824 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656675265, ExchCode = 'BIV' WHERE SecCode = 3501208 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21650965200, Ticker = 'NOKIA', ExchCode = 'PRA' WHERE SecCode = 3504673 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21611042362, ExchCode = 'DEU' WHERE SecCode = 3513992 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21660430834, ExchCode = 'DEU' WHERE SecCode = 3529093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667480309, ExchCode = 'QTX' WHERE SecCode = 3539018 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757243010, ExchCode = 'STU' WHERE SecCode = 3543197 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21753145831, ExchCode = 'BCO' WHERE SecCode = 3547843 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796358598, ExchCode = 'TDG' WHERE SecCode = 3555037 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21656838842, ExchCode = 'STU' WHERE SecCode = 3558191 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3559180 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784379563, ExchCode = 'LAS' WHERE SecCode = 3578207 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21661179149, ExchCode = 'MUN', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 3588341 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21878957446, ExchCode = 'SIG', PermQuoteRetireDate = '2023-09-23' WHERE SecCode = 3601109 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704243, ExchCode = 'MXQ' WHERE SecCode = 3604834 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21893299383, ExchCode = 'GTX' WHERE SecCode = 3619191 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667209671, ExchCode = 'DEU' WHERE SecCode = 3629787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667202566, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3629856 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 3634438 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21668632710, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3639274 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951255.0 WHERE SecCode = 3644456 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21723938636, PermQuoteStatus = 'DC', Ticker = 'EP2', ExchCode = 'QTX', PermQuoteRetireDate = '2023-09-05' WHERE SecCode = 3663204 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21636387547, Ticker = '2NFL.GB', ExchCode = 'AQS' WHERE SecCode = 3669927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21675091688, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 3690817 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21748912165, ExchCode = 'MUN', PermQuoteRetireDate = '2021-12-29' WHERE SecCode = 3691752 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 3703402 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727383886, ExchCode = 'MEX' WHERE SecCode = 3732368 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22160094634, ExchCode = 'DEU' WHERE SecCode = 3756337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21785453299, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3756592 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21758727556, ExchCode = 'MUN', PermQuoteRetireDate = '2022-10-14' WHERE SecCode = 3779971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21690636322, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3783080 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705324, ExchCode = 'MXQ' WHERE SecCode = 3793436 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3799585 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21691134946, ExchCode = 'FRA' WHERE SecCode = 3817686 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727373511, ExchCode = 'MEX' WHERE SecCode = 3821865 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21671394405, ExchCode = 'BIV' WHERE SecCode = 3822020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21694235031, ExchCode = 'FRA' WHERE SecCode = 3830032 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21696168646, ExchCode = 'DEU' WHERE SecCode = 3841484 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767399333, ExchCode = 'MUN' WHERE SecCode = 3848225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727371260, ExchCode = 'MEX' WHERE SecCode = 3851577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21701895330, ExchCode = 'STU' WHERE SecCode = 3875755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702351475, ExchCode = 'DEU', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 3883551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938950149, Ticker = 'UPRl', ExchCode = 'BCO' WHERE SecCode = 3883708 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380310, ExchCode = 'LAS' WHERE SecCode = 3886781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21702467120, ExchCode = 'FRA' WHERE SecCode = 3886782 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21703226345, ExchCode = 'STU' WHERE SecCode = 3888229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727368560, ExchCode = 'BIV' WHERE SecCode = 3890289 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21704405236, ExchCode = 'STU' WHERE SecCode = 3899655 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21709209289, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21710209423, ExchCode = 'TDG' WHERE SecCode = 3909637 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727371475, ExchCode = 'MEX' WHERE SecCode = 3913216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21980198380, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3919559 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21820576474, ExchCode = 'DUS' WHERE SecCode = 3921329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295405, ExchCode = 'GTX', PermQuoteRetireDate = '2024-10-01', PermSecMapEndDate = '2024-10-01' WHERE SecCode = 3949028 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757664205, ExchCode = 'MUN' WHERE SecCode = 3958735 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727363718, ExchCode = 'MEX' WHERE SecCode = 3966586 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727363715, ExchCode = 'MEX' WHERE SecCode = 3966587 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21808198439, ExchCode = 'MUN' WHERE SecCode = 3972240 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21720126823, ExchCode = 'STU', PermQuoteRetireDate = '2025-04-04' WHERE SecCode = 4001067 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4018435 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787826668, Ticker = '1BACm', ExchCode = 'BCO' WHERE SecCode = 4031699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846510, Ticker = '1ELEm', ExchCode = 'BCO' WHERE SecCode = 4031704 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928250, Ticker = '1Tm', ExchCode = 'BCO' WHERE SecCode = 4031711 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828442, Ticker = '1CECm', ExchCode = 'BCO' WHERE SecCode = 4031734 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928205, Ticker = '1RRTLm', ExchCode = 'BCO' WHERE SecCode = 4031758 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026734, Ticker = '1AAL' WHERE SecCode = 4031774 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026877, Ticker = '1ANTM' WHERE SecCode = 4031775 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026831, Ticker = '1AA' WHERE SecCode = 4031777 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027042, Ticker = '1AAD' WHERE SecCode = 4031778 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828455, Ticker = '1AIXAm', ExchCode = 'BCO' WHERE SecCode = 4031796 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928210, Ticker = '1AT1m', ExchCode = 'BCO' WHERE SecCode = 4031807 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026770, Ticker = '1DE' WHERE SecCode = 4031840 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027047, Ticker = '1DEZ' WHERE SecCode = 4031841 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828467, Ticker = '1DHERm', ExchCode = 'BCO' WHERE SecCode = 4031842 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828427, Ticker = '1EUZm', ExchCode = 'BCO' WHERE SecCode = 4031863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026810, Ticker = '1G' WHERE SecCode = 4031878 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026915, Ticker = '1HOG' WHERE SecCode = 4031890 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027132, Ticker = '1HFG' WHERE SecCode = 4031894 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026954, Ticker = '1HOT' WHERE SecCode = 4031902 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026869, Ticker = '1INTU' WHERE SecCode = 4031911 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026971, Ticker = '1LXS' WHERE SecCode = 4031934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026785, Ticker = '1NDX' WHERE SecCode = 4031953 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928222, Ticker = '1NXPIm', ExchCode = 'BCO' WHERE SecCode = 4031960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21597655815, Ticker = '4RI', ExchCode = 'ETX' WHERE SecCode = 4031971 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780027139, Ticker = '1PAH' WHERE SecCode = 4031975 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787861869, Ticker = '1PYPLm', ExchCode = 'BCO' WHERE SecCode = 4031977 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026822, Ticker = '1REGN' WHERE SecCode = 4031980 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026833, Ticker = '1RHM' WHERE SecCode = 4031982 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928220, Ticker = '1RDCm', ExchCode = 'BCO' WHERE SecCode = 4031987 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026942, Ticker = '1SHA', PermQuoteRetireDate = '2024-09-30' WHERE SecCode = 4031994 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026859, Ticker = '1SKB' WHERE SecCode = 4031999 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026937, Ticker = '1SNAP' WHERE SecCode = 4032002 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780026743, Ticker = '1WCH' WHERE SecCode = 4032048 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21767179786, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4034103 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 55838220597, Ticker = 'OCPET', ExchCode = 'BRU', PermQuoteRetireDate = '2023-10-02' WHERE SecCode = 4046600 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729412447, ExchCode = 'FRA' WHERE SecCode = 4059429 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21729887692, ExchCode = 'STU', PermQuoteRetireDate = '2025-09-05', PermSecMapEndDate = NULL WHERE SecCode = 4062000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21799240230, ExchCode = 'DUS' WHERE SecCode = 4109346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21737082360, ExchCode = 'DUS' WHERE SecCode = 4109380 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21951908303, Ticker = '49Y0', ExchCode = 'DUS', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 4110882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21751586975, ExchCode = 'FRA' WHERE SecCode = 4121689 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667704289, Ticker = 'AZULBN', ExchCode = 'MXQ' WHERE SecCode = 4153255 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21732155822, ExchCode = 'DEU' WHERE SecCode = 4188457 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21755406168, ExchCode = 'STU' WHERE SecCode = 4195320 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757505124, PermQuoteStatus = 'DC', Ticker = 'Z620', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4196898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21803758400, ExchCode = 'STU' WHERE SecCode = 4201669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21746665414, ExchCode = 'FRA' WHERE SecCode = 4204825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21745958218, ExchCode = 'DEU' WHERE SecCode = 4209246 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791223141, ExchCode = 'STU' WHERE SecCode = 4209753 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705135, ExchCode = 'MXQ' WHERE SecCode = 4226196 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21778023555, ExchCode = 'FRA', PermQuoteRetireDate = '2023-12-28' WHERE SecCode = 4228115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727347434, ExchCode = 'BIV' WHERE SecCode = 4256652 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21770642456, PermQuoteStatus = 'DC', Ticker = '0YL', ExchCode = 'TDG', PermQuoteRetireDate = '2022-09-19' WHERE SecCode = 4259224 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21756809736, ExchCode = 'DEU' WHERE SecCode = 4275420 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21757070807, ExchCode = 'STU' WHERE SecCode = 4277546 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727345443, ExchCode = 'BIV' WHERE SecCode = 4282147 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21759692063, ExchCode = 'DEU' WHERE SecCode = 4295731 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763122567, ExchCode = 'MUN' WHERE SecCode = 4296979 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667705427, ExchCode = 'MXQ' WHERE SecCode = 4298620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808893315, ExchCode = 'QTX', PermSecMapStartDate = '2026-06-24' WHERE SecCode = 4314871 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762580118, ExchCode = 'FRA' WHERE SecCode = 4316189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21762580175, ExchCode = 'DEU' WHERE SecCode = 4316190 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21842459237, ExchCode = 'HAN' WHERE SecCode = 4321331 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763690130, ExchCode = 'QTX' WHERE SecCode = 4321393 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782100438, ExchCode = 'QTX', PermQuoteRetireDate = '2024-04-29' WHERE SecCode = 4324497 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21763596387, ExchCode = 'MUN' WHERE SecCode = 4324622 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784388426, ExchCode = 'LAS' WHERE SecCode = 4369859 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782535999, ExchCode = 'QTX' WHERE SecCode = 4372550 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650250, ExchCode = 'DUS' WHERE SecCode = 4379790 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776452791, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4379791 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21776870580, ExchCode = 'DEU' WHERE SecCode = 4380751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830294239, ExchCode = 'GTX' WHERE SecCode = 4383000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238824, ExchCode = 'LAS' WHERE SecCode = 4385213 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301468, ExchCode = 'GTX' WHERE SecCode = 4393468 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781234893, ExchCode = 'BER' WHERE SecCode = 4413712 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727312695, ExchCode = 'BIV' WHERE SecCode = 4420916 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21780353097, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727312258, ExchCode = 'BIV' WHERE SecCode = 4424570 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727303270, ExchCode = 'BIV' WHERE SecCode = 4426957 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21783670602, ExchCode = 'EQD' WHERE SecCode = 4426958 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21787553936, ExchCode = 'DEU', PermQuoteRetireDate = '2021-01-07' WHERE SecCode = 4446127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818102097, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4449683 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21791470018, ExchCode = 'QTX' WHERE SecCode = 4451262 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727301153, ExchCode = 'BIV' WHERE SecCode = 4452337 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789552350, ExchCode = 'LAS' WHERE SecCode = 4458768 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795956950, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4466620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21794817581, ExchCode = 'FRA' WHERE SecCode = 4481104 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797244125, ExchCode = 'STU' WHERE SecCode = 4487625 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21796870257, ExchCode = 'FRA', PermQuoteRetireDate = '2025-11-04' WHERE SecCode = 4489240 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21805426109, ExchCode = 'DUS' WHERE SecCode = 4491934 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21797238012, ExchCode = 'DEU' WHERE SecCode = 4494227 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21795591035, Ticker = '0A6N', ExchCode = 'LSE' WHERE SecCode = 4500467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727286505, ExchCode = 'BIV' WHERE SecCode = 4505794 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21802851613, ExchCode = 'STU', PermQuoteRetireDate = '2026-01-07' WHERE SecCode = 4511508 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781458722, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4517877 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 4539159 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951410.0 WHERE SecCode = 4542562 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727301437, ExchCode = 'BIV' WHERE SecCode = 4547978 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21806896207, ExchCode = 'FRA' WHERE SecCode = 4550781 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365429.0 WHERE SecCode = 4553949 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 4557737 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823056706, ExchCode = 'STU', PermQuoteRetireDate = '2025-08-05', PermSecMapEndDate = NULL WHERE SecCode = 4557926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21810406482, ExchCode = 'FRA' WHERE SecCode = 4586633 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830296406, ExchCode = 'GTX' WHERE SecCode = 4594421 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830295798, ExchCode = 'GTX' WHERE SecCode = 4603527 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780105234, ExchCode = 'GTX' WHERE SecCode = 4603529 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727263611, ExchCode = 'MEX' WHERE SecCode = 4610049 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780747375, ExchCode = 'FRA' WHERE SecCode = 4615939 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884462002, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 4632115 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822771356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2021-08-16' WHERE SecCode = 4637752 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21822791593, ExchCode = 'FRA' WHERE SecCode = 4637756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21823073549, ExchCode = 'DEU' WHERE SecCode = 4637757 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21854886175, ExchCode = 'MUN' WHERE SecCode = 4639654 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21830312261, ExchCode = 'GTX' WHERE SecCode = 4646599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780368954, ExchCode = 'TDG' WHERE SecCode = 4648214 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21884954175, ExchCode = 'MUN', PermQuoteRetireDate = '2026-05-04', PermSecMapEndDate = '2026-05-04' WHERE SecCode = 4664716 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244581, ExchCode = 'MEX' WHERE SecCode = 4684128 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727244576, ExchCode = 'BIV' WHERE SecCode = 4695806 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21832282236, ExchCode = 'MXQ' WHERE SecCode = 4695826 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365435.0 WHERE SecCode = 4751036 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867779, ExchCode = 'FRA' WHERE SecCode = 4752188 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21851867533, ExchCode = 'DEU' WHERE SecCode = 4752212 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21852098692, ExchCode = 'DEU' WHERE SecCode = 4753666 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609722, ExchCode = 'DUS' WHERE SecCode = 4781733 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 4792285 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727216819, ExchCode = 'MEX' WHERE SecCode = 4802294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380493, ExchCode = 'LAS' WHERE SecCode = 4815349 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21863999710, ExchCode = 'DEU' WHERE SecCode = 4823658 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864899126, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4823660 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864899514, ExchCode = 'DEU' WHERE SecCode = 4823661 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864897333, ExchCode = 'DEU' WHERE SecCode = 4823663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865290174, ExchCode = 'GTX' WHERE SecCode = 4823664 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21864884560, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4823669 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21865902197, ExchCode = 'FRA' WHERE SecCode = 4827931 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21861142799, ExchCode = 'FRA' WHERE SecCode = 4829216 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21873923001, ExchCode = 'DUS' WHERE SecCode = 4830767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580240, ExchCode = 'GER' WHERE SecCode = 4834792 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792865438, ExchCode = 'GTX' WHERE SecCode = 4841234 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789616854, ExchCode = 'QTX' WHERE SecCode = 4845025 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21886398797, ExchCode = 'DEU', PermQuoteRetireDate = '2022-08-16', PermSecMapEndDate = '2022-08-16' WHERE SecCode = 4845029 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21881522588, ExchCode = 'STU' WHERE SecCode = 4847006 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21871068055, ExchCode = 'DEU' WHERE SecCode = 4862983 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21875612276, ExchCode = 'QTX', PermQuoteRetireDate = '2022-09-13' WHERE SecCode = 4893294 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236796694010, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4940671 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885478060, ExchCode = 'DEU' WHERE SecCode = 4940672 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21883757511, PermQuoteStatus = 'DC', Ticker = '7U6', ExchCode = 'BER', PermQuoteRetireDate = '2025-10-01' WHERE SecCode = 4949680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21913716228, ExchCode = 'DEU' WHERE SecCode = 4960863 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21885992168, ExchCode = 'FRA' WHERE SecCode = 4960864 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 4973304 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21891740368, ExchCode = 'FRA' WHERE SecCode = 4991559 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22183909427, ExchCode = 'SWX' WHERE SecCode = 5013560 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21914308142, ExchCode = 'GTX' WHERE SecCode = 5013561 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21902954507, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5041763 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777507074, ExchCode = 'STU', PermQuoteRetireDate = '2023-09-08' WHERE SecCode = 5063516 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805605436, ExchCode = 'MUN' WHERE SecCode = 5089305 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012676, Ticker = '2KDP' WHERE SecCode = 5107765 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778416293, ExchCode = 'TDG' WHERE SecCode = 5123687 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'CINV' WHERE SecCode = 5130676 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21954642004, ExchCode = 'QTX' WHERE SecCode = 5137254 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798145084, ExchCode = 'DUS' WHERE SecCode = 5140247 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 5161263 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21508528400, ExchCode = 'DEU' WHERE SecCode = 5161278 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792173203, ExchCode = 'FRA' WHERE SecCode = 5161343 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727308116, Ticker = 'WPMl', ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21475034611, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2014-11-13' WHERE SecCode = 5161351 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727248292, ExchCode = 'MEX' WHERE SecCode = 5161356 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21781498592, ExchCode = 'MXQ' WHERE SecCode = 5161409 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21850514745, ExchCode = 'DEU' WHERE SecCode = 5161417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781650207, ExchCode = 'DUS' WHERE SecCode = 5166812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21943651732, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 5174473 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931188804, ExchCode = 'STU' WHERE SecCode = 5189077 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22105049597, Ticker = 'KRC*', ExchCode = 'MXQ' WHERE SecCode = 5206281 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951868.0 WHERE SecCode = 5213046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21931108954, ExchCode = 'HAM', PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 5220960 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236783133624, ExchCode = 'TDG' WHERE SecCode = 5230230 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999012577, Ticker = '2HU3' WHERE SecCode = 5258607 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21935825325, ExchCode = 'TDG' WHERE SecCode = 5260620 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21938327486, ExchCode = 'DEU' WHERE SecCode = 5277551 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781581879, ExchCode = 'QTX' WHERE SecCode = 5338742 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380709, ExchCode = 'LAS' WHERE SecCode = 5343608 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21952265408, ExchCode = 'DEU' WHERE SecCode = 5347429 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951447.0 WHERE SecCode = 5359369 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784380716, ExchCode = 'LAS' WHERE SecCode = 5383335 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236785534615, ExchCode = 'QTX' WHERE SecCode = 5383599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782223779, ExchCode = 'QTX' WHERE SecCode = 5395767 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21712126614, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-17' WHERE SecCode = 5430827 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365435.0 WHERE SecCode = 5443588 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778288801, ExchCode = 'FRA' WHERE SecCode = 5466221 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778288799, ExchCode = 'FRA' WHERE SecCode = 5466447 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 5474595 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778585140, ExchCode = 'BIV' WHERE SecCode = 5493568 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21667975336, ExchCode = 'FRA' WHERE SecCode = 5503680 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835698, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503687 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21538283057, PermQuoteStatus = 'AC', Ticker = 'ZE2', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5503701 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21999011031, Ticker = '2TUI1U' WHERE SecCode = 5503702 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835708, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503714 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21837512065, Ticker = '3PYPa', PermQuoteRetireDate = '2021-09-16' WHERE SecCode = 5503776 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 5503781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167619191, ExchCode = 'BCO' WHERE SecCode = 5526345 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21809151304, Ticker = '3FTE', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 5535000 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471184, ExchCode = 'BIV' WHERE SecCode = 5542023 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779471180, ExchCode = 'MEX' WHERE SecCode = 5549613 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21786101497, ExchCode = 'DEU' WHERE SecCode = 5553189 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779601836, ExchCode = 'FRA' WHERE SecCode = 5553225 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779608959, ExchCode = 'FRA' WHERE SecCode = 5553229 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236779690389, ExchCode = 'STU' WHERE SecCode = 5553509 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-07-23' WHERE SecCode = 5567944 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21970293165, ExchCode = 'MUN' WHERE SecCode = 5569360 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236778760132, ExchCode = 'MEX' WHERE SecCode = 5569424 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21541308584, PermQuoteStatus = 'DC', Ticker = '2LA', ExchCode = 'TDG', PermQuoteRetireDate = '2024-01-02' WHERE SecCode = 5569431 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 25727212174, ExchCode = 'MEX' WHERE SecCode = 5604481 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236780661116, ExchCode = 'DUS' WHERE SecCode = 5620203 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22010677492, ExchCode = 'DEU' WHERE SecCode = 5638751 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236781954019, ExchCode = 'FRA' WHERE SecCode = 5687951 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782060238, ExchCode = 'STU' WHERE SecCode = 5691174 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795035307, ExchCode = 'GTX' WHERE SecCode = 5706779 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782254675, ExchCode = 'FRA' WHERE SecCode = 5710467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21772643122, ExchCode = 'FRA' WHERE SecCode = 5740839 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782810015, ExchCode = 'FRA' WHERE SecCode = 5745661 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782810012, ExchCode = 'FRA' WHERE SecCode = 5745662 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782810016, ExchCode = 'FRA' WHERE SecCode = 5745663 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782810019, ExchCode = 'FRA' WHERE SecCode = 5745664 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782872476, ExchCode = 'FRA' WHERE SecCode = 5749727 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782891343, ExchCode = 'FRA' WHERE SecCode = 5749886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782891391, ExchCode = 'FRA' WHERE SecCode = 5749887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236782928373, ExchCode = 'FRA' WHERE SecCode = 5749901 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236784996993, ExchCode = 'FRA' WHERE SecCode = 5804329 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22174666338, ExchCode = 'DXE' WHERE SecCode = 5920812 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236787714243, ExchCode = 'BIV' WHERE SecCode = 6004772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236788245572, ExchCode = 'DUS' WHERE SecCode = 6010815 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236789864380, ExchCode = 'STU' WHERE SecCode = 6078492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21814699350, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 6097395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917836167, Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097408 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917835680, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 6097422 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21906823830, ExchCode = 'AQX' WHERE SecCode = 6097426 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21917823888, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-04' WHERE SecCode = 6097430 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099128285, ExchCode = 'BCO' WHERE SecCode = 6097445 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22099128284, Ticker = 'SMCIm', ExchCode = 'BCO' WHERE SecCode = 6097447 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22086901855, ExchCode = 'GTX' WHERE SecCode = 6104636 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928239, Ticker = '1SAABm', ExchCode = 'BCO' WHERE SecCode = 6167093 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928243, Ticker = '1VOLCm', ExchCode = 'BCO' WHERE SecCode = 6167094 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928229, Ticker = '1MYCRm', ExchCode = 'BCO' WHERE SecCode = 6167096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928224, Ticker = '1SWEDm', ExchCode = 'BCO' WHERE SecCode = 6167097 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928227, Ticker = '1SSABm', ExchCode = 'BCO' WHERE SecCode = 6167100 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928230, Ticker = '1SKABm', ExchCode = 'BCO' WHERE SecCode = 6167101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928218, Ticker = '1LUNDm', ExchCode = 'BCO' WHERE SecCode = 6167102 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928238, Ticker = '1ATCBm', ExchCode = 'BCO' WHERE SecCode = 6167106 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928235, Ticker = '1SKFBm', ExchCode = 'BCO' WHERE SecCode = 6167110 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846515, Ticker = '1CLNXm', ExchCode = 'BCO' WHERE SecCode = 6167118 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928240, Ticker = '1BEIJm', ExchCode = 'BCO' WHERE SecCode = 6167119 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928228, Ticker = '1LIFCm', ExchCode = 'BCO' WHERE SecCode = 6167120 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928223, Ticker = '1LAGRm', ExchCode = 'BCO' WHERE SecCode = 6167122 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928246, Ticker = '1SWECm', ExchCode = 'BCO' WHERE SecCode = 6167124 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928226, Ticker = '1AAKm', ExchCode = 'BCO' WHERE SecCode = 6167125 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928233, Ticker = '1LATOm', ExchCode = 'BCO' WHERE SecCode = 6167126 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928225, Ticker = '1EPIAm', ExchCode = 'BCO' WHERE SecCode = 6167127 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928237, Ticker = '1GETIm', ExchCode = 'BCO' WHERE SecCode = 6167132 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928221, Ticker = '1EQTm', ExchCode = 'BCO' WHERE SecCode = 6167133 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928232, Ticker = '1SECUm', ExchCode = 'BCO' WHERE SecCode = 6167134 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928231, Ticker = '1EVOm', ExchCode = 'BCO' WHERE SecCode = 6167135 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928241, Ticker = '1HOLMm', ExchCode = 'BCO' WHERE SecCode = 6167139 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928245, Ticker = '1MTRSm', ExchCode = 'BCO' WHERE SecCode = 6167141 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846513, Ticker = '1HUHm', ExchCode = 'BCO' WHERE SecCode = 6167142 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846548, Ticker = '1LUMOm', ExchCode = 'BCO' WHERE SecCode = 6167146 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846541, Ticker = '1QTCOm', ExchCode = 'BCO' WHERE SecCode = 6167150 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846503, Ticker = '1VIDm', ExchCode = 'BCO' WHERE SecCode = 6167151 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846509, Ticker = '1SCYRm', ExchCode = 'BCO' WHERE SecCode = 6167153 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846540, Ticker = '1METSm', ExchCode = 'BCO' WHERE SecCode = 6167156 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846535, Ticker = '1UPMm', ExchCode = 'BCO' WHERE SecCode = 6167159 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846534, Ticker = '1KCRm', ExchCode = 'BCO' WHERE SecCode = 6167161 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846524, Ticker = '1SLRm', ExchCode = 'BCO' WHERE SecCode = 6167162 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846511, Ticker = '1KEMIm', ExchCode = 'BCO' WHERE SecCode = 6167163 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928217, Ticker = '1INDTm', ExchCode = 'BCO' WHERE SecCode = 6167164 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846531, Ticker = '1WRTm', ExchCode = 'BCO' WHERE SecCode = 6167165 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846526, Ticker = '1ROVIm', ExchCode = 'BCO' WHERE SecCode = 6167167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846504, Ticker = '1OUTm', ExchCode = 'BCO' WHERE SecCode = 6167168 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846516, Ticker = '1COLm', ExchCode = 'BCO' WHERE SecCode = 6167170 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846523, Ticker = '1ACXm', ExchCode = 'BCO' WHERE SecCode = 6167172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846508, Ticker = '1ANAm', ExchCode = 'BCO' WHERE SecCode = 6167173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846527, Ticker = '1IDRm', ExchCode = 'BCO' WHERE SecCode = 6167174 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846500, Ticker = '1PUIGm', ExchCode = 'BCO' WHERE SecCode = 6167175 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846521, Ticker = '1ANEm', ExchCode = 'BCO' WHERE SecCode = 6167176 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846518, Ticker = '1LOGm', ExchCode = 'BCO' WHERE SecCode = 6167177 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928268, Ticker = '1ANETm', ExchCode = 'BCO' WHERE SecCode = 6264055 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928265, Ticker = '1APOm', ExchCode = 'BCO' WHERE SecCode = 6264071 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928258, Ticker = '1AEPm', ExchCode = 'BCO' WHERE SecCode = 6264089 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928256, Ticker = '1ALGNm', ExchCode = 'BCO' WHERE SecCode = 6264096 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928254, Ticker = '1ALBm', ExchCode = 'BCO' WHERE SecCode = 6264101 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928244, Ticker = '1ABTm', ExchCode = 'BCO' WHERE SecCode = 6264113 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = '1ECHO' WHERE SecCode = 6264131 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928206, Ticker = '1TTHm', ExchCode = 'BCO' WHERE SecCode = 6264142 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792206094, ExchCode = 'QTX' WHERE SecCode = 6264277 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792556212, ExchCode = 'GTX' WHERE SecCode = 6271498 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792097807, ExchCode = 'FRA' WHERE SecCode = 6278719 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236792427502, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6278721 AND Type_ = 10; UPDATE data_universe_permid SET PriTrdQuotePermID = NULL WHERE SecCode = 6321016 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951797.0 WHERE SecCode = 6331897 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793349912, ExchCode = 'FRA' WHERE SecCode = 6334406 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793448738, ExchCode = 'FRA' WHERE SecCode = 6341809 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21887549247, ExchCode = 'GTX' WHERE SecCode = 6358857 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21843989711, ExchCode = 'MEX' WHERE SecCode = 6368810 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116655560, ExchCode = 'FRA' WHERE SecCode = 6368868 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116655688, ExchCode = 'GER' WHERE SecCode = 6368869 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116655569, ExchCode = 'FRA' WHERE SecCode = 6368870 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116655530, ExchCode = 'GER' WHERE SecCode = 6368872 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22116655499, ExchCode = 'FRA' WHERE SecCode = 6368874 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236793831169, ExchCode = 'TDG' WHERE SecCode = 6377085 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22125770690, ExchCode = 'DEU' WHERE SecCode = 6443261 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22189197578, Ticker = 'PJSRm', ExchCode = 'BCO' WHERE SecCode = 6453964 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22142451400, ExchCode = 'BTE' WHERE SecCode = 6457882 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136365452, ExchCode = 'DEU' WHERE SecCode = 6518574 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22136365302, ExchCode = 'DEU' WHERE SecCode = 6518575 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798145080, ExchCode = 'DUS' WHERE SecCode = 6518576 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798145081, ExchCode = 'DUS' WHERE SecCode = 6518577 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798269749, ExchCode = 'TDG' WHERE SecCode = 6522492 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236797256275, ExchCode = 'BIV' WHERE SecCode = 6524571 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798221430, ExchCode = 'TDG' WHERE SecCode = 6528825 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798309550, ExchCode = 'STU' WHERE SecCode = 6533454 AND Type_ = 10; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-24' WHERE SecCode = 6541020 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798746060, Ticker = 'X1Y0', ExchCode = 'DUS' WHERE SecCode = 6543873 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236794669394, ExchCode = 'BIV' WHERE SecCode = 6543895 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236798743814, ExchCode = 'QTX' WHERE SecCode = 6543898 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808846549, Ticker = '1ANGUm', ExchCode = 'BCO' WHERE SecCode = 6564746 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799174470, ExchCode = 'FRA' WHERE SecCode = 6564772 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22140857331, ExchCode = 'FRA' WHERE SecCode = 6564781 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799174468, ExchCode = 'FRA' WHERE SecCode = 6564784 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799174467, ExchCode = 'FRA' WHERE SecCode = 6564786 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799175963, ExchCode = 'TDG' WHERE SecCode = 6564787 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236799371518, ExchCode = 'FRA' WHERE SecCode = 6575446 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800095947, ExchCode = 'TDG' WHERE SecCode = 6590583 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800237935, ExchCode = 'TDG' WHERE SecCode = 6593876 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238544, ExchCode = 'FRA' WHERE SecCode = 6593880 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238546, ExchCode = 'FRA' WHERE SecCode = 6593881 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238622, ExchCode = 'FRA' WHERE SecCode = 6593883 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238547, ExchCode = 'FRA' WHERE SecCode = 6593884 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238548, ExchCode = 'FRA' WHERE SecCode = 6593886 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800238624, ExchCode = 'FRA' WHERE SecCode = 6593887 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800269662, ExchCode = 'FRA' WHERE SecCode = 6596130 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236800658724, ExchCode = 'QTX' WHERE SecCode = 6596132 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 6608407 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22135602762, ExchCode = 'GTX' WHERE SecCode = 6617649 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801607867, ExchCode = 'TDG' WHERE SecCode = 6628715 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236801914263, ExchCode = 'FRA' WHERE SecCode = 6628800 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22155220901, ExchCode = 'DEU' WHERE SecCode = 6629415 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22157135278, ExchCode = 'DEU' WHERE SecCode = 6642930 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 1004365480.0 WHERE SecCode = 6654321 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951541.0 WHERE SecCode = 6664665 AND Type_ = 10; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 6667820 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22161741374, ExchCode = 'DEU' WHERE SecCode = 6686046 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22161764453, ExchCode = 'DEU' WHERE SecCode = 6686051 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22161764414, ExchCode = 'DEU' WHERE SecCode = 6686052 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804305881, ExchCode = 'FRA' WHERE SecCode = 6721467 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22167339217, Ticker = 'DDUM', ExchCode = 'LSE' WHERE SecCode = 6727855 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804755612, ExchCode = 'FRA' WHERE SecCode = 6737926 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804755696, ExchCode = 'FRA' WHERE SecCode = 6737927 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236804755694, ExchCode = 'FRA' WHERE SecCode = 6737928 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236795337293, ExchCode = 'BIV' WHERE SecCode = 6741058 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22169965637, ExchCode = 'DEU' WHERE SecCode = 6753080 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236777699531, ExchCode = 'BIV' WHERE SecCode = 6755754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236805901586, ExchCode = 'CHI' WHERE SecCode = 6779523 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22096729407, ExchCode = 'STU' WHERE SecCode = 6796811 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22180069245, ExchCode = 'QTX' WHERE SecCode = 6808918 AND Type_ = 10; UPDATE data_universe_permid SET Ticker = 'L7S0' WHERE SecCode = 6849999 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-23' WHERE SecCode = 6857266 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-24' WHERE SecCode = 6862172 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22182598142, ExchCode = 'DEU' WHERE SecCode = 6882167 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22182904097, ExchCode = 'DEU' WHERE SecCode = 6882170 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22182909357, ExchCode = 'DEU' WHERE SecCode = 6882173 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22182909394, ExchCode = 'DEU' WHERE SecCode = 6882174 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22182909266, ExchCode = 'DEU' WHERE SecCode = 6882175 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 6882180 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807884570, ExchCode = 'FRA' WHERE SecCode = 6890826 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807884558, ExchCode = 'FRA' WHERE SecCode = 6890827 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807884379, ExchCode = 'FRA' WHERE SecCode = 6890828 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 21929724955, ExchCode = 'BEC' WHERE SecCode = 6890830 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807883959, ExchCode = 'FRA' WHERE SecCode = 6893691 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807886146, ExchCode = 'BIV' WHERE SecCode = 6893698 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236807977900, ExchCode = 'TDG' WHERE SecCode = 6896919 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808269919, ExchCode = 'FRA' WHERE SecCode = 6902160 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22188946900, Ticker = 'STARp', ExchCode = 'SIG' WHERE SecCode = 6902755 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryInstr = 1 WHERE SecCode = 6908263 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 6911165 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 6911174 AND Type_ = 10; UPDATE data_universe_permid SET PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-03' WHERE SecCode = 6914477 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 6914624 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 6917394 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-06-23' WHERE SecCode = 6917395 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808391954, ExchCode = 'FRA' WHERE SecCode = 6917417 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808395024, ExchCode = 'FRA' WHERE SecCode = 6917418 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808397274, ExchCode = 'FRA' WHERE SecCode = 6917419 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 6917426 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808186817, ExchCode = 'FRA' WHERE SecCode = 6917506 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 6920999 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 6923699 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808893306, ExchCode = 'QTX' WHERE SecCode = 6923754 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808844130, ExchCode = 'MUN' WHERE SecCode = 6923755 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808548554, ExchCode = 'FRA' WHERE SecCode = 6923756 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808928949, Ticker = 'SPCXUSD', ExchCode = 'BRN' WHERE SecCode = 6930635 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 22188306890, ExchCode = 'DEU' WHERE SecCode = 6934884 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6937614 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6937615 AND Type_ = 10; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 6937627 AND Type_ = 10; UPDATE data_universe_permid SET ValQuotePermID = 236808829663.0 WHERE SecCode = 6937641 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6937642 AND Type_ = 10; UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6937643 AND Type_ = 10; UPDATE data_universe_permid SET QuotePermID = 236808828835, ExchCode = 'FRA' WHERE SecCode = 6937686 AND Type_ = 10; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'GBR' WHERE SecCode = 10811703 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'GGY' WHERE SecCode = 10825671 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 10897487 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 10902674 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951309.0 WHERE SecCode = 10907626 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 10912521 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'USA', PriTRBCIndPermID = 4294951307.0, PermOrgIPODate = NULL WHERE SecCode = 10924589 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 10925281 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 10928393 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 10929425 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 10929506 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 10963904 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 10965069 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 10971543 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10982722 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 10988488 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 10989893 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 10990193 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11002517 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11003302 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11004074 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11005008 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11011028 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 11013171 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11013447 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 11014082 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 25727401551, InstrPermID = 232935240329, ValQuotePermID = 236807904976.0, IsPrimaryQuote = 0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'MGIDF', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2018-06-20', PermSecMapEndDate = NULL WHERE SecCode = 11014419 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11015466 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11021015 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11022918 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11030702 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236808848000, PermQuoteStatus = 'AC', Ticker = 'BIFRF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-23', PermSecMapEndDate = NULL WHERE SecCode = 11050129 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 11053803 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', Ticker = 'SCICF', PermQuoteRetireDate = NULL WHERE SecCode = 11056230 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11103949 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951587.0 WHERE SecCode = 11111194 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 11113329 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'ROU' WHERE SecCode = 11129595 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11131529 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11133132 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11136661 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 11137709 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11139481 AND Type_ = 1; UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 11146599 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11147394 AND Type_ = 1; UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 11165973 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11172796 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = NULL WHERE SecCode = 11182098 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11192617 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11192670 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11203600 AND Type_ = 1; UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-06-25' WHERE SecCode = 11207780 AND Type_ = 1; UPDATE data_universe_permid SET QuotePermID = 236808848258, ExchCode = 'GTC', PermSecMapStartDate = '2026-06-23' WHERE SecCode = 11219196 AND Type_ = 1; UPDATE data_universe_permid SET PermSecMapStartDate = '2026-06-23', PermSecMapEndDate = NULL WHERE SecCode = 11225957 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 11234124 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 11270668 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11275438 AND Type_ = 1; UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11277550 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'AC', PermInstrStatus = 'AC', Ticker = 'MVTPS', PermQuoteRetireDate = NULL WHERE SecCode = 11278633 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 11279678 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-24', PermSecMapEndDate = '2026-06-24' WHERE SecCode = 11279679 AND Type_ = 1; UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11286891 AND Type_ = 1; UPDATE data_universe_permid SET IsPrimaryInstr = 0 WHERE SecCode = 11295230 AND Type_ = 1; UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11297631 AND Type_ = 1;