UPDATE data_universe SET Name = 'AMERICAN TOWER CORP COM' WHERE SecCode = 5125 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '1998-01-08' WHERE SecCode = 19450 AND Type_ = 1;
UPDATE data_universe SET Name = 'EAGLE BANCORPORATION INC COM' WHERE SecCode = 22512 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'SIGMA FOODS S.A.B. SER''A''NPV' WHERE SecCode = 27152 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 27531 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ANFP.I', QuotePermID = 21475586638.0, ExchCode = 'CPA', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 33925 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475405461.0, ExchCode = 'MUN' WHERE SecCode = 35324 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BIBG.I', QuotePermID = 21475512055.0, ExchCode = 'CXE', PermQuoteRetireDate = '2008-11-03' WHERE SecCode = 35717 AND Type_ = 10;
UPDATE data_universe SET Name = 'KITE REALTY GROUP TRUST COM NEW' WHERE SecCode = 39778 AND Type_ = 1;
UPDATE data_universe SET Name = 'LAMAR ADVERTISING CO CL A' WHERE SecCode = 41259 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = 'BRBWSJ' WHERE SecCode = 44550 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO', QuotePermID = 21474913868.0, ExchCode = 'BUR', PermQuoteRetireDate = '2010-08-19', endDate = '2010-08-18' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21526380304.0, ExchCode = 'CHI' WHERE SecCode = 47172 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'DYH', QuotePermID = 21830308575.0, ExchCode = 'GTX' WHERE SecCode = 48143 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 52189 AND Type_ = 1;
UPDATE data_universe SET RkdExchCode = 'NA', RkdExchCtry = NULL WHERE SecCode = 56757 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55845732327.0, PermQuoteStatus = 'AC', ExchCode = 'MUN', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 58288 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'US91705J3032', RkdSEDOL = 'BWQLQ1', RkdCUSIP = '91705J30', DsPrimQtSedol = 'BWQLQ13' WHERE SecCode = 58893 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US91705J4022', RkdSEDOL = 'BWQLPK', RkdCUSIP = '91705J40', DsPrimQtSedol = 'BWQLPK5' WHERE SecCode = 58894 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'NSUd', QuotePermID = 21531132175.0, ExchCode = 'BCO', PermQuoteRetireDate = '2021-07-26', endDate = '2020-11-16' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475422918.0, ExchCode = 'GER', PermQuoteRetireDate = '2002-08-27', PermSecMapEndDate = '1999-09-11', endDate = '1999-09-11' WHERE SecCode = 60880 AND Type_ = 10;
UPDATE data_universe SET Name = 'STAR GROUP LP UNIT LTD PARTNR' WHERE SecCode = 72182 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 75879 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-01-27' WHERE SecCode = 76156 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81363 AND Type_ = 10;
UPDATE data_universe SET Name = 'WEYERHAEUSER CO COM NEW' WHERE SecCode = 81912 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-01-21', startDate = '1986-03-26' WHERE SecCode = 85890 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87170 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BFB HEALTH LTD HKD0.01' WHERE SecCode = 93048 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898257779.0, ExchCode = 'CHI' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET Name = 'AMICUS THERAPEUTIC COM' WHERE SecCode = 102088 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-01-21' WHERE SecCode = 105003 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'VIYASH', PermIDTicker = 'VIYASH', RkdRIC = 'VIYA.NS', RkdDisplayRIC = 'VIYA.NS' WHERE SecCode = 125802 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 126044 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Y9261D16', Name = 'UNITED VAN DER HOR INR1 (POST SUBD)' WHERE SecCode = 126518 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 143909 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21915101821.0, ExchCode = 'FRA' WHERE SecCode = 147555 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 167878 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 183177 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 252333 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'INDII.L^A26', RkdIssueStatus = 0.0, PermQuoteRetireDate = '2026-01-23', endDate = '2026-01-23' WHERE SecCode = 391456 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 409668 AND Type_ = 10;
UPDATE data_universe SET Name = 'LOTUS RESOURCES NPV DFD 29/01/26(EX-SPLIT)' WHERE SecCode = 455870 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-21' WHERE SecCode = 522787 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'CTN.HNO^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-01-23', SecMapEndDate = '2023-12-08', PermQuoteRetireDate = '2026-01-23', PermSecMapEndDate = '2026-01-22', endDate = '2023-12-08' WHERE SecCode = 561067 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'PEC.HNO^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-01-23', SecMapEndDate = '2025-12-12', PermQuoteRetireDate = '2026-01-23', PermSecMapEndDate = '2026-01-22', endDate = '2025-01-23' WHERE SecCode = 841108 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0 WHERE SecCode = 1112903 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q5S64716' WHERE SecCode = 1171484 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDG', QuotePermID = 21512147101.0, ExchCode = 'LSE', PermQuoteRetireDate = '2013-12-17' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 2133371 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2394815 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2429962 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-01-21' WHERE SecCode = 2459997 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951380.0 WHERE SecCode = 2513982 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 2587437 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 2642323 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-05-28', PermSecMapEndDate = '2026-01-22', endDate = '2025-05-28' WHERE SecCode = 2872655 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3002461 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3125027 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'CRANDEC2.LM^A26', RkdIssueStatus = 0.0 WHERE SecCode = 3217271 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3247171 AND Type_ = 10;
UPDATE data_universe SET Name = 'PURPLE AGROTECH INR10' WHERE SecCode = 3257175 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BPSRYZ03', RkdSEDOL = 'BPSRYZ', RkdCUSIP = 'G2480E14', DsPrimQtSedol = 'BPSRYZ0', PermSecMapEndDate = '2026-01-22', endDate = '2026-01-22' WHERE SecCode = 3309807 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'PARAMPARA', PermIDTicker = 'PARAMPARA', RkdRIC = 'PAMA.NS', RkdDisplayRIC = 'PAMA.NS' WHERE SecCode = 3435608 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3735955 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3740587 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3825558 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3986736 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4054156 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4355919 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2025-07-16', PermSecMapEndDate = '2026-01-22', endDate = '2025-07-16' WHERE SecCode = 4429562 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4441403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4617629 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BVVK7R18', RkdSEDOL = 'BVVK7R', RkdCUSIP = 'G7385H13', DsPrimQtSedol = 'BVVK7R1' WHERE SecCode = 4626812 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 4757875 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-01-23', SecMapEndDate = '2026-01-22', PermQuoteRetireDate = '2026-01-23', endDate = '2026-01-22' WHERE SecCode = 4850936 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4972406 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5078443 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5227158 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5454652 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5473222 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, PermSecMapEndDate = '2026-01-21' WHERE SecCode = 5565397 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 5669477 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791838443.0, ExchCode = 'FRA' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'KYG4417G1064', RkdTicker = '2525', RkdSEDOL = 'BVLD6X', RkdCUSIP = 'G4417G10', RkdRIC = '2525.HK', RkdDisplayRIC = '2525.HK', RkdCode = 144041.0, RkdIssueID = 1.0, RkdIssueCode = 183985.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6456244 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000421307', RkdTicker = 'SNM', RkdSEDOL = 'BV8H5T', RkdCUSIP = 'Q8407M10', RkdRIC = 'SNM.AX', RkdDisplayRIC = 'SNM.AX', RkdCode = 144028.0, RkdIssueID = 1.0, RkdIssueCode = 183965.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 6524554 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6543792 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-01-23', SecMapEndDate = '2026-01-22', PermSecMapEndDate = '2026-01-22', endDate = '2026-01-22' WHERE SecCode = 6601514 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-01-22', SecMapEndDate = '2026-01-21', PermSecMapEndDate = '2026-01-22', endDate = '2026-01-21' WHERE SecCode = 11135320 AND Type_ = 1;
UPDATE data_universe SET Name = 'DEVONIAN HEALTH GROUP INC COM NEW', PermSecMapEndDate = '2026-01-22', endDate = '2026-01-22' WHERE SecCode = 11139732 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'PRB.TO^A26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2026-01-23', endDate = '2026-01-23' WHERE SecCode = 11146137 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097134744.0, PriInstrPermID = 21586035826.0, PriTRBCIndPermID = NULL WHERE SecCode = 11156721 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097134744.0, PriInstrPermID = 21586035826.0, PriTRBCIndPermID = NULL WHERE SecCode = 11158330 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 5097125495.0, PriInstrPermID = 21596636301.0 WHERE SecCode = 11163237 AND Type_ = 1;
UPDATE data_universe SET Name = 'SIQ MOUNTAIN INDUSTRIES INC COM' WHERE SecCode = 11170307 AND Type_ = 1;
UPDATE data_universe SET Name = 'OLENOX INDUSTRIES INC COM NEW' WHERE SecCode = 11173442 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11177763 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11186220 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US86804F5098', RkdCUSIP = '86804F50', DsPrimQtSedol = 'BWQLPM7' WHERE SecCode = 11194320 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2018-11-06', startDate = '2018-11-06' WHERE SecCode = 11195058 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11197041 AND Type_ = 1;
UPDATE data_universe SET Name = 'BAKKT INC COM CL A NEW' WHERE SecCode = 11214756 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'GPGI', RkdRIC = 'GPGI.K', RkdDisplayRIC = 'GPGI.N', Name = 'GPGI INC COM CL A' WHERE SecCode = 11214926 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 11235543 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US02115M2089', RkdCUSIP = '02115M20', RkdRIC = 'ACAXU.OQ^A24', ModelCntry = 'SG', RkdCode = 132070.0, RkdIssueID = 2.0, RkdIssueCode = 169237.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 2.0, RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND', OrgPermID = 5072802379.0, PriInstrPermID = 25727202332.0, DomCntry = 'SGP', PriTRBCIndPermID = 4294951595.0, PermOrgIPODate = '2022-02-01' WHERE SecCode = 11237818 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA4937342067', RkdSEDOL = 'BWQLS2', RkdCUSIP = '49373420', DsPrimQtSedol = 'BWQLS28' WHERE SecCode = 11243273 AND Type_ = 1;
UPDATE data_universe SET Name = 'TOTEC RESOURCES LTD COM NEW' WHERE SecCode = 11250304 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG1993R1184', RkdSEDOL = 'BWQLQ3', RkdCUSIP = 'G1993R11', DsPrimQtSedol = 'BWQLQ35' WHERE SecCode = 11261750 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 11265603 AND Type_ = 1;
UPDATE data_universe SET Name = 'ACCO GROUP HLDGS LTD ORD SHS CL A' WHERE SecCode = 11286916 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'MBQIF', QuotePermID = 236801833566.0, InstrPermID = 232806683451.0, OrgPermID = 5086518911.0, PriValQuotePermID = 236777290184.0, PriInstrPermID = 232806683451.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'GTC', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951264.0, PermOrgIPODate = '2023-05-05', PermSecMapStartDate = '2026-01-20' WHERE SecCode = 11287704 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11289654 AND Type_ = 1;
