Raw
ethereum.logs
Description of the ethereum.logs table on Dune
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
Datatypes on Snowflake datashare are different in some cases, read more here.
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
Was this page helpful?