UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 8918 AND Type_ = 1;
UPDATE data_universe SET RkdIssueOrder = 2.0 WHERE SecCode = 17729 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 29246 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951901.0 WHERE SecCode = 30634 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 31300 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'VENDA.OL^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-28', SecMapEndDate = '2025-10-28', PermQuoteRetireDate = '2025-10-28', PermSecMapEndDate = '2025-10-28', endDate = '2025-10-28' WHERE SecCode = 46631 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DYHd', QuotePermID = 236781095764.0, ExchCode = 'AQX' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = NULL WHERE SecCode = 57851 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 67008 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q7747619' WHERE SecCode = 68875 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US29405E5050', RkdSEDOL = 'BPYV2R', RkdCUSIP = '29405E50', DsPrimQtSedol = 'BPYV2R4' WHERE SecCode = 70929 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 71219 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 72920 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 72964 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000428302', RkdTicker = 'CYMDE', PermIDTicker = 'CYMDE', RkdSEDOL = 'BV3P4M', RkdRIC = 'CYMDE.AX', RkdDisplayRIC = 'CYMDE.AX', DsPrimQtSedol = 'BV3P4M8', SecMapEndDate = '2025-10-26', PermSecMapEndDate = '2019-06-25', endDate = '2019-06-25' WHERE SecCode = 73540 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 78476 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 78989 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951386.0 WHERE SecCode = 84631 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 87703 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 90236 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 91065 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95166 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95869 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 111504 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951822.0 WHERE SecCode = 114551 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE953E01022', RkdSEDOL = 'BV5CVM', RkdCUSIP = 'Y4747N12', DsPrimQtSedol = 'BV5CVM6', PermSecMapEndDate = '2025-10-27', endDate = '2025-10-27' WHERE SecCode = 115611 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 117052 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'NSX.AX^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-10-27', SecMapEndDate = '2025-10-15', PermQuoteRetireDate = '2025-10-27', PermSecMapEndDate = '2025-10-27', endDate = '2025-10-15' WHERE SecCode = 126884 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 137418 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'PFC.L^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-28', SecMapEndDate = '2025-05-01', PermQuoteRetireDate = '2025-10-28', PermSecMapEndDate = '2025-10-28', endDate = '2025-05-01' WHERE SecCode = 140947 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-24', PermSecMapEndDate = '2025-10-27', endDate = '2025-10-24' WHERE SecCode = 147135 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-11-26' WHERE SecCode = 212167 AND Type_ = 10;
UPDATE data_universe SET Name = 'DART MINING NL NPV DFD 28/10/25(EX-SPLIT)' WHERE SecCode = 285238 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 340322 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'DAECHANG SOLUTION KRW500' WHERE SecCode = 346396 AND Type_ = 10;
UPDATE data_universe SET Name = 'JEEN AI TECH ILS1.5' WHERE SecCode = 358625 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 376433 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BLIN.BO', DsCtryQtStatus = 'S', RkdIssueStatus = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', DsSecDelistDate = NULL, SecMapEndDate = '2079-06-06', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2025-10-27', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 385733 AND Type_ = 10;
UPDATE data_universe SET Name = 'ALPHA SEVEN GROUP VND10000' WHERE SecCode = 570966 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'VNSTEEL N' WHERE SecCode = 632193 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951197.0 WHERE SecCode = 821957 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 836830 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951713.0 WHERE SecCode = 845505 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'VNSTEEL T', DsExchQtStartDate = '2011-11-03' WHERE SecCode = 1457734 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'GUOSHENG SECURITIE ''A''CNY1' WHERE SecCode = 1552065 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1622185 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1675617 AND Type_ = 10;
UPDATE data_universe SET OrgTypeCode = 'COM' WHERE SecCode = 2571155 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG644671227', RkdSEDOL = 'BW5S92', RkdCUSIP = 'G6446712', DsPrimQtSedol = 'BW5S927', DsExchQtStartDate = '2014-09-19' WHERE SecCode = 2633144 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2813062 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2862772 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VEND', PermIDTicker = 'VEND', RkdRIC = 'VEND.OL', RkdDisplayRIC = 'VEND.OL' WHERE SecCode = 2907935 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2909244 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'RESURS.ST^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-28', SecMapEndDate = '2025-10-27', PermQuoteRetireDate = '2025-10-28', PermSecMapEndDate = '2025-10-28', endDate = '2025-10-27' WHERE SecCode = 3155966 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 21615482030.0 WHERE SecCode = 3201369 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21615835543.0, ExchCode = 'FRA', PermQuoteRetireDate = '2022-09-27', endDate = '2022-09-27' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3327782 AND Type_ = 10;
UPDATE data_universe SET PriInstrPermID = 21615482030.0 WHERE SecCode = 3365567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3396940 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3409197 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'AYOJ.J^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-28', SecMapEndDate = '2025-10-21', PermQuoteRetireDate = '2025-10-28', PermSecMapEndDate = '2025-10-28', endDate = '2025-10-21' WHERE SecCode = 3409784 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CYMDE', DsPrimQtSedol = 'BV3P4M8' WHERE SecCode = 3519895 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21922259627.0, ExchCode = 'EQD' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-24', PermSecMapEndDate = '2025-10-26', endDate = '2025-10-24' WHERE SecCode = 3845929 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209283.0, ExchCode = 'CHA' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4225978 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'SPGS', PermIDTicker = 'SPGS', RkdRIC = 'SPGS.TA', RkdDisplayRIC = 'SPGS.TA' WHERE SecCode = 4272418 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BWE.AX^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-27', SecMapEndDate = '2025-08-29', PermQuoteRetireDate = '2025-10-27', PermSecMapEndDate = '2025-10-27', endDate = '2025-08-29' WHERE SecCode = 4317547 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4349879 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951932.0 WHERE SecCode = 4395420 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-24', PermSecMapEndDate = '2025-10-26', endDate = '2025-10-24' WHERE SecCode = 4415705 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-24', PermSecMapEndDate = '2025-10-26', endDate = '2025-10-24' WHERE SecCode = 4502481 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-27' WHERE SecCode = 4511509 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-24', PermSecMapEndDate = '2025-10-26', endDate = '2025-10-24' WHERE SecCode = 4574924 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'VQLA.VI^J25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-10-28', SecMapEndDate = '2025-10-24', PermQuoteRetireDate = '2025-10-28', PermSecMapEndDate = '2025-10-28', endDate = '2025-10-24' WHERE SecCode = 4655472 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4871152 AND Type_ = 10;
UPDATE data_universe SET Name = 'KLEVO REWARDS LTD NPV', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4871191 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'ID1000178700', RkdTicker = 'MMIX', RkdSEDOL = 'BPCM7T', RkdCUSIP = 'Y712FZ10', RkdRIC = 'MMIX.JK', RkdDisplayRIC = 'MMIX.JK', RkdCode = 135013.0, RkdIssueID = 1.0, RkdIssueCode = 171655.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'JAK', RkdExchCtry = 'IDN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 5264846 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5286263 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-10-01', PermOrgIPODate = NULL, PermSecMapEndDate = '2025-10-26', endDate = '2025-10-01' WHERE SecCode = 5493582 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951856.0 WHERE SecCode = 5618186 AND Type_ = 10;
UPDATE data_universe SET Name = 'LOIVE CO LTD NPV' WHERE SecCode = 5848751 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7791.TW', RkdDisplayRIC = '7791.TW', DsExchMnem = 'TAI', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 6012727 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ONCOI', PermIDTicker = 'ONCOI', RkdRIC = 'ONCOI.OL', RkdDisplayRIC = 'ONCOI.OL' WHERE SecCode = 6039856 AND Type_ = 10;
UPDATE data_universe SET Name = 'LOIVE CO LTD NPV' WHERE SecCode = 6203017 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6457843 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6495234 AND Type_ = 10;
UPDATE data_universe SET Name = 'KIATNAKIN PHATRA S DR 1000:1' WHERE SecCode = 6507154 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 10928401 AND Type_ = 1;
UPDATE data_universe SET Name = 'NULEGACY GOLD CORP COM' WHERE SecCode = 10980732 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'ADAPY', PermIDTicker = NULL, RkdRIC = 'ADAPY.PK', RkdDisplayRIC = 'ADAPY.PK', DsTypeCode = 'EQ', RkdExchCode = 'OTC', PermQuoteRetireDate = '2025-10-28', endDate = '2025-10-28' WHERE SecCode = 11148019 AND Type_ = 1;
UPDATE data_universe SET Name = 'GIEGER ENERGY CORP COM' WHERE SecCode = 11185572 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA75865L1094', RkdSEDOL = 'BPYV2J', RkdCUSIP = '75865L10', DsPrimQtSedol = 'BPYV2J6' WHERE SecCode = 11190644 AND Type_ = 1;
UPDATE data_universe SET Name = 'UCOMMUNE INTERNATIONAL LTD *W EXP 11/18/2025' WHERE SecCode = 11202141 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA07135M3021', PermIDTicker = 'BATXD', RkdSEDOL = 'BQ3QCL', RkdCUSIP = '07135M30', DsPrimQtSedol = 'BQ3QCL1' WHERE SecCode = 11212317 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 11221887 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2022-03-07' WHERE SecCode = 11239371 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA28619V1058', RkdTicker = 'EONE', RkdSEDOL = 'BRCDG7', RkdCUSIP = '28619V10', RkdRIC = 'EONE.CD', RkdDisplayRIC = 'EONE.CD', DsPrimQtSedol = 'BRCDG74' WHERE SecCode = 11241066 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 12.0 WHERE SecCode = 11267607 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2024-09-25' WHERE SecCode = 11269754 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'BYAH', PermIDTicker = 'BYAH', RkdRIC = 'BYAH.O', RkdDisplayRIC = 'BYAH.OQ' WHERE SecCode = 11273567 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11286424 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N' WHERE SecCode = 11286464 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951916.0 WHERE SecCode = 11287172 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ZAMD', QuotePermID = 236797572207.0, InstrPermID = 232904485187.0, OrgPermID = 4295903297.0, PriValQuotePermID = 236797572207.0, PriInstrPermID = 8590934144.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NLB', QuoteClass = 'DRC', InstrClass = 'DRC', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951261.0, PermOrgIPODate = '1979-10-15', PermSecMapStartDate = '2025-10-15', startDate = '2025-10-15' WHERE SecCode = 11287203 AND Type_ = 1;
