UPDATE data_universe_ds2 SET Name = 'SODITECH EUR0.7' WHERE SecCode = 45560 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2023-05-04', SecMapEndDate = '2023-04-27' WHERE SecCode = 48441 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2021-01-13', SecMapEndDate = '2021-01-04' WHERE SecCode = 61041 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2018-02-20', SecMapEndDate = '2018-02-19' WHERE SecCode = 65927 AND Type_ = 10;
UPDATE data_universe_ds2 SET ISIN = NULL, Name = 'CAISSA TOURISM GRO ''A''CNY1' WHERE SecCode = 67405 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-12', SecMapEndDate = '2024-01-08' WHERE SecCode = 68049 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BS46CY7' WHERE SecCode = 68937 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 70969 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 73099 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'TENNESSEE VALLEY AUTH FED BE PARRS D 2028' WHERE SecCode = 75120 AND Type_ = 1;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 75309 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 76156 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'VODAFONE GROUP PLC SPONSORED ADR' WHERE SecCode = 80306 AND Type_ = 1;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 84223 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'AGENT AI CO LTD KRW500' WHERE SecCode = 87756 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-13', SecMapEndDate = '2025-12-08' WHERE SecCode = 87959 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'GDI INTEGRATED FAC SVCS INC SUBORDINATE VTG' WHERE SecCode = 91135 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'CANADIAN TIRE CORPORATION LT CL A' WHERE SecCode = 91939 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'CANADIAN UTILS CDS BOOK ENTR CL A' WHERE SecCode = 91961 AND Type_ = 1;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-13', SecMapEndDate = '2026-01-09' WHERE SecCode = 95397 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 96544 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 98235 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 105003 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BSD5VX7' WHERE SecCode = 123967 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'SKM EGG PRODUCTS INR5' WHERE SecCode = 145678 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'CANADIAN GOLDFIELDS DISCOVER COM' WHERE SecCode = 330805 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'CATALINA RESOURCES NPV' WHERE SecCode = 557332 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 593923 AND Type_ = 10;
UPDATE data_universe_ds2 SET ISIN = NULL WHERE SecCode = 991953 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-13', SecMapEndDate = '2026-01-06' WHERE SecCode = 1166946 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 1181384 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 1494099 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 1497364 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A', DsPrimQtSedol = 'BVPLT30' WHERE SecCode = 1900549 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'SOILBUILD CONSTRUC NPV (POST-SPLT)' WHERE SecCode = 2246445 AND Type_ = 10;
UPDATE data_universe_ds2 SET ISIN = NULL WHERE SecCode = 2260564 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-08-18', SecMapEndDate = '2025-08-15' WHERE SecCode = 2444970 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 2457965 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 2535221 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 2706356 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsTypeCode = 'EQ' WHERE SecCode = 2753900 AND Type_ = 10;
UPDATE data_universe_ds2 SET SecMapEndDate = '2025-12-29' WHERE SecCode = 2912878 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 2994441 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 3108143 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-10-14', SecMapEndDate = '2024-08-13' WHERE SecCode = 3146732 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2024-10-07', SecMapEndDate = '2023-08-08' WHERE SecCode = 3317346 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 3321443 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-13' WHERE SecCode = 3322264 AND Type_ = 10;
UPDATE data_universe_ds2 SET ISIN = NULL, Name = 'ANHUI ORIVIE TECHN A CNY1' WHERE SecCode = 3385844 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 3569570 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 3740587 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-12', SecMapEndDate = '2025-12-30' WHERE SecCode = 3852893 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 4010776 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 4035749 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 4300561 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 4441403 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsSecDelistDate = '2025-08-22' WHERE SecCode = 4463095 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 4558219 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 4617629 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsSecDelistDate = '2025-08-26' WHERE SecCode = 4640279 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 4796256 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 4908363 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 5037204 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BV2C3W3' WHERE SecCode = 5301614 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 5493163 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 5546615 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BLH4700', DsTypeCode = 'EQ' WHERE SecCode = 5626479 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 5649894 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 5652422 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 5824136 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'STAG INDUSTRIAL INC COM' WHERE SecCode = 11001987 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'ILC CRITICAL MINERALS LTD COM' WHERE SecCode = 11004009 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'CHAR TECHNOLOGIES INC NEW COM' WHERE SecCode = 11117583 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'IRHYTHM HOLDINGS INC COM' WHERE SecCode = 11163237 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'ZEV VENTURES INC COM NEW' WHERE SecCode = 11181887 AND Type_ = 1;
UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BS46BT5' WHERE SecCode = 11198773 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'LEONABIO, INC COM' WHERE SecCode = 11212286 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'METAGENOMI THERAPEUTICS INC COM' WHERE SecCode = 11262405 AND Type_ = 1;
UPDATE data_universe_ds2 SET IsMajorSec = 'N' WHERE SecCode = 11289546 AND Type_ = 1;
