SmartQueryTools

Add Moving Average to Parquet Files Online

Add a moving average, rolling sum, rolling min, or rolling max column to Parquet files directly in your browser. Choose window size, order-by column, and optional partitioning — no upload required.

About this tool

Smooth time-series data in a Parquet file by adding a Simple Moving Average (SMA) or Exponential Moving Average (EMA) column. Set your window size, choose the value column and an order-by column, and download the result with the rolling average appended. Common for trend analysis, noise reduction, and financial chart preparation. Runs locally in your browser.

Frequently Asked Questions

What types of moving average does the Parquet moving average tool calculate?

Simple Moving Average (SMA, equal weight to all values in the window) and Exponential Moving Average (EMA, more weight to recent values). Both require a window size. The result is appended as a new column alongside the original data.

What window size should I use for a moving average on a Parquet file?

Common choices are 7 for a weekly rolling average on daily data, 30 for a monthly rolling average, or 12 for a yearly rolling average on monthly data. Smaller windows react faster to changes; larger windows produce a smoother trend but lag behind recent movements.

How are the first rows handled in the Parquet moving average — the rows without enough history?

Rows that do not have enough prior rows to fill the window receive NULL by default. Enable the partial window option to compute the average over however many rows are available at the start of the series instead of leaving them null.

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