lido_v2_ethereum

Tables

stETH_Submitted_event

ETH staking submissions to Lido’s stETH contract on Ethereum, capturing deposit amounts, sender addresses, and optional referral codes. Used for analyzing staking inflows, user acquisition patterns, and referral program effectiveness.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.

Sample Data

address	removed	in_amount	in_sender	log_index	in_referral	block_number	block_timestamp	transaction_hash
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	10000000000000000000	0x0b358edd6e7eb4b38af3ddd7fcea775254602532	469	0x0000000000000000000000000000000000000000	13627341	2021-11-16T15:22:59.000Z	0xcfb15fa24d18c470cc77774d9ff90ff15b44ecd6b98036f0da2b8cf86df9ab79
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	10000000000000000000	0x477951e4e30d6c67d97471cd04414c2746b59f69	406	0x0000000000000000000000000000000000000000	13629387	2021-11-16T23:05:01.000Z	0x4c214f0b6d905bec14fb5e5fe4ec7e61be3336900da4c986a465b8001fcebbfa
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	8583369011081106265	0x17bd6e450ab4534d3fe50f7c0780603902fa3773	239	0x0000000000000000000000000000000000000000	13626246	2021-11-16T11:07:15.000Z	0xea7173636affb7000743759f569c33eae7ae40428adfd15ac316fe229f466abd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lido_v2_ethereum.stETH_Submitted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

stETH_TokenRebased_event

Lido stETH (Staked ETH) rebase events on Ethereum, emitted daily when the protocol updates share-to-ETH conversion ratios based on validator rewards. Captures pre/post total ether and shares, fee distribution, and time elapsed for tracking staking yield accrual and protocol fee generation.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reportTimestamp`	`STRING`	Unix timestamp of when the oracle report was submitted that triggered this rebase event. Value is in seconds since epoch, typically occurring daily at 12:20-12:30 UTC.
`in_timeElapsed`	`STRING`	Time elapsed since the previous event or report in the same series. String-encoded integer representing seconds.
`in_preTotalShares`	`STRING`	Total stETH shares before the rebase event occurred. Measured in wei (1e18 smallest units), represents the aggregate shares across all stETH holders prior to the daily oracle report.
`in_preTotalEther`	`STRING`	Total amount of ETH staked in the Lido protocol before the rebase event, denominated in wei (1e-18 ETH). This value represents the protocol’s total pooled ETH balance prior to applying staking rewards or penalties for the reporting period.
`in_postTotalShares`	`STRING`	Total number of stETH shares in the protocol after the rebase event. Represented as a wei-denominated integer (18 decimals), typically in the quadrillions range.
`in_postTotalEther`	`STRING`	Total ether staked in the Lido stETH contract after the rebase event, denominated in wei (10^-18 ETH). Represents the updated pool size following validator rewards, penalties, or withdrawals.
`in_sharesMintedAsFees`	`STRING`	Number of stETH shares minted as protocol fees during this rebase event, denominated in wei (1e-18 stETH). These shares represent Lido’s service fee taken from staking rewards before distribution to holders.

Sample Data

address	removed	log_index	block_number	in_timeElapsed	block_timestamp	in_preTotalEther	transaction_hash	in_postTotalEther	in_preTotalShares	in_postTotalShares	in_reportTimestamp	in_sharesMintedAsFees
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	18	17805821	86400	2023-07-30T12:22:47.000Z	7924349740045416497008665	0x510f7bfde83e2b48996d278314168124885fc5185f3366b31830a2c69fea70db	7921254677310165103885808	6988618029024738993614351	6985210008707694021262219	1690718411	75372979632230615359
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	18	18341450	86400	2023-10-13T12:23:35.000Z	8827704681202208062579518	0x3c8b588dc31dce63610a9b74ada1bf87f6f0d045cc416dd945387ba004609b71	8817336567768810545045536	7725515716562565822973427	7715708258185896970074032	1697198411	81374082035291563397
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	18	18534376	86400	2023-11-09T12:25:47.000Z	8958500945738104071007691	0xf482ad0d6b7d83748aee4728c81f3d5a6d662577fad6b7a55c73e39f3286f910	8954577251607172228314158	7818465700085899630386757	7814210064320602293845927	1699531211	92351149653801536707

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lido_v2_ethereum.stETH_TokenRebased_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

stETH_TransferShares_event

Lido stETH share transfer events on Ethereum, tracking share-denominated movements between addresses including mints from zero address. Used for analyzing stETH ownership changes and rebasing token mechanics at the share level rather than token balance level.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sharesValue`	`STRING`	Amount of stETH shares transferred in this event, denominated in wei (1e18 shares). Shares represent proportional ownership of the total staked ETH in Lido’s pool, which rebases as staking rewards accrue.

Sample Data

in_to	address	in_from	removed	log_index	block_number	in_sharesValue	block_timestamp	transaction_hash
0xebbc13a7a9aae71f8b41009a69ef9868e7163dd2	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	0x0000000000000000000000000000000000000000	false	150	17220352	1446998554627427670	2023-05-09T03:54:47.000Z	0x35d4d5a36f0926b101e87390aceadeb10844fa6a35b0780d25418ab14c11725b
0xfe11cbafb9e0f6ccb8d0bd2247eb8b6be296b522	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	0x0000000000000000000000000000000000000000	false	331	17221888	2689762363050500451	2023-05-09T09:04:59.000Z	0x6c69d0a4d877d5f0dc78797716910a4e31d628321b01e5c7b78c90cfd951481e
0xda088d771212708f3aa983593531fc38ad3627af	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	0x0000000000000000000000000000000000000000	false	151	17225472	173024578004156020	2023-05-09T21:12:23.000Z	0x613d3302d15ab9e02f5a56a49dfd969e5063431d565403d043f7a2b947f7d160

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lido_v2_ethereum.stETH_TransferShares_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WithdrawalQueueERC721_WithdrawalClaimed_event

Withdrawal claim events from Lido’s ERC721-based withdrawal queue on Ethereum, recording when stakers successfully claim their unstaked ETH. Contains request IDs, ETH amounts (in wei), and owner/receiver addresses for analyzing Lido withdrawal processing and claim patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_requestId`	`STRING`	Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountOfETH`	`STRING`	Amount of ETH withdrawn and claimed by the receiver, denominated in wei (1 ETH = 10^18 wei). Values range from small fractions to over 100 ETH per withdrawal request.

Sample Data

address	removed	in_owner	log_index	in_receiver	block_number	in_requestId	in_amountOfETH	block_timestamp	transaction_hash
0x889edc2edab5f40e902b864ad4d7ade8e412f9b1	false	0x5a6b14edfcdd1a0710aeeedf8d83295fd892996a	180	0x5a6b14edfcdd1a0710aeeedf8d83295fd892996a	18600192	15981	50000000000000000	2023-11-18T17:25:11.000Z	0xd20a8ead329a0d945931b5c8fbc5ff5dc03d1ca26f51cef0af5e822a71eba1f0
0x889edc2edab5f40e902b864ad4d7ade8e412f9b1	false	0x450671184da005416d9685cdecb0705a9f35a87e	445	0x450671184da005416d9685cdecb0705a9f35a87e	18595334	15887	8036640310000000000	2023-11-18T01:01:11.000Z	0x427bb8e12b6106de57a8e15f9dd03b3e12d0eeb7f9fd496c16fc4fecc57e8248
0x889edc2edab5f40e902b864ad4d7ade8e412f9b1	false	0x9dad92fe2653e934fa95537d36d90e4a827f045a	171	0x9dad92fe2653e934fa95537d36d90e4a827f045a	18597640	15849	5000000000000000000	2023-11-18T08:47:35.000Z	0xe910eebd442d661cb278086813b2615fd1e2d525022d43da04ef92200c709150

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lido_v2_ethereum.WithdrawalQueueERC721_WithdrawalClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

WithdrawalQueueERC721_WithdrawalRequested_event

Withdrawal request events from Lido’s stETH withdrawal queue on Ethereum, capturing unstaking requests with stETH amounts, underlying shares, requestor addresses, and unique request IDs. Used for tracking withdrawal demand patterns and analyzing staking liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_requestId`	`STRING`	Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.
`in_requestor`	`STRING`	Address of the account that initiated the stETH withdrawal request. Can be the same as the owner (in_owner) or a different address acting on behalf of the owner.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountOfStETH`	`STRING`	Amount of stETH (Lido Staked ETH) requested for withdrawal, denominated in wei (18 decimals). This value represents the stETH token balance being unstaked, typically slightly higher than the underlying shares due to accrued staking rewards.
`in_amountOfShares`	`STRING`	Amount of Lido stETH shares being withdrawn, denominated in the smallest unit (wei-equivalent). Represents the internal accounting unit used by Lido’s rebasing token mechanism.

Sample Data

address	removed	in_owner	log_index	block_number	in_requestId	in_requestor	block_timestamp	in_amountOfStETH	transaction_hash	in_amountOfShares
0x889edc2edab5f40e902b864ad4d7ade8e412f9b1	false	0x723e33f9cd648317d6cecbc713f3042932fbdaba	341	18199827	10347	0x723e33f9cd648317d6cecbc713f3042932fbdaba	2023-09-23T16:52:47.000Z	5240928009872648	0x55a413f97d4efa6203562a4c0779772dd2450e976efbb4c84823d403a0865060	4594946414803549
0x889edc2edab5f40e902b864ad4d7ade8e412f9b1	false	0xf247ce1317480723abfeaf898534873155d25be7	133	18196077	10285	0xf247ce1317480723abfeaf898534873155d25be7	2023-09-23T04:16:23.000Z	6808886555835053	0x248f917a8a83120cb77d23683ea971f2c277608f5f562a9c3ea5d43db80007a1	5970199738844625
0x889edc2edab5f40e902b864ad4d7ade8e412f9b1	false	0xd4b02eca7b2682455fa853f17e21d1c6b605d434	129	18198214	10314	0xd4b02eca7b2682455fa853f17e21d1c6b605d434	2023-09-23T11:26:23.000Z	7152283931902406	0xb324d0e8bdec17431dfb1a15146f99984bf938ea71f36d053caa3cf2f31ae86b	6271299031380247

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.lido_v2_ethereum.WithdrawalQueueERC721_WithdrawalRequested_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

stETH_Submitted_event

stETH_TokenRebased_event

stETH_TransferShares_event

WithdrawalQueueERC721_WithdrawalClaimed_event

WithdrawalQueueERC721_WithdrawalRequested_event

​Tables

​stETH_Submitted_event

​stETH_TokenRebased_event

​stETH_TransferShares_event

​WithdrawalQueueERC721_WithdrawalClaimed_event

​WithdrawalQueueERC721_WithdrawalRequested_event

Tables

stETH_Submitted_event

stETH_TokenRebased_event

stETH_TransferShares_event

WithdrawalQueueERC721_WithdrawalClaimed_event

WithdrawalQueueERC721_WithdrawalRequested_event