Table of contents

The eth_mainnet.logs Logs tables store all logs data that gets generated by smart contracts.

Columns

Name	Type	Description
tx_hash	varchar	The transaction hash of the transaction that produced this log
tx_index	integer	The index position of the transaction in this block (cumulative amount of transactions ordered by execution)
block_hash	varchar	A unique identifier for that block
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 log
log_index	integer	This logs index position in the block (cumulative amount of logs ordered by execution)
contract_address	varchar	The address of the contract that emitted the log
data	varchar	Unindexed data containing further information on the event
topic0	varchar	Keccak256 hash of a flattened event declaration string
topic1	varchar	Second indexed topic of the event
topic2	varchar	Third indexed topic of the event
topic3	varchar	Fourth indexed topic of the event
removed	varchar	N/A
ym	varchar	Year month