UPDATE data_universe SET RkdRIC = 'SPT.L^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-10-17', SecMapEndDate = '2025-10-16', PermQuoteRetireDate = '2025-10-17', endDate = '2025-10-16' WHERE SecCode = 6779 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5096908316.0, PriInstrPermID = 8590026615.0, DomCntry = NULL, PermOrgIPODate = '1998-12-26', startDate = '1998-12-26' WHERE SecCode = 9467 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-16', SecMapEndDate = '2025-10-15', PermQuoteRetireDate = '2025-10-16', PermSecMapEndDate = '2025-10-16', endDate = '2025-10-15' WHERE SecCode = 30613 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 36418 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 QuotePermID = 55836518194.0, ExchCode = 'FRA' WHERE SecCode = 46439 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DYHd', QuotePermID = 236781095764.0, ExchCode = 'AQX' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951374.0 WHERE SecCode = 51413 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836324566.0, ExchCode = 'BER', PermQuoteRetireDate = '2018-01-16' WHERE SecCode = 60120 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 QuotePermID = 21605378798.0, ExchCode = 'STU' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHINA CHANGBAISHAN HKD0.01' WHERE SecCode = 67475 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BMG4088X2064', RkdSEDOL = 'BR4WBJ', RkdCUSIP = 'G4088X20', DsPrimQtSedol = 'BR4WBJ6' WHERE SecCode = 93588 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 21888753828.0 WHERE SecCode = 95673 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 105084 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 115440 AND Type_ = 10;
UPDATE data_universe SET Name = 'AGP INVT MGMT LTD NPV' WHERE SecCode = 115441 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 125550 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 126493 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951393.0 WHERE SecCode = 132659 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU000000CZN9', RkdTicker = 'CZN', PermIDTicker = 'CZN', RkdSEDOL = 'B07V52', RkdCUSIP = 'Q2874S25', RkdRIC = 'CZN.AX', RkdDisplayRIC = 'CZN.AX', DsPrimQtSedol = 'B07V522', RkdCode = 46853.0, RkdIssueID = 1.0, RkdIssueCode = 61365.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = 'IND', SecMapStartDate = '2025-10-16', SecMapEndDate = '2079-06-06', PermSecMapStartDate = '2025-10-16', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 133785 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 135123 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 140586 AND Type_ = 10;
UPDATE data_universe SET Name = 'WELCURE DRUG & PH INR1 (POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 142568 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q9173526' WHERE SecCode = 200828 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'IVXG.H^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-10-17', endDate = '2025-10-17' WHERE SecCode = 294573 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 320069 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 333042 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA75974M2040', RkdSEDOL = 'BVPWD0', RkdCUSIP = '75974M20', DsPrimQtSedol = 'BVPWD08' WHERE SecCode = 361480 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'ITD CORPORATION VND10000' WHERE SecCode = 586494 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951787.0 WHERE SecCode = 683653 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 760049 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 831995 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLITs', QuotePermID = 21482394593.0, ExchCode = 'BUR', PermQuoteRetireDate = '2014-04-11' WHERE SecCode = 1456636 AND Type_ = 10;
UPDATE data_universe SET Name = 'NORDIC FINAN ASA NOK1.75', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 1458933 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951895.0 WHERE SecCode = 1597257 AND Type_ = 10;
UPDATE data_universe SET Name = 'BTCS SA PLN0.50' WHERE SecCode = 2495862 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6095.T^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-17', SecMapEndDate = '2025-10-16', PermSecMapEndDate = '2025-10-16', endDate = '2025-10-16' WHERE SecCode = 2566806 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-10-16' WHERE SecCode = 2601968 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE671K01027', RkdSEDOL = 'BS81L2', RkdCUSIP = 'Y8303M10', DsPrimQtSedol = 'BS81L29', PermSecMapEndDate = '2025-10-16', endDate = '2025-10-16' WHERE SecCode = 2963532 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE060D01028', RkdSEDOL = 'BS81KZ', DsPrimQtSedol = 'BS81KZ5', PermSecMapEndDate = '2025-10-16', endDate = '2025-10-16' WHERE SecCode = 3007957 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0026598583', RkdSEDOL = 'BRBFS7', RkdCUSIP = 'W989B021', DsPrimQtSedol = 'BRBFS75', PermSecMapEndDate = '2025-10-16', endDate = '2025-10-16' WHERE SecCode = 3084587 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DANYANG SYNGEN INT ''A''CNY1' WHERE SecCode = 3213250 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3232935 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3272839 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 3283980 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3339576 AND Type_ = 10;
UPDATE data_universe SET Country = 'FRA' WHERE SecCode = 3402732 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 = 'TSF INVESTMENTS LT INR5' WHERE SecCode = 3441472 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'AURIGROW', PermIDTicker = 'AURIGROW', RkdRIC = 'AURR.NS', RkdDisplayRIC = 'AURR.NS' WHERE SecCode = 3495863 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE00YB01025', RkdSEDOL = 'BS81L4', DsPrimQtSedol = 'BS81L41' WHERE SecCode = 3883663 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 4029417 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 4038316 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CZN', DsPrimQtSedol = 'B07V522' WHERE SecCode = 4489164 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-16' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'RHR', QuotePermID = 236797408859.0, PermQuoteStatus = 'AC', ExchCode = 'LSE', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-14', startDate = '2021-03-12', endDate = NULL WHERE SecCode = 4531654 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE645S01024', RkdSEDOL = 'BW5T2L', RkdCUSIP = 'Y7S23U11', PermSecMapEndDate = '2025-10-16', endDate = '2025-10-16' WHERE SecCode = 4667075 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236789414736.0, ExchCode = 'LAS' WHERE SecCode = 4671288 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4693638 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4767831 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21860598463.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-10-09' WHERE SecCode = 4800907 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 136857.0 WHERE SecCode = 5430796 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951330.0 WHERE SecCode = 5656159 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 6041236 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6128250 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6159033 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6434975 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, PermIDTicker = 'CZN', RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, DsPrimQtSedol = 'B07V522', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, SecMapEndDate = '2025-10-15', PermSecMapEndDate = '2025-10-16', endDate = '2025-10-15' WHERE SecCode = 6448816 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CH1484953687', RkdTicker = 'SMG', RkdSEDOL = 'BMYF0H', RkdCUSIP = 'H7884J11', RkdRIC = 'SMGC.S', RkdDisplayRIC = 'SMGC.S', RkdCode = 143227.0, RkdIssueID = 1.0, RkdIssueCode = 182847.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SWF', RkdExchCtry = 'CHE', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6460614 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '544571', QuotePermID = 236797026581.0, IsPrimaryQuote = 0.0, ExchCode = 'BSE' WHERE SecCode = 6495234 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951811.0 WHERE SecCode = 6503361 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-10-16', endDate = '2025-10-16' WHERE SecCode = 11019872 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-10-16' WHERE SecCode = 11074055 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 0.6667 WHERE SecCode = 11197385 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA3001447067', RkdSEDOL = 'BVPWCX', RkdCUSIP = '30014470', DsPrimQtSedol = 'BVPWCX4' WHERE SecCode = 11200982 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-10-16', SecMapEndDate = '2025-10-15', endDate = '2025-10-15' WHERE SecCode = 11204035 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11226563 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2025-10-14', PermSecMapEndDate = '2025-10-16', endDate = '2025-10-14' WHERE SecCode = 11232126 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US80516T4022', RkdTicker = 'SVRE', RkdSEDOL = 'BTZPSQ', RkdCUSIP = '80516T40', RkdRIC = 'SVRE.O', RkdDisplayRIC = 'SVRE.OQ', RkdCode = 143225.0, RkdIssueID = 1.0, RkdIssueCode = 182845.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'ADR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', ShPerListing = 3600.0, PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11241711 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA00844N2086', RkdSEDOL = 'BVPWCW', RkdCUSIP = '00844N20', DsPrimQtSedol = 'BVPWCW3' WHERE SecCode = 11248311 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'FORL.PK', RkdDisplayRIC = 'FORL.PK', RkdExchCode = 'OTC' WHERE SecCode = 11252798 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285177 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285209 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285245 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11285376 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11285378 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG0R78B1228', RkdTicker = 'BCSS.U', RkdSEDOL = 'BW5YWC', RkdCUSIP = 'G0R78B12', RkdRIC = 'BCSS_u.K', RkdDisplayRIC = 'BCSS_u.N', RkdCode = 142930.0, RkdIssueID = 1.0, RkdIssueCode = 182456.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11286100 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ATMYF', QuotePermID = 236796521509.0, InstrPermID = 21854318361.0, OrgPermID = 5081468569.0, PriValQuotePermID = 21854318360.0, PriInstrPermID = 21854318361.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'GTC', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951899.0, SecMapStartDate = '2025-03-26', PermOrgIPODate = '2021-11-08', PermSecMapStartDate = '2025-10-01' WHERE SecCode = 11286113 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11286287 AND Type_ = 1;
