Write a hive query to find the top 10 stocks with largest intraday price change (difference between high and low price during a trading day) and also display the amount of the change.

Posted: November 7th, 2022

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

1. Load the large stocks dataset (400 MB) 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 (example for Saber, it is symbols starting with “S”).
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 (difference between high and low price during a trading day) and also display the amount of the change.

For This or a Similar Paper Click To Order Now