cardano.epoch_stake

Description of the epoch_stake table on Dune

Table Description

Contains per-epoch stake delegation snapshots for the Cardano blockchain. Each row represents the stake delegated by a specific stake address to a stake pool for a given epoch, including the epoch when delegation began and when it became active.

Column Descriptions

Column	Description	Type
epoch	The epoch number for this stake snapshot.	integer
stake_address	The stake (reward) address of the delegator.	varchar
stake_lovelace	The amount of stake delegated, in lovelace.	decimal(38,0)
pool_hash	The hash of the stake pool to which the stake is delegated.	varchar
delegation_epoch	The epoch in which the delegation was registered.	integer
active_epoch	The epoch in which the delegation became active for reward calculation.	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