UPDATE data_universe SET DsExchQtStartDate = '1995-04-21' WHERE SecCode = 27223 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEWCAP HOLDING A/S DKK100', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 38881 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 39884 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'VRE.N^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-27', SecMapEndDate = '2026-05-26', PermQuoteRetireDate = '2026-05-27', PermSecMapEndDate = '2026-05-27', endDate = '2026-05-26' WHERE SecCode = 43982 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-05-27' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21500701254.0, PermQuoteStatus = 'AC', ExchCode = 'STU', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 56158 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BN4KLB4' WHERE SecCode = 66361 AND Type_ = 10;
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 RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET Name = 'MGEN SOLUTIONS KRW1000' WHERE SecCode = 75296 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75305 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 DsCtryQtStatus = 'S' WHERE SecCode = 79308 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 80572 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81554 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951343.0 WHERE SecCode = 86158 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87142 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6489.T^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-28', SecMapEndDate = '2026-05-27', endDate = '2026-05-27' WHERE SecCode = 87909 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7925.T^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-28', SecMapEndDate = '2026-05-27', endDate = '2026-05-27' WHERE SecCode = 88123 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88208 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BW61LW9' WHERE SecCode = 88263 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'E-STARCO CO LTD KRW1000' WHERE SecCode = 89357 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 Name = 'DUFU LIQUOR GROUP HKD0.01' WHERE SecCode = 90242 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 95693 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 95711 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '2026-05-26' WHERE SecCode = 96942 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '5727.T^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-28', SecMapEndDate = '2026-05-27', endDate = '2026-05-27' WHERE SecCode = 97597 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-27', endDate = '2026-05-27' WHERE SecCode = 100775 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 101143 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 101206 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951542.0 WHERE SecCode = 112367 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115197 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 139835 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-28', SecMapEndDate = '2026-05-26', PermQuoteRetireDate = '2026-05-27', endDate = '2026-05-26' WHERE SecCode = 145065 AND Type_ = 10;
UPDATE data_universe SET Name = 'LANSDOWNE OIL&GAS ORD GBP0.0005', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 145107 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTHZM26' WHERE SecCode = 161158 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NANO CHEM TECH INC KRW2500' WHERE SecCode = 195173 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 269312 AND Type_ = 1;
UPDATE data_universe SET Name = 'DAESAN F&B INC KRW1000' WHERE SecCode = 309233 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951542.0 WHERE SecCode = 425352 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2008-06-09' WHERE SecCode = 521938 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'TKC.HNO^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-28', SecMapEndDate = '2023-09-22', PermQuoteRetireDate = '2026-05-28', endDate = '2023-09-22' WHERE SecCode = 556650 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 556899 AND Type_ = 10;
UPDATE data_universe SET Name = 'VISION VALUES HOLD HKD0.1' WHERE SecCode = 703142 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 833514 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NEXTEYE CO LTD KRW1000' WHERE SecCode = 1157094 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLIT', QuotePermID = 21482228292.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 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 QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3030734 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 3049340 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-28', SecMapEndDate = '2026-05-19', endDate = '2026-05-19' WHERE SecCode = 3182305 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RANDA', DsPrimQtSedol = 'BKVF423' WHERE SecCode = 3207868 AND Type_ = 10;
UPDATE data_universe SET Name = 'GOLD TOWN GAMES NPV' WHERE SecCode = 3212737 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3270931 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3288947 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3338134 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3375307 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3441265 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SASSEUR REIT NPV (REIT)' WHERE SecCode = 3441670 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2018-07-23' WHERE SecCode = 3555006 AND Type_ = 10;
UPDATE data_universe SET Name = 'JOYWORKS&CO CO LTD KRW500', DsCtryQtStatus = 'S' WHERE SecCode = 3706496 AND Type_ = 10;
UPDATE data_universe SET Name = 'COPUS KOREA CO LTD KRW500' WHERE SecCode = 3849303 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 WHERE SecCode = 4272422 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 PrimaryIssueCode = NULL WHERE SecCode = 4425536 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 DsCtryQtStatus = 'S' WHERE SecCode = 5147782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5197293 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NGO', DsExchQtStartDate = '2023-01-26' WHERE SecCode = 5316695 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2023-05-11' WHERE SecCode = 5417648 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5572142 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5745928 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6075866 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6667908 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-28', SecMapEndDate = '2026-05-27', endDate = '2026-05-27' WHERE SecCode = 6806141 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-05-18', startDate = '2026-05-18' WHERE SecCode = 6854845 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6870727 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BW5VPW8' WHERE SecCode = 10928316 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BW5VPT5' WHERE SecCode = 10964546 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VIBED', QuotePermID = 25727375347.0, IsPrimaryQuote = 0.0, ExchCode = 'PNK', PermSecMapStartDate = '2024-06-01', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11024402 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA39138C7594', RkdTicker = 'GWO.PR.R', RkdSEDOL = 'B8J3QK', RkdCUSIP = '39138C75', RkdRIC = 'GWO_pr.TO', RkdDisplayRIC = 'GWO_pr.TO', RkdCode = 14935.0, RkdIssueID = 8.0, RkdIssueCode = 114103.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 7.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'FIN' WHERE SecCode = 11036855 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11131840 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA39138C7347', RkdTicker = 'GWO.PR.S', RkdSEDOL = 'BMQXL1', RkdCUSIP = '39138C73', RkdRIC = 'GWO_ps.TO', RkdDisplayRIC = 'GWO_ps.TO', RkdCode = 14935.0, RkdIssueID = 9.0, RkdIssueCode = 185348.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 8.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'FIN' WHERE SecCode = 11135614 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA39138C7263', RkdTicker = 'GWO.PR.T', RkdSEDOL = 'BYYK3H', RkdCUSIP = '39138C72', RkdRIC = 'GWO_pt.TO', RkdDisplayRIC = 'GWO_pt.TO', RkdCode = 14935.0, RkdIssueID = 10.0, RkdIssueCode = 185349.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 9.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'FIN' WHERE SecCode = 11172683 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AIFA' WHERE SecCode = 11178317 AND Type_ = 1;
UPDATE data_universe SET Name = 'ROCKET ONE INC COM' WHERE SecCode = 11193974 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ACT', DsExchMnem = 'TSE', QuotePermID = 21682529071.0, IsPrimaryQuote = 1.0, ExchCode = 'TOR', PermSecMapStartDate = '2024-08-20' WHERE SecCode = 11194103 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11195740 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951271.0 WHERE SecCode = 11209569 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951271.0 WHERE SecCode = 11211234 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA39138C6927', RkdTicker = 'GWO.PR.Y', RkdSEDOL = 'BP0PT0', RkdCUSIP = '39138C69', RkdRIC = 'GWO_py.TO', RkdDisplayRIC = 'GWO_py.TO', RkdCode = 14935.0, RkdIssueID = 11.0, RkdIssueCode = 185350.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 10.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'FIN' WHERE SecCode = 11231924 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'SKYA', RkdRIC = 'SKYA.O', RkdDisplayRIC = 'SKYA.OQ', Name = 'SKYAI INC COMMON STOCK' WHERE SecCode = 11240940 AND Type_ = 1;
UPDATE data_universe SET Name = 'SKYAI INC *W EXP 99/99/9999' WHERE SecCode = 11240954 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 11260395 AND Type_ = 1;
UPDATE data_universe SET Name = 'GIGCAPITAL7 CORP UNIT 08/26/2029' WHERE SecCode = 11268849 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 11270118 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11274176 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11275132 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CCAQU' WHERE SecCode = 11277562 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CCAQ' WHERE SecCode = 11279225 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA39138C6844', RkdTicker = 'GWO.PR.Z', RkdSEDOL = 'BV8CNW', RkdCUSIP = '39138C68', RkdRIC = 'GWO_pz.TO', RkdDisplayRIC = 'GWO_pz.TO', RkdCode = 14935.0, RkdIssueID = 12.0, RkdIssueCode = 185351.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 11.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'FIN' WHERE SecCode = 11285638 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BW5VP73' WHERE SecCode = 11286854 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11295488 AND Type_ = 1;
