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.
Table Details
| Property | Value |
|---|---|
| Table Name | hyperevm.assets.stablecoin_transfers |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, unique_id |
| Clustering Key(s) | block_timestamp::date, token_address |
| Search Optimization | from_address, to_address, transaction_hash, token_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| from_address | VARCHAR(42) | Address where the stablecoin is being transferred from. |
| to_address | VARCHAR(42) | Address where the stablecoin is being transferred to. |
| token_address | VARCHAR(42) | Token address of the stablecoin transferred. |
| token_name | VARCHAR(16777216) | Name of the stablecoin transferred. |
| token_symbol | VARCHAR(16777216) | Symbol of the stablecoin transferred. |
| raw_amount_str | VARCHAR(16777216) | Amount of tokens transferred (unnormalized) in string to retain precision. |
| raw_amount | FLOAT | Amount of tokens transferred (unnormalized). |
| amount_str | VARCHAR(16777216) | Amount of tokens transferred, normalized in string to retain precision. |
| amount | FLOAT | Amount of tokens transferred, normalized. |
| usd_amount | FLOAT | The USD amount of the tokens at the time of the transfer. |
| transaction_from_address | VARCHAR(42) | The address of the sending party of this transaction. |
| transaction_to_address | VARCHAR(42) | The address of the receiving party of this transaction. |
| transaction_hash | VARCHAR(66) | Transaction hash that this transfer belongs to. |
| transaction_index | NUMBER(38,0) | The position of this transaction in the block. |
| log_index | NUMBER(38,0) | The position of this log within the block. |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this transfer was included on the blockchain. |
| block_number | NUMBER(38,0) | The block number that the corresponding transaction of this transfer belongs to. |
| block_hash | VARCHAR(66) | The block hash that the corresponding transaction of this transfer belongs to. |
| unique_id | VARCHAR(16777216) | Unique ID generated for each stablecoin transfer. |
| currency | VARCHAR(16777216) | The fiat currency that the stablecoin is pegged to (e.g., USD, EUR). |
| base_asset | VARCHAR(16777216) | The base asset or backing of the stablecoin. |
| is_bridge | BOOLEAN | Whether the stablecoin is a bridged version from another chain. |
| _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_LTZ(9) | Timestamp of when the stablecoin metadata was last updated. |