Skip to content
TheChatArchiveThe Chat Archive
Claudeclaude-3-7-sonnet-20250219· AnthropicHugging Face LMArena Human Preference 140K

is it standard practice to put raw ohclv data and indicator calc in a sql db, then store…

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with Coherecommand-a-03-2025’s answer.
  1. User

    is it standard practice to put raw ohclv data and indicator calc in a sql db, then store the major data pulls in parquet during testing? quant finance

  2. Claude Assistant

    For quant finance, that approach is quite common. Storing raw OHLCV data and indicator calculations in SQL provides good structure and query flexibility during development, while using Parquet for major data pulls during testing offers performance benefits.

    Parquet's columnar format is particularly well-suited for quantitative analysis since it compresses efficiently and allows for faster reads on specific columns. This becomes important when you're running multiple backtest iterations and need quick access to large datasets.

    Many quant shops use this hybrid approach - SQL for data management and Parquet (or similar formats like Arrow) for performance-critical testing phases. It balances the need for data integrity with computational efficiency.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.