stellar.core Table: ez_daily_balances Type: Base Table
What
Daily snapshot of token balances with USD valuations for each account/asset combination on the Stellar network. This incremental table enriches the daily balance data with price information to calculate USD values. Uses the last price of each day from the hourly price feed for end-of-day valuations. Retains only the last 100 days of data (older records are automatically deleted) This table only contains balances for verified assetsColumns
| 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 |
| SYMBOL | TEXT | SYMBOL column |
| BALANCE | FLOAT | BALANCE column |
| BALANCE_USD | FLOAT | BALANCE_USD column |
| DAILY_BALANCE_CHANGE | FLOAT | DAILY_BALANCE_CHANGE column |
| DAILY_BALANCE_CHANGE_USD | FLOAT | DAILY_BALANCE_CHANGE_USD column |
| BALANCE_CHANGED_ON_DATE | BOOLEAN | BALANCE_CHANGED_ON_DATE column |
| IS_NATIVE | BOOLEAN | IS_NATIVE column |
| TOKEN_IS_VERIFIED | BOOLEAN | TOKEN_IS_VERIFIED column |
| EZ_DAILY_BALANCES_ID | TEXT | EZ_DAILY_BALANCES_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |