Table Description

This table contains stake snapshots for Midnight pools, including live and active stake and delegator counts.

Column Descriptions

Column Name	Data Type	Description
id	bigint	Internal stake history identifier.
pool_id	varchar	Pool identifier.
mainchain_epoch	bigint	Mainchain epoch associated with the snapshot.
live_stake	decimal(38,0)	Live stake for the pool.
active_stake	decimal(38,0)	Active stake for the pool.
live_delegators	bigint	Number of live delegators.
live_saturation	double	Live saturation ratio for the pool.
declared_pledge	decimal(38,0)	Declared pledge amount.
live_pledge	decimal(38,0)	Live pledge amount.
recorded_at	timestamp	Timestamp when the snapshot was recorded.
_updated_at	timestamp	Timestamp when this record was last updated.
_ingested_at	timestamp	Timestamp when this record was ingested into Dune.