Returns Consolidated Financial Data For Company As Of Observation Date

This SQL query returns financial metrics such as total assets (ACT), total liabilities (LT), capital expenditures (CAPX), and earnings before interest and taxes (EBIT) for a specific company identified by its GVKEY as of a given observation date.