UPDATE data_universe_ds2 SET SecMapEndDate = '2025-12-22' WHERE SecCode = 30013 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsExchQtStartDate = '1994-01-06' WHERE SecCode = 42414 AND Type_ = 10;
UPDATE data_universe_ds2 SET SecMapEndDate = '2026-06-23' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 49597 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-18' WHERE SecCode = 55789 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 72682 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BTZCS54', SecMapEndDate = '2026-06-22' WHERE SecCode = 78713 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 81778 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 83518 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'CHUBB LIMITED COM' WHERE SecCode = 83700 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'DYNASTY DIGITAL HKD0.083' WHERE SecCode = 92589 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsSecDelistDate = '2024-10-01' WHERE SecCode = 95595 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'CHA AI HLTH KARE KRW500' WHERE SecCode = 95821 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 127118 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'NEOTERRA GROUP PLC ORD GBP0.01' WHERE SecCode = 131838 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-24', SecMapEndDate = '2026-05-20' WHERE SecCode = 136156 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 195140 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'LSKAIROBOT CO LTD KRW2500' WHERE SecCode = 195173 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-10' WHERE SecCode = 206733 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 288634 AND Type_ = 10;
UPDATE data_universe_ds2 SET SecMapEndDate = '2079-06-06' WHERE SecCode = 336664 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 457880 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 541069 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-10' WHERE SecCode = 562896 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'NEOVACS EUR1 (POST CONS)' WHERE SecCode = 588831 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'PHIONX USD0.15' WHERE SecCode = 637304 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-24', SecMapEndDate = '2026-04-01' WHERE SecCode = 798142 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-23' WHERE SecCode = 1459417 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 1459462 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BTZCS54' WHERE SecCode = 1522818 AND Type_ = 10;
UPDATE data_universe_ds2 SET ISIN = NULL WHERE SecCode = 1599586 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'JAKOTA CAPITAL (HO HKD0.1' WHERE SecCode = 1660603 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 2428148 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'FIRST INV.CO.R/EST EGP0.5' WHERE SecCode = 2462655 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 2462661 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 2693646 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'S' WHERE SecCode = 2862763 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'ATMA INDUSTRIES LI INR10' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe_ds2 SET ISIN = NULL WHERE SecCode = 2976322 AND Type_ = 10;
UPDATE data_universe_ds2 SET ISIN = NULL, Name = 'CHINA CRYSTAL NEW USD2.0' WHERE SecCode = 3076058 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 3262686 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'AAC CLYDE SPACE AB NPV' WHERE SecCode = 3284914 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'BEAUTIFUL LIFE GP HKD0.01' WHERE SecCode = 3327782 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'REACH NEW HLDGS LT HKD0.2' WHERE SecCode = 3378476 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 3395672 AND Type_ = 10;
UPDATE data_universe_ds2 SET ISIN = NULL WHERE SecCode = 3401658 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-24', SecMapEndDate = '2026-06-19' WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'COMINTELL' WHERE SecCode = 3721197 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'AMAERO INC NPV CDI 40:1', Country = 'USA' WHERE SecCode = 4036738 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'HUMAN XTENSIONS LT ILS0.01' WHERE SecCode = 4429560 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'METAVISIO SA EUR0.002' WHERE SecCode = 4796000 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsExchQtStartDate = '2023-06-30' WHERE SecCode = 5455474 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsExchQtStartDate = '2023-06-29' WHERE SecCode = 5455477 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-24', SecMapEndDate = '2026-06-23' WHERE SecCode = 6857266 AND Type_ = 10;
UPDATE data_universe_ds2 SET Name = 'DALY RESOURCES NPV' WHERE SecCode = 6930668 AND Type_ = 10;
UPDATE data_universe_ds2 SET DsExchMnem = 'TSE' WHERE SecCode = 11015873 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'HAPPEN INC COM NEW' WHERE SecCode = 11142751 AND Type_ = 1;
UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BW60F13' WHERE SecCode = 11176481 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'CAT STRATEGIC METALS CORP COM SHS' WHERE SecCode = 11203366 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'FIRY INC COM CL A' WHERE SecCode = 11207267 AND Type_ = 1;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-22' WHERE SecCode = 11210606 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'RUM GROUP INC COM CL A' WHERE SecCode = 11222408 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'RUM GROUP INC *W EXP 09/16/2027' WHERE SecCode = 11222507 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'SMARTBIRD INC CL A NEW' WHERE SecCode = 11233216 AND Type_ = 1;
UPDATE data_universe_ds2 SET DsPrimQtSedol = 'BVSRPB5' WHERE SecCode = 11262021 AND Type_ = 1;
UPDATE data_universe_ds2 SET Name = 'NORTHMIN CORP COM SHS' WHERE SecCode = 11266759 AND Type_ = 1;
UPDATE data_universe_ds2 SET Country = 'USA' WHERE SecCode = 11277550 AND Type_ = 1;
UPDATE data_universe_ds2 SET DsCtryQtStatus = 'A' WHERE SecCode = 11286891 AND Type_ = 1;
UPDATE data_universe_ds2 SET IsMajorSec = 'N' WHERE SecCode = 11295230 AND Type_ = 1;
