Skip to main content

Table Details

PropertyValue
Table Namefilecoin.raw.fevm_token_transfers
Table StatusBeta 🌱
Unique Keytipset_timestamp, unique_id
Clustering Key(s)to_date("tipset_timestamp")
Search Optimizationfrom_address, to_address, message_cid

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.
event_indexNUMBER(38,0)Zero-based index of this event within its transaction. The specific semantics depend on the chain — on Aptos this is the event_index within the transaction; on Cosmos this is within the message.
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
emitterVARCHAR(16777216)Actor address that emitted this Filecoin built-in actor event
revertedBOOLEANTrue if this message or tipset was reverted due to a chain reorganization
event_typeVARCHAR(16777216)Type or category of the onchain event that produced this record. The specific values depend on the model (e.g. transfer_single / batch_transfer for ERC-1155, deposit / withdraw for bridges).
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).
from_address_evmVARCHAR(16777216)From address EVM of the transaction.
to_address_evmVARCHAR(16777216)EVM-compatible 20-byte address derived from the destination, used on chains with dual addressing schemes.
raw_amount_strVARCHAR(16777216)Token amount in the smallest unit as a string. Same concept as amount_raw_str — the column is named raw_amount_str in models that follow the raw_ prefix convention rather than the _raw suffix convention.
raw_amountFLOATToken amount in the smallest indivisible unit (not decimal-adjusted). Same concept as amount_raw — the column is named raw_amount in models that follow the raw_ prefix convention.
topicsVARIANTArray of indexed event topics for this contract event log.
dataVARCHAR(16777216)ABI-encoded non-indexed parameters of an event log, or the calldata of a transaction/trace. Decode using the relevant ABI to extract individual field values.
fevm_token_transfer_indexNUMBER(38,0)Position of this EVM token transfer within the message
unique_idVARCHAR(16777216)Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes.
_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.