Question
Description- Data Sets: NASDAQ Exchange Daily 1970-2010 Open, Close, High, Low and Volume Download links: NASDAQ_dividends_A.csv (Links to an external site.)Links to an external site.
Description-
Data Sets: NASDAQ Exchange Daily 1970-2010 Open, Close, High, Low and Volume
Download links: NASDAQ_dividends_A.csv (Links to an external site.)Links to an external site. NASDAQ_daily_prices_A_sample.csv (Links to an external site.)Links to an external site.
Summary of data: There are two types of data
File name starting with NASDAQ_daily_prices*: These files is a CSV (comma seperated values) file which contains following fields which are self-explanatory.
exchange, stock_symbol,date, stock_price_open, stock_price_high, stock_price_low, stock_price,_close, stock_volume, stock_price_adj_close
File name starting with NASDAQ_daily_prices*: These files is a CSV (comma separated values) file which contains following fields which are self-explanatory.
exchange, stock_symbol, date,dividends
Find the Solution for following problems
Create an external table for NASDAQ daily prices data set.
Create an external table for NASDAQ dividends data set.
Find out total volume sale for each stock symbol which has closing price more than $5.
Find out highest price in the history for each stock symbol.
Find out highest dividends given for each stock symbol in entire history.
Find out highest price and highest dividends for each stock symbol if highest price and highest dividends exist.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started