> ## 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          | `hedera.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           | True if this is the issuer's canonical deployment on this chain (not a bridge-wrapped version).                                  |
| stablecoin\_type                | VARCHAR(16777216) | Classification of the stablecoin mechanism (e.g. `fiat_backed`, `crypto_backed`, `algorithmic`).                                 |
| currency                        | VARCHAR(16777216) | Fiat currency this stablecoin is pegged to, as an ISO 4217 code in lowercase (e.g. `usd`, `eur`).                                |
| from\_address                   | VARCHAR(16777216) | Address that sent the transfer. For token transfers, the account whose balance decreased.                                        |
| to\_address                     | VARCHAR(16777216) | Address that received the transfer. For token transfers, the account whose balance increased.                                    |
| token\_address                  | VARCHAR(16777216) | Contract address of the stablecoin token.                                                                                        |
| token\_type                     | VARCHAR(16777216) | Token standard for the asset (e.g. `erc20`) or the native currency symbol.                                                       |
| token\_name                     | VARCHAR(16777216) | Name of the stablecoin.                                                                                                          |
| token\_symbol                   | VARCHAR(16777216) | Symbol of the stablecoin.                                                                                                        |
| token\_decimals                 | NUMBER(38,0)      | Decimal precision of the stablecoin. Used to convert raw amounts: normalized\_amount = raw\_amount / 10^decimals.                |
| raw\_amount\_str                | VARCHAR(16777216) | Transfer amount in the smallest unit as a string, to preserve full precision.                                                    |
| raw\_amount                     | FLOAT             | Transfer amount in the token's smallest indivisible unit (not decimal-adjusted).                                                 |
| amount\_str                     | VARCHAR(16777216) | Normalized transfer amount stored as a string to preserve full precision.                                                        |
| amount                          | FLOAT             | Transfer amount normalized by the token's decimal precision (raw\_amount / 10^decimals).                                         |
| usd\_amount                     | FLOAT             | USD value of the transfer 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. |
| payer\_account\_id              | VARCHAR(16777216) | Hedera account ID of the account that paid the transaction fee.                                                                  |
| transaction\_type               | VARCHAR(16777216) | Ethereum transaction envelope type. 0 = Legacy, 1 = Access List (EIP-2930), 2 = EIP-1559 dynamic fee.                            |
| transaction\_hash               | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                      |
| transaction\_id                 | VARCHAR(16777216) | Hedera transaction ID in the format `{payer_account_id}@{seconds}.{nanoseconds}`.                                                |
| transfers\_index                | NUMBER(38,0)      | Zero-based index of this transfer within a Hedera transaction that contains multiple transfers.                                  |
| block\_hash                     | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block.                                   |
| block\_number                   | NUMBER(38,0)      | Sequential number of the block that contains this record.                                                                        |
| block\_timestamp                | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                          |
| consensus\_timestamp            | TIMESTAMP\_NTZ(9) | The consensus timestamp on Hedera, expressed as nanoseconds since Unix epoch.                                                    |
| unique\_id                      | VARCHAR(16777216) | Allium's deterministic unique identifier for this row, stable across full refreshes.                                             |
| \_transfer\_created\_at         | TIMESTAMP\_NTZ(9) | Timestamp when the underlying transfer record was first ingested.                                                                |
| \_transfer\_updated\_at         | TIMESTAMP\_NTZ(9) | Timestamp when the underlying transfer record was last updated.                                                                  |
| \_metadata\_updated\_at         | TIMESTAMP\_NTZ(9) | Timestamp when the stablecoin metadata was last updated.                                                                         |
| \_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.                                                                    |
| \_changed\_since\_full\_refresh | BOOLEAN           | Indicates if the record has changed since the last full data refresh.                                                            |