Table Details
| Property | Value |
|---|---|
| Table Name | flynet.snapshots.balances |
| Table Status | Beta 🌱 |
| Unique Key | block_number, address, token_address |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | address, token_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| address | VARCHAR(42) | The wallet or contract address holding the token balance. |
| token_address | VARCHAR(42) | The contract address of the token, or the native token sentinel address. |
| raw_balance | VARCHAR(16777216) | 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(66) | 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(16777216) | 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. |