UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 144 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-29' WHERE SecCode = 4259 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29' WHERE SecCode = 5301 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF NY MELLON CORP COM' WHERE SecCode = 8265 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29' WHERE SecCode = 11689 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'FOCL', PermIDTicker = 'FOCL', RkdRIC = 'FOCL.O', RkdDisplayRIC = 'FOCL.OQ' WHERE SecCode = 22386 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-28', PermSecMapEndDate = '2026-05-28' WHERE SecCode = 27223 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 31059 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 31300 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA65506N2005', RkdCUSIP = '65506N20', DsPrimQtSedol = 'BXCGHG1' WHERE SecCode = 32929 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0, startDate = '1996-05-31' WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 51555 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NAS', ExchCode = 'NAS' WHERE SecCode = 54177 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 66361 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72757 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SBI INVESTMENT KOR KRW1000' WHERE SecCode = 72766 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 ISIN = NULL, Name = 'GOLD&S CO LTD KRW2500' WHERE SecCode = 75207 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 Name = 'DONGKUK HOLDINGS KRW500' WHERE SecCode = 77183 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'Q CAPITAL PARTNERS KRW2500' WHERE SecCode = 79286 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-05-21', PermQuoteRetireDate = '2026-05-22', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-21' WHERE SecCode = 80714 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, PermIDTicker = 'HLXDA', RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, DsPrimQtSedol = 'BTXZF98', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, SecMapStartDate = '1960-01-01', SecMapEndDate = '2026-05-28', PermSecMapEndDate = '2026-05-29', startDate = '1960-01-01', endDate = '2026-05-28' WHERE SecCode = 82750 AND Type_ = 10;
UPDATE data_universe SET Name = 'BOUNTY OIL & GAS NPV' WHERE SecCode = 83612 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 83949 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-28' WHERE SecCode = 89348 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 PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 93886 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 94746 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-05-22', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-22' WHERE SecCode = 95221 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 OrgPermID = 6000033422.0, PriInstrPermID = 8590932878.0, DomCntry = 'LUX', IncCntry = 'LUX', PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 95711 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SUNRIGHT LTD NPV' WHERE SecCode = 96685 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'FW.CD', RkdDisplayRIC = 'FW.CD', RkdExchCode = 'CNQ', ExchCode = 'CNX' WHERE SecCode = 97649 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'MEGO.BO', RkdDisplayRIC = 'MEGO.BO' WHERE SecCode = 98614 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000127491.0, PriInstrPermID = 8590934736.0, DomCntry = 'USA', IncCntry = 'USA', PermOrgIPODate = '2000-06-13' WHERE SecCode = 99097 AND Type_ = 1;
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 RkdTicker = 'MERCURYEV', RkdRIC = 'MERC.NS', RkdDisplayRIC = 'MERC.NS', RkdExchCode = 'NSE' WHERE SecCode = 135748 AND Type_ = 10;
UPDATE data_universe SET Name = 'LANSDOWNE RES PLC ORD GBP0.0005' WHERE SecCode = 145107 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 145422 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951329.0 WHERE SecCode = 172771 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951329.0 WHERE SecCode = 172772 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 291899 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 298971 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000138146.0, IsPrimaryInstr = 0.0, PermInstrStatus = 'DC', DomCntry = NULL, PriTRBCIndPermID = NULL WHERE SecCode = 309092 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29' WHERE SecCode = 320346 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 331348 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'ATOP.WA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', SecMapEndDate = '2026-03-09', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-03-09' WHERE SecCode = 367748 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 406383 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'N CITRON INC KRW1000' WHERE SecCode = 498337 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 545311 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SHYP.WA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', SecMapEndDate = '2026-01-02', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-01-02' WHERE SecCode = 797952 AND Type_ = 10;
UPDATE data_universe SET Name = 'HONOR MATRIX HLDGS HKD0.08' WHERE SecCode = 841106 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 863938 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-05-28' WHERE SecCode = 887451 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'OXYP.WA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-12', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-12' WHERE SecCode = 900837 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-28', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-28' WHERE SecCode = 1072078 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'BERP.WA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-19', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-19' WHERE SecCode = 1077940 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-28', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-28' WHERE SecCode = 1214471 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 1614017 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'PTE.WA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-28', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-28' WHERE SecCode = 1644134 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2065783 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'FKD.WA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-11', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-11' WHERE SecCode = 2152212 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', SecMapEndDate = '2025-11-05', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2025-11-05' WHERE SecCode = 2356424 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEXT BIOMETRICS GR NOK0.1' WHERE SecCode = 2374403 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NSE' WHERE SecCode = 2665928 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET Name = 'NAVICARE BIOTECH TWD10' WHERE SecCode = 2762473 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5083215730.0, PriInstrPermID = 21559031668.0, PermOrgIPODate = '2025-09-11' WHERE SecCode = 2832701 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951502.0 WHERE SecCode = 2913389 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21568326330.0, ExchCode = 'DEU', PermQuoteRetireDate = '2022-06-08', endDate = '2022-06-08' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BK OF NY MELLON CO BDR EACH REPR 1 COM' WHERE SecCode = 2963577 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21614525595.0, ExchCode = 'TDG' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3002458 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMPL CAPITAL LTD INR10 (POST SUBD)' WHERE SecCode = 3075390 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951293.0 WHERE SecCode = 3213249 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 3263712 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951370.0 WHERE SecCode = 3378474 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951774.0 WHERE SecCode = 3379082 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 3395018 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'MTEP.WA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-28', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-28' WHERE SecCode = 3396069 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'GOVP.WA^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-28', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-28' WHERE SecCode = 3406950 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951191.0 WHERE SecCode = 3409196 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-28' WHERE SecCode = 3508359 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-29', endDate = '2026-05-29' WHERE SecCode = 3620663 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 3682014 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 PrimaryIssueType = 'EQU' WHERE SecCode = 4291597 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 = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-28', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-28' WHERE SecCode = 4339135 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 4391283 AND Type_ = 10;
UPDATE data_universe SET Name = 'SOLIDUS GOLD LTD NPV' WHERE SecCode = 4413669 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 4456235 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951582.0 WHERE SecCode = 4457143 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 PermInstrStatus = 'DC' WHERE SecCode = 4608541 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236806951761.0 WHERE SecCode = 4613103 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', SecMapEndDate = '2026-05-28', PermQuoteRetireDate = '2026-05-29', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-28' WHERE SecCode = 4670054 AND Type_ = 10;
UPDATE data_universe SET Name = 'ARIBIO LABORATORY KRW500' WHERE SecCode = 4748376 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VZLA', PermIDTicker = 'VZLA', RkdRIC = 'VZLAA.L', RkdDisplayRIC = 'VZLAA.L' WHERE SecCode = 4777233 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 4784326 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 4842767 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BIO2', QuotePermID = 21869787736.0, InstrPermID = 21869785698.0, PriValQuotePermID = 21869787736.0, IsPrimaryInstr = 0.0, PermInstrStatus = 'DC', ExchCode = 'GER', PermQuoteRetireDate = '2022-04-28', PermSecMapStartDate = '2022-01-27', PermSecMapEndDate = '2022-04-28', startDate = '2022-01-27', endDate = '2022-04-27' WHERE SecCode = 4850230 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-28' WHERE SecCode = 4897803 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951404.0 WHERE SecCode = 4897999 AND Type_ = 10;
UPDATE data_universe SET Name = 'LE MERITE EXPORTS INR2(POST SUBD)' WHERE SecCode = 4991509 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'DHANSA', PermIDTicker = 'DHANSA', RkdRIC = 'DANS.NS', RkdDisplayRIC = 'DANS.NS' WHERE SecCode = 5834661 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-06-29' WHERE SecCode = 6331607 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0028799429', RkdSEDOL = 'BXFG2B', RkdCUSIP = 'W2R51G11', DsPrimQtSedol = 'BXFG2B8', PermSecMapEndDate = '2026-05-29', endDate = '2026-05-29' WHERE SecCode = 6608224 AND Type_ = 10;
UPDATE data_universe SET Name = 'Z GAYRIMENKUL YATI TRY1' WHERE SecCode = 6627693 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-02-06' WHERE SecCode = 6645649 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 6674525 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236804823846.0, PermInstrStatus = 'AC' WHERE SecCode = 6741012 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6802655 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6806141 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ANET80', QuotePermID = 236806941506.0, InstrPermID = 232934924312.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941506.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846649 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SOFTBANK80', QuotePermID = 236806941507.0, InstrPermID = 232934924300.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941507.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846650 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NEE80', QuotePermID = 236806941508.0, InstrPermID = 232934924302.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941508.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846651 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MP80', QuotePermID = 236806941509.0, InstrPermID = 232934924295.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941509.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846652 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GOLDUS80', QuotePermID = 236806941510.0, InstrPermID = 232934924307.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941510.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846653 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MONTAGE80', QuotePermID = 236806941511.0, InstrPermID = 232934924305.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941511.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846654 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ABBV80', QuotePermID = 236806941513.0, InstrPermID = 232934924294.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941513.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846655 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SNDK80', QuotePermID = 236806941515.0, InstrPermID = 232934924297.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941515.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846656 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BOEING80', QuotePermID = 236806941518.0, InstrPermID = 232934924298.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941518.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846657 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RKLB80', QuotePermID = 236806941723.0, InstrPermID = 232934924303.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941723.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12', startDate = '2026-05-12' WHERE SecCode = 6846658 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'COIN80', QuotePermID = 236806941521.0, InstrPermID = 232934924299.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941521.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846659 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GEV80', QuotePermID = 236806941522.0, InstrPermID = 232934924306.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941522.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846660 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MOUTAI80', QuotePermID = 236806941523.0, InstrPermID = 232934924308.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941523.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846661 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MAOGEP80', QuotePermID = 236806941524.0, InstrPermID = 232934924301.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941524.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846662 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MIDEA80', QuotePermID = 236806941525.0, InstrPermID = 232934924310.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941525.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846663 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'JLMAG80', QuotePermID = 236806941526.0, InstrPermID = 232934924313.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941526.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846664 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MIXUE80', QuotePermID = 236806941527.0, InstrPermID = 232934924304.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941527.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846665 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CNRE80', QuotePermID = 236806941528.0, InstrPermID = 232934924309.0, OrgPermID = 4295892709.0, PriValQuotePermID = 236806941528.0, PriInstrPermID = 8590941630.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SET', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'THA', IncCntry = 'THA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1989-08-02', PermSecMapStartDate = '2026-05-12' WHERE SecCode = 6846666 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236807004508.0, IsPrimaryInstr = 1.0, PermInstrStatus = 'AC' WHERE SecCode = 6846681 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '2D9', QuotePermID = 236806952271.0, InstrPermID = 232845190744.0, OrgPermID = 5087213393.0, PriValQuotePermID = 236806952271.0, PriInstrPermID = 232845190744.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'DUS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'DEU', IncCntry = 'DEU', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-13', PermSecMapStartDate = '2026-05-13' WHERE SecCode = 6846840 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236807004486.0, PermInstrStatus = 'AC' WHERE SecCode = 6846841 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '2950', QuotePermID = 236806935461.0, InstrPermID = 232934680680.0, OrgPermID = 5076944702.0, PriValQuotePermID = 236806935461.0, PriInstrPermID = 21772232735.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'CYM', PriTRBCIndPermID = 4294951833.0, PermQuoteRetireDate = '2026-06-22', PermOrgIPODate = '2023-01-17', PermSecMapStartDate = '2026-05-11', startDate = '2026-05-11' WHERE SecCode = 6849662 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'KTK', QuotePermID = 236807107899.0, InstrPermID = 232935415480.0, OrgPermID = 6000096742.0, PriValQuotePermID = 236807107899.0, PriInstrPermID = 232935415480.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'ASX', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', OrgTypeCode = 'COM', DomCntry = 'AUS', IncCntry = 'AUS', PriTRBCIndPermID = 4294951862.0, PermOrgIPODate = '2026-05-18', PermSecMapStartDate = '2026-05-14', startDate = '2026-05-14' WHERE SecCode = 6854786 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RKG', QuotePermID = 236807087931.0, InstrPermID = 232934826980.0, OrgPermID = 5090801974.0, PriValQuotePermID = 236807087931.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'WSE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'POL', IncCntry = 'POL', PermOrgIPODate = '2026-05-15', PermSecMapStartDate = '2026-05-14', startDate = '2026-05-14' WHERE SecCode = 6854790 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '8558', QuotePermID = 236807017599.0, InstrPermID = 232935138834.0, OrgPermID = 5046711390.0, PriValQuotePermID = 236807017599.0, PriInstrPermID = 21573177627.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'CYM', PriTRBCIndPermID = 4294951782.0, PermQuoteRetireDate = '2026-06-24', PermOrgIPODate = '2015-10-08', PermSecMapStartDate = '2026-05-13', startDate = '2026-05-13' WHERE SecCode = 6857266 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RFBL', QuotePermID = 236807257056.0, InstrPermID = 232934737976.0, OrgPermID = 5086974678.0, PriValQuotePermID = 236807257056.0, PriInstrPermID = 232934737976.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NSI', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'IND', IncCntry = 'IND', PriTRBCIndPermID = 4294951871.0, PermOrgIPODate = '2026-05-19', PermSecMapStartDate = '2026-05-18', startDate = '2026-05-18' WHERE SecCode = 6862164 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '2951', QuotePermID = 236807060456.0, InstrPermID = 232935358630.0, OrgPermID = 4295870861.0, PriValQuotePermID = 236807060456.0, PriInstrPermID = 8590943829.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'HKG', PriTRBCIndPermID = 4294951582.0, PermQuoteRetireDate = '2026-06-25', PermOrgIPODate = '1990-10-29', PermSecMapStartDate = '2026-05-14', startDate = '2026-05-14' WHERE SecCode = 6862172 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '288180', QuotePermID = 236807166023.0, InstrPermID = 232935579211.0, OrgPermID = 5044636256.0, PriValQuotePermID = 236807166023.0, PriInstrPermID = 232935579211.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'KOE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'KOR', IncCntry = 'KOR', PriTRBCIndPermID = 4294951862.0, PermOrgIPODate = '2026-05-19', PermSecMapStartDate = '2026-05-15', startDate = '2026-05-15' WHERE SecCode = 6862181 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '7920', QuotePermID = 236806939650.0, InstrPermID = 232934848580.0, OrgPermID = 5051769058.0, PriValQuotePermID = 236806939650.0, PriInstrPermID = 232934848580.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TWO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'TWN', IncCntry = 'TWN', PriTRBCIndPermID = 4294951264.0, PermOrgIPODate = '2026-05-20', PermSecMapStartDate = '2026-05-12', startDate = '2026-05-12' WHERE SecCode = 6865110 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '7922', QuotePermID = 236807254782.0, InstrPermID = 232935523400.0, OrgPermID = 6000134617.0, PriValQuotePermID = 236807254782.0, PriInstrPermID = 232935523400.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TWO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'TWN', IncCntry = 'TWN', PermOrgIPODate = '2026-05-22', PermSecMapStartDate = '2026-05-18', startDate = '2026-05-18' WHERE SecCode = 6870727 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PUBLI', QuotePermID = 236807018323.0, InstrPermID = 232932732631.0, OrgPermID = 6000084183.0, PriValQuotePermID = 236807018323.0, PriInstrPermID = 232932732631.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'STO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'SWE', IncCntry = 'SWE', PriTRBCIndPermID = 4294951328.0, PermOrgIPODate = '2026-05-20', PermSecMapStartDate = '2026-05-13', startDate = '2026-05-13' WHERE SecCode = 6870728 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '6872', QuotePermID = 236807254603.0, InstrPermID = 232935362923.0, OrgPermID = 5052122774.0, PriValQuotePermID = 236807254603.0, PriInstrPermID = 232935362923.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CHN', IncCntry = 'CHN', PriTRBCIndPermID = 4294951264.0, PermOrgIPODate = '2026-05-22', PermSecMapStartDate = '2026-05-18', startDate = '2026-05-18' WHERE SecCode = 6870729 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '574A', QuotePermID = 236807065159.0, InstrPermID = 232935135413.0, OrgPermID = 5063184825.0, PriValQuotePermID = 236807065159.0, PriInstrPermID = 232935135413.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TYO', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'JPN', IncCntry = 'JPN', PriTRBCIndPermID = 4294951787.0, PermOrgIPODate = '2026-05-27', PermSecMapStartDate = '2026-05-14', startDate = '2026-05-14' WHERE SecCode = 6880044 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951895.0, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10928316 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10964546 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US8112923094', RkdCUSIP = '81129230', DsPrimQtSedol = 'BXGPXX3' WHERE SecCode = 11131010 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951265.0 WHERE SecCode = 11131840 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11135613 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236807111662.0 WHERE SecCode = 11163329 AND Type_ = 1;
UPDATE data_universe SET Name = 'ROCKET ONE INC COM NEW' WHERE SecCode = 11193974 AND Type_ = 1;
UPDATE data_universe SET PriValQuotePermID = 236807360353.0 WHERE SecCode = 11216466 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11217696 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 0.6667 WHERE SecCode = 11225764 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11226283 AND Type_ = 1;
UPDATE data_universe SET Name = 'QTREX QUANTUM LTD *W EXP 07/16/2026' WHERE SecCode = 11227222 AND Type_ = 1;
UPDATE data_universe SET Name = 'SKYAI INC COM' WHERE SecCode = 11240940 AND Type_ = 1;
UPDATE data_universe SET Name = 'SKYAI INC *W EXP 04/13/2027' WHERE SecCode = 11240954 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2022-11-14' WHERE SecCode = 11247421 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TUNG', DsExchMnem = 'TSX', QuotePermID = 236777242940.0, IsPrimaryQuote = 1.0, ExchCode = 'CVE', PermSecMapStartDate = '2025-01-23' WHERE SecCode = 11259074 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ZUUZF' WHERE SecCode = 11262773 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11267641 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11269370 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-01' WHERE SecCode = 11269373 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF NY MELLON CORP NON CUM PFD SE K' WHERE SecCode = 11275816 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11279604 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097053907.0, PriInstrPermID = 232889622079.0, DomCntry = 'ARE', IncCntry = 'JEY', PriTRBCIndPermID = 4294951423.0, PermOrgIPODate = '2026-05-22' WHERE SecCode = 11279854 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NXB' WHERE SecCode = 11288144 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11293741 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11293776 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11293777 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11293913 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdCode = 126744.0, RkdIssueCode = 160517.0 WHERE SecCode = 11294226 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232891591990.0 WHERE SecCode = 11295149 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295445 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AGM PR I', QuotePermID = 236807424927.0, InstrPermID = 232934960570.0, OrgPermID = 4295903977.0, PriTrdQuotePermID = 236807424927.0, PriValQuotePermID = 236806952453.0, PriInstrPermID = 8589950541.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'NONCUM', InstrClass = 'NONCUM', OrgTypeCode = 'GVTDA', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = '1988-12-09', PermSecMapStartDate = '2026-05-22' WHERE SecCode = 11295810 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FRVO', QuotePermID = 236806953827.0, InstrPermID = 232931256131.0, OrgPermID = 5080052747.0, PriTrdQuotePermID = 236806953827.0, PriValQuotePermID = 25727023062.0, PriInstrPermID = 232931256131.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NSM', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 1004365471.0, PermOrgIPODate = '2026-05-13', PermSecMapStartDate = '2026-05-13' WHERE SecCode = 11295811 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236806954150.0, PriValQuotePermID = 25727023011.0, PermInstrStatus = 'AC' WHERE SecCode = 11295855 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'WENC', QuotePermID = 236806939620.0, InstrPermID = 232922661803.0, OrgPermID = 6000054199.0, PriTrdQuotePermID = 236806939620.0, PriValQuotePermID = 25727023272.0, PriInstrPermID = 232922661803.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'MEX', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-04-30', PermSecMapStartDate = '2026-05-12', startDate = '2026-04-30' WHERE SecCode = 11295857 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236807028723.0, PriValQuotePermID = 25727022716.0, PermInstrStatus = 'AC' WHERE SecCode = 11295876 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236806954180.0, PriValQuotePermID = 25727022945.0, IsPrimaryInstr = 1.0, PermInstrStatus = 'AC' WHERE SecCode = 11295889 AND Type_ = 1;
UPDATE data_universe SET InstrClass = 'ORD' WHERE SecCode = 11295942 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236807111772.0, PriValQuotePermID = 25727022154.0, PermInstrStatus = 'AC' WHERE SecCode = 11295986 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MYX', QuotePermID = 236807111731.0, InstrPermID = 232912118866.0, OrgPermID = 5097089147.0, PriTrdQuotePermID = 236807111731.0, PriValQuotePermID = 25727022245.0, PriInstrPermID = 232912118866.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-04-14', PermSecMapStartDate = '2026-05-15', startDate = '2026-04-14' WHERE SecCode = 11295987 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'FMAC', QuotePermID = 236807170291.0, InstrPermID = 232912781224.0, OrgPermID = 5097061900.0, PriTrdQuotePermID = 236807170291.0, PriValQuotePermID = 25727022097.0, PriInstrPermID = 232912781224.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-03-27', PermSecMapStartDate = '2026-05-16', startDate = '2026-03-27' WHERE SecCode = 11296057 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IPFX', QuotePermID = 236807170483.0, InstrPermID = 232920114395.0, OrgPermID = 5097118446.0, PriTrdQuotePermID = 236807170483.0, PriValQuotePermID = 25727022029.0, PriInstrPermID = 232920114395.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951374.0, PermOrgIPODate = '2026-03-27', PermSecMapStartDate = '2026-05-16', startDate = '2026-03-27' WHERE SecCode = 11296059 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VECA', QuotePermID = 236807111617.0, InstrPermID = 232901226787.0, PriTrdQuotePermID = 236807111617.0, PriValQuotePermID = 25727022440.0, IsPrimaryInstr = 1.0, QuoteClass = 'ORD', InstrClass = 'ORD', PermSecMapStartDate = '2026-05-15', PermSecMapEndDate = NULL, startDate = '2026-05-06', endDate = NULL WHERE SecCode = 11296172 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OCTV', QuotePermID = 236807170558.0, InstrPermID = 232924000396.0, OrgPermID = 5092319824.0, PriTrdQuotePermID = 236807170558.0, PriValQuotePermID = 25727021966.0, PriInstrPermID = 232924000396.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NSM', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'IRL', PermOrgIPODate = '2026-05-21', PermSecMapStartDate = '2026-05-18', startDate = '2026-05-18' WHERE SecCode = 11296310 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'KPET', QuotePermID = 236806950899.0, InstrPermID = 232927509423.0, OrgPermID = 6000050691.0, PriTrdQuotePermID = 236806950899.0, PriValQuotePermID = 25727023108.0, PriInstrPermID = 232927509423.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-03-31', PermSecMapStartDate = '2026-05-12', startDate = '2026-03-31' WHERE SecCode = 11296312 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG041261010', RkdTicker = 'AACP', RkdSEDOL = 'BVMCPL', RkdCUSIP = 'G0412610', RkdRIC = 'AACP.O', RkdDisplayRIC = 'AACP.OQ', RkdCode = 144686.0, RkdIssueID = 1.0, RkdIssueCode = 185002.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11296579 AND Type_ = 1;
