ethereum.logs

​

Table Description

The logs table represents the logs generated by the Ethereum Virtual Machine (EVM) when a contract is executed. Logs are a way to store data on the blockchain. Logs originate from events that occur during the execution of a smart contract. A log consists of:

• topic list: a list of 0 to 4 32-byte data topics. Topic0 is the hash of the signature of the event (indexed), and the remaining topics are indexed parameters of the event.
• data: contains non-indexed data.

This is the raw version of this table, for decoded event logs, see the decoded logs section.

​

Column Descriptions

​

Table Sample

​

Examples

​

Filter the logs for a specific contract

select *
from ethereum.logs
where contract_address = 0x06012c8cf97bead5deae237070f9587f8e7a266d
limit 10

​

Filter the logs for a specific topic

select *
from ethereum.logs
where topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef

​

Show the logs of a specific block

SELECT *
FROM ethereum.logs
WHERE evt_block_number = 1000000