Skip to content

Liquid Staking Events

The ethereum.liquid_staking_events table provides indexed views on all deposit and withdraw events for liquid staking protocols.

Columns

Name Type Description
account_address text The address that owns the liquid staking position.
block_number integer The block number at which the event occurred.
category text The category of the liquid staking event (deposit, withdraw).
contract_address text The contract address that facilitated the staking event.
contract_version text The version of the liquid staking protocol.
log_index integer The log index at which the event occurred.
metadata jsonb Protocol-specific metadata for the event.
protocol_name text The name of the liquid staking protocol.
quantity_shares numeric The share quantity added or removed from the liquid staking position (negative on withdraw events, NULL if protocol does not use shares).
staked_token_address text The address of the token staked in the liquid staking event (i.e. ETH).
staked_token_quantity numeric The quantity of the staked token in the event (negative on withdraw events).
timestamp timestamp without time zone The timestamp at which the event occurred.
total_account_shares numeric The total shares the account address owns after the event (NULL if protocol does not use shares).
total_pool_shares numeric The total shares of the staking pool/vault at the time of the event (NULL if protocol does not use shares).
transaction_hash text The transaction hash at which the event occurred.
yield_token_address text The address of the token minted/burned in the liquid staking event to represent a staking position (i.e. stETH).
yield_token_quantity numeric The quantity of the yield token in the event (negative on withdraw events).
__block_number integer An internal identifier for the indexer that updates this row. Use block_number instead when querying.
__confirmed boolean Flag indicating whether the transfer has been confirmed.
__last_modified timestamp The date at which this row was last updated (in ISO-8601 format).

Supported Protocols

Protocol
binance-v1 coinbase-v1 frax-v1 lido-v2
rocket-v1 stakewise-v1

Indexes

Index
protocol_name, timestamp, log_index
account_address, timestamp, log_index
timestamp, log_index
transaction_hash, log_index
__last_modified
__indexer_id WHERE __confirmed = false
__indexer_id, __block_number
contract_address, staked_token_address, block_number, log_index

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.