UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'AVB.N^H26', RkdIssueStatus = 0.0 WHERE SecCode = 7360 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VMRK' WHERE SecCode = 24399 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IA' WHERE SecCode = 36212 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 41340 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 44800 AND Type_ = 1;
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 SecMapEndDate = '2026-08-18' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-08-17', PermQuoteRetireDate = '2026-08-18', PermSecMapEndDate = '2026-08-18', endDate = '2026-08-17' WHERE SecCode = 56158 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'PARIGROUP SE NPV' WHERE SecCode = 56972 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 69823 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 RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74874 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TKUN-M' WHERE SecCode = 75484 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 RkdTicker = 'ANDREWYU', RkdRIC = 'ANDY.NS', RkdDisplayRIC = 'ANDY.NS', RkdExchCode = 'NSE' WHERE SecCode = 79991 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX7YSQ7' WHERE SecCode = 80202 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ZAF' WHERE SecCode = 80375 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000480105', RkdTicker = 'HGODB', PermIDTicker = 'HGODB', RkdRIC = 'HGODB.AX', RkdDisplayRIC = 'HGODB.AX', DsPrimQtSedol = 'BXV1TJ4', PermSecMapEndDate = '2026-08-18', endDate = '2026-08-18' WHERE SecCode = 83058 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 83957 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET Name = 'KIRLOSKAR PNEUMATI INR1 (POST SUB DIVISON)' WHERE SecCode = 85397 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NICE INFOR&TELECOM KRW100' WHERE SecCode = 89214 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 PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-08-18' WHERE SecCode = 90404 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-08-18' WHERE SecCode = 90405 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-08-18' WHERE SecCode = 91266 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 PermInstrStatus = 'DC' WHERE SecCode = 99171 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616157076.0, PermQuoteStatus = 'DC', ExchCode = 'MCX', PermQuoteRetireDate = '2026-07-20', PermSecMapEndDate = '2026-07-20' WHERE SecCode = 102656 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115140 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'US YATIRIM HOLDNG TRY1 (B SHARES)' WHERE SecCode = 133994 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'HIRE.NS', RkdDisplayRIC = 'HIRE.NS', Name = 'HIRECT LTD INR2' WHERE SecCode = 136742 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 139413 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', DsPrimQtSedol = 'BXNRYG2', PermSecMapEndDate = '2026-08-18', endDate = '2026-08-18' WHERE SecCode = 146694 AND Type_ = 10;
UPDATE data_universe SET Name = 'IWIN CO LTD KRW 5000' WHERE SecCode = 170844 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'CMHC', RkdRIC = 'CMHC.S', RkdDisplayRIC = 'CMHC.S' WHERE SecCode = 203053 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE817H01022', RkdSEDOL = 'BVVH26', RkdCUSIP = 'Y1024P12' WHERE SecCode = 375907 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BMG051122098', RkdSEDOL = 'BXV21H', RkdCUSIP = 'G0511220' WHERE SecCode = 384065 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 538910 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'GKB', RkdRIC = 'GKBO.NS', RkdDisplayRIC = 'GKBO.NS', RkdExchCode = 'NSE' WHERE SecCode = 601160 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 692755 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 750417 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX7YSQ7' WHERE SecCode = 1335466 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'AZADIND', RkdRIC = 'AZAI.NS', RkdDisplayRIC = 'AZAI.NS', RkdExchCode = 'NSE' WHERE SecCode = 1466823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1468047 AND Type_ = 10;
UPDATE data_universe SET Name = 'HOWMET AEROSPACE I BDR EACH 25 REPR 1 SHS' WHERE SecCode = 1546577 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1693310 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'VESSEL CO LTD KRW1000' WHERE SecCode = 2283967 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX7YSQ7' WHERE SecCode = 2445238 AND Type_ = 10;
UPDATE data_universe SET Name = 'RJVAN HOLDINGS LTD NPV (POST CON)' WHERE SecCode = 2599220 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2727819 AND Type_ = 10;
UPDATE data_universe SET ExchCode = 'AKT' WHERE SecCode = 2923300 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-18', SecMapEndDate = '2025-10-08', PermQuoteRetireDate = '2026-08-19', PermSecMapEndDate = '2026-08-18', endDate = '2025-10-08' WHERE SecCode = 2935048 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21589220364.0, ExchCode = 'DEU', PermQuoteRetireDate = '2021-03-19', endDate = '2021-03-19' 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 = 'GILEAD SCIENCES BDR EACH 12  REP 1 COM' WHERE SecCode = 3151351 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3256348 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEPI ROCKCASTLE N. EUR0.01' WHERE SecCode = 3375338 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET Name = 'SCALARE PTNRS HLDG NPV' WHERE SecCode = 3721200 AND Type_ = 10;
UPDATE data_universe SET Name = 'PNC FINANCIAL SVCS BDR EACH 20 REPR 1 COM' WHERE SecCode = 3837267 AND Type_ = 10;
UPDATE data_universe SET Name = 'SIMON PROP GROUP BDR EACH 16 REPR 1 ORD SHS' WHERE SecCode = 3839014 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 Name = 'GREEN PWR GP LTD HKD0.01' WHERE SecCode = 4010777 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OBT', DsPrimQtSedol = 'BVY4D27', PermSecMapEndDate = '2026-08-18', endDate = '2026-08-18' WHERE SecCode = 4046414 AND Type_ = 10;
UPDATE data_universe SET Name = 'EOG RESOURCES INC BDR EACH 10 REPR 1 COM' WHERE SecCode = 4054224 AND Type_ = 10;
UPDATE data_universe SET Name = 'EXELON CORP BDR EACH 4 REP 1 COM NPV' WHERE SecCode = 4054269 AND Type_ = 10;
UPDATE data_universe SET Name = 'NETAPP INC BDR EACH 14 REPR 1 COM' WHERE SecCode = 4056167 AND Type_ = 10;
UPDATE data_universe SET Name = 'SYSCO CORP BDR EACH 6 REP 1 COM' WHERE SecCode = 4056168 AND Type_ = 10;
UPDATE data_universe SET Name = 'INTERCONT EXCHANGE BDR EACH 12 REP 1 COM' WHERE SecCode = 4077707 AND Type_ = 10;
UPDATE data_universe SET Name = 'EXTRA SPACE STORAG BDR EACH 12 REPR 1 COM' WHERE SecCode = 4079123 AND Type_ = 10;
UPDATE data_universe SET Name = 'REPUBLIC SERVICES BDR EACH 16 REPR 1 COM' WHERE SecCode = 4079152 AND Type_ = 10;
UPDATE data_universe SET Name = 'PUBLIC STORAG BDR EACH 25 REPR 1 COM' WHERE SecCode = 4079161 AND Type_ = 10;
UPDATE data_universe SET Name = 'GARMIN LTD BDR EACH 16 REPR 1 COM' WHERE SecCode = 4079191 AND Type_ = 10;
UPDATE data_universe SET Name = 'VIVMARK RESIDENTIA BDR EACH 2 REPR 1 COM' WHERE SecCode = 4079198 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 = 'S' WHERE SecCode = 4335872 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4375184 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 PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-02-26', PermQuoteRetireDate = '2026-08-18', PermSecMapEndDate = '2026-08-18', endDate = '2026-02-26' WHERE SecCode = 4634180 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000485658', RkdTicker = 'PM1', RkdSEDOL = 'BVK8SY', RkdRIC = 'PM1.AX', RkdDisplayRIC = 'PM1.AX', Name = 'PALISADE METALS LT NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4702568 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 4854770 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6416387 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '544794', QuotePermID = 236805390569.0, ExchCode = 'BSE' WHERE SecCode = 6930638 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'FI4000602354', RkdTicker = 'IQMX', RkdSEDOL = 'BV86WH', RkdCUSIP = 'X4R3H110', RkdRIC = 'IQMXC.HE', RkdDisplayRIC = 'IQMXC.HE', RkdCode = 141712.0, RkdIssueID = 3.0, RkdIssueCode = 182207.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HEL', RkdExchCtry = 'FIN', PrimaryIssueType = 'EQU', PrimaryIssueCode = 141712.0, COATypeCode = 'IND' WHERE SecCode = 6960587 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6982422 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 7017401 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-19', SecMapEndDate = '2026-08-18', endDate = '2026-08-18' WHERE SecCode = 7020253 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '544854', QuotePermID = 236803383890.0, ExchCode = 'BSE' WHERE SecCode = 7034030 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '544858', QuotePermID = 236802548447.0, ExchCode = 'BSE' WHERE SecCode = 7044198 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11044306 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2024-09-06' WHERE SecCode = 11074036 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXWZH80' WHERE SecCode = 11178737 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11193348 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-08-18', PermSecMapEndDate = '2026-08-18' WHERE SecCode = 11210508 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BT6M3W5' WHERE SecCode = 11215364 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-18', SecMapEndDate = '2026-08-17', endDate = '2026-08-17' WHERE SecCode = 11228754 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVSP928' WHERE SecCode = 11253723 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11260086 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG904751156', RkdSEDOL = 'BX2GLV', RkdCUSIP = 'G9047511', RkdListingType = 'OSR', ShPerListing = NULL WHERE SecCode = 11269292 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11277444 AND Type_ = 1;
UPDATE data_universe SET Name = 'NEIGHBORHOOD INTELLIGENCE IN *W EXP 07/23/2031' WHERE SecCode = 11286777 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11287866 AND Type_ = 1;
UPDATE data_universe SET Name = 'AGNICO EAGLE MINES LTD RIGHT 06/16/2036' WHERE SecCode = 11297634 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CGCF', QuotePermID = 236812531569.0, InstrPermID = 232933598514.0, OrgPermID = 6000157948.0, PriTrdQuotePermID = 236812531569.0, PriValQuotePermID = 25726993439.0, PriInstrPermID = 232933598514.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-06-25', PermSecMapStartDate = '2026-08-15', startDate = '2026-06-25' WHERE SecCode = 11300572 AND Type_ = 1;