WITH price_history AS (
SELECT stock_ticker, timestamp, open, high, low, close, volume,
LAG(open) OVER (PARTITION BY stock_ticker ORDER BY timestamp) as prev_open,
LAG(high) OVER (PARTITION BY stock_ticker ORDER BY timestamp) as prev_high,
LAG(low) OVER (PARTITION BY stock_ticker ORDER BY timestamp) as prev_low,
LAG(close) OVER (PARTITION BY stock_ticker ORDER BY timestamp) as prev_close
FROM stock_prices
)
SELECT DISTINCT t.stock_ticker FROM technical_indicators t
JOIN price_history sp ON t.stock_ticker = sp.stock_ticker
WHERE t.calculation_date = CURRENT_DATE
AND (
);