Table Details
| Property | Value |
|---|---|
| Table Name | near.assets.near_token_transfers |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, unique_id |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | from_address, to_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| from_address | VARCHAR(16777216) | The sender address of the NEAR transfer |
| to_address | VARCHAR(16777216) | The recipient address of the NEAR transfer |
| token_address | VARCHAR(16777216) | The address of the native NEAR token (fixed as ‘near’) |
| token_name | VARCHAR(16777216) | The name of the token (fixed as ‘Near’) |
| token_symbol | VARCHAR(16777216) | The symbol of the token (fixed as ‘NEAR’) |
| raw_amount_str | VARCHAR(16777216) | The raw amount in yoctoNEAR as a string |
| raw_amount | FLOAT | The raw amount in yoctoNEAR |
| amount_str | VARCHAR(16777216) | The normalized amount in NEAR as a string |
| amount | FLOAT | The normalized amount in NEAR |
| usd_amount | FLOAT | The USD value of the transfer |
| usd_exchange_rate | FLOAT | The exchange rate used to calculate the USD value |
| signer_id | VARCHAR(16777216) | The ID of the signer of the transaction |
| method_name | VARCHAR(16777216) | The method name invoked in the transaction |
| success | BOOLEAN | Boolean indicating if the transaction was successful |
| transaction_hash | VARCHAR(16777216) | Unique identifier for the transaction |
| transaction_index | NUMBER(38,0) | The index of the transaction within the block |
| transaction_block_height | NUMBER(38,0) | The block height of the transaction |
| receipt_id | VARCHAR(16777216) | The ID of the receipt for the transaction |
| receipt_index | NUMBER(38,0) | The index of the receipt within the block |
| receipt_action_index | NUMBER(38,0) | The index of the action within the receipt |
| block_height | NUMBER(38,0) | The height of the block containing this transfer |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block containing this transfer |
| block_hash | VARCHAR(16777216) | The hash of the block containing this transfer |
| chunk_hash | VARCHAR(16777216) | The hash of the chunk containing this transfer |
| unique_id | VARCHAR(16777216) | A unique identifier for the transfer |
| _created_at | TIMESTAMP_NTZ(9) | The timestamp when the record was created |
| _updated_at | TIMESTAMP_NTZ(9) | The timestamp when the record was last updated |