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.
Column Name | Type | Description |
---|---|---|
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. |
date | ticker | open | high | low | close |
---|---|---|---|---|---|
08/01/2023 00:00:00 | GOOG | 130.85 | 132.92 | 127.78 | 130.17 |
07/01/2023 00:00:00 | GOOG | 120.32 | 134.07 | 115.83 | 133.11 |
06/01/2023 00:00:00 | GOOG | 123.50 | 129.55 | 116.91 | 120.97 |
05/01/2023 00:00:00 | GOOG | 107.72 | 127.05 | 104.50 | 123.37 |
04/01/2023 00:00:00 | GOOG | 102.67 | 109.63 | 102.38 | 108.22 |
PostgreSQL 14