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.erc1155_token_transfers |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, unique_id |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | token_address, from_address, to_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| event_type | VARCHAR(16777216) | Type of transfer event for ERC1155 tokens. This can either be single_transfer or batch_transfer. |
| operator | VARCHAR(42) | Address of the ERC1155 operator. |
| array_index | NUMBER(38,0) | Index position within a batch transfer array. For single transfers, this value is 0. |
| from_address | VARCHAR(42) | Address where the token is being transferred from. |
| to_address | VARCHAR(42) | Address where the token is being transferred to. |
| token_address | VARCHAR(42) | Token address of the asset transferred. |
| token_name | VARCHAR(16777216) | Token name. |
| token_symbol | VARCHAR(16777216) | Token symbol. |
| token_id | VARCHAR(16777216) | The token ID of the token. |
| raw_amount_str | VARCHAR(16777216) | Amount of token transferred, unnormalized, in string (to retain precision). |
| raw_amount | FLOAT | Amount of tokens transferred, unnormalized. |
| amount_str | VARCHAR(16777216) | Amount of token transferred, normalized, in string (to retain precision). |
| amount | FLOAT | Amount of token transferred, normalized. |
| 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 (could be a contract address). |
| transaction_hash | VARCHAR(66) | The transaction hash that this transfer belongs to. |
| transaction_index | NUMBER(38,0) | The position of this transaction in the block. The first transaction of a block has index 0. |
| log_index | NUMBER(38,0) | The position of this log within the block. The first log of a block has index 0. |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this transaction 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 transfer. |
| _tokens_updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the token metadata was last updated. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full refresh. |