UPDATE data_universe SET RkdISIN = 'US04546C3043', RkdSEDOL = 'BN4BBM', RkdCUSIP = '04546C30', DsPrimQtSedol = 'BN4BBM8' WHERE SecCode = 19506 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-08-25' WHERE SecCode = 58740 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 DsCtryQtStatus = 'A' WHERE SecCode = 68049 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BOSCH HOME COMFORT INR10' WHERE SecCode = 68781 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 68818 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 71191 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73265 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'S1814C13' WHERE SecCode = 73535 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73890 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73903 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 74387 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75145 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77804 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78891 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 80275 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US88583P2039', RkdSEDOL = 'BN4BBL', RkdCUSIP = '88583P20', DsPrimQtSedol = 'BN4BBL7' WHERE SecCode = 80544 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81254 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81556 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86753 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87934 AND Type_ = 10;
UPDATE data_universe SET Name = 'LONG INVESTMENT CO HKD0.04' WHERE SecCode = 88099 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG4642G1111', RkdSEDOL = 'BMDLWV', RkdCUSIP = 'G4642G11', DsPrimQtSedol = 'BMDLWV8' WHERE SecCode = 88176 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90560 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 91304 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93380 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93565 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 93867 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 94843 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2022-04-27' WHERE SecCode = 95673 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC' WHERE SecCode = 96898 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-29' WHERE SecCode = 97555 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5097092780.0, OrgTypeCode = 'UNK', DomCntry = NULL, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 98668 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 99006 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q9764A20' WHERE SecCode = 105545 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 115281 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 120588 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 120797 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 124850 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133128 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 133888 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 134615 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 137529 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 140347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140399 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140816 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 141806 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 143382 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 144424 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 145840 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 164113 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 186176 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 340527 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 379152 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'OPB', RkdSEDOL = 'B3B3R4', RkdRIC = 'OPG.F', RkdDisplayRIC = 'OPG.F', RkdExchCode = 'FRA', RkdExchCtry = 'DEU', PriValQuotePermID = 21801448617.0 WHERE SecCode = 390110 AND Type_ = 10;
UPDATE data_universe SET Name = 'KING GEN PCL THB0.5 (LOCAL)' WHERE SecCode = 554134 AND Type_ = 10;
UPDATE data_universe SET Name = 'KING GEN PCL THB0.5 (NVDR)' WHERE SecCode = 554340 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 822496 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 827639 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 881834 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 897188 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1072162 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BMDLWV8' WHERE SecCode = 1191248 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1292949 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDGl', QuotePermID = 21531119071.0, ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1599536 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BMDLWV8' WHERE SecCode = 1659157 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1668753 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1803433 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2014209 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2157369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2273695 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2014-08-11' WHERE SecCode = 2395685 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 = 2518701 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5086803651.0, IncCntry = 'BMU', PermOrgIPODate = '2014-04-25' WHERE SecCode = 2543652 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2593540 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2637937 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2679840 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2682320 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2747568 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2885873 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2940845 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21762568152.0, ExchCode = 'MUN', PermQuoteRetireDate = '2022-06-07', endDate = '2022-06-07' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2970654 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21573317853.0 WHERE SecCode = 2987267 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3020761 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3022449 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3211294 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG223911176', RkdSEDOL = 'BW9KCW', RkdCUSIP = 'G2239111', DsPrimQtSedol = 'BW9KCW0' WHERE SecCode = 3276029 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3317105 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3387565 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3394104 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3403629 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3407483 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3418988 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3434591 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BSGRa', QuotePermID = 21642498305.0, IsPrimaryQuote = 0.0, PermQuoteStatus = 'AC', ExchCode = 'BCO', PermQuoteRetireDate = NULL WHERE SecCode = 3441370 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3444651 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3495771 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 = 3569566 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3569568 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5086803651.0, IncCntry = 'BMU', PermOrgIPODate = '2014-04-25' WHERE SecCode = 3864527 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4204830 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4218669 AND Type_ = 10;
UPDATE data_universe SET Country = 'ISR' WHERE SecCode = 4395426 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4427868 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4429543 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4502482 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4542562 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4558203 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4601622 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4607551 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q496BU10' WHERE SecCode = 4608552 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4634301 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4650985 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'XHC' WHERE SecCode = 4687568 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4746930 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4767820 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4794498 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4811076 AND Type_ = 10;
UPDATE data_universe SET Name = 'SOLIS MINERALS LTD NPV' WHERE SecCode = 4816848 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5086803651.0, IncCntry = 'BMU', PermOrgIPODate = '2014-04-25' WHERE SecCode = 4911167 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5067130 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'XET', DsExchQtStartDate = '2025-10-29' WHERE SecCode = 5082549 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-30' WHERE SecCode = 5144071 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5156823 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-29' WHERE SecCode = 5388817 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '9167.T^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-25', endDate = '2025-12-25' WHERE SecCode = 5493574 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5597176 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5618934 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2024-02-07' WHERE SecCode = 5649894 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5894960 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6100251 AND Type_ = 10;
UPDATE data_universe SET Name = 'GOLDSKY RES CORP SDR EACH REP 1 COM NPV' WHERE SecCode = 6196028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6211060 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6440023 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y973CH10' WHERE SecCode = 6520650 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y076G310' WHERE SecCode = 6522461 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y971KW10' WHERE SecCode = 6522469 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y808TN10' WHERE SecCode = 6533618 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y196DU10' WHERE SecCode = 6538873 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y203HN10' WHERE SecCode = 6541034 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y973CJ10' WHERE SecCode = 6556268 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6567929 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y6S7ZR10' WHERE SecCode = 6587240 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6593989 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y0S7M610' WHERE SecCode = 6601535 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y594ZF10' WHERE SecCode = 6603584 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 1.0 WHERE SecCode = 6608196 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'OPLN', PermIDTicker = 'OPLN', RkdRIC = 'OPLN.K', RkdDisplayRIC = 'OPLN.N' WHERE SecCode = 10925285 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2014-12-12' WHERE SecCode = 11143084 AND Type_ = 1;
UPDATE data_universe SET Name = 'GOLDSKY RES CORP COM SHS' WHERE SecCode = 11152573 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC' WHERE SecCode = 11182284 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11189974 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097087995.0, PriTRBCIndPermID = 4294951922.0, PermOrgIPODate = NULL WHERE SecCode = 11218246 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BVC', Name = 'BITVENTURES LTD SPON ADS' WHERE SecCode = 11221669 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-12-24' WHERE SecCode = 11226494 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US27877D3026', RkdSEDOL = 'BN4BCC', RkdCUSIP = '27877D30', DsPrimQtSedol = 'BN4BCC5' WHERE SecCode = 11248018 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG3016G1111', RkdSEDOL = 'BV7DVT', RkdCUSIP = 'G3016G11', DsPrimQtSedol = 'BV7DVT4' WHERE SecCode = 11252534 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11288811 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097004189.0, PermOrgIPODate = '2025-12-17' WHERE SecCode = 11289565 AND Type_ = 1;
