Table Details
| Property | Value |
|---|---|
| Table Name | near.raw.account_changes |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, block_height, account_id, change_type |
| Clustering Key(s) | to_date("block_timestamp") |
| Search Optimization | account_id, block_height, change_type |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| block_height | NUMBER(38,0) | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike block_slot, this only increments for slots that produced a block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| account_id | VARCHAR(16777216) | Lighter internal account identifier. |
| change_type | VARCHAR(16777216) | Nature of the balance change |
| account_change_index | NUMBER(38,0) | Sequential index of this account state change within the block. |
| _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. |