> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# First Txn Per Wallet

The first transaction sent by each wallet, with the full transaction and receipt fields of that transaction.

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| 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. |