UPDATE data_universe SET DomCntry = 'DEU' WHERE SecCode = 7686 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'DEU' WHERE SecCode = 7699 AND Type_ = 10;
UPDATE data_universe SET Name = 'AXIA ENERGIA SA SPONSORED ADR' WHERE SecCode = 13061 AND Type_ = 1;
UPDATE data_universe SET Name = 'AXIA ENERGIA SA PREF A' WHERE SecCode = 27902 AND Type_ = 10;
UPDATE data_universe SET Name = 'AXIA ENERGIA SA PREF B' WHERE SecCode = 28602 AND Type_ = 10;
UPDATE data_universe SET Name = 'AXIA ENERGIA SA COM NPV' WHERE SecCode = 28624 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NEOE3.SA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-05', PermQuoteRetireDate = '2026-05-05', endDate = '2026-05-05' WHERE SecCode = 28992 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 31000 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 31098 AND Type_ = 1;
UPDATE data_universe SET PriValQuotePermID = 55838736412.0 WHERE SecCode = 31370 AND Type_ = 10;
UPDATE data_universe SET Name = 'GOLDEN ENTMT INC COM' WHERE SecCode = 41253 AND Type_ = 1;
UPDATE data_universe SET RkdListingType = 'GSR' WHERE SecCode = 46051 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-05-04' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 53093 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'FR00140173Y6', RkdSEDOL = 'BPH1RG', RkdCUSIP = 'F0428025', DsPrimQtSedol = 'BPH1RG5' WHERE SecCode = 63566 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, RkdRIC = 'SGMO.PK', RkdDisplayRIC = 'SGMO.PK', RkdExchCode = 'OTC', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-05', endDate = '2026-05-05' WHERE SecCode = 68111 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 69654 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71892 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73885 AND Type_ = 10;
UPDATE data_universe SET RkdListingType = 'CCR' WHERE SecCode = 73894 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951328.0 WHERE SecCode = 74291 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'FIRST PHILIPPINE H PHP10' WHERE SecCode = 74691 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75057 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 76132 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 DsCtryQtStatus = 'S' WHERE SecCode = 76376 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 76925 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'PEAX SOLUTIONS LTD ILS0.1' WHERE SecCode = 78182 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78324 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78583 AND Type_ = 10;
UPDATE data_universe SET Name = 'HLB INNOVATION KRW2500' WHERE SecCode = 78986 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 79084 AND Type_ = 10;
UPDATE data_universe SET Name = 'FILSYN CORPORATION ''A'' PHP0.5' WHERE SecCode = 79918 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y3R13H11' WHERE SecCode = 82274 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 82499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 82656 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86003 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '8126.HK^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-05', SecMapEndDate = '2026-05-04', endDate = '2026-05-04' WHERE SecCode = 87258 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'COSLEAGUER GLOBAL KRW500' WHERE SecCode = 87378 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87854 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 DomCntry = 'CYM' WHERE SecCode = 90496 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '1987-02-26' WHERE SecCode = 90585 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 94620 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 RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'F&J PRINCE HLDGS ''B''PHP1' WHERE SecCode = 98130 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'F&J PRINCE HLDGS ''A''PHP1' WHERE SecCode = 98238 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98341 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 99726 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA74061R1010', RkdSEDOL = 'BWH901', RkdCUSIP = '74061R10', DsPrimQtSedol = 'BWH9014' WHERE SecCode = 101281 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA74061R2000', RkdSEDOL = 'BWH8ZW', RkdCUSIP = '74061R20', Name = 'MULVIHILL CAPITAL MANAGEMENT PFD SHS', DsPrimQtSedol = 'BWH8ZW7' WHERE SecCode = 101282 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'FRA' WHERE SecCode = 101803 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115260 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115666 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115983 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 123430 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126259 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126433 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 126517 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 126583 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 128794 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 131454 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134905 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 135123 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 136292 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 136779 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 137018 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-05', SecMapEndDate = '2026-04-29', endDate = '2026-04-29' WHERE SecCode = 137592 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NATURE & ENVIRONME KRW5000' WHERE SecCode = 141951 AND Type_ = 10;
UPDATE data_universe SET Name = 'KESPION CO LTD KRW1000' WHERE SecCode = 142298 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q4771624' WHERE SecCode = 144424 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 144958 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145633 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 146722 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'P0R47710' WHERE SecCode = 147112 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HWAIL PHARM KRW 5000' WHERE SecCode = 169669 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BRSAUDACNOR9', RkdTicker = 'SAUD3', PermIDTicker = 'SAUD3', RkdRIC = 'SAUD3.SA', RkdDisplayRIC = 'SAUD3.SA' WHERE SecCode = 184471 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 192787 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'CHN' WHERE SecCode = 200890 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 214185 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 243314 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 254713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 256141 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 294085 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 311013 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 317135 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'BMU' WHERE SecCode = 334255 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55834800221.0, ExchCode = 'HKG', PermQuoteRetireDate = '2018-04-24', endDate = '2018-04-16' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475473201.0, ExchCode = 'GER' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 385049 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 386484 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951723.0 WHERE SecCode = 386790 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236798948725.0, ExchCode = 'DUS' WHERE SecCode = 396306 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU000000MMI6', RkdTicker = 'MMI', PermIDTicker = 'MMI', RkdSEDOL = 'BTDBK3', RkdCUSIP = 'Q6070X19', RkdRIC = 'MMI.AX', RkdDisplayRIC = 'MMI.AX', DsPrimQtSedol = 'BTDBK35' WHERE SecCode = 555050 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'TUR' WHERE SecCode = 561994 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21606036474.0, ExchCode = 'MUN', PermQuoteRetireDate = '2018-02-19' WHERE SecCode = 564280 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 826747 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 843994 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'PSG.HNO^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-05', SecMapEndDate = '2024-05-31', PermQuoteRetireDate = '2026-05-05', endDate = '2024-05-31' WHERE SecCode = 1043297 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951284.0 WHERE SecCode = 1064740 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET Name = 'BIOSYSEN HKD0.01' WHERE SecCode = 1239236 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1399557 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1470576 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ARE' WHERE SecCode = 2441640 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'VTL.WA^E26', RkdIssueStatus = 0.0 WHERE SecCode = 2458784 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2469416 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951263.0 WHERE SecCode = 2528823 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'GGY' WHERE SecCode = 2536035 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2593579 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2650080 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2725363 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2873693 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2882462 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 2905569 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 2945892 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2963471 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-05-04' WHERE SecCode = 3021792 AND Type_ = 10;
UPDATE data_universe SET Name = 'KUMHO HT INC KRW5000' WHERE SecCode = 3026618 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3072605 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931857.0, ExchCode = 'BTE' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21716782408.0, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21', endDate = '2021-01-20' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3256150 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951880.0 WHERE SecCode = 3273613 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BTQKTR62', RkdSEDOL = 'BTQKTR', RkdCUSIP = 'G4R38C10', DsPrimQtSedol = 'BTQKTR6' WHERE SecCode = 3288678 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3318951 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CYM' WHERE SecCode = 3350753 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3397138 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3433638 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'JEY' WHERE SecCode = 3438892 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21650788270.0, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE652Z01025', RkdSEDOL = 'BQT2PP', RkdCUSIP = 'Y048M912', DsPrimQtSedol = 'BQT2PP8' WHERE SecCode = 3559194 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3663161 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3841574 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3894832 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 ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 4066636 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4087764 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4211729 AND Type_ = 10;
UPDATE data_universe SET Name = 'HURUM CO LTD KRW500' WHERE SecCode = 4264589 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 DomCntry = 'CHL' WHERE SecCode = 4377438 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4443965 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4502482 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 4513760 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 = 4629357 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4645346 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'OPN.AX^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-04', PermQuoteRetireDate = '2026-05-04', PermOrgIPODate = NULL, endDate = '2026-05-04' WHERE SecCode = 4650985 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'P7S61C10' WHERE SecCode = 4668766 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4736609 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4821633 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4918578 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'CLGUN' WHERE SecCode = 4959591 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-05-04', endDate = '2026-04-14' WHERE SecCode = 5112392 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5142396 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'THA' WHERE SecCode = 5153431 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5195346 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951723.0 WHERE SecCode = 5227169 AND Type_ = 10;
UPDATE data_universe SET Name = 'SENSORVIEW CO LTD KRW100' WHERE SecCode = 5473222 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'AUS' WHERE SecCode = 5485039 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5489259 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5493583 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5819566 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5870946 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'THA' WHERE SecCode = 6047857 AND Type_ = 10;
UPDATE data_universe SET Name = 'INTL GEMOLOGICAL I INR2' WHERE SecCode = 6047860 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951723.0 WHERE SecCode = 6082611 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-04', PermQuoteRetireDate = '2026-05-04', PermOrgIPODate = NULL WHERE SecCode = 6100251 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6173318 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'AUS' WHERE SecCode = 6354186 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6482833 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6558331 AND Type_ = 10;
UPDATE data_universe SET Name = 'ESENTIA ENGY DEV NPV' WHERE SecCode = 6562724 AND Type_ = 10;
UPDATE data_universe SET Name = 'AXIA ENERGIA SA PREF C NPV' WHERE SecCode = 6610302 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-05', SecMapEndDate = '2026-05-04', endDate = '2026-05-04' WHERE SecCode = 6622347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-05-05', SecMapEndDate = '2026-05-04', endDate = '2026-05-04' WHERE SecCode = 6737828 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000457384', RkdTicker = 'VAL', RkdSEDOL = 'BW2JZ5', RkdCUSIP = 'Q9358110', RkdRIC = 'VAL.AX', RkdDisplayRIC = 'VAL.AX', RkdCode = 144747.0, RkdIssueID = 1.0, RkdIssueCode = 185108.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6737830 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6772978 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-04-30' WHERE SecCode = 6789603 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6802673 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '2945', QuotePermID = 236806319592.0, InstrPermID = 232932523991.0, OrgPermID = 4295871627.0, PriValQuotePermID = 236806319592.0, PriInstrPermID = 8590929117.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'BMU', PriTRBCIndPermID = 4294951550.0, PermQuoteRetireDate = '2026-05-21', PermOrgIPODate = '1992-11-12', PermSecMapStartDate = '2026-04-28', startDate = '2026-04-28' WHERE SecCode = 6813826 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236806332266.0, PermInstrStatus = 'AC', InstrClass = 'UNT' WHERE SecCode = 6813829 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '2946', QuotePermID = 236806328501.0, InstrPermID = 232932596300.0, OrgPermID = 5064646741.0, PriValQuotePermID = 236806328501.0, PriInstrPermID = 21655490017.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'CYM', PriTRBCIndPermID = 4294951593.0, PermQuoteRetireDate = '2026-06-08', PermOrgIPODate = '2019-02-15', PermSecMapStartDate = '2026-04-29', startDate = '2026-04-29' WHERE SecCode = 6820121 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 10906505 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US1709241046', RkdTicker = 'CHRN', PermIDTicker = 'CHRN', RkdSEDOL = 'BX565X', RkdCUSIP = '17092410', RkdRIC = 'CHRN.O', RkdDisplayRIC = 'CHRN.OQ', Name = 'CHRONOSCALE CORPORATION COM NEW', DsPrimQtSedol = 'BX565X1' WHERE SecCode = 11072364 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11142929 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000098180.0, PriInstrPermID = 21557558303.0, IncCntry = 'VGB' WHERE SecCode = 11153361 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'ERE_u.TO^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-05', endDate = '2026-05-05' WHERE SecCode = 11163321 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11172678 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL, IsPrimaryInstr = 0.0 WHERE SecCode = 11182728 AND Type_ = 1;
UPDATE data_universe SET RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11184700 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11196578 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11196721 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CAN' WHERE SecCode = 11205238 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2020-06-01' WHERE SecCode = 11205402 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11205537 AND Type_ = 1;
UPDATE data_universe SET Name = 'ONTERRIS INC COM' WHERE SecCode = 11210284 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'UHG.OQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-05', SecMapEndDate = '2026-05-01', PermQuoteRetireDate = '2026-05-05', endDate = '2026-05-01' WHERE SecCode = 11221146 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11224790 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'AUS' WHERE SecCode = 11225564 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11236613 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA88433P1062', RkdTicker = 'TRCG', PermIDTicker = 'TRCG', RkdSEDOL = 'BWH8ZY', RkdCUSIP = '88433P10', RkdRIC = 'TRCG.V', RkdDisplayRIC = 'TRCG.V', DsPrimQtSedol = 'BWH8ZY9' WHERE SecCode = 11246642 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11256200 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11257858 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA22535J3047', RkdSEDOL = 'BW46FP', RkdCUSIP = '22535J30', DsPrimQtSedol = 'BW46FP7', SecMapEndDate = '2026-05-03', endDate = '2026-05-03' WHERE SecCode = 11261939 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951730.0 WHERE SecCode = 11262203 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11270779 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2024-11-27' WHERE SecCode = 11272086 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-02-20' WHERE SecCode = 11275118 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11278867 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA48301P1099', RkdTicker = 'KIRO', RkdSEDOL = 'BQ3QKM', RkdCUSIP = '48301P10', RkdRIC = 'KIRO.V', RkdDisplayRIC = 'KIRO.V', RkdCode = 144749.0, RkdIssueID = 1.0, RkdIssueCode = 185111.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11293711 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293848 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236806319531.0, PriValQuotePermID = 25727025012.0, PermInstrStatus = 'AC' WHERE SecCode = 11294499 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236805389681.0 WHERE SecCode = 11295026 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IACQU', QuotePermID = 236806319386.0, InstrPermID = 232931556688.0, OrgPermID = 6000095553.0, PriTrdQuotePermID = 236806319386.0, PriValQuotePermID = 25727025041.0, PriInstrPermID = 232931556688.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-04-28', PermSecMapStartDate = '2026-04-28' WHERE SecCode = 11295027 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG3624C1226', RkdTicker = 'FTHAU', RkdSEDOL = 'BNZGTM', RkdCUSIP = 'G3624C12', RkdRIC = 'FTHAU.O', RkdDisplayRIC = 'FTHAU.OQ', RkdCode = 144748.0, RkdIssueID = 1.0, RkdIssueCode = 185109.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11295150 AND Type_ = 1;
UPDATE data_universe SET Name = 'GENERAL CATALYST GBL RESIL M UNIT 04/13/2031' WHERE SecCode = 11295151 AND Type_ = 1;
UPDATE data_universe SET Name = 'HEMAB THERAPEUTICS HLDGS INC COM SHS' WHERE SecCode = 11295179 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2024-10-25', endDate = '2024-10-25' WHERE SecCode = 11295198 AND Type_ = 1;
