I’m trying to figure out how to get a sensor state that was 24h ago. Is that possible at all?

last_updated has gone in the v32 database schema: it’s last_updated_ts now which is a UNIX timestamp.