---
title: "How iSAM Funds built an options research platform for a 10,000x data problem with ClickHouse Cloud"
description: "iSAM Funds, a UK-based systematic asset manager, built an options research platform on ClickHouse Cloud to handle the 10,000x data fan-out from underlying instruments to related options. Migrating from Postgres, the team achieved 35-50x compression and increased single-core ingestion from 8,000 to 800,000 rows per second, while ClickHouse’s native Apache Arrow support eliminated encoding reshuffling. ClickHouse’s columnar storage and vectorized execution made queries fast enough to run on demand, allowing the team to drop pre-computed rollups and materialized views and remove a layer of pipeline complexity. The managed service integrates with iSAM’s AWS footprint and enterprise authentication, pushes backups to iSAM’s own buckets for developer use, and lets them scale instances up for large backfills then down to control costs. The platform gives researchers fast, interactive access to full options history, shortening the time from hypothesis to tested strategy."
---

# How iSAM Funds built an options research platform for a 10,000x data problem with ClickHouse Cloud

[Clickhouse](https://yomu.fyi/company/clickhouse) · Oct 10, 2026

**Type:** Problem & solution

## Summary

iSAM Funds, a UK-based systematic asset manager, built an options research platform on ClickHouse Cloud to handle the 10,000x data fan-out from underlying instruments to related options. Migrating from Postgres, the team achieved 35-50x compression and increased single-core ingestion from 8,000 to 800,000 rows per second, while ClickHouse’s native Apache Arrow support eliminated encoding reshuffling. ClickHouse’s columnar storage and vectorized execution made queries fast enough to run on demand, allowing the team to drop pre-computed rollups and materialized views and remove a layer of pipeline complexity. The managed service integrates with iSAM’s AWS footprint and enterprise authentication, pushes backups to iSAM’s own buckets for developer use, and lets them scale instances up for large backfills then down to control costs. The platform gives researchers fast, interactive access to full options history, shortening the time from hypothesis to tested strategy.

## Context

iSAM Funds needed to store and query full options history for research, but the 10,000x data fan-out from underlying instruments to related options created a massive data engineering challenge. Postgres could not handle the volume, and simple horizontal partitioning was ineffective due to uneven market activity across exchange products.

## Approach / What changed

The team migrated from Postgres to ClickHouse Cloud, using its columnar storage and vectorized execution to achieve 35-50x compression and 100x faster single-core ingestion. They integrated with their existing AWS infrastructure and enterprise authentication, and used ClickHouse’s native Arrow support to avoid encoding reshuffling. The managed service allowed them to scale instances up for large backfills and down afterward, avoiding peak-sizing on-premises hardware.

## Takeaways

- ClickHouse’s columnar storage achieved 35-50x compression over Postgres for time-series options data without special tuning.
- Single-core ingestion jumped from 8,000 to 800,000 rows per second, and ClickHouse’s performance eliminated the need for pre-computed rollups and materialized views.
- The team uses ClickHouse Cloud’s ability to scale instances up for large backfills and down afterward, avoiding the cost of peak-sizing on-premises hardware.

## FAQ

### How did ClickHouse handle the 10,000x data fan-out from underlying instruments to options?

ClickHouse's columnar storage and vectorized execution made queries fast enough to run on demand, so the team could store full history without pre-aggregation. The 35-50x compression also reduced storage footprint significantly.

### What integration capabilities did iSAM need from ClickHouse Cloud?

iSAM required integration with its existing AWS footprint and enterprise authentication stack. ClickHouse Cloud provided direct connectivity over AWS and supported pushing backups to iSAM's own buckets for developer use.

### How did the team manage costs with ClickHouse Cloud?

They scale the instance up for large backfills and let it scale back down afterward, rather than sizing an on-premises machine for peak load. Steve Barham calls this a cost-efficient way of renting expensive hardware.

**Tags:** [Apache Arrow](https://yomu.fyi/topic/apache-arrow), [AWS](https://yomu.fyi/topic/aws), [ClickHouse](https://yomu.fyi/topic/clickhouse), [Data Engineering](https://yomu.fyi/topic/data-engineering), [Finance](https://yomu.fyi/topic/finance)

- Source: [Clickhouse](https://clickhouse.com/blog/isam-market-data-research-platform)
- Source URL: https://clickhouse.com/blog/isam-market-data-research-platform
- Ingested by Yomu: 2026-10-09T15:00:11.868Z

[Read original post](https://clickhouse.com/blog/isam-market-data-research-platform)