Continuous-aggregate OHLC rollups

[Miracle656]

Background

Computing candles on the fly is expensive. Materialized/continuous aggregates give fast OHLC queries at scale.

What to build

Add continuous aggregates (TimescaleDB hypertable + continuous aggregate, or scheduled materialized views) for 1m/1h/1d OHLC, with a refresh policy and a query endpoint that reads the rollup.

Key files

• prisma/schema.prisma / sql/ migrations
• src/api/candles.ts

Acceptance criteria

• Rollups refresh incrementally
• Candle endpoint reads the aggregate, not raw rows
• Benchmark shows the speedup vs on-the-fly

Drips Wave · Complexity: Advanced · 200 points

[benedictworks-home]

@benedictworks-home has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hello Maintainer, I would love to work on this issue.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @benedictworks-home to this issue.

[dumbdev]

@dumbdev has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi Maintainer, Pls I can work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @dumbdev to this issue.

[JinadJay]

@JinadJay has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Please assign this issue to me

ℹ️ Repo Maintainers: To accept this application, review their application or assign @JinadJay to this issue.

[oncleweynom]

@oncleweynom has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

goodmorning would want to work on this issue please

ℹ️ Repo Maintainers: To accept this application, review their application or assign @oncleweynom to this issue.

[Just-Bamford]

@Just-Bamford has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi maintainer, I'd like to work on this issue. My approach is to introduce continuous OHLC rollups using TimescaleDB continuous aggregates (or scheduled materialized views where appropriate), with incremental refresh policies for 1m, 1h, and 1d intervals. I'll update the candle API to query the aggregated data instead of raw events, add the required database migrations, and include benchmarks demonstrating the performance improvement over on-the-fly candle generation.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Just-Bamford to this issue.

[Ebendttl]

@Ebendttl has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi! I'm interested in working on this issue.

I have the required skills to work on it.

Thanks!

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Ebendttl to this issue.

[drips-wave]

Congratulations, @Just-Bamford! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @Just-Bamford: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊