Text of docs.cloud.google.com › blockchain-analytics › docs › schema as Styx crawled it on Nov 19, 2026. The page may have changed since. Only its words are kept, without pictures or layout.

Open the live page

Dataset schemas | Blockchain Analytics | Google Cloud Documentation

Skip to main content Console English Deutsch Español – América Latina Français Indonesia Italiano Português – Brasil עברית 中文 – 简体 中文 – 繁體 日本語 한국어 Sign in Blockchain Analytics Start free Home Documentation Data analytics Blockchain Analytics Reference Dataset schemas Stay organized with collections Save and categorize content based on your preferences. This page describes Blockchain Analytics table schemas.

Arbitrum One Tables available for analysis blocks : Table holding Arbitrum block data. decoded_events : Table holding decoded event data for a variety of popular Arbitrum event types. logs : Table holding Arbitrum event logs emitted during on-chain activity. receipts : Table holding transaction receipts, data about outcomes of transactions. transactions : Table holding transactions which are actions initiated by externally owned accounts.

Avalanche Contract Chain Tables available for analysis blocks : Table holding Avalanche block data. decoded_events : Table holding decoded event data for a variety of popular Avalanche event types. logs : Table holding Avalanche event logs emitted during on-chain activity. receipts : Table holding transaction receipts, data about outcomes of transactions. transactions : Table holding transactions which are actions initiated by externally owned accounts.

Cronos Mainnet Tables available for analysis blocks : Table holding Cronos block data. decoded_events : Table holding decoded event data for a variety of popular Cronos event types. logs : Table holding Cronos event logs emitted during on-chain activity. receipts : Table holding transaction receipts, data about outcomes of transactions. transactions : Table holding transactions which are actions initiated by externally owned accounts.

Ethereum Goerli Tables available for analysis blocks : Table holding Ethereum Goerli block data. decoded_events : Table holding decoded event data for a variety of popular Ethereum Goerli event types. logs : Table holding Ethereum Goerli event logs emitted during on-chain activity. receipts : Table holding transaction receipts, data about outcomes of transactions. transactions : Table holding transactions which are actions initiated by externally owned accounts.

Ethereum Mainnet Tables available for analysis accounts_state : Table holding account state at block heights where the account was seen transacting on-chain (excludes internal transactions). blocks : Table holding Ethereum block data. decoded_events : Table holding decoded event data for a variety of popular Ethereum event types. logs : Table holding Ethereum event logs emitted during on-chain activity. receipts : Table holding transaction receipts, data about outcomes of transactions. token_transfers : Table holding ERC-20, ERC-721, and ERC-1155 token transfers. traces : Table holding Parity-style traces which show actions executed by the EVM for some specific transaction or block reward. transactions : Table holding transactions which are actions initiated by externally owned accounts.

Clustered materialized views accounts : Identifies accounts as externally owned accounts or smart contracts with the following schema, clustered on address . Field name BigQuery type Description address STRING Address identifying the account. code STRING Compiled runtime bytecode of this account, given the account is a smart contract. code_hash STRING Hash of the code of the account. For all externally-owned accounts this will be 0xc5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a470 .

This is the hash when there is no code present. is_contract BOOLEAN Whether or not this address is a smart contract. True, if the address identifies a smart contract. accounts_state_by_address : Materialized view that has the same schema as the accounts_state table and clusters the data on the address column. transactions_by_from_address : Materialized view that has the same schema as the transactions table and clusters the data on the from_address column. transactions_by_to_address : Materialized view that has the same schema as the transactions table and clusters the data on the to_address column.

Optimism Mainnet Tables available for analysis blocks : Table holding Optimism block data. decoded_events : Table holding decoded event data for a variety of popular Optimism event types. logs : Table holding Optimism event logs emitted during on-chain activity. receipts : Table holding transaction receipts, data about outcomes of transactions. transactions : Table holding transactions which are actions initiated by externally owned accounts.

Polygon Mainnet Tables available for analysis blocks : Table holding Polygon block data. decoded_events : Table holding decoded event data for a variety of popular Polygon event types. logs : Table holding Polygon event logs emitted during on-chain activity. receipts : Table holding transaction receipts, data about outcomes of transactions. transactions : Table holding transactions which are actions initiated by externally owned accounts.

Tron Mainnet blocks : Table holding Tron block data. decoded_events : Table holding decoded event data for a variety of popular Tron event types. logs : Table holding Tron event logs emitted during on-chain activity. receipts : Table holding transaction receipts, data about outcomes of transactions. transactions : Table holding transactions which are actions initiated by externally owned accounts. BigQuery schemas Reference the Schema tab of each table in BigQuery: Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License .

For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates. Last updated 2026-11-10 UTC.