UPDATE data_universe SET QuotePermID = 21475610141.0, ExchCode = 'NMQ', PermSecMapStartDate = '1996-07-06', PermSecMapEndDate = '2002-07-19', endDate = '2002-07-19' WHERE SecCode = 1733 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1987-02-26' WHERE SecCode = 2344 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 46660756687.0, ExchCode = 'IEX' WHERE SecCode = 2407 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '2002-09-06' WHERE SecCode = 3844 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3885 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'EG5', QuotePermID = 21475530610.0, ExchCode = 'PLU', PermQuoteRetireDate = '2009-01-05', endDate = '2009-01-05' WHERE SecCode = 4613 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-25' WHERE SecCode = 4882 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5054 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1973-01-02' WHERE SecCode = 5119 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475463071.0, IsPrimaryQuote = 0.0, ExchCode = 'TOR', PermQuoteRetireDate = '2000-11-16', PermSecMapStartDate = '1994-05-27', PermSecMapEndDate = '2000-11-16' WHERE SecCode = 5368 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'HNT', QuotePermID = 21475560651.0, IsPrimaryQuote = 0.0, ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05', PermSecMapStartDate = '1999-09-06', endDate = '2008-12-05' WHERE SecCode = 6198 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 6419 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = 'GBR' WHERE SecCode = 6877 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2018-11-21' WHERE SecCode = 6882 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 6946 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '2000-06-14' WHERE SecCode = 7700 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475191525.0, IsPrimaryQuote = 0.0, PermQuoteRetireDate = '2002-09-02', PermSecMapStartDate = '2001-07-06', PermSecMapEndDate = '2002-09-02' WHERE SecCode = 7873 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2007-09-27' WHERE SecCode = 8097 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475322263.0, InstrPermID = 21475322253.0, OrgPermID = 4295909141.0, PriValQuotePermID = 21475322263.0, PriInstrPermID = 21475322253.0, PermQuoteRetireDate = '2005-03-02', PermSecMapStartDate = '2002-11-04', PermSecMapEndDate = '2005-03-02' WHERE SecCode = 8419 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475187328.0, InstrPermID = 8590015558.0, OrgPermID = 4295893894.0, PriValQuotePermID = 21475187328.0, PriInstrPermID = NULL, IsPrimaryInstr = 0.0, PermInstrStatus = 'DC', PriTRBCIndPermID = NULL, PermQuoteRetireDate = '1995-12-15' WHERE SecCode = 8628 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55845639155.0, IsPrimaryQuote = 0.0, ExchCode = 'BAT', PermQuoteRetireDate = '2024-09-19' WHERE SecCode = 8807 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '1994-05-09' WHERE SecCode = 9046 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475086058.0, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13', endDate = '2014-01-13' WHERE SecCode = 10135 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475191955.0, InstrPermID = 21475191954.0, OrgPermID = 4295884920.0, PriValQuotePermID = 21475191955.0, PriInstrPermID = 8590937788.0, PriTRBCIndPermID = 4294951362.0, PermQuoteRetireDate = '1996-08-15', PermSecMapStartDate = '1994-05-12', PermSecMapEndDate = '1996-08-15', endDate = '1996-08-15' WHERE SecCode = 10230 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '1995-11-24' WHERE SecCode = 10739 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2007-01-02', PermSecMapEndDate = '2023-09-23' WHERE SecCode = 11425 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '1997-05-09' WHERE SecCode = 11857 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = 'GBR' WHERE SecCode = 11996 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = 'GBR' WHERE SecCode = 12079 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2006-04-01', startDate = '2004-03-19' WHERE SecCode = 12199 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2013-11-06' WHERE SecCode = 12200 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475324002.0, IsPrimaryQuote = 0.0, PermQuoteRetireDate = '2002-09-18', PermSecMapStartDate = '2000-01-31', PermSecMapEndDate = '2002-09-18' WHERE SecCode = 12326 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475193285.0, InstrPermID = 8590018143.0, OrgPermID = 4295909365.0, PriTrdQuotePermID = NULL, PriValQuotePermID = 21475193285.0, PriInstrPermID = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', QuoteClass = 'ORD', InstrClass = 'ORD', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951833.0, PermQuoteRetireDate = '1997-11-07', PermOrgIPODate = NULL WHERE SecCode = 13028 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '2000-06-07' WHERE SecCode = 13375 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838321093.0, IsPrimaryQuote = 0.0, ExchCode = 'NYS', PermSecMapStartDate = '1997-07-26', PermSecMapEndDate = '2011-01-15' WHERE SecCode = 15982 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2005-05-03' WHERE SecCode = 17279 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475433463.0, IsPrimaryQuote = 0.0, ExchCode = 'CVE', PermQuoteRetireDate = '2002-06-06', PermSecMapStartDate = '1996-11-06', PermSecMapEndDate = '2002-06-06', startDate = '1996-11-06' WHERE SecCode = 18292 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475174888.0, InstrPermID = 8590929744.0, OrgPermID = 4295913119.0, PriValQuotePermID = 21475174891.0, PriInstrPermID = NULL, IsPrimaryQuote = 0.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'OBB', PriTRBCIndPermID = 4294951791.0, PermQuoteRetireDate = '2001-10-03', PermOrgIPODate = NULL, PermSecMapStartDate = '1753-01-01', PermSecMapEndDate = '2001-10-03', startDate = '1753-01-01' WHERE SecCode = 18961 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '1998-05-08' WHERE SecCode = 19566 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2006-05-24' WHERE SecCode = 21136 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-09-29', PermSecMapEndDate = '2004-11-30' WHERE SecCode = 22428 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2005-11-15' WHERE SecCode = 23802 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2005-10-10' WHERE SecCode = 24035 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2005-05-05' WHERE SecCode = 24404 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55839893177.0, InstrPermID = 46642911462.0, PriValQuotePermID = 55839893177.0, PermQuoteRetireDate = '2006-06-29', PermSecMapStartDate = '2005-06-09', PermSecMapEndDate = '2006-06-29', endDate = '2006-06-16' WHERE SecCode = 25364 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '1993-05-03', endDate = '1995-01-31' WHERE SecCode = 26040 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-05-09' WHERE SecCode = 26212 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 26306 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-16' WHERE SecCode = 26985 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2005-04-06' WHERE SecCode = 27118 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 27293 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'REBRISA-B', QuotePermID = 55838849012.0, InstrPermID = 8589946763.0, PriValQuotePermID = 55838849012.0, IsPrimaryInstr = 0.0, PermSecMapStartDate = '2004-12-08', PermSecMapEndDate = NULL, startDate = '1999-04-09', endDate = NULL WHERE SecCode = 27616 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55838805423.0, InstrPermID = 8589999922.0, PriValQuotePermID = 55838805423.0, IsPrimaryInstr = 0.0, PermQuoteRetireDate = '2006-01-06', PermSecMapStartDate = '2001-08-30', PermSecMapEndDate = '2006-01-07' WHERE SecCode = 27870 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-06-06' WHERE SecCode = 28058 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1992-03-02' WHERE SecCode = 28163 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-05-01', startDate = '1992-11-18' WHERE SecCode = 28284 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'UNK', IncCntry = 'GBR' WHERE SecCode = 28416 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2006-03-16' WHERE SecCode = 28515 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2005-05-04' WHERE SecCode = 28529 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 28639 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1992-03-04' WHERE SecCode = 29592 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '1993-01-04', endDate = '1994-07-04' WHERE SecCode = 29802 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-10-24' WHERE SecCode = 29836 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-23' WHERE SecCode = 30013 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475191869.0, InstrPermID = 8589990330.0, OrgPermID = 4295884376.0, PriValQuotePermID = 21475191869.0, PriInstrPermID = 8590937799.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PriTRBCIndPermID = 4294951385.0, PermQuoteRetireDate = '2002-09-09', PermOrgIPODate = '1991-12-10', PermSecMapStartDate = '1998-05-23', PermSecMapEndDate = '2002-09-09', startDate = '1993-12-14', endDate = '2002-06-11' WHERE SecCode = 30034 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-08-10', PermQuoteRetireDate = '2026-09-28', PermSecMapEndDate = '2026-09-28', endDate = '2026-08-10' WHERE SecCode = 30432 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-09-07' WHERE SecCode = 31053 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2018-04-11', startDate = '1993-07-01' WHERE SecCode = 31496 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 32492 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2010-01-27' WHERE SecCode = 33033 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-29' WHERE SecCode = 34106 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-08-28' WHERE SecCode = 34192 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 34267 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-16' WHERE SecCode = 35750 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2006-07-18' WHERE SecCode = 35935 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ILHd', QuotePermID = 21475801120.0, IsPrimaryQuote = 0.0, ExchCode = 'SIG', PermQuoteRetireDate = '2013-06-20', PermSecMapStartDate = '2000-09-05', PermSecMapEndDate = '2013-06-18' WHERE SecCode = 35941 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2006-07-18' WHERE SecCode = 36013 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 46660755208.0, ExchCode = 'BAT' WHERE SecCode = 36046 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2022-02-18', PermSecMapEndDate = '2024-04-08' WHERE SecCode = 36147 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-26' WHERE SecCode = 36168 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-10-09', PermSecMapEndDate = '2024-10-10' WHERE SecCode = 36484 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2005-07-01' WHERE SecCode = 36617 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 36687 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 36740 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475338025.0, InstrPermID = 8590016599.0, OrgPermID = 4295867048.0, PriValQuotePermID = 55835446948.0, PriInstrPermID = NULL, IsPrimaryInstr = 0.0, PermInstrStatus = 'DC', PriTRBCIndPermID = 4294951386.0, PermQuoteRetireDate = '2003-02-26', PermOrgIPODate = NULL, PermSecMapStartDate = '2002-07-12', PermSecMapEndDate = '2003-02-26', endDate = '2002-12-19' WHERE SecCode = 36785 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55839186805.0, IsPrimaryQuote = 0.0, ExchCode = 'NMQ', PermSecMapStartDate = '2011-04-14', PermSecMapEndDate = '2011-09-12', endDate = '2011-09-12' WHERE SecCode = 37377 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2001-06-08' WHERE SecCode = 37953 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 44643695678.0, ExchCode = 'BAT' WHERE SecCode = 37977 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2019-11-01' WHERE SecCode = 38044 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2017-01-06' WHERE SecCode = 38429 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2016-09-06' WHERE SecCode = 38621 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475699181.0, InstrPermID = 8590024250.0, OrgPermID = 4295889862.0, PriValQuotePermID = 21475699178.0, PriInstrPermID = 8590024250.0, IsPrimaryQuote = 0.0, PriTRBCIndPermID = 4294951856.0, PermQuoteRetireDate = '2001-02-19', PermSecMapEndDate = '2001-02-19', endDate = '2001-02-16' WHERE SecCode = 39154 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 39158 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 39379 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2023-08-03' WHERE SecCode = 39502 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '1988-03-25', endDate = '2000-09-27' WHERE SecCode = 39542 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475360132.0, ExchCode = 'DUS' WHERE SecCode = 39970 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LBLKF', QuotePermID = 55835393134.0, IsPrimaryQuote = 0.0, ExchCode = 'PNK', PermQuoteRetireDate = '2011-04-20', PermSecMapStartDate = '2004-05-01', PermSecMapEndDate = '2011-04-20' WHERE SecCode = 40042 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2019-06-28' WHERE SecCode = 40169 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475187287.0, IsPrimaryQuote = 0.0, ExchCode = 'BER', PermQuoteRetireDate = '2001-09-24', PermSecMapStartDate = '1753-01-01', PermSecMapEndDate = '1995-03-24', startDate = '1753-01-01', endDate = '1995-03-24' WHERE SecCode = 40216 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 40526 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXFGD26' WHERE SecCode = 41460 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 41869 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836330572.0, IsPrimaryQuote = 0.0, ExchCode = 'BER', PermQuoteRetireDate = '2017-08-01', PermSecMapStartDate = '1990-03-30', PermSecMapEndDate = '2017-08-01', startDate = '1990-03-30' WHERE SecCode = 41892 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2016-12-08', PermSecMapEndDate = '2025-05-07', startDate = '2016-12-08' WHERE SecCode = 42619 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-04-02', PermSecMapEndDate = '2026-07-06' WHERE SecCode = 43039 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '1993-09-27' WHERE SecCode = 43285 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-08-03' WHERE SecCode = 44481 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-04-02' WHERE SecCode = 44550 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '2001-06-21' WHERE SecCode = 45097 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-03-02' WHERE SecCode = 45280 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '2001-10-22' WHERE SecCode = 45473 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RKKK', QuotePermID = 21475081838.0, ExchCode = 'XIM', PermQuoteRetireDate = '2013-12-14', endDate = '2013-12-14' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868.0, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 46121 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55839467132.0, InstrPermID = 15629240704.0, OrgPermID = 8589934248.0, PriTrdQuotePermID = NULL, PriValQuotePermID = 55839467132.0, PriInstrPermID = 8590920653.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', QuoteClass = 'PRF', InstrClass = 'PRF', PriTRBCIndPermID = 4294951354.0, PermQuoteRetireDate = '2004-12-30', PermOrgIPODate = NULL, PermSecMapStartDate = '1994-11-08', PermSecMapEndDate = '2004-12-30' WHERE SecCode = 46124 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21528548680.0, ExchCode = 'CIN', PermQuoteRetireDate = '2009-08-07', PermSecMapStartDate = '2005-06-15', PermSecMapEndDate = '2009-08-07', endDate = '2009-08-06' WHERE SecCode = 46180 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-02-26' WHERE SecCode = 46213 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 46622 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-04-01' WHERE SecCode = 46630 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2005-05-05' WHERE SecCode = 47072 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2006-05-31' WHERE SecCode = 47305 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-03-07', PermSecMapEndDate = '2024-03-12' WHERE SecCode = 47334 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2006-05-31', PermSecMapEndDate = '2022-07-25', startDate = '2000-06-30' WHERE SecCode = 47348 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PDJ', QuotePermID = 55867899849.0, InstrPermID = 15629756692.0, OrgPermID = 4295904557.0, PriValQuotePermID = 55839288204.0, PriInstrPermID = 8590935312.0, IsPrimaryQuote = 0.0, ExchCode = 'DEA', QuoteClass = 'INDEXLN', InstrClass = 'INDEXLN', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951368.0, PermQuoteRetireDate = '2011-12-30', PermOrgIPODate = '1986-03-21', PermSecMapStartDate = '2005-10-31', PermSecMapEndDate = '2011-12-30', startDate = '2004-02-23', endDate = '2011-12-28' WHERE SecCode = 48111 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1989-04-19' WHERE SecCode = 48344 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21605425823.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-20', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 49435 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 49579 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-06-03', PermSecMapEndDate = '2024-06-17' WHERE SecCode = 49879 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-09-25' WHERE SecCode = 50796 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55839790272.0, InstrPermID = 8589962679.0, PriValQuotePermID = 55839790272.0, ExchCode = 'NYS', PermQuoteRetireDate = '2003-01-10', PermSecMapStartDate = '1990-03-23', PermSecMapEndDate = '2002-12-04', endDate = '2002-12-04' WHERE SecCode = 50861 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-06-25' WHERE SecCode = 51321 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-01-18' WHERE SecCode = 51466 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-09-26', PermSecMapEndDate = '2026-05-22' WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-06-11' WHERE SecCode = 51555 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2023-03-06' WHERE SecCode = 52036 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2008-08-20' WHERE SecCode = 52204 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 52251 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2020-03-02' WHERE SecCode = 52457 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PFD4d', QuotePermID = 21474884398.0, IsPrimaryQuote = 0.0, ExchCode = 'TRQ', PermSecMapStartDate = '2002-12-24', PermSecMapEndDate = '2012-11-28' WHERE SecCode = 52691 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 52746 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2012-02-03' WHERE SecCode = 52872 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1997-05-16' WHERE SecCode = 52882 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '1999-02-22' WHERE SecCode = 52926 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2010-05-27' WHERE SecCode = 53646 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'POO', QuotePermID = 55836483298.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'FRA', PermQuoteRetireDate = '2011-01-04', endDate = '2011-01-04' WHERE SecCode = 53862 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-08-23' WHERE SecCode = 55045 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475890345.0, IsPrimaryQuote = 0.0, ExchCode = 'FRA', PermQuoteRetireDate = '2022-02-28', PermSecMapEndDate = '2022-02-28' WHERE SecCode = 55111 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475033644.0, IsPrimaryQuote = 0.0, ExchCode = 'TDG', PermQuoteRetireDate = '2013-01-03', PermSecMapStartDate = '2005-06-03', PermSecMapEndDate = '2015-03-18', endDate = '2013-01-03' WHERE SecCode = 55131 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-09-01' WHERE SecCode = 55155 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-11-26', startDate = '1998-06-22' WHERE SecCode = 55331 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1989-07-12' WHERE SecCode = 55406 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ECVd', QuotePermID = 21531120125.0, ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-14', PermSecMapStartDate = '2025-02-04', PermSecMapEndDate = '2025-09-11', endDate = '2025-09-10' WHERE SecCode = 55888 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 56119 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475579003.0, IsPrimaryQuote = 0.0, PermQuoteRetireDate = '2002-12-19', PermSecMapStartDate = '2002-12-10', PermSecMapEndDate = '2002-12-19', startDate = '2002-12-10', endDate = '2002-12-19' WHERE SecCode = 56237 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-08', PermSecMapEndDate = '2026-07-13' WHERE SecCode = 56295 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1991-03-22' WHERE SecCode = 56360 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21478810765.0, IsPrimaryQuote = 0.0, ExchCode = 'TDG', PermQuoteRetireDate = '2012-05-14', PermSecMapEndDate = '2023-12-04', endDate = '2012-05-14' WHERE SecCode = 56433 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1998-12-01' WHERE SecCode = 56640 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-11-15' WHERE SecCode = 56738 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2023-08-07', PermSecMapEndDate = '2023-08-08' WHERE SecCode = 56761 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-04-25' WHERE SecCode = 56822 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PLD.U', QuotePermID = 55839649708.0, InstrPermID = 8591049211.0, PriValQuotePermID = 55839649708.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermSecMapStartDate = '2004-03-17', PermSecMapEndDate = '2007-12-18', startDate = '2004-03-17', endDate = '2007-12-14' WHERE SecCode = 56857 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 56859 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PSA PR F CL', QuotePermID = 55838325088.0, InstrPermID = 15629460429.0, OrgPermID = 5068057414.0, PriTrdQuotePermID = 55838325088.0, PriValQuotePermID = 55839325078.0, PriInstrPermID = 8590934842.0, IsPrimaryInstr = 0.0, ExchCode = 'NYS', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'CINV', PriTRBCIndPermID = 4294951314.0, PermQuoteRetireDate = '2012-10-15', PermOrgIPODate = '1984-10-19', PermSecMapStartDate = '2005-09-22', PermSecMapEndDate = '2012-10-15', endDate = '2012-10-12' WHERE SecCode = 58038 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-21' WHERE SecCode = 58288 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-02-16', startDate = '1999-04-16' WHERE SecCode = 58290 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-08-10', startDate = '1999-04-23' WHERE SecCode = 58327 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-02-24' WHERE SecCode = 58336 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '1999-04-23' WHERE SecCode = 58337 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475434157.0, IsPrimaryQuote = 0.0, ExchCode = 'LCX', PermQuoteRetireDate = '2009-02-14', PermSecMapStartDate = '2005-05-03', PermSecMapEndDate = '2010-01-12', endDate = '2009-02-14' WHERE SecCode = 58469 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SAC', QuotePermID = 55838241577.0, ExchCode = 'MUN', PermQuoteRetireDate = '2020-04-16', PermSecMapStartDate = '2020-04-15', PermSecMapEndDate = '2020-04-16' WHERE SecCode = 58579 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2007-01-09', startDate = '1997-06-25' WHERE SecCode = 58632 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-11-18', PermSecMapEndDate = '2024-11-22', startDate = '1999-05-18' WHERE SecCode = 58680 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475564773.0, IsPrimaryQuote = 0.0, ExchCode = 'MUN', PermQuoteRetireDate = '2004-10-11', endDate = '2004-10-11' WHERE SecCode = 58740 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'USEd', QuotePermID = 21474877723.0, IsPrimaryQuote = 0.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2018-08-03', PermSecMapEndDate = '2023-06-05', endDate = '2018-08-03' WHERE SecCode = 58882 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475228763.0, ExchCode = 'NMQ', PermQuoteRetireDate = '2003-02-24', PermSecMapStartDate = '1995-06-01', PermSecMapEndDate = '2002-07-19', endDate = '2002-07-19' WHERE SecCode = 59099 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2000-03-10' WHERE SecCode = 59308 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-05-05' WHERE SecCode = 59737 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AWS', QuotePermID = 55838748997.0, IsPrimaryQuote = 0.0, PermQuoteRetireDate = '2011-04-18', PermSecMapStartDate = '1995-03-24', PermSecMapEndDate = '2011-04-18', startDate = '1995-03-24' WHERE SecCode = 59916 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2006-04-04' WHERE SecCode = 60325 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '1988-12-19', endDate = '2000-05-02' WHERE SecCode = 60366 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SHEL', QuotePermID = 55838325260.0, InstrPermID = 8590936112.0, PriTrdQuotePermID = 55838325260.0, PriValQuotePermID = 55839325417.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2005-07-26', endDate = NULL WHERE SecCode = 60771 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55835780841.0, IsPrimaryQuote = 0.0, ExchCode = 'DUS', PermQuoteRetireDate = '2015-06-30', PermSecMapStartDate = '2009-11-25', PermSecMapEndDate = '2015-06-30' WHERE SecCode = 60874 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '1999-09-20', endDate = '2000-06-29' WHERE SecCode = 60933 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '1988-01-01' WHERE SecCode = 61070 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-12-17', startDate = '1999-09-23' WHERE SecCode = 61216 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 61518 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-10' WHERE SecCode = 61656 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-02' WHERE SecCode = 62571 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-07-01', startDate = '1961-06-26' WHERE SecCode = 62883 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-07-01', startDate = '1989-10-18' WHERE SecCode = 62884 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-06-20', PermSecMapEndDate = '2024-06-21' WHERE SecCode = 64913 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-04' WHERE SecCode = 64954 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-10-05' WHERE SecCode = 64971 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-08-13' WHERE SecCode = 65129 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-15' WHERE SecCode = 65365 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '2000-12-21', endDate = '2001-04-05' WHERE SecCode = 65625 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-04-01', startDate = '2000-05-11' WHERE SecCode = 65664 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '2000-10-12' WHERE SecCode = 65813 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'IEM', QuotePermID = 21475573609.0, IsPrimaryQuote = 0.0, ExchCode = 'HAN', PermQuoteRetireDate = '2007-09-12', PermSecMapStartDate = '2000-05-03', PermSecMapEndDate = '2013-06-17', startDate = '2000-05-03', endDate = '2007-09-12' WHERE SecCode = 65870 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 66216 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-09-14' WHERE SecCode = 66236 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'HJG', QuotePermID = 34488747308.0, ExchCode = 'XPH', PermQuoteRetireDate = '2009-02-14', endDate = '2009-02-14' WHERE SecCode = 68290 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-08-31', PermSecMapEndDate = '2026-09-01' WHERE SecCode = 68545 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-08-07' WHERE SecCode = 68568 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2022-02-22' WHERE SecCode = 68948 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1961-03-28' WHERE SecCode = 69016 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2019-01-09' WHERE SecCode = 69525 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70042 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70098 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-01-04' WHERE SecCode = 70276 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-03-27' WHERE SecCode = 70336 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55839469089.0, ExchCode = 'BSE', PermQuoteRetireDate = '2002-10-01', PermSecMapStartDate = '1993-12-21', PermSecMapEndDate = '2002-10-01' WHERE SecCode = 70348 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-08-10' WHERE SecCode = 70402 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 70438 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-24' WHERE SecCode = 70569 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-24' WHERE SecCode = 70619 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21789546797.0, IsPrimaryQuote = 1.0, ExchCode = 'NSI' WHERE SecCode = 71672 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-03-27' WHERE SecCode = 72102 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '517326', QuotePermID = 55838336788.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2016-01-08', PermSecMapEndDate = '2016-01-08' WHERE SecCode = 72171 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-09-18' WHERE SecCode = 72200 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 72215 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72293 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-04-26' WHERE SecCode = 72593 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2018-05-01' WHERE SecCode = 72697 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermSecMapStartDate = NULL WHERE SecCode = 72801 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-17' WHERE SecCode = 72815 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-06-13' WHERE SecCode = 72928 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2010-12-10', startDate = '2005-11-07' WHERE SecCode = 72930 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = '524552', QuotePermID = 55838340093.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2016-04-20' WHERE SecCode = 73016 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-10-13' WHERE SecCode = 73179 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '1996-07-04', startDate = '1996-07-04' WHERE SecCode = 73789 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2006-07-28' WHERE SecCode = 73960 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2023-02-08' WHERE SecCode = 74331 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 74431 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1979-01-02' WHERE SecCode = 74977 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2006-07-28', PermSecMapEndDate = '2026-09-12' WHERE SecCode = 75213 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1990-03-19' WHERE SecCode = 75387 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 75413 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1978-11-24' WHERE SecCode = 75769 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-07-22' WHERE SecCode = 75801 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2013-10-01' WHERE SecCode = 75877 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1999-07-09' WHERE SecCode = 75927 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2024-11-14' WHERE SecCode = 76467 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-07-24' WHERE SecCode = 76638 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OSS', DsPrimQtSedol = 'BXN8487', PermSecMapEndDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 76701 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-07-14' WHERE SecCode = 77172 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '1995-11-24' WHERE SecCode = 77255 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PAET', QuotePermID = 55835340694.0, InstrPermID = 8590940710.0, OrgPermID = 4295899556.0, PriTrdQuotePermID = 55835340694.0, PriValQuotePermID = 55839281423.0, PriInstrPermID = 8590940710.0, ExchCode = 'NSM', PriTRBCIndPermID = 4294951189.0, PermQuoteRetireDate = '2011-12-01', PermSecMapStartDate = '2002-07-19', PermSecMapEndDate = '2011-12-01', endDate = '2011-11-30' WHERE SecCode = 77422 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-16' WHERE SecCode = 77701 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '511656', QuotePermID = 55838336898.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2016-08-17' WHERE SecCode = 77710 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77719 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-09-25', PermSecMapEndDate = '2026-09-27', endDate = '2026-09-25' WHERE SecCode = 77865 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 78001 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = '6486.T^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-29', SecMapEndDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 78010 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '2002-07-08', endDate = '2007-12-04' WHERE SecCode = 78555 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-01-16', PermSecMapEndDate = '2024-01-22' WHERE SecCode = 78584 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21503679853.0, IsPrimaryQuote = 0.0, ExchCode = 'INC', PermQuoteRetireDate = '2018-01-08', PermSecMapEndDate = '2018-01-07' WHERE SecCode = 78623 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '500057', QuotePermID = 55847725384.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2016-04-20' WHERE SecCode = 78678 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-16' WHERE SecCode = 78963 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-23' WHERE SecCode = 79069 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21503680599.0, IsPrimaryQuote = 0.0, ExchCode = 'INC', PermQuoteRetireDate = '2018-01-08', PermSecMapEndDate = '2018-01-07' WHERE SecCode = 79082 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79086 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL WHERE SecCode = 79349 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-21' WHERE SecCode = 79351 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 79377 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '524101', QuotePermID = 21475723345.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2009-06-09', PermSecMapStartDate = '2002-05-09', PermSecMapEndDate = '2009-06-09' WHERE SecCode = 79395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79422 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79510 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2015-12-21' WHERE SecCode = 80021 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55838806400.0, InstrPermID = 8590105399.0, OrgPermID = 4295893164.0, PriValQuotePermID = 55838806400.0, PriInstrPermID = 8590933316.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'SET', QuoteClass = 'NVDR', InstrClass = 'NVDR', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951374.0, PermQuoteRetireDate = '2021-08-18', PermSecMapStartDate = '2002-12-04', PermSecMapEndDate = '2021-08-17' WHERE SecCode = 80489 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2003-08-04' WHERE SecCode = 80557 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'GULF SPACE TECH THB5(NVDR)' WHERE SecCode = 80661 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21520090187.0, IsPrimaryQuote = 0.0, ExchCode = 'MCD', PermSecMapStartDate = '2001-08-27', PermSecMapEndDate = '2020-05-26' WHERE SecCode = 81100 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '522259', QuotePermID = 55838338296.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2018-01-08', PermSecMapEndDate = '2018-01-07' WHERE SecCode = 81818 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-04-01' WHERE SecCode = 81933 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1990-06-01' WHERE SecCode = 82159 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-11-07' WHERE SecCode = 82190 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-07-14' WHERE SecCode = 82297 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1990-01-02' WHERE SecCode = 82384 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-15' WHERE SecCode = 82764 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-24' WHERE SecCode = 82791 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82801 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-23' WHERE SecCode = 82927 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82974 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21520090489.0, IsPrimaryQuote = 0.0, ExchCode = 'MCD', PermSecMapStartDate = '2002-01-14', PermSecMapEndDate = '2020-05-26' WHERE SecCode = 83636 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2016-10-03', startDate = '2014-12-31' WHERE SecCode = 83664 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1996-12-16' WHERE SecCode = 84315 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-08-11' WHERE SecCode = 84538 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2009-03-24' WHERE SecCode = 84834 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-24' WHERE SecCode = 85790 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '642A', DsPrimQtSedol = 'BWNN2V4', PriInstrPermID = NULL, PermSecMapEndDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 86002 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '1993-03-02' WHERE SecCode = 86623 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 86776 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-14' WHERE SecCode = 86836 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-10-02' WHERE SecCode = 87076 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2002-05-08', PermSecMapEndDate = '2009-06-17', endDate = '2009-06-17' WHERE SecCode = 87081 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55838809392.0, IsPrimaryQuote = 1.0, PermQuoteRetireDate = '2021-08-18', PermSecMapStartDate = '2003-01-02', PermSecMapEndDate = '2011-12-01', endDate = '2011-12-01' WHERE SecCode = 87485 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2007-03-12', SecMapEndDate = '2079-06-06', endDate = '2013-06-16' WHERE SecCode = 87614 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-07-25' WHERE SecCode = 88312 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55839775790.0, InstrPermID = 8589998591.0, PriValQuotePermID = 55839775790.0, PermQuoteRetireDate = '2003-01-18', PermSecMapStartDate = '2002-12-06', PermSecMapEndDate = '2003-01-15', startDate = '2002-12-06', endDate = '2003-01-15' WHERE SecCode = 88651 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-04-26' WHERE SecCode = 89178 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'QINGHAI BIOTECH PH HKD0.0625' WHERE SecCode = 89269 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SILSTON', QuotePermID = 55839651194.0, InstrPermID = 8590024779.0, OrgPermID = 4295883606.0, PriValQuotePermID = 55839651194.0, PriInstrPermID = 8590024779.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'KLS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'MYS', IncCntry = 'MYS', PriTRBCIndPermID = 4294951696.0, PermQuoteRetireDate = '2007-04-13', PermSecMapStartDate = '2003-02-25', PermSecMapEndDate = '2007-04-13' WHERE SecCode = 89329 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-09-17' WHERE SecCode = 89416 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365444.0 WHERE SecCode = 89597 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AKTAF', QuotePermID = 55835386793.0, InstrPermID = 8590943497.0, PriValQuotePermID = 55838796360.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'AC', ExchCode = 'PNK', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2008-07-03' WHERE SecCode = 90149 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 90150 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-03' WHERE SecCode = 90481 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475190514.0, IsPrimaryQuote = 0.0, ExchCode = 'PNK', PermSecMapStartDate = '2004-06-18' WHERE SecCode = 90513 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 90744 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-09-25', PermSecMapEndDate = '2026-09-27', endDate = '2026-09-25' WHERE SecCode = 90918 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-29', SecMapEndDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 90956 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475463468.0, IsPrimaryQuote = 0.0, ExchCode = 'CVE', PermQuoteRetireDate = '2001-05-31', PermSecMapStartDate = '1997-04-22', PermSecMapEndDate = '2001-05-31' WHERE SecCode = 90961 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-13' WHERE SecCode = 91014 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475461343.0, IsPrimaryQuote = 0.0, ExchCode = 'CVE', PermQuoteRetireDate = '2001-06-06', PermSecMapStartDate = '1990-03-30', PermSecMapEndDate = '2001-06-06' WHERE SecCode = 91243 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-24' WHERE SecCode = 91249 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1997-09-17' WHERE SecCode = 91284 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91332 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OGL', QuotePermID = 55835582426.0, InstrPermID = 8590025137.0, PriValQuotePermID = 55835582426.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, QuoteClass = 'CHESS', InstrClass = 'CHESS', PermQuoteRetireDate = '2015-09-02', PermSecMapStartDate = '2001-09-13', PermSecMapEndDate = '2015-09-01', endDate = '2014-11-27' WHERE SecCode = 91395 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475296886.0, InstrPermID = 8590943586.0, OrgPermID = 4295862298.0, PriValQuotePermID = 21475296886.0, PriInstrPermID = 8590943586.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'TOR', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'UNK', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951782.0, PermQuoteRetireDate = '2004-07-26', PermSecMapStartDate = '2002-05-28', PermSecMapEndDate = '2004-07-26' WHERE SecCode = 91460 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1999-08-24' WHERE SecCode = 92027 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-09-30' WHERE SecCode = 92088 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475436159.0, IsPrimaryQuote = 0.0, ExchCode = 'TOR', PermQuoteRetireDate = '2001-09-07', PermSecMapStartDate = '1995-05-03', PermSecMapEndDate = '2001-09-07' WHERE SecCode = 92134 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2019-12-16' WHERE SecCode = 92309 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2022-03-16' WHERE SecCode = 92921 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2023-01-10' WHERE SecCode = 92971 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55839661795.0, IsPrimaryQuote = 0.0, ExchCode = 'TOR', PermQuoteRetireDate = '2000-12-19', PermSecMapStartDate = '1993-04-07', PermSecMapEndDate = '2000-12-19' WHERE SecCode = 93027 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1960-01-01' WHERE SecCode = 93070 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55839663994.0, IsPrimaryQuote = 0.0, ExchCode = 'CVE', PermQuoteRetireDate = '2001-07-12', PermSecMapStartDate = '1999-08-19', PermSecMapEndDate = '2001-07-12', startDate = '1999-08-19' WHERE SecCode = 93128 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475442253.0, IsPrimaryQuote = 0.0, ExchCode = 'CVE', PermQuoteRetireDate = '2003-06-23', PermSecMapStartDate = '1997-03-04', PermSecMapEndDate = '2003-06-24' WHERE SecCode = 93137 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-24', endDate = '2026-09-24' WHERE SecCode = 93165 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475464202.0, IsPrimaryQuote = 0.0, ExchCode = 'CVE', PermQuoteRetireDate = '2001-05-31', PermSecMapStartDate = '1990-03-30', PermSecMapEndDate = '2001-05-31', startDate = '1990-03-30' WHERE SecCode = 93225 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2009-09-22', PermSecMapEndDate = '2016-02-19' WHERE SecCode = 93272 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93272 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-03-27', startDate = '1997-08-26' WHERE SecCode = 93434 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475447577.0, IsPrimaryQuote = 0.0, ExchCode = 'TOR', PermQuoteRetireDate = '2000-11-30', PermSecMapStartDate = '1993-10-04', PermSecMapEndDate = '2000-11-30', startDate = '1993-10-04' WHERE SecCode = 93516 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '2000-05-02' WHERE SecCode = 93629 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 93789 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2018-12-21', PermSecMapEndDate = '2023-12-07' WHERE SecCode = 93867 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55839884366.0, InstrPermID = 8589943183.0, OrgPermID = 4297966103.0, PriValQuotePermID = 55839884366.0, PriInstrPermID = NULL, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, QuoteClass = 'ORD', InstrClass = 'ORD', PriTRBCIndPermID = 4294951822.0, PermQuoteRetireDate = '2000-05-15', PermSecMapStartDate = '1996-02-13', PermSecMapEndDate = '2000-05-15', startDate = '1996-02-13', endDate = '2000-05-15' WHERE SecCode = 93873 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FAL.PR.B', QuotePermID = 21475491419.0, InstrPermID = 8589975003.0, PriValQuotePermID = 21475491419.0, IsPrimaryInstr = 0.0, PermQuoteRetireDate = '2009-03-02', PermSecMapStartDate = '2004-03-02', PermSecMapEndDate = '2009-03-02', startDate = '2004-03-02', endDate = '2009-02-27' WHERE SecCode = 93895 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475366287.0, PermQuoteRetireDate = '2001-11-29', PermSecMapStartDate = '1996-06-03', PermSecMapEndDate = '2001-11-29' WHERE SecCode = 93977 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 94161 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475444607.0, IsPrimaryQuote = 0.0, ExchCode = 'TOR', PermQuoteRetireDate = '2001-05-03', PermSecMapStartDate = '1996-06-21', PermSecMapEndDate = '2001-05-03' WHERE SecCode = 94329 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2017-01-02', endDate = '2017-01-02' WHERE SecCode = 94434 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-08-19' WHERE SecCode = 94441 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2023-07-16' WHERE SecCode = 94448 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2024-02-07' WHERE SecCode = 94495 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475424108.0, IsPrimaryQuote = 0.0, ExchCode = 'CVE', PermQuoteRetireDate = '2001-12-05', PermSecMapStartDate = '1990-03-30', PermSecMapEndDate = '2001-12-05' WHERE SecCode = 94548 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-09-26' WHERE SecCode = 94586 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475415915.0, IsPrimaryQuote = 0.0, ExchCode = 'CVE', PermQuoteRetireDate = '2003-06-23', PermSecMapStartDate = '2002-11-27', PermSecMapEndDate = '2003-06-24' WHERE SecCode = 94688 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-01-04' WHERE SecCode = 94711 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2023-07-16' WHERE SecCode = 94895 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 94933 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2004-10-04', startDate = '1988-09-12' WHERE SecCode = 94965 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2023-02-14' WHERE SecCode = 95024 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2024-07-30' WHERE SecCode = 95299 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2024-04-25' WHERE SecCode = 95360 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-07-14' WHERE SecCode = 95617 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-11-21' WHERE SecCode = 95971 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2023-07-16' WHERE SecCode = 96517 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-01-05' WHERE SecCode = 96535 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 25727194972.0, IsPrimaryQuote = 0.0, ExchCode = 'PNK', PermQuoteRetireDate = '2025-04-01', PermSecMapStartDate = '2022-06-23', PermSecMapEndDate = '2025-04-01', endDate = '2024-05-17' WHERE SecCode = 96643 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 96704 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-03-07', startDate = '1974-02-04' WHERE SecCode = 96824 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-02-10', PermSecMapEndDate = '2023-02-18', endDate = '2023-02-18' WHERE SecCode = 96843 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = '009415', QuotePermID = 55834591457.0, InstrPermID = 8589991688.0, PriValQuotePermID = 55834591457.0, IsPrimaryInstr = 0.0, QuoteClass = 'PRF', InstrClass = 'PRF', PermSecMapStartDate = '2007-05-04', PermSecMapEndDate = NULL, startDate = '1995-08-14', endDate = NULL WHERE SecCode = 96847 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-02-19' WHERE SecCode = 96896 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2023-05-30' WHERE SecCode = 97151 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-17' WHERE SecCode = 97224 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NTL.PR.G', QuotePermID = 21475490650.0, InstrPermID = 46642142162.0, PriValQuotePermID = 21475490650.0, IsPrimaryInstr = 0.0, PermSecMapStartDate = '2005-05-24', PermSecMapEndDate = '2009-06-29', endDate = '2009-06-19' WHERE SecCode = 97288 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA7270534075', RkdTicker = 'PXI', RkdSEDOL = 'BT6977', RkdCUSIP = '72705340', RkdRIC = 'PXI.CD', RkdDisplayRIC = 'PXI.CD', RkdCode = 93373.0, RkdIssueID = 1.0, RkdIssueCode = 117529.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN' WHERE SecCode = 98055 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A', DsExchMnem = 'NGO', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', PermSecMapStartDate = '2026-09-21', endDate = NULL WHERE SecCode = 98177 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475296884.0, IsPrimaryQuote = 0.0, PermQuoteRetireDate = '2002-05-28', PermSecMapStartDate = '1999-03-04', PermSecMapEndDate = '2002-05-28' WHERE SecCode = 98267 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 98388 AND Type_ = 1;
UPDATE data_universe SET Name = 'VISION LITHIUM INC COM SHS', PermSecMapEndDate = '2026-09-26', endDate = '2026-09-26' WHERE SecCode = 98629 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-24' WHERE SecCode = 98748 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98852 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-17' WHERE SecCode = 98891 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 99085 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-09-28', PermSecMapEndDate = '2026-09-27', endDate = '2026-09-27' WHERE SecCode = 99240 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '506720', QuotePermID = 55838341282.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermSecMapEndDate = '2019-03-17' WHERE SecCode = 99385 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-05-06' WHERE SecCode = 99478 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2021-09-30' WHERE SecCode = 99739 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2021-09-30' WHERE SecCode = 99740 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LUN', QuotePermID = 55846093956.0, InstrPermID = 8590927305.0, PriValQuotePermID = 55846093956.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', ExchCode = 'CPH', PermQuoteRetireDate = '2022-06-10', startDate = '1999-06-17' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-10-04', startDate = '1987-05-26' WHERE SecCode = 101127 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-11-20' WHERE SecCode = 101343 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 101352 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2002-03-08' WHERE SecCode = 101489 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 101540 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-04-06', PermSecMapEndDate = '2023-06-08', startDate = '2002-01-09' WHERE SecCode = 101594 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-29' WHERE SecCode = 101676 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2002-01-28' WHERE SecCode = 102166 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 102468 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21748242454.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-20', PermSecMapEndDate = NULL WHERE SecCode = 102656 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 102657 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21605425908.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-20', PermSecMapEndDate = NULL WHERE SecCode = 102863 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 102909 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2002-10-07' WHERE SecCode = 103298 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-21' WHERE SecCode = 103471 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 103851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 105182 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '2012-02-08' WHERE SecCode = 105466 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2022-03-17', startDate = '2008-02-04' WHERE SecCode = 105573 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '2012-04-18' WHERE SecCode = 111341 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-15' WHERE SecCode = 111346 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2020-03-10', PermSecMapEndDate = '2024-12-05', startDate = '2020-03-10', endDate = '2024-12-05' WHERE SecCode = 111504 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '532526', QuotePermID = 55838337015.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2018-01-08', PermSecMapEndDate = '2018-01-07' WHERE SecCode = 111772 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-03-18' WHERE SecCode = 111793 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-10-16' WHERE SecCode = 112415 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '700110', QuotePermID = 55852875278.0, InstrPermID = 8591256942.0, PriValQuotePermID = 55852875278.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'BSE', QuoteClass = 'PRF', InstrClass = 'PRF', PermQuoteRetireDate = '2022-10-03', PermSecMapStartDate = '2010-10-14', PermSecMapEndDate = '2018-09-28', startDate = '2008-03-14', endDate = '2018-09-28' WHERE SecCode = 113119 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ELET.I', QuotePermID = 21475509699.0, IsPrimaryQuote = 0.0, ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03', PermSecMapEndDate = '2015-11-02', endDate = '2008-11-03' WHERE SecCode = 113733 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2015-11-18' WHERE SecCode = 113846 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TRAC', QuotePermID = 55836050759.0, InstrPermID = 8590943306.0, OrgPermID = 4295894581.0, PriValQuotePermID = 55836050759.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'LSE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', IncCntry = 'GBR', PriTRBCIndPermID = 4294951702.0, PermQuoteRetireDate = '2008-07-10', PermSecMapStartDate = '2006-12-20', PermSecMapEndDate = '2008-07-10' WHERE SecCode = 114724 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115260 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115666 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 115829 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115980 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115997 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116213 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-10' WHERE SecCode = 116421 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-11-07', startDate = '2004-11-07' WHERE SecCode = 117183 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-11-07', startDate = '2004-11-07' WHERE SecCode = 117185 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 119593 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 120585 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 123430 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 124613 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 124738 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-30' WHERE SecCode = 124744 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q8710G22' WHERE SecCode = 125248 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125556 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125692 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 126053 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126457 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126634 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2007-07-06' WHERE SecCode = 126780 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126828 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '2005-05-18' WHERE SecCode = 126966 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126972 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2005-02-02', startDate = '2005-02-02' WHERE SecCode = 128785 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-11-22', PermSecMapEndDate = '2024-10-28', startDate = '2002-06-14' WHERE SecCode = 130405 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-16' WHERE SecCode = 130564 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2019-03-18', startDate = '2008-03-25' WHERE SecCode = 130623 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-10-02' WHERE SecCode = 130714 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 130886 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GOLDEN ENGY PWR ILS1.00' WHERE SecCode = 133109 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 133893 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '532631', QuotePermID = 55838337259.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2013-10-01', PermSecMapStartDate = '2005-05-05', PermSecMapEndDate = '2013-10-01' WHERE SecCode = 133999 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135272 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135448 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135736 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-27' WHERE SecCode = 135779 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135958 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136034 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136772 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136981 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136991 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 137019 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 137670 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-10-10', startDate = '2005-07-11' WHERE SecCode = 137695 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX59BG5' WHERE SecCode = 137982 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 138036 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2005-07-13', PermSecMapEndDate = '2011-11-26', startDate = '2005-07-13', endDate = '2011-11-26' WHERE SecCode = 140062 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 140277 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140586 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2005-10-19' WHERE SecCode = 141005 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475372846.0, InstrPermID = 21475372845.0, PriValQuotePermID = 21475372846.0, IsPrimaryInstr = 0.0, PermQuoteRetireDate = '2002-11-01', PermSecMapStartDate = '2001-08-30', PermSecMapEndDate = '2002-11-01', startDate = '2001-08-30', endDate = '2002-11-01' WHERE SecCode = 141074 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475873601.0, ExchCode = 'TDG', PermQuoteRetireDate = '2015-11-27', endDate = '2015-11-27' WHERE SecCode = 141320 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-02-28', startDate = '2005-11-09' WHERE SecCode = 141616 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KUSBP', QuotePermID = 55838831414.0, InstrPermID = 8589992698.0, PriValQuotePermID = 21480951991.0, IsPrimaryInstr = 0.0, ExchCode = 'RTS', QuoteClass = 'CUM', InstrClass = 'CUM', PermQuoteRetireDate = '2012-05-24', PermSecMapStartDate = '2010-01-27', PermSecMapEndDate = '2012-05-24', startDate = '2005-09-29', endDate = '2010-11-16' WHERE SecCode = 141667 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2005-11-22' WHERE SecCode = 141715 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-17', PermSecMapEndDate = '2025-12-23' WHERE SecCode = 141806 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55846587409.0, IsPrimaryQuote = 0.0, ExchCode = 'MUN', PermQuoteRetireDate = '2013-07-01', PermSecMapStartDate = '2013-06-29', PermSecMapEndDate = '2013-07-01' WHERE SecCode = 142040 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-18' WHERE SecCode = 142381 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142542 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21503681262.0, IsPrimaryQuote = 0.0, ExchCode = 'INC', PermQuoteRetireDate = '2018-01-08', PermSecMapEndDate = '2018-01-07' WHERE SecCode = 142569 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NLX', QuotePermID = 55839928498.0, InstrPermID = 8589958550.0, OrgPermID = 4295895407.0, PriValQuotePermID = 55839928498.0, PriInstrPermID = NULL, IsPrimaryInstr = 0.0, ExchCode = 'LSE', OrgTypeCode = 'COM', PriTRBCIndPermID = 4294951310.0, PermQuoteRetireDate = '2007-06-06', PermSecMapStartDate = '2006-04-07', PermSecMapEndDate = '2007-06-05', startDate = '2006-04-03', endDate = '2007-05-04' WHERE SecCode = 142590 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NNGRP', QuotePermID = 21475312740.0, InstrPermID = 8589941821.0, PriValQuotePermID = 21475312740.0, IsPrimaryInstr = 0.0, ExchCode = 'RTS', QuoteClass = 'PRF', InstrClass = 'PRF', PermQuoteRetireDate = '2007-03-22' WHERE SecCode = 142777 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 142857 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 142886 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 142894 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-24', startDate = '2006-01-25' WHERE SecCode = 143039 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-02-08' WHERE SecCode = 143094 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 143734 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 143736 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BFPMV798', RkdTicker = 'TERN', RkdSEDOL = 'BFPMV7', RkdCUSIP = 'G8760J11', RkdRIC = 'TERNT.L', RkdDisplayRIC = 'TERNT.L', RkdCode = 51875.0, RkdIssueID = 1.0, RkdIssueCode = 67729.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'LON', RkdExchCtry = 'GBR' WHERE SecCode = 144137 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-09-17', startDate = '2006-04-01' WHERE SecCode = 144252 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BIO VIEW ILS1' WHERE SecCode = 144311 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-28' WHERE SecCode = 144578 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-04-01' WHERE SecCode = 144656 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-10-16', startDate = '2006-04-28' WHERE SecCode = 144658 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-17' WHERE SecCode = 144847 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-17' WHERE SecCode = 144913 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836325242.0, IsPrimaryQuote = 0.0, ExchCode = 'BER', PermQuoteRetireDate = '2012-12-17', PermSecMapStartDate = '2006-04-24', PermSecMapEndDate = '2012-12-17', startDate = '2006-04-24' WHERE SecCode = 145020 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-10-17' WHERE SecCode = 145615 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-09' WHERE SecCode = 145678 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-08-13', startDate = '2006-06-27' WHERE SecCode = 146200 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-10-01' WHERE SecCode = 146206 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21605426057.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-20', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 146271 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21605426058.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-20', PermSecMapEndDate = NULL WHERE SecCode = 146275 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BAUER GMBH & CO NPV', PermSecMapStartDate = '2023-06-21' WHERE SecCode = 146295 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-01-09' WHERE SecCode = 146398 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836333977.0, IsPrimaryQuote = 0.0, ExchCode = 'BER', PermQuoteRetireDate = '2023-02-01', PermSecMapStartDate = '2023-01-30', PermSecMapEndDate = '2023-02-01' WHERE SecCode = 146399 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-22', startDate = '2006-10-30' WHERE SecCode = 146423 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836576527.0, IsPrimaryQuote = 0.0, ExchCode = 'FRA', PermQuoteRetireDate = '2022-02-25' WHERE SecCode = 146789 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2023-11-28' WHERE SecCode = 147023 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-15' WHERE SecCode = 147109 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21903777196.0, ExchCode = 'HAN', PermQuoteRetireDate = '2023-03-16' WHERE SecCode = 147555 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-24', PermSecMapEndDate = '2025-01-28', startDate = '2006-09-18' WHERE SecCode = 161962 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-02-29' WHERE SecCode = 164441 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-13' WHERE SecCode = 167240 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 168034 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-12-29', startDate = '2006-10-25' WHERE SecCode = 169919 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-09-07', PermSecMapEndDate = '2023-02-15', startDate = '2006-11-07' WHERE SecCode = 174509 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-17' WHERE SecCode = 174567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838553343.0, ExchCode = 'STU', PermQuoteRetireDate = '2017-06-15', PermSecMapStartDate = '2017-06-13', PermSecMapEndDate = '2017-06-15', startDate = '2008-05-05' WHERE SecCode = 175240 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2006-10-13' WHERE SecCode = 176033 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2023-07-16' WHERE SecCode = 176751 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21531130034.0, ExchCode = 'BCO', PermQuoteRetireDate = '2026-05-26', PermSecMapStartDate = '2026-01-14', PermSecMapEndDate = '2026-01-15', startDate = '2006-11-23' WHERE SecCode = 176977 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21860843237.0, ExchCode = 'MUN', PermQuoteRetireDate = '2023-08-18', PermSecMapStartDate = '2023-06-27', PermSecMapEndDate = '2023-10-18', endDate = '2023-05-16' WHERE SecCode = 177474 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21507329852.0, ExchCode = 'FRA' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 179072 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-08-29', startDate = '2006-11-29' WHERE SecCode = 179565 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-08-27', PermSecMapEndDate = '2025-08-07', startDate = '2006-12-06' WHERE SecCode = 183074 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836337738.0, ExchCode = 'BER', PermQuoteRetireDate = '2010-06-16', PermSecMapStartDate = '2006-11-30', PermSecMapEndDate = '2012-01-31', startDate = '2006-11-30', endDate = '2010-06-16' WHERE SecCode = 183758 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MLD', QuotePermID = 55836054383.0, InstrPermID = 8590922756.0, PriValQuotePermID = 55836054383.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermInstrStatus = 'DC', ExchCode = 'LSE', PermQuoteRetireDate = '2016-12-22' WHERE SecCode = 187054 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-08-16', PermSecMapEndDate = '2024-01-02' WHERE SecCode = 187940 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '532792', QuotePermID = 55838336625.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2018-01-08', PermSecMapEndDate = '2018-01-07' WHERE SecCode = 192009 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55835777030.0, PermQuoteStatus = 'AC', ExchCode = 'DUS', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 193790 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '2018-02-25' WHERE SecCode = 194201 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 201990 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-05-20', startDate = '2007-03-08' WHERE SecCode = 202296 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2015-11-02', startDate = '2008-11-26' WHERE SecCode = 203639 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-20', startDate = '2007-03-23' WHERE SecCode = 209470 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-10-11', startDate = '2007-03-22' WHERE SecCode = 211976 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-18' WHERE SecCode = 216572 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21605426049.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-20', PermSecMapEndDate = NULL WHERE SecCode = 240051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 243354 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 244283 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-02-06' WHERE SecCode = 246280 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 250218 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-05-02', PermSecMapEndDate = '2025-07-01' WHERE SecCode = 252333 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2018-11-21' WHERE SecCode = 253279 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '500162', QuotePermID = 55838337485.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2018-01-08', PermSecMapEndDate = '2018-01-07' WHERE SecCode = 253281 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-20' WHERE SecCode = 255900 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 255960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 256504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 257965 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '532840', QuotePermID = 55838335947.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2018-01-08', PermSecMapEndDate = '2018-01-07' WHERE SecCode = 288247 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21578218088.0, InstrPermID = 8590688309.0, OrgPermID = 4297709872.0, PriTrdQuotePermID = 21578218088.0, PriValQuotePermID = 55838852387.0, PriInstrPermID = 8590688309.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PriTRBCIndPermID = 4294951678.0, PermQuoteRetireDate = '2018-06-20', PermOrgIPODate = NULL, PermSecMapStartDate = '2015-12-18', PermSecMapEndDate = '2018-06-20' WHERE SecCode = 291240 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55836414959.0, IsPrimaryQuote = 0.0, ExchCode = 'FRA', PermQuoteRetireDate = '2012-02-16', PermSecMapStartDate = '2007-05-15', PermSecMapEndDate = '2012-02-16' WHERE SecCode = 292149 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-10' WHERE SecCode = 292967 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2012-05-31' WHERE SecCode = 293087 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2015-12-01', startDate = '2007-05-03' WHERE SecCode = 297735 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 301329 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-06-02' WHERE SecCode = 301431 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 303801 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'WWAY', QuotePermID = 55856340829.0, IsPrimaryQuote = 0.0, ExchCode = 'NAQ', PermQuoteRetireDate = '2013-02-04', PermSecMapStartDate = '2009-12-21', PermSecMapEndDate = '2013-02-04', startDate = '2007-06-18', endDate = '2013-01-31' WHERE SecCode = 306398 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-08-18' WHERE SecCode = 306599 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-10-16', startDate = '2007-07-17' WHERE SecCode = 309333 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2007-08-01', startDate = '2007-08-01' WHERE SecCode = 312797 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FTF.A', QuotePermID = 55840225969.0, InstrPermID = 8589960210.0, PriValQuotePermID = 55840225969.0, IsPrimaryInstr = 0.0, PermQuoteRetireDate = '2007-08-20', PermSecMapStartDate = '2007-07-18', PermSecMapEndDate = '2007-08-20', startDate = '2007-07-18' WHERE SecCode = 313611 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-25' WHERE SecCode = 316370 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EIOK.I', QuotePermID = 21475565340.0, IsPrimaryQuote = 0.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-11-03', PermSecMapStartDate = '2007-09-21', PermSecMapEndDate = '2012-12-17', endDate = '2008-11-03' WHERE SecCode = 321214 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-25', PermSecMapEndDate = '2024-09-04' WHERE SecCode = 322847 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-02-01' WHERE SecCode = 322857 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-05-05' WHERE SecCode = 326691 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-07-26' WHERE SecCode = 331291 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 331320 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 333162 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2007-12-13', startDate = '2007-12-12' WHERE SecCode = 334500 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2017-02-02' WHERE SecCode = 336071 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-22' WHERE SecCode = 336989 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2024-03-01' WHERE SecCode = 341633 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2019-10-03' WHERE SecCode = 341804 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 342238 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2007-12-18' WHERE SecCode = 343267 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-07-18', startDate = '2007-12-06' WHERE SecCode = 345787 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2016-12-12', startDate = '2008-02-15' WHERE SecCode = 364525 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-02-21', startDate = '2008-02-22' WHERE SecCode = 367131 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2016-08-29', startDate = '2008-03-07' WHERE SecCode = 370411 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2013-12-17' WHERE SecCode = 375579 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 378081 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-02' WHERE SecCode = 381016 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 389876 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '532979', QuotePermID = 55840923161.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermSecMapStartDate = '2008-05-27', PermSecMapEndDate = '2020-05-26', startDate = '2008-05-27' WHERE SecCode = 390099 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-08-02', PermSecMapEndDate = '2025-05-16' WHERE SecCode = 390344 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-15' WHERE SecCode = 403620 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 403765 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 408145 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-18' WHERE SecCode = 409869 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-08-06', startDate = '2008-08-01' WHERE SecCode = 412429 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-29', PermQuoteRetireDate = '2026-09-29', endDate = '2026-09-29' WHERE SecCode = 414532 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 425884 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 425905 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475860104.0, IsPrimaryQuote = 0.0, ExchCode = 'BER', PermQuoteRetireDate = '2011-11-16', PermSecMapStartDate = '2008-09-29', PermSecMapEndDate = '2012-12-17', startDate = '2008-09-29', endDate = '2011-11-16' WHERE SecCode = 427070 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-08-25', startDate = '2008-10-06' WHERE SecCode = 427703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 429392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 442754 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475012660.0, ExchCode = 'STU', PermSecMapStartDate = '2026-01-01', startDate = '2011-02-01' WHERE SecCode = 486485 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'JOOSUNG CORP KRW2500' WHERE SecCode = 490265 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55849412055.0, ExchCode = 'MUN', PermQuoteRetireDate = '2023-04-27', PermSecMapStartDate = '2023-04-18', PermSecMapEndDate = '2023-04-27', startDate = '2009-05-08', endDate = '2023-04-25' WHERE SecCode = 510405 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21587574515.0, IsPrimaryQuote = 0.0, ExchCode = 'MCD', PermSecMapStartDate = '2009-05-07', PermSecMapEndDate = '2020-05-26', startDate = '2009-05-07' WHERE SecCode = 510799 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 519069 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 519104 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '2007-01-04' WHERE SecCode = 519518 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '1989-04-18', endDate = '1991-12-13' WHERE SecCode = 521329 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '500448', QuotePermID = 55852854610.0, InstrPermID = 8591357461.0, PriValQuotePermID = 55852854610.0, IsPrimaryInstr = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2018-07-04', PermSecMapStartDate = '2010-09-06', PermSecMapEndDate = '2011-05-13' WHERE SecCode = 522409 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616156726.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2022-06-27' WHERE SecCode = 529779 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21750435328.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-20', PermSecMapEndDate = NULL WHERE SecCode = 531911 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-01-03' WHERE SecCode = 532904 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-09-27', startDate = '2009-08-03' WHERE SecCode = 534988 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2021-06-28' WHERE SecCode = 535026 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-09-19', startDate = '2009-08-20' WHERE SecCode = 536728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-17', startDate = '2009-10-09' WHERE SecCode = 549681 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5000437248.0, PriInstrPermID = 21500996857.0, PriTRBCIndPermID = 4294951465.0, PermOrgIPODate = '2009-09-24' WHERE SecCode = 553594 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55849272403.0, ExchCode = 'RTF', PermQuoteRetireDate = '2014-08-11', PermSecMapEndDate = '2022-12-14', endDate = '2014-08-11' WHERE SecCode = 555865 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'tosb', QuotePermID = 21616156390.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 555916 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OGKFG', QuotePermID = 55838843389.0, IsPrimaryQuote = 0.0, ExchCode = 'RTE', PermQuoteRetireDate = '2011-11-01', PermSecMapStartDate = '2009-11-04', PermSecMapEndDate = '2011-11-02' WHERE SecCode = 555926 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616156568.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 556000 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616156705.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 556046 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2009-11-04' WHERE SecCode = 556064 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616156391.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 556075 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55856721631.0, IsPrimaryQuote = 0.0, ExchCode = 'STU', PermQuoteRetireDate = '2025-07-08', PermSecMapStartDate = '2025-07-03', PermSecMapEndDate = '2025-07-08' WHERE SecCode = 559949 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-23' WHERE SecCode = 561151 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-06-05' WHERE SecCode = 562568 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-22' WHERE SecCode = 564094 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-05-21', PermSecMapEndDate = '2026-01-02' WHERE SecCode = 564282 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2010-02-04' WHERE SecCode = 565283 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-04-19', startDate = '2010-02-08' WHERE SecCode = 565717 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 637304 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-12-07' WHERE SecCode = 650352 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474990767.0, IsPrimaryQuote = 0.0, ExchCode = 'FRA', PermQuoteRetireDate = '2012-12-17', PermSecMapStartDate = '2011-08-25', PermSecMapEndDate = '2012-12-17' WHERE SecCode = 652762 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 685105 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 703243 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616156971.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-20', PermSecMapStartDate = '2014-02-14', PermSecMapEndDate = NULL, endDate = '2017-01-08' WHERE SecCode = 703244 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 703347 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 703364 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 703367 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'zillp', QuotePermID = 55847697000.0, InstrPermID = 8590562905.0, PriValQuotePermID = 55847697000.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', QuoteClass = 'PRF', InstrClass = 'PRF', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2005-05-11', PermSecMapEndDate = NULL, startDate = '2005-05-11', endDate = NULL WHERE SecCode = 703462 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616156489.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-20', PermSecMapStartDate = '2015-03-18', PermSecMapEndDate = NULL, endDate = '2017-09-04' WHERE SecCode = 709572 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-13' WHERE SecCode = 710252 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-09-25' WHERE SecCode = 774326 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475803905.0, IsPrimaryQuote = 0.0, ExchCode = 'STU', PermQuoteRetireDate = '2011-11-11', PermSecMapStartDate = '2010-08-05', PermSecMapEndDate = '2012-12-17', startDate = '2010-08-05', endDate = '2011-11-11' WHERE SecCode = 790358 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 794875 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-05-25' WHERE SecCode = 820836 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-06-18', startDate = '2010-09-29' WHERE SecCode = 827424 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-11-01', startDate = '2010-10-12' WHERE SecCode = 836921 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475130308.0, IsPrimaryQuote = 0.0, ExchCode = 'FRA', PermSecMapStartDate = '2012-11-16', PermSecMapEndDate = '2012-12-17' WHERE SecCode = 851458 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-10-01', PermSecMapEndDate = '2025-02-06' WHERE SecCode = 853682 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2010-12-10', PermSecMapEndDate = '2014-06-26', startDate = '2010-12-10', endDate = '2014-06-26' WHERE SecCode = 877588 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 881877 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-09-08' WHERE SecCode = 1012884 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 1012892 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-10-30', startDate = '2011-03-11' WHERE SecCode = 1024298 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-05-18', PermSecMapEndDate = NULL, startDate = '2011-03-18', endDate = NULL WHERE SecCode = 1054745 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'THAI NGUYEN IRON & VND10000' WHERE SecCode = 1089511 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1111663 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'STOR', QuotePermID = 21475827842.0, IsPrimaryQuote = 0.0, ExchCode = 'LSE', PermQuoteRetireDate = '2011-06-29', PermSecMapStartDate = '2011-05-18', PermSecMapEndDate = '2011-06-29' WHERE SecCode = 1152203 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1160469 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HUD101 CONSTRUCTIO VND10000' WHERE SecCode = 1165232 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-06-28' WHERE SecCode = 1174486 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475845504.0, IsPrimaryQuote = 0.0, ExchCode = 'FRA', PermQuoteRetireDate = '2011-11-07', PermSecMapStartDate = '2011-06-10', PermSecMapEndDate = '2011-11-07', startDate = '2011-06-10' WHERE SecCode = 1182248 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-08-08', startDate = '2011-07-07' WHERE SecCode = 1189832 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475852462.0, InstrPermID = 21475852522.0, PriValQuotePermID = 21475852462.0, QuoteClass = 'DEFER', InstrClass = 'DEFER', PermQuoteRetireDate = '2011-12-21', PermSecMapStartDate = '2011-06-23', PermSecMapEndDate = '2011-12-21', startDate = '2011-06-23' WHERE SecCode = 1197626 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1204782 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-02-12' WHERE SecCode = 1205229 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-02-15', startDate = '2011-07-06' WHERE SecCode = 1207751 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209860 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209863 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1209871 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 1297616 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-08-21', startDate = '2011-09-08' WHERE SecCode = 1310566 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-09', startDate = '2011-09-23' WHERE SecCode = 1353073 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475907682.0, ExchCode = 'BER', PermQuoteRetireDate = '2012-12-17', PermSecMapStartDate = '2011-09-27', PermSecMapEndDate = '2012-12-17' WHERE SecCode = 1403467 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2018-11-21' WHERE SecCode = 1434690 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21477057669.0, IsPrimaryQuote = 0.0, ExchCode = 'BER', PermSecMapStartDate = '2011-10-27', PermSecMapEndDate = '2012-12-17', startDate = '2011-10-26', endDate = '2012-12-12' WHERE SecCode = 1453119 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2021-02-18' WHERE SecCode = 1455226 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-07-17', startDate = '2011-11-02' WHERE SecCode = 1456770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1465105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1468628 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG1145Y1281', RkdSEDOL = 'BTNMPF', RkdCUSIP = 'G1145Y12' WHERE SecCode = 1494004 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-06-07' WHERE SecCode = 1517314 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1546587 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1554192 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616156919.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1571261 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21484980046.0, ExchCode = 'RTS', PermQuoteRetireDate = '2021-02-13', PermSecMapStartDate = '2012-04-27', PermSecMapEndDate = '2020-01-16' WHERE SecCode = 1574226 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PRZMA.E', QuotePermID = 21503784193.0, InstrPermID = 21503784191.0, PriValQuotePermID = 21503784193.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2012-05-14', PermSecMapEndDate = NULL, startDate = '2012-05-14', endDate = NULL WHERE SecCode = 1584590 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MEGAP.E', QuotePermID = 21503902676.0, InstrPermID = 21503902675.0, PriValQuotePermID = 21503902676.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2012-05-16', PermSecMapEndDate = NULL, startDate = '2012-05-16', endDate = NULL WHERE SecCode = 1588769 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-05-08' WHERE SecCode = 1611823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1627735 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'mbrd', QuotePermID = 55840780378.0, PermQuoteStatus = 'AC', ExchCode = 'RTB', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-20', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1631839 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-20' WHERE SecCode = 1631899 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-06-09' WHERE SecCode = 1632047 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-05-18', PermSecMapEndDate = NULL, startDate = '2012-09-12', endDate = NULL WHERE SecCode = 1662596 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1670286 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-11' WHERE SecCode = 1673254 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BTUCL', QuotePermID = 25727307006.0, InstrPermID = 8590938555.0, PriTrdQuotePermID = NULL, PriValQuotePermID = 55839008305.0, IsPrimaryInstr = 0.0, ExchCode = 'SGO', PermSecMapStartDate = '2020-11-09', PermSecMapEndDate = NULL, startDate = '2020-11-09', endDate = NULL WHERE SecCode = 1707710 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-19', startDate = '2012-10-29' WHERE SecCode = 1740792 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-07-30' WHERE SecCode = 1929711 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-04-28' WHERE SecCode = 1947186 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1980972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1998415 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-30' WHERE SecCode = 2008417 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236798387630.0, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-01-01', PermSecMapEndDate = NULL, startDate = '2021-05-12', endDate = NULL WHERE SecCode = 2043821 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2013-04-03', endDate = '2013-04-03' WHERE SecCode = 2206946 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 2216872 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 2223846 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 2239284 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-05-18', startDate = '2013-05-16' WHERE SecCode = 2244416 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-12-05', startDate = '2021-11-19' WHERE SecCode = 2262602 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-02-09' WHERE SecCode = 2264327 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '2013-07-02' WHERE SecCode = 2270987 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2380641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2387392 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2417968 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DASAN SOLUETA KRW5000' WHERE SecCode = 2452495 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2452498 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-08-15' WHERE SecCode = 2453084 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-02-28' WHERE SecCode = 2488632 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-20' WHERE SecCode = 2499215 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2529641 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-04-01', startDate = '2014-04-22' WHERE SecCode = 2545673 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2580912 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-10' WHERE SecCode = 2582177 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TRELDFK00016', RkdTicker = 'LIDFA.E', RkdSEDOL = 'BNGWY6', RkdCUSIP = 'M6678L13', RkdRIC = 'LIDFA.IS', RkdDisplayRIC = 'LIDFA.IS', RkdCode = 87661.0, RkdIssueID = 2.0, RkdIssueCode = 132500.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'IST', RkdExchCtry = 'TUR' WHERE SecCode = 2582180 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2592376 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '538538', QuotePermID = 21544141668.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2015-09-01', PermSecMapStartDate = '2014-07-10', PermSecMapEndDate = '2015-09-01', startDate = '2014-07-10', endDate = '2015-06-03' WHERE SecCode = 2593579 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2646543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2693652 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2014-12-23', startDate = '2014-12-23' WHERE SecCode = 2745146 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2015-02-04' WHERE SecCode = 2769140 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-22' WHERE SecCode = 2774720 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2782958 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2015-03-05', PermSecMapEndDate = '2017-04-05', endDate = '2017-04-05' WHERE SecCode = 2831982 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2015-02-16' WHERE SecCode = 2837416 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 2876215 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-09', PermSecMapEndDate = '2026-07-14', startDate = '2015-04-30' WHERE SecCode = 2884543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565073418.0, InstrPermID = 21565073416.0, OrgPermID = 4295871023.0, PriValQuotePermID = 21565073418.0, PriInstrPermID = 8590923077.0, QuoteClass = 'ORD', InstrClass = 'ORD', PriTRBCIndPermID = 4294951909.0, PermQuoteRetireDate = '2015-07-15', PermOrgIPODate = '2003-03-03', PermSecMapStartDate = '2015-06-08', PermSecMapEndDate = '2015-07-15' WHERE SecCode = 2911321 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2926786 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2015-07-06', PermSecMapEndDate = '2025-09-10' WHERE SecCode = 2929651 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX59BG5' WHERE SecCode = 2930560 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21761647591.0, ExchCode = 'BER', PermQuoteRetireDate = '2022-06-13', PermSecMapStartDate = '2022-06-08', PermSecMapEndDate = '2022-06-13', startDate = '2015-07-24', endDate = '2022-06-10' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21589172352.0, ExchCode = 'FRA' WHERE SecCode = 2976573 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '539347', QuotePermID = 21572076096.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermQuoteRetireDate = '2018-01-08', PermSecMapEndDate = '2018-01-07' WHERE SecCode = 2983749 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2020-10-30', startDate = '2015-11-11' WHERE SecCode = 2998192 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2024-12-11' WHERE SecCode = 2998998 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3001070 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3010342 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040837 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2015-12-15' WHERE SecCode = 3046281 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-17' WHERE SecCode = 3049287 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-08-02', startDate = '2015-12-31' WHERE SecCode = 3056866 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3092872 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-15', startDate = '2016-02-17' WHERE SecCode = 3093751 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-03-16', startDate = '2016-02-25' WHERE SecCode = 3101137 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-20' WHERE SecCode = 3211131 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3215617 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DASAN DMC CO LTD KRW5000' WHERE SecCode = 3217947 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3233484 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247268 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-08-31', startDate = '2016-09-29' WHERE SecCode = 3247387 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2016-10-12' WHERE SecCode = 3247407 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247535 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-02-24', PermSecMapEndDate = '2022-03-02' WHERE SecCode = 3257549 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-09-17', startDate = '2016-11-01' WHERE SecCode = 3260102 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3283291 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-02-16' WHERE SecCode = 3288947 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3317677 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-05-21' WHERE SecCode = 3318944 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-06-10', startDate = '2017-05-02' WHERE SecCode = 3339539 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y2715R16' WHERE SecCode = 3339546 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-25' WHERE SecCode = 3345834 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'LK SAMYANG CO LTD KRW500' WHERE SecCode = 3358012 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-04-17', startDate = '2017-07-13' WHERE SecCode = 3376117 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '540616', QuotePermID = 21617807918.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE', PermSecMapStartDate = '2017-07-18', PermSecMapEndDate = '2020-05-26', startDate = '2017-07-18' WHERE SecCode = 3378173 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-24' WHERE SecCode = 3378902 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-07-10', startDate = '2018-07-25' WHERE SecCode = 3380814 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-07-13' WHERE SecCode = 3384114 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-04-16', startDate = '2017-09-08' WHERE SecCode = 3396301 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-11-24', startDate = '2017-04-17' WHERE SecCode = 3396310 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-05-18' WHERE SecCode = 3396343 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-11-09', startDate = '2017-04-18' WHERE SecCode = 3396346 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3396929 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-20', startDate = '2017-10-30' WHERE SecCode = 3402118 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2024-08-12' WHERE SecCode = 3407236 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-05-01', startDate = '2017-12-25' WHERE SecCode = 3407480 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-05', startDate = '2017-12-01' WHERE SecCode = 3430809 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-02', startDate = '2018-02-26' WHERE SecCode = 3437644 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-01' WHERE SecCode = 3439235 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-09-14', startDate = '2018-03-15' WHERE SecCode = 3440405 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-05-23', startDate = '2018-03-23' WHERE SecCode = 3441266 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-07-03', startDate = '2018-03-28' WHERE SecCode = 3444232 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-05-10', startDate = '2018-04-11' WHERE SecCode = 3445391 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-30' WHERE SecCode = 3446471 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-14' WHERE SecCode = 3446767 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-11-12' WHERE SecCode = 3496984 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21833146656.0, IsPrimaryQuote = 1.0, ExchCode = 'NSI' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-09-16' WHERE SecCode = 3521045 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-09-18', PermSecMapEndDate = '2025-03-06', startDate = '2018-06-15' WHERE SecCode = 3523330 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-14' WHERE SecCode = 3536039 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-05-05' WHERE SecCode = 3545217 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3588049 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-02-23', startDate = '2018-10-11' WHERE SecCode = 3619517 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'AGT', PermIDTicker = 'AGT', RkdRIC = 'AGT.AX', RkdDisplayRIC = 'AGT.AX' WHERE SecCode = 3631185 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2018-10-24' WHERE SecCode = 3635551 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-08-27', startDate = '2018-12-03' WHERE SecCode = 3661124 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-11-09', PermSecMapEndDate = '2024-12-23' WHERE SecCode = 3672936 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3703524 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-10-07', startDate = '2018-12-19' WHERE SecCode = 3706438 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-15' WHERE SecCode = 3783087 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-05-05', PermSecMapEndDate = '2022-08-01', startDate = '2019-03-05' WHERE SecCode = 3831323 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21830274264.0, PermQuoteStatus = 'AC', ExchCode = 'GTX', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 3837240 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-06-02' WHERE SecCode = 3837242 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-18' WHERE SecCode = 3863379 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2019-07-02' WHERE SecCode = 3879161 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NGHE AN PHARMA MED VND10000' WHERE SecCode = 3881142 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-10-16', startDate = '2019-07-12' WHERE SecCode = 3883663 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-16' WHERE SecCode = 3893038 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-11-02', startDate = '2019-07-16' WHERE SecCode = 3894812 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, startDate = '2020-02-21' WHERE SecCode = 3991798 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-03', startDate = '2019-11-27' WHERE SecCode = 4028389 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4036729 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 4038739 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HANOI CONSTRUCT.JS VND10000' WHERE SecCode = 4041227 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HAPRO VODKA JSC VND10000' WHERE SecCode = 4041229 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'VIETNAM LIVESTOCK VND10000' WHERE SecCode = 4041317 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-11-26' WHERE SecCode = 4043176 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7082.T^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-29', SecMapEndDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 4089894 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-03-06' WHERE SecCode = 4245391 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17', startDate = '2020-06-15' WHERE SecCode = 4259306 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-08-12', PermSecMapEndDate = '2025-12-10', startDate = '2020-06-19' WHERE SecCode = 4272300 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21698119286.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'RTB', PermQuoteRetireDate = '2023-07-07', PermSecMapStartDate = '2020-07-24', PermSecMapEndDate = '2023-10-10', endDate = '2023-07-07' WHERE SecCode = 4282342 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-05', startDate = '2020-07-06' WHERE SecCode = 4286260 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2020-07-14' WHERE SecCode = 4294110 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'VIET NAM BOOKS JSC VND10000' WHERE SecCode = 4333239 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-04-10', startDate = '2020-09-07' WHERE SecCode = 4348212 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2020-09-23' WHERE SecCode = 4365795 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21765402860.0, IsPrimaryQuote = 1.0, PermQuoteStatus = 'AC', ExchCode = 'TYO', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 4365821 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-11-18', PermSecMapEndDate = '2026-09-25' WHERE SecCode = 4366521 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01', startDate = '2020-09-25' WHERE SecCode = 4368585 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-06-24', startDate = '2020-09-28' WHERE SecCode = 4369834 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-08-03', startDate = '2020-09-30' WHERE SecCode = 4371568 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-10-13' WHERE SecCode = 4372590 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-11-15', startDate = '2020-10-15' WHERE SecCode = 4382906 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-12-01', startDate = '2020-10-15' WHERE SecCode = 4382907 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-10-03', startDate = '2020-10-19' WHERE SecCode = 4385228 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-04', startDate = '2020-10-21' WHERE SecCode = 4388154 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-02', startDate = '2020-10-21' WHERE SecCode = 4388174 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-02-09' WHERE SecCode = 4421086 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17', startDate = '2020-11-27' WHERE SecCode = 4424405 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-01-01' WHERE SecCode = 4425599 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG9877W1371', RkdSEDOL = 'BWPJ8K', RkdCUSIP = 'G9877W13' WHERE SecCode = 4434256 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-10-18', startDate = '2020-12-18' WHERE SecCode = 4446014 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-12-11', startDate = '2020-12-24' WHERE SecCode = 4452304 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-25' WHERE SecCode = 4499125 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-06-01' WHERE SecCode = 4502156 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21800722506.0, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 4511455 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4513603 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-08-29', startDate = '2021-03-09' WHERE SecCode = 4526129 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-05-11', startDate = '2021-03-18' WHERE SecCode = 4536307 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PIKA' WHERE SecCode = 4545466 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17', startDate = '2021-04-05' WHERE SecCode = 4555921 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-02-25', PermSecMapEndDate = '2023-01-18' WHERE SecCode = 4561908 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-05-20', PermSecMapEndDate = '2026-03-23', startDate = '2021-05-04' WHERE SecCode = 4578183 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-16', PermSecMapEndDate = '2025-07-14', startDate = '2021-04-30' WHERE SecCode = 4582897 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-12-11', startDate = '2021-05-06' WHERE SecCode = 4588493 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21818255206.0, IsPrimaryQuote = 1.0, ExchCode = 'ASX' WHERE SecCode = 4629512 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21632430721.0, IsPrimaryQuote = 1.0, ExchCode = 'NSI' WHERE SecCode = 4630514 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AQP', QuotePermID = 21819101343.0, IsPrimaryQuote = 1.0, ExchCode = 'CPH', PermQuoteRetireDate = '2026-02-03' WHERE SecCode = 4634346 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AURA', QuotePermID = 21823212543.0, ExchCode = 'OSL', PermQuoteRetireDate = '2025-08-26' WHERE SecCode = 4640279 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-12-12', startDate = '2021-08-16' WHERE SecCode = 4675092 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BARIA-VUNGTAU WATE VND10000' WHERE SecCode = 4695774 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DA NHIM-HAM THUAN- VND10000' WHERE SecCode = 4709534 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MASAN MEATLIFE COR VND10000' WHERE SecCode = 4709537 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'AN BINH COMMERCIAL VND10000' WHERE SecCode = 4709541 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4724733 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PYRUM', QuotePermID = 21845045449.0, ExchCode = 'OSL' WHERE SecCode = 4726082 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-15' WHERE SecCode = 4750089 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17', startDate = '2021-10-28' WHERE SecCode = 4752159 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17', startDate = '2021-11-02' WHERE SecCode = 4757838 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-21' WHERE SecCode = 4773790 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-09-04', startDate = '2021-11-18' WHERE SecCode = 4774902 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-19', startDate = '2021-11-02' WHERE SecCode = 4774913 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SIGNUP', QuotePermID = 21855983807.0, ExchCode = 'STO', PermQuoteRetireDate = '2023-06-07' WHERE SecCode = 4781670 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17' WHERE SecCode = 4784469 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '890152', QuotePermID = 21801060189.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'BSE', PermQuoteRetireDate = '2025-03-17' WHERE SecCode = 4784483 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-29', PermQuoteRetireDate = '2026-09-29', endDate = '2026-09-29' WHERE SecCode = 4790470 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-19', startDate = '2021-12-09' WHERE SecCode = 4798355 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-24' WHERE SecCode = 4800505 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-08-15', startDate = '2021-12-08' WHERE SecCode = 4800553 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-07-10', startDate = '2021-10-01' WHERE SecCode = 4807496 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-12-08', startDate = '2021-12-30' WHERE SecCode = 4821620 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17', startDate = '2022-01-10' WHERE SecCode = 4826128 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-17' WHERE SecCode = 4829186 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ABCOTS', QuotePermID = 21866151157.0, IsPrimaryQuote = 1.0, ExchCode = 'NSI' WHERE SecCode = 4829189 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-20' WHERE SecCode = 4830791 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-21' WHERE SecCode = 4832168 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-11' WHERE SecCode = 4878972 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21889613175.0, ExchCode = 'DEU' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-02-18' WHERE SecCode = 4890277 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-02-28', startDate = '2018-06-29' WHERE SecCode = 4903838 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4932395 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '543518', QuotePermID = 21875078878.0, IsPrimaryQuote = 1.0, ExchCode = 'BSE' WHERE SecCode = 4962631 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '640A', DsPrimQtSedol = 'BWNN2S1', PriInstrPermID = NULL, PermSecMapStartDate = '2026-09-17', PermSecMapEndDate = '2026-09-28', startDate = '2022-04-21', endDate = '2026-09-28' WHERE SecCode = 4969540 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-10-10', startDate = '2022-05-03' WHERE SecCode = 4970859 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21853224571.0, IsPrimaryQuote = 1.0, ExchCode = 'ASX' WHERE SecCode = 4983975 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '543519', QuotePermID = 21845375594.0, IsPrimaryQuote = 1.0, ExchCode = 'BSE' WHERE SecCode = 4985756 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VMED', QuotePermID = 21963189998.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2025-09-04', PermSecMapEndDate = '2026-01-15', endDate = '2025-09-04' WHERE SecCode = 4985764 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-05-27', startDate = '2022-05-27' WHERE SecCode = 5015946 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2022-05-25' WHERE SecCode = 5015951 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-09' WHERE SecCode = 5019011 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-05-31', PermSecMapEndDate = '2022-06-01', startDate = '2022-03-16' WHERE SecCode = 5023792 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-05-31', startDate = '2022-05-31' WHERE SecCode = 5025151 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17', startDate = '2022-06-28' WHERE SecCode = 5063447 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-09', startDate = '2022-07-11' WHERE SecCode = 5082416 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, ModelCntry = 'XH', QuotePermID = 25727191251.0, InstrPermID = 25727191252.0, OrgPermID = 5046911264.0, PriValQuotePermID = 25727191251.0, PriInstrPermID = 21804101209.0, QuoteClass = 'ORD', InstrClass = 'ORD', DomCntry = 'CHN', IncCntry = 'CHN', PriTRBCIndPermID = 4294951290.0, PermQuoteRetireDate = '2022-09-07', PermOrgIPODate = '2021-12-23', PermSecMapStartDate = '2022-08-16', PermSecMapEndDate = '2022-09-06', startDate = '2022-08-16' WHERE SecCode = 5126109 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-09-16', startDate = '2022-09-08' WHERE SecCode = 5147780 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21668607095.0, ExchCode = 'MUN', PermQuoteRetireDate = '2023-06-12', PermSecMapStartDate = '2023-06-06', PermSecMapEndDate = '2023-06-12', endDate = '2023-06-12' WHERE SecCode = 5161279 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-05-15', startDate = '2022-10-19' WHERE SecCode = 5203333 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5203344 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-02', startDate = '2022-10-18' WHERE SecCode = 5209692 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-02', startDate = '2022-11-07' WHERE SecCode = 5223424 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-11-18', startDate = '2022-11-16' WHERE SecCode = 5241267 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-11-16', PermSecMapEndDate = '2023-04-24', startDate = '2022-11-16' WHERE SecCode = 5241397 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2024-08-12' WHERE SecCode = 5260331 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5260397 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-01-27', startDate = '2022-12-19' WHERE SecCode = 5283353 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2022-12-29', startDate = '2022-12-29' WHERE SecCode = 5290246 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-01-11', startDate = '2023-01-11' WHERE SecCode = 5301199 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-03-01', startDate = '2023-02-21' WHERE SecCode = 5344601 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-02', startDate = '2023-02-23' WHERE SecCode = 5346573 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21974026078.0, ExchCode = 'DEU' WHERE SecCode = 5452246 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RAUTEN0223', QuotePermID = 236777855753.0, InstrPermID = 232809652086.0, PriValQuotePermID = 236777855753.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'HEX', PermQuoteRetireDate = '2023-06-21', startDate = '2023-06-13' WHERE SecCode = 5454694 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-12-28', startDate = '2023-07-04' WHERE SecCode = 5460498 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-30', startDate = '2023-07-14' WHERE SecCode = 5468546 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5473221 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21979547297.0, ExchCode = 'DEU' WHERE SecCode = 5481082 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-12-30', startDate = '2023-08-10' WHERE SecCode = 5493154 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-12-09' WHERE SecCode = 5521905 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-09-20', startDate = '2023-09-20' WHERE SecCode = 5527529 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-09-22', startDate = '2023-09-25' WHERE SecCode = 5536057 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-12-25', startDate = '2023-09-26' WHERE SecCode = 5536088 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2023-10-04', startDate = '2023-10-04' WHERE SecCode = 5544128 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-07-26' WHERE SecCode = 5568011 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CIENC04 GROUP JSC VND10000' WHERE SecCode = 5572148 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-11-07', startDate = '2023-12-26' WHERE SecCode = 5618933 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236780730608.0, ExchCode = 'FRA' WHERE SecCode = 5620353 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5645855 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17', startDate = '2024-02-09' WHERE SecCode = 5650584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5674192 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17', startDate = '2024-02-29' WHERE SecCode = 5677481 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5677485 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5678868 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-17', startDate = '2024-03-07' WHERE SecCode = 5679082 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-07-31', startDate = '2024-03-21' WHERE SecCode = 5697973 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5738355 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-12-02', startDate = '2024-05-02' WHERE SecCode = 5740526 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 5740743 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-11-12', startDate = '2024-06-27' WHERE SecCode = 5762104 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'XG', QuotePermID = 236784456197.0, InstrPermID = 232844798798.0, OrgPermID = 5087191471.0, PriValQuotePermID = 236784456197.0, PriInstrPermID = 232844798798.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PHS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'PHL', IncCntry = 'PHL', PriTRBCIndPermID = 1004365465.0, PermOrgIPODate = '2024-07-16', PermSecMapStartDate = '2024-07-10', startDate = '2024-07-10' WHERE SecCode = 5835880 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 5846488 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-08-28', startDate = '2024-08-13' WHERE SecCode = 5883365 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-19', startDate = '2024-07-18' WHERE SecCode = 5886906 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-10-04', startDate = '2024-09-26' WHERE SecCode = 5931892 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-11-20', startDate = '2024-11-20' WHERE SecCode = 5938453 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-06-26' WHERE SecCode = 5944529 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-06-18', startDate = '2024-10-28' WHERE SecCode = 5969252 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'KLS' WHERE SecCode = 5969257 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-10-29', startDate = '2024-10-28' WHERE SecCode = 5969259 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-10-28', startDate = '2024-10-28' WHERE SecCode = 5972463 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-12-08', PermSecMapEndDate = '2025-12-11' WHERE SecCode = 5974293 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2024-12-17', startDate = '2024-12-16' WHERE SecCode = 6041236 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-03', PermSecMapEndDate = '2025-04-29', startDate = '2025-01-03' WHERE SecCode = 6056873 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-19', startDate = '2024-12-30' WHERE SecCode = 6056887 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-13', startDate = '2025-01-13' WHERE SecCode = 6074811 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-16', startDate = '2025-01-14' WHERE SecCode = 6075862 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-01-27', startDate = '2025-01-27' WHERE SecCode = 6101734 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-21', startDate = '2025-02-21' WHERE SecCode = 6144899 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-28', startDate = '2025-02-28' WHERE SecCode = 6153865 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-18', startDate = '2025-03-18' WHERE SecCode = 6186410 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6190838 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-11-19', PermSecMapEndDate = '2025-11-25' WHERE SecCode = 6281752 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-06-29' WHERE SecCode = 6300525 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-30', startDate = '2025-06-16' WHERE SecCode = 6322256 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-19', startDate = '2025-07-18' WHERE SecCode = 6375311 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-08-06', startDate = '2025-08-06' WHERE SecCode = 6400769 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-19', startDate = '2025-09-15' WHERE SecCode = 6403494 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-19', startDate = '2025-09-15' WHERE SecCode = 6453918 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-09-19', startDate = '2025-09-19' WHERE SecCode = 6464955 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-09-30', startDate = '2025-09-30' WHERE SecCode = 6478334 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-10-10', startDate = '2025-10-10' WHERE SecCode = 6495234 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-12-04', startDate = '2025-11-13' WHERE SecCode = 6551070 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-13', startDate = '2025-11-20' WHERE SecCode = 6562598 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-05-04', startDate = '2025-11-19' WHERE SecCode = 6562602 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6590947 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-12-12', startDate = '2025-12-12' WHERE SecCode = 6596072 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2025-12-09', startDate = '2025-12-09' WHERE SecCode = 6598773 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-03-30', startDate = '2025-12-16' WHERE SecCode = 6603583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6608218 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6645652 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236802980063.0, IsPrimaryQuote = 1.0, ExchCode = 'NSI' WHERE SecCode = 6667827 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NX1', QuotePermID = 21600998619.0, InstrPermID = 21600835128.0, OrgPermID = 5052530544.0, PriValQuotePermID = 21600998619.0, PriInstrPermID = 21600835128.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'ASX', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', OrgTypeCode = 'COM', DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = 4294951265.0, PermOrgIPODate = '2017-01-11', PermSecMapStartDate = '2026-02-16' WHERE SecCode = 6667908 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236802980062.0, IsPrimaryQuote = 1.0, ExchCode = 'NSI' WHERE SecCode = 6668263 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '507A', QuotePermID = 236802773533.0, InstrPermID = 232919985703.0, OrgPermID = 4295953454.0, PriValQuotePermID = 236802773533.0, PriInstrPermID = 232919985703.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TYO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'JPN', IncCntry = 'JPN', PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = '2026-02-20', PermSecMapStartDate = '2026-02-09', startDate = '2026-02-09' WHERE SecCode = 6678533 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '506A', QuotePermID = 236802773528.0, InstrPermID = 232920192726.0, OrgPermID = 6000024729.0, PriValQuotePermID = 236802773528.0, PriInstrPermID = 232920192726.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TYO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'JPN', IncCntry = 'JPN', PermOrgIPODate = '2026-02-20', PermSecMapStartDate = '2026-02-09', startDate = '2026-02-09' WHERE SecCode = 6678534 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236803482561.0, InstrPermID = 232922859145.0, OrgPermID = 5085522834.0, PriValQuotePermID = 236803482561.0, PriInstrPermID = 232865585469.0, IncCntry = 'CHN', PriTRBCIndPermID = 4294951833.0, PermQuoteRetireDate = '2026-04-10', PermOrgIPODate = '2025-10-10', PermSecMapStartDate = '2026-02-26', PermSecMapEndDate = '2026-04-09', startDate = '2026-02-26' WHERE SecCode = 6694372 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '7489', QuotePermID = 236803097844.0, InstrPermID = 232921108711.0, OrgPermID = 5083639472.0, PriValQuotePermID = 236803097844.0, PriInstrPermID = 232921108711.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CHN', IncCntry = 'CHN', PriTRBCIndPermID = 4294951705.0, PermOrgIPODate = '2026-03-19', PermSecMapStartDate = '2026-02-16', startDate = '2026-02-16' WHERE SecCode = 6727823 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-04-06', startDate = '2026-04-06' WHERE SecCode = 6768845 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BAO THANG TRAN JTC VND10000' WHERE SecCode = 6806187 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000471070', RkdTicker = 'NHU', RkdSEDOL = 'BWM20M', RkdCUSIP = 'Q6644Q10', RkdRIC = 'NHU.AX', RkdDisplayRIC = 'NHU.AX', RkdCode = 145636.0, RkdIssueID = 1.0, RkdIssueCode = 186481.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6941636 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-06' WHERE SecCode = 6960490 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-16', startDate = '2026-07-16' WHERE SecCode = 7006700 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-30', startDate = '2026-07-30' WHERE SecCode = 7034012 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-07-31', startDate = '2026-07-31' WHERE SecCode = 7044709 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-08-17', startDate = '2026-08-17' WHERE SecCode = 7053203 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-09-25', PermSecMapEndDate = '2026-09-27', endDate = '2026-09-25' WHERE SecCode = 7067509 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-09-21', startDate = '2026-09-21' WHERE SecCode = 7116171 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2026-09-15', startDate = '2026-09-15' WHERE SecCode = 7121864 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '1999-07-02', endDate = '2000-01-19' WHERE SecCode = 10776137 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LSTZB', QuotePermID = 55854529529.0, InstrPermID = 8591406350.0, OrgPermID = 5001440558.0, PriTrdQuotePermID = NULL, PriValQuotePermID = 55853747064.0, PriInstrPermID = 8589979818.0, IsPrimaryQuote = 0.0, ExchCode = 'GCZ', PriTRBCIndPermID = 4294951555.0, PermQuoteRetireDate = '2011-11-29', PermOrgIPODate = NULL, PermSecMapStartDate = '2009-11-20', PermSecMapEndDate = '2011-11-29', endDate = '2011-11-28' WHERE SecCode = 10923767 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ESNSF', QuotePermID = 55835387326.0, IsPrimaryQuote = 0.0, ExchCode = 'PNK', PermQuoteRetireDate = '2011-10-04', PermSecMapStartDate = '2007-05-23', PermSecMapEndDate = '2011-10-04', startDate = '2000-10-10' WHERE SecCode = 10924399 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2009-12-10', startDate = '2009-12-10' WHERE SecCode = 10925298 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2022-09-20', PermSecMapEndDate = '2023-12-21', startDate = '2010-05-27' WHERE SecCode = 10961514 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 10963994 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2010-10-07' WHERE SecCode = 10970877 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25727261302.0, ExchCode = 'PNK' WHERE SecCode = 10972929 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-01' WHERE SecCode = 10986427 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11002751 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2011-06-23' WHERE SecCode = 11004560 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-11' WHERE SecCode = 11009770 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-23' WHERE SecCode = 11024317 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-26', endDate = '2026-09-26' WHERE SecCode = 11026378 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11026489 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-07-04' WHERE SecCode = 11029836 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2017-07-18' WHERE SecCode = 11034344 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-10-03' WHERE SecCode = 11034504 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 44653934253.0, ExchCode = 'BTY' WHERE SecCode = 11035687 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 46660755154.0, ExchCode = 'BAT', PermQuoteRetireDate = '2017-11-17', endDate = '2017-11-16' WHERE SecCode = 11036019 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11046298 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2013-08-20' WHERE SecCode = 11069908 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2016-09-22' WHERE SecCode = 11070054 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'I PR A', QuotePermID = 21522359826.0, InstrPermID = 44647151634.0, OrgPermID = 5037477697.0, PriTrdQuotePermID = 21522359826.0, PriValQuotePermID = 21522359802.0, PriInstrPermID = 21475802721.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'NYS', QuoteClass = 'PREFERRED', InstrClass = 'PREFERRED', OrgTypeCode = 'COM', DomCntry = 'LUX', IncCntry = 'LUX', PriTRBCIndPermID = 4294951782.0, PermQuoteRetireDate = '2016-05-02', PermSecMapStartDate = '2013-04-18', PermSecMapEndDate = '2016-05-02' WHERE SecCode = 11072783 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-10-03' WHERE SecCode = 11078064 AND Type_ = 1;
UPDATE data_universe SET Name = 'TRINITY SILVER CORP COM SHS', PermSecMapEndDate = '2026-09-26', endDate = '2026-09-26' WHERE SecCode = 11079081 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2013-12-04', startDate = '2013-12-04' WHERE SecCode = 11108368 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2024-01-03' WHERE SecCode = 11112583 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2024-01-03' WHERE SecCode = 11112811 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US30329Y4035', RkdTicker = 'FGC', PermIDTicker = 'FGC', RkdSEDOL = 'BT3F63', RkdCUSIP = '30329Y40', RkdRIC = 'FGC.O', RkdDisplayRIC = 'FGC.OQ', Name = 'FG COMMUNITIES HOLDINGS INC COM NEW', RkdCode = 96730.0, RkdIssueID = 1.0, RkdIssueCode = 121971.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11128101 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-26', endDate = '2026-09-26' WHERE SecCode = 11128630 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2024-05-24' WHERE SecCode = 11128701 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-17' WHERE SecCode = 11129839 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2024-10-01' WHERE SecCode = 11136493 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 46660755599.0, ExchCode = 'ASE' WHERE SecCode = 11142439 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 46660756335.0, ExchCode = 'ASE' WHERE SecCode = 11144267 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '2020-10-08' WHERE SecCode = 11148470 AND Type_ = 1;
UPDATE data_universe SET DsSecDelistDate = NULL, endDate = NULL WHERE SecCode = 11150246 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 11151337 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXFGJF1' WHERE SecCode = 11154062 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2017-12-28', startDate = '2015-12-14' WHERE SecCode = 11154987 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, endDate = '2021-01-28' WHERE SecCode = 11156076 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2016-05-18' WHERE SecCode = 11158964 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '2016-08-09' WHERE SecCode = 11161497 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2017-08-03', startDate = '2016-09-02' WHERE SecCode = 11162056 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2016-10-15' WHERE SecCode = 11163308 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2017-12-28', startDate = '2016-12-19' WHERE SecCode = 11165916 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-09-25', PermQuoteRetireDate = '2026-09-28', PermSecMapEndDate = '2026-09-28', endDate = '2026-09-25' WHERE SecCode = 11169287 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-09-25', PermQuoteRetireDate = '2026-09-28', PermSecMapEndDate = '2026-09-28', endDate = '2026-09-25' WHERE SecCode = 11174853 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-24' WHERE SecCode = 11177953 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-09-25', PermQuoteRetireDate = '2026-09-28', PermSecMapEndDate = '2026-09-28', endDate = '2026-09-25' WHERE SecCode = 11179294 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2023-10-26', PermSecMapEndDate = '2024-02-06' WHERE SecCode = 11179704 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-02-27' WHERE SecCode = 11180340 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US30329Y2054', RkdTicker = 'FGCPP', PermIDTicker = 'FGCPP', RkdSEDOL = 'BQ749L', RkdCUSIP = '30329Y20', RkdRIC = 'FGCPP.O', RkdDisplayRIC = 'FGCPP.OQ', Name = 'FG COMMUNITIES HOLDINGS INC 8% PFD SER A', RkdCode = 96730.0, RkdIssueID = 2.0, RkdIssueCode = 146839.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11181095 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2024-08-12' WHERE SecCode = 11184700 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'HOM.UN', QuotePermID = 25727370753.0, ExchCode = 'TOR', PermSecMapStartDate = '2019-06-07', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11185516 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2018-06-29', PermSecMapEndDate = '2019-12-19', startDate = '2018-06-28' WHERE SecCode = 11186840 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-02-16' WHERE SecCode = 11191442 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11195311 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11195616 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA7566783063', RkdTicker = 'RGLD', RkdSEDOL = 'C08GD6', RkdCUSIP = '75667830', RkdRIC = 'RGLD.CD', RkdDisplayRIC = 'RGLD.CD', RkdCode = 115610.0, RkdIssueID = 1.0, RkdIssueCode = 145421.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN' WHERE SecCode = 11199084 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2020-03-07', startDate = '2019-11-07' WHERE SecCode = 11201893 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US91823B1098', RkdTicker = 'UWMC RTWI', RkdSEDOL = 'BXFGJL', RkdCUSIP = '91823B10', RkdRIC = 'UWMC.K', RkdDisplayRIC = 'UWMC_r_w.N', RkdCode = 121408.0, RkdIssueID = 3.0, RkdIssueCode = 155325.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 11206247 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2019-07-29', startDate = '2019-07-29' WHERE SecCode = 11206707 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2020-07-09', PermSecMapEndDate = '2021-09-30', startDate = '2020-07-09' WHERE SecCode = 11209868 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25727295584.0, ExchCode = 'PNK' WHERE SecCode = 11210196 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2021-10-21' WHERE SecCode = 11210734 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2020-08-06', endDate = '2020-08-06' WHERE SecCode = 11210766 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-10-31' WHERE SecCode = 11213861 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2021-08-25', endDate = '2021-08-25' WHERE SecCode = 11214198 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2020-10-30', PermSecMapEndDate = '2021-08-16', startDate = '2020-10-30' WHERE SecCode = 11214280 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2021-11-21', startDate = '2020-11-24' WHERE SecCode = 11215249 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2020-12-02', startDate = '2020-12-02' WHERE SecCode = 11215652 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2021-12-10' WHERE SecCode = 11215722 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriTrdQuotePermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermQuoteRetireDate = NULL, PermSecMapStartDate = NULL, PermSecMapEndDate = NULL, startDate = '2020-12-17' WHERE SecCode = 11216359 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2021-01-22', startDate = '2021-01-22' WHERE SecCode = 11217857 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2023-05-18' WHERE SecCode = 11220020 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-07-22' WHERE SecCode = 11221178 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-01-08' WHERE SecCode = 11221406 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2023-05-18' WHERE SecCode = 11222676 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25727261304.0, ExchCode = 'PNK' WHERE SecCode = 11224253 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXFGD04' WHERE SecCode = 11226190 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-26', endDate = '2026-09-26' WHERE SecCode = 11226614 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365447.0 WHERE SecCode = 11226962 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2022-03-16' WHERE SecCode = 11227194 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-14' WHERE SecCode = 11227876 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2022-08-29' WHERE SecCode = 11228089 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-12-05' WHERE SecCode = 11228574 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-14' WHERE SecCode = 11228590 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-14' WHERE SecCode = 11228591 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-14' WHERE SecCode = 11229231 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXFGD15' WHERE SecCode = 11234992 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-14', startDate = '2021-10-05' WHERE SecCode = 11235445 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-14' WHERE SecCode = 11235551 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-14' WHERE SecCode = 11235561 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-14' WHERE SecCode = 11235581 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-26', endDate = '2026-09-26' WHERE SecCode = 11236809 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-14', startDate = '2022-01-26' WHERE SecCode = 11238018 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXFGCZ2' WHERE SecCode = 11240122 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000363307.0, PriInstrPermID = 25727191998.0, DomCntry = 'HKG', PriTRBCIndPermID = 4294951705.0 WHERE SecCode = 11242842 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-03-13', startDate = '2022-07-26' WHERE SecCode = 11244098 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2022-07-26', startDate = '2022-07-26' WHERE SecCode = 11244190 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-14' WHERE SecCode = 11245826 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25727195245.0, ExchCode = 'TOR' WHERE SecCode = 11245859 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-04-02' WHERE SecCode = 11248321 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 47768289156.0, ExchCode = 'TXE' WHERE SecCode = 11252887 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-26', endDate = '2026-09-26' WHERE SecCode = 11255869 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-26', endDate = '2026-09-26' WHERE SecCode = 11256200 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236781181555.0, ExchCode = 'XMG' WHERE SecCode = 11261205 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2025-02-07' WHERE SecCode = 11262359 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 47768288296.0, ExchCode = 'TXE' WHERE SecCode = 11266183 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'A', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-28', PermSecMapEndDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 11268483 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-11-26', startDate = '2024-11-26' WHERE SecCode = 11271847 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2024-12-04', startDate = '2024-12-04' WHERE SecCode = 11272074 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ALZ', QuotePermID = 236797575614.0, InstrPermID = 232869223062.0, OrgPermID = 4295870171.0, PriValQuotePermID = 236797575614.0, PriInstrPermID = 8590928697.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'DEU', IncCntry = 'DEU', PriTRBCIndPermID = 4294951347.0, PermOrgIPODate = '1895-12-12', PermSecMapStartDate = '2025-10-16' WHERE SecCode = 11274491 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-09-25', PermQuoteRetireDate = '2026-09-28', PermSecMapEndDate = '2026-09-28', endDate = '2026-09-25' WHERE SecCode = 11274903 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-26', endDate = '2026-09-26' WHERE SecCode = 11275238 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951816.0 WHERE SecCode = 11275439 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GOW', RkdSEDOL = 'BXFGFT', Name = 'GOWELL ENERGY TECHNOLOGY ORD SHS', PermSecMapEndDate = '2026-09-28', endDate = '2026-09-28' WHERE SecCode = 11275867 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951816.0 WHERE SecCode = 11277492 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-26', endDate = '2026-09-26' WHERE SecCode = 11280356 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXFGCY1' WHERE SecCode = 11286201 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NOVO', QuotePermID = 236799047741.0, InstrPermID = 232906585800.0, OrgPermID = 4295865996.0, PriValQuotePermID = 236799047741.0, PriInstrPermID = 8590939933.0, DomCntry = 'DNK', IncCntry = 'DNK', PriTRBCIndPermID = 4294951272.0, PermOrgIPODate = '1974-05-17' WHERE SecCode = 11288489 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 47763235542.0, IsPrimaryQuote = 1.0, ExchCode = 'NSM' WHERE SecCode = 11291210 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 11299498 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG370731062', RkdTicker = 'FWAC', RkdSEDOL = 'BNYHT0', RkdCUSIP = 'G3707310', RkdRIC = 'FWAC.O', RkdDisplayRIC = 'FWAC.OQ', RkdCode = 144843.0, RkdIssueID = 1.0, RkdIssueCode = 185233.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11299932 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-09-22' WHERE SecCode = 11302031 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BRRKU', Name = 'BLUEROCK ACQUISITION CORP II UNIT 09/22/2031', QuotePermID = 236811322713.0, InstrPermID = 232947349597.0, OrgPermID = 6000215555.0, PriTrdQuotePermID = 236811322713.0, PriValQuotePermID = 25726995782.0, PriInstrPermID = 232947349597.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-09-25', PermSecMapStartDate = '2026-09-25' WHERE SecCode = 11302302 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PNAQ', QuotePermID = 236814955910.0, InstrPermID = 232932832728.0, OrgPermID = 6000209444.0, PriTrdQuotePermID = 236814955910.0, PriValQuotePermID = 25726988848.0, PriInstrPermID = 232932832728.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PermOrgIPODate = '2026-08-07', PermSecMapStartDate = '2026-09-22', startDate = '2026-08-07' WHERE SecCode = 11302303 AND Type_ = 1;