Download the following files:
The daily_prices file contains stock ticker symbols and opening, high, low and closing prices, as well as sales volumes.
The dividends file contains stock ticker symbols and dividend amounts.
Only a subset of stocks have dividends, so the stocks in the files do not match one-for-one.
Line one of each file is a header row that shows which column is which.
For every stock that pays a dividend, calculate the Market Capitalization (volume * closing price) for each day at the stock market’s closing bell. Identify which dividend-paying stock had the highest Market Capitalization of them all.
By way of example, based on the samples below, NGI and NAV are dividend-paying stocks, but NEX is not. Calculating the Market Capitalizations (MC) for NGI and NAV, the highest MC is NGI’s with an 200592, thus the answer is NGI
35.05 * 5500 = 192774.9
35.02 * 5400 = 189108.0
41.22 * 3900 = 160758.0
41.64 * 4800 = 199872.0
41.79 * 4800 = 200592.0
SAMPLE prices file:
SAMPLE dividends file: