Skip to main content

EVM Schema

Updated on
Nov 16, 2026

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.
40 fields and storage details
Sort keys network, numberPartition (network, intDiv(number, 1000000))
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
numberUInt64Yes
hashFixedString(32)No
parent_hashFixedString(32)No
timestampUInt64NoUnix seconds
block_datetimeDateTimeNo
sha3_unclesNullable(FixedString(32))No
logs_bloomStringNoraw bytes
transactions_rootNullable(FixedString(32))No
state_rootNullable(FixedString(32))No
receipts_rootNullable(FixedString(32))No
minerNullable(FixedString(20))No
difficultyNullable(UInt256)No
total_difficultyNullable(UInt256)No
extra_dataStringNoraw bytes
mix_hashNullable(FixedString(32))No
nonceNullable(FixedString(8))No
sizeNullable(UInt64)No
gas_limitNullable(UInt64)No
gas_usedNullable(UInt64)No
base_fee_per_gasNullable(UInt64)No
withdrawals_rootNullable(FixedString(32))No
blob_gas_usedNullable(UInt64)No
excess_blob_gasNullable(UInt64)No
parent_beacon_block_rootNullable(FixedString(32))No
requests_hashNullable(FixedString(32))No
unclesArray(FixedString(32))No
withdrawal_indexesArray(UInt64)Noparallel arrays: entry i is one withdrawal
withdrawal_validator_indexesArray(UInt64)Noparallel arrays: entry i is one withdrawal
withdrawal_addressesArray(FixedString(20))Noparallel arrays: entry i is one withdrawal
withdrawal_amountsArray(UInt64)Nogwei; parallel with the other withdrawal_* arrays
transaction_hashesArray(FixedString(32))Noin block order
transaction_countUInt32No
l1_block_numberNullable(UInt64)NoL2 (Arbitrum / zkSync)
send_rootNullable(FixedString(32))NoArbitrum
send_countNullable(UInt64)NoL2 (Arbitrum / zkSync)
l1_batch_numberNullable(UInt64)NoL2 (Arbitrum / zkSync)
l1_batch_timestampNullable(UInt64)NoL2 (Arbitrum / zkSync)
otherStringNoJSON of unmodeled header keys, '' if none
ingested_atDateTime64(3)Noingestion freshness
evm_contract_changescontract lifecycle events.
19 fields and storage details
Sort keys network, address, block_number, block_hash, transaction_index, change_idPartition network
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
addressFixedString(20)Yes
block_numberUInt64Yes
block_hashFixedString(32)Yes
block_datetimeDateTimeNo
transaction_hashFixedString(32)No
transaction_indexUInt32Yes
change_idFixedString(32)Yes
change_typeLowCardinality(String)Nosee the values in use with SELECT DISTINCT change_type and a network filter
deployerNullable(FixedString(20))No
trace_addressArray(UInt32)No
log_indexNullable(UInt32)No
runtime_code_hashNullable(FixedString(32))No
direct_kindLowCardinality(Nullable(String))Nosee the values in use with SELECT DISTINCT direct_kind and a network filter
minimal_proxy_implementationNullable(FixedString(20))No
relation_kindLowCardinality(Nullable(String))No
relation_keyStringNo
target_addressNullable(FixedString(20))No
provenanceLowCardinality(String)No
evm_logsone row per event log (reorg-removed logs excluded). Bloom on address, topic0. Minmax on block_datetime.
16 fields and storage details
Sort keys network, block_number, transaction_index, log_indexPartition (network, intDiv(block_number, 1000000))
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
block_numberUInt64Yes
block_hashFixedString(32)No
block_datetimeDateTimeNo
transaction_hashFixedString(32)No
transaction_indexUInt32Yes
log_indexUInt32Yesindex within the block
addressFixedString(20)Noemitting contract
topic0Nullable(FixedString(32))Noevent signature hash (null for anonymous events)
topic1Nullable(FixedString(32))Noindexed argument, positional; an address is left-padded to 32 bytes
topic2Nullable(FixedString(32))Noindexed argument, positional; an address is left-padded to 32 bytes
topic3Nullable(FixedString(32))Noindexed argument, positional; an address is left-padded to 32 bytes
dataStringNoraw ABI-encoded data bytes
l1_batch_numberNullable(UInt64)NozkSync
log_typeNullable(String)NozkSync
otherStringNo
evm_native_currenciesnative currency of each network. Small. Lists every valid network name.
6 fields and storage details
Sort keys networkPartition None
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
chain_idUInt64No
native_assetLowCardinality(String)NoCAIP, e.g. slip44:60
symbolLowCardinality(String)No
decimalsUInt8No
updated_atDateTime64(3)No
evm_native_transfersnative value movements with value > 0. Bloom on from_address, to_address.
12 fields and storage details
Sort keys network, block_number, block_hash, transaction_index, trace_addressPartition (network, intDiv(block_number, 1000000))
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
block_numberUInt64Yes
block_hashFixedString(32)Yes
block_datetimeDateTimeNo
transaction_hashFixedString(32)No
transaction_indexUInt32Yes
trace_addressArray(UInt32)Yes
call_typeLowCardinality(String)No
is_internalBoolNofalse = transaction-level value, true = internal call
from_addressFixedString(20)No
to_addressFixedString(20)No
amountUInt256Nowei
evm_protocol_contractsregistered protocol contracts (wrapped native tokens, ...). Small.
11 fields and storage details
Sort keys network, address, valid_from_blockPartition network
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
addressFixedString(20)Yes
valid_from_blockUInt64Yes
valid_to_blockNullable(UInt64)Noexclusive; null = current
protocol_kindLowCardinality(String)No
decoder_kindLowCardinality(Nullable(String))No
asset_kindLowCardinality(Nullable(String))No
symbolLowCardinality(Nullable(String))No
decimalsNullable(UInt8)No
overlaps_native_balanceBoolNotrue = do not sum with native transfers
updated_atDateTime64(3)No
evm_runtime_codesdeployed bytecode by hash (no network column).
6 fields and storage details
Sort keys runtime_code_hashPartition None
ColumnTypeSort KeyNotes
runtime_code_hashFixedString(32)Yes
runtime_codeStringNoraw deployed bytecode; large
direct_kindLowCardinality(String)No
minimal_proxy_implementationNullable(FixedString(20))No
classifier_versionUInt32No
producer_revisionLowCardinality(String)No
evm_token_metadatatoken name, symbol and decimals by block range. Small.
8 fields and storage details
Sort keys network, address, valid_from_blockPartition network
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
addressFixedString(20)Yes
valid_from_blockUInt64Yes
valid_to_blockNullable(UInt64)Noexclusive; null = current
nameNullable(String)No
symbolLowCardinality(Nullable(String))No
decimalsNullable(UInt8)No
updated_atDateTime64(3)No
evm_tracesone row per callTracer frame. Bloom on from_address, to_address.
21 fields and storage details
Sort keys network, block_number, transaction_index, trace_addressPartition (network, intDiv(block_number, 1000000))
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
block_numberUInt64Yes
block_hashNullable(FixedString(32))No
block_datetimeDateTimeNo
transaction_hashNullable(FixedString(32))No
transaction_indexUInt32Yes
trace_addressArray(UInt32)Yes[] = the top-level call, [0,2] = third child of first child; length() = depth
emitted_logsArray(Tuple(Nullable(UInt32), Nullable(UInt32)))No(index, position) of logs emitted by this frame
call_typeLowCardinality(String)NoCALL, DELEGATECALL, STATICCALL, CALLCODE, CREATE, CREATE2, SELFDESTRUCT; '' = the whole trace failed
from_addressNullable(FixedString(20))No
to_addressNullable(FixedString(20))Nothe created contract for CREATE*
valueNullable(UInt256)Nowei
gasNullable(UInt64)No
gas_usedNullable(UInt64)No
inputStringNoraw bytes
outputStringNoraw bytes
errorLowCardinality(String)No'' on success
revert_reasonStringNo
subtracesUInt32No
otherStringNo
entry_otherStringNo
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.
64 fields and storage details
Sort keys network, block_number, transaction_indexPartition (network, intDiv(block_number, 1000000))
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
block_numberUInt64Yes
block_hashFixedString(32)No
block_datetimeDateTimeNo
hashFixedString(32)No
transaction_indexUInt32Yes
from_addressNullable(FixedString(20))No
to_addressNullable(FixedString(20))Nonull for contract creation
nonceNullable(UInt64)No
gasNullable(UInt64)No
valueNullable(UInt256)Nowei
gas_priceNullable(UInt256)Nowei
max_fee_per_gasNullable(UInt256)Nowei
max_priority_fee_per_gasNullable(UInt256)Nowei
max_fee_per_blob_gasNullable(UInt256)Nowei
inputStringNoraw calldata bytes; the first 4 bytes are the selector
transaction_typeNullable(UInt8)No0 legacy, 1 2930, 2 1559, 3 blob, 4 7702
chain_idNullable(UInt256)No
access_list_addressesArray(FixedString(20))No
access_list_storage_keysArray(Array(FixedString(32)))No
blob_versioned_hashesArray(FixedString(32))No
authorization_chain_idsArray(UInt256)NoEIP-7702, parallel arrays
authorization_addressesArray(FixedString(20))NoEIP-7702, parallel arrays
authorization_noncesArray(UInt64)NoEIP-7702, parallel arrays
authorization_y_paritiesArray(UInt8)NoEIP-7702, parallel arrays
authorization_rsArray(UInt256)NoEIP-7702, parallel arrays
authorization_ssArray(UInt256)NoEIP-7702, parallel arrays
vNullable(UInt256)No
y_parityNullable(UInt8)No
rNullable(UInt256)No
sNullable(UInt256)No
source_hashNullable(FixedString(32))NoOP-Stack deposits
mintNullable(UInt256)NoOP-Stack deposits
is_system_txNullable(Bool)NoOP-Stack deposits
request_idNullable(FixedString(32))NoArbitrum
ticket_idNullable(FixedString(32))NoArbitrum
beneficiaryNullable(FixedString(20))NoArbitrum
l1_batch_numberNullable(UInt64)NozkSync
l1_batch_tx_indexNullable(UInt64)NozkSync
statusNullable(Bool)Noreceipt status: true = success (null pre-Byzantium, see root)
rootNullable(FixedString(32))Nopre-Byzantium
cumulative_gas_usedUInt64No
gas_usedUInt64No
effective_gas_priceNullable(UInt256)Nowei; fee = gas_used * effective_gas_price
receipt_blob_gas_usedNullable(UInt64)No
blob_gas_priceNullable(UInt256)Noblob fee = receipt_blob_gas_used * blob_gas_price
contract_addressNullable(FixedString(20))Noset on contract creation
logs_bloomStringNo
log_countUInt32No
l1_gas_usedNullable(UInt64)NoOP-Stack
l1_gas_priceNullable(UInt256)NoOP-Stack
l1_feeNullable(UInt256)NoOP-Stack
l1_fee_scalarNullable(String)NoOP-Stack; decimal text, e.g. "0.684"
l1_base_fee_scalarNullable(UInt64)NoOP-Stack
l1_blob_base_feeNullable(UInt256)NoOP-Stack
l1_blob_base_fee_scalarNullable(UInt64)NoOP-Stack
deposit_nonceNullable(UInt64)NoOP-Stack
deposit_receipt_versionNullable(UInt64)NoOP-Stack
receipt_l1_block_numberNullable(UInt64)NoArbitrum
gas_used_for_l1Nullable(UInt64)NoArbitrum
receipt_l1_batch_numberNullable(UInt64)NozkSync
receipt_l1_batch_tx_indexNullable(UInt64)NozkSync
otherStringNoJSON of unmodeled keys
receipt_otherStringNoJSON of unmodeled keys
evm_transfer_asset_blocksper-block completion ledger of the transfer pipeline. max(block_number) is the transfer data head.
8 fields and storage details
Sort keys network, block_numberPartition network
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
block_numberUInt64Yes
block_hashFixedString(32)No
source_uuidUUIDNo
source_kindLowCardinality(String)No
source_topicNullable(String)No
source_partitionNullable(Int32)No
source_offsetNullable(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.
13 fields and storage details
Sort keys network, address, block_number, block_hash, transaction_index, log_indexPartition (network, intDiv(block_number, 1000000))
ColumnTypeSort KeyNotes
networkLowCardinality(String)Yes
addressFixedString(20)Yestoken contract (the sort key after network)
block_numberUInt64Yes
block_hashFixedString(32)Yes
block_datetimeDateTimeNo
transaction_hashFixedString(32)No
transaction_indexUInt32Yes
log_indexUInt32Yes
topic0FixedString(32)NoTransfer, TransferSingle, TransferBatch, Deposit or Withdrawal signature
topic1Nullable(FixedString(32))No
topic2Nullable(FixedString(32))No
topic3Nullable(FixedString(32))No
dataStringNoraw ABI-encoded data bytes