cardano.off_chain_pool_data

Description of the off_chain_pool_data table on Dune

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

Table Sample