Hi, I am trying to retrieve stock prices and volume data for S&P 500 constituent stocks (0#.SPX) at a particular date using the following code:
rd.get_data('{}({})'.format(universe, date), ['TR.CompanyMarketCap(SDATE={}).date'.format(date), 'TR.RIC', 'TR.CompanyMarketCap(SDATE={})'.format(date), 'TR.PRICEOPEN(SDATE={})'.format(date), 'TR.PRICEHIGH(SDATE={})'.format(date), 'TR.PRICELOW(SDATE={})'.format(date), 'TR.PRICECLOSE(SDATE={})'.format(date), 'TR.VOLUME(SDATE={})'.format(date), 'TR.CompanyMarketCap(SDATE={}).currency'.format(date)])
And I have found some irregularities within the data. For example, in PM.N stock prices at 2019-09-16. I received the following data:
{'Instrument': 'PM.N', 'Date': Timestamp('2019-09-16 00:00:00'), 'RIC': 'PM.N', 'Company Market Cap': 112953973255.2, 'Price Open': 71.95, 'Price High': 72.71, 'Price Low': 71.77, 'Price Close': 72.6, 'Volume': 1493077, 'Currency': 'USD'}
However, when comparing to official data from NASDAQ website (https://www.nasdaq.com/market-activity/stocks/pm)
the open price and volume data is clearly different. Am I using the wrong fields or is there something wrong with the data? Also where can I find the field for adjusted close price?