UPDATE data_universe SET PriTRBCIndPermID = 4294951301.0 WHERE SecCode = 3878 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'BNY' WHERE SecCode = 8265 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PFCIBEST', QuotePermID = 55838845317.0, InstrPermID = 8589948120.0, OrgPermID = 5094748203.0, PriValQuotePermID = 55838845317.0, PriInstrPermID = 8589949779.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'COL', QuoteClass = 'PRF', InstrClass = 'PRF', OrgTypeCode = 'COM', DomCntry = 'COL', IncCntry = 'COL', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '1753-01-01', PermSecMapStartDate = '2010-06-01' WHERE SecCode = 27450 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-19' WHERE SecCode = 27786 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BIO1n.H^E26', RkdIssueStatus = 0.0 WHERE SecCode = 51554 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CAN', IncCntry = NULL WHERE SecCode = 70208 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TRLEF' WHERE SecCode = 71190 AND Type_ = 1;
UPDATE data_universe SET Name = 'SOFTMEDX HLTH CARE NPV (POST SPLT)' WHERE SecCode = 74731 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'DAEWON CHEMICAL KRW2500' WHERE SecCode = 76424 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 80386 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81512 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 81919 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 83269 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951830.0 WHERE SecCode = 84759 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 85641 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 86918 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000207540', RkdTicker = 'SPX', PermIDTicker = 'SPX', RkdSEDOL = 'BMXJPN', RkdCUSIP = 'Q2442414', RkdRIC = 'SPX.AX', RkdDisplayRIC = 'SPX.AX', DsPrimQtSedol = 'BMXJPN5', PermSecMapEndDate = '2026-05-12', endDate = '2026-05-12' WHERE SecCode = 87204 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'FIN' WHERE SecCode = 88902 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-10' WHERE SecCode = 89948 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CASTORA AGRI COMMO INR10' WHERE SecCode = 92313 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SEOUL FOOD IND PFD KRW1000' WHERE SecCode = 95047 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SEOUL FOOD IND KRW1000' WHERE SecCode = 95093 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 95479 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951773.0 WHERE SecCode = 97638 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951855.0 WHERE SecCode = 98388 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 101344 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-21', PermSecMapEndDate = '2026-05-21' WHERE SecCode = 104433 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CS CORPORATION KRW1000' WHERE SecCode = 113243 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2004-12-22', endDate = '2004-12-22' WHERE SecCode = 113860 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-12' WHERE SecCode = 117055 AND Type_ = 10;
UPDATE data_universe SET Name = 'BIO VIEW ILS0.01' WHERE SecCode = 144311 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 145496 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 185120 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 310997 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'WOOGENE B&G CO LTD KRW2500' WHERE SecCode = 387440 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'SDA.HN^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-22', SecMapEndDate = '2026-05-15', PermQuoteRetireDate = '2026-05-22', endDate = '2026-05-15' WHERE SecCode = 561036 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'IHK.HNO^E26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-05-22', SecMapEndDate = '2026-05-21', PermQuoteRetireDate = '2026-05-22', endDate = '2026-05-21' WHERE SecCode = 562961 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-05-21', endDate = '2026-05-20' WHERE SecCode = 577384 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951333.0 WHERE SecCode = 612110 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1083459 AND Type_ = 10;
UPDATE data_universe SET Name = 'SIRIUS MEDIA EUR0.02' WHERE SecCode = 1109069 AND Type_ = 10;
UPDATE data_universe SET Name = 'COMPARTAMOS BANCO PEN34.78' WHERE SecCode = 1187507 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SGD' WHERE SecCode = 1371891 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 1539171 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1635177 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1653492 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1722200 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q3482M18' WHERE SecCode = 2372641 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21532984899.0, ExchCode = 'BCO' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2510706 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2587195 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951603.0 WHERE SecCode = 2642302 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2746333 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2769155 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2832701 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BX017R92', RkdSEDOL = 'BX017R', RkdCUSIP = 'G2105G13', DsPrimQtSedol = 'BX017R9' WHERE SecCode = 2853439 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2955815 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'FASHION PLATFORM KRW500' WHERE SecCode = 2997005 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951888.0 WHERE SecCode = 3002449 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951280.0 WHERE SecCode = 3118169 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21724552589.0, PermQuoteStatus = 'AC', ExchCode = 'BTE', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL WHERE SecCode = 3177550 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3194837 AND Type_ = 10;
UPDATE data_universe SET Name = 'HANJOO LIGHT METAL KRW1000' WHERE SecCode = 3230624 AND Type_ = 10;
UPDATE data_universe SET Name = 'THAI PRIME PROP FR THB8.1696 (LOCAL)' WHERE SecCode = 3260040 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3268522 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SPX', DsPrimQtSedol = 'BMXJPN5' WHERE SecCode = 3275548 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951912.0 WHERE SecCode = 3282642 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21732297982.0, ExchCode = 'DUS' WHERE SecCode = 3324152 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'INE721X01023', RkdSEDOL = 'BTZCSM', RkdCUSIP = 'Y2R8WB12', DsPrimQtSedol = 'BTZCSM1' WHERE SecCode = 3374733 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951810.0 WHERE SecCode = 3408974 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-05-22' WHERE SecCode = 3441370 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3554989 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'AV2n.F', RkdDisplayRIC = 'AV2n.F', RkdIssueStatus = 1.0, RkdExchCode = 'FRA' WHERE SecCode = 3840551 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '4582.TW', RkdDisplayRIC = '4582.TW', DsExchMnem = 'TAI', RkdExchCode = 'TPE', ExchCode = 'TAI' WHERE SecCode = 3969541 AND Type_ = 10;
UPDATE data_universe SET Name = 'LUMI EDUC GP A.S NOK0.42' WHERE SecCode = 4502158 AND Type_ = 10;
UPDATE data_universe SET Name = 'XPLUS INC KRW500' WHERE SecCode = 4511450 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 0.0 WHERE SecCode = 4513760 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4867324 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951362.0 WHERE SecCode = 5541936 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6075866 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', QuotePermID = NULL, InstrPermID = NULL, OrgPermID = NULL, PriValQuotePermID = NULL, PriInstrPermID = NULL, IsPrimaryQuote = NULL, IsPrimaryInstr = NULL, PermQuoteStatus = NULL, PermInstrStatus = NULL, ExchCode = NULL, QuoteClass = NULL, InstrClass = NULL, OrgTypeCode = NULL, DomCntry = NULL, IncCntry = NULL, PriTRBCIndPermID = NULL, DsSecDelistDate = '2026-05-22', SecMapEndDate = '2026-05-21', PermQuoteRetireDate = NULL, PermOrgIPODate = NULL, PermSecMapStartDate = NULL, startDate = '2026-04-16', endDate = '2026-05-21' WHERE SecCode = 6786369 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 6786375 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 144664.0 WHERE SecCode = 6789475 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236806319592.0, InstrPermID = 232932523991.0, OrgPermID = 4295871627.0, PriValQuotePermID = 236806319592.0, PriInstrPermID = 8590929117.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'AC', ExchCode = 'HKG', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'HKG', IncCntry = 'BMU', PriTRBCIndPermID = 4294951550.0, PermQuoteRetireDate = '2026-05-21', PermOrgIPODate = '1992-11-12', PermSecMapStartDate = '2026-04-28', PermSecMapEndDate = '2026-05-20', startDate = '2026-04-28' WHERE SecCode = 6813826 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y274CA10' WHERE SecCode = 6857264 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y8343D10' WHERE SecCode = 6865121 AND Type_ = 10;
UPDATE data_universe SET Name = 'DIGIMARC CORPORATION COM' WHERE SecCode = 10785144 AND Type_ = 1;
UPDATE data_universe SET DsExchMnem = 'TSE', ExchCode = 'TOR' WHERE SecCode = 10983015 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA93390B4055', RkdSEDOL = 'BTRTV3', RkdCUSIP = '93390B40', DsPrimQtSedol = 'BTRTV32' WHERE SecCode = 11019099 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US29350E3027', RkdSEDOL = 'BTQJ1C', RkdCUSIP = '29350E30', DsPrimQtSedol = 'BTQJ1C2' WHERE SecCode = 11142344 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11162946 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11165423 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11172678 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA5362151063', RkdSEDOL = 'BTQKY7', RkdCUSIP = '53621510', DsPrimQtSedol = 'BTQKY71' WHERE SecCode = 11174950 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-12-13', endDate = '2025-12-13' WHERE SecCode = 11199053 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11202259 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 11217696 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'OPTH', QuotePermID = 236807278636.0, PermQuoteStatus = 'AC', ExchCode = 'MPM', PermQuoteRetireDate = NULL, PermSecMapStartDate = '2026-05-20', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11222037 AND Type_ = 1;
UPDATE data_universe SET Name = 'QTREX QUANTUM LTD SHS' WHERE SecCode = 11222088 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US46265P3055', RkdSEDOL = 'BTQJ19', RkdCUSIP = '46265P30', DsPrimQtSedol = 'BTQJ199', PermSecMapEndDate = '2025-10-25', endDate = '2025-10-25' WHERE SecCode = 11223868 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = '2021-05-26' WHERE SecCode = 11224790 AND Type_ = 1;
UPDATE data_universe SET Name = 'QTREX QUANTUM LTD *W EXP 06/30/2026' WHERE SecCode = 11227222 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-03-25', endDate = '2026-03-25' WHERE SecCode = 11238670 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2025-01-25', endDate = '2025-01-25' WHERE SecCode = 11262020 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG9161K1206', RkdSEDOL = 'BTQJ1H', RkdCUSIP = 'G9161K12', DsPrimQtSedol = 'BTQJ1H7' WHERE SecCode = 11263606 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US49457M2052', RkdSEDOL = 'BTQJ1F', RkdCUSIP = '49457M20', DsPrimQtSedol = 'BTQJ1F5' WHERE SecCode = 11265603 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG57Y3D1176', RkdSEDOL = 'BTQJ11', RkdCUSIP = 'G57Y3D11', DsPrimQtSedol = 'BTQJ111' WHERE SecCode = 11275368 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11279854 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 = 11291637 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, IsMajorSec = 'N', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL WHERE SecCode = 11293913 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11294590 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 = 11295153 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LCLN', QuotePermID = 236806330206.0, InstrPermID = 232932608037.0, OrgPermID = 6000113465.0, PriTrdQuotePermID = 236806330206.0, PriValQuotePermID = 25727024898.0, PriInstrPermID = 232932608037.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951362.0, PermOrgIPODate = '2026-05-20', PermSecMapStartDate = '2026-05-16', startDate = '2026-05-16' WHERE SecCode = 11296208 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG7310E1026', RkdTicker = 'QADR', RkdSEDOL = 'BT3HDV', RkdCUSIP = 'G7310E10', RkdRIC = 'QADR.O', RkdDisplayRIC = 'QADR.OQ', RkdCode = 143140.0, RkdIssueID = 1.0, RkdIssueCode = 182724.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11296240 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG770AL1036', RkdTicker = 'RREV', RkdSEDOL = 'BMWF1B', RkdCUSIP = 'G770AL10', RkdRIC = 'RREV.O', RkdDisplayRIC = 'RREV.OQ', RkdCode = 144770.0, RkdIssueID = 1.0, RkdIssueCode = 185147.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11296242 AND Type_ = 1;
