Cluster `evm-mainnet`. Every table has a `network LowCardinality(String)` column except `evm_runtime_codes`. Nullable columns are null when a chain or era does not carry the field. `FixedString` columns and raw-byte `String` columns need `hex()` to read and `unhex()` to filter. Row counts are approximate. ## `evm_blocks`: one row per block Sort `(network, number)`. Partition `(network, intDiv(number, 1000000))`. ~630M rows. Minmax on `block_datetime`, `ingested_at`. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | number | UInt64 | | | hash | FixedString(32) | | | parent_hash | FixedString(32) | | | timestamp | UInt64 | Unix seconds | | block_datetime | DateTime | | | sha3_uncles | Nullable(FixedString(32)) | | | logs_bloom | String | raw bytes | | transactions_root | Nullable(FixedString(32)) | | | state_root | Nullable(FixedString(32)) | | | receipts_root | Nullable(FixedString(32)) | | | miner | Nullable(FixedString(20)) | | | difficulty | Nullable(UInt256) | | | total_difficulty | Nullable(UInt256) | | | extra_data | String | raw bytes | | mix_hash | Nullable(FixedString(32)) | | | nonce | Nullable(FixedString(8)) | | | size | Nullable(UInt64) | | | gas_limit | Nullable(UInt64) | | | gas_used | Nullable(UInt64) | | | base_fee_per_gas | Nullable(UInt64) | | | withdrawals_root | Nullable(FixedString(32)) | | | blob_gas_used | Nullable(UInt64) | | | excess_blob_gas | Nullable(UInt64) | | | parent_beacon_block_root | Nullable(FixedString(32)) | | | requests_hash | Nullable(FixedString(32)) | | | uncles | Array(FixedString(32)) | | | withdrawal_indexes | Array(UInt64) | parallel arrays: entry `i` is one withdrawal | | withdrawal_validator_indexes | Array(UInt64) | parallel arrays: entry `i` is one withdrawal | | withdrawal_addresses | Array(FixedString(20)) | parallel arrays: entry `i` is one withdrawal | | withdrawal_amounts | Array(UInt64) | **gwei**; parallel with the other `withdrawal_*` arrays | | transaction_hashes | Array(FixedString(32)) | in block order | | transaction_count | UInt32 | | | l1_block_number | Nullable(UInt64) | L2 (Arbitrum / zkSync) | | send_root | Nullable(FixedString(32)) | Arbitrum | | send_count | Nullable(UInt64) | L2 (Arbitrum / zkSync) | | l1_batch_number | Nullable(UInt64) | L2 (Arbitrum / zkSync) | | l1_batch_timestamp | Nullable(UInt64) | L2 (Arbitrum / zkSync) | | other | String | JSON of unmodeled header keys, `''` if none | | ingested_at | DateTime64(3) | ingestion freshness | ## `evm_contract_changes`: contract lifecycle events Sort `(network, address, block_number, block_hash, transaction_index, change_id)`. Partition `network`. ~1.2B rows. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | address | FixedString(20) | | | block_number | UInt64 | | | block_hash | FixedString(32) | | | block_datetime | DateTime | | | transaction_hash | FixedString(32) | | | transaction_index | UInt32 | | | change_id | FixedString(32) | | | change_type | LowCardinality(String) | see the values in use with `SELECT DISTINCT change_type` and a network filter | | deployer | Nullable(FixedString(20)) | | | trace_address | Array(UInt32) | | | log_index | Nullable(UInt32) | | | runtime_code_hash | Nullable(FixedString(32)) | | | direct_kind | LowCardinality(Nullable(String)) | see the values in use with `SELECT DISTINCT direct_kind` and a network filter | | minimal_proxy_implementation | Nullable(FixedString(20)) | | | relation_kind | LowCardinality(Nullable(String)) | | | relation_key | String | | | target_address | Nullable(FixedString(20)) | | | provenance | LowCardinality(String) | | ## `evm_logs`: one row per event log (reorg-removed logs excluded) Sort `(network, block_number, transaction_index, log_index)`. Partition `(network, intDiv(block_number, 1000000))`. ~110B rows. Bloom on `address`, `topic0`. Minmax on `block_datetime`. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | block_number | UInt64 | | | block_hash | FixedString(32) | | | block_datetime | DateTime | | | transaction_hash | FixedString(32) | | | transaction_index | UInt32 | | | log_index | UInt32 | index within the **block** | | address | FixedString(20) | emitting contract | | topic0 | Nullable(FixedString(32)) | event signature hash (null for anonymous events) | | topic1 | Nullable(FixedString(32)) | indexed argument, positional; an address is left-padded to 32 bytes | | topic2 | Nullable(FixedString(32)) | indexed argument, positional; an address is left-padded to 32 bytes | | topic3 | Nullable(FixedString(32)) | indexed argument, positional; an address is left-padded to 32 bytes | | data | String | raw ABI-encoded data bytes | | l1_batch_number | Nullable(UInt64) | zkSync | | log_type | Nullable(String) | zkSync | | other | String | | ## `evm_native_currencies`: native currency of each network Sort `(network)`. Partition `none`. ~55 rows. Small. Lists every valid network name. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | chain_id | UInt64 | | | native_asset | LowCardinality(String) | CAIP, e.g. `slip44:60` | | symbol | LowCardinality(String) | | | decimals | UInt8 | | | updated_at | DateTime64(3) | | ## `evm_native_transfers`: native value movements with value > 0 Sort `(network, block_number, block_hash, transaction_index, trace_address)`. Partition `(network, intDiv(block_number, 1000000))`. ~16B rows. Bloom on `from_address`, `to_address`. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | block_number | UInt64 | | | block_hash | FixedString(32) | | | block_datetime | DateTime | | | transaction_hash | FixedString(32) | | | transaction_index | UInt32 | | | trace_address | Array(UInt32) | | | call_type | LowCardinality(String) | | | is_internal | Bool | false = transaction-level value, true = internal call | | from_address | FixedString(20) | | | to_address | FixedString(20) | | | amount | UInt256 | wei | ## `evm_protocol_contracts`: registered protocol contracts (wrapped native tokens, ...) Sort `(network, address, valid_from_block)`. Partition `network`. ~47 rows. Small. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | address | FixedString(20) | | | valid_from_block | UInt64 | | | valid_to_block | Nullable(UInt64) | exclusive; null = current | | protocol_kind | LowCardinality(String) | | | decoder_kind | LowCardinality(Nullable(String)) | | | asset_kind | LowCardinality(Nullable(String)) | | | symbol | LowCardinality(Nullable(String)) | | | decimals | Nullable(UInt8) | | | overlaps_native_balance | Bool | true = do not sum with native transfers | | updated_at | DateTime64(3) | | ## `evm_runtime_codes`: deployed bytecode by hash (no `network` column) Sort `(runtime_code_hash)`. Partition `none`. ~22M rows. | Column | Type | Notes | |---|---|---| | runtime_code_hash | FixedString(32) | | | runtime_code | String | raw deployed bytecode; large | | direct_kind | LowCardinality(String) | | | minimal_proxy_implementation | Nullable(FixedString(20)) | | | classifier_version | UInt32 | | | producer_revision | LowCardinality(String) | | ## `evm_token_metadata`: token name, symbol and decimals by block range Sort `(network, address, valid_from_block)`. Partition `network`. ~0 rows. Small. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | address | FixedString(20) | | | valid_from_block | UInt64 | | | valid_to_block | Nullable(UInt64) | exclusive; null = current | | name | Nullable(String) | | | symbol | LowCardinality(Nullable(String)) | | | decimals | Nullable(UInt8) | | | updated_at | DateTime64(3) | | ## `evm_traces`: one row per `callTracer` frame Sort `(network, block_number, transaction_index, trace_address)`. Partition `(network, intDiv(block_number, 1000000))`. ~390B rows. Bloom on `from_address`, `to_address`. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | block_number | UInt64 | | | block_hash | Nullable(FixedString(32)) | | | block_datetime | DateTime | | | transaction_hash | Nullable(FixedString(32)) | | | transaction_index | UInt32 | | | trace_address | Array(UInt32) | `[]` = the top-level call, `[0,2]` = third child of first child; `length()` = depth | | emitted_logs | Array(Tuple(Nullable(UInt32), Nullable(UInt32))) | (index, position) of logs emitted by this frame | | call_type | LowCardinality(String) | CALL, DELEGATECALL, STATICCALL, CALLCODE, CREATE, CREATE2, SELFDESTRUCT; `''` = the whole trace failed | | from_address | Nullable(FixedString(20)) | | | to_address | Nullable(FixedString(20)) | the created contract for CREATE* | | value | Nullable(UInt256) | wei | | gas | Nullable(UInt64) | | | gas_used | Nullable(UInt64) | | | input | String | raw bytes | | output | String | raw bytes | | error | LowCardinality(String) | `''` on success | | revert_reason | String | | | subtraces | UInt32 | | | other | String | | | entry_other | String | | ## `evm_transactions`: one row per transaction, receipt fields merged in Sort `(network, block_number, transaction_index)`. Partition `(network, intDiv(block_number, 1000000))`. ~29B rows. Minmax on `block_datetime`. A projection on `(network, hash)` makes `WHERE network = … AND hash = unhex('…')` fast. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | block_number | UInt64 | | | block_hash | FixedString(32) | | | block_datetime | DateTime | | | hash | FixedString(32) | | | transaction_index | UInt32 | | | from_address | Nullable(FixedString(20)) | | | to_address | Nullable(FixedString(20)) | null for contract creation | | nonce | Nullable(UInt64) | | | gas | Nullable(UInt64) | | | value | Nullable(UInt256) | wei | | gas_price | Nullable(UInt256) | wei | | max_fee_per_gas | Nullable(UInt256) | wei | | max_priority_fee_per_gas | Nullable(UInt256) | wei | | max_fee_per_blob_gas | Nullable(UInt256) | wei | | input | String | raw calldata bytes; the first 4 bytes are the selector | | transaction_type | Nullable(UInt8) | 0 legacy, 1 2930, 2 1559, 3 blob, 4 7702 | | chain_id | Nullable(UInt256) | | | access_list_addresses | Array(FixedString(20)) | | | access_list_storage_keys | Array(Array(FixedString(32))) | | | blob_versioned_hashes | Array(FixedString(32)) | | | authorization_chain_ids | Array(UInt256) | EIP-7702, parallel arrays | | authorization_addresses | Array(FixedString(20)) | EIP-7702, parallel arrays | | authorization_nonces | Array(UInt64) | EIP-7702, parallel arrays | | authorization_y_parities | Array(UInt8) | EIP-7702, parallel arrays | | authorization_rs | Array(UInt256) | EIP-7702, parallel arrays | | authorization_ss | Array(UInt256) | EIP-7702, parallel arrays | | v | Nullable(UInt256) | | | y_parity | Nullable(UInt8) | | | r | Nullable(UInt256) | | | s | Nullable(UInt256) | | | source_hash | Nullable(FixedString(32)) | OP-Stack deposits | | mint | Nullable(UInt256) | OP-Stack deposits | | is_system_tx | Nullable(Bool) | OP-Stack deposits | | request_id | Nullable(FixedString(32)) | Arbitrum | | ticket_id | Nullable(FixedString(32)) | Arbitrum | | beneficiary | Nullable(FixedString(20)) | Arbitrum | | l1_batch_number | Nullable(UInt64) | zkSync | | l1_batch_tx_index | Nullable(UInt64) | zkSync | | status | Nullable(Bool) | receipt status: true = success (null pre-Byzantium, see `root`) | | root | Nullable(FixedString(32)) | pre-Byzantium | | cumulative_gas_used | UInt64 | | | gas_used | UInt64 | | | effective_gas_price | Nullable(UInt256) | wei; fee = `gas_used * effective_gas_price` | | receipt_blob_gas_used | Nullable(UInt64) | | | blob_gas_price | Nullable(UInt256) | blob fee = `receipt_blob_gas_used * blob_gas_price` | | contract_address | Nullable(FixedString(20)) | set on contract creation | | logs_bloom | String | | | log_count | UInt32 | | | l1_gas_used | Nullable(UInt64) | OP-Stack | | l1_gas_price | Nullable(UInt256) | OP-Stack | | l1_fee | Nullable(UInt256) | OP-Stack | | l1_fee_scalar | Nullable(String) | OP-Stack; decimal text, e.g. `"0.684"` | | l1_base_fee_scalar | Nullable(UInt64) | OP-Stack | | l1_blob_base_fee | Nullable(UInt256) | OP-Stack | | l1_blob_base_fee_scalar | Nullable(UInt64) | OP-Stack | | deposit_nonce | Nullable(UInt64) | OP-Stack | | deposit_receipt_version | Nullable(UInt64) | OP-Stack | | receipt_l1_block_number | Nullable(UInt64) | Arbitrum | | gas_used_for_l1 | Nullable(UInt64) | Arbitrum | | receipt_l1_batch_number | Nullable(UInt64) | zkSync | | receipt_l1_batch_tx_index | Nullable(UInt64) | zkSync | | other | String | JSON of unmodeled keys | | receipt_other | String | JSON of unmodeled keys | ## `evm_transfer_asset_blocks`: per-block completion ledger of the transfer pipeline Sort `(network, block_number)`. Partition `network`. ~630M rows. `max(block_number)` is the transfer data head. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | block_number | UInt64 | | | block_hash | FixedString(32) | | | source_uuid | UUID | | | source_kind | LowCardinality(String) | | | source_topic | Nullable(String) | | | source_partition | Nullable(Int32) | | | source_offset | Nullable(Int64) | | ## `evm_transfer_candidates`: `Transfer`-shaped logs (ERC-20/721/1155, WETH9 Deposit/Withdrawal, ...) Sort `(network, address, block_number, block_hash, transaction_index, log_index)`. Partition `(network, intDiv(block_number, 1000000))`. ~54B rows. Sorted by token `address`, so per-token queries are fast. Bloom on `topic0`…`topic3`. | Column | Type | Notes | |---|---|---| | network | LowCardinality(String) | | | address | FixedString(20) | token contract (the sort key after `network`) | | block_number | UInt64 | | | block_hash | FixedString(32) | | | block_datetime | DateTime | | | transaction_hash | FixedString(32) | | | transaction_index | UInt32 | | | log_index | UInt32 | | | topic0 | FixedString(32) | `Transfer`, `TransferSingle`, `TransferBatch`, `Deposit` or `Withdrawal` signature | | topic1 | Nullable(FixedString(32)) | | | topic2 | Nullable(FixedString(32)) | | | topic3 | Nullable(FixedString(32)) | | | data | String | raw ABI-encoded data bytes |