duckdb-schema

The A-share DuckDB schema defines tables for stocks, shareholders, bonds, daily_market, fundamentals, and klines. It specifies primary keys, data types, indices, and cross-table relationships to eliminate guesswork during SQL development and data validation.

You can join stocks, shareholders, and klines tables by referencing the schema's defined cross-table relationships and primary keys. This allows you to accurately query and model a stock's complete financial data, including market fundamentals and shareholder composition.

Yes, DuckDB is applicable for schema discovery and data validation of A-share fundamentals. The schema reference details table definitions, primary keys, and data units specifically for fundamentals, ensuring data consistency and accurate SQL query planning.

The DuckDB schema reference explicitly defines data types, primary keys, and indices for daily_market and klines tables. This detailed mapping supports accurate query planning and data integrity checks across your financial datasets.

Yes, this schema reference is designed for data analysts and engineers performing SQL development. It provides the structural definitions needed to draft queries, but assumes you understand SQL basics to query stocks, bonds, and fundamentals tables effectively.