EVM Schema
The EVM schema covers blocks, transactions, logs, traces, transfers, and contract activity across supported EVM networks. Browse the tables below to find their fields, data types, sort keys, and partition strategies. For practical examples, see EVM Queries.
Querying EVM Data
The EVM schema contains data from multiple networks. Choose the network and block range you want to analyze, and check how a table stores addresses and hashes before using them in a query.
Most tables have a network column. Find valid values in evm_native_currencies and filter on the network you need. The exception is evm_runtime_codes, which has no network column. For large tables, use the sort and partition keys listed below to narrow the data scanned. Many tables use block_number; evm_blocks uses number instead.
Addresses and hashes stored as FixedString are raw bytes. Use hex() to display them, or unhex() to filter with a hexadecimal value after removing its 0x prefix. The same applies to String columns described as raw bytes. Some fields are nullable because their availability varies by network and protocol era.
Complete Schema
Select a table to view its fields, sort keys, and partition strategy.
evm_blocksone row per block. Minmax on block_datetime, ingested_at.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
number | UInt64 | Yes | |
hash | FixedString(32) | No | |
parent_hash | FixedString(32) | No | |
timestamp | UInt64 | No | Unix seconds |
block_datetime | DateTime | No | |
sha3_uncles | Nullable(FixedString(32)) | No | |
logs_bloom | String | No | raw bytes |
transactions_root | Nullable(FixedString(32)) | No | |
state_root | Nullable(FixedString(32)) | No | |
receipts_root | Nullable(FixedString(32)) | No | |
miner | Nullable(FixedString(20)) | No | |
difficulty | Nullable(UInt256) | No | |
total_difficulty | Nullable(UInt256) | No | |
extra_data | String | No | raw bytes |
mix_hash | Nullable(FixedString(32)) | No | |
nonce | Nullable(FixedString(8)) | No | |
size | Nullable(UInt64) | No | |
gas_limit | Nullable(UInt64) | No | |
gas_used | Nullable(UInt64) | No | |
base_fee_per_gas | Nullable(UInt64) | No | |
withdrawals_root | Nullable(FixedString(32)) | No | |
blob_gas_used | Nullable(UInt64) | No | |
excess_blob_gas | Nullable(UInt64) | No | |
parent_beacon_block_root | Nullable(FixedString(32)) | No | |
requests_hash | Nullable(FixedString(32)) | No | |
uncles | Array(FixedString(32)) | No | |
withdrawal_indexes | Array(UInt64) | No | parallel arrays: entry i is one withdrawal |
withdrawal_validator_indexes | Array(UInt64) | No | parallel arrays: entry i is one withdrawal |
withdrawal_addresses | Array(FixedString(20)) | No | parallel arrays: entry i is one withdrawal |
withdrawal_amounts | Array(UInt64) | No | gwei; parallel with the other withdrawal_* arrays |
transaction_hashes | Array(FixedString(32)) | No | in block order |
transaction_count | UInt32 | No | |
l1_block_number | Nullable(UInt64) | No | L2 (Arbitrum / zkSync) |
send_root | Nullable(FixedString(32)) | No | Arbitrum |
send_count | Nullable(UInt64) | No | L2 (Arbitrum / zkSync) |
l1_batch_number | Nullable(UInt64) | No | L2 (Arbitrum / zkSync) |
l1_batch_timestamp | Nullable(UInt64) | No | L2 (Arbitrum / zkSync) |
other | String | No | JSON of unmodeled header keys, '' if none |
ingested_at | DateTime64(3) | No | ingestion freshness |
evm_contract_changescontract lifecycle events.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
address | FixedString(20) | Yes | |
block_number | UInt64 | Yes | |
block_hash | FixedString(32) | Yes | |
block_datetime | DateTime | No | |
transaction_hash | FixedString(32) | No | |
transaction_index | UInt32 | Yes | |
change_id | FixedString(32) | Yes | |
change_type | LowCardinality(String) | No | see the values in use with SELECT DISTINCT change_type and a network filter |
deployer | Nullable(FixedString(20)) | No | |
trace_address | Array(UInt32) | No | |
log_index | Nullable(UInt32) | No | |
runtime_code_hash | Nullable(FixedString(32)) | No | |
direct_kind | LowCardinality(Nullable(String)) | No | see the values in use with SELECT DISTINCT direct_kind and a network filter |
minimal_proxy_implementation | Nullable(FixedString(20)) | No | |
relation_kind | LowCardinality(Nullable(String)) | No | |
relation_key | String | No | |
target_address | Nullable(FixedString(20)) | No | |
provenance | LowCardinality(String) | No |
evm_logsone row per event log (reorg-removed logs excluded). Bloom on address, topic0. Minmax on block_datetime.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
block_number | UInt64 | Yes | |
block_hash | FixedString(32) | No | |
block_datetime | DateTime | No | |
transaction_hash | FixedString(32) | No | |
transaction_index | UInt32 | Yes | |
log_index | UInt32 | Yes | index within the block |
address | FixedString(20) | No | emitting contract |
topic0 | Nullable(FixedString(32)) | No | event signature hash (null for anonymous events) |
topic1 | Nullable(FixedString(32)) | No | indexed argument, positional; an address is left-padded to 32 bytes |
topic2 | Nullable(FixedString(32)) | No | indexed argument, positional; an address is left-padded to 32 bytes |
topic3 | Nullable(FixedString(32)) | No | indexed argument, positional; an address is left-padded to 32 bytes |
data | String | No | raw ABI-encoded data bytes |
l1_batch_number | Nullable(UInt64) | No | zkSync |
log_type | Nullable(String) | No | zkSync |
other | String | No |
evm_native_currenciesnative currency of each network. Small. Lists every valid network name.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
chain_id | UInt64 | No | |
native_asset | LowCardinality(String) | No | CAIP, e.g. slip44:60 |
symbol | LowCardinality(String) | No | |
decimals | UInt8 | No | |
updated_at | DateTime64(3) | No |
evm_native_transfersnative value movements with value > 0. Bloom on from_address, to_address.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
block_number | UInt64 | Yes | |
block_hash | FixedString(32) | Yes | |
block_datetime | DateTime | No | |
transaction_hash | FixedString(32) | No | |
transaction_index | UInt32 | Yes | |
trace_address | Array(UInt32) | Yes | |
call_type | LowCardinality(String) | No | |
is_internal | Bool | No | false = transaction-level value, true = internal call |
from_address | FixedString(20) | No | |
to_address | FixedString(20) | No | |
amount | UInt256 | No | wei |
evm_protocol_contractsregistered protocol contracts (wrapped native tokens, ...). Small.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
address | FixedString(20) | Yes | |
valid_from_block | UInt64 | Yes | |
valid_to_block | Nullable(UInt64) | No | exclusive; null = current |
protocol_kind | LowCardinality(String) | No | |
decoder_kind | LowCardinality(Nullable(String)) | No | |
asset_kind | LowCardinality(Nullable(String)) | No | |
symbol | LowCardinality(Nullable(String)) | No | |
decimals | Nullable(UInt8) | No | |
overlaps_native_balance | Bool | No | true = do not sum with native transfers |
updated_at | DateTime64(3) | No |
evm_runtime_codesdeployed bytecode by hash (no network column).
| Column | Type | Sort Key | Notes |
|---|---|---|---|
runtime_code_hash | FixedString(32) | Yes | |
runtime_code | String | No | raw deployed bytecode; large |
direct_kind | LowCardinality(String) | No | |
minimal_proxy_implementation | Nullable(FixedString(20)) | No | |
classifier_version | UInt32 | No | |
producer_revision | LowCardinality(String) | No |
evm_token_metadatatoken name, symbol and decimals by block range. Small.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
address | FixedString(20) | Yes | |
valid_from_block | UInt64 | Yes | |
valid_to_block | Nullable(UInt64) | No | exclusive; null = current |
name | Nullable(String) | No | |
symbol | LowCardinality(Nullable(String)) | No | |
decimals | Nullable(UInt8) | No | |
updated_at | DateTime64(3) | No |
evm_tracesone row per callTracer frame. Bloom on from_address, to_address.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
block_number | UInt64 | Yes | |
block_hash | Nullable(FixedString(32)) | No | |
block_datetime | DateTime | No | |
transaction_hash | Nullable(FixedString(32)) | No | |
transaction_index | UInt32 | Yes | |
trace_address | Array(UInt32) | Yes | [] = the top-level call, [0,2] = third child of first child; length() = depth |
emitted_logs | Array(Tuple(Nullable(UInt32), Nullable(UInt32))) | No | (index, position) of logs emitted by this frame |
call_type | LowCardinality(String) | No | CALL, DELEGATECALL, STATICCALL, CALLCODE, CREATE, CREATE2, SELFDESTRUCT; '' = the whole trace failed |
from_address | Nullable(FixedString(20)) | No | |
to_address | Nullable(FixedString(20)) | No | the created contract for CREATE* |
value | Nullable(UInt256) | No | wei |
gas | Nullable(UInt64) | No | |
gas_used | Nullable(UInt64) | No | |
input | String | No | raw bytes |
output | String | No | raw bytes |
error | LowCardinality(String) | No | '' on success |
revert_reason | String | No | |
subtraces | UInt32 | No | |
other | String | No | |
entry_other | String | No |
evm_transactionsone row per transaction, receipt fields merged in. Minmax on block_datetime. A projection on (network, hash) makes WHERE network = … AND hash = unhex('…') fast.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
block_number | UInt64 | Yes | |
block_hash | FixedString(32) | No | |
block_datetime | DateTime | No | |
hash | FixedString(32) | No | |
transaction_index | UInt32 | Yes | |
from_address | Nullable(FixedString(20)) | No | |
to_address | Nullable(FixedString(20)) | No | null for contract creation |
nonce | Nullable(UInt64) | No | |
gas | Nullable(UInt64) | No | |
value | Nullable(UInt256) | No | wei |
gas_price | Nullable(UInt256) | No | wei |
max_fee_per_gas | Nullable(UInt256) | No | wei |
max_priority_fee_per_gas | Nullable(UInt256) | No | wei |
max_fee_per_blob_gas | Nullable(UInt256) | No | wei |
input | String | No | raw calldata bytes; the first 4 bytes are the selector |
transaction_type | Nullable(UInt8) | No | 0 legacy, 1 2930, 2 1559, 3 blob, 4 7702 |
chain_id | Nullable(UInt256) | No | |
access_list_addresses | Array(FixedString(20)) | No | |
access_list_storage_keys | Array(Array(FixedString(32))) | No | |
blob_versioned_hashes | Array(FixedString(32)) | No | |
authorization_chain_ids | Array(UInt256) | No | EIP-7702, parallel arrays |
authorization_addresses | Array(FixedString(20)) | No | EIP-7702, parallel arrays |
authorization_nonces | Array(UInt64) | No | EIP-7702, parallel arrays |
authorization_y_parities | Array(UInt8) | No | EIP-7702, parallel arrays |
authorization_rs | Array(UInt256) | No | EIP-7702, parallel arrays |
authorization_ss | Array(UInt256) | No | EIP-7702, parallel arrays |
v | Nullable(UInt256) | No | |
y_parity | Nullable(UInt8) | No | |
r | Nullable(UInt256) | No | |
s | Nullable(UInt256) | No | |
source_hash | Nullable(FixedString(32)) | No | OP-Stack deposits |
mint | Nullable(UInt256) | No | OP-Stack deposits |
is_system_tx | Nullable(Bool) | No | OP-Stack deposits |
request_id | Nullable(FixedString(32)) | No | Arbitrum |
ticket_id | Nullable(FixedString(32)) | No | Arbitrum |
beneficiary | Nullable(FixedString(20)) | No | Arbitrum |
l1_batch_number | Nullable(UInt64) | No | zkSync |
l1_batch_tx_index | Nullable(UInt64) | No | zkSync |
status | Nullable(Bool) | No | receipt status: true = success (null pre-Byzantium, see root) |
root | Nullable(FixedString(32)) | No | pre-Byzantium |
cumulative_gas_used | UInt64 | No | |
gas_used | UInt64 | No | |
effective_gas_price | Nullable(UInt256) | No | wei; fee = gas_used * effective_gas_price |
receipt_blob_gas_used | Nullable(UInt64) | No | |
blob_gas_price | Nullable(UInt256) | No | blob fee = receipt_blob_gas_used * blob_gas_price |
contract_address | Nullable(FixedString(20)) | No | set on contract creation |
logs_bloom | String | No | |
log_count | UInt32 | No | |
l1_gas_used | Nullable(UInt64) | No | OP-Stack |
l1_gas_price | Nullable(UInt256) | No | OP-Stack |
l1_fee | Nullable(UInt256) | No | OP-Stack |
l1_fee_scalar | Nullable(String) | No | OP-Stack; decimal text, e.g. "0.684" |
l1_base_fee_scalar | Nullable(UInt64) | No | OP-Stack |
l1_blob_base_fee | Nullable(UInt256) | No | OP-Stack |
l1_blob_base_fee_scalar | Nullable(UInt64) | No | OP-Stack |
deposit_nonce | Nullable(UInt64) | No | OP-Stack |
deposit_receipt_version | Nullable(UInt64) | No | OP-Stack |
receipt_l1_block_number | Nullable(UInt64) | No | Arbitrum |
gas_used_for_l1 | Nullable(UInt64) | No | Arbitrum |
receipt_l1_batch_number | Nullable(UInt64) | No | zkSync |
receipt_l1_batch_tx_index | Nullable(UInt64) | No | zkSync |
other | String | No | JSON of unmodeled keys |
receipt_other | String | No | JSON of unmodeled keys |
evm_transfer_asset_blocksper-block completion ledger of the transfer pipeline. max(block_number) is the transfer data head.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
block_number | UInt64 | Yes | |
block_hash | FixedString(32) | No | |
source_uuid | UUID | No | |
source_kind | LowCardinality(String) | No | |
source_topic | Nullable(String) | No | |
source_partition | Nullable(Int32) | No | |
source_offset | Nullable(Int64) | No |
evm_transfer_candidatesTransfer-shaped logs (ERC-20/721/1155, WETH9 Deposit/Withdrawal, ...). Sorted by token address, so per-token queries are fast. Bloom on topic0…topic3.
| Column | Type | Sort Key | Notes |
|---|---|---|---|
network | LowCardinality(String) | Yes | |
address | FixedString(20) | Yes | token contract (the sort key after network) |
block_number | UInt64 | Yes | |
block_hash | FixedString(32) | Yes | |
block_datetime | DateTime | No | |
transaction_hash | FixedString(32) | No | |
transaction_index | UInt32 | Yes | |
log_index | UInt32 | Yes | |
topic0 | FixedString(32) | No | Transfer, TransferSingle, TransferBatch, Deposit or Withdrawal signature |
topic1 | Nullable(FixedString(32)) | No | |
topic2 | Nullable(FixedString(32)) | No | |
topic3 | Nullable(FixedString(32)) | No | |
data | String | No | raw ABI-encoded data bytes |