quantdb-fields

Documents verified units, formats, and pitfalls for QuantDB financial datasets.

1.5k|337|Updated Apr 15, 2026
One-click install
npx skills add https://github.com/qusong0627/QuantMind --skill quantdb-fields-qusong0627
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: quantdb-fields
Source: https://github.com/qusong0627/QuantMind/tree/main/skills/quantdb-fields
Command: npx skills add https://github.com/qusong0627/QuantMind --skill quantdb-fields-qusong0627

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? QuantDB stores market data across many datasets with inconsistent units—stock volume in shares but index volume in lots, amounts in ten-thousand yuan, dividend rates as percentages in one table and decimals in another. Using the wrong unit silently corrupts analysis results by factors of 100 or 10,000. This Skill provides a field-by-field reference of empirically verified units, symbol formats, and known data gaps so analyses and backtests use correct calibers. ## Core Features & Use Cases - Unit Reference Tables: Verified units for kline data, index daily, valuation, technical indicators, L1/L2 factors, financial statements, and PG tables, each backed by real measurement evidence. - L2 Tick Data Guidance: Field definitions and pitfalls for Wind L2 order/trade records and ten-level order book snapshots, including the Shanghai vs Shenzhen volume double-counting issue and mixed-source unit detection. - Pre-Analysis Checklist: A checklist covering symbol format (suffix vs prefix), adjustment caliber (forward/backward/unadjusted), stale datasets, and known data gaps to check before any analysis. - Use Case: Before computing turnover rate or dividend yield for a stock report, consult this Skill to learn that valuation.dividend_rate is a percentage value (0.148 = 0.148%) while features_daily.dividend_rate is a decimal, avoiding a 100x error. ## Quick Start Ask the agent to check the correct units and caliber for QuantDB fields like volume, amount, or dividend_rate before running your analysis or backtest.

Frequently Asked Questions about quantdb-fields

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
What are the units for volume and amount in QuantDB stock data?

Individual stock kline volume is in shares and amount is in ten-thousand yuan (wan yuan). Index daily data is the opposite for volume: it uses lots (1 lot = 100 shares), while amount stays in ten-thousand yuan.

How do I check dividend rate units in QuantDB?

The valuation table's dividend_rate is a percentage value (0.148 means 0.148%), switched to this caliber from 20260814. The features_daily table keeps the decimal caliber (0.0148), so the two differ by 100x and must be normalized before comparison.

Why does QuantDB tick data volume not match daily volume?

Tick data has mixed sources: Wind-imported snapshots use shares and ten-thousand yuan, while older synced data uses lots and yuan. Also, Shenzhen L2 trade sums are roughly 2x the daily volume while Shanghai matches, so tick sums cannot be used directly as daily volume.

What symbol format does QuantDB use for stock codes?

Parquet datasets use suffix format like 601138.SH, while the PostgreSQL stock_daily_latest table uses prefix format like SH601138. Querying with the wrong format returns zero rows, so match the format to the data source.

Which QuantDB datasets are stale or have known gaps?

Minute-level min1/min5 data stopped at 2026-07-24, hsgt_north northbound data stopped in 2024-08, instrument_detail lags at 20260720, and L2 raw tick data covers only 20260511. Always check the latest date before using these datasets.