UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 3260 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'CCRN.OQ^G26', RkdIssueStatus = 0.0 WHERE SecCode = 17852 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951203.0 WHERE SecCode = 19809 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 23057 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0, PermOrgIPODate = '1991-06-10', startDate = '1991-06-10' WHERE SecCode = 26606 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteRetireDate = '2026-07-13', endDate = '2026-07-13' WHERE SecCode = 29401 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BRJWJJ7' WHERE SecCode = 34106 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55846120871.0, ExchCode = 'CPH' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-28' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-29', endDate = '2026-07-29' WHERE SecCode = 48155 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 67742 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71040 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 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 PermIDTicker = 'WYO', DsPrimQtSedol = 'BXJPKF1', PermSecMapEndDate = '2026-07-28', endDate = '2026-07-28' WHERE SecCode = 77332 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TONGYANG INC 2ND PFD KRW1000' WHERE SecCode = 77957 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78134 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FBR', Name = 'FBR LTD NPV' WHERE SecCode = 79182 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81754 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 82061 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89214 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 RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KR MOTORS KRW2500' WHERE SecCode = 91257 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 91841 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 93525 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-28', PermSecMapEndDate = '2026-07-28' WHERE SecCode = 94937 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 = 'TONGYANG INC PFD KRW1000' WHERE SecCode = 97907 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BRJWJK8' WHERE SecCode = 101676 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115473 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951331.0 WHERE SecCode = 120435 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermIDTicker = 'BIG', Name = 'BIO-GATE AG NPV (POST SPLIT)', InfoCode = 29885, DsPrimQtSedol = 'BTXVRG7', SecMapStartDate = '2006-04-04', startDate = '2006-04-04' WHERE SecCode = 144578 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145938 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 164730 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 191882 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 298971 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermIDTicker = 'EFR', Name = 'EVERFLOW RESOURCES NPV' WHERE SecCode = 300098 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 306753 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'ZINC OF IRELAND NPV' WHERE SecCode = 309255 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-27' WHERE SecCode = 309977 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CELDB', DsPrimQtSedol = 'BRJMV35', SecMapEndDate = '2026-07-27', PermSecMapEndDate = '2026-07-28', endDate = '2026-07-27' WHERE SecCode = 332462 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 352045 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 432745 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 497196 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 PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-27' WHERE SecCode = 766928 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KOREA NEW NETWORK KRW5000' WHERE SecCode = 854182 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475892461.0, ExchCode = 'GER', PermQuoteRetireDate = '2012-04-10', endDate = '2012-04-10' WHERE SecCode = 1265152 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FBR' WHERE SecCode = 1486652 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 ISIN = NULL, Name = 'DGENX CO LTD KRW2500' WHERE SecCode = 1934499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2086231 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVV5L85', PermSecMapEndDate = '2026-07-28', endDate = '2026-07-28' WHERE SecCode = 2222292 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-29', SecMapEndDate = '2026-07-28', PermSecMapEndDate = '2026-07-28', endDate = '2026-07-28' WHERE SecCode = 2566807 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-28' WHERE SecCode = 2580219 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KYN', DsPrimQtSedol = 'BRWJ3J3', PermSecMapEndDate = '2026-07-28', endDate = '2026-07-28' WHERE SecCode = 2593540 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2708934 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2813083 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'FBR' WHERE SecCode = 2864335 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3318434 AND Type_ = 10;
UPDATE data_universe SET Name = 'TAIWAN ELECTRIC VE TWD10' WHERE SecCode = 3319846 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ZNWD.L^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-28', PermSecMapEndDate = '2026-07-28' WHERE SecCode = 3409577 AND Type_ = 10;
UPDATE data_universe SET Name = 'ASTER DM QUALITY C INR10' WHERE SecCode = 3438039 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-29', SecMapEndDate = '2026-07-27', PermQuoteRetireDate = '2026-07-29', endDate = '2026-07-27' WHERE SecCode = 3444705 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951946.0 WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CELDB', DsPrimQtSedol = 'BRJMV35' WHERE SecCode = 3827940 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 3899669 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 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 DsCtryQtStatus = 'S' WHERE SecCode = 3989802 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4043055 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 ISIN = NULL WHERE SecCode = 4401340 AND Type_ = 10;
UPDATE data_universe SET Name = 'ARIBIO HLDGS CO KRW500' WHERE SecCode = 4402220 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4557739 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 = 4607294 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5045124 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21565180699.0, ExchCode = 'FRA' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-28', PermSecMapEndDate = '2026-07-28' WHERE SecCode = 5540647 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-31' WHERE SecCode = 5617108 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '467930.KQ^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-27' WHERE SecCode = 5617213 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5645855 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5674196 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '191A.T^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-07-27' WHERE SecCode = 5807861 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6190838 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CH1286293811', RkdTicker = '4SY', RkdSEDOL = 'BVBCTS', RkdCUSIP = 'H3585J12', RkdRIC = '4SY.D', RkdDisplayRIC = '4SY.D', RkdCode = 145250.0, RkdIssueID = 1.0, RkdIssueCode = 185875.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'DUS', RkdExchCtry = 'DEU', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6213121 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6608218 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 6617659 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951369.0 WHERE SecCode = 6705492 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000467094', RkdTicker = 'BST', RkdSEDOL = 'BW2BYG', RkdCUSIP = 'Q1698610', RkdRIC = 'BST.AX', RkdDisplayRIC = 'BST.AX', RkdCode = 145252.0, RkdIssueID = 1.0, RkdIssueCode = 185877.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6809154 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-29', SecMapEndDate = '2026-07-28', PermSecMapEndDate = '2026-07-28', endDate = '2026-07-28' WHERE SecCode = 6937640 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6948295 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6948302 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE0R1301019', RkdTicker = 'TEJA', RkdSEDOL = 'BTRDLK', RkdCUSIP = 'Y8T7RH10', RkdRIC = 'TEJE.NS', RkdDisplayRIC = 'TEJE.NS', RkdCode = 145249.0, RkdIssueID = 1.0, RkdIssueCode = 185874.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NSE', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6967201 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-29', SecMapEndDate = '2026-07-28', PermSecMapEndDate = '2026-07-28', endDate = '2026-07-28' WHERE SecCode = 6967208 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IL0012448887', RkdTicker = 'RAFA', RkdSEDOL = 'BRJVQT', RkdCUSIP = 'M8187410', RkdRIC = 'RAFA.TA', RkdDisplayRIC = 'RAFA.TA', RkdCode = 145247.0, RkdIssueID = 1.0, RkdIssueCode = 185870.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TLV', RkdExchCtry = 'ISR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6985918 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IT0005722191', RkdTicker = 'GPSY', RkdSEDOL = 'BT6D5Q', RkdCUSIP = 'T5R4EE11', RkdRIC = 'GPSY.MI', RkdDisplayRIC = 'GPSY.MI', RkdCode = 145241.0, RkdIssueID = 1.0, RkdIssueCode = 185864.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BIT', RkdExchCtry = 'ITA', PrimaryIssueType = 'IPO', COATypeCode = '' WHERE SecCode = 6997043 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-07-27' WHERE SecCode = 7009109 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-07-27' WHERE SecCode = 7009111 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-07-27' WHERE SecCode = 7009112 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TW0007939001', RkdTicker = '7939', RkdSEDOL = 'BXV1VB', RkdCUSIP = 'Y270P410', RkdRIC = '7939.TWO', RkdDisplayRIC = '7939.TWO', RkdCode = 145243.0, RkdIssueID = 1.0, RkdIssueCode = 185866.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TPO', RkdExchCtry = 'TWN', PrimaryIssueType = 'EQU', COATypeCode = '', PermOrgIPODate = '2026-07-27' WHERE SecCode = 7009117 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-07-27' WHERE SecCode = 7009128 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951203.0 WHERE SecCode = 10785144 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRJHZ27' WHERE SecCode = 10978767 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVCK9X0', DsTypeCode = 'EQ' WHERE SecCode = 11107997 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11132638 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 11139732 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'AVNS.N^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-27', PermSecMapEndDate = '2026-07-27' WHERE SecCode = 11141279 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'YARW', PermIDTicker = 'YARW', RkdRIC = 'YARW.O', RkdDisplayRIC = 'YARW.OQ', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11181173 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2018-12-18' WHERE SecCode = 11192817 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-27', endDate = '2026-07-27' WHERE SecCode = 11217255 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11220687 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11235663 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'WBG.X', RkdRIC = 'WBGx.CD', RkdDisplayRIC = 'WBGx.CD' WHERE SecCode = 11245791 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11249600 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11250417 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951748.0 WHERE SecCode = 11255869 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG3514S1469', RkdSEDOL = 'BPY0BP', RkdCUSIP = 'G3514S14' WHERE SecCode = 11256200 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CCIXU.OQ^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-28', PermSecMapEndDate = '2026-07-28' WHERE SecCode = 11264900 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 11265603 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-28', SecMapEndDate = '2026-07-27', endDate = '2026-07-27' WHERE SecCode = 11266601 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CCIX.OQ^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-07-28', PermSecMapEndDate = '2026-07-28' WHERE SecCode = 11270798 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-03-19' WHERE SecCode = 11291143 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-03-19' WHERE SecCode = 11293456 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-06-23' WHERE SecCode = 11298186 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951895.0 WHERE SecCode = 11298232 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US45047B1052', RkdTicker = 'ITG', RkdSEDOL = 'BX59CL', RkdCUSIP = '45047B10', RkdRIC = 'ITG.O', RkdDisplayRIC = 'ITG.OQ', RkdCode = 145248.0, RkdIssueID = 1.0, RkdIssueCode = 185872.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11298541 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IRR', QuotePermID = 236810510413.0, InstrPermID = 232945651498.0, OrgPermID = 6000211039.0, PriValQuotePermID = 236810510413.0, PriInstrPermID = 232945651498.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'CVE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951901.0, PermOrgIPODate = '2026-07-27', PermSecMapStartDate = '2026-07-24', startDate = '2026-07-24' WHERE SecCode = 11299639 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FTRA', QuotePermID = 236810458069.0, InstrPermID = 232937910044.0, OrgPermID = 6000139512.0, PriTrdQuotePermID = 236810458069.0, PriValQuotePermID = 25727003529.0, PriInstrPermID = 232937910044.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-05', PermSecMapStartDate = '2026-07-23', startDate = '2026-06-05' WHERE SecCode = 11299661 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LTGR', QuotePermID = 236810510385.0, InstrPermID = 232920020267.0, OrgPermID = 5097134630.0, PriTrdQuotePermID = 236810510385.0, PriValQuotePermID = 25727003234.0, PriInstrPermID = 232920020267.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PermOrgIPODate = '2026-06-04', PermSecMapStartDate = '2026-07-24', startDate = '2026-06-04' WHERE SecCode = 11299663 AND Type_ = 1;