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;
All Tables
Database

Table

Metadata
commodities oil_brent_daily
commodities oil_wti_daily
crypto fact_coin_price_history
real_estate freddie_mac_house_price_index
stocks company
stocks nasdaq_listed
stocks s_and_p_500
stocks stock_price
stocks stock_price_history_daily