Table of contents

The eth_mainnet.transactions table provides indexed views of all transactions that succeeded, or were partially successful (had at least 1 successful internal transaction).

Columns

Name	Type	Description
block_hash	varchar	The length of the blockchain in blocks
block_number	integer	The length of the blockchain in blocks
timestamp	integer	The block time
block_time	date	The time when the block was mined that includes this transaction
hash	varchar	The hash of the transaction
nonce	varchar	The transaction nonce, unique to that wallet
tx_index	integer	The transactions index position in the block
from	varchar	Address of the sender
to	varchar	Address of the receiver.
value	varchar	The amount of [chain_gas_token] sent in this transaction in wei.
gas_price	decimal(38,0)	The gas price in wei
gas	decimal(38,0)	The gas limit in wei
input	varchar	N/A
status	boolean	N/A
contract_address	varchar	The address of the contract that emitted the transactions
cumulative_gas_used	varchar	N/A
gas_used	decimal(38,0)	The gas consumed by the transaction in wei
effective_gas_price	decimal(38,0)	The gas price this transaction paid in wei
logs_bloom	varchar	Obtain the logs bloom from a list of log entries.
ym	varchar	Year month