Data Schema

All blockchain data is organized into schemas by chain, with consistent table structures across networks.

Chains

Schema	Chain	Status
ethereum	Ethereum Mainnet	Live
polygon	Polygon PoS	Live
arbitrum	Arbitrum One	Beta

Core Tables

Each chain schema contains the following tables:

events

Decoded contract events (logs).

Column	Type	Description
block_number	BIGINT	Block in which the event was emitted
block_timestamp	TIMESTAMP	Block timestamp
tx_hash	VARCHAR	Transaction hash
log_index	INTEGER	Log index within the transaction
contract_address	VARCHAR	Emitting contract address
event_name	VARCHAR	Decoded event name (e.g. Transfer)
event_signature	VARCHAR	Keccak256 event signature
args	JSON	Decoded event arguments

transactions

On-chain transactions.

Column	Type	Description
block_number	BIGINT	Block number
tx_hash	VARCHAR	Transaction hash
from_address	VARCHAR	Sender
to_address	VARCHAR	Recipient
value	NUMERIC	Value in wei
gas_used	BIGINT	Gas consumed
status	INTEGER	1 = success, 0 = reverted

blocks

Block metadata.

Column	Type	Description
block_number	BIGINT	Block number
block_timestamp	TIMESTAMP	Block timestamp
block_hash	VARCHAR	Block hash
parent_hash	VARCHAR	Parent block hash
gas_limit	BIGINT	Block gas limit
gas_used	BIGINT	Total gas used