UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'GES.N^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2026-01-23', SecMapEndDate = '2026-01-22', PermQuoteRetireDate = '2026-01-23', PermSecMapEndDate = '2026-01-23', endDate = '2026-01-22' WHERE SecCode = 31586 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ANFp', QuotePermID = 21475800397.0, ExchCode = 'SIG', PermQuoteRetireDate = '2012-12-10', endDate = '2012-12-10' WHERE SecCode = 33925 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475405466.0, ExchCode = 'STU' WHERE SecCode = 35324 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BIB', QuotePermID = 55836324256.0, ExchCode = 'BER', PermQuoteRetireDate = '2013-03-20' WHERE SecCode = 35717 AND Type_ = 10;
UPDATE data_universe SET Name = 'KIMCO REALTY CORP COM' WHERE SecCode = 39663 AND Type_ = 1;
UPDATE data_universe SET Name = 'MARSH & MCLENNAN COS INC COM' WHERE SecCode = 44716 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097134247.0, PriTRBCIndPermID = NULL, PermOrgIPODate = '1999-12-08' WHERE SecCode = 45146 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21526380627.0, ExchCode = 'BTE' WHERE SecCode = 47172 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DYHd', QuotePermID = 236781095764.0, ExchCode = 'AQX' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET Name = 'NOVAGOLD RESOURCES INC COM NEW' WHERE SecCode = 51313 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21475422916.0, ExchCode = 'FRA', PermQuoteRetireDate = '2002-08-26', PermSecMapEndDate = '2002-08-26', endDate = '2002-08-22' WHERE SecCode = 60880 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-26' WHERE SecCode = 74992 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 88997 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 89298 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-26' WHERE SecCode = 99233 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-26' WHERE SecCode = 101984 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'VIYASH SCIENTIFIC INR2' WHERE SecCode = 125802 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BLK.I', QuotePermID = 21475530695.0, ExchCode = 'CIR', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 145528 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21915101968.0, ExchCode = 'DEU' WHERE SecCode = 147555 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US90137F6088', RkdCUSIP = '90137F60', DsPrimQtSedol = 'BRBNNJ6' WHERE SecCode = 159732 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55838243234.0, ExchCode = 'MUN', PermQuoteRetireDate = '2023-03-17', PermSecMapEndDate = NULL, endDate = '2023-03-17' WHERE SecCode = 178289 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VLG', QuotePermID = 55838736391.0, ExchCode = 'MCE', PermQuoteRetireDate = '2013-08-09' WHERE SecCode = 182166 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21798248733.0, ExchCode = 'FRA' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21937822314.0, ExchCode = 'HAN' WHERE SecCode = 201949 AND Type_ = 10;
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 PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-01-23' WHERE SecCode = 391456 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 561067 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-26' WHERE SecCode = 586469 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CIPRUN TECHNOLOGY HKD0.1' WHERE SecCode = 753821 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 841108 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-26' WHERE SecCode = 2441643 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-26' WHERE SecCode = 2513984 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'G4766E10' WHERE SecCode = 2745164 AND Type_ = 10;
UPDATE data_universe SET Name = 'HUA HSUAN REAL TWD10' WHERE SecCode = 2747587 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3040839 AND Type_ = 10;
UPDATE data_universe SET Name = 'RAON ROBOTICS INC KRW500' WHERE SecCode = 3044062 AND Type_ = 10;
UPDATE data_universe SET Name = 'THAC GROUP (HLDGS) HKD0.2' WHERE SecCode = 3211310 AND Type_ = 10;
UPDATE data_universe SET Name = 'CORO ENERGY PLC ORD GBP0.01', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3309807 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'PARAMPARA DAIRY DE INR10' WHERE SecCode = 3435608 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG4R39W1672', RkdSEDOL = 'BTZRKH', RkdCUSIP = 'G4R39W16', DsPrimQtSedol = 'BTZRKH5', PermSecMapEndDate = '2026-01-23', endDate = '2026-01-23' WHERE SecCode = 3622411 AND Type_ = 10;
UPDATE data_universe SET Name = 'SUNBORN INTL OYJ NPV' WHERE SecCode = 3664433 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3691618 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET Name = 'MARSH & MCLENNAN BDR EACH 2 REPR 1 COM' WHERE SecCode = 4077652 AND Type_ = 10;
UPDATE data_universe SET Name = 'RAPID NUTRITION PL GBP0.1(POST CONSOLIDATION)' WHERE SecCode = 4626812 AND Type_ = 10;
UPDATE data_universe SET Name = 'STACK BTC PLC ORD GBP0.01' WHERE SecCode = 4757875 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'M0R6E711' WHERE SecCode = 4842761 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-01-23' WHERE SecCode = 4850936 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21929410708.0, ExchCode = 'DUS' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-26' WHERE SecCode = 5208169 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'M7S61L11' WHERE SecCode = 5297846 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0016830038', RkdTicker = 'NEO B', RkdSEDOL = 'BNM3GG', RkdCUSIP = 'W6716211', RkdRIC = 'NEOb.ST', RkdDisplayRIC = 'NEOb.ST', RkdCode = 144063.0, RkdIssueID = 1.0, RkdIssueCode = 184014.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'STO', RkdExchCtry = 'SWE', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 5822258 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 5940212 AND Type_ = 10;
UPDATE data_universe SET Country = 'CYM' WHERE SecCode = 5965442 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'JP3758310001', RkdTicker = '359A', RkdSEDOL = 'BSVGYW', RkdCUSIP = 'J4917V10', RkdRIC = '359A.T', RkdDisplayRIC = '359A.T', RkdCode = 142018.0, RkdIssueID = 1.0, RkdIssueCode = 181136.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TYO', RkdExchCtry = 'JPN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6297435 AND Type_ = 10;
UPDATE data_universe SET Name = 'AVENUESAI LTD' WHERE SecCode = 6375311 AND Type_ = 10;
UPDATE data_universe SET Name = 'IL ROBOTICS CO LTD KRW100' WHERE SecCode = 6556259 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6578324 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG7314Y1044', RkdTicker = '2661', RkdSEDOL = 'BW9DKT', RkdCUSIP = 'G7314Y10', RkdRIC = '2661.HK', RkdDisplayRIC = '2661.HK', RkdCode = 143723.0, RkdIssueID = 2.0, RkdIssueCode = 184001.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 6612485 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y755DU10' WHERE SecCode = 6628097 AND Type_ = 10;
UPDATE data_universe SET Name = 'SUMMIT HOTEL PPTYS COM' WHERE SecCode = 10987529 AND Type_ = 1;
UPDATE data_universe SET Name = 'KIMCO REALTY CORP DP CV CL N 7.25%' WHERE SecCode = 11001649 AND Type_ = 1;
UPDATE data_universe SET Name = 'NATURAL GROCERS BY VITAMIN COM' WHERE SecCode = 11030656 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11139732 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'EZRA', RkdRIC = 'EZRA.O', RkdDisplayRIC = 'EZRA.OQ' WHERE SecCode = 11142544 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-01-23', PermSecMapEndDate = '2026-01-23' WHERE SecCode = 11146137 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-26' WHERE SecCode = 11149498 AND Type_ = 1;
UPDATE data_universe SET Name = 'BANK OF N T BUTTERFIELD & SO SHS NEW' WHERE SecCode = 11162584 AND Type_ = 1;
UPDATE data_universe SET Name = 'KIMCO REALTY CORP 5.125% DEP PFD L' WHERE SecCode = 11175816 AND Type_ = 1;
UPDATE data_universe SET Name = 'SUMMIT HOTEL PPTYS 6.250% CUM PFD E' WHERE SecCode = 11178746 AND Type_ = 1;
UPDATE data_universe SET Name = 'KIMCO REALTY CORP 5.25% DEP SHS M' WHERE SecCode = 11180082 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA23347H1064', RkdTicker = 'DRC', RkdCUSIP = '23347H10', RkdRIC = 'DRC.CD', RkdDisplayRIC = 'DRC.CD', DsPrimQtSedol = 'BNHV9Q5' WHERE SecCode = 11199545 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11212834 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11214756 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'GPGI' WHERE SecCode = 11214926 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRBNNV8' WHERE SecCode = 11218581 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11224254 AND Type_ = 1;
UPDATE data_universe SET Name = 'SUMMIT HOTEL PPTYS 5.875% RED PFD F' WHERE SecCode = 11228447 AND Type_ = 1;
UPDATE data_universe SET Name = 'CANADIAN UTILS CDS BOOK ENTR 4.75% 2ND PFD HH' WHERE SecCode = 11235272 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BTY4LS5' WHERE SecCode = 11239813 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = NULL WHERE SecCode = 11241337 AND Type_ = 1;
UPDATE data_universe SET Name = 'KIBOKO GOLD INC COM SHS', PermSecMapEndDate = '2026-01-23', endDate = '2026-01-23' WHERE SecCode = 11243273 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRBNNX0' WHERE SecCode = 11250671 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRBNMT9' WHERE SecCode = 11253723 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRBNRF0' WHERE SecCode = 11258156 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRBNN74' WHERE SecCode = 11264399 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BRBNNQ3' WHERE SecCode = 11274027 AND Type_ = 1;
UPDATE data_universe SET Name = 'BLUENERGIES LTD COM' WHERE SecCode = 11277291 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA24378A1012', RkdTicker = 'SEAS', RkdCUSIP = '24378A10', RkdRIC = 'SEAS.CD', RkdDisplayRIC = 'SEAS.CD', DsPrimQtSedol = 'BWQLRX2' WHERE SecCode = 11288084 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, PriInstrPermID = 232900985308.0 WHERE SecCode = 11289051 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, PriInstrPermID = 232901218110.0 WHERE SecCode = 11289054 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11290284 AND Type_ = 1;
UPDATE data_universe SET Name = 'X3 ACQUISITION CORP LTD UNIT 12/19/2030', QuotePermID = 236801852273.0, IsPrimaryQuote = 1.0, ExchCode = 'NMS' WHERE SecCode = 11290893 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US0919471013', RkdTicker = 'BTGO', PermIDTicker = 'BTGO', RkdSEDOL = 'BTY39L', RkdCUSIP = '09194710', RkdRIC = 'BTGO.K', RkdDisplayRIC = 'BTGO.N', RkdCode = 143018.0, RkdIssueID = 2.0, RkdIssueCode = 183997.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '', QuotePermID = 236801729187.0, InstrPermID = 232902468726.0, OrgPermID = 5063773761.0, PriTrdQuotePermID = 236801729187.0, PriValQuotePermID = 25727039739.0, PriInstrPermID = 232902468726.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 1004365393.0, PermOrgIPODate = '2026-01-22', PermSecMapStartDate = '2026-01-17', startDate = '2026-01-17' WHERE SecCode = 11290900 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236801916716.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, ExchCode = 'NMS' WHERE SecCode = 11290921 AND Type_ = 1;
