cardano.pool_reward

Description of the pool_reward table on Dune

Table Description

Contains staking reward distribution data for the Cardano blockchain. Each row represents a reward earned by a stake address for a specific epoch, including the reward type (leader, member, treasury, reserves), the pool that generated the reward, and the epoch in which the reward becomes spendable.

Column Descriptions

Column	Description	Type
stake_address	The stake (reward) address that earned the reward.	varchar
earned_epoch	The epoch in which the reward was earned.	integer
spendable_epoch	The epoch in which the reward becomes spendable.	integer
reward_type	The type of reward (e.g., leader, member, treasury, reserves).	varchar
pool_hash	The hash of the stake pool that generated the reward.	varchar
amount_lovelace	The reward amount, in lovelace.	decimal(38,0)
slot	The slot number associated with the reward record.	bigint
_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