UPDATE data_universe SET PermSecMapEndDate = '2026-05-15' WHERE SecCode = 11450 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-15' WHERE SecCode = 31046 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-15' WHERE SecCode = 31059 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 33001 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 33002 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-15' WHERE SecCode = 44608 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951557.0 WHERE SecCode = 49537 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 56567 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 56568 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 56569 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 56570 AND Type_ = 1;
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 DsCtryQtStatus = 'S' WHERE SecCode = 75124 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 PermSecMapEndDate = '2026-05-15', endDate = '2026-05-15' WHERE SecCode = 79775 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 80088 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 81676 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 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 PriTRBCIndPermID = 4294951339.0 WHERE SecCode = 90602 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 RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951592.0 WHERE SecCode = 99123 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-15', endDate = '2026-05-15' WHERE SecCode = 104537 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q0136511' WHERE SecCode = 190747 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 243415 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 299990 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'FORA.OQ^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-18', PermQuoteRetireDate = '2026-05-18', endDate = '2026-05-18' WHERE SecCode = 309092 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'UBXN.S^E26', RkdIssueStatus = 0.0, endDate = '2026-05-18' WHERE SecCode = 329828 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-15' WHERE SecCode = 331348 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CIGN.NS^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-18', PermQuoteRetireDate = '2026-05-18', endDate = '2026-05-18' WHERE SecCode = 406383 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 427557 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951642.0 WHERE SecCode = 559774 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'XH', DomCntry = 'CHN' WHERE SecCode = 822049 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-15' WHERE SecCode = 1614017 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 PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 2752909 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21650788270.0, ExchCode = 'INC' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951595.0, PermOrgIPODate = NULL WHERE SecCode = 3583190 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951833.0 WHERE SecCode = 3663157 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 3827945 AND Type_ = 10;
UPDATE data_universe SET ModelCntry = 'HK', DomCntry = 'HKG' WHERE SecCode = 3844944 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 = 4035744 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 PermIDTicker = 'LKFT34', PermSecMapEndDate = '2026-05-15', endDate = '2026-05-15' WHERE SecCode = 4385253 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-15', endDate = '2026-05-15' WHERE SecCode = 4443375 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 QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236785348309.0, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 5194287 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 5395747 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 5553171 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 5597638 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'PUBLI.OL^E26', RkdIssueStatus = 0.0, PermQuoteRetireDate = '2026-05-18', endDate = '2026-05-18' WHERE SecCode = 5738497 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 140471.0, RelType = 8.0 WHERE SecCode = 5996598 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'TAI', ExchCode = 'TAI' WHERE SecCode = 6119501 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6396608 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6601498 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6601511 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6752847 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-05-15' WHERE SecCode = 6802661 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951321.0 WHERE SecCode = 6849656 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-05-15' WHERE SecCode = 6854792 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'XMAX' WHERE SecCode = 10958972 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 11028748 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US74346N8002', RkdSEDOL = 'BWW4HR', RkdCUSIP = '74346N80' WHERE SecCode = 11030383 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951557.0 WHERE SecCode = 11075111 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BTVMFC', DsPrimQtSedol = 'BTVMFC4' WHERE SecCode = 11108815 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11142371 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US75946W5040', RkdSEDOL = 'BWW4HP', RkdCUSIP = '75946W50' WHERE SecCode = 11142544 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-15', PermSecMapEndDate = '2026-05-15' WHERE SecCode = 11153355 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAQ' WHERE SecCode = 11163329 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 11172672 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG514131629', RkdSEDOL = 'BVSVSV', RkdCUSIP = 'G5141316' WHERE SecCode = 11175825 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG752714060', RkdSEDOL = 'BWW4GN', RkdCUSIP = 'G7527140' WHERE SecCode = 11176237 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11183746 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US8314456067', RkdSEDOL = 'BWW4HN', RkdCUSIP = '83144560' WHERE SecCode = 11193348 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AUC' WHERE SecCode = 11196570 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US0070258696', RkdSEDOL = 'BWW4HM', RkdCUSIP = '00702586' WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11213861 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NSM' WHERE SecCode = 11214794 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11216358 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 11228341 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 11233390 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11237417 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-15', PermSecMapEndDate = '2026-05-15', endDate = '2026-05-15' WHERE SecCode = 11237837 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-15', PermSecMapEndDate = '2026-05-15' WHERE SecCode = 11243084 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-15', endDate = '2026-05-15' WHERE SecCode = 11251612 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 11260025 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'UZX' WHERE SecCode = 11260721 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11266303 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11268849 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2024-09-11' WHERE SecCode = 11269370 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PUSA' WHERE SecCode = 11274804 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'JE00BT8Q3M55', RkdTicker = 'AIIR', PermIDTicker = 'AIIR', RkdSEDOL = 'BT8Q3M', RkdCUSIP = 'G0180Y10', RkdRIC = 'AIIR.O', RkdDisplayRIC = 'AIIR.OQ', ExchCode = 'NAS' WHERE SecCode = 11279854 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BWW4HQ', RkdCUSIP = '98591520', DsPrimQtSedol = 'BWW4HQ8' WHERE SecCode = 11282219 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291071 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11291899 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293453 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232912118866.0 WHERE SecCode = 11293741 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232912781224.0 WHERE SecCode = 11293776 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232920114395.0 WHERE SecCode = 11293777 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 11294571 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA29602L1040', RkdTicker = 'EM', RkdSEDOL = 'BMWDSZ', RkdCUSIP = '29602L10', RkdRIC = 'EM.V', RkdDisplayRIC = 'EM.V', RkdCode = 144858.0, RkdIssueID = 1.0, RkdIssueCode = 185270.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11294772 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295064 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236807028648.0, IsPrimaryQuote = 1.0, ExchCode = 'NYS', PermOrgIPODate = '2026-05-15' WHERE SecCode = 11295229 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BFH PR B', ExchCode = 'NYQ' WHERE SecCode = 11295357 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236807028723.0, IsPrimaryQuote = 1.0, ExchCode = 'NSM' WHERE SecCode = 11295876 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-05-15' WHERE SecCode = 11295911 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2026-05-15', startDate = '2026-05-15' WHERE SecCode = 11295981 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GUACU', QuotePermID = 236806335277.0, InstrPermID = 232932781412.0, OrgPermID = 6000114794.0, PriTrdQuotePermID = 236806335277.0, PriValQuotePermID = 25727024769.0, PriInstrPermID = 232932781412.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-05-15', PermSecMapStartDate = '2026-05-15' WHERE SecCode = 11295985 AND Type_ = 1;
