Baselight
SELECT ticker, adj_close, "date" 
FROM @blt.joebeachcapital_s_and_p500_index_stocks_daily_updated.sp500_data 
WHERE "date" = (SELECT MAX("date") FROM @blt.joebeachcapital_s_and_p500_index_stocks_daily_updated.sp500_data)
ORDER BY adj_close DESC 

Share link

Anyone who has the link will be able to view this.