Table Details
| Property | Value |
|---|---|
| Table Name | celo.assets.fungible_balances_daily |
| Table Status | Production-Ready |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| date | TIMESTAMP_NTZ(9) | The date of the daily balance snapshot. |
| address | VARCHAR(16777216) | The wallet or contract address holding the balance. |
| token_address | VARCHAR(16777216) | The token contract address. |
| token_name | VARCHAR(16777216) | Name of the token. |
| token_symbol | VARCHAR(16777216) | Symbol of the token. |
| token_decimals | NUMBER(38,0) | Decimal precision of the token. |
| raw_balance_str | VARCHAR(16777216) | The raw balance as string to retain precision. |
| raw_balance | FLOAT | The balance in raw units (unnormalized). |
| balance_str | VARCHAR(16777216) | The balance amount normalized, in string to retain precision. |
| balance | FLOAT | The balance amount, normalized by token decimals. |
| usd_exchange_rate | FLOAT | The USD exchange rate of the token at the time of the snapshot. |
| usd_balance | FLOAT | The USD value of the balance at the time of the snapshot. |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block with the last activity for this address-token pair. |
| last_activity_block_number | NUMBER(38,0) | Block number of the last activity for this address-token pair. |
| last_activity_block_hash | VARCHAR(16777216) | Block hash of the last activity for this address-token pair. |