UPDATE data_universe SET ModelCntry = 'US', DomCntry = 'USA' WHERE SecCode = 3883 AND Type_ = 1; UPDATE data_universe SET RkdRIC = 'BRFS3.SA^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-23', PermQuoteRetireDate = '2025-09-23', endDate = '2025-09-23' WHERE SecCode = 27115 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 40716 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 55846120871.0, ExchCode = 'CPH' WHERE SecCode = 45892 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951179.0 WHERE SecCode = 50144 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'VHC.O', RkdDisplayRIC = 'VHC.OQ', RkdExchCode = 'NASD', ExchCode = 'NAS' WHERE SecCode = 53360 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21805754481.0, ExchCode = 'MUN' WHERE SecCode = 61290 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 62101 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 69973 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1997-11-14' WHERE SecCode = 69984 AND Type_ = 10; UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SPTN.OQ^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-23', SecMapEndDate = '2025-09-19', PermQuoteRetireDate = '2025-09-23', endDate = '2025-09-19' WHERE SecCode = 70919 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71866 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2025-10-14' WHERE SecCode = 72964 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73840 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'US', DomCntry = 'USA' WHERE SecCode = 74273 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 74899 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 74992 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-09-16', PermQuoteRetireDate = '2025-09-21', PermSecMapEndDate = '2025-09-22', endDate = '2025-09-16' WHERE SecCode = 75258 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77263 AND Type_ = 10; UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 78176 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL, Name = 'ANTELOPUS SELAN EN INR10' WHERE SecCode = 79139 AND Type_ = 10; UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 79830 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80018 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 83863 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '1986-06-06' WHERE SecCode = 85191 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86362 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 88335 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'US', DomCntry = 'USA' WHERE SecCode = 88378 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'NEXGBINA', PermIDTicker = 'NEXGBINA', RkdRIC = 'NEXI.KL', RkdDisplayRIC = 'NEXI.KL' WHERE SecCode = 91350 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95325 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 98900 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951190.0 WHERE SecCode = 100020 AND Type_ = 1; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 100312 AND Type_ = 1; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 104469 AND Type_ = 10; UPDATE data_universe SET Name = 'SAYONA MINING LTD NPV' WHERE SecCode = 111747 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 116794 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 121155 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'INE198501012', RkdTicker = 'EUROPRATIK', PermIDTicker = 'EUROPRATIK', RkdSEDOL = 'B04LNW', RkdCUSIP = 'Y6135F10', RkdRIC = 'EURR.NS', RkdDisplayRIC = 'EURR.NS', DsPrimQtSedol = NULL, RkdCode = 142221.0, RkdIssueID = 1.0, RkdIssueCode = 181445.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NSE', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = 'IND', QuotePermID = 236789865785.0, InstrPermID = 232870988381.0, OrgPermID = 5086485920.0, PriValQuotePermID = 236789865785.0, PriInstrPermID = 232870988381.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NSI', OrgTypeCode = 'COM', IncCntry = 'IND', PriTRBCIndPermID = 4294951519.0, PermSecMapStartDate = '2025-09-22', PermSecMapEndDate = NULL WHERE SecCode = 134942 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU0000420739', RkdTicker = 'CQT', PermIDTicker = 'CQT', RkdSEDOL = 'BSSB50', RkdRIC = 'CQT.AX', RkdDisplayRIC = 'CQT.AX', DsPrimQtSedol = 'BSSB505', SecMapEndDate = '2025-09-21', endDate = '2025-09-21' WHERE SecCode = 141616 AND Type_ = 10; UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 142701 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 175341 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 202318 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 261188 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC', SecMapEndDate = '2025-09-02', PermSecMapEndDate = '2025-09-21', endDate = '2025-09-02' WHERE SecCode = 294471 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2025-09-24' WHERE SecCode = 298972 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 302126 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'BRMBRFACNOR1', RkdTicker = 'MBRF3', PermIDTicker = 'MBRF3', RkdRIC = 'MBRF3.SA', RkdDisplayRIC = 'MBRF3.SA', DsPrimQtSedol = 'BV8H6L2' WHERE SecCode = 302757 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2007-07-20' WHERE SecCode = 310249 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2007-07-20' WHERE SecCode = 310250 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2007-07-20' WHERE SecCode = 310251 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'ADANI POWER LTD INR2 (POST SUBD)' WHERE SecCode = 536728 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 547478 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'VE.MI^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-23', SecMapEndDate = '2025-02-25', PermQuoteRetireDate = '2025-09-23', endDate = '2025-02-25' WHERE SecCode = 586040 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951908.0 WHERE SecCode = 913819 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'GRAND OAK CANYONS INR10' WHERE SecCode = 1175373 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 1286597 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'BLIT', QuotePermID = 21482228292.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951506.0 WHERE SecCode = 1998237 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 2295691 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2382439 AND Type_ = 10; UPDATE data_universe SET Name = 'NEWTRAC FOODS & BE INR10' WHERE SecCode = 2396464 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2456874 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'BTCS SA PLN0.50' WHERE SecCode = 2495862 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-09-19', PermSecMapEndDate = '2025-09-22', endDate = '2025-09-19' WHERE SecCode = 3184000 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2025-08-27', PermSecMapEndDate = '2025-09-21', endDate = '2025-08-27' WHERE SecCode = 3213375 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 3260117 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3317774 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'AU0000421117', RkdTicker = 'XRA', PermIDTicker = 'XRA', RkdSEDOL = 'BSSB62', RkdRIC = 'XRA.AX', RkdDisplayRIC = 'XRA.AX', DsPrimQtSedol = 'BSSB624', PermSecMapEndDate = '2025-09-22', endDate = '2025-09-22' WHERE SecCode = 3320330 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 3345831 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3407823 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3429657 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3569570 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3629677 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3634457 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951697.0 WHERE SecCode = 3731082 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3779974 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3885291 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3886816 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4018127 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4286258 AND Type_ = 10; UPDATE data_universe SET ModelCntry = 'US', DomCntry = 'USA' WHERE SecCode = 4388104 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4447189 AND Type_ = 10; UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 4491668 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4655498 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4702567 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-09-23', SecMapEndDate = '2025-09-22', PermQuoteRetireDate = '2025-09-23', endDate = '2025-09-22' WHERE SecCode = 4751051 AND Type_ = 10; UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'CQT', DsPrimQtSedol = 'BSSB505' WHERE SecCode = 4897799 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4929226 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'LLL.AX^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-22', SecMapEndDate = '2025-01-22', PermQuoteRetireDate = '2025-09-22', PermSecMapEndDate = '2025-09-22', endDate = '2025-01-22' WHERE SecCode = 5054835 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5078451 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5188793 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5349583 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'ORAO.ASE^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-23', SecMapEndDate = '2025-06-03', PermQuoteRetireDate = '2025-09-23', endDate = '2025-06-03' WHERE SecCode = 5474601 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2079-06-06', PermOrgIPODate = '2025-09-19', endDate = NULL WHERE SecCode = 5536057 AND Type_ = 10; UPDATE data_universe SET RkdRIC = 'KNDR.ASE^I25', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-09-23', endDate = '2025-09-23' WHERE SecCode = 5616087 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5652421 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'BAC', PermIDTicker = 'BAC', RkdRIC = 'BACJ.J', RkdDisplayRIC = 'BACJ.J' WHERE SecCode = 5954213 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'BACA' WHERE SecCode = 5954214 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'BACB' WHERE SecCode = 5954215 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'BACC' WHERE SecCode = 5954216 AND Type_ = 10; UPDATE data_universe SET Name = 'SAGILITY LTD INR10' WHERE SecCode = 5990989 AND Type_ = 10; UPDATE data_universe SET Name = 'BLACKBUCK LTD INR1' WHERE SecCode = 6008774 AND Type_ = 10; UPDATE data_universe SET SecMapStartDate = '2025-05-05' WHERE SecCode = 6270416 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6354184 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951631.0 WHERE SecCode = 6389725 AND Type_ = 10; UPDATE data_universe SET SecMapEndDate = '2025-09-19', PermSecMapEndDate = '2025-09-21', endDate = '2025-09-19' WHERE SecCode = 6418158 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-09-23', SecMapEndDate = '2025-09-22', PermSecMapEndDate = '2025-09-22', endDate = '2025-09-22' WHERE SecCode = 6421094 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-09-23', SecMapEndDate = '2025-09-22', PermSecMapEndDate = '2025-09-22', endDate = '2025-09-22' WHERE SecCode = 6421141 AND Type_ = 10; UPDATE data_universe SET DsExchQtStartDate = '2025-09-18', startDate = '2025-09-17' WHERE SecCode = 6460642 AND Type_ = 10; UPDATE data_universe SET Name = 'GRUPO NUTRISA SAB NPV', PriTRBCIndPermID = 4294951425.0 WHERE SecCode = 6462844 AND Type_ = 10; UPDATE data_universe SET PermSecMapEndDate = '2025-09-20', endDate = '2025-09-20' WHERE SecCode = 10925121 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'US9630257965', RkdSEDOL = 'BLDCLW', RkdCUSIP = '96302579', DsPrimQtSedol = 'BLDCLW8' WHERE SecCode = 11015187 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2025-09-20', endDate = '2025-09-20' WHERE SecCode = 11036554 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11037077 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = '2025-09-20', endDate = '2025-09-20' WHERE SecCode = 11037925 AND Type_ = 1; UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-09-19', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-09-22', endDate = '2025-09-19' WHERE SecCode = 11199506 AND Type_ = 1; UPDATE data_universe SET ModelCntry = 'US', DomCntry = 'USA' WHERE SecCode = 11205537 AND Type_ = 1; UPDATE data_universe SET RkdRIC = 'CMPO.K' WHERE SecCode = 11214926 AND Type_ = 1; UPDATE data_universe SET ModelCntry = 'GB', DomCntry = 'GBR' WHERE SecCode = 11214934 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '1986-06-06' WHERE SecCode = 11216248 AND Type_ = 1; UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11216266 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11221086 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '1986-06-06' WHERE SecCode = 11222396 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11235392 AND Type_ = 1; UPDATE data_universe SET Name = 'NEW EARTH RES CORP COM' WHERE SecCode = 11251487 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'KYG351501385', RkdSEDOL = 'BLDCLZ', RkdCUSIP = 'G3515013', DsPrimQtSedol = 'BLDCLZ1' WHERE SecCode = 11256200 AND Type_ = 1; UPDATE data_universe SET Name = 'MINGTENG INTL CORP INC USD CL A ORD SHS' WHERE SecCode = 11264399 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11268474 AND Type_ = 1; UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11272056 AND Type_ = 1; UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11274795 AND Type_ = 1; UPDATE data_universe SET RkdRIC = 'RHLD.K' WHERE SecCode = 11275118 AND Type_ = 1; UPDATE data_universe SET SecMapStartDate = '2025-09-17' WHERE SecCode = 11285384 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285415 AND Type_ = 1; UPDATE data_universe SET SecMapStartDate = '2025-09-18', startDate = '2025-09-18' WHERE SecCode = 11285475 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = '2025-09-18' WHERE SecCode = 11285479 AND Type_ = 1;