| 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_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| 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 | VARCHAR(16777216) | 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. |
| 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. |
| 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_l1_gas_used | NUMBER(38,0) | The amount of gas used on the L1 chain for posting transaction data (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_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_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). |
| 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. |
| log_count | NUMBER(38,0) | Number of event logs emitted in the transaction. |
| transaction_type | NUMBER(38,0) | Ethereum transaction envelope type. 0 = Legacy, 1 = Access List (EIP-2930), 2 = EIP-1559 dynamic fee. |
| source_hash | VARCHAR(66) | Hash that uniquely identifies the source of a deposit transaction on OP Stack chains. Derived from the L1 origin block hash and deposit index, used to prevent replay of the same L1 deposit. |
| chain_id | NUMBER(38,0) | The unique identifier of the blockchain network. |
| mint | VARCHAR(16777216) | Amount of ETH minted on L2 by this transaction. Populated for OP Stack deposit transactions bridging ETH from L1. |
| receipt_l1_base_fee_scalar | NUMBER(38,0) | Scalar applied to the L1 base fee when computing the L1 data cost for this transaction (OP Stack Ecotone fee model). Expressed in units of 1e-6. |
| receipt_l1_blob_base_fee | NUMBER(38,0) | L1 blob base fee (in wei) at the time this transaction was included, used to compute the blob portion of the L1 data cost (OP Stack Ecotone fee model). |
| receipt_l1_blob_base_fee_scalar | NUMBER(38,0) | Scalar applied to the L1 blob base fee when computing the L1 data cost for this transaction (OP Stack Ecotone fee model). Expressed in units of 1e-6. |
| 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. |
| 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. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| receipt_blob_gas_used | NUMBER(38,0) | Amount of blob gas consumed by this transaction (EIP-4844). Each blob uses a fixed 131,072 units of blob gas; a transaction carrying N blobs uses N × 131,072. |
| 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). |
| 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. |
