🗃️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.
Last updated
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.
Last updated
We now support Base and Linea!
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.
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
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_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
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
