| hash | VARCHAR(66) | Hash of this record’s transaction. Alias for transaction_hash used in raw tables that preserve the original blockchain field name. |
| nonce | NUMBER(38,0) | Number of transactions sent from the sender’s address prior to this one. Used to prevent replay attacks and ensure transaction ordering. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
| from_address | VARCHAR(42) | Address that initiated or sent from in this event. For token transfers, the account whose balance decreased. For transactions, the transaction sender (msg.sender). |
| to_address | VARCHAR(42) | Address that received in this event. For token transfers, the account whose balance increased. For transactions, the destination address (may be a smart contract). |
| value | NUMBER(38,0) | Amount of native currency (e.g. ETH, MATIC) transferred with this transaction or trace, in the chain’s smallest unit (Wei for EVM chains). Zero for calls that don’t move native currency. |
| gas | NUMBER(38,0) | Maximum gas units the sender is willing to consume for this transaction. The actual consumption is captured in gas_used. |
| gas_price | NUMBER(38,0) | Gas price the sender offered to pay, in Wei per gas unit. For EIP-1559 transactions, this equals the effective gas price paid (base fee + priority fee). |
| input | VARCHAR(16777216) | Encoded calldata sent with the transaction. For contract calls, contains the function selector (first 4 bytes) and ABI-encoded arguments. Empty for simple ETH transfers. |
| receipt_cumulative_gas_used | NUMBER(38,0) | Total gas consumed by all transactions up to and including this one in the block. |
| receipt_gas_used | NUMBER(38,0) | Gas consumed by this specific transaction, as recorded in the transaction receipt. |
| receipt_contract_address | VARCHAR(42) | The contract address created, if the transaction was a contract creation, otherwise null. |
| receipt_root | VARCHAR(66) | Transaction stateroot (pre Byzantium). |
| receipt_status | NUMBER(38,0) | Transaction execution result from the receipt. 1 = success, 0 = reverted/failed. Null for pre-Byzantium transactions. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| receipt_effective_gas_price | NUMBER(38,0) | Actual gas price paid per unit by this transaction, in Wei. For EIP-1559 transactions this is base_fee + priority_fee (capped at max_fee). |
| max_fee_per_gas | NUMBER(38,0) | EIP-1559 maximum total fee per gas the sender is willing to pay (base fee + priority fee), in Wei. |
| max_priority_fee_per_gas | NUMBER(38,0) | EIP-1559 tip per gas offered to the block producer to prioritize inclusion, in Wei. |
| transaction_type | NUMBER(38,0) | Ethereum transaction envelope type. 0 = Legacy, 1 = Access List (EIP-2930), 2 = EIP-1559 dynamic fee. |
| receipt_gas_used_for_l1 | NUMBER(38,0) | |
| receipt_l1_block_number | NUMBER(38,0) | |
| log_count | NUMBER(38,0) | Number of event logs emitted in the transaction. |
| _updated_at | TIMESTAMP_LTZ(9) | Timestamp of when the entry was last updated in the database. |
