| TX_HASH | TEXT | The transaction hash for the trace. Please note, this is not necessarily unique in this table as transactions frequently have multiple traces. |
| BLOCK_NUMBER | NUMBER | The block number of this transaction. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp of this transaction. |
| FROM_ADDRESS | TEXT | The sending address of this trace. This is not necessarily the from address of the transaction. |
| TO_ADDRESS | TEXT | The receiving address of this trace. This is not necessarily the to address of the transaction. |
| VALUE | FLOAT | The amount of ETH transferred in this trace. |
| VALUE_PRECISE_RAW | TEXT | The precise, unadjusted amount of the transaction. This is returned as a string to avoid precision loss. |
| VALUE_PRECISE | TEXT | The precise, adjusted amount of the transaction. This is returned as a string to avoid precision loss. |
| GAS | NUMBER | The gas supplied for this trace. |
| GAS_USED | NUMBER | The gas used for this trace. |
| INPUT | TEXT | The input data for this trace. |
| OUTPUT | TEXT | The output data for this trace. |
| TYPE | TEXT | The type of internal transaction. Common trace types are CALL, DELEGATECALL, and STATICCALL. |
| IDENTIFIER | TEXT | This field represents the position and type of the trace within the transaction. |
| DATA | OBJECT | The raw JSON data for this trace. |
| TX_STATUS | TEXT | Status of the transaction. |
| Note: this may be null for the transactions that are reverted, as described in the docs landing page. | | |
| SUB_TRACES | NUMBER | The amount of nested sub traces for this trace. |
| TRACE_STATUS | TEXT | The status of the trace, either SUCCESS or FAIL |
| ERROR_REASON | TEXT | The reason for the trace failure, if any. |
| TRACE_INDEX | NUMBER | The index of the trace within the transaction. |
| FACT_TRACES_ID | TEXT | A uniquely generated identifier assigned by a surrogate key |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which the record was initially created and inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which this record was last modified by an internal process. |
