UPDATE data_universe SET PermIDTicker = 'XAN', QuotePermID = 21475442982.0, ExchCode = 'POS' WHERE SecCode = 4772 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 25727361719.0 WHERE SecCode = 7360 AND Type_ = 1;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 39078 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 18909.0 WHERE SecCode = 47708 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74180 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 74250 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 74992 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VOITHPAPR', RkdRIC = 'VOIT.NS', RkdDisplayRIC = 'VOIT.NS', RkdExchCode = 'NSE' WHERE SecCode = 78264 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 78903 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 79678 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', SecMapEndDate = '2026-08-19', PermQuoteRetireDate = '2026-08-20', PermSecMapEndDate = '2026-08-20', endDate = '2026-08-19' WHERE SecCode = 81099 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 81640 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 55834584871.0 WHERE SecCode = 84305 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 55834595821.0 WHERE SecCode = 86473 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 98128 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 98224 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232947802533.0, IsPrimaryInstr = 0.0, PermOrgIPODate = '2026-08-20' WHERE SecCode = 101345 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 105408 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115997 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 18909.0 WHERE SecCode = 134321 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'LADDERUP', RkdRIC = 'LADF.NS', RkdDisplayRIC = 'LADF.NS', RkdExchCode = 'NSE' WHERE SecCode = 134906 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 140875 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142870 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MLCO', Name = 'MORE LIFE CO CORP COM NEW', PermSecMapEndDate = '2026-08-20', endDate = '2026-08-20' WHERE SecCode = 159738 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'QUB.AX^H26', RkdIssueStatus = 0.0 WHERE SecCode = 186577 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 311238 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 369170 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 514193 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'VTS.HNO^H26', RkdIssueStatus = 0.0, PermInstrStatus = 'DC' WHERE SecCode = 586476 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 965980 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 1072078 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1183053 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1293048 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21492779438.0, ExchCode = 'BUR' WHERE SecCode = 1541403 AND Type_ = 10;
UPDATE data_universe SET Name = 'WOOREE E&L HAROUTI KRW2500', DsCtryQtStatus = 'A' WHERE SecCode = 2086231 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2569978 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT7JJ94' WHERE SecCode = 2835254 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2872662 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931877.0, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3198701 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21593027899.0 WHERE SecCode = 3217845 AND Type_ = 10;
UPDATE data_universe SET Name = 'CANVAS N CO LTD KRW500', DsCtryQtStatus = 'A' WHERE SecCode = 3230631 AND Type_ = 10;
UPDATE data_universe SET Name = 'THAI PRIME PROP FR THB8.1396 (LOCAL)' WHERE SecCode = 3260040 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'LKPSEC', RkdRIC = 'LKPS.NS', RkdDisplayRIC = 'LKPS.NS', RkdExchCode = 'NSE' WHERE SecCode = 3275554 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3318434 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BT8QVP4' WHERE SecCode = 3359156 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3382226 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-21', SecMapEndDate = '2026-08-20', endDate = '2026-08-20' WHERE SecCode = 3440134 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3554990 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3721420 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3773536 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-08-20', SecMapEndDate = '2026-08-19', PermQuoteRetireDate = '2026-08-20', PermSecMapEndDate = '2026-08-20', endDate = '2026-08-19' WHERE SecCode = 3837261 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3980014 AND Type_ = 10;
UPDATE data_universe SET Name = 'LAONPEOPLE INC KRW2500', DsCtryQtStatus = 'A' WHERE SecCode = 3989802 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VMRK34', DsPrimQtSedol = 'BP95Y75' WHERE SecCode = 4079198 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4447564 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4495552 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4607294 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4739247 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21932177205.0, ExchCode = 'MUN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4903829 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5430796 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '7855.TW', RkdDisplayRIC = '7855.TW', RkdExchCode = 'TPE' WHERE SecCode = 6478350 AND Type_ = 10;
UPDATE data_universe SET Name = 'ACE SOFTWARE EXP INR110(PPD INR79.75UPD30.25' WHERE SecCode = 6612680 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = NULL WHERE SecCode = 6694372 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6705484 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2025-03-10', startDate = '2025-03-10' WHERE SecCode = 6708240 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-08-20', SecMapEndDate = '2026-08-19', PermQuoteRetireDate = '2026-08-20', PermSecMapEndDate = '2026-08-20', endDate = '2026-08-19' WHERE SecCode = 6951990 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-07-16' WHERE SecCode = 6985984 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'PH0000062838', RkdTicker = 'SMC2V', RkdSEDOL = 'BV5G7P', RkdCUSIP = 'Y7510634', RkdRIC = 'SMC2V.PS', RkdDisplayRIC = 'SMC2V.PS', RkdCode = 21636.0, RkdIssueID = 26.0, RkdIssueCode = 186077.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 23.0, RkdExchCode = 'PSE', RkdExchCtry = 'PHL', PrimaryIssueType = 'EQU', PrimaryIssueCode = 21636.0, COATypeCode = 'IND' WHERE SecCode = 7023609 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'PH0000062846', RkdTicker = 'SMC2W', RkdSEDOL = 'BV5G7Q', RkdCUSIP = 'Y7510636', RkdRIC = 'SMC2W.PS', RkdDisplayRIC = 'SMC2W.PS', RkdCode = 21636.0, RkdIssueID = 27.0, RkdIssueCode = 186078.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 24.0, RkdExchCode = 'PSE', RkdExchCtry = 'PHL', PrimaryIssueType = 'EQU', PrimaryIssueCode = 21636.0, COATypeCode = 'IND' WHERE SecCode = 7023610 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'PH0000062853', RkdTicker = 'SMC2X', RkdSEDOL = 'BV5G7S', RkdCUSIP = 'Y7510635', RkdRIC = 'SMC2X.PS', RkdDisplayRIC = 'SMC2X.PS', RkdCode = 21636.0, RkdIssueID = 28.0, RkdIssueCode = 186079.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 25.0, RkdExchCode = 'PSE', RkdExchCtry = 'PHL', PrimaryIssueType = 'EQU', PrimaryIssueCode = 21636.0, COATypeCode = 'IND' WHERE SecCode = 7023611 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 10928206 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000162820.0, PriInstrPermID = 21475759430.0 WHERE SecCode = 10985859 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 11067357 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SNUS PR I', Name = 'SANTANDER HOLDINGS USA INC DEP SH RP SR I', DsPrimQtSedol = 'BT06SF1' WHERE SecCode = 11070075 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-21', SecMapEndDate = '2026-08-19', endDate = '2026-08-19' WHERE SecCode = 11141457 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-08-21', SecMapEndDate = '2026-08-19', endDate = '2026-08-19' WHERE SecCode = 11141459 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11145445 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL WHERE SecCode = 11163196 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SNUS PR H', Name = 'SANTANDER HOLDINGS USA INC DP SHS REP SER H' WHERE SecCode = 11179901 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11182672 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PONIF' WHERE SecCode = 11193523 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C094KN4' WHERE SecCode = 11199544 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA76206T1084', RkdTicker = 'RHEL', RkdSEDOL = 'BNYG3Z', RkdCUSIP = '76206T10', RkdRIC = 'RHEL.CD', RkdDisplayRIC = 'RHEL.CD' WHERE SecCode = 11208072 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'CHTRP', Name = 'CHARTER COMMUNICATIONS INC CUM PFD SR A' WHERE SecCode = 11216393 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C094KT0' WHERE SecCode = 11224426 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'BTLN', PermIDTicker = 'BTLN', RkdRIC = 'BTLN.O', RkdDisplayRIC = 'BTLN.OQ' WHERE SecCode = 11226614 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C094KW3' WHERE SecCode = 11226914 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000057256.0, PriInstrPermID = 25727217391.0, PriTRBCIndPermID = 4294951610.0, PermOrgIPODate = '2021-10-27' WHERE SecCode = 11232780 AND Type_ = 1;
UPDATE data_universe SET Name = 'ADLAI NORTYE GROUP LTD SPONSORED ADS', DsTypeCode = 'EQ' WHERE SecCode = 11257663 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C094KR8' WHERE SecCode = 11259864 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG8552M1419', RkdSEDOL = 'C0471P', RkdCUSIP = 'G8552M14' WHERE SecCode = 11261930 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'C094N02' WHERE SecCode = 11269313 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-08-19', PermQuoteRetireDate = '2026-08-20', PermSecMapEndDate = '2026-08-20', endDate = '2026-08-19' WHERE SecCode = 11274901 AND Type_ = 1;
UPDATE data_universe SET Country = 'USA' WHERE SecCode = 11275438 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-08-19', PermQuoteRetireDate = '2026-08-20', PermSecMapEndDate = '2026-08-20', endDate = '2026-08-19' WHERE SecCode = 11277128 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11281521 AND Type_ = 1;
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 = 11297292 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'VGG669031087', RkdTicker = 'OCAC', RkdSEDOL = 'BXL2BV', RkdCUSIP = 'G6690310', RkdRIC = 'OCAC.K', RkdDisplayRIC = 'OCAC.N', RkdCode = 133580.0, RkdIssueID = 1.0, RkdIssueCode = 169775.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11299988 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-07-30', startDate = '2026-07-30' WHERE SecCode = 11300093 AND Type_ = 1;
UPDATE data_universe SET DsCmpyCode = 215626, IsMajorSec = 'Y' WHERE SecCode = 11300197 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LYNX', QuotePermID = 236812532054.0, InstrPermID = 232944765154.0, OrgPermID = 6000213059.0, PriTrdQuotePermID = 236812532054.0, PriValQuotePermID = 25726993327.0, PriInstrPermID = 232944765154.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951866.0, PermOrgIPODate = '2026-08-19', PermSecMapStartDate = '2026-08-15', startDate = '2026-08-15' WHERE SecCode = 11300666 AND Type_ = 1;