Network Table
Description
Master registry of supported blockchains (Ethereum, Polygon, Arbitrum, …). Use it to scope queries by chain and to join instance/token data back to a human-readable network.
Schema
| Field | Type | Description |
|---|---|---|
| id | STRING | Deterministic 64-bit ID (truncated MD5 of slug). |
| name | STRING | Human-readable name (e.g., ethereum, polygon). |
| subgraph_id | STRING | The Graph subgraph identifier for indexing on this chain. |
| slug | STRING | Canonical network identifier used across the system. |
| ingested_at | TIMESTAMP | When this row was inserted into BigQuery (UTC). |
Example Queries
List networks we currently expose
SELECT id, slug, name
FROM `defi_prepared.network`
ORDER BY name;
Count V3 pools per network
SELECT n.name AS network, COUNT(*) AS v3_pools
FROM `defi_prepared.uniswap_v3_pool` p
JOIN `defi_prepared.dex_instance` d ON p.dex_instance_id = d.id
JOIN `defi_prepared.network` n ON d.network_id = n.id
GROUP BY 1 ORDER BY 2 DESC;