Table Details
| Property | Value |
|---|---|
| Table Name | filecoin.raw.native_token_transfers |
| Table Status | Beta 🌱 |
| Unique Key | tipset_timestamp, unique_id |
| Clustering Key(s) | to_date("tipset_timestamp") |
| Search Optimization | from_address, to_address, message_cid |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| tipset_height | NUMBER(38,0) | Filecoin tipset height (block height). A tipset is a set of blocks at the same height that form the canonical chain. |
| tipset_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the Filecoin tipset. |
| message_cid | VARCHAR(16777216) | The CID of the message containing the transfer. |
| message_tipset_index | NUMBER(38,0) | Position of this message within its tipset’s ordered message list |
| trace_address | VARCHAR(16777216) | Path of this trace within the call graph, as an array of indices. An empty array means the top-level transaction call. [0] means the first sub-call, [0, 1] means the second sub-call of the first sub-call, etc. |
| from_address | VARCHAR(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_address | VARCHAR(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). |
| raw_amount_str | VARCHAR(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_amount | FLOAT | Token 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. |
| amount_str | VARCHAR(16777216) | Normalized token amount stored as a string to preserve full precision. Equivalent to amount but avoids floating-point truncation for very large or very small values. |
| amount | FLOAT | Token amount normalized by the token’s decimal precision (amount_raw / 10^decimals). This is the human-readable value (e.g. 1.5 USDC rather than 1500000). |
| method_num | NUMBER(38,0) | Numeric identifier of the actor method called by this message |
| exit_code | NUMBER(38,0) | Exit code of the Filecoin message execution (0 = success) |
| transfer_index | NUMBER(38,0) | Index to disambiguate multiple transfers in one transaction. |
| unique_id | VARCHAR(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_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |