how can I delete my purchase history

You cannot delete a subscription that you have canceled.

This will disappear from your purchases after about a year.

But you can hide the subscription history, see -> Hide purchases from the App Store

Hide purchases from the App Store – Apple Support (UK)

You cannot do that.

But since you’re the only person using your Apple ID, that should not matter.