UPDATE data_universe SET PermIDTicker = 'ATVAM.NL', QuotePermID = 21475526227.0, ExchCode = 'PLU', PermQuoteRetireDate = '2009-02-06' WHERE SecCode = 364 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BEYi', QuotePermID = 21715145964.0, ExchCode = 'AQX', PermQuoteRetireDate = '2023-11-10', endDate = '2023-07-14' WHERE SecCode = 1807 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475442988.0, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US04638F1084', RkdSEDOL = '206035', RkdCUSIP = '04638F10', RkdRIC = 'ALOT.OQ^H26', RkdDisplayRIC = 'ALOT.OQ', RkdCode = 379.0, RkdIssueID = 1.0, RkdIssueCode = 367.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 6892 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVDBT32' WHERE SecCode = 10042 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475450491.0, ExchCode = 'SGO' WHERE SecCode = 28192 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838830951.0, ExchCode = 'SGO' WHERE SecCode = 28657 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 30615 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US3976242061', RkdTicker = 'GEF B', RkdSEDOL = '239408', RkdCUSIP = '39762420', RkdRIC = 'GEFb', RkdDisplayRIC = 'GEFb.N', RkdCode = 10848.0, RkdIssueID = 2.0, RkdIssueCode = 14992.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 2.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 31364 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ANFp', QuotePermID = 21475800397.0, ExchCode = 'SIG', PermQuoteRetireDate = '2012-12-10', endDate = '2012-12-10' WHERE SecCode = 33925 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'WLV2', QuotePermID = 55838646696.0, ExchCode = 'STU', PermQuoteRetireDate = '2015-07-08' WHERE SecCode = 34242 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21552519273.0, ExchCode = 'DUS' WHERE SecCode = 35642 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BIB', QuotePermID = 21475512051.0, ExchCode = 'HAN', PermQuoteRetireDate = '2007-09-12' WHERE SecCode = 35717 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21523788483.0, ExchCode = 'BTE' WHERE SecCode = 35857 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475422364.0, ExchCode = 'HAN', PermQuoteRetireDate = '2004-04-23', endDate = '2004-04-23' WHERE SecCode = 36125 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MPC OCEANIC GROUP NPV' WHERE SecCode = 41470 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'INVN', QuotePermID = 21475591259.0, ExchCode = 'SWX', PermQuoteRetireDate = '2009-04-09', endDate = '2009-04-08' WHERE SecCode = 42094 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'IAW_I.TQ', QuotePermID = 21475522580.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2008-08-21' WHERE SecCode = 42203 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-08' WHERE SecCode = 42719 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'DE0005556112', RkdTicker = 'GRP1', RkdSEDOL = '769679', RkdCUSIP = 'D2874A10', RkdRIC = 'GRPG.MU^J03', RkdDisplayRIC = 'GRPGk.F', RkdCode = 28900.0, RkdIssueID = 1.0, RkdIssueCode = 39562.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'MNC', RkdExchCtry = 'DEU' WHERE SecCode = 44555 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55842440800.0, ExchCode = 'CHI', PermQuoteRetireDate = '2012-05-04', endDate = '2012-05-04' 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 QuotePermID = 55836518194.0, ExchCode = 'FRA' WHERE SecCode = 46439 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21526380627.0, ExchCode = 'BTE' WHERE SecCode = 47172 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475389822.0, ExchCode = 'FRA' WHERE SecCode = 47266 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21830308575.0, ExchCode = 'GTX' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475085642.0, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13', endDate = '2014-01-13' WHERE SecCode = 49244 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836324566.0, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475422916.0, ExchCode = 'FRA', PermQuoteRetireDate = '2002-08-26', PermSecMapEndDate = '2002-08-26', endDate = '2002-08-22' WHERE SecCode = 60880 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PSFm', QuotePermID = 21478541730.0, ExchCode = 'EQD', PermQuoteRetireDate = '2017-02-03', endDate = '2017-02-03' WHERE SecCode = 62335 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 67667 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 67697 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 69272 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 69942 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 DsCtryQtStatus = 'A' WHERE SecCode = 74250 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75398 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 75416 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 RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '0007.HK^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-09', SecMapEndDate = '2026-09-08', PermQuoteRetireDate = '2026-09-09', PermSecMapEndDate = '2026-09-08', endDate = '2026-09-08' WHERE SecCode = 77609 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BILLIONS CO LTD KRW2500' WHERE SecCode = 78933 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BLUE STAR INFOTECH INR10' WHERE SecCode = 79420 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BMG8571C2643', RkdSEDOL = 'BX7YSQ', RkdCUSIP = 'G8571C26' WHERE SecCode = 80202 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 81438 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 82108 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 82146 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'PRITISH NANDY COMM INR10' WHERE SecCode = 82653 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 83142 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-09' WHERE SecCode = 83525 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 84719 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 84973 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 PermSecMapEndDate = '2026-09-08' WHERE SecCode = 89953 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-09', SecMapEndDate = '2001-12-10', PermQuoteRetireDate = '2026-09-09', endDate = '2001-12-10' WHERE SecCode = 90579 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90657 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 92181 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94485 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 RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 97525 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 99138 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 99172 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-09', SecMapEndDate = '2026-09-08', PermQuoteRetireDate = '2026-09-09', endDate = '2026-09-08' WHERE SecCode = 100179 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55838225427.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-01-27', endDate = '2014-01-17' WHERE SecCode = 113625 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-07', SecMapEndDate = '2026-09-07', PermQuoteRetireDate = '2026-09-07', PermSecMapEndDate = '2026-09-08', endDate = '2026-09-07' WHERE SecCode = 114808 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 119591 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 121149 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 127092 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 132080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 133195 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 135763 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 146140 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21738226557.0, ExchCode = 'STU', PermQuoteRetireDate = '2023-02-21', endDate = '2023-02-21' WHERE SecCode = 177474 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836333820.0, ExchCode = 'BER' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55842328665.0, ExchCode = 'MUN' WHERE SecCode = 184361 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21798248748.0, ExchCode = 'DEU' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DOCK', QuotePermID = 55838811238.0, ExchCode = 'OSL', PermQuoteRetireDate = '2013-05-06', endDate = '2013-04-22' WHERE SecCode = 196096 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 255424 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 258786 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 258792 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CCC', QuotePermID = 21475481804.0, ExchCode = 'AEX', PermQuoteRetireDate = '2008-05-27' WHERE SecCode = 300582 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 302310 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 302433 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 317598 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 383497 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 396138 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236792907732.0, ExchCode = 'GER' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 450695 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 521135 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 550827 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 692769 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 898133 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'PLCSYSA00016', RkdTicker = 'AXN', RkdSEDOL = 'B3PML2', RkdCUSIP = 'X1805L10', RkdRIC = 'AXNP.WA', RkdDisplayRIC = 'AXNP.WA', RkdCode = 116748.0, RkdIssueID = 1.0, RkdIssueCode = 147097.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'WAR', RkdExchCtry = 'POL' WHERE SecCode = 925527 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 933424 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CAPITAL B EUR0.8(POST CONSOLIDATION)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1178962 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1316139 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'POLYl', QuotePermID = 21481777624.0, ExchCode = 'QMF', PermQuoteRetireDate = '2014-01-13', endDate = '2014-01-13' WHERE SecCode = 1453952 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21535814878.0, ExchCode = 'AQS', PermQuoteRetireDate = '2025-09-30', endDate = '2025-09-29' WHERE SecCode = 1472965 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21491231424.0, ExchCode = 'OSL' WHERE SecCode = 1534902 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 1641430 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21513762384.0, ExchCode = 'SIG', PermQuoteRetireDate = '2022-09-29', endDate = '2020-07-14' WHERE SecCode = 1699140 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2065778 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '1219', QuotePermID = 21529228932.0, ExchCode = 'IXH', PermQuoteRetireDate = '2013-10-18', endDate = '2013-10-18' WHERE SecCode = 2343144 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2373426 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21530936903.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2025-06-02' WHERE SecCode = 2373427 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BFG35570', RkdTicker = 'EUSP', RkdSEDOL = 'BFG355', RkdCUSIP = 'G3209S10', RkdRIC = 'EUSPP.L^G19', RkdDisplayRIC = 'EUSPP.L', RkdCode = 95920.0, RkdIssueID = 1.0, RkdIssueCode = 120942.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SEA', RkdExchCtry = 'GBR' WHERE SecCode = 2399379 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21634375087.0, ExchCode = 'BTE', PermQuoteRetireDate = '2018-10-19' WHERE SecCode = 2438937 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21575044691.0, ExchCode = 'BTE', PermQuoteRetireDate = '2021-09-01', endDate = '2021-09-01' WHERE SecCode = 2441640 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2462091 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21543091461.0, ExchCode = 'BTE', PermQuoteRetireDate = '2015-06-23' WHERE SecCode = 2530826 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2533380 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2595744 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-09', SecMapEndDate = '2026-09-08', PermQuoteRetireDate = '2026-09-09', endDate = '2026-09-08' WHERE SecCode = 2614226 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'COSAN LOGISTICA SA COM NPV' WHERE SecCode = 2644142 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21560879167.0, ExchCode = 'STU' WHERE SecCode = 2855772 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DE000A1MMEV4', RkdTicker = 'GTH', RkdSEDOL = 'BYM68X', RkdCUSIP = 'D2R78K10', RkdRIC = 'GTHn.DE', RkdDisplayRIC = 'GTHn.DE', RkdCode = 103688.0, RkdIssueID = 1.0, RkdIssueCode = 130421.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ETR', RkdExchCtry = 'DEU' WHERE SecCode = 2932355 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FORTALE*', QuotePermID = 21667704657.0, ExchCode = 'MXQ' WHERE SecCode = 2934154 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'JIYA ECO-PRODUCTS INR100 ( POST CONS)' WHERE SecCode = 2938936 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2959530 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 2961761 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21589220364.0, ExchCode = 'DEU' WHERE SecCode = 2976573 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21614525595.0, ExchCode = 'TDG' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3005679 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3009093 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3011192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3018641 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3037819 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3049345 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3051792 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3051797 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3067181 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3087022 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3113761 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3133501 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931857.0, ExchCode = 'BTE', PermQuoteRetireDate = '2018-06-18' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3162862 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3172341 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3213023 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3234669 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3242484 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21596783867.0, ExchCode = 'CHI', PermQuoteRetireDate = '2025-11-17' WHERE SecCode = 3247374 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21597039974.0, ExchCode = 'BER' WHERE SecCode = 3247790 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21598409222.0, ExchCode = 'DEU' WHERE SecCode = 3260114 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3275685 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-08' WHERE SecCode = 3283798 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3283859 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3283969 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3295160 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX', PermQuoteRetireDate = '2022-10-03', endDate = '2022-10-03' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3347459 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3347763 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3382226 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3392350 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3393831 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3395184 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3401731 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3402856 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3407187 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3435135 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858705514.0, ExchCode = 'STU', PermQuoteRetireDate = '2024-01-04' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3441470 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3445582 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3445583 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NGIL', QuotePermID = 25727169919.0, ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21654874247.0, ExchCode = 'BTE', PermQuoteRetireDate = '2022-04-01' WHERE SecCode = 3537067 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3586927 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3588090 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3612339 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3750914 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3799576 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3812315 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LGRS', QuotePermID = 21689477071.0, ExchCode = 'LSE', PermQuoteRetireDate = '2025-02-12' WHERE SecCode = 3818837 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-09', SecMapEndDate = '2025-09-08', PermQuoteRetireDate = '2026-09-09', PermSecMapEndDate = '2026-09-08', endDate = '2025-09-08' WHERE SecCode = 3827947 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3881129 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 3961764 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 DsCtryQtStatus = 'A' WHERE SecCode = 4010770 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4041277 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4054102 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4060785 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4201683 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4273937 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4286258 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 COATypeCode = '' WHERE SecCode = 4310593 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4313231 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4335862 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21774178677.0, ExchCode = 'BCO', PermQuoteRetireDate = '2026-03-20' WHERE SecCode = 4338899 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4339145 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4341610 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21910570378.0, PermQuoteStatus = 'DC', ExchCode = 'CHJ', PermQuoteRetireDate = '2025-09-04', endDate = '2025-09-04' WHERE SecCode = 4365821 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MOBIDAYS INC KRW2500' WHERE SecCode = 4495552 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236777414895.0, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2026-04-27' WHERE SecCode = 4511455 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4557733 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 COATypeCode = '' WHERE SecCode = 4603473 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4615787 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4615788 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4639757 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4641474 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4682756 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4724707 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PYRUM', QuotePermID = 21845045449.0, ExchCode = 'OSL' WHERE SecCode = 4726082 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4728954 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TMTA', QuotePermID = 21848078189.0, ExchCode = 'LSE', PermQuoteRetireDate = '2024-03-07' WHERE SecCode = 4735056 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4746790 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CLUB DE FUTBOL INT EUR0.01' WHERE SecCode = 4759584 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4800505 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-09-23' WHERE SecCode = 4806550 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236799369659.0, ExchCode = 'CHI' WHERE SecCode = 4815279 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236777414965.0, ExchCode = 'AQE', PermQuoteRetireDate = '2023-06-09' WHERE SecCode = 4865336 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4893249 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4897803 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 4940655 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'Z3N0', QuotePermID = 236790283796.0, ExchCode = 'FRA' WHERE SecCode = 4989623 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5035049 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5168288 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5223194 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5283335 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5316691 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CREG', QuotePermID = 21953622157.0, ExchCode = 'MIL' WHERE SecCode = 5354972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5410102 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5443484 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21974026078.0, ExchCode = 'DEU' WHERE SecCode = 5452246 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21974977007.0, ExchCode = 'DEU' WHERE SecCode = 5457246 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21979863375.0, ExchCode = 'DEU' WHERE SecCode = 5482616 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5525177 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5601206 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22007599680.0, ExchCode = 'DEU' WHERE SecCode = 5620353 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5632198 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5658429 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951945.0 WHERE SecCode = 5678883 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5686525 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5904440 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5940212 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5981831 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5981833 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5987986 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5987988 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5988063 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5996598 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 5999070 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6039879 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 6092922 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6203257 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6383728 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 6418147 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BASK39', QuotePermID = 236796236834.0, InstrPermID = 232892866328.0, OrgPermID = 5066622518.0, PriValQuotePermID = 236796236834.0, PriInstrPermID = 21684483875.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SAO', QuoteClass = 'BDR', InstrClass = 'BDR', OrgTypeCode = 'COM', DomCntry = 'CHE', IncCntry = 'CHE', PriTRBCIndPermID = 1004365393.0, PermSecMapStartDate = '2025-09-22', startDate = '2025-09-22' WHERE SecCode = 6472077 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6538858 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6578038 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6645652 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6699549 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'JP3051220006', RkdTicker = '509A', RkdSEDOL = 'BTTPQZ', RkdCUSIP = 'J1769U10', RkdRIC = '509A.T', RkdDisplayRIC = '509A.T', RkdCode = 145472.0, RkdIssueID = 1.0, RkdIssueCode = 186231.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TYO', RkdExchCtry = 'JPN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6708242 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6728353 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6755622 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6755623 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6755624 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6756397 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6806143 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6806170 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6806193 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6813227 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6846841 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6887836 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6930668 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6937617 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6939101 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6939106 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6941637 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6945360 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6948298 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6957660 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6967198 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6967201 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6977549 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6985946 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6989185 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 6997056 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 7000372 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7006693 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7006701 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7006703 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7009112 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-09', endDate = '2026-09-09' WHERE SecCode = 7025885 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-09', SecMapEndDate = '2026-09-08', PermSecMapEndDate = '2026-09-08', endDate = '2026-09-08' WHERE SecCode = 7034017 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7040613 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7044192 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7044707 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7050896 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007WT4', RkdCUSIP = 'Y9910G10' WHERE SecCode = 7055217 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7055221 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7058577 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7061740 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7061742 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7064157 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7067499 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7067656 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7075702 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7077875 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7077877 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7080319 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7080326 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-09-03', startDate = '2026-08-31' WHERE SecCode = 7080407 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE19FR01012', RkdTicker = 'ASHUTOSH', RkdSEDOL = 'BVPW7G', RkdCUSIP = 'Y0269K10', RkdRIC = 'ASHH.NS', RkdDisplayRIC = 'ASHH.NS', RkdCode = 145478.0, RkdIssueID = 1.0, RkdIssueCode = 186239.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NSE', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 7088929 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7088931 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 7088935 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA38076G5095', RkdTicker = 'AUXX', RkdSEDOL = 'BRJHZ2', RkdCUSIP = '38076G50', RkdRIC = 'AUXX.V', RkdDisplayRIC = 'AUXX.V', RkdCode = 83341.0, RkdIssueID = 1.0, RkdIssueCode = 105021.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN' WHERE SecCode = 10978767 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 10980509 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA3927631083', RkdTicker = 'GCUC', RkdSEDOL = 'BVDBY7', RkdCUSIP = '39276310', RkdRIC = 'GCUC.V', RkdDisplayRIC = 'GCUC.V', RkdCode = 83960.0, RkdIssueID = 1.0, RkdIssueCode = 105830.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN', IsPrimaryInstr = 0.0 WHERE SecCode = 10989428 AND Type_ = 1;
UPDATE data_universe SET Name = 'ARC MINERAL ROYALTIES LTD COM NEW', PermSecMapEndDate = '2026-09-08', endDate = '2026-09-08' WHERE SecCode = 11022365 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11178978 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11192828 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXXNMS8' WHERE SecCode = 11194816 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US23255M3034', RkdTicker = 'KRSA', RkdSEDOL = 'BVDBY8', RkdCUSIP = '23255M30', RkdRIC = 'KRSA.O', RkdDisplayRIC = 'KRSA.OQ', Name = 'KORSANA BIOSCIENCES INC COM', DsPrimQtSedol = 'BVDBY82', RkdCode = 119040.0, RkdIssueID = 1.0, RkdIssueCode = 150106.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11194938 AND Type_ = 1;
UPDATE data_universe SET Name = 'SANGRIX INC CL A ORD SHS' WHERE SecCode = 11199544 AND Type_ = 1;
UPDATE data_universe SET QuoteClass = 'DEPOSITSHS', InstrClass = 'DEPOSITSHS' WHERE SecCode = 11208071 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951518.0 WHERE SecCode = 11214197 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA38077K1030', RkdTicker = 'GCR', RkdSEDOL = 'BWK80L', RkdCUSIP = '38077K10', RkdRIC = 'GCR.CD', RkdDisplayRIC = 'GCR.CD', RkdCode = 15583.0, RkdIssueID = 2.0, RkdIssueCode = 160538.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN' WHERE SecCode = 11218243 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11223225 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US53271X2071', RkdTicker = 'LIMN', RkdSEDOL = 'C094KT', RkdCUSIP = '53271X20', RkdRIC = 'LIMN.O', RkdDisplayRIC = 'LIMN.OQ', RkdCode = 126741.0, RkdIssueID = 1.0, RkdIssueCode = 160514.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11224426 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-08', SecMapEndDate = '2026-09-04', endDate = '2026-09-04' WHERE SecCode = 11231709 AND Type_ = 1;
UPDATE data_universe SET Name = 'ASPIRE LAKEWOOD HOLDINGS INC COM' WHERE SecCode = 11240840 AND Type_ = 1;
UPDATE data_universe SET Name = 'ASPIRE LAKEWOOD HOLDINGS INC *W EXP 02/14/2030' WHERE SecCode = 11240919 AND Type_ = 1;
UPDATE data_universe SET Name = 'NEXUS ADVANCED TCHNOLOGIES INC ORD SHS' WHERE SecCode = 11247303 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVDBT43' WHERE SecCode = 11251647 AND Type_ = 1;
UPDATE data_universe SET Name = 'QUETTA ACQUISITION CORP UNIT 99/99/9999' WHERE SecCode = 11258099 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US05330T3041', RkdTicker = 'AMIX', RkdSEDOL = 'BVSRPB', RkdCUSIP = '05330T30', RkdRIC = 'AMIX.O', RkdDisplayRIC = 'AMIX.OQ', RkdCode = 137280.0, RkdIssueID = 1.0, RkdIssueCode = 174517.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11262021 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = '' WHERE SecCode = 11266729 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US23126K3041', RkdTicker = 'CURX', RkdSEDOL = 'BXTCNS', RkdCUSIP = '23126K30', RkdRIC = 'CURX.O', RkdDisplayRIC = 'CURX.OQ', RkdCode = 140566.0, RkdIssueID = 1.0, RkdIssueCode = 179163.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11284122 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BSBHNJ5' WHERE SecCode = 11285909 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG4092C1235', RkdTicker = 'GCDT', RkdSEDOL = 'BVY6YY', RkdCUSIP = 'G4092C12', RkdRIC = 'GCDT.K', RkdDisplayRIC = 'GCDT.A', RkdCode = 138773.0, RkdIssueID = 1.0, RkdIssueCode = 176719.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASE', RkdExchCtry = 'USA' WHERE SecCode = 11290571 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11299372 AND Type_ = 1;