stellar.core Table: fact_daily_balances Type: Base Table
What
Daily snapshot of token balances for each account/asset combination on the Stellar network. This model creates a complete daily time series by forward-filling the most recent balance when there’s no activity on a given day. If multiple balance updates occur within a day, only the last balance of that day is retained. Note: Currently filtered to verified tokens only. No automatic data retention policy applied - all historical data is preserved.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BALANCE_DATE | DATE | BALANCE_DATE column |
| ACCOUNT_ID | TEXT | ACCOUNT_ID column |
| ASSET_ISSUER | TEXT | ASSET_ISSUER column |
| ASSET_CODE | TEXT | ASSET_CODE column |
| BALANCE | FLOAT | BALANCE column |
| IS_DELETED | BOOLEAN | IS_DELETED column |
| BALANCE_CHANGED_ON_DATE | BOOLEAN | BALANCE_CHANGED_ON_DATE column |
| DAILY_BALANCE_CHANGE | FLOAT | DAILY_BALANCE_CHANGE column |
| DAILY_BALANCE_ID | TEXT | DAILY_BALANCE_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |
| _INVOCATION_ID | TEXT | _INVOCATION_ID column |