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

Unique Key: `unique_id`

| Column Name            | Data Type         | Description                                                   |
| ---------------------- | ----------------- | ------------------------------------------------------------- |
| bet\_index             | BIGINT            | Array index of the before-execution transfer                  |
| bet\_from\_address     | VARCHAR           | Address initiating the transfer before execution              |
| bet\_purpose           | VARCHAR           | Purpose of the before-execution transfer (e.g., 'feePayment') |
| bet\_value\_hex        | VARCHAR           | Hexadecimal value of the before-execution transfer in Wei     |
| bet\_value             | NUMERIC           | Decimal value of the before-execution transfer in Wei         |
| aet\_index             | BIGINT            | Array index of the after-execution transfer                   |
| aet\_to\_address       | VARCHAR           | Address receiving the transfer after execution                |
| aet\_purpose           | VARCHAR           | Purpose of the after-execution transfer (e.g., 'gasRefund')   |
| aet\_value\_hex        | VARCHAR           | Hexadecimal value of the after-execution transfer in Wei      |
| aet\_value             | NUMERIC           | Decimal value of the after-execution transfer in Wei          |
| transaction\_hash      | VARCHAR           | Hash of the transaction                                       |
| transaction\_index     | BIGINT            | Position of the transaction in the block                      |
| from\_address          | VARCHAR           | Transaction sender address                                    |
| to\_address            | VARCHAR           | Transaction recipient address                                 |
| value                  | BIGINT            | Transaction value                                             |
| input                  | VARCHAR           | Transaction input data                                        |
| output                 | VARCHAR           | Transaction output data                                       |
| trace\_type            | VARCHAR           | Type of trace (e.g., 'call')                                  |
| call\_type             | VARCHAR           | Type of call if applicable                                    |
| reward\_type           | VARCHAR           | Type of reward if applicable                                  |
| gas                    | BIGINT            | Gas limit of the trace call                                   |
| gas\_used              | BIGINT            | Amount of gas used                                            |
| subtraces              | BIGINT            | Number of sub-traces                                          |
| trace\_address         | VARCHAR           | Address path of the trace                                     |
| error                  | VARCHAR           | Error message if any                                          |
| status                 | BIGINT            | Status of the transaction                                     |
| block\_timestamp       | TIMESTAMP\_NTZ(9) | Block timestamp                                               |
| block\_number          | BIGINT            | Block number                                                  |
| block\_hash            | VARCHAR           | Hash of the block                                             |
| trace\_id              | VARCHAR           | Unique identifier for the trace                               |
| selector               | VARCHAR           | 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           | 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.                   |