UPDATE data_universe SET RkdTicker = 'CVSA', PermIDTicker = 'CVSA', RkdRIC = 'CVSA.K', RkdDisplayRIC = 'CVSA.N', Name = 'COVISTA INC COM' WHERE SecCode = 19632 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 30902 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 35239 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21532854931.0, ExchCode = 'AQX' WHERE SecCode = 45820 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 SecMapEndDate = '2026-02-23' WHERE SecCode = 49579 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'STGG.F', RkdDisplayRIC = 'STGG.F', RkdExchCode = 'FRA' WHERE SecCode = 59737 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21589872687.0, ExchCode = 'STU', PermQuoteRetireDate = '2018-01-17' WHERE SecCode = 60120 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BRE2.ST^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-02-24', SecMapEndDate = '2026-02-23', PermQuoteRetireDate = '2026-02-24', endDate = '2026-02-23' WHERE SecCode = 65268 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'KSSM.BO', RkdDisplayRIC = 'KSSM.BO' WHERE SecCode = 70136 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 70634 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74053 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 74992 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 74993 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79190 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-23' WHERE SecCode = 80329 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG4515X1189', RkdSEDOL = 'BS1KZM', RkdCUSIP = 'G4515X11', DsPrimQtSedol = 'BS1KZM1' WHERE SecCode = 82712 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-02-20', PermSecMapEndDate = '2026-02-23', endDate = '2026-02-20' WHERE SecCode = 86645 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 88997 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 90572 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 90988 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 91451 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA4987223050', RkdSEDOL = 'BW2JKM', RkdCUSIP = '49872230', DsPrimQtSedol = 'BW2JKM0' WHERE SecCode = 95869 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 95929 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 100020 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21616157076.0, ExchCode = 'MCX' WHERE SecCode = 102656 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'TCC', RkdRIC = 'TCCC.NS', RkdDisplayRIC = 'TCCC.NS', RkdExchCode = 'NSE' WHERE SecCode = 136492 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 140254 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'GAS', QuotePermID = 21475431308.0, ExchCode = 'OSL', PermQuoteRetireDate = '2008-07-30' WHERE SecCode = 141248 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'LINGBAO GOLD GP CO CNY0.2 H' WHERE SecCode = 142960 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 146722 AND Type_ = 10;
UPDATE data_universe SET Name = 'ENERGY SERVICES OF AMER CORP COM' WHERE SecCode = 168905 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'LNFI.ST^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-02-24', SecMapEndDate = '2026-02-23', PermQuoteRetireDate = '2026-02-24', endDate = '2026-02-23' WHERE SecCode = 185120 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 296637 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55834800221.0, ExchCode = 'HKG', PermQuoteRetireDate = '2018-04-24', endDate = '2018-04-16' WHERE SecCode = 345190 AND Type_ = 10;
UPDATE data_universe SET Name = 'PROSPECT PREDICTION MARKETS COM' WHERE SecCode = 355079 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 367108 AND Type_ = 1;
UPDATE data_universe SET Name = 'HALO MINERALS PLC ORD GBP0.000001' WHERE SecCode = 373512 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 397637 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 559885 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-02-13', PermSecMapEndDate = '2026-02-23', endDate = '2026-02-13' WHERE SecCode = 586452 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BVMBRL7' WHERE SecCode = 1171484 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLIT', QuotePermID = 21482228292.0, ExchCode = 'STO', PermQuoteRetireDate = '2014-04-29' WHERE SecCode = 1456636 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 ISIN = NULL WHERE SecCode = 1546646 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1565080 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1623752 AND Type_ = 10;
UPDATE data_universe SET Name = 'JRC GROUP SA PLN1.00' WHERE SecCode = 2072759 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2671255 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2862779 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2894539 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951348.0 WHERE SecCode = 2902051 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 2912972 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'AARNAV', RkdRIC = 'AARA.NS', RkdDisplayRIC = 'AARA.NS', RkdExchCode = 'NSE' WHERE SecCode = 3065854 AND Type_ = 10;
UPDATE data_universe SET Name = 'RNT-X CO LTD KRW500.00' WHERE SecCode = 3196334 AND Type_ = 10;
UPDATE data_universe SET Name = 'CTP GROUP CORPORAT VND10000' WHERE SecCode = 3215562 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-03-23' WHERE SecCode = 3247113 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247161 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3405555 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG429011193', RkdSEDOL = 'BTTPQL', RkdCUSIP = 'G4290111', DsPrimQtSedol = 'BTTPQL1' WHERE SecCode = 3620666 AND Type_ = 10;
UPDATE data_universe SET Name = 'SUN KONG HLDGS LTD HKD0.1' WHERE SecCode = 3719722 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '341310.KN^B26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-02-24', SecMapEndDate = '2026-02-23', PermSecMapEndDate = '2026-02-23', endDate = '2026-02-23' WHERE SecCode = 4054101 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4057396 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4357423 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-02-20', PermSecMapEndDate = '2026-02-23', endDate = '2026-02-20' WHERE SecCode = 4415699 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21818254739.0, ExchCode = 'BCO', PermQuoteRetireDate = '2026-01-13' WHERE SecCode = 4617741 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236785348309.0, ExchCode = 'QTX' WHERE SecCode = 5161349 AND Type_ = 10;
UPDATE data_universe SET Name = 'PARATAXIS ETHEREUM KRW100' WHERE SecCode = 5572144 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2025-03-11' WHERE SecCode = 6163808 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BTXVG712', RkdTicker = 'DGQ', RkdSEDOL = 'BTXVG7', RkdCUSIP = 'G2706P10', RkdRIC = 'DGQ.ASE', RkdDisplayRIC = 'DGQ.ASE', RkdCode = 144343.0, RkdIssueID = 1.0, RkdIssueCode = 184371.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'AQS', RkdExchCtry = 'GBR', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6580843 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DE000A40Y557', RkdTicker = '6U0', RkdSEDOL = 'BVV8TD', RkdCUSIP = 'D8T73K10', RkdRIC = '6U0.HA', RkdDisplayRIC = '6U0.HA', RkdCode = 144345.0, RkdIssueID = 1.0, RkdIssueCode = 184373.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6590752 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6612688 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-02-20', PermSecMapEndDate = '2026-02-23', endDate = '2026-02-20' WHERE SecCode = 6626801 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'MYL03067O005', RkdTicker = 'AAI', RkdSEDOL = 'BTXPJC', RkdCUSIP = 'Y042C310', RkdRIC = 'ASSC.KL', RkdDisplayRIC = 'ASSC.KL', RkdCode = 144342.0, RkdIssueID = 1.0, RkdIssueCode = 184370.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'KUL', RkdExchCtry = 'MYS', PrimaryIssueType = 'EQU', COATypeCode = '', PriTRBCIndPermID = 4294951875.0 WHERE SecCode = 6635166 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951602.0 WHERE SecCode = 6674464 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'RYZ', PermIDTicker = 'RYZ', RkdRIC = 'RYZ', RkdDisplayRIC = 'RYZ.N' WHERE SecCode = 10960487 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11037861 AND Type_ = 1;
UPDATE data_universe SET Name = 'CHIRON REAL ESTATE INC COM NEW' WHERE SecCode = 11037925 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11131355 AND Type_ = 1;
UPDATE data_universe SET Name = 'ENLIVEX LTD COM' WHERE SecCode = 11138070 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'M8216Q30' WHERE SecCode = 11139865 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 11143514 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11165564 AND Type_ = 1;
UPDATE data_universe SET Name = 'CHIRON REAL ESTATE INC 7.50% CUM PFD A' WHERE SecCode = 11176836 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11195341 AND Type_ = 1;
UPDATE data_universe SET Name = 'DNA X INC COM' WHERE SecCode = 11196781 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11197810 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 11212834 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'DK', DomCntry = 'DNK' WHERE SecCode = 11214218 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 11214756 AND Type_ = 1;
UPDATE data_universe SET Name = 'ACL CONSTR LTD COM' WHERE SecCode = 11224879 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'LVROF', PermIDTicker = NULL, RkdRIC = 'LVROF.PK', RkdDisplayRIC = 'LVROF.PK', RkdExchCode = 'OTC', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-02-24', endDate = '2026-02-24' WHERE SecCode = 11231624 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11236688 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU', PriTrdQuotePermID = NULL, PriValQuotePermID = 236803248381.0 WHERE SecCode = 11240505 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 43200.0 WHERE SecCode = 11241711 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA92339J1075', RkdTicker = 'V', PermIDTicker = 'V', RkdSEDOL = 'BR1FDY', RkdCUSIP = '92339J10', RkdRIC = 'V.V', RkdDisplayRIC = 'V.V', DsPrimQtSedol = 'BR1FDY7' WHERE SecCode = 11247421 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US45840Y5006', RkdSEDOL = 'BR1F8R', RkdCUSIP = '45840Y50', DsPrimQtSedol = 'BR1F8R5' WHERE SecCode = 11252479 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG7523E1135', RkdSEDOL = 'BR1F8G', RkdCUSIP = 'G7523E11', DsPrimQtSedol = 'BR1F8G4' WHERE SecCode = 11286854 AND Type_ = 1;
UPDATE data_universe SET Name = 'CHIRON REAL ESTATE INC 8.0 PF CUM SR B' WHERE SecCode = 11288131 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA09511B1085', RkdTicker = 'BGAU', RkdSEDOL = 'BVYDH8', RkdCUSIP = '09511B10', RkdRIC = 'BGAU.TO', RkdDisplayRIC = 'BGAU.TO', RkdCode = 144341.0, RkdIssueID = 1.0, RkdIssueCode = 184369.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11291357 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'Y' WHERE SecCode = 11292229 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11292243 AND Type_ = 1;
