Raw
Transactions
Table Columns
Unique Key:
| Column Name | Data Type | Description |
|---|---|---|
| block_number | BIGINT | Block number containing this transaction |
| block_hash | VARCHAR | Hash of the block containing this transaction |
| consensus_timestamp | TIMESTAMP_NTZ(9) | The consensus timestamp when the transaction was executed |
| transaction_hash | VARCHAR | Hash of the transaction |
| transaction_id | VARCHAR | Unique identifier for the transaction |
| nonce | BIGINT | Nonce of the transaction |
| result | VARCHAR | Result of the transaction execution |
| transaction_type | VARCHAR | Type of transaction (CRYPTOTRANSFER, CONTRACTCALL, etc.) |
| payer_account_id | VARCHAR | Account ID of the account that paid for the transaction |
| entity_id | VARCHAR | ID of the entity involved in the transaction |
| charged_tx_fee | BIGINT | Transaction fee charged in tinybars |
| max_fee | BIGINT | Maximum fee set for the transaction |
| memo | VARCHAR | Memo attached to the transaction |
| scheduled | BOOLEAN | Whether this is a scheduled transaction |
| node | VARCHAR | Node that processed the transaction |
| valid_duration_seconds | BIGINT | Duration for which the transaction is valid |
| parent_consensus_timestamp | TIMESTAMP_NTZ(9) | Consensus timestamp of the parent transaction |
| valid_start_timestamp | TIMESTAMP_NTZ(9) | Timestamp when the transaction becomes valid |
| contract_result | VARIANT | Result data from contract execution |
| bytes | VARCHAR | Raw transaction bytes |
| transfers | VARIANT | HBAR transfers in the transaction |
| token_transfers | VARIANT | Token transfers in the transaction |
| nft_transfers | VARIANT | NFT transfers in the transaction |
| staking_reward_transfers | VARIANT | Staking reward transfers in the transaction |
| consensus_timestamp_raw | DECIMAL(29,9) | Raw consensus timestamp as decimal |
| parent_consensus_timestamp_raw | DECIMAL(29,9) | Raw parent consensus timestamp as decimal |
| valid_start_timestamp_raw | DECIMAL(29,9) | Raw valid start timestamp as decimal |
| log_count | BIGINT | Number of logs generated by the transaction |
| extra_evm_fields | VARIANT | Additional EVM-specific fields |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |