This page describes Blockchain Analytics table schemas.
Avalanche Contract Chain
Tables available for analysis
- blocks: Table holding Avalanche block data.
- 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.
Ethereum Mainnet
Tables available for analysis
- accounts: Materialized view; identifies accounts as externally owned accounts or smart contracts.
- 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.
- 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 decoded ERC-20, ERC-721, and ERC-1155 token transfer events.
- 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.
Materialized views
accounts
| 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. |
Fantom Opera
Tables available for analysis
- blocks: Table holding Fantom block data.
- logs: Table holding Fantom 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.
Optimism Mainnet
Tables available for analysis
- blocks: Table holding Optimism block data.
- 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.
Tron Mainnet
Tables available for analysis
- blocks: Table holding Tron block data.
- 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
Please reference the Schema tab of each table in BigQuery:
