| hash | VARCHAR(66) | Unique identifier of a transaction. |
| nonce | NUMBER(38,0) | The transaction nonce, unique to the wallet |
| transaction_index | NUMBER(38,0) | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| from_address | VARCHAR(42) | The address of the sending party of this transaction. |
| to_address | VARCHAR(42) | The address of the receiving party of this transaction (could be a contract address). |
| value | NUMBER(38,0) | The amount of ether sent in this transaction, in wei. |
| gas | NUMBER(38,0) | The maximum amount of gas allocated for this transaction in wei. |
| gas_price | NUMBER(38,0) | Cost per unit of gas specified by the transaction in wei. The higher the gas price, the higher chance of getting included in a block. |
| input | VARCHAR(16777216) | The data sent along with the transaction. |
| receipt_cumulative_gas_used | NUMBER(38,0) | The total amount of gas used when this transaction was executed in the block. |
| receipt_gas_used | NUMBER(38,0) | The total amount of gas consumed by a transaction as recorded in its 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) | Success status of the transaction. Either 1 (success) or 0 (failure). |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block that contains this transaction was included on the blockchain. |
| block_number | NUMBER(38,0) | The length of the chain, in blocks. |
| block_hash | VARCHAR(66) | Unique identifier of the block that includes this transaction. |
| max_fee_per_gas | NUMBER(38,0) | The maximum fee per gas that the transaction sender is willing to pay for this transaction (introduced in EIP1559) |
| max_priority_fee_per_gas | NUMBER(38,0) | The maximum fee per gas the transaction sender is willing to give to validators (Proof of Stake) or miners (Proof of Work) to incentivize them to include their transaction (introduced in EIP1559) |
| transaction_type | NUMBER(38,0) | The integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees. |
| receipt_effective_gas_price | NUMBER(38,0) | The sum of the base fee and tip paid per unit of gas. |
| log_count | NUMBER(38,0) | Number of event logs emitted in the transaction. |
| y_parity | NUMBER(38,0) | The parity (0 or 1) of the y-coordinate of the curve point for the signature’s recovery identifier. |
| mint | NUMBER(38,0) | Amount of ETH minted on L2 by this transaction. Populated for OP Stack deposit transactions bridging ETH from L1. |
| receipt_l1_fee | NUMBER(38,0) | The Layer 1 fee paid for the transaction (applicable for Layer 2 transactions). |
| receipt_l1_gas_price | NUMBER(38,0) | The gas price used to compute L1 calldata fee (applicable for Layer 2 transactions). |
| receipt_l1_gas_used | NUMBER(38,0) | The amount of gas used on the L1 chain for posting transaction data (applicable for Layer 2 transactions). |
| source_hash | VARCHAR(66) | Unique hash identifying the origin of an OP Stack deposit transaction, derived from the L1 block hash and deposit log index. |
| access_list | VARIANT | A list of addresses and storage keys that the transaction plans to access, introduced in EIP-2930 to help optimize gas costs. |
| deposit_receipt_version | NUMBER(38,0) | Version identifier for the deposit receipt format used in L1->L2 deposits |
| receipt_blob_gas_used | NUMBER(38,0) | Total blob gas used for the transactions |
| receipt_da_footprint_gas_scalar | NUMBER(38,0) | Scalar applied to the transaction’s data-availability footprint when computing gas usage, as reported in the receipt (newer OP Stack chains). |
| receipt_deposit_nonce | NUMBER(38,0) | Nonce used to track L1→L2 deposit transactions, for tracking cross-chain deposits and preventing replay attacks. |
| receipt_deposit_receipt_version | NUMBER(38,0) | Version identifier for the L1 deposit receipt format. |
| receipt_l1_base_fee_scalar | NUMBER(38,0) | The base fee scalar component applied to L1 base fee to calculate L1 data costs for rollups (applicable for Layer 2 transactions). |
| receipt_l1_blob_base_fee | NUMBER(38,0) | Base fee per blob (in wei) on L1 (post-EIP-4844) (applicable for Layer 2 transactions). |
| receipt_l1_blob_base_fee_scalar | NUMBER(38,0) | Scalar applied to blob base fee to adjust L1 blob costs on L2 (applicable for Layer 2 transactions). |
| receipt_operator_fee_constant | NUMBER(38,0) | Flat operator-fee component in wei, as reported in the transaction receipt (OP Stack Isthmus+). Combined with the scalar as operatorFeeConstant + (gasUsed × operatorFeeScalar / 1e6) (Isthmus) or operatorFeeConstant + (gasUsed × operatorFeeScalar × 100) (Jovian). Zero for deposit transactions. |
| receipt_operator_fee_scalar | NUMBER(38,0) | Gas-proportional operator-fee scalar, as reported in the transaction receipt (OP Stack Isthmus+). Set by the chain operator; Isthmus scales it by 1e6, Jovian multiplies by 100. Zero for deposit transactions. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |
