> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Account Changes

### 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.                                                                                               |