A FRED-inspired Electron desktop app for visualising, transforming, storing, and managing time-series data. Built with React, TypeScript, and SQLite for financial data analysis — with support for multiple databases, custom transforms, and full session persistence.
Overview
Epoch organises everything into 3 tabs. Each one solves a distinct part of the workflow — from importing raw data to browsing a multi-source database library — without getting in the way of the others.
Multi-series charts with zoom, pan, crosshair, drag-select range, and a range of transformations applicable to time series data.
Drop a CSV or Excel file, or paste tabular data directly. The app parses the data and auto-detects date formats, data types, etc. You can then review and commit the data to the database or simply add it to a graph.
Browse, edit, and delete series across internal and external SQLite databases.
Workflow
Step 01 — Import
Drop a CSV or Excel file onto the Upload tab, or paste directly from a spreadsheet. Epoch parses multiple columns in one go, auto-detects date formats, deduplicates column codes, and strips trailing blank columns from Excel exports.
Step 02 — Review
Before any series lands in the database or one of your graphs, a review panel lets you edit the name, unique code, description, detected frequency, and data type.
Step 03 — Visualise
Add any saved series to the Graph tab. Scroll to zoom the Y-axis, scroll horizontally to pan the time range, or drag-select a window. Double-click resets to full range. Once your chart looks how you want it to, you can save it for later use, or even export it to share with other Epoch users as a .tsv-graph file.
Step 04 — Transform
Apply transformations to your time series data at the click of a button. Add Moving Averages, Time-shifts, Multipliers, and more.
Step 05 — Persist
Series are stored in a local SQLite database. The entire graph state — zoom range, active series, transforms, moving averages, colors — is auto-saved every 1.5 seconds and fully restored on the next launch. External .db files on network shares can be added as read/write data sources. They are fully modifyable within the app and shareable.
Stack
Download
Installs Epoch with a desktop shortcut. I don't have a developper license yet so you'll have to manually approve the installer by left clicking the file > Properties > Unblock. After that, the app will download updates automatically.
Download (.exe)Windows · ~80 MB · GitHub Releases