UPDATE data_universe_permid SET QuotePermID = 21475562090, Ticker = 'AAT.L', ExchCode = 'CLO', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 13 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 1677 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 2503 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 5705 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'ALP', PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 10042 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 19541 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 29006 AND Type_ = 1;
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 OrgTypeCode = 'COM' WHERE SecCode = 34366 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475562064, PermQuoteStatus = 'DC', Ticker = 'AEC.I', ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 34462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474856477, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 34937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339577, ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 35746 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 35852 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'JLMC' WHERE SecCode = 37878 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 39477 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 43350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474913868, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21616156912, ExchCode = 'MCX' WHERE SecCode = 46535 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM' WHERE SecCode = 48065 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836582583, ExchCode = 'FRA' WHERE SecCode = 48131 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 48155 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 51313 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 51449 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 53563 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 21590786433, ExchCode = 'TDG' WHERE SecCode = 56615 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 57031 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835784245, ExchCode = 'DUS' WHERE SecCode = 60025 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667481256, ExchCode = 'QTX' WHERE SecCode = 60108 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836324566, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 60267 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836340932, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 60564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836555411, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 60831 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 61966 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836411094, ExchCode = 'FRA' WHERE SecCode = 65414 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474862261, ExchCode = 'DEU', PermQuoteRetireDate = '2019-02-14' WHERE SecCode = 65643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21525212599, ExchCode = 'DEU', PermQuoteRetireDate = '2020-03-20' WHERE SecCode = 65700 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951962.0 WHERE SecCode = 67930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993485, Ticker = 'AMBALALSA', ExchCode = 'NSI' WHERE SecCode = 67964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993411, Ticker = 'RRIL', ExchCode = 'NSI' WHERE SecCode = 67984 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993420, Ticker = 'ASTAR', ExchCode = 'NSI' WHERE SecCode = 68642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837398161, Ticker = 'BATLIBOI', ExchCode = 'NSI' WHERE SecCode = 69599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993401, Ticker = 'DRAGARWQ', ExchCode = 'NSI' WHERE SecCode = 69817 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853739011, Ticker = 'BIMETAL', ExchCode = 'NSI' WHERE SecCode = 69819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993497, Ticker = 'TIMEX', ExchCode = 'NSI' WHERE SecCode = 70339 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590021898.0 WHERE SecCode = 71995 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773396560, Ticker = 'NOVARTIND', ExchCode = 'NSI' WHERE SecCode = 72031 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'CUBT' WHERE SecCode = 72759 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 75034 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805993494, Ticker = 'DAICHI', ExchCode = 'NSI' WHERE SecCode = 76161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993499, Ticker = 'ELANTAS', ExchCode = 'NSI' WHERE SecCode = 77281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21707935054, Ticker = 'KENNAMET', ExchCode = 'NSI' WHERE SecCode = 77423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993452, Ticker = 'FERMENTA', ExchCode = 'NSI' WHERE SecCode = 77496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720509626, Ticker = 'KIRLFER', ExchCode = 'NSI' WHERE SecCode = 77685 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951676.0 WHERE SecCode = 77744 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993445, Ticker = 'ABMKNO', ExchCode = 'NSI' WHERE SecCode = 78123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993495, Ticker = 'HAWKINCOOK', ExchCode = 'NSI' WHERE SecCode = 78124 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993488, Ticker = 'MAFATIND', ExchCode = 'NSI' WHERE SecCode = 78179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853739011, Ticker = 'BIMETAL', ExchCode = 'NSI' WHERE SecCode = 78317 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510652677, Ticker = 'SAYAJIHOTL', ExchCode = 'NSI' WHERE SecCode = 78436 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993418, Ticker = 'LAHOTIOV', ExchCode = 'NSI' WHERE SecCode = 78669 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993496, Ticker = 'SHARDUL', ExchCode = 'NSI' WHERE SecCode = 79134 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993479, Ticker = 'DISAQ', ExchCode = 'NSI' WHERE SecCode = 79143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993388, Ticker = 'SURYALA', ExchCode = 'NSI' WHERE SecCode = 79167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993491, Ticker = 'ZFSTEERING', ExchCode = 'NSI' WHERE SecCode = 79352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993494, Ticker = 'DAICHI', ExchCode = 'NSI' WHERE SecCode = 79393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993401, Ticker = 'DRAGARWQ', ExchCode = 'NSI' WHERE SecCode = 79454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993486, Ticker = 'COCKERILL', ExchCode = 'NSI' WHERE SecCode = 79708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853994776, Ticker = 'ARIHANT', ExchCode = 'NSI' WHERE SecCode = 81364 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 81404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993420, Ticker = 'ASTAR', ExchCode = 'NSI' WHERE SecCode = 81432 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993480, Ticker = 'METROGLOBL', ExchCode = 'NSI' WHERE SecCode = 81448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993409, Ticker = 'BNALTD', ExchCode = 'NSI' WHERE SecCode = 81530 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21773396426, Ticker = 'GOODYEAR', ExchCode = 'NSI' WHERE SecCode = 81842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993427, Ticker = 'HALDYNGL', ExchCode = 'NSI' WHERE SecCode = 82086 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837398161, Ticker = 'BATLIBOI', ExchCode = 'NSI' WHERE SecCode = 82188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993427, Ticker = 'HALDYNGL', ExchCode = 'NSI' WHERE SecCode = 82225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993413, Ticker = 'NILE', ExchCode = 'NSI' WHERE SecCode = 82349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993453, Ticker = 'FEDDERSHOL', ExchCode = 'NSI' WHERE SecCode = 82376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21829128000, Ticker = 'GRAUWEIL', ExchCode = 'NSI' WHERE SecCode = 82830 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993410, Ticker = 'WPIL', ExchCode = 'NSI' WHERE SecCode = 82963 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993495, Ticker = 'HAWKINCOOK', ExchCode = 'NSI' WHERE SecCode = 83598 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 84777 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 85011 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951676.0 WHERE SecCode = 85117 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805993489, Ticker = 'NITTAGELA', ExchCode = 'NSI' WHERE SecCode = 85309 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-21' WHERE SecCode = 85403 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805993483, Ticker = 'KOTIC', ExchCode = 'NSI' WHERE SecCode = 85459 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993492, Ticker = 'KLBRENG-B', ExchCode = 'NSI' WHERE SecCode = 85463 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720509626, Ticker = 'KIRLFER', ExchCode = 'NSI' WHERE SecCode = 86139 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2016-04-28' WHERE SecCode = 87690 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805993488, Ticker = 'MAFATIND', ExchCode = 'NSI' WHERE SecCode = 87888 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993481, Ticker = 'MAJESAUT', ExchCode = 'NSI' WHERE SecCode = 87992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727196678, ExchCode = 'A2X' WHERE SecCode = 88378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993392, Ticker = 'BLIL', ExchCode = 'NSI' WHERE SecCode = 89004 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993488, Ticker = 'MAFATIND', ExchCode = 'NSI' WHERE SecCode = 89191 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993482, Ticker = 'NIRLON', ExchCode = 'NSI' WHERE SecCode = 90549 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 90575 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993413, Ticker = 'NILE', ExchCode = 'NSI' WHERE SecCode = 90638 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993441, Ticker = 'DECNGOLD', ExchCode = 'NSI' WHERE SecCode = 92308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856898038, Ticker = 'RAJPALAYAM', ExchCode = 'NSI' WHERE SecCode = 92707 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993415, Ticker = 'PRADPME', ExchCode = 'NSI' WHERE SecCode = 92907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993439, Ticker = 'ELCIDIN', ExchCode = 'NSI' WHERE SecCode = 93370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993484, Ticker = 'WELSPLSOL', ExchCode = 'NSI' WHERE SecCode = 93886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510652677, Ticker = 'SAYAJIHOTL', ExchCode = 'NSI' WHERE SecCode = 94741 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993493, Ticker = 'SHINDL', ExchCode = 'NSI' WHERE SecCode = 95291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993496, Ticker = 'SHARDUL', ExchCode = 'NSI' WHERE SecCode = 95826 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'IND' WHERE SecCode = 95890 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993498, Ticker = 'TRANSPEK', ExchCode = 'NSI' WHERE SecCode = 97040 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 97194 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993497, Ticker = 'TIMEX', ExchCode = 'NSI' WHERE SecCode = 97488 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 98161 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805993487, Ticker = 'ULTRAMAR', ExchCode = 'NSI' WHERE SecCode = 98416 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 98684 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'PGL', PermSecMapEndDate = '2026-04-14' WHERE SecCode = 99340 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993491, Ticker = 'ZFSTEERING', ExchCode = 'NSI' WHERE SecCode = 99376 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21898260294, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993435, Ticker = 'PIONRINV', ExchCode = 'NSI' WHERE SecCode = 105058 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 111378 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656727011, ExchCode = 'STU' WHERE SecCode = 111811 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 112217 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'WAU', PermSecMapStartDate = '2014-12-05', PermSecMapEndDate = '2020-10-06' WHERE SecCode = 112299 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474985217, ExchCode = 'DEU', PermQuoteRetireDate = '2018-03-07' WHERE SecCode = 112633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836392695, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17' WHERE SecCode = 112818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656058758, ExchCode = 'DEU' WHERE SecCode = 112899 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 113190 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21537960958, ExchCode = 'FRA' WHERE SecCode = 113326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836322915, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2024-07-29', PermSecMapEndDate = '2024-07-29' WHERE SecCode = 113421 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474875381, ExchCode = 'DEU' WHERE SecCode = 113424 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22066833177, ExchCode = 'DEU' WHERE SecCode = 113554 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784384599, ExchCode = 'LAS' WHERE SecCode = 113578 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 113797 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 113962 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993421, Ticker = 'KAMAHOLD', ExchCode = 'NSI' WHERE SecCode = 114709 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522213024, ExchCode = 'MUN' WHERE SecCode = 115781 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 115818 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993431, Ticker = 'MENNPIS', ExchCode = 'NSI' WHERE SecCode = 115991 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHE' WHERE SecCode = 116097 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993455, Ticker = 'FRONTSP', ExchCode = 'NSI' WHERE SecCode = 116201 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836328905, Ticker = 'FNZA', ExchCode = 'BER', PermQuoteRetireDate = '2022-01-26', PermSecMapEndDate = NULL WHERE SecCode = 116225 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21805754472, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 116327 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951165.0 WHERE SecCode = 117023 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21771298416, ExchCode = 'DEU' WHERE SecCode = 117723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381737, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 117726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823487855, ExchCode = 'DUS' WHERE SecCode = 117727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21593419464, ExchCode = 'HAM', PermQuoteRetireDate = '2019-05-02' WHERE SecCode = 117729 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'CHE' WHERE SecCode = 120312 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993456, Ticker = 'BAJAJST', ExchCode = 'NSI' WHERE SecCode = 124713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55858407804, Ticker = 'KOVAI', ExchCode = 'NSI' WHERE SecCode = 124732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704311, ExchCode = 'MXQ' WHERE SecCode = 125073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993448, Ticker = 'MCCHRLS-B', ExchCode = 'NSI' WHERE SecCode = 125323 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993446, Ticker = 'TECHNVISN', ExchCode = 'NSI' WHERE SecCode = 125588 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993395, Ticker = 'GNRL', ExchCode = 'NSI' WHERE SecCode = 126055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993393, Ticker = 'HBESD', ExchCode = 'NSI' WHERE SecCode = 126437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993412, Ticker = 'PRAVEG', ExchCode = 'NSI' WHERE SecCode = 126452 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993457, Ticker = 'AVAILFC', ExchCode = 'NSI' WHERE SecCode = 126465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993451, Ticker = 'KANCHI', ExchCode = 'NSI' WHERE SecCode = 126504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993422, Ticker = 'EMPOWER', ExchCode = 'NSI' WHERE SecCode = 126537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785774660, ExchCode = 'FRA' WHERE SecCode = 128487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624077684, ExchCode = 'DEU' WHERE SecCode = 128489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21780909428, ExchCode = 'DEU' WHERE SecCode = 128495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21509803695, Ticker = 'CR2B.GB', ExchCode = 'PLU', PermQuoteRetireDate = '2009-07-20' WHERE SecCode = 128516 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780682738, ExchCode = 'GTX' WHERE SecCode = 128769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993416, Ticker = 'VELJAN', ExchCode = 'NSI' WHERE SecCode = 128989 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993437, Ticker = 'THAKDEV', ExchCode = 'NSI' WHERE SecCode = 133084 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993403, Ticker = 'INVPRECQ', ExchCode = 'NSI' WHERE SecCode = 133616 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475473389, ExchCode = 'GER' WHERE SecCode = 133773 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993397, Ticker = 'ZSARACOM', ExchCode = 'NSI' WHERE SecCode = 135271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993424, Ticker = 'BNAGROCHEM', ExchCode = 'NSI' WHERE SecCode = 135933 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993442, Ticker = 'SHBAJRG', ExchCode = 'NSI' WHERE SecCode = 135999 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993425, Ticker = 'SCANSTL', ExchCode = 'NSI' WHERE SecCode = 136226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993390, Ticker = 'SIKA', ExchCode = 'NSI' WHERE SecCode = 136528 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993396, Ticker = 'INDPRUD', ExchCode = 'NSI' WHERE SecCode = 137250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667469445, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-04' WHERE SecCode = 137310 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993402, Ticker = 'BIRLAPREC', ExchCode = 'NSI' WHERE SecCode = 137514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556785810, ExchCode = 'STU', PermQuoteRetireDate = '2024-04-24' WHERE SecCode = 138113 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 139179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55837355357, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-16' WHERE SecCode = 139430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624377344, PermQuoteStatus = 'DC', Ticker = 'YAJ0', ExchCode = 'FRA', PermQuoteRetireDate = '2026-04-14', PermSecMapStartDate = '2017-10-16', PermSecMapEndDate = '2026-04-10' WHERE SecCode = 140068 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22163091531, ExchCode = 'DEU' WHERE SecCode = 140136 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777652457, ExchCode = 'FRA' WHERE SecCode = 140677 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 140714 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 140875 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 141035 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 141515 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 141785 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 142002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993478, Ticker = 'WIMPLAST', ExchCode = 'NSI' WHERE SecCode = 142567 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 142690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475878362, ExchCode = 'STU' WHERE SecCode = 142742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21539137828, Ticker = 'MMWL', ExchCode = 'NSI' WHERE SecCode = 142794 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275207, ExchCode = 'GTX' WHERE SecCode = 142826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21588166933, ExchCode = 'DEU' WHERE SecCode = 142944 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475781102, ExchCode = 'TDG' WHERE SecCode = 143432 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MLT' WHERE SecCode = 143568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875273, ExchCode = 'MUN' WHERE SecCode = 143895 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 143937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531377131, ExchCode = 'STU' WHERE SecCode = 147396 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836332381, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 147595 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498598256, ExchCode = 'DUS', PermQuoteRetireDate = '2013-12-19' WHERE SecCode = 147608 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21597657799, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 147614 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475770343, ExchCode = 'STU' WHERE SecCode = 147615 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608475922, ExchCode = 'STU', PermQuoteRetireDate = '2022-07-26' WHERE SecCode = 147619 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502568061, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 147620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21712607733, ExchCode = 'STU' WHERE SecCode = 147621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498609931, ExchCode = 'TDG' WHERE SecCode = 147623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341248, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-19' WHERE SecCode = 147636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308280, ExchCode = 'GTX' WHERE SecCode = 147900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830308439, ExchCode = 'GTX' WHERE SecCode = 147907 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836339056, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-12' WHERE SecCode = 147913 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 164737 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 174727 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21474888417, ExchCode = 'DEU' WHERE SecCode = 177735 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 177991 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951676.0 WHERE SecCode = 178312 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 178391 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951962.0 WHERE SecCode = 178594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993386, Ticker = 'SAPPL', ExchCode = 'NSI' WHERE SecCode = 178934 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533564239, ExchCode = 'STU', PermQuoteRetireDate = '2025-12-08' WHERE SecCode = 180684 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 183744 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 189030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21628831642, ExchCode = 'STU' WHERE SecCode = 196618 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 197824 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 202482 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21508060519, ExchCode = 'MUN' WHERE SecCode = 203893 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993449, Ticker = 'GRAVISSHO', ExchCode = 'NSI' WHERE SecCode = 209905 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 224179 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'BMU' WHERE SecCode = 242460 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805993430, Ticker = 'PREMCO', ExchCode = 'NSI' WHERE SecCode = 243350 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993408, Ticker = 'BI', ExchCode = 'NSI' WHERE SecCode = 243467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475033457, Ticker = 'CHA', ExchCode = 'TDG', PermQuoteRetireDate = '2013-08-15' WHERE SecCode = 246441 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 247942 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21561267915, ExchCode = 'BTE' WHERE SecCode = 248524 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21825087089, ExchCode = 'DEU' WHERE SecCode = 248556 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 248881 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 248885 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 249576 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836342055, ExchCode = 'BER', PermQuoteRetireDate = '2019-12-04' WHERE SecCode = 249609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21617119543, Ticker = 'CKI', ExchCode = 'STU', PermQuoteRetireDate = '2019-08-14' WHERE SecCode = 249643 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 249664 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 249723 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 249766 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55835778048, Ticker = '85C', ExchCode = 'DUS' WHERE SecCode = 250460 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 252548 AND Type_ = 10;
UPDATE data_universe_permid SET OrgTypeCode = 'COM', DomCntry = 'USA', PermOrgIPODate = '2007-12-20' WHERE SecCode = 255669 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 236805993414, Ticker = 'COMFINTE', ExchCode = 'NSI' WHERE SecCode = 255685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993490, Ticker = 'ELPROINTL', ExchCode = 'NSI' WHERE SecCode = 255886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993436, Ticker = 'ACSTECH', ExchCode = 'NSI' WHERE SecCode = 256128 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 257835 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC' WHERE SecCode = 261168 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 278881 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 283687 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-27' WHERE SecCode = 285308 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993447, Ticker = 'AKCAPIT', ExchCode = 'NSI' WHERE SecCode = 288286 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MLT' WHERE SecCode = 289899 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 290965 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993458, Ticker = 'BLACKROSE', ExchCode = 'NSI' WHERE SecCode = 290984 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 292738 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951537.0 WHERE SecCode = 293206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794261329, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 296129 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 302601 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MTQ' WHERE SecCode = 302755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475035599, ExchCode = 'TDG' WHERE SecCode = 304121 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 305563 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 306578 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 308067 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'TXBUF' WHERE SecCode = 309236 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 316073 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 318002 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'USA' WHERE SecCode = 324876 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 325774 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 331585 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 332759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55838302799, PermQuoteStatus = 'DC', Ticker = 'SZG.DE', ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17' WHERE SecCode = 333102 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836370746, ExchCode = 'FRA', PermQuoteRetireDate = '2009-04-20' WHERE SecCode = 333158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21491206922, ExchCode = 'STU', PermQuoteRetireDate = '2017-07-31' WHERE SecCode = 333182 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, ValQuotePermID = 236805996349.0 WHERE SecCode = 334399 AND Type_ = 1;
UPDATE data_universe_permid SET QuotePermID = 55836320912, ExchCode = 'BER' WHERE SecCode = 334857 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804396433, ExchCode = 'QTX' WHERE SecCode = 335262 AND Type_ = 10;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, ValQuotePermID = 236805996349.0 WHERE SecCode = 346209 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 352645 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 354677 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 360227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836321328, Ticker = '45G1', ExchCode = 'BER', PermQuoteRetireDate = '2019-05-06' WHERE SecCode = 360278 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'AUS' WHERE SecCode = 361482 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 362754 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 362759 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475489994, Ticker = '0JJ7', ExchCode = 'LSE', PermQuoteRetireDate = '2009-05-20' WHERE SecCode = 363969 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 364402 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 372405 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667484743, ExchCode = 'QTX' WHERE SecCode = 375326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993423, Ticker = '3BBLACKBIO', ExchCode = 'NSI' WHERE SecCode = 378062 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 385049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782463487, ExchCode = 'QTX' WHERE SecCode = 385281 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993387, Ticker = 'NEAGI', ExchCode = 'NSI' WHERE SecCode = 385393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993440, Ticker = 'SHRIKRISH', ExchCode = 'NSI' WHERE SecCode = 388653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799281035, ExchCode = 'FRA' WHERE SecCode = 396303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993432, Ticker = 'THACKER', ExchCode = 'NSI' WHERE SecCode = 408483 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 410491 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 412813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598800488, ExchCode = 'STU' WHERE SecCode = 412853 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55842858889, Ticker = 'SICAGEN', ExchCode = 'NSI', PermSecMapStartDate = '2026-04-20' WHERE SecCode = 417079 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 441306 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 467680 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 PermOrgIPODate = '1753-01-01' WHERE SecCode = 480681 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 481041 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 481044 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2026-04-21' WHERE SecCode = 485083 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 503842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531133909, Ticker = 'S0CBd', ExchCode = 'BCO', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 507109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521102408, ExchCode = 'STU' WHERE SecCode = 513937 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 517855 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862774028, ExchCode = 'MXQ' WHERE SecCode = 529546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886808270, ExchCode = 'MUN' WHERE SecCode = 533520 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 534826 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55851360620, ExchCode = 'FRA', PermQuoteRetireDate = '2019-02-21' WHERE SecCode = 535417 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55849997680, Ticker = 'SBUL', ExchCode = 'MIL' WHERE SecCode = 536401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480923684, ExchCode = 'BER', PermQuoteRetireDate = '2019-12-17' WHERE SecCode = 536609 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475422413, Ticker = 'FISKS.FI', ExchCode = 'PLU', PermQuoteRetireDate = '2009-09-03' WHERE SecCode = 536734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993444, Ticker = 'BENGALASM', ExchCode = 'NSI' WHERE SecCode = 539510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522030496, ExchCode = 'TDG' WHERE SecCode = 541495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21607765095, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 541523 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 542613 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807916878, ExchCode = 'TDG' WHERE SecCode = 542943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21475529491, ExchCode = 'NGM', PermQuoteRetireDate = '2010-03-27' WHERE SecCode = 547513 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21522128043, ExchCode = 'MUN' WHERE SecCode = 548067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301241, ExchCode = 'GTX' WHERE SecCode = 549236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785844948, ExchCode = 'TDG' WHERE SecCode = 549886 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993400, Ticker = 'BTTL', ExchCode = 'NSI' WHERE SecCode = 550258 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853693620, ExchCode = 'MUN', PermQuoteRetireDate = '2022-11-01', PermSecMapEndDate = '2022-11-01' WHERE SecCode = 553231 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 553351 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55852277935, ExchCode = 'MEX' WHERE SecCode = 554302 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 554690 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21520392600, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 556230 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856027323, ExchCode = 'FRA', PermQuoteRetireDate = '2013-07-04' WHERE SecCode = 556535 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667485192, ExchCode = 'QTX' WHERE SecCode = 558811 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856606623, ExchCode = 'FRA' WHERE SecCode = 559437 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21575565347, ExchCode = 'STU', PermQuoteRetireDate = '2018-04-26' WHERE SecCode = 560723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856859125, ExchCode = 'FRA', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 561328 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 561641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55856960400, ExchCode = 'FRA' WHERE SecCode = 561861 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512281634, ExchCode = 'TRQ' WHERE SecCode = 563059 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55857958579, ExchCode = 'FRA', PermQuoteRetireDate = '2021-08-19' WHERE SecCode = 567636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55853019549, ExchCode = 'MEX' WHERE SecCode = 580373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993433, Ticker = 'TAMBOLIIN', ExchCode = 'NSI' WHERE SecCode = 583144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21550981529, ExchCode = 'HAM', PermQuoteRetireDate = '2020-09-10' WHERE SecCode = 583151 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859177674, ExchCode = 'STU' WHERE SecCode = 592307 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55859254286, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28' WHERE SecCode = 599978 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 603770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21651373202, ExchCode = 'DEU' WHERE SecCode = 607486 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 612114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21847342799, ExchCode = 'MUN' WHERE SecCode = 627565 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 679950 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55863112368, Ticker = 'BABC.GB', ExchCode = 'PLU' WHERE SecCode = 703518 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21865290783, ExchCode = 'DUS' WHERE SecCode = 744688 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 772343 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 810401 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 822020 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'PGL' WHERE SecCode = 830971 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 854144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610380111, ExchCode = 'DEU' WHERE SecCode = 862925 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'WAU' WHERE SecCode = 869149 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 887841 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 997772 AND Type_ = 10;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 1013085 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993394, Ticker = 'GRANDOAK', ExchCode = 'NSI' WHERE SecCode = 1175373 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747333681, ExchCode = 'DEU' WHERE SecCode = 1447581 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582997752, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 1455200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21477469688, ExchCode = 'STU', PermQuoteRetireDate = '2015-06-01' WHERE SecCode = 1457731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674604, ExchCode = 'BIV' WHERE SecCode = 1460771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993391, Ticker = 'ASHIKA', ExchCode = 'NSI' WHERE SecCode = 1465979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21479229300, ExchCode = 'BUR', PermQuoteRetireDate = '2015-05-04' WHERE SecCode = 1472753 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 1480296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21480921413, ExchCode = 'FRA' WHERE SecCode = 1481937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482228346, ExchCode = 'DEU' WHERE SecCode = 1485685 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488606, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2020-11-02', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1485688 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 1485713 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596919147, Ticker = 'SLHOm', ExchCode = 'BTE', PermQuoteRetireDate = '2019-09-18' WHERE SecCode = 1503000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21652933092, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 1503040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21483930016, ExchCode = 'FRA' WHERE SecCode = 1503058 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494566098, ExchCode = 'STU' WHERE SecCode = 1514883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21482802786, Ticker = 'PU7D.S', ExchCode = 'CEX', PermQuoteRetireDate = '2012-05-24' WHERE SecCode = 1514908 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21584924792, Ticker = 'LIMEm', ExchCode = 'CHI', PermQuoteRetireDate = '2019-09-18' WHERE SecCode = 1517254 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656678236, ExchCode = 'BIV' WHERE SecCode = 1518823 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21486988002, ExchCode = 'DEU' WHERE SecCode = 1519184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488288403, ExchCode = 'FRA' WHERE SecCode = 1524542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850857936, ExchCode = 'MUN' WHERE SecCode = 1524543 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21767179775, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 1524544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21488652814, ExchCode = 'FRA' WHERE SecCode = 1524617 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854497767, ExchCode = 'DEU' WHERE SecCode = 1525756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21794818026, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 1527439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21489507452, ExchCode = 'STU', PermQuoteRetireDate = '2012-02-14' WHERE SecCode = 1527466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21659841732, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1527486 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21490958523, ExchCode = 'FRA' WHERE SecCode = 1531694 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1534836 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535779 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535783 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535796 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1535825 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21492888711, ExchCode = 'STU', PermQuoteRetireDate = '2014-07-25' WHERE SecCode = 1537137 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21494270027, ExchCode = 'DEU' WHERE SecCode = 1538607 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21493877846, ExchCode = 'FRA' WHERE SecCode = 1538642 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21630031903, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 1538644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502889367, ExchCode = 'STU', PermQuoteRetireDate = '2016-07-11' WHERE SecCode = 1544112 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583635011, ExchCode = 'FRA' WHERE SecCode = 1552943 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 1554723 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498230074, ExchCode = 'FRA' WHERE SecCode = 1554784 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498302420, ExchCode = 'DEU' WHERE SecCode = 1555173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21498521053, ExchCode = 'DEU' WHERE SecCode = 1556381 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502328853, ExchCode = 'FRA' WHERE SecCode = 1564927 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 1566689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502150126, ExchCode = 'STU' WHERE SecCode = 1568506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21502130153, ExchCode = 'BUR' WHERE SecCode = 1570494 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563046128, ExchCode = 'FRA' WHERE SecCode = 1570622 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 DomCntry = 'CHN' WHERE SecCode = 1621283 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 1622692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21731630886, Ticker = 'KJ7', ExchCode = 'HAM', PermQuoteRetireDate = '2021-11-01' WHERE SecCode = 1623980 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21507475276, ExchCode = 'FRA', PermQuoteRetireDate = '2023-10-09', PermSecMapEndDate = '2023-10-09' WHERE SecCode = 1624002 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993480, Ticker = 'METROGLOBL', ExchCode = 'NSI' WHERE SecCode = 1643728 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 1644060 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21510005786, ExchCode = 'FRA' WHERE SecCode = 1653506 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21512104207, ExchCode = 'STU', PermQuoteRetireDate = '2018-07-09' WHERE SecCode = 1655572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629962634, Ticker = '7O2', ExchCode = 'STU' WHERE SecCode = 1656414 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 1671658 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917520427, ExchCode = 'DEU' WHERE SecCode = 1689167 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22104925597, ExchCode = 'DEU' WHERE SecCode = 1793865 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285770, PermQuoteStatus = 'AC', Ticker = NULL, ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 1793899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681116521, ExchCode = 'DEU' WHERE SecCode = 1795399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21543577148, ExchCode = 'BER' WHERE SecCode = 1984022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538768207, Ticker = 'ECXl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-01-08' WHERE SecCode = 2013070 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836337983, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2126923 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21519816623, ExchCode = 'FRA' WHERE SecCode = 2151455 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952626663, ExchCode = 'DEU' WHERE SecCode = 2220730 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538346547, Ticker = 'YE2', ExchCode = 'STU', PermQuoteRetireDate = '2026-03-02' WHERE SecCode = 2226907 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 2231322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21527854591, ExchCode = 'STU', PermQuoteRetireDate = '2021-01-06' WHERE SecCode = 2288362 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532303445, ExchCode = 'FRA' WHERE SecCode = 2324950 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 2334633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045908023, ExchCode = 'MEX' WHERE SecCode = 2337158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255542, ExchCode = 'DEU' WHERE SecCode = 2357967 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21529795323, ExchCode = 'STU' WHERE SecCode = 2357969 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530042418, ExchCode = 'DEU' WHERE SecCode = 2357974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530485265, ExchCode = 'DEU' WHERE SecCode = 2365655 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21530255543, ExchCode = 'DEU' WHERE SecCode = 2365695 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2367883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21532303306, ExchCode = 'STU' WHERE SecCode = 2375403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818955555, ExchCode = 'STU' WHERE SecCode = 2375404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796438921, ExchCode = 'FRA' WHERE SecCode = 2375433 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540177743, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533684531, ExchCode = 'DEU' WHERE SecCode = 2435313 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21533681891, ExchCode = 'STU' WHERE SecCode = 2435329 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 2462083 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951595.0 WHERE SecCode = 2470936 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622038833, Ticker = '22N0', ExchCode = 'TDG', PermQuoteRetireDate = '2023-07-18' WHERE SecCode = 2513110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21538134819, ExchCode = 'FRA' WHERE SecCode = 2515704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696140082, ExchCode = 'QTX' WHERE SecCode = 2522906 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784379477, ExchCode = 'LAS' WHERE SecCode = 2524755 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993428, Ticker = 'KIRANVYPAR', ExchCode = 'NSI' WHERE SecCode = 2539972 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656673930, ExchCode = 'BIV' WHERE SecCode = 2542465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540740431, ExchCode = 'DEU' WHERE SecCode = 2550284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21688529407, Ticker = '53S1', ExchCode = 'DUS', PermQuoteRetireDate = '2021-06-25' WHERE SecCode = 2550286 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 2555927 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2560602 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = '0TU' WHERE SecCode = 2562162 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386870, ExchCode = 'LAS' WHERE SecCode = 2564929 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22121993910, ExchCode = 'BCO' WHERE SecCode = 2586441 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 2587444 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 2593531 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 2594256 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545670873, ExchCode = 'ASX' WHERE SecCode = 2600061 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566715663, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2604391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21545615705, ExchCode = 'FRA', PermQuoteRetireDate = '2017-09-07' WHERE SecCode = 2613148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624665037, ExchCode = 'STU', PermQuoteRetireDate = '2021-10-01' 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 = 21593419522, ExchCode = 'HAM' WHERE SecCode = 2631564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21548543680, ExchCode = 'FRA' WHERE SecCode = 2644172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549408522, ExchCode = 'DUS', PermQuoteRetireDate = '2017-11-01' WHERE SecCode = 2659169 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21551225716, ExchCode = 'STU' WHERE SecCode = 2670411 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 2670436 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'WAU' WHERE SecCode = 2677980 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 2697322 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540948191, Ticker = '0QTP', ExchCode = 'LSE', PermQuoteRetireDate = '2020-03-10' WHERE SecCode = 2710438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955513813, ExchCode = 'DUS' WHERE SecCode = 2711152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21552534617, ExchCode = 'STU' WHERE SecCode = 2711203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727309229, ExchCode = 'MEX' WHERE SecCode = 2715641 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553011784, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2023-11-29' WHERE SecCode = 2718428 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590021898.0 WHERE SecCode = 2720693 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21553634480, Ticker = 'TUINl', ExchCode = 'BCO', PermQuoteRetireDate = '2015-05-20' WHERE SecCode = 2731347 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656677010, ExchCode = 'BIV' WHERE SecCode = 2743610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704488, ExchCode = 'MXQ' WHERE SecCode = 2747774 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2755821 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951945.0 WHERE SecCode = 2761273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706109, Ticker = 'WFTN', ExchCode = 'MXQ' WHERE SecCode = 2767178 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667704555, ExchCode = 'MXQ' WHERE SecCode = 2770567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830306561, ExchCode = 'GTX' WHERE SecCode = 2774739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21549893649, ExchCode = 'FRA' WHERE SecCode = 2784985 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21556645393, ExchCode = 'FRA' WHERE SecCode = 2800411 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993438, Ticker = 'MERCANTILE', ExchCode = 'NSI' WHERE SecCode = 2807465 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993450, Ticker = 'SONAL', ExchCode = 'NSI' WHERE SecCode = 2807466 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21557252518, ExchCode = 'MUN' WHERE SecCode = 2809751 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843924761, ExchCode = 'DEU' WHERE SecCode = 2809752 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GBR' WHERE SecCode = 2809881 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993443, Ticker = 'ABANSENT', ExchCode = 'NSI' WHERE SecCode = 2812143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656676401, ExchCode = 'BIV' WHERE SecCode = 2812158 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21558477129, ExchCode = 'DEU' WHERE SecCode = 2813079 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381707, ExchCode = 'LAS' WHERE SecCode = 2817416 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 QuotePermID = 21915623088, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 2846585 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21559577677, ExchCode = 'DEU' WHERE SecCode = 2848442 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993434, Ticker = 'BEEKAY', ExchCode = 'NSI' WHERE SecCode = 2852514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21560671527, ExchCode = 'DEU' WHERE SecCode = 2855770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21589220365, ExchCode = 'DEU', PermQuoteRetireDate = '2019-04-05' WHERE SecCode = 2855771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916461039, ExchCode = 'DUS' WHERE SecCode = 2855819 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21661952426, ExchCode = 'DEU' WHERE SecCode = 2858567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21599521455, PermQuoteStatus = 'DC', ExchCode = 'BER', DomCntry = 'HKG', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2861791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21606219341, ExchCode = 'MUN' WHERE SecCode = 2864401 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563865313, PermQuoteStatus = 'DC', ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-15' WHERE SecCode = 2867587 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562382955, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 2870145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21562290887, ExchCode = 'STU' WHERE SecCode = 2870150 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993417, Ticker = 'PML', ExchCode = 'NSI' WHERE SecCode = 2873698 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818705338, ExchCode = 'DUS' WHERE SecCode = 2880971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21596035551, ExchCode = 'STU' WHERE SecCode = 2883460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428180, ExchCode = 'GTX' WHERE SecCode = 2887226 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784386769, ExchCode = 'LAS' WHERE SecCode = 2887270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21563099878, ExchCode = 'DEU' WHERE SecCode = 2892987 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21682701551, Ticker = 'EXX1', ExchCode = 'BRN' WHERE SecCode = 2897593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667479042, ExchCode = 'QTX' WHERE SecCode = 2905610 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22073079957, ExchCode = 'TDG' WHERE SecCode = 2905791 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2907082 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830296735, ExchCode = 'GTX' WHERE SecCode = 2907244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954100418, Ticker = 'H3D0', ExchCode = 'QTX', PermQuoteRetireDate = '2023-12-06' WHERE SecCode = 2909900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595116297, ExchCode = 'STU' WHERE SecCode = 2909901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21564939130, ExchCode = 'FRA' WHERE SecCode = 2909928 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 2915148 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705855, Ticker = 'UGN', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 2919739 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566942523, ExchCode = 'DEU' WHERE SecCode = 2921712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21531457530, ExchCode = 'DEU' WHERE SecCode = 2923399 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779823342, ExchCode = 'GTX' WHERE SecCode = 2924580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21566935898, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 2930544 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703900629, ExchCode = 'STU', PermQuoteRetireDate = '2019-12-04' WHERE SecCode = 2930555 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21954293373, ExchCode = 'DUS' WHERE SecCode = 2930976 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21540992047, ExchCode = 'TDG', PermQuoteRetireDate = '2019-05-24', PermSecMapEndDate = '2019-05-24' WHERE SecCode = 2932394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 55836341299, ExchCode = 'BER', PermQuoteRetireDate = '2012-01-02' WHERE SecCode = 2947875 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783066619, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 2947926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21670295233, ExchCode = 'STU' WHERE SecCode = 2947959 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21569333990, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2952372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21732787252, ExchCode = 'DUS' WHERE SecCode = 2982598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21624461911, ExchCode = 'STU' WHERE SecCode = 2985309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21634753681, ExchCode = 'TDG' WHERE SecCode = 3001072 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21792943751, ExchCode = 'GER', PermQuoteRetireDate = '2022-08-11' WHERE SecCode = 3010358 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3015974 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890669833, Ticker = '9GLA', ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-31', PermSecMapEndDate = NULL WHERE SecCode = 3020820 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 3026590 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993426, Ticker = 'QUINT', ExchCode = 'NSI' WHERE SecCode = 3050430 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993385, Ticker = 'ELITECON', ExchCode = 'NSI' WHERE SecCode = 3058490 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21619609100, ExchCode = 'MUN' WHERE SecCode = 3065856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21582997825, Ticker = 'RYA', ExchCode = 'GER', PermQuoteRetireDate = '2017-06-26' WHERE SecCode = 3072584 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21586927375, ExchCode = 'STU', PermQuoteRetireDate = '2021-11-22', PermSecMapEndDate = '2020-07-09' WHERE SecCode = 3076717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916460747, Ticker = 'OD7F', ExchCode = 'FRA' WHERE SecCode = 3076722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21916285720, Ticker = NULL, ExchCode = 'DUS' WHERE SecCode = 3076725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21581022764, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3083485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608475923, ExchCode = 'STU' WHERE SecCode = 3085564 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'AGW0' WHERE SecCode = 3087021 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21583224723, ExchCode = 'DEU', PermQuoteRetireDate = '2024-07-16' WHERE SecCode = 3102662 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'PGL' WHERE SecCode = 3120795 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 3121291 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544712, ExchCode = 'QTX' WHERE SecCode = 3125957 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3130996 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 3145309 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21587931857, ExchCode = 'BTE' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929444790, ExchCode = 'QTX' WHERE SecCode = 3167791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993429, Ticker = 'RSDFIN', ExchCode = 'NSI' WHERE SecCode = 3167795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993384, Ticker = 'MADHAVIPL', ExchCode = 'NSI' WHERE SecCode = 3177803 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3183964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993398, Ticker = 'SEIL', ExchCode = 'NSI' WHERE SecCode = 3196329 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862038094, ExchCode = 'DUS' WHERE SecCode = 3196992 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804997785, ExchCode = 'FRA' WHERE SecCode = 3196993 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 3198701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786090215, Ticker = 'PCFH', ExchCode = 'TDG' WHERE SecCode = 3198718 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21629963304, ExchCode = 'TDG', PermQuoteRetireDate = '2018-10-22' WHERE SecCode = 3199703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21590831223, ExchCode = 'STU' WHERE SecCode = 3201375 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993419, Ticker = 'TAALTECH', ExchCode = 'NSI' WHERE SecCode = 3207296 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993389, Ticker = 'KPL', ExchCode = 'NSI' WHERE SecCode = 3213384 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21714016577, ExchCode = 'MUN' WHERE SecCode = 3215534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21748306921, ExchCode = 'BER', PermQuoteRetireDate = '2023-04-06', PermSecMapEndDate = NULL WHERE SecCode = 3215564 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100465, ExchCode = 'QTX' WHERE SecCode = 3215565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802150007, Ticker = 'AD', ExchCode = 'SWX' WHERE SecCode = 3217753 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782100410, ExchCode = 'QTX' WHERE SecCode = 3247170 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667478399, ExchCode = 'QTX' WHERE SecCode = 3247179 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591485238, Ticker = '1CBK', ExchCode = 'MIL' WHERE SecCode = 3247531 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656679797, ExchCode = 'BIV' WHERE SecCode = 3257336 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598166844, ExchCode = 'FRA' WHERE SecCode = 3259354 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21598341840, ExchCode = 'FRA', PermQuoteRetireDate = '2024-08-13', PermSecMapEndDate = '2024-08-13' WHERE SecCode = 3260030 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705431, ExchCode = 'MXQ' WHERE SecCode = 3275797 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 3277059 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3277217 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951920.0 WHERE SecCode = 3282203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21517543534, ExchCode = 'FRA' WHERE SecCode = 3282250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21602970799, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 3283956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21604748306, ExchCode = 'FRA' WHERE SecCode = 3288791 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797988618, ExchCode = 'BER', PermQuoteRetireDate = '2022-07-29' WHERE SecCode = 3309705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21608278641, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL WHERE SecCode = 3312546 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705301, Ticker = 'LOGM*', ExchCode = 'MXQ', PermQuoteRetireDate = '2020-02-18' WHERE SecCode = 3312549 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22057914115, ExchCode = 'DEU' WHERE SecCode = 3315780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21610379972, ExchCode = 'FRA' WHERE SecCode = 3316586 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786651644, ExchCode = 'QTX' WHERE SecCode = 3317115 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951647.0 WHERE SecCode = 3317249 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 3317647 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 3318951 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667482861, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21611321674, ExchCode = 'FRA' WHERE SecCode = 3327824 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781510732, ExchCode = 'DUS' WHERE SecCode = 3337226 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951945.0 WHERE SecCode = 3344593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21614735175, ExchCode = 'DEU' WHERE SecCode = 3358057 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590021898.0 WHERE SecCode = 3358234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21615050504, ExchCode = 'FRA' WHERE SecCode = 3359272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819145774, PermQuoteStatus = 'AC', Ticker = '015A', ExchCode = 'TDG', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3375389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696040965, ExchCode = 'FRA', PermQuoteRetireDate = '2022-10-05' WHERE SecCode = 3391721 AND Type_ = 10;
UPDATE data_universe_permid SET PermSecMapEndDate = '2020-06-22' WHERE SecCode = 3392529 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21622029272, ExchCode = 'SWX' WHERE SecCode = 3394008 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951765.0 WHERE SecCode = 3396938 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21810204931, ExchCode = 'DEU' WHERE SecCode = 3401365 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780428164, ExchCode = 'GTX' WHERE SecCode = 3401402 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21718790762, ExchCode = 'CHI' WHERE SecCode = 3404188 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951795.0 WHERE SecCode = 3407487 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786141622, ExchCode = 'MXQ' WHERE SecCode = 3409219 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801066696, Ticker = 'C0B1', ExchCode = 'DEU' WHERE SecCode = 3410283 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3430800 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3431921 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3432346 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 3432477 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993404, Ticker = 'IWP', ExchCode = 'NSI' WHERE SecCode = 3436903 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236788404566, ExchCode = 'QTX' WHERE SecCode = 3439533 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667706312, ExchCode = 'MXQ' WHERE SecCode = 3440422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381781, ExchCode = 'LAS' WHERE SecCode = 3446357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781344364, ExchCode = 'DUS' WHERE SecCode = 3446483 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21646071844, ExchCode = 'FRA', PermQuoteRetireDate = '2019-12-30' WHERE SecCode = 3446651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21648822392, ExchCode = 'TDG', PermQuoteRetireDate = '2023-09-08', PermSecMapEndDate = '2025-06-03' WHERE SecCode = 3490821 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794206137, ExchCode = 'TDG' WHERE SecCode = 3495930 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757056989, ExchCode = 'TDG' WHERE SecCode = 3514006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830305699, ExchCode = 'GTX' WHERE SecCode = 3532734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685853416, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 3543173 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21655132827, ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-30' WHERE SecCode = 3545357 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452801, ExchCode = 'DEU' WHERE SecCode = 3549483 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3571429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782645921, ExchCode = 'BER', PermQuoteRetireDate = '2021-04-07' WHERE SecCode = 3587027 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21572528819, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993399, Ticker = 'NATIONSTD', ExchCode = 'NSI' WHERE SecCode = 3588023 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 3588107 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3599690 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3599725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893299383, ExchCode = 'GTX' WHERE SecCode = 3619191 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3623117 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667209671, ExchCode = 'DEU' WHERE SecCode = 3629787 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667705588, ExchCode = 'MXQ' WHERE SecCode = 3644857 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 3650260 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21715145241, Ticker = 'ROAIz', ExchCode = 'BCO', PermQuoteRetireDate = '2024-03-11' WHERE SecCode = 3656623 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 3661153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21674763371, ExchCode = 'DEU', PermQuoteRetireDate = '2021-12-21' WHERE SecCode = 3691752 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21673848109, ExchCode = 'BIV' WHERE SecCode = 3717229 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21679877079, ExchCode = 'FRA' WHERE SecCode = 3731062 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750785399, ExchCode = 'DEU' WHERE SecCode = 3731132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383886, ExchCode = 'MEX' WHERE SecCode = 3732368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21734197778, ExchCode = 'STU' WHERE SecCode = 3738155 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21681872326, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 3754712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527412, ExchCode = 'FRA' WHERE SecCode = 3767864 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800715066, ExchCode = 'DUS', PermQuoteRetireDate = '2023-06-02' WHERE SecCode = 3767947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21685868276, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 3783080 AND Type_ = 10;
UPDATE data_universe_permid SET PriInstrPermID = 8590021898.0 WHERE SecCode = 3800520 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719386690, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-28', PermSecMapEndDate = '2023-03-30' WHERE SecCode = 3806448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21747575648, ExchCode = 'QTX' WHERE SecCode = 3809860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781544674, ExchCode = 'DUS' WHERE SecCode = 3817679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21691134946, ExchCode = 'FRA' WHERE SecCode = 3817686 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21671394215, ExchCode = 'MEX' WHERE SecCode = 3822020 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21697686068, ExchCode = 'BER' WHERE SecCode = 3830044 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799607048, Ticker = 'NVAX', ExchCode = 'SWX' WHERE SecCode = 3831364 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21795367137, ExchCode = 'DEU' WHERE SecCode = 3841485 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3847197 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387101, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 3849234 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888036799, ExchCode = 'MUN' WHERE SecCode = 3852867 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 3875785 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21703557839, Ticker = 'UPR', ExchCode = 'LSE' WHERE SecCode = 3883708 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951834.0 WHERE SecCode = 3890335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21820365544, ExchCode = 'DUS', PermQuoteRetireDate = '2025-12-02' WHERE SecCode = 3905161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22168601313, ExchCode = 'DEU' WHERE SecCode = 3913159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727383362, ExchCode = 'MEX' WHERE SecCode = 3934323 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 3989795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720001076, ExchCode = 'TDG', PermQuoteRetireDate = '2023-06-05' WHERE SecCode = 4001067 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21719403307, ExchCode = 'DEU' WHERE SecCode = 4004565 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22043076029, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4008980 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 4013383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727359630, ExchCode = 'MEX' WHERE SecCode = 4024645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21722747312, ExchCode = 'BCO' WHERE SecCode = 4024795 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236787826668, Ticker = '1BACm', ExchCode = 'BCO' WHERE SecCode = 4031699 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011239, Ticker = '2T' WHERE SecCode = 4031711 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026926, Ticker = '1CEC' WHERE SecCode = 4031734 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026865, Ticker = '11COV' WHERE SecCode = 4031771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011913, Ticker = '2AAL' WHERE SecCode = 4031774 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011911, Ticker = '2AA' WHERE SecCode = 4031777 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027150, Ticker = '1AIXA' WHERE SecCode = 4031796 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780027148, Ticker = '1DHER' WHERE SecCode = 4031842 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012795, Ticker = '2KHC' WHERE SecCode = 4031921 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026920, Ticker = '1MAR' WHERE SecCode = 4031937 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143822, Ticker = '2UCB', ExchCode = 'MIL' WHERE SecCode = 4032109 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010953, Ticker = '2ACS' WHERE SecCode = 4032115 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011967, Ticker = '2DD' WHERE SecCode = 4032277 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751582009, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4034103 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 4046489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21969591969, ExchCode = 'DEU' WHERE SecCode = 4046648 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 4066633 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 4066638 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 4068202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21870301372, ExchCode = 'MUN' WHERE SecCode = 4068293 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21733147228, ExchCode = 'FRA' WHERE SecCode = 4087444 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 4087815 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951377.0 WHERE SecCode = 4102330 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21751586898, ExchCode = 'DEU' WHERE SecCode = 4121689 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 4153236 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21656674204, ExchCode = 'BIV' WHERE SecCode = 4153255 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781829986, ExchCode = 'QTX' WHERE SecCode = 4178603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21739433458, ExchCode = 'DEU' WHERE SecCode = 4178604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21711236400, ExchCode = 'MXQ' WHERE SecCode = 4187947 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745348418, ExchCode = 'TDG' WHERE SecCode = 4188130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21745304635, ExchCode = 'DEU' WHERE SecCode = 4195320 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 4195353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21750154407, ExchCode = 'STU', PermQuoteRetireDate = '2023-12-19' 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 = 21754534014, ExchCode = 'TDG' WHERE SecCode = 4256876 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21757455927, ExchCode = 'DEU' WHERE SecCode = 4277594 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759692047, ExchCode = 'FRA' WHERE SecCode = 4295731 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759801437, ExchCode = 'FRA' WHERE SecCode = 4296979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21699218038, ExchCode = 'FRA' WHERE SecCode = 4298602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22159899270, ExchCode = 'DEU' WHERE SecCode = 4298603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21696686071, ExchCode = 'STU' WHERE SecCode = 4298604 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21720132349, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4298606 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21759524962, ExchCode = 'FRA' WHERE SecCode = 4298644 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727343768, ExchCode = 'BIV' WHERE SecCode = 4303636 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011157, Ticker = '2SPOT' WHERE SecCode = 4309035 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143914, Ticker = '2TKWY', ExchCode = 'MIL' WHERE SecCode = 4309036 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999010963, Ticker = '2AMS' WHERE SecCode = 4309037 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011282, Ticker = '2NB' WHERE SecCode = 4309038 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143959, Ticker = '2RMS', ExchCode = 'MIL' WHERE SecCode = 4309039 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22000143858, Ticker = '2ASM', ExchCode = 'MIL' WHERE SecCode = 4309043 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999012280, Ticker = '2FSLR' WHERE SecCode = 4309045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21761432057, ExchCode = 'DEU' WHERE SecCode = 4309050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381904, ExchCode = 'LAS' WHERE SecCode = 4321331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763596291, ExchCode = 'DUS' WHERE SecCode = 4321393 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21709366460, ExchCode = 'BIV' WHERE SecCode = 4324371 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727341342, ExchCode = 'BIV' WHERE SecCode = 4324380 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21763724005, ExchCode = 'MUN', PermQuoteRetireDate = '2024-05-02' WHERE SecCode = 4324497 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21839048914, ExchCode = 'MUN' WHERE SecCode = 4324503 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871880783, ExchCode = 'MUN' WHERE SecCode = 4346668 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 4362601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776452791, ExchCode = 'FRA' WHERE SecCode = 4379791 AND Type_ = 10;
UPDATE data_universe_permid SET Ticker = 'WAU' WHERE SecCode = 4380737 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21776270386, ExchCode = 'DEU' WHERE SecCode = 4385213 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951585.0 WHERE SecCode = 4385257 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794740524, ExchCode = 'LAS' WHERE SecCode = 4388200 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991740, ExchCode = 'FRA' WHERE SecCode = 4400153 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21778680491 WHERE SecCode = 4406073 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783161157, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4415732 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803077161, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 4420922 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21782664057, ExchCode = 'DEU', PermQuoteRetireDate = '2024-10-31', PermSecMapEndDate = '2024-10-31' WHERE SecCode = 4422563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775216637, ExchCode = 'TDG' WHERE SecCode = 4422567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797999209, ExchCode = 'DEU' WHERE SecCode = 4423904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307218, ExchCode = 'BIV' WHERE SecCode = 4426954 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21783652671, ExchCode = 'DEU' WHERE SecCode = 4426955 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 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 PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 4434256 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 4434385 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785087353, ExchCode = 'DEU' WHERE SecCode = 4434390 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21785453356, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01', PermSecMapEndDate = '2025-12-31' WHERE SecCode = 4436991 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830301800, ExchCode = 'GTX' WHERE SecCode = 4446128 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854730428, ExchCode = 'STU', PermQuoteRetireDate = '2023-07-31', PermSecMapEndDate = NULL WHERE SecCode = 4449703 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727299967, ExchCode = 'MEX' WHERE SecCode = 4449704 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301154, ExchCode = 'MEX' 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 = 21795367131, ExchCode = 'FRA' WHERE SecCode = 4463145 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793674463, ExchCode = 'DUS' WHERE SecCode = 4472927 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896842819, ExchCode = 'DEU', PermQuoteRetireDate = '2024-03-07' WHERE SecCode = 4478078 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991761, IsPrimaryQuote = 1, ExchCode = 'FRA' WHERE SecCode = 4484496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796645883, ExchCode = 'BER', PermQuoteRetireDate = '2025-11-05' WHERE SecCode = 4489240 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21788257872, ExchCode = 'FRA', PermQuoteRetireDate = '2023-04-25' WHERE SecCode = 4494110 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21774928119, ExchCode = 'FRA' WHERE SecCode = 4494217 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21789568662, ExchCode = 'DEU' WHERE SecCode = 4495550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727306777, ExchCode = 'BIV' WHERE SecCode = 4495563 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307046, ExchCode = 'SGO' WHERE SecCode = 4495633 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21798383553, ExchCode = 'DEU' WHERE SecCode = 4502474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409262, ExchCode = 'FRA' WHERE SecCode = 4502493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21955219315, ExchCode = 'TDG' WHERE SecCode = 4511502 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802419041, ExchCode = 'TDG', PermQuoteRetireDate = '2026-01-06' WHERE SecCode = 4511508 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21800727363, ExchCode = 'DEU' WHERE SecCode = 4513649 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780960627, ExchCode = 'STU' WHERE SecCode = 4517645 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21799910326, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4517877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21801932254, ExchCode = 'FRA' WHERE SecCode = 4522869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21851675957, ExchCode = 'STU' WHERE SecCode = 4526144 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21890670000, PermQuoteStatus = 'DC', ExchCode = 'GTX', PermQuoteRetireDate = '2025-10-27' WHERE SecCode = 4527883 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781627749, ExchCode = 'QTX' WHERE SecCode = 4527891 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802419115, ExchCode = 'TDG' WHERE SecCode = 4534797 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21803771947, ExchCode = 'DEU' WHERE SecCode = 4536359 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808935929, ExchCode = 'MUN', PermQuoteRetireDate = '2025-05-02' WHERE SecCode = 4536360 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21802587261, ExchCode = 'STU' WHERE SecCode = 4536481 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777335789, ExchCode = 'FRA' WHERE SecCode = 4539327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727301437, ExchCode = 'BIV' WHERE SecCode = 4547978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727271946, ExchCode = 'BIV' WHERE SecCode = 4549301 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727349197, ExchCode = 'MEX' WHERE SecCode = 4550708 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830274062, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 4550761 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21806535085, ExchCode = 'MUN' WHERE SecCode = 4550781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893554100, ExchCode = 'FRA' WHERE SecCode = 4554184 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21886801843, ExchCode = 'GTX' WHERE SecCode = 4557762 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21807446197, ExchCode = 'FRA', PermQuoteRetireDate = '2025-08-04', PermSecMapEndDate = '2025-08-04' WHERE SecCode = 4557926 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799305062, ExchCode = 'FRA' WHERE SecCode = 4557948 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797820641, ExchCode = 'FRA' WHERE SecCode = 4557949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21796817020, ExchCode = 'FRA' WHERE SecCode = 4563448 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835428, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 4563460 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772241118, ExchCode = 'FRA' WHERE SecCode = 4563504 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819144478, ExchCode = 'FRA' WHERE SecCode = 4565422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808950993, ExchCode = 'FRA' WHERE SecCode = 4568422 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808951005, ExchCode = 'DEU' WHERE SecCode = 4568423 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809547031, ExchCode = 'DEU' WHERE SecCode = 4568462 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21781234969, ExchCode = 'MUN' WHERE SecCode = 4570290 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151060, Ticker = '3S1E', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 4575015 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151231, Ticker = '3GME', ExchCode = 'LSE', PermQuoteRetireDate = '2024-12-16' WHERE SecCode = 4575016 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151437, PermQuoteStatus = 'AC', Ticker = '3SGE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 4575017 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21775216403, ExchCode = 'FRA', PermQuoteRetireDate = '2023-04-28' WHERE SecCode = 4576447 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811980857, ExchCode = 'MUN' WHERE SecCode = 4576474 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830286428, ExchCode = 'GTX' WHERE SecCode = 4579634 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21811991582, ExchCode = 'DEU' WHERE SecCode = 4579689 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812637185, ExchCode = 'FRA' WHERE SecCode = 4579692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874194533 WHERE SecCode = 4579789 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860615572, ExchCode = 'STU' WHERE SecCode = 4585453 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097201, ExchCode = 'LAS' WHERE SecCode = 4588270 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835172728, PermQuoteStatus = 'DC', ExchCode = 'MXQ', PermQuoteRetireDate = '2024-01-26' WHERE SecCode = 4589288 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812606578, ExchCode = 'MUN', PermQuoteRetireDate = '2021-05-18' WHERE SecCode = 4589403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380574, ExchCode = 'LAS' WHERE SecCode = 4593303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727305821, ExchCode = 'MEX' WHERE SecCode = 4597223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836865415, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4598716 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097262, ExchCode = 'LAS' WHERE SecCode = 4601728 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21999011220, Ticker = '2INVEB' WHERE SecCode = 4601877 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815149494, ExchCode = 'STU' 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 = 21815153830, ExchCode = 'FRA' WHERE SecCode = 4603534 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888036736, ExchCode = 'STU' WHERE SecCode = 4603537 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21830275562, ExchCode = 'GTX' WHERE SecCode = 4607695 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21816241209, ExchCode = 'STU' WHERE SecCode = 4607717 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21860833294, ExchCode = 'GTX' WHERE SecCode = 4608705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22138517569, ExchCode = 'BTE' WHERE SecCode = 4609997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727263611, ExchCode = 'MEX' WHERE SecCode = 4610049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045075404, ExchCode = 'LAS' WHERE SecCode = 4613099 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21786868049, ExchCode = 'MUN' WHERE SecCode = 4613105 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22007949146, ExchCode = 'DEU' WHERE SecCode = 4615939 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818133763, ExchCode = 'DEU' WHERE SecCode = 4616836 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818527622, ExchCode = 'FRA' WHERE SecCode = 4618010 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818136786, ExchCode = 'QTX' WHERE SecCode = 4618159 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819293770, ExchCode = 'TDG' WHERE SecCode = 4620160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21819968078, ExchCode = 'DEU' WHERE SecCode = 4625009 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21822364738, ExchCode = 'TDG' WHERE SecCode = 4634352 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823963642, ExchCode = 'STU' WHERE SecCode = 4635203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21823273411, ExchCode = 'STU' WHERE SecCode = 4637757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21854881328, ExchCode = 'GTX' WHERE SecCode = 4639654 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 4640316 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21859334865, ExchCode = 'FRA' WHERE SecCode = 4643318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21824689924, ExchCode = 'MUN' WHERE SecCode = 4646599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831914249, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4651786 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21848696115, ExchCode = 'GTX' WHERE SecCode = 4658662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831549319, ExchCode = 'TDG' WHERE SecCode = 4671286 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388763, ExchCode = 'LAS' WHERE SecCode = 4675215 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21832851078, ExchCode = 'DEU' WHERE SecCode = 4676228 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419029, ExchCode = 'LAS' WHERE SecCode = 4680383 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835615671, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-03' WHERE SecCode = 4682771 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835316539, ExchCode = 'STU' WHERE SecCode = 4684000 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21835314248, ExchCode = 'GTX' WHERE SecCode = 4685284 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21838659452, ExchCode = 'TDG' WHERE SecCode = 4693646 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837529343, ExchCode = 'FRA' WHERE SecCode = 4693647 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21837527952, Ticker = 'CARB', ExchCode = 'MIL' WHERE SecCode = 4693652 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933374646, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2023-01-02' WHERE SecCode = 4697438 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21840037614, ExchCode = 'TDG', PermQuoteRetireDate = '2022-01-21' WHERE SecCode = 4707187 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727233442, ExchCode = 'MEX' WHERE SecCode = 4714894 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842933521, ExchCode = 'FRA' WHERE SecCode = 4716089 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21842933962, PermQuoteStatus = 'AC', ExchCode = 'DEU', PermQuoteRetireDate = NULL WHERE SecCode = 4716090 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954835, ExchCode = 'LAS' WHERE SecCode = 4718902 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933381561, ExchCode = 'STU' WHERE SecCode = 4720517 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21843597790, ExchCode = 'FRA' WHERE SecCode = 4722188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21845531907, ExchCode = 'MUN' WHERE SecCode = 4724688 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4727653 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 4730172 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850866652, ExchCode = 'TDG' WHERE SecCode = 4733055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21850708573, ExchCode = 'MUN' WHERE SecCode = 4745391 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21852735329, ExchCode = 'FRA' WHERE SecCode = 4756369 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'MTQ' WHERE SecCode = 4759539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932244742, ExchCode = 'BCO' WHERE SecCode = 4761550 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855114065, ExchCode = 'GTX' WHERE SecCode = 4767879 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856018995, ExchCode = 'STU' WHERE SecCode = 4773769 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21855838898, ExchCode = 'QTX' WHERE SecCode = 4773770 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21856722496, ExchCode = 'MUN' WHERE SecCode = 4775201 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 4777328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857142963, ExchCode = 'STU' WHERE SecCode = 4781733 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857609571, ExchCode = 'MUN' WHERE SecCode = 4782126 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21857898826, ExchCode = 'FRA' WHERE SecCode = 4784525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800097247, ExchCode = 'LAS' WHERE SecCode = 4786541 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21921513349, Ticker = 'A6I', ExchCode = 'QTX' WHERE SecCode = 4792475 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 4804602 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22161390154, Ticker = 'CON3l', ExchCode = 'CHI' WHERE SecCode = 4806678 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907559014, ExchCode = 'MUN', PermQuoteRetireDate = '2026-02-11' WHERE SecCode = 4811141 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21772241331, ExchCode = 'FRA' WHERE SecCode = 4815315 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863192887, ExchCode = 'DEU' WHERE SecCode = 4815349 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21862998607, ExchCode = 'QTX' WHERE SecCode = 4818264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781684618, ExchCode = 'DUS' WHERE SecCode = 4818275 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21866164599, ExchCode = 'STU' WHERE SecCode = 4827931 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888954019, ExchCode = 'MUN', PermQuoteRetireDate = '2022-08-19', PermSecMapEndDate = NULL WHERE SecCode = 4845029 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871055968, ExchCode = 'GTX' WHERE SecCode = 4845045 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380530, ExchCode = 'LAS' WHERE SecCode = 4847006 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580567, ExchCode = 'DEU' WHERE SecCode = 4850978 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 4850979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872098103, ExchCode = 'DEU' WHERE SecCode = 4857302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871894898, ExchCode = 'DEU' WHERE SecCode = 4868662 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21872584687, ExchCode = 'FRA' WHERE SecCode = 4873679 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874648333, Ticker = '9XK', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4873803 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799954831, ExchCode = 'LAS' WHERE SecCode = 4887246 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21929410708, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874656927, ExchCode = 'FRA' WHERE SecCode = 4889264 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727204792, ExchCode = 'MEX' WHERE SecCode = 4914666 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882010751, ExchCode = 'DEU' WHERE SecCode = 4934324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882166752, PermQuoteStatus = 'DC', Ticker = 'Y23', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 4934325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881998635, ExchCode = 'STU', PermQuoteRetireDate = '2022-03-25', PermSecMapEndDate = '2022-03-25' WHERE SecCode = 4934327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380552, ExchCode = 'LAS' WHERE SecCode = 4940672 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 4943224 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778071474, PermQuoteStatus = 'AC', Ticker = '62U2', ExchCode = 'MUN', PermQuoteRetireDate = NULL WHERE SecCode = 4943250 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884189014, ExchCode = 'QTX', PermQuoteRetireDate = '2024-08-15' WHERE SecCode = 4943410 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21884460465, ExchCode = 'MUN' WHERE SecCode = 4946106 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21885689459, ExchCode = 'DEU' WHERE SecCode = 4959593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21975240638, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2025-01-06' WHERE SecCode = 4969407 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21888705427, ExchCode = 'MUN' WHERE SecCode = 4973331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799419078, ExchCode = 'LAS' WHERE SecCode = 4973332 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21889560981, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 4980098 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727212161, ExchCode = 'BIV' WHERE SecCode = 4980103 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953147, ExchCode = 'DEU' WHERE SecCode = 5002370 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21892953078, ExchCode = 'FRA' WHERE SecCode = 5002372 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22072401492, ExchCode = 'DEU' WHERE SecCode = 5009346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21907308927, ExchCode = 'DUS' WHERE SecCode = 5020949 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174654874, ExchCode = 'DEU' WHERE SecCode = 5031899 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823918, ExchCode = 'AQX' WHERE SecCode = 5038692 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238786, ExchCode = 'LAS' WHERE SecCode = 5067500 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21904445286, ExchCode = 'QTX' WHERE SecCode = 5072163 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076711, ExchCode = 'LAS' WHERE SecCode = 5072165 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380635, ExchCode = 'LAS' WHERE SecCode = 5082547 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779601759, ExchCode = 'STU' WHERE SecCode = 5091022 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21910179774, ExchCode = 'QTX' WHERE SecCode = 5094355 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21913716500, ExchCode = 'FRA' WHERE SecCode = 5107775 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21911875317, ExchCode = 'MUN', PermQuoteRetireDate = '2023-10-27', PermSecMapEndDate = '2023-10-27' WHERE SecCode = 5112411 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951920.0 WHERE SecCode = 5121835 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5122869 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21912123776, ExchCode = 'DEU' WHERE SecCode = 5130680 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951920.0 WHERE SecCode = 5132731 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 PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5145485 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21752682691, ExchCode = 'FRA' WHERE SecCode = 5161303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727308116, ExchCode = 'SIG' WHERE SecCode = 5161346 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727248292, ExchCode = 'MEX' WHERE SecCode = 5161356 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727344850, ExchCode = 'MEX' WHERE SecCode = 5161363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521369386, ExchCode = 'SGO' WHERE SecCode = 5161394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21667488565, ExchCode = 'QTX' WHERE SecCode = 5161404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727348365, ExchCode = 'BIV' WHERE SecCode = 5161413 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381527, ExchCode = 'LAS' WHERE SecCode = 5161439 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21893559951, Ticker = 'AZPN1*', ExchCode = 'MXQ' WHERE SecCode = 5161449 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21871079564, ExchCode = 'MXQ' WHERE SecCode = 5161453 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 5162445 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 5166572 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21920795450, ExchCode = 'AUX' WHERE SecCode = 5168048 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-22', PermSecMapEndDate = '2023-05-11' WHERE SecCode = 5168280 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173437, ExchCode = 'MEX' WHERE SecCode = 5168285 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21943651732, ExchCode = 'STU' WHERE SecCode = 5174473 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21950535364, ExchCode = 'MUN' WHERE SecCode = 5203361 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21928371762, ExchCode = 'MUN' WHERE SecCode = 5218830 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 5227171 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22140088087, ExchCode = 'HAM' WHERE SecCode = 5229902 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'ZAF' WHERE SecCode = 5230202 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388873, ExchCode = 'LAS' WHERE SecCode = 5230333 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793845610, PermQuoteStatus = 'DC', ExchCode = 'TDG', PermQuoteRetireDate = '2025-08-26' WHERE SecCode = 5239813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173431, ExchCode = 'BIV' WHERE SecCode = 5241334 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21948492664, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL WHERE SecCode = 5253710 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784387487, ExchCode = 'LAS' WHERE SecCode = 5258620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21935253947, ExchCode = 'STU' WHERE SecCode = 5260620 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236775222346, ExchCode = 'BIV' WHERE SecCode = 5267090 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 5292495 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21956341568, ExchCode = 'HAN' WHERE SecCode = 5292722 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727198673, ExchCode = 'BIV' WHERE SecCode = 5301207 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802775547, ExchCode = 'FRA' WHERE SecCode = 5310445 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781581879, ExchCode = 'QTX' WHERE SecCode = 5338742 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784388897, ExchCode = 'LAS' WHERE SecCode = 5341321 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789864381, ExchCode = 'TDG' WHERE SecCode = 5343623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21853633707, ExchCode = 'DEU' WHERE SecCode = 5347222 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21952265408, ExchCode = 'DEU' WHERE SecCode = 5347429 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784381676, ExchCode = 'LAS' WHERE SecCode = 5374858 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803907172, ExchCode = 'QTX' WHERE SecCode = 5379104 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5380514 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784380716, ExchCode = 'LAS' WHERE SecCode = 5383335 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21959716837, ExchCode = 'FRA' WHERE SecCode = 5383598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21961201424, ExchCode = 'FRA' WHERE SecCode = 5388847 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777874394, ExchCode = 'GTX' WHERE SecCode = 5403440 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21812179638, ExchCode = 'DEU' WHERE SecCode = 5410114 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22045076773, ExchCode = 'LAS', PermQuoteRetireDate = '2024-12-16', PermSecMapEndDate = '2024-12-16' WHERE SecCode = 5434319 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21991218437, ExchCode = 'BER' WHERE SecCode = 5434328 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727171626, ExchCode = 'MEX' WHERE SecCode = 5443497 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5446095 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5448867 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21726334950, ExchCode = 'DEU' WHERE SecCode = 5466446 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727193595, ExchCode = 'BIV' WHERE SecCode = 5474598 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21978145461, ExchCode = 'DEU' WHERE SecCode = 5474599 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21818729656, ExchCode = 'DEU' WHERE SecCode = 5478214 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223819, ExchCode = 'QTX' WHERE SecCode = 5479512 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778437244, ExchCode = 'BIV' WHERE SecCode = 5482856 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778585123, ExchCode = 'MEX' WHERE SecCode = 5493568 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792893349, ExchCode = 'TDG' WHERE SecCode = 5493665 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778659888, ExchCode = 'BIV' WHERE SecCode = 5496143 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932421406, PermQuoteStatus = 'AC', Ticker = '3LFBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5496168 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982260691, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 5496242 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21982274729, Ticker = '3BAS', ExchCode = 'MIL' WHERE SecCode = 5496244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727277713, ExchCode = 'MEX' WHERE SecCode = 5503675 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151593, PermQuoteStatus = 'AC', Ticker = '3LNE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503687 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21793394120, PermQuoteStatus = 'DC', Ticker = '1L8', ExchCode = 'TDG', PermQuoteRetireDate = '2022-02-01' WHERE SecCode = 5503701 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780026804, Ticker = '1TUI1U' WHERE SecCode = 5503702 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21809151100, PermQuoteStatus = 'AC', Ticker = '3LUE', ExchCode = 'LSE', PermQuoteRetireDate = NULL WHERE SecCode = 5503714 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898176, PermQuoteStatus = 'AC', Ticker = '3LUBm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503715 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21932898195, PermQuoteStatus = 'AC', Ticker = '3SAPm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5503720 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917835157, Ticker = NULL, PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5503776 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580254, ExchCode = 'FRA' WHERE SecCode = 5503779 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21906823945, ExchCode = 'AQE' WHERE SecCode = 5503780 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580225, ExchCode = 'GER' WHERE SecCode = 5503781 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21874663720, ExchCode = 'AQE' WHERE SecCode = 5503782 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776471889, ExchCode = 'BIV' WHERE SecCode = 5503860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309751, Ticker = '3LPA', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5503872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099128275, ExchCode = 'BCO' WHERE SecCode = 5503898 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22085810217, ExchCode = 'BTE' WHERE SecCode = 5503900 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21861198674, Ticker = 'ARK3', ExchCode = 'LSE' WHERE SecCode = 5503901 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21836309769, Ticker = '3LMO', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5506501 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778891290, ExchCode = 'FRA' WHERE SecCode = 5507430 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 5521904 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779309034, ExchCode = 'MUN' WHERE SecCode = 5527560 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21988984185, ExchCode = 'DEU' WHERE SecCode = 5527561 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21970293156, ExchCode = 'MUN' WHERE SecCode = 5533519 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781569891, PermQuoteStatus = 'DC', ExchCode = 'QTX', PermQuoteRetireDate = '2025-12-10' WHERE SecCode = 5533603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21831436884, Ticker = 'SFTG', ExchCode = 'PAR', PermQuoteRetireDate = '2024-10-28' WHERE SecCode = 5534997 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110956, Ticker = 'SFTGm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-05-05' WHERE SecCode = 5534998 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110937, Ticker = '3SFTm', ExchCode = 'BCO', PermQuoteRetireDate = '2025-04-29' WHERE SecCode = 5535008 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21992342600, ExchCode = 'DEU' WHERE SecCode = 5550738 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21992894231, ExchCode = 'DEU' WHERE SecCode = 5551977 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21777335739, ExchCode = 'DEU' WHERE SecCode = 5553183 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777584029, ExchCode = 'MEX' WHERE SecCode = 5558570 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 5563526 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917834791, PermQuoteStatus = 'DC', Ticker = NULL, ExchCode = 'EQD', PermQuoteRetireDate = '2024-09-23' WHERE SecCode = 5569213 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 5569226 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 5569227 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21881554208, ExchCode = 'GTX' WHERE SecCode = 5569235 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21933110941, PermQuoteStatus = 'AC', Ticker = '3FNGm', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 5569243 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21896580283, ExchCode = 'DUS' WHERE SecCode = 5569302 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917830166, ExchCode = 'DEU', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5569303 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21591864463, ExchCode = 'STU', PermQuoteRetireDate = '2020-09-14' WHERE SecCode = 5569318 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21873360059, Ticker = '3MRN', ExchCode = 'MIL' WHERE SecCode = 5569367 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236778760132, ExchCode = 'MEX' WHERE SecCode = 5569424 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951806.0 WHERE SecCode = 5569943 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779927384, ExchCode = 'MEX' WHERE SecCode = 5574878 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21997738310, ExchCode = 'DEU' WHERE SecCode = 5577509 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 5579581 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 5579582 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780193394, ExchCode = 'FRA', PermQuoteRetireDate = '2023-11-30' WHERE SecCode = 5601088 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236780515980, ExchCode = 'FRA' WHERE SecCode = 5607542 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21815640610, ExchCode = 'SWX' WHERE SecCode = 5614653 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781060455, ExchCode = 'STU' WHERE SecCode = 5616156 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794769105, ExchCode = 'LAS' WHERE SecCode = 5623203 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779309551, ExchCode = 'MEX' WHERE SecCode = 5626507 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727173436, ExchCode = 'MEX' WHERE SecCode = 5628244 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781095333, ExchCode = 'STU' WHERE SecCode = 5633895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21923117428, Ticker = 'LCO3', ExchCode = 'LSE' WHERE SecCode = 5638747 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21595966732, ExchCode = 'TDG', PermQuoteRetireDate = '2020-01-23' WHERE SecCode = 5638827 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848440, ExchCode = 'QTX', PermQuoteRetireDate = '2024-11-18' WHERE SecCode = 5638860 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21917848459, PermQuoteStatus = 'AC', ExchCode = 'QTX', PermQuoteRetireDate = NULL WHERE SecCode = 5638862 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21882433442, ExchCode = 'SWX' WHERE SecCode = 5645885 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727307755, ExchCode = 'MEX' WHERE SecCode = 5658305 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236781343894, ExchCode = 'TDG' WHERE SecCode = 5663580 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782223838, ExchCode = 'QTX' WHERE SecCode = 5663968 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727197816, ExchCode = 'BIV' WHERE SecCode = 5668406 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21863949567 WHERE SecCode = 5674188 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22021922875, ExchCode = 'DEU' WHERE SecCode = 5687951 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5710743 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22027362169, ExchCode = 'STU' WHERE SecCode = 5715993 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22028682766, Ticker = '2HENS' WHERE SecCode = 5720895 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779601760, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5727660 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782758334, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 5740527 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782871477, ExchCode = 'STU' WHERE SecCode = 5745665 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 = 21937290553, ExchCode = 'FRA' WHERE SecCode = 5749952 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782954307, ExchCode = 'FRA' WHERE SecCode = 5749956 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801851316, PermQuoteStatus = 'AC', ExchCode = 'LAS', PermQuoteRetireDate = NULL WHERE SecCode = 5782813 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22136364064, ExchCode = 'CHI' WHERE SecCode = 5782854 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22040670142, ExchCode = 'GTX' WHERE SecCode = 5785805 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037308993, ExchCode = 'DEU' WHERE SecCode = 5786123 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22037302983, ExchCode = 'DEU' WHERE SecCode = 5786125 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783782319, ExchCode = 'STU' WHERE SecCode = 5786132 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236783963980, ExchCode = 'STU' WHERE SecCode = 5786133 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785534609, ExchCode = 'QTX' WHERE SecCode = 5786134 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5787496 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784438281, ExchCode = 'STU' WHERE SecCode = 5827593 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784421384, ExchCode = 'MEX' WHERE SecCode = 5834725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22031122900, Ticker = 'CO3Sl', ExchCode = 'BCO' WHERE SecCode = 5839249 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601266, ExchCode = 'FRA' WHERE SecCode = 5842621 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601265, ExchCode = 'FRA' WHERE SecCode = 5842622 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784601263, ExchCode = 'FRA' WHERE SecCode = 5842623 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236786494467, ExchCode = 'GTX' WHERE SecCode = 5871394 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236776416443, ExchCode = 'MEX' WHERE SecCode = 5888377 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236785943776, ExchCode = 'FRA' WHERE SecCode = 5907872 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236784888212, ExchCode = 'MEX' WHERE SecCode = 5907884 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 5951011 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21951582651, ExchCode = 'MXQ' WHERE SecCode = 5958705 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 5974244 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951834.0 WHERE SecCode = 6012712 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22070354815, ExchCode = 'DEU' WHERE SecCode = 6012971 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795664148, ExchCode = 'MEX' WHERE SecCode = 6014420 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805993483, Ticker = 'KOTIC', ExchCode = 'NSI' WHERE SecCode = 6069601 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21521370126, ExchCode = 'BEC' WHERE SecCode = 6097304 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 = 21780909373, ExchCode = 'FRA' WHERE SecCode = 6097404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21797409290, PermQuoteStatus = 'AC', ExchCode = 'FRA', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6097431 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236779005194, PermQuoteStatus = 'AC', Ticker = '5VF', ExchCode = 'FRA', PermQuoteRetireDate = NULL WHERE SecCode = 6097454 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777911611, ExchCode = 'MEX' WHERE SecCode = 6097467 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22086901855, ExchCode = 'GTX' WHERE SecCode = 6104636 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6177642 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6177643 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791141240, ExchCode = 'TDG' WHERE SecCode = 6190705 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792959667, ExchCode = 'STU' WHERE SecCode = 6204567 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22099147227, ExchCode = 'DEU' WHERE SecCode = 6232440 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 6232441 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236791838443, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6258489 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796404945, ExchCode = 'STU' WHERE SecCode = 6285539 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236792988435, ExchCode = 'GTX' WHERE SecCode = 6310651 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172912563, ExchCode = 'SWX' WHERE SecCode = 6324051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793393667, ExchCode = 'STU' WHERE SecCode = 6334403 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236793349913, ExchCode = 'MUN' WHERE SecCode = 6334404 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794559562, ExchCode = 'GTX' WHERE SecCode = 6334406 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 6336211 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794499501, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL WHERE SecCode = 6347434 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21808950961, ExchCode = 'DEU' WHERE SecCode = 6364834 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236789866541, ExchCode = 'MEX' WHERE SecCode = 6375353 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 21973297712, ExchCode = 'BIV' WHERE SecCode = 6398458 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236794459345, ExchCode = 'FRA' WHERE SecCode = 6407331 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236795695820, ExchCode = 'TDG' WHERE SecCode = 6443223 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798509196, ExchCode = 'MUN' WHERE SecCode = 6445725 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802152101, ExchCode = 'TDG' WHERE SecCode = 6445726 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142096843, ExchCode = 'SWX' WHERE SecCode = 6453964 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22142451440, ExchCode = 'BCO' WHERE SecCode = 6457882 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22128281486, ExchCode = 'QTX' WHERE SecCode = 6457998 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6469386 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796467110, ExchCode = 'CHA' WHERE SecCode = 6480251 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796466550, ExchCode = 'STU' WHERE SecCode = 6480271 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236782109019, ExchCode = 'TDG' WHERE SecCode = 6480272 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796439132, ExchCode = 'BIV' WHERE SecCode = 6480273 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796466898, ExchCode = 'FRA' WHERE SecCode = 6480274 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131277091, ExchCode = 'DEU' WHERE SecCode = 6480324 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22131288389, ExchCode = 'DEU' WHERE SecCode = 6480325 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796521732, ExchCode = 'TDG' WHERE SecCode = 6480326 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236796468070, ExchCode = 'DUS' WHERE SecCode = 6480327 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236797031043, ExchCode = 'MEX' WHERE SecCode = 6497499 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 = 236798202984, ExchCode = 'MUN' WHERE SecCode = 6522492 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798109633, ExchCode = 'QTX' WHERE SecCode = 6522493 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798598065, ExchCode = 'FRA' WHERE SecCode = 6541040 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236798948296, ExchCode = 'FRA' WHERE SecCode = 6554915 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6569470 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727346662, Ticker = '0QF', ExchCode = 'BRN' WHERE SecCode = 6578363 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 25727315149, Ticker = '5Q5', ExchCode = 'BRN' WHERE SecCode = 6578368 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236799957422, ExchCode = 'DUS' WHERE SecCode = 6584681 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238834, ExchCode = 'QTX' WHERE SecCode = 6587160 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800238832, ExchCode = 'QTX' WHERE SecCode = 6587161 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800270185, ExchCode = 'DUS' WHERE SecCode = 6590614 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6590676 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6590677 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6590956 AND Type_ = 10;
UPDATE data_universe_permid SET DomCntry = 'CHN' WHERE SecCode = 6590957 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800709238, ExchCode = 'QTX' WHERE SecCode = 6596130 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236800660438, ExchCode = 'DUS' WHERE SecCode = 6596132 AND Type_ = 10;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 6622353 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951834.0 WHERE SecCode = 6628671 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236801833041, ExchCode = 'BIV' WHERE SecCode = 6628690 AND Type_ = 10;
UPDATE data_universe_permid SET PermOrgIPODate = '2026-01-26' WHERE SecCode = 6629206 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236802226958, ExchCode = 'FRA' WHERE SecCode = 6635226 AND Type_ = 10;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 6643259 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22011191250, ExchCode = 'SGO' WHERE SecCode = 6678589 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803403433, ExchCode = 'FRA' WHERE SecCode = 6691979 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803604760, ExchCode = 'FRA' WHERE SecCode = 6692049 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803604762, ExchCode = 'FRA' WHERE SecCode = 6692050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803604763, ExchCode = 'FRA' WHERE SecCode = 6692051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236803716655, ExchCode = 'FRA' WHERE SecCode = 6694389 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22165234298, ExchCode = 'GTX' WHERE SecCode = 6710093 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804168533, ExchCode = 'STU' WHERE SecCode = 6724297 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236790866059, ExchCode = 'LAS' WHERE SecCode = 6728400 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804826537, ExchCode = 'FRA' WHERE SecCode = 6741050 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804838755, ExchCode = 'FRA' WHERE SecCode = 6741051 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804838757, ExchCode = 'FRA' WHERE SecCode = 6741052 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804838739, ExchCode = 'FRA' WHERE SecCode = 6741053 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236804838759, ExchCode = 'FRA' WHERE SecCode = 6741055 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236777699531, ExchCode = 'BIV' WHERE SecCode = 6755754 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170324839, ExchCode = 'DEU' WHERE SecCode = 6755756 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170325761, ExchCode = 'DEU' WHERE SecCode = 6755757 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22170325818, ExchCode = 'DEU' WHERE SecCode = 6755758 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805613170, ExchCode = 'FRA' WHERE SecCode = 6779510 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22172748632, ExchCode = 'DEU' WHERE SecCode = 6779525 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805705305, ExchCode = 'FRA' WHERE SecCode = 6782676 AND Type_ = 10;
UPDATE data_universe_permid SET IsPrimaryQuote = 1 WHERE SecCode = 6789603 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 236805901665, ExchCode = 'FRA' WHERE SecCode = 6793382 AND Type_ = 10;
UPDATE data_universe_permid SET QuotePermID = 22174126941, ExchCode = 'DEU' WHERE SecCode = 6793389 AND Type_ = 10;
UPDATE data_universe_permid SET PermInstrStatus = 'DC' WHERE SecCode = 10771857 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10811185 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'GGY' WHERE SecCode = 10893375 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'HKG' WHERE SecCode = 10894382 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-21' WHERE SecCode = 10906610 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CYM' WHERE SecCode = 10908159 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe_permid SET DomCntry = 'CAN' WHERE SecCode = 11027738 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'USA' WHERE SecCode = 11037093 AND Type_ = 1;
UPDATE data_universe_permid SET PriInstrPermID = 8590021898.0 WHERE SecCode = 11052831 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951962.0 WHERE SecCode = 11054827 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 11056198 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 11056475 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11065371 AND Type_ = 1;
UPDATE data_universe_permid SET IncCntry = 'CAN' WHERE SecCode = 11072320 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951648.0 WHERE SecCode = 11148393 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'LYXX' WHERE SecCode = 11149414 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'AGNPD', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11156632 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11161916 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = 'BRLL' WHERE SecCode = 11173258 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11177805 AND Type_ = 1;
UPDATE data_universe_permid SET PriTrdQuotePermID = NULL, PermQuoteStatus = 'DC', Ticker = NULL, PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11195911 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11200032 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951648.0 WHERE SecCode = 11205487 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951749.0 WHERE SecCode = 11211799 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11213058 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 11219283 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 11224447 AND Type_ = 1;
UPDATE data_universe_permid SET Ticker = NULL, PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 11243696 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 11245399 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11248163 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11258156 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11267015 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 11270728 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapStartDate = '2026-04-21', PermSecMapEndDate = NULL WHERE SecCode = 11276190 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = '2025-05-09' WHERE SecCode = 11278158 AND Type_ = 1;
UPDATE data_universe_permid SET PermSecMapEndDate = NULL WHERE SecCode = 11281132 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290799 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290801 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290803 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290804 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290806 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290807 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290808 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290809 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290810 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290811 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290812 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11290882 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 11290884 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 11290885 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 11290886 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 11290887 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteRetireDate = '2026-04-22' WHERE SecCode = 11290888 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', Ticker = NULL, PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11292575 AND Type_ = 1;
UPDATE data_universe_permid SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-04-21', PermSecMapEndDate = '2026-04-21' WHERE SecCode = 11293445 AND Type_ = 1;
UPDATE data_universe_permid SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 11293777 AND Type_ = 1;
UPDATE data_universe_permid SET PermOrgIPODate = NULL WHERE SecCode = 11294620 AND Type_ = 1;