UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'EA.OQ^H26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-08-05', SecMapEndDate = '2026-08-04', endDate = '2026-08-04' WHERE SecCode = 23378 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-05', SecMapEndDate = '2026-07-30', endDate = '2026-07-30' WHERE SecCode = 33139 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21593087896.0, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 44481 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868.0, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 46706 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000220625.0 WHERE SecCode = 49676 AND Type_ = 1;
UPDATE data_universe SET Name = 'DUNE OIL CORP COM SHS', DsPrimQtSedol = 'BNYG424', PermOrgIPODate = NULL, startDate = '2019-03-30' WHERE SecCode = 71190 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77039 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81168 AND Type_ = 10;
UPDATE data_universe SET Name = 'YPF SOCIEDAD ANONIMA SPONSORED ADS' WHERE SecCode = 82852 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86795 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BNYGM75' WHERE SecCode = 93906 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'ZHEJIANG DIGITAL C ''A''CNY1' WHERE SecCode = 95868 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-08-04', endDate = '2026-08-04' WHERE SecCode = 98956 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'INE063E01061', RkdSEDOL = 'BVMWHP', RkdCUSIP = 'Y7063121' WHERE SecCode = 112417 AND Type_ = 10;
UPDATE data_universe SET Name = 'SINOMA INTL ENGINE ''A''CNY1' WHERE SecCode = 133129 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 137529 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 138070 AND Type_ = 10;
UPDATE data_universe SET Name = 'M1 AESTHETICS AG NPV (POST SPLIT)' WHERE SecCode = 142381 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'PHC', RkdRIC = 'PHC.KW', RkdDisplayRIC = 'PHC.KW' WHERE SecCode = 143799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 147076 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 154474 AND Type_ = 1;
UPDATE data_universe SET PriValQuotePermID = 55836394912.0 WHERE SecCode = 161158 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-05', SecMapEndDate = '2026-08-04', endDate = '2026-08-04' WHERE SecCode = 265315 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'MOJ.WA^G26', RkdIssueStatus = 0.0 WHERE SecCode = 295300 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-05', SecMapEndDate = '2026-08-04', endDate = '2026-08-04' WHERE SecCode = 309037 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-05', endDate = '2026-08-05' WHERE SecCode = 331641 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000229832.0, IncCntry = 'USA', PriTRBCIndPermID = 1004365348.0 WHERE SecCode = 336830 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475473202.0, ExchCode = 'FRA' WHERE SecCode = 351305 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 538910 AND Type_ = 10;
UPDATE data_universe SET Name = 'DU DU HOLDINGS HKD0.01' WHERE SecCode = 562883 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX86HZ4', SecMapEndDate = '2026-08-03', endDate = '2026-08-03' WHERE SecCode = 565859 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX86HZ4' WHERE SecCode = 581703 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1485663 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-08-04', PermSecMapEndDate = '2026-08-04' WHERE SecCode = 2990831 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ALPOU.PA^G26', RkdIssueStatus = 0.0 WHERE SecCode = 3026504 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3268522 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 DsExchQtStartDate = '2017-07-10', startDate = '2017-07-06' WHERE SecCode = 3374533 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'AILIFE INTL GRO LT HKD0.01' WHERE SecCode = 3410319 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 DsExchQtStartDate = '2018-04-09', startDate = '2018-04-05' WHERE SecCode = 3445137 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2019-04-16', startDate = '2019-04-15' WHERE SecCode = 3814221 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-05', endDate = '2026-08-05' WHERE SecCode = 3838939 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET Name = 'SHAPE ROBOTICS A/S DKK0.10' WHERE SecCode = 4275853 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4298613 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 DomCntry = 'CHN' WHERE SecCode = 4850228 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5239788 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5691346 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET Name = 'TMC CO LTD KRW100' WHERE SecCode = 6598772 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007ND7', RkdTicker = '1081', RkdSEDOL = 'BXFG27', RkdCUSIP = 'Y1R2GQ10', RkdRIC = '1081.HK', RkdDisplayRIC = '1081.HK', RkdCode = 145292.0, RkdIssueID = 1.0, RkdIssueCode = 185928.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', PrimaryIssueCode = 83596.0, RelType = 4.0, COATypeCode = '' WHERE SecCode = 6900878 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 6948289 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-05', SecMapEndDate = '2026-08-04', endDate = '2026-08-04' WHERE SecCode = 6951858 AND Type_ = 10;
UPDATE data_universe SET DsCmpyCode = 207801, IsMajorSec = 'N' WHERE SecCode = 6960587 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7023607 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVYB5T9' WHERE SecCode = 11019669 AND Type_ = 1;
UPDATE data_universe SET Name = 'AFFINITY BANCSHARES INC COM' WHERE SecCode = 11171838 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US54570M4050', RkdSEDOL = 'BNYHSZ', RkdCUSIP = '54570M40', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11186433 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'STLN', Name = 'STARLING ONCOLOGY INST INC COM' WHERE SecCode = 11207431 AND Type_ = 1;
UPDATE data_universe SET Name = 'STARLING ONCOLOGY INST INC *W EXP 11/15/2026' WHERE SecCode = 11207554 AND Type_ = 1;
UPDATE data_universe SET Name = 'RHELION LIFE SCIENCES CORP COM', PermSecMapEndDate = '2026-08-04', endDate = '2026-08-04' WHERE SecCode = 11208072 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CSRVD', Name = 'SCOTIA METALS CORP COM SHS', PermSecMapEndDate = '2026-08-04', endDate = '2026-08-04' WHERE SecCode = 11211670 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11224426 AND Type_ = 1;
UPDATE data_universe SET Name = 'DERMATA THERAPEUTICS INC *W EXP 08/17/2026' WHERE SecCode = 11228754 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11242380 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MCD' WHERE SecCode = 11244112 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11247303 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BNYGMD1' WHERE SecCode = 11247654 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CVX' WHERE SecCode = 11250819 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA45836R1055', RkdTicker = 'VEIL', RkdSEDOL = 'C084F3', RkdCUSIP = '45836R10', RkdRIC = 'VEIL.CD', RkdDisplayRIC = 'VEIL.CD', DsPrimQtSedol = 'C084F30' WHERE SecCode = 11260025 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'QNME' WHERE SecCode = 11266820 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11270869 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11275372 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11284287 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232930492506.0 WHERE SecCode = 11298892 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BCCQ', QuotePermID = 236811597258.0, InstrPermID = 232933255515.0, OrgPermID = 6000170068.0, PriTrdQuotePermID = 236811597258.0, PriValQuotePermID = 25726995188.0, PriInstrPermID = 232933255515.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-07-07', PermSecMapStartDate = '2026-08-01', startDate = '2026-07-07' WHERE SecCode = 11299987 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OCAC', QuotePermID = 236811326815.0, InstrPermID = 232817132721.0, OrgPermID = 5083167342.0, PriTrdQuotePermID = 236811326815.0, PriValQuotePermID = 25726995659.0, PriInstrPermID = 232817132721.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'VGB', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-06-09', PermSecMapStartDate = '2026-07-30', startDate = '2026-06-09' WHERE SecCode = 11299988 AND Type_ = 1;