Creating historization table to capture Incremental load using pyspark

I would like to create a historical table for a snapshot data each time a new transaction is performed on an id

As an output i'm looking for a table like this