Table Details
| Property | Value |
|---|---|
| Table Name | cardano.unhydrated.fungible_balances_eod |
| Table Status | Production-Ready |
| Unique Key | block_date, address, token |
| Clustering Key(s) | block_date, _short_address, _short_token |
| Search Optimization | address, token |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR(16777216) | The Cardano address holding the balance. |
| token | VARCHAR(16777216) | The token identifier (policy ID + asset name for native tokens, or “lovelace” for ADA). |
| raw_balance_str | VARCHAR(16777216) | Raw cumulative balance as a string to retain precision. |
| block_date | TIMESTAMP_NTZ(9) | Date of the balance snapshot. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the last activity on this date. |
| block_height | NUMBER(38,0) | Block height of the last activity on this date. |
| block_hash | VARCHAR(16777216) | Block hash of the last activity on this date. |
| transaction_hash | VARCHAR(16777216) | Transaction hash of the last activity on this date. |
| transaction_index | NUMBER(38,0) | Transaction index of the last activity on this date. |
| pseudo_global_order | NUMBER(38,0) | Ordering key combining block height and transaction index. |
| _short_address | VARCHAR(16777216) | Short prefix of the address for search optimization. |
| _short_token | VARCHAR(16777216) | Short prefix of the token for search optimization. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |