Skip to main content
Schema: blast.core Table: fact_traces Type: Base Table This table contains flattened trace data for internal contract calls. User-defined functions (UDFs) are available to decode hex encoded fields, including utils.udf_hex_to_int().

Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERThe block number of this transaction.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe block timestamp of this transaction.
TX_HASHTEXTThe transaction hash for the trace. Please note, this is not necessarily unique in this table as transactions frequently have multiple traces.
TX_POSITIONNUMBERThe position of the transaction within the block.
TRACE_INDEXNUMBERThe index of the trace within the transaction.
FROM_ADDRESSTEXTThe sending address of this trace. This is not necessarily the from address of the transaction.
TO_ADDRESSTEXTThe receiving address of this trace. This is not necessarily the to address of the transaction.
INPUTTEXTThe input data for this trace.
OUTPUTTEXTThe output data for this trace.
TYPETEXTThe type of internal transaction. Common trace types are CALL, DELEGATECALL, and STATICCALL.
TRACE_ADDRESSTEXTThe trace address for this trace.
SUB_TRACESNUMBERThe amount of nested sub traces for this trace.
VALUEFLOATThe amount of the native asset transferred in this trace.
VALUE_PRECISE_RAWTEXTThe precise, unadjusted amount of the transaction. This is returned as a string to avoid precision loss.
VALUE_PRECISETEXTThe precise, adjusted amount of the transaction. This is returned as a string to avoid precision loss.
VALUE_HEXTEXTThe value of the transaction in hexadecimal format.
GASNUMBERThe gas supplied for this trace.
GAS_USEDNUMBERThe gas used for this trace.
ORIGIN_FROM_ADDRESSTEXT
ORIGIN_TO_ADDRESSTEXT
ORIGIN_FUNCTION_SIGNATURETEXT
TRACE_SUCCEEDEDBOOLEANThe boolean value representing if the trace succeeded.
ERROR_REASONTEXTThe reason for the trace failure, if any.
REVERT_REASONTEXTThe reason for the revert, if available.
TX_SUCCEEDEDBOOLEANWhether the transaction was successful, returned as a boolean.
IDENTIFIERTEXTThis column is being deprecated for standardization purposes. Please update your queries to use the trace_address column instead by March 10, 2025.
DATAOBJECTThis column is being deprecated for standardization purposes. Please remove from your queries by March 10, 2025.
TX_STATUSTEXTThis column is being deprecated for standardization purposes. Please update your queries to use the tx_succeeded column instead by March 10, 2025.
TRACE_STATUSTEXTThis column is being deprecated for standardization purposes. Please update your queries to use the trace_succeeded column instead by March 10, 2025.
FACT_TRACES_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was last modified.