Transactions - Allium Documentation Hub

All transactions, starting from genesis.

Table Details

Property	Value
Table Name	`near.raw.transactions`
Table Status	Production-Ready
Unique Key	`block_timestamp`, `hash`
Clustering Key(s)	`to_date("block_timestamp")`
Search Optimization	`signer_id`, `receiver_id`, `hash`

Transactions represent the operations initiated by users on the NEAR network. They include details such as the sender, receiver, amount, and any actions to be executed. Each transaction is identified by a unique hash and is included in a block once validated.

Table Columns

Column Name	Data Type	Description
block_hash	VARCHAR(16777216)	The hash of the block this transaction was associated with
block_height	NUMBER(38,0)	The height of the block
block_timestamp	TIMESTAMP_NTZ(9)	The time at which the block was created/added to the chain
final_execution_status	VARCHAR(16777216)	The final execution status of the transaction
receipts_outcome_count	NUMBER(38,0)	The number of outcomes from receipts generated by the transaction
status	VARIANT	The status of the transaction
success	BOOLEAN	Whether the transaction was successful
hash	VARCHAR(16777216)	The hash of the transaction
nonce	NUMBER(38,0)	The number of transactions made by the sender prior to this one encoded as hexadecimal
public_key	VARCHAR(16777216)	The public key of the signer
receiver_id	VARCHAR(16777216)	The account id of the transaction receiver
signature	VARCHAR(16777216)	The standard ed25519 signature type
signer_id	VARCHAR(16777216)	The account id of the transaction originator
transaction_actions_count	NUMBER(38,0)	The number of actions in the transaction
transaction_index	NUMBER(38,0)	The index of the transaction within the block
executor_id	VARCHAR(16777216)	The id of the originator
gas_burnt	NUMBER(38,0)	The gas burnt while executing the transaction
logs	VARIANT	Logs for the application being executed by this transaction
metadata	VARIANT	Describes the transaction information
receipt_ids	VARIANT	The ids of the receipts generated by the transaction
transaction_outcome_status	VARIANT	The status of the transaction outcome
tokens_burnt	VARCHAR(16777216)	The amount of tokens burnt
transaction_outcome_proof	VARIANT	The proof of the transaction outcome
gas_used	NUMBER(38,0)	The amount of gas used
transaction_fee_raw	VARCHAR(16777216)	The raw transaction fee
_created_at	TIMESTAMP_NTZ(9)	Timestamp of the entry creation
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of the entry update
chunk_hash	VARCHAR(16777216)	Hash of the shard chunk in which this token transfer was included.