bob.logs

Description of the bob.logs table on Dune

The data for the bob tables is hosted on Dune by the bob team in the context of Hosted blockchain integrations - a legacy integration route which only includes raw EVM data. We are working to migrate it over to the standard EVM integration.

Table Description

The bob.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. If the chain is a Fully Managed chain, decoded transaction calls will be available, see call tables section. If this is a Hosted chain, decoded call tables will not be available.

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 bob.logs
WHERE contract_address = 0x06012c8cf97bead5deae237070f9587f8e7a266d
LIMIT 10

Filter the logs for a specific topic

SELECT *
FROM bob.logs
WHERE topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef

Show the logs of a specific block

SELECT *
FROM bob.logs
WHERE evt_block_number = 1000000