Hive - Project

17 / 17

Step 3 - Write Queries

Now, as you have successfully loaded the data into the table. Please complete the below queries based on the table data.


Fill in the blanks to complete the queries. Please input text in lowercase.

Complete the following queries:

Q1: This query should give unique symbols

select  symbol  nyse

Q2: This query should give out two columns: symbol and average open price for each symbol.

select , (price_open) AS avg_price  nyse  symbol;

Answer some more questions related to the data:

Q3: The symbol for which the price_open was maximum:  and the maximum was on this date in yyyy-mm-dd format: 

Q4: The symbol that has the maximum change in price in the most recent month: