Table Columns
Unique Key:block_number, address, token_address
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR | The wallet or contract address holding the token balance. |
| token_address | VARCHAR | The contract address of the token, or the native token sentinel address. |
| raw_balance | VARCHAR | The unnormalized token balance at this block, stored as a string to preserve precision. |
| block_number | NUMBER(38,0) | The block number at which this balance snapshot was recorded. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block at which this balance snapshot was recorded. |
| block_hash | VARCHAR | The hash of the block at which this balance snapshot was recorded. |
| is_balance_change | BOOLEAN | Whether this snapshot was triggered by a balance-changing event in this block. |
| _metadata | VARIANT | Internal metadata from the balance ingestion pipeline. |
| _error | VARIANT | Error information if the balance fetch encountered an issue. |
| _source | VARCHAR | The data source or ingestion pipeline that produced this record. |
| _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. |