Skip to content

Processed Compustat

The processed annual and quarterly Compustat tables provide reusable financial statements and identifiers for mappings and firm-level analyses.

flowchart LR
    project[(Project-raw Compustat)] --> process[Parse and derive measures]
    process --> annual[(Annual Compustat)]
    process --> quarterly[(Quarterly Compustat)]

    classDef source fill:#e8eef7,stroke:#52739e
    classDef process fill:#fff0cc,stroke:#a66b00
    classDef data fill:#e2f2e7,stroke:#3b7a4b
    class project source
    class process process
    class annual,quarterly data
Dataset Grain Location
Processed annual gvkey, fiscal year /data/full/processed/compustat_annual.parquet
Processed quarterly gvkey, fiscal quarter /data/full/processed/compustat_quarterly.parquet

shared/data/build_processed/compustat.py parses dates, normalizes gvkey, and derives ROA, log assets, and sales per employee. Quarterly records receive annual employment matched on gvkey and fiscal year.

python shared/data/build_processed/compustat.py

The files exist once under full; analyses join them to the selected Revelio coverage. Downstream users include the Revelio-Compustat mapping, company-year MQ, executive matching, and the public-firm analysis data.