lido_v1_ethereum

Tables

AragonFinance_NewTransaction_event

Transaction events from Lido’s Aragon Finance module on Ethereum tracking treasury outflows and inflows. Primarily captures reward program distributions to entities with transaction amounts, references, and directional flow indicators.

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_transactionId`	`STRING`	Unique identifier for the cross-chain transaction. 66-character hex string including 0x prefix.
`in_incoming`	`BOOL`	Indicates the direction of the transaction relative to the Aragon Finance contract — true for deposits, false for withdrawals or outgoing payments. Based on sample data, this field is consistently false for reward program disbursements to external entities.
`in_entity`	`STRING`	Ethereum address of the counterparty involved in the Aragon Finance transaction (typically the recipient for outgoing payments). Hex-encoded, 0x-prefixed 40-character string representing the entity receiving funds in Lido’s reward program distributions.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_reference`	`STRING`	Human-readable description of the transaction’s purpose or context within Lido’s Aragon Finance system. Typically describes fund allocations such as reward program top-ups or liquidity pool incentives.

Sample Data

address	removed	in_amount	in_entity	log_index	in_incoming	block_number	in_reference	block_timestamp	in_transactionId	transaction_hash
0xb9e5cbb9ca5b0d659238807e84d0176930753d86	false	70000000000000000000000	0x87d93d9b2c672bf9c9642d853a8682546a5012b5	133	false	14209536	Reward program top up	2022-02-15T08:03:00.000Z	95	0x6bd46387477f375600a704027664d77af6b8dd24268569fb2a259d6bc5e4d017
0xb9e5cbb9ca5b0d659238807e84d0176930753d86	false	500000000000000000000000	0x87d93d9b2c672bf9c9642d853a8682546a5012b5	51	false	14512265	Reward program top up	2022-04-03T09:09:09.000Z	119	0x924e7f13ee2d8b0d76312037eff7ff6a66609732a49b9692f1737e6d721a8344
0xb9e5cbb9ca5b0d659238807e84d0176930753d86	false	160000000000000000000000	0x87d93d9b2c672bf9c9642d853a8682546a5012b5	192	false	14120106	Reward program top up	2022-02-01T12:33:26.000Z	88	0x51ad5defd7561c2349a6dc4334ef6d0dbec95608bffa6694bc4969ef3e75d837

Example Query

Query with partition filter

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

Oracle_Completed_event

Oracle completion events from Lido’s Ethereum staking protocol recording Beacon Chain validator count and total staked ETH balance updates by epoch. Used to track Lido’s validator growth and staking rewards accrual over time.

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_epochId`	`STRING`	Ethereum beacon chain epoch identifier when the Lido oracle report was completed. Epochs are sequential periods of approximately 6.4 minutes containing 32 slots each.
`in_beaconBalance`	`STRING`	Total ETH balance held in Lido’s Beacon Chain validators at the time of oracle report completion. Stored in wei (1 ETH = 10^18 wei) as evidenced by 21-24 digit values.
`in_beaconValidators`	`STRING`	Number of active Lido validators on the Ethereum Beacon Chain at the reported epoch. Increases over time as Lido stakes more ETH and activates additional validators.

Sample Data

address	removed	log_index	in_epochId	block_number	block_timestamp	in_beaconBalance	transaction_hash	in_beaconValidators
0x442af784a788a5bd6f42a01ebe9f287a871243fb	false	154	15300	11809251	2021-02-07T12:27:44.000Z	131660417621988000000000	0x47211be29ac91e8038c8fab38b8f5842ea4be85e32192167f18f727e33cf1d92	4108
0x442af784a788a5bd6f42a01ebe9f287a871243fb	false	1	212625	17620530	2023-07-04T12:21:59.000Z	7531794854051067000000000	0xea1f2ba5fd8160fd9f159181fe9ec83eff45cd16b8e3f462bb5fde4e594ec1fb	235844
0x442af784a788a5bd6f42a01ebe9f287a871243fb	false	327	56925	13003839	2021-08-11T12:21:05.000Z	751939645863494000000000	0x08f74abb46f440983e2ed87b041c77b847ffec511a6944207b19312a0bfefac6	23091

Example Query

Query with partition filter

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

Oracle_PostTotalShares_event

Oracle reporting events from Lido v1 staking protocol on Ethereum tracking daily balance updates with pre/post total pooled ETH amounts and total share counts. Used for analyzing staking rewards accrual, validator performance, and stETH exchange rate calculations.

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_postTotalPooledEther`	`STRING`	Total amount of pooled ETH (in wei) in the Lido protocol after the oracle report was submitted. Represents the updated protocol TVL including staking rewards or penalties for the reporting period.
`in_preTotalPooledEther`	`STRING`	Total amount of pooled ETH (in wei) before this oracle update, representing the protocol’s TVL prior to accounting for staking rewards or penalties. String-encoded to preserve precision for values exceeding standard integer limits.
`in_timeElapsed`	`STRING`	Time elapsed since the previous event or report in the same series. String-encoded integer representing seconds.
`in_totalShares`	`STRING`	Total number of shares outstanding in the vault. Numeric string representation of share tokens in the smallest unit.

Sample Data

address	removed	log_index	block_number	in_timeElapsed	in_totalShares	block_timestamp	transaction_hash	in_preTotalPooledEther	in_postTotalPooledEther
0x442af784a788a5bd6f42a01ebe9f287a871243fb	false	171	13384528	86400	1320952068998423704296412	2021-10-09T12:27:13.000Z	0xd678b7523ddcf69cee163001ea0be453e6b7046814c92c9a05f2d197b3545d58	1377685967604426977561345	1377897610303132977561345
0x442af784a788a5bd6f42a01ebe9f287a871243fb	false	215	17863024	86400	7033897359363113715573136	2023-08-07T12:21:23.000Z	0xfa7e15c08688dd2db824aca4645a758c8a446d333a4390b812ef413281fb0cb6	7996811700412727190343678	7983663726415703751745482
0x442af784a788a5bd6f42a01ebe9f287a871243fb	false	68	16240202	86400	4376401362502935179350231	2022-12-22T12:20:11.000Z	0x1a7f2b2e46e86e7b72ae2d5bf52b20c6518644b4f3bda298c8f9e8177a5580ac	4821177917890718632977214	4821888517928052721015793

Example Query

Query with partition filter

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

stETH_SharesBurnt_event

Lido stETH share burn events on Ethereum, recording when stETH shares are destroyed along with pre- and post-rebase token amounts. Used to track staking withdrawals, slashing penalties, and stETH supply changes from the rebasing mechanism.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_preRebaseTokenAmount`	`STRING`	Token amount before the rebase event, denominated in stETH wei (1e18 precision). This value represents the stETH balance calculated from shares immediately prior to Lido’s daily rebase adjustment.
`in_postRebaseTokenAmount`	`STRING`	Token amount in wei after the rebase event has occurred. Represents the updated balance following Lido’s staking rewards distribution and share price adjustment.
`in_sharesAmount`	`STRING`	Amount of stETH shares burned in this transaction, denominated in the protocol’s internal share units (wei). Shares represent proportional ownership of the stETH pool and are distinct from the rebasing token amount.

Sample Data

address	removed	log_index	in_account	block_number	block_timestamp	in_sharesAmount	transaction_hash	in_preRebaseTokenAmount	in_postRebaseTokenAmount
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	12	0xd15a672319cf0352560ee76d9e89eab0889046d3	18391506	2023-10-20T12:22:23.000Z	5642938015748549228817	0xec05c50d9ed342a2a4ac01ccc242e0dd74aed18b21454013a3f45f7a9d879674	6448503053172503061004	6453217315281260636717
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	12	0xd15a672319cf0352560ee76d9e89eab0889046d3	18312889	2023-10-09T12:22:59.000Z	36522508249552548918827	0xd418066cc84af20e9b4ca215ba855e6d00d0a7b7107a5d1a96442aef8e5d280f	41525531854285041301740	41722095266018856935338
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	158	0xd15a672319cf0352560ee76d9e89eab0889046d3	18134500	2023-09-14T12:24:11.000Z	5606715945152419741962	0xb5784459aca4c67490b3dea0e67b3f90df7b9e5c642c5b07029496ee390bda83	6384587724760868270386	6389313914398582163874

Example Query

Query with partition filter

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

stETH_Submitted_event

ETH staking submissions to Lido protocol on Ethereum, emitted when users deposit ETH in exchange for stETH (Lido staked ETH). Used to track staking inflows, referral activity, and individual deposit sizes for analyzing Lido’s liquid staking adoption and user behavior.

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	6184451600000000041	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	139	0x0000000000000000000000000000000000000000	12595366	2021-06-08T17:55:42.000Z	0xe00f6566cb4b9a7ed54509f150eca9525fcd77a736f5814677c37db7056ac9ca
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	1157252740000000008	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	195	0x0000000000000000000000000000000000000000	12594980	2021-06-08T16:31:16.000Z	0xb45cea4f99238a835ba5e7d74208691eab8edf09e501235f9cd3144d41bb7b6e
0xae7ab96520de3a18e5e111b5eaab095312d7fe84	false	4935981920000000031	0x0000000000007f150bd6f54c40a34d7c3d5e9f56	303	0x0000000000000000000000000000000000000000	12591352	2021-06-08T02:57:41.000Z	0x83ca9c05b23dd130d3985badd737d7450a565d55e8703330b3705dbcf8053c76

Example Query

Query with partition filter

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

stETH_TransferShares_event

stETH share transfer events from Lido’s liquid staking protocol on Ethereum, tracking internal share movements between accounts rather than token balances. Used for analyzing stETH rebasing mechanics, share ownership changes, and distinguishing minting (from zero address) from peer-to-peer transfers.

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`	Number of stETH shares transferred in the transaction, denominated in wei (10^-18). Represents the underlying shares being moved, which differ from the stETH token amount due to Lido’s rebasing mechanism.

Sample Data

in_to	address	in_from	removed	log_index	block_number	in_sharesValue	block_timestamp	transaction_hash
0x1166ae53a4d8779532260dfdd84dc065bcc5b1a4	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	0xdef13e0461bd92f2cd4ffacb947b50a5ab2cc998	false	119	16968522	1342534004529579413	2023-04-03T12:33:47.000Z	0x0f81cd8559fecf28881c7ad174ac7c777cfc001dc022fa1ab73a8a289ddcdcf4
0x85b9e6f24a8c6759068eb127017c29e1eb762a58	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	0x9551032a36c2b31d3a42d69dfa2d2b09ca9ecc88	false	157	16966264	8951234263120617339	2023-04-03T04:52:59.000Z	0xa79a176dd00c9486b084af6918e24c0ae915cd63dd9130d8784ba1e195b0b36d
0xecb456ea5365865ebab8a2661b0c503410e9b347	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	0xdc24316b9ae028f1497c275eb9192a3ea0f67022	false	120	16969278	871915512599614	2023-04-03T15:07:23.000Z	0x3883a11867b4583e5ba35d732aa9487633e4562084d37cc64653f33d3cf80013

Example Query

Query with partition filter

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

StMATIC_ClaimTokensEvent_event

Claim redemption events from Lido’s stMATIC (Staked MATIC) contract on Ethereum, recording when users burn their staked token receipts to withdraw underlying MATIC. Tracks claim request IDs, claimed amounts, and burned tokens for monitoring Lido’s Polygon staking withdrawal flow.

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 initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__id`	`STRING`	Unique identifier for the vault or position within the protocol. String-encoded integer value.
`in__amountClaimed`	`STRING`	Amount of stMATIC tokens claimed by the user in the withdrawal process, denominated in wei (18 decimals). Represents the actual tokens withdrawn after the unbonding period completes.
`in__amountBurned`	`STRING`	Amount of stMATIC tokens burned during the claim transaction, denominated in wei (10^-18 MATIC). Always zero in practice, as the Lido stMATIC claim mechanism burns tokens in a separate transaction step.

Sample Data

in__id	address	removed	in__from	log_index	block_number	block_timestamp	transaction_hash	in__amountClaimed
1009	0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	0x28609645f2d2a214c97625f704f19cfd8ff3799c	582	16673861	2023-02-21T02:17:23.000Z	0x6159595b0005eafe5f258e86e43f4259422aed8baf55559c79bb0f3ffd40f76b	19706131732657456685152
1002	0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	0x22a212677548a0999e9402f10a455a4f84e29714	286	16679419	2023-02-21T21:02:35.000Z	0xa71f8653a5bac4f064a247b3edf7288bda7f9e7dd0b928fd58b6991a57e4cd17	42827044516457520856225
1010	0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	0xbb4cdfcf3a989a950fec54acf64ca5044cffc3e8	50	16674412	2023-02-21T04:09:35.000Z	0xe55554ad3d6425c1987f76800961271ed741fd83689910161033949d195c9406	77233347084261581468

Example Query

Query with partition filter

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

stMatic_DistributeRewardsEvent_event

Reward distribution events from Lido’s stMATIC contract on Ethereum, recording when staking rewards are distributed to token holders. Tracks reward amounts and timing for analyzing Lido’s Polygon staking yield distribution.

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__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

address	removed	log_index	in__amount	block_number	block_timestamp	transaction_hash
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	194	1892553371099184925235	17934731	2023-08-17T13:06:59.000Z	0xda21dc156b085238bff0cfea347cde16839f7469faec0a582a5b4b35da696a2d
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	135	1118760999226925501412	17031802	2023-04-12T12:02:11.000Z	0x4abc69f0658c7ac95ef0df67ee828169a55f8e7b04d798bf73f2d98e0a5a8e3e
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	214	657320506762665031648	15357760	2022-08-17T08:52:13.000Z	0xd745b9d8836caa1a805845cab047d81c782ac45b19786aed3746cb2ddabc6df8

Example Query

Query with partition filter

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

StMATIC_RequestWithdrawEvent_event

Withdrawal request events from Lido’s stMATIC (staked MATIC) token contract on Ethereum, tracking user unstaking requests with amount, sender address, and optional referral. Used for analyzing withdrawal patterns and liquidity flows from Polygon staking positions.

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 initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__referral`	`STRING`	Address of the referral partner associated with this stMATIC withdrawal request on Ethereum. Typically the zero address when no referral is involved, or a partner wallet address when attributed.

Sample Data

address	removed	in__from	log_index	in__amount	block_number	in__referral	block_timestamp	transaction_hash
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	0xd42b01a78f5dfcdb98789c079d640987c52b1f69	511	783933984072729809331	16698424	0x0000000000000000000000000000000000000000	2023-02-24T13:15:35.000Z	0xff28745874c22c31d0dd8d339789faa54ad0e8db659b5da5b9ae2300b13bbd19
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	0x1fff2cc43a54b66af3fe8760d98a6ab0b33f22de	521	325812091090552159847	16694869	0x0000000000000000000000000000000000000000	2023-02-24T01:12:23.000Z	0x851abaa8182ecc6b707654cccddf27d1b4510c284803ccaeb12369e65d0789ec
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	0xb4840fa66485ca6c5caaba413f969b683f7dbd4d	193	837858218805886978842	16698806	0x0000000000000000000000000000000000000000	2023-02-24T14:32:35.000Z	0xfdcf8f1c57b56a4ca5f863ea16cbe5885d5ff551556bfa145d5f641d1c156554

Example Query

Query with partition filter

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

StMATIC_SetNodeOperatorRegistryAddress_event

Configuration change events for Lido’s stMATIC node operator registry on Ethereum. Tracks updates to the registry contract address used for managing validators in Lido’s Polygon liquid staking protocol.

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__newNodeOperatorRegistryAddress`	`STRING`	Contract address of the newly configured node operator registry for the StMATIC contract. This Ethereum address represents the registry contract managing validators in the Lido stMATIC protocol.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in__newNodeOperatorRegistryAddress
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	230	16525722	2023-01-31T08:49:59.000Z	0xe0deacbb7f95af9fdabae66443be49623c0964526f09d06d419068b0e06bf183	0x216b8b78e0632138dc38907dd089aab601ed6edc

Example Query

Query with partition filter

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

StMATIC_SetProtocolFee_event

Protocol fee configuration events from Lido’s stMATIC (Staked MATIC) contract on Ethereum, tracking changes to the protocol’s fee percentage. Records the old and new fee values in basis points for analyzing Lido’s fee structure evolution.

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_oldProtocolFee`	`INT64`	Previous protocol fee value before the update, expressed in basis points (1/100th of a percent). A value of 0 indicates no fee was previously charged, while 10 represents a 0.10% fee.
`in_newProtocolFee`	`INT64`	Updated protocol fee value. Integer representing the new fee amount in basis points or protocol-specific units.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newProtocolFee	in_oldProtocolFee
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	229	16525722	2023-01-31T08:49:59.000Z	0xe0deacbb7f95af9fdabae66443be49623c0964526f09d06d419068b0e06bf183	10	0

Example Query

Query with partition filter

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

StMATIC_SubmitEvent_event

MATIC token deposit events into Lido’s stMATIC liquid staking contract on Ethereum. Captures stake submissions with depositor addresses, amounts, and optional referral codes for tracking staking activity and referral programs.

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 initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__amount`	`STRING`	Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
`in__referral`	`STRING`	Ethereum address that referred the user to stake MATIC via Lido’s StMATIC contract. Typically the zero address (null referral) or matches the staker’s address for self-referrals.

Sample Data

address	removed	in__from	log_index	in__amount	block_number	in__referral	block_timestamp	transaction_hash
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	0x8d365687a75dc7688864822869ae0551bb6fc105	444	6999900000000000000000000	17835611	0x0000000000000000000000000000000000000000	2023-08-03T16:18:11.000Z	0xa440321c9f62e6ba95b642c8f6cd6488bd168d50564966b51a4070fd200de942
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	0x7f6d9c90b07a5c87287556fdbd7d9f5ceb39026a	303	4629600757900000000000	17832238	0x0000000000000000000000000000000000000000	2023-08-03T04:58:47.000Z	0x44af61c6c360e8da1cf7af33f158a87bec7fb4dbc5adbf9a4bb719fc281f7225
0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	false	0x659de82a1658e8764d4ed9307c9a7f190cb60133	199	73854413490835730427	17831564	0x0000000000000000000000000000000000000000	2023-08-03T02:43:23.000Z	0x731508ac70468f7982539cf7e7974febcfb4a6a5f0ff475a4db1c5c30e626bb3

Example Query

Query with partition filter

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

StMATIC_Transfer_event

Transfer events for stMATIC (Lido’s staked MATIC token) on Ethereum, tracking mints, burns, and transfers between addresses. Sample data shows zero address transfers indicating staking deposits and withdrawals with token amounts in wei.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0x0000000000000000000000000000000000000000	0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	0x30e151be10c49174f30f7e2497ce7d6eb9aa0ca0	false	212240250207463761841515	137	16670286	2023-02-20T14:15:23.000Z	0x05038a973bd580c8e047ffe73c76b5dc23b94e18b8e739fcaea9db30727a6b8f
0x0000000000000000000000000000000000000000	0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	0x3945c314acea2a83bed858691dec1589af7a70ca	false	137572270456596884233	129	16668267	2023-02-20T07:26:47.000Z	0x04d019a60338443b94492ec47b19d506e38462bbd923e607188123c19f11e226
0x0000000000000000000000000000000000000000	0x9ee91f9f426fa633d227f7a9b000e28b9dfd8599	0xeeec8188365f59e03bdd8022f096d6e13e45433a	false	864893812799529627838	83	16669407	2023-02-20T11:18:11.000Z	0xbd152920cd2b91d7a1002f01d536507924161dc17468de9ee3e48268c65e593d

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AragonFinance_NewTransaction_event

Oracle_Completed_event

Oracle_PostTotalShares_event

stETH_SharesBurnt_event

stETH_Submitted_event

stETH_TransferShares_event

StMATIC_ClaimTokensEvent_event

stMatic_DistributeRewardsEvent_event

StMATIC_RequestWithdrawEvent_event

StMATIC_SetNodeOperatorRegistryAddress_event

StMATIC_SetProtocolFee_event

StMATIC_SubmitEvent_event

StMATIC_Transfer_event

​Tables

​AragonFinance_NewTransaction_event

​Oracle_Completed_event

​Oracle_PostTotalShares_event

​stETH_SharesBurnt_event

​stETH_Submitted_event

​stETH_TransferShares_event

​StMATIC_ClaimTokensEvent_event

​stMatic_DistributeRewardsEvent_event

​StMATIC_RequestWithdrawEvent_event

​StMATIC_SetNodeOperatorRegistryAddress_event

​StMATIC_SetProtocolFee_event

​StMATIC_SubmitEvent_event

​StMATIC_Transfer_event

Tables

AragonFinance_NewTransaction_event

Oracle_Completed_event

Oracle_PostTotalShares_event

stETH_SharesBurnt_event

stETH_Submitted_event

stETH_TransferShares_event

StMATIC_ClaimTokensEvent_event

stMatic_DistributeRewardsEvent_event

StMATIC_RequestWithdrawEvent_event

StMATIC_SetNodeOperatorRegistryAddress_event

StMATIC_SetProtocolFee_event

StMATIC_SubmitEvent_event

StMATIC_Transfer_event