Last record of the same group

I think there are similar questions but none of them really matches my case. I tried left outer join to get the latest status but then I can't get the latest record based on the parent id grouping.

I have the following tables

Document table

Document history table

What query gives me the following table
(group with parent_id1 and parent_id2)

So docs that have the same parent_id1 and parent_id2 are different versions of the same doc so we only interested in the latest version based on timestamp. We also need their latest status from the history table based on the timestamp (one to many)

Using inner join and group by we can do it as follows :

select h3.*, h2.status
from history h2
inner join (
  select t.id, t.version_name, t.parnet_id1, t.parent_id2, max(h.timestamp) as timestamp
  from history h
  inner join (
    select d.id, d.version_name, d.parnet_id1, d.parent_id2
    from document d
    inner join (
      select parnet_id1, parent_id2, max(timestamp) as timestamp
      from document
      group by parnet_id1, parent_id2
    ) as s on s.parnet_id1 = d.parnet_id1 and s.parent_id2 = d.parent_id2 and s.timestamp = d.timestamp
  ) t on t.id = h.document_id
  group by t.id, t.version_name, t.parnet_id1, t.parent_id2
) as h3 on h2.document_id = h3.id and h3.timestamp = h2.timestamp

Demo here