UPDATE data_universe SET PriTRBCIndPermID = 4294951276.0 WHERE SecCode = 3626 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'XAN', QuotePermID = 21475442982.0, ExchCode = 'POS' WHERE SecCode = 4772 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 7178 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236814266140.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-09-10', startDate = '2005-02-10' WHERE SecCode = 8851 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'GB0007365546', RkdTicker = 'CLLN', RkdSEDOL = '073655', RkdCUSIP = 'G1900N10', RkdRIC = 'CLLN.L^G26', RkdDisplayRIC = 'CLLN.L', RkdCode = 17120.0, RkdIssueID = 1.0, RkdIssueCode = 24300.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'LON', RkdExchCtry = 'GBR' WHERE SecCode = 10081 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'US0906557055', RkdTicker = 'BRTX', RkdSEDOL = 'BRF0S4', RkdCUSIP = '09065570', RkdRIC = 'BRTX.O', RkdDisplayRIC = 'BRTX.OQ', RkdCode = 105663.0, RkdIssueID = 1.0, RkdIssueCode = 132883.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 15660 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CLP282671054', RkdTicker = 'LASCONDES', RkdSEDOL = '220326', RkdCUSIP = 'P2826710', RkdRIC = 'LASCONDES.SN', RkdDisplayRIC = 'LASCONDES.SN', RkdCode = 48820.0, RkdIssueID = 1.0, RkdIssueCode = 63980.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SCL', RkdExchCtry = 'CHL' WHERE SecCode = 28165 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55838830955.0, ExchCode = 'BEC' WHERE SecCode = 28657 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951433.0 WHERE SecCode = 30548 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA41752X1015', RkdTicker = 'HTE.UN', RkdSEDOL = '215497', RkdCUSIP = '41752X10', RkdRIC = 'HTE_u.TO^L09', RkdDisplayRIC = 'HTE_u.TO', RkdCode = 33363.0, RkdIssueID = 1.0, RkdIssueCode = 44700.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'CCR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 32850 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'ANFP.I', QuotePermID = 21475586638.0, ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 33925 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'US81761L2016', RkdTicker = 'SVC', RkdSEDOL = 'BVMYDH', RkdCUSIP = '81761L20', RkdRIC = 'SVC.O', RkdDisplayRIC = 'SVC.OQ', RkdCode = 7644.0, RkdIssueID = 1.0, RkdIssueCode = 10564.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 34008 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'WLVG.I', QuotePermID = 21475586117.0, ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 34242 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21492516206.0, ExchCode = 'STU' WHERE SecCode = 35642 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'BIBd', QuotePermID = 21475113523.0, ExchCode = 'EQD', PermQuoteRetireDate = '2013-03-21' WHERE SecCode = 35717 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 35801 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21523788402.0, ExchCode = 'CHI' WHERE SecCode = 35857 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 37493 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21475360132.0, ExchCode = 'DUS' WHERE SecCode = 39970 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951649.0 WHERE SecCode = 40941 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'INVN.I', QuotePermID = 21475591267.0, ExchCode = 'CSS', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 42094 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'YZAi', QuotePermID = 21474865386.0, ExchCode = 'NQX', PermQuoteRetireDate = '2010-07-02' WHERE SecCode = 42203 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 46278 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21475389822.0, ExchCode = 'FRA' WHERE SecCode = 47266 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55836326929.0, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 48143 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 48158 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 48715 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21474860786.0, ExchCode = 'BTE', PermQuoteRetireDate = '2019-11-01', endDate = '2019-11-01' WHERE SecCode = 49244 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 51222 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1999-03-24' WHERE SecCode = 58043 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2026-01-01' WHERE SecCode = 58173 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'DE0007501009', RkdTicker = 'TTO', RkdSEDOL = '572330', RkdCUSIP = 'D8468N10', RkdRIC = 'TTOG.F', RkdDisplayRIC = 'TTOG.F', RkdCode = 21058.0, RkdIssueID = 1.0, RkdIssueCode = 29202.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'FRA', RkdExchCtry = 'DEU' WHERE SecCode = 59657 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21524803141.0, ExchCode = 'FRA', PermQuoteRetireDate = '2018-01-17' WHERE SecCode = 60120 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951203.0 WHERE SecCode = 60552 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NSU', QuotePermID = 21475572971.0, ExchCode = 'HAN', PermQuoteRetireDate = '2007-09-12', endDate = '2007-09-12' WHERE SecCode = 60647 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'DE0005407100', RkdTicker = 'CSH', RkdSEDOL = '576151', RkdCUSIP = 'D1497G10', RkdRIC = 'CSHG.DE', RkdDisplayRIC = 'CSHG.DE', RkdCode = 17065.0, RkdIssueID = 1.0, RkdIssueCode = 24190.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ETR', RkdExchCtry = 'DEU' WHERE SecCode = 60648 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21475422918.0, ExchCode = 'GER', PermQuoteRetireDate = '2002-08-27', PermSecMapEndDate = '1999-09-11', endDate = '1999-09-11' WHERE SecCode = 60880 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'PSF.I', QuotePermID = 21475581196.0, ExchCode = 'CML', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 62335 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'CRU.I', QuotePermID = 21475525989.0, ExchCode = 'COO', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 63884 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 69536 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70042 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70098 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70438 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'DUNXF' WHERE SecCode = 71190 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'SPELS', RkdRIC = 'SPEL.NS', RkdDisplayRIC = 'SPEL.NS', RkdExchCode = 'NSE' WHERE SecCode = 72144 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951464.0 WHERE SecCode = 72221 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-12', PermSecMapEndDate = '2026-09-11' WHERE SecCode = 72759 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'LAND.PS^G26', RkdIssueStatus = 0.0 WHERE SecCode = 73885 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75057 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'US8816242098', RkdTicker = 'TEVA', RkdSEDOL = '288387', RkdCUSIP = '88162420', RkdRIC = 'TEVA.K', RkdDisplayRIC = 'TEVA.N', DsCtryQtStatus = 'D', RkdCode = 4586.0, RkdIssueID = 1.0, RkdIssueCode = 5954.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'ADR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', ShPerListing = 1.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-12', SecMapEndDate = '2026-09-11', PermQuoteRetireDate = '2026-09-12', endDate = '2026-09-11' WHERE SecCode = 75213 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76103 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'AVANCE', RkdRIC = 'AVTC.NS', RkdDisplayRIC = 'AVTC.NS', RkdExchCode = 'NSE' WHERE SecCode = 76634 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76780 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78207 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78583 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79086 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79422 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-12', PermSecMapEndDate = '2026-09-11' WHERE SecCode = 80477 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-12', PermSecMapEndDate = '2026-09-11' WHERE SecCode = 80562 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 82301 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82358 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82801 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82950 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82974 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 85350 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 86052 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 86895 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 87246 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-12', PermSecMapEndDate = '2026-09-11' WHERE SecCode = 88709 AND Type_ = 10; UPDATE data_universe SET OrgPermID = 6000370490.0, PriTRBCIndPermID = 4294951688.0, PermOrgIPODate = NULL WHERE SecCode = 90101 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951986.0 WHERE SecCode = 90149 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951986.0 WHERE SecCode = 90150 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951807.0 WHERE SecCode = 90871 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91332 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA11221E1097', RkdTicker = 'SBC', RkdSEDOL = 'B0Q1CP', RkdCUSIP = '11221E10', RkdRIC = 'SBC.TO', RkdDisplayRIC = 'SBC.TO', RkdCode = 49158.0, RkdIssueID = 1.0, RkdIssueCode = 64295.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 91434 AND Type_ = 1; UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 96963 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-12', PermSecMapEndDate = '2026-09-11' WHERE SecCode = 97370 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-14', PermQuoteRetireDate = '2026-09-14', endDate = '2026-09-14' WHERE SecCode = 98128 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98341 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA53621C1014', RkdTicker = 'LCU', PermIDTicker = 'LCU', RkdSEDOL = 'C0BCT9', RkdCUSIP = '53621C10', RkdRIC = 'LCU.CD', RkdDisplayRIC = 'LCU.CD', RkdCode = 38633.0, RkdIssueID = 1.0, RkdIssueCode = 51117.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN', PermSecMapEndDate = '2026-09-12', endDate = '2026-09-12' WHERE SecCode = 98368 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98852 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 99812 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 100155 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21898257745.0, ExchCode = 'BTE' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 105289 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'CPNT.I', QuotePermID = 21475535230.0, ExchCode = 'CST', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 113625 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115197 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115260 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115666 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115980 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115997 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 116213 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 116617 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 119593 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 120585 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 123430 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 124738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125539 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125625 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125692 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126259 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126305 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126429 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126430 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126457 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126517 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126634 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126810 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = 'BMVTH4', RkdRIC = 'TRNI.BO', RkdDisplayRIC = 'TRNI.BO', RkdIssueStatus = 1.0 WHERE SecCode = 126818 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126828 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126972 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 128794 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 130886 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133893 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134770 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134846 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134904 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134905 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135272 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135448 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135730 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135736 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135958 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136034 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136507 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136772 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136981 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136987 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136991 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137019 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 138036 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 139133 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-14' WHERE SecCode = 141330 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142426 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142542 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142799 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142870 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'SE0010520981', RkdTicker = 'KAHL', RkdSEDOL = 'BF1PV3', RkdCUSIP = 'W5016Y15', RkdRIC = 'KAHL.ST^J19', RkdDisplayRIC = 'KAHL.ST', RkdCode = 51792.0, RkdIssueID = 1.0, RkdIssueCode = 67715.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'STO', RkdExchCtry = 'SWE' WHERE SecCode = 143582 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'DK0060052843', RkdTicker = 'BOSTAD B', RkdSEDOL = 'B1GZBK', RkdCUSIP = 'K0851T10', RkdRIC = 'BOSTADb.CO^E20', RkdDisplayRIC = 'BOSTADb.CO', RkdCode = 58377.0, RkdIssueID = 1.0, RkdIssueCode = 75145.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CPH', RkdExchCtry = 'DNK' WHERE SecCode = 176442 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21720719075.0, ExchCode = 'BER', PermQuoteRetireDate = '2023-06-27', endDate = '2023-05-16' WHERE SecCode = 177474 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CA53184C1005', RkdTicker = 'LBS', RkdSEDOL = 'B1G2NG', RkdCUSIP = '53184C10', RkdRIC = 'LBS.TO', RkdDisplayRIC = 'LBS.TO', RkdCode = 57482.0, RkdIssueID = 1.0, RkdIssueCode = 74399.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 177935 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 21507329852.0, ExchCode = 'FRA' WHERE SecCode = 178289 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21548011121.0, ExchCode = 'STU' WHERE SecCode = 184361 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 194378 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'DOCK.I', QuotePermID = 21475510665.0, ExchCode = 'COO', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 196096 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 197345 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243154 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243222 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243354 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 255960 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 256504 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 257965 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-09-12', PermSecMapEndDate = '2026-09-11' WHERE SecCode = 285288 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2026-09-11', PermSecMapEndDate = '2026-09-12', endDate = '2026-09-11' WHERE SecCode = 295475 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 340660 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 345666 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378075 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378080 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 378081 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 389876 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 397834 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 403765 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 408145 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 425884 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 425905 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 429392 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 431231 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 442754 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 519104 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951216.0 WHERE SecCode = 531090 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 537537 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'STL.HNO^G26', RkdIssueStatus = 0.0 WHERE SecCode = 561094 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'IE00B97C0C31', RkdTicker = 'KIBO', RkdSEDOL = 'B97C0C', RkdCUSIP = 'G5257311', RkdRIC = 'KIBO.L^G26', RkdDisplayRIC = 'KIBO.L', RkdCode = 87166.0, RkdIssueID = 1.0, RkdIssueCode = 109671.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'LON', RkdExchCtry = 'GBR' WHERE SecCode = 646415 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 685105 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 769908 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'SSF.HNO^G26', RkdIssueStatus = 0.0 WHERE SecCode = 780397 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 794875 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951779.0 WHERE SecCode = 797952 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843994 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU0000090060', RkdTicker = 'EUZ', RkdSEDOL = 'BMVSW4', RkdCUSIP = 'Q3642R12', RkdRIC = 'EUZJ.J', RkdDisplayRIC = 'EUZJ.J', RkdCode = 48450.0, RkdIssueID = 1.0, RkdIssueCode = 63335.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'JNB', RkdExchCtry = 'ZAF' WHERE SecCode = 907800 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 999958 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951871.0 WHERE SecCode = 1077940 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951356.0 WHERE SecCode = 1108989 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 1154797 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL, RkdRIC = '1909.T^I26', RkdDisplayRIC = '1909.T^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-14', endDate = '2026-09-14' WHERE SecCode = 1160469 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A', PriTRBCIndPermID = 4294951713.0 WHERE SecCode = 1204782 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209860 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209863 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1209871 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1241264 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1465105 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21479505819.0, ExchCode = 'PLU', PermQuoteRetireDate = '2012-01-17', endDate = '2012-01-17' WHERE SecCode = 1472965 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 1481674 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 1542751 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1554192 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1622760 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1627735 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1629626 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951746.0 WHERE SecCode = 1644134 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1670286 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '121850.KQ^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-14', PermQuoteRetireDate = '2026-09-14', endDate = '2026-09-14' WHERE SecCode = 1694231 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'ABGPe', QuotePermID = 21513756453.0, ExchCode = 'HFT', PermQuoteRetireDate = '2014-05-02', endDate = '2014-05-02' WHERE SecCode = 1699140 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1704676 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1980972 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1998415 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951307.0 WHERE SecCode = 2257450 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951801.0 WHERE SecCode = 2292896 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2338222 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2341361 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A', PriTRBCIndPermID = 4294951713.0 WHERE SecCode = 2380641 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2387392 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2417968 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 2428148 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'CPL', RkdRIC = 'CAPA.NS', RkdDisplayRIC = 'CAPA.NS', RkdExchCode = 'NSE' WHERE SecCode = 2436736 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21533733328.0, ExchCode = 'STO', PermQuoteRetireDate = '2018-10-18' WHERE SecCode = 2438937 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2452498 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2529641 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2569978 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 2579455 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2580912 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2592376 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 2620147 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2646543 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2782958 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2873693 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'DE000RYSE888', RkdTicker = 'RY8', RkdSEDOL = 'BWT3FC', RkdCUSIP = 'D6S0AT10', RkdRIC = 'RY8.D^G26', RkdDisplayRIC = 'RY8.D', RkdCode = 104493.0, RkdIssueID = 1.0, RkdIssueCode = 131437.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'DUS', RkdExchCtry = 'DEU' WHERE SecCode = 2884543 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2899717 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2909912 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2926786 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2943703 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21761647591.0, ExchCode = 'BER', PermQuoteRetireDate = '2022-06-13', PermSecMapEndDate = NULL, endDate = '2022-06-10' WHERE SecCode = 2944460 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 2982652 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3001070 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3005679 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3040837 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3084613 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'GB00BZ4G2K23', RkdSEDOL = 'BZ4G2K', RkdCUSIP = 'G6014T10', RkdRIC = 'MPHM.L^L20', RkdDisplayRIC = 'MPHM.L', RkdCode = 108605.0, RkdIssueID = 1.0, RkdIssueCode = 136305.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'LON', RkdExchCtry = 'GBR' WHERE SecCode = 3194870 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212151 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212191 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3233484 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3247268 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247535 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3272839 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3302636 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3317677 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 PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 3320156 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21623235806.0, ExchCode = 'TDG', PermQuoteRetireDate = '2022-06-27', endDate = '2022-06-27' WHERE SecCode = 3324152 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951854.0 WHERE SecCode = 3387570 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951633.0 WHERE SecCode = 3406950 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21858470839.0, ExchCode = 'DEU', PermQuoteRetireDate = '2024-01-03', endDate = '2023-12-29' WHERE SecCode = 3436782 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3441467 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'OBCL.NS', RkdDisplayRIC = 'OBCL.NS' WHERE SecCode = 3444850 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3532738 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3543193 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3554990 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3586960 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3587036 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3613565 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3685210 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3754743 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'LGRSl', QuotePermID = 21693145541.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-07-21' WHERE SecCode = 3818837 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'ARVEX' WHERE SecCode = 3885292 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951962.0 WHERE SecCode = 3969541 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3980014 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'PLKLBTR00014', RkdTicker = 'DFH', RkdSEDOL = 'BKMQP8', RkdCUSIP = 'X4536D10', RkdRIC = 'DFHP.WA', RkdDisplayRIC = 'DFHP.WA', RkdCode = 121254.0, RkdIssueID = 1.0, RkdIssueCode = 153043.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'WAR', RkdExchCtry = 'POL' WHERE SecCode = 3986680 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4036729 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4272300 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'DE000A2QDNX9', RkdTicker = 'C0M', RkdSEDOL = 'BM95XP', RkdCUSIP = 'D1T2Z910', RkdRIC = 'C0M.H', RkdDisplayRIC = 'C0M.H', RkdCode = 125209.0, RkdIssueID = 1.0, RkdIssueCode = 158379.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HAM', RkdExchCtry = 'DEU' WHERE SecCode = 4388174 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4446004 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951637.0 WHERE SecCode = 4453359 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 DsCtryQtStatus = 'S' WHERE SecCode = 4513603 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4531619 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951203.0 WHERE SecCode = 4617615 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21820741604.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-10' WHERE SecCode = 4626906 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4682756 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'PYRUMo', QuotePermID = 236787861852.0, ExchCode = 'BCO' WHERE SecCode = 4726082 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 QuotePermID = 236777414710.0, ExchCode = 'AQX' WHERE SecCode = 4865336 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951366.0 WHERE SecCode = 4989476 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'HT5', QuotePermID = 21890440366.0, ExchCode = 'DEU' WHERE SecCode = 4989623 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5085785 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5105872 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5112409 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 5147795 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5234143 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'SE0019354358', RkdTicker = 'MNDRK', RkdSEDOL = 'BMH9DG', RkdCUSIP = 'W5757V12', RkdRIC = 'MNDRK.TE^G26', RkdDisplayRIC = 'MNDRK.TE', RkdCode = 141446.0, RkdIssueID = 1.0, RkdIssueCode = 180268.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'AKT', RkdExchCtry = 'SWE' WHERE SecCode = 5347334 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'CREGm', QuotePermID = 21954311219.0, ExchCode = 'BCO' WHERE SecCode = 5354972 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 5383316 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236778101323.0, ExchCode = 'FRA' WHERE SecCode = 5457246 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236778518455.0, ExchCode = 'FRA' WHERE SecCode = 5482616 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 5607462 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236780730608.0, ExchCode = 'FRA' WHERE SecCode = 5620353 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5649726 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5657397 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5738355 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951260.0 WHERE SecCode = 5747500 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 5842444 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5940234 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 6006808 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21890431098.0, ExchCode = 'FRA' WHERE SecCode = 6256382 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '353A.FU', RkdDisplayRIC = '353A.FU', RkdExchCode = 'FUK' WHERE SecCode = 6258213 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = '25752l', QuotePermID = 236793411522.0, ExchCode = 'SIG' WHERE SecCode = 6334328 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 6400762 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6590947 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 6694372 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 6937624 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Y372PV10' WHERE SecCode = 7006694 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Y182CD10' WHERE SecCode = 7009109 AND Type_ = 10; UPDATE data_universe SET RkdCUSIP = 'Y774Y510' WHERE SecCode = 7025893 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007WR8', RkdCUSIP = 'Y163MK10' WHERE SecCode = 7044210 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'CNE100007V64', RkdCUSIP = 'Y130MJ10' WHERE SecCode = 7044211 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'PREF' WHERE SecCode = 7067670 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'TW0007914004', RkdTicker = '7914', RkdSEDOL = 'BVTCGB', RkdCUSIP = 'Y901R710', RkdRIC = '7914.TWO', RkdDisplayRIC = '7914.TWO', RkdCode = 145533.0, RkdIssueID = 1.0, RkdIssueCode = 186321.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TPO', RkdExchCtry = 'TWN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 7070152 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7077875 AND Type_ = 10; UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 7093151 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2026-09-11' WHERE SecCode = 7098759 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 10928445 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'QNTA', PermSecMapEndDate = '2026-09-12', endDate = '2026-09-12' WHERE SecCode = 11019097 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'AETH.X' WHERE SecCode = 11028341 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2026-09-12', endDate = '2026-09-12' WHERE SecCode = 11030426 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US45824Q8877', RkdTicker = 'GCTK', RkdSEDOL = 'BVPTKW', RkdCUSIP = '45824Q88', RkdRIC = 'GCTK.O', RkdDisplayRIC = 'GCTK.OQ', RkdCode = 87144.0, RkdIssueID = 1.0, RkdIssueCode = 109646.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11045990 AND Type_ = 1; UPDATE data_universe SET SecMapEndDate = '2026-09-11', PermSecMapEndDate = '2026-09-12', endDate = '2026-09-11' WHERE SecCode = 11065371 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA45676A1057', RkdSEDOL = 'BC1JG9', RkdCUSIP = '45676A10', RkdRIC = 'ISC.TO^G26', RkdDisplayRIC = 'ISC.TO', RkdCode = 94896.0, RkdIssueID = 1.0, RkdIssueCode = 119489.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 11080057 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951368.0 WHERE SecCode = 11112733 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11115529 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11131358 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 11131887 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11146600 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US5007541064', RkdTicker = 'KHC', RkdSEDOL = 'BYRY49', RkdCUSIP = '50075410', RkdRIC = 'KHC', RkdDisplayRIC = 'KHC.OQ', RkdCode = 103558.0, RkdIssueID = 1.0, RkdIssueCode = 130253.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', ExchCode = 'NYS' WHERE SecCode = 11150148 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US05344R4011', RkdTicker = 'CHGA', RkdSEDOL = 'BV8CW1', RkdCUSIP = '05344R40', RkdRIC = 'CHGA.O', RkdDisplayRIC = 'CHGA.OQ', RkdCode = 113025.0, RkdIssueID = 1.0, RkdIssueCode = 142115.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11156680 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA90140G1063', RkdTicker = 'IRON', RkdSEDOL = 'BXWZH8', RkdCUSIP = '90140G10', RkdRIC = 'IRON.CD', RkdDisplayRIC = 'IRON.CD', RkdCode = 118166.0, RkdIssueID = 1.0, RkdIssueCode = 149006.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN' WHERE SecCode = 11178737 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US81752R3084', RkdTicker = 'SRG PRA', RkdSEDOL = 'BYVZVN', RkdCUSIP = '81752R30', RkdRIC = 'SRG_pa', RkdDisplayRIC = 'SRG_pa.N', RkdCode = 103370.0, RkdIssueID = 4.0, RkdIssueCode = 145562.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 11180027 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA74052G1063', RkdSEDOL = 'BKBPWZ', RkdCUSIP = '74052G10', RkdRIC = 'PHAh.V^H26', RkdDisplayRIC = 'PHAh.V', RkdCode = 124849.0, RkdIssueID = 1.0, RkdIssueCode = 157877.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NEX', RkdExchCtry = 'CAN' WHERE SecCode = 11192959 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA82809U1049', RkdTicker = 'PONY', RkdSEDOL = 'BRCB4B', RkdCUSIP = '82809U10', RkdRIC = 'PONY.CD', RkdDisplayRIC = 'PONY.CD', RkdCode = 117004.0, RkdIssueID = 1.0, RkdIssueCode = 147435.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN' WHERE SecCode = 11193523 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US6443933089', RkdTicker = 'NFE', RkdSEDOL = 'BVN1L1', RkdCUSIP = '64439330', RkdRIC = 'NFE.O', RkdDisplayRIC = 'NFE.OQ', DsPrimQtSedol = 'BVN1L14', RkdCode = 117992.0, RkdIssueID = 1.0, RkdIssueCode = 148774.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PriInstrPermID = 232845444448.0, IsPrimaryInstr = 0.0, PermSecMapEndDate = '2026-09-12', endDate = '2026-09-12' WHERE SecCode = 11193719 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-14', endDate = '2026-09-14' WHERE SecCode = 11225955 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2026-09-12', endDate = '2026-09-12' WHERE SecCode = 11226560 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US6529412040', RkdTicker = 'NXXT', RkdSEDOL = 'BVN1L3', RkdCUSIP = '65294120', RkdRIC = 'NXXT.O', RkdDisplayRIC = 'NXXT.OQ', DsPrimQtSedol = 'BVN1L36', RkdCode = 128883.0, RkdIssueID = 1.0, RkdIssueCode = 163361.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PermSecMapEndDate = '2026-09-12', endDate = '2026-09-12' WHERE SecCode = 11230023 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US39531G3083', RkdTicker = 'VIP', RkdSEDOL = 'BNBXNV', RkdCUSIP = '39531G30', RkdRIC = 'VIP.O', RkdDisplayRIC = 'VIP.OQ', RkdCode = 130616.0, RkdIssueID = 1.0, RkdIssueCode = 165672.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11230326 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA39525U1075', RkdTicker = 'GFR', RkdSEDOL = 'BRBYMD', RkdCUSIP = '39525U10', RkdRIC = 'GFR.TO', RkdDisplayRIC = 'GFR.TO', RkdCode = 128506.0, RkdIssueID = 1.0, RkdIssueCode = 162859.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 11235595 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'VGG982181296', RkdTicker = 'VCIG', RkdSEDOL = 'BT9RPS', RkdCUSIP = 'G9821812', RkdRIC = 'VCIG.O', RkdDisplayRIC = 'VCIG.OQ', RkdCode = 134758.0, RkdIssueID = 1.0, RkdIssueCode = 171318.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11251558 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951536.0 WHERE SecCode = 11260721 AND Type_ = 1; UPDATE data_universe SET OrgPermID = 6000370490.0, PriTRBCIndPermID = 4294951688.0, PermOrgIPODate = NULL WHERE SecCode = 11260764 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KY07323B1007', RkdSEDOL = 'BR89CV', RkdCUSIP = '07323B10', RkdRIC = 'BAYA.OQ^G26', RkdDisplayRIC = 'BAYA.OQ', RkdCode = 138137.0, RkdIssueID = 1.0, RkdIssueCode = 175792.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11260969 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'VGG2452S1002', RkdTicker = 'CIGL', RkdSEDOL = 'BSPRX2', RkdCUSIP = 'G2452S10', RkdRIC = 'CIGL.O', RkdDisplayRIC = 'CIGL.OQ', RkdCode = 140185.0, RkdIssueID = 1.0, RkdIssueCode = 178678.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11277561 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG3106Q1102', RkdTicker = 'EVAC U', RkdSEDOL = 'BQ0G5G', RkdCUSIP = 'G3106Q11', RkdRIC = 'EVAC_u.K', RkdDisplayRIC = 'EVAC_u.N', RkdCode = 142748.0, RkdIssueID = 1.0, RkdIssueCode = 182186.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 11280134 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US37954A4022', RkdTicker = 'XRN PRB', RkdSEDOL = 'BVMNM8', RkdCUSIP = '37954A40', RkdRIC = 'XRN_pb', RkdDisplayRIC = 'XRN_pb.N', RkdCode = 88702.0, RkdIssueID = 2.0, RkdIssueCode = 185244.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 11288131 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2026-09-10' WHERE SecCode = 11291179 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11295230 AND Type_ = 1; UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11298136 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA5439372056', RkdTicker = 'MESC', RkdSEDOL = 'BWL86S', RkdCUSIP = '54393720', RkdRIC = 'MESC.CD', RkdDisplayRIC = 'MESC.CD', RkdCode = 137556.0, RkdIssueID = 1.0, RkdIssueCode = 174870.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN' WHERE SecCode = 11298959 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US2759131012', RkdTicker = 'EWAV', RkdSEDOL = 'BXCH0D', RkdCUSIP = '27591310', RkdRIC = 'EWAV.O', RkdDisplayRIC = 'EWAV.OQ', RkdCode = 144797.0, RkdIssueID = 1.0, RkdIssueCode = 185176.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11299230 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951922.0 WHERE SecCode = 11299498 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = 232940397624.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11300261 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG6659W1033', RkdTicker = 'NSAI', RkdSEDOL = 'BWJJD7', RkdCUSIP = 'G6659W10', RkdRIC = 'NSAI.O', RkdDisplayRIC = 'NSAI.OQ', RkdCode = 145363.0, RkdIssueID = 1.0, RkdIssueCode = 186039.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11300649 AND Type_ = 1; UPDATE data_universe SET QuotePermID = 236814265775.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11301551 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'OCLT', QuotePermID = 236814341276.0, InstrPermID = 232940397624.0, OrgPermID = 6000166282.0, PriTrdQuotePermID = 236814341276.0, PriValQuotePermID = 25726990324.0, PriInstrPermID = 232940397624.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-08-07', PermSecMapStartDate = '2026-09-11', startDate = '2026-08-07' WHERE SecCode = 11301613 AND Type_ = 1;