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

# Transactions

### Table Columns

Unique Key: `hash`

| Column Name                          | Data Type         | Description                                                                                                                           |
| ------------------------------------ | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------- |
| hash                                 | VARCHAR           | Unique identifier of a transaction.                                                                                                   |
| nonce                                | BIGINT            | [The transaction nonce, unique to the wallet](https://evm.org/en/glossary/#nonce)                                                     |
| transaction\_index                   | BIGINT            | The position of this transaction in the block that it belongs to. The first transaction has index 0.                                  |
| from\_address                        | VARCHAR           | The address of the sending party of this transaction.                                                                                 |
| to\_address                          | VARCHAR           | The address of the receiving party of this transaction (could be a contract address).                                                 |
| value                                | VARCHAR           | The amount of ether sent in this transaction, in wei.                                                                                 |
| gas                                  | BIGINT            | The maximum amount of gas allocated for this transaction in wei.                                                                      |
| gas\_price                           | BIGINT            | 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           | The data sent along with the transaction.                                                                                             |
| receipt\_cumulative\_gas\_used       | BIGINT            | The total amount of gas used when this transaction was executed in the block.                                                         |
| receipt\_gas\_used                   | BIGINT            | The total amount of gas consumed by a transaction as recorded in its receipt                                                          |
| receipt\_contract\_address           | VARCHAR           | The contract address created, if the transaction was a contract creation, otherwise null.                                             |
| receipt\_root                        | VARCHAR           | Transaction stateroot (pre Byzantium).                                                                                                |
| receipt\_status                      | BIGINT            | 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                        | BIGINT            | The length of the chain, in blocks.                                                                                                   |
| block\_hash                          | VARCHAR           | Unique identifier of the block that includes this transaction.                                                                        |
| transaction\_type                    | BIGINT            | The integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees.                    |
| receipt\_effective\_gas\_price       | BIGINT            | The sum of the base fee and tip paid per unit of gas.                                                                                 |
| receipt\_l1\_fee                     | BIGINT            | The Layer 1 fee paid for the transaction (applicable for Layer 2 transactions).                                                       |
| receipt\_l1\_fee\_scalar             | VARCHAR           | Multiplier used to adjust L1 data fees for L2s (applicable for Layer 2 transactions).                                                 |
| receipt\_l1\_base\_fee\_scalar       | BIGINT            | The base fee scalar component applied to L1 base fee to calculate L1 data costs for rollups (applicable for Layer 2 transactions).    |
| receipt\_l1\_gas\_price              | BIGINT            | The gas price used to compute L1 calldata fee (applicable for Layer 2 transactions).                                                  |
| receipt\_l1\_gas\_used               | BIGINT            | The amount of gas used on the L1 chain for posting transaction data (applicable for Layer 2 transactions).                            |
| receipt\_l1\_blob\_base\_fee         | BIGINT            | Base fee per blob (in wei) on L1 (post-EIP-4844) (applicable for Layer 2 transactions).                                               |
| receipt\_l1\_blob\_base\_fee\_scalar | BIGINT            | Scalar applied to blob base fee to adjust L1 blob costs on L2 (applicable for Layer 2 transactions).                                  |
| receipt\_deposit\_nonce              | BIGINT            | Nonce used to track L1→L2 deposit transactions, for tracking cross-chain deposits and preventing replay attacks.                      |
| receipt\_deposit\_receipt\_version   | BIGINT            | Version identifier for the L1 deposit receipt format.                                                                                 |
| log\_count                           | BIGINT            | 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.                                                                                                        |