UPDATE data_universe SET RkdTicker = 'BNY', RkdRIC = 'BNY', RkdDisplayRIC = 'BNY.N' WHERE SecCode = 8265 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'CEMENTOS.SN^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-20', SecMapEndDate = '2026-05-19', PermSecMapEndDate = '2026-05-20', endDate = '2026-05-19' WHERE SecCode = 27786 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 31046 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1992-08-28' WHERE SecCode = 31059 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 DsCtryQtStatus = 'A' WHERE SecCode = 69596 AND Type_ = 10;
UPDATE data_universe SET Name = 'BOHAE BREWERY CO KRW2500' WHERE SecCode = 70756 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 70984 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 76424 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951173.0 WHERE SecCode = 77892 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ENEX CO KRW2500' WHERE SecCode = 78828 AND Type_ = 10;
UPDATE data_universe SET Name = 'FAR EAST FAME LINE THB10 (LOCAL)' WHERE SecCode = 79296 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79462 AND Type_ = 10;
UPDATE data_universe SET Name = 'FAR EAST FAME LINE THB10(NVDR)' WHERE SecCode = 80522 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81810 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 81841 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-19', endDate = '2026-05-19' WHERE SecCode = 83612 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KEC HOLDINGS CO KRW2500' WHERE SecCode = 85834 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 86949 AND Type_ = 10;
UPDATE data_universe SET Name = 'ONTIDE CORP KRW1000' WHERE SecCode = 87109 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'SGP' WHERE SecCode = 88334 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88882 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89532 AND Type_ = 10;
UPDATE data_universe SET Name = 'MDS RETL ING TBK LKD SHS(IDR5000 & IDR350 &' WHERE SecCode = 91760 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CASO.BO', RkdDisplayRIC = 'CASO.BO' WHERE SecCode = 92313 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 92990 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95047 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95093 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95610 AND Type_ = 10;
UPDATE data_universe SET PermSecMapStartDate = '2004-04-01' WHERE SecCode = 98629 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'TLITn.MI^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-21', SecMapEndDate = '2026-05-19', endDate = '2026-05-19' WHERE SecCode = 104433 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 111560 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 113243 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KUK-IL PAPER MANUF KRW1000' WHERE SecCode = 116295 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137316 AND Type_ = 10;
UPDATE data_universe SET Name = 'VISA CHROME LTD INR10' WHERE SecCode = 143733 AND Type_ = 10;
UPDATE data_universe SET Name = 'PSG CORPORATION PC THB2 (LOCAL)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 165534 AND Type_ = 10;
UPDATE data_universe SET Name = 'PSG CORPORATION PC THB2 (NVDR)' WHERE SecCode = 165862 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KEC CORP KRW2500' WHERE SecCode = 169161 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 255969 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 387440 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 529633 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 529635 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'AIKEb.TE^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-05-21', SecMapEndDate = '2026-05-20', PermSecMapEndDate = '2024-11-11', endDate = '2024-11-11' WHERE SecCode = 577384 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 883105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 887451 AND Type_ = 10;
UPDATE data_universe SET Name = 'CENTUPLE GLOBAL LT INR10' WHERE SecCode = 1208371 AND Type_ = 10;
UPDATE data_universe SET Name = 'SIGMA DEFENCE SA PLN0.10' WHERE SecCode = 1371891 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1444255 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CU MEDICAL SYSTEMS KRW2500' WHERE SecCode = 1483929 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21492779438.0, ExchCode = 'BUR' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1722200 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2003322 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 2082530 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 2568211 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2580242 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2580244 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2909912 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2997005 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3002458 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21588488685.0, PermQuoteStatus = 'DC', ExchCode = 'BCO', PermQuoteRetireDate = '2025-07-21', PermSecMapEndDate = '2025-02-03' WHERE SecCode = 3177550 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3230624 AND Type_ = 10;
UPDATE data_universe SET InfoCode = 293579, DsSecCode = 216650, IsMajorSec = 'Y', DsCtryQtStatus = 'A', DsPrimQtSedol = 'BNW1MC7', DsSecDelistDate = NULL, DsExchQtStartDate = '2016-11-08', SecMapStartDate = '2016-11-08', SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 3263264 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3268522 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667482861.0, ExchCode = 'QTX' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3431044 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NGIL', QuotePermID = 25727169919.0, ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'AAV', PermQuoteStatus = 'AC', ExchCode = 'UPC', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-20', PermSecMapEndDate = NULL, startDate = '2018-06-25', endDate = NULL WHERE SecCode = 3531558 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3554989 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'AV2n.DE^E26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', endDate = '2026-05-20' WHERE SecCode = 3840551 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-05-19' WHERE SecCode = 3945211 AND Type_ = 10;
UPDATE data_universe SET Name = 'INNOTENA INC KRW500' WHERE SecCode = 4001156 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951490.0 WHERE SecCode = 4365043 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951950.0 WHERE SecCode = 4386307 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4511450 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 4914438 AND Type_ = 10;
UPDATE data_universe SET Name = 'NOMAD COMPUTE PLC ORD GBP0.01' WHERE SecCode = 5067274 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'HKG' WHERE SecCode = 5085769 AND Type_ = 10;
UPDATE data_universe SET Name = 'BELLOCK INC KRW200' WHERE SecCode = 5096919 AND Type_ = 10;
UPDATE data_universe SET Name = 'FINGER STORY CO. KRW500' WHERE SecCode = 5268198 AND Type_ = 10;
UPDATE data_universe SET Name = 'PPI PUB PROP INV A NPV', Country = 'SWE' WHERE SecCode = 5738497 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5740525 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951411.0 WHERE SecCode = 5936371 AND Type_ = 10;
UPDATE data_universe SET ExchCode = 'TAI' WHERE SecCode = 6012718 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6075866 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-03-26' WHERE SecCode = 6139865 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GENO', QuotePermID = 236804823846.0, IsPrimaryQuote = 1.0, ExchCode = 'OSL' WHERE SecCode = 6741012 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-04-02', startDate = '2026-03-19' WHERE SecCode = 6756395 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2026-04-02', startDate = '2026-03-19' WHERE SecCode = 6756396 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, 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-05-21', SecMapEndDate = '2026-05-20', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2026-04-29', endDate = '2026-05-20' WHERE SecCode = 6813826 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SLVR.TO', RkdDisplayRIC = 'SLVR.TO', RkdExchCode = 'TSE' WHERE SecCode = 10983015 AND Type_ = 1;
UPDATE data_universe SET Name = 'INTERNATIONAL PROSPECT COM' WHERE SecCode = 11006195 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-05-19', endDate = '2026-05-15' WHERE SecCode = 11139994 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BWW4HP7' WHERE SecCode = 11142544 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BVSVSV8' WHERE SecCode = 11175825 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BWW4GN8' WHERE SecCode = 11176237 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11185275 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BWW4HN5' WHERE SecCode = 11193348 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 11198134 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA1850536006', RkdSEDOL = 'BT3HH7', RkdCUSIP = '18505360', DsPrimQtSedol = 'BT3HH76' WHERE SecCode = 11199053 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951555.0 WHERE SecCode = 11200202 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BWW4HM4' WHERE SecCode = 11207780 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'PRTCY', RkdRIC = 'PRTCY.PK', RkdDisplayRIC = 'PRTCY.PK', DsTypeCode = 'EQ', RkdExchCode = 'OTC' WHERE SecCode = 11214758 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'ABXX.TO', RkdDisplayRIC = 'ABXX.TO', RkdExchCode = 'TSE' WHERE SecCode = 11216466 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11218121 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 236793806642.0, PermQuoteStatus = 'DC', ExchCode = 'GTC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20', endDate = '2026-05-20' WHERE SecCode = 11222037 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'QTEX', Name = 'QTREX QUANTUM LTD ORD' WHERE SecCode = 11222088 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2021-05-26' WHERE SecCode = 11224879 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-20', PermSecMapEndDate = '2026-05-20' WHERE SecCode = 11226283 AND Type_ = 1;
UPDATE data_universe SET Name = 'QTREX QUANTUM LTD *W EXP 07/16/2026' WHERE SecCode = 11227222 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951971.0 WHERE SecCode = 11232859 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'SOPAQ', RkdRIC = 'SOPAQ.PK', RkdDisplayRIC = 'SOPAQ.PK', RkdExchCode = 'OTC' WHERE SecCode = 11233738 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11237323 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US68237Q4010', RkdSEDOL = 'BT3HH9', RkdCUSIP = '68237Q40', DsPrimQtSedol = 'BT3HH98' WHERE SecCode = 11238670 AND Type_ = 1;
UPDATE data_universe SET Name = 'BIG TREE CLOUD HLDGS LTD *W EXP 05/31/2029' WHERE SecCode = 11248861 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11260395 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG4290F1265', RkdSEDOL = 'BT3HH8', RkdCUSIP = 'G4290F12', DsPrimQtSedol = 'BT3HH87' WHERE SecCode = 11262020 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11264491 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232902764891.0 WHERE SecCode = 11291637 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11293243 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11293741 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293935 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232925935066.0 WHERE SecCode = 11295153 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 11295354 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TMPTF', QuotePermID = 236806768751.0, InstrPermID = 232900440706.0, OrgPermID = 5096943962.0, PriValQuotePermID = 236797411344.0, PriInstrPermID = 232900440706.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'PNK', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951294.0, PermOrgIPODate = '2025-10-15', PermSecMapStartDate = '2026-05-07' WHERE SecCode = 11295604 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 11295987 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'AMAN', QuotePermID = 236806021336.0, InstrPermID = 232931566334.0, OrgPermID = 6000106214.0, PriTrdQuotePermID = 236806021336.0, PriValQuotePermID = 25727025608.0, PriInstrPermID = 232931566334.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NAS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-19', PermSecMapStartDate = '2026-05-19' WHERE SecCode = 11296167 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VECA.U', QuotePermID = 236796891242.0, InstrPermID = 232903530782.0, OrgPermID = 5096911354.0, PriTrdQuotePermID = 236796891242.0, PriValQuotePermID = 25727058471.0, PriInstrPermID = 232901226787.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'UNT', InstrClass = 'UNT', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-06', PermSecMapStartDate = '2025-10-20', PermSecMapEndDate = '2026-05-05', startDate = '2025-10-20', endDate = '2026-05-05' WHERE SecCode = 11296172 AND Type_ = 1;
