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 | |||
|---|---|---|---|
| ankr-v1 | 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.