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 specified date (mm/dd/yyyy) of the stock data. |
| ticker | varchar | The stock ticker symbol (e.g., AAPL) for the corresponding company. |
| open | decimal | The opening price of the stock at the start of the trading day. |
| high | decimal | The highest price reached by the stock during the trading day. |
| low | decimal | The lowest price reached by the stock during the trading day. |
| close | decimal | The closing price of the stock at the end of the trading day. |
Example Input:
| date | ticker | open | high | low | close |
|---|---|---|---|---|---|
| 01/31/2023 00:00:00 | GOOG | 89.83 | 101.58 | 85.57 | 99.87 |
| 02/28/2023 00:00:00 | GOOG | 99.74 | 108.82 | 88.86 | 90.30 |
| 03/31/2023 00:00:00 | GOOG | 90.16 | 107.51 | 89.77 | 104.00 |
| 04/30/2023 00:00:00 | GOOG | 102.67 | 109.63 | 102.38 | 108.22 |
| 05/31/2023 00:00:00 | GOOG | 107.72 | 127.05 | 104.50 | 123.37 |
Solution
PostgreSQL 14