> ## 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

### Table Details

| Property | Value |
| - | - |
| Table Name | `arbitrum.wallet_features.first_txn_per_wallet` |
| Table Status | Production-Ready |
| Clustering Key(s) | `block_timestamp::date` |
| Search Optimization | `from_address`, `to_address`, `hash` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| 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 | NUMBER(38,0) | 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. |
| 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\_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. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| 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\_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| 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). |
| 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. |
| transaction\_type | NUMBER(38,0) | Ethereum transaction envelope type. 0 = Legacy, 1 = Access List (EIP-2930), 2 = EIP-1559 dynamic fee. |
| receipt\_gas\_used\_for\_l1 | NUMBER(38,0) | |
| receipt\_l1\_block\_number | NUMBER(38,0) | |
| log\_count | NUMBER(38,0) | Number of event logs emitted in the transaction. |
| \_updated\_at | TIMESTAMP\_LTZ(9) | Timestamp of when the entry was last updated in the database. |

### Related Docs

* [EVM Wallet Features First Txn Per Wallet](https://docs.allium.so/historical-data/supported-blockchains/evm/core-schemas/wallet_features/first-txn-per-wallet.md)