goerli.transactions

SQL table schema for goerli.transactions and goerli.recent_transactions

Goerli Block transactions,

Column Name	Data Type	Description
hash	CHARACTER VARYING	The transaction's hash
nonce	BIGINT	Incremental account transaction number
transaction_index	BIGINT	Index of transaction in block
from_address	CHARACTER VARYING	Address of sender, signing transaction
to_address	CHARACTER VARYING	The receiving address, a contract or externally-owned.
value	DECIMAL	The amount of Wei to transfer.
gas	BIGINT	The maximum allowed gas for the transaction.
gas_price	BIGINT	The price the sender is willing to pay per unit of gas
input	CHARACTER VARYING	optional, arbitrary input data
receipt_cumulative_gas_used	BIGINT	Total amount of gas used in the block, inclusive of this transaction
receipt_gas_used	BIGINT	Gas used in this transaction
receipt_contract_address	CHARACTER VARYING	Contract address, if created
receipt_root	CHARACTER VARYING	Pre-byzantine, the post-transaction state root.
receipt_status	BIGINT	Status, from the receipt, indicating either success (1) or failure (0).
block_timestamp	BIGINT	Unix time when the block including this transaction was mined.
block_number	BIGINT	The number of the block including this transaction
block_hash	CHARACTER VARYING	The hash of the block including this transaction
max_fee_per_gas	BIGINT	The maximum allowed fee per gas for the transaction.
max_priority_fee_per_gas	BIGINT	The maximum allowed priority fee per gas for the transaction.
transaction_type	BIGINT	The transactionType id
receipt_effective_gas_price	BIGINT	Effective/cumulative gas price. Minimum of the max gas price, or the base fee plus inclusion fee.
max_fee_per_blob_gas	DECIMAL	The maximum allowed fee for blob gas, associated with EIP-4844 (since Cancun upgrade)
blob_versioned_hashes	ARRAY	Array of 32 byte data. Represents blob hashes associated with the transaction's EIP-4844 data (since Cancun upgrade)