Transactions

Table Columns

Column NameDescription

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

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.

max_fee_per_gas

max_priority_fee_per_gas

receipt_cumulative_gas_used

The total amount of gas used when this transaction was executed in the block.

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

log_count

Number of event logs emitted in the transaction.

transaction_type

The integer of the transaction type, 0x0 for legacy transactions, 0x1 for access list types, 0x2 for dynamic fees.

_created_at

Timestamp of the entry creation.

_updated_at

Timestamp of the entry update.

Last updated