> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Fungible Token Transfers 🌱

### Table Details

| Property     | Value                                      |
| ------------ | ------------------------------------------ |
| Table Name   | `filecoin.assets.fungible_token_transfers` |
| Table Status | Beta 🌱                                    |

### 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.                                                                                                                                                                     |
| 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).                                                 |
| token\_type         | VARCHAR(16777216) | Token standard for the asset. One of: `erc20` (fungible), `erc721` (non-fungible), `erc1155` (semi-fungible), or the native currency symbol (e.g. `eth`, `matic`, `bnb`).                                           |
| token\_address      | VARCHAR(16777216) | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address.             |
| 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).                                                         |
| usd\_amount         | FLOAT             | USD value of the token amount at the time of the event, computed using the hourly USD exchange rate.                                                                                                                |
| usd\_exchange\_rate | FLOAT             | USD price per unit of the token at the time of the event, used to compute `usd_amount`. Sourced from Allium's hourly price feed.                                                                                    |
| 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.                               |