Similar to my last post, perhaps these data errors are causing by different companies using the same Ticker.
It appears that multiple tickers using same Ticker (perhaps on different exchanges, or maybe Ticker was re-used after prior company was de-listed?) may be causing some data errors. In this particular case:
3 different companies are using same Ticker 'ES':
-- Ticker: 'ES'
-- 3 different SimFinID: '446632' and '378141' and '822439'
-- '446632' is EnergySolutions
-- '378141' (Eversource Energy)
-- '822439' (NSTAR ELECTRIC)
(actually Eversource Energy and NSTAR ELECTRIC merged in 2012 and NSTAR is now subsidiary of Eversource. Probably shouldn't have own SimFin ID I'm guessing?)
(It's additionally confusing because they are all in the same IndustryCode (Utilities, 105001).)
I am finding errors in the Share Price data. There are Share Price records for both Eversource Energy (378141) and EnergySolutions (446632); however, the actual data seems to all refer to Eversource Energy share prices only. In fact, EnergySolutions 446632 was taken private in 2013 so there shouldn't be any more Share Prices after that. But even the data before 2013 seems to be duplicated from Eversource, and is not accurate for EnergySolutions.