Token Metadata
ERC-20 contract registry mapping addresses to symbols, names, and decimals.
1 table — Ethereum only.
| Table | Chain |
|---|---|
agent.ethereum_erc20 | Ethereum |
Schema
Engine: MergeTree | ORDER BY: contract_address
| Column | Type | Description |
|---|---|---|
blockchain | String | Always 'ethereum' |
contract_address | String | Lowercase hex. Primary key for joins. |
symbol | Nullable(String) | Token ticker (e.g., USDC, WETH). Not unique — multiple contracts can share a symbol. |
name | Nullable(String) | Full token name |
decimals | Nullable(Int64) | Typically 18 (ETH-like) or 6 (USDC/USDT) |
Good to Know
- Small dimension table — safe to use in subqueries or JOINs without filtering.
- Always join on
contract_address, never onsymbol(symbols are not unique). - Ethereum only. Other chains don't have a separate ERC-20 metadata table.
- Reflects deployment-time metadata — tokens that rebrand won't show new names.