UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 10938 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 23211 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 8589953249.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2025-12-22', PermQuoteRetireDate = '2026-06-23', endDate = '2025-12-22' WHERE SecCode = 30013 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 30213 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 30235 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 33326 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 44329 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-23' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 49597 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951527.0 WHERE SecCode = 54469 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-18', PermSecMapEndDate = '2026-06-23', endDate = '2026-06-18' WHERE SecCode = 55789 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 69402 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 69638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72682 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 PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 76880 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 78159 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 78460 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BXNDA', DsPrimQtSedol = 'BTZCS54', SecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 78713 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81778 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 82358 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 82584 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 82957 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83518 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHUBB LIMITED COM' WHERE SecCode = 83700 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 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 PermInstrStatus = 'DC' WHERE SecCode = 89948 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA0402673044', RkdTicker = 'AR.PR.D', RkdCUSIP = '04026730', RkdRIC = 'AR_pd.TO^H08', RkdCode = 42858.0, RkdIssueID = 1.0, RkdIssueCode = 55783.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 90518 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 92482 AND Type_ = 1;
UPDATE data_universe SET Name = 'DYNASTY DIGITAL HKD0.083' WHERE SecCode = 92589 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 93731 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET DsSecDelistDate = '2024-10-01' WHERE SecCode = 95595 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHA AI HLTH KARE KRW500' WHERE SecCode = 95821 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-29' WHERE SecCode = 95877 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', endDate = '2026-06-24' WHERE SecCode = 96476 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000133454.0, PriInstrPermID = 8590028042.0, PermOrgIPODate = NULL WHERE SecCode = 97949 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-26' WHERE SecCode = 113724 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y0497S10' WHERE SecCode = 113941 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 127118 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'TERA', Name = 'NEOTERRA GROUP PLC ORD GBP0.01' WHERE SecCode = 131838 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 137731 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 144724 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951915.0 WHERE SecCode = 145059 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 190299 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 195140 AND Type_ = 10;
UPDATE data_universe SET Name = 'LSKAIROBOT CO LTD KRW2500' WHERE SecCode = 195173 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-10', PermQuoteRetireDate = '2026-06-23', endDate = '2026-06-10' WHERE SecCode = 206733 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 288634 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 331348 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ECHO' WHERE SecCode = 335216 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'AU0000475568', RkdTicker = 'M96', RkdSEDOL = 'BX59CS', RkdRIC = 'M96.AX', RkdDisplayRIC = 'M96.AX', SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 336664 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 522882 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 545930 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951968.0 WHERE SecCode = 558540 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-10', PermQuoteRetireDate = '2026-06-23', endDate = '2026-06-10' WHERE SecCode = 562896 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEOVACS EUR1 (POST CONS)' WHERE SecCode = 588831 AND Type_ = 10;
UPDATE data_universe SET Name = 'PHIONX USD0.15' WHERE SecCode = 637304 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 726370 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-24', SecMapEndDate = '2026-04-01', PermQuoteRetireDate = '2026-06-24', endDate = '2026-04-01' WHERE SecCode = 798142 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 968951 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1158940 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BXNDA', DsPrimQtSedol = 'BTZCS54' WHERE SecCode = 1522818 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1599586 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE798C01017', RkdTicker = '512197', RkdSEDOL = 'B8KQ3N', RkdCUSIP = 'Y7936N11', RkdRIC = 'SILV.BO', RkdDisplayRIC = 'SILV.BO', RkdCode = 145043.0, RkdIssueID = 1.0, RkdIssueCode = 185566.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BOM', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 1641430 AND Type_ = 10;
UPDATE data_universe SET Name = 'JAKOTA CAPITAL (HO HKD0.1' WHERE SecCode = 1660603 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2428148 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ALFER' WHERE SecCode = 2571188 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2693646 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2782865 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2836275 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2862763 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2866617 AND Type_ = 10;
UPDATE data_universe SET Name = 'ATMA INDUSTRIES LI INR10' WHERE SecCode = 2943703 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2954425 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2976322 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 3015899 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 3062337 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CHINA CRYSTAL NEW USD2.0' WHERE SecCode = 3076058 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3183968 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3259339 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3262686 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3284006 AND Type_ = 10;
UPDATE data_universe SET Name = 'AAC CLYDE SPACE AB NPV' WHERE SecCode = 3284914 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3297033 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET Name = 'BEAUTIFUL LIFE GP HKD0.01' WHERE SecCode = 3327782 AND Type_ = 10;
UPDATE data_universe SET Name = 'REACH NEW HLDGS LT HKD0.2' WHERE SecCode = 3378476 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951319.0 WHERE SecCode = 3380814 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2014-12-16' WHERE SecCode = 3387586 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3395672 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3401658 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951439.0 WHERE SecCode = 3615170 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-06-24', SecMapEndDate = '2026-06-19', PermQuoteRetireDate = '2026-06-24', endDate = '2026-06-19' WHERE SecCode = 3703402 AND Type_ = 10;
UPDATE data_universe SET Name = 'COMINTELL' WHERE SecCode = 3721197 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 3852663 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 Name = 'AMAERO INC NPV CDI 40:1', Country = 'USA' WHERE SecCode = 4036738 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 Name = 'HUMAN XTENSIONS LT ILS0.01' WHERE SecCode = 4429560 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-22' WHERE SecCode = 4434255 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 PriTRBCIndPermID = 4294951843.0 WHERE SecCode = 4617794 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21899163259.0, ExchCode = 'AQX', PermQuoteRetireDate = '2024-09-30', endDate = '2024-09-30' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 125689.0, PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 4749905 AND Type_ = 10;
UPDATE data_universe SET Name = 'METAVISIO SA EUR0.002' WHERE SecCode = 4796000 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 5417660 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2023-06-30' WHERE SecCode = 5455474 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2023-06-29', startDate = '2023-06-29' WHERE SecCode = 5455477 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5500276 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 5633491 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5760140 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 5859841 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 5898712 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6008861 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 6058661 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 6258209 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6258211 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 6305206 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'TWN' WHERE SecCode = 6322269 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6396598 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951678.0 WHERE SecCode = 6533610 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6601486 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6601499 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01', startDate = '1753-01-01' WHERE SecCode = 6601500 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 6626390 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 6626814 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951832.0 WHERE SecCode = 6628117 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951210.0 WHERE SecCode = 6635229 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 6638314 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 6829242 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-24', SecMapEndDate = '2026-06-23', endDate = '2026-06-23' WHERE SecCode = 6857266 AND Type_ = 10;
UPDATE data_universe SET Name = 'DALY RESOURCES NPV', IsPrimaryQuote = 1.0, PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = '2026-06-23' WHERE SecCode = 6930668 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10923248 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'TSE', ExchCode = 'TOR' WHERE SecCode = 11015873 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23', endDate = '2026-06-23' WHERE SecCode = 11112456 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11130053 AND Type_ = 1;
UPDATE data_universe SET Name = 'HAPPEN INC COM NEW' WHERE SecCode = 11142751 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11151885 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BW60F13' WHERE SecCode = 11176481 AND Type_ = 1;
UPDATE data_universe SET Name = 'CAT STRATEGIC METALS CORP COM SHS' WHERE SecCode = 11203366 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'FIRY', RkdRIC = 'FIRY.K', RkdDisplayRIC = 'FIRY.N', Name = 'FIRY INC COM CL A' WHERE SecCode = 11207267 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-06-23', SecMapEndDate = '2026-06-22', endDate = '2026-06-22' WHERE SecCode = 11210606 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-23', endDate = '2026-06-23' WHERE SecCode = 11214004 AND Type_ = 1;
UPDATE data_universe SET Name = 'RUM GROUP INC COM CL A' WHERE SecCode = 11222408 AND Type_ = 1;
UPDATE data_universe SET Name = 'RUM GROUP INC *W EXP 09/16/2027' WHERE SecCode = 11222507 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365405.0 WHERE SecCode = 11226938 AND Type_ = 1;
UPDATE data_universe SET Name = 'SMARTBIRD INC CL A NEW' WHERE SecCode = 11233216 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-24', endDate = '2026-06-24' WHERE SecCode = 11235980 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11239433 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11248583 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2023-01-18' WHERE SecCode = 11248948 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVSRPB5' WHERE SecCode = 11262021 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NMB', Name = 'NORTHMIN CORP COM SHS' WHERE SecCode = 11266759 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ARLYF' WHERE SecCode = 11267641 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11270668 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-02-05' WHERE SecCode = 11271694 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2025-02-05' WHERE SecCode = 11274684 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11275270 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11275438 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11277033 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TMS', Country = 'USA', ExchCode = 'NAS' WHERE SecCode = 11277550 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11286613 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 11286891 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11294834 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, IsMajorSec = 'N', PriInstrPermID = 232917713569.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-23', PermSecMapEndDate = '2026-06-23' WHERE SecCode = 11295230 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11295811 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236808686462.0, IsPrimaryQuote = 1.0, ExchCode = 'TOR' WHERE SecCode = 11297816 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MTNE', QuotePermID = 236808552194.0, InstrPermID = 232870524460.0, OrgPermID = 5091405187.0, PriTrdQuotePermID = 236808552194.0, PriValQuotePermID = 25727017304.0, PriInstrPermID = 232870524460.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-05-01', PermSecMapStartDate = '2026-06-17', startDate = '2026-05-01' WHERE SecCode = 11297836 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CAII', QuotePermID = 236808687074.0, InstrPermID = 232925823392.0, OrgPermID = 6000078832.0, PriTrdQuotePermID = 236808687074.0, PriValQuotePermID = 25727016813.0, PriInstrPermID = 232925823392.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-29', PermSecMapStartDate = '2026-06-19', startDate = '2026-04-29' WHERE SecCode = 11297837 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236808687047.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11297838 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236808687092.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11297839 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236808687143.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11297841 AND Type_ = 1;