Transactions

Transactions, which change the state of the EVM, need to be broadcast to the whole network. Any node can broadcast a request for a transaction to be executed on the EVM; after this happens, a validator will execute the transaction and propagate the resulting state change to the rest of the network.

Table Columns

Column Name	Description
block_number	The length of the chain, in blocks.
block_timestamp	The time when the block that contains this transaction was included on the blockchain.
block_hash	Unique identifier of the block that includes this transaction.
hash	Unique identifier of a transaction.
nonce	The transaction nonce, unique to the wallet
transaction_index	The position of this transaction in the block that it belongs to. The first transaction has index 0.
from_address	The address of the sending party of this transaction.
to_address	The address of the receiving party of this transaction (could be a contract address).
value	The amount of ether sent in this transaction, in wei.
gas	The maximum amount of gas allocated for this transaction in wei.
gas_price	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	The data send along with the transaction.
log_count	Number of event logs emitted in the transaction.
transaction_type	The integer of the transaction type, 0 for legacy transactions, 1 for access list types, 2 for dynamic fees.
max_fee_per_gas	The maximum fee per gas that the transaction sender is willing to pay for this transaction (introduced in EIP1559)
max_priority_fee_per_gas	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)
receipt_cumulative_gas_used	The total amount of gas used when this transaction was executed in the block.
receipt_gas_used	Gas consumed by the transaction in wei.
receipt_effective_gas_price	The sum of the base fee and tip paid per unit of gas.
receipt_contract_address	The contract address created, if the transaction was a contract creation, otherwise null.
receipt_root	Transaction stateroot (pre Byzantium)
receipt_status	Success status of the transaction. Either 1 (success) or 0 (failure).
receipt_l1_fee	The fee associated with a transaction on the Layer 1, it is calculated as l1GasPrice multiplied by l1GasUsed.
receipt_l1_fee_scalar	A multiplier applied to the actual gas usage on Layer 1 to calculate the dynamic costs. If set to 1, it has no impact on the L1 gas usage.
receipt_l1_gas_price	L1 gas price that the Sequencer will use to estimate the L1 portion of fees (calldata costs).
receipt_l1_gas_used	The amount of gas consumed by a transaction on the Layer 1.
_created_at	Timestamp of the entry creation.
_updated_at	Timestamp of the entry update.