Logs

eth.logs

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

Columns

• tx_hash — FixedString(66)
• log_index — UInt32
• block_number — UInt64
• contract_address — FixedString(42)
• topic1 — FixedString(66)
• topic2 — FixedString(66)
• topic3 — FixedString(66)
• topic4 — FixedString(66)
• data — String

Modeling notes

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