| ledger_key | The unique ledger key when the trust line state last changed | string | | Yes | |
| account_id | The account address | string | | Yes | |
| asset_type | The identifier for type of asset code, can be a alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. | integer | - credit_alphanum4
- credit_alphanum12
- native
| Yes | |
| asset_issuer | The account address of the original asset issuer that created the asset held by this account | string | | No | |
| asset_code | The 4 or 12 character code representation of the asset held by this account | string | | No | |
| liquidity_pool_id | If the asset held is part of a liquidity pool share, the unique pool id from which the asset balance originates | string | | No | |
| balance | The number of units of an asset held by this account | float | | Yes | |
| trust_line_limit | The maximum amount of this asset that this account is willing to accept. The limit is specified when opening a trust line | integer | | Yes | |
| buying_liabilities | The sum of all buy offers owned by this account for non-native assets | float | | Yes | |
| selling_liabilities | The sum of all sell offers owned by this account for non-native assets | float | | Yes | |
| flags | Denotes the enabling and disabling of certain asset issuer privileges | integer | - 0 - None, Default
- 1 - Authorized
- 2 - Authorized to Maintain Liabilities
- 4 - Clawback Enabled
| Yes | Flags are set on the issuer accounts for an asset. When user accounts trust an asset, the flags applied to the asset originate from this account |
| last_modified_ledger | The ledger sequence number when the ledger entry (this unique signer for the account) was modified | integer | | Yes | |
| ledger_entry_change | Code that describes the ledger entry change type that was applied to the ledger entry | integer | - 0 - Ledger Entry Created
- 1 - Ledger Entry Updated
- 2 - Ledger Entry Deleted
- 3 - Ledger Entry State
| Yes | Valid entry change types are 0, 1, and 2 for ledger entries of type trust_lines. |
| deleted | Indicates whether the ledger entry (trust line) has been deleted or not. Once an entry is deleted, it cannot be recovered | boolean | | Yes | |
| closed_at | Timestamp in UTC when this ledger closed and committed to the network. Ledgers are expected to close ~every 5 seconds | timestamp | | Yes | |
| ledger_sequence | The sequence number of this ledger. It represents the order of the ledger within the Stellar blockchain. Each ledger has a unique sequence number that increments with every new ledger, ensuring that ledgers are processed in the correct order. | integer | | Yes | |
| batch_id | String representation of the run id for a given DAG in Airflow | string | | Yes | |
| batch_run_date | The start date for the batch interval. When taken with the date in the batch_id, the date represents the interval of ledgers processed | datetime | | Yes | The table is partitioned on batch_run_date. It is recommended to always include the batch_run_date in the filter if possible to help reduce query cost. |
| batch_insert_ts | The timestamp in UTC when a batch of records was inserted into the database | timestamp | | Yes | |
| sponsor | The account address that is sponsoring the base reserves for the trust line | string | | No | |
| asset_id | Unique identifier for asset_code, asset_issuer | integer | | No | |