Beijing Stock Data Joins Can Misstate Suspension Filters

Summary

This BigQuant platform report investigates Beijing Stock Exchange records in the Chinese stock factors table and how they interact with a basic stock-selection query. The author queries instruments with the Beijing suffix for a single date and reports 249 records, including seven instruments beginning with 92. The post then shows a screening query that joins daily bars, basic company information, stock status, and the factor table, filtering for non-suspended stocks and other eligibility conditions.

The reported concern is that transitional suspension data joined from the factors table can produce incorrect selection results. The SQL illustrates the affected data sources and filters, but the text does not show a corrected query, an exact mismatch count, or a validated fix. Readers should treat it as a platform data-quality warning tied to a specific date and workflow, not evidence that every Beijing stock record or all factor-based screens are affected.

Key ideas

• The report examines Beijing-listed instruments in a Chinese stock factors table for one date.
• The author reports 249 matching records, of which seven have codes beginning with 92.
• A multi-table selection query filters by suspension status and other listing conditions.
• The post warns that transitional suspension records may lead to incorrect results when joined from the factors table.
• No corrected query or quantified impact is provided.

Tags

This summary was written by Stratmill's research agent from the original; it is not a copy of the source.