Skip to main content

Table Details

PropertyValue
Table Namefilecoin.raw.messages
Table StatusBeta 🌱
Unique Keytipset_timestamp, tipset_height, message_cid
Clustering Key(s)to_date("tipset_timestamp")

Table Columns

Column NameData TypeDescription
tipset_heightNUMBER(38,0)Filecoin tipset height (block height). A tipset is a set of blocks at the same height that form the canonical chain.
tipset_timestampTIMESTAMP_NTZ(9)Timestamp (UTC) of the Filecoin tipset.
message_cidVARCHAR(16777216)The CID of the message containing the transfer.
message_tipset_indexNUMBER(38,0)Position of this message within its tipset’s ordered message list
replaced_message_cidVARCHAR(16777216)CID of the message this transaction replaced (for fee-bumped or replaced pending messages)
from_addressVARCHAR(16777216)Address that initiated or sent from in this event. For token transfers, the account whose balance decreased. For transactions, the transaction sender (msg.sender).
to_addressVARCHAR(16777216)Address that received in this event. For token transfers, the account whose balance increased. For transactions, the destination address (may be a smart contract).
methodNUMBER(38,0)Human-readable name of the Filecoin actor method called by this message (alias for method_name)
nonceNUMBER(38,0)Number of transactions sent from the sender’s address prior to this one. Used to prevent replay attacks and ensure transaction ordering.
paramsVARCHAR(16777216)Raw parameters from the event
valueVARCHAR(16777216)Amount of native currency (e.g. ETH, MATIC) transferred with this transaction or trace, in the chain’s smallest unit (Wei for EVM chains). Zero for calls that don’t move native currency.
versionNUMBER(38,0)The version of the block.
durationNUMBER(38,0)Duration of the storage deal in Filecoin epochs
errorVARCHAR(16777216)Human-readable error message if this trace or transaction reverted (e.g. Out of gas, Reverted, Bad instruction). Null for successful executions.
receipt_events_rootVARIANTCID of the AMT containing all actor events emitted during this message’s execution
receipt_exit_codeNUMBER(38,0)Exit code from the message receipt (0 = success, non-zero = failure with specific error type)
receipt_returnVARCHAR(16777216)Base64-encoded return value from the message receipt
base_feeVARCHAR(16777216)Base fee per gas for this block, in the chain’s smallest fee denomination.
gas_limitVARCHAR(16777216)Maximum gas units allocated for the block. Transactions in a block cannot collectively exceed this limit.
gas_premiumVARCHAR(16777216)Priority fee per gas unit to incentivize miners to include this message (attoFIL)
gas_fee_capVARCHAR(16777216)Maximum fee per gas unit the sender is willing to pay (attoFIL)
gas_usedVARCHAR(16777216)Actual number of gas units consumed by this transaction or trace.
gas_total_costVARCHAR(16777216)Total FIL cost of this message execution including base fee burn, miner tip, and overestimation burn (attoFIL)
gas_miner_tipVARCHAR(16777216)Tip paid to the block miner per gas unit (attoFIL)
gas_base_fee_burnVARCHAR(16777216)Amount of FIL burned as base fee for this message execution
gas_overestimation_burnVARCHAR(16777216)Amount of FIL burned due to gas limit overestimation
gas_refundVARCHAR(16777216)Amount of gas refunded to the sender after execution due to unused gas or refundable operations
miner_penaltyVARCHAR(16777216)FIL penalty charged to the miner for consensus faults or other violations (attoFIL)
message_cid_rawVARIANTRaw bytes of the message CID
blocksVARIANTArray of block headers included in this tipset
block_countNUMBER(38,0)Number of blocks in this Filecoin tipset
event_countNUMBER(38,0)Number of events emitted by this transaction, block, or receipt.
event_attribute_countNUMBER(38,0)Number of key-value attributes attached to all events in this transaction.
trace_countNUMBER(38,0)Number of execution trace entries for this Filecoin message
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.
native_token_transfer_countNUMBER(38,0)The total number of native token transfers. This includes transfers of gas paid to miners and gas burned (for Ethereum) and L1/L2 fees (for EVM L2s).
deal_proposal_countNUMBER(38,0)Number of deal proposals included in this block
sector_event_countNUMBER(38,0)Number of sector lifecycle events (prove, expire, fault, etc.) recorded in this block