UPDATE data_universe SET PermIDTicker = 'KFX', QuotePermID = 21475562628.0, ExchCode = 'VTX', PermQuoteRetireDate = '2009-02-02', endDate = '2009-02-02' WHERE SecCode = 3735 AND Type_ = 10;
UPDATE data_universe SET Name = 'DIME COML BANCSHARES INC COM' WHERE SecCode = 10388 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951384.0 WHERE SecCode = 10938 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 12512 AND Type_ = 1;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 32631 AND Type_ = 1;
UPDATE data_universe SET Name = 'PEOPLE INC COM NEW' WHERE SecCode = 34455 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 21474913868.0, ExchCode = 'BUR' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '1980-03-17' WHERE SecCode = 49041 AND Type_ = 1;
UPDATE data_universe SET SecMapEndDate = '2026-06-05' WHERE SecCode = 49578 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'USA' WHERE SecCode = 60083 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-05', endDate = '2026-06-05' WHERE SecCode = 68823 AND Type_ = 1;
UPDATE data_universe SET ISIN = NULL, Name = 'GANSU SHANGFENG MA ''A''CNY1' WHERE SecCode = 69208 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 73192 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951445.0 WHERE SecCode = 73402 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951910.0 WHERE SecCode = 78159 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'BSIN', RkdRIC = 'BSIN.O', RkdDisplayRIC = 'BSIN.OQ' WHERE SecCode = 78205 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 88193 AND Type_ = 10;
UPDATE data_universe SET PrimaryIssueType = 'PVT' WHERE SecCode = 94475 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'VREOD', SecMapEndDate = '2079-06-06', PermSecMapEndDate = '2026-06-05', endDate = '2026-06-05' WHERE SecCode = 95324 AND Type_ = 1;
UPDATE data_universe SET Name = 'LASSILA & TIKANOJ NPV' WHERE SecCode = 99925 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21898260294.0, ExchCode = 'BCO' WHERE SecCode = 100332 AND Type_ = 10;
UPDATE data_universe SET Name = 'POPEES BABY CARE INR10' WHERE SecCode = 116617 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'AUDR.BO', RkdDisplayRIC = 'AUDR.BO' WHERE SecCode = 125762 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'AKN', PermIDTicker = 'AKN', RkdRIC = 'AKN.L', RkdDisplayRIC = 'AKN.L' WHERE SecCode = 132696 AND Type_ = 10;
UPDATE data_universe SET DomCntry = 'IND' WHERE SecCode = 135522 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951910.0 WHERE SecCode = 145059 AND Type_ = 10;
UPDATE data_universe SET PriValQuotePermID = 21629642716.0 WHERE SecCode = 146206 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 55846008505.0, ExchCode = 'STU', PermQuoteRetireDate = '2018-10-31', endDate = '2018-10-31' WHERE SecCode = 147917 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'SHUAIBA' WHERE SecCode = 243506 AND Type_ = 10;
UPDATE data_universe SET Name = 'CRITICAL ELEMENTS LITHIUM CO COM' WHERE SecCode = 282135 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 55838777196.0, PermQuoteStatus = 'AC', ExchCode = 'HAM', PermQuoteRetireDate = NULL, PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 301431 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951949.0 WHERE SecCode = 391407 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 404901 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2008-07-04' WHERE SecCode = 406383 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHINA WOOD INTL HKD0.01' WHERE SecCode = 558056 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951254.0 WHERE SecCode = 726788 AND Type_ = 10;
UPDATE data_universe SET Name = 'CRAFTROOT RETL LTD INR10' WHERE SecCode = 1204807 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'TH1080C10Z02', RkdSEDOL = 'BLNL7G', DsPrimQtSedol = 'BLNL7G1', PermSecMapEndDate = '2026-06-05', endDate = '2026-06-05' WHERE SecCode = 1485605 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'BRDGl', QuotePermID = 21531119071.0, ExchCode = 'BCO', PermQuoteRetireDate = '2014-03-20' WHERE SecCode = 1511749 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05' WHERE SecCode = 2189779 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951504.0 WHERE SecCode = 2920445 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermSecMapEndDate = '2026-06-04' WHERE SecCode = 3101370 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3114312 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-08' WHERE SecCode = 3207291 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21597458276.0, ExchCode = 'BER', PermQuoteRetireDate = '2020-07-27', endDate = '2020-07-27' WHERE SecCode = 3255119 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3318319 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'VEONa', QuotePermID = 21610682901.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-03-11' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951698.0 WHERE SecCode = 3396703 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951812.0 WHERE SecCode = 3435659 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951981.0 WHERE SecCode = 3441172 AND Type_ = 10;
UPDATE data_universe SET Name = 'E2E NETWORKS LTD INR1(POST SUBD)', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 3497959 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21572528819.0, ExchCode = 'DEU' WHERE SecCode = 3587028 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21709209289.0, ExchCode = 'AUX' WHERE SecCode = 3905192 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951601.0 WHERE SecCode = 4054210 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4362605 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 4501936 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951261.0 WHERE SecCode = 4510031 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21884462002.0, ExchCode = 'TRQ', PermQuoteRetireDate = '2024-10-22', endDate = '2024-10-21' WHERE SecCode = 4626906 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21860598463.0, ExchCode = 'BCO', PermQuoteRetireDate = '2025-10-09' WHERE SecCode = 4800907 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21892048749.0, ExchCode = 'HAN' WHERE SecCode = 4889208 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = NULL, RkdTicker = NULL, RkdSEDOL = NULL, RkdCUSIP = NULL, RkdRIC = NULL, RkdDisplayRIC = NULL, DsPrimQtSedol = 'BXFLKV9', RkdCode = NULL, RkdIssueID = NULL, RkdIssueCode = NULL, RkdIssueType = NULL, RkdIssueStatus = NULL, RkdIssueOrder = NULL, RkdListingType = NULL, RkdExchCode = NULL, RkdExchCtry = NULL, PrimaryIssueType = NULL, COATypeCode = NULL, SecMapEndDate = '2026-06-04', PermSecMapEndDate = '2026-06-05', endDate = '2026-06-04' WHERE SecCode = 5067274 AND Type_ = 10;
UPDATE data_universe SET SecMapEndDate = '2026-06-05' WHERE SecCode = 5108979 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5264846 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5398958 AND Type_ = 10;
UPDATE data_universe SET Name = 'RAMATH HOSPITALITY SAR10' WHERE SecCode = 5541698 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-08' WHERE SecCode = 6622164 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = '2026-02-06' WHERE SecCode = 6645653 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951361.0 WHERE SecCode = 6672572 AND Type_ = 10;
UPDATE data_universe SET Country = 'BMU', PermOrgIPODate = NULL WHERE SecCode = 6885945 AND Type_ = 10;
UPDATE data_universe SET Name = 'AI REVENUE ASSISTA NPV' WHERE SecCode = 6893660 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryQuote = 1.0 WHERE SecCode = 6897222 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'GB00BXFLKV95', RkdTicker = 'NMD', RkdSEDOL = 'BXFLKV', RkdCUSIP = 'G6561P10', RkdRIC = 'NMD.ASE', RkdDisplayRIC = 'NMD.ASE', DsPrimQtSedol = 'BXFLKV9', RkdCode = 133555.0, RkdIssueID = 1.0, RkdIssueCode = 169744.0, RkdIssueType = 'C', RkdIssueStatus = 1.0, RkdIssueOrder = 1.0, RkdListingType = 'OSR', RkdExchCode = 'AQS', RkdExchCtry = 'GBR', PrimaryIssueType = 'EQU', COATypeCode = 'IND', SecMapStartDate = '2026-06-05', SecMapEndDate = '2079-06-06', PermSecMapStartDate = '2026-06-05', PermSecMapEndDate = NULL, endDate = NULL WHERE SecCode = 6900861 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'CSX', ExchCode = 'CVE' WHERE SecCode = 11012454 AND Type_ = 1;
UPDATE data_universe SET PriValQuotePermID = 21495995528.0 WHERE SecCode = 11024402 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-07-07' WHERE SecCode = 11027686 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'IL0012415878', RkdCUSIP = 'M6000J19', SecMapEndDate = '2026-06-04', endDate = '2026-06-04' WHERE SecCode = 11065371 AND Type_ = 1;
UPDATE data_universe SET Name = 'ICECURE MED LTD ORD SHS NEW' WHERE SecCode = 11110620 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermOrgIPODate = NULL, PermSecMapEndDate = '2026-06-05' WHERE SecCode = 11157118 AND Type_ = 1;
UPDATE data_universe SET DomCntry = 'CHN' WHERE SecCode = 11158630 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-05', endDate = '2026-06-05' WHERE SecCode = 11181696 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US14161W3034', RkdCUSIP = '14161W30' WHERE SecCode = 11181738 AND Type_ = 1;
UPDATE data_universe SET PermSecMapEndDate = '2026-06-05', endDate = '2026-06-05' WHERE SecCode = 11183460 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA1599161058', RkdCUSIP = '15991610', DsPrimQtSedol = 'BQMJ363' WHERE SecCode = 11189015 AND Type_ = 1;
UPDATE data_universe SET Name = 'TRULIEVE CANNABIS CORP SUB VTG SHS' WHERE SecCode = 11190437 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 195000.0 WHERE SecCode = 11198134 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951350.0 WHERE SecCode = 11203252 AND Type_ = 1;
UPDATE data_universe SET Name = 'DIME COML BANCSHARES INC 5.5% NCUM PFD A' WHERE SecCode = 11204719 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG9897X1319', RkdCUSIP = 'G9897X13' WHERE SecCode = 11205267 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951449.0 WHERE SecCode = 11213191 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US31447E2046' WHERE SecCode = 11225909 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 11226938 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA8740851032', RkdTicker = 'TALA', RkdCUSIP = '87408510', RkdRIC = 'TALA.V', RkdDisplayRIC = 'TALA.V', DsPrimQtSedol = 'BQMJ385', SecMapEndDate = '2079-06-06', endDate = NULL WHERE SecCode = 11229681 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US1827443003', RkdCUSIP = '18274430' WHERE SecCode = 11238076 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'SELX.OQ' WHERE SecCode = 11243110 AND Type_ = 1;
UPDATE data_universe SET QuotePermID = 236776474518.0, IsPrimaryQuote = 0.0, ExchCode = 'CES', PermSecMapStartDate = '2022-06-24', PermSecMapEndDate = '2026-06-03' WHERE SecCode = 11245859 AND Type_ = 1;
UPDATE data_universe SET ExchCode = 'NAS' WHERE SecCode = 11268806 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC', PermQuoteRetireDate = '2026-06-05', PermSecMapEndDate = '2026-06-05', endDate = '2026-06-05' WHERE SecCode = 11277617 AND Type_ = 1;
UPDATE data_universe SET PermQuoteRetireDate = '2026-06-08' WHERE SecCode = 11277958 AND Type_ = 1;
UPDATE data_universe SET DsPrimQtSedol = 'BSGYW16' WHERE SecCode = 11279727 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'LUNR.TO', RkdDisplayRIC = 'LUNR.TO', RkdExchCode = 'TSE', ExchCode = 'TOR' WHERE SecCode = 11289698 AND Type_ = 1;
UPDATE data_universe SET SecMapStartDate = '2026-02-28' WHERE SecCode = 11292682 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11295229 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951281.0 WHERE SecCode = 11295817 AND Type_ = 1;
UPDATE data_universe SET PriInstrPermID = 232933217084.0 WHERE SecCode = 11296313 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11296373 AND Type_ = 1;
UPDATE data_universe SET Name = 'ENVIRI CORP COM' WHERE SecCode = 11296509 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'JAY', QuotePermID = 236807904923.0, InstrPermID = 232883560258.0, OrgPermID = 5095329410.0, PriValQuotePermID = 236807904923.0, PriInstrPermID = 232883560258.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'CVE', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'CAN', IncCntry = 'CAN', PriTRBCIndPermID = 4294951922.0, PermOrgIPODate = '2026-06-04', PermSecMapStartDate = '2026-06-03', startDate = '2026-06-03' WHERE SecCode = 11296975 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'QNT', QuotePermID = 236807983895.0, InstrPermID = 232936195992.0, OrgPermID = 6000125980.0, PriTrdQuotePermID = 236807983895.0, PriValQuotePermID = 25727019470.0, PriInstrPermID = 232936195992.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NMS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951211.0, PermOrgIPODate = '2026-06-04', PermSecMapStartDate = '2026-06-04' WHERE SecCode = 11297031 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'SSMR', QuotePermID = 236807886679.0, InstrPermID = 232936143699.0, OrgPermID = 5096966410.0, PriTrdQuotePermID = 236807886679.0, PriValQuotePermID = 25727019933.0, PriInstrPermID = 232936143699.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'USA', PriTRBCIndPermID = 4294951916.0, PermOrgIPODate = '2026-06-04', PermSecMapStartDate = '2026-06-02', startDate = '2026-06-02' WHERE SecCode = 11297036 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'ETSS', QuotePermID = 236807886717.0, InstrPermID = 232902122712.0, OrgPermID = 5096827317.0, PriTrdQuotePermID = 236807886717.0, PriValQuotePermID = 25727019873.0, PriInstrPermID = 232902122712.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NYS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-15', PermSecMapStartDate = '2026-06-02', startDate = '2026-05-15' WHERE SecCode = 11297053 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = 'PECE', QuotePermID = 236807904915.0, InstrPermID = 232911343828.0, OrgPermID = 5096920868.0, PriTrdQuotePermID = 236807904915.0, PriValQuotePermID = 25727019778.0, PriInstrPermID = 232911343828.0, IsPrimaryQuote = 1.0, IsPrimaryInstr = 1.0, PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'NAS', QuoteClass = 'ORD', InstrClass = 'ORD', OrgTypeCode = 'COM', DomCntry = 'USA', IncCntry = 'CYM', PriTRBCIndPermID = 4294951348.0, PermOrgIPODate = '2026-05-22', PermSecMapStartDate = '2026-06-03', startDate = '2026-05-22' WHERE SecCode = 11297056 AND Type_ = 1;
