BigQuery - Time Travel

Run a query against the table to get the data from the state the table was in at the given timestamp.

e.g.
This would show the data from 1 hour ago.

SELECT
  *
FROM
  `<database>.<schema>.<table>`
  FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 HOUR);