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 | casper.raw.native_token_transfers |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, block_height, transaction_hash, transfer_index |
| Clustering Key(s) | to_date("block_timestamp") |
| Search Optimization | from_address, to_address, transaction_hash |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| from_address | VARCHAR(16777216) | Address that sent the native CSPR. |
| from_address_type | VARCHAR(16777216) | Type of the sender address (Account, Contract, or Hash). |
| to_address | VARCHAR(16777216) | Address that received the native CSPR. |
| to_address_type | VARCHAR(16777216) | Type of the recipient address (Account, Contract, or Hash). |
| amount_str | VARCHAR(16777216) | Amount transferred in motes as a string (preserves full precision). |
| amount | VARCHAR(16777216) | Amount transferred in motes. |
| source | VARCHAR(16777216) | Source purse URef the funds were drawn from. |
| target | VARCHAR(16777216) | Target purse URef the funds were credited to. |
| gas | VARCHAR(16777216) | Gas charged for executing the transfer. |
| id | VARCHAR(16777216) | Optional transfer memo identifier supplied by the sender. |
| from_address_raw | VARCHAR(16777216) | Raw underlying bytes of the sender address before formatting. |
| to_address_raw | VARCHAR(16777216) | Raw underlying bytes of the recipient address before formatting. |
| era_id | NUMBER(38,0) | Era (epoch) the block belongs to. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block this event was included in. |
| block_height | NUMBER(38,0) | Height of the block this event was included in. |
| block_hash | VARCHAR(100) | Hash of the block this event was included in. |
| transaction_hash | VARCHAR(100) | Hash of the transaction this event belongs to. |
| transaction_index | NUMBER(38,0) | Index of the transaction within the block. |
| transaction_result | VARCHAR(16777216) | Execution result of the parent transaction (Success or Failure). |
| transfer_index | NUMBER(38,0) | Index of the transfer within the transaction. |
| transfer_version | VARCHAR(16777216) | Version of the transfer record format. |
| _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. |