Format Timestamps in Parquet Files Online
Reformat timestamp and date columns in Parquet files directly in your browser. Convert between ISO 8601, Unix epoch, US date, and custom strftime patterns — no upload required.
About this tool
Convert date and timestamp columns in a Parquet file from one format to another — ISO 8601, Unix epoch, US date, EU date, or a custom strftime pattern. Useful before loading data into databases or BI tools with strict format requirements.
Frequently Asked Questions
What timestamp formats does the Parquet timestamp tool support?
ISO 8601, Unix epoch (seconds and milliseconds), US date (MM/DD/YYYY), European date (DD/MM/YYYY), and any custom format using strftime patterns.
What if the tool does not recognise the date format in my Parquet file?
Enter a custom strftime pattern in the format field. For example %d/%m/%Y %H:%M:%S matches 31/12/2024 23:59:59. The strftime reference covers all supported tokens.
Does the Parquet timestamp tool convert time zones?
No. The tool reformats how a timestamp is displayed but does not shift values between time zones. For timezone conversion use the SQL Query tool with AT TIME ZONE.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Parse URL Column in Parquet Files Online
Parse URL columns in Parquet files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.
Add Lag / Lead Column to Parquet Files Online
Add a LAG or LEAD column to Parquet files to shift any column forward or backward by N rows. See previous day's sales, next value in a sequence, or any time-shifted comparison — runs entirely in your browser.
Filter by Date Range Parquet Files Online
Filter Parquet files to rows within a date range using simple start and end date pickers. See a live match count before you apply the filter — no upload required, runs in your browser.
Compute Correlation Matrix for Parquet Files Online
Compute a Pearson correlation matrix for numeric columns in Parquet files directly in your browser. Instantly spot which variables move together — colour-coded heatmap, no upload required.
Find Fuzzy Duplicates in Parquet Files Online
Find near-duplicate rows in Parquet files using Levenshtein edit distance or Jaro-Winkler similarity — all in your browser. Set your own threshold and download the matched pairs as CSV — no upload required.