Write a SQL command to find the stocks with average daily volume larger than 1 million shares.Write a Hive query to find the top 3 stocks by volume and whose symbol start with the first letter of your name.

1. Load the large stocks dataset ) into HDFS and use the dataset to create a Hive table using the location attribute.

2. Write a SQL command to find the stocks with average daily volume larger than 1 million shares.

3. Write a Hive query to find the top 3 stocks by volume for the year 2004.

4. Write a Hive query to find the top 3 stocks by volume and whose symbol start with the first letter of your name.

5. Write a Hive query to find all the stocks symbols whose closing price is larger than your age.

6. Write a Hive query to find the top 10 stocks with largest intraday price change  and also display the amount of the change.

Last Completed Projects