SQL · Bloomberg · Medium
Problem You are given a table stock_prices that holds daily OHLC (open, high, low, close) data for a set of FAANG stocks. Table: stock_prices Each row represents one trading day for one ticker. The combination (date, ticker) is unique. Task For every FAANG ticker, compute the month-over-month percentage change in its closing price. For a given ticker and calendar month, use the closing price from the last trading day of that month. Only include months that have a preceding…
Checking your access…