So your query on your data should be something like...

SELECT TIMESTAMP_SECONDS(CAST(last_opened_time AS int64)) AS last_opened_at FROM sample;