UPDATE data_universe SET PermIDTicker = 'KFX', QuotePermID = 21475562628.0, ExchCode = 'VTX', PermQuoteRetireDate = '2009-02-02', endDate = '2009-02-02' WHERE SecCode = 3735 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PCI', QuotePermID = 21475530609.0, ExchCode = 'POS', PermQuoteRetireDate = '2008-12-05', endDate = '2008-12-05' WHERE SecCode = 4613 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'XAN', QuotePermID = 21475442982.0, ExchCode = 'POS' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'NOTVQ', RkdSEDOL = NULL, RkdRIC = 'NOTVQ.PK', RkdDisplayRIC = 'NOTVQ.PK', RkdExchCode = 'OTC' WHERE SecCode = 9321 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2002-03-22' WHERE SecCode = 11689 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 28602 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 29858 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 37631 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 40255 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 40941 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 44507 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'MASI.OQ^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-11', SecMapEndDate = '2026-06-09', endDate = '2026-06-09' WHERE SecCode = 44800 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 48629 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 49435 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-10' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 49698 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'D1176028' WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 52016 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 52597 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 52734 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951764.0 WHERE SecCode = 52790 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 53104 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 53167 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 53347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 55642 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ACOMA', QuotePermID = 21474899218.0, ExchCode = 'BUR', PermQuoteRetireDate = '2013-02-01', endDate = '2013-01-31' WHERE SecCode = 61968 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 62323 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236808161669.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-06-09' WHERE SecCode = 69221 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71847 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 RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 80356 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU000000HLX7', RkdTicker = 'HLX', PermIDTicker = 'HLX', RkdSEDOL = '641966', RkdCUSIP = 'Q4566710', RkdRIC = 'HLX.AX', RkdDisplayRIC = 'HLX.AX', DsPrimQtSedol = '6419666', RkdCode = 23699.0, RkdIssueID = 1.0, RkdIssueCode = 32578.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = 'IND', SecMapStartDate = '2026-06-10', SecMapEndDate = '2079-06-06', PermSecMapStartDate = '2026-06-10', PermSecMapEndDate = NULL, startDate = '1986-05-22', endDate = NULL WHERE SecCode = 82750 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 83000 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q1714E20' WHERE SecCode = 83612 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4556.T^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-11', SecMapEndDate = '2026-06-10', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 85118 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951691.0 WHERE SecCode = 86474 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 87258 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 87909 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 88260 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 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 RkdISIN = 'CA4820451017', RkdTicker = 'JUN.A', RkdSEDOL = 'BVTD8G', RkdCUSIP = '48204510', RkdRIC = 'JUNa.V', RkdDisplayRIC = 'JUNa.V', DsPrimQtSedol = 'BVTD8G8' WHERE SecCode = 97343 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 100724 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 102597 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 102656 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 102789 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 103626 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 104502 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 121264 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 137931 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 146271 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 146275 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 146283 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55846008505.0, ExchCode = 'STU', PermQuoteRetireDate = '2018-10-31', endDate = '2018-10-31' WHERE SecCode = 147917 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 197332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 206733 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 239119 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 240051 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 241763 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 241853 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 241855 AND Type_ = 10;
UPDATE data_universe SET Name = 'BEVEST ASA NOK12' WHERE SecCode = 317693 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 323208 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 331012 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 364378 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 388224 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 507425 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 530685 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 531911 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 542968 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'EVOLOGIC INTL LTD NPV' WHERE SecCode = 549697 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 553259 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 561090 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 562896 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 608979 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 703334 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 703456 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 736972 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 827639 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236793424076.0 WHERE SecCode = 940796 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1144815 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1246746 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y3814N25' WHERE SecCode = 1485605 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951937.0 WHERE SecCode = 1531716 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN0112', QuotePermID = 21512394267.0, ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 1773399 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 1929718 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 2083922 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2252347 AND Type_ = 10;
UPDATE data_universe SET Name = 'NOVAVEST REAL ESTA CHF19.90 (REGD) SERIES A' WHERE SecCode = 2293878 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2394812 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2593540 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 2701549 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2729683 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 2731234 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2945305 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'AOF.AX^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-10', SecMapEndDate = '2026-06-03', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-03' WHERE SecCode = 3184368 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3194837 AND Type_ = 10;
UPDATE data_universe SET Name = 'RANGE INTL LTD NPV' WHERE SecCode = 3207868 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3217845 AND Type_ = 10;
UPDATE data_universe SET Name = 'KEO CAPITAL AB SER''A''NPV' WHERE SecCode = 3219525 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-20' WHERE SecCode = 3247536 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3289743 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 3319626 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'TBX0.TG', RkdDisplayRIC = 'TBX0.TG', RkdIssueStatus = 1.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 3339539 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3365568 AND Type_ = 10;
UPDATE data_universe SET Name = 'AZZURO RES PLC CDI 1:1' WHERE SecCode = 3395184 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3395480 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3433491 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 3437535 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 3540555 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = NULL WHERE SecCode = 3899669 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 = 4001155 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4035749 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4178606 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 PrimaryIssueCode = NULL WHERE SecCode = 4425536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4464617 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'G1993H10' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 4533297 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 RkdISIN = 'IL0011758195', RkdTicker = 'ABOU', RkdSEDOL = 'BN44PV', RkdCUSIP = 'M4058W10', RkdRIC = 'ABOU.TA', RkdDisplayRIC = 'ABOU.TA', RkdCode = 145011.0, RkdIssueID = 1.0, RkdIssueCode = 185497.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TLV', RkdExchCtry = 'ISR', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 4613101 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'HUI', RkdRIC = 'HUI.L', RkdDisplayRIC = 'HUI.L', RkdExchCode = 'LON' WHERE SecCode = 4825109 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-06-09', PermQuoteRetireDate = '2026-06-10', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-09' WHERE SecCode = 4854770 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4871153 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-10' WHERE SecCode = 5108979 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951227.0 WHERE SecCode = 5260510 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 5438120 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5454712 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951588.0 WHERE SecCode = 5509537 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5859846 AND Type_ = 10;
UPDATE data_universe SET Name = 'SCANDINAVIAN ASTOR NPV' WHERE SecCode = 5898737 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6173318 AND Type_ = 10;
UPDATE data_universe SET Name = 'OPTASIA LTD NPV' WHERE SecCode = 6533413 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6622164 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6622350 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6686349 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y077NE10' WHERE SecCode = 6802661 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y8818910' WHERE SecCode = 6806185 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, PermIDTicker = 'HLX', RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, DsPrimQtSedol = '6419666', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, SecMapEndDate = '2026-06-09', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-09' WHERE SecCode = 6808989 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-11', SecMapEndDate = '2026-06-10', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 6829241 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y767UC10' WHERE SecCode = 6839611 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6857268 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y6T0KL10' WHERE SecCode = 6870722 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 11030021 AND Type_ = 1;
UPDATE data_universe SET Name = 'ABOUND ENERGY INC COM NEW', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11198984 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11199570 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA05157Q1028', RkdTicker = 'AURO', RkdSEDOL = 'BVTD8L', RkdCUSIP = '05157Q10', RkdRIC = 'AURO.V', RkdDisplayRIC = 'AURO.V', DsPrimQtSedol = 'BVTD8L3' WHERE SecCode = 11215356 AND Type_ = 1;
UPDATE data_universe SET Name = 'PETCO HEALTH & WELLNESS CO I CL A COM' WHERE SecCode = 11217503 AND Type_ = 1;
UPDATE data_universe SET Name = 'SAB BIOTHERAPEUTICS INC *W EXP 10/22/2026' WHERE SecCode = 11219202 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US92339H2004', RkdSEDOL = 'BVTD8N', RkdCUSIP = '92339H20', DsPrimQtSedol = 'BVTD8N5' WHERE SecCode = 11219488 AND Type_ = 1;
UPDATE data_universe SET Name = 'MOOLEC SCIENCE SA *W EXP 01/30/2028' WHERE SecCode = 11220162 AND Type_ = 1;
UPDATE data_universe SET Name = 'AURORA INNOVATION INC *W EXP 11/03/2026' WHERE SecCode = 11223947 AND Type_ = 1;
UPDATE data_universe SET Name = 'ESTRELLA IMMUNOPHARMA INC *W EXP 09/29/2028' WHERE SecCode = 11229780 AND Type_ = 1;
UPDATE data_universe SET Name = 'AERIES TECHNOLOGY INC *W EXP 11/06/2028' WHERE SecCode = 11235701 AND Type_ = 1;
UPDATE data_universe SET Name = 'TEVOGEN BIO HLDGS INC *W EXP 02/14/2029' WHERE SecCode = 11236752 AND Type_ = 1;
UPDATE data_universe SET Name = 'FOLD HLDGS INC *W EXP 02/14/2030' WHERE SecCode = 11238242 AND Type_ = 1;
UPDATE data_universe SET Name = 'ASPIRE BIOPHARMA HLDGS INC *W EXP 02/14/2030' WHERE SecCode = 11240919 AND Type_ = 1;
UPDATE data_universe SET Name = 'AUTOMATA RARE EARTH CORP COM' WHERE SecCode = 11243216 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US8256935003', RkdSEDOL = 'BVTD8K', RkdCUSIP = '82569350', DsPrimQtSedol = 'BVTD8K2' WHERE SecCode = 11245181 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = '52D0', RkdRIC = '52D0.F^F26', RkdExchCode = 'FRA', RkdExchCtry = 'DEU' WHERE SecCode = 11245859 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951568.0 WHERE SecCode = 11257658 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG3937M2059', RkdSEDOL = 'BVTD87', RkdCUSIP = 'G3937M20', DsPrimQtSedol = 'BVTD879' WHERE SecCode = 11258165 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueCode = NULL, RelType = NULL WHERE SecCode = 11260395 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-06-09', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-09' WHERE SecCode = 11261977 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ENRD', DsExchMnem = 'NAS', ShPerListing = 1.0, ExchCode = 'NMS', QuoteClass = 'ADR', InstrClass = 'ADR', SecMapStartDate = '2024-03-28', PermSecMapEndDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11263764 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11267640 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-11', SecMapEndDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11268281 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CH1476899161', RkdTicker = 'VRXA', RkdSEDOL = 'BVMH34', RkdCUSIP = 'H9130A10', RkdRIC = 'VRXA.O', RkdDisplayRIC = 'VRXA.OQ', DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-11', SecMapEndDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11270117 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-11', SecMapEndDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11272673 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US05338N1019', RkdTicker = 'AVAT', RkdSEDOL = 'BWRXM8', RkdCUSIP = '05338N10', RkdRIC = 'AVAT.O', RkdDisplayRIC = 'AVAT.OQ', DsPrimQtSedol = 'BWRXM87' WHERE SecCode = 11274579 AND Type_ = 1;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-10' WHERE SecCode = 11275347 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11277843 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'BREZU.OQ^F26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-06-11', SecMapEndDate = '2026-06-10', endDate = '2026-06-10' WHERE SecCode = 11295855 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232906636152.0, DsExchQtStartDate = '2026-05-21', PermOrgIPODate = '2026-06-10' WHERE SecCode = 11296309 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US53229X1019', RkdTicker = 'LFTO', RkdSEDOL = 'BPSKXZ', RkdCUSIP = '53229X10', RkdRIC = 'LFTO.O', RkdDisplayRIC = 'LFTO.OQ', RkdCode = 144131.0, RkdIssueID = 1.0, RkdIssueCode = 184101.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11297024 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA9199211066', RkdTicker = 'VGC', RkdSEDOL = 'BXM7C0', RkdCUSIP = '91992110', RkdRIC = 'VGC.TO', RkdDisplayRIC = 'VGC.TO', RkdCode = 145010.0, RkdIssueID = 1.0, RkdIssueCode = 185496.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11297183 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BEP.PR.S', QuotePermID = 236808062388.0, InstrPermID = 232937628887.0, OrgPermID = 5036863897.0, PriValQuotePermID = 236808062388.0, PriInstrPermID = 8590920530.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'PREFERRED', InstrClass = 'PREFERRED', OrgTypeCode = 'COM', DomCntry = 'BMU', IncCntry = 'BMU', PriTRBCIndPermID = 1004365477.0, PermOrgIPODate = '1999-11-18', PermSecMapStartDate = '2026-06-06', startDate = '2026-06-06' WHERE SecCode = 11297190 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'WHK', QuotePermID = 236808063351.0, InstrPermID = 232935364690.0, OrgPermID = 5082506312.0, PriTrdQuotePermID = 236808063351.0, PriValQuotePermID = 25727019075.0, PriInstrPermID = 232935364690.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951998.0, PermOrgIPODate = '2026-06-09', PermSecMapStartDate = '2026-06-06', startDate = '2026-06-06' WHERE SecCode = 11297291 AND Type_ = 1;