Back to questions
The Bloomberg terminal is the go-to resource for financial professionals, offering convenient access to a wide array of financial datasets. In this SQL interview query for Data Analyst at Bloomberg, you're given the historical data on Google's stock performance.
Your task is to:
This question serves as a platform for you to explore into the dataset and execute your queries. Please refrain from submitting your solution for this question.
|date||datetime||The specific date and time of the stock data.|
|ticker||varchar||Indicates the stock ticker symbol (e.g., GOOG) for the corresponding company.|
|open||decimal (5,2)||The opening price of the stock on that particular date.|
|high||decimal (5,2)||The highest price reached by the stock during the day.|
|low||decimal (5,2)||The lowest price reached by the stock during the day.|
|close||decimal (5,2)||The closing price of the stock at the end of the trading day.|