UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 12192 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US30233Q1085', RkdSEDOL = 'BVSRPD', RkdCUSIP = '30233Q10', Name = 'EXXONMOBIL HOLDINGS CORPORATN COM', DsPrimQtSedol = 'BVSRPD7' WHERE SecCode = 25075 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 36833 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 40869 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ZWM.S^F26', RkdIssueStatus = 0.0, PermInstrStatus = 'DC' WHERE SecCode = 49597 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 60453 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ISR' WHERE SecCode = 67230 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'HURXLEY HLDGS CORP NPV' WHERE SecCode = 68288 AND Type_ = 10;
UPDATE data_universe SET Name = 'ANTAM (PERSERO) TB IDR100' WHERE SecCode = 68598 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GUJARAT ENERGY LTD INR2 (POST SUBD)' WHERE SecCode = 72544 AND Type_ = 10;
UPDATE data_universe SET Name = 'ANTAM (PERSERO) TB CDI IDR500 (5:1)' WHERE SecCode = 72624 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '032980.KQ^G26', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-30' WHERE SecCode = 72952 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73995 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75879 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = '8048.HK^F26', RkdIssueStatus = 0.0 WHERE SecCode = 76126 AND Type_ = 10;
UPDATE data_universe SET Name = 'DAIWA LTD NPV' WHERE SecCode = 76305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77859 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA60365B1085', RkdSEDOL = 'BWXHXK', RkdCUSIP = '60365B10', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 80076 AND Type_ = 1;
UPDATE data_universe SET Name = 'GALILEI HOLDINGS C NPV' WHERE SecCode = 80253 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81363 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL WHERE SecCode = 84305 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'JHG.N^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 84357 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85718 AND Type_ = 10;
UPDATE data_universe SET Name = 'CRYPTO FLOW TECH HKD0.1' WHERE SecCode = 87126 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 88692 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89307 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89550 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89758 AND Type_ = 10;
UPDATE data_universe SET Name = 'NATIONAL GAS & IND SAR10' WHERE SecCode = 90401 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90762 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 91086 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93353 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'ISR' WHERE SecCode = 93827 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BPY09K3' WHERE SecCode = 94367 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'SAPPORO BREWERIES NPV' WHERE SecCode = 94693 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95099 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'UNI CHEM KRW5000' WHERE SecCode = 95402 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000176703.0, OrgTypeCode = 'UNK', DomCntry = NULL, PriTRBCIndPermID = NULL WHERE SecCode = 97012 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 97012 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 100020 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 101260 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-02' WHERE SecCode = 104996 AND Type_ = 10;
UPDATE data_universe SET Name = 'XINJIANG SAILIMU M ''A''CNY1' WHERE SecCode = 105122 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MITSUI FUDOSAN RET REIT' WHERE SecCode = 114792 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125762 AND Type_ = 10;
UPDATE data_universe SET Name = 'RISHAB SPECIAL YAR INR10' WHERE SecCode = 126342 AND Type_ = 10;
UPDATE data_universe SET Name = 'LEXORAA INDUSTRIES INR10' WHERE SecCode = 126816 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 140844 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 143382 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 144665 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'RAK.NZ^E26', RkdIssueStatus = 0.0 WHERE SecCode = 145065 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 145774 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'VOIM ASA NOK1' WHERE SecCode = 212058 AND Type_ = 10;
UPDATE data_universe SET Name = 'PADAM COTTON YARNS INR1(POST SUBD)' WHERE SecCode = 243321 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 285304 AND Type_ = 10;
UPDATE data_universe SET Name = 'SURYACHAKRA POWER INR10' WHERE SecCode = 311013 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 319543 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GAON' WHERE SecCode = 349154 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TISI INC NPV' WHERE SecCode = 376140 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 376308 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55840859405.0, InstrPermID = 8590964758.0, OrgPermID = 4295888781.0, PriValQuotePermID = 55840859405.0, PriInstrPermID = 8590964758.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'AC', ExchCode = 'JNB', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'ZAF', IncCntry = 'ZAF', PriTRBCIndPermID = 4294951338.0, PermQuoteRetireDate = '2026-06-30', PermOrgIPODate = '2008-05-20', PermSecMapStartDate = '2008-05-19', PermSecMapEndDate = '2026-06-30' WHERE SecCode = 387643 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '101390.KQ^G26', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-30' WHERE SecCode = 409378 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 484585 AND Type_ = 10;
UPDATE data_universe SET InfoCode = 399868, DsSecCode = 274316, IsMajorSec = 'N', DsCtryQtStatus = 'D', DsPrimQtSedol = 'BTHVCS0', DsSecDelistDate = '2026-07-01', DsExchQtStartDate = '2026-06-30', SecMapStartDate = '2026-06-26', endDate = '2026-07-01' WHERE SecCode = 552491 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 843986 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232940880151.0 WHERE SecCode = 863623 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232940880151.0 WHERE SecCode = 863867 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 876445 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 933268 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'GFC.TA^F26', RkdIssueStatus = 0.0, QuotePermID = 21475776663.0, InstrPermID = 21475776662.0, OrgPermID = 5001689056.0, PriValQuotePermID = 21475776663.0, PriInstrPermID = 21475776662.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'TLV', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'ISR', IncCntry = 'ISR', PriTRBCIndPermID = 4294951448.0, PermQuoteRetireDate = '2026-06-30', PermOrgIPODate = '2011-02-17', PermSecMapStartDate = '2011-02-23', PermSecMapEndDate = '2026-06-30', startDate = '2011-02-17' WHERE SecCode = 1025098 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1353487 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1557092 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '106520.KQ^G26', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-30' WHERE SecCode = 1622819 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN011', QuotePermID = 21512412458.0, ExchCode = 'BUR' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1686400 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'OISIX INC NPV' WHERE SecCode = 2099072 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '3681.T^G26', RkdIssueStatus = 0.0, PermSecMapEndDate = '2026-06-30' WHERE SecCode = 2394793 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', DsPrimQtSedol = 'BPYV489', PermSecMapEndDate = '2026-07-01', endDate = '2026-07-01' WHERE SecCode = 2417295 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2417296 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 2531731 AND Type_ = 10;
UPDATE data_universe SET Name = 'RAAMA FINANCE LTD INR1' WHERE SecCode = 2592374 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2606468 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2696581 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2751777 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PIIPPO', QuotePermID = 21558959513.0, InstrPermID = 21558957147.0, OrgPermID = 4298270378.0, PriValQuotePermID = 21558959513.0, PriInstrPermID = 21558957147.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'HEX', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'FIN', IncCntry = 'FIN', PriTRBCIndPermID = 4294951688.0, PermQuoteRetireDate = '2026-06-30', PermOrgIPODate = '2015-03-10', PermSecMapStartDate = '2015-03-06', PermSecMapEndDate = '2026-06-30', startDate = '2015-03-06' WHERE SecCode = 2835285 AND Type_ = 10;
UPDATE data_universe SET Name = 'BLUEGOD ENTERTAIN INR1 (POST SUBD)' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2911314 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2913389 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2938929 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2945267 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, SecMapEndDate = '2079-06-06', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 2963543 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21589220364.0, ExchCode = 'DEU' WHERE SecCode = 2976573 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3038373 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3064599 AND Type_ = 10;
UPDATE data_universe SET Name = 'KANORIA ENERGY&INF INR5 (POST CONSOLIDATION)' WHERE SecCode = 3083499 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3086359 AND Type_ = 10;
UPDATE data_universe SET Name = 'SPR AUTO TECHNOLOG INR10' WHERE SecCode = 3185057 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '230360.KQ^F26', RkdIssueStatus = 0.0, PriValQuotePermID = NULL WHERE SecCode = 3217845 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3244940 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3275687 AND Type_ = 10;
UPDATE data_universe SET Name = 'PYRATZ CORPORATION EUR0.01' WHERE SecCode = 3275891 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3276033 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLINC B' WHERE SecCode = 3355024 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 232940880151.0 WHERE SecCode = 3371087 AND Type_ = 10;
UPDATE data_universe SET Name = 'SPRINGFORM TECHNOL INR10' WHERE SecCode = 3430222 AND Type_ = 10;
UPDATE data_universe SET Name = 'MEDICORTEX INTERNA SER''B''NPV' WHERE SecCode = 3433717 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3435529 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858470979.0, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-03', endDate = '2023-12-29' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3446637 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3629679 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3658733 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '227100.KQ^G26', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-30' WHERE SecCode = 3663157 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC', PermSecMapStartDate = '2026-06-30', PermSecMapEndDate = NULL, startDate = '2018-12-18', endDate = NULL WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 3706713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3719721 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3719722 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3798194 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GIFTEE GROUP INC NPV', RkdCode = 144914.0, RkdIssueCode = 185379.0, COATypeCode = '', QuotePermID = 236807886595.0, InstrPermID = 232937981300.0, PriValQuotePermID = 236807886595.0, PermSecMapStartDate = '2026-06-02', PermSecMapEndDate = NULL, startDate = '2019-09-20', endDate = NULL WHERE SecCode = 3961764 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4010770 AND Type_ = 10;
UPDATE data_universe SET Name = 'ACME INTERNATIONAL HKD0.01' WHERE SecCode = 4010777 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4129530 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01', endDate = '2026-07-01' WHERE SecCode = 4388174 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'C3R', QuotePermID = 21821661136.0, InstrPermID = 21820666943.0, OrgPermID = 5080142663.0, PriValQuotePermID = 21821661136.0, PriInstrPermID = 21820666943.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'GER', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'DEU', IncCntry = 'DEU', PriTRBCIndPermID = 4294951239.0, PermOrgIPODate = '2021-06-29', PermSecMapStartDate = '2021-06-23', startDate = '2021-06-23' WHERE SecCode = 4632104 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'MDH.L', RkdDisplayRIC = 'MDH.L', RkdExchCode = 'LON', PriValQuotePermID = 236808501799.0 WHERE SecCode = 4633023 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236809169007.0 WHERE SecCode = 5155289 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 5257731 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5262913 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5295044 AND Type_ = 10;
UPDATE data_universe SET Name = 'KUNDAN EDIFICE LIM INR10' WHERE SecCode = 5536095 AND Type_ = 10;
UPDATE data_universe SET Name = 'SAKIGAKE HOLDINGS NPV' WHERE SecCode = 5610094 AND Type_ = 10;
UPDATE data_universe SET Name = 'DOCMODE HEALTH TEC INR10' WHERE SecCode = 5646894 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 5689852 AND Type_ = 10;
UPDATE data_universe SET Name = 'DIVE GP INC NPV' WHERE SecCode = 5703163 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-30' WHERE SecCode = 5859850 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '293A.T', RkdDisplayRIC = '293A.T', RkdExchCode = 'TYO' WHERE SecCode = 6043600 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-30' WHERE SecCode = 6104639 AND Type_ = 10;
UPDATE data_universe SET Name = 'DASHER NEUROSCIENC TWD10' WHERE SecCode = 6308593 AND Type_ = 10;
UPDATE data_universe SET Name = 'ELLOS HOLDING AB NPV POST SPLIT' WHERE SecCode = 6608224 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 6724414 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PRABHAPP1', DsCtryQtStatus = 'A', DsPrimQtSedol = 'BWXKHB0', PermSecMapEndDate = '2026-07-01', endDate = '2026-07-01' WHERE SecCode = 6772975 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6832528 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6927587 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y734D110' WHERE SecCode = 6948297 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y5278110' WHERE SecCode = 6951857 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SEM.N^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 10922117 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 0.33333 WHERE SecCode = 10971738 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NSLR', Name = 'NEOSTELLAR CAP CORP COM NEW' WHERE SecCode = 11002274 AND Type_ = 1;
UPDATE data_universe SET Name = 'CHRONOSCALE HOLDINGS CORP COM NEW' WHERE SecCode = 11072364 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVV9XH0' WHERE SecCode = 11144792 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2013-02-26' WHERE SecCode = 11148269 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'BLD.N^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 11149443 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 25769770007.0, IsPrimaryQuote = 1.0, PermInstrStatus = 'DC', ExchCode = 'TOR', PermQuoteRetireDate = '2026-06-30', PermSecMapStartDate = '2016-04-26', PermSecMapEndDate = '2026-06-30', endDate = '2026-06-30' WHERE SecCode = 11158560 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11169286 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'STEL.N^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01' WHERE SecCode = 11178625 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BJVSHY8' WHERE SecCode = 11195368 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11196712 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GLAS', QuotePermID = 236809171108.0, PermQuoteStatus = 'AC', ExchCode = 'MPE', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-06-30', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11198864 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SILA.N^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-01', SecMapEndDate = '2026-06-30', PermQuoteRetireDate = '2026-07-01', PermSecMapEndDate = '2026-07-01', endDate = '2026-06-30' WHERE SecCode = 11201264 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11202259 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 11211867 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11227447 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'CIRC', RkdRIC = 'CIRC.O', RkdDisplayRIC = 'CIRC.OQ', Name = 'CIRCLE8 GROUP INC COM' WHERE SecCode = 11229331 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11252479 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BPY0BP2' WHERE SecCode = 11256200 AND Type_ = 1;
UPDATE data_universe SET Country = 'BMU' WHERE SecCode = 11264576 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11275438 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'HODO', PermIDTicker = 'HODO', RkdRIC = 'HODO.O', RkdDisplayRIC = 'HODO.OQ' WHERE SecCode = 11275764 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000174710.0, IncCntry = 'USA', PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 11277550 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-07-02', SecMapEndDate = '2026-07-01', endDate = '2026-07-01' WHERE SecCode = 11277714 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295148 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11297836 AND Type_ = 1;
