| 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(66) | 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. |
| receipt_l1_fee | NUMBER(38,0) | The Layer 1 fee paid for the transaction (applicable for Layer 2 transactions). |
| receipt_l1_fee_scalar | VARCHAR(16777216) | Multiplier used to adjust L1 data fees for L2s (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). |
| log_count | NUMBER(38,0) | Number of event logs emitted in the transaction. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |
| receipt_effective_gas_price | NUMBER(38,0) | The sum of the base fee and tip paid per unit of gas. |
| authorization_list | VARIANT | An array of objects present in 7702 transactions, each containing the delegated address, chain ID, nonce, signature data (r, s, yParity), and the recovered authority. |
| transaction_type | NUMBER(38,0) | The integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees. |
| 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. |
| y_parity | VARCHAR(16777216) | The parity (0 or 1) of the y-coordinate of the curve point for the signature’s recovery identifier. |
| 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). |
| deposit_receipt_version | NUMBER(38,0) | Version identifier for the deposit receipt format used in L1->L2 deposits |
| 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. |
| _extra_fields | VARIANT | Any additional fields that aren’t explicitly defined |
