stellar.core Table: fact_daily_balances Type: Base Table
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 | |
| ACCOUNT_ID | TEXT | |
| ASSET_ISSUER | TEXT | |
| ASSET_CODE | TEXT | |
| BALANCE | FLOAT | |
| IS_DELETED | BOOLEAN | |
| BALANCE_CHANGED_ON_DATE | BOOLEAN | |
| DAILY_BALANCE_CHANGE | FLOAT | |
| DAILY_BALANCE_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | |
| _INVOCATION_ID | TEXT |