UPDATE data_universe SET PermQuoteStatus = 'DC' WHERE SecCode = 33139 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 55838651983.0 WHERE SecCode = 44481 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BCB.AX^G26', RkdIssueStatus = 0.0 WHERE SecCode = 68818 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-07-31', SecMapEndDate = '2024-09-02', PermQuoteRetireDate = '2026-07-30', endDate = '2024-09-02' WHERE SecCode = 73692 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET Name = 'GMI VENTURE CO LTD KRW2500' WHERE SecCode = 76411 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'KUMHO ELECTRIC INC KRW2500' WHERE SecCode = 85899 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'MIGDAL INS CO LTD ILS0.01' WHERE SecCode = 86396 AND Type_ = 10;
UPDATE data_universe SET DomCntry = NULL WHERE SecCode = 87093 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXV5LT0' WHERE SecCode = 87188 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88310 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 89196 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 93315 AND Type_ = 10;
UPDATE data_universe SET PriTrdQuotePermID = 25727440034.0, PriValQuotePermID = 55835418695.0 WHERE SecCode = 99085 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA6076773093', RkdSEDOL = 'BXL2FB', RkdCUSIP = '60767730' WHERE SecCode = 99582 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2004-06-14' WHERE SecCode = 113906 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SINOMA INTL HLDG C ''A''CNY1' WHERE SecCode = 133129 AND Type_ = 10;
UPDATE data_universe SET Name = 'CONTAX PARTICIPACO COM NPV' WHERE SecCode = 134752 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'IPO' WHERE SecCode = 134942 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-08-05' WHERE SecCode = 265315 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', DsSecDelistDate = '2026-07-31', SecMapEndDate = '2026-07-30', PermQuoteRetireDate = '2026-07-31', endDate = '2026-07-30' WHERE SecCode = 295300 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'TAKE LTD INR1' WHERE SecCode = 318166 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-08-28' WHERE SecCode = 323207 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1753-01-01' WHERE SecCode = 331374 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHALLENGER GOLD LT NPV DFD 06/08/26(EX-SPLIT)' WHERE SecCode = 332462 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US48214U1043', RkdSEDOL = 'BXL2C4', RkdCUSIP = '48214U10', PermOrgIPODate = NULL WHERE SecCode = 336830 AND Type_ = 1;
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 RkdSEDOL = 'BXP2X4' WHERE SecCode = 353611 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BXV21H9' WHERE SecCode = 384065 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 522857 AND Type_ = 10;
UPDATE data_universe SET Name = 'SINO ENERGY CONSER USD0.01' WHERE SecCode = 565859 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'QRTP.WA^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-02-09', PermQuoteRetireDate = '2026-07-31', PermOrgIPODate = NULL, endDate = '2026-02-09' WHERE SecCode = 1485705 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CTY1SN0112', QuotePermID = 21512394267.0, ExchCode = 'HEX' WHERE SecCode = 1677271 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BXV21H9' WHERE SecCode = 2700364 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'GBR' WHERE SecCode = 2905569 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'POLARIS AI HANDY KRW500' WHERE SecCode = 2924543 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21587931877.0, ExchCode = 'CHI' WHERE SecCode = 3157265 AND Type_ = 10;
UPDATE data_universe SET Name = 'PRABHAT ENT LTD INR10' WHERE SecCode = 3220940 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NAMU AX CORP KRW100' WHERE SecCode = 3240135 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21716782408.0, ExchCode = 'MUN', PermQuoteRetireDate = '2021-06-21', endDate = '2021-01-20' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21732297982.0, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET Name = 'NARMADA AGROBASE INR5(POST SUBD)' WHERE SecCode = 3446471 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NGIL', QuotePermID = 25727169919.0, ExchCode = 'MCD' WHERE SecCode = 3512933 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528792.0, ExchCode = 'FRA' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000223425.0 WHERE SecCode = 3837264 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET Name = 'PHASE EDUCATION AS DKK0.10' WHERE SecCode = 4275853 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000223425.0 WHERE SecCode = 4381180 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4626859 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 QuotePermID = 21959379953.0, ExchCode = 'TDG' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 5059311 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5617108 AND Type_ = 10;
UPDATE data_universe SET Name = 'E8 CO LTD KRW500' WHERE SecCode = 5668085 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG4417G1148', RkdSEDOL = 'BTNP4P', RkdCUSIP = 'G4417G11' WHERE SecCode = 6456244 AND Type_ = 10;
UPDATE data_universe SET Name = 'HUGO BOSS AG NPV (ASD LINE 13/08/26 CAS)' WHERE SecCode = 6951990 AND Type_ = 10;
UPDATE data_universe SET Name = 'GWARDAR RES LTD NPV', PermOrgIPODate = '2026-07-31', startDate = '2026-07-03' WHERE SecCode = 7006693 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7009117 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE0QJW01029', RkdTicker = 'LCL', RkdSEDOL = 'BNC3LK', RkdCUSIP = 'Y4S34R11', RkdRIC = 'LOHC.NS', RkdDisplayRIC = 'LOHC.NS', RkdCode = 145283.0, RkdIssueID = 1.0, RkdIssueCode = 185912.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NSE', RkdExchCtry = 'IND', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 7017401 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 236811320550.0 WHERE SecCode = 7017411 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'LTNG', Name = 'LIGHTNING RESOURCE CORP COM NEW' WHERE SecCode = 10934601 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC' WHERE SecCode = 10976948 AND Type_ = 1;
UPDATE data_universe SET PriTrdQuotePermID = 236811326872.0 WHERE SecCode = 11015444 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA89346D7356', RkdTicker = 'TA.PR.F', RkdSEDOL = 'B6Y1L7', RkdCUSIP = '89346D73', RkdRIC = 'TA_pf.TO', RkdDisplayRIC = 'TA_pf.TO', RkdCode = 23641.0, RkdIssueID = 4.0, RkdIssueCode = 115152.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', PrimaryIssueCode = 23641.0, COATypeCode = 'UTL' WHERE SecCode = 11016250 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2012-05-10' WHERE SecCode = 11024463 AND Type_ = 1;
UPDATE data_universe SET Name = 'TECNOGLASS HOLDINGS INC COM SHS', Country = 'USA', DsPrimQtSedol = 'BXD1FS3', PermOrgIPODate = '2012-05-10' WHERE SecCode = 11028764 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11046053 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000223425.0 WHERE SecCode = 11158354 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000223425.0 WHERE SecCode = 11158355 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000223425.0 WHERE SecCode = 11158356 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000223425.0 WHERE SecCode = 11159153 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-07-31' WHERE SecCode = 11182962 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000223425.0 WHERE SecCode = 11207807 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11228094 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US3207035078', RkdSEDOL = 'BT3L2N', RkdCUSIP = '32070350' WHERE SecCode = 11233010 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BXP2W2' WHERE SecCode = 11240122 AND Type_ = 1;
UPDATE data_universe SET RkdCUSIP = 'M6147216' WHERE SecCode = 11245088 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 8.0 WHERE SecCode = 11249579 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 11255741 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'APO_pa.N^G26', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', SecMapEndDate = '2026-07-30', PermQuoteRetireDate = '2026-07-31', endDate = '2026-07-30' WHERE SecCode = 11256233 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US9887402058', RkdSEDOL = 'BXRVP0', RkdCUSIP = '98874020', ShPerListing = 30.0 WHERE SecCode = 11268474 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG9876W1380', RkdSEDOL = 'BVCK9N', RkdCUSIP = 'G9876W13' WHERE SecCode = 11273379 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US18912E3062', RkdSEDOL = 'BXL29L', RkdCUSIP = '18912E30' WHERE SecCode = 11274459 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG6713S1140', RkdSEDOL = 'BXL2B2', RkdCUSIP = 'G6713S11' WHERE SecCode = 11278479 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG812371360', RkdSEDOL = 'BTMQZD', RkdCUSIP = 'G8123713' WHERE SecCode = 11281418 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 11294226 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232933255451.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11297293 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11297676 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11298232 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2026-07-31' WHERE SecCode = 11298973 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GYGY', QuotePermID = 236811209709.0, InstrPermID = 232928909707.0, OrgPermID = 5067759640.0, PriTrdQuotePermID = 236811209689.0, PriValQuotePermID = 25726995858.0, PriInstrPermID = 232928909707.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'SCD', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951205.0, PermSecMapStartDate = '2026-07-29', startDate = '2026-07-29' WHERE SecCode = 11299822 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JMKE', QuotePermID = 236811085894.0, InstrPermID = 232943939530.0, OrgPermID = 6000183268.0, PriTrdQuotePermID = 236811085894.0, PriValQuotePermID = 25726996038.0, PriInstrPermID = 232943939530.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951592.0, PermOrgIPODate = '2026-07-30', PermSecMapStartDate = '2026-07-28', startDate = '2026-07-28' WHERE SecCode = 11299829 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'REF', QuotePermID = 236811085876.0, InstrPermID = 232944376231.0, OrgPermID = 5071168524.0, PriTrdQuotePermID = 236811085876.0, PriValQuotePermID = 25726996060.0, PriInstrPermID = 232944376231.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951490.0, PermOrgIPODate = '2026-07-30', PermSecMapStartDate = '2026-07-28', startDate = '2026-07-28' WHERE SecCode = 11299832 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ISNR', QuotePermID = 236811209855.0, InstrPermID = 232933255451.0, OrgPermID = 6000141808.0, PriTrdQuotePermID = 236811209838.0, PriValQuotePermID = 25726995809.0, PriInstrPermID = 232933255451.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'XNG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PermOrgIPODate = '2026-06-09', PermSecMapStartDate = '2026-07-29', startDate = '2026-06-09' WHERE SecCode = 11299862 AND Type_ = 1;