Account_stats
The account_stats Table
The account_stats table in the XCore Trade DB stores hourly snapshots of the equity, exposure and margin of each account. Tracking of a metric starts when it first becomes non-zero. Each row summarizes its recorded values during the hour; consecutive hours can contain the same values.
This table provides valuable insights into how an account’s exposure, margin, or equity has fluctuated over time. XCore users can utilize this data to extract information such as the highest margin usage over a specified period.
| Attributes | Description |
|---|---|
| Account | The name of the Account as defined in the XCore system. |
| Time | Timestamp (date, time) when a snapshot of the account took place. (epoch format) |
| Type | The type of metric recorded. Possible values: • exposure • margin • equity |
| Open | The opening value of the respective Account ‘Type’ |
| High | The highest value of the respective Account ‘Type’ |
| Low | The lowest value of the respective Account ‘Type’ |
| Close | The closing value of the respective Account ‘Type’ |