Core Tables
arc.blocks, arc.transactions, arc.logs and arc.traces are the raw layer. They are typed, flattened, and written from node RPC with no interpretation.
arc.blocks
One row per block. Height, hash, parent hash, timestamp, gas_used, transaction_count. Coverage is genesis to head minus the two-block lag.
arc.transactions
One row per transaction. to_address is Nullable — contract-creating transactions leave it null rather than inventing a value.
arc.logs and arc.traces
Logs are the event stream decoders consume. Traces are flattened call rows, not JSON blobs. Both are rebuildable from the node by block range.
Buildingarc.traces is live in storage and not yet exposed on the API.