UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 3901 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21475442988.0, ExchCode = 'CHI' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 7013 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236809529907.0, PriTrdQuotePermID = 236809529907.0, ExchCode = 'NAS', PermSecMapStartDate = '2026-07-08' WHERE SecCode = 9345 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236809529934.0, PriTrdQuotePermID = 236809529934.0, ExchCode = 'NMS', PermSecMapStartDate = '2026-07-08' WHERE SecCode = 12307 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096835110.0, PriInstrPermID = 8590931788.0, IncCntry = 'CYM', PriTRBCIndPermID = NULL WHERE SecCode = 13989 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'TBRG.OQ^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-10', SecMapEndDate = '2026-07-08', PermQuoteRetireDate = '2026-07-10', endDate = '2026-07-08' WHERE SecCode = 16322 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 19809 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 34959 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482034.0, ExchCode = 'QTX' WHERE SecCode = 35642 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DYH', QuotePermID = 55836326929.0, PermQuoteStatus = 'DC', ExchCode = 'BER', PermQuoteRetireDate = '2026-01-01' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838405650.0, PriValQuotePermID = 55835776660.0, ExchCode = 'STU', PermQuoteRetireDate = '2026-07-09', PermSecMapEndDate = NULL, endDate = '2026-07-09' WHERE SecCode = 56295 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'ES01717430J3', RkdSEDOL = 'BSSDT7', RkdCUSIP = 'E8S88138', DsPrimQtSedol = 'BSSDT76' WHERE SecCode = 66628 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 67906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-09', PermQuoteRetireDate = '2026-07-09', PermSecMapEndDate = '2026-07-09', endDate = '2026-07-09' WHERE SecCode = 68818 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 71115 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55838832264.0, InstrPermID = 8589951641.0, OrgPermID = 4295886187.0, PriValQuotePermID = 55838832264.0, PriInstrPermID = 8589951641.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', ExchCode = 'PHS', QuoteClass = 'FULLPAID', InstrClass = 'FULLPAID', OrgTypeCode = 'COM', DomCntry = 'PHL', IncCntry = 'PHL', PriTRBCIndPermID = 4294951333.0, PermQuoteRetireDate = '2026-07-06', PermOrgIPODate = '1999-12-13', PermSecMapStartDate = '1999-12-16', PermSecMapEndDate = '2026-07-05' WHERE SecCode = 73885 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'REALORD TECH CO HKD0.10' WHERE SecCode = 73912 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CERYVYN THERAPEUTI NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 74387 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74528 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 77289 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'UEME.KL^G26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-10', SecMapEndDate = '2026-06-11', PermQuoteRetireDate = '2026-07-10', endDate = '2026-06-11' WHERE SecCode = 78488 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 78664 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL WHERE SecCode = 88250 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVSV6C5' WHERE SecCode = 91736 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL WHERE SecCode = 91917 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '1960-01-01' WHERE SecCode = 92626 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA3742713025', RkdSEDOL = 'BPY09K', RkdCUSIP = '37427130' WHERE SecCode = 94367 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1990-06-08' WHERE SecCode = 94669 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 95184 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 95321 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MASON CAPITAL CORP KRW1000' WHERE SecCode = 96193 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTMT3V9' WHERE SecCode = 99271 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 99992 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 113490 AND Type_ = 10;
UPDATE data_universe SET Name = 'METEORIC RES LTD NPV' WHERE SecCode = 113780 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'FEN.L^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-07-09' WHERE SecCode = 114799 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 115380 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', DsPrimQtSedol = 'BT6D6W9', PermSecMapEndDate = '2026-07-09', endDate = '2026-07-09' WHERE SecCode = 126529 AND Type_ = 10;
UPDATE data_universe SET Name = 'EBIX LTD INR1(POST SUBD)' WHERE SecCode = 135128 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'MSLG.BO', RkdDisplayRIC = 'MSLG.BO', Name = 'MSL GLOBAL LTD INR10' WHERE SecCode = 136774 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137655 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-07-08', PermQuoteRetireDate = '2026-07-09', PermSecMapEndDate = '2026-07-09', endDate = '2026-07-08' WHERE SecCode = 145285 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55856245271.0, ExchCode = 'DUS', PermQuoteRetireDate = '2018-11-14', endDate = '2018-11-13' WHERE SecCode = 147917 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 206733 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VNE', RkdRIC = 'VNE.HNO', RkdDisplayRIC = 'VNE.HNO', RkdIssueStatus = 1.0, RkdExchCode = 'UPC' WHERE SecCode = 522937 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-10', SecMapEndDate = '2026-07-09', PermQuoteRetireDate = '2026-07-10', endDate = '2026-07-09' WHERE SecCode = 558540 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 562896 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermInstrStatus = 'DC' WHERE SecCode = 565523 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-15' WHERE SecCode = 702056 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-28' WHERE SecCode = 766928 AND Type_ = 10;
UPDATE data_universe SET Name = 'EMETALS LTD NPV' WHERE SecCode = 797593 AND Type_ = 10;
UPDATE data_universe SET Name = 'LIT LIFE HLDGS LTD HKD0.01 (POST COMP)' WHERE SecCode = 819403 AND Type_ = 10;
UPDATE data_universe SET Name = 'EXXONMOBIL HOLDING BDR EACH 8 REPR 1 COM' WHERE SecCode = 1060452 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRYDB', DsPrimQtSedol = 'BVMTKZ6', PermSecMapEndDate = '2026-07-09', endDate = '2026-07-09' WHERE SecCode = 1142412 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1580356 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2455560 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2515633 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ALVGV.PA^G26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 2531731 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = NULL, IsPrimaryQuote = 0.0 WHERE SecCode = 2646553 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2865468 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-09', PermQuoteRetireDate = '2026-07-09' WHERE SecCode = 2970654 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21628902471.0, ExchCode = 'MUN' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3010361 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3056107 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3056869 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21716782408.0, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21', endDate = '2021-01-20' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21858470979.0, ExchCode = 'FRA', PermQuoteRetireDate = '2024-01-03' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET Name = 'NATIONAL REALTY CO VND10000' WHERE SecCode = 3444853 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3547243 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3706493 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2019-01-08' WHERE SecCode = 3719723 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3917553 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 4426889 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 ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21929410708.0, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ALUAV', ExchCode = 'PAR' WHERE SecCode = 4981964 AND Type_ = 10;
UPDATE data_universe SET Name = 'IBI LION SOCIMI SA EUR0.805' WHERE SecCode = 5063552 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXPVRZ2' WHERE SecCode = 5082416 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 5277525 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 6056914 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 6441612 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6627460 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6708243 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6885937 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL WHERE SecCode = 6890758 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, ModelCntry = 'HK', DsCtryQtStatus = 'D', QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, DsSecDelistDate = '2026-07-10', SecMapEndDate = '2026-07-09', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2026-06-03', endDate = '2026-07-09' WHERE SecCode = 6893663 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6893664 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DK0064982565', RkdTicker = 'IG', RkdSEDOL = 'BX59JL', RkdCUSIP = 'K4922D10', RkdRIC = 'IGR.CO', RkdDisplayRIC = 'IGR.CO', RkdCode = 145150.0, RkdIssueID = 1.0, RkdIssueCode = 185729.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CPH', RkdExchCtry = 'DNK', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6911554 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HSX', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-07-09', PermSecMapEndDate = NULL, startDate = '2019-07-30', endDate = NULL WHERE SecCode = 6927579 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6945363 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6948299 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6948300 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6951850 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6951870 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6951874 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 6969124 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6969131 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951294.0 WHERE SecCode = 6969139 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6969149 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951954.0 WHERE SecCode = 6969348 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BTMT3X1' WHERE SecCode = 11019958 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-07-09', endDate = '2026-07-09' WHERE SecCode = 11027686 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL WHERE SecCode = 11080057 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'M4130Y17' WHERE SecCode = 11138070 AND Type_ = 1;
UPDATE data_universe SET Name = 'AZIO AI HOLDINGS INC COM' WHERE SecCode = 11173743 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BTMQZB4' WHERE SecCode = 11193775 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ZAIRF' WHERE SecCode = 11198984 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VRNO' WHERE SecCode = 11219488 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL WHERE SecCode = 11219530 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL WHERE SecCode = 11231455 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BTMT3Z3', PermSecMapEndDate = '2025-07-05', endDate = '2025-07-05' WHERE SecCode = 11231753 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11248308 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 11249090 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PMA' WHERE SecCode = 11271948 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'MHY731181209', RkdSEDOL = 'BSNSP9', RkdCUSIP = 'Y7311812' WHERE SecCode = 11277132 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US81517B1017', RkdTicker = 'SECZ', RkdSEDOL = 'BPXZLS', RkdCUSIP = '81517B10', RkdRIC = 'SECZ.K', RkdDisplayRIC = 'SECZ.N', RkdExchCode = 'NYSE' WHERE SecCode = 11277957 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', QuotePermID = 236809410558.0, IsPrimaryQuote = 0.0, PermInstrStatus = 'DC', ExchCode = 'TXC', DsSecDelistDate = '2026-07-10', SecMapEndDate = '2025-09-26', endDate = '2025-09-26' WHERE SecCode = 11277960 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US4629211073', RkdTicker = 'IQMX', RkdSEDOL = 'BTCLFZ', RkdCUSIP = '46292110', RkdRIC = 'IQMX.O', RkdDisplayRIC = 'IQMX.OQ', RkdListingType = 'ADR', ShPerListing = 1.0 WHERE SecCode = 11278832 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BTMQZD6', PermSecMapEndDate = '2025-12-11', endDate = '2025-12-11' WHERE SecCode = 11281418 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'EQ', DsExchMnem = 'NYS', ExchCode = 'NYS' WHERE SecCode = 11290249 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA88834X1042', RkdTicker = 'TITI', RkdSEDOL = 'BT66LP', RkdCUSIP = '88834X10', RkdRIC = 'TITI.V', RkdDisplayRIC = 'TITI.V', RkdCode = 145148.0, RkdIssueID = 1.0, RkdIssueCode = 185727.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN', PrimaryIssueType = 'PVT', COATypeCode = 'IND' WHERE SecCode = 11294283 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11294653 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US51255A2015', RkdSEDOL = 'BPK474', RkdCUSIP = '51255A20' WHERE SecCode = 11294834 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11296975 AND Type_ = 1;
UPDATE data_universe SET Name = 'FREEDOM METALS ACQUISITION UNIT 07/01/2031' WHERE SecCode = 11298892 AND Type_ = 1;
