The Timeseries Refinery#
The Timeseries Refinery is a platform to store, transform and monitor time series data. It keeps a full revision history of every series — enabling time-travel and backtesting — centralizes data from internal silos and external APIs, and exposes a shared, curated catalog to its users, from Python, the browser, Excel or an MCP server.
At a glance, the Refinery lets you:
store versioned time series with full history (time-travel, backtesting);
centralize data from internal silos and external APIs, queried on the fly or scraped on schedule;
automate data processes (ETL, predictions, computations, sanity checks…);
aggregate and transform series with formulas;
build a common catalog — a shared, curated data referential.
Content
- Getting Started
- Installation
- Overview
- Working with the Refinery
- Basics
- General setup reminder
- How to create / update / read “primary” time series
- How to Exists / Rename / Delete time series
- Going further: playing with revisions
- Adding and fetching metadata
- Using formulas : create a formula
- Similarities and differences with primary series
- Using the formula editor
- Seeing all the formulas
- Create a time series information system
- To the next level
- Doing your own app using the Refinery
- Data acquisition: a structured path
- Performance aspects: stored time series and formulas
- Formulas: when to use a cache/materialized view
- How to cache formulas
- Tasks system: how to organize and schedule tasks
- Data architecture at scale: putting the Data Mesh to work
- Basics
- Core Components
- Working with series in Python
- Table of Contents
- Creating a series
- Updating a series
- Working with versions
- Point and version erasure
- Retrieving history
- Working with metadata
- Replacing a series entirely
- Checking series existence
- Renaming a series
- Deleting a series
- Finding series
- Getting series information
- Working with logs
- Staircase operations
- Time Series Operations API
- Working with series in the browser
- Supervision
- Formulas (computed series)
- Formula Language Reference
- Formula cache
- Groups
- Folders
- Search Query Language Reference
- Task Manager Operations
- Time Series Monitoring
- Excel addin
- Testing
- Dashboards
- The MCP server
- Securing the Refinery
- Settings
- Working with series in Python
- Operations Guide
- Configuration Reference
- Best Practices
- Formula Debugging Techniques
- Troubleshooting
- API documentation
- Base Series Operations
- tsa.get
- tsa.update
- tsa.multi_update
- tsa.replace
- tsa.exists
- tsa.source
- tsa.delete
- tsa.rename
- tsa.type
- tsa.interval
- tsa.inferred_freq
- tsa.insertion_dates
- tsa.history
- tsa.staircase
- tsa.block_staircase
- tsa.strip
- tsa.log
- tsa.metadata
- tsa.internal_metadata
- tsa.replace_metadata
- tsa.update_metadata
- tsa.old_metadata
- tsa.list_metadata_keys
- tsa.list_internal_metadata_keys
- tsa.tree
- tsa.path_series
- tsa.series_path
- tsa.set_series_path
- tsa.delete_path
- tsa.rename_path
- tsa.info
- tsa.sources
- Search and Baskets
- Groups
- tsa.group_exists
- tsa.group_get
- tsa.group_update
- tsa.group_replace
- tsa.group_delete
- tsa.group_rename
- tsa.group_type
- tsa.group_source
- tsa.group_interval
- tsa.group_inferred_freq
- tsa.group_insertion_dates
- tsa.group_history
- tsa.group_log
- tsa.group_metadata
- tsa.group_internal_metadata
- tsa.group_old_metadata
- tsa.update_group_metadata
- tsa.replace_group_metadata
- tsa.group_find
- tsa.group_catalog
- Supervision
- Formulas
- Excel
- Dashboards
- tsa.dashboard.update_figure
- tsa.dashboard.figures_catalog
- tsa.dashboard.figure_exists
- tsa.dashboard.get_figure
- tsa.dashboard.figure_dependents
- tsa.dashboard.delete_figure
- tsa.dashboard.rename_figure
- tsa.dashboard.dashboards_catalog
- tsa.dashboard.update_dashboard
- tsa.dashboard.dashboard_exists
- tsa.dashboard.get_dashboard
- tsa.dashboard.delete_dashboard
- tsa.dashboard.rename_dashboard
- tsa.dashboard.balance_list
- tsa.dashboard.balance_formula
- tsa.dashboard.balance_exists
- tsa.dashboard.update_balance
- tsa.dashboard.rename_balance
- tsa.dashboard.delete_balance
- Formula cache
- Tasks
- Base Series Operations