SELECT date, max(msft), max(aapl) FROM (SELECT date, case when symbol = 'MSFT' then close end as msft, case when symbol = 'AAPL' then close end as aapl FROM stocks.stock_price_history_daily WHERE symbol in ('MSFT', 'AAPL') ORDER BY date desc limit 30) as sub1 GROUP BY date;