This thread should be applicable: DATE format support while loading data from PARQUET file which located in S3
We convert Parquet int96 timestamps to a format directly compatible with e.g. DATETIME, but Parquet writers can also represent times as plain old integer parquet values representing offsets from 1970-01-01, and we don’t yet perform automatic conversion for those. The workaround is to use timestampadd() as described, comparing the integer values against the expected date to guess what unit the integer offset is in, and whether the time should be interpreted as UTC or as local timezone time.