UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 15660 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 29198 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 29201 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 30186 AND Type_ = 1;
UPDATE data_universe SET Name = 'HORNBECK OFFSHORE SERVICES I COM' WHERE SecCode = 33185 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MPCG' WHERE SecCode = 41470 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RKKK', QuotePermID = 21475081838.0, ExchCode = 'XIM', PermQuoteRetireDate = '2013-12-14', endDate = '2013-12-14' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-09-09' WHERE SecCode = 49579 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-09-10', SecMapEndDate = '2026-08-25', PermQuoteRetireDate = '2026-09-10', PermSecMapEndDate = '2019-02-21', endDate = '2019-02-21' WHERE SecCode = 49733 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5066583001.0, DomCntry = 'TWN', PriTRBCIndPermID = 4294951836.0 WHERE SecCode = 50767 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 53304 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 56435 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 58043 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 67667 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70873 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 25561.0 WHERE SecCode = 71587 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 72993 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SANGSANGIN INVESTM KRW5000' WHERE SecCode = 74250 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75398 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 77609 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79596 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81657 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 83525 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951268.0 WHERE SecCode = 83865 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 90059 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 90579 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 91543 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NASA', DsPrimQtSedol = 'C0BCTQ2' WHERE SecCode = 92683 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 97105 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-09-09' WHERE SecCode = 100179 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 105004 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 105204 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 105418 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114108 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 114560 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 134904 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 138966 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140966 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 141330 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 214381 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 252333 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 257965 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-10', SecMapEndDate = '2026-09-09', endDate = '2026-09-09' WHERE SecCode = 326691 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 330453 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 359141 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX53JN0', PermSecMapStartDate = '2002-08-23', PermSecMapEndDate = '2006-10-19', endDate = '2006-10-19' WHERE SecCode = 567723 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX53JN0' WHERE SecCode = 595312 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q7717421', Name = 'PDI GOLD LTD NPV' WHERE SecCode = 890647 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1542760 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DEFENDER CAPITAL L NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 2065774 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2417968 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-09-09' WHERE SecCode = 2614226 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2872662 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2900881 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GERMAN TECH HLDG NPV' WHERE SecCode = 2932355 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'THERACRYF PLC ORD GBP0.0005' WHERE SecCode = 3015744 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3027562 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3032260 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3217958 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3283798 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BRAZULA02PR3', RkdTicker = 'AZUL54', RkdSEDOL = 'BV7DQD', RkdCUSIP = 'P0R0AQ27', RkdRIC = 'AZUL54.SA^A26', RkdDisplayRIC = 'AZUL54.SA', RkdCode = 112451.0, RkdIssueID = 1.0, RkdIssueCode = 141250.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SAO', RkdExchCtry = 'BRA' WHERE SecCode = 3322264 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3358237 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'WISE BIRDS INC KRW500' WHERE SecCode = 3382226 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CRESTO' WHERE SecCode = 3430216 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858470979.0, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-03' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3551900 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'THEWORKS PLC ORD GBP0.01' WHERE SecCode = 3553122 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3586985 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'WHIE.BO^I26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 3827947 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4197876 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4228170 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4273937 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4286258 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsPrimQtSedol = 'BT7JHB2', QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2020-07-22' WHERE SecCode = 4303692 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2018-11-05' WHERE SecCode = 4396374 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4598562 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4615788 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365477.0 WHERE SecCode = 5078443 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5153429 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5220928 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5407817 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5410105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5534935 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5600657 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5632198 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5645941 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 6349671 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6354191 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-01-28' WHERE SecCode = 6629441 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0027099060', RkdTicker = 'APRTEC', RkdSEDOL = 'BVPLPY', RkdCUSIP = 'W1R51210', RkdRIC = 'APRTEC.TE', RkdDisplayRIC = 'APRTEC.TE', RkdCode = 145505.0, RkdIssueID = 1.0, RkdIssueCode = 186271.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'AKT', RkdExchCtry = 'SWE' WHERE SecCode = 6638314 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-05-13' WHERE SecCode = 6846670 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'VIGO PHOTONICS SA PLN1.00 ALLOTMENT CERTS G', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-09-08', PermQuoteRetireDate = '2026-09-09', PermSecMapEndDate = '2026-09-09', endDate = '2026-09-08' WHERE SecCode = 7025885 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 7034017 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7064157 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7080319 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'C0BCTR3' WHERE SecCode = 10973904 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-09-09' WHERE SecCode = 10989428 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11022365 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BT8R5S8', PermSecMapEndDate = '2020-12-25', endDate = '2020-12-25' WHERE SecCode = 11062014 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US35243J2006', RkdTicker = 'FBRT PRE', RkdSEDOL = 'BNKDZ4', RkdCUSIP = '35243J20', RkdRIC = 'FBRT_pe.K', RkdDisplayRIC = 'FBRT_pe.N', RkdCode = 119098.0, RkdIssueID = 6.0, RkdIssueCode = 168338.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 11074374 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'IL0011313900', RkdTicker = 'EOCN', PermIDTicker = 'EOCN', RkdSEDOL = 'BKMDKS', RkdCUSIP = 'M4723820', RkdRIC = 'EOCN.O', RkdDisplayRIC = 'EOCN.OQ', Name = 'EOCENE LTD ORD', RkdCode = 96729.0, RkdIssueID = 1.0, RkdIssueCode = 121970.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11131358 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US29273V7047', RkdTicker = 'ET PRI', RkdSEDOL = 'BMHLS3', RkdCUSIP = '29273V70', RkdRIC = 'ET_pi', RkdDisplayRIC = 'ET_pi.N', RkdCode = 51550.0, RkdIssueID = 10.0, RkdIssueCode = 184939.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 6.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 11168246 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951264.0 WHERE SecCode = 11181540 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-08', endDate = '2026-09-08' WHERE SecCode = 11194816 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KRSA' WHERE SecCode = 11194938 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C04BN20', PermSecMapEndDate = '2026-07-14', endDate = '2026-07-14' WHERE SecCode = 11198134 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11206769 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US67623L5057', RkdTicker = 'OPAD', RkdSEDOL = 'BXCGJ3', RkdCUSIP = '67623L50', RkdRIC = 'OPAD.O', RkdDisplayRIC = 'OPAD.OQ', RkdCode = 125178.0, RkdIssueID = 1.0, RkdIssueCode = 158343.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11216072 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11216542 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US06682J6055', RkdTicker = 'PARA', RkdSEDOL = 'BT9QV8', RkdCUSIP = '06682J60', RkdRIC = 'PARA.O', RkdDisplayRIC = 'PARA.OQ', RkdCode = 126023.0, RkdIssueID = 1.0, RkdIssueCode = 159564.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11219296 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11237445 AND Type_ = 1;
UPDATE data_universe SET Name = 'ASPIRE-LAKEWOOD HOLDINGS INC COM' WHERE SecCode = 11240840 AND Type_ = 1;
UPDATE data_universe SET Name = 'ASPIRE-LAKEWOOD HOLDINGS INC *W EXP 02/18/2030' WHERE SecCode = 11240919 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG531511338', RkdTicker = 'NXAT', PermIDTicker = 'NXAT', RkdSEDOL = 'BNYG4S', RkdCUSIP = 'G5315113', RkdRIC = 'NXAT.O', RkdDisplayRIC = 'NXAT.OQ', Name = 'NEXUS ADVANCED TECHNOLOGIES ORD SHS', RkdCode = 133835.0, RkdIssueID = 1.0, RkdIssueCode = 170098.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11247303 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US65290E1010', RkdTicker = 'NXT', RkdSEDOL = 'BR1GTS', RkdCUSIP = '65290E10', RkdRIC = 'NXT.O', RkdDisplayRIC = 'NXT.OQ', RkdCode = 135746.0, RkdIssueID = 1.0, RkdIssueCode = 172548.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11249583 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11250292 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11251097 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsPrimQtSedol = 'C0BCTC8', QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL WHERE SecCode = 11255951 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11258156 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG7385S1193', RkdTicker = 'ATTT', PermIDTicker = 'ATTT', RkdSEDOL = 'BP9M53', RkdCUSIP = 'G7385S11', RkdRIC = 'ATTT.O', RkdDisplayRIC = 'ATTT.OQ', Name = 'ATLAS TRINITY TECH LIMITED ORD SHS', RkdCode = 138135.0, RkdIssueID = 1.0, RkdIssueCode = 175790.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11265201 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11270239 AND Type_ = 1;
UPDATE data_universe SET Name = 'PMA GRAPHENE TCHNOLOGY GRP INC CLS A ORD SHS' WHERE SecCode = 11271948 AND Type_ = 1;
UPDATE data_universe SET Name = 'XTEND AI ROBOTICS INC COM' WHERE SecCode = 11275776 AND Type_ = 1;
UPDATE data_universe SET PermSecMapStartDate = '2026-09-09', PermSecMapEndDate = NULL, startDate = '2025-09-26', endDate = NULL WHERE SecCode = 11285909 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-02-09' WHERE SecCode = 11289585 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11290408 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000225077.0, DomCntry = 'FRA', IncCntry = 'FRA', PriTRBCIndPermID = 4294951205.0, PermOrgIPODate = NULL, startDate = '2026-01-28' WHERE SecCode = 11291179 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-02-09' WHERE SecCode = 11291747 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG6951A1067', RkdTicker = 'PTAC', RkdSEDOL = 'BVMYDG', RkdCUSIP = 'G6951A10', RkdRIC = 'PTAC.O', RkdDisplayRIC = 'PTAC.OQ', RkdCode = 144703.0, RkdIssueID = 1.0, RkdIssueCode = 185033.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA' WHERE SecCode = 11298807 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-07-20', startDate = '2026-07-20' WHERE SecCode = 11299498 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US47668J1025', RkdTicker = 'JMKE', RkdSEDOL = 'BT5DG9', RkdCUSIP = '47668J10', RkdRIC = 'JMKE.K', RkdDisplayRIC = 'JMKE.N', RkdCode = 145482.0, RkdIssueID = 1.0, RkdIssueCode = 186244.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 11299829 AND Type_ = 1;