UPDATE data_universe SET RkdRIC = 'IDOXgb.ASE^G26', RkdIssueStatus = 0.0 WHERE SecCode = 4259 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 13986 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'AHORRO FAMILIAR SA EUR6', PermInstrStatus = 'AC' WHERE SecCode = 34112 AND Type_ = 10;
UPDATE data_universe SET Name = 'STOCKWIK AB NPV' WHERE SecCode = 45389 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 DsSecDelistDate = '2015-02-13' WHERE SecCode = 54533 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-17', SecMapEndDate = '2026-07-16', PermQuoteRetireDate = '2026-07-17', endDate = '2026-07-16' WHERE SecCode = 55872 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 68018 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BANPUU', DsCtryQtStatus = 'S' WHERE SecCode = 69239 AND Type_ = 10;
UPDATE data_universe SET Name = 'FREET INC KRW2500', DsCtryQtStatus = 'A' WHERE SecCode = 70873 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FBRDD', DsPrimQtSedol = 'BTJTN67', SecMapEndDate = '2026-07-15', endDate = '2026-07-15' WHERE SecCode = 79182 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2021-08-18' WHERE SecCode = 80873 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BANPUU-R', DsCtryQtStatus = 'S' WHERE SecCode = 80912 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-01-28' WHERE SecCode = 82266 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82271 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82721 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-10-30' WHERE SecCode = 83255 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-07-26' WHERE SecCode = 84601 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL WHERE SecCode = 86473 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2011-02-23' WHERE SecCode = 87233 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-01-09' WHERE SecCode = 87506 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-10-29' WHERE SecCode = 87551 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-12-20' WHERE SecCode = 90098 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2006-01-20' WHERE SecCode = 90366 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90658 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 91810 AND Type_ = 10;
UPDATE data_universe SET Name = 'ARDI ALLIANCES LTD INR10' WHERE SecCode = 92181 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVZJWH9' WHERE SecCode = 92897 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-11-07' WHERE SecCode = 95612 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-09-03' WHERE SecCode = 97253 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2004-07-02' WHERE SecCode = 97361 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98797 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'GTLS.N^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-16', endDate = '2026-07-16' WHERE SecCode = 111353 AND Type_ = 1;
UPDATE data_universe SET DsSecDelistDate = '2025-01-09' WHERE SecCode = 114591 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-15', endDate = '2026-07-15' WHERE SecCode = 125248 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX2JGG3' WHERE SecCode = 126797 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-09-03' WHERE SecCode = 132667 AND Type_ = 10;
UPDATE data_universe SET Name = 'RUKUN RAHARJA IDR5' WHERE SecCode = 145040 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'CPRX.OQ^G26', RkdIssueStatus = 0.0, SecMapEndDate = '2026-07-14', PermSecMapEndDate = '2026-07-16', endDate = '2026-07-14' WHERE SecCode = 181407 AND Type_ = 1;
UPDATE data_universe SET Name = 'WORLD COPPER LTD COM', DsPrimQtSedol = 'BX2GQH5' WHERE SecCode = 291245 AND Type_ = 1;
UPDATE data_universe SET PriValQuotePermID = 236809843802.0 WHERE SecCode = 377680 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2018-09-21' WHERE SecCode = 418416 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2008-05-30' WHERE SecCode = 522605 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-17', SecMapEndDate = '2024-11-27', PermQuoteRetireDate = '2026-07-17', endDate = '2024-11-27' WHERE SecCode = 546068 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951347.0 WHERE SecCode = 561052 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 810847 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-04-29' WHERE SecCode = 962216 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 962511 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 1240100 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FBRDD', DsPrimQtSedol = 'BTJTN67' WHERE SecCode = 1486652 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1522789 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1580356 AND Type_ = 10;
UPDATE data_universe SET Name = 'SINCLAIR GOLD LTD NPV' WHERE SecCode = 1621235 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1622760 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN011', QuotePermID = 21512412458.0, ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2226891 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2457963 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-02-17' WHERE SecCode = 2566755 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2636886 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 98698.0 WHERE SecCode = 2697387 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-02-09' WHERE SecCode = 2701613 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2717421 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FBRDD', DsPrimQtSedol = 'BTJTN67' WHERE SecCode = 2864335 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3124242 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3258936 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3259989 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3271698 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-07-24' WHERE SecCode = 3347766 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 3392101 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-17', SecMapEndDate = '2026-07-16', PermQuoteRetireDate = '2026-07-17', endDate = '2026-07-16' WHERE SecCode = 3392421 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-09-03' WHERE SecCode = 3825559 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BRJSMB8' WHERE SecCode = 3917553 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4053515 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2022-06-17' WHERE SecCode = 4077688 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7317.T^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-17', SecMapEndDate = '2026-07-16', endDate = '2026-07-16' WHERE SecCode = 4194828 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4287539 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4341612 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4642911 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2022-11-22' WHERE SecCode = 4675202 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-08-17' WHERE SecCode = 4739247 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VAN', DsPrimQtSedol = 'BX3CHD5' WHERE SecCode = 4842750 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4871287 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-12-06' WHERE SecCode = 4882380 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-31' WHERE SecCode = 5059311 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXS3SF2' WHERE SecCode = 5122912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5146920 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-07-07' WHERE SecCode = 5454697 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-08-04' WHERE SecCode = 5455473 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-07-22' WHERE SecCode = 5455477 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-04-02' WHERE SecCode = 5551976 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5617213 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-09-02' WHERE SecCode = 5850296 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-09-17' WHERE SecCode = 5883107 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6043647 AND Type_ = 10;
UPDATE data_universe SET Name = 'AQARIOS QUANTUM TE NPV' WHERE SecCode = 6056914 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-04-25' WHERE SecCode = 6186416 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-09-29' WHERE SecCode = 6429307 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2025-09-29' WHERE SecCode = 6429308 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6503362 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6538872 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6587240 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0028778498', RkdTicker = 'AIRA', RkdSEDOL = 'BT5HXQ', RkdCUSIP = 'W0317B10', RkdRIC = 'AIRA.ST', RkdDisplayRIC = 'AIRA.ST', RkdCode = 145182.0, RkdIssueID = 1.0, RkdIssueCode = 185776.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'STO', RkdExchCtry = 'SWE', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6893660 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6951851 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007RM9', RkdTicker = '6951', RkdSEDOL = 'BTFGMX', RkdCUSIP = 'Y1R99A11', RkdRIC = '6951.HK', RkdDisplayRIC = '6951.HK', RkdCode = 145181.0, RkdIssueID = 1.0, RkdIssueCode = 185774.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', PrimaryIssueCode = 98698.0, RelType = 4.0, COATypeCode = '' WHERE SecCode = 6974599 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX2GLT2' WHERE SecCode = 10912673 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11024463 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000191567.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951641.0, PermOrgIPODate = NULL WHERE SecCode = 11028764 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX2GQ53' WHERE SecCode = 11068907 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11111276 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'PHA.H', PermIDTicker = 'PHA.H', RkdRIC = 'PHAh.V', RkdDisplayRIC = 'PHAh.V', RkdExchCode = 'NEX', ExchCode = 'NEX' WHERE SecCode = 11192959 AND Type_ = 1;
UPDATE data_universe SET Name = 'QUHUO LTD CLS A SHS', DsPrimQtSedol = 'BXP2VS6', DsTypeCode = 'EQ', QuoteClass = 'ORD', InstrClass = 'ORD' WHERE SecCode = 11209704 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11210591 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'ORGN.OQ^G26', RkdIssueStatus = 0.0, SecMapEndDate = '2026-07-01', PermSecMapEndDate = '2026-07-16', endDate = '2026-07-01' WHERE SecCode = 11211867 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-16', SecMapEndDate = '2026-07-15', endDate = '2026-07-15' WHERE SecCode = 11227222 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, SecMapEndDate = '2026-07-14', PermSecMapEndDate = '2026-07-16', endDate = '2026-07-14' WHERE SecCode = 11228018 AND Type_ = 1;
UPDATE data_universe SET DsSecDelistDate = '2024-03-14' WHERE SecCode = 11232506 AND Type_ = 1;
UPDATE data_universe SET DsSecDelistDate = '2023-12-12' WHERE SecCode = 11234554 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11244056 AND Type_ = 1;
UPDATE data_universe SET Name = 'HONGLI GROUP INC. ORD SHS CL A' WHERE SecCode = 11250986 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'DPU', Name = 'TOP KINGWIN LTD SHS CLASS A' WHERE SecCode = 11251027 AND Type_ = 1;
UPDATE data_universe SET DsSecDelistDate = '2025-12-02' WHERE SecCode = 11255285 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11261977 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL, PermOrgIPODate = NULL, startDate = '2024-03-26' WHERE SecCode = 11263764 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11264576 AND Type_ = 1;
UPDATE data_universe SET Name = 'TRIDENT DIGITAL TECH HOLDING ORD CLASS B', QuoteClass = 'ORD', InstrClass = 'ORD' WHERE SecCode = 11269292 AND Type_ = 1;
UPDATE data_universe SET DsSecDelistDate = '2026-02-17' WHERE SecCode = 11278260 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11282219 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11286103 AND Type_ = 1;
UPDATE data_universe SET Name = '55 NORTH GOLD INC COM SHS' WHERE SecCode = 11286526 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BX2GM22' WHERE SecCode = 11288189 AND Type_ = 1;
UPDATE data_universe SET Name = 'FORBRIGHT INC CL A COM' WHERE SecCode = 11297376 AND Type_ = 1;
