UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-22', PermSecMapEndDate = '2026-07-22' WHERE SecCode = 17852 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000174232.0, PriTrdQuotePermID = NULL, PriValQuotePermID = 55835320972.0, PriInstrPermID = 8590940909.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, startDate = '1991-06-11' WHERE SecCode = 26606 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55846120871.0, ExchCode = 'CPH' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-07-22' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 61660 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET Name = 'DELEK PROP DEV LTD ILS0.1(POST SUBD)' WHERE SecCode = 75262 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 DsCtryQtStatus = 'S' WHERE SecCode = 77098 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TIANYI WATER ENERG TWD10' WHERE SecCode = 79892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81730 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-24' WHERE SecCode = 83485 AND Type_ = 10;
UPDATE data_universe SET Name = 'VISUAL PHOTONICS TWD10' WHERE SecCode = 83819 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 86168 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DONGWON MOBILITY KRW500' WHERE SecCode = 87084 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 RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000480642', RkdTicker = 'ARO', RkdSEDOL = 'BT67DK', RkdRIC = 'ARO.AX', RkdDisplayRIC = 'ARO.AX', DsPrimQtSedol = 'BT67DK8', SecMapEndDate = '2026-07-21', endDate = '2026-07-21' WHERE SecCode = 92639 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000090017.0, PriInstrPermID = 8589997975.0, PermOrgIPODate = NULL WHERE SecCode = 93063 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 PermQuoteStatus = 'DC' WHERE SecCode = 96636 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GORO' WHERE SecCode = 99271 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115281 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-23', SecMapEndDate = '2026-07-22', endDate = '2026-07-22' WHERE SecCode = 121063 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 125696 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142298 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SHENGRONG HLDG LTD HKD0.25' WHERE SecCode = 166185 AND Type_ = 10;
UPDATE data_universe SET Name = 'WORLD COPPER LTD COM SHS' WHERE SecCode = 291245 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 323135 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000079192.0, PriInstrPermID = 21765344631.0, PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = '2020-08-21' WHERE SecCode = 336464 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 343233 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 355342 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 395048 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 400273 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 516194 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 752070 AND Type_ = 10;
UPDATE data_universe SET Name = 'CAPITAL B EUR0.08' WHERE SecCode = 1178962 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1200611 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET Name = 'MEPET METRO PETROL TRY1 (B SHARES)' WHERE SecCode = 1252935 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET Name = 'HEMP & HEALTH SA PLN0.10' WHERE SecCode = 1660626 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN011', QuotePermID = 21512412458.0, ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NIPPON REIT INVEST REIT' WHERE SecCode = 2536082 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'CAP', RkdRIC = 'CAP2.DE', RkdDisplayRIC = 'CAP2.DE' WHERE SecCode = 2830908 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-22' WHERE SecCode = 3026504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3048443 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247331 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'EMS' WHERE SecCode = 3285690 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CRE LOGISTICS REIT REIT' WHERE SecCode = 3431318 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3441651 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 ISIN = NULL, DsCtryQtStatus = 'S' WHERE SecCode = 4032215 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT67DK8' WHERE SecCode = 4058518 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 PermInstrStatus = 'DC' WHERE SecCode = 4434365 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4487673 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 QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21932177205.0, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5059330 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5234138 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 129604.0 WHERE SecCode = 5408126 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'TAI', ExchCode = 'TAI' WHERE SecCode = 5476908 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '5022.T^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-07-23', SecMapEndDate = '2026-07-16', endDate = '2026-07-16' WHERE SecCode = 5567944 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'BRM.MI^G26', RkdIssueStatus = 0.0, PrimaryIssueType = 'IPO', PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-22' WHERE SecCode = 6389710 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 6472078 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 6472080 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 6472081 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 6472082 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6870704 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000468936', RkdTicker = 'DLY', RkdSEDOL = 'BTGRDC', RkdCUSIP = 'Q3272V10', RkdRIC = 'DLY.AX', RkdDisplayRIC = 'DLY.AX', RkdCode = 145210.0, RkdIssueID = 1.0, RkdIssueCode = 185813.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6930668 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SA16J034MRH7', RkdTicker = '9655', RkdSEDOL = 'BXM0PN', RkdCUSIP = 'M706BG10', RkdRIC = '9655.SE', RkdDisplayRIC = '9655.SE', RkdCode = 145207.0, RkdIssueID = 1.0, RkdIssueCode = 185808.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SAU', RkdExchCtry = 'SAU', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6969155 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007Q87', RkdTicker = '2249', RkdSEDOL = 'BTFGMT', RkdCUSIP = 'Y6306811', RkdRIC = '2249.HK', RkdDisplayRIC = '2249.HK', RkdCode = 145208.0, RkdIssueID = 1.0, RkdIssueCode = 185810.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', PrimaryIssueCode = 129604.0, RelType = 4.0, COATypeCode = '' WHERE SecCode = 6977544 AND Type_ = 10;
UPDATE data_universe SET Name = 'DELEK PROP DEV LTD ILS0.1' WHERE SecCode = 6980292 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232943730754.0, IsPrimaryInstr = 1.0 WHERE SecCode = 6982424 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6997069 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475110262.0, ExchCode = 'NSQ' WHERE SecCode = 10965319 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US9630257544', RkdSEDOL = 'BX55HP', RkdCUSIP = '96302575' WHERE SecCode = 11015187 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11046293 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BT5DFH8' WHERE SecCode = 11061719 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'NSA.N^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-07-22', SecMapEndDate = '2026-07-21', endDate = '2026-07-21' WHERE SecCode = 11147409 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PWCM', Name = 'POWERCOMPUTE INC COM' WHERE SecCode = 11151156 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CHGA', Name = 'CHANGE AGENTS CORP COM' WHERE SecCode = 11156680 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'NSA_pa.N^G26', Name = 'PUBLIC STORAGE 6 PFD BEN INT T', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-07-22', SecMapEndDate = '2026-07-21', endDate = '2026-07-21' WHERE SecCode = 11177647 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BPY059' WHERE SecCode = 11181200 AND Type_ = 1;
UPDATE data_universe SET Name = 'COLUMBIA FINL INC COM SHS' WHERE SecCode = 11184721 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US22053A3059', RkdSEDOL = 'BWXHR5', RkdCUSIP = '22053A30' WHERE SecCode = 11196712 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2019-12-16' WHERE SecCode = 11203233 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-22', SecMapEndDate = '2026-07-21', endDate = '2026-07-21' WHERE SecCode = 11214172 AND Type_ = 1;
UPDATE data_universe SET Name = 'KORE GROUP HLDGS INC COM NEW' WHERE SecCode = 11216102 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'GRSD', RkdRIC = 'GRSD.O', RkdDisplayRIC = 'GRSD.OQ', Name = 'GRANDSTAND LIMITED ORDINARY SHARES' WHERE SecCode = 11227626 AND Type_ = 1;
UPDATE data_universe SET Name = 'VULCAN INFRASTRUCTURE & PWR CLASS A COM' WHERE SecCode = 11230326 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11244657 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11251539 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'NSA_pb.N^G26', Name = 'PUBLIC STORAGE 6 SER U CUM RED', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-07-22', SecMapEndDate = '2026-07-21', endDate = '2026-07-21' WHERE SecCode = 11257506 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11260559 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'BAYA.OQ^G26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL, startDate = '2023-12-29' WHERE SecCode = 11260969 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11269247 AND Type_ = 1;
UPDATE data_universe SET Name = 'VELOS ACQUISITION I CORP CL A' WHERE SecCode = 11269897 AND Type_ = 1;
UPDATE data_universe SET Name = 'VELOS ACQUISITION I CORP UNIT 99/99/9999' WHERE SecCode = 11269939 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MEDS' WHERE SecCode = 11275132 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5071083136.0, PriInstrPermID = 232930373617.0, DomCntry = 'FIN', IncCntry = 'FIN', PriTRBCIndPermID = 4294951243.0, PermOrgIPODate = '2026-07-03' WHERE SecCode = 11277714 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11298597 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BRTMU', QuotePermID = 236809829224.0, InstrPermID = 232944659822.0, OrgPermID = 6000183301.0, PriTrdQuotePermID = 236809829224.0, PriValQuotePermID = 25727006012.0, PriInstrPermID = 232944659822.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-07-21', PermSecMapStartDate = '2026-07-21' WHERE SecCode = 11299478 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NCOOU', QuotePermID = 236808503670.0, InstrPermID = 232940462128.0, OrgPermID = 6000163992.0, PriTrdQuotePermID = 236808503670.0, PriValQuotePermID = 25727017554.0, PriInstrPermID = 232940462128.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-07-21', PermSecMapStartDate = '2026-07-17', startDate = '2026-07-17' WHERE SecCode = 11299479 AND Type_ = 1;
