> ## 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.

# Transfers

### Table Details

| Property | Value |
| - | - |
| Table Name | `bob.stablecoins.transfers` |
| Table Status | Production-Ready |
| Unique Key | `block_timestamp::date`, `unique_id` |
| Clustering Key(s) | `block_timestamp::date, token_address` |
| Search Optimization | `from_address`, `to_address`, `transaction_hash`, `token_address`, `token_symbol` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| product\_id | VARCHAR(16777216) | Allium stablecoin product identifier (e.g. usdc, usdt) |
| is\_native | BOOLEAN | Whether the transfer was of a chain-native stablecoin issuance (vs. a bridged/wrapped representation) |
| stablecoin\_type | VARCHAR(16777216) | Backing model of the stablecoin (e.g. fiat-backed, crypto-collateralized, algorithmic) |
| currency | VARCHAR(16777216) | The reference currency the stablecoin is pegged to (e.g. USD, EUR) |
| from\_address | VARCHAR(42) | Sender of the stablecoin transfer |
| to\_address | VARCHAR(42) | Recipient of the stablecoin transfer |
| token\_address | VARCHAR(42) | Contract address of the stablecoin token |
| token\_name | VARCHAR(16777216) | Name of the stablecoin |
| token\_symbol | VARCHAR(16777216) | Symbol of the stablecoin |
| raw\_amount\_str | VARCHAR(16777216) | Transfer amount, unnormalized, as string to retain precision |
| raw\_amount | FLOAT | Transfer amount, unnormalized |
| amount\_str | VARCHAR(16777216) | Transfer amount, normalized, as string to retain precision |
| amount | FLOAT | Transfer amount, normalized by token decimals |
| usd\_amount | FLOAT | Transfer amount valued in USD at the time of transfer |
| usd\_exchange\_rate | FLOAT | Exchange rate used for USD conversion |
| transaction\_from\_address | VARCHAR(42) | The address that initiated the transaction containing the transfer |
| transaction\_to\_address | VARCHAR(42) | The transaction's `to` address (often a router or contract) |
| transaction\_hash | VARCHAR(66) | Hash of the transaction containing the transfer |
| transaction\_index | NUMBER(38,0) | Index of the transaction within the block |
| log\_index | NUMBER(38,0) | Log index of the transfer event within the transaction |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Block timestamp of the transfer |
| block\_number | NUMBER(38,0) | Block number of the transfer |
| block\_hash | VARCHAR(66) | Block hash containing the transfer |
| unique\_id | VARCHAR(16777216) | Unique identifier for the transfer event |
| \_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. |
| \_metadata\_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp when token metadata (name, symbol, etc.) was last updated |

### Related Docs

* [EVM Stablecoins Transfers](/historical-data/supported-blockchains/evm/core-schemas/stablecoins/transfers)