UPDATE data_universe SET Name = 'PAMPA INVEST SA NPV' WHERE SecCode = 29336 AND Type_ = 10; UPDATE data_universe SET Name = 'ICICI BK LTD ADR' WHERE SecCode = 35383 AND Type_ = 1; 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 PermIDTicker = 'SPACEN B', Name = 'SPACE NORD INVEST SER''B''NPV' WHERE SecCode = 63974 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 68472 AND Type_ = 10; UPDATE data_universe SET Name = 'CHARLES SCHWAB CORP (THE) COM' WHERE SecCode = 68498 AND Type_ = 1; UPDATE data_universe SET DsSecDelistDate = '2026-07-31' WHERE SecCode = 69239 AND Type_ = 10; UPDATE data_universe SET Name = 'ICICI BANK LTD INR2' WHERE SecCode = 70332 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 73610 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 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 RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10; UPDATE data_universe SET RkdRIC = '031440.KS^H26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-08-10' WHERE SecCode = 81495 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 82506 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83107 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88892 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 DsCtryQtStatus = 'S' WHERE SecCode = 90059 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10; UPDATE data_universe SET IncCntry = 'CAN' WHERE SecCode = 91312 AND Type_ = 1; UPDATE data_universe SET IncCntry = 'CAN' WHERE SecCode = 92027 AND Type_ = 1; UPDATE data_universe SET RkdISIN = 'CA04342X1069', RkdTicker = 'ARN', RkdSEDOL = 'BV87YW', RkdCUSIP = '04342X10', RkdRIC = 'ARN.TO', RkdDisplayRIC = 'ARN.TO', DsPrimQtSedol = 'BV87YW9' WHERE SecCode = 94108 AND Type_ = 1; 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 PermOrgIPODate = NULL, startDate = '1989-12-22' WHERE SecCode = 96476 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10; UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 101044 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL, Name = 'CD PROJEKT RED SA PLN1.00' WHERE SecCode = 102273 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 116213 AND Type_ = 10; UPDATE data_universe SET PermQuoteRetireDate = '2026-08-25' WHERE SecCode = 125258 AND Type_ = 10; UPDATE data_universe SET Name = 'STRAITS ENERGY RES NPV' WHERE SecCode = 134048 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 143539 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 168934 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 183464 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'AMFIRST REAL ESTAT NPV REIT' WHERE SecCode = 189610 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'SENTRAL REIT NPV REIT' WHERE SecCode = 191322 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 199026 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 251780 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 334615 AND Type_ = 1; UPDATE data_universe SET ISIN = NULL, Name = 'BURNPUR CEMENT LTD INR10( POST CONS)' WHERE SecCode = 375907 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 409668 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 411775 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 424452 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 537537 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL WHERE SecCode = 716988 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'SUNWAY REAL ESTATE NPV REIT' WHERE SecCode = 730932 AND Type_ = 10; UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 766928 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'FUJIAN NOX BELLCOW ''A''CNY1' WHERE SecCode = 832098 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1124073 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'PAVILION REAL ESTA NPV UNITS' WHERE SecCode = 1480265 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1627735 AND Type_ = 10; UPDATE data_universe SET Name = 'IGB REAL ESTATE IN NPV UNITS' WHERE SecCode = 1661613 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = 'CTY1SN0112', QuotePermID = 21512394267.0, ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2341361 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2592377 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2604161 AND Type_ = 10; UPDATE data_universe SET ISIN = NULL, Name = 'GL PHARM TECH CORP KRW500' WHERE SecCode = 2700373 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10; UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-11', PermSecMapEndDate = '2026-08-11' WHERE SecCode = 2910676 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21777322524.0, ExchCode = 'BER', PermQuoteRetireDate = '2021-03-23', endDate = '2021-03-22' WHERE SecCode = 2976573 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10; UPDATE data_universe SET Name = 'CHARLES SCHWAB COR BDR EACH 8 REPR 1 COM' WHERE SecCode = 3151361 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951658.0 WHERE SecCode = 3182842 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951741.0 WHERE SecCode = 3199640 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951431.0 WHERE SecCode = 3201344 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3210058 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951208.0 WHERE SecCode = 3211130 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951745.0 WHERE SecCode = 3247784 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3254562 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951251.0 WHERE SecCode = 3282642 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3282990 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951567.0 WHERE SecCode = 3287543 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951578.0 WHERE SecCode = 3289743 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 1004365474.0 WHERE SecCode = 3289744 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951514.0 WHERE SecCode = 3289825 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951283.0 WHERE SecCode = 3295399 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3311038 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951778.0 WHERE SecCode = 3317103 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951776.0 WHERE SecCode = 3317675 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951676.0 WHERE SecCode = 3318059 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 3318951 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3319626 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 3322714 AND Type_ = 10; UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 3337681 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951586.0 WHERE SecCode = 3339794 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 1004365468.0 WHERE SecCode = 3345496 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3359489 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951713.0 WHERE SecCode = 3367944 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3378307 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951842.0 WHERE SecCode = 3379082 AND Type_ = 10; UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951761.0 WHERE SecCode = 3401656 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951702.0 WHERE SecCode = 3410261 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3543193 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3554989 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'INE869Y01028', RkdSEDOL = 'BX86GL', RkdCUSIP = 'Y8584V16' WHERE SecCode = 3574018 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951312.0 WHERE SecCode = 3915749 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 DsPrimQtSedol = 'BRWFW50' WHERE SecCode = 4068201 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 DsCtryQtStatus = 'A' WHERE SecCode = 4359799 AND Type_ = 10; UPDATE data_universe SET OrgPermID = 5037932217.0, PriInstrPermID = NULL WHERE SecCode = 4381180 AND Type_ = 10; UPDATE data_universe SET Name = 'ICICI BANK LTD BDR EACH 1 REPR 1 ADR' WHERE SecCode = 4388118 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4434255 AND Type_ = 10; UPDATE data_universe SET RkdTicker = 'BITC', RkdRIC = 'BITC.TA', RkdDisplayRIC = 'BITC.TA' WHERE SecCode = 4524358 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 DsCtryQtStatus = 'A' WHERE SecCode = 4612956 AND Type_ = 10; UPDATE data_universe SET Name = 'NYCE INTERNATIONAL ORD GBP0.01' WHERE SecCode = 4815285 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-12', SecMapEndDate = '2026-08-11', endDate = '2026-08-11' WHERE SecCode = 4815347 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951429.0 WHERE SecCode = 4873356 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 21932177205.0, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951514.0 WHERE SecCode = 4956712 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4960809 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951988.0 WHERE SecCode = 5065053 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5102742 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5179600 AND Type_ = 10; UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5482519 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951321.0 WHERE SecCode = 5904437 AND Type_ = 10; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 6569470 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2025-10-28', startDate = '2025-10-28' WHERE SecCode = 6572062 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951312.0 WHERE SecCode = 6601486 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951578.0 WHERE SecCode = 6829241 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6985983 AND Type_ = 10; UPDATE data_universe SET PermOrgIPODate = '2026-07-22' WHERE SecCode = 6997043 AND Type_ = 10; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7025881 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951321.0 WHERE SecCode = 7040467 AND Type_ = 10; UPDATE data_universe SET PriTRBCIndPermID = 4294951321.0 WHERE SecCode = 7040469 AND Type_ = 10; UPDATE data_universe SET Name = 'BTG PACTUAL RENDA URBANA FUN' WHERE SecCode = 7040605 AND Type_ = 10; UPDATE data_universe SET RkdISIN = 'INE1J5V01013', RkdTicker = 'ANAWIL', RkdSEDOL = 'BXNWR2', RkdCUSIP = 'Y012M010', RkdRIC = 'ANAW.NS', RkdDisplayRIC = 'ANAW.NS', RkdCode = 145314.0, RkdIssueID = 1.0, RkdIssueCode = 185965.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NSE', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 7040628 AND Type_ = 10; UPDATE data_universe SET DsPrimQtSedol = 'BV87XQ6' WHERE SecCode = 11001028 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11005576 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'D' WHERE SecCode = 11019872 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-10', PermSecMapEndDate = '2026-08-10' WHERE SecCode = 11028132 AND Type_ = 1; UPDATE data_universe SET RkdSEDOL = 'BXP2VV' WHERE SecCode = 11151222 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11153980 AND Type_ = 1; UPDATE data_universe SET Name = 'CHARLES SCHWAB CORP (THE) DEP SHS 1/40 PFD' WHERE SecCode = 11156976 AND Type_ = 1; UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 11165205 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11193246 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11206889 AND Type_ = 1; UPDATE data_universe SET Country = 'CYM' WHERE SecCode = 11214218 AND Type_ = 1; UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'STRR.V^G26', RkdIssueStatus = 0.0 WHERE SecCode = 11219530 AND Type_ = 1; UPDATE data_universe SET Name = 'CHARLES SCHWAB CORP (THE) 4.450% DEP PFD J' WHERE SecCode = 11221478 AND Type_ = 1; UPDATE data_universe SET DsExchMnem = 'TSE', ExchCode = 'TOR' WHERE SecCode = 11229681 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'GFTA', Name = 'GRAFTA NANOTECH CORP COM', PermSecMapEndDate = '2026-08-11', endDate = '2026-08-11' WHERE SecCode = 11236025 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11241297 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11244511 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11252534 AND Type_ = 1; UPDATE data_universe SET Name = 'TJGC GROUP LTD CLS A ORD SHS' WHERE SecCode = 11274176 AND Type_ = 1; UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11274216 AND Type_ = 1; UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11280133 AND Type_ = 1; UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11282159 AND Type_ = 1; UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11284225 AND Type_ = 1; UPDATE data_universe SET PermIDTicker = 'WLCO', QuotePermID = 236812146361.0, InstrPermID = 232920116903.0, OrgPermID = 6000148702.0, PriTrdQuotePermID = 236812146361.0, PriValQuotePermID = 25726994211.0, PriInstrPermID = 232920116903.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CYM', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-18', PermSecMapStartDate = '2026-08-08', startDate = '2026-06-18' WHERE SecCode = 11300311 AND Type_ = 1;