stellar.core Table: fact_trust_lines Type: Base Table
FACT_TRUST_LINES table captures trust relationship events and balance states at time of transaction
activity on the Stellar network. Each record represents the trustline state (balance, limits,
liabilities) for an account-asset pair as recorded when a transaction affecting that trustline
occurred. NOTE: This is NOT a comprehensive daily snapshot of all account balances - it only
contains records when trustlines are created, modified, or involved in transactions.
To reconstruct the current or historical balance state for analysis, you must identify the most
recent record per account-asset pair using techniques like ROW_NUMBER() OVER (PARTITION BY
account_id, asset_id ORDER BY ledger_sequence DESC). The table includes balance changes triggered by
payments, trades, trustline modifications, and other operations, but accounts with no recent
activity will not have recent records.
Key data points include ASSET_CODE, ASSET_ISSUER, BALANCE (at transaction time), TRUST_LINE_LIMIT,
BUYING_LIABILITIES, and SELLING_LIABILITIES. The DELETED flag indicates trustline removal. This
transactional approach means supply calculations require careful aggregation of the latest state per
account to avoid double-counting and to account for inactive accounts not represented in recent
data.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| ACCOUNT_ID | TEXT | |
| CLOSED_AT | TIMESTAMP_NTZ | |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | |
| ASSET_ID | NUMBER | |
| ASSET_TYPE | TEXT | |
| ASSET_ISSUER | TEXT | |
| ASSET_CODE | TEXT | |
| LIQUIDITY_POOL_ID | TEXT | |
| BALANCE | FLOAT | |
| TRUST_LINE_LIMIT | FLOAT | |
| BUYING_LIABILITIES | FLOAT | |
| SELLING_LIABILITIES | FLOAT | |
| FLAGS | TEXT | |
| LAST_MODIFIED_LEDGER | NUMBER | |
| LEDGER_ENTRY_CHANGE | NUMBER | |
| DELETED | BOOLEAN | |
| LEDGER_SEQUENCE | NUMBER | |
| LEDGER_KEY | TEXT | |
| SPONSOR | TEXT | |
| BATCH_ID | TEXT | |
| BATCH_RUN_DATE | TIMESTAMP_NTZ | |
| BATCH_INSERT_TS | TIMESTAMP_NTZ | |
| FACT_TRUST_LINES_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |