Back to questions
SQL Tutorial Lesson: Stock Performance [Bloomberg SQL Interview Question]
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:
- Calculate the difference in closing prices between consecutive months.
- Calculate the difference between the closing price of the current month and the closing price from 3 months prior.
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.
Schema:
| 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. |
Example Input:
| 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 |
Solution
PostgreSQL 14