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

# CEP18 Token Transfers

### Table Details

| Property            | Value                                                                   |
| ------------------- | ----------------------------------------------------------------------- |
| Table Name          | `casper.raw.cep18_token_transfers`                                      |
| Table Status        | Production-Ready                                                        |
| Unique Key          | `block_timestamp`, `block_height`, `transaction_hash`, `transfer_index` |
| Clustering Key(s)   | `to_date("block_timestamp")`                                            |
| Search Optimization | `from_address`, `to_address`, `transaction_hash`                        |

### Table Columns

| Column Name             | Data Type         | Description                                                       |
| ----------------------- | ----------------- | ----------------------------------------------------------------- |
| from\_address           | VARCHAR(16777216) | Address that sent the CEP-18 tokens.                              |
| from\_address\_type     | VARCHAR(16777216) | Type of the sender address (Account, Contract, or Hash).          |
| to\_address             | VARCHAR(16777216) | Address that received the CEP-18 tokens.                          |
| to\_address\_type       | VARCHAR(16777216) | Type of the recipient address (Account, Contract, or Hash).       |
| amount                  | VARCHAR(16777216) | Raw amount transferred in the token's smallest unit.              |
| contract\_package\_hash | VARCHAR(16777216) | Contract package hash of the CEP-18 token.                        |
| event\_type             | VARCHAR(16777216) | CEP-18 event type (e.g., Transfer, Mint, Burn, Approval).         |
| event\_format           | VARCHAR(16777216) | Event encoding format (e.g., CES, native dictionary write).       |
| spender\_address        | VARCHAR(16777216) | Spender address for approval or transfer\_from events.            |
| spender\_address\_type  | VARCHAR(16777216) | Type of the spender address (Account, Contract, or Hash).         |
| dictionary\_key         | VARCHAR(16777216) | Dictionary key under which the event was written.                 |
| raw\_data               | VARIANT           | Raw decoded event payload as structured data.                     |
| era\_id                 | NUMBER(38,0)      | Era (epoch) the block belongs to.                                 |
| block\_timestamp        | TIMESTAMP\_NTZ(9) | Timestamp of the block this event was included in.                |
| block\_height           | NUMBER(38,0)      | Height of the block this event was included in.                   |
| block\_hash             | VARCHAR(100)      | Hash of the block this event was included in.                     |
| transaction\_hash       | VARCHAR(100)      | Hash of the transaction this event belongs to.                    |
| transaction\_index      | NUMBER(38,0)      | Index of the transaction within the block.                        |
| transaction\_result     | VARCHAR(16777216) | Execution result of the parent transaction (Success or Failure).  |
| transfer\_index         | NUMBER(38,0)      | Index of the transfer within the transaction.                     |
| transform\_index        | NUMBER(38,0)      | Index of the transform within the transaction's execution result. |
| \_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.     |