UPDATE data_universe SET PermQuoteRetireDate = '2026-04-06' WHERE SecCode = 39762 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21532854931.0, ExchCode = 'AQX' WHERE SecCode = 45820 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 19515.0 WHERE SecCode = 59237 AND Type_ = 10;
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 OrgTypeCode = 'CINV' WHERE SecCode = 60863 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'CINV' WHERE SecCode = 60864 AND Type_ = 1;
UPDATE data_universe SET OrgTypeCode = 'CINV' WHERE SecCode = 60865 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-04-03', PermSecMapEndDate = '2026-04-02' WHERE SecCode = 67013 AND Type_ = 10;
UPDATE data_universe SET RkdCUSIP = 'Q496BR17' WHERE SecCode = 77877 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 81073 AND Type_ = 10;
UPDATE data_universe SET Name = 'TOHO SYSTEM SCIENC NPV' WHERE SecCode = 82893 AND Type_ = 10;
UPDATE data_universe SET Name = 'ARCHION CORP NPV' WHERE SecCode = 83142 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IND' WHERE SecCode = 84726 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'ATI.H', PermIDTicker = 'ATI.H', RkdRIC = 'ATIh.V', RkdDisplayRIC = 'ATIh.V', RkdExchCode = 'NEX', ExchCode = 'NEX' WHERE SecCode = 90302 AND Type_ = 1;
UPDATE data_universe SET RkdIssueOrder = 1.0, RkdListingType = 'OSR' WHERE SecCode = 100020 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21474873619.0, PermQuoteRetireDate = '2017-05-22' WHERE SecCode = 114277 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837424519.0, ExchCode = 'TYO' WHERE SecCode = 115378 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 123699 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836323663.0, ExchCode = 'BER', PermQuoteRetireDate = '2016-03-04', endDate = '2016-03-03' WHERE SecCode = 141320 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'OEIG.I', QuotePermID = 21475589551.0, PermQuoteStatus = 'DC', ExchCode = 'CFR', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 141633 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836323845.0, ExchCode = 'BER', PermQuoteRetireDate = '2018-10-03' WHERE SecCode = 142529 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NIMBSPROJ', QuotePermID = 236805232448.0, PriValQuotePermID = 236805232448.0, ExchCode = 'NSI' WHERE SecCode = 142539 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21475425493.0, ExchCode = 'POS' WHERE SecCode = 142661 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55837367607.0, ExchCode = 'GER', PermQuoteRetireDate = '2011-05-28', endDate = '2011-05-28' WHERE SecCode = 150698 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55836450746.0, ExchCode = 'FRA' WHERE SecCode = 161397 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21528682235.0, ExchCode = 'QMF', PermQuoteRetireDate = '2012-09-03', endDate = '2012-08-31' WHERE SecCode = 164836 AND Type_ = 10;
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 = 21798248748.0, ExchCode = 'DEU' WHERE SecCode = 186452 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21830289175.0, ExchCode = 'GTX' WHERE SecCode = 201949 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-06' WHERE SecCode = 255791 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'KETO.BO', RkdDisplayRIC = 'KETO.BO', DsCtryQtStatus = 'S' WHERE SecCode = 786648 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 2311287 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21540177743.0, ExchCode = 'TRQ' WHERE SecCode = 2397369 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21655828179.0, ExchCode = 'FRA' WHERE SecCode = 3317366 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21685853416.0, ExchCode = 'STO' WHERE SecCode = 3540514 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueCode = 120724.0 WHERE SecCode = 4001161 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-07' WHERE SecCode = 4049121 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236791494702.0, PermQuoteStatus = 'AC', ExchCode = 'JAX', PermQuoteRetireDate = NULL, endDate = NULL WHERE SecCode = 4365821 AND Type_ = 10;
UPDATE data_universe SET Name = 'EBR SYSTEMS INC NPV DFD 10/04/26(EX-SPLT)' WHERE SecCode = 4780386 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-02' WHERE SecCode = 5511073 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-04-06' WHERE SecCode = 5513352 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC', PermSecMapEndDate = '2026-04-02' WHERE SecCode = 5678867 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 22099147197.0, ExchCode = 'DEU' WHERE SecCode = 6240409 AND Type_ = 10;
UPDATE data_universe SET Name = 'FII RIOB' WHERE SecCode = 6258207 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6628819 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6638309 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CNE100007F07', RkdTicker = '2768', RkdSEDOL = 'BWRQ5B', RkdCUSIP = 'Y7166911', RkdRIC = '2768.HK', RkdDisplayRIC = '2768.HK', RkdCode = 144103.0, RkdIssueID = 2.0, RkdIssueCode = 184831.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'HKG', RkdExchCtry = 'HKG', PrimaryIssueType = 'EQU', PrimaryIssueCode = 98701.0, RelType = 4.0, COATypeCode = 'IND' WHERE SecCode = 6642603 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6672510 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6756389 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6756397 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SDEV' WHERE SecCode = 10924424 AND Type_ = 1;
UPDATE data_universe SET OrgPermID = 6000082980.0, PriInstrPermID = 21561829974.0, PermOrgIPODate = NULL WHERE SecCode = 11147281 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 500000.0, PermSecMapEndDate = '2026-04-03', endDate = '2026-04-03' WHERE SecCode = 11154766 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'MHY8564M1131', RkdTicker = 'SEAL PR A', RkdSEDOL = 'BZ0BDR', RkdCUSIP = 'Y8564M11', RkdRIC = 'SEAL_pa.K', RkdDisplayRIC = 'SEAL_pa.N', RkdCode = 45841.0, RkdIssueID = 5.0, RkdIssueCode = 184838.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 2.0, RkdExchCode = 'NYSE', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11163153 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'BMG162584053', RkdTicker = 'BEP.PR.M', RkdSEDOL = 'BYVW2H', RkdCUSIP = 'G1625840', RkdRIC = 'BEP_pm.TO', RkdDisplayRIC = 'BEP_pm.TO', RkdCode = 89898.0, RkdIssueID = 3.0, RkdIssueCode = 184832.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 2.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11181199 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA98420Q4051', RkdCUSIP = '98420Q40' WHERE SecCode = 11185229 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-03', endDate = '2026-04-03' WHERE SecCode = 11196048 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 0.6667 WHERE SecCode = 11197385 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US4869171078', RkdTicker = 'KEEL', PermIDTicker = 'KEEL', RkdCUSIP = '48691710', RkdRIC = 'KEEL.TO', RkdDisplayRIC = 'KEEL.TO', DsPrimQtSedol = 'BS2DWC8' WHERE SecCode = 11198774 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-03', endDate = '2026-04-03' WHERE SecCode = 11204164 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'BMG162582313', RkdCUSIP = 'G1625823', RkdCode = 89898.0, RkdIssueID = 4.0, RkdIssueCode = 184833.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 3.0, RkdExchCode = 'NA', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11205405 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-03', endDate = '2026-04-03' WHERE SecCode = 11206308 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'QH.OQ', PermQuoteRetireDate = '2026-04-06' WHERE SecCode = 11209704 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-03', endDate = '2026-04-03' WHERE SecCode = 11216256 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-03', endDate = '2026-04-03' WHERE SecCode = 11216266 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'SBDS.N', PermQuoteRetireDate = '2026-04-06' WHERE SecCode = 11232870 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-03', endDate = '2026-04-03' WHERE SecCode = 11238338 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'BMG162582644', RkdTicker = 'BEP.PR.R', RkdSEDOL = 'BMF1MJ', RkdCUSIP = 'G1625826', RkdRIC = 'BEP_pr.TO', RkdDisplayRIC = 'BEP_pr.TO', RkdCode = 89898.0, RkdIssueID = 5.0, RkdIssueCode = 184834.0, RkdIssueType = 'P', RkdIssueStatus = 1.0, RkdIssueOrder = 4.0, RkdExchCode = 'TSE', RkdExchCtry = 'CAN', PrimaryIssueType = 'EQU', COATypeCode = 'IND' WHERE SecCode = 11240881 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-03', endDate = '2026-04-03' WHERE SecCode = 11270459 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-03', endDate = '2026-04-03' WHERE SecCode = 11272366 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-04-03', endDate = '2026-04-03' WHERE SecCode = 11273677 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232915403868.0 WHERE SecCode = 11291838 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11291840 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232908163730.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11291896 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232913258244.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11291897 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232905105054.0, IsPrimaryInstr = 0.0 WHERE SecCode = 11292080 AND Type_ = 1;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 11293456 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US40445M1009', RkdTicker = 'HMH', RkdSEDOL = 'BTHVSL', RkdCUSIP = '40445M10', RkdRIC = 'HMH.O', RkdDisplayRIC = 'HMH.OQ', RkdCode = 144613.0, RkdIssueID = 1.0, RkdIssueCode = 184841.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'NASD', RkdExchCtry = 'USA', PrimaryIssueType = 'EQU', COATypeCode = '' WHERE SecCode = 11293952 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'TMTS', ModelCntry = 'US', QuotePermID = 236805245436.0, InstrPermID = 232913645899.0, OrgPermID = 5097119192.0, PriTrdQuotePermID = 236805245436.0, PriValQuotePermID = 25727028487.0, PriInstrPermID = 232913645899.0, IsPrimaryQuote = 0.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-02-11', PermSecMapStartDate = '2026-04-02', startDate = '2026-02-11' WHERE SecCode = 11294069 AND Type_ = 1;
