UPDATE data_universe SET SecMapEndDate = '2025-09-22', PermSecMapEndDate = '2025-09-23', endDate = '2025-09-22' WHERE SecCode = 27115 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 27315 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 27316 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'ANFP.I', QuotePermID = 21475586638.0, ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 33925 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US4418151076', RkdCUSIP = '44181510', RkdRIC = 'HI.N^C03', RkdCode = 48842.0, RkdIssueID = 4.0, RkdIssueCode = 182573.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 34077 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475405461.0, ExchCode = 'MUN' WHERE SecCode = 35324 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951688.0 WHERE SecCode = 36443 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET DsExchMnem = 'NAS' WHERE SecCode = 53360 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-23', SecMapEndDate = '2025-09-22', PermQuoteRetireDate = '2025-09-23', PermSecMapEndDate = '2025-09-23', endDate = '2025-09-22' WHERE SecCode = 55088 AND Type_ = 1;
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 QuotePermID = 21605378798.0, ExchCode = 'STU' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 64798 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 70919 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'PIRA.NS^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-23', SecMapEndDate = '2025-09-22', PermQuoteRetireDate = '2025-09-24', PermSecMapEndDate = '2025-09-23', endDate = '2025-09-22' WHERE SecCode = 71866 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 77263 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5096758315.0, PriInstrPermID = 8589987565.0, PermOrgIPODate = '1997-02-10' WHERE SecCode = 78176 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 78207 AND Type_ = 10;
UPDATE data_universe SET Name = 'JIADING INTERNATIO HKD0.002' WHERE SecCode = 79747 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81224 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-09-25' WHERE SecCode = 86007 AND Type_ = 10;
UPDATE data_universe SET Name = 'NEXG BINA BERHAD NPV' WHERE SecCode = 91350 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SOL' WHERE SecCode = 95997 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 99006 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 99982 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125696 AND Type_ = 10;
UPDATE data_universe SET InfoCode = 387105, DsSecCode = 267772, DsCmpyCode = 209897, DsCtryQtStatus = 'A', DsPrimQtSedol = 'B04LNW1', DsExchMnem = 'NSE', DsSecDelistDate = NULL, DsExchQtStartDate = '2025-01-22', SecMapStartDate = '2025-09-23', SecMapEndDate = '2079-06-06', PermOrgIPODate = '2025-09-23', startDate = '2025-01-22', endDate = NULL WHERE SecCode = 134942 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CONNEQT HEALTH LTD NPV', SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 141616 AND Type_ = 10;
UPDATE data_universe SET Name = 'JIANGXI TUNGSTEN R ''A''CNY1' WHERE SecCode = 285309 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'COSM.SI^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-24', SecMapEndDate = '2025-08-01', PermSecMapEndDate = '2025-09-23', endDate = '2025-08-01' WHERE SecCode = 298972 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdSEDOL = 'BV8H6L' WHERE SecCode = 302757 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 312877 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 379037 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y9003510' WHERE SecCode = 548535 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 586040 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 607528 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SWIRE PROPERTIES L HKD1' WHERE SecCode = 658183 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NEDI NO.2' WHERE SecCode = 784280 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 820748 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'NOVKAN', PermIDTicker = 'NOVKAN', RkdRIC = 'NOVKAN.ST', RkdDisplayRIC = 'NOVKAN.ST', SecMapStartDate = '2011-07-25' WHERE SecCode = 1030653 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 DsCtryQtStatus = 'A' WHERE SecCode = 2372641 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951551.0 WHERE SecCode = 2505948 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 2529065 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951211.0 WHERE SecCode = 2586430 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 2678895 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BSRJ2N2', PermSecMapEndDate = '2025-09-23', endDate = '2025-09-23' WHERE SecCode = 2861758 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 108321.0 WHERE SecCode = 3156046 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951272.0 WHERE SecCode = 3181360 AND Type_ = 10;
UPDATE data_universe SET Name = 'OPTIMUM RE SPAIN S EUR5.20' WHERE SecCode = 3247303 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'NO0013647693', RkdSEDOL = 'BSS92R', RkdCUSIP = 'R2R66P10', DsPrimQtSedol = 'BSS92R5', PermSecMapEndDate = '2025-09-23', endDate = '2025-09-23' WHERE SecCode = 3266303 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ARCHERMIND TECH CO A CNY1', DsExchQtStartDate = '2017-01-20' WHERE SecCode = 3296405 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 3309732 AND Type_ = 10;
UPDATE data_universe SET Name = 'XENORA MINERALS LT NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3320330 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3445941 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'ANXA.L^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-09-24', SecMapEndDate = '2025-09-23', PermQuoteRetireDate = '2025-09-24', endDate = '2025-09-23' WHERE SecCode = 3526140 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 3537017 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3569570 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '2750.TWO^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-09-24', SecMapEndDate = '2025-09-23', PermSecMapEndDate = '2025-09-23', endDate = '2025-09-23' WHERE SecCode = 3571379 AND Type_ = 10;
UPDATE data_universe SET Name = 'ENVISION GREENWISE HKD0.005' WHERE SecCode = 3582243 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3629677 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3881163 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4018127 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4337006 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NPAPER.ST^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-09-24', SecMapEndDate = '2025-09-23', PermQuoteRetireDate = '2025-09-24', endDate = '2025-09-23' WHERE SecCode = 4388410 AND Type_ = 10;
UPDATE data_universe SET Name = 'HOPIUM S.A. EUR0.001' WHERE SecCode = 4451238 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 4491668 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 4590515 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21831570623.0, ExchCode = 'DEU' WHERE SecCode = 4671288 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4697290 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 4751051 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'DMRE.BO', RkdDisplayRIC = 'DMRE.BO' WHERE SecCode = 4796251 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = '544522', QuotePermID = 236796263483.0, ExchCode = 'BSE' WHERE SecCode = 4829189 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'RIGHTB.ST^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-09-24', SecMapEndDate = '2025-09-22', PermQuoteRetireDate = '2025-09-24', endDate = '2025-09-22' WHERE SecCode = 4895650 AND Type_ = 10;
UPDATE data_universe SET Name = 'COOL CAPS INDUSTR INR2(POST SUBD)' WHERE SecCode = 4938159 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5292508 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5292509 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5349583 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2025-09-23' WHERE SecCode = 5474601 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '9164.T^I25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-09-24', SecMapEndDate = '2025-09-22', PermSecMapEndDate = '2025-09-23', endDate = '2025-09-22' WHERE SecCode = 5478193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5493583 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SBAR', RkdRIC = 'SBAR.L', RkdDisplayRIC = 'SBAR.L', RkdIssueStatus = 1.0, RkdExchCode = 'LON' WHERE SecCode = 5616087 AND Type_ = 10;
UPDATE data_universe SET Name = 'AFRICA BITCOIN NPV ORD SHS', IsMajorSec = 'Y', PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5954213 AND Type_ = 10;
UPDATE data_universe SET Name = 'AFRICA BITCOIN NPV PREF A', PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5954214 AND Type_ = 10;
UPDATE data_universe SET Name = 'AFRICA BITCOIN NPV PREF B', PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5954215 AND Type_ = 10;
UPDATE data_universe SET Name = 'AFRICA BITCOIN NPV PREF C', PriTRBCIndPermID = 4294951349.0 WHERE SecCode = 5954216 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TW0007832008', RkdTicker = '7832', RkdSEDOL = 'BNKKPC', RkdCUSIP = 'Y4096B10', RkdRIC = '7832.TWO', RkdDisplayRIC = '7832.TWO', RkdCode = 143037.0, RkdIssueID = 1.0, RkdIssueCode = 182599.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TPO', RkdExchCtry = 'TWN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6276729 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6297438 AND Type_ = 10;
UPDATE data_universe SET Name = 'EVERLAST MINERALS NPV' WHERE SecCode = 6411862 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6441631 AND Type_ = 10;
UPDATE data_universe SET DsExchQtStartDate = '2025-09-10', startDate = '2025-09-03' WHERE SecCode = 6441636 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 1004365393.0 WHERE SecCode = 6465197 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10925121 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 10971989 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'ASE.V', RkdDisplayRIC = 'ASE.V', RkdExchCode = 'CVE' WHERE SecCode = 11023364 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11036554 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11037925 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11204015 AND Type_ = 1;
UPDATE data_universe SET RkdDisplayRIC = 'CMPO.N', DsExchMnem = 'NYS', RkdExchCode = 'NYSE', ExchCode = 'NYS' WHERE SecCode = 11214926 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11223644 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951358.0 WHERE SecCode = 11256986 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5096758343.0, PriInstrPermID = 232845760699.0, PermOrgIPODate = '2025-05-30' WHERE SecCode = 11274795 AND Type_ = 1;
UPDATE data_universe SET RkdDisplayRIC = 'RHLD.N', DsExchMnem = 'NYS', RkdExchCode = 'NYSE', ExchCode = 'NYS' WHERE SecCode = 11275118 AND Type_ = 1;
UPDATE data_universe SET DsCmpyCode = 187535, IsMajorSec = 'N' WHERE SecCode = 11284186 AND Type_ = 1;
UPDATE data_universe SET DsCmpyCode = 46139, IsMajorSec = 'N' WHERE SecCode = 11284197 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11284225 AND Type_ = 1;
UPDATE data_universe SET DsCmpyCode = 37378, IsMajorSec = 'N' WHERE SecCode = 11285148 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US62188E1038', RkdTicker = 'MLCI', RkdSEDOL = 'BTZP07', RkdCUSIP = '62188E10', RkdRIC = 'MLCI.O', RkdDisplayRIC = 'MLCI.OQ', RkdCode = 2185.0, RkdIssueID = 1.0, RkdIssueCode = 2770.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11285346 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US9409231050', RkdTicker = 'WBI', RkdSEDOL = 'BMVFC4', RkdCUSIP = '94092310', RkdRIC = 'WBI', RkdDisplayRIC = 'WBI.N', RkdCode = 143014.0, RkdIssueID = 1.0, RkdIssueCode = 182576.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11285431 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'POW.PR.H', QuotePermID = 236796143606.0, InstrPermID = 232901055829.0, OrgPermID = 4295860768.0, PriValQuotePermID = 236796143606.0, PriInstrPermID = 8590927515.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'TOR', QuoteClass = 'PREFERRED', InstrClass = 'PREFERRED', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951339.0, PermOrgIPODate = '1985-01-01', PermSecMapStartDate = '2025-09-19', startDate = '2025-09-19' WHERE SecCode = 11285548 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'HCMA', ModelCntry = 'US', QuotePermID = 236796185784.0, InstrPermID = 232888786653.0, OrgPermID = 5095611959.0, PriTrdQuotePermID = 236796185784.0, PriValQuotePermID = 25727060931.0, PriInstrPermID = 232888786653.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 = '2025-08-01', PermSecMapStartDate = '2025-09-20', startDate = '2025-08-01' WHERE SecCode = 11285633 AND Type_ = 1;