Transactions
Transactions are cryptographically signed instructions from accounts.
An account will initiate a transaction to update the state of the blockchain network. Transactions always originate from an externally owned account (a smart contract can not initiate a transaction). 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.
Learn more in the official Ethereum documentation here.
Table Columns
Unique Key: hash
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 | |
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. |
access_list | Optional list of addresses and storage keys that the transaction plans to access. Helps reduce gas costs for complex transactions. |
y_parity | The parity (0 for even, 1 for odd) of the y-coordinate of the curve point for which r is the x-coordinate in secp256k1 signature. |
beneficiary | The address that receives the transaction fees (typically used in certain L2 solutions). |
deposit_value | The amount of ETH deposited in a deposit transaction |
l1_base_fee | The base fee of the L1 block referenced by this L2 transaction (relevant for L2 scaling solutions). |
max_submission_fee | The maximum fee the user is willing to pay for submitting the transaction |
retry_to | The address to which a retry transaction is sent |
retry_value | The value associated with a retry transaction. |
retry_data | The data payload associated with a retry transaction. |
refund_to | The address to which any refunds should be sent |
request_id | A unique identifier for the transaction request |
_created_at | Timestamp of the entry creation. |
_updated_at | Timestamp of the entry update. |
Last updated