Transactions

eth.transactions

Purpose: TODO (describe what this table powers and its grain).

Columns

• hash — FixedString(66)
• block_number — UInt64
• tx_index — UInt32
• type — UInt8
• status — UInt8
• nonce — UInt64
• chain_id — UInt64
• from_address — FixedString(42)
• to_address — FixedString(42)
• contract_address — FixedString(42)
• value — UInt256
• data — String
• gas_limit — UInt64
• gas_used — UInt64
• gas_price — UInt256
• max_fee_per_gas — UInt256
• max_priority_fee_per_gas — UInt256
• effective_gas_price — UInt256

Modeling notes

• Engine: MergeTree
• Partition key: intDiv(block_number, 1000000)
• Sorting (ORDER BY): block_number, tx_index