🗃️Raw Events

The following are the standard table schema for all EVM chains. EVM chains include: Arbitrum, Avalanche, Base, BNB Smart Chain, Celo, Ethereum, Fantom, Linea, Optimism, and Polygon.

We now support Base and Linea!

Datasets

All EVM chain events data are named with the raw_$chain dataset names. For each EVM chain, we cover the following events: blocks, logs, token_transfers, transactions. For some EVM chains, we cover traces, contracts, balances, and token lists.

Raw EVM Chain Event Data

Blocks

Field Name	Data Type	Description
timestamp	TIMESTAMP	The timestamp for when the block was collated
number	INTEGER	The block number
hash	STRING	Hash of the block
parent_hash	STRING	Hash of the parent block
nonce	STRING	Hash of the generated proof-of-work
sha3_uncles	STRING	SHA3 of the uncles data in the block
logs_bloom	STRING	The bloom filter for the logs of the block
transactions_root	STRING	The root of the transaction trie of the block
state_root	STRING	The root of the final state trie of the block
receipts_root	STRING	The root of the receipts trie of the block
miner	STRING	The address of the beneficiary to whom the mining rewards were given
difficulty	NUMERIC	Integer of the difficulty for this block
total_difficulty	NUMERIC	Integer of the total difficulty of the chain until this block
size	INTEGER	The size of this block in bytes
extra_data	STRING	The extra data field of this block
gas_limit	INTEGER	The maximum gas allowed in this block
gas_used	INTEGER	The total used gas by all transactions in this block
transaction_count	INTEGER	The number of transactions in the block
base_fee_per_gas	INTEGER	Protocol base fee per gas, which can move up or down

Logs

Field name	Data Type	Description
log_index	INTEGER	Integer of the log index position in the block
transaction_hash	STRING	Hash of the transactions this log was created from
transaction_index	INTEGER	Integer of the transactions index position log was created from
address	STRING	Address from which this log originated
data	STRING	Contains one or more 32 Bytes non-indexed arguments of the log
topics	STRING	Indexed log arguments (0 to 4 32-byte hex strings). (In solidity: The first topic is the hash of the signature of the event (e.g. Deposit(address,bytes32,uint256)), except you declared the event with the anonymous specifier.)
block_timestamp	TIMESTAMP	Timestamp of the block where this log was in
block_number	INTEGER	The block number where this log was in
block_hash	STRING	Hash of the block where this log was in

Token Transfers

Field name	Data Type	Description
token_address	STRING	ERC20 token address
from_address	STRING	Address of the sender
to_address	STRING	Address of the receiver
value	STRING	Amount of tokens transferred (ERC20) / id of the token transferred (ERC721). Use safe_cast for casting to NUMERIC or FLOAT64
transaction_hash	STRING	Transaction hash
log_index	INTEGER	Log index in the transaction receipt
block_timestamp	TIMESTAMP	Timestamp of the block where this transfer was in
block_number	INTEGER	Block number where this transfer was in
block_hash	STRING	Hash of the block where this transfer was in

Transactions

Field name	Data Type	Description
hash	STRING	Hash of the transaction
nonce	INTEGER	The number of transactions made by the sender prior to this one
transaction_index	INTEGER	Integer of the transactions index position in the block
from_address	STRING	Address of the sender
to_address	STRING	Address of the receiver. null when its a contract creation transaction
value	NUMERIC	Value transferred in Wei
gas	INTEGER	Gas provided by the sender
gas_price	INTEGER	Gas price provided by the sender in Wei
input	STRING	The data sent along with the transaction
receipt_cumulative_gas_used	INTEGER	The total amount of gas used when this transaction was executed in the block
receipt_gas_used	INTEGER	The amount of gas used by this specific transaction alone
receipt_contract_address	STRING	The contract address created, if the transaction was a contract creation, otherwise null
receipt_root	STRING	32 bytes of post-transaction stateroot (pre Byzantium)
receipt_status	INTEGER	Either 1 (success) or 0 (failure) (post Byzantium)
block_timestamp	TIMESTAMP	Timestamp of the block where this transaction was in
block_number	INTEGER	Block number where this transaction was in
block_hash	STRING	Hash of the block where this transaction was in
max_fee_per_gas	INTEGER	Total fee that covers both base and priority fees
max_priority_fee_per_gas	INTEGER	Fee given to miners to incentivize them to include the transaction
transaction_type	INTEGER	Transaction type
receipt_effective_gas_price	INTEGER	The actual value per gas deducted from the senders account. Replacement of gas_price after EIP-1559