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

# Traces EVM Transfers

### Table Details

| Property            | Value                                |
| ------------------- | ------------------------------------ |
| Table Name          | `everclear.raw.traces_evm_transfers` |
| Table Status        | Production-Ready                     |
| Unique Key          | `block_timestamp`, `unique_id`       |
| Clustering Key(s)   | `block_timestamp::date`              |
| Search Optimization | `transaction_hash`                   |

### Table Columns

| Column Name            | Data Type          | Description                                                   |
| ---------------------- | ------------------ | ------------------------------------------------------------- |
| bet\_index             | NUMBER(38,0)       | Array index of the before-execution transfer                  |
| bet\_from\_address     | VARCHAR(134217728) | Address initiating the transfer before execution              |
| bet\_purpose           | VARCHAR(134217728) | Purpose of the before-execution transfer (e.g., 'feePayment') |
| bet\_value\_hex        | VARCHAR(134217728) | Hexadecimal value of the before-execution transfer in Wei     |
| bet\_value             | VARCHAR(134217728) | Decimal value of the before-execution transfer in Wei         |
| aet\_index             | NUMBER(38,0)       | Array index of the after-execution transfer                   |
| aet\_to\_address       | VARCHAR(134217728) | Address receiving the transfer after execution                |
| aet\_purpose           | VARCHAR(134217728) | Purpose of the after-execution transfer (e.g., 'gasRefund')   |
| aet\_value\_hex        | VARCHAR(134217728) | Hexadecimal value of the after-execution transfer in Wei      |
| aet\_value             | VARCHAR(134217728) | Decimal value of the after-execution transfer in Wei          |
| transaction\_hash      | VARCHAR(66)        | Hash of the transaction                                       |
| transaction\_index     | NUMBER(38,0)       | Position of the transaction in the block                      |
| from\_address          | VARCHAR(42)        | Transaction sender address                                    |
| to\_address            | VARCHAR(42)        | Transaction recipient address                                 |
| value                  | VARCHAR(16777216)  | Transaction value                                             |
| input                  | VARCHAR(16777216)  | Transaction input data                                        |
| output                 | VARCHAR(16777216)  | Transaction output data                                       |
| trace\_type            | VARCHAR(16777216)  | Type of trace (e.g., 'call')                                  |
| call\_type             | VARCHAR(16777216)  | Type of call if applicable                                    |
| reward\_type           | VARCHAR(16777216)  | Type of reward if applicable                                  |
| gas                    | NUMBER(38,0)       | Gas limit of the trace call                                   |
| gas\_used              | NUMBER(38,0)       | Amount of gas used                                            |
| subtraces              | NUMBER(38,0)       | Number of sub-traces                                          |
| trace\_address         | VARCHAR(16777216)  | Address path of the trace                                     |
| error                  | VARCHAR(16777216)  | Error message if any                                          |
| status                 | NUMBER(38,0)       | Status of the transaction                                     |
| block\_timestamp       | TIMESTAMP\_NTZ(9)  | Block timestamp                                               |
| block\_number          | NUMBER(38,0)       | Block number                                                  |
| block\_hash            | VARCHAR(66)        | Hash of the block                                             |
| trace\_id              | VARCHAR(16777216)  | Unique identifier for the trace                               |
| selector               | VARCHAR(10)        | Function selector                                             |
| before\_evm\_transfers | VARIANT            | JSON array of transfers before execution                      |
| after\_evm\_transfers  | VARIANT            | JSON array of transfers after execution                       |
| unique\_id             | VARCHAR(134217728) | Unique identifier for the transfer record                     |
| \_ingested\_at         | TIMESTAMP\_NTZ(9)  | Timestamp when the upstream record was ingested               |
| \_created\_at          | TIMESTAMP\_NTZ(9)  | Timestamp when the record was created.                        |
| \_updated\_at          | TIMESTAMP\_NTZ(9)  | Timestamp when the record was last updated.                   |

### Related Docs

* [EVM Raw Traces EVM Transfers](/historical-data/supported-blockchains/evm/core-schemas/raw/traces-evm-transfers)