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
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
Anyone who has the link will be able to view this.