| 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 | VARCHAR(16777216) | 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. |
| 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. |
| fee_token | VARCHAR(16777216) | The token address used to pay transaction fees, enabling gas payment in tokens other than the native currency (ERC-4337 account abstraction). |
| receipt_fee_token | VARCHAR(16777216) | The actual token used for fee payment as recorded in the transaction receipt, may differ from the requested fee_token. |
| fee_payer_signature | VARCHAR(16777216) | The signature authorizing a third party (paymaster) to pay transaction fees on behalf of the sender (ERC-4337 sponsored transactions). |
| receipt_fee_payer | VARCHAR(16777216) | The address that paid the transaction fees, which may differ from the sender when using paymasters or sponsored transactions. |
| nonce_key | VARCHAR(16777216) | The key component of a two-dimensional nonce system, allowing multiple independent nonce sequences per account (ERC-4337). |
| calls | VARIANT | Array of call data for batch transactions, enabling multiple contract calls in a single transaction (account abstraction feature). |
| signature | VARIANT | The cryptographic signature authorizing the transaction, format varies based on the account type (EOA vs smart contract wallet). |
| valid_before | TIMESTAMP_NTZ(9) | The Unix timestamp before which the transaction authorization is valid, used for time-bounded permits (ERC-3009). |
| valid_after | TIMESTAMP_NTZ(9) | The Unix timestamp after which the transaction authorization becomes valid, used for delayed execution permits (ERC-3009). |
| aa_authorization_list | VARIANT | List of account abstraction authorizations for ERC-4337 UserOperations, containing paymaster and signature data. |
| key_authorization | VARCHAR(16777216) | Authorization data for key-based access control in smart contract wallets, specifying permitted signing keys. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |
