Short answer
HubSpot's KB: the export includes only records that had or have a value, with current and historical values and when they changed. Dates are in UTC. It needs CRM Export and Object Edit All permissions, and revision history is limited per object.
1. In HubSpot
The relevant screen in my demo portal.

2. Worth knowing
For one record, the property history panel is quicker.