Skip to main content

Table Details

PropertyValue
Table Namealeph-zero.raw.traces_evm_transfers
Table StatusDeprecated ◽
Unique Keyblock_timestamp, unique_id
Clustering Key(s)block_timestamp::date
Search Optimizationtransaction_hash

Table Columns

Column NameData TypeDescription
bet_indexNUMBER(38,0)Array index of the before-execution transfer
bet_from_addressVARCHAR(134217728)Address initiating the transfer before execution
bet_purposeVARCHAR(134217728)Purpose of the before-execution transfer (e.g., ‘feePayment’)
bet_value_hexVARCHAR(134217728)Hexadecimal value of the before-execution transfer in Wei
bet_valueVARCHAR(134217728)Decimal value of the before-execution transfer in Wei
aet_indexNUMBER(38,0)Array index of the after-execution transfer
aet_to_addressVARCHAR(134217728)Address receiving the transfer after execution
aet_purposeVARCHAR(134217728)Purpose of the after-execution transfer (e.g., ‘gasRefund’)
aet_value_hexVARCHAR(134217728)Hexadecimal value of the after-execution transfer in Wei
aet_valueVARCHAR(134217728)Decimal value of the after-execution transfer in Wei
transaction_hashVARCHAR(66)Hash of the transaction
transaction_indexNUMBER(38,0)Position of the transaction in the block
from_addressVARCHAR(42)Transaction sender address
to_addressVARCHAR(42)Transaction recipient address
valueVARCHAR(16777216)Transaction value
inputVARCHAR(16777216)Transaction input data
outputVARCHAR(16777216)Transaction output data
trace_typeVARCHAR(16777216)Type of trace (e.g., ‘call’)
call_typeVARCHAR(16777216)Type of call if applicable
reward_typeVARCHAR(16777216)Type of reward if applicable
gasNUMBER(38,0)Gas limit of the trace call
gas_usedNUMBER(38,0)Amount of gas used
subtracesNUMBER(38,0)Number of sub-traces
trace_addressVARCHAR(16777216)Address path of the trace
errorVARCHAR(16777216)Error message if any
statusNUMBER(38,0)Status of the transaction
block_timestampTIMESTAMP_NTZ(9)Block timestamp
block_numberNUMBER(38,0)Block number
block_hashVARCHAR(66)Hash of the block
trace_idVARCHAR(16777216)Unique identifier for the trace
selectorVARCHAR(10)Function selector
before_evm_transfersVARIANTJSON array of transfers before execution
after_evm_transfersVARIANTJSON array of transfers after execution
unique_idVARCHAR(134217728)Unique identifier for the transfer record
_ingested_atTIMESTAMP_NTZ(9)Timestamp when the upstream record was ingested
_created_atTIMESTAMP_NTZ(9)Timestamp when the record was created.
_updated_atTIMESTAMP_NTZ(9)Timestamp when the record was last updated.