Table Description
Contains off-chain metadata for Cardano stake pools. Each row represents a stake pool’s self-reported metadata — including its ticker symbol, name, description, and homepage — as fetched from the metadata URL registered on-chain. This table is useful for enriching on-chain staking data with human-readable pool identifiers.Column Descriptions
| Column | Description | Type |
|---|---|---|
| pool_hash | The hash identifier of the stake pool. | varchar |
| pool_id | The bech32-encoded pool ID. | varchar |
| ticker | The pool’s ticker symbol (e.g., BLOCK, ADAOZ). | varchar |
| name | The human-readable name of the pool. | varchar |
| description | A description of the pool provided by the operator. | varchar |
| homepage | The URL of the pool operator’s homepage. | varchar |
| metadata_url | The URL from which the pool metadata was fetched. | varchar |
| metadata_hash | The hash of the metadata content, for integrity verification. | varchar |
| fetched_at | The timestamp when the metadata was last fetched. | timestamp |
| version | The version number of the metadata record. | integer |
| _updated_at | The time when this record was last updated. | timestamp |
| _ingested_at | The time when this record was ingested into Dune. | timestamp |