stellar.core Table: ez_daily_balances Type: Base Table
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 assets
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BALANCE_DATE | DATE | |
| ACCOUNT_ID | TEXT | |
| ASSET_ISSUER | TEXT | |
| ASSET_CODE | TEXT | |
| SYMBOL | TEXT | |
| BALANCE | FLOAT | |
| BALANCE_USD | FLOAT | |
| DAILY_BALANCE_CHANGE | FLOAT | |
| DAILY_BALANCE_CHANGE_USD | FLOAT | |
| BALANCE_CHANGED_ON_DATE | BOOLEAN | |
| IS_NATIVE | BOOLEAN | |
| TOKEN_IS_VERIFIED | BOOLEAN | |
| EZ_DAILY_BALANCES_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |