Select the most recent record (of many items) with PostgreSQL
blog.timescale.com