US Equities Basic Adjustment Factors
US Equities Basic Adjustment Factors
Production
·
The US Equities Basic Adjustment Factors dataset provides adjustment factors for corporate events that influence price and/or volume, with each entry being supplemented with the event type and adjustment reason. This dataset allows users to compute forward and backward price and volume adjustment as needed. This dataset encompasses all US equities, with history dated back to 2007. For ease of access and organization, each equity ticker is stored as an individual file.
Dataset Info
Dataset Name ID
eq_adj_factors_basic
Algoseek Dataset ID
US1002
Data Format
Reference
Data Class
Equity
Data Type
Event
Time Granularity
Event
Region
US
Universe
All stocks, ETFs/ETNs from US exchanges
Version
1.0
Update Frequency Options
End of day
Start Date
01/01/2023
End Date
12/31/2023
Access Methods
SQL
Universe Identifiers
A, AAL, AAP + 500 more
Description
One year of data (2023) for SP500 index.
Data Size
1.7 MB / year
Update Size
9.8 KB
Update Frequency
1 Day
Start Date
2007-01-01
End Date
Ongoing
SQL (ArdaDB)
Easily connect to your data using SQL with a database connection. No complex setup, just instant access to your data - run queries, retrieve insights, and manage data effortlessly. Secure, fast, and built for developers, analysts, and teams who need reliable access without the hassle.
USEquityReferenceData.BasicAdjustments
Update Time
01:30 ET
Database Table
USEquityReferenceData.BasicAdjustments
Database Schema
USEquityReferenceData
Object Type
Table
Primary Date Column
EffectiveDate
Timestamp Column
--
Internal ID Column
SecId
Identifier Column
Ticker
Data Fields
Preview Data
| # | name | data type | description |
|---|---|---|---|
| 1 | ASID | Integer | A unique identifier for a security |
| 2 | Ticker | String | Symbol name |
| 3 | EffectiveDate | Date | The date on which the event becomes effective |
| 4 | AdjustmentFactor | Float | The value of the Adjustment factor for the event |
| 5 | AdjustmentReason | String | The reason for the Corporate Event |
| 6 | EventId | String | Unique Event ID under the AdjustmentReason |
CSV (S3)
Easily connect to your data stored in S3 and access CSV files without hassle. Streamline data retrieval with fast, secure, and scalable access, whether for analytics, processing, or integration.
us-equity-adjustment-secid-yyyy
S3 Bucket Name
us-equity-adjustment-secid-yyyy
Update Time
01:30 ET
S3 Bucket Path
xx/xxxxx.csv
S3 Bucket Path Description
One csv file per SecId grouped into folders by first two digits where xx - two leading digits of SecId, xxxxx - SecId
S3 Start Year
2007
S3 End Year
N/A
S3 Bucket Size
2.5 MB / year
Sample Data File
Data Fields
Preview Data
| # | name | data type | description |
|---|---|---|---|
| 1 | SecId | Integer | Unique security identifier |
| 2 | Ticker | String | Ticker on the Effective Date |
| 3 | EffectiveDate | String | Date that the event becomes effective |
| 4 | AdjustmentFactor | Decimal | The value of the Adjustment factor for the event |
| 5 | AdjustmentReason | String | The reason for the Corporate Event |
| 6 | EventId | Integer | Unique Event ID under the AdjustmentReason, i.e., each pair of AdjustmentReason and EventId is unique. |