UPDATE data_universe SET PermQuoteStatus = 'DC', SecMapEndDate = '2026-08-24', PermQuoteRetireDate = '2026-09-17', endDate = '2026-08-24' WHERE SecCode = 31065 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', SecMapEndDate = '2026-08-24', PermQuoteRetireDate = '2026-09-17', endDate = '2026-08-24' WHERE SecCode = 31066 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 37033 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'FI0009003651', RkdTicker = 'SJA1V', RkdSEDOL = '429609', RkdCUSIP = 'X6164P10', RkdRIC = 'SJA1V.HE^A03', RkdDisplayRIC = 'SJA1V.HE', RkdCode = 18333.0, RkdIssueID = 1.0, RkdIssueCode = 25831.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HEL', RkdExchCtry = 'FIN' WHERE SecCode = 38704 AND Type_ = 10;
UPDATE data_universe SET IncCntry = NULL WHERE SecCode = 41828 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 55842440800.0, ExchCode = 'CHI', PermQuoteRetireDate = '2012-05-04', endDate = '2012-05-04' WHERE SecCode = 45820 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 IncCntry = NULL WHERE SecCode = 51273 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'ALZCHEM GROUP AG NPV (REGD)' WHERE SecCode = 58954 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21805754481.0, ExchCode = 'MUN' WHERE SecCode = 61290 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 67075 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2026-09-15', PermSecMapEndDate = '2026-09-16', startDate = '1960-01-01', endDate = '2026-09-15' WHERE SecCode = 69925 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 5096332697.0, IncCntry = 'CAN' WHERE SecCode = 71190 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 73403 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 73754 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 74823 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-09-16', startDate = '1984-07-02' WHERE SecCode = 74991 AND Type_ = 10;
UPDATE data_universe SET SecMapStartDate = '1960-01-01', SecMapEndDate = '2026-09-15', PermSecMapEndDate = '2026-09-16', startDate = '1960-01-01', endDate = '2026-09-15' WHERE SecCode = 75231 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 76193 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 77011 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 77707 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 78237 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-10-13' WHERE SecCode = 79308 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A', DsPrimQtSedol = 'BX7VQ75' WHERE SecCode = 79918 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 81361 AND Type_ = 10;
UPDATE data_universe SET Name = 'AVENTUS CAP INC COM' WHERE SecCode = 81608 AND Type_ = 1;
UPDATE data_universe SET Name = 'PNC MEDIA & ENTERT INR10' WHERE SecCode = 82653 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951205.0 WHERE SecCode = 83802 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 84051 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, RkdRIC = 'SMAH.BO', RkdDisplayRIC = 'SMAH.BO', Name = 'SMAART TECH SVCS INR10' WHERE SecCode = 85350 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87464 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BX7VQ86' WHERE SecCode = 88408 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL WHERE SecCode = 89466 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 89467 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 89550 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA00208D4084', RkdSEDOL = 'B6463M', RkdCUSIP = '00208D40', RkdRIC = 'ARX.TO^I26', RkdDisplayRIC = 'ARX.TO', RkdCode = 15845.0, RkdIssueID = 1.0, RkdIssueCode = 22729.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 89953 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 90276 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'NANJING TECH EQU T ''A''CNY1' WHERE SecCode = 90697 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 91105 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q3648H19', Name = 'EV RESOURCES LTD NPV' WHERE SecCode = 91543 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'SAMBO INDUSTRIAL C KRW500' WHERE SecCode = 94566 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 95516 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 95635 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 95663 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 96390 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000166717.0, PriInstrPermID = 8590932358.0, PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = NULL WHERE SecCode = 97778 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000205514.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 97864 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BT69779' WHERE SecCode = 98055 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 99595 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 100657 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'RU0009831325', RkdTicker = 'sepo', RkdSEDOL = '739871', RkdCUSIP = 'X7603Q10', RkdRIC = 'SEPOI.RTS^E17', RkdDisplayRIC = 'SEPOI.RTS', RkdCode = 60413.0, RkdIssueID = 1.0, RkdIssueCode = 77413.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'RTB', RkdExchCtry = 'RUS' WHERE SecCode = 102999 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000205514.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 110312 AND Type_ = 1;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 113738 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 115666 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 115728 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 124316 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 125625 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'PPG.AX^H26', RkdIssueStatus = 0.0, PermOrgIPODate = NULL WHERE SecCode = 133128 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 142670 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 142799 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'USU760951058', RkdTicker = 'RPSE', RkdSEDOL = 'B0YBN1', RkdCUSIP = 'U7609510', RkdRIC = 'RPSE.L^I09', RkdDisplayRIC = 'RPSE.L', RkdCode = 64271.0, RkdIssueID = 1.0, RkdIssueCode = 81995.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SEA', RkdExchCtry = 'GBR' WHERE SecCode = 145268 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0001718032', RkdTicker = 'IPL', RkdSEDOL = 'B14SY5', RkdCUSIP = 'W4962P10', RkdRIC = 'IPLT.ST^K18', RkdDisplayRIC = 'IPLT.ST', RkdCode = 53386.0, RkdIssueID = 1.0, RkdIssueCode = 69285.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'STO', RkdExchCtry = 'SWE' WHERE SecCode = 145409 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 145584 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00B1D3Q599', RkdTicker = 'SSPH', RkdSEDOL = 'B1D3Q5', RkdCUSIP = 'G8403V10', RkdRIC = 'SSPH.L^I08', RkdDisplayRIC = 'SSPH.L', RkdCode = 56892.0, RkdIssueID = 1.0, RkdIssueCode = 73658.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'SEA', RkdExchCtry = 'GBR' WHERE SecCode = 166440 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21738226557.0, ExchCode = 'STU', PermQuoteRetireDate = '2023-02-21', endDate = '2023-02-21' WHERE SecCode = 177474 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-09-16' WHERE SecCode = 330899 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA68634K1066', RkdSEDOL = 'BYZGJ9', RkdCUSIP = '68634K10', RkdRIC = 'OLA.TO^H26', RkdDisplayRIC = 'OLA.TO', RkdCode = 63544.0, RkdIssueID = 1.0, RkdIssueCode = 80863.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 331641 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'UNK' WHERE SecCode = 396234 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-15' WHERE SecCode = 412789 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 514193 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 643063 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'SE0003273531', RkdTicker = 'ECO B', RkdSEDOL = 'B68R9D', RkdCUSIP = 'W2750T10', RkdRIC = 'ECOb.TE', RkdDisplayRIC = 'ECOb.TE', RkdCode = 83882.0, RkdIssueID = 1.0, RkdIssueCode = 105737.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'AKT', RkdExchCtry = 'SWE' WHERE SecCode = 654456 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 703056 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00B3QXB771', RkdTicker = 'RKS', RkdSEDOL = 'B3QXB7', RkdCUSIP = 'G7614T10', RkdRIC = '9CU.SG^G20', RkdDisplayRIC = '9CU.SG', RkdCode = 90622.0, RkdIssueID = 1.0, RkdIssueCode = 113817.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BWB', RkdExchCtry = 'DEU' WHERE SecCode = 1153320 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 1225954 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'C0GC2T1' WHERE SecCode = 1499149 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2286223 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 2469419 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'CHE' WHERE SecCode = 2534064 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 2700712 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 3200920 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3378303 AND Type_ = 10;
UPDATE data_universe SET RkdSEDOL = NULL WHERE SecCode = 3401655 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3407819 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3574012 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 3666998 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'INM PARK ROSE IBER EUR0.9683' WHERE SecCode = 3738156 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = '279060.KN^I26', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2026-09-18', SecMapEndDate = '2026-09-17', PermQuoteRetireDate = '2026-09-18', endDate = '2026-09-17' WHERE SecCode = 3812315 AND Type_ = 10;
UPDATE data_universe SET OrgPermID = 6000374137.0, PriTRBCIndPermID = NULL WHERE SecCode = 3885292 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 3961773 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4307878 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4451124 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4466632 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236777414895.0, PermQuoteStatus = 'DC', ExchCode = 'AQX', PermQuoteRetireDate = '2026-04-27' WHERE SecCode = 4511455 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdDisplayRIC = NULL WHERE SecCode = 4561851 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4617629 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4702567 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4738041 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-09-16' WHERE SecCode = 4761385 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'DE000A3E5ED2', RkdTicker = 'VEZ', RkdSEDOL = 'BLH36Q', RkdCUSIP = 'D8T4KG11', RkdRIC = 'VEZ.F', RkdDisplayRIC = 'VEZ.F', RkdCode = 131055.0, RkdIssueID = 1.0, RkdIssueCode = 166253.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'FRA', RkdExchCtry = 'DEU' WHERE SecCode = 4761537 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4794498 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4800501 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 4887145 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'PALX22', PermSecMapEndDate = '2026-09-16', endDate = '2026-09-16' WHERE SecCode = 5274293 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 5410105 AND Type_ = 10;
UPDATE data_universe SET DsPrimQtSedol = 'BWGFKP7' WHERE SecCode = 5495255 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'QCR' WHERE SecCode = 5516786 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951212.0 WHERE SecCode = 5747500 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SVEAF B', DsPrimQtSedol = 'BX8KQW6' WHERE SecCode = 5959464 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 6074839 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'AC' WHERE SecCode = 6318935 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'IT0005640286', RkdSEDOL = 'BQT2DT', RkdCUSIP = 'T2R7AZ10', RkdRIC = 'BRM.MI^G26', RkdDisplayRIC = 'BRM.MI', RkdCode = 142663.0, RkdIssueID = 1.0, RkdIssueCode = 182059.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'BIT', RkdExchCtry = 'ITA', PermInstrStatus = 'DC' WHERE SecCode = 6389710 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 6472005 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 6507130 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 6865118 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6945360 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'POLAR RESOURCES AS NOK0.10' WHERE SecCode = 6974600 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7050896 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, DsCtryQtStatus = 'D', PermQuoteStatus = 'DC', SecMapEndDate = '2026-09-17', endDate = '2026-09-17' WHERE SecCode = 7050905 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000477424', RkdTicker = 'AMK', RkdSEDOL = 'BTFGZX', RkdCUSIP = 'Q0250M10', RkdRIC = 'AMK.AX', RkdDisplayRIC = 'AMK.AX', RkdCode = 145575.0, RkdIssueID = 1.0, RkdIssueCode = 186391.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASX', RkdExchCtry = 'AUS', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 7077876 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-10-23' WHERE SecCode = 7098758 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 7105088 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2009-02-04' WHERE SecCode = 10902827 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA8139211038', RkdSEDOL = 'BTTMWQ', RkdCUSIP = '81392110', RkdRIC = 'SES.TO^I26', RkdDisplayRIC = 'SES.TO', RkdCode = 80861.0, RkdIssueID = 1.0, RkdIssueCode = 102107.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'TSE', RkdExchCtry = 'CAN' WHERE SecCode = 10958979 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'TOR' WHERE SecCode = 11013283 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteRetireDate = '2026-09-18', endDate = '2026-09-18' WHERE SecCode = 11110709 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-09-22' WHERE SecCode = 11150246 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000276182.0, PriInstrPermID = 21532704350.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11152877 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000276182.0, PriInstrPermID = 21532704350.0, PriTRBCIndPermID = NULL, PermOrgIPODate = NULL WHERE SecCode = 11173973 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US76169C3088', RkdTicker = 'REXR PRB', RkdSEDOL = 'BF3FQ9', RkdCUSIP = '76169C30', RkdRIC = 'REXR_pb.K', RkdDisplayRIC = 'REXR_pb.N', RkdCode = 94556.0, RkdIssueID = 3.0, RkdIssueCode = 145371.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 2.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA' WHERE SecCode = 11178868 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11183688 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'LECRD', DsPrimQtSedol = 'BT69780' WHERE SecCode = 11199570 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BWTT722' WHERE SecCode = 11219126 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000213018.0, PermOrgIPODate = NULL WHERE SecCode = 11228666 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2026-09-17', SecMapEndDate = '2026-09-16', endDate = '2026-09-16' WHERE SecCode = 11228767 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11241045 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'IMPTF' WHERE SecCode = 11255951 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA92859L2012', PermIDTicker = NULL, RkdSEDOL = 'BNKKX4', RkdCUSIP = '92859L20', RkdRIC = 'VROY.V^I26', RkdDisplayRIC = 'VROY.V', RkdCode = 140242.0, RkdIssueID = 1.0, RkdIssueCode = 178751.0, RkdIssueType = 'C', RkdIssueStatus = 0.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CVE', RkdExchCtry = 'CAN', PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-09-17', PermSecMapEndDate = '2026-09-17' WHERE SecCode = 11268711 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US42227T3032', RkdTicker = 'HOST', PermIDTicker = 'HOST', RkdSEDOL = 'BNGC7L', RkdCUSIP = '42227T30', RkdRIC = 'HOST.K', RkdDisplayRIC = 'HOST.A', Name = 'HOST DIGITAL INC CL A', RkdCode = 140284.0, RkdIssueID = 1.0, RkdIssueCode = 178806.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'ASE', RkdExchCtry = 'USA' WHERE SecCode = 11269574 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11271848 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11273974 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11274687 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11276087 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA49848M1041', RkdTicker = 'KLN', RkdSEDOL = 'BV9BDJ', RkdCUSIP = '49848M10', RkdRIC = 'KLN.CD', RkdDisplayRIC = 'KLN.CD', RkdCode = 62125.0, RkdIssueID = 1.0, RkdIssueCode = 79620.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'CNQ', RkdExchCtry = 'CAN' WHERE SecCode = 11287301 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232941387321.0 WHERE SecCode = 11299614 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232922460668.0 WHERE SecCode = 11299690 AND Type_ = 1;
UPDATE data_universe SET IsMajorSec = 'N', PriInstrPermID = 232937214960.0 WHERE SecCode = 11301272 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236814550509.0, IsPrimaryQuote = 1.0, ExchCode = 'NAS' WHERE SecCode = 11301778 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ASBH', QuotePermID = 236814399878.0, InstrPermID = 232952740309.0, OrgPermID = 4297083618.0, PriTrdQuotePermID = 236814399878.0, PriValQuotePermID = 25726989993.0, PriInstrPermID = 232952740309.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951386.0, PermOrgIPODate = '2026-09-16', PermSecMapStartDate = '2026-09-12', startDate = '2026-09-12' WHERE SecCode = 11301784 AND Type_ = 1;